NTSB investigations, WA
27 cases where NTSB found Mountainous/hilly terrain.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 2 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
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\", '03021010'))
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", '03021010')) 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 WPR24FA298Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75L3 · Yacolt, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at a low altitude in mountainous terrain in moderately high density altitude conditions, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB WPR24FA001Accident · 1 fatalClass 3 · FieldFinal reportCubcrafters CCK-1865 · Twisp, WAThe pilot’s failure to see and avoid a rock during an aborted landing on a hillside, the collision with which resulted in damage to the aileron system that precluded subsequent control of the airplane.NTSB WPR22LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lyman, WAThe pilot’s delayed decision to exit the valley with rising terrain and failure to maintain clearance from trees.NTSB WPR21LA332Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wenatchee, WAThe student pilot’s inadequate inflight navigation and the flight instructors delayed remedial action which resulted in a collision with trees.NTSB WPR21LA251Accident · Serious injuriesClass 4 · LimitedFinal reportStinson 108-3 · Stevenson, WAA runway incursion, which resulted in a go-around, and subsequent forced landing when the airplane was not able to climb at a rate sufficient to clear approaching rising terrain.NTSB WPR20CA218Accident · No injuriesClass 4 · Data collectionFinal reportRans S6 · Richland, WAThe pilot's inability to arrest a descent rate or maintain altitude after encountering a downdraft while maneuvering at low altitude near mountainous terrain that resulted in a hard landing.NTSB WPR20CA125Accident · Minor injuriesData collectionFinal reportCessna 172 · Yakima, WAThe pilot's failure to attain sufficient altitude during a go-around, which resulted in impact with hilly terrain.NTSB GAA18CA248Accident · Minor injuriesData collectionFinal reportCessna 172 · Port Angeles, WAThe pilot’s exceedance of the airplane’s critical angle of attack during a turn away from terrain, which resulted in an accelerated stall. Contributing to the accident was the pilot’s decision to delay the turn to avoid terrain.NTSB WPR17FA139Accident · 2 fatalField investigationFinal reportNorth Wing Uum Sport X2 912 · Chelan, WAThe flight instructor's failure to maintain control of the aircraft while demonstrating a spiral dive, which resulted in a loss of control. Contributing to the accident was the instructor's decision to demonstrate a spiral dive maneuver at an altitude that…NTSB WPR17LA084Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Brinnon, WAThe flight instructor's decision to fly into a valley without ensuring adequate clearance to avoid the rising terrain.NTSB WPR16LA142Accident · No injuriesLimited investigationFinal reportBell UH 1H · Mt. Adams, WAThe pilot’s failure to maintain yaw control as he slowed the helicopter during a landing approach, which resulted in the loss of helicopter control due to the loss of tail rotor effectiveness.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 WPR15FA241Accident · 2 fatalField investigationFinal reportCessna T182T · Oroville, WAThe pilot’s failure to maintain terrain clearance while maneuvering. Contributing to the accident was the pilots’ selection, for undetermined reasons, of a route different than the most commonly used route.NTSB WPR15LA219Accident · Minor injuriesLimited investigationFinal reportGarlick UH1H · Walla Walla, WAThe helicopter’s reduction in aerodynamic lift while operating in variable wind conditions for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have…NTSB WPR15FA215Accident · 2 fatalField investigationFinal reportPiper PA 22-160 · Twin Sisters Mtn, WAThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB WPR15FA212Accident · 2 fatalField investigationFinal reportBeech A35 · Mazama, WAThe noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his failure to maintain clearance from mountainous terrain.NTSB WPR12CA117Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Randle, WAThe pilot exceeded the helicopter's performance, resulting in low rotor rpm and settling.NTSB WPR12FA105Accident · 3 fatalField investigationFinal reportCessna 172S · North Bend, WAThe pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.NTSB WPR12CA026Accident · Serious injuriesData collectionFinal reportAyres S2R-600 · Kahlotus, WAThe pilot’s failure to maintain clearance from the ground due to his distraction with programming a global positioning system receiver.NTSB WPR11FA319Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Verlot, WAThe non-instrument rated pilot’s decision to continue visual flight into clouds and his failure to maintain clearance from terrain while maneuvering in an area of reduced visibility, low clouds, and mountain obscuration.NTSB WPR11LA306Accident · Serious injuriesLimited investigationFinal reportGrumman American Avn. AA-5 · Yacoit, WAThe pilot’s failure to maintain clearance from terrain.NTSB WPR11LA181Accident · Serious injuriesLimited investigationFinal reportCessna A188 · Palouse, WAThe pilot did not maintain adequate clearance from obstacles during a low-level aerial application maneuver.NTSB WPR11FA061Accident · 1 fatalField investigationFinal reportAmerican Champion 8GCBC · Bremerton, WAThe pilot did not maintain clearance from terrain for undetermined reasons. Contributing to the accident were the pilot’s use of oxycodone and his severe coronary artery disease.NTSB WPR10FA223Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D1 · Skokomish, WAThe pilot's failure to maintain clearance from trees while flying over hilly, forested terrain.NTSB WPR09LA010Accident · Serious injuriesLimited investigationFinal reportBell 206B · Cougar, WAThe pilot's failure to maintain clearance between his external load and trees while maneuvering. Contributing to the accident were hilly terrain and trees.NTSB LAX08FA246Accident · 3 fatalField investigationFinal reportCessna 172N · McMurray, WAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.NTSB SEA08CA113Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Waitsburg, WAThe pilot's failure to maintain clearance from the terrain while maneuvering at low altitude. Contributing to the accident was the rising terrain.