Skip to content

NTSB investigations: Piper PA-22-150, NM

27 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" = 'NM' 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\" = 'NM' 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" = 'NM' 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 CEN17FA315Accident · 1 fatalField investigationFinal reportPiper PA 22-150 · Las Vegas, NMThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to land, which resulted in an accelerated stall and the pilot’s subsequent loss of control. Contributing to the accident was the gap in the pilot’s flight experience, his…Aug 9, 2017 · N3664Z · Substantial damage NTSB CEN09CA301Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Las Cruces, NMThe pilot's failure to maintain directional control while landing in a crosswind. Contributing to the accident was the pilot's decision to land on a runway with a prevailing crosswind.May 17, 2009 · N8042D · Substantial damage NTSB FTW92LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Truth Or Cons, NMThe pilot's inability to stop due to worn brakes and low brake fluid.Jun 5, 1992 · N4547A · Substantial damage NTSB DEN90LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Las Vegas, NMThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.Aug 26, 1990 · N3163Z · Substantial damage NTSB DEN89LA015Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Edgewood, NMThe acft had just been overhauled & a new prop (hartzell model 7636D-4) had been installed in place of the old prop. The plt rprtd that after takeoff, the acft failed to climb, although he was using full power. He said he headed for lower terrain & circled…Oct 14, 1988 · N7258D · Substantial damage NTSB DEN88FA084Accident · 1 fatalField investigationFinal reportPiper PA-22 · Angel Fire, NMAfter takeoff, the acft could not outclimb rapidly rising terrain off the end of the rwy and collided with trees/terrain. Exam of wreckage disclosed fouled plugs from rich mixture and low cyl compression. Exam of airport info did not describe topography…Mar 19, 1988 · N3254Z · Destroyed NTSB FTW84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gallup, NMThe plt reported that he was taking off from a dirt road when the eng lost power shortly after lift-off. Subsequently, the left main gear collapsed during a hard/forced landing.Dec 12, 1983 · N3957P · Substantial damage NTSB FTW83LA156Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ramon, NMThe flt departed Oklahoma city, ok with en route stops planned at amarillo, TX tucumcari, NM. At tucumcari, the occupants found themselves 'staggering a little' & concluded this was from exposure to hi alt (en route 6500 ft, tucumcari, 4065 ft). After…Mar 15, 1983 · N1841P · Substantial damage NTSB FTW82FQG20Accident · Serious injuriesFinal reportPiper PA-22-150 · Clovis, NMThe eng quit immediately after takeoff & the acft flipped over during a forced landing in a plowed field. A 4 inch piece of gasket that was installed between the carburetor air filter & carburetor air box had come loose & was found lodged in the carburetor…Aug 27, 1982 · N4827A · Substantial damage NTSB DEN78DQA30Accident · No injuriesClosedPiper PA-22 · Eagle Nest, NMJun 9, 1978 · N1917P · Substantial damage NTSB DEN78FQA08Accident · Minor injuriesClosedPiper PA-22 · Albuquerque, NMDec 17, 1977 · N1745P · Substantial damage NTSB DEN71FQD24Accident · Minor injuriesClosedPiper PA-22 · Sunland Pk, NMMay 23, 1971 · N200F · Substantial damage NTSB DEN71FQA27Accident · Serious injuriesClosedPiper PA-22 · Folsom, NMNov 8, 1970 · N7554D · Destroyed NTSB DEN71FQA18Accident · Minor injuriesClosedPiper PA-22 · Bloomfield, NMOct 10, 1970 · N9974D · Substantial damage NTSB DEN71DQG40Accident · No injuriesClosedPiper PA-22 · Clovis, NMOct 5, 1970 · N3946P · Substantial damage NTSB DEN69D0039Accident · Minor injuriesClosedPiper PA-22 · Mountainair, NMJun 30, 1968 · N5810D · Substantial damage NTSB DEN69F0015Accident · No injuriesClosedPiper PA-22 · Roswell, NMJun 10, 1968 · N1687P · Substantial damage NTSB DEN68A0051Accident · 1 fatalClosedPiper PA-22 · Laguna, NMApr 23, 1968 · N2744P · Destroyed NTSB DEN68D0238Accident · Minor injuriesClosedPiper PA-22 · Clovis, NMFeb 12, 1968 · N3720Z · Substantial damage NTSB DEN67D0211Accident · No injuriesClosedPiper PA-22 · Newcomb, NMJan 20, 1967 · N6933B · Substantial damage NTSB DEN67D0026Accident · No injuriesClosedPiper PA-22 · Santa Rosa, NMJul 13, 1966 · N6067D · Substantial damage NTSB DEN66F0103Accident · Serious injuriesClosedPiper PA-22 · Grants, NMSep 3, 1965 · N4802A · Destroyed NTSB DEN66D0086Accident · No injuriesClosedPiper PA-22 · Albuquerque, NMJul 6, 1965 · N7546D · Substantial damage NTSB DEN66F0038Accident · No injuriesClosedPiper PA-22 · Roswell, NMApr 25, 1965 · N3634P · Substantial damage NTSB DEN65A0051Accident · 3 fatalClosedPiper PA22 · Bernardo, NMJan 24, 1965 · N4436A · Destroyed NTSB UNK64X3254Accident · No injuriesClosedPiper PA22 · Alameda, NMAug 7, 1964 · N8034D · Substantial damage NTSB UNK64X2528Accident · Serious injuriesClosedPiper PA22 · Cowles, NMJun 27, 1964 · N6179D · Destroyed