NTSB investigations, WA
11 cases where the defining event was Landing area overshoot.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2024 | 1 |
| 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 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\" = '380')
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" = '380') 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 WPR26LA272Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5A · Metaline Falls, WAThe pilot’s distracted attention on approach to landing on their failure to attain a proper touchdown point and his inability to stop the landing roll on the grass runway.,NTSB WPR24LA166Accident · No injuriesClass 4 · LimitedFinal reportThomas J Spencer RV-10 · Snohomish, WAThe pilot’s failure to attain a proper touchdown point during landing with a tailwind which resulted in a runway overrun.NTSB GAA18CA280Accident · Minor injuriesData collectionFinal reportCessna 172 · Nooksack, WAThe pilot’s improper approach in tailwind conditions, which resulted in long landing and subsequent runway overrun.NTSB GAA18CA042Accident · No injuriesData collectionFinal reportStinson SR 5E · Burlington, WAThe pilot’s unstabilized approach, which resulted in a hard, bounced landing and nose-over. Also causal to the accident was the pilot’s improper decision to land on a closed alternate grass landing area.NTSB WPR17LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Enumclaw, WAThe pilot's improper approach for landing, which resulted in the airplane landing long, and his delayed decision to go around with insufficient runway remaining, which resulted in collision with an airport perimeter fence.NTSB WPR15CA214Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Laurier, WAThe pilot's inadequate decision to continue the approach, which resulted in a long landing and insufficient runway remaining to stop the airplane before it departed the end of the runway.NTSB WPR14CA378Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Walla Walla, WAThe pilot's misjudged approach which resulted in overshooting the landing point and insufficient remaining landing surface.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 WPR09CA276Accident · No injuriesData collectionFinal reportCessna A185F · Wenatchee, WAThe pilot's misjudged approach and failure to attain the proper touchdown point.NTSB WPR09CA080Accident · No injuriesData collectionFinal reportTarantola RV6A · Onalaska, WAThe pilot's improper decision to land with a tailwind, which resulted in the runway overrun. Contributing to the accident was the tailwind.NTSB LAX08CA225Accident · No injuriesData collectionFinal reportCessna 182J · Metaline Falls, WAThe pilot's misjudged altitude and distance, which resulted in the airplane's failure to attain the proper touchdown point and a landing overrun. Contributing to the accident were trees and the short runway.