# Final NTSB investigations: Amateur-built UNKNOWN ENG, ND

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 GAA16CA326](https://openairdocs.org/ntsb/GAA16CA326.md): Schweizer G 164 · Cummings, ND · Accident · No injuries · Data collection · Final report · Jun 17, 2016 · N36333 · Substantial damage
  > The pilot's failure to maintain an adequate rate of descent while landing, which resulted in a hard landing, short of the runway.
- [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 CEN11LA541](https://openairdocs.org/ntsb/CEN11LA541.md): Weatherly 620B · Hettinger, ND · Accident · No injuries · Limited investigation · Final report · Jul 30, 2011 · N90181 · Substantial damage
  > Internal failure of the engine for undetermined reasons.
- [NTSB CHI00LA210](https://openairdocs.org/ntsb/CHI00LA210.md): Grumman G164 · Mcville, ND · Accident · No injuries · Limited investigation · Final report · Jul 10, 2000 · N10244 · Substantial damage
  > the pilot's failure to maintain clearance with the power lines. A factor associated with the accident was the power line.
- [NTSB DEN83LA099](https://openairdocs.org/ntsb/DEN83LA099.md): Enstrom F-28F · Belfield, ND · Accident · No injuries · Limited investigation · Final report · Apr 17, 1983 · N8623B · Substantial damage
  > The helicopter rolled over on a slight slope in an open field during a landing. The pilot stated that the acft touched down on the left skid, the acft started to tip to the left and he over corrected so that the acft rolled over to the right.
- [NTSB MKC75DTG10](https://openairdocs.org/ntsb/MKC75DTG10.md): Piper PA-18 · Cooperstown, ND · Accident · No injuries · Closed · Aug 4, 1974 · N167T · Substantial damage
- [NTSB MKC74FTG22](https://openairdocs.org/ntsb/MKC74FTG22.md): Piper PA-25 · Hazelton, ND · Accident · No injuries · Closed · Jun 27, 1974 · N7358Z · Substantial damage
- [NTSB MKC73FTG17](https://openairdocs.org/ntsb/MKC73FTG17.md): Stearman A75 · Northwood, ND · Accident · No injuries · Closed · May 30, 1973 · N75664 · Substantial damage
- [NTSB MKC71AK045](https://openairdocs.org/ntsb/MKC71AK045.md): Piper J3-C · Mcleod, ND · Accident · 2 fatal · Closed · Feb 10, 1971 · N92429 · Destroyed
- [NTSB MKC70FDD16](https://openairdocs.org/ntsb/MKC70FDD16.md): Piper PA-18 · Lehr, ND · Accident · 1 fatal · Closed · Jun 19, 1970 · N3281Z · Destroyed
- [NTSB MKC67A0020](https://openairdocs.org/ntsb/MKC67A0020.md): Boeing A75 · Hatton, ND · Accident · 1 fatal · Closed · Aug 31, 1966 · N75664 · Destroyed
- [NTSB MKC67D0088](https://openairdocs.org/ntsb/MKC67D0088.md): Piper PA-18 · Marion, ND · Accident · No injuries · Closed · Jun 24, 1966 · N3281Z · Substantial damage

## 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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=99999&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.