Depends, different people respond differently to benzodiazepines. For myself, a 5mg valium relaxes me but does not induce sleep. Similar to having a glass or two of wine, really. For others, they'll basically be knocked out. I'm not convinced it's necessary for flying myself, but if you have any sort of flight anxiety it can be a game-changer.