Skip to content

NTSB investigations: Piper PA-22-150, NY

38 cases on aircraft the registry lists as Piper PA-22-150. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 ('7102210')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7102210'))
  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 ('7102210'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA20CA246Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA22 · Cortland, NYThe mechanic’s incorrect rigging of the aileron control cables, which resulted in a reversal of aileron control inputs applied by the pilot during the takeoff. Also causal was the mechanic’s inadequate post-maintenance inspection and the pilot's inadequate…Jul 13, 2020 · N2716P · Substantial damage NTSB ERA15LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA 22-150 · Tompkins, NYA total loss of engine power for reasons that could not be determined during postaccident examinations and testing.Oct 25, 2014 · N8064Y · Substantial damage NTSB ERA12CA350Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Norwich, NYThe pilot's inability to maintain directional control during a landing with a deflated left main landing gear tire.May 19, 2012 · N3956P · Substantial damage NTSB NYC06CA051Accident · No injuriesData collectionFinal reportPiper PA-22 · Jamestown, NYThe pilot's failure to maintain directional control during the landing rollout. Factors included the ice on the runway and the soft terrain.Dec 28, 2005 · N4792A · Substantial damage NTSB NYC99LA105Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Oswego, NYThe pilot's inadequate fuel management which resulted in fuel starvation and subsequent loss of engine power.May 3, 1999 · N2716P · Substantial damage NTSB BFO93LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Mayville, NYThe pilot's failure to select the proper runway for takeoff, and his failure to maintain clearance with terrain. A factor related to the accident was a prevailing tailwind.Jul 5, 1993 · N1990P · Destroyed NTSB NYC91LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Nayville, NYFailure of the pilot to attain adequate airspeed to climb, which resulted in a stall/mush. The trees were a related factor.Jul 1, 1991 · N8670D · Substantial damage NTSB NYC85LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Batavia, NYThe commercial rated-flight instructor took off genesee co. airport and flew a normal pattern for landing. Some gustiness was noted by the pilot by observing the wind sock. During landing roll out, a slight swerve to the south, aircraft landing to the west,…May 17, 1985 · N7523D · Substantial damage NTSB NYC83LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Dansville, NYDuring landing the flange on the right main landing gear strut broke off allowing the shock cord to collapse.Jan 29, 1983 · N7523D · Substantial damage NTSB NYC82DA102Accident · Minor injuriesFinal reportPiper PA-22-150 · Seneca Falls, NYWhile trying to roll out of a left turn on downwind the pilot experienced a jammed rudder control. Full aileron control was not available because of the aileron-rudder interconnect system and a considerable buffet was induced during an attempt to level the…May 21, 1982 · N6086D · Substantial damage NTSB NYC79DFJ11Accident · Minor injuriesClosedPiper PA-22 · Niagara Falls, NYMar 3, 1979 · N2434P · Substantial damage NTSB NYC78FFJ27Accident · No injuriesClosedPiper PA-22 · Cicero, NYJul 30, 1978 · N5826D · Substantial damage NTSB NYC77FFA14Accident · No injuriesClosedPiper PA-22 · Watertown, NYFeb 27, 1977 · N2748P · Substantial damage NTSB NYC76FHM34Accident · Serious injuriesClosedPiper PA-22 · Cornwall, NYJul 29, 1976 · N3549Z · Substantial damage NTSB NYC75DFA35Accident · No injuriesClosedPiper PA-22 · Ballston Spa, NYApr 10, 1975 · N2632P · Substantial damage NTSB NYC73DFJ10Accident · No injuriesClosedPiper PA-22 · Wolcott, NYSep 20, 1972 · N3840P · Substantial damage NTSB NYC72DFJ32Accident · No injuriesClosedPiper PA-22 · East Amherst, NYMar 26, 1972 · N7341D · Substantial damage NTSB NYC72FFA07Accident · No injuriesClosedPiper PA-22 · Cobleskill, NYAug 16, 1971 · N4469A · Substantial damage NTSB NYC71DFJ31Accident · No injuriesClosedPiper PA-22 · Lockport, NYFeb 26, 1971 · N3200Z · Substantial damage NTSB NYC71FFA21Accident · No injuriesClosedPiper PA-22 · Duanesburg, NYOct 18, 1970 · N2395P · Substantial damage NTSB NYC71FFJ12Accident · Minor injuriesClosedPiper PA-22 · Farmersville, NYSep 20, 1970 · N7037D · Substantial damage NTSB NYC70D0051Accident · No injuriesClosedPiper PA-22 · Westville, NYJul 22, 1969 · N3417Z · Substantial damage NTSB NYC69A0059Accident · 1 fatalClosedPiper PA-22 · Lakewood, NYDec 5, 1968 · N3179Z · Substantial damage NTSB NYC69D0106Accident · No injuriesClosedPiper PA-22 · Plattsburgh, NYJul 1, 1968 · N2836P · Substantial damage NTSB NYC68F0193Accident · No injuriesClosedPiper PA-22 · Kingston, NYSep 8, 1967 · N7236D · Substantial damage NTSB NYC68D0156Accident · No injuriesClosedPiper PA-22 · New Salem, NYAug 31, 1967 · N7236D · Substantial damage NTSB NYC68F0043Accident · Minor injuriesClosedPiper PA-22 · Germantown, NYMay 28, 1967 · N5713D · Substantial damage NTSB NYC67F0608Accident · Serious injuriesClosedPiper PA-22 · Bloomingdale, NYApr 16, 1967 · N1795P · Substantial damage NTSB NYC67F0578Accident · No injuriesClosedPiper PA-22 · Marcy, NYFeb 26, 1967 · N3629P · Substantial damage NTSB NYC67F0210Accident · No injuriesClosedPiper PA-22 · Roscoe, NYAug 7, 1966 · N7457D · Substantial damage NTSB ANC67A0001Accident · Minor injuriesClosedPiper PA-22 · Garden City, NYJul 11, 1966 · N3500P · Destroyed NTSB NYC66D0703Accident · No injuriesClosedPiper PA-22 · Roscoe, NYMay 24, 1966 · N6920D · Substantial damage NTSB NYC66D0470Accident · No injuriesClosedPiper PA-22 · Ballston Spa, NYJan 22, 1966 · N2632P · Substantial damage NTSB NYC66D0455Accident · No injuriesClosedPiper PA-22 · Newburgh, NYJan 9, 1966 · N4821A · Substantial damage NTSB NYC65F0043Accident · No injuriesClosedPiper PA22 · Seneca Falls, NYFeb 6, 1965 · N6154D · Substantial damage NTSB UNK65X1386Accident · No injuriesClosedPiper PA22 · Dansville, NYFeb 3, 1965 · N3520P · Substantial damage NTSB UNK64X3939Accident · No injuriesClosedPiper PA22 · Endicott, NYSep 12, 1964 · N4353A · Destroyed NTSB UNK64X3193Accident · No injuriesClosedPiper PA22 · Whitelaw, NYAug 3, 1964 · N3725P · Destroyed