Fatal NTSB investigations, 2002, 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, 2002, 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\") = 2002
    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 SEA03FA015Accident · 2 fatalField investigationFinal reportCaron Seawind · Bryant, WAA loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain.Nov 30, 2002 · N313FC · DestroyedNTSB SEA03FA013Accident · 2 fatalField investigationFinal reportCessna 172P · Malaga, WAThe pilot's attempted VFR flight into IMC resulting in the aircraft colliding with trees and up sloping terrain. Contributing factors were clouds, trees, and uphill terrain. The pilot’s performance and judgment were likely impaired by the effects of…Nov 26, 2002 · N65564 · DestroyedNTSB SEA02FA171Accident · 1 fatalField investigationFinal reportCessna 175B · Arlington, WAA partial loss of engine power for undetermined reasons during the initial climb, followed by the pilot's failure to maintain airspeed while maneuvering. Impairing drugs found in the pilot's system at the time of the accident were a factor.Sep 9, 2002 · N8195T · Substantial damageNTSB SEA02LA098Accident · 1 fatalLimited investigationFinal reportUnknown Quicksilver MX II · Cook, WAFailure to maintain aircraft control. High winds were a factor.Jun 9, 2002 · UNREG · Substantial damageNTSB SEA02FA027Accident · 1 fatalField investigationFinal reportCessna 150G · Ilwaco, WAA loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during a low altitude turn.Jan 13, 2002 · N2669J · Destroyed