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 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 WPR15CA214Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Laurier, WAThe pilot's inadequate decision to continue the approach, which resulted in a long landing and insufficient runway remaining to stop the airplane before it departed the end of the runway.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 GAA15CA175Accident · Minor injuriesData collectionFinal reportCessna 150J · Renton, WAThe pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.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 WPR15LA201Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Oak Harbor, WAThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA15CA160Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Anacortes, WAThe pilot's excessive brake application during the landing roll resulting in a nose over.NTSB GAA15CA139Accident · Minor injuriesData collectionFinal reportRandall W Grandpre CH-701 Zenith · Quincy, WAThe pilot's inadequate selection of a take-off area, resulting in a collision with obstacles and a loss of directional control.NTSB WPR15LA186Accident · Serious injuriesLimited investigationFinal reportRockwell International S 2R · Washtucna, WAThe pilot's failure to maintain directional control while landing with a quartering tailwind.NTSB GAA15CA120Accident · No injuriesData collectionFinal reportBeech RC 45J · Everett, WAThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with a sign.NTSB WPR15FA181Accident · 1 fatalField investigationFinal reportBeech F35 · Everett, WAThe partial loss of engine power during takeoff due to debris within the fuel servo, which restricted fuel flow throughout the engine fuel system and resulted in a partial loss of engine power.NTSB GAA15CA107Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Hay, WAThe pilot's and flight instructor's improper brake application during the landing roll. Contributing to the accident was the flight instructor's failure to make a positive transfer of controls.NTSB GAA15LA085Accident · Serious injuriesLimited investigationFinal reportDestiny 2000 · Eltopia, WAThe flight instructor’s failure to tell the student pilot to abort the takeoff after the powered parachute experienced wing oscillations, which resulted in the student pilot’s loss of aircraft control during initial climb and subsequent impact with terrain.…NTSB GAA15CA065Accident · No injuriesData collectionFinal reportChampion 7ECA · Quincy, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB WPR15LA159Accident · Minor injuriesLimited investigationFinal reportGarlick UH-1B · Kettle Falls, WAA total loss of engine power due to foreign object (towel) ingestion. Contributing to the accident was maintenance personnel’s inadequate postmaintenance inspection of the engine.NTSB WPR15FA158Accident · 2 fatalField investigationFinal reportPiper PA 46 350P · Spokane, WAThe mechanic's incorrect installation of two aileron cables and the subsequent inadequate functional checks of the aileron system before flight by both the mechanic and the pilot, which prevented proper roll control from the cockpit, resulting in the pilot's…NTSB GAA15CA062Accident · No injuriesData collectionFinal reportIssoire Siren PIK 30 · Deer Park, WAA loss of lift, which precipitated a forced off airport landing, and collision with terrain.NTSB WPR15LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Centralia, WAMaintenance personnel’s incorrect installation of the fuel selector valvehandle, which resulted in fuel starvation, a loss of engine power, and a forced hard landing. Contributing to the accident was the pilot's failure to follow the manufacturer's checklist.NTSB WPR15LA167Accident · No injuriesLimited investigationFinal reportBeech F33A · Puyallup, WAA total loss of engine power due to fuel starvation as a result of a mechanic’s failure to properly tighten the B-nut to the fuel pump inlet during a recent annual inspection. Contributing to the accident was the pilot's decision to take off despite…NTSB WPR15LA111Accident · 1 fatalLimited investigationFinal reportPiper PA46 - 350P · Spokane, WAA total loss of engine power due to the refueler’s incorrect refueling of the airplane. Contributing to the accident was the fixed-base operator’s improper fueling nozzle, which facilitated the use of an incorrect fuel, and the pilot’s inadequate preflight…NTSB WPR15LA109Accident · No injuriesLimited investigationFinal reportBell/Garlick UH 1H · Shelton, WAThe fatigue failure of the engine-to-transmission driveshaft adapter attachment bolt due to the application of inadequate torque on the bolt during assembly.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 WPR15LA101Accident · Minor injuriesLimited investigationFinal reportVans RV7 - Undesignat · Belfair, WAA total loss of engine power during cruise flight due to the fatigue failure of the engine crankshaft. Contributing to the accident was the unapproved repair and improper inspection of the engine crankshaft.NTSB WPR15CA095Accident · No injuriesData collectionFinal reportPiper PA 12 · Ridgefield, WAThe pilot's delayed action to use carburetor heat before the engine experienced a total loss of power while operating at cruise flight in conditions conducive to carburetor icing.NTSB WPR15LA092Accident · 1 fatalLimited investigationFinal reportAlexander RV-7 · Seabeck, WAA loss of airplane control for reasons that could not be determined because the airplane impacted water, and the majority of the wreckage was not recovered.NTSB WPR15CA056Accident · No injuriesData collectionFinal reportTaylorcraft BL 65 · Everett, WAThe pilot's failure to maintain directional control during the landing roll resulting in a runway excursion and collision with hangars.NTSB WPR15CA053Accident · No injuriesData collectionFinal reportStafford Wayne H Glastar · Monroe, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and encounter with terrain.NTSB WPR15LA023Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Basin City, WAMaintenance personnel’s and the airplane owner’s failure to inspect the engine for cracks in the cylinders as required by an airworthiness directive, which resulted in the loss of engine power during low-altitude maneuvering flight.NTSB WPR14FA393Accident · 1 fatalField investigationFinal reportTifft Kitfox III · Lake Stevens, WAThe pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…NTSB WPR14CA386Accident · Minor injuriesData collectionFinal reportCessna E162 · Bellingham, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.NTSB WPR14CA383Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Rimrock, WAThe pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.NTSB WPR14CA360Accident · No injuriesData collectionFinal reportNavion Navion F · Colville, WAThe pilot's loss of directional control during the landing roll.NTSB WPR14FA355Accident · 1 fatalField investigationFinal reportThomas C Sikes Loehle 5151 Mustang · Chehalis, WAThe pilot’s failure to maintain adequate airspeed during initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin. Contributing to the accident was that pilot’s psychiatric disease, which…NTSB WPR14CA378Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Walla Walla, WAThe pilot's misjudged approach which resulted in overshooting the landing point and insufficient remaining landing surface.NTSB WPR14CA358Accident · No injuriesData collectionFinal reportBoeing A75N1 (PT-17) · Seattle, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.NTSB WPR14LA340Accident · No injuriesLimited investigationFinal reportHughes 269C · Darrington, WAMaintenance personnel’s failure to secure the throttle mount bracket during a recent engine installation, which resulted in the loss of throttle movement and an inability to control engine power.NTSB WPR14FA310Accident · 1 fatalField investigationFinal reportBell 206A · Wenatchee, WAThe pilot's failure to maintain a proper decent rate and path, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's impairment by a sedating medication.NTSB WPR14LA308Accident · Serious injuriesLimited investigationFinal reportMdhi 369D · Oso, WAThe pilot/mechanic’s failure to properly perform required inspections of the main rotor blades at the necessary intervals, which resulted in an in-flight separation of a main rotor blade due to disbonding and fatigue cracking. Contributing to the accident was…NTSB WPR14LA307Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Auburn, WAA collapse of the nose landing gear for reasons that could not be determined based on the available information.NTSB WPR14CA306Accident · No injuriesData collectionFinal reportBosco Don Searey · Mount Vernon, WAThe pilot's failure to maintain lateral control while taxiing. Contributing to the accident was the incorrect decision to takeoff once the sponson had been damaged.NTSB WPR14LA298Accident · No injuriesLimited investigationFinal reportPiper PA 30 · Othello, WAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR14CA290Accident · Minor injuriesData collectionFinal reportBell 47K · Kingston, WAThe pilot's failure to maintain aircraft control during the landing approach, which resulted in an excessive descent angle and settling with power.NTSB WPR14LA285Accident · Minor injuriesLimited investigationFinal reportBailey-Moyes Microlights Dragonfly B Model · Buckley, WAThe pilot’s inability to maintain airplane control due to a loss of flight control effectiveness for reasons that could not be determined during postaccident examinations.NTSB WPR14FA286Accident · 1 fatalField investigationFinal reportCessna 182 · Fall City, WAThe pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR14LA284Accident · No injuriesLimited investigationFinal reportGlobe GC 1B · Puyallup, WAThe failure of the exhaust assembly in the No. 3 cylinder for reasons that could not be determined due to the damage incurred to the fractured parts. Also causal to the accident was maintenance personnel’s improper installation of the cylinder.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 WPR14CA287Accident · No injuriesData collectionFinal reportMooney M20TN · Yakima, WAThe pilot's failure to configure the landing gear for landing.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 WPR14CA276Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Moses Lake, WAThe airplane impacted a bird during low level flight.