FWIW, from the CIA website, they are currently hiring and one of the pre-requisite backgrounds is "piloting experience." Who knows if you would be flying, though. Also, I know the FBI does some of the flying for them - I think non-covert ops type missions.