NTSB investigations, 1973, 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, 1973, 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\") = 1973
    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 SEA74DYG22Accident · No injuriesClosedPiper PA-28 · Richland, WADec 31, 1973 · N2350T · Substantial damageNTSB SEA74AS028Accident · 2 fatalClosedCessna 182P · Kelso, WADec 30, 1973 · N58661 · DestroyedNTSB SEA74DYE32Accident · No injuriesClosedHiller UH-12E · Queets, WADec 28, 1973 · N28875 · DestroyedNTSB SEA74AS027Accident · 1 fatalClosedPiper PA-31 · Walla Walla, WADec 27, 1973 · N66798 · DestroyedNTSB SEA74AS026Accident · No injuriesClosedCessna 182 · Anacortes, WADec 21, 1973 · N1814X · DestroyedNTSB SEA74FYE31Accident · Serious injuriesClosedCessna 337A · Maynard, WADec 11, 1973 · N5313S · DestroyedNTSB SEA74DYE30Accident · No injuriesClosedCessna 182 · Tacoma, WADec 11, 1973 · N5501B · Substantial damageNTSB SEA74IS025Incident · No injuriesClosedBoeing 720A · Moses Lake, WADec 5, 1973 · N7225U · Minor damageNTSB SEA74DYE29Accident · No injuriesClosedCessna 180H · Tillacum, WADec 1, 1973 · N8237V · Substantial damageNTSB SEA74AYE28Accident · Serious injuriesClosedBeech A23-19 · Everett, WANov 30, 1973 · N8735M · Substantial damageNTSB SEA74AS024Accident · 2 fatalClosedCessna 210 · Quilcene, WANov 19, 1973 · N9550T · DestroyedNTSB SEA74DYE27Accident · No injuriesClosedCessna 172 · Morton, WANov 3, 1973 · N2132Y · Substantial damageNTSB SEA74AS023Accident · 2 fatalClosedPiper PA-28 · Wenatchee, WANov 3, 1973 · N5806U · DestroyedNTSB SEA74DYE26Accident · No injuriesClosedHiller Acft FH1100 · Centralia, WANov 1, 1973 · N750NH · Substantial damageNTSB SEA74DYE25Accident · No injuriesClosedBell 47G-3B · Forks, WANov 1, 1973 · N73918 · Substantial damageNTSB SEA74DYG18Accident · No injuriesClosedCessna 180H · Othello, WAOct 20, 1973 · N9020M · Substantial damageNTSB SEA74FYE23Accident · No injuriesClosedSikorsky S-58E · Alpental, WAOct 19, 1973 · N4382S · Substantial damageNTSB SEA74IS020Incident · Minor injuriesClosedDouglas DC-8 · Spokane, WAOct 18, 1973 · N4903C · Substantial damageNTSB SEA74DYE22Accident · No injuriesClosedPiper PA-24 · Renton, WAOct 18, 1973 · N9026P · Substantial damageNTSB SEA74DYE21Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WAOct 18, 1973 · N15627 · DestroyedNTSB SEA74DYE24Accident · No injuriesClosedLuscombe 8A · Auburn, WAOct 17, 1973 · N28461 · Substantial damageNTSB SEA74DYG19Accident · No injuriesClosedCessna 182H · Wenatchee, WAOct 16, 1973 · N2473X · Substantial damageNTSB SEA74AS019Accident · 1 fatalClosedPiper PA-28R · Tenino, WAOct 13, 1973 · N9456N · DestroyedNTSB SEA74DYE20Accident · No injuriesClosedBell 47F-2 · Forks, WAOct 8, 1973 · N5161B · Substantial damageNTSB SEA74DYG20Accident · No injuriesClosedMooney M20E · Prosser, WAOct 6, 1973 · N1335W · Substantial damageNTSB SEA74AYC20Accident · Serious injuriesClosedSorrell SNS-6 · Dallesport, WAOct 4, 1973 · N66S · Substantial damageNTSB SEA74DYE19Accident · No injuriesClosedHughes 269A · Forks, WASep 23, 1973 · N8763F · Substantial damageNTSB SEA74DYE18Accident · No injuriesClosedPiper PA-18 · Arlington, WASep 23, 1973 · N7474D · Substantial damageNTSB SEA74AS017Accident · 2 fatalClosedPiper PA-20 · Oakesdale, WASep 18, 1973 · N7666K · DestroyedNTSB SEA74FYE15Accident · Serious injuriesClosedCessna 150L · Federal Way, WASep 16, 1973 · N6519G · Substantial damageNTSB SEA74DYE17Accident · No injuriesClosedHughes 269C · Eagle Lake, WASep 16, 1973 · N8955F · Substantial damageNTSB SEA74FYG17Accident · No injuriesClosedPitts S-1C · Spokane, WASep 9, 1973 · N5S · Substantial damageNTSB SEA74DYE12Accident · No injuriesClosedHughes 269A · Eatonville, WASep 7, 1973 · N8813 · Substantial damageNTSB SEA74DYE11Accident · No injuriesClosedCessna 140A · Tacoma, WASep 7, 1973 · N5396C · Substantial damageNTSB SEA74FYG14Accident · Minor injuriesClosedCessna 150F · La Crosse, WASep 4, 1973 · N8678S · DestroyedNTSB SEA74DYE10Accident · No injuriesClosedHughes 269B · Puyallup, WASep 4, 1973 · N9432F · Substantial damageNTSB SEA74DYE09Accident · No injuriesClosedBell 205-A1 · Lester, WASep 2, 1973 · N1440W · DestroyedNTSB SEA74FYG16Accident · No injuriesClosedPiper PA-28 · Colville, WAAug 31, 1973 · N4557J · Substantial damageNTSB SEA74AS013Accident · 2 fatalClosedCessna 172 · Packwood, WAAug 30, 1973 · N3843Q · DestroyedNTSB SEA74FYG13Accident · Serious injuriesClosedHughes 369HS · Packwood, WAAug 26, 1973 · N9043F · DestroyedNTSB SEA74AS009Accident · 4 fatalClosedPiper PA-28 · Eatonville, WAAug 23, 1973 · N15587 · DestroyedNTSB SEA74DYE14Accident · No injuriesClosedCessna 150 · Federal Way, WAAug 21, 1973 · N7296S · Substantial damageNTSB SEA74DVG12Accident · No injuriesClosedCessna 210C · Spokane, WAAug 16, 1973 · N3968Y · Substantial damageNTSB SEA74FYG08Accident · Serious injuriesClosedBell 47J-2A · Inchelium, WAAug 8, 1973 · N8439E · DestroyedNTSB SEA74FYC08Accident · Minor injuriesClosedCessna 150 · Vancouver, WAAug 7, 1973 · N7962F · Substantial damageNTSB SEA74DYG10Accident · No injuriesClosedBell 47G3B2 · Tonasket, WAAug 3, 1973 · N78255 · Substantial damageNTSB SEA74FYE08Accident · Minor injuriesClosedCessna 172 · Kent, WAAug 2, 1973 · N7241Q · Substantial damageNTSB SEA74DYG05Accident · No injuriesClosedCessna 150 · Pullman, WAJul 27, 1973 · N16058 · Substantial damageNTSB SEA74DYG06Accident · No injuriesClosedSchemp SHK-1 · Ephrata, WAJul 22, 1973 · N1582 · Substantial damageNTSB SEA74DYC03Accident · Minor injuriesClosedChampion 7SC · Moro, WAJul 20, 1973 · CF-VFY · Substantial damage