NTSB investigations: Piper PA-28-161, FL

6 cases on aircraft the registry lists as Piper PA-28-161, where the sequence of events included Loss of control in flight. 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
NTSB investigations: Piper PA-28-161, FL per year, 2008–2026: 6 cases
20082
20131
20141
20182

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.\"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\" = '240' 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 GAA18CA479Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to avoid a bird during the landing flare, which resulted in an aerodynamic stall.Aug 9, 2018 · N487JK · Substantial damageNTSB GAA18CA204Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot’s failure to maintain a stabilized approach, which resulted in overcorrection with the rudder during the landing, loss of control, and a runway excursion.Mar 2, 2018 · N158ND · 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 ERA13CA307Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Okeechobee, FLThe student pilot’s failure to maintain directional control during a go-around.Jun 28, 2013 · N614FT · Substantial damageNTSB NYC08CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe student pilot's loss of directional control on landing. Contributing to the accident was the crosswind and wind gusts.Apr 7, 2008 · N9233X · Substantial damageNTSB 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