Skip to content

NTSB investigations: Piper PA-24-250, NM

41 cases on aircraft the registry lists as Piper PA-24-250. 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 ('7102404')) 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 ('7102404'))
  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 ('7102404'))
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 GAA19CA053Accident · Minor injuriesData collectionFinal reportPiper PA24 · Texico, NMThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Nov 5, 2018 · N3214P · Substantial damage NTSB CEN14LA107Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Silver City, NMThe collapse of the landing gear during landing for reasons that could not be determined during postaccident examinations.Jan 3, 2014 · N6767P · Substantial damage NTSB DEN03LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Belen, NMthe pilot's improper preflight/in-flight decision making which resulted in the loss of engine power due to fuel starvation. Contributing factors include, the partial fuel selector valve failure, the pilot's intentional operation with known deficiencies in…Mar 14, 2003 · N6960P · Substantial damage NTSB FTW97FA103Accident · 5 fatalField investigationFinal reportPiper PA-24-250 · Farmington, NMloss of aircraft control for undetermined reason(s).Feb 15, 1997 · N6433P · Destroyed NTSB DEN90LA169Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bingham, NMThe fuel exhaustion induced power loss. Factors were the pilot's failure to refuel and the unsuitable terrain in which the forced landing was performed.Aug 11, 1990 · N5470P · Substantial damage NTSB DEN89FA045Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elephant Butte, NMDuring a return flight from having maintenance performed on the acft the plt executed a low pass by his home which was located on a point of land overlooking Elephant Butte reservoir, NM. During the maneuver while in a steep turn the left wing struck the…Dec 21, 1988 · N751SP · Destroyed NTSB DEN87FA046Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Leyba, NMThe plt departed albuquerque on October 29, 1986, in his acft for an unknown destination. When he failed to return to his home, relatives notified local authorities. A search was begun and on January 23, 1987, the wreckage was found. The pilot was deceased…Oct 29, 1986 · N8323P · Substantial damage NTSB DEN86FA098Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Truth&Consequen, NMThe plt took off on a night IFR flt after being briefed on adverse wx which included severe turbulence and moderate mixed icing conditions. The acft was not equipped for flt in icing conditions. Radio and radar contact with the flt was lost in the vicinity of…Mar 11, 1986 · N7410P · Destroyed NTSB DEN85LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Las Vegas, NMThe plt stated he was on a x-country flt and after aprx 1.5 hrs, the engine started to run rough. The plt attempted to correct the roughness and when he applied the carb heat, the engine quit. The plt turned off the carb heat but power could not be restored…Oct 3, 1984 · N5758P · Substantial damage NTSB FTW83LA388Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Lindreth, NMThe plt said he was approaching the rwy at 90 mph with full flaps and at 300 ft AGL he hit a downdraft. He added power and raised the nose but could not stop the descent.Aug 20, 1983 · N5230P · Substantial damage NTSB DEN79FQA48Accident · No injuriesClosedPiper PA-24 · Truth Or Cons, NMAug 23, 1979 · N8451P · Substantial damage NTSB DEN79FQA39Accident · No injuriesClosedPiper PA-24 · Angel Fire, NMJul 23, 1979 · N6499P · Substantial damage NTSB DEN79FQA22Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMMar 25, 1979 · N8243P · Substantial damage NTSB DEN79FQA12Accident · No injuriesClosedPiper PA-24 · Roswell, NMDec 17, 1978 · N8311P · Substantial damage NTSB DEN78FA056Accident · 3 fatalClosedPiper PA-24 · Carrizozo, NMAug 10, 1978 · N5338P · Destroyed NTSB DEN79FQG04Accident · No injuriesClosedPiper PA-28 · Hobbs, NMAug 7, 1978 · N8289P · Substantial damage NTSB DEN77DQA12Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMJan 23, 1977 · N8031P · Substantial damage NTSB DEN76FQA47Accident · No injuriesClosedPiper PA-24 · Los Lunas, NMMay 29, 1976 · N6178P · Substantial damage NTSB DEN75DQA33Accident · No injuriesClosedPiper PA-24 · Sanostee, NMFeb 20, 1975 · N7247P · Substantial damage NTSB DEN71DQG73Accident · Minor injuriesClosedPiper PA-24 · Clovis, NMJun 5, 1971 · N7402P · Substantial damage NTSB DEN71DQA57Accident · No injuriesClosedPiper PA-24 · Aztec, NMMay 28, 1971 · N7749P · Substantial damage NTSB DEN71FQA32Accident · No injuriesClosedPiper PA-24 · Taos, NMDec 16, 1970 · N7687P · Destroyed NTSB DEN71FQA23Accident · No injuriesClosedPiper PA-24 · Gallup, NMOct 30, 1970 · N7749P · Substantial damage NTSB DEN70D0101Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMOct 21, 1969 · N6983P · Substantial damage NTSB DEN69F0229Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMMay 5, 1969 · N8299P · Substantial damage NTSB DEN69D0049Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMJul 6, 1968 · N6235P · Substantial damage NTSB DEN68D0170Accident · Minor injuriesClosedPiper PA-24 · Willard, NMDec 21, 1967 · N8004P · Substantial damage NTSB DEN67A0073Accident · 2 fatalClosedPiper PA-24 · Raton, NMMay 27, 1967 · N8163P · Destroyed NTSB DEN67D0206Accident · No injuriesClosedPiper PA-24 · Carrizozo, NMJan 14, 1967 · N7682P · Substantial damage NTSB DEN67F0091Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMAug 26, 1966 · N6101P · Substantial damage NTSB DEN67D0088Accident · No injuriesClosedPiper PA-24 · Taos, NMAug 24, 1966 · N7687P · Substantial damage NTSB DEN66F0228Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMFeb 21, 1966 · N6953P · Substantial damage NTSB DEN66F0171Accident · No injuriesClosedPiper PA-24 · Las Cruces, NMNov 16, 1965 · N6263P · Substantial damage NTSB DEN66D0049Accident · No injuriesClosedPiper PA-24 · Lucy, NMJul 23, 1965 · N8004P · Substantial damage NTSB DEN66D0039Accident · No injuriesClosedPiper PA-24 · Los Alamos, NMJun 16, 1965 · N5371P · Substantial damage NTSB DEN65D0046Accident · No injuriesClosedPiper PA-24 · Taos, NMMar 30, 1965 · N5209P · Substantial damage NTSB UNK65X0591Accident · No injuriesClosedPiper PA24 · Corona, NMNov 7, 1964 · N5985P · Substantial damage NTSB UNK65X0439Accident · Serious injuriesClosedPiper PA-24 · Albuquerque, NMOct 25, 1964 · N5139P · Substantial damage NTSB UNK65X0129Accident · No injuriesClosedPiper PA24 · Columbus, NMOct 3, 1964 · N5243P · Substantial damage NTSB UNK64X3506Accident · No injuriesClosedPiper PA24 · Socorro, NMAug 21, 1964 · N6160P · Substantial damage NTSB UNK64X2784Accident · 4 fatalClosedPiper PA24 · Tijeras, NMJul 12, 1964 · N8339P · Destroyed