NTSB investigations, WA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 SEA07LA011Accident · No injuriesLimited investigationFinal reportSorensen Searey · Marysville, WAThe pilot's failure to identify an unsafe condition (strong tidal currents) prior to a water landing, which resulted in the airplane nosing over when the pilot was unable to maintain aircraft control.NTSB SEA07FA006Accident · 1 fatalField investigationFinal reportRobinson R44 · Sumner, WAThe complete loss of engine power, for undetermined reasons, while on final approach, and the pilot's loss of control of the helicopter after the power loss. Factors include a lake below the final approach to the private landing pad.NTSB SEA07LA005Accident · Minor injuriesLimited investigationFinal reportHatcher Fisher Celebrity · Anacortes, WAA loss of engine power during takeoff for undetermined reasons.NTSB SEA07CA003Accident · No injuriesData collectionFinal reportCessna T182T · Spokane, WAThe pilot's excessive braking which resulted in a loss of aircraft control during the landing roll. A taxiway sign was a factor.NTSB SEA07LA001Accident · Minor injuriesLimited investigationFinal reportOneil Oneil Glassair II-S · Richland, WALoss of partial engine power for undetermined reasons during the initial climb after takeoff. Trees were a factor during the landing roll.NTSB SEA06CA189Accident · Minor injuriesData collectionFinal reportNorthwing Apache Sport · Brewster, WAThe pilot's failure to maintain control of the aircraft during the landing, resulting in its impact with terrain. A factor was the wind gust condition.NTSB SEA06CA177Accident · No injuriesData collectionFinal reportCessna 182RG · Shelton, WAThe pilot's failure to extend the landing gear prior to a practice soft-field landing, and the certified flight instructor's failure to take remedial action. Factors include the pilot's failure to use a checklist.NTSB SEA06LA172Accident · No injuriesLimited investigationFinal reportMooney M20C · Eastsound, WAThe pilot's failure to maintain airspeed during final approach resulting in an inadvertent stall and hard landing.NTSB SEA06CA170Accident · No injuriesData collectionFinal reportPiper PA-22-20-150 · Auburn, WAThe flight instructor's delayed remedial action during the landing roll in response to the student's loss of directional control, which resulted in a ground loop. A factor associated with the accident was the student's failure to maintain directional control.NTSB SEA06LA166Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Auburn, WAThe failure of the landing gear's normal retraction/extension assembly due to an overload condition.NTSB SEA06LA162Accident · 1 fatalLimited investigationFinal reportKaman HH-43F · Metaline Falls, WAThe failure of the left-hand cross-shaft input internal spline while the helicopter was in a hover, which resulted in the loss of gear box timing, in-flight blade contact and separation, and the subsequent loss of control and impact with a log deck.NTSB SEA06CA171Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Greenacres, WAThe pilot's selection of an unsuitable landing runway which resulted in a runway overrun and collision with a fence. A contributing factor was the wet runway condition.NTSB SEA06CA157Accident · No injuriesData collectionFinal reportPiggott Bearhawk · Port Angeles, WAThe loss of directional control as a result of the disconnected tail wheel steering system, which led to an inadvertent ground loop during the landing roll.NTSB SEA06CA149Accident · No injuriesData collectionFinal reportMaule M-7-235C · Auburn, WAThe loss of directional control [not possible] during landing roll as a result of the disconnected tail wheel steering assembly [for undetermined reasons], which led to an inadvertent ground loop during the landing roll.NTSB SEA06CA145Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Lamont, WAThe pilot's failure to maintain terrain clearance while maneuvering.NTSB SEA06FA139Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Easton, WAThe loss of power in both engines for undetermined reasons while in cruise flight, leading to an attempted forced landing. Factors include unfavorable winds at the site of the forced landing, and trees off the approach end of the grass runway the pilot was…NTSB SEA06CA143Accident · No injuriesData collectionFinal reportRolladen-Schneider LS3A · Enumclaw, WAThe glider pilot's failure to maintain directional control during the landing roll, resulting in the aircraft impacting the dirt embankment on the side of the emergency run-out area. Factors include the pilot's improper decision not to deploy more airbrakes…NTSB SEA06LA133Accident · No injuriesLimited investigationFinal reportNanchang China CJ-6 · Brewster, WAThe failure of the engine's three planetary gears for undetermined reasons. A factor contributing to the accident was the tree orchard.NTSB SEA06LA134Accident · 3 fatalLimited investigationFinal reportTaylor Royal T · Davenport, WAThe pilot's failure to maintain aircraft control while maneuvering, resulting in a collision with terrain.NTSB SEA06LA130Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Snohomish, WAThe loss of engine power for undertermined reasons. Conditions for carburetor icing were present at the time of the accident. Factors included the fence and the berm.NTSB SEA06CA131Accident · No injuriesData collectionFinal reportCessna 177A · Olympia, WAThe pilot's inadequate recovery from a bounced landing which resulted in a hard landing.NTSB SEA06CA127Accident · No injuriesData collectionFinal reportCessna 182K · Center Island, WADistance/speed misjudged by the pilot during landing. Rough uneven terrain was a factor.NTSB SEA06CA122Accident · Minor injuriesData collectionFinal reportCessna 150K · Shelton, WAThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. Compensation for weather (head winds), and trees were factors.NTSB SEA06LA112Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3T · Port Townsend, WAThe pilot's misjudgment of the airplane's height above the water during a precautionary landing which resulted in a hard landing. Contributing factors were glassy water conditions, fog, and the pilot's inadvertent VFR flight into IMC.NTSB SEA06CA101Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Vaughn, WAThe loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06LA100Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Battle Ground, WAthe pilot's excessive airspeed and exceeding the proper touchdown point during landing, which resulted in a hard landing and subsequent overrun of the runway. Factors contributing to the accident included the fence, the trees and the pilot's failure to…NTSB SEA06CA091Accident · No injuriesData collectionFinal reportMurphy Renegade · Port Angeles, WAThe loss of engine power while in cruise flight for undetermined reasons. Trees were a factor.NTSB SEA06CA086Accident · No injuriesData collectionFinal reportSchmidt RV7A · Northport, WAThe pilot's failure to maintain directional control during the landing flare/touchdown. Factors contributing to the accident included the gusty wind and soft terrain conditions which resulted in the aircraft nosing over during the landing roll.NTSB SEA06CA078Accident · No injuriesData collectionFinal reportCessna 170B · Shelton, WAThe main landing gear wheel failure during the takeoff ground roll. A related factor was directional control of the aircraft was not possible after the wheel failure.NTSB SEA06TA071Accident · No injuriesFinal reportBell 206B · Sprague, WAThe pilot's failure to maintain clearance from mountainous terrain while maneuvering. Mountainous terrain was a factor.NTSB SEA06LA064Accident · No injuriesLimited investigationFinal reportSessi Midget Mustang SK-1 · Everett, WAThe pilot did not abort the takeoff and subsequently did not maintain aircraft control during the initial takeoff climb. The installation of the wrong propeller assembly and inadequate maintenance were factors.NTSB SEA06FA055Accident · 2 fatalField investigationFinal reportCessna 182P · Goldendale, WAThe pilot's failure to maintain terrain clearance during descent. Factors contributing to the accident were the high mountains, mountain obscuration, the dark night condition, and the pilot's improper in-flight planning/decision making.NTSB SEA06FA054Accident · 1 fatalField investigationFinal reportBeech 58P · Bow, WAThe pilot's failure to maintain aircraft control during the climb to cruise. Contributing factors included a loss of engine power to the right engine folowing a turbocharger failure, instrument meteorological and dark night conditions.NTSB SEA06LA053Accident · Serious injuriesLimited investigationFinal reportCessna 150 · White Salmon, WAThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. Contributing factors were the inadequate preflight by the pilot, and the airplane's fuel contamination by water.NTSB SEA06CA051Accident · No injuriesData collectionFinal reportErcoupe 415-C · Arlington, WAThe pilot's excessive descent rate and his delay in taking action to reduce the descent rate which resulted in an in-flight collision with the runway during an emergency landing. Contributing factors were the total loss of engine oil pressure and the pilot's…NTSB SEA06LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WACarburetor heat was not used during the initial climb in probable serious carburetor icing conditions during cruise power. Carburetor icing conditions and wet terrain were factors.NTSB SEA06FA147Accident · 1 fatalField investigationFinal reportCessna 421C · Carson, WAThe pilot's failure to maintain aircraft control while maneuvering. Icing conditions, clouds and the pilot's continued flight into known adverse weather were factors.NTSB SEA06LA040Accident · No injuriesLimited investigationFinal reportHolscher KR II · McNeil Island, WAFuel exhaustion while in cruise flight due to inaccurate fuel quantity indications. Factors included the pilot's failure to positively determine the quantity of fuel onboard the aircraft during preflight, and rough, uneven grassy terrain at the location where…NTSB SEA06CA041Accident · No injuriesData collectionFinal reportCessna 172A · Othello, WAThe pilot's failure to maintain directional control during the takeoff roll. A factor was the berm.NTSB SEA06FA039Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Burlington, WAThe pilot's failure to maintain the published minimum descent altitude and not adhering to the published missed approach procedures, which resulted in an in-flight collision with trees and terrain. Factors contributing to the accident were low ceilings and…NTSB SEA06LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Kelso, WAEncounter with carburetor icing conditions while maneuvering for the downwind which resulted in a loss of engine power due to carburetor ice. The aircraft nosing over during the landing roll in soft sand was a factor.NTSB SEA06LA033Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe ground personnel baggage handler failed to maintain clearance from the aircraft with cargo handling equipment during ground operations and inadvertently damaged the airplane's pressure bulkhead which subsequently decompressed during climb to cruise.NTSB SEA06LA026Accident · Serious injuriesLimited investigationFinal reportHitchens EDI 90FT · Chehalis, WAThe pilot's loss of control of the aircraft for undetermined reasons while on a one-half mile straight-in VFR GPS final approach. Factors included his unsuccessful remedial action, and contact with the terrain in an open soft field.NTSB SEA06CA027Accident · Minor injuriesData collectionFinal reportCessna TP206A · Snohomish, WAThe pilot's higher than normal airspeed on landing which resulted in a runway overrun. Contributing factors were the fog and the wet runway surface.NTSB SEA06CA024Accident · No injuriesData collectionFinal reportCessna 210-5 · Lopez Island, WAThe pilot's failure to maintain adequate clearance from an airport sign during the visual approach. The sign was a factor in the accident.NTSB SEA06CA030Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Auburn, WAThe collapse of the left main landing gear after landing for undetermined reasons.NTSB SEA06LA021Accident · No injuriesLimited investigationFinal reportCessna 180 · Lopez, WAThe airline transport pilot, who was receiving recurrent training, failed to maintain aircraft control, which was followed by an inadvertent ground loop. A contributing factor was the inadequate supervision by the flight instructor.NTSB SEA06CA018Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Tacoma, WAThe collapse of the landing gear due to the pilot's failure to use the emergency gear extension system after his aircraft experienced a complete loss of electrical power. Factors include the malfunction of the voltage regulating system, which lead to the…NTSB SEA06FA015Accident · Minor injuriesField investigationFinal reportAgusta A109E · Olympia, WAThe pilot's improper positioning of the number 2 Power Flight Control switch and his inability to obtain the proper climb rate to clear a concrete wall barrier. Contributing factors included the checklist not being followed and the limit override switch not…NTSB SEA06CA014Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Yelm, WAThe complete loss of engine power during the initial climb for undetermined reasons, and the excessive descent rate during the ensuing forced landing.