NTSB investigations, 2016, WI
5 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 5 |
|---|---|
| 2010 | 3 |
| 2011 | 5 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 5 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 5 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 4 |
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\") = 2016
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\" = '300' 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") = 2016 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" = '300' 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 GAA16CA476Accident · No injuriesData collectionFinal reportLuscombe 8 · Juneau, WIThe pilot's failure to maintain directional control during the landing roll in gusting crosswind conditions, which resulted in a runway excursion. Contributing to the accident was the foot pad cover slipping off the right rudder pedal 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 CEN16LA274Accident · No injuriesLimited investigationFinal reportChance Vought F4U 5 · East Troy, WIA failure of the O-ring in the left brake master cylinder for reasons that could not be determined, which resulted in a loss of directional control during landing.NTSB GAA16CA323Accident · Minor injuriesData collectionFinal reportMooney M20 · Reedsburg, WIThe pilot's long landing and failure to stop the airplane on the runway, resulting in an overrun, impact with a fence, and substantial damage to the airplane.NTSB GAA16CA292Accident · No injuriesData collectionFinal reportAeronca 7BCM · Rochester, WIThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion, left main landing gear collapse, and a nose down. Contributing to the accident was the wind shift.