# Fatal NTSB investigations: Resources

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 ANC20MA010](https://openairdocs.org/ntsb/ANC20MA010.md): Airbus AS350B2 · Kekaha, HI · Accident · 7 fatal · Class 1 · Major · Final report · Dec 27, 2019 · N985SA · Destroyed
  > The pilot’s decision to continue flight under visual flight rules (VFR) into instrument meteorological conditions (IMC), which resulted in the collision into terrain. Contributing to the accident was Safari Aviation Inc.’s lack of safety management processes…
- [NTSB DCA18MA142](https://openairdocs.org/ntsb/DCA18MA142.md): Boeing 737 7H4 · Philadelphia, PA · Accident · 1 fatal · Class 1 · Major · Final report · Apr 17, 2018 · N772SW · Substantial damage
  > A low-cycle fatigue crack in the dovetail of fan blade No. 13, which resulted in the fan blade separating in flight and impacting the engine fan case at a location that was critical to the structural integrity and performance of the fan cowl structure. This…
- [NTSB CEN18FA063](https://openairdocs.org/ntsb/CEN18FA063.md): Cessna 208 · Punta Islita, Costa Rica · Accident · 12 fatal · Field investigation · Final report · Dec 31, 2017 · TI-BEI · Destroyed
  > The flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…
- [NTSB DCA15MA019](https://openairdocs.org/ntsb/DCA15MA019.md): Scaled Composites 339 · Koehn Dry Lake, CA · Accident · 1 fatal · Class 1 · Major · Final report · Oct 31, 2014 · N339SS · Destroyed
  > Scaled Composites' failure to consider and protect against the possibility that a single human error could result in a catastrophic hazard to the SpaceShipTwo vehicle. This failure set the stage for the copilot's premature unlocking of the feather system as a…
- [NTSB DCA13MA120](https://openairdocs.org/ntsb/DCA13MA120.md): Boeing 777-200ER · San Francisco, CA · Accident · 3 fatal · Class 1 · Major · Final report · Jul 6, 2013 · HL7742 · Destroyed
  > The flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…
- [NTSB ANC13GA036](https://openairdocs.org/ntsb/ANC13GA036.md): Eurocopter AS350 · Talkeetna, AK · Accident · 3 fatal · Class 1 · Final report · Mar 31, 2013 · N911AA · Destroyed
  > The pilot's decision to continue flight under visual flight rules into deteriorating weather conditions, which resulted in the pilot's spatial disorientation and loss of control. Also causal was the Alaska Department of Public Safety's punitive culture and…
- [NTSB DCA11MA076](https://openairdocs.org/ntsb/DCA11MA076.md): Gulfstream GVI · Roswell, NM · Accident · 4 fatal · Class 1 · Major · Final report · Apr 2, 2011 · N652GD · Substantial damage
  > The National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…

## 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", '040220'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/040220/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.
