Magic Carpet Ride
If my memory serves me correct; the first human FTL warp space flight was piloted by Zefram Cochrane, was was suffering a "4-alarm hangover" at the time. He was also playing Steppenwolf's "Magic Carpet Ride" VERY LOUD at blast off.
Heck, if I win lotto next week, I'll buy a seat on one of Sir Richard's spacecraft, and when we fire the engine I would want to have a few tots of rum under my belt; and Steppenwolf's "Magic Carpet Ride" playing very loudly.
As for accidents on the Shuttle, things go pear-shaped *way* too quickly for a human to react, drunk or not. The Shuttle launch is mostly automatic anyway - I suspect Nasa provides a few buttons to press to give the astronauts something to do; the Russians with Buran proved that something as complex as a Shuttle is actually very easy to fly completely automatically - which partly removes the need for a Shuttle anyway!