NTSB investigations, 2023, WI
6 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\") = 2023
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") = 2023 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 CEN23LA393Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Plover, WIThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB CEN23FA320Accident · Minor injuriesClass 3 · FieldFinal reportHeath V-Strut · Oshkosh, WIThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN23LA272Accident · Serious injuriesClass 4 · LimitedFinal reportSix Chuter SR7 XL · Chetek, WIThe pilot’s failure to maintain aircraft control during initial climb which resulted in an impact with a pole, trees, and terrain.NTSB CEN23FA239Accident · 2 fatalClass 3 · FieldFinal reportMooney M20R · Watertown, WIThe pilot’s loss of control due to spatial disorientation while operating in instrument meteorological conditions. Contributing to the accident was the pilot’s impairment from the prohibited substance; however, the extent of impairment could not be determined.NTSB CEN23LA236Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Stevens Point, WIThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with the runway.NTSB CEN23LA133Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Hilbert, WIThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.