Skip to content

NTSB investigations: Piper PA-28-180, NM

29 cases on aircraft the registry lists as Piper PA-28-180. 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 ('7102808')) 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 ('7102808'))
  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 ('7102808'))
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 WPR22LA041Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Farmington, NMThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.Nov 17, 2021 · N9467J · Substantial damage NTSB WPR21LA174Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Silver City, NMThe pilot’s loss of situational awareness and failure to touchdown on the runway which resulted in a collision with the airport’s perimeter fence.Apr 12, 2021 · N222BM · Substantial damage NTSB CEN16LA349Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Cuba, NMA partial loss of engine power for reasons that could not be determined based on available information.Sep 4, 2016 · N9241J · Substantial damage NTSB FTW02LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Teresa, NMthe pilot's inadequate compensation for the gusty crosswind conditions resulting in a loss of control of the airplane during the landing. A contributing factor was the gusty crosswind.May 2, 2002 · N7504W · Substantial damage NTSB DEN99LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Edgewood, NMThe pilot's excessive rotation during takeoff, resulting in an inadvertent stall/mush. Factors were the pilot's lack of recent flight experience, and the high density altitude..Jul 31, 1999 · N7521W · Substantial damage NTSB FTW97LA315Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gila, NMthe pilot's impairment of judgment and performance due to alcohol, and his failure to maintain directional control of the airplane, which resulted in a ground swerve, and collision with vegetation (cactus) and a fence. Related factors were: the soft runway…Aug 19, 1997 · N9455J · Substantial damage NTSB FTW94LA005Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180C · Albuquerque, NMThe pilot's failure to maintain adequate airspeed. The high density altitude was a factor.Oct 5, 1993 · N9317J · Destroyed NTSB FTW93LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Magdalena, NMFuel exhaustion power loss due to the pilot's failure to refuel. Factors were the unsuitable terrain and the dark nightFeb 13, 1993 · N2187R · Substantial damage NTSB DEN85LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Angle Fire, NMOn June 26, 1985, a Piper pa 28-180, descended and crashed after takeoff from angel Fire airport, NM. The plt reported no mechanical difficulties. The density alt was 10609 ft. the takeoff distance chart indicates a maximum da of 7000 ft. the plt was not…Jun 26, 1985 · N6504J · Substantial damage NTSB DEN84LA198Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Albuquerque, NMWhile en route, the acft's ELT suddenly activated. The plt made an unplanned landing at laguna, NM to correct the ELT problem, then he continued on to coronado arpt at Albuquerque, NM. He said this incident made him tense. After receiving radar vectors to the…Jun 26, 1984 · N44017 · Substantial damage NTSB FTW81DQA44Accident · No injuriesClosedPiper PA-28 · Clayton, NMAug 26, 1981 · N1057X · Substantial damage NTSB DEN78FQA23Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMMay 15, 1978 · N7553W · Substantial damage NTSB DEN78FA008Accident · 1 fatalClosedPiper PA-28 · Carlsbad, NMNov 25, 1977 · N2665T · Substantial damage NTSB DEN77FQA26Accident · Serious injuriesClosedPiper PA-28 · Las Vegas, NMMar 8, 1977 · N5122G · Destroyed NTSB DEN74FQA07Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMJul 13, 1973 · N9602J · Substantial damage NTSB DEN73DQD14Accident · No injuriesClosedPiper PA-28 · Alamogordo, NMJan 21, 1973 · N6502J · Substantial damage NTSB DEN72FQA45Accident · No injuriesClosedPiper PA-28 · Gallup, NMJun 27, 1972 · N6362J · Substantial damage NTSB DEN72FQA10Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMAug 9, 1971 · N5374L · Substantial damage NTSB DEN71DQD15Accident · No injuriesClosedPiper PA-28 · Columbus, NMFeb 26, 1971 · N7926N · Substantial damage NTSB DEN71FQA42Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMJan 17, 1971 · N7472W · Substantial damage NTSB DEN71DQA31Accident · No injuriesClosedPiper PA-28 · Taos, NMNov 28, 1970 · N9618J · Substantial damage NTSB DEN71FQA30Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMNov 25, 1970 · N9101J · Substantial damage NTSB DEN69D0110Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMOct 13, 1968 · N8419W · Substantial damage NTSB DEN69A0018Accident · 4 fatalClosedPiper PA-28 · Santa Fe, NMOct 2, 1968 · N8905J · Destroyed NTSB DEN68D0188Accident · No injuriesClosedPiper PA-28 · Clines Cnrs, NMDec 18, 1967 · N9671J · Substantial damage NTSB DEN67F0288Accident · Minor injuriesClosedPiper PA-28 · Albuquerque, NMJun 9, 1967 · N9728J · Substantial damage NTSB DEN67D0212Accident · No injuriesClosedPiper PA-28 · Roswell, NMFeb 4, 1967 · N7786W · Substantial damage NTSB DEN67D0090Accident · No injuriesClosedPiper PA-28 · Alamogordo, NMJul 4, 1966 · N7574W · Substantial damage NTSB UNK64X2658Accident · No injuriesClosedPiper PA28 · Rosweell, NMJul 5, 1964 · N7486W · Substantial damage