Fatal NTSB investigations, WI

20 cases where the first occurrence was “In flight collision with terrain/water”.

Cases per year

19822026
Fatal NTSB investigations, WI per year, 1982–2026: 20 cases
19821
19832
19841
19883
19891
19904
19931
19981
20001
20011
20031
20041
20052

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 c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
  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 CHI05LA237Accident · 1 fatalLimited investigationFinal reportKircher RV-8 · Menomonie, WIThe pilot's decision to perform an aerobatic roll during takeoff, the low altitude, and his failure to maintain clearance from the crops and terrain.Aug 21, 2005 · N505DF · DestroyedNTSB CHI05FA197Accident · 1 fatalField investigationFinal reportNorth American F-51D · Malone, WIThe pilot not maintaining aircraft control and clearance from terrain for undetermined reasons during a low level maneuver.Jul 26, 2005 · N6327T · DestroyedNTSB CHI04FA223Accident · 1 fatalField investigationFinal reportCessna 172L · Webster, WIThe high velocity impact with terrain for undetermined reasons.Aug 12, 2004 · N3599F · DestroyedNTSB CHI04FA045Accident · 2 fatalField investigationFinal reportMooney 20E · Webster, WIThe pilot's inadequate decision to conduct a low altitude flight maneuver without sufficient altitude to maintain clearance from the terrain. Low altitude flight and ostentatious display are contributing factors.Dec 20, 2003 · N1275X · DestroyedNTSB CHI01FA085Accident · 1 fatalField investigationFinal reportCessna 152 · Horicon, WIthe inadvertent stall/spin. Additional factors included the aerobatic manuevers, low altitude, and the procedures not followed.Feb 10, 2001 · N5085P · DestroyedNTSB CHI00FA057Accident · 1 fatalField investigationFinal reportBeech D-95A Travelair · Dunbar, WIthe pilot failed to maintain a proper glidepath and obstacle clearance during an instrument approach. Additional factors to the accident included the dark night, icing conditions, flight into known adverse weather, and conditions conducive to pilot fatigue.Jan 6, 2000 · N5918S · DestroyedNTSB CHI99LA007Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Superior, WIthe pilot not maintaining clearance with the terrain, and his improper decision to enter maneuvers too close to the terrain. Factors contributing to this accident were the aerobatic maneuvers, the trees and the berm.Oct 9, 1998 · N924TA · DestroyedNTSB CHI94FA048Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Antigo, WIthe failure of the pilot in command to maintain proper altitude.Dec 10, 1993 · N550BC · Substantial damageNTSB CHI90MA244Accident · 5 fatalMajor investigationFinal reportBell 206B · Elkhorn, WIImproper planning/decision by the pilot, and his failure to attain adequate altitude before flying over rising terrain at night. Factors related to the accident were: darkness, fog, haze, rising terrain, and the lack of visual cues that were available to the…Aug 27, 1990 · N16933 · DestroyedNTSB CHI90FA236Accident · 7 fatalField investigationFinal reportPiper PA-32R-300 · Watertown, WIInitiation of VFR flight into adverse weather and instrument meteorologial conditions. Factors which contributed to the accident were the adverse weather conditions and the pilot's self-induced pressure to maintain currency.Aug 19, 1990 · N4070Q · DestroyedNTSB CHI90FAMS3Accident · 2 fatalMissing aircraftFinal reportCessna 172M · Kewaunee, WIUndetermined.Aug 14, 1990 · N9529H · DestroyedNTSB CHI90FA065Accident · 1 fatalField investigationFinal reportCessna 402B · Appleton, WIThe pilot's decision to continue flight into known adverse weather conditions resulting in a windshear encounter with insufficient altitude for recovery. The existing adverse weather conditions were factors.Jan 17, 1990 · N87163 · DestroyedNTSB CHI90FA028Accident · 3 fatalField investigationFinal reportBeech A36 · Shell Lake, WIThe pilot-in-command's failure to perform a missed approach, his descending below the minimum descent altitude, and his failure to maintain proper altitude to avoid impact with the terrain. Contributing to the accident was the pilot-in-command's lack of total…Nov 14, 1989 · N1607W · DestroyedNTSB CHI88DEP12Accident · 1 fatalFinal reportPiper PA-36-300 · Pulaski, WIThe aircraft descended at a high rate of speed, 75 degrees nosedown, into the terrain. His widow stated that the pilot had left home at approximately 2100 CST on the accident night, in an inebriated condition. After a discussion about his drinking, he…Sep 14, 1988 · N57847 · DestroyedNTSB CHI88FA120Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Wautoma, WIPerformance of an aerobatic maneuver with insufficient altitude for recovery.May 31, 1988 · N28156 · DestroyedNTSB CHI88FA056Accident · 1 fatalField investigationFinal reportCessna 150M · Norwalk, WIThe pilot made several calls to the fss and obtained weather briefings for reported and forecast IFR conditions along his proposed route of flight. After departure from sparta, Wisconsin in weather described by witnesses to be below VMC, the aircraft impacted…Jan 31, 1988 · N9458U · DestroyedNTSB CHI85FA020Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Bruce, WIThe acft crashed into a heavily wooded area during a x-country personal flight. Witnesses observed the acft circle the lighted football field at atlanta, WI, at an altitude low enough that they feared the acft would hit trees in the vicinity. At this time the…Oct 20, 1984 · N2898D · DestroyedNTSB CHI84FAMS1Accident · 1 fatalMissing aircraftFinal reportMooney M20C · Near Green Bay, WIAfter a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…Nov 22, 1983 · N9232M · DestroyedNTSB CHI83FA371Accident · 1 fatalField investigationFinal reportSiai-Marchetti F.260C · Oshkosh, WIThe foreign registered plt had a statement of aerobatic competency by an FAA inspector which contained a min alt limitation of 300 ft AGL. While performing at an air show, he had planned to pull up in a half loop, make a half roll on top, enter a 2 turn spin…Aug 6, 1983 · IRAID · Substantial damageNTSB CHI82FA329Accident · 1 fatalField investigationFinal reportCessna 310Q · Near Woodruff, WIAt approximately 2050, the acft was cleared for a NDB approach to lakeland arpt. At 2100, the acft crashed into a heavily wooded area 8.5 mi nw of the arpt.Aug 30, 1982 · N7746Q · Destroyed