NTSB investigations, WI

12 cases where NTSB found Identification/recognition.

Cases per year

20102026
NTSB investigations, WI per year, 2010–2026: 12 cases
20102
20111
20182
20191
20201
20221
20231
20242
20251

Latest 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\", '02041510'))
  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.

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.Jun 18, 2025 · N932DB · Substantial damageNTSB 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.Sep 12, 2024 · N7878M · Substantial damageNTSB CEN24LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Middleton, WIThe student pilot’s failure to maintain directional control during the takeoff roll.Jan 4, 2024 · N3477E · Substantial damageNTSB CEN23FA369Accident · 1 fatalClass 3 · FieldFinal reportPiper J5A · Iola, WIThe pilot’s failure to maintain control of the airplane after landing on a grass taxiway with a tailwind, which resulted in a nose over.Aug 19, 2023 · N35417 · Substantial damageNTSB CEN23LA037Accident · Minor injuriesClass 3 · LimitedFinal reportFairchild SA227-AT · Pewaukee, WIThe flight crew’s failure to maintain adequate airspeed and their exceedance of the airplane’s critical angle of attack during the instrument approach, which resulted in an aerodynamic stall. Contributing to the accident was an undetermined anomaly in the…Nov 15, 2022 · N247DH · Substantial damageNTSB 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.Aug 30, 2020 · N88204 · Substantial damageNTSB 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.Oct 17, 2019 · N82308 · Substantial damageNTSB 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.Jun 9, 2018 · N529DW · Substantial damageNTSB CEN18LA121Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Blair, WIThe pilot’s failure to recognize and compensate for hazards during the external load operation, which led to a collision between a lineman (external load) and a powerline.Mar 7, 2018 · N499SL · No damageNTSB CEN11LA448Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Burlington, WIThe improper installation of the fuel selector indicator handle, which resulted in a total loss of engine power due to fuel starvation.Jun 29, 2011 · N2332V · Substantial damageNTSB 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.Sep 5, 2010 · N819WW · Substantial damageNTSB CEN10CA283Accident · No injuriesData collectionFinal reportCessna 182A · Franksville, WIThe pilot’s inadequate preflight inspection and delay in aborting the takeoff.Jun 2, 2010 · N4974D · Substantial damage