# Fatal NTSB investigations: Air traffic event

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 CEN24LA144](https://openairdocs.org/ntsb/CEN24LA144.md): Piper PA28 · Muncie, IN · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 1, 2024 · N8438B · Destroyed
  > The pilot’s spatial disorientation and subsequent loss of control while maneuvering outside established instrument approach procedures in instrument meteorological conditions, which resulted in an impact with terrain. Contributing to the accident was the…
- [NTSB ERA22FA318](https://openairdocs.org/ntsb/ERA22FA318.md): Piper PA-46-350P · North Las Vegas, NV · Accident · 4 fatal · Class 3 · Field · Final report · Jul 17, 2022 · N97CX · 2 aircraft · Destroyed
  > The low-wing airplane pilot’s failure to ensure that the airplane was aligned with the correct runway, which resulted in a collision with the high-wing airplane on final approach. Contributing to the accident was the controller’s failure to provide timely and…
- [NTSB CEN13LA244](https://openairdocs.org/ntsb/CEN13LA244.md): Dean Leslie N Highlander · Bryan, OH · Accident · 1 fatal · Limited investigation · Final report · Apr 27, 2013 · N58LD · Substantial damage
  > The pilot's failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.
- [NTSB DCA12PA049](https://openairdocs.org/ntsb/DCA12PA049.md): Israel Aircraft Industries F21-C2 · Fallon, NV · Accident · 1 fatal · Final report · Mar 6, 2012 · N404AX · Destroyed
  > fuel exhaustion following missed approaches due to deficient ATC handling under weather conditions which were significantly lower than forecast. The second missed approach may have been initiated due to limited pilot instrument proficiency. Contributing to…
- [NTSB WPR11FA032](https://openairdocs.org/ntsb/WPR11FA032.md): Mooney M20J · Lander, WY · Accident · 4 fatal · Field investigation · Final report · Oct 25, 2010 · N201HF · Substantial damage
  > The pilot's decision to depart into known adverse weather conditions over mountainous terrain, which required operation near the limits of the airplane's performance capability and which resulted in a loss of airplane control and subsequent ground impact.…
- [NTSB CEN10FA065](https://openairdocs.org/ntsb/CEN10FA065.md): New Piper PA-46-500TP · Mendoza, TX · Accident · 2 fatal · Field investigation · Final report · Dec 7, 2009 · N600YE · Substantial damage
  > ***This report was modified on May 22, 2014. Please see the docket for this accident to view the original report.*** The pilot's spatial disorientation, which resulted in his loss of airplane control. Contributing to the pilot's spatial disorientation was the…

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '100' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/100/sequence?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.