I wanted to learn a new data analysis tool (Power BI) so I decided to build a simple dashboard based on the NTSB database. I thought it might be interesting to the Mooney community so I am sharing the link with you. This is the same data you'll find in lots of other places, but hopefully this visualization makes it easy to slice & dice. I'm working on some other similar ones that include the GA fleet at large and one that is focused on Van's RV aircraft (GA is here and Van's is here if you're curious).A couple notes:- The data source is the XML file on the NTSB site. They update the data once per day. At this time I'm not sure if the link I'm posting refreshes against that data or if I have to trigger that refresh on my side.- The report is fairly interactive, for example click on the model donut to filter the heat map and grid. Same thing on the heat map, click to filter by phase of flight. Click again to clear your filter.
- Right clicking various objects gives you a few more filtering options including raw data.- If you click any of the links to the final report and don't get a result, it is because there isn't one issued yet. I'm just building that URL based on the accident number.- I'm certainly open to feedback/suggestions but this is just something I'm playing with so I can't promise I'll do anything else with it. I am hoping to publish some other variations at a later date.- I don't care if you share the link.- If a moderator wishes to move or delete this post, I'm fine with that, too.
I hope this is educational. Blue skies.
John