Coming from the civi side...
There's an NDB approach to a local field that juts out diagonally over the Atlantic. The standard approach takes you probably 3 miles offshore, and down to 1600'. Which by itself is already fairly low for being that far out over water, but its not really a big deal. It gets hairy when you've got 4 aircraft shooting the same approach being stacked up and out over the ocean. I was flying a 172 under the hood getting some crazy vectors and just following orders while my IP kept his SA up for the both of us. Glancing at the GPS I could see we were pushing 10 miles offshore at 1600'. At that point you start second guessing your IO-360 engine and your religion. We turn inbound, and immediately approach clears us down to the MDA of 500-odd feet. Uneasily I look at my IP with a "Do I REALLY want to do that right now?" puppy dog look on my face, and he comes back with "Just keep it here for a bit...and pedal faster." Never liked that approach.