VansAirForceForums  
Home > VansAirForceForums

- POSTING RULES
- Donate yearly (please).
- Advertise in here!

- Today's Posts | Insert Pics

  #1  
Old 01-26-2018, 12:42 PM
jmbaute jmbaute is offline
 
Join Date: Feb 2005
Location: Blacksburg, VA
Posts: 148
Default 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
__________________

John B
Mooney M20C (KPSK)
RV7 Wings

www.pdfplates.com

Last edited by jmbaute : 01-26-2018 at 02:40 PM.
Reply With Quote
  #2  
Old 01-26-2018, 01:22 PM
mturnerb mturnerb is offline
 
Join Date: Apr 2015
Location: Ponte Vedra, FL
Posts: 695
Default

Just visited your page: this is outstanding and should be a great tool for anyone who wants to study RV accidents.
__________________
Turner Billingsley
RV-14A In Progress
N14VB Reserved
https://turnerb14a.blogspot.com/
Reply With Quote
  #3  
Old 01-26-2018, 02:53 PM
Bob Martin's Avatar
Bob Martin Bob Martin is offline
 
Join Date: Jan 2005
Location: Richmond, Virginia
Posts: 1,106
Default 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, 1150+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
Reply With Quote
  #4  
Old 01-27-2018, 09:23 PM
mbauer mbauer is offline
 
Join Date: Nov 2015
Location: Nikiski, AK
Posts: 195
Default

Thank you for putting this together.

Best regards,
Mike Bauer
__________________
Mike Bauer
N999SN 1998 Syd Nelson RV-6 (purchased 2017)
2017 Dues Paid
2018 Dues Paid
Reply With Quote
  #5  
Old 01-28-2018, 05:47 AM
StuBob StuBob is offline
 
Join Date: Oct 2015
Location: Indianapolis, IN
Posts: 248
Default

Thatís really an amazing tool. Thanks for putting in all that work.
__________________
Stu F.
Indianapolis (KMQJ)
Reply With Quote
  #6  
Old 01-29-2018, 06:47 AM
jmbaute jmbaute is offline
 
Join Date: Feb 2005
Location: Blacksburg, VA
Posts: 148
Default 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>
__________________

John B
Mooney M20C (KPSK)
RV7 Wings

www.pdfplates.com
Reply With Quote
  #7  
Old 01-29-2018, 07:15 AM
ChiefPilot's Avatar
ChiefPilot ChiefPilot is offline
 
Join Date: Jan 2005
Location: Twin Cities, MN
Posts: 1,486
Default

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
Reply With Quote
  #8  
Old 01-29-2018, 07:59 AM
rv8ch rv8ch is offline
 
Join Date: Feb 2005
Location: LSGG
Posts: 2,316
Default Flight Hours

Quote:
Originally Posted by ChiefPilot View Post
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.
__________________
Mickey Coggins
http://rv8.ch
Reply With Quote
  #9  
Old 01-29-2018, 08:39 AM
StuBob StuBob is offline
 
Join Date: Oct 2015
Location: Indianapolis, IN
Posts: 248
Default

Quote:
Originally Posted by ChiefPilot View Post
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.
Indianapolis (KMQJ)
Reply With Quote
  #10  
Old 01-29-2018, 08:48 AM
Ironflight's Avatar
Ironflight Ironflight is offline
VAF Moderator / Line Boy
 
Join Date: Jan 2005
Location: Dayton, NV
Posts: 11,667
Default

Quote:
Originally Posted by rv8ch View Post
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 in Chief - 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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -6. The time now is 09:51 AM.


The VAFForums come to you courtesy Delta Romeo, LLC. By viewing and participating in them you agree to build your plane using standardized methods and practices and to fly it safely and in accordance with the laws governing the country you are located in.