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 SEA00LA179Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAThe Cessna 172 pilot's failure to maintain clearance with the Cessna 182. Factors included aircraft parked/standing on the taxiway and the refueling area, and a congested/confined taxiway.NTSB SEA00LA177Accident · No injuriesLimited investigationFinal reportCessna 172P · Auburn, WADamage to aircraft under unknown circumstances.NTSB SEA00LA175Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Wapato, WAThe pilot's failure to maintain clearance from the trees off the approach end of the runway, and his delay of the remedial action that would have allowed him to clear the trees. Factors include the pilot's failure to maintain a proper glidepath, trees off the…NTSB SEA00LA171Accident · No injuriesLimited investigationFinal reportCessna 180H · Roche Harbor, WAThe pilot's failure to adequately compensate for wind conditions during landing.NTSB SEA00LA197Accident · No injuriesLimited investigationFinal reportBell 206BII · Newhalem, WADebonding between the elastomeric material and the center plate of the transmission isolation mount.NTSB SEA00LA169Accident · Serious injuriesLimited investigationFinal reportClearwaters RAF 2000 · Leahy, WAA loss of control for undetermined reasons.NTSB SEA00LA137Accident · No injuriesLimited investigationFinal reportBeaver Ferguson F-II · Benton City, WAThe pilot's failure to approach the strip with adequate airspeed for the conditions (resulting in a stall/mush situation), and his failure to maintain adequate altitude and/or clearance above a power line on the approach path. Factors included crosswind…NTSB SEA00LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Snohomish, WAThe right main landing gear failed for undetermined reasons.NTSB SEA00LA129Accident · Serious injuriesLimited investigationFinal reportKaman K-1200 · Cusick, WAThe termination of power to the main rotor system as a result of the malfunction of the free-wheeling sprag clutch assembly, followed by the torsional overload separation of the engine adapter shaft. Factors include trees in the area where the emergency…NTSB SEA00FA132Accident · 3 fatalField investigationFinal reportCessna 180F · Gold Bar, WAThe non-instrument rated pilot's attempted VFR flight in instrument meteorological conditions. Contributing factors were mountainous terrain and cloud, low ceiling and obscuration conditions.NTSB SEA00LA119Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kennewick, WAA failure in the engine's number 1 piston, resulting in a total loss of engine power. Factors included the aircraft windshield being covered with oil (restricting forward visibility), a road sign, and a ditch beside the road on which the forced landing was…NTSB SEA00LA116Accident · Serious injuriesLimited investigationFinal reportDavis/Crouch Avid MK IV · Concrete, WAFracture of the engine's #1 connecting rod, resulting in a total loss of engine power. Factors were an engine overheat condition experienced at an undetermined time, and no suitable terrain for a forced landing.NTSB SEA00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ephrata, WAThe pilot-in-command's failure to maintain directional control during landing roll.NTSB SEA00LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Vancouver, WAThe pilot's failure to determine the aircraft's airworthiness before flight, resulting in operation of the aircraft in an unairworthy condition and consequent fuel starvation, and his subsequent failure to maintain adequate airspeed in an emergency turn back…NTSB SEA00IA108Incident · No injuriesIncident investigationFinal reportDouglas DC-8-73 · Seattle, WAAuxiliary hydraulic pump leak resulting in a failure of the hydraulic system.NTSB SEA00LA105Accident · No injuriesLimited investigationFinal reportSchmidt SEA REY · Northport, WAThe pilot's loss of directional control due to his inadequate remedial action in correcting for engine torque during the aborted landing. Factors include trees near the area where the pilot was attempting to land.NTSB SEA00LA103Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Kennewick, WAThe pilot's exceedance of the helicopter's hovering capabilities in a downwind hover. Factors included tailwind conditions, the pilot's lack of experience in the type of operation being conducted, and trees in the area where the helicopter settled.NTSB SEA00LA101Accident · Minor injuriesLimited investigationFinal reportBell 206B · Bridgeport, WAAircraft control was not maintained. Inadequate remedial action and diverted attention were factors.NTSB SEA00LA099Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilots failure to maintain clearance from power transmission lines.NTSB SEA00LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Quinault, WAFuel starvation due to the pilot's failure to position the fuel selector valve to the proper/correct position while switching fuel tanks. Factors include unreliable fuel selector valve position detents, having no suitable terrain in which to execute a forced…NTSB SEA00LA096Accident · No injuriesLimited investigationFinal reportAS+ AS-4 · Ephrata, WAThe pilot's improper in-flight decision by not immediately seeking a safe landing site upon encountering the sink. A factor was the high vegetation (sagebrush).NTSB SEA00LA094Accident · No injuriesLimited investigationFinal reportBoeing 767-200 · Seattle, WAThe failure of the B-767 flight crew to ensure their aircraft's jet blast was not a hazard to the Cessna. A factor for the Cessna was the B-767 moving on the taxiway. A factor for the B-767 was the Cessna standing in the runup area. A factor for both aircraft…NTSB SEA00LA089Accident · Serious injuriesLimited investigationFinal reportGifford TR-4 · Wenatchee, WAThe pilot's improper decision to attempt to close the canopy (entry door) after it inadvertently opened in flight, instead of making a precautionary landing with it open. Factors include the pilot's failure to follow all items on the checklist, his failure to…NTSB SEA00LA088Accident · Minor injuriesLimited investigationFinal reportAvions Mudry et Cie CAP 231 · Ephrata, WAThe pilot's failure to maintain aircraft control subsequent to the aircraft's canopy opening in flight. Factors include the pilot's failure confirm that the aircraft's canopy was secured prior to takeoff and impaired vision.NTSB SEA00LA082Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Ephrata, WALoss of engine power due to failure of the number three cylinder exhaust valve push rod. Soft terrain encountered during the landing roll-out was a factor.NTSB SEA00LA083Accident · No injuriesLimited investigationFinal reportde Havilland U-6A · Kenmore, WAThe pilot's failure to maintain control of the aircraft during the landing roll. Contributing factors were the power wave created by the nearby yacht, the rough water conditions, and the pilot's loss of visual contact with the wave during the rollout.NTSB SEA00LA071Accident · No injuriesLimited investigationFinal reportCessna 150H · Lopez Island, WAProper touchdown point not attained by the pilot. Factors include excessive speed at touchdown, a wet runway, a fence, and the pilot's inadvertent flight into IMC.NTSB SEA00LA070Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Auburn, WAThe pilot's failure to follow aircraft operating procedures by not raising the flaps during the go-around maneuver. Contributing factors were the pilot's failure to adhere to the balked landing checklist (FLAPS to 20) resulting in degraded climb performance,…NTSB SEA00LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe pilot's failure to attain proper alignment with the landing runway, and her failure to maintain proper glide path for the landing runway, resulting in an encounter with vortex turbulence from a preceding heavy aircraft landing on a parallel runway and…NTSB SEA00IA069Incident · No injuriesIncident investigationFinal reportCessna 182P · Tacoma, WAFlap attachment failure. Restricted movement of the aileron was a factor.NTSB SEA00LA065Accident · No injuriesLimited investigationFinal reportAero Design Eleven 12 · Spokane, WACracking of the weld between the tailwheel stinger housing and longitudinal cross tube, resulting in separation of the tube/tail wheel assembly from the airframe.NTSB SEA00LA066Accident · No injuriesLimited investigationFinal reportBeech A200 · Seattle, WAThe pilot's failure to properly follow pre-takeoff checklists (resulting in the engine starters remaining engaged after engine start, generators not being activated, discharge of the aircraft battery and consequent total electrical failure during flight with…NTSB SEA00LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Silverdale, WAThe pilot's inadequate compensation for winds. Factors include gusty, shifting winds, crosswinds, and an earthen berm near the edge of the runway.NTSB SEA00IA062Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Seattle, WAContaminated air being ducted into the aircraft's cabin from the engine exhaust of a nearby ground power cart.NTSB SEA00FA061Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Stanwood, WAThe disengagement of the oil jet fitting from its threaded receptacle at the forward end of the engine crankshaft. This resulted in excessive oil within the clutch assembly, the subsequent slipping of the clutch, and ultimately the disengagement of the rotor…NTSB SEA00LA059Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WADisintegration of a lining of the right brake and subsequent lodging of brake lining debris between the brake housing and brake disc, resulting in seizure of the right brake. A factor was that directional control was not possible.NTSB SEA00IA057Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Seattle, WAAn oil leak from the aircraft's APU that subsequently contaminated the aircraft's environmental system.NTSB SEA00LA058Accident · No injuriesLimited investigationFinal reportCessna 170B · Lopez Island, WAThe pilot's failure to maintain aircraft control during landing. Contributing factors were the crosswind condition, gusts, and the pilot's overall lack of total (flight and tail wheel) experience.NTSB SEA00LA054Accident · No injuriesLimited investigationFinal reportCessna 172N · Quincy, WAFailure to maintain terrain clearance. Factors include mountainous/hilly terrain.NTSB SEA00IA050Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Seattle, WAThe flight crew's encounter with a suspicious device, which necessitated an emergency evacuation.NTSB SEA00LA049Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Townsend, WAThe pilot's failure to adequately compensate for changing wind conditions during the landing roll in a tailwheel-equipped aircraft. Factors include a variable, shifting wind that changed from a quartering headwind to a quartering tailwind just prior to the…NTSB SEA00LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Richland, WAFailure of a connecting rod for undetermined reasons. Factors include unsuitable terrain for the forced landing attempt.NTSB SEA00LA046Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-8-63F · Seattle, WAInadequate inspection of the number 1 and 2 engine cowls by company maintenance personnel and inadequate preflight inspection by the flight engineer, resulting in unsecured cowls separating from the aircraft during takeoff. A factor was unsecured number 1 and…NTSB SEA00LA045Accident · No injuriesLimited investigationFinal reportCessna 150H · Spangle, WAExhaustion of the fuel supply due to a leaking fuel tank system. Factors contributing to the accident were, inaccurate fuel quantity sensors, the lack of suitable terrain in the area of the forced landing, and a fence alongside the dirt upon which the pilot…NTSB SEA00LA043Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Kahlotus, WAThe pilot's failure to maintain sufficient altitude over, or clearance with, a barbed-wire fence. A factor was the fence.NTSB SEA00LA041Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Snohomish, WAThe pilot's improper decision to attempt a go-around, then attempt to stop on the wet grass. Factors include variable winds, the pilot's inadequate compensation for the winds conditions, his inadequate recovery from a bounced landing, wet grass along the side…NTSB SEA00LA036Accident · No injuriesLimited investigationFinal reportBeech D18S · Everett, WALoss of aircraft control during initial climb for undetermined reasons.NTSB SEA00FA037Accident · 1 fatalField investigationFinal reportCessna 150G · Marysville, WAFuel exhaustion due to the non-certificated 'pilot's' failure to determine the fuel quantity prior to takeoff. Factors include a dark night, and a non-iluminated electrical transmission wire strung across the highway upon which the pilot was attempting to…NTSB SEA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182S · Kennewick, WAThe pilot's decision to continue flight into known icing conditions, and his subsequent failure to maintain adequate airspeed on final approach, resulting in a hard landing. Factors included: icing conditions; the pilot's improper decision to continue to his…NTSB SEA00LA029Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Port Townsend, WACompensation for wind conditions was inadequate. Gusting wind conditions were a factor.