NTSB investigations: Piper PA-22-135, CO
8 cases on aircraft the registry lists as Piper PA-22-135. 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
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1991 | 1 |
| 1999 | 1 |
| 2005 | 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 ('7102206'))
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 ('7102206'))
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 DEN05FA124Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Kremmling, COthe pilot's failure to maintain clearance from terrain.NTSB DEN99LA162Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Greeley, COThe pilot's inadvertent ground loop during landing roll. Factors were the malfunctioning self centering locking device on the tail wheel, the right rear quartering tail wind, and the 3 to 4 inch high berm along the edge of the runway.NTSB DEN92LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Siebert, COTotal loss of engine power due to a plugged vent in the tank filler cap, resulting in fuel starvation. Factors related to the accident were: darkness and the lack of suitable terrain for a forced landing.NTSB DEN78DTE49Accident · No injuriesClosedPiper PA-22 · Burlington, CONTSB DEN77FA046Accident · 2 fatalClosedPiper PA-22 · Englewood, CONTSB DEN72DTE37Accident · No injuriesClosedPiper PA-22 · Arboles, CONTSB DEN70DXD25Accident · Minor injuriesClosedPiper PA-22 · Pueblo, CONTSB DEN70D0095Accident · Minor injuriesClosedPiper PA-22 · Arriba, CO