NTSB investigations, 2004, WA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 year(c.\"eventDate\") = 2004
    AND 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.

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.May 13, 2004 · N1829P · Substantial damageNTSB 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…May 10, 2004 · N54477 · Substantial damageNTSB SEA04LA078Accident · No injuriesLimited investigationFinal reportRobinson R-22 Mariner · Chehalis, WAA loss of engine power for undetermined reasons.May 6, 2004 · N6291T · Substantial damageNTSB 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.Apr 29, 2004 · N7631K · Substantial damageNTSB 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.Apr 17, 2004 · N127DD · Substantial damageNTSB 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.Apr 10, 2004 · N14026 · Substantial damageNTSB 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.Apr 2, 2004 · N65914 · Substantial damageNTSB 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.Apr 2, 2004 · N161D · 2 aircraft · Substantial damageNTSB 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.Apr 1, 2004 · N284DM · Substantial damageNTSB 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…Mar 29, 2004 · N65ZA · Substantial damageNTSB 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.Mar 26, 2004 · N8420V · Substantial damageNTSB 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.Mar 25, 2004 · N731YZ · Substantial damageNTSB 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.Mar 21, 2004 · N3950S · Substantial damageNTSB 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.Mar 21, 2004 · N200TZ · Substantial damageNTSB 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.Mar 14, 2004 · N65675 · Substantial damageNTSB SEA04LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Eltopia, WARemedial action delayed during the takeoff roll. Factors include rough/uneven terrain.Mar 14, 2004 · N1883V · Substantial damageNTSB 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.Mar 10, 2004 · N7362X · Substantial damageNTSB 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.Mar 3, 2004 · N75844 · Substantial damageNTSB 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.Mar 1, 2004 · N2534V · DestroyedNTSB 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…Feb 24, 2004 · N368SW · No damageNTSB SEA04LA043Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Liberty, WAThe failure of the tail rotor slider lugs due to fatigue while the helicopter was maneuvering.Feb 23, 2004 · N6257P · Substantial damageNTSB 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.Feb 20, 2004 · N5559G · Substantial damageNTSB 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…Jan 19, 2004 · C-GTAQ · No damageNTSB 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.Jan 14, 2004 · N185WB · Substantial damageNTSB 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.Jan 13, 2004 · N64ML · Substantial damage