Hi Jack. Think about a Blue Card. It's a working residence permit that you can get in the EU as a highly qualified worker if you fullfill some basic income requirements (around 37K euro p.a. in Germany). You are obliged to work within your education field, i.e. engineering or medicine or whatever. However particularly in Germany after 21 month of posessing of the Blue Card (Blaue Karte) you can get a permanent residence permit without any limitations and do what you want, i.e. pilots training.