NTSB investigations, WI
8 cases where the sequence of events included Preflight or dispatch event.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 2 |
| 2015 | 1 |
| 2017 | 1 |
| 2022 | 2 |
| 2023 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '030' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '030' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN23LA104Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SF50 · Waukesha, WIThe pilot’s failure to maintain aircraft control during landing. Contributing to the accident was the pilot’s inadequate preflight inspection removal of the angle of attack vane cover.NTSB CEN22LA353Accident · Serious injuriesClass 3 · LimitedFinal reportSonex Sonex · River Falls, WIThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.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 CEN17FA287Accident · 2 fatalField investigationFinal reportAerofab Lake LA 4 250 · Oshkosh, WIThe pilot's failure to properly configure the airplane for takeoff and his decision to takeoff with a tailwind in unfavorable water conditions, which resulted in the airplane entering an aerodynamic stall and the pilot losing control.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 CEN11LA085Accident · Serious injuriesLimited investigationFinal reportEmbraer EMB-135LR · Milwaukee, WIAn in-flight encounter with turbulence during cruise flight, which resulted in a serious injury to a flight attendant.NTSB CEN10CA283Accident · No injuriesData collectionFinal reportCessna 182A · Franksville, WIThe pilot’s inadequate preflight inspection and delay in aborting the takeoff.NTSB CEN09CA477Accident · No injuriesData collectionFinal reportCessna A185F · River Falls, WIThe pilot not checking the security of the fuel caps prior to flight leading to fuel exhaustion and the subsequent non-mechanical loss of engine power during descent.