Seneca III, doing an ambulance trip. Somewhere along the way I hear this loud bang, and look all over for the cause. Checking instruments, checking doors. Looking at the cowl for oil, the usual. Nothing. Turns out that a mother had put some big balloons in back, the big mylar kind. At altitude, they burst, made a hell of a racket.
Next time I went to pick someone up, same thing; big bundle of the large mylar balloons. I told the mother I couldn't take them; they'd have to be deflated. Right there on the ramp at PHX, she lets the whole bundle go. Two busy runways, lots of arrivals and departures, and a big bundle of reflective balloons rising out of the middle. I thought someone was going to show up to kick my butt, but no one did. So I kicked it myself. Repeatedly.
Terrifying in flight is a Shorts filled with skydivers, packed in there like sardines. Somewhere close to FL 180, gas is rapidly expanding, needs somewhere to go. Attempts to reroute it to some internal holding resorvoir fail at a critical moment, and with several minutes left to go before the door comes open, the gas becomes self evident. The point of origin is easily identified by the wave of jumpers rubbing their eyes, propogating out from me. All eyes turn, looks of destain followed by someone yelling "get a rope!"
Door comes open, not quite on jump run yet. Now or never. Scramble over bodies that can't move quite fast enough for a lynching (legs still asleep from the ride up). Dive for door, making sure that all remaining gas is expelled BEFORE leaving the airplane. Roll over on exit to wave and display large fecal-eating grin, and wave. Free at last. Except, in three minutes, they'll catch up on the ground. How low can I go and pull, make it to the parking lot, and drive off before the lynching takes place? Not terror, but suspense.
Discomforting would be getting out the door and realizing that one forgot one's parachute rig in the haste to exit. It's happened...several years ago a photographer back east made it out the door with his camera gear intact, but no parachute, and he filmed it all the way to impact. I wouldn't classify that as terror; the outcome is a given. Certainly I'd guess that it wasn't a comfortable ride down, but probably peaceful to some degree. All decisions are made for you at that point...for the rest of your life.