Fatal NTSB investigations: Piper PA-28R-200

5 cases on aircraft the registry lists as Piper PA-28R-200, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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

19832026
Fatal NTSB investigations: Piper PA-28R-200 per year, 1983–2026: 5 cases
19831
19881
19941
19961
20071

Latest 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.\"highestInjuryLevel\" = 'Fatal'
    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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351))
  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.

NTSB NYC08FA053Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Augusta, GAA loss of engine power due to the fatigue fracture of the number 2 cylinder attach studs, and the subsequent separation of the number 2 cylinder.Dec 5, 2007 · N43274 · Substantial damageNTSB IAD96FA055Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Wareham, MALoss of engine power due to bearing insert being destroyed by excess heat. A factor in this accident is the pilot's experience level.Mar 30, 1996 · N57012 · DestroyedNTSB LAX94FA308Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · San Luis Obispo, CAthe failure of the No. 4 cylinder connecting rod for undetermined reasons. The dark night lighting conditions, which hampered the ability of the pilots to detect the power lines, was a factor in this accident.Aug 7, 1994 · N6959J · DestroyedNTSB LAX89FA032Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Anaheim, CAFive minutes after departure and during normal cruise flight, the certified flight instructor noticed a prop overspeed. He immediately pulled back on the prop control to reduce engine r.p.m. and instructed the student, a private pilot, to divert to the…Nov 3, 1988 · N9467N · Substantial damageNTSB FTW83FA406Accident · 1 fatalField investigationFinal reportPiper PA 28R-200 · Copan, OKThe acft collided with an electric transmission line and burned during an emergency landing. The flt had been in progress only an hour when the plt lost his engine oil pressure and his engine failed. ATC gave him a heading to the nearest arpt but he could not…Aug 31, 1983 · N1292T · Destroyed