Are there any types of prescription drugs that should not be taken while flying?

Depends: Are you doing the flying? If so, any sort of sedating medication is absolutely contraindicated.

All: The Partial Pressure of Oxygen on the human body is less the higher altitude you go. This will generally cause your body to react differently with a medication vs. ground level pressure. The different medication action may not be in your best interest.