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

9 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, MI per year, 1966–2026: 9 cases
19661
19671
19711
19731
19791
19911
19931
20201
20211

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\" = 'MI' 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 CEN21LA104Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA-24-250 · New Hudson, MIThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of an instrument rating and the low visibility at the time…Jan 2, 2021 · N8347P · DestroyedNTSB CEN20LA373Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA24 · Midland, MIThe loss of engine power due to fuel starvation.Sep 1, 2020 · N5939P · Substantial damageNTSB CHI93FA225Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elwell, MIImproper use of the fuel selector by the pilot, which resulted in fuel starvation.Jun 26, 1993 · N7779P · Substantial damageNTSB CHI92FA053Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Berrien Springs, MIThe pilot-in-command's (cfi's) poor in-flight planning/decision-making and misjudged fuel supply/consumption. A related factor is overconfidence in personal ability.Dec 11, 1991 · N6919P · DestroyedNTSB CHI80FAMS1Accident · 1 fatalClosedPiper PA-24 · Ganges, MIOct 10, 1979 · N8437P · DestroyedNTSB NYC73AN118Accident · 4 fatalClosedPiper PA-24 · Pontiac, MIMar 2, 1973 · N5910P · DestroyedNTSB CHI72AC043Accident · 1 fatalClosedPiper PA-24 · Ypsilanti, MINov 10, 1971 · N6861P · DestroyedNTSB CHI68A0047Accident · 3 fatalClosedPiper PA-24 · Davisburg, MINov 21, 1967 · N7165P · DestroyedNTSB CHI66A0097Accident · 4 fatalClosedPiper PA-24 · North Point, MIJun 8, 1966 · N6686P · Destroyed