NTSB investigations: Piper PA-28R-200, NM
13 cases on aircraft the registry lists as Piper PA-28R-200. 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
| 1976 | 1 |
|---|---|
| 1977 | 3 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1995 | 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 ('7102811'))
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 ('7102811'))
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 FTW95LA260Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Mimbres, NMInadequate preflight planning and the selection of unsuitable terrain for takeoff by the pilot-in-command.NTSB DEN89LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Angel Fire, NMThe pilot's failure to properly evaluate the existing weather conditions and the subsequent takeoff into adverse conditions which degraded the airplane's climb capability. The pilot performed an intentional gear up landing.NTSB DEN87LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lordsburg, NMWhile en route on a x-country flt, a severe eng vibration began. The plt reduced power & slowed the airspeed to reduce the severity of the vibration. Subsequently, he elected to make a wheels-up landing on rocky desert terrain. After landing, he discovered…NTSB DEN85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Los Almos, NMThe plt was making an apch to rwy 27 at the los alamos muni arpt in gusty x-wind conditions. The arpt was located atop a mesa & rwy 27 had a 1.5% uphill rwy gradient. The plt said he selected 2 notches (25 deg) of flaps. The winds were reported to be from 210…NTSB FTW82DA035Accident · Minor injuriesFinal reportPiper PA-28R-200 · Estancia, NMThe pilot stated he experienced an engine stoppage in flight and attempted to land on a dirt road. Both fuel tanks were found empty and a total of 3 to 4 ounces of fuel was drained from the aircraft fuel system.NTSB FTW81FQA39Accident · No injuriesClosedPiper PA-28R · Santa Fe, NMNTSB FTW81FQA07Accident · No injuriesClosedPiper PA-28R · Taos Pueblo, NMNTSB DEN80FQA02Accident · Minor injuriesClosedPiper PA-28R · Torreon, NMNTSB DEN79FA010Accident · 2 fatalClosedPiper PA-28R · Cimarron, NMNTSB DEN78FQD02Accident · 1 fatalClosedPiper PA-28R · Columbus, NMNTSB DEN77FQA39Accident · No injuriesClosedPiper PA-28R · Albuquerque, NMNTSB DEN77FQA29Accident · No injuriesClosedPiper PA-28R · Albuquerque, NMNTSB DEN76AD065Accident · 2 fatalClosedPiper PA-28R · Melrose, NM