NTSB investigations, 1976, 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, 1976, 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\") = 1976
    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 IAD77DKW11Accident · No injuriesClosedBrantly B2B · Fayetteville, TNDec 31, 1976 · N2271U · DestroyedNTSB IAD77DKW10Accident · Minor injuriesClosedErco 415CD · Rockwood, TNDec 22, 1976 · N94706 · Substantial damageNTSB IAD77FKW08Accident · Serious injuriesClosedPiper PA-28 · Athens, TNNov 21, 1976 · N8033N · Substantial damageNTSB IAD77FKW09Accident · No injuriesClosedPiper PA-28 · Chattanooga, TNNov 19, 1976 · N4799F · Substantial damageNTSB IAD77DKW07Accident · No injuriesClosedFairchild 24 · Rockwood, TNNov 12, 1976 · N81365 · DestroyedNTSB IAD77DA011Accident · 1 fatalClosedBell 47G-2 · Pigeon Forge, TNNov 6, 1976 · N6755D · DestroyedNTSB IAD77FKW06Accident · Minor injuriesClosedCessna 182 · Elizabethton, TNOct 31, 1976 · N71757 · DestroyedNTSB IAD77FKW05Accident · No injuriesClosedCessna 402 · Erin, TNOct 22, 1976 · N4532Q · Substantial damageNTSB IAD77DKW03Accident · Minor injuriesClosedAeronca 7AC · Cross Plains, TNOct 17, 1976 · N83389 · Substantial damageNTSB IAD77DKW04Accident · No injuriesClosedMooney M20E · Jasper, TNOct 15, 1976 · N6993U · Substantial damageNTSB IAD77FA003Accident · Minor injuriesClosedBeech E18S · Blountville, TNOct 8, 1976 · N633DN · Substantial damageNTSB IAD77FA002Accident · 4 fatalClosedCessna 177RG · Centerville, TNOct 6, 1976 · N1865Q · DestroyedNTSB IAD77DKW01Accident · No injuriesClosedCurtis JN4C · Tullahoma, TNOct 2, 1976 · N49289 · Substantial damageNTSB IAD76FLT20Accident · No injuriesClosedHughes 269B · Millington, TNSep 28, 1976 · N9428F · Substantial damageNTSB IAD76DKW39Accident · No injuriesClosedGrumman G-164 · Livingston, TNSep 13, 1976 · N465Y · Substantial damageNTSB IAD76FKW38Accident · No injuriesClosedCessna 170B · Powell, TNSep 11, 1976 · N2434D · Substantial damageNTSB IAD76FKW37Accident · No injuriesClosedPiper PA-28 · Blountville, TNSep 7, 1976 · N56405 · Substantial damageNTSB IAD76FLT19Accident · No injuriesClosedCessna 182A · Covington, TNSep 5, 1976 · N2141G · Substantial damageNTSB IAD76AI097Accident · 2 fatalClosedCessna 210 · Athens, TNSep 5, 1976 · N6111F · DestroyedNTSB IAD76AI096Accident · 2 fatalClosedBeech E18S · Covington, TNSep 1, 1976 · N1052N · DestroyedNTSB IAD76DLT18Accident · No injuriesClosedBoeing A75 · Somerville, TNAug 9, 1976 · N60601 · Substantial damageNTSB IAD76AI090Accident · 1 fatalClosedPiper J-3 · Ooltewah, TNAug 8, 1976 · N1360M · Substantial damageNTSB IAD76FLT17Accident · Minor injuriesClosedPiper PA-25 · Henderson, TNAug 4, 1976 · N4869Y · DestroyedNTSB IAD76DKW36Accident · No injuriesClosedCessna 150 · Lawrenceburg, TNJul 18, 1976 · N5747G · Substantial damageNTSB IAD76DLT15Accident · No injuriesClosedPiper PA-36 · Memphis, TNJul 13, 1976 · N9934P · Substantial damageNTSB IAD76DKW35Accident · Minor injuriesClosedPiper PA-28 · Bluff City, TNJul 11, 1976 · N7402W · DestroyedNTSB IAD76FLT14Accident · Serious injuriesClosedPiper PA-28 · Memphis, TNJul 3, 1976 · N43229 · DestroyedNTSB IAD76AI079Accident · 1 fatalClosedPiper PA-28 · Jamestown, TNJul 3, 1976 · N55494 · DestroyedNTSB IAD76FLT13Accident · No injuriesClosedGrumman G-164A · Covington, TNJun 21, 1976 · N7951 · Substantial damageNTSB IAD76FKW34Accident · Serious injuriesClosedCessna 150 · Murfreesboro, TNJun 17, 1976 · N50196 · DestroyedNTSB IAD76FLT12Accident · Serious injuriesClosedPiper PA-32 · Dyersburg, TNJun 15, 1976 · N222GE · Substantial damageNTSB IAD76FLT16Accident · No injuriesClosedPiper PA-20 · Memphis, TNJun 10, 1976 · N6896K · Substantial damageNTSB IAD76DLT11Accident · No injuriesClosedCessna 180 · Covington, TNJun 5, 1976 · N9377T · Substantial damageNTSB IAD76FKW33Accident · No injuriesClosedPiper PA-28 · Powells Xroads, TNMay 27, 1976 · N5053T · Substantial damageNTSB IAD76DKW32Accident · Minor injuriesClosedCessna 140 · Jasper, TNMay 21, 1976 · N89178 · Substantial damageNTSB IAD76FKW30Accident · No injuriesClosedBellanca 17-30A · Lebanon, TNMay 2, 1976 · N39845 · DestroyedNTSB IAD76DLT10Accident · No injuriesClosedBeech B19 · Covington, TNApr 29, 1976 · N2167W · Substantial damageNTSB IAD76FKW27Accident · No injuriesClosedPiper PA-31T · Cleveland, TNApr 12, 1976 · N82002 · Substantial damageNTSB IAD76FLT08Accident · No injuriesClosedCessna 150 · Covington, TNApr 11, 1976 · N3400V · Substantial damageNTSB IAD76AI065Accident · 6 fatalClosedCessna 210L · Allardt, TNApr 11, 1976 · N1649X · DestroyedNTSB IAD76FKW28Accident · No injuriesClosedPiper PA-25 · Springfield, TNApr 10, 1976 · N8523L · Substantial damageNTSB IAD76FLT09Accident · No injuriesClosedCessna T337G · Memphis, TNApr 8, 1976 · N5CP · Substantial damageNTSB IAD76FKW26Accident · No injuriesClosedCessna 172 · Spencer, TNApr 4, 1976 · N5063H · Substantial damageNTSB IAD76DKW25Accident · No injuriesClosedCessna 182 · Madisonville, TNMar 28, 1976 · N3941D · Substantial damageNTSB IAD76FKW24Accident · Minor injuriesClosedPiper PA-28 · Murfreesboro, TNMar 19, 1976 · N5270L · Substantial damageNTSB IAD76FLT07Accident · No injuriesClosedBeech A65 · Parsons, TNFeb 27, 1976 · N465AA · Substantial damageNTSB IAD76FKW23Accident · No injuriesClosedCessna 210 · Fayetteville, TNFeb 14, 1976 · N9435T · Substantial damageNTSB IAD76AI055Accident · 3 fatalClosedCessna TP206 · Blountville, TNFeb 13, 1976 · N4651F · DestroyedNTSB IAD76AI056Accident · No injuriesClosedPiper PA-34 · Greeneville, TNFeb 3, 1976 · N55073 · Substantial damageNTSB NYC76AN069Accident · 1 fatalClosedCessna 210H · Dyersburg, TNJan 25, 1976 · N5945F · Substantial damage