NTSB investigations, 2011, WI
19 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 22 |
|---|---|
| 2009 | 12 |
| 2010 | 12 |
| 2011 | 19 |
| 2012 | 16 |
| 2013 | 10 |
| 2014 | 17 |
| 2015 | 20 |
| 2016 | 18 |
| 2017 | 13 |
| 2018 | 16 |
| 2019 | 4 |
| 2020 | 5 |
| 2021 | 3 |
| 2022 | 1 |
| 2023 | 6 |
| 2024 | 5 |
| 2025 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 2011
AND 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\" = '470' 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 year(c."eventDate") = 2011 AND 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" = '470' 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 CEN12FA080Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Bern, WIThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in a loss of control and subsequent impact with the terrain.NTSB CEN12LA074Accident · No injuriesLimited investigationFinal reportBeech S35 · Elkhart Lake, WIThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN11CA665Accident · No injuriesData collectionFinal reportEsselstyn Chuck RV-6 · Lyons, WIThe pilot's failure to obtain a proper touchdown point while landing, which resulted in a runway overrun.NTSB CEN11LA632Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18-150 · Long Lake, WIThe pilot's failure to complete the prelanding checklist, which resulted in the landing gear wheels not being retracted for the water landing.NTSB CEN11FA625Accident · 1 fatalField investigationFinal reportSocata TBM 700 · Mt. Pleasant, WIThe pilot’s failure to properly trim the airplane’s rudder during cruise flight, which resulted in a prolonged uncoordinated flight condition, unporting of the fuel tank feed line, and subsequent fuel starvation and engine power loss. Contributing to the…NTSB CEN11CA586Accident · Minor injuriesData collectionFinal reportCessna TU206G · Shawno, WIThe pilot's loss of control on final approach, while maneuvering to avoid birds.NTSB CEN11LA549Accident · No injuriesLimited investigationFinal reportAerosport Ikarus C42E · East Troy, WIThe flight instrctor's delayed remedial action during landing. Contributing to the accident was the student pilot’s loss of directional control when he became distracted with the open door.NTSB CEN11LA546Accident · 2 fatalLimited investigationFinal reportReinboldt Richard A Challenger II · Reedsburg, WIThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB CEN11LA536Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13 · Stoughton, WIThe pilot’s improper preflight planning and his failure to gain proper airspeed during takeoff from a grass airstrip resulting in a stall, the loss of control, and subsequent impact with the trees. Contributing to the accident was the pilot operating the…NTSB CEN11FA505Accident · 2 fatalField investigationFinal reportPiper J3L-65 · Van Dyne, WIThe pilot’s inability to maintain airplane control while maneuvering for reasons that could not be determined from the available evidence.NTSB CEN11LA522Accident · No injuriesLimited investigationFinal reportCessna 172B · Middleton, WIThe total loss of engine power during climb after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN11CA462Accident · No injuriesData collectionFinal reportMooney M20S · Washington Island, WIThe pilot's failure to maintain aircraft control during the landing and his delayed remedial action to abort the landing.NTSB CEN11FA433Accident · 1 fatalField investigationFinal reportKlemp Gregory J Challenger II · Neshkoro, WIThe total loss of engine power during the initial climb due to a cold seizure as a result of a broken fan V-belt. Contributing to the accident was the passenger's interference with the flight controls during the forced landing.NTSB CEN11CA453Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf 912 · Oconto, WIThe powered parachute pilot's decision to execute an in-flight full-flare which resulted in exceeding the angle of attack capabilities of the parachute wing, and subsequent inadvertent stall.NTSB CEN11LA429Accident · Minor injuriesLimited investigationFinal reportKeesler W8 Tailwind · Oshkosh, WIThe loss of engine power during initial climb for undetermined reasons.NTSB CEN11FA310Accident · 1 fatalField investigationFinal reportJurmu Stol CH701 · Pulaski, WIThe pilot did not maintain control of the airplane during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of recent flight experience.NTSB CEN11CA290Accident · No injuriesData collectionFinal reportCessna 182H · Park Falls, WIThe student pilot's failure to maintain aircraft control during an aborted landing.NTSB CEN11FA240Accident · 2 fatalField investigationFinal reportCessna 150D · Baraboo, WIThe student pilot’s inadequate preflight planning and his decision to continue the flight into instrument meteorological conditions, which resulted in a subsequent loss of airplane control.NTSB CEN11LA177Accident · Minor injuriesLimited investigationFinal reportPiper PA-16 · Lake Koshkonong, WIA loss of engine power for undetermined reasons during a low-altitude pass over a frozen lake.