NTSB investigations: Piper PA-20, MI
14 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 |
| 1967 | 1 |
| 1970 | 1 |
| 1972 | 2 |
| 1975 | 2 |
| 1983 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 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\" = 'MI' 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" = 'MI' 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 CHI94LA337Accident · 1 fatalLimited investigationFinal reportPiper PA-20 · Greenville, MIIncapacitation of the pilot due to a seizure and/or loss of consciousness. A factor related to the accident was: the pilot's failure to properly report his medical information on his FAA medical application.NTSB CHI93LA151Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lapeer, MIThe pilot's failure to maintain directional control during the landing roll.NTSB CHI91LA271Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Saginaw, MIDirectional control was not maintained by the pilot which resulted in a ground loop. A factor related to the accident was a crosswind.NTSB CHI89LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Gladwin, MIFailure of the pilot seated in the left seat of the airplane to use brakes to correct for a left turn caused by a bent tail wheel.NTSB CHI85LA349Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Bay City, MIThe acft was damaged during a hard forced landing following a loss of pwr shortly after takeoff. The plt reported that at an alt of aprx 250 ft AGL, the eng quit. Post accident inspection revealed the fuel selector was positioned on the right tank which…NTSB CHI83LA320Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Mason, MIThe student & instructor plt (CFI) were practicing landings in the student's acft, which was equipped with brakes only on the left side. Reportedly, the student flared high during a landing & the CFI added power to recover. After touchdown, the roll-out was…NTSB CHI76DEM08Accident · No injuriesClosedPiper PA-20 · Charlotte, MINTSB CHI76FEC06Accident · No injuriesClosedPiper PA-20 · Tecumseh, MINTSB CHI72DET25Accident · No injuriesClosedPiper PA-20 · Benton Harbr, MINTSB CHI72DEM62Accident · No injuriesClosedPiper PA-20 · Charlotte, MINTSB CHI71AC001Accident · 1 fatalClosedPiper PA-20 · Mikado, MINTSB CHI68F0147Accident · No injuriesClosedPiper PA-20 · Spring Port, MINTSB CHI67F0230Accident · No injuriesClosedPiper PA-20 · Ionia, MINTSB CHI66F0077Accident · No injuriesClosedPiper PA-20 · Luzerne, MI