NTSB investigations, 1964, WA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19632026
NTSB investigations, 1964, WA per year, 1963–2026: 4,814 cases
19631
1964110
1965131
1966140
1967159
1968125
1969116
1970118
197186
1972107
1973104
1974109
1975129
1976117
1977104
1978118
1979118
1980107
1981102
198295
1983101
198489
198573
1986100
198779
198880
198976
199078
199194
199279
199369
199467
199573
199665
199762
199867
199968
200067
200166
200266
200374
200475
200559
200649
200753
200858
200958
201051
201158
201254
201337
201447
201536
201632
201739
201847
201937
202028
202141
202235
202336
202429
202537
202629

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\") = 1964
    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 UNK65X1183Accident · Serious injuriesClosedPiper PA-28 · North Bend, WADec 29, 1964 · N5812W · Substantial damageNTSB UNK65X1036Accident · No injuriesClosedPiper J3 · Birch Bay, WADec 17, 1964 · N92145 · Substantial damageNTSB UNK65X0907Accident · No injuriesClosedCessna 310 · Everett, WADec 3, 1964 · N4818B · Substantial damageNTSB UNK65X0881Accident · 4 fatalClosedBeechcraft S35 · Tacoma, WANov 29, 1964 · N5723K · DestroyedNTSB UNK65X0866Accident · Minor injuriesClosedCessna 195 · Morris Lake, WANov 28, 1964 · CF-GGM · Substantial damageNTSB UNK65X0818Accident · No injuriesClosedCessna 172 · Mesa, WANov 24, 1964 · N7362T · DestroyedNTSB UNK65X0777Accident · Minor injuriesClosedN American F51D · Enumclaw, WANov 21, 1964 · N7715C · Substantial damageNTSB UNK65X0580Accident · No injuriesClosedCessna 172 · Ellensburg, WANov 6, 1964 · N7545X · DestroyedNTSB UNK65X0474Accident · Minor injuriesClosedCessna 150 · Medical Lake, WAOct 29, 1964 · N7942E · DestroyedNTSB UNK65X0423Accident · No injuriesClosedPiper PA28 · Spokane, WAOct 25, 1964 · N6241W · Substantial damageNTSB UNK65X0398Accident · No injuriesClosedCessna 170B · Mesa, WAOct 24, 1964 · N2599D · Substantial damageNTSB UNK65X0367Accident · No injuriesClosedBeech F35 · Ocean Shores, WAOct 22, 1964 · N4218B · Substantial damageNTSB UNK65X0348Accident · No injuriesClosedPiper PA30 · Everett, WAOct 20, 1964 · N7048Y · Substantial damageNTSB UNK65X0328Accident · Minor injuriesClosedSchweizer 222E · Issaquah, WAOct 18, 1964 · N2769R · No damageNTSB UNK65X0211Accident · No injuriesClosedCessna 140A · Wheeler, WAOct 9, 1964 · N4052A · Substantial damageNTSB UNK65X0186Accident · No injuriesClosedCessna 140 · Camas, WAOct 7, 1964 · N76645 · No damageNTSB UNK65X0181Accident · No injuriesClosedPiper PA20 · Yakima, WAOct 7, 1964 · N7754K · Substantial damageNTSB UNK65X0143Accident · No injuriesClosedLuscombe 8E · Selah, WAOct 4, 1964 · N2728K · Substantial damageNTSB UNK65X0132Accident · 2 fatalClosedPiper PA-18 · Waterville, WAOct 3, 1964 · N7221K · DestroyedNTSB UNK64X4197Accident · Minor injuriesClosedPiper PA22 · Lynden, WASep 28, 1964 · N2334A · Substantial damageNTSB UNK64X4170Accident · No injuriesClosedBeechcraft D35 · Puyallup, WASep 26, 1964 · N2988B · Substantial damageNTSB UNK64X4155Accident · No injuriesClosedRyan STA · Whidbey Is, WASep 26, 1964 · N18923 · Substantial damageNTSB UNK64X4083Accident · No injuriesClosedBeechcraft C35 · Kelso, WASep 21, 1964 · N1877D · Substantial damageNTSB UNK64X4065Accident · No injuriesClosedPiper J5 · Oak Harbor, WASep 20, 1964 · N35021 · Substantial damageNTSB UNK64X4064Accident · No injuriesClosedPiper PA28 · Chehalis, WASep 20, 1964 · N8518W · Substantial damageNTSB UNK64X4005Accident · No injuriesClosedNavy N3N · Chelan Falls, WASep 16, 1964 · N44920 · Substantial damageNTSB UNK64X4002Accident · Minor injuriesClosedBeechcraft M23 · Tacoma, WASep 16, 1964 · N8706M · DestroyedNTSB SEA65A0025Accident · 2 fatalClosedBeechcraft 35 · Granite Fals, WASep 16, 1964 · N3070V · DestroyedNTSB UNK64X3940Accident · Minor injuriesClosedPiper J2 · Mt Wash, WASep 12, 1964 · N17540 · Substantial damageNTSB UNK64X3920Accident · No injuriesClosedPiper PA12 · Inchelium, WASep 11, 1964 · N2505M · Substantial damageNTSB UNK64X3897Accident · Minor injuriesClosedCessna 172 · Snohomish, WASep 10, 1964 · N8945B · Substantial damageNTSB UNK64X3791Accident · No injuriesClosedPiper PA18A · Tonasket, WASep 5, 1964 · N1870A · Substantial damageNTSB UNK64X3784Accident · No injuriesClosedCessna 120 · Vancouver, WASep 5, 1964 · N1782N · Substantial damageNTSB UNK64X3780Accident · No injuriesClosedBell 47G2 · Manson, WASep 4, 1964 · N3794G · Substantial damageNTSB UNK64X3758Accident · 1 fatalClosedBoeing A75 · Quincy, WASep 3, 1964 · N49385 · 2 aircraft · Substantial damageNTSB UNK64X3694Accident · 1 fatalClosedBeechcraft B-35 · Keyport, WAAug 30, 1964 · N5030C · DestroyedNTSB UNK64X3693Accident · No injuriesClosedHughes 269A · Redondo, WAAug 30, 1964 · N8792F · DestroyedNTSB UNK64X3679Accident · 1 fatalClosedCessna 150 · Renton, WAAug 29, 1964 · N516RA · DestroyedNTSB UNK64X3600Accident · No injuriesClosedCessna 182 · Seattle, WAAug 26, 1964 · N7122E · Substantial damageNTSB UNK64X3572Accident · No injuriesClosedCessna 140 · Tacoma, WAAug 24, 1964 · N3624V · Substantial damageNTSB UNK64X3560Accident · No injuriesClosedPiper PA24 · Stuart Is, WAAug 23, 1964 · N5293P · Substantial damageNTSB UNK64X3477Accident · No injuriesClosedCessna 172 · Kelso, WAAug 19, 1964 · N7045T · Substantial damageNTSB UNK64X3408Accident · Serious injuriesClosedCallair A6 · Sunnyside, WAAug 15, 1964 · N9997G · DestroyedNTSB UNK64X3357Accident · Minor injuriesClosedGrumman G164 · Touchet, WAAug 13, 1964 · N10269 · Substantial damageNTSB UNK64X3334Accident · No injuriesClosedBeechcraft M35 · Tekoa, WAAug 11, 1964 · N9769R · Substantial damageNTSB UNK64X3330Accident · No injuriesClosedRepublic RC3 · Seattle, WAAug 11, 1964 · N6401K · DestroyedNTSB UNK64X3325Incident · No injuriesClosedBell B-47G2 · Monitor, WAAug 11, 1964 · N2483B · No damageNTSB UNK64X3204Accident · 1 fatalClosedMooney M20 · La Touche, WAAug 3, 1964 · N5294B · DestroyedNTSB UNK64X3176Accident · No injuriesClosedBeechcraft D35 · Lind, WAAug 2, 1964 · N2979F · Substantial damageNTSB UNK64X3038Accident · Minor injuriesClosedAeronca 15AC · Spokane, WAJul 25, 1964 · N1326H · Substantial damage