NTSB investigations, WI
31 cases where NTSB found Attention/monitoring.
Cases per year
| 2008 | 3 |
|---|---|
| 2010 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 5 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 4 |
| 2023 | 1 |
| 2024 | 3 |
| 2025 | 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\", '020215'))
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", '020215')) 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 CEN26LA025Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Eau Claire, WIThe pilot’s failure to ensure that the landing gear was properly extended before landing. Contributing to the accident was the pilot’s unfamiliarity with the landing gear warning horn and failure to verify the gear was extended with the cockpit position…NTSB CEN25LA211Accident · No injuriesClass 4 · LimitedFinal reportCessna U206 · Falun, WIThe pilot experiencing the featureless terrain illusion during the approach which gave the perception that the airplane was at a higher altitude over the glassy water surface than it was, resulting in the airplane impacting the water.NTSB CEN25LA149Accident · Serious injuriesClass 3 · LimitedFinal reportPphu Ekolot KR-030 Topaz · Platteville, WIThe pilot’s failure to maintain clearance from terrain for reasons which could not be determined.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 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 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 CEN21LA349Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Randolph, WIThe pilot’s failure to maintain clearance from power lines during a low-level aerial application flight.NTSB CEN21LA336Accident · No injuriesClass 3 · LimitedFinal reportDriver RV-7 · Oshkosh, WIThe RV-8 pilot’s failure to account for the position of the RV-7 behind him during the landing roll in a staggered landing formation, which resulted in a ground collision of the two airplanes. Contributing to the accident was the self-induced pressure created…NTSB CEN21LA333Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Baraboo, WIThe pilot’s failure to maintain clearance from the fence while on final approach.NTSB CEN21LA452Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mineral Point, WIThe pilot’s failure to see and avoid a wire during an aerial application flight, resulting in a collision with the wire.NTSB CEN20CA300Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dickeyville, WIThe pilot did not maintain clearance from wires during an aerial application flight.NTSB CEN19IA234Incident · No injuriesClass 3 · IncidentFinal reportMooney M20J · Oshkosh, WIThe failure of both pilots to remain clear of the other while flying in formation.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 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 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 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 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 GAA16CA067Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 65 · New Lisbon, WIThe pilot's exceedance of the airplane's critical angle of attack, resulting in an inadvertent aerodynamic stall and impact with terrain.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 GAA15CA159Accident · No injuriesData collectionFinal reportVans RV-12 · Oshkosh, WIThe pilot's failure to monitor the airplane's glide path during the final approach, which resulted in a low approach path and impact with terrain.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 CEN12CA464Accident · Serious injuriesData collectionFinal reportBertram William J Bertram 2000 · Shiocton, WIThe pilot’s distraction with taking photographs, which resulted in his failure to maintain sufficient altitude to avoid the guy wire.NTSB CEN10IA447Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301 · Ripon, WIThe inability of either pilot to see the other airplane due to the blind spot created by their respective airplane's wings.NTSB CHI08LA272Accident · 1 fatalLimited investigationFinal reportSocata TB-20 Trinidad · Cassville, WIThe left seat pilot's failure to maintain control of the airplane during a go-around and the inadvertent in-flight opening of the cabin door for undetermined reasons. Contributing to the accident was the distraction of the door opening.NTSB CHI08LA211Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Mayville, WIThe pilot's failure to maintain clearance with the rotating rotor blades after he exited the helicopter after landing.NTSB CHI08CA202Accident · No injuriesData collectionFinal reportAB Sportine Aviacija Genesis 2 · Beloit, WIThe inadequate visual lookout by the driver of the golf cart and the air/ground communications not available to the golf cart driver during movement onto an active runway while the glider was landing.