NTSB investigations: Piper PA-22-108, CO
10 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 | 4 |
|---|---|
| 1966 | 1 |
| 1974 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 2011 | 1 |
| 2025 | 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\" = 'CO' 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" = 'CO' 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 CEN26LA053Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-108 · Colorado Springs, COThe pilot’s failure to maintain directional control during the landing.NTSB CEN11CA677Accident · No injuriesData collectionFinal reportPiper PA-22-108 · Monte Vista, COThe student pilot's loss of control while landing, which resulted in a ground loop.NTSB DEN86FA147Accident · 1 fatalField investigationFinal reportPiper PA-20-160 · Buena Vista, COWhen the plt took off, the wind was light & variable. However, when he returned to the arpt about 20 to 30 min later, dark threatening clouds had moved into the area. He attempted to land on rwy 14. During the landing, the acft bounced & went off the right…NTSB DEN85LA206Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Boulder, COAccording to the plt, he was approaching the Boulder municipal arpt, Boulder, Colorado, for a VFR landing when his engine failed to develop sufficient power to sustain flight. A forced landing was made to a farmer's field. The acft sustained substantial…NTSB DEN75AD026Accident · 1 fatalClosedPiper PA-22 · Craig, CONTSB DEN66D0226Accident · No injuriesClosedPiper PA-22 · Denver, CONTSB DEN66F0148Accident · No injuriesClosedPiper PA-22 · Broomfield, CONTSB DEN66D0120Accident · No injuriesClosedPiper PA-22 · La Junta, CONTSB DEN65D0098Accident · No injuriesClosedPiper PA-22 · Montrose, CONTSB DEN65F0008Accident · No injuriesClosedPiper PA22 · Broomfield, CO