NTSB investigations: Piper PA-22-108, WI
17 cases on aircraft the registry lists as Piper PA-22-108. 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 | 2 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1976 | 1 |
| 1981 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1998 | 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\" = 'WI' 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 ('7102204'))
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" = 'WI' 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 ('7102204'))
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 CHI98LA350Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Janesville, WIthe pilot's failure to land the airplane at a proper touchdown point on the runway. A factor was the excessive rate of descent which developed on final approach.NTSB CHI91LA284Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Pulaski, WIThe pilot's inadequate compensation for wind conditions. The gusty crosswind was a related factor.NTSB CHI89LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Necedah, WIPilot-in-command's improper use of the fuel selector.NTSB CHI81FER15Accident · No injuriesClosedPiper PA-22 · Turtle Lake, WINTSB CHI77DEP11Accident · No injuriesClosedPiper PA-22 · West Bend, WINTSB CHI73AC045Accident · 2 fatalClosedPiper PA-22 · Wisconsn Rpds, WINTSB CHI73FEP03Accident · Serious injuriesClosedPiper PA-22 · Arkdale, WINTSB CHI71DDJ37Accident · No injuriesClosedPiper PA-22 · Platteville, WINTSB CHI71AC053Accident · 1 fatalClosedPiper PA-22 · Dyckesville, WINTSB CHI71DDJ25Accident · No injuriesClosedPiper PA-22 · Niagara, WINTSB CHI69D0294Accident · Minor injuriesClosedPiper PA-22 · Platteville, WINTSB CHI68D0580Accident · No injuriesClosedPiper PA-22 · Platteville, WINTSB CHI67D0524Accident · No injuriesClosedPiper PA-22 · Eleva, WINTSB CHI67D0014Accident · No injuriesClosedPiper PA22 · Janesville, WINTSB CHI66D0593Accident · No injuriesClosedPiper PA-22 · Janesville, WINTSB CHI66D0049Accident · No injuriesClosedPiper PA-22 · Milwaukee, WINTSB CHI65F0172Accident · No injuriesClosedPiper PA-22 · Eau Claire, WI