Fatal NTSB investigations, 1981, OR

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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

19642026
Fatal NTSB investigations, 1981, OR per year, 1964–2026: 600 cases
196413
19658
196615
196717
196817
196916
197011
197118
197218
197313
197411
197515
197616
197720
197823
19797
198011
198116
198214
19839
198413
19859
19869
19876
19884
198910
199012
199111
19928
19937
199411
199511
19968
199714
19985
199912
20007
20014
20026
200311
20048
200512
20069
20079
20086
20096
20107
20117
20125
20135
20142
20156
20164
20174
20182
201912
20207
20214
20223
20233
20245
20252
20266

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\") = 1981
    AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 SEA82FA013Accident · 1 fatalClosedErco 415-C · Ashland, ORDec 21, 1981 · N87307 · DestroyedNTSB SEA82FA012Accident · 2 fatalClosedPiper PA-32 · Brogan, ORDec 12, 1981 · N4041R · DestroyedNTSB SEA82FA010Accident · 1 fatalClosedPiper PA-28 · Mill City, ORDec 6, 1981 · N8415W · DestroyedNTSB SEA82FA006Accident · 5 fatalClosedCessna 172M · Payette, ORNov 26, 1981 · N9710H · DestroyedNTSB SEA82FA003Accident · 1 fatalClosedMaule M-5 · North Bend, ORNov 7, 1981 · N62076 · DestroyedNTSB SEA81FYM46Accident · 1 fatalClosedDruine D-31 · Corvallis, ORSep 19, 1981 · N7193 · DestroyedNTSB SEA81FA056Accident · 2 fatalClosedAeronca 7AC · Myrtle Creek, ORSep 17, 1981 · N4323E · DestroyedNTSB SEA81FA048Accident · 2 fatalClosedCessna 150H · Blue River, ORJul 24, 1981 · N6551S · DestroyedNTSB SEA81FYM32Accident · 1 fatalClosedMinicoupe Johnsn · Gaston, ORJul 18, 1981 · N74BJ · Substantial damageNTSB SEA81FA040Accident · 1 fatalClosedPiper PA-24 · Riverside, ORJun 12, 1981 · N9437P · DestroyedNTSB SEA83FA056Accident · 2 fatalClosedCessna 170 · Azalea, ORJun 6, 1981 · N3973V · DestroyedNTSB SEA81FA036Accident · 1 fatalClosedBell 206B · Govt Camp, ORMay 22, 1981 · N58004 · Substantial damageNTSB SEA81FA023Accident · 1 fatalClosedPiper PA28RT · Astoria, ORMar 14, 1981 · N2853T · DestroyedNTSB SEA81FA021Accident · 2 fatalClosedBeech A36 · Eugene, ORMar 4, 1981 · N17504 · DestroyedNTSB SEA83FYM03Accident · 1 fatalClosedPiper PA-24 · Scappoose, ORFeb 9, 1981 · N8604P · DestroyedNTSB SEA81FA015Accident · 3 fatalClosedAero Comdr 690B · Burns, ORJan 7, 1981 · N81521 · Destroyed