Fatal 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 per year

19642026
Fatal NTSB investigations, 2003, WA per year, 1964–2026: 839 cases
196420
196513
196615
196713
196825
196920
197025
197117
197219
197316
197426
197523
197617
197730
197830
197922
198020
198123
198213
198324
198412
198521
198621
198713
198813
198918
199018
199118
199220
199310
199411
199517
199613
199710
199814
199912
20005
200110
20025
200312
200416
20058
20069
200712
200812
20095
20107
20117
20125
20131
20148
20159
20162
20174
20188
20198
20204
20214
20226
20234
20247
20255
20264

Latest cases

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'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 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…Nov 29, 2003 · N439AF · DestroyedNTSB SEA03LA170Accident · 1 fatalLimited investigationFinal reportAvid Magnum · Greenwater, WAThe pilot's failure to maintain aircraft control while manuevering for undetermined reasons.Aug 16, 2003 · N2054F · Substantial damageNTSB 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…Jul 26, 2003 · N314KA · DestroyedNTSB SEA03FA148Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Tulalip, WAA loss of control for unknown reasons.Jul 22, 2003 · N7190K · DestroyedNTSB SEA03FA124Accident · 1 fatalField investigationFinal reportBeech A36TC · East Wenatchee, WALoss of engine power due to fuel starvation that resulted from the right wing tank reaching an unusable fuel level. Also causal was an unapproved alteration of the aircraft’s fuel system. Contributing to the accident were the incorrect installation of an…Jul 4, 2003 · N279WP · Substantial damageNTSB SEA03FA121Accident · 1 fatalField investigationFinal reportLamb RV-4 · Vail, WAA loss of engine power due to the pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing factors were the non-operating (vandalized) runway lights, the pilot's delayed departure to his…Jun 29, 2003 · N6596X · Substantial damageNTSB SEA03FA106Accident · 1 fatalField investigationFinal reportDowner RC-3 · Yelm, WAThe failure of the pilot to abort the takeoff roll. Factors contributing to the accident included the failure of the aircraft to accelerate for undetermined reasons and the trees.Jun 17, 2003 · N6723K · DestroyedNTSB SEA03LA095Accident · 1 fatalLimited investigationFinal reportRans S-14 · Pasco, WAThe pilot's failure to maintain aircraft control while maneuvering. A physical impairment due to alcohol was a factor.Jun 6, 2003 · None · Substantial damageNTSB SEA03FA089Accident · 2 fatalField investigationFinal reportCessna 172 · Republic, WAThe pilot's failure to maintain airspeed resulting in a stall and subsequent loss of control during low altitude maneuvering.May 30, 2003 · N7301A · 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 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 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 · Destroyed