NTSB investigations, 1966, TN

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1966, 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\") = 1966
    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 MIA67F0349Accident · 1 fatalClosedCessna P206A · Dyersburg, TNDec 26, 1966 · N4663F · Substantial damageNTSB MIA67F0317Accident · No injuriesClosedMooney M20C · Nashville, TNDec 18, 1966 · N6075Q · Substantial damageNTSB MIA67A0062Accident · 1 fatalClosedAero Comdr 680 · Spring City, TNDec 2, 1966 · N6857S · DestroyedNTSB MIA67F0295Accident · No injuriesClosedBeech B50 · Nashville, TNNov 22, 1966 · N3665B · Substantial damageNTSB MIA67F0268Accident · 1 fatalClosedPiper PA-28 · Whiteville, TNNov 13, 1966 · N4585R · DestroyedNTSB MIA67F0277Accident · No injuriesClosedCessna 150 · Somerville, TNNov 12, 1966 · N8135F · Substantial damageNTSB MIA67F0267Accident · Serious injuriesClosedCessna 182 · Dyersburg, TNNov 11, 1966 · N5729B · Substantial damageNTSB MIA67F0297Accident · No injuriesClosedLuscombe 8A · Johnson City, TNNov 6, 1966 · N71672 · Substantial damageNTSB MIA67F0263Accident · Minor injuriesClosedMooney M20A · Paris, TNNov 3, 1966 · N1055C · DestroyedNTSB MIA67F0187Accident · No injuriesClosedPiper PA-28 · Chattanooga, TNOct 10, 1966 · N6070W · Substantial damageNTSB MIA67D0214Accident · No injuriesClosedCessna 182E · Nashville, TNOct 10, 1966 · N9234X · Substantial damageNTSB MIA67F0232Accident · No injuriesClosedPiper J-3 · Whiteville, TNOct 8, 1966 · N88533 · Substantial damageNTSB MIA67F0219Accident · No injuriesClosedCessna 150 · Ashland City, TNOct 8, 1966 · N8681G · Substantial damageNTSB MIA67F0235Accident · No injuriesClosedPiper PA-24 · Maryville, TNOct 7, 1966 · N7206P · DestroyedNTSB MIA67A0040Accident · 3 fatalClosedMooney M20E · Dunlap, TNSep 27, 1966 · N6024Q · DestroyedNTSB MIA67F0186Accident · No injuriesClosedPiper PA-12 · Fayetteville, TNSep 16, 1966 · N92765 · Substantial damageNTSB MIA67D0181Accident · Serious injuriesClosedSchleicher KA-6CR · Johnson City, TNSep 5, 1966 · N1304S · Substantial damageNTSB MIA67A0032Accident · 2 fatalClosedSchweizer TG-3A · Lewisburg, TNSep 3, 1966 · N1436M · DestroyedNTSB MIA67F0166Accident · No injuriesClosedPiper PA-28 · Bristol, TNSep 2, 1966 · N7866W · Substantial damageNTSB MIA67A0022Accident · 2 fatalClosedPiper PA-28 · Greenville, TNAug 10, 1966 · N9236J · DestroyedNTSB MIA67F0113Accident · No injuriesClosedBeech 95-55 · Nashville, TNAug 6, 1966 · N1356Z · Substantial damageNTSB MIA67D0086Accident · No injuriesClosedCessna 172 · Tiptonville, TNJul 30, 1966 · N3794L · Substantial damageNTSB MIA67A0054Accident · 1 fatalClosedMooney M20C · Roan Mountn, TNJul 30, 1966 · N6054Q · DestroyedNTSB MIA67F0101Accident · No injuriesClosedPiper PA-30 · Nashville, TNJul 20, 1966 · N7386Y · Substantial damageNTSB MIA67F0009Accident · Minor injuriesClosedPiper PA12 · Gallatin, TNJul 17, 1966 · N98966 · Substantial damageNTSB MIA67A0007Accident · No injuriesClosedBell 47D1 · Powell, TNJul 16, 1966 · N6357X · Substantial damageNTSB MIA67F0100Accident · Minor injuriesClosedAero Comdr 520 · Linden, TNJul 10, 1966 · N500U · Substantial damageNTSB MIA67D0013Accident · No injuriesClosedBeech A23 · Rockwood, TNJul 6, 1966 · N1484L · Substantial damageNTSB MIA67D0012Accident · No injuriesClosedCessna 182G · Cleveland, TNJul 4, 1966 · N3219S · Substantial damageNTSB MIA67F0002Accident · No injuriesClosedForney F1A · Mt Pleasant, TNJun 21, 1966 · N3022G · Substantial damageNTSB MIA66F0593Accident · No injuriesClosedCessna 337 · Knoxville, TNJun 15, 1966 · N6212F · Substantial damageNTSB MIA67F0003Accident · Minor injuriesClosedPiper PA28 · Bristol, TNJun 14, 1966 · N8776W · Substantial damageNTSB MIA66F0598Accident · No injuriesClosedBeech A23 · Warrensburg, TNJun 13, 1966 · N1441L · Substantial damageNTSB MIA66F0578Accident · Minor injuriesClosedPiper PA-22 · Parsons, TNJun 12, 1966 · N7434D · DestroyedNTSB MIA66D0597Accident · No injuriesClosedAeronca 7AC · Nashville, TNJun 12, 1966 · N82350 · Minor damageNTSB MIA67D0007Accident · No injuriesClosedPiper PA22 · Tullahoma, TNJun 11, 1966 · N4918Z · Substantial damageNTSB MIA67F0042Accident · Serious injuriesClosedPiper PA-24 · Livingston, TNJun 10, 1966 · N7235P · Substantial damageNTSB MIA66D0574Accident · Minor injuriesClosedAeronca 7AC · Fayetteville, TNMay 29, 1966 · N83857 · Substantial damageNTSB MIA66D0573Accident · No injuriesClosedCessna 170B · Johnson City, TNMay 23, 1966 · N8278A · Substantial damageNTSB MIA66F0548Accident · Serious injuriesClosedCessna 150 · Knoxville, TNMay 15, 1966 · N6088T · DestroyedNTSB MIA66A0133Accident · 1 fatalClosedFairchild 24G · Memphis, TNMay 15, 1966 · N19117 · DestroyedNTSB MIA66F0543Accident · Serious injuriesClosedCessna 170B · Greenville, TNMay 8, 1966 · N3118A · Substantial damageNTSB MIA66F0522Accident · No injuriesClosedPiper PA-24 · Nashville, TNApr 29, 1966 · N8188P · Substantial damageNTSB MIA66D0517Accident · No injuriesClosedCessna 182 · Shelbyville, TNApr 22, 1966 · N6302B · Substantial damageNTSB MIA66A0119Accident · Serious injuriesClosedBell 47G-2 · Lafollette, TNApr 10, 1966 · N5182B · Substantial damageNTSB MIA66A0118Accident · 1 fatalClosedCessna 185A · Lafollette, TNApr 8, 1966 · N4184Y · DestroyedNTSB MIA66A0115Accident · 4 fatalClosedBeech 95 · Milligan, TNApr 6, 1966 · N495AA · DestroyedNTSB MIA66D0476Accident · Minor injuriesClosedChampion 7FC · Millington, TNMar 27, 1966 · N7534E · Substantial damageNTSB MIA66A0107Accident · 2 fatalClosedPiper PA-23 · Gallatin, TNMar 20, 1966 · N2179P · Substantial damageNTSB MIA66F0449Accident · Minor injuriesClosedPiper PA-22 · Greenville, TNMar 14, 1966 · N5426Z · Destroyed