NTSB investigations, WI
26 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2021 | 1 |
| 2022 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '342' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN22LA141Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150M · Brodhead, WIA loss of engine power due to the fatigue fracture of the No. 1 cylinder’s rocker shaft bosses, which resulted in a forced landing into uneven terrain.NTSB CEN21LA213Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C23 · Merrill, WIThe loss of engine power due to tappet failure.NTSB CEN19LA071Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Beechwood, WIA partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18FA200Accident · 1 fatalField investigationFinal reportDe Havilland DH112 Venom · Sheboygan, WIThe airplane's encounter with wake turbulence from the lead airplane in the formation flight, which resulted in a compressor stall and the airplane's subsequent inability to climb.NTSB CEN18LA158Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · East Troy, WIA partial loss of engine power for reasons that could not be determined based on the available information, which resulted in impact with terrain and dynamic rollover during the subsequent attempted landing.NTSB CEN17FA197Accident · 2 fatalField investigationFinal reportAerotek Pitts S 2A · Sheboygan Falls, WIThe pilot's failure to maintain airplane control following a partial loss of engine power during a low-level aerobatic maneuver; the reason for the loss of engine power could not be determined during postaccident examination of the engine. Contributing to the…NTSB GAA17LA090Accident · No injuriesLimited investigationFinal reportPiper PA28R · Watertown, WIThe pilot’s failure to attain a proper glidepath on approach for landing, which resulted in impact with trees. Contributing to the accident was a partial, temporary loss of engine power for reasons that could not be determined because postaccident examination…NTSB CEN17LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Wilmot, WIA failure of the No. 1 piston pin plug due to corrosion in the cylinder barrel, which resulted in oil contamination, oil starvation to the crankshaft connecting rod bearings, and a subsequent partial loss of engine power.NTSB CEN16LA302Accident · Serious injuriesLimited investigationFinal reportSonex Waiex · Fond du Lac, WIA partial loss of engine for reasons that could not be determined during an examination of the engine.NTSB CEN16FA290Accident · 1 fatalField investigationFinal reportFlight Design Ctls · Fond du Lac, WICarburetor contamination following exposure to water in the fuel, which resulted in a carburetor malfunction and a partial loss of engine power. Contributing to the accident was the pilot's loss of airplane control that resulted in a stall.NTSB CEN16LA273Accident · No injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe separated rocker arm assembly for undetermined reasons, which resulted in the partial loss of engine power and led to the landing gear collapsing during the subsequent forced landing.NTSB CEN16LA123Accident · Serious injuriesLimited investigationFinal reportBrockman William A Challenger II · Neshkoro, WIA total loss of engine power for reasons that could not be determined, as postaccident examination revealed no anomalies that would have precluded normal operation. Contributing to the accident was the non-certificated pilot's decision to maneuver at low…NTSB CEN15LA418Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Platteville, WIThe partial loss of right engine power for undetermined reasons with insufficient runway remaining for the aborted takeoff.NTSB CEN15LA413Accident · Minor injuriesLimited investigationFinal reportVenus CP328 Super Emeraude · Port Wing, WIThe pilot’s undershooting the landing area and the subsequent impact with a hay bale. Also causal to the accident was the operation of the airplane in conditions conducive to carburetor icing, which reduced the engine power during the landing.NTSB CEN15FA249Accident · 2 fatalField investigationFinal reportMonnett John T JR Sonex SA · Oshkosh, WIThe pilot's failure to maintain sufficient airspeed following a loss of engine power during initial takeoff climb, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the loss of…NTSB CEN15LA217Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Neillsville, WIA partial loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN14LA412Accident · Serious injuriesLimited investigationFinal reportEnstrom F 28F · Tomah, WIA loss of engine power due to the malfunction of the No. 4 cylinder intake valve.NTSB CEN14LA443Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Waukesha, WIThe loss of engine power for reasons that could not be determined because no anomalies were identified during postaccident examination.NTSB CEN13CA543Accident · Serious injuriesData collectionFinal reportTaylorcraft BL 65 · Chippewa Falls, WIThe loss of engine power after takeoff due to carburetor icing.NTSB CEN12LA661Accident · No injuriesLimited investigationFinal reportLake LA4 · Kenosha, WIThe loss of engine power for reasons that could not be determined because examination and test run of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA530Accident · Serious injuriesLimited investigationFinal reportWilliams John T-51 Mustang · Oshkosh, WIThe separation of an engine cooling hose from the radiator.NTSB CEN11LA429Accident · Minor injuriesLimited investigationFinal reportKeesler W8 Tailwind · Oshkosh, WIThe loss of engine power during initial climb for undetermined reasons.NTSB CEN10CA525Accident · Minor injuriesData collectionFinal reportWeber Acro Sport II · Plum City, WIThe pilot’s improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN09LA263Accident · 1 fatalLimited investigationFinal reportLaseure Sonerai II · Grantsburg, WIThe pilot's failure to maintain airspeed during initial climb which resulted in a stall/spin. Contributing to the accident was the degraded engine performance.NTSB CHI08LA230Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Tomahawk, WIA total loss of engine power due to a loss of all of the engine's oil as a result of the safety wire on the governor idler gear shaft's oil plug breaking, leading to the oil plug coming unscrewed. Contributing to the accident was the lack of a suitable area…NTSB CHI08FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Stevens Point, WIThe partial loss of engine power for undetermined reasons.