NTSB investigations: Piper PA-28R-201T, NM
6 cases on aircraft the registry lists as Piper PA-28R-201T. 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
| 1980 | 1 |
|---|---|
| 1983 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 2007 | 1 |
| 2008 | 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 ('7102813'))
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 ('7102813'))
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 CEN09LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Santo Domingo Pueblo, NMA loss of engine power due a loss of oil pressure resulting in heat distress and mechanical failure of the engine. The reason for the loss of oil pressure was not determined.NTSB DEN07LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Taos, NMThe unsecured B-nut fitting to the fuel return line which allowed for fuel spillage, an engine fire, and fuel exhaustion that led to the engine's subsequent failure. a factor contributing to the accident was the pilot's intentional wheels up landing in rough,…NTSB FTW97LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Raton, NMfailure of the exhaust rocker arm retaining studs due to over torquing of the attachment bolts by maintenance personnel during installation. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93FA105Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Radium Springs, NMA total failure of the airplane's vacuum system. Factors which contributed to the accident were: the dark night, snow, the pilot's loss of aircraft control, and the pilot's lack of experience in flying in actual intrument meteorological conditions.NTSB FTW83LA411Accident · No injuriesLimited investigationFinal reportPiper PA28R-201T · Anton Chico, NMDuring flt, the plt heard a 'pop' noise which was followed by a loss of power. The fuel flow indicated zero & he was unable to start the eng. During a forced landing, the left wing hit a bush which caused the acft to swerve & the main gear to collapse. An…NTSB FTW80FA103Accident · 1 fatalClosedPiper PA-28R · Lovington, NM