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 community so I am sharing the link with you.
edit: supposed to be a pic here but for the life of me I can't figure out why it isn't showing.
This is the same data you'll find in lots of other places, including on this website (Doug's page was actually my inspiration).
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.
- I'm using some custom logic against the entire database of ~81k incidents to get to "Vans" models. This is a little tricky since as you know, you can call your aircraft anything you want at registration. I'm "close" to what Doug reports on his page and for now I'm calling it "good enough".
- 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.
- 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 don't care if you share the link.
- If a moderator wishes to move or delete this post, I'm fine with that, too.
Blues Skies,
John
edit: supposed to be a pic here but for the life of me I can't figure out why it isn't showing.
This is the same data you'll find in lots of other places, including on this website (Doug's page was actually my inspiration).
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.
- I'm using some custom logic against the entire database of ~81k incidents to get to "Vans" models. This is a little tricky since as you know, you can call your aircraft anything you want at registration. I'm "close" to what Doug reports on his page and for now I'm calling it "good enough".
- 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.
- 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 don't care if you share the link.
- If a moderator wishes to move or delete this post, I'm fine with that, too.
Blues Skies,
John
Last edited: