NTSB investigations, WA
372 cases where NTSB found Use of equip/info.
Cases per year
| 2008 | 12 |
|---|---|
| 2009 | 29 |
| 2010 | 16 |
| 2011 | 28 |
| 2012 | 23 |
| 2013 | 23 |
| 2014 | 31 |
| 2015 | 12 |
| 2016 | 19 |
| 2017 | 19 |
| 2018 | 35 |
| 2019 | 17 |
| 2020 | 19 |
| 2021 | 20 |
| 2022 | 22 |
| 2023 | 15 |
| 2024 | 12 |
| 2025 | 14 |
| 2026 | 6 |
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\", '020630'))
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", '020630')) 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 WPR26LA265Accident · No injuriesClass 4 · LimitedFinal reportVans RV-7A · Covington, WAThe pilot’s improper pitch control during landing, which resulted in a bounced landing, nose landing gear collapse, and nose over.NTSB WPR26LA261Accident · No injuriesClass 4 · LimitedFinal reportKitfox S7 STI · Greenwater, WAThe pilot’s failure to maintain directional control during the landing roll, in variable wind conditions.NTSB WPR26LA241Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Port Angeles, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR26LA208Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Pasco, WAThe pilot’s inadvertent excessive braking during the landing roll, which resulted in a nose over.NTSB WPR26LA136Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Chehalis, WAThe pilot’s improper recovery from a bounced landing, which resulted in a tail strike.NTSB WPR26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech 76 · Snohomish, WAThe flight instructor’s inadequate supervision of a dual student who attempted a go-around using one engine which resulted in a loss of control and impact with the ground.NTSB WPR26LA016Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Olympia, WAThe pilot’s inadvertent retraction of the landing gear after landing.NTSB WPR25LA306Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Toledo, WAThe pilot’s failure to maintain control of the airplane during takeoff in crosswind conditions..NTSB WPR25LA308Accident · Serious injuriesClass 4 · LimitedFinal reportThomas Graham Teenie Two · Chehalis, WAThe pilot's improper decision to take off with the airplane over its maximum allowable gross weight, which degraded its climb performance and led to a subsequent off airport landing.NTSB WPR25LA270Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Everett, WAThe pilot’s failure to maintain directional control during landing in crosswind conditions.NTSB WPR25LA246Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E · Fobes Hill, WAThe pilot’s abrupt maneuver to avoid a powerline during an aerial application flight, which resulted in the helicopter’s impact with terrain.NTSB WPR25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Cashmere, WAThe pilot’s failure to maintain clearance from obstacles during an aborted landing, while flying in tailwind conditions. Contributing to the accident was the high density altitude weather condition.NTSB WPR25LA229Accident · No injuriesClass 4 · LimitedFinal reportLake Tahoe Properties CA 8 · Davenport, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR25LA199Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Tukwila, WAThe pilot’s failure to maintain yaw control during a takeoff to a hover in a gusting crosswind, which resulted in a loss of directional control and a subsequent hard landing.NTSB WPR25LA172Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Spokane Valley, WAThe pilot’s failure to maintain directional control during a takeoff roll in quartering tailwind conditions.NTSB WPR25LA179Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · East Wenatchee, WAThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.NTSB ANC25LA047Accident · No injuriesClass 4 · LimitedFinal reportBrian Peck RV-14 · Camas, WAThe pilot’s failure to maintain directional control during landing roll which resulted in a runway excursion.NTSB WPR25LA168Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7BCM · Port Townsend, WAThe flight instructor’s delayed remedial action and inadequate compensation for shifting wind conditions which resulted in a veer off the runway and collision with a sign.NTSB WPR25LA162Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Monroe, WAThe student pilot’s failure to maintain airplane control during landing, and the flight instructor’s delayed remedial action, which resulted in impact with a ditch.NTSB WPR25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Waterville, WAThe pilot’s failure to maintain directional control during landing roll.NTSB WPR25LA061Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Gig Harbor, WAThe student pilot’s failure to maintain directional control during a touch-and-go.NTSB WPR25LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna A185E · Seattle, WAThe pilot’s failure to maintain directional control during landing roll with a crosswind.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 WPR24LA303Accident · No injuriesClass 4 · LimitedFinal reportCessna T206H · Big Bend-Gold Bar, WAThe pilot’s improper flare, which resulted in a hard landing.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 WPR24FA226Accident · 2 fatalClass 3 · FieldFinal reportChampion 7GCBC · Eatonville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid trees, which resulted in an aerodynamic stall.NTSB WPR24LA222Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Tacoma, WAThe pilot’s failure to maintain directional control during landing.NTSB WPR24FA200Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Bluestem, WAThe pilot’s failure to manage main rotor rpm during an autorotation, which resulted in a loss of helicopter control. Contributing to the accident was a loss of power for reasons that could not be determined.NTSB WPR24LA188Accident · Serious injuriesClass 3 · LimitedFinal reportDavid Fisher Murphy Moose · Ocean Shores, WAThe pilot’s hard, bounced landing, subsequent failure to maintain adequate airspeed, and his exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall and impact with terrain.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 ANC24LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Deer Park, WAThe pilot’s improper landing flare which resulted in the airplane contacting the ground short of the runway.NTSB WPR24LA099Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-18A 150 · Dallesport, WAThe pilot’s failure to disengage the ignition prior to moving the propeller by hand resulting in the inadvertent starting of the engine.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 WPR23LA356Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Eatonville, WAThe pilot's failure to maintain directional control during the takeoff roll, in gusty wind conditions, which resulted in a runway excursion.NTSB WPR23FA344Accident · 1 fatalClass 3 · FieldFinal reportSeawind 3000 · Bellevue, WAThe pilot’s loss of airplane control after encountering a lake swell and skipping during takeoff.NTSB WPR23LA326Accident · No injuriesClass 4 · LimitedFinal reportHenry Steven J JA 30 Superstol · Leavenworth, WAThe pilot's failure to maintain airplane control during taxi, which resulted in a nose over.NTSB WPR23LA291Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Friday Habor, WAThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB WPR23LA285Accident · Minor injuriesClass 3 · LimitedFinal reportMaule M-5-235C · Eastsound, WAThe pilot’s improper in-flight fuel management, which led to fuel starvation and a total loss of engine power.NTSB WPR23LA276Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Chelan, WAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop and subsequent nose over.NTSB WPR23LA268Accident · No injuriesClass 4 · LimitedFinal reportVickers-Armstrong Spitfire IX · Deer Park, WAThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB WPR23LA248Accident · No injuriesClass 4 · LimitedFinal reportFound FBA2C · Moses Lake, WAThe pilot’s failure to maintain directional control during landing.NTSB WPR23LA273Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Metaline Falls, WAThe pilot’s loss of directional control during landing due to impact with a concrete ring embedded in the grass runway.NTSB WPR23LA231Accident · Minor injuriesClass 4 · LimitedFinal reportJohnson Gary L Fisher Horizon 1 · Chelan, WAThe pilot’s improper selection of a touchdown point and delayed recognition, which resulted in an impact with an obstacle.NTSB WPR23LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna 310I · Sunnyside, WAThe failure of the side brace lock assembly of the right main landing gear due to overstress as a result of a hard landing.NTSB WPR23LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Twisp, WAThe pilot’s loss of directional control during landing, which resulted in a runway excursion and ground loop.NTSB WPR23LA180Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Ariel, WAThe pilot’s failure to maintain aircraft control during the landing roll, resulting in a nose over.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 WPR23FA034Accident · 4 fatalClass 2 · FieldFinal reportTextron 208B · Snohomish, WAThe pilot’s improper recovery following a departure from controlled flight after an intentional aerodynamic stall, which resulted in an exceedance of airspeed limitations, airframe overstress, and a subsequent inflight breakup.NTSB WPR23LA042Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 180 · Kahlotus, WAThe pilot’s failure to check the fuel selector position before takeoff and his improper fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal was the pilot’s loss of airplane control which resulted in an aerodynamic…NTSB WPR23LA026Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Puyallup, WAThe pilot’s inadequate fuel management that resulted in the loss of engine power due to fuel exhaustion.