# Final NTSB investigations: Piper PA-28-180, 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 GAA15CA103](https://openairdocs.org/ntsb/GAA15CA103.md): Piper PA 28-180 · Steele, ND · Accident · No injuries · Data collection · Final report · May 12, 2015 · N56074 · Substantial damage
  > The pilot's failure to maintain directional control during landing, which resulted in a collision with objects while attempting to abort the landing.
- [NTSB CHI93LA033](https://openairdocs.org/ntsb/CHI93LA033.md): Piper PA-28-180 · Makoti, ND · Accident · No injuries · Limited investigation · Final report · Nov 15, 1992 · N7057W · Substantial damage
  > The pilot not maintaining a proper glidepath during his approach to landing.
- [NTSB DEN86LA209](https://openairdocs.org/ntsb/DEN86LA209.md): Piper PA-28-180 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Jul 26, 1986 · N7592W · Destroyed
  > The plt reports that the flt was descending through 7,000 ft approaching the dest arpt when the eng began to run rough and lost pwr. The flt continued toward to the arpt but was unable to reach the rwy and landed about 1/4 mi short. After touchdown the acft…
- [NTSB MKC76FTG27](https://openairdocs.org/ntsb/MKC76FTG27.md): Piper PA-28 · Maddock, ND · Accident · No injuries · Closed · Aug 24, 1976 · N4405T · Substantial damage
- [NTSB MKC74AK041](https://openairdocs.org/ntsb/MKC74AK041.md): Piper PA-28 · Christine, ND · Accident · 1 fatal · Closed · Jan 26, 1974 · N6617J · Destroyed
- [NTSB MKC69F0258](https://openairdocs.org/ntsb/MKC69F0258.md): Piper PA-28 · Mayville, ND · Accident · No injuries · Closed · Sep 29, 1968 · N8007W · Substantial damage
- [NTSB MKC69D0107](https://openairdocs.org/ntsb/MKC69D0107.md): Piper PA-28 · Hazen, ND · Accident · No injuries · Closed · Jul 7, 1968 · N8994J · Substantial damage
- [NTSB MKC68D0539](https://openairdocs.org/ntsb/MKC68D0539.md): Piper PA-28 · Langdon, ND · Accident · No injuries · Closed · Apr 26, 1968 · N7526W · Substantial damage
- [NTSB MKC68F0465](https://openairdocs.org/ntsb/MKC68F0465.md): Piper PA-28 · Windsor, ND · Accident · No injuries · Closed · Mar 1, 1968 · N7549W · Substantial damage
- [NTSB MKC68F0043](https://openairdocs.org/ntsb/MKC68F0043.md): Piper PA-28 · Langdon, ND · Accident · No injuries · Closed · Jan 30, 1968 · N7000W · Substantial damage
- [NTSB MKC67D0516](https://openairdocs.org/ntsb/MKC67D0516.md): Piper PA-28 · Cooperstown, ND · Accident · No injuries · Closed · Mar 23, 1967 · N9282J · Substantial damage
- [NTSB UNK64X2077](https://openairdocs.org/ntsb/UNK64X2077.md): Piper PA28 · Williston, ND · Accident · No injuries · Closed · Jun 2, 1964 · N7167W · 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.aircraft_model_code IN ('7102808'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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