Skip to content

NTSB investigations, WI

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

Where

Latest cases

Query with SQL

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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
  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.

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."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CHI02LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Sauk City, WIA loss of engine power due to a seized exhaust valve. A related factor was the mowed hay field.Aug 8, 2002 · N8910D · Substantial damage NTSB CHI01LA013Accident · No injuriesLimited investigationFinal reportRepublic RC-3 · Baraboo, WIthe failure of the number five intake valve spring during initial climbout and that there was no suitable terrain during the forced landing. A factor was the corn crop.Oct 12, 2000 · N6175K · Substantial damage NTSB CHI97LA011Accident · Serious injuriesLimited investigationFinal reportAero Commander 685 · Eden, WIa partial loss of engine power due to improper adjustment of the fuel pump by an unqualified person (pilot-in-command) and the pilot's inadequate preflight planning which resulted in his selection of unsuitable terrain for the attempted takeoff. The pilot's…Oct 19, 1996 · N58RG · Destroyed NTSB CHI96LA253Accident · No injuriesLimited investigationFinal reportYasecko LONG-EZE · Waukesha, WIFailure of the throttle cable.Jul 24, 1996 · N303Y · Substantial damage NTSB CHI96LA236Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Waupaca, WIinadequate maintenance of the throttle cable by maintenance personnel.Jul 10, 1996 · N2047S · Substantial damage NTSB CHI96LA006Accident · No injuriesLimited investigationFinal reportCessna 172F · Danbury, WIthe partial failure of the left magneto, the road sign, and the road embankment. A factor relating to this accident is the brush which obscured the road sign.Oct 11, 1995 · N8740U · Substantial damage NTSB CHI94LA156Accident · No injuriesLimited investigationFinal reportCessna 150F · Chippewa Falls, WIthe loss of engine power due to a binding carburetor heat door.May 12, 1994 · N6872F · Substantial damage NTSB CHI93LA205Accident · No injuriesLimited investigationFinal reportCessna 172P · Hartford, WIThe failure of the number four cylinder and unsuitable terrain.Jun 14, 1993 · N55404 · Substantial damage NTSB CHI91DEP11Accident · Serious injuriesFinal reportEnglish Pietenpol Aircamper · Brodhead, WIErosion of an exhaust valve.Jul 27, 1991 · N14961 · Substantial damage NTSB CHI90DEP07Accident · No injuriesFinal reportBell 47-G2 · Hatley, WIThe partial loss of power due to sticking intake valves.Jul 10, 1990 · N6768D · Substantial damage NTSB CHI90DEP05Accident · No injuriesFinal reportCirrus Klappmeier Cirrus VF-30 · Baraboo, WIManufacturer's inadequate equipment design to prevent a fuel leak which resulted in an in-flight fire. A factor related to the accident was the lack of an unsuitable forced landing area.Jun 14, 1990 · N888EK · Destroyed NTSB CHI89DEP02Accident · No injuriesFinal reportCessna 172M · West Bend, WIPartial failure of the throttle cable. Unsuitable (soft) terrain and transmission wires in the landing area were considered to be factors.Mar 27, 1989 · N9578V · Substantial damage NTSB CHI88LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Stanley, WIJan 3, 1988 · N863A · Substantial damage NTSB CHI88IA003Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Milwaukee, WIAircraft landed without further incident after exhaust centerbody fell away from the #1 engine during initial climb. The centerbody landed on private property with no property damage. A service bulletin issued by the manufacturer to inspect the centerbody and…Oct 5, 1987 · N157US · Minor damage NTSB CHI87LA211Accident · No injuriesLimited investigationFinal reportCessna 172K · Jefferson, WIThe aircraft was en route on a personal cross country flight when it experienced an engine failure and was forced to make an emergency landing in an alfalfa field. The aircraft landed long and collided with a telephone pole and fence at the end of the field.…Sep 12, 1987 · N84352 · Substantial damage NTSB CHI86FA174Accident · 2 fatalField investigationFinal reportCessna 172K · Random Lake, WIThe acft lost pwr on final apprch and crashed into a swamp. Post accident investigation revealed that the eng camshaft was worn reducing the pwr output of the powerplant.Jul 20, 1986 · N79069 · Destroyed NTSB DCA85AA036Accident · 31 fatalFinal reportDouglas DC-9-14 · Milwaukee, WIThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-87/01. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Drg…Sep 6, 1985 · N100ME · Destroyed NTSB CHI85LA297Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Iola, WIUpon takeoff at approximately 100 ft AGL the pilot experienced a partial power loss which necessitated a forced landing in a soft, wet potato field. The pilot had time to switch fuel tanks and magnetos prior to touchdown, but the power loss remained constant.…Jul 13, 1985 · N1487A · Substantial damage NTSB CHI84LA332Accident · No injuriesLimited investigationFinal reportArnold Forest Quickie 2 · Grantsburg, WIThe acft made one forced landing after engine trouble. The plt cleaned the fuel filters and took off for a test flt. The engine failed during takeoff. Post accident inspection of the engine showed it would run but the oil pressure was very low.Aug 5, 1984 · CGUER · Destroyed NTSB CHI84LA270Accident · No injuriesLimited investigationFinal reportHughes 500C/369HS · Arena, WIDuring an agricultural spraying operation the helicopter eng lost pwr. The plt attempted an autorotation. The acft rolled over on landing. The plt stated that he observed a loss of eng & rotor RPM, necessatating the autorotation. Inspection of the eng…Jun 30, 1984 · N377ST · Substantial damage NTSB CHI84LA210Accident · Minor injuriesLimited investigationFinal reportWagner Cuby WAG-A-BOND · Lyons, WIThe plt noticed '...a little power loss...' After takeoff at about 550 AGL. He turned downwind & flew a normal traffic pattern, but at a lower altitude. The acft stalled during the base turn. The plt stated that the loss of power was due to the mixture…May 27, 1984 · N34WA · Substantial damage NTSB CHI84FA022Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Dodgeville, WIMomentarily after lifting off, the plt heard a pronounced decrease in eng noise & noted that the tachometer indication had dropped to 1950 RPM. He elected to abort, but was unable to stop on the remaining rwy. After departing the rwy, the acft hit an object &…Oct 16, 1983 · N8419G · Destroyed NTSB CHI83FA370Accident · Minor injuriesField investigationFinal reportZenair Cricket MC12 · Oshkosh, WIDuring a formation takeoff, the plt was flying in a left wingman position & the flt entered a relatively steep climb. The plt stated that the airspeed was slightly above the stall speed at about 100 to 150 ft AGL when the left eng lost power & the acft began…Aug 5, 1983 · CGAYW · Substantial damage NTSB CHI83LA219Accident · No injuriesLimited investigationFinal reportPiper PA25 · Tomah, WIThe acft lost power and made a forced landing immediately after takeoff on an aerial application mission. The landing gear collapsed during the landing. The pilot stated that the accident occurred on the 5th flt of the day after taking off on runway 27 and…May 17, 1983 · N4521Y · Substantial damage