Fatal NTSB investigations: Piper PA-24-250, IN

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

19662026
Fatal NTSB investigations: Piper PA-24-250, IN per year, 1966–2026: 10 cases
19662
19672
19722
19771
19881
20101
20181

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.\"eventStateOrRegion\" = 'IN' AND c.\"eventCountry\" = 'USA'
    AND 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'))
  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 CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.Dec 13, 2018 · N6785P · DestroyedNTSB CEN10LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain control of the airplane. Contributing to the accident was the pilot’s decision to conduct the flight with known physiological impairment and his use of unapproved sedating medication, both of which likely impaired his ability…Apr 19, 2010 · N5425P · DestroyedNTSB CHI88DEX01Accident · 1 fatalFinal reportPiper PA-24-250 · Salem, INN6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway.Jan 5, 1988 · N6487P · DestroyedNTSB CHI78FA005Accident · 4 fatalClosedBeech P35 · Francesville, INOct 30, 1977 · N1555S · 2 aircraft · DestroyedNTSB CHI73AC012Accident · 3 fatalClosedPiper PA-24 · Nappanee, INAug 7, 1972 · N6378P · DestroyedNTSB CHI73AC004Accident · 4 fatalClosedPiper PA-24 · Kewanna, INJul 15, 1972 · N5491P · DestroyedNTSB CHI67A0136Accident · 3 fatalClosedPiper PA-24 · Madison, INJun 21, 1967 · N7895P · DestroyedNTSB CHI67A0124Accident · 4 fatalClosedPiper PA-24 · Covington, INMay 13, 1967 · N6536P · DestroyedNTSB CHI67A0032Accident · 3 fatalClosedPiper PA-24 · Fort Wayne, INSep 1, 1966 · N8115P · DestroyedNTSB CHI66A0083Accident · 3 fatalClosedPiper PA-24 · Seymour, INApr 5, 1966 · N7300P · Destroyed