# Fatal, Final NTSB investigations, ND: Aircraft oper/perf/capability

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 CEN21LA044](https://openairdocs.org/ntsb/CEN21LA044.md): Piper PA-22-135 · Dunn Center, ND · Accident · 1 fatal · Class 3 · Limited · Final report · Nov 8, 2020 · N3606A · Destroyed
  > The noninstrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in a loss of control.
- [NTSB CEN19FA030](https://openairdocs.org/ntsb/CEN19FA030.md): Cessna 441 · Harmon, ND · Accident · 3 fatal · Class 2 · Field · Final report · Nov 18, 2018 · N441CX · Destroyed
  > The pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.
- [NTSB CEN16FA212](https://openairdocs.org/ntsb/CEN16FA212.md): Piper PA 28-140 · Wishek, ND · Accident · 3 fatal · Field investigation · Final report · Jun 9, 2016 · N6223W · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a climbing turn after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's self-induced pressure to…
- [NTSB CEN14FA400](https://openairdocs.org/ntsb/CEN14FA400.md): Larry Ketterling FEW P-51 Mustang · Lisbon, ND · Accident · 1 fatal · Field investigation · Final report · Aug 1, 2014 · N116LK · Destroyed
  > The partial loss of engine power for a reason that could not be determined because of extensive impact and postcrash fire damage, and the pilot's failure to maintain adequate airspeed, which resulted in the airplane's wing exceeding its critical…
- [NTSB CEN12LA615](https://openairdocs.org/ntsb/CEN12LA615.md): Goodyear F2G · Valley City, ND · Accident · 1 fatal · Limited investigation · Final report · Sep 7, 2012 · N5577N · Substantial damage
  > The pilot’s decision to initiate the aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.
- [NTSB CEN12LA336](https://openairdocs.org/ntsb/CEN12LA336.md): Bellanca 8GCBC · Zahl, ND · Accident · 1 fatal · Limited investigation · Final report · Jun 4, 2012 · N88095 · Substantial damage
  > The non-certificated pilot's improper preflight planning, which resulted in fuel exhaustion, and his failure to maintain airplane control after a total loss of engine power.
- [NTSB CEN09LA277](https://openairdocs.org/ntsb/CEN09LA277.md): Champion 7GCBC · Surrey, ND · Accident · 2 fatal · Limited investigation · Final report · May 3, 2009 · N5106T · Destroyed
  > The pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.

## 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."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0106'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/0106/cases?fatal=1&state=ND&status=final

---
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.
