NTSB investigations, 2011, WA
12 cases where the sequence of events included Runway excursion.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 8 |
| 2010 | 6 |
| 2011 | 12 |
| 2012 | 9 |
| 2013 | 4 |
| 2014 | 11 |
| 2015 | 3 |
| 2016 | 9 |
| 2017 | 7 |
| 2018 | 9 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 3 |
| 2023 | 3 |
| 2025 | 4 |
| 2026 | 2 |
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\" = 'WA' 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") = 2011 AND c."eventStateOrRegion" = 'WA' 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 WPR12CA037Accident · No injuriesData collectionFinal reportCessna 180H · Snohomish, WAThe pilot's decision to land in a high, gusting, variable wind.NTSB WPR11CA408Accident · No injuriesData collectionFinal reportCessna 140 · Kent, WAThe student pilot's inadvertent application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB WPR11FA407Accident · No injuriesField investigationFinal reportCirrus Design SR22 · Fall City, WAThe pilot's inadequate approach planning and failure to achieve the proper touchdown point, which resulted in a runway overrun.NTSB WPR11LA371Accident · No injuriesLimited investigationFinal reportCarpenter Kolb Twinstar III · Republic, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR11CA345Accident · No injuriesData collectionFinal reportStinson 108-1 · Moses Lake, WAThe pilot's failure to maintain directional control during an aborted takeoff.NTSB WPR11CA343Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Colville, WAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.NTSB WPR11CA326Accident · Minor injuriesData collectionFinal reportMaule M-7-235C · Tonasket, WAThe pilot's failure to achieve the proper touchdown point, which resulted in a landing overrun.NTSB WPR11CA308Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Enumclaw, WAThe pilot's failure to maintain an adequate airspeed during an encounter with a mountain wave and downdraft landing.NTSB WPR11CA229Accident · No injuriesData collectionFinal reportRockwell International S-2R · Kahlotus, WAThe pilot's failure to maintain directional control during takeoff.NTSB WPR11CA194Accident · No injuriesData collectionFinal reportCessna 172R · Othello, WAThe pilot's failure to maintain directional during the landing roll.NTSB WPR11CA177Accident · No injuriesData collectionFinal reportCessna 172 · Republic, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR11FA159Accident · No injuriesField investigationFinal reportFairchild SA227-AC · Seattle, WAThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.