NTSB investigations, 1964, OR

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

19622026
NTSB investigations, 1964, OR per year, 1962–2026: 3,390 cases
19621
196474
196588
1966121
1967121
196884
196980
197068
197177
197275
197384
197471
197577
197681
197795
197888
197990
198076
198175
198282
198365
198470
198556
198651
198740
198841
198945
199049
199151
199248
199339
199446
199556
199660
199756
199840
199943
200056
200147
200239
200348
200440
200554
200638
200747
200840
200931
201040
201131
201235
201331
201418
201529
201623
201727
201831
201942
202023
202136
202224
202323
202430
202520
202623

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\" = 'OR' 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 UNK65X1108Accident · 3 fatalClosedPiper PA-22 · Salem, ORDec 23, 1964 · N2472A · DestroyedNTSB UNK65X1084Accident · 2 fatalClosedStinson 108 · Salem, ORDec 21, 1964 · N97562 · DestroyedNTSB UNK65X1034Accident · No injuriesClosedMooney M20A · Urg, ORDec 17, 1964 · N1095B · Substantial damageNTSB UNK65X0804Accident · No injuriesClosedAero Cmdr 680 · Portland, ORNov 23, 1964 · N6872S · Substantial damageNTSB UNK65X0484Accident · No injuriesClosedCessna 182 · Wallowa Co, OROct 30, 1964 · N3824D · Substantial damageNTSB UNK65X0359Accident · No injuriesClosedCessna 150 · Troutdale, OROct 21, 1964 · N6091T · Substantial damageNTSB UNK65X0340Accident · No injuriesClosedPiper PA23 · Rome, OROct 19, 1964 · N4942P · Substantial damageNTSB UNK65X0271Accident · No injuriesClosedCessna 182 · Minam Lodge, OROct 14, 1964 · N5818B · Substantial damageNTSB UNK65X0151Accident · Serious injuriesClosedCessna 140 · Beaverton, OROct 4, 1964 · N2291N · Substantial damageNTSB UNK65X0103Accident · No injuriesClosedStinson 1083 · Burns, OROct 1, 1964 · N6804M · Substantial damageNTSB UNK65X0100Case · No injuriesClosedBoeing B-720 · Portland, OROct 1, 1964 · N7211UNTSB UNK64X4199Accident · Serious injuriesClosedTaylorcraft BC12D · Bly, ORSep 28, 1964 · N34239 · DestroyedNTSB UNK64X4192Accident · No injuriesClosedBeechcraft 95 · Scappoose, ORSep 28, 1964 · N2736Y · Substantial damageNTSB UNK64X4157Accident · No injuriesClosedStinson 1082 · Hillsboro, ORSep 26, 1964 · N9351K · Substantial damageNTSB UNK64X3913Accident · No injuriesClosedNavion · Bend, ORSep 11, 1964 · N8838H · Substantial damageNTSB UNK64X3807Accident · 1 fatalClosedCessna 175A · Idleyld Park, ORSep 5, 1964 · N8074T · DestroyedNTSB UNK64X3583Accident · Minor injuriesClosedAeronca 7AC · Chiloquin, ORAug 25, 1964 · N2266E · DestroyedNTSB UNK64X3549Accident · 1 fatalClosedAeronca 7AC · Tillamook, ORAug 22, 1964 · N81971 · DestroyedNTSB UNK64X3474Accident · No injuriesClosedCessna 180 · Salem, ORAug 19, 1964 · N9024C · Substantial damageNTSB UNK64X3320Accident · Minor injuriesClosedPiper PA22 · Drewsey, ORAug 10, 1964 · N4871Z · Substantial damageNTSB UNK64X3249Accident · No injuriesClosedErcoupe 415C · Burns, ORAug 7, 1964 · N3179H · Substantial damageNTSB UNK64X3233Accident · No injuriesClosedPiper PA22 · Mulino, ORAug 6, 1964 · N7102D · Substantial damageNTSB UNK64X3219Accident · No injuriesClosedBell 47G3B1 · Jordan Valley, ORAug 4, 1964 · N30856 · DestroyedNTSB UNK64X3216Accident · No injuriesClosedPiper PA24 · Astoria, ORAug 4, 1964 · N5506P · Substantial damageNTSB UNK64X3102Accident · No injuriesClosedPiper PA30 · Hillsboro, ORJul 29, 1964 · N7398Y · Substantial damageNTSB UNK64X2989Accident · 2 fatalClosedPiper PA22 · Klamath Falls, ORJul 23, 1964 · N3257Z · DestroyedNTSB UNK64X2884Accident · 2 fatalClosedPiper PA-28 · Vale, ORJul 17, 1964 · N5139W · DestroyedNTSB UNK64X2728Accident · No injuriesClosedBeechcraft M23 · Troutdale, ORJul 9, 1964 · N2382Q · Substantial damageNTSB UNK64X2612Accident · Minor injuriesClosedTaylorcraft BC12D · Gaston, ORJul 3, 1964 · N96033 · DestroyedNTSB UNK64X2504Accident · Serious injuriesClosedErcoupe 415G · Mccredie Spgs, ORJun 26, 1964 · N94430 · DestroyedNTSB UNK64X2502Accident · No injuriesClosedLuscombe 8A · Lakeside, ORJun 26, 1964 · N45728 · Substantial damageNTSB UNK64X2448Accident · No injuriesClosedPiper PA22 · Bend, ORJun 23, 1964 · N3316B · Substantial damageNTSB UNK64X2378Accident · No injuriesClosedPiper PA24 · Aurora, ORJun 19, 1964 · N6297P · Substantial damageNTSB UNK64X2336Accident · No injuriesClosedCessna 310 · Mcnary, ORJun 17, 1964 · N3045D · Substantial damageNTSB UNK64X2312Accident · No injuriesClosedCessna 210 · Klamath Falls, ORJun 16, 1964 · N196T · Substantial damageNTSB UNK64X2311Accident · 5 fatalClosedN.American F-51D · Roseburg, ORJun 15, 1964 · N1451D · DestroyedNTSB UNK64X2172Accident · No injuriesClosedPiper PA24 · Siletz, ORJun 7, 1964 · N6173P · Substantial damageNTSB UNK64X2100Accident · No injuriesClosedPiper PA18 · Bonanza, ORJun 4, 1964 · N1019A · Substantial damageNTSB UNK64X2065Accident · No injuriesClosedBoeing PT17 · Silvers, ORJun 2, 1964 · N9182Z · Substantial damageNTSB UNK64X1995Accident · No injuriesClosedPiper J3 · Sandy, ORMay 28, 1964 · N7074H · Substantial damageNTSB UNK64X1982Accident · Minor injuriesClosedBoeing E75 · Waconda, ORMay 27, 1964 · N1064N · Substantial damageNTSB UNK64X1961Accident · Minor injuriesClosedAeronca 7AC · Burns, ORMay 26, 1964 · N82569 · Substantial damageNTSB UNK64X1958Accident · 1 fatalClosedAeronca 11AC · Madras, ORMay 26, 1964 · N9181E · DestroyedNTSB UNK64X1889Accident · 1 fatalClosedGrumman TBM-3U · Rome, ORMay 22, 1964 · N7848C · DestroyedNTSB UNK64X1865Accident · Minor injuriesClosedBell 47G-2 · Enterprise, ORMay 20, 1964 · N4021A · Substantial damageNTSB UNK64X1814Accident · Serious injuriesClosedPiper PA22 · The Dalles, ORMay 17, 1964 · N3640P · DestroyedNTSB UNK64X1688Accident · No injuriesClosedPiper PA-22 · Mulino, ORMay 9, 1964 · N8644D · Substantial damageNTSB UNK64X1633Accident · No injuriesClosedPiper PA30 · Mill City, ORMay 6, 1964 · N246NW · Substantial damageNTSB UNK64X1554Accident · No injuriesClosedCessna 170B · Prineville, ORMay 2, 1964 · N2850C · Substantial damageNTSB UNK64X1551Accident · No injuriesClosedPiper PA28 · Hillsboro, ORMay 1, 1964 · N5723W · Substantial damage