Online NTSB accident database

The ramblings of our community of aviators.

Moderators: Rick, Lance Murray

Post Reply
User avatar
Rich
5 Diamonds Member
5 Diamonds Member
Posts: 4592
Joined: Mon Aug 30, 2010 12:40 pm
First Name: Rich
Aircraft Type: DA40
Aircraft Registration: N40XE
Airports: S39 Prineville OR
Has thanked: 145 times
Been thanked: 1180 times

Online NTSB accident database

Post by Rich »

Some time in the last few weeks they have bifurcated this into different tools and data sources. The traditional one cuts off at 2008 and the new one (named CAROL) starts off from there (supposedly - on the CAROL page, it says it starts at 2010).

This CAROL tool uses an entirely different user-interface paradigm, where you manually construct elements of the query (for you SQL folks) and retrieves based on that. OK, I can figure that out.

It looks like it's a work in progress. A couple of days ago, it would return seriously incomplete data for both Diamond and Cirrus. I actually sent a note to them pointing this out. Today it looks like the defect may have been corrected.
2002 DA40-180: MT, PowerFlow, 530W/430W, KAP140, ext. baggage, 1090 ES out, 2646 MTOW, 40gal., Surefly, Flightstream 210, Orion 600 LED, XeVision, Aspen E5
User avatar
ZAV
3 Diamonds Member
3 Diamonds Member
Posts: 84
Joined: Sun Nov 04, 2018 1:40 am
First Name: Bryan
Aircraft Type: DA40
Aircraft Registration: N387DS
Airports: KLEX
Has thanked: 16 times
Been thanked: 25 times

Re: Online NTSB accident database

Post by ZAV »

I don’t see the monthly lists I used to look through.
User avatar
Rich
5 Diamonds Member
5 Diamonds Member
Posts: 4592
Joined: Mon Aug 30, 2010 12:40 pm
First Name: Rich
Aircraft Type: DA40
Aircraft Registration: N40XE
Airports: S39 Prineville OR
Has thanked: 145 times
Been thanked: 1180 times

Re: Online NTSB accident database

Post by Rich »

ZAV wrote: Tue Nov 24, 2020 2:20 am I don’t see the monthly lists I used to look through.
If you're referring to this, it's still available. Stuff shows up here that never makes it to the NTSB site:

https://www.asias.faa.gov/apex/f?p=100:93:::NO:::
2002 DA40-180: MT, PowerFlow, 530W/430W, KAP140, ext. baggage, 1090 ES out, 2646 MTOW, 40gal., Surefly, Flightstream 210, Orion 600 LED, XeVision, Aspen E5
User avatar
ZAV
3 Diamonds Member
3 Diamonds Member
Posts: 84
Joined: Sun Nov 04, 2018 1:40 am
First Name: Bryan
Aircraft Type: DA40
Aircraft Registration: N387DS
Airports: KLEX
Has thanked: 16 times
Been thanked: 25 times

Re: Online NTSB accident database

Post by ZAV »

No. The NTSB site had a monthly list with links to preliminary or final reports. It was easy to scroll through. I can’t find it after the website change and switch to the CAROL tool.
User avatar
Rich
5 Diamonds Member
5 Diamonds Member
Posts: 4592
Joined: Mon Aug 30, 2010 12:40 pm
First Name: Rich
Aircraft Type: DA40
Aircraft Registration: N40XE
Airports: S39 Prineville OR
Has thanked: 145 times
Been thanked: 1180 times

Re: Online NTSB accident database

Post by Rich »

Bryan, I didn't know about that one. I will say this tool looks to allow more tailored inquiries. For example, it's better at allowing filtering for non-fatal accidents. But because it combines all transportation sectors, it does add some klunkiness.
2002 DA40-180: MT, PowerFlow, 530W/430W, KAP140, ext. baggage, 1090 ES out, 2646 MTOW, 40gal., Surefly, Flightstream 210, Orion 600 LED, XeVision, Aspen E5
User avatar
Rich
5 Diamonds Member
5 Diamonds Member
Posts: 4592
Joined: Mon Aug 30, 2010 12:40 pm
First Name: Rich
Aircraft Type: DA40
Aircraft Registration: N40XE
Airports: S39 Prineville OR
Has thanked: 145 times
Been thanked: 1180 times

Re: Online NTSB accident database

Post by Rich »

Nominally it still has the same limitation on model, with DA40 yielding different results than DA 40. But the query can be constructed to get past this, since it uses the search filter as "contains". Therefore the workaround is to use Diamond as the make, with, e.g., 40 as the model.
2002 DA40-180: MT, PowerFlow, 530W/430W, KAP140, ext. baggage, 1090 ES out, 2646 MTOW, 40gal., Surefly, Flightstream 210, Orion 600 LED, XeVision, Aspen E5
User avatar
Rich
5 Diamonds Member
5 Diamonds Member
Posts: 4592
Joined: Mon Aug 30, 2010 12:40 pm
First Name: Rich
Aircraft Type: DA40
Aircraft Registration: N40XE
Airports: S39 Prineville OR
Has thanked: 145 times
Been thanked: 1180 times

Re: Online NTSB accident database

Post by Rich »

Rich wrote: Tue Nov 24, 2020 6:43 pm Nominally it still has the same limitation on model, with DA40 yielding different results than DA 40. But the query can be constructed to get past this, since it uses the search filter as "contains". Therefore the workaround is to use Diamond as the make, with, e.g., 40 as the model.
I found this also works in the pre-2009 tool, as well. Interesting after all these years to discover that. It just hadn't occurred to me to try.
2002 DA40-180: MT, PowerFlow, 530W/430W, KAP140, ext. baggage, 1090 ES out, 2646 MTOW, 40gal., Surefly, Flightstream 210, Orion 600 LED, XeVision, Aspen E5
Post Reply