Fatal NTSB investigations: Piper PA-28-161

7 cases on aircraft the registry lists as Piper PA-28-161, where the sequence of events included Collision with terr/obj (non-CFIT). 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

20082026
Fatal NTSB investigations: Piper PA-28-161 per year, 2008–2026: 7 cases
20081
20132
20141
20161
20191
20241

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 ('7102803', '7102834')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
  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 ERA24FA300Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Palm Beach Gardens, FLA loss of engine power for reasons that could not be determined.Jul 10, 2024 · N81250 · Substantial damageNTSB ERA19FA116Accident · 1 fatalClass 2 · FieldFinal reportPiper PA28 · Fellsmere, FLThe student pilot's loss of control due to spatial disorientation following an encounter with instrument meteorological conditions shortly after takeoff. Contributing to the accident was the failure of both the pilot and the flight school to ensure that the…Mar 5, 2019 · N556PU · Substantial damageNTSB ERA17FA072Accident · 1 fatalField investigationFinal reportPiper PA28 · Middlebury, VTThe pilot's improper decision to return to the airport following a partial or complete loss of engine power during takeoff initial climb and his failure to maintain sufficient airspeed while maneuvering, which resulted in exceedance of the critical angle of…Dec 23, 2016 · N31202 · Substantial damageNTSB ERA14LA117Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Stuart, FLThe noninstrument-rated pilot’s continued flight into dark night, instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation and subsequent impact with water.Feb 8, 2014 · N2571U · DestroyedNTSB ERA14LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Elkmont, ALA stuck exhaust valve, which resulted in a total loss of engine power at low altitude. Contributing to the accident were the pilot’s decision to fly at a low altitude, which reduced his forced landing options when the loss of engine power occurred; and poor…Nov 30, 2013 · N8878E · DestroyedNTSB ERA13FA385Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Danville, VAThe student pilot's failure to maintain control and climb the airplane during a go-around maneuver. Contributing to the accident was the flight instructor's failure to provide adequate oversight of the student pilot by ensuring that the cockpit was free of…Aug 29, 2013 · N9089N · DestroyedNTSB NYC08FA148Accident · 1 fatalField investigationFinal reportPiper PA 28-161 · Venice, FLThe pilot's inflight loss of control for undetermined reasons.Mar 25, 2008 · N465TC · Substantial damage