NTSB investigations, WI
10 cases where NTSB found Aircraft capability.
Cases per year
| 2012 | 2 |
|---|---|
| 2015 | 4 |
| 2016 | 2 |
| 2020 | 1 |
| 2025 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010610'))
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", '010610')) 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 CEN25LA344Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Markesan, WIThe pilot’s failure to attain a proper touchdown point which resulted in a long landing and subsequent runway overrun.NTSB CEN20LA125Accident · No injuriesClass 3 · LimitedFinal reportMitsubishi MU 2B-40 · Chilton, WIThe pilot's decision to land on the turf runway with insufficient landing performance and his subsequent loss of control during the landing roll.NTSB CEN16LA288Accident · No injuriesLimited investigationFinal reportCessna 208B · Baldwin, WIThe pilot's decision to land the fully loaded parachutist drop airplane on a wet grass runway that had insufficient length for the landing in high temperature conditions, which resulted in a runway overrun, when a more suitable longer runway was available at…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 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 CEN15LA345Accident · No injuriesLimited investigationFinal reportAir Tractor AT 401 · Nekoosa, WIThe pilot’s inadequate preflight planning, which resulted in his attempt to take off for the agricultural application flight with the airplane over its maximum gross weight in high-density altitude conditions and led to the airplane’s degraded climb…NTSB CEN15FA320Accident · 4 fatalField investigationFinal reportBeech M35 · Amery, WIThe pilot’s loss of airplane control while maneuvering with the airplane near its maximum gross weight, which resulted in the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall.NTSB CEN15FA119Accident · 1 fatalField investigationFinal reportCessna 182L · Owen, WIThe flight instructor's decision to initiate flight into forecasted icing conditions in an airplane that was not certified or equipped for flight into icing conditions, which resulted in significant structural ice accumulation to the extent that the airplane…NTSB CEN13CA042Accident · Minor injuriesData collectionFinal reportLuscombe 8E · West Bend, WIThe pilot‘s failure to maintain clearance from power lines at the end of the short runway, which resulted in an aborted takeoff and subsequent nose-over of the airplane.NTSB CEN13LA023Accident · Minor injuriesLimited investigationFinal reportBeech B90 · Sturtevant, WIThe pilot's decision to continue the landing after touching down long and on a wet runway that reduced the airplane’s braking capability, which resulted in an overrun.