NTSB investigations: Piper PA-22-135, PA
13 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
| 1965 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1990 | 1 |
| 2010 | 1 |
| 2013 | 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\" = 'PA' 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" = 'PA' 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 ERA14LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Selinsgrove, PAThe incorrect (reverse) rigging of the elevator cables by maintenance personnel and their subsequent failure to verify that the rigging was correct during postmaintenance checks and the pilot's inadequate preflight check.NTSB ERA10CA245Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Hoensdale, PAThe pilot's improper final approach, resulting in a bounced landing and ground loop. Contributing to the accident was the pilot's lack of experience in tailwheel airplanes.NTSB NYC90LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Franklin Center, PALoss of engine power for an undetermined reason and the failure of the pilot to maintain airspeed during a forced landing which restuled in an inadvertent stall.NTSB NYC84LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Canton, PAThe pilot performed a runup prior to departure. He used one notch of flaps and approximately 800 feet of runway to break ground. During the climbout at approximately 200 ft the engine 'started skipping then quit.' The pilot was unable to restore power before…NTSB NYC83FHA03Accident · Serious injuriesFinal reportPiper PA-22-135 · New Hope, PAThe acft collided with a power line while the pilot and a friend in another plane were flying along the deleware river. The plt reported that as he approached a bridge, he climbed to clear over the bridge and some power lines, then started to descend. He…NTSB NYC76FGT21Accident · No injuriesClosedPiper PA-22 · Tower City, PANTSB NYC73DHA19Accident · No injuriesClosedPiper PA-22 · Prospectville, PANTSB NYC71DHA37Accident · No injuriesClosedPiper PA-22 · Warrington, PANTSB NYC70DHA06Accident · No injuriesClosedPiper PA-22 · Langhorne, PANTSB NYC69F0259Accident · No injuriesClosedPiper PA-22 · Bessemer, PANTSB NYC68D0351Accident · No injuriesClosedPiper PA-22 · Roaring Branch, PANTSB NYC68F0046Accident · No injuriesClosedPiper PA-22 · Belle Vernon, PANTSB NYC65D0095Accident · No injuriesClosedPiper PA-22 · Corsica, PA