NTSB investigations, 2016, WA
9 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\") = 2016
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") = 2016 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 WPR17LA037Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 24 · Anacortes, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and separation of the left main landing gear.NTSB GAA17CA011Accident · No injuriesData collectionFinal reportFuller Neil H Glasair SH 2 · Bellingham, WAThe pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.NTSB WPR16LA187Accident · No injuriesLimited investigationFinal reportJurcan Seawind 3000 · Renton, WAThe failure of the landing gear system to either fully retract or extend due to a cracked hydraulic fitting flare, which resulted in the loss of hydraulic pressure.NTSB GAA16CA485Accident · Minor injuriesData collectionFinal reportDormaier Monte R Baby Great Lakes · Mazama, WAThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.NTSB GAA16CA410Accident · No injuriesData collectionFinal reportAeronca 11AC · Gig Harbor, WAThe pilot's failure to maintain directional control during landing, and subsequent wing tip strike, which resulted in substantial damage to the rear spar.NTSB GAA16CA382Accident · Minor injuriesData collectionFinal reportGonzalez Manuel A RV 7 · Langley, WAThe pilot's decision to land with a tailwind, which resulted in, landing long, a runway overrun, and impact with a berm and nose over.NTSB GAA16CA345Accident · No injuriesData collectionFinal reportCessna 170 · Everett, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and substantial damage to the fuselage.NTSB GAA16CA281Accident · Minor injuriesData collectionFinal reportAmerican Champion 8KCAB · Black Diamond, WAThe pilot's abnormal runway contact during the landing flare, which resulted in a porpoise, aerodynamic stall, impact with terrain, and nose over.NTSB GAA16CA193Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Burlington, WAThe pilot's excessive application of the brakes during the landing roll, resulting in a loss of directional control, runway excursion, and ground loop.