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 SEA90LA087Accident · No injuriesLimited investigationFinal reportCessna 140 · Washougal, WAThe pilot's inadequate preflight inspection of the airplane, which allowed water to remain in the fuel system. Collision with a tree was a factor related to the accident.NTSB SEA90IA085Incident · Minor injuriesIncident investigationFinal reportFairchild SA227 · Olympia, WADue to an ice build-up departing the propeller and striking the cabin window.NTSB SEA90LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Bremerton, WAFailure of the tail rotor control for an undetermined reason.NTSB SEA90LA082Accident · No injuriesLimited investigationFinal reportRobert Van Scoyoc Soneria IIL · Ellensburg, WAThe loss of engine power due to carburetor icing, caused by the pilot's failure to apply carburetor heat. Factors in the accident were the carburetor icing weather conditions and the lack of suitable terrain for forced landing.NTSB SEA90LA081Accident · 1 fatalLimited investigationFinal reportHughes 369D · Kelso, WAFailure of the pilot to keep the external load clear of obstacles (trees). Factors related to the accident were: failure of the pilot and ground crewman to follow safety procedures, and the proximity of the trees.NTSB SEA90LA077Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Wenatchee, WAThe pilot's failure to maintain directional control during landing.NTSB SEA90LA075Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Pomeroy, WAA malfunctioning fuel injection system and the pilot's attempted operation above certificated maximum gross weight with a known deficiency in this equipment.NTSB SEA90LA070Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Port Orchard, WAImproper maintenance, and the installation of an improper carburetor. A factor related to the accident was the presence of trees and stumps in the emergency landing area.NTSB SEA90LA067Accident · Serious injuriesLimited investigationFinal reportBecker Bensen B8M · Burlington, WAThe pilot's failure to maintain clearance from the propeller.NTSB SEA90FA071Accident · 1 fatalField investigationFinal reportNorth American Navion H · Enumclaw, WAPilot's inadequate preflight planning, and inadvertent flight into IMC conditions. Factors in the accident were the low ceiling and visibility weather conditions, the mountainous/hill terrain, the pilot's lack of instrument qualification and his lack of…NTSB SEA90FA057Accident · 2 fatalField investigationFinal reportCessna 170 · Republic, WAImproper inspection and airworthiness certification of the aircraft on the last annual inspection by an FAA authorized repair station, the inadequate engine performance and low cylinder compression, and the pilots attempt to takeoff with known aircraft…NTSB SEA90TL#01Accident · No injuriesClass 3Final reportBell 206 · Cougar, WANTSB SEA90LA051Accident · No injuriesLimited investigationFinal reportCessna 150J · Graham, WALoss of engine power due to fuel exhaustion and inadequate remedial action after bouncing/ballooning during the forced landing. The pilot's inadequate preflight planning/preparation was a factor related to the accident.NTSB SEA90LA048Accident · Minor injuriesLimited investigationFinal reportBell BH-47G3B2 · Des Moines, WAPartial loss of engine power, cause undetermined. The aircraft was not recovered and examination of the engine was not possible.NTSB SEA90LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Vancouver, WAEngine loss of power was due to moisture damage to the coils in the magnetoes. During the forced landing in an open field, the airplane collided with a fence which resulted in substantial damage. The airplane had not undergone current maintenance inspections…NTSB SEA90IA042Incident · No injuriesIncident investigationFinal reportBoeing 747-446B · Everett, WAA break from pre-existing intergranular cracks which led to a fracture.NTSB SEA90LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Winthrop, WAWater contamination of the fuel and the pilot's inadequate preflight of the aircraft. Darkness and the obstructions in the emergency landing area were related factors.NTSB SEA90FA039Accident · 1 fatalField investigationFinal reportPiper PA28-180 · Castle Rock, WAThe pilot lost control of the airplane which entered a stall/spin that the pilot did not recover from.NTSB SEA90FA036Accident · 2 fatalField investigationFinal reportPiper PA-18 · Longmire, WAUndetermined.NTSB SEA90LA034Accident · No injuriesLimited investigationFinal reportCessna 177B · Friday Harbor, WAFailure of the pilot to attain the proper touchdown point or go-around. Factors related to the accident concerned the runway condition.NTSB DCA90MA011Accident · 6 fatalClass 1 · MajorFinal reportBritish Aerospace BAE-3101 · Pasco, WAThe flightcrew's decision to continue an unstabilized instrument landing system (ILS) approach that led to a stall, most likely of the horizontal stabilizer, and loss of control at low altitude. Contributing to the accident was the air traffic controller's…NTSB SEA90FA027Accident · 2 fatalField investigationFinal reportCessna 172N · Nordland, WAUndetermined.NTSB SEA90LA029Accident · No injuriesLimited investigationFinal reportAero Commander 600 S-2D · Walla Walla, WAAn engine loss of power for undetermined reasons. Contributing to the accident was the embankment.NTSB SEA90FA028Accident · 2 fatalField investigationFinal reportCessna 210-5 (205) · Rainier, WAContinued flight by the pilot into known adverse weather conditions, and his failure to maintain sufficient altitude/clearance from wooded mountainous terrain. Factors related to the accident were: darkness and the weather/terrain conditions.NTSB SEA90LA025Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Raymond, WALoss of engine power due to fatigue failure of the impeller. The helicopter was substantially damaged as a result of a roll-over on uneven terrain.NTSB SEA90LA024Accident · No injuriesLimited investigationFinal reportCessna A-185-F · Seattle, WAThe pilot did not maintain directional control of the airplane during the landing roll.NTSB SEA90FA021Accident · 2 fatalField investigationFinal reportBeech B35 · Bremerton, WAThe pilot's improper IFR procedure, his failure to maintain proper alignment on the ILS approach, and his failure to initiate a missed approached after reaching the lateral limits of the ILS system or decision height. Darkness and deteriorating weather were…NTSB SEA90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bremerton, WAFuel exhaustion and inadequate preflight planning.NTSB SEA90FA019Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Vancouver, WAThe pilot in command's inadequate preflight planning, pilot's attempted VFR flight into IMC conditions and the pilot's lack of instrument qualifications. Contributing to the accident was the low ceiling, fog and the pilot's lack of recent experience.NTSB SEA90LA018Accident · No injuriesLimited investigationFinal reportCessna 140 · Amboy, WALoss of engine power due to carburetor icing.NTSB SEA90LA017Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Vancouver, WAThe pilot's inadvertant leaning of the fuel mixture to near idle cutoff, causing the engine to quit.NTSB SEA90LA014Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot failed to adequately compensate for tailwind conditions when landing on a short wet runway.NTSB SEA90FA133Accident · 1 fatalField investigationFinal reportCessna 172M · Snoqualmie, WAIntentional flight into known adverse weather conditions and poor weather evaluation by the pilot.NTSB SEA90LA010Accident · No injuriesLimited investigationFinal reportHughes 369D · Neah Bay, WAFatigue failure of all four attachment studs of the tailrotor gearbox resulting in separation of the gear box, and inadequate maintenance inspection.NTSB SEA90FA005Accident · 1 fatalField investigationFinal reportHughes 369D · Bothell, WAThe pilot failed to determine weather conditions before the flight, his attempt to fly VFR in IMC, and his failure to maintain obstacle clearance altitude. Factors in the accident were the low ceiling, rain and fog weather conditions.NTSB SEA90FA002Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Cougar, WAContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude/clearance above mountainous terrain. The adverse weather and terrain were related factors.NTSB SEA89LA181Accident · No injuriesLimited investigationFinal reportCessna 152 · Alderwood Manor, WAInadequate compensation for wind conditions by the student pilot, and inadequate supervision by the instructor pilot (CFI), which resulted in a failure to maintain proper altitude. Factors related to the accident were: unfavorable (variable) wind, downdraft,…NTSB SEA89LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · East Sound, WAThe student pilot's failure to maintain directional control.NTSB SEA89LA175Accident · 1 fatalLimited investigationFinal reportBell 47G3B2 · Monitor, WAThe pilot failed to maintain aircraft separation from obstacles on the ground. A factor in the accident was the bright glare from the rising sun.NTSB SEA89LA174Accident · Serious injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Kapowsin, WAAn undetermined loss of engine power.NTSB SEA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAThe pilot's failure to obtain current in-flight wind information in order to calculate that his remaining fuel supply was adequate to reach his final destination. Contributing was his inadequate preflight planning.NTSB SEA89LA167Accident · No injuriesLimited investigationFinal reportRobinson R22 · Kent, WAThe instructor pilot's failure to take timely corrective action to recover from a low rotor RPM condition, resulting in impact with the ground.NTSB SEA89LA164Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lester, WAThe pilot's loss of control of the aircraft due to his improper use of the aircraft flight controls. Contributing factors in the accident were the moderate turbulence and trace mixed icing in clouds.NTSB SEA89LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Alderwood Manor, WAImproper planning/decision by the pilot. The tailwind and high obstructions were related factors.NTSB SEA89FA156Accident · 1 fatalField investigationFinal reportCessna TU206C · Skykomish, WAThe pilot's decision to continue the flight into IMC. The pilot did not adequately plan and prepare for the flight and was unable to maintain a proper altitude above the terrain for VMC. Fog was a related factor.NTSB SEA89FA155Accident · No injuriesField investigationFinal reportCessna 402B · Seattle, WAThe landing gear down lock mechanism failure.NTSB SEA89FA160Accident · 4 fatalField investigationFinal reportCessna 152 · Snohomish, WAThe pilot's failure to see and avoid N49231, a Cessna 172. Contributing factors were: a flight path directly into the setting sun, and the low light conditions of dusk on the ground below.NTSB SEA89LA149Accident · Serious injuriesLimited investigationFinal reportSwanson RV-4 · Carnation, WAThe pilot entered an inadvertent stall and hit trees while performing aerobatics.NTSB SEA89LA145Accident · No injuriesLimited investigationFinal reportCessna 177 · Fall City, WAThe pilot misjudged his landing flare and then did not properly recover from the resulting bounce.NTSB SEA89LA144Accident · No injuriesLimited investigationFinal reportRobinson R22 · Brinnon, WAThe pilot's inadequate in-flight planning. The helicopter skid contacted the water as a result of the pilot's misjudgement of clearance above the water.