NTSB investigations: Piper PA-22-160, MI
18 cases on aircraft the registry lists as Piper PA-22-160. 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
| 1964 | 2 |
|---|---|
| 1965 | 4 |
| 1967 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1978 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1992 | 2 |
| 2017 | 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 ('7102214'))
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 ('7102214'))
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 GAA17CA416Accident · No injuriesData collectionFinal reportPiper PA 22 · Breckenridge, MIThe pilot’s loss of situational awareness during the approach over a corn field, which resulted in collision with corn stalks.NTSB CHI93LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Saline, MIThe pilot's failure to maintain aircraft control and airspeed.NTSB CHI93LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · West Branch, MIThe pilot's failure to maintain aircraft control during the landing roll.NTSB CHI83LA305Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Berrien Springs, MIThe plt reported that when he landed, the wind was variable from west to north at 12 to 15 KTS. He stated that after touchdown, he held the tail up in the slip stream. Reportedly, directional control was good until the acft entered an area that was not…NTSB CHI80FEC16Accident · Minor injuriesClosedPiper PA-22 · Hadley, MINTSB CHI79DEM39Accident · No injuriesClosedPiper PA-22 · Selkirk, MINTSB CHI78FEM31Accident · No injuriesClosedPiper PA-22 · Evart, MINTSB CHI78FA043Accident · 4 fatalClosedPiper PA-22 · Saint Helen, MINTSB CHI73FEC10Accident · No injuriesClosedPiper PA-22 · Sebewaing, MINTSB CHI71DEM91Accident · No injuriesClosedPiper PA-22 · Hubbard Lake, MINTSB CHI70FBJ22Accident · Minor injuriesClosedPiper PA-22 · Orangeville, MINTSB CHI67F0662Accident · No injuriesClosedPiper PA-22 · New Hudson, MINTSB CHI66D0173Accident · No injuriesClosedPiper PA-22 · Troy, MINTSB CHI65F0150Accident · No injuriesClosedPiper PA-22 · Plymouth, MINTSB CHI65F0137Accident · No injuriesClosedPiper PA-22 · Boyne Falls, MINTSB CHI65F0036Accident · No injuriesClosedPiper PA-22 · Kalamazoo, MINTSB UNK64X2026Accident · Minor injuriesClosedPiper PA22 · St Helen, MINTSB UNK64X0255Accident · No injuriesClosedPiper PA22 · BENTON HARBOr, MI