NTSB investigations: Piper PA-22-135, IL
16 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
| 1964 | 3 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 1 |
| 1972 | 2 |
| 1974 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1983 | 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\" = 'IL' 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" = 'IL' 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 CHI94LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Harvard, ILthe pilot's excessive taxi speed. A factor in the accident was the wet grass runway.NTSB CHI93LA191Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Kewanee, ILThe pilot's failure to refuel the airplane prior to fuel exhaustion. A factor in the accident is the pilot's inadvertent stall/mush during the forced landing.NTSB CHI83LA352Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Pittsfield, ILThe student plt was on a personal flt with a passenger on board. During arrival, he landed on rwy 25 (1700 ft long) with a x-wind from 160 deg at 8 KTS. He reported that the landing was made on his 2nd attempt, but he did not get on the ground soon enough to…NTSB CHI80FA025Accident · 2 fatalClosedPiper PA-22 · Princeton, ILNTSB CHI78FEE35Accident · Serious injuriesClosedPiper PA-22 · Marseilles, ILNTSB CHI74FEE65Accident · No injuriesClosedPiper PA-22 · Monee, ILNTSB CHI73DEE33Accident · No injuriesClosedPiper PA-22 · Lockport, ILNTSB CHI73DEE07Accident · No injuriesClosedPiper PA-22 · Hinsdale, ILNTSB CHI68F0706Accident · Minor injuriesClosedPiper PA-22 · Kankakee, ILNTSB CHI68D0242Accident · No injuriesClosedPiper PA-22 · Pekin, ILNTSB CHI67D0523Accident · No injuriesClosedPiper PA-22 · Lemont, ILNTSB CHI66D0700Accident · No injuriesClosedPiper PA-22 · Galva, ILNTSB CHI65F0113Accident · No injuriesClosedPiper PA-22 · Tinley Park, ILNTSB UNK64X4092Accident · No injuriesClosedPiper PA22 · Taylorville, ILNTSB UNK64X3108Accident · No injuriesClosedPiper PA22 · Wheeling, ILNTSB UNK64X0834Accident · No injuriesClosedPiper PA22 · East Moline, IL