Fatal NTSB investigations, 1978, 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, 1978, 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\") = 1978
    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 DCA79AA005Accident · 10 fatalClosedDouglas DC-8 · Portland, ORDec 28, 1978 · N8082U · DestroyedNTSB SEA79FA017Accident · 1 fatalClosedCessna 150K · Astoria, ORDec 10, 1978 · N8339M · DestroyedNTSB SEA79FA016Accident · 1 fatalClosedPiper PA-14 · Eugene, ORDec 1, 1978 · N5013W · DestroyedNTSB SEA79FA014Accident · 2 fatalClosedBellanca 17-30 · Medford, ORNov 19, 1978 · N7320V · DestroyedNTSB SEA79FA012Accident · 1 fatalClosedCessna 177B · Kimberly, ORNov 9, 1978 · N11606 · DestroyedNTSB SEA79FA011Accident · 3 fatalClosedCessna 185 · Joseph, ORNov 5, 1978 · N80169 · DestroyedNTSB SEA79FA010Accident · 3 fatalClosedPiper PA-20 · Joseph, OROct 28, 1978 · N2411A · DestroyedNTSB SEA78FYK24Accident · 1 fatalClosedCallair B-1A · Glide, ORSep 20, 1978 · N7269V · Substantial damageNTSB SEA78FA065Accident · 1 fatalClosedPiper PA-28 · Rainier, ORSep 14, 1978 · N5877U · DestroyedNTSB SEA78FA063Accident · 4 fatalClosedPiper PA-28 · Sisters, ORSep 7, 1978 · N39499 · DestroyedNTSB SEA78FYM50Accident · 1 fatalClosedMini Coupe Buffum · Independence, ORAug 30, 1978 · N75MB · DestroyedNTSB SEA78FA058Accident · 2 fatalClosedBeech C35 · Redmond, ORAug 19, 1978 · N668D · DestroyedNTSB SEA78FA056Accident · 2 fatalClosedCessna 172XP · Eugene, ORAug 15, 1978 · N736XU · DestroyedNTSB SEA78FA055Accident · 3 fatalClosedAero Comdr 100 · Bly, ORAug 11, 1978 · N4179X · DestroyedNTSB SEA78FA039Accident · 4 fatalClosedPiper PA-28R · Baker, ORJun 24, 1978 · N40048 · DestroyedNTSB SEA78FA038Accident · 1 fatalClosedNavion A · Ashland, ORJun 23, 1978 · N91504 · DestroyedNTSB SEA78FYM39Accident · 1 fatalClosedBoeing E75N1 · John Day, ORJun 16, 1978 · N4769V · DestroyedNTSB SEA78FA025Accident · 1 fatalClosedCessna 150L · Junction City, ORApr 11, 1978 · N10627 · DestroyedNTSB SEA78FA023Accident · 4 fatalClosedPiper PA-28 · Milton Frwtr, ORMar 18, 1978 · N1844T · DestroyedNTSB SEA78FA019Accident · 4 fatalClosedBeech 35 · Cascade Locks, ORFeb 7, 1978 · N3087V · DestroyedNTSB SEA78FYK07Accident · 1 fatalClosedPiper PA-25 · Christmas Vly, ORJan 20, 1978 · N6559L · DestroyedNTSB SEA78FYK06Accident · 1 fatalClosedHiller UH-12E · Reedsport, ORJan 20, 1978 · N65149 · Minor damageNTSB SEA78FA018Accident · 6 fatalClosedPiper PA-23 · Medford, ORJan 15, 1978 · N5675Y · Destroyed