NTSB investigations, WA
20 cases where the defining event was Runway excursion.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 2025 | 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 c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '300')
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 c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '300') 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 ANC25LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Snohomish, WAThe pilot’s decision to continue the landing attempt with insufficient runway remaining, which resulted in a runway overrun and collision with a fence.NTSB WPR23LA089Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-C55 · Yelm, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway over run. Contributing to the accident was a wet runway.NTSB WPR22LA194Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · East Sound, WAThe pilot's failure to attain a proper touchdown point which, resulted in a runway overrun and collision with trees.NTSB WPR22LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna T207 · Crane Island, WAThe pilot’s failure to obtain a proper touch down location on a wet grass runway, resulting in a runway overrun and impact with terrain.NTSB WPR22LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Laurier, WAThe flight instructor’s delayed remedial action to prevent the airplane from landing long which, resulted in a runway overrun and collision with terrain.NTSB GAA18CA078Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot’s decision to abort the takeoff following a touch-and-go landing with too little runway remaining, which resulted in a runway overrun.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 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 WPR14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Anacortes, WAThe pilot's improper application of brakes during the landing roll resulted in a runway excursion and nose over.NTSB WPR13CA309Accident · Minor injuriesData collectionFinal reportCessna 172S · Monroe, WAThe student pilot's failure to maintain directional control during the landing roll, and the flight instructor's delayed remedial action that resulted in a runway excursion.NTSB WPR12CA389Accident · Minor injuriesData collectionFinal reportCessna 182L · Metaline Falls, WAThe pilot’s inadequate compensation for a sudden wind shift during the landing roll, which resulted in a runway overrun.NTSB WPR12LA207Accident · No injuriesLimited investigationFinal reportMaule MX-7 · Roche Harbor, WAA damaged brake master cylinder piston rod, which resulted in a landing with the left brake applied. The damage was a result of normal parking brake operation.NTSB WPR12CA037Accident · No injuriesData collectionFinal reportCessna 180H · Snohomish, WAThe pilot's decision to land in a high, gusting, variable wind.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 WPR11CA343Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Colville, WAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.NTSB WPR11CA022Accident · Minor injuriesData collectionFinal reportRotherwick Glasair III · Colville, WAThe pilot's misjudged approach and failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB WPR10LA365Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Prescott, WAThe airplane’s inability to maintain a positive rate of climb after takeoff for undetermined reasons. Contributing to the accident was the pilot’s delayed reaction to initiate an emergency release of the spray mixture.NTSB WPR09CA363Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Metaline Falls, WAThe pilot’s failure, during the landing roll, to identify the end of the runway and stop the airplane within the space available.NTSB WPR09CA300Accident · No injuriesData collectionFinal reportNorth American/Victoria MNT LT AT-6A · Olympia, WAThe pilot's inadequate compensation for the crosswind gust and failure to maintain directional control while landing.NTSB SEA08LA164Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik SportStar · Arlington, WAThe pilot's failure to maintain directional control of the airplane during the takeoff roll in gusty conditions.