NTSB investigations, WA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 SEA97FA201Accident · 5 fatalField investigationFinal reportCessna 182C · Bremerton, WAThe pilot's failure to maintain adequate airspeed in a climbing turn at low altitude, resulting in a stall and impact with terrain. A factor was the pilot exceeding the aircraft's maximum takeoff gross weight limitation.NTSB SEA97FA196Accident · 1 fatalField investigationFinal reportSouthern Aero UH-1B · Skykomish, WAA fatigue fracture in the main rotor mast, which resulted in an in flight separation of the main rotor from the helicopter. Contributing to the accident was insufficient Federal Aviation Administration airworthiness standards and requirements for the aircraft.NTSB SEA97LA193Accident · No injuriesLimited investigationFinal reportCessna TU206G · Edwall, WAA fatigue failure of the engine crankshaft. Factors contributing to the accident were the rolling terrain, and the fence.NTSB SEA97LA192Accident · No injuriesLimited investigationFinal reportCessna 175 · Lynnwood, WAThe pilot's inadequate preflight planning and preparation, which led to fuel exhaustion and subsequent loss of engine power.NTSB SEA97LA191Accident · Minor injuriesLimited investigationFinal reportBell 47G · Wellpinit, WAThe pilot's selection of an unsuitable landing site, and his failure to maintain rotor blade clearance from terrain during landing.NTSB SEA97LA189Accident · Minor injuriesLimited investigationFinal reportRotz RAF 2000 GTX SE · Olympia, WAThe pilot's failure to attain adequate rotor rpm prior to takeoff.NTSB SEA97FA188Accident · Serious injuriesField investigationFinal reportBeech 1900C · Seattle, WAA stall/mush condition resulting from an aft center of gravity which was inaccurately provided to the pilot-in-command by contractual cargo-loading personnel. Additional causes were overloading of the aircraft's landing gear and fuel leakage resulting in a…NTSB SEA97LA186Accident · No injuriesLimited investigationFinal reportCessna 172M · Langley, WAA failed exhaust valve. Factors were tailwind and excessive airspeed during the ensuing forced landing. .NTSB SEA97LA182Accident · 1 fatalLimited investigationFinal reportCessna 140 · Vancouver, WAAircraft control was not maintained. Continued operation with known deficiencies in equipment and movement restrictions to an exhaust valve were factors.NTSB SEA97LA197Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Elma, WAThe pilot's inadequate compensation for wind conditions while landing. A factor was the crosswind.NTSB SEA97LA175Accident · No injuriesLimited investigationFinal reportCessna T210H · Stehekin, WAThe pilot's misreading of the windsock and subsequent downwind landing. Factors in the accident were the sunglare and tailwind.NTSB SEA97LA173Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Graham, WAInadequate aircraft preflight by the pilot-in-command, and water contamination in the fuel resulting in a loss of engine power. A factor was a power transmission line in the forced landing area.NTSB SEA97LA167Accident · No injuriesLimited investigationFinal reportCessna 140 · Arlington, WAFailure of the right-main landing gear axle after landing.NTSB SEA97LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Naches, WAinadequate preflight by the pilot, and subsequent fuel exhaustion, which led to a forced landing and subsequent nose over of the aircraft. Related factors were: the FBO did not refuel the aircraft as requested, and soft terrain was encountered during the…NTSB SEA97LA156Accident · No injuriesLimited investigationFinal reportStiritz Eipper MX II · Newport, WAThe failure of the owner/builder to adequately inspect his homebuilt aircraft, which subsequently led to the failure of the right wing lift cable attach bolt and resulted in the collapse of the right wing during flight.NTSB SEA97LA151Accident · No injuriesLimited investigationFinal reportCessna 182P · Yakima, WAThe loss of engine power for undetermined reasons. Contributing to the accident was the soft terrain.NTSB SEA97LA150Accident · No injuriesLimited investigationFinal reportCorben Junior ACE · East Wenatchee, WAThe dual student's improper attempt to abort the takeoff and the flight instructor's inadequate supervision of the flight.NTSB SEA97LA143Accident · No injuriesLimited investigationFinal reportCessna A188 · Richland, WAthe pilot's failure to maintain airspeed. Inadequate in-flight planning and high obstructions that restricted evasive maneuvers were factors.NTSB SEA97LA134Accident · No injuriesLimited investigationFinal reportCessna 172C · Fall City, WAthe pilot's selection of unsuitable terrain for landing. The soft, wet terrain was a related factor.NTSB SEA97LA129Accident · No injuriesLimited investigationFinal reportCessna 210D · Renton, WALanding gear hydraulic system power pack failure.NTSB SEA97LA126Accident · No injuriesLimited investigationFinal reportGarlick UH-1H · Addy, WAThe inflight failure of the K-FLEX engine-to-gear box drive shaft and no suitable site in which to make a forced/emergency landing. A factor was the mountainous/hilly terrain.NTSB SEA97LA118Accident · No injuriesLimited investigationFinal reportHughes 369D · Moclips, WAInadequate installation of the fuel control by company maintenance personnel and a loose nut on a line. A disconnected Pc line was a factor.NTSB SEA97LA113Accident · No injuriesLimited investigationFinal reportCessna 207 · Roche Harbor, WAThe pilot's inadequate remedial action upon encountering a downdraft on final approach. The downdraft was a factor.NTSB SEA97LA112Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Snohomish, WAthe pilot's encounter with of a loss of tail rotor effectiveness (LTE) situation, and his subsequent inadequate remedial action. Related factors included: wind conditions that were conducive to an unanticipated right yaw event, and the pilot's limited…NTSB SEA97LA111Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Freeland, WAFuel exhaustion due to the flight instructor's failure to insure there was proper fuel in the aircraft and the flight instructor's misjudgment of his altitude and airspeed while executing a power-off forced landing in a large open field. Factors include: a…NTSB SEA97LA099Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Rosalia, WAThe pilot-in-command's failure to maintain clearance with terrain. Factors contributing to the accident were, hilly terrain conditions and impairment due to recent use of marihuana.NTSB CHI97IA122Incident · No injuriesIncident investigationFinal reportBeech 35 · Spokane, WAthe vibration of the fuselage was due to flutter.NTSB SEA97LA095Accident · No injuriesLimited investigationFinal reportCessna 172N · Pullman, WAThe pilot's failure to maintain clearance from a fuel truck parked near his taxi route. Factors include a dark night and a vehicle parked near the pilot's route of taxi.NTSB SEA97LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Ilwaco, WAThe student pilot's failure to land the aircraft at the proper touchdown point. Factors include inadequate preflight planning/preparation by the student pilot, inadequate supervision by the student pilot's flight instructor, rain, fog, strong crosswinds, a…NTSB SEA97LA088Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Prescott, WAfailure of the pilot to maintain terrain clearance from uneven/hilly terrain.NTSB SEA97LA086Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Sequim, WAThe pilot-in-command's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor was trees in the forced landing area.NTSB SEA97LA083Accident · Minor injuriesLimited investigationFinal reportCessna 150D · Arlington, WAThe failure of the commercial pilot to perform an adequate visual lookout while on final approach for landing on the runway, and the failure of the student pilot of the other airplane to perform an adequate visual lookout prior to taking off from the same…NTSB SEA97LA102Accident · No injuriesLimited investigationFinal reportBoeing E75 · Spokane, WAThe pilot-in-command's inadequate application of crosswind controls during landing rollout. Factors were gusty crosswinds.NTSB SEA97LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAthe pilots' inadequate evaluation of the strong winds, when they attempted to turn to taxi with a very strong tailwind. Factors relating to the accident included the high and unfavorable winds.NTSB SEA97LA079Accident · 1 fatalLimited investigationFinal reportRose VP-1 · Gardiner, WAThe pilot-in-command's failure to maintain control of the aircraft. Factors contributing to the accident were gusty and high winds.NTSB SEA97LA077Accident · No injuriesLimited investigationFinal reportde Havilland DHC-8 · Wenatchee, WAfailure of the ground marshaller to marshal the airplane into a correct parking place on the ramp, her failure to verify clearance between the right wing of the airplane and the ground de-ice cart, and failure of the flight crew to ensure clearance of the…NTSB SEA97LA078Accident · No injuriesLimited investigationFinal reportCessna 177B · Everett, WAfailure of the pilot to maintain directional control of the airplane after landing. Factors relating to the accident include: a blown (failed) nose tire, and soft terrain beside the runway.NTSB SEA97LA073Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arlington, WALanding long (improper touchdown point) and collapse of the main landing gear during an intentional swerve or groundloop. Factors include excessive airspeed on approach.NTSB SEA97LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · College Place, WAThe certified flight instructor's improper in-flight decision to continue the landing attempt and not perform a go-around, her failure to attain the proper touchdown point, and her failure to apply proper remedial action. A contributing factor was the…NTSB SEA97LA068Accident · Minor injuriesLimited investigationFinal reportHemingway Varieze · Arlington, WAThe pilot's failure to maintain control of the aircraft. Factors contributing to the accident were the pilot's lack of total experience in the type of aircraft and the gusty wind conditions.NTSB SEA97LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Toledo, WAThe pilot's excessive application of the brakes on a tailwheel equipped aircraft. Factors include the pilot's inadequate compensation for wind conditions, and a crosswind blowing at the time of the landing.NTSB SEA97LA052Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201 · Chehalis, WAThe failure of the first pilot to conduct an adequate preflight inspection, and his failure to properly manage the aircraft fuel supply. This led to fuel starvation and a subsequent loss of engine power. Factors contributing to the accident are the false…NTSB SEA97IA051Incident · No injuriesIncident investigationFinal reportBeech 1900D · Seattle, WAan axial shift of the aft flap track bearing's outer roller, resulting in erosion and failure of the flap track bracket/bearing assembly. A factor relating to the incident was: inadequate inspection of the flap roller bearing/bracket assemblies.NTSB SEA97LA050Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Lopez, WAThe pilot's improper decision to initiate flight into marginal VFR conditions at night which led to inadvertent flight into instrument meteorological conditions, and his failure to maintain adequate clearance from terrain. Factors contributing to the accident…NTSB SEA97LA045Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Richland, WAfailure of the pilot to see-and-avoid an ultralight aircraft that was taxiing and had stopped in front of him.NTSB SEA97IA040Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Seattle, WAThe failure of the left wing walker to verify the clearance between the left wing and the fuel truck during taxi, and his delay in signaling the lead marshaller to alert the pilot to stop the aircraft prior to impact. Factors contributing to the incident…NTSB SEA97LA039Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Friday Harbor, WAfailure of the engine (powerplant) for undetermined reason(s). A factor relating to the accident include: being over water at the time of power failure.NTSB SEA97LA038Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Spokane, WAThe failure of the pilots of both airplanes to see and avoid each other. A factor contributing to the accident was the Cessna's pilot diverted attention.NTSB SEA97LA054Accident · No injuriesLimited investigationFinal reportCessna 182M · Vancouver, WAThe pilot-in-command's touchdown with an excessive rate of descent. Factors included gusty crossiwnds.NTSB SEA97LA030Accident · No injuriesLimited investigationFinal reportCessna 421B · Olympia, WAinoperative deicing equipment, due to multiple wing boot holes and malfunctioning control/shuttle valves; subsequent build-up of airframe (wing) ice; and failure of the pilot to maintain adequate airspeed during the flare for landing. Factors relating to the…