The first thing to ask: What are you going to do with the video?
If it's for yourself, to record your performance, and not intended for public consumption, the best location would be somewhere over your shoulder with a view of the dashboard and possibly through the windscreen - although the difference in light levels normally makes it hard to capture both in one shot. Add an audio feed (intercom splitter cable) and you're done.
If you intend to edit the video for public consumption (YouTube?) then you really have a project on your hands. Watch a bunch of flying videos that are on YouTube already. First, from an "experience" angle. Did you enjoy the video?
Then, for the ones you enjoyed, from a technical angle: How did the author make the video enjoyable? You'll find that the most interesting ones are shot from a whole bunch of different angles, both inside and outside the plane, and consist of mostly short clips of about 4 seconds. Longer if you are able to incorporate some sort of running commentary or if something interesting is going on in the shot itself. You'll also find that the audio is a clever mix of commentary, ATC traffic, engine noise and/or background music so some audio mixing is also required. And the video tells a story from beginning to end.
Don't underestimate this editing process. It's not uncommon to spend a few days editing, with the result being a 10-minute clip. And you may need several hours worth of footage to extract just 10 minutes of worthwhile material.
Only when you know what kind of story you will want to tell, will you be able to decide questions on equipment. The question "what type of camera to use" is only one of them. You also need to worry about splitter cables and maybe an ND filter of some sort. And don't forget a variety of suction cups, tethers, clamps, brackets, ball mounts and stuff so you can mount the equipment exactly where you want it.