NTSB investigations, 2003, 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\") = 2003
    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 SEA03LA080Accident · No injuriesLimited investigationFinal reportAllen SA-300 · Yakima, WADirectional control was not maintained during the landing roll. A steering spring disconnected as a result of a tailwheel shimmy was a factor.May 9, 2003 · N147DA · Substantial damageNTSB SEA03LA078Accident · No injuriesLimited investigationFinal reportBeech F-35 · Anacortes, WAThe pilot's inadvertent selection of the incorrect fuel tank selector position (OFF) while in cruise flight over open water, and his failure to activate the fuel wobble-pump. A contributing factor was the unsuitable terrain.May 8, 2003 · N5030B · DestroyedNTSB SEA03LA075Accident · Minor injuriesLimited investigationFinal reportDeJager RV-6 · Bellingham, WAThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power.Apr 29, 2003 · N239D · Substantial damageNTSB SEA03LA073Accident · No injuriesLimited investigationFinal reportPilatus B4-PC11AF · Enumclaw, WAThe pilot's failure to maintain directional control. Contributing factors were the crosswind/tailwind conditions and the trees which the glider impacted.Apr 27, 2003 · N159AS · Substantial damageNTSB SEA03LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Pasco, WAThe pilot's inadequate remedial action when his aircraft began to veer during the landing roll, and his ultimate failure to maintain directional control which resulted in a ground loop. Factors include the pilot's momentary diversion of his attention during…Apr 27, 2003 · N180MK · Substantial damageNTSB SEA03LA072Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Ephrata, WAThe pilot's failure to maintain aircraft control while on final approach for landing. Low airspeed was a factor.Apr 26, 2003 · N3839 · Substantial damageNTSB SEA03LA076Accident · No injuriesLimited investigationFinal reportFokker F27MK 600 · Port Townsend, WAThe failure of the accessory drive shaft due to deterioration of bearing number 1 in the aft fork of the universal joint for undetermined reasons during cruise flight.Apr 17, 2003 · N730FE · Substantial damageNTSB SEA03FA165Accident · 2 fatalField investigationFinal reportCessna 320D · Mazama, WAThe pilot's failure to maintain clearance from terrain while maneuvering. Mountainous terrain, trees and mountain obscuration were factors.Apr 17, 2003 · N4178T · Substantial damageNTSB SEA03LA061Accident · No injuriesLimited investigationFinal reportAvia Stroitel AC-5M · Richland, WAThe pilot's failure to maintain airspeed and the failure of the propeller drive assembly. A factor contributing to the accident was the inadvertent stall.Apr 12, 2003 · N125MZ · Substantial damageNTSB SEA03LA058Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe entanglement of the fuel quantity sender float in the start pump wiring within the fuel tank as a result of the wiring not being properly secured. This rendered the fuel gauge inaccurate and the low fuel warning light inoperative which led to fuel…Apr 7, 2003 · N5225C · Substantial damageNTSB SEA03LA054Accident · No injuriesLimited investigationFinal reportCessna T210L · Gig Harbor, WAA total loss of power for undetermined reasons during base turn.Apr 2, 2003 · N701TM · Substantial damageNTSB SEA03LA052Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Mabton, WAA partial loss of power, for undetermined reasons, during a shallow approach, that ultimately lead to a situation where the pilot found it necessary to attempt a forced landing while the helicopter was moving slightly sideways. Factors include rough/uneven…Mar 30, 2003 · N2629Z · Substantial damageNTSB SEA03LA050Accident · No injuriesLimited investigationFinal reportHiperlight SNS-8 · South Prairie, WAThe failure of the pilot to maintain control of the aircraft during the crosswind turn resulting in an inadvertent spin entry, followed by his intentional stall to a landing resulting in a hard landing and subsequent nose over.Mar 25, 2003 · UNREG · Substantial damageNTSB SEA03LA049Accident · No injuriesLimited investigationFinal reportCessna 172G · Packwood, WALoss of partial engine power for undetermined reasons during the initial climb after takeoff. Loose gravel/sandy was a factor during the landing roll.Mar 24, 2003 · N4150L · Substantial damageNTSB SEA03IA046Incident · No injuriesIncident investigationFinal reportBoeing DC-9-82 · 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 sunglare from the wet paved surfaces, and a visual illusion created by the airport surface…Mar 15, 2003 · N298AA · No damageNTSB SEA03FA041Accident · 2 fatalField investigationFinal reportGrubert KIS TRI-R TR-1 · Puyallup, WAThe pilot-in-command's failure to maintain adequate flying airspeed during the turn from crosswind to downwind resulting in an inadvertent stall/spin and subsequent collision with terrain (ground).Feb 24, 2003 · N23KS · DestroyedNTSB SEA03LA037Accident · No injuriesLimited investigationFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain adequate airspeed and the instructor's inadequate supervision of the flight. Contributing factors were the rime icing conditions, and the soft terrain encountered on the off runway rollout.Feb 9, 2003 · N912LB · Substantial damageNTSB SEA03LA034Accident · No injuriesLimited investigationFinal reportBeech E18S · Burlington, WAThe pilot's failure to adequately remove ice/frost from the aircraft and to maintain airspeed during the initial climb after takeoff. An inadequate preflight was a factor.Feb 4, 2003 · N48K · Substantial damageNTSB SEA03LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Prosser, WAImproper flare while landing. Factors include rough uneven terrain.Feb 1, 2003 · N75392 · Substantial damageNTSB SEA03LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Ellensburg, WAAircraft control was not maintained during the landing roll. A tailwind and a snow bank were factors.Jan 28, 2003 · N48769 · Substantial damageNTSB SEA03FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Eastsound, WAThe pilot's failure to maintain clearance from the water and his failure to reset the altimeter to the local barometric pressure. Contributing factors were fog and night conditions.Jan 19, 2003 · N7282C · DestroyedNTSB SEA03LA027Accident · No injuriesLimited investigationFinal reportClassic Fighter Industries ME-262 Reproduction · Everett, WAFailure of the left main gear hydraulic actuator locking slide during landing. Factors include an embankment adjacent to the landing runway.Jan 17, 2003 · N262AZ · Substantial damageNTSB SEA03FA026Accident · No injuriesField investigationFinal reportCessna 172K · Gig Harbor, WAThe loss of engine power in the climb due to the fracture of the number seven engine crankshaft cheek due to the propagation of a fatigue crack initiation point. Factors include a vehicle pulling onto the road that the pilot selected for his forced emergency…Jan 14, 2003 · N1909V · Substantial damageNTSB SEA03FA025Accident · No injuriesField investigationFinal reportMooney M20F · Tacoma, WAA loss of engine power during cruise flight due to fatigue failure of the crankshaft as a result of an inadequate quality of material during the manufacturing process. Trees were a factor.Jan 12, 2003 · N6442Q · Substantial damage