I'm guessing it wasn't a good flight

I'm pretty sure this was a pants filler for all passengers:

The gun carried by a US Airways pilot accidentally went off on a flight from Denver to Charlotte on Saturday, causing the plane to be pulled from service, the airline said on Monday.

No one was injured by the shot, and the aircraft landed safely in Charlotte. Flight 1536 had 124 passengers, two pilots and three flight attendants aboard, US Airways said.

The pilot was a Federal Flight Deck Officer, permissioned by the U.S. Transportation Security Administration to carry a firearm.

I support allowing pilots to carry arms, but they've got to take great care to make sure they are carrying securely.

I bet the passengers were well behaved for the rest of the flight.