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 WPR09CA329Accident · No injuriesData collectionFinal reportNalis Glastar · Arlington, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank prior to takeoff.NTSB WPR09CA328Accident · No injuriesData collectionFinal reportBoeing A75N1 · Gig Harbor, WAThe pilot's inadequate compensation for the crosswind and failure to maintain directional control.NTSB WPR09LA318Accident · 1 fatalLimited investigationFinal reportAlexander Schleicher ASW 27-18E · Ephrata, WAThe pilot’s failure to maintain control of the glider during flight and his exceedance of the glider’s design limits during an attempted recovery from a spin.NTSB WPR09FA316Accident · 2 fatalField investigationFinal reportCessna 172M · Rimrock, WAThe pilot's failure to maintain clearance from trees during a go-around. Contributing to the accident was the pilot's lack of flight experience, and his delayed initiation of a go-around.NTSB WPR09CA310Accident · No injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot's failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB WPR09CA306Accident · No injuriesData collectionFinal reportJenkins Jack Glastar SP · Coupeville, WAThe pilot’s improper landing flare that resulted in a hard landing on soft/grassy terrain.NTSB WPR09CA300Accident · No injuriesData collectionFinal reportNorth American/Victoria MNT LT AT-6A · Olympia, WAThe pilot's inadequate compensation for the crosswind gust and failure to maintain directional control while landing.NTSB WPR09CA294Accident · No injuriesData collectionFinal reportDornier ALPHA-JET · Arlington, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident were the distractions created by the pilot incorrectly setting a radio frequency and by his fixation on an airplane that was on the runway during his approach.NTSB WPR09CA291Accident · No injuriesData collectionFinal reportClarke Colin A Glastar · Wenatchee, WAThe pilot’s failure to maintain adequate airspeed, resulting in an aerodynamic stall and loss of control.NTSB WPR09CA283Accident · Minor injuriesData collectionFinal reportSmith Albert F Challenger TWO · Moses Lake, WAThe student pilot's inadequate compensation for the crosswind condition and failure to maintain lateral roll control of the airplane. Also causal was the flight instructor's failure to effectively communicate his instruction to relinquish the flight controls…NTSB WPR09CA278Accident · No injuriesData collectionFinal reportCessna 180J · Bellingham, WAThe pilot's failure to maintain directional control during landing.NTSB WPR09CA276Accident · No injuriesData collectionFinal reportCessna A185F · Wenatchee, WAThe pilot's misjudged approach and failure to attain the proper touchdown point.NTSB WPR09CA262Accident · No injuriesData collectionFinal reportCessna 210 · Seattle, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to activate the fuel boost pump when attempting an engine restart. Contributing to the accident was the pilot's failure to use a checklist.NTSB WPR09CA260Accident · No injuriesData collectionFinal reportStinson SR-8B · Tacoma, WAThe application of unintended braking input due to the pilot's failure to keep his feet correctly positioned on the rudder pedals during the landing roll.NTSB WPR09CA252Accident · No injuriesData collectionFinal reportCessna 185E · Tacoma, WAThe pilot's failure to maintain directional control while landing with a crosswind.NTSB WPR09FA246Accident · Minor injuriesField investigationFinal reportCessna 172 · Burlington, WAThe failure of the pilot of another airplane to maintain adequate visual lookout during the approach.NTSB WPR09CA232Accident · Minor injuriesData collectionFinal reportAtkins John RAF 2000 G · South Prairie, WAThe pilot's abrupt maneuver to avoid a collision that resulted in an airspeed reduction and subsequent loss of lift provided by the rotor system. Contributing to the accident was the failure of both pilots to maintain an adequate visual lookout for other…NTSB WPR09LA227Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Colfax, WAA total loss of engine power due to excessive wear in several carburetor components that led to a malfunction of the carburetor.NTSB WPR09LA223Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Puyallup, WAA loss of engine power due to fuel starvation as a result of the pilot’s failure to verify the fuel levels in the tanks, and, his failure to select the proper fuel tank.NTSB WPR09LA217Accident · Minor injuriesLimited investigationFinal reportGoodacre CA4-HP · Mansfield, WAThe pilot's failure to maintain aircraft control while landing with a known crosswind condition.NTSB WPR09LA197Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Lopez Island, WAA loss of engine power during cruise flight due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the aft mounting nuts for the newly installed propeller governor and the pilot’s failure to secure the oil…NTSB WPR09CA191Accident · Serious injuriesData collectionFinal reportRemos Gemini Remos · Jefferson, WAThe pilot's inadequate compensation for the gusty crosswinds conditions while approaching to land.NTSB WPR09CA186Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 58 · Anacortes, WAThe partial loss of engine power due to the passenger's inadvertent movement of the engine throttle control.NTSB WPR09CA188Accident · Serious injuriesData collectionFinal reportHiller Sixchuter Legend XL · Vancouver, WAThe pilot's failure to attain/maintain adequate airspeed to become airborne within the distance available for takeoff.NTSB WPR09CA185Accident · No injuriesData collectionFinal reportCessna 172L · Richland, WAThe pilot's improper landing flare.NTSB WPR09CA182Accident · No injuriesData collectionFinal reportCessna 172S · Snohomish, WAAn in-flight collision with a crow.NTSB WPR09CA172Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's improper flare and improper recovery from a bounced landing.NTSB WPR09CA126Accident · No injuriesData collectionFinal reportErcoupe 415-E · Camas, WAThe pilot's misjudged landing flare and inadequate recovery from a bounced landing.NTSB WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.NTSB WPR09CA107Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's failure to maintain directional control during the takeoff roll.Contributing to the accident was the student pilot's decision to initiate the takeoff with the airplane positioned near the left edge of the runway.NTSB WPR09CA084Accident · No injuriesData collectionFinal reportCessna U206E · Crane Island, San Juan Is., WAThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's improper application of brakes.NTSB WPR09FA068Accident · No injuriesField investigationFinal reportBoeing 757-351 · Seattle, WAThe failure of the tug operator and wing walker of the other airplane to maintain clearance with this aircraft during the pushback process in dark night. Also causal was the ramp controller's misinterpretation of the other airplane's gate location and her…NTSB WPR09IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-890 · Seattle, WAThe failure of the deicing crew to follow company procedures by not receiving confirmation from the flight crew before beginning to deice the airplane.NTSB WPR09CA080Accident · No injuriesData collectionFinal reportTarantola RV6A · Onalaska, WAThe pilot's improper decision to land with a tailwind, which resulted in the runway overrun. Contributing to the accident was the tailwind.NTSB WPR09LA039Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Camas, WAA loss of engine power for undermined reasons. Contributing to the accident was the low altitude and airspeed, which precluded making a safe autorotation.NTSB WPR09CA101Accident · No injuriesData collectionFinal reportBeech K35 · Port Townsend, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a checklist and the distraction caused by the discussion with the passenger.NTSB WPR09CA037Accident · No injuriesData collectionFinal reportCessna 182S · White Swan, WACollision with terrain while maneuvering for undetermined reasons.NTSB WPR09LA022Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Concrete, WAThe loss of engine power during initial climb due to the pilot's improper exhaust system maintenance, which resulted in restriction of the carburetor's air intake.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 WPR09CA002Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lynden, WAThe separation of the tailwheel spring retaining clip for unknown reasons, which resulted in the loss of directional control during the landing roll.NTSB WPR09TA001Accident · No injuriesFinal reportEurocopter AS350B3 · Blaine, WAThe pilot's failure to maintain main rotor rpm, which resulted in a hard landing. Contributing to the accident were the flight instructor's delayed remedial action and inadequate supervision of the flight.NTSB SEA08CA215Accident · No injuriesData collectionFinal reportNorth American AT-6 · Arlington, WAThe front seated pilot's inadequate compensation for the right quartering tailwind and failure to maintain directional control. Also causal was the rear seated pilot's inadequate remedial action and failure to regain directional control.NTSB SEA08CA214Accident · No injuriesData collectionFinal reportLaird LC-1B-300 · Spokane, WAThe pilot’s misjudged landing flare that resulted in a hard landing. A contributing factor was the impact related failure of the tail wheel spring attachment bolts due to overload, which resulted in a ground loop.NTSB SEA08CA212Accident · No injuriesData collectionFinal reportSport Flight International Astra · Spokane, WAThe pilot's excessive use of brakes and failure to maintain directional control during the landing roll.NTSB SEA08LA207Accident · Serious injuriesLimited investigationFinal reportSimpson Amphibious Trike · Lake Chelan, WAThe pilot's failure to maintain adequate airspeed during the initial climb, which resulted in an inadvertent aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the float-equipped, weight-shift airplane.NTSB SEA08LA206Accident · No injuriesLimited investigationFinal reportStearman C3-B · Stevenson, WAA loss of engine power due to fuel starvation from a piece of disintegrating gasket material that was blocking the fuel jet. Also causal was the failure of maintenance personnel to verify the condition of the gaskets when the carburetor was examined prior to…NTSB SEA08LA200Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Napavine, WAThe pilot's decision to make a low-altitude pass, and his failure to maintain clearance from all structures while maneuvering.NTSB LAX08LA290Accident · 1 fatalLimited investigationFinal reportAirborne XT-912 · Chelan, WAThe pilot's failure to maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall.NTSB LAX08CA279Accident · No injuriesData collectionFinal reportAnderson R E/Abromavich L J Lancair 360 · Vancouver, WAThe pilot's improper flare, which resulted in a hard landing.NTSB SEA08CA184Accident · No injuriesData collectionFinal reportWheat Excalibur EX · Moses Lake, WAThe right rudder pedal attach rivets sheared due to overload.