NTSB investigations: Piper PA-25-235, NM
16 cases on aircraft the registry lists as Piper PA-25-235. 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1991 | 1 |
| 1996 | 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\" = '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 ('7102504'))
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 ('7102504'))
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 FTW96LA323Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Moriarity, NMloss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.NTSB DEN91LA088Accident · No injuriesLimited investigationFinal reportPiper PA-25C-235 · Las Cruces, NMPower loss due to fuel contamination. A factor was: pilot's inadequate airplane preflight.NTSB DEN85LA159Accident · No injuriesLimited investigationFinal reportPiper PA-25-235-B · Lovington, NMThe plt attempted to take off to the east from a 1000-foot mowed alfalfa field at a field elevation of 3700 ft MSL. The plt estimated the winds to be from the southeast at 8 mph. The density altitude was computed to be between 6578 and 6871 ft MSL. According…NTSB FTW82DA297Accident · No injuriesFinal reportPiper PA-25-235 · Santa Rosa, NMWhile landing, the aircraft swerved off the runway and received substantial damage. An investigation revealed that the right main wheel had come off the axle. A closer examination revealed that the retaining nut and the cotter pin, which holds the nut in…NTSB FTW81FQA40Accident · No injuriesClosedPiper PA-25 · Dexter, NMNTSB DEN79DQG07Accident · Minor injuriesClosedPiper PA-25 · Portales, NMNTSB DEN79FQD14Accident · Serious injuriesClosedPiper PA-25 · Deming, NMNTSB DEN79DQA10Accident · No injuriesClosedPiper PA-25 · Dexter, NMNTSB DEN77DQG03Accident · No injuriesClosedPiper PA-25 · Rogers, NMNTSB DEN76FQA03Accident · No injuriesClosedPiper PA-25 · Roswell, NMNTSB DEN72FQG38Accident · 1 fatalClosedPiper PA-25 · Clovis, NMNTSB DEN72DQG14Accident · No injuriesClosedPiper PA-25 · Clovis, NMNTSB DEN71DQG31Accident · No injuriesClosedPiper PA-25 · Clovis, NMNTSB DEN71DQA02Accident · No injuriesClosedPiper PA-25 · Raton, NMNTSB DEN67D0115Accident · No injuriesClosedPiper PA-25 · Carlsbad, NMNTSB UNK64X2944Accident · No injuriesClosedPiper PA25 · Gallup, NM