Fatal NTSB investigations: Piper PA-28-140, 2002

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

19642026
Fatal NTSB investigations: Piper PA-28-140, 2002 per year, 1964–2026: 508 cases
19641
19655
19662
196718
196821
196925
197027
197132
197223
197325
197426
197524
197613
197720
197810
197915
19803
19819
198213
19836
19843
19857
19869
19875
198814
19896
199010
19918
19924
199310
19945
19954
19967
19971
19987
19993
20007
20012
20027
20033
20044
20056
20064
20076
20083
20093
20102
20113
20123
20133
20141
20155
20162
20172
20182
20192
20202
20213
20223
20234
20243
20262

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\") = 2002
    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 ('7102802'))
  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 LAX03FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Phelan, CAthe student pilot's failure to maintain an adequate airspeed while maneuvering that lead to a stall spin and impact with flat desert terrain.Dec 4, 2002 · N15969 · Substantial damageNTSB MIA03FA016Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Climax, NCThe pilot's operation of the airplane at a low altitude during final approach that resulted in an in-flight collision with a tree, a witness reported pitch-up, and subsequent stall and in-flight collision with terrain.Nov 15, 2002 · N8162N · Substantial damageNTSB FTW03FA008Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Lakeview, ARthe pilot's failure to maintain clearance with the terrain while maneuvering.Oct 8, 2002 · N4344J · DestroyedNTSB ATL02FA175Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Milton, FLA sheared mixture cable which resulted in a loss of engine power.Sep 23, 2002 · N8828N · Substantial damageNTSB ATL02FA150Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Spartanburg, SCThe pilot's failure to maintain airspeed during the takeoff initial climb which resulted in an inadvertent stall and subsequent collision with an embankment.Aug 3, 2002 · N7362J · DestroyedNTSB LAX02FA234Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Kneeland, CAThe pilot's failure to maintain clearance with the trees while executing an instrument approach. Contributing factors were the clouds and obscuration weather conditions.Jul 23, 2002 · N8801N · DestroyedNTSB CHI02FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Niles, MIFlight into known adverse weather conditions by the pilot and the spatial disorientation of pilot. Contributing factors were the lack of certification by the pilot and the weather conditions.Mar 8, 2002 · N5246T · Destroyed