# Fatal NTSB investigations: Documentation/record keeping

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB WPR24FA080](https://openairdocs.org/ntsb/WPR24FA080.md): Swanson R/Swanson S RV-6 · Concord, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jan 30, 2024 · N30AK · Substantial damage
  > A total loss of engine power during takeoff due to a separated fuel line and the pilot’s subsequent failure to maintain control of the airplane. Contributing to the accident were the pilot's medical condition and the effects of multiple impairing substances.
- [NTSB DCA22MA193](https://openairdocs.org/ntsb/DCA22MA193.md): Dehavilland DHC-3 · Freeland, WA · Accident · 10 fatal · Class 1 · Major · Final report · Sep 4, 2022 · N725TH · Destroyed
  > The in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…
- [NTSB ANC19FA019](https://openairdocs.org/ntsb/ANC19FA019.md): De Havilland DHC 2 · Metlakatla, AK · Accident · 2 fatal · Class 2 · Field · Final report · May 20, 2019 · N67667 · Substantial damage
  > The pilot’s inadequate compensation for a quartering tailwind during a water landing, which resulted in a loss of control and subsequent nose-over. Contributing to the accident was the company’s inadequate operational control of the flight release process,…
- [NTSB DCA19MA086](https://openairdocs.org/ntsb/DCA19MA086.md): Boeing 767 · Trinity Bay, TX · Accident · 3 fatal · Class 1 · Major · Final report · Feb 23, 2019 · N1217A · Destroyed
  > The inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…
- [NTSB ERA18FA264](https://openairdocs.org/ntsb/ERA18FA264.md): Dassault Falcon 50 · Greenville, SC · Accident · 2 fatal · Field investigation · Final report · Sep 27, 2018 · N114TD · Substantial damage
  > The operator's decision to allow a flight in an airplane with known, unresolved maintenance discrepancies, and the flight crew's failure to properly configure the airplane in a way that would have allowed the emergency or parking brake systems to stop the…
- [NTSB WPR18FA143](https://openairdocs.org/ntsb/WPR18FA143.md): I.C.A.-Brasov IS 29D · Avenal, CA · Accident · 1 fatal · Field investigation · Final report · May 19, 2018 · N38ES · Destroyed
  > The pilot's improper installation of the wings onto the glider, which resulted in an in-flight wing separation. Contributing to the accident were the pilot's limited familiarity with the design and a lack of reliable assembly guidance.
- [NTSB ERA14FA120](https://openairdocs.org/ntsb/ERA14FA120.md): Cessna 210L · Clay, AL · Accident · 2 fatal · Field investigation · Final report · Feb 15, 2014 · N732EJ · Destroyed
  > The pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…
- [NTSB DCA13MA121](https://openairdocs.org/ntsb/DCA13MA121.md): Dehavilland DHC-3 · Soldotna, AK · Accident · 10 fatal · Major investigation · Final report · Jul 7, 2013 · N93PC · Destroyed
  > The operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…
- [NTSB DCA12FA051](https://openairdocs.org/ntsb/DCA12FA051.md): Convair 440 - NO Series · San Juan, PR · Accident · 2 fatal · Class 1 · Field · Final report · Mar 15, 2012 · N153JR · Destroyed
  > the flight crew's failure to maintain adequate airspeed after shutting down the right engine due to an in-flight fire in one of the right augmentors. The failure to maintain airspeed resulted in either an aerodynamic stall or a loss of directional control.
- [NTSB CEN12FA086](https://openairdocs.org/ntsb/CEN12FA086.md): Piper PA-31-350 · Riverwoods, IL · Accident · 3 fatal · Field investigation · Final report · Nov 29, 2011 · N59773 · Substantial damage
  > The pilot's inadequate preflight planning and in-flight decision-making, which resulted in a loss of engine power due to fuel exhaustion during approach. Contributing to the accident was the pilot's decision to operate an airplane after using illicit drugs.
- [NTSB WPR11MA454](https://openairdocs.org/ntsb/WPR11MA454.md): North American/Aero Classics P-51D · Reno, NV · Accident · 11 fatal · Class 1 · Major · Final report · Sep 16, 2011 · N79111 · Substantial damage
  > The reduced stiffness of the elevator trim tab system that allowed aerodynamic flutter to occur at racing speeds. The reduced stiffness was a result of deteriorated locknut inserts that allowed the trim tab attachment screws to become loose and to initiate…
- [NTSB ERA10FA502](https://openairdocs.org/ntsb/ERA10FA502.md): Cessna 172 · Chatsworth, GA · Accident · 2 fatal · Field investigation · Final report · Sep 25, 2010 · N84249 · Substantial damage
  > The pilot's inadequate flight planning and in-flight fuel management resulting in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the operator's failure to ensure aircraft records pertaining to engine modifications and…
- [NTSB ERA09FA497](https://openairdocs.org/ntsb/ERA09FA497.md): Robinson R44 · Jackson, MS · Accident · 1 fatal · Field investigation · Final report · Sep 1, 2009 · N33PX · Substantial damage
  > The pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.
- [NTSB DCA09MA027](https://openairdocs.org/ntsb/DCA09MA027.md): Bombardier DHC-8-402 · Clarence Center, NY · Accident · 50 fatal · Class 1 · Major · Final report · Feb 13, 2009 · N200WQ · Destroyed
  > The captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…
- [NTSB CHI08LA272](https://openairdocs.org/ntsb/CHI08LA272.md): Socata TB-20 Trinidad · Cassville, WI · Accident · 1 fatal · Limited investigation · Final report · Sep 3, 2008 · N597TB · Substantial damage
  > The left seat pilot's failure to maintain control of the airplane during a go-around and the inadvertent in-flight opening of the cabin door for undetermined reasons. Contributing to the accident was the distraction of the door opening.
- [NTSB DFW08MA076](https://openairdocs.org/ntsb/DFW08MA076.md): Cessna 500 · Oklahoma City, OK · Accident · 5 fatal · Class 1 · Major · Final report · Mar 4, 2008 · N113SH · Destroyed
  > Airplane wing-structure damage sustained during impact with one or more large birds (American white pelicans), which resulted in a loss of control of the airplane.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1
WHERE c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '040330'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/040330/cases?fatal=1

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
