NTSB investigations, WA
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 SEA93LA110Accident · No injuriesLimited investigationFinal reportCessna 210 · Palouse, WAThe pilot in command not maintaining directional control. A factor contributing to the accident was the control interference by the passenger.NTSB SEA93LA108Accident · No injuriesLimited investigationFinal reportGrove GR-2 · Buckley, WAThe pilot's premature liftoff. The pilot's failure to maintain directional control and the high vegetation beside the runway were factors.NTSB SEA93LA105Accident · 1 fatalLimited investigationFinal reportKaman HH-43F · Anatone, WAFatigue failure of the rotor transmission drive system, resulting from the improper certification/approval of the aircraft modification by the federal aviation administration.NTSB SEA93LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Kapowsin, WAAn undetermined loss of engine power.NTSB SEA93FA102Accident · 1 fatalField investigationFinal reportCessna 172C · Darrington, WAFuel exhaustion and the pilot in command's inadequate refueling of the aircraft.NTSB SEA93LA097Accident · No injuriesLimited investigationFinal reportCessna 182N · Anacortes, WAThe loss of control by the PIC when he selected the wrong runway, failed to attain the proper touchdown point, inadvertently stalled the acft attempting to abort the landing, and failed to maintain directional control after the aircraft mushed back onto the…NTSB SEA93FA094Accident · Serious injuriesField investigationFinal reportGrumman A6E · Steptoe, WAThe inherent limitations of the see-and-avoid concept of separation of aircraft operating under visual flight rules that precluded the crew of the A6E and the pilot of the agcat from recognizing a collision hazard and taking actions to avoid a midair…NTSB SEA93LA095Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS4A · Wenatchee, WAMisjudged weather evaluation. Factors include high winds encountered on approach.NTSB SEA93LA092Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BL-65 · Spokane, WAFailure of the number 4 cylinder exhaust valve seat and the inadvertent stalling of the aircraft by the pilot in command. Factors contributing to the accident were buildings and power lines.NTSB SEA93LA087Accident · No injuriesLimited investigationFinal reportCessna T210M · Scappose, WAClearance from objects was not maintained. The pilot's poor inflight planning and the weather conditions were factors.NTSB SEA93FA091Accident · 4 fatalField investigationFinal reportLake LA-4-200 · Gold Bar, WAThe pilot's failure to maintain adequate airspeed while maneuvering for a water landing.NTSB SEA93LA086Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Davenport, WAUnsuitable terrain was selected for landing. A factor to the accident was: soft terrain.NTSB SEA93LA085Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Walla Walla, WAA loss of engine power for undetermined reasons. The lack of a suitable landing area was a factor.NTSB SEA93LA081Accident · No injuriesLimited investigationFinal reportCessna U206F · Friday Harbor, WAThe improper use of flight controls by the pilot in command. Factors relating to the accident were the strong, tailwind weather conditions.NTSB SEA93LA079Accident · No injuriesLimited investigationFinal reportCessna 177 · Buena, WAThe pilot in command's failure to maintain directional control. Factors contributing to the accident were crosswinds and the fence.NTSB SEA93LA078Accident · No injuriesLimited investigationFinal reportSchweizer G-164B-600 · Quincy, WAUnsuitable terrain encountered during a forced landing after an engine cylinder assembly had separated. Factors include a snowbank.NTSB SEA93LA067Accident · No injuriesLimited investigationFinal reportBeech C-99 · Seattle, WAThe improper starting procedure by the pilot of the Aeronca. A factor contributing to the accident was inadequate communications by the pilot of the Aeronca.NTSB SEA93LA066Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Battleground, WAThe pilot in command's allowing the aircraft to enter a stall/spin condition. Factors contributing to the accident were a tailwind, power lines and trees.NTSB SEA93LA059Accident · No injuriesLimited investigationFinal reportCessna A185F · Inglewood, WAFuel exhaustion, the pilot in command's inadequate preflight, and his failure to flare on landing. A factor contributing to the accident was fog.NTSB SEA93FA046Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Lester, WAUndetermined.NTSB SEA93FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Aberdeen, WAThe pilot's failure to maintain proper altitude, and an inadequate visual lookout. Factors include weather below approach minimums, fog, drizzle, and a dark night.NTSB SEA93FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Marysville, WAThe design stress limits of the airframe were exceeded by the student pilot.NTSB SEA93FA026Accident · 6 fatalField investigationFinal reportBeech A60 · Snoqualmie Pass, WAFailure of the pilot to maintain control of the aircraft, his failure to prevent the aircraft from exceeding the never exceed speed (vne), and subsequent exceeding of the design stress limits of the aircraft. Factors related to the accident were: weather…NTSB SEA93LA024Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Vancouver, WAThe pilot's inability to see birds due to darkness.NTSB SEA93LA022Accident · No injuriesLimited investigationFinal reportCessna 210N · Spokane, WAThe pilot's premature retraction of the gear. Factors include a wet and icy runway.NTSB SEA93LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Olympia, WAThe pilot's poor inflight decision, and excessive airspeed on final. Factors include a wet turf runway, and trees adjacent to the runway.NTSB SEA93LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Lind, WAThe aircraft encountered rough terrain during the landing roll after the pilot elected to perform a precautionary landing in an open field, due to deteriorating weather.NTSB SEA93LA019Accident · No injuriesLimited investigationFinal reportBeech A35 · Vancouver, WADesign stress limits of the aircraft were exceeded.NTSB SEA93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spokane, WAInadequate preflight planning/preparation. Factors to the accident were: fuel exhaustion and inadequate fuel consumption calculations.NTSB SEA93FA002Accident · 4 fatalField investigationFinal reportBeech N35 · Burlington, WAThe failure of screws on the propeller hub during takeoff, the improper inflight decision by the pilot to return for landing, and the steep, excessive bank angle which resulted in a stall/spin and loss of control.NTSB SEA92LA216Accident · No injuriesLimited investigationFinal reportCessna 182L · Vancouver, WAThe partial loss of engine power from failure of the no 5 piston, and the soft terrain at the forced ldg site, resulting in collapse of the nose landing gear.NTSB SEA92LA212Accident · No injuriesLimited investigationFinal reportBeech E35 · Anacortes, WAThe pilot in command's failure to maintain directional control. A factor contributing to the accident was: the pilot in command's not extending the flaps for landing.NTSB SEA92LA211Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Blakely Island, WAThe removal of the control gust lock was not performed. Factors to the accident were: inadequate preflight, the checklist was not used, and the control gust lock marking flag was gone due to previous damage.NTSB SEA92LA209Accident · 2 fatalLimited investigationFinal reportAnderson Vans RV-6 · Puyallup, WAThe failure of the pilot to configure the acft for landing (lowering of flaps) and maintain airspeed above stall during final approach for landing.NTSB SEA92LA206Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Leavenworth, WAThe premature lift off by the pilot. Factors relating to the accident were the soft, rough turf airstrip and the high obstructions at the end of the runway.NTSB SEA92LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lopez, WAThe pilot's faiure to obtain proper assistance and to properly set the throttle.NTSB SEA92LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Packwood, WAThe improper in-flt planning and decision by the student pilot and his failure to maintain terrain clearance. Factors relating to the accident were the box canyon and the rising mountainous terrain.NTSB SEA92FA197Accident · 4 fatalField investigationFinal reportCessna 170A · Lopez, WAThe pilot's inadvertent stall/spin. Factors include gusty, unfavorable, high velocity winds, and turbulence.NTSB SEA92LA201Accident · No injuriesLimited investigationFinal reportCessna 140 · Vancouver, WAInadequate remedial action of the pilot in command (CFI). Factors include airspeed not being maintained by the student pilot, and rough/uneven terrain.NTSB SEA92FA195Accident · 3 fatalField investigationFinal reportSnodgrass Starduster TOO · Lacey, WAThe failure of both pilots to see and avoid each other.NTSB SEA92LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAInadequate visual lookout by the other pilot.NTSB SEA92LA199Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Bucoda, WAThe failure of the pilot to maintain proper alignment while landing on water, resulting in a swerve during deceleration.NTSB SEA92LA191Accident · No injuriesLimited investigationFinal reportHelio H-391B · Edmonds, WAThe partial loss of engine power when an exhaust valve seized in the open position and the water where the pilot was forced to land, which resulted in an acft nose over on touchdown.NTSB SEA92LA190Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Mattawa, WAThe inadvertent locking of the acft brakes while landing by the PIC, resulting in an acft nose over on the gravel strip.NTSB SEA92LA189Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Concrete, WAThe loss of engine power due to fuel exhaustion, resulting from the IMPR0PER in-flight planning by the pilot in command and his failure to select a proper touchdown point for an emergency forced landing. A factor relating to the accident was the uneven…NTSB SEA92LA188Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Snoqualmie, WAThe pilot's not maintaining control of the aircraft because of incapacitation resulting from both hypoglycemia/diet and loss of consciousness.NTSB SEA92LA184Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Mattawa, WALoss of engine power due to fuel contamination as a result of inadequate maintenance by the operator. A factor contributing to the accident was soft terrain.NTSB SEA92LA187Accident · No injuriesLimited investigationFinal reportCessna 182F · Alderwood Manor, WAThe pilot selected the wrong runway for wind conditions.NTSB SEA92LA183Accident · No injuriesLimited investigationFinal reportJohn S. Holzemer Rotorway Exec · Kirkland, WACyclic control movement was restricted. A factor to the accident was: directional control was not possible.NTSB SEA92LA172Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe pilot misjudged the landing flare. Factors include a lack of total pilot expereince.