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 SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.NTSB SEA04LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Battle Ground, WAThe student pilot's misjudgment of distance and his failure to do a go-around. Also causal was the instructor's inadequate supervision of the flight. Factors include gusty crosswinds, the dual student's failure to adequately compensate for those winds, a wet…NTSB SEA04LA078Accident · No injuriesLimited investigationFinal reportRobinson R-22 Mariner · Chehalis, WAA loss of engine power for undetermined reasons.NTSB SEA04LA075Accident · No injuriesLimited investigationFinal reportPiper PA-20 · North Bend, WAThe pilot's failure to maintain aircraft control during the landing roll. A rough landing surface and tailwind gusts were factors.NTSB SEA04LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Everett, WAThe pilot's failure to maintain directional control of the aircraft as a result of a locked main gear brake during the landing roll. An inadvertent ground loop was a factor.NTSB SEA04CA068Accident · No injuriesData collectionFinal reportYakovlev Yak 54 · Friday Harbor, WAThe pilot's failure to properly align with the runway. Factors include rough/uneven terrain, inadequate preflight planning and diminished forward visibility.NTSB SEA04LA064Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Belliigham, WAThe failure of the pilot to select the proper touchdown point while conducting a forced landing. Factors included the #1 engine malfunction, the right propeller oil control valve leak, and the shallow subsurface terrain condition.NTSB SEA04LA063Accident · 1 fatalLimited investigationFinal reportGlasflugel STD Libelle 201B · Oso, WAThe pilot of the Glaser-Dirks (lead glider) failure to maintain clearance from the Glasflugel (trailing glider) resulting in a mid-air collision while maneuvering.NTSB SEA04LA062Accident · 1 fatalLimited investigationFinal reportDavenport RV-8F · College Place, WAA loss of engine power for undetermined reason(s) and the pilot's failure to maintain adequate flying airspeed during the forced landing. A contributing factor was the pilot's decision to attempt a turn at low altitude.NTSB SEA04LA066Accident · No injuriesLimited investigationFinal reportPZL Warzawa-Okecie PZL-104 Wilga 35A · Burlington, WAThe passenger's interference with flight controls during a go-around maneuver. Contributing to the accident were the passenger's anxiety/apprehension, the pilot's inadequate brief to the passenger about potential control interference, and the gusty wind…NTSB SEA04CA059Accident · No injuriesData collectionFinal reportRockwell S-2R · Mattawa, WACompensation for wind conditions not maintained. Factors include a tailwind and a rock pile adjacent to the runway.NTSB SEA04LA057Accident · No injuriesLimited investigationFinal reportCessna A188B · Palouse, WAThe pilot's decision to takeoff downwind resulting in his inability to achieve a positive climb rate and an in-flight collision with terrain. Factors contributing to the accident included the rising terrain and the tailwind condition.NTSB SEA04LA053Accident · No injuriesLimited investigationFinal reportCessna 172E · Raymond, WAThe pilot's failure to maintain directional control during the landing roll resulting in the aircraft nosing over. Incorrect remedial action and soft terrain were factors.NTSB SEA04CA054Accident · Minor injuriesData collectionFinal reportMenefee RAF Vari-Eze · Bremerton, WAFailure to maintain airspeed while on final approach resulting in a stall. Factors include a rough running engine for undetermined reasons and rough/uneven terrain.NTSB SEA04LA055Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Cusick, WAThe pilot's failure to adequately compensate for crosswind conditions and his failure to maintain proper alignment in the direction of landing during the touchdown portion of a water landing on a river. Factors include crosswind conditions.NTSB SEA04LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Eltopia, WARemedial action delayed during the takeoff roll. Factors include rough/uneven terrain.NTSB SEA04LA056Accident · No injuriesLimited investigationFinal reportCessna R182 · Bremerton, WAThe pilot's failure to maintain directional control which resulted in a loss of control and subsequent wing strike with terrain. A contributing factor was the soft terrain.NTSB SEA04LA048Accident · No injuriesLimited investigationFinal reportCessna 172N · Gig Harbor, WAThe pilot's failure to follow the published IFR procedure resulting in failure to maintain clearance from objects during an instrument approach. Trees and an inoperative glide slope receiver were factors.NTSB SEA04LA050Accident · 2 fatalLimited investigationFinal reportCessna 170 · Herron, WAThe failure of the left muffler while maneuvering, resulting in a carbon monoxide leak into the cabin rendering the pilot incapacitated, and the subsequent uncontrolled descent and impact with water.NTSB SEA04IA045Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Seattle, WAThe First Officer's misidentification of the parallel taxiway as the active runway, resulting in the need for a sidestep maneuver while on short final for a full-stop landing. Factors include sun-glare from wet paved surfaces, a visual illusion created by the…NTSB SEA04LA043Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Liberty, WAThe failure of the tail rotor slider lugs due to fatigue while the helicopter was maneuvering.NTSB SEA04LA042Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Longview, WAFuel exhaustion while maneuvering, as a result of the pilot's inadequate in-flight decision/planning, leading to his failure to refuel the airplane prior to running out of fuel. A ditch was a factor.NTSB SEA04IA035Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8 · Seattle, WAThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Factors include sun glare and shadows around the runway/taxiway environment, and visual illusions created by the…NTSB SEA04LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Deer Park, WAThe dual student pilot's failure to maintain directional control during the landing roll and the failure of the flight instructor to provide remedial action. A factor was snowbank.NTSB SEA04LA033Accident · No injuriesLimited investigationFinal reportCessna 172RG · Enumclaw, WAA loss of engine power while maneuvering due to the failure of the heads of six of the eight cam followers. Factors include the pilot's decision to keep the gear retracted during the forced landing, and the rough/uneven terrain.NTSB SEA04LA025Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Moclips, WAA sudden loss of engine power during hover for undetermined reasons.NTSB SEA04FA023Accident · 1 fatalField investigationFinal reportFairchild Swearingen SA227-AT · Spokane, WAThe pilot-in-command's failure to maintain proper glidepath alignment during an ILS approach in poor weather resulting in collision with trees and terrain. Contributing factors were the unreliable status of the primary (NAV 1) ILS receiver (leaving the pilot…NTSB SEA04LA017Accident · No injuriesLimited investigationFinal reportCessna 150C · Toledo, WAFailure of the main landing gear attachment during the landing roll. An inadequate maintenance modification was a factor.NTSB SEA04LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Kapowsin, WAThe loss of engine power for undetermined reasons. A contributing factor to the accident was the trees.NTSB SEA04LA015Accident · No injuriesLimited investigationFinal reportSchmitt Exec 162F · Prosser, WAThe student pilot's abrupt application of excessive collective and the flight instructor's inadequate supervision of the student. Contributing factors were the ditch and low rotor RPM.NTSB SEA04LA008Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Spanaway, WAThe pilot's misjudgment of distance and altitude resulting in an undershoot of the runway and collision with a fence. A fence was a factor in the accident.NTSB SEA04LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Trout Lake, WAThe failure of the pilot to maintain directional control of the aircraft during the landing roll. A factor was the wet runway.NTSB SEA04LA002Accident · No injuriesLimited investigationFinal reportCessna 172S · Seattle, WAImproper flare during the landing. Excessive airspeed and improper remedial action were factors.NTSB SEA04LA001Accident · Minor injuriesLimited investigationFinal reportCessna 340 · Blakely Island, WAThe pilot's inadequate compensation for downdrafts on final approach resulting in an excessive descent rate on short final. Factors include downdrafts off the approach end of the selected runway, and low clouds/fog.NTSB SEA03CA200Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Basin City, WAClearance not maintained while on short approach to the runway. A factor was the corn stalks near the runway.NTSB SEA03LA198Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cle Elum, WAAn undershoot due to the pilot's failure to maintain a proper glide path on final approach to landing. A factor was the gravel.NTSB SEA03LA197Accident · No injuriesLimited investigationFinal reportThompson Avid Flyer · Roche Harbor, WAA complete loss of power due to fuel starvation for undetermined reason(s).NTSB SEA03LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Bremerton, WAAircraft control was not maintained during the landing roll which resulted in the aircraft nosing over.NTSB SEA03LA201Accident · No injuriesLimited investigationFinal reportCessna 172S · Anacortes, WAThe pilot attempting to taxi the airplane with a known system deficiency. Factors include worn wheel brakes and a drainage ditch.NTSB SEA03LA186Accident · Serious injuriesLimited investigationFinal reportSchmidt Zodiac 601 XL · Sumner, WALoss of engine power during the initial climb. Factors include the in-flight collision with trees during the uncontrolled descent.NTSB SEA03LA170Accident · 1 fatalLimited investigationFinal reportAvid Magnum · Greenwater, WAThe pilot's failure to maintain aircraft control while manuevering for undetermined reasons.NTSB SEA03LA163Accident · No injuriesLimited investigationFinal reportSchulze Lancair 360 · Vancouver, WALoss of engine power for undetermined reasons during the initial climb. Collision with a vehicle during landing was a factor.NTSB SEA03LA154Accident · Serious injuriesLimited investigationFinal reportBollinger RV-6A · Wenatchee, WAFuel starvation following the separation of a purge valve assembly as a result of the builders failure to re-safety the face retaining/stop screw on the fuel vapor purge valve after the safety wire on the subject screw was removed in order to change the…NTSB SEA03GA153Accident · 1 fatalFinal reportKaman K-1200 · Keller, WACorrosion fatigue within the blade retention bolt bushing(s) of the main rotor blade grip resulting in fatigue, cracking and ultimate separation of the upper grip plate. The separation of the upper blade grip plate led to a dynamic imbalance within the rotor…NTSB SEA03LA156Accident · No injuriesLimited investigationFinal reportHughes 269C · Marblemount, WAThe partial failure of a magneto during hover taxi over water, leading to a forced landing in shallow water near the shoreline. Factors include the aircraft being over a lake at the time that the partial loss of power made it impossible to keep it airborne.NTSB SEA03LA151Accident · No injuriesLimited investigationFinal reportHughes 269C · Snohomish, WAThe dual students failure to maintain clearance from the terrain during the go-around from a simulated autorotational flare, and the instructor pilot's failure to take adequate remedial action to keep the dual student from allowing the aircraft to impact the…NTSB SEA03LA149Accident · No injuriesLimited investigationFinal reportCessna 182C · Cashmere, WAThe pilot in command's misjudgment of distance and speed, and his failure to execute a go-around. A contributing factor was the fence.NTSB SEA03FA148Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Tulalip, WAA loss of control for unknown reasons.NTSB SEA03FA147Accident · No injuriesField investigationFinal reportCessna Citation 525 · Coupeville, WAThe loss of airplane pitch control (trim runway and mistrim condition) resulting from a failure in the airplane's electric pitch trim system. Factors that contributed to the accident were the manufacturer's inadequate design of the pitch trim circuitry that…NTSB SEA03LA150Accident · No injuriesLimited investigationFinal reportCessna 185 · Sinclair Is., WAThe pilot's failure to maintain directional control while taxiing for takeoff. Factors contributing to the accident were the ditch and the fence.