NTSB investigations, 1980, NE

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, NE per year, 1962–2026: 1,895 cases
19621
196458
196567
196672
196789
196880
196988
197074
197193
197264
197352
197471
197547
197664
197752
197849
197941
198036
198134
198242
198339
198440
198531
198627
198721
198816
198922
199013
199124
199220
199321
199420
199516
199614
199714
199828
199923
200013
200119
200214
200312
200411
200515
200617
200711
200813
200915
201013
20117
201221
201311
201411
201511
201610
20179
201812
201913
20209
20219
202214
202310
202417
202511
20264

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\" = 'NE' 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 MKC81FCJ04Accident · No injuriesClosedCessna 182 · Albion, NEDec 4, 1980 · N2506R · DestroyedNTSB MKC81DCJ03Accident · No injuriesClosedPiper PA-15 · Cambridge, NENov 24, 1980 · N4196H · Substantial damageNTSB MKC81DCJ02Accident · No injuriesClosedCessna 120 · Aurora, NENov 9, 1980 · N89765 · Substantial damageNTSB MKC81DCJ01Accident · No injuriesClosedCessna 175A · Broken Bow, NENov 4, 1980 · N6978E · Substantial damageNTSB MKC80DCJ34Accident · Serious injuriesClosedPiper PA-28 · Burwell, NESep 21, 1980 · N7414W · Substantial damageNTSB MKC80DCJ33Accident · Minor injuriesClosedUniv Acft 108-2 · Omaha, NESep 14, 1980 · N8003K · Substantial damageNTSB MKC80DCJ31Accident · No injuriesClosedPiper PA-28 · Ogallala, NESep 7, 1980 · N5376F · Substantial damageNTSB MKC80DCJ32Accident · No injuriesClosedPiper PA-28R · Nebraska City, NESep 6, 1980 · N2137N · Substantial damageNTSB MKC80DCJ39Accident · No injuriesClosedPiper PA-25 · Weeping Water, NESep 4, 1980 · N4997Y · Substantial damageNTSB MKC80DCJ29Accident · No injuriesClosedCessna 152 · Columbus, NEAug 25, 1980 · N49696 · Substantial damageNTSB MKC80FA049Accident · Serious injuriesClosedPiper PA-28R · Omaha, NEAug 17, 1980 · N4308X · Substantial damageNTSB MKC80DCJ28Accident · No injuriesClosedGrumman G-164B · Cambridge, NEAug 9, 1980 · N6648Q · DestroyedNTSB MKC80DCJ27Accident · No injuriesClosedCessna A188B · Axtell, NEAug 7, 1980 · N53150 · Substantial damageNTSB MKC80FCJ26Accident · Minor injuriesClosedMaule M4-210 · O'Neill, NEAug 4, 1980 · N9823M · Substantial damageNTSB MKC80DCJ24Accident · No injuriesClosedPiper PA-25 · Overton, NEAug 4, 1980 · N9625P · DestroyedNTSB MKC80DCJ23Accident · No injuriesClosedCessna 188 · Blue Hill, NEJul 30, 1980 · N9793V · Substantial damageNTSB MKC80DCJ20Accident · No injuriesClosedCessna A188B · Holdrege, NEJul 28, 1980 · N53199 · Substantial damageNTSB MKC80FCJ25Accident · No injuriesClosedCessna 150L · Sutton, NEJul 27, 1980 · N17262 · DestroyedNTSB MKC80DCJ21Accident · No injuriesClosedPiper PA-25 · Minden, NEJul 27, 1980 · N4533Y · Substantial damageNTSB MKC80DCJ19Accident · Minor injuriesClosedStinson 108-3 · Minden, NEJul 18, 1980 · N6400M · Substantial damageNTSB MKC80DCJ18Accident · No injuriesClosedMooney M20F · Gordon, NEJul 15, 1980 · N9631M · Substantial damageNTSB MKC80FCJ16Accident · No injuriesClosedAero Comndr 500B · Omaha, NEJun 22, 1980 · N888CA · Substantial damageNTSB MKC80DCJ15Accident · Serious injuriesClosedKen Kanta KR-2 · Omaha, NEJun 17, 1980 · N49849 · Substantial damageNTSB DCA80AA019Accident · 13 fatalClosedSwearingen 226TC · Valley, NEJun 12, 1980 · N650S · DestroyedNTSB MKC80FCJ13Accident · No injuriesClosedGreat Lakes 01 · Omaha, NEJun 6, 1980 · N5994 · Substantial damageNTSB MKC80DCJ12Accident · No injuriesClosedCessna 188 · Clay Center, NEMay 30, 1980 · N4956R · Substantial damageNTSB MKC80FA036Accident · 1 fatalClosedCherokee II · So Sioux City, NEMay 28, 1980 · N129V · Substantial damageNTSB MKC80DCJ11Accident · No injuriesClosedCessna 152 · Omaha, NEApr 23, 1980 · N25595 · Substantial damageNTSB MKC80FCJ10Accident · No injuriesClosedPiper PA-22 · Lincoln, NEApr 18, 1980 · N8631D · Substantial damageNTSB MKC80FA029Accident · 1 fatalClosedCessna 210L · Sidney, NEApr 7, 1980 · N2120S · DestroyedNTSB MKC80FCJ08Accident · No injuriesClosedCessna 152 · Imperial, NEApr 5, 1980 · N757PY · Substantial damageNTSB MKC80FCJ09Accident · No injuriesClosedCessna 310 · Thedford, NEMar 25, 1980 · N5474J · Substantial damageNTSB MKC80DA027Accident · No injuriesClosedPiper PA-31 · Utica, NEMar 13, 1980 · N6493L · Substantial damageNTSB MKC80DCJ07Accident · No injuriesClosedBeech 200 · Hastings, NEFeb 14, 1980 · N349D · Substantial damageNTSB MKC80FCJ06Accident · Serious injuriesClosedPiper J3C · Milburn, NEJan 30, 1980 · N2764C · Substantial damageNTSB MKC80DCJ05Accident · No injuriesClosedCessna 172M · Sidney, NEJan 6, 1980 · N64294 · Substantial damage