NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 SEA67F0232Accident · No injuriesClosedBeech A45 · Aurora, ORDec 31, 1966 · N6602C · Substantial damageNTSB SEA67F0233Accident · Minor injuriesClosedNavion B · Hillsboro, ORDec 21, 1966 · N5351K · Substantial damageNTSB SEA67A0045Accident · No injuriesClosedBell 47G3B1 · Yachats, ORDec 14, 1966 · N8554F · Substantial damageNTSB SEA67F0231Accident · No injuriesClosedCessna 182H · Harrisburg, ORDec 12, 1966 · N2449X · Substantial damageNTSB SEA68A0008Accident · 1 fatalClosedCallari S-1A · Ashland, ORDec 8, 1966 · N37368 · DestroyedNTSB SEA67F0227Accident · No injuriesClosedBeech A23 · Portland, ORNov 27, 1966 · N2374W · Substantial damageNTSB SEA67D0215Accident · Serious injuriesClosedPiper PA-22 · Gibbon, ORNov 25, 1966 · N5830D · DestroyedNTSB SEA67D0226Accident · No injuriesClosedBeech 35 · Madras, ORNov 23, 1966 · N3854N · Substantial damageNTSB SEA67F0197Accident · No injuriesClosedCessna 320E · Eugene, ORNov 6, 1966 · N3446Q · Substantial damageNTSB SEA67F0225Accident · No injuriesClosedCessna 411 · Paisley, ORNov 5, 1966 · N7366U · Substantial damageNTSB SEA67D0222Accident · No injuriesClosedPiper PA-18 · Fossil, ORNov 3, 1966 · N3957Z · Substantial damageNTSB SEA67F0216Accident · No injuriesClosedPiper PA-32 · Sisters, OROct 31, 1966 · N3560W · Substantial damageNTSB SEA67F0224Accident · No injuriesClosedCessna 182E · Springfield, OROct 27, 1966 · N9257X · DestroyedNTSB SEA67D0223Accident · No injuriesClosedBellanca 14-13 · Malin, OROct 26, 1966 · N86717 · DestroyedNTSB SEA67D0196Accident · No injuriesClosedPiper PA-22 · Mulino, OROct 22, 1966 · N623A · Substantial damageNTSB SEA67D0204Accident · No injuriesClosedBeech A23 · Klamath Fall, OROct 19, 1966 · N3590R · DestroyedNTSB SEA67A0033Accident · No injuriesClosedHughes 269B · Frenchglen, OROct 13, 1966 · N9317F · Substantial damageNTSB SEA67D0190Accident · No injuriesClosedPiper PA-22 · Idanha, OROct 2, 1966 · N4418A · Substantial damageNTSB DCA67A0003Accident · 18 fatalClosedDouglas DC-9 · Nwemme, OROct 1, 1966 · N9101 · DestroyedNTSB SEA67F0161Accident · No injuriesClosedPiper PA-24 · North Bend, ORSep 28, 1966 · N5036P · Substantial damageNTSB SEA67F0189Accident · Serious injuriesClosedCessna T-210F · Hillsboro, ORSep 21, 1966 · N6731R · DestroyedNTSB SEA67A0030Accident · Minor injuriesClosedBensen B8-M · Albany, ORSep 20, 1966 · N74115 · DestroyedNTSB SEA67F0217Accident · No injuriesClosedCessna 170A · Chiloquin, ORSep 16, 1966 · N5471C · Substantial damageNTSB SEA67A0022Accident · 4 fatalClosedBeech A35 · Mitchell, ORSep 11, 1966 · N745B · DestroyedNTSB SEA67F0184Accident · Minor injuriesClosedCessna 150 · Springfield, ORSep 5, 1966 · N3690J · Substantial damageNTSB SEA67D0181Accident · No injuriesClosedAeronca 7FC · Blachly, ORSep 4, 1966 · N7547E · Substantial damageNTSB SEA67A0020Accident · No injuriesClosedHiller UH-12E · Cottage Grve, ORSep 3, 1966 · N9732C · Substantial damageNTSB SEA67D0180Accident · No injuriesClosedCessna 182B · Troutdale, ORSep 2, 1966 · N2654G · Substantial damageNTSB SEA67F0116Accident · Serious injuriesClosedPiper PA-22 · Redmond, ORSep 1, 1966 · N6956B · Substantial damageNTSB SEA67A0019Accident · No injuriesClosedBell 47G3B1 · Medford, ORSep 1, 1966 · N73287 · Substantial damageNTSB SEA67F0187Accident · No injuriesClosedCessna 150 · Eugene, ORAug 31, 1966 · N1236Y · Substantial damageNTSB SEA67D0172Accident · No injuriesClosedBeech S35 · Salem, ORAug 30, 1966 · N2001W · Substantial damageNTSB SEA67F0115Accident · No injuriesClosedCessna 150 · Roseburg, ORAug 25, 1966 · N6533F · Substantial damageNTSB SEA67D0171Accident · No injuriesClosedBeech S35 · Eugene, ORAug 25, 1966 · N6147V · Substantial damageNTSB SEA67A0017Accident · 1 fatalClosedBeech G35 · Rogue River, ORAug 25, 1966 · N4545D · DestroyedNTSB SEA67F0214Accident · No injuriesClosedPiper PA-22 · Hillsboro, ORAug 24, 1966 · N2931P · Substantial damageNTSB SEA67F0162Accident · No injuriesClosedPiper PA-22 · Lebanon, ORAug 21, 1966 · N8991C · Substantial damageNTSB SEA67F0158Accident · No injuriesClosedCessna 310 · Hillsboro, ORAug 21, 1966 · N3028D · Substantial damageNTSB SEA67D0098Accident · No injuriesClosedCessna 180 · Pendleton, ORAug 21, 1966 · N1681C · Substantial damageNTSB SEA67F0157Accident · No injuriesClosedPiper PA-24 · Oregon City, ORAug 19, 1966 · N7798P · Substantial damageNTSB SEA67F0112Accident · No injuriesClosedCessna 182-A · Crescent Lke, ORAug 19, 1966 · N5878B · Substantial damageNTSB SEA67A0015Accident · Serious injuriesClosedDouglas A-26B · La Grande, ORAug 18, 1966 · N7719C · Substantial damageNTSB SEA67A0014Accident · 3 fatalClosedCessna 320-1 · Fairview, ORAug 15, 1966 · N5760X · DestroyedNTSB SEA67F0146Accident · No injuriesClosedAeronca 7AC · North Bend, ORAug 14, 1966 · N82802 · Substantial damageNTSB SEA67F0147Accident · No injuriesClosedTaylorcraft BC12-D · Tigard, ORAug 13, 1966 · N5033M · Substantial damageNTSB SEA67F0105Accident · No injuriesClosedCessna 170B · Troutdale, ORAug 9, 1966 · N2575D · Substantial damageNTSB SEA67D0087Accident · No injuriesClosedPiper PA-22 · Heppner, ORAug 8, 1966 · N4512A · Substantial damageNTSB SEA67A0012Accident · No injuriesClosedPiper PA-28 · Mitchell, ORAug 7, 1966 · N7409W · Substantial damageNTSB SEA67A0010Accident · Minor injuriesClosedHughes 269B · Eaverton, ORAug 7, 1966 · N9427F · Substantial damageNTSB SEA67A0009Accident · 2 fatalClosedPiper PA-22 · Seaside, ORAug 7, 1966 · N7629D · Destroyed