NTSB investigations, WA
79 cases where NTSB found Attention/monitoring.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 7 |
| 2010 | 3 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 3 |
| 2017 | 4 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 4 |
| 2024 | 7 |
| 2025 | 2 |
| 2026 | 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\", '020215'))
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", '020215')) 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 WPR25LA262Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Burlington, WAThe pilot’s failure to see and avoid the light pole, which resulted in a collision with the light pole and subsequent ground impact.NTSB WPR25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Concrete, WAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.NTSB WPR24LA318Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Seattle, WAThe Gulfstream pilot’s failure to maintain clearance from the Cessna while taxiing that resulted in a ground collision.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 WPR24LA301Accident · No injuriesClass 4 · LimitedFinal reportThompson Ryan L Thompson Craft · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB WPR24FA285Accident · 1 fatalClass 3 · FieldFinal reportCessna A185F · Kent, WAThe pilot’s failure to properly configure the amphibious landing gear for a water landing, which resulted in a touchdown on the water with the wheels extended, noseover, and airplane submersion.NTSB WPR24LA173Accident · No injuriesClass 4 · LimitedFinal reportSikorsky S-55QT · Benton City, WAThe pilot’s failure to maintain clearance from power lines during a low altitude operation.NTSB WPR24LA139Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Olympia, WAThe flight instructor’s delayed action to arrest the descending, left pedal turn while maneuvering for a low-altitude hover with the helicopter near the maximum gross weight limitation, which resulted in an impact with the ground and a dynamic rollover.NTSB WPR24LA113Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox S7 Super Sport · Asotin, WAPilot’s failure to maintain clearance from powerlines during low altitude flying.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 WPR23LA293Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Port Angeles, WAThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR23LA105Accident · No injuriesClass 4 · LimitedFinal reportHughes 269C · Yakima, WAThe pilot's failure to see and avoid a powerline while flying at low altitude over a river.NTSB WPR23LA101Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Dallesport, WAThe flight instructor’s failure to see and avoid a channel marker during a step taxi in preparation for takeoff on the water.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 WPR22LA353Accident · No injuriesClass 3 · LimitedFinal reportCessna 525B · Pasco, WAThe failure of the pilot to ensure the landing gear was extended before landing. Contributing was the pilot’s failure to fly a stabilized approach, and his configuration of the airplane that prevented activation of the landing gear not extended warning system…NTSB WPR22LA245Accident · Serious injuriesClass 4 · LimitedFinal reportHiller UH-12E · Wenatchee, WAThe pilot’s failure to maintain clearance from power lines during low-level operations in light rain conditions.NTSB WPR22LA220Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Auburn, WAThe student pilot’s loss of helicopter control and the flight instructor’s delayed remedial action while providing hover training which resulted in a dynamic rollover.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 WPR21LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Renton, WAThe boat operator’s failure to remain a safe distance from the floatplane during the takeoff run, which resulted in a collision.NTSB WPR21LA084Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Winthrop, WAThe pilot’s failure to adequately monitor the environment which resulted in a collision with a snowbank and subsequent loss of control.NTSB WPR21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Palouse, WAThe student pilot’s improper landing flare and loss of directional control and the flight instructor’s delayed remedial action resulted in a runway excursion and nose over.NTSB WPR21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Moses Lake, WAThe pilot’s failure to maintain clearance from telephone wires while on final approach for landing which resulted in a collision.NTSB WPR20LA331Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Randle, WAThe pilot's failure to maintain clearance from a tree while conducting an external load operation.NTSB GAA19CA509Accident · Serious injuriesData collectionFinal reportRobinson R44 · Cypress Island, WAThe pilot's failure to maintain adequate clearance from a tree while maneuvering at a low altitude.NTSB WPR19FA219Accident · 1 fatalClass 3 · FieldFinal reportCapes Murphy Moose · Marysville, WAThe pilot’s failure to maintain terrain clearance while turning to final approach to avoid a collision with another airplane flying a straight in approach to the same runway. Contributing to the accident was the pilots of both airplanes failure to adequately…NTSB WPR19FA124Accident · 2 fatalClass 3 · FieldFinal reportVans RV 6 · Ridgefield, WAThe pilots' inadvertent exceedance of the airplane's critical angle of attack following an inflight collision with a bird.NTSB GAA19CA136Accident · No injuriesData collectionFinal reportCessna 182 · Arlington, WAThe pilot's distraction during the engine warm-up, which resulted in the airplane's collision with a hangar. Contributing to the accident was the pilot's failure to set the brakes.NTSB WPR18FA261Accident · 2 fatalClass 3 · FieldFinal reportGruber Beelzabub · Rochester, WAThe pilot’s failure to maintain clearance from a tree while maneuvering at a low altitude.NTSB WPR18TA243Accident · No injuriesFinal reportBeech 36 · Kelso, WAThe pilot's fuel mismanagement, which led to fuel starvation, a total loss of engine power, and the subsequent forced landing to a field.NTSB WPR18FA210Accident · 2 fatalField investigationFinal reportMooney M20J · Lopez Island, WAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering for landing, which resulted in a cross-control aerodynamic stall, spin, and impact with terrain. Contributing to the accident was the flight instructor's delayed remedial…NTSB GAA18CA352Accident · No injuriesData collectionFinal reportBell 206 · Orondo, WAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.NTSB WPR18LA151Accident · 1 fatalLimited investigationFinal reportCessna 150M · Bainbridge Island, WAThe pilot's failure to maintain clearance from the water and his distraction by using the tablet for navigation, which resulted in his failure to detect that the airplane had entered a descent.NTSB GAA18CA029Accident · Serious injuriesData collectionFinal reportSix Chuter West Legend XL · Mabton, WAThe pilot’s failure to see and avoid transmission wires.NTSB GAA17CA564Accident · No injuriesData collectionFinal reportBoeing PT 13 · Skagit, WAThe pilot’s failure to maintain clearance from airport lighting during the landing roll.NTSB GAA17CA458Accident · No injuriesData collectionFinal reportRandall Marvin L Vans RV 3A · Spokane, WAThe other pilot’s failure to maintain adequate clearance and visual lookout while taxiing, which resulted in his airplane colliding with the stationary airplane.NTSB GAA17CA369Accident · No injuriesData collectionFinal reportBell 206B · Entiat, WAThe pilot’s failure to secure a loose item inside the cockpit that interfered with antitorque pedal control and led to a loss of helicopter control due to a loss of tail rotor effectiveness.NTSB WPR16LA189Accident · Serious injuriesLimited investigationFinal reportDehavilland Beaver DHC 2 MK.1 · Lopez Island, WAThe pilot's decision to land in an area of low visibility and ground fog, which resulted in collision with water.NTSB GAA16CA417Accident · No injuriesData collectionFinal reportCessna 172 · Everett, WAThe pilot's failure to maintain clearance from the building door, which resulted in substantial damage to the left wing.NTSB GAA16CA258Accident · No injuriesData collectionFinal reportBell OH 58 · Waitsburg, WAThe pilot's failure to maintain clearance from the power line during low reconnaissance flight, which resulted in a power line strike, loss of control, and a subsequent hard landing.NTSB WPR16FA001Accident · 1 fatalField investigationFinal reportJohnson Coot · Deer Park, WAThe pilot's failure to maintain sufficient airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Contributing to the accident was the pilot's diverted attention due to the rough…NTSB WPR15FA204Accident · 2 fatalField investigationFinal reportHughes 269C · Asotin, WAThe pilot's failure to maintain adequate clearance from power lines while maneuvering in a canyon.NTSB WPR15CA107Accident · No injuriesData collectionFinal reportPiper PA28 - 180 · Garfield, WAThe pilot did not maintain clearance from a power line while maneuvering at a low altitude.NTSB WPR14CA279Accident · Serious injuriesData collectionFinal reportWiley Kitfox IV · Sprague, WAThe pilot's failure to maintain adequate clearance from powerlines during the landing approach resulting in a collision.NTSB WPR14CA270Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Quincy, WAThe pilot's failure to maintain clearance from a wind generator tower while drying cherries, which resulted in a loss of aircraft control and subsequent hard landing.NTSB WPR14CA229Accident · No injuriesData collectionFinal reportAeronca 11AC · Tacoma, WAThe student pilot's improper application of rudder resulted in a loss of control during the landing roll and the flight instructor's inadequate oversight.NTSB WPR14CA150Accident · No injuriesData collectionFinal reportJust Highlander · Yakima, WAThe student pilot's inadequate compensation for the gusting crosswind conditions and the certified flight instructor's inadequate supervision, resulting in a loss of directional control during the landing roll.NTSB WPR14CA092Accident · No injuriesData collectionFinal reportCessna 177RG · Richland, WAThe pilot's failure to extend the landing gear prior to landing. Contributing to the accident was the pilot's diverted attention and not using a checklist.NTSB WPR13CA422Accident · No injuriesData collectionFinal reportBeech 35 - Undesignat · Seattle, WAThe pilot's distracted attention and failure to extend the landing gear, which resulted in a gear up landing.NTSB WPR13CA371Accident · No injuriesData collectionFinal reportCessna 172H · Metaline Falls, WAThe pilot's failure to maintain clearance from a windsock pole while taxiing.