Fatal NTSB investigations, WI

17 cases where the first occurrence was “Airframe/component/system failure/malfunction”.

Cases per year

19822026
Fatal NTSB investigations, WI per year, 1982–2026: 17 cases
19821
19831
19842
19882
19891
19901
19912
19922
19931
19972
20011
20071

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\" = 130)
  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 CHI07MA160Accident · 6 fatalClass 1 · MajorFinal reportCessna 550 · Milwaukee, WIThe National Transportation Safety Board determines that the probable cause of this accident was the pilots’ mismanagement of an abnormal flight control situation through improper actions, including failing to control airspeed and to prioritize control of the…Jun 4, 2007 · N550BP · DestroyedNTSB CHI01FA180Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 · La Crosse, WIThe fatigue failure of the aircraft's left wing tip fuel tank rear attachment, while the aircraft was being maneuvered in a low approach, leading to the tank's in-flight separation and subsequent in-flight break up of the airplane and the aircraft's control…Jun 16, 2001 · N301FM · DestroyedNTSB CHI97FA248Accident · 1 fatalField investigationFinal reportValley Adventurers Adventurer 333 · Fond Du Lac, WIThe kit manufacturer's use of inadequate material in construction of the airplane, his inadequate application of quality controls resulting in the debonding of the horizontal stabilizer. Factors were the total loss of the horizontal stabilizer, the elevator,…Aug 5, 1997 · N323VA · DestroyedNTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.Aug 2, 1997 · N5516V · DestroyedNTSB CHI94FA001Accident · 1 fatalField investigationFinal reportBeech G35 · Webster, WIIn-flight breakup of the airplane for an undetermined reason.Oct 2, 1993 · N4421D · DestroyedNTSB CHI92FA223Accident · 2 fatalField investigationFinal reportEdra/Mcdermitt Seabird/Petrel · Oshkosh, WIInadequate quality control during the manufacturing process resulting in the in-flight structural failure of the tailboom.Aug 3, 1992 · N109SB · DestroyedNTSB CHI92FA066Accident · 1 fatalField investigationFinal reportPiper PA-31P · Mosinee, WIAn inflight fire with the cabin heater as the origin, and unsuitable terrain in which to make a forced landing. A factor related to the accident was the soft terrain.Jan 2, 1992 · N500BH · DestroyedNTSB CHI91DEP09Accident · 1 fatalFinal reportBowers Flybaby 1A · Stoughton, WIThe inadequate design by the manufacturer to provide for adequate protection from moisture accumulation in the form of drain holes. Contributing factors were the deterioration (wood rot) of the wing spar attach and the lack of inspection access.Jun 17, 1991 · N8084D · DestroyedNTSB CHI91DEP08Accident · 1 fatalFinal reportJack Thomas Pitts S-IT · Kenosha, WIImproper maintenance, by person or persons unknown, to the elevator control system which allowed a bolt attaching the elevator control rod to the pitch bellcrank to become disconnected during flight.Jun 16, 1991 · N83AM · DestroyedNTSB CHI90FA117Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · West Bend, WIInflight failure of the right wing strut-to-spar attachment fitting due to fatigue initiated by improper welding techniques involving inadequate post-weld cooling control.Apr 24, 1990 · N2976R · DestroyedNTSB CHI89DEP01Accident · 1 fatalFinal reportCessna T337G · Green Bay, WIThe pilot's loss of aircraft control, due to the loss of cockpit/instrument panel lighting for an undetermined reason, the inoperative penlight, and subsequent spatial disorientation of the pilot. Factors related to the accident were: darkness and the adverse…Jan 26, 1989 · N6CF · DestroyedNTSB CHI88FA248Accident · 2 fatalField investigationFinal reportCessna 210L · Monroe, WISep 30, 1988 · N5268V · DestroyedNTSB CHI88DEP13Accident · 1 fatalFinal reportHeibel AIR Command 532 · Cottage Grove, WIWhile in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.…Sep 21, 1988 · N7015C · DestroyedNTSB CHI84LA338Accident · 1 fatalLimited investigationFinal reportPiper PA-28-160 · Palmyra, WIWhile on a personal flt the eng and airframe began to vibrate severely. The plt closed the throttle and turned eastward to land in a mint field. As he approached the field he applied power to clear a row of small houses, but during this maneuver struck a…Aug 4, 1984 · N5086W · DestroyedNTSB CHI84FA226Accident · 1 fatalField investigationFinal reportHiller UH-12E · Merrimac, WIThe acft crashed and burned after an in-flt explosion at about 75 ft AGL as the acft approached to land. The acft had experienced electrical problems of overheating generators and irregular voltage outputs on 2 previous occasions. The pltwas told after some…Jun 10, 1984 · N93431 · DestroyedNTSB CHI83FA258Accident · 2 fatalField investigationFinal reportCessna T210L · Porter Township, WIBoth occupants were rated plts. The plt in the right front seat of the acft had applied for membership with the organization that owned the plane. He may have been receiving informal instruction in the operation of the acft. During flt, the acft was observed…Jun 15, 1983 · N732CD · DestroyedNTSB CHI82FA357Accident · 2 fatalField investigationFinal reportFlitecraft Senior Aero · Footville, WIThe home built aircraft was on a familiarization flight for the pilot in the right seat. One witness stated he saw the aircraft (at about 2000 ft AGL) enter a nose high (straight up) attitude followed by a nose low (straight down) attitude. A spin then…Sep 18, 1982 · N119P · Destroyed