NTSB investigations, 1981, TN

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, 1981, 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\") = 1981
    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 ATL82FKW03Accident · Serious injuriesClosedBeech V35B · Concord, TNDec 8, 1981 · N4261S · DestroyedNTSB ATL82FKW02Accident · No injuriesClosedCessna 150 · Whitwell, TNNov 26, 1981 · N7387X · Substantial damageNTSB ATL82FA013Accident · 2 fatalClosedHughes 269A · Elizabethton, TNNov 1, 1981 · N8833F · DestroyedNTSB ATL82FA012Accident · 1 fatalClosedPiper PA-28 · Powell, TNOct 29, 1981 · N6452W · DestroyedNTSB ATL82FA006Accident · 1 fatalClosedCessna A150L · Oak Ridge, TNOct 11, 1981 · N5957J · DestroyedNTSB ATL82DLT01Accident · No injuriesClosedCessna A188B · Kenton, TNOct 9, 1981 · N4853R · DestroyedNTSB ATL82DKW01Accident · No injuriesClosedPiper PA-28 · Jacksboro, TNOct 1, 1981 · N9778W · DestroyedNTSB ATL81FA115Accident · 1 fatalClosedPitts S-1 · Cleveland, TNSep 13, 1981 · N123JC · DestroyedNTSB ATL81FKW26Accident · Serious injuriesClosedTaylorcraft DCO-65 · Pleasant View, TNSep 6, 1981 · N48280 · DestroyedNTSB ATL81FKW25Accident · No injuriesClosedCessna 152 · Columbia, TNAug 25, 1981 · N48005 · Substantial damageNTSB ATL81FKW24Accident · Serious injuriesClosedBensen B8 · Hixson, TNAug 22, 1981 · N3815 · DestroyedNTSB ATL81FLT15Accident · No injuriesClosedAir Tractor AT-301 · Obion, TNAug 20, 1981 · N36498 · Substantial damageNTSB ATL81FKW23Accident · No injuriesClosedCessna 182G · Athens, TNAug 20, 1981 · N2495R · Substantial damageNTSB ATL81FLT13Accident · Serious injuriesClosedCessna 150 · Jackson, TNAug 15, 1981 · N9305U · Substantial damageNTSB ATL81FKW22Accident · No injuriesClosedCessna 210 · Winchester, TNJul 30, 1981 · N22527 · DestroyedNTSB ATL81DKW21Accident · No injuriesClosedTexas Hel M-47A · Rickman, TNJul 29, 1981 · N1001F · Substantial damageNTSB ATL81FKW20Accident · Minor injuriesClosedCessna 206 · Kingsport, TNJul 25, 1981 · N9407G · Substantial damageNTSB ATL81FA100Accident · 4 fatalClosedPiper PA-24 · Center Grove, TNJul 23, 1981 · N5472P · DestroyedNTSB ATL81FA099Accident · 2 fatalClosedAeronca 7AC · Rogersville, TNJul 22, 1981 · N4407E · DestroyedNTSB ATL81FA097Accident · 3 fatalClosedPiper PA-28R · Sweetwater, TNJul 17, 1981 · N8348C · DestroyedNTSB ATL81FLT12Accident · Minor injuriesClosedCessna 172 · Brownsville, TNJul 11, 1981 · N4361R · Substantial damageNTSB ATL81FLT10Accident · 1 fatalClosedPitts S1S · Savannah, TNJun 9, 1981 · N8020 · DestroyedNTSB ATL81FLT09Accident · Minor injuriesClosedCessna 150 · Bolivar, TNMay 29, 1981 · N6789G · Substantial damageNTSB ATL81FA079Accident · 3 fatalClosedCessna 182 · Elizabethton, TNMay 28, 1981 · N444SP · DestroyedNTSB ATL81FA072Accident · 1 fatalClosedPiper PA-30 · Smyrna, TNMay 12, 1981 · N7512Y · DestroyedNTSB ATL81FLT08Accident · No injuriesClosedHughes 269C · Ridgely, TNMay 3, 1981 · N7487F · Substantial damageNTSB ATL81FLT07Accident · No injuriesClosedPiper PA-25 · Pickwick Dam, TNApr 28, 1981 · N7682Z · Substantial damageNTSB ATL81DKW19Accident · No injuriesClosedCessna 152 · Collegedale, TNApr 28, 1981 · N69038 · Substantial damageNTSB ATL81FKW18Accident · No injuriesClosedPiper PA-22 · Tullahoma, TNApr 26, 1981 · N7518D · Substantial damageNTSB ATL81DKW16Accident · No injuriesClosedHughes 369D · Ashland City, TNApr 13, 1981 · N58221 · Substantial damageNTSB ATL81FKW15Accident · No injuriesClosedEnstrom F-28A · Knoxville, TNApr 8, 1981 · N4871 · Substantial damageNTSB ATL81FLT06Accident · No injuriesClosedGrumman G-164B · Brownsville, TNApr 6, 1981 · N6773K · Substantial damageNTSB ATL81DKW14Accident · Minor injuriesClosedVolksplane 1 · Crossville, TNMar 26, 1981 · N2879 · Substantial damageNTSB ATL81FKW12Accident · No injuriesClosedCessna 150F · Lebanon, TNMar 11, 1981 · N7891F · DestroyedNTSB ATL81FA048Accident · 1 fatalClosedCessna 172P · Woodbury, TNFeb 18, 1981 · N51095 · DestroyedNTSB ATL81FKW11Accident · No injuriesClosedPiper PA-28 · Woodbury, TNFeb 15, 1981 · N2845T · Substantial damageNTSB ATL81FKW10Accident · No injuriesClosedCessna U206F · Crossville, TNFeb 14, 1981 · N50946 · DestroyedNTSB ATL81FKW09Accident · Minor injuriesClosedPiper PA-32 · Nashville, TNFeb 14, 1981 · N3932W · DestroyedNTSB ATL81IA037Incident · No injuriesClosedCessna 414 · Jackson, TNJan 26, 1981 · N1678T · Minor damageNTSB ATL81FA035Accident · 2 fatalClosedAeronca 11AC · Maryville, TNJan 24, 1981 · N3267E · Substantial damageNTSB ATL81FKW08Accident · No injuriesClosedCessna 182RG · Sevierville, TNJan 16, 1981 · N4778S · Substantial damageNTSB ATL81FKW06Accident · No injuriesClosedCessna 177RG · Nashville, TNJan 14, 1981 · N52709 · Substantial damageNTSB MKC81FA012Accident · No injuriesClosedBeech F35 · Paris, TNJan 1, 1981 · N266S · Substantial damage