So how about that, front wheel flew off!

Just for the sake of saying and trivia, The left side lugs and studs were once left hand threads for this very reason. Centrifugal forces tighten right hand threads on the right side but will loosen right hand threads on the left side.