NTSB investigations, WI
16 cases where NTSB found Gusts.
Cases per year
| 2010 | 2 |
|---|---|
| 2012 | 3 |
| 2016 | 2 |
| 2017 | 2 |
| 2021 | 2 |
| 2023 | 1 |
| 2024 | 3 |
| 2026 | 1 |
Where
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\", '03034045'))
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", '03034045')) 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 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 CEN24LA322Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Chetek, WIThe pilot’s improper landing flare and hard landing.NTSB CEN24LA299Accident · No injuriesClass 4 · LimitedFinal reportCessna 177A · Palmyra, WIThe student pilot’s failure to maintain directional control during the landing with gusty wind conditions.NTSB CEN24LA231Accident · No injuriesClass 4 · LimitedFinal reportFoskett James J CH 750 Cruiser · East Troy, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB CEN23LA209Accident · No injuriesClass 4 · LimitedFinal reportKolb Firestar SS · Lodi, WIThe pilot’s failure to maintain control during takeoff.NTSB CEN21LA280Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Hayward, WIThe pilot's failure to maintain directional control during landing with gusting wind.NTSB CEN21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Delavan, WIThe pilot’s failure to maintain control of the airplane during the landing roll with gusting crosswinds, which resulted in his excessive brake input and a subsequent nose over.NTSB GAA18CA005Accident · No injuriesData collectionFinal reportCessna 172 · Black River Falls, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.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 GAA16CA476Accident · No injuriesData collectionFinal reportLuscombe 8 · Juneau, WIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion. Contributing to the accident was the foot pad cover slipping off the right rudder pedal during the landing roll.NTSB CEN16LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA 25-235 · Arlington, WIThe pilot’s failure to establish proper airspeed and angle-of-attack during takeoff with the airplane at its maximum gross weight in elevated density altitude and gusting tailwind conditions, which resulted in an aerodynamic stall.NTSB CEN12CA596Accident · No injuriesData collectionFinal reportArvold Jordon R CH 750 · Colfax, WIThe pilot did not maintain control of the airplane while landing with a gusty crosswind.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 CEN12LA573Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Belgium, WIThe pilot’s failure to maintain control of the helicopter while landing in gusting wind conditions, which resulted in a hard landing.NTSB CEN10CA371Accident · No injuriesData collectionFinal reportBrantly B-2B · East Troy, WIThe pilot's failure to maintain control during landing.NTSB CEN10CA158Accident · No injuriesData collectionFinal reportCessna 172M · Waupaca, WIThe student pilot's failure to maintain directional control while taking off in gusting winds.