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 SEA08FA185Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Olalla, WAThe complete loss of engine power due to the accumulation of ice in the carburetor as a result of the pilot's failure to use carburetor heat.NTSB SEA08LA178Accident · 1 fatalLimited investigationFinal reportKolb Mark III · Richland, WAThe pilot's failure to maintain an adequate airspeed above stall speed while executing a steeply banked turn in the traffic pattern.NTSB SEA08CA177Accident · Minor injuriesData collectionFinal reportAnglin RV-6 · Puyallup, WAThe complete loss of engine power for undetermined reasons. Contributing to the accident were hidden obstructions (tree stumps) in the field of long grass within which the pilot executed his forced landing.NTSB SEA08CA176Accident · Minor injuriesData collectionFinal reportCessna 210E · Auburn, WAA catastrophic engine failure due to the partial blockage of the lubricating oil galley in one of the crankshaft connecting rod journals, leading to the failure of the connecting rod cap.NTSB SEA08CA172Accident · Serious injuriesData collectionFinal reportLyons Navajo HKS · Waterville, WAThe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was a microburst condition.NTSB SEA08CA171Accident · No injuriesData collectionFinal reportde Havilland Beaver DHC-2 MK.1 · Kenmore, WAThe pilot's failure to maintain aircraft control while water taxiing. Contributing to the accident were the pilot's failure to compensate for the wind condition and a tailwind.NTSB LAX08LA253Accident · 2 fatalLimited investigationFinal reportLong Lancair ES · Cliffdell, WAThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident was turbulence and clouds.NTSB LAX08FA246Accident · 3 fatalField investigationFinal reportCessna 172N · McMurray, WAThe pilot's improper decision to continue VFR flight into instrument meteorological weather conditions. Contributing to the accident were low ceilings, reduced visibility, and mountainous terrain.NTSB LAX08FA244Accident · 2 fatalField investigationFinal reportCessna A185F · Shelton, WAThe pilot's failure to attain and maintain adequate airspeed during initial climb, which resulted in an aerodynamic stall.NTSB LAX08CA247Accident · No injuriesData collectionFinal reportMooney M20K · Chehalis, WAThe pilot's failure to lower the landing gear, resulting in a gear up landing.NTSB SEA08CA163Accident · Minor injuriesData collectionFinal reportLet Blanik L-13 · Arlington, WAThe pilot's failure to maintain clearance from a tree while making an off-field landing in a glider. Contributing to the accident was the pilot's inadequate compensation for the gusting winds.NTSB LAX08CA234Accident · No injuriesData collectionFinal reportCessna 172M · Leavenworth, WAThe pilot's inadequate preflight planning and failure to attain a sufficient airspeed to continue the takeoff. A contributing factor was the high density altitude and short runway.NTSB LAX08CA225Accident · No injuriesData collectionFinal reportCessna 182J · Metaline Falls, WAThe pilot's misjudged altitude and distance, which resulted in the airplane's failure to attain the proper touchdown point and a landing overrun. Contributing to the accident were trees and the short runway.NTSB SEA08LA164Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik SportStar · Arlington, WAThe pilot's failure to maintain directional control of the airplane during the takeoff roll in gusty conditions.NTSB OPS08IA007Incident · No injuriesIncident investigationFinal reportBoeing 737-700 · Seattle, WAThe diverted attention during taxi of the flight crew in the other aircraft. Contributing to the incident was the air traffic control clearance was not followed by the flight crew of the other aircraft.NTSB LAX08CA216Accident · No injuriesData collectionFinal reportCessna 172M · Skykomish, WAThe pilot's inadequate in-flight planning/decision and failure to execute a go-around when the airplane floated during the flare. Contributing to the accident was the short and wet turf runway surface, which reduced braking action.NTSB SEA08CA151Accident · No injuriesData collectionFinal reportCessna T182T · Point Roberts, WAThe pilot's failure to maintain clearance from trees during a go-around. Contributing to the accident were the pilot inadvertently allowing the airplane to porpoise during the landing flare, and the presence of a tailwind.NTSB LAX08CA176Accident · No injuriesData collectionFinal reportClarke Colin Glastar · Wenatchee, WAThe pilot's failure to initiate a timely go-around after the first bounce.NTSB LAX08CA163Accident · No injuriesData collectionFinal reportCessna 172P · Bremerton, WAThe student pilot's inadequate recovery from a bounced landing.NTSB LAX08LA161Accident · Minor injuriesLimited investigationFinal reportDavison Vari Eze · Arlington, WAA loss of engine power for undetermined reasons.NTSB LAX08LA160Accident · 1 fatalLimited investigationFinal reportQuad City Ultralight Challenger LSS · Moses Lake, WAThe pilot's inability to maintain control due to an in-flight separation of the vertical fin as a result of the failure of the airplane's builder to properly secure the vertical fin to the fuselage.NTSB SEA08LA147Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Tacoma, WAThe collapse of the right main landing gear for undetermined reasons.NTSB SEA08LA139Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Chehalis, WAA loss of engine power due to fuel exhaustion caused by a missing fuel tank cap that allowed the fuel to be siphoned out. Also causal was the pilot's inadequate preflight inspection at the last airport.NTSB LAX08LA145Accident · No injuriesLimited investigationFinal reportBabcock KR-2 · Olympia, WAA total loss of engine power during takeoff due to the carburetor's mixture needle backing out.NTSB LAX08FA144Accident · 2 fatalField investigationFinal reportde Havilland DHC-2 MK I · Stehekin, WAThe pilot's failure to retract the landing gear wheels prior to performing a water landing. Contributing to the accident were the pilot's disabling of the landing gear warning/advisory system and possible fatigue due to his work schedule.NTSB SEA08LA127Accident · 1 fatalLimited investigationFinal reportThorp T-18 · Kent, WAThe loss of engine power for undetermined reasons. Contributing to the accident were the lack of a suitable landing area and the pilot's failure to maintain an adequate airspeed while maneuvering in response to the loss of engine power.NTSB SEA08CA122Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Nimbus-4M · Ephrata, WAThe pilot's inadequate preflight inspection and his failure to connect the left aileron control rod during assembly.NTSB SEA08LA120Accident · 2 fatalLimited investigationFinal reportYakovlev Yak 52 · Vancouver, WAThe pilot's failure to maintain an airspeed sufficient to avoid a stall during a low altitude aerobatic maneuver. Contributing to the accident was the low altitude at which the pilot initiated the maneuver.NTSB SEA08CA113Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Waitsburg, WAThe pilot's failure to maintain clearance from the terrain while maneuvering at low altitude. Contributing to the accident was the rising terrain.NTSB SEA08CA115Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Twisp, WAThe pilot's failure to maintain adequate clearance from a ground obstacle while taxiing.NTSB LAX08CA106Accident · No injuriesData collectionFinal reportMaule M-5-235C · Monroe, WAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing rollout.NTSB LAX08LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Concrete, WAA loss of engine power for undetermined reasons.NTSB LAX08CA110Accident · Serious injuriesData collectionFinal reportSnobird Charger · Toledo, WAThe pilot's improper use of the flight controls during takeoff.NTSB SEA08CA093Accident · Minor injuriesData collectionFinal reportGrumman G-164A · Dayton, WAThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed. A contributing factor was the sudden windshift.NTSB LAX08CA082Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilot's inadequate compensation for the wind conditions, failure to attain and maintain an adequate airspeed that resulted in a stall mush, and, the subsequent failure to maintain terrain and obstacle clearance during the takeoff initial climb.…NTSB LAX08CA087Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Bremerton, WAThe pilot's failure to maintain directional control while taxiing. A contributing factor was the control interference on the rudder pedals created by the pilot's footwear.NTSB LAX08LA059Accident · 2 fatalLimited investigationFinal reportMunson RV-6A · Stanwood, WAThe pilot's failure to maintain airspeed above stall (Vs) during an emergency landing that lead to a stall and uncontrolled descent. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB SEA08LA068Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Mukilteo, WALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was a power line.NTSB SEA08LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Centerville, WAA loss of engine power due to carburetor icing conditions and the failure of the pilot to use the correct amount of carburetor heat for the existing conditions.NTSB SEA08CA044Accident · No injuriesData collectionFinal reportCessna 182 · Spokane, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the fence.NTSB SEA08FA046Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Orting, WAThe pilot's failure to maintain clearance from trees while maneuvering. A contributing factor was the dark night.NTSB SEA08CA039Accident · No injuriesData collectionFinal reportPiper PA-18A-135 · Yelm, WAThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing roll. Contributing factors were the rough/uneven terrain and log.NTSB SEA08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tacoma, WAThe failure of both pilots to maintain an adequate visual lookout during cruise flight.NTSB SEA08LA020Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58+ · Cougar, WAThe pilot's failure to maintain clearance from a nearby tree while performing a hover-climb. Factors include his failure to maintain clearance from his long-line cable, and his likely diverted attention to the entanglement of the cable on the helicopter's…NTSB LAX08CA022Accident · No injuriesData collectionFinal reportBagnall Harold E Kitfox Lite 2 · N. Bonneville, WAThe pilot's failure to maintain an adequate airspeed while maneuvering at low altitude that resulted in a stall-mush condition and collision with the water.NTSB SEA08FA013Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Sequim, WAThe pilot's misjudged distance and altitude that led to an undershoot; his failure to maintain directional control during the landing roll; and his failure to maintain clearance from trees during an attempted aborted landing.NTSB LAX08MA007Accident · 10 fatalMajor investigationFinal reportCessna 208B · Naches, WAThe pilot's failure to maintain an adequate airspeed to avoid an aerodynamic stall while maneuvering. Contributing to the accident were the pilot's impaired physiological state due to hypoxia, the pilot's inadequate preflight weather evaluation, and his…NTSB LAX07CA287Accident · No injuriesData collectionFinal reportCessna 150L · Woodland, WAa partial loss of engine power due to carburetor icing conditions.NTSB SEA07FA262Accident · 3 fatalField investigationFinal reportBeech A-36TC · Burlington, WAThe pilot's decision to descend below the published minimum descent altitude (MDA), and his failure to maintain clearance from vertical objects during an instrument approach. Contributing to the accident were low ceilings, inadequate preflight planning, and…NTSB SEA07CA256Accident · Minor injuriesData collectionFinal reportRogerson Hiller RH-1100 · Stanwood, WAThe pilot's failure to execute a go-around and his failure to reduce his groundspeed to zero prior to touching down on the rough/uneven terrain. Factors include the momentary restriction of a flight control, rough/uneven terrain, and a tailwind.