NTSB investigations: Piper PA-20, OR
15 cases on aircraft the registry lists as Piper PA-20. 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 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1971 | 2 |
| 1975 | 2 |
| 1978 | 1 |
| 1984 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2008 | 1 |
| 2013 | 1 |
| 2014 | 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\" = 'OR' 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 ('7102002'))
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" = 'OR' 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 ('7102002'))
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 WPR14CA326Accident · No injuriesData collectionFinal reportPiper PA20 - Undesignat · Dayton, ORThe pilot's decision to land on an unsuitable surface, which resulted in a nose over.NTSB WPR13CA372Accident · No injuriesData collectionFinal reportPiper PA-20 · Aurora, ORThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground-loop.NTSB SEA08CA141Accident · No injuriesData collectionFinal reportPiper PA-20 · Fields, ORThe pilot's failure to maintain aircraft control during the approach. Contributing to the accident was a windshear.NTSB SEA01LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hood River, ORThe pilot's failure to maintain directional control during landing.NTSB SEA96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mulino, ORloss of engine power for undetermined reason(s).NTSB SEA84LA047Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Imnaha, ORThe acft nosed over during a forced landing on a snow covered field. The plt reported that the acft began to lose power at about 6500 ft MSL. An inspection of the eng did not reveal any mechanical malfunction or discrepancy.NTSB SEA79FA010Accident · 3 fatalClosedPiper PA-20 · Joseph, ORNTSB SEA75DYI31Accident · No injuriesClosedPiper PA-20 · Eugene, ORNTSB SEA75AS032Accident · 3 fatalClosedPiper PA-20 · Drain, ORNTSB SEA72FYC24Accident · Minor injuriesClosedPiper PA-20 · Washougal, ORNTSB SEA72DYC10Accident · No injuriesClosedPiper PA-20 · Woodburn, ORNTSB SEA71DVQ09Accident · No injuriesClosedPiper PA-20 · Klamath Flls, ORNTSB SEA69F0064Accident · No injuriesClosedPiper PA-20 · Redmond, ORNTSB SEA67A0007Accident · 3 fatalClosedPiper PA-20 · Glide, ORNTSB SEA65F0039Accident · No injuriesClosedPiper PA-20 · Ontario, OR