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

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, 2000 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\") = 2000
    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 NYC01WA037Accident · 1 fatalForeign investigationPiper PA-28-140 · Sherbrooke, CanadaNov 15, 2000 · N3DP · DestroyedNTSB IAD01FA013Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stuart, VAPilot's continued flight into known adverse weather conditions during cruise flight. Factors in the accident were the low ceiling, dark night, and the pilot's failure to obtain in-flight weather advisories.Nov 10, 2000 · N513FL · DestroyedNTSB LAX01LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Gorman, CAthe pilot's failure to maintain airspeed while maneuvering, which resulted in an inadvertent stall. A contributing factor was the pilot's use of impairing medications.Oct 30, 2000 · N16503 · Substantial damageNTSB CHI01FA024Accident · 1 fatalField investigationFinal reportPiper PA28-140 · Sparta, MIThe pilot's failure to maintain proper runway alignment on departure and his failure to maintain clearance from the trees. The pilot's attempted flight into known adverse weather, his lack of instrument experience, the fog, and the trees were contributing…Oct 25, 2000 · N98094 · DestroyedNTSB LAX00FA314Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Poway, CAThe pilot's intentional flight into known adverse weather.Aug 27, 2000 · N428FL · DestroyedNTSB IAD00FA053Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bealeton, VAthe flight instructor's improper pre-flight plan and decision to land and depart an airport with insufficient runway. A factor in the accident was the short grass runway with a 100-foot obstruction at the end.Jun 23, 2000 · N311SB · DestroyedNTSB CHI00FA090Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Dighton, KSthe inadvertent stall. Factors relating to this accident were the pilot's inadvertent flight into known adverse weather conditions, the icing conditions, and improper in-flight planning by the pilot.Mar 18, 2000 · N4494X · Destroyed