NTSB investigations, WA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 WPR17FA107Accident · 1 fatalField investigationFinal reportSchleicher ASW 28 18E · Ephrata, WAThe pilot's failure to maintain glider control while attempting to conduct an off-airport landing, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR17LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-260 · Mukilteo, WAThe improper maintenance of the carburetor, which resulted in a stuck float and a partial loss of engine power during takeoff.NTSB GAA17CA240Accident · Minor injuriesData collectionFinal reportParlette Robert L Glastar · Wenatchee, WAThe pilot’s improper landing flare and subsequent failure to adequately compensate for gusting wind conditions during a go-around.NTSB WPR17LA087Accident · Serious injuriesLimited investigationFinal reportTitan Tornado I · Spanaway, WAMaintenance personnel’s improper attachment of the aileron system components, which resulted in the pilot's inability to maintain flight control.NTSB GAA17CA216Accident · No injuriesData collectionFinal reportCessna 172 · Twisp, WAThe pilot’s failure to maintain crosswind correction during landing, which resulted in the airplane cartwheeling.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 GAA17CA158Accident · No injuriesData collectionFinal reportSocata TBM700 · Bellingham, WAThe pilot’s failure to properly deice the airplane before takeoff, which resulted in an aerodynamic stall during the initial climb.NTSB WPR17LA058Accident · No injuriesLimited investigationFinal reportBeech E17L · Discovery Bay, WAA loss of engine power for reasons that could not be determined based on the available information.NTSB GAA17CA106Accident · Minor injuriesData collectionFinal reportMaule M7 · Palouse, WAThe pilot’s failure to maintain directional control on an ice- and snow-covered runway during taxi with a crosswind, which resulted in a runway excursion.NTSB WPR17FA044Accident · 4 fatalField investigationFinal reportCessna 182 · Dabob, WAThe non-instrument-rated pilot's decision to continue a night visual flight rules into instrument flight rules conditions, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot's failure to obtain…NTSB WPR17LA037Accident · No injuriesClass 3 · LimitedFinal reportBeech A23 24 · Anacortes, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and separation of the left main landing gear.NTSB GAA17CA072Accident · No injuriesData collectionFinal reportPiper PA 28R · Payallup, WAThe airport’s failure to issue a NOTAM regarding the deployment of the traffic monitoring camera system before the accident, which resulted in the airplane striking the camera system during a short-field approach and landing.NTSB WPR17LA014Accident · No injuriesLimited investigationFinal reportAerospatiale AS350 · Starbuck, WAA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s reliance on the fuel gauge that was displaying an incorrect fuel amount due to the separation of the fuel transmitter float pin guide from the float.NTSB ENG17IA003Incident · No injuriesIncident investigationFinal reportAirbus A330 223 · Seattle, WAA No. 1 engine fire caused by a fuel manifold supply line high cycle fatigue crack which led to a fuel leak that subsequently ignited on hot engine case surfaces. The fatigue crack originated and progressed due to elevated fuel manifold assembly vibration…NTSB GAA17CA011Accident · No injuriesData collectionFinal reportFuller Neil H Glasair SH 2 · Bellingham, WAThe pilot’s failure to maintain directional control during the takeoff roll in crosswind conditions, which resulted in a runway excursion.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 WPR16LA187Accident · No injuriesLimited investigationFinal reportJurcan Seawind 3000 · Renton, WAThe failure of the landing gear system to either fully retract or extend due to a cracked hydraulic fitting flare, which resulted in the loss of hydraulic pressure.NTSB WPR16LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Rockport, WAThe pilot's failure to maintain helicopter control while on the ground, which resulted in mast bumping.NTSB GAA16CA485Accident · Minor injuriesData collectionFinal reportDormaier Monte R Baby Great Lakes · Mazama, WAThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.NTSB GAA16CA452Accident · No injuriesData collectionFinal reportSimmons Noel SDL · Naches, WAThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB WPR16LA164Accident · Minor injuriesLimited investigationFinal reportZenith CH601 · Ocean Shores, WAA reduction in electrical power, which disabled both fuel pumps and resulted in fuel starvation and a loss of engine power.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 GAA16CA405Accident · Minor injuriesData collectionFinal reportBell 206 · Outlook, WAThe pilot and ground crew's failure to visually inspect the helicopter's skids before takeoff, which resulted in a water hose becoming entangled on the right skid, a loss of control, an impact with terrain, and a post-crash fire.NTSB GAA16CA410Accident · No injuriesData collectionFinal reportAeronca 11AC · Gig Harbor, WAThe pilot's failure to maintain directional control during landing, and subsequent wing tip strike, which resulted in substantial damage to the rear spar.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 GAA16CA345Accident · No injuriesData collectionFinal reportCessna 170 · Everett, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and substantial damage to the fuselage.NTSB GAA16CA305Accident · Minor injuriesData collectionFinal reportCessna 172 · Pasco, WAThe flight instructor's failure to maintain pitch control during the simulated engine failure after takeoff, which resulted in a hard landing, landing gear(s) collapse, and wing damage.NTSB GAA16CA286Accident · No injuriesData collectionFinal reportCessna 172 · Arlington, WAThe failure of the airplane’s right steering rod end, which resulted in the pilot’s inability to maintain directional control.NTSB GAA16CA281Accident · Minor injuriesData collectionFinal reportAmerican Champion 8KCAB · Black Diamond, WAThe pilot's abnormal runway contact during the landing flare, which resulted in a porpoise, aerodynamic stall, impact with terrain, and nose over.NTSB WPR16LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Seattle, WAThe pilot’s failure to use the emergency procedures checklist for generator failures or for gear extension following a loss of electrical power due to the separated flag terminal of a diode in overstress, which resulted in a gear-up landing.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 GAA16CA216Accident · No injuriesData collectionFinal reportAirborne Redback · Arlington, WAThe pilot's failure to adequately secure the aircraft while manually starting the engine from outside the cockpit, which resulted in the unmanned aircraft becoming airborne and colliding with a hangar roof.NTSB WPR16FA095Accident · 1 fatalField investigationFinal reportMooney M20K · Woodland, WAThe pilot's delay in recognizing that the airplane was not performing as expected and aborting the takeoff, which resulted in collision with a berm beyond the end of the runway. Contributing to the accident were the pilot's exceedance of the airplane's gross…NTSB GAA16CA193Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Burlington, WAThe pilot's excessive application of the brakes during the landing roll, resulting in a loss of directional control, runway excursion, and ground loop.NTSB WPR16LA090Accident · No injuriesLimited investigationFinal reportCessna 172L · McNeil Island, WAThe student pilot's fuel mismanagement, which led to fuel starvation and a total loss of engine power during cruise flight. Contributing to the accident was his failure to follow the appropriate engine start, before takeoff, and emergency checklists.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 GAA16CA138Accident · No injuriesData collectionFinal reportCessna 170 · Enumclaw, WAThe pilot's incorrect brake application during taxi, which resulted in a nose over.NTSB GAA16CA112Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Auburn, WAThe failure of the pilot receiving instruction to maintain directional control during the landing roll, resulting in a ground-loop.NTSB WPR16LA045Accident · No injuriesLimited investigationFinal reportPiper PA18 · Newman Lake, WAA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB DCA16IA036Incident · No injuriesIncident investigationFinal reportBoeing 737 · Seattle, WAthe flight crew's misidentification of the taxiway as the landing runway.NTSB WPR16LA032Accident · No injuriesLimited investigationFinal reportHughes 369D · Carlisle, WAA total loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel quantity gauge.NTSB WPR16LA021Accident · No injuriesLimited investigationFinal reportMD Helicopter 369D · Sedro-Woolley, WAThe loss of engine power due to fuel starvation as a result of naphthenate fuel contamination, which blocked the fuel flow through the start pump.NTSB WPR16LA011Accident · No injuriesLimited investigationFinal reportChristopher Tom Kitfox 5 · Battle Ground, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR16LA003Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Fall City, WAThe airplane’s collision with the ground short of the runway for reasons that could not be determined based on the available evidence.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 WPR15FA268Accident · Serious injuriesField investigationFinal reportCessna 150F · Port Townsend, WAThe loss of engine power due to the mechanic's inadequate tightening of the crankshaft gear retaining bolts during an engine overhaul, which resulted in fatigue failure of the bolts and the crankshaft gear dowel pin that allowed the crankshaft gear to…NTSB GAA15CA283Accident · No injuriesData collectionFinal reportStinson HW75 · Bremerton, WAThe pilot's failure to maintain directional control during the landing roll, resulting in the left main landing gear collapse and substantial damage to the left wing strut attachment points.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 WPR15LA235Accident · Minor injuriesLimited investigationFinal reportCleveland Allan B Nieuport 11# · Bellingham, WAA partial loss of engine power for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or anomalies that would have precluded normal operation.