NTSB investigations: Piper PA-24, NM
14 cases on aircraft the registry lists as Piper PA-24. 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
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 3 |
| 1970 | 1 |
| 1972 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 2019 | 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 ('7102402'))
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 ('7102402'))
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 WPR20FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 24 · Angel Fire, NMThe airplane’s degraded performance due to high-density altitude and gusting wind conditions, which resulted in its inability to maintain altitude during the initial takeoff climb. Contributing to the accident was the pilot’s lack of experience with high…NTSB DEN89FA061Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Albuquerque, NMEngine stoppage from fuel starvation which resulted from the pilot's failure to select the fullest tank for takeoff. In addition the pilot attempted to return to the airport during the forced landing and inadvertently stalled the aircraft during the…NTSB DEN89FA010Accident · Serious injuriesField investigationFinal reportPiper PA-24-180 · Albuquerque, NMPlt-rated pax told plt, coronado arpt 'in sight'. Plt was suspicious because loran indicated arpt was 3 mi away but trusted former instrument student's judgment & landed at closed alameda arpt instead of coronado arpt. Coronado UNICOM had told plt 'multiple…NTSB DEN86LA221Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Albuquerque, NMThe plt rprtd the acft was refueled to capacity at longmont, CO. Full capacity should have provided at least 3.6 hrs of flying time at normal consumption. After refueling, the acft was flown 1.3 hrs to fowler, CO, where it remained parked for a week. The plt…NTSB DEN72FQA39Accident · No injuriesClosedPiper PA-24 · Alameda, NMNTSB DEN71DQD01Accident · No injuriesClosedPiper PA-24 · Rodeo, NMNTSB DEN70F0120Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNTSB DEN70F0011Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNTSB DEN69D0219Accident · No injuriesClosedPiper PA-24 · Hobbs, NMNTSB DEN69D0123Accident · No injuriesClosedPiper PA-24 · Columbus, NMNTSB DEN68D0115Accident · No injuriesClosedPiper PA-24 · Grady, NMNTSB DEN66F0220Accident · No injuriesClosedPiper PA-24 · Albuquerque, NMNTSB DEN66A0009Accident · 3 fatalClosedPiper PA-24 · Ruidoso, NMNTSB DEN66F0041Accident · No injuriesClosedPiper PA-24 · Artesia, NM