NTSB investigations, WA
30 cases where NTSB found Descent/approach/glide path.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 2 |
Where
Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062040'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062040')) 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 WPR24LA017Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Eastsound, WAThe pilot's unstable approach and improper configuration of the flaps during a go-around which resulted in an aerodynamic stall and subsequent impact with terrain.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 WPR22LA294Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · White Salmon, WAThe pilot’s failure to attain a proper touchdown point, and his delayed decision to go around which, resulted in a 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 WPR21LA296Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Chelan, WAThe pilot’s unstable approach to land in turbulent conditions, which resulted in a hard landing short of the runway and subsequent loss of directional control and collision with terrain.NTSB GAA20CA058Accident · No injuriesData collectionFinal reportLet L13 · Enumclaw, WAThe pilot's failure to maintain a proper glidepath, which resulted in a collision with trees.NTSB GAA20CA018Accident · Serious injuriesData collectionFinal reportFoxworthy Rick A Sonex · Langley, WAThe pilot's failure to maintain a proper approach path, which resulted in impact with a tree.NTSB GAA19CA034Accident · No injuriesData collectionFinal reportJust Just Aircraft (Highl · Monroe, WAThe pilot's improper engine modification and operation, which resulted in a total loss of engine power due to fuel starvation, and the pilot's failure to maintain an adequate approach path, which resulted in the airplane landing short of the runway.NTSB GAA18CA443Accident · No injuriesData collectionFinal reportJust JA30 Superstol · Chelan Falls, WAThe pilot's improper approach over a river, which resulted in a collision with a dock.NTSB GAA18CA384Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC41 · Chelan, WAThe pilot's improper approach, which resulted in the airplane landing long and a subsequent 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 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 WPR16LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Pullman, WAThe student pilot's improper landing approach, which resulted in a hard landing and the subsequent overstress failure of the nose landing gear.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 WPR14FA310Accident · 1 fatalField investigationFinal reportBell 206A · Wenatchee, WAThe pilot's failure to maintain a proper decent rate and path, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's impairment by a sedating medication.NTSB WPR13CA130Accident · No injuriesData collectionFinal reportCessna 152 · Kelso, WAThe student pilot's inadequate landing flare and lack of remedial actions, which resulted in a hard bounced landing.NTSB WPR12FA385Accident · Serious injuriesField investigationFinal reportEaston Searey · Friday Harbor, WAThe pilot’s inadequate glidepath and failure to maintain clearance from the transmission wire during a landing approach.NTSB WPR12LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chehalis, WAThe pilot did not correctly manage his glide profile during a simulated engine-out forced landing. Contributing to the accident was the pilot's decision not to add additional engine power, which resulted in a runway undershoot.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 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 WPR11LA076Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · College Place, WAThe pilot's failure to abort the landing when he lost sight of the runway due to sun glare, and his inadequate compensation for the crosswind.NTSB WPR11CA040Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Carnation, WAThe pilot's failure to attain the proper touchdown point during a practice off-airport landing.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 WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.NTSB WPR09CA126Accident · No injuriesData collectionFinal reportErcoupe 415-E · Camas, WAThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.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.NTSB LAX08CA176Accident · No injuriesData collectionFinal reportClarke Colin Glastar · Wenatchee, WAThe pilot's failure to initiate a timely go-around after the first bounce.