# Fatal NTSB investigations: Physical, general

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 CEN11FA253](https://openairdocs.org/ntsb/CEN11FA253.md): Piper PA46-350P · Monroe, MI · Accident · 3 fatal · Field investigation · Final report · Mar 29, 2011 · N619VH · Substantial damage
  > The pilot's demonstration of poor judgment by attempting a high-speed pass several feet above the runway and his subsequent failure to maintain clearance from the runway.
- [NTSB CEN11GA020](https://openairdocs.org/ntsb/CEN11GA020.md): Bell 206B · Clarkson Valley, MO · Accident · 1 fatal · Final report · Oct 15, 2010 · N96MP · Substantial damage
  > The total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and decision-making, and his improper control inputs following the loss of engine power, which resulted in mast bumping and separation of the…
- [NTSB ANC10MA068](https://openairdocs.org/ntsb/ANC10MA068.md): Dehavilland DHC-3 · Aleknagik, AK · Accident · 5 fatal · Class 1 · Major · Final report · Aug 9, 2010 · N455A · Substantial damage
  > The pilot's temporary unresponsiveness for reasons that could not be established from the available information. Contributing to the investigation's inability to determine exactly what occurred in the final minutes of the flight was the lack of a cockpit…
- [NTSB CEN10LA459](https://openairdocs.org/ntsb/CEN10LA459.md): Schempp-Hirth VENTUS-2B · Batesville, TX · Accident · 1 fatal · Limited investigation · Final report · Aug 4, 2010 · N7470C · 2 aircraft · Substantial damage
  > Both glider pilots' inability to see and avoid the other resulting in a mid-air collision.
- [NTSB CEN10FA424](https://openairdocs.org/ntsb/CEN10FA424.md): Eurocopter AS 350 B2 · Kingfisher, OK · Accident · 2 fatal · Field investigation · Final report · Jul 23, 2010 · N918EM · Substantial damage
  > The pilot’s impaired judgment, due to medications, which led to an abrupt low-level maneuver and subsequent impact with trees and terrain.
- [NTSB CEN09LA311](https://openairdocs.org/ntsb/CEN09LA311.md): Thornton RV-6A · Plainwell, MI · Accident · 2 fatal · Limited investigation · Final report · May 21, 2009 · N39JT · Destroyed
  > The pilot's failure to maintain aircraft control for undetermined reasons.

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

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