NTSB investigations: Piper PA-30, NM

10 cases on aircraft the registry lists as Piper PA-30. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

NTSB investigations: Piper PA-30, NM per year, 1965–2026: 10 cases
1965	2
1966	1
1968	1
1970	1
1977	2
1984	1
2011	1
2020	1

Where

Open the map

Latest cases

Query with SQL

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 ('7103002')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7103002'))
  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 ('7103002'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 WPR20LA223Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Vaughn, NMThe total loss of power in the right engine due to fuel starvation. Contributing to the accident was the pilot’s failure to follow the manufacturer-recommended procedure after the loss of power in the right engine.Jul 15, 2020 · N8488Y · Substantial damage NTSB CEN11LA262Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Ruidoso, NMThe left engine's intermittent loss of power during initial climb for undetermined reasons. Contributing to the accident was the high density altitude at the time of the accident.Apr 3, 2011 · N7849Y · Substantial damage NTSB DEN85FA043Accident · 3 fatalField investigationFinal reportPiper PA-30-160 · Albuquerque, NMThe flt was en route from forth worth, TX, to santa fe, new Mexico, when the plt decided to divert to Albuquerque. The a/c crashed while being vectored for an ILS approach to rwy 8. The plt received his instrument rating slightly more than 6 mos before the…Dec 15, 1984 · N7329Y · Destroyed NTSB DEN77FQA46Accident · Serious injuriesClosedPiper PA-30 · Albuquerque, NMJul 30, 1977 · N222GM · Substantial damage NTSB DEN77FQA44Accident · No injuriesClosedPiper PA-30 · Estancia, NMJul 12, 1977 · N8502Y · Substantial damage NTSB DEN70AQA19Accident · No injuriesClosedPiper PA-30 · Ruidoso, NMMay 8, 1970 · N7795Y · Substantial damage NTSB DEN69D0003Accident · No injuriesClosedPiper PA-30 · Roswell, NMJun 1, 1968 · N7897Y · Substantial damage NTSB DEN66D0324Accident · No injuriesClosedXpiper PA-30 · Albuquerque, NMJun 3, 1966 · N7485Y · Substantial damage NTSB DEN66D0153Accident · No injuriesClosedPiper PA-30 · Farmington, NMOct 1, 1965 · N7007Y · Substantial damage NTSB DEN65F0025Accident · No injuriesClosedPiper PA-30 · Alamogordo, NMFeb 20, 1965 · N7318Y · Substantial damage