You answered another question I had mind regarding Airborne school (I didn't know scuba school was also an option for midshipmen) and the academy. It appears that it's harder to get NSW from the academy (or probably any other commissioning source) than aviation. Conversely, is SWO generally considered the least attractive/competitive option (no offense at all mean to SWO)?
Ya. SWO is the easiest. NSW/SPECWAR most selective. I'm sure the numbers are on the USNA website. Aviation is not too hard, as long as you get like a C average.
I'd say the hardest billet to get is Medical Corps. I think we had like three guys from my class get it; one was a classmate in my company and he was a prior FMF corpsman. The MC is not under any commitment to select
any guys from USNA - though they almost always do - so you have to really sell yourself. Since USNA doesn't have pre-med, gouge was to major in chem and knock it out of the park if you wanted to go for it.
Billet numbers ebb and flow with budgets and administration. I was at USNA during the Clinton years, and Navy Pilot billet numbers literally doubled between my plebe and firstie years. Very generally speaking, for an average recent grad class, about as many Academy mids go SWO as Navy Air (pilot+NFO) and if you want either of those and are physically qualified, you'll probably get it. If you're running below a 2.0 you may not graduate; it's usually the 2nd Class physical that knocks guys out of running for aviation, not grades. As I recall, the anchor man (last in the class) in my class got Navy Pilot.
If you want Nuke (SWO-N or Subs) you have to interview with Director of Naval Reactors, and they look closely at your grades, as power school is very tough academically, and they want to see that you've performed well in engineering/science classes.
The Marines vett Mids via the opinions of Marines assigned to USNA and summer programs at Quantico. As with NSW, they want to see if you're a good fit for the community.
Policy when I graduated was that you would be comissioned in a URL community if physcially qualified. You could commission RL (Supply, etc) only if you were NPQed for some reason. Not sure if that's still the case.