Nitrogen narcosis is especially relevant to divers. Recreational SCUBA diving is usually limited to around 30m depth and some divers will start noticing effects (basically like getting drunk) near that depth when using air in the tanks. This is why different mixtures (e.g. trimix) are used at increased depths, though there are other important effects of breathing air at pressure such as oxygen toxicity.