NTSB investigations, WI
69 cases where NTSB found Object/animal/substance.
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 7 |
| 2015 | 6 |
| 2016 | 6 |
| 2017 | 6 |
| 2018 | 10 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 1 |
| 2026 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '030220'))
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", '030220')) 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 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 CEN26LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Grantsburg, WIThe collision with a white-tail deer during the landing in dark night visual conditions.NTSB CEN24LA294Incident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Appleton, WIThe pilot’s failure to maintain adequate wingtip clearance while taxiing. Contributing to the accident was the ambiguous nonstandard parking at the time of the incident.NTSB CEN24LA275Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206B · Cuba City, WIThe pilot’s failure to maintain clearance from a wire during an agricultural application pass.NTSB CEN23LA272Accident · Serious injuriesClass 4 · LimitedFinal reportSix Chuter SR7 XL · Chetek, WIThe pilot’s failure to maintain aircraft control during initial climb which resulted in an impact with a pole, trees, and terrain.NTSB CEN22LA441Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Shell Lake, WIA collision with a deer during landing, which resulted in substantial damage to the left wing.NTSB CEN22LA221Accident · Serious injuriesClass 3 · LimitedFinal reportCameron Balloons Z-90 · Burlington, WIThe pilot’s selection of an inappropriate landing location and his failure to avoid an oncoming freight train, which resulted in the train colliding with and dragging the balloon.NTSB CEN22LA112Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Hortonville, WIThe loss of direction control while maneuvering off the plowed surface to avoid a collision with a vehicle.NTSB CEN21LA333Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Baraboo, WIThe pilot’s failure to maintain clearance from the fence while on final approach.NTSB CEN20LA436Accident · No injuriesClass 4 · LimitedFinal reportPiper J3 · Hartford, WIThe pilot’s loss of situation awareness which resulted in landing in a grass area and the subsequent collision with a runway marker.NTSB CEN20LA329Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA22 · Burlington, WIA partial loss of engine power due to the formation of carburetor ice while on the ground, which resulted in reduced climb capability and impact with trees during the initial climb.NTSB CEN20CA300Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dickeyville, WIThe pilot did not maintain clearance from wires during an aerial application flight.NTSB GAA19CA245Accident · No injuriesData collectionFinal reportErcoupe 415 C · Rosendale, WIThe pilot's selection of unsuitable terrain for an off-airport precautionary landing, which resulted in impact with a fence and a nose-over.NTSB CEN19TA075Accident · Minor injuriesFinal reportMBB BK117 · Strum, WIThe pilot's failure to maintain clearance from the fire truck.NTSB CEN19LA045Accident · Serious injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe pilot's failure to maintain proper alignment with the runway during final approach, which resulted in impact with a tree.NTSB GAA19CA074Accident · No injuriesData collectionFinal reportCirrus SR22 · Sand Creek, WIThe mechanic's failure to properly secure the air reference line, which resulted in a loss of engine power.NTSB GAA18CA546Accident · No injuriesData collectionFinal reportPiper PA28 · De Pere, WIThe pilot's improper decision not to abort the takeoff after the airplane encountered standing water on the runway, which decreased its speed and led to its subsequent inability to climb and resulted in a runway overrun.NTSB GAA18CA490Accident · Serious injuriesData collectionFinal reportCessna 172 · DePere, WIThe pilot’s failure to maintain lateral control and his subsequent failure to maintain the runway heading during an attempted go-around, which resulted in impact with trees.NTSB CEN18CA293Accident · Minor injuriesData collectionFinal reportJust JA30 Superstol · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during the initial climb and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN18CA291Accident · No injuriesData collectionFinal reportQuad City Challenger · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed during the base to final turn and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB GAA18CA432Accident · No injuriesData collectionFinal reportPiper PA28 · Oregon, WIThe pilot's improper decision to take off with a known brake malfunction, which resulted in a collision with a barn during landing on a wet runway.NTSB GAA18CA400Accident · No injuriesData collectionFinal reportChampion 8GCBC · Waunakee, WIThe pilot’s failure to maintain clearance from tall corn along the edge of the airstrip during takeoff.NTSB CEN18FA215Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 · Oshkosh, WIThe pilot's decision to fly over the river at a low altitude and his failure to maintain clearance with wires during low-level flight.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 GAA17CA523Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Redgranite, WIThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA491Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Westby, WIThe pilot's failure to see and avoid power lines while maneuvering at low altitude.NTSB GAA17CA420Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2008 · Lone Rock, WIThe student pilot’s improper landing flare, which resulted in a bounced landing and subsequent loss of directional control and runway excursion during the aborted landing. Contributing to the improper landing flare was the student’s distraction by a deer…NTSB GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.NTSB GAA17CA244Accident · No injuriesData collectionFinal reportBeech 99 · Waukesha, WIAn in-flight collision with a bird during the approach.NTSB CEN17LA090Accident · No injuriesLimited investigationFinal reportCessna 172B · Prairie Du Sac, WIThe pilot's decision to taxi the airplane from the roadway and his subsequent failure to maintain clearance from signs and a fence after a successful emergency landing following a total loss of engine power.NTSB GAA17CA070Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Stone Lake, WIThe pilot’s failure to maintain lateral control while in a hover and the helicopter’s subsequent impact with a tree.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 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 GAA16CA323Accident · Minor injuriesData collectionFinal reportMooney M20 · Reedsburg, WIThe pilot's long landing and failure to stop the airplane on the runway, resulting in an overrun, impact with a fence, and substantial damage to the airplane.NTSB CEN16LA097Accident · No injuriesLimited investigationFinal reportPiper PA 28-140 · Sturtevant, WIThe pilot's failure to maintain a proper glidepath during a landing at dusk, which resulted in impact with a moving ground vehicle. Contributing to the accident was the inoperative precision approach path indicator.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 CEN15CA348Accident · Minor injuriesData collectionFinal reportRobinson R44 · Kansasville, WIThe pilot's inability to see and avoid power lines that were low to the ground and a green color that blended with the background crops.NTSB GAA15CA177Accident · Minor injuriesData collectionFinal reportCentrair 101A · Hartford, WIThe glider pilot's failure to connect the elevator to the elevator control rod during the assembly process, resulting in a loss of control, and a collision with terrain during takeoff.NTSB CEN15LA242Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Superior, WIA stuck aileron due to a battery that had become jammed in the aileron bell crank.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 GAA15CA009Accident · No injuriesData collectionFinal reportBeech 76 · Juda, WIThe pilot's improper fuel planning, which resulted in fuel exhaustion, and a loss of engine power enroute.NTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.NTSB CEN14CA426Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Lancaster, WIThe pilot's inadequate monitoring of the environment and failure to maintain clearance from transmission wires during an aerial application flight.NTSB CEN14FA399Accident · 1 fatalField investigationFinal reportZimmerman Breezy · Oshkosh, WIThe pilot’s failure to maintain airplane control during landing while the air traffic controller was simultaneously coordinating the landing of three airplanes on the same runway, which resulted in the airplane exiting the runway and impacting a parked ground…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 CEN14CA291Accident · No injuriesData collectionFinal reportJabiru USA Sport J230-SP · Middleton, WIThe pilot's failure to maintain directional control during takeoff.NTSB CEN14CA257Accident · Minor injuriesData collectionFinal reportPiper PA 28R-200 · La Pointe, WIThe pilot's failure to maintain control of the airplane during the landing.NTSB CEN14CA132Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Hartford, WIThe pilot's inadequate preflight planning and failure to inspect the runway before departure.NTSB CEN13CA528Accident · Minor injuriesData collectionFinal reportBellanca 7ECA · Delavan, WIThe collision with a hawk during the takeoff roll, which resulted in a loss of directional control, runway excursion, and subsequent noseover.NTSB CEN13LA004Accident · No injuriesLimited investigationFinal reportBoeing 717-200 · Milwaukee, WIAn obstruction (a sleeve of cups) that lodged under the catering truck brake pedal, which prevented the driver from stopping the truck before it struck the parked airplane.