# NTSB investigations: Piper PA-18, NE

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 CEN12CA148](https://openairdocs.org/ntsb/CEN12CA148.md): Piper PA-18 · Thedford, NE · Accident · No injuries · Data collection · Final report · Feb 5, 2012 · N3671Z · Substantial damage
  > The pilot did not maintain directional control during landing, which resulted in a runway excursion.
- [NTSB CHI91LA069](https://openairdocs.org/ntsb/CHI91LA069.md): Piper PA-18 · Ashland, NE · Accident · No injuries · Limited investigation · Final report · Jan 12, 1991 · N2115A · Substantial damage
  > The pilot's failure to maintain clearance above the terrain. Factors related to the accident were the low pass and ostentatious display.
- [NTSB MKC87FA051](https://openairdocs.org/ntsb/MKC87FA051.md): Piper PA-18 · Venango, NE · Accident · 1 fatal · Field investigation · Final report · Feb 22, 1987 · N9498D · Destroyed
  > A witness saw the airplane fly over his property from the north to the south and he waved to the pilots. The airplane then came back toward the north at a low altitude and when the witness heard the power being applied, the left wing dropped and almost…
- [NTSB MKC78DCJ14](https://openairdocs.org/ntsb/MKC78DCJ14.md): Piper PA-18 · Haigler, NE · Accident · No injuries · Closed · Mar 22, 1978 · N1451C · Substantial damage
- [NTSB MKC76DCJ58](https://openairdocs.org/ntsb/MKC76DCJ58.md): Piper PA-18 · Abie, NE · Accident · 1 fatal · Closed · Aug 5, 1976 · N9103D · Destroyed
- [NTSB MKC73FCJ35](https://openairdocs.org/ntsb/MKC73FCJ35.md): Piper PA-18 · Maywood, NE · Accident · Serious injuries · Closed · Apr 28, 1973 · N1228A · Destroyed
- [NTSB MKC72AK019](https://openairdocs.org/ntsb/MKC72AK019.md): Piper PA-18 · Seneca, NE · Accident · 2 fatal · Closed · Sep 18, 1971 · N7166K · Destroyed
- [NTSB MKC71AK008](https://openairdocs.org/ntsb/MKC71AK008.md): Piper PA-18 · Merriman, NE · Accident · 1 fatal · Closed · Aug 9, 1970 · N9060D · Destroyed
- [NTSB MKC68F0140](https://openairdocs.org/ntsb/MKC68F0140.md): Piper PA-18 · Alliance, NE · Accident · No injuries · Closed · Jun 28, 1967 · N1277A · Substantial damage
- [NTSB MKC68D0056](https://openairdocs.org/ntsb/MKC68D0056.md): Piper PA-18 · Angora, NE · Accident · No injuries · Closed · May 19, 1967 · N9103D · Substantial damage
- [NTSB UNK65X1519](https://openairdocs.org/ntsb/UNK65X1519.md): Piper PA-18A · Kimball, NE · Accident · No injuries · Closed · Jul 25, 1965 · N9099D · Substantial damage
- [NTSB MKC66F0094](https://openairdocs.org/ntsb/MKC66F0094.md): Piper PA-18 · Fremont, NE · Accident · Minor injuries · Closed · Jul 17, 1965 · N7489D · Substantial damage
- [NTSB MKC65D0023](https://openairdocs.org/ntsb/MKC65D0023.md): Piper PA-18 · Eustis, NE · Accident · No injuries · Closed · Feb 6, 1965 · N8671C · 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" = 'NE' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7101802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7101802&state=NE

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