NTSB investigations, 1980, 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, 1980, 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\") = 1980
    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 SEA81DYK02Accident · Minor injuriesClosedHughes 369 · Powers, ORDec 15, 1980 · N8607F · Substantial damageNTSB SEA81FA010Accident · 1 fatalClosedAero Comdr 685 · Ashland, ORDec 12, 1980 · N9221N · DestroyedNTSB SEA81DYM10Accident · Serious injuriesClosedStinson L-5 · Philomath, ORDec 7, 1980 · N68842 · Substantial damageNTSB SEA81DYK03Accident · No injuriesClosedPiper PA-34 · Sutherlin, ORDec 7, 1980 · N2924C · Substantial damageNTSB SEA81DYK01Accident · No injuriesClosedPiper PA-32R · Adel, ORNov 30, 1980 · N1260H · Substantial damageNTSB SEA81FYM09Accident · Minor injuriesClosedBell 47G-3 · Buell, ORNov 22, 1980 · N6784D · Substantial damageNTSB SEA81FA002Accident · 1 fatalClosedCessna 182Q · Ashland, OROct 15, 1980 · N735PZ · DestroyedNTSB SEA81DYM05Accident · No injuriesClosedMooney M20A · Sandy, OROct 9, 1980 · N8168E · Substantial damageNTSB SEA81DYM04Accident · No injuriesClosedPiper PA-18 · Hillsboro, OROct 5, 1980 · N82481 · Substantial damageNTSB SEA81DYM03Accident · No injuriesClosedPiper PA-28R · Nehalem, OROct 4, 1980 · N5145W · Substantial damageNTSB SEA81DYM02Accident · No injuriesClosedPiper PA-28 · Molalla, OROct 3, 1980 · N33638 · Substantial damageNTSB SEA80FYM63Accident · No injuriesClosedCessna 182A · Harrisburg, ORSep 28, 1980 · N6163B · Substantial damageNTSB SEA80FYK18Accident · Serious injuriesClosedBell 47J-2A · Brookings, ORSep 9, 1980 · N2ZH · DestroyedNTSB SEA80FA046Accident · 1 fatalClosedCessna 172N · Pendleton, ORSep 7, 1980 · N3444E · DestroyedNTSB SEA80FYM60Accident · 1 fatalClosedBLN Works FF-6B · Shedd, ORSep 6, 1980 · N27057 · DestroyedNTSB SEA80DYM58Accident · No injuriesClosedCessna 172 · Molalla, ORSep 4, 1980 · N4923D · Substantial damageNTSB SEA80DYK17Accident · Minor injuriesClosedCessna 150 · Redmond, ORSep 4, 1980 · N1280Q · Substantial damageNTSB SEA81FYM61Accident · No injuriesClosedGrum Amer AA-5A · Newburg, ORSep 2, 1980 · N26777 · Substantial damageNTSB SEA81FYM07Accident · No injuriesClosedHughes 269C · Pilot Rock, ORAug 31, 1980 · N9643F · Substantial damageNTSB SEA80FYK15Accident · No injuriesClosedPiper PA-28R · Sixes, ORAug 25, 1980 · N444JT · Substantial damageNTSB SEA80DYK14Accident · No injuriesClosedCessna 210 · French Glen, ORAug 22, 1980 · N8250M · Substantial damageNTSB SEA80DYM55Accident · No injuriesClosedHiller Acft UH-12E · Tillamook, ORAug 19, 1980 · N59366 · Substantial damageNTSB SEA80DYM53Accident · No injuriesClosedAero Comdr 100 · Prineville, ORAug 17, 1980 · N2924T · Substantial damageNTSB SEA80DYK16Accident · No injuriesClosedCessna 188 · Medford, ORAug 15, 1980 · N4736Q · Substantial damageNTSB SEA80FYM54Accident · Serious injuriesClosedPiper PA-28 · Portland, ORAug 13, 1980 · N8084V · Substantial damageNTSB SEA80FYK13Accident · Minor injuriesClosedCessna 421 · Redmond, ORAug 11, 1980 · N3150K · Substantial damageNTSB SEA80FA040Accident · 4 fatalClosedAerofab LA-4-2 · Cascade Locks, ORAug 9, 1980 · N65640 · DestroyedNTSB SEA80FYK12Accident · Serious injuriesClosedCessna 182A · Roseburg, ORAug 5, 1980 · N3903D · Substantial damageNTSB SEA80FYK11Accident · No injuriesClosedCessna 140 · Creswell, ORAug 3, 1980 · N3691V · Substantial damageNTSB SEA80DYM51Accident · No injuriesClosedCessna 150L · Tigard, ORJul 27, 1980 · N11624 · Substantial damageNTSB SEA80DYM56Accident · No injuriesClosedCessna 210B · Lagrande, ORJul 26, 1980 · N9552X · Substantial damageNTSB SEA80FYM50Accident · Minor injuriesClosedPiper PA-22 · Dallas, ORJul 17, 1980 · N8841C · Substantial damageNTSB SEA80DYM47Accident · Serious injuriesClosedCessna 152 · Milton-Freewtr, ORJul 13, 1980 · N68450 · Substantial damageNTSB SEA80DYM46Accident · No injuriesClosedPiper PA-28 · Brooks, ORJul 13, 1980 · N2159C · Substantial damageNTSB SEA80DYM49Accident · No injuriesClosedHenkes RV-3 · Canby, ORJul 12, 1980 · N20RV · Substantial damageNTSB SEA80DYK09Accident · No injuriesClosedMaule M-5 · Klamath Falls, ORJul 8, 1980 · N369DG · Substantial damageNTSB SEA80FYM44Accident · No injuriesClosedPiper J3C-85 · Hood River, ORJul 7, 1980 · N7116H · Substantial damageNTSB SEA80DYM45Accident · No injuriesClosedPiper PA-18 · Hermiston, ORJul 7, 1980 · N9432P · Substantial damageNTSB SEA80DYM43Accident · No injuriesClosedPiper PA-36 · The Dalles, ORJul 7, 1980 · N9973P · Substantial damageNTSB SEA80FYK10Accident · Serious injuriesClosedPrue Super STD · Brothers, ORJun 27, 1980 · N86675 · DestroyedNTSB SEA80FA036Accident · 4 fatalClosedPiper PA32RT · Granite, ORJun 26, 1980 · N39691 · DestroyedNTSB SEA80DYM48Accident · No injuriesClosedCessna 150J · Long Creek, ORJun 22, 1980 · N61365 · Substantial damageNTSB SEA80FYM41Accident · No injuriesClosedHiller Acft UH-12E · Gales Creek, ORJun 20, 1980 · N48220 · Substantial damageNTSB SEA80DYM42Accident · No injuriesClosedCessna 182 · Madras, ORJun 15, 1980 · N70641 · Substantial damageNTSB SEA80FA032Accident · 1 fatalClosedPiper PA-28 · Woodburn, ORJun 14, 1980 · N5887V · DestroyedNTSB SEA80FA044Accident · 2 fatalClosedPiper PA-28 · Portland, ORJun 12, 1980 · N2333U · DestroyedNTSB SEA80FYM40Accident · Minor injuriesClosedHiller Acft FH1100 · Albany, ORJun 4, 1980 · N92484 · Substantial damageNTSB SEA80FA031Accident · 1 fatalClosedCessna 210L · Harrisburg, ORJun 4, 1980 · N732DX · DestroyedNTSB SEA80DYM38Accident · No injuriesClosedCessna 150 · Sevenson, ORMay 19, 1980 · N55041 · Substantial damageNTSB SEA80DYM37Accident · No injuriesClosedPiper PA-28 · Yamhill, ORMay 18, 1980 · N32526 · Substantial damage