NTSB investigations, WI
9 cases where the sequence of events included Part(s) separation from AC.
Cases per year
| 2012 | 1 |
|---|---|
| 2014 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2024 | 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\" = '338' 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" = '338' 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 CEN24LA330Accident · No injuriesClass 4 · LimitedFinal reportEsqual VM1 · Oshkosh, WIThe pilot’s premature rotation during takeoff which resulted in the airplane settling back to the runway and the subsequent separation of the left wheel.NTSB CEN22LA258Accident · No injuriesClass 3 · LimitedFinal reportEurocopter Deutschland EC 135 P2+ · Waukesha, WIThe separation and subsequent ingestion of the fenestron fairing cover into the fenestron blades for undetermined reasons.NTSB GAA19CA338Accident · No injuriesData collectionFinal reportPzl-Swidnik PW-5 · Independence, WIThe separation of the canopy from the glider during an off-airport landing for reasons that could not be determined.NTSB CEN17FA248Accident · 6 fatalField investigationFinal reportCessna 421C · Catawba, WIA loss of control and subsequent in-flight breakup for reasons that could not be determined based on the available information.NTSB CEN16FA290Accident · 1 fatalField investigationFinal reportFlight Design Ctls · Fond du Lac, WICarburetor contamination following exposure to water in the fuel, which resulted in a carburetor malfunction and a partial loss of engine power. Contributing to the accident was the pilot's loss of airplane control that resulted in a stall.NTSB CEN15LA399Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Hancock, WIThe in-flight failure of the left wing lower forward attach point under normal loading conditions due to corrosion and fatigue cracking in the center section hinge brackets. Contributing to the accident was the operator's inadequate maintenance and overweight…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 CEN14LA401Accident · No injuriesLimited investigationFinal reportMosquito XE · Oshkosh, WIThe failure of the retaining assembly on the tail rotor blade, which resulted in the separation of the blade and the subsequent loss of helicopter control.NTSB CEN12LA539Accident · Minor injuriesLimited investigationFinal reportGn-1 Aircamper Mathes · Burlington, WIThe pilot's improper installation of the propeller bolts, which resulted in the in-flight separation of the propeller.