NTSB investigations: Piper PA-22-135, NY
17 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 | 4 |
|---|---|
| 1965 | 1 |
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 2 |
| 1969 | 2 |
| 1971 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1999 | 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\" = 'NY' 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" = 'NY' 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 NYC99FA181Accident · 1 fatalField investigationFinal reportPiper PA 22-135 · Palatine, NYThe pilot was impaired by an illegal drug, and entered an inadvertent stall/spin.NTSB NYC83LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Olean, NYThe acft nosed over during taxi after landing when the acft went off the runway into soft dirt. The student pilot had completed a cross-country flight without incident. After landing during taxi at Olean, NY the pilot applied brakes and the acft swerved to…NTSB NYC81FFJ12Accident · Minor injuriesClosedPiper PA-22 · Mayville, NYNTSB NYC77FFJ16Accident · No injuriesClosedPiper PA-22 · Angola, NYNTSB NYC72DFJ21Incident · No injuriesClosedPiper PA-22 · Central Sq, NYNTSB NYC69D0336Accident · No injuriesClosedPiper PA-22 · East Bethany, NYNTSB NYC69F0294Accident · No injuriesClosedPiper PA-22 · Amityville, NYNTSB NYC69D0006Accident · Minor injuriesClosedPiper PA-22 · Old Forge, NYNTSB NYC69F0053Accident · Serious injuriesClosedPiper PA-22 · Canastota, NYNTSB NYC67F0600Accident · No injuriesClosedPiper PA-22 · Monticello, NYNTSB NYC67F0109Accident · No injuriesClosedPiper PA-22 · Bethpage, NYNTSB NYC66D0521Accident · No injuriesClosedPiper PA-22 · Olean, NYNTSB NYC66F0332Accident · No injuriesClosedPiper PA-22 · Rochester, NYNTSB UNK65X0720Accident · No injuriesClosedPiper PA22 · Montauk, NYNTSB UNK64X3280Accident · No injuriesClosedPiper PA22 · Staten Island, NYNTSB UNK64X1808Accident · No injuriesClosedPiper PA22 · Albany, NYNTSB UNK64X0284Accident · No injuriesClosedPiper PA22 · Amherst, NY