NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 SEA66F0193Accident · No injuriesClosedCessna 150 · Ellensburg, WADec 30, 1965 · N7718E · Substantial damageNTSB SEA66D0199Accident · No injuriesClosedCessna 150 · Mount Vernon, WADec 27, 1965 · N8751S · Substantial damageNTSB SEA66D0179Accident · No injuriesClosedBeechcraft 35 · Pullman, WADec 17, 1965 · N3854N · Substantial damageNTSB SEA66F0181Accident · No injuriesClosedCessna 150F · Redmond, WADec 15, 1965 · N8801S · Substantial damageNTSB SEA66A0037Accident · No injuriesClosedBell 47G-2 · Auburn, WADec 14, 1965 · N2865B · Substantial damageNTSB SEA66F0182Accident · Minor injuriesClosedTaylorcraft DC0-65 · Kent, WADec 11, 1965 · N49174 · Substantial damageNTSB SEA66F0172Accident · No injuriesClosedCessna 182 · Pasco, WADec 8, 1965 · N5111D · Substantial damageNTSB SEA66D0169Accident · No injuriesClosedCessna 140 · Wenatchee, WADec 5, 1965 · N89528 · Substantial damageNTSB SEA66D0183Accident · No injuriesClosedCessna 172 · Bellingham, WADec 3, 1965 · N6933X · Substantial damageNTSB SEA66A0035Accident · Minor injuriesClosedDouglas DC-3 · Hoquiam, WADec 1, 1965 · N62375 · Substantial damageNTSB SEA66F0184Accident · No injuriesClosedCessna 150 · Renton, WANov 28, 1965 · N8081S · Substantial damageNTSB SEA66A0032Accident · Minor injuriesClosedBell 47G-2 · 38mi E.Kelso, WANov 23, 1965 · N6145C · Substantial damageNTSB SEA66D0159Accident · No injuriesClosedCessna 182 · Othello, WANov 19, 1965 · N2417X · Substantial damageNTSB SEA66F0176Accident · Minor injuriesClosedAeronca 7AC · Vancouver, WANov 17, 1965 · N81933 · Substantial damageNTSB SEA66I0034Incident · No injuriesClosedDouglas DC-8 · Mcchord Afb, WANov 15, 1965 · N8026U · No damageNTSB SEA66F0166Accident · Minor injuriesClosedPiper PA-18 · Waitsburg, WANov 13, 1965 · N1265A · Substantial damageNTSB SEA66D0162Accident · No injuriesClosedCessna 140A · Seattle, WANov 13, 1965 · N358TA · Substantial damageNTSB SEA66A0031Accident · No injuriesClosedHiller UH-12B · Federal Way, WANov 11, 1965 · N7212H · Substantial damageNTSB SEA66F0158Accident · No injuriesClosedPiper PA-18 · White Swan, WANov 9, 1965 · N1323A · DestroyedNTSB SEA66F0163Accident · Serious injuriesClosedErco 415C · Coupeville, WAOct 31, 1965 · N99300 · DestroyedNTSB SEA66F0151Accident · No injuriesClosedBeechcraft D-17S · Tacoma, WAOct 31, 1965 · N9000C · Substantial damageNTSB SEA66F0185Accident · Serious injuriesClosedStinson HW-75 · Port Orchard, WAOct 26, 1965 · N22511 · Substantial damageNTSB SEA66F0152Accident · No injuriesClosedCessna 170B · Silverdale, WAOct 13, 1965 · N3122A · Substantial damageNTSB SEA66F0145Accident · Serious injuriesClosedLuscombe 8A · Goldbar, WAOct 11, 1965 · N1157K · DestroyedNTSB SEA66A0025Accident · 1 fatalClosedCessna 172 · Puyallup, WAOct 10, 1965 · N5724A · DestroyedNTSB SEA66A0024Accident · 2 fatalClosedPiper PA-28 · Enumclaw, WAOct 8, 1965 · N8662W · DestroyedNTSB SEA66F0157Accident · No injuriesClosedCessna 310C · Pasco, WAOct 6, 1965 · N6675B · Substantial damageNTSB SEA66D0150Accident · No injuriesClosedErcoupe 415-C · Anacortes, WAOct 1, 1965 · N3572H · Substantial damageNTSB SEA66F0136Accident · No injuriesClosedGreat Lakes 2T-1E · Spokane, WASep 30, 1965 · N11333 · Substantial damageNTSB SEA66F0140Accident · No injuriesClosedCessna 175 · Kent, WASep 25, 1965 · N9356B · Substantial damageNTSB SEA66D0139Accident · No injuriesClosedCessna 140 · Everett, WASep 24, 1965 · N89983 · Substantial damageNTSB SEA66F0126Accident · No injuriesClosedCessna 337 · Spokane, WASep 17, 1965 · N2181X · Substantial damageNTSB SEA66F0134Accident · Minor injuriesClosedTaylorcraft DC-65 · Hooper, WASep 13, 1965 · N36341 · DestroyedNTSB SEA66F0130Accident · Minor injuriesClosedCessna 150 · Mazama, WASep 12, 1965 · N8210S · DestroyedNTSB SEA66D0138Accident · No injuriesClosedPiper PA-22 · Port Angeles, WASep 9, 1965 · N4780Z · DestroyedNTSB SEA66A0019Accident · 1 fatalClosedSmith Mini DSA-1 · Puyallup, WASep 6, 1965 · N93139 · DestroyedNTSB SEA66F0132Accident · No injuriesClosedCessna 180 · Orchards, WASep 5, 1965 · N2468C · Substantial damageNTSB SEA66D0110Accident · No injuriesClosedAeronca 7CCM · Bremerton, WASep 3, 1965 · N6436C · Substantial damageNTSB SEA66F0115Accident · No injuriesClosedAeronca 11AC · Bellevue, WAAug 22, 1965 · N9500E · Substantial damageNTSB SEA66A0016Accident · No injuriesClosedHughes 269A · Granite Flls, WAAug 22, 1965 · N8772F · Substantial damageNTSB SEA66D0101Accident · Minor injuriesClosedCessna 150 · Dalkena, WAAug 21, 1965 · N6420T · Substantial damageNTSB SEA66A0014Accident · 1 fatalClosedHelio Acft H-391B · Mead, WAAug 19, 1965 · N4132D · DestroyedNTSB SEA66F0100Accident · No injuriesClosedCessna 172 · Othello, WAAug 18, 1965 · N8613U · Substantial damageNTSB SEA66F0090Accident · No injuriesClosedPiper PA-25 · Othello, WAAug 18, 1965 · N6900Z · Substantial damageNTSB SEA66F0092Accident · No injuriesClosedCessna 172 · Kent, WAAug 15, 1965 · N9739T · Substantial damageNTSB SEA66A0010Accident · 1 fatalClosedCessna 180A · 8s Mt Vernon, WAAug 11, 1965 · N9561B · DestroyedNTSB SEA66F0085Accident · Minor injuriesClosedLuscombe 8A · Deer Park, WAAug 7, 1965 · N25229 · Substantial damageNTSB SEA66F0086Accident · No injuriesClosedPiper PA-28 · Walla Walla, WAAug 6, 1965 · N7902W · Substantial damageNTSB SEA66D0074Accident · No injuriesClosedGlobe GC-1B · Seattle, WAAug 6, 1965 · N80659 · Substantial damageNTSB SEA66F0071Accident · No injuriesClosedPiper PA-22 · Spokane, WAAug 5, 1965 · N6121D · Substantial damage