NTSB investigations: Piper PA-28R-201, NM
7 cases on aircraft the registry lists as Piper PA-28R-201. 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
| 1978 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 2014 | 1 |
| 2018 | 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 ('7102816', '7102833'))
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 ('7102816', '7102833'))
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 CEN19CA017Accident · No injuriesData collectionFinal reportPiper PA28R · Hobbs, NMThe pilot's incorrect altimeter setting during the night visual approach, which resulted in a controlled flight into terrain.NTSB CEN14CA164Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Ruidoso, NMThe pilot's failure to adjust the engine's fuel-air mixture and decision to takeoff in high density attitude conditions which degraded the airplane's performance.NTSB DEN88LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lordsburg, NMFollowing takeoff the acft lost power at 150-200 ft AGL. Plt landed in rough terrain. During landing the left wing and landing gear separated. Examination revealed a failed exhaust valve guide and soft valve springs due to blow-by heat. At the time of the…NTSB DEN85LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Angle Fire, NMThe plt stated that shortly after takeoff from the 6700 ft long rwy with a density alt of 10400 ft, turbulence was experienced and the airspeed decreased to aprx 70 KTS. Unable to maintain alt, a forced landing was attempted during which the acft contacted a…NTSB DEN84LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Los Alamos, NMThe attempted downwind takeoff was aborted but resulted in an overrun off the end of the rwy. According to the PIC the airspeed indicator was inoperative and the brakes were well worn prior to departure. With about 1000 ft of rwy remaining the abort was…NTSB DEN78FQA46Accident · Serious injuriesClosedPiper PA-32 · Canjilon, NMNTSB DEN78FQA50Accident · No injuriesClosedPiper PA-28R · Santa Rosa, NM