NTSB investigations, WI
68 cases where NTSB found Action.
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 3 |
| 2010 | 6 |
| 2011 | 5 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 5 |
| 2025 | 6 |
| 2026 | 3 |
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020410'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '020410')) 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 CEN26LA262Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Janesville, WIThe pilot’s failure to extend the landing gear before landing.NTSB CEN26LA125Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12IS · Appleton, WIThe pilot’s failure to maintain proper airspeed during landing and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with the runway. Contributing to the accident was the flight instructor’s delayed…NTSB CEN26LA121Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Antigo, WIThe pilot receiving instruction’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN26LA011Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Portage, WIThe student pilot’s failure to maintain proper airspeed and attitude for a short field landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN25LA404Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR20 · Watertown, WIThe flight instructor’s failure to maintain control of the airplane following the student pilot’s bounced landing. Contributing to the accident was the flight instructor’s delayed remedial action which resulted in diminished airplane performance during the…NTSB CEN25LA344Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Markesan, WIThe pilot’s failure to attain a proper touchdown point which resulted in a long landing and subsequent runway overrun.NTSB CEN25LA257Accident · Minor injuriesClass 4 · LimitedFinal reportVan's RV-6 · New Richmond, WIThe pilot’s failure to maintain proper airspeed and altitude during the approach which resulted in a runway overshoot and subsequent landing in a lake. Contributing to the accident was the pilot’s delayed remedial action to abort the landing.NTSB CEN25LA220Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Ashland, WIThe pilot’s failure to extend the landing gear before landing and his failure to conduct the before landing checklist.NTSB CEN25LA204Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Pembine, WIThe pilot’s improper flare during landing which resulted in a bounced landing.NTSB CEN24LA379Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Janesville, WIThe student pilot’s improper flare and the flight instructor’s delayed remedial action that resulted in a hard, bounced landing.NTSB CEN24LA356Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-12 · Cumberland, WIThe total loss of engine power due to carburetor icing and the pilot’s delayed use carburetor heat in weather conditions conducive to carburetor icing.NTSB CEN24LA286Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Radisson, WIThe non-certificated mechanic’s failure to properly tighten and torque the fuel system pressure test port cap, which resulted in a total loss of engine power, and a subsequent forced landing.NTSB CEN24LA288Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Ft. Atkinson, WIThe pilot’s failure to extend the landing gear before landing due to distractions and his failure to conduct the Before Landing checklist.NTSB CEN24LA097Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Kenosha, WIThe pilot’s failure to maintain control of the helicopter while landing.NTSB CEN24LA052Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Manitowoc, WIMaintenance personnel’s improper servicing of the magnetos, which resulted in their accelerated wear, failure, and the total loss of engine power.NTSB CEN23FA333Accident · 2 fatalClass 3 · FieldFinal reportRotorway 162F · Oshkosh, WIThe failure of the gyroplane pilot to see and avoid the helicopter while maneuvering in the traffic pattern. Contributing to the accident was the gyroplane pilot’s performance of a prohibited maneuver in the traffic pattern.NTSB CEN22LA346Accident · No injuriesClass 4 · LimitedFinal reportMeschler Gary R RV-4 · Oshkosh, WIThe failure of the pilot of N694V (RV-8) to maintain clearance from the preceding airplane, N79KM (RV-4), while taxiing for takeoff, which resulted in an on-ground collision.NTSB CEN22LA302Accident · Minor injuriesClass 4 · LimitedFinal reportPitts S1 · Sturgeon Bay, WIThe pilot’s failure to maintain airplane control during landing, which resulted in a runway excursion and nose over. Contributing to the accident was the pilot’s inadequate preflight inspection and the pilot’s lack of flight control system knowledge.NTSB CEN21LA474Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion H · Burlington, WIThe pilot’s failure to maintain aircraft control during landing with a gusting crosswind that resulted in an aerodynamic stall and a hard impact on the runway.NTSB CEN21LA407Accident · No injuriesClass 4 · LimitedFinal reportAeromot AMT-100 · Menomonie, WIThe pilot’s failure to extend the landing gear.NTSB CEN20CA275Accident · No injuriesClass 4 · Data collectionFinal reportCondor Condor · Freedom, WIThe pilot's failure to initiate a climb in a timely manner which resulted in contact with wires.NTSB CEN20FA008Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Green Bay, WIThe pilot’s low final approach path and his failure to see and avoid a truck traveling on a roadway, which resulted in a collision with the truck.NTSB CEN19LA290Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35 · Monroe, WIA total loss of engine power due to the failure of the Nos. 5 and 6 connecting rods from a lack of oil lubrication for reasons that could not be determined.NTSB CEN19LA188Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 560 · Janesville, WIThe passenger’s decision to unbuckle her restraints during an in-flight turbulence event, resulting in serious injury.NTSB GAA18CA171Accident · No injuriesData collectionFinal reportBeech 76 · Oshkosh, WIThe pilot’s failure to extend the landing gear and the flight instructor’s failure to ensure that the landing gear were extended during landing. Contributing to the accident were the pilot’s and the instructor’s improper use of checklist.NTSB CEN18LA038Accident · Serious injuriesLimited investigationFinal reportPiper / Laudeman J3C 65 · Palmyra, WIThe pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had…NTSB CEN17FA067Accident · 1 fatalField investigationFinal reportDemmer BD-4 · Brookfield, WIThe pilot's failure to abort the takeoff when he was not able to maintain directional control in the strong crosswind conditions.NTSB CEN16FA373Accident · 2 fatalField investigationFinal reportCessna 182 · Ephraim, WIThe pilot's improper decision to execute a maneuvering approach at low altitude during night conditions, which resulted in controlled flight into terrain.NTSB CEN16CA383Accident · Minor injuriesData collectionFinal reportMooney M20D · Brodhead, WIThe pilot's loss of airplane control during initial climb due to an excessively nose-high attitude. Contributing to the accident was the pilot's failure to properly set the elevator trim before takeoff in accordance with the Before Takeoff checklist.NTSB CEN16LA309Accident · No injuriesLimited investigationFinal reportCessna 172K · Neenah, WIA loss of engine power due to oil starvation, which resulted from the pilot, who was not a certified airframe and powerplant mechanic, removing the vacuum pump from the engine, and his misconception that he could operate the airplane without the pump.NTSB CEN15FA311Accident · Serious injuriesField investigationFinal reportPiper PA-46-310P · Oshkosh, WIThe pilot's failure to perform a go-around after receiving a modified landing clearance and his failure to maintain adequate airspeed while maneuvering to land, which resulted in the airplane exceeding its critical angle of attack in a steep bank and entering…NTSB CEN15LA351Accident · Minor injuriesLimited investigationFinal reportRoberts Bruce W Vans Aircraft RV 9A · Land O' Lakes, WIThe pilot’s failure to maintain a proper descent rate, which resulted in a hard landing.NTSB CEN14CA362Accident · No injuriesData collectionFinal reportAeronca 65CA · Pulaski, WIThe student pilot's improper flight control inputs resulting in a loss of control during the landing. Contributing to the accident was the flight instructor's delayed remedial action.NTSB CEN14LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Superior, WIThe failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.NTSB CEN13FA438Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Lake Michigan, WIAn encounter with wake turbulence, which resulted in the pilot’s loss of control of the airplane and its subsequent in-flight breakup. Contributing to the accident was the approach controller’s failure to issue a wake turbulence advisory to the pilot.NTSB CEN13LA395Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Plover, WIThe pilot’s failure to maintain proper engine rpm, which resulted in a high rate of descent and ground impact.NTSB CEN13FA351Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · La Pointe, WIThe pilot’s failure to maintain airplane control after deciding to go around after a gear-up landing, resulting in an aerodynamic stall.NTSB CEN13CA316Accident · No injuriesData collectionFinal reportSheldrick John H RV-6 · Brookfield, WIThe pilot's failure to maintain runway alignment and his failure to recognize that the airplane had drifted away from the runway prior to landing.NTSB CEN13LA330Accident · No injuriesLimited investigationFinal reportCessna TP206B · Sturgeon Bay, WIThe pilot’s improper reselection of the left fuel tank, which had an obstructed vent system and resulted in a total loss of engine power during the approach for landing.NTSB CEN13LA071Accident · Minor injuriesLimited investigationFinal reportScott Ironsides · East Troy, WIFailure of the steel weld fittings on the right main landing gear.NTSB CEN13LA023Accident · Minor injuriesLimited investigationFinal reportBeech B90 · Sturtevant, WIThe pilot's decision to continue the landing after touching down long and on a wet runway that reduced the airplane’s braking capability, which resulted in an overrun.NTSB CEN12CA590Accident · No injuriesData collectionFinal reportCessna 180J · Wausau, WIThe pilot's loss of control during landing roll out, resulting in a runway excursion. Contributing to the accident was an unexpected crosswind wind gust.NTSB CEN12LA507Accident · No injuriesLimited investigationFinal reportCessna 150M · Cottage Grove, WIThe pilot's decision to land on a runway with significant overgrown vegetation along the edges and his landing, which was left of the centerline.NTSB CEN12CA406Accident · No injuriesData collectionFinal reportPiper PA-24 · Watertown, WIThe pilot’s failure to extend the landing gear before landing.NTSB CEN12LA248Accident · Minor injuriesLimited investigationFinal reportAerostar International Raven S49A · Janesville, WIThe pilot’s failure to maintain clearance from the powerlines while landing.NTSB CEN12LA182Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · East Troy, WIThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN12LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Denmark, WIThe pilot’s loss of control due to his alcohol impairment. Contributing to the accident was the pilot's decision to fly at night with a known interior lighting malfunction.NTSB CEN12LA129Accident · Minor injuriesLimited investigationFinal reportAviat A-1C-180 · Chetek, WIThe passenger’s interference with the flight controls, which resulted in the airplane’s failure to climb after an aborted landing. Contributing was the pilot's failure to maintain directional control during landing roll, which resulted in the need to abort…NTSB CEN11CA665Accident · No injuriesData collectionFinal reportEsselstyn Chuck RV-6 · Lyons, WIThe pilot's failure to obtain a proper touchdown point while landing, which resulted in a runway overrun.NTSB CEN11LA549Accident · No injuriesLimited investigationFinal reportAerosport Ikarus C42E · East Troy, WIThe flight instrctor's delayed remedial action during landing. Contributing to the accident was the student pilot’s loss of directional control when he became distracted with the open door.