Fatal NTSB investigations, WI

8 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.

Cases per year

19872026
Fatal NTSB investigations, WI per year, 1987–2026: 8 cases
19871
19921
19931
19961
20031
20043

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\" = 351)
  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 CHI05FA048Accident · 2 fatalField investigationFinal reportBeech S35 · Herman, WIThe installation of the improper cylinder base packing seals by maintenance personnel resulting in the loss of lubriation and subsequent failure of the number four connecting rod/bearing. A factor associated with the accident was the trees that the airplane…Dec 25, 2004 · N5631K · Substantial damageNTSB CHI04FA203Accident · 1 fatalField investigationFinal reportKnoepflein Lancair Legacy 2000 · Madison, WIA loss of engine power due to high engine temperatures which resulted in a failure of the number three piston, the pilot's continued operation of the airplane with known high temperature problems, the pilot's poor inflight planning, and the pilot's failure to…Aug 1, 2004 · N98SN · DestroyedNTSB CHI04LA128Accident · 1 fatalLimited investigationFinal reportNorth American P-51C · Hager City, WIThe improper installation of the camshaft drive gear assembly which resulted in the retaining nut backing off allowing the drive gear to move up the shaft. A factor associated with the accident was the low altitude at which the power loss occurred and the…May 29, 2004 · N61429 · Substantial damageNTSB CHI03LA201Accident · 2 fatalLimited investigationFinal reportMcIlraith Sea Rey · Tomah, WIThe loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed resulting in a stall/spin during the forced landing.Jul 5, 2003 · N216ST · DestroyedNTSB CHI96FA113Accident · 1 fatalField investigationFinal reportPiper PA-32 · Milwaukee, WIInadequate maintenance and inspection in that the Airworthiness Directive which applied to the fuel pump had not been complied with. A factor was the pilot was unable to reach land.Jan 17, 1996 · N3326Q · DestroyedNTSB CHI93FA158Accident · 1 fatalField investigationFinal reportBeech E-18S · Lone Rock, WIwas a pre-mature extension of the landing gear by the pilot which resulted in the inability of the pilot to maintain the minimum descent altitude. Factors related to the accident were the loose cylinder and loss of oil.May 4, 1993 · N80CB · DestroyedNTSB CHI92FA215Accident · 2 fatalField investigationFinal reportCessna P210N · Mineral Point, WIThe pilot's inadvertent stall and descent into terrain during a forced landing. Related factors are the manufacturer's undertorqued crankcase halves and inadequate surveillance, the pilot's delay in setting up the proper descent rate, and the altered aircraft…Jul 29, 1992 · N6503W · Substantial damageNTSB MKC87FA161Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Solon Springs, WIThe surviving pax rprtd that drg initial climb after takeoff, the eng suddenly stopped & did not respond to atmts of a restart. The plt turned back toward the arpt, but was unable to reach the rwy. The acft impacted large trees in a wooded area, then crashed…Aug 15, 1987 · N5831D · Destroyed