Fatal NTSB investigations, 2011, 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, 2011, 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\") = 2011
    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 CEN12FA080Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bern, WIThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.Nov 24, 2011 · N203MK · Substantial damageNTSB CEN11FA625Accident · 1 fatalField investigationFinal reportSocata TBM 700 · Mt. Pleasant, WIThe pilot’s failure to properly trim the airplane’s rudder during cruise flight, which resulted in a prolonged uncoordinated flight condition, unporting of the fuel tank feed line, and subsequent fuel starvation and engine power loss. Contributing to the…Sep 5, 2011 · N850SY · Substantial damageNTSB CEN11LA546Accident · 2 fatalLimited investigationFinal reportReinboldt Richard A Challenger II · Reedsburg, WIThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.Aug 4, 2011 · N340BR · Substantial damageNTSB CEN11FA531Accident · 1 fatalField investigationFinal reportEdwards Douglas L SKY Ranger · Wautoma, WIThe pilot’s failure to maintain proper airspeed and attitude control of the airplane in the turn, which resulted in an aerodynamic stall.Aug 1, 2011 · N7501Y · Substantial damageNTSB CEN11FA505Accident · 2 fatalField investigationFinal reportPiper J3L-65 · Van Dyne, WIThe pilot’s inability to maintain airplane control while maneuvering for reasons that could not be determined from the available evidence.Jul 25, 2011 · N81BF · Substantial damageNTSB CEN11FA433Accident · 1 fatalField investigationFinal reportKlemp Gregory J Challenger II · Neshkoro, WIThe total loss of engine power during the initial climb due to a cold seizure as a result of a broken fan V-belt. Contributing to the accident was the passenger's interference with the flight controls during the forced landing.Jun 30, 2011 · N12911 · Substantial damageNTSB CEN11FA310Accident · 1 fatalField investigationFinal reportJurmu Stol CH701 · Pulaski, WIThe pilot did not maintain control of the airplane during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of recent flight experience.Apr 29, 2011 · N701MJ · Substantial damageNTSB CEN11FA240Accident · 2 fatalField investigationFinal reportCessna 150D · Baraboo, WIThe student pilot’s inadequate preflight planning and his decision to continue the flight into instrument meteorological conditions, which resulted in a subsequent loss of airplane control.Mar 20, 2011 · N4178U · Substantial damage