Fatal NTSB investigations: Piper PA-24-250

7 cases on aircraft the registry lists as Piper PA-24-250, where the first occurrence was “In flight collision with terrain/water”. 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

19862026
Fatal NTSB investigations: Piper PA-24-250 per year, 1986–2026: 7 cases
19861
19881
19901
19931
19951
19961
20011

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 ('7102404')
      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\" = 230))
  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 IAD01FA039Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Paris, VApilot's continued visual flight into instrument meteorological conditions.Mar 31, 2001 · N5841P · Substantial damageNTSB ATL97FA014Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Avon Park, FLThe pilot's improper use of the elevator trim, which resulted in runway contact by the propeller during the takeoff roll and subsequent loss of aircraft control.Oct 31, 1996 · N8353P · Substantial damageNTSB LAX96FA249Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Death Valley, CAthe non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions.Dec 23, 1995 · N7304P · DestroyedNTSB FTW94FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Longview, TXPoor judgment of the pilot due to impairment from consumption of alcohol and use of a drug (marijuana), and his failure to correct a descent, while maneuvering at low altitude. A factor related to the accident was: the pilot's psychological condition.Nov 10, 1993 · N6651P · DestroyedNTSB ATL91FA015Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Rock Hill, SCThe pilot misjudged the aircraft's altitude/clearance above the runway during a low pass and allowed the propeller to contact the runway; he then failed to maintain airspeed after a pull-up and allowed the aircraft to stall.Nov 6, 1990 · N7840P · DestroyedNTSB DEN89FA045Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elephant Butte, NMDuring a return flight from having maintenance performed on the acft the plt executed a low pass by his home which was located on a point of land overlooking Elephant Butte reservoir, NM. During the maneuver while in a steep turn the left wing struck the…Dec 21, 1988 · N751SP · DestroyedNTSB DEN87FA046Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Leyba, NMThe plt departed albuquerque on October 29, 1986, in his acft for an unknown destination. When he failed to return to his home, relatives notified local authorities. A search was begun and on January 23, 1987, the wreckage was found. The pilot was deceased…Oct 29, 1986 · N8323P · Substantial damage