NTSB investigations, 1980, TN

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, TN per year, 1962–2026: 2,140 cases
19621
19632
196474
196556
196658
196758
196851
196957
197056
197158
197256
197362
197439
197556
197653
197743
197840
197938
198041
198143
198228
198341
198435
198534
198636
198737
198836
198926
199029
199126
199225
199326
199427
199538
199633
199734
199821
199928
200026
200125
200223
200335
200427
200522
200619
200723
200824
200921
201025
201123
201229
201317
201424
201524
201625
201720
201813
201924
202024
202120
202226
202326
202429
202529
202615

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\" = 'TN' 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 ATL81DLT02Accident · No injuriesClosedPiper PA-28R · Reelfoot Lake, TNDec 13, 1980 · N2141T · Substantial damageNTSB ATL81FA024Accident · 2 fatalClosedPiper PA-30 · Sunbright, TNDec 2, 1980 · N99EJ · DestroyedNTSB ATL81FA021Accident · 4 fatalClosedCessna T210N · Tazewell, TNDec 2, 1980 · N4846C · DestroyedNTSB ATL81FKW05Accident · 2 fatalClosedVarieze 1 · Signal Mt, TNNov 13, 1980 · N111EZ · DestroyedNTSB ATL81IA015Incident · Serious injuriesClosedBoeing 707 · Memphis, TNNov 12, 1980 · G-BDEA · No damageNTSB ATL81FKW04Accident · Minor injuriesClosedBeech E35 · Chattanooga, TNNov 2, 1980 · N3314C · Substantial damageNTSB ATL80DKW03Accident · No injuriesClosedGrumman G-164B · Portland, TNOct 10, 1980 · N48624 · DestroyedNTSB ATL81FKW02Accident · Minor injuriesClosedBell 47G · Clarksville, TNOct 8, 1980 · N64877 · Substantial damageNTSB ATL80FKW01Accident · No injuriesClosedCessna 172 · Nashville, TNOct 3, 1980 · N3008E · Substantial damageNTSB ATL80FKW23Accident · No injuriesClosedCessna 152 · Murfreesboro, TNSep 23, 1980 · N5396M · Substantial damageNTSB ATL80FKW22Accident · No injuriesClosedQuickie 01 · Collegedale, TNSep 20, 1980 · N45BT · Substantial damageNTSB ATL80DKW21Accident · No injuriesClosedChampion 7ECA · Lawrenceburg, TNSep 14, 1980 · N1633G · Substantial damageNTSB ATL80DKW20Accident · No injuriesClosedPiper PA-12 · Crossville, TNSep 7, 1980 · N3467M · Substantial damageNTSB ATL80DLT12Accident · No injuriesClosedPiper PA-28 · Union City, TNSep 1, 1980 · N2152Z · Substantial damageNTSB ATL80FKW19Accident · 1 fatalClosedErco 415-C · Nashville, TNAug 18, 1980 · N99446 · DestroyedNTSB ATL80FLT11Accident · Minor injuriesClosedPiper PA-23 · Jackson, TNAug 1, 1980 · N7AD · DestroyedNTSB ATL80FKW18Accident · Minor injuriesClosedCessna 150L · Jonesboro, TNJul 29, 1980 · N16087 · DestroyedNTSB ATL80DKW17Accident · No injuriesClosedCessna 170 · Tazewell, TNJul 18, 1980 · N170HC · Substantial damageNTSB ATL80FA074Accident · 2 fatalClosedPiper PA-28R · Reliance, TNJul 14, 1980 · N32036 · DestroyedNTSB ATL80FKW16Accident · Serious injuriesClosedPiper PA-32 · Sparta, TNJul 8, 1980 · N3157D · Substantial damageNTSB ATL80DKW15Accident · No injuriesClosedBell 47G-3B · Livingston, TNJul 6, 1980 · N8463E · DestroyedNTSB ATL80FA065Accident · 5 fatalClosedPiper PA-23 · Rockford, TNJul 3, 1980 · N6087Y · DestroyedNTSB ATL80DKW14Accident · No injuriesClosedCessna 152 · Greenville, TNJun 19, 1980 · N24298 · Substantial damageNTSB ATL80FLT08Accident · Serious injuriesClosedPitts S1A · Oakland, TNMay 26, 1980 · N99MS · DestroyedNTSB ATL80FLT07Accident · No injuriesClosedHughes 269C · Martin, TNMay 3, 1980 · N9665F · Substantial damageNTSB IAD80DKW13Accident · Serious injuriesClosedCallair A9 · Centerville, TNApr 21, 1980 · N8251H · DestroyedNTSB ATL80FKW12Accident · Minor injuriesClosedCessna 206 · Mcminnville, TNApr 19, 1980 · N3856G · DestroyedNTSB IAD80FLT06Accident · No injuriesClosedGrumman G-164A · Montezuma, TNApr 16, 1980 · N48408 · Substantial damageNTSB IAD80FKW11Accident · No injuriesClosedCessna 152 · Murfreesboro, TNMar 28, 1980 · N4848B · Substantial damageNTSB IAD80FA034Accident · 2 fatalClosedCessna 152 · Apison, TNMar 26, 1980 · N4896H · DestroyedNTSB IAD80FLT05Accident · Serious injuriesClosedCessna 152 · Memphis, TNMar 25, 1980 · N49867 · DestroyedNTSB IAD80FA032Accident · 1 fatalClosedPiper PA-28R · Alcoa, TNMar 24, 1980 · N3059T · DestroyedNTSB IAD80FKW10Accident · Serious injuriesClosedPiper PA-32 · Gatlinburg, TNMar 20, 1980 · N649TP · DestroyedNTSB IAD80FA029Accident · 1 fatalClosedCessna 182K · Hartsville, TNMar 3, 1980 · N48G · DestroyedNTSB IAD80FKW09Accident · 1 fatalClosedDer Jagger Wilson · Loudon, TNFeb 24, 1980 · N75BW · DestroyedNTSB IAD80FKW08Accident · Serious injuriesClosedCessna 172 · Tn Ridge, TNFeb 2, 1980 · N6248E · Substantial damageNTSB IAD80DKW07Accident · No injuriesClosedCessna A150L · Oliver Spgs, TNJan 27, 1980 · N5957J · Substantial damageNTSB IAD80FLT04Accident · Minor injuriesClosedCessna 150 · Jackson, TNJan 26, 1980 · N6364K · Substantial damageNTSB IAD80FKW06Accident · No injuriesClosedSchweizer 1-26E · Benton, TNJan 19, 1980 · N2994H · Substantial damageNTSB IAD80FKW05Accident · No injuriesClosedPiper PA-28 · Carryville, TNJan 15, 1980 · N9216W · Substantial damageNTSB IAD80FKW04Accident · Serious injuriesClosedRaven S55A · Knoxville, TNJan 3, 1980 · N8542L · No damage