NTSB investigations: Piper PA-28-140, 2017

15 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
NTSB investigations: Piper PA-28-140, 2017 per year, 1964–2026: 3,857 cases
196435
1965102
1966177
1967263
1968182
1969227
1970220
1971230
1972189
1973183
1974169
1975141
1976129
1977123
1978118
197983
198066
198176
198263
198340
198448
198535
198640
198742
198846
198930
199045
199146
199230
199331
199445
199529
199625
199730
199827
199921
200030
200121
200224
200319
200417
200521
200620
200723
200816
200912
201016
20118
201217
201320
201415
201518
201616
201715
201821
201917
202016
202120
202217
202318
202413
20259
202612

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\") = 2017
    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 WPR18LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Odessa, FLA loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power.Nov 25, 2017 · N57351 · Substantial damageNTSB GAA18CA038Accident · Minor injuriesData collectionFinal reportPiper PA28 · Batavia, OHThe pilot’s failure to apply carburetor heat in conditions conducive to carburetor icing, which resulted in a partial loss of engine power during landing.Nov 5, 2017 · N98299 · Substantial damageNTSB WPR17FA215Accident · 1 fatalField investigationFinal reportPiper PA 28-140 · Brinnon, WAThe flight instructor's failure to completely and properly evaluate the student pilot's incorrectly- planned flight, and his failure to use all available resources to maintain situation awareness during the flight, which resulted in controlled flight into…Sep 30, 2017 · N9549W · DestroyedNTSB ERA17LA277Accident · Minor injuriesLimited investigationFinal reportPiper PA28 · Canton, GAMaintenance personnel's failure to ensure the proper throttle linkage travel clearance after the installation of an exhaust system.Aug 15, 2017 · N2804T · Substantial damageNTSB ERA17LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJThe student pilot's improper decision to conduct a night flight and his failure to maintain adequate altitude during the approach, which resulted in controlled flight into trees and terrain. Contributing to the accident was the student pilot's lack of total…Aug 6, 2017 · N56884 · Substantial damageNTSB WPR17LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Honolulu, HIA total loss of engine power during initial climb for reasons that could not be determined due to impact and fire damage.Jun 30, 2017 · N4244T · Substantial damageNTSB ERA17CA218Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Honesdale, PAThe pilot’s failure to maintain directional control during crosswind conditions.Jun 29, 2017 · N6977W · Substantial damageNTSB GAA17CA336Accident · No injuriesData collectionFinal reportPiper PA 28 · Auburn, INThe pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.Jun 8, 2017 · N4543R · Substantial damageNTSB GAA17CA322Accident · No injuriesData collectionFinal reportPiper PA28 · Gilbert, SCThe pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.May 27, 2017 · N5544J · Substantial damageNTSB CEN17LA341Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Ray, MIThe pilot's failure to maintain a proper approach speed, which resulted in in a hard landing and a runway excursion. Contributing to the accident was the pilot's decision to fly the airplane without an instructor onboard.May 27, 2017 · N5584U · Substantial damageNTSB CEN17LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Muskogee, OKThe pilot's improper in-flight fuel management, which resulted in a partial loss of engine power due to fuel starvation.May 13, 2017 · N3976K · Substantial damageNTSB WPR17LA092Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Whittier, CAThe pilot's impaired decision-making due to alcohol intoxication and his improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Apr 4, 2017 · N55339 · Substantial damageNTSB CEN17FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stonewall, TXThe pilot's failure to attain a proper touchdown point following a loss of engine power and his inability to stop the airplane on the short, soft runway. Contributing to the accident was the inadequate maintenance of the airplane by the owner and the mechanic…Mar 25, 2017 · N4329T · Substantial damageNTSB ERA17LA128Accident · No injuriesLimited investigationFinal reportPiper PA28 · Tampa, FLA collapsed engine induction duct, which resulted in restricted air flow to the engine and a subsequent loss of engine power. Contributing to the accident was the operator's failure to ensure that the correct induction duct was installed.Mar 12, 2017 · N8447R · Substantial damageNTSB GAA17CA157Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Weiser, IDThe student pilot’s failure to maintain directional control and to maintain clearance from a snow berm during the aborted landing.Feb 25, 2017 · N4404T · Substantial damage