Fatal NTSB investigations, 2015, WI

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19642026
Fatal NTSB investigations, 2015, WI per year, 1964–2026: 459 cases
19645
196512
19664
196710
196812
196913
19709
19718
197210
197311
197415
19757
197611
197712
197811
197915
19807
198111
19829
198313
198411
19855
19865
19879
19887
19898
199011
19919
199212
199310
19942
19957
19965
19976
199810
19995
20007
200113
20025
20035
200410
20056
20066
20075
200810
20094
20102
20118
20122
20132
20144
20157
20164
20176
20185
20192
20201
20217
20222
20235
20241
20251
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\") = 2015
    AND c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 CEN15LA399Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Hancock, WIThe in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…Aug 26, 2015 · N2005C · DestroyedNTSB CEN15FA328Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Milwaukee, WIThe pilot's improper pitch control during the landing, which resulted in the propeller striking the runway, and his failure to maintain adequate airspeed during the subsequent go-around, which resulted in the airplane exceeding its critical angle of attack…Jul 29, 2015 · N425KJ · DestroyedNTSB CEN15FA320Accident · 4 fatalField investigationFinal reportBeech M35 · Amery, WIThe pilot’s loss of airplane control while maneuvering with the airplane near its maximum gross weight, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.Jul 27, 2015 · N9CB · DestroyedNTSB CEN15FA315Accident · 2 fatalField investigationFinal reportSanford Zenith CH 601XL · Bristol, WIThe pilot’s failure to maintain airspeed and airplane control following a loss of engine power during cruise flight. Contributing to the accident was the installation of ignition system coils that were not engine-manufacturer replacement parts, which…Jul 25, 2015 · N9601 · Substantial damageNTSB CEN15FA249Accident · 2 fatalField investigationFinal reportMonnett John T JR Sonex SA · Oshkosh, WIThe pilot's failure to maintain sufficient airspeed following a loss of engine power during initial takeoff climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the loss of…Jun 2, 2015 · N123SX · Substantial damageNTSB CEN15LA195Accident · 1 fatalLimited investigationFinal reportQuad City Challenger - II · Chippewa Falls, WIThe pilot’s incapacitation due to a cardiovascular event, which resulted in a loss of control and subsequent impact with terrain.Apr 11, 2015 · N30796 · Substantial damageNTSB CEN15FA119Accident · 1 fatalField investigationFinal reportCessna 182L · Owen, WIThe flight instructor's decision to initiate flight into forecasted icing conditions in an airplane that was not certified or equipped for flight into icing conditions, which resulted in significant structural ice accumulation to the extent that the airplane…Jan 26, 2015 · N3181R · Substantial damage