Fatal NTSB investigations: Piper PA-28R-200, FL

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

19692026
Fatal NTSB investigations: Piper PA-28R-200, FL per year, 1969–2026: 10 cases
19691
19731
19751
19801
19922
19941
19991
20151
20171

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\" = 'FL' 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 ('7102811'))
  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 ERA17FA108Accident · 3 fatalField investigationFinal reportPiper PA28R · Cedar Key, FLThe non-instrument-rated pilot's improper decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of airplane control.Feb 12, 2017 · N4504X · DestroyedNTSB ERA15FA299Accident · 1 fatalField investigationFinal reportPiper PA-28R · Marathon, FLThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation while turning after takeoff in dark night conditions in a sparsely populated area, which resulted in the airplane’s descent into water. Contributing to the…Aug 10, 2015 · N54380 · DestroyedNTSB MIA99FA172Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Cape Canaveral, FLThe pilot's VFR flight into Instrument meteorological conditions and his subsequent failure to maintain control of the aircraft resulting in overload and separation of both wings. Contributing factors were the pilot's failure to obtain a preflight and…Jun 10, 1999 · N56192 · DestroyedNTSB MIA94FA098Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Sarasota, FLFailure of the pilot(s) to maintain control of the airplane due to spatial disorientation. Factors related to the accident were: A malfunction that resulted in a loss of normal radio transmission, and the pilot(s) lack of recent experience in this make and…Mar 21, 1994 · N55999 · DestroyedNTSB MIA93FA036Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Tarpon Springs, FLThe pilot's failure to maintain the minumum descent altitude (mda) while on a non-precision instrument approach. Factors which contributed to the accident were: the flight service station (fss) specialist's failure to provide the published notice to airmen…Dec 26, 1992 · N5343T · DestroyedNTSB MIA92FA183Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · New Hope, FLPoor in-flight planning and decision and failure of the pilot to maintain aircraft control.Sep 16, 1992 · N1083X · DestroyedNTSB MIA81FA010Accident · 3 fatalClosedPiper PA-28R · Jacksonville, FLOct 30, 1980 · N444JS · DestroyedNTSB MIA76AM040Accident · 3 fatalClosedPiper PA-28R · Lake Hamilton, FLNov 2, 1975 · N1191X · DestroyedNTSB MIA74AM034Accident · 2 fatalClosedPiper PA-28R · Fort Pierce, FLOct 18, 1973 · N15482 · Substantial damageNTSB MIA70A0020Accident · 2 fatalClosedPiper PA-28R · Lake City, FLSep 16, 1969 · N2991R · Destroyed