NTSB investigations: Piper PA-28-140, 2019

10 cases on aircraft the registry lists as Piper PA-28-140, 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
NTSB investigations: Piper PA-28-140, 2019 per year, 2008–2026: 135 cases
20086
20094
20106
20116
201212
201310
20148
201515
20169
20178
201816
201910
20204
20214
20224
20235
20245
20252
20261

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 year(c.\"eventDate\") = 2019
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102802')
      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 GAA19CA512Accident · No injuriesData collectionFinal reportPiper PA28 · Chickasha, OKThe student pilot's failure to maintain crosswind correction during landing and his subsequent loss of directional control during the landing roll, which resulted in a runway excursion and impact with uneven terrain.Aug 12, 2019 · N5600U · Substantial damageNTSB CEN19LA252Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Miami, FLThe flight instructor's and student pilot's inadequate preflight inspection of the fuel system for water contamination, which resulted in a loss of engine power during takeoff and subsequent forced landing.Aug 5, 2019 · N5915U · Substantial damageNTSB GAA19CA430Accident · No injuriesData collectionFinal reportPiper PA28 · Wasilla, AKThe pilot's improper landing flare, which resulted in an aerodynamic stall and subsequent hard landing, runway excursion, and collision with a sign.Jul 10, 2019 · N4245J · Substantial damageNTSB GAA19CA404Accident · No injuriesData collectionFinal reportPiper PA28 · SaipanThe pilot's failure to maintain directional control while exiting the runway, which resulted in a runway excursion and collision with taxiway lighting and runway signage.Jul 10, 2019 · N6733F · Substantial damageNTSB GAA19CA350Accident · No injuriesData collectionFinal reportPiper PA28 · Nowdoinham, METhe flight instructor's delayed decision to abort the takeoff from a wet, grass runway with insufficient runway remaining, which resulted in a runway overrun and the airplane going down an embankment.Jun 7, 2019 · N7227F · Substantial damageNTSB GAA19CA272Accident · No injuriesData collectionFinal reportPiper PA28 · Maitland, FLThe pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.May 16, 2019 · N6753W · Substantial damageNTSB ERA19FA164Accident · 1 fatalField investigationFinal reportPiper PA28 · Foley, ALA partial loss of engine power due to a stuck exhaust valve and the flight instructor's exceedance of the airplane's critical angle of attack following the loss of power, which resulted in an aerodynamic stall at low altitude.May 6, 2019 · N5542U · DestroyedNTSB ERA19CA289Accident · No injuriesData collectionFinal reportPiper PA28 · Winder, GAThe student pilot’s loss of airplane control, the flight instructor's delayed remedial action, and the student's delay in relinquishing the flight controls, which resulted in the airplane striking a runway sign during a go-around.Mar 28, 2019 · N6412W · Substantial damageNTSB GAA19CA131Accident · No injuriesData collectionFinal reportPiper PA28 · Williamsburg, VAThe pilot's excessive brake application during the landing roll, which resulted in a runway excursion and collision with a drainage culvert.Jan 26, 2019 · N6166W · Substantial damageNTSB WPR19LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Salt Lake City, UTA partial loss of engine power due to the mechanic’s failure to properly secure the throttle lever locking nut and cotter pin.Jan 15, 2019 · N1697J · Substantial damage