Craig,
Most insurance companies (all the ones I know of anyway) have "Aviation Exclusion" clauses, which they will include in the policy as soon as they find out you are a pilot. These clauses generally say that for a certain time period at the beginning of the policy (generally 2 years), if you die in an airplane accident where you were the pilot in command, the insurance company is not liable for the death benefit. After that time period they expire, and the policy pays the death benefit regardless of the cause, as if that clause were never in the policy. If you are not a pilot at the time you execute the policy (when it is first issued by the company), this clause will not be in there, and cannot be added at a later date when you do earn your wings.
DO NOT attempt in any way to hide the fact you are a pilot, either to the company or to your agent. If the company discovers that you are a pilot during their "due dilligence" background checks, they will not issue the policy because you lied to them on the application (yes, there is a question on the app that asks if you fly). If you do hide the fact you're a pilot, and get the policy issued without the exclusion, and then have an accident during the normal exclusion period, the company can dispute the benefit claim in court and have an excellent chance of winning based of the argument that you intentionally defrauded them by hiding the fact you were a pilot on the application. Honesty is the best "policy" whenever dealing with insurance companies. They will not decline to issue you a policy soley because you're a pilot, but they can (and will) decline you if you lie to them.
As to what type of insurance to buy, get Term life, not Whole Life or Universal Life. Term Life is the best bargain (price vs. benefit), and is "pure protection". The whole point of life insurance is to protect your family from the loss of your income, not save or invest for them. Many finacial experts will tell you that the best practice is to separate your insurance from your investments, and Term is the only insurance type that allows you to do that effectively.
Hope this helps,