|
-
POSTING RULES

-
Donate yearly (please).
-
Advertise in here!
-
Today's Posts
|
Insert Pics
|

01-26-2018, 12:42 PM
|
|
|
|
Join Date: Feb 2005
Location: Blacksburg, VA
Posts: 149
|
|
RV accident data analysis
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
Last edited by jmbaute : 01-26-2018 at 02:40 PM.
|

01-26-2018, 01:22 PM
|
|
|
|
Join Date: Apr 2015
Location: Ponte Vedra, FL
Posts: 1,474
|
|
Just visited your page: this is outstanding and should be a great tool for anyone who wants to study RV accidents.
|

01-26-2018, 02:53 PM
|
 |
|
|
Join Date: Jan 2005
Location: Charlottesville, Virginia
Posts: 1,230
|
|
Nice work!
I agree.......thanks for doing this...
But this is something I will not be showing my wife! 
__________________
Bob Martin
RV-6, 0-360 Hartzell C/S, Tip up, 1200+TT
James extended cowl/plenum, induction, -8VS and Rudder. TSFlightline hoses. Oregon Aero leather seats.
D100-KMD150-660-TT ADI2- AS air/oil seperator. Vetterman exhaust with turndown tips.
Louisa, Virginia KLKU N94TB
|

01-27-2018, 09:23 PM
|
|
|
|
Join Date: Nov 2015
Location: Nikiski, AK
Posts: 413
|
|
Thank you for putting this together.
Best regards,
Mike Bauer
__________________
Mike Bauer
N999SN 1998 Syd Nelson RV-6 (purchased 2017)
UTC -09:00 Alaska
|

01-28-2018, 05:47 AM
|
|
|
|
Join Date: Oct 2015
Location: Indianapolis, IN
Posts: 254
|
|
That?s really an amazing tool. Thanks for putting in all that work.
__________________
Stu F.
RV8
|

01-29-2018, 06:47 AM
|
|
|
|
Join Date: Feb 2005
Location: Blacksburg, VA
Posts: 149
|
|
All GA accidents
Here is a similar report showing the same data for the GA fleet at large, for the data nerds out there (amateur built not included in this).
Doug, thanks for posting the screenshot on the front page of VAF, if there is value, feel free to add the interactive chart to your accidents page; code snip below, although we are getting slightly different numbers. I'd be happy to discuss what filters I'm using.
Code:
<iframe width="800" height="600" src="https://app.powerbi.com/view?r=eyJrIjoiMTI1OTk1YmItZGQ1ZS00Mzg2LTk4MjMtOWIyNDFjMWVlYWQxIiwidCI6ImU0MmUzNTJmLWZiZDUtNGI3Mi1iOTRlLTFjMDkzNzk0Mjc4MiIsImMiOjN9" frameborder="0" allowFullScreen="true"></iframe>
|

01-29-2018, 07:15 AM
|
 |
|
|
Join Date: Jan 2005
Location: Twin Cities, MN
Posts: 1,565
|
|
Does this data take into account flight hours or fleet sizes? If not, what value does this data provide?
__________________
Brad Benson, Maplewood MN.
RV-6A N164BL, Flying since Nov 2012!
If you're not making mistakes, you're probably not making anything
|

01-29-2018, 07:59 AM
|
 |
|
|
Join Date: Feb 2005
Location: LSGY
Posts: 3,198
|
|
Flight Hours
Quote:
Originally Posted by ChiefPilot
Does this data take into account flight hours or fleet sizes? If not, what value does this data provide?
|
I agree - that was the first thing that popped into my mind - how many hours flown? Unfortunately that's a really hard number to get it seems. It can be estimated, but there are no firm numbers.
|

01-29-2018, 08:39 AM
|
|
|
|
Join Date: Oct 2015
Location: Indianapolis, IN
Posts: 254
|
|
Quote:
Originally Posted by ChiefPilot
Does this data take into account flight hours or fleet sizes? If not, what value does this data provide?
|
You're right; there are no denominators, which is what makes the difference between data and anecdotes.
Nonetheless, I think it has tremendous value as a collection of anecdotes. For instance, having read something like 50 reports on ground loops, I've learned that it isn't generally the initial deviation that causes the accident, but the overcorrection. Most of them read like, "Upon landing, the airplane encountered a gust and veered to the left. The pilot corrected with right rudder and brake, causing the airplane to veer to the right. He attempted correction with left rudder and brake but was unable to regain control. The airplane departed the runway to the right....."
I'm not trying to start a conversation about groundloops, just illustrating that these reports are valuable, even if statistically meaningless.
__________________
Stu F.
RV8
|

01-29-2018, 08:48 AM
|
 |
VAF Moderator / Line Boy
|
|
Join Date: Jan 2005
Location: Dayton, NV
Posts: 12,256
|
|
Quote:
Originally Posted by rv8ch
I agree - that was the first thing that popped into my mind - how many hours flown? Unfortunately that's a really hard number to get it seems. It can be estimated, but there are no firm numbers.
|
I read accident stuff for two reasons - one is to get an idea of the RATE of accidents, and in that case, this data doesn?t;t tell us anything.
But the more important reason for reading accident stuff is figuring out the CAUSE of accidents - and in that case, this is really fascinating information. Knowing what causes accidents can help us avoid them ourselves. Knowing how many (or how often) accidents happen isn?t really useful, except to bean counters.
TRhis is pretty neat stuff - but as I always say, you really need to read the descriptions of accidents to help learn to avoid them yourself.
__________________
Paul F. Dye
Editor at Large - KITPLANES Magazine
RV-8 - N188PD - "Valkyrie"
RV-6 (By Marriage) - N164MS - "Mikey"
RV-3B - N13PL - "Tsamsiyu"
A&P, EAA Tech Counselor/Flight Advisor
Dayton Valley Airpark (A34)
http://Ironflight.com
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -6. The time now is 12:39 AM.
|