NTSB investigations: Piper PA-18, NE
13 cases on aircraft the registry lists as Piper PA-18. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1965 | 3 |
|---|---|
| 1967 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 2012 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN12CA148Accident · No injuriesData collectionFinal reportPiper PA-18 · Thedford, NEThe pilot did not maintain directional control during landing, which resulted in a runway excursion.NTSB CHI91LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ashland, NEThe pilot's failure to maintain clearance above the terrain. Factors related to the accident were the low pass and ostentatious display.NTSB MKC87FA051Accident · 1 fatalField investigationFinal reportPiper PA-18 · Venango, NEA 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 MKC78DCJ14Accident · No injuriesClosedPiper PA-18 · Haigler, NENTSB MKC76DCJ58Accident · 1 fatalClosedPiper PA-18 · Abie, NENTSB MKC73FCJ35Accident · Serious injuriesClosedPiper PA-18 · Maywood, NENTSB MKC72AK019Accident · 2 fatalClosedPiper PA-18 · Seneca, NENTSB MKC71AK008Accident · 1 fatalClosedPiper PA-18 · Merriman, NENTSB MKC68F0140Accident · No injuriesClosedPiper PA-18 · Alliance, NENTSB MKC68D0056Accident · No injuriesClosedPiper PA-18 · Angora, NENTSB UNK65X1519Accident · No injuriesClosedPiper PA-18A · Kimball, NENTSB MKC66F0094Accident · Minor injuriesClosedPiper PA-18 · Fremont, NENTSB MKC65D0023Accident · No injuriesClosedPiper PA-18 · Eustis, NE