NTSB investigations, 1964, 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, 1964, 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\") = 1964
    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 UNK65X1193Accident · 5 fatalClosedPiper PA-22 · Pelham, TNDec 30, 1964 · N8655D · DestroyedNTSB UNK65X1187Accident · Minor injuriesClosedPiper J3C · Roellen, TNDec 30, 1964 · N75264 · Substantial damageNTSB UNK65X0966Accident · No injuriesClosedLuscombe 8A · Tullahoma, TNDec 10, 1964 · N1342B · Substantial damageNTSB UNK65X0939Accident · No injuriesClosedBeechraft 35 · Knoxville, TNDec 6, 1964 · N400X · Substantial damageNTSB UNK65X0843Accident · 1 fatalClosedCessna 172 · Troy, TNNov 26, 1964 · N8059B · DestroyedNTSB UNK65X0776Accident · No injuriesClosedBeechcraft H18 · Knoxville, TNNov 21, 1964 · N177G · Substantial damageNTSB UNK65X0748Accident · No injuriesClosedPiper PA22 · Cookeville, TNNov 17, 1964 · N5362Z · Substantial damageNTSB UNK65X0678Accident · No injuriesClosedBoeing 707 123B · Nashville, TNNov 12, 1964 · N7516A · Substantial damageNTSB UNK65X0654Accident · No injuriesClosedPiper PA22 · Sanburg, TNNov 11, 1964 · N5164Z · Substantial damageNTSB UNK65X0648Accident · No injuriesClosedCessna 150 · Johnson City, TNNov 10, 1964 · N4507U · DestroyedNTSB UNK65X0603Accident · 2 fatalClosedBeechcraft 23 · Grd Junction, TNNov 7, 1964 · N8713M · DestroyedNTSB UNK65X0546Accident · Serious injuriesClosedPiper PA22 · Gleason, TNNov 3, 1964 · N1631P · DestroyedNTSB UNK65X0542Accident · No injuriesClosedCessna 210 · Knoxville, TNNov 3, 1964 · N9528T · Substantial damageNTSB UNK65X0500Accident · No injuriesClosedStinson 108-3 · Sewanee, TNOct 31, 1964 · N6869M · Substantial damageNTSB UNK65X0479Accident · 3 fatalClosedBeechcraft C-50 · Shelbyville, TNOct 29, 1964 · N3799B · DestroyedNTSB UNK65X0258Accident · No injuriesClosedPiper PA24 · Murfreesburg, TNOct 12, 1964 · N4250 · Substantial damageNTSB UNK65X0250Accident · 1 fatalClosedTaylorcraft BC12D · Savannah, TNOct 11, 1964 · N39268 · DestroyedNTSB UNK65X0194Accident · No injuriesClosedGlobe GC1B · Powell, TNOct 8, 1964 · N3767K · Substantial damageNTSB UNK65X0120Accident · No injuriesClosedCessna 182 · Celina, TNOct 3, 1964 · N7222E · Substantial damageNTSB UNK64X3977Accident · Serious injuriesClosedPiper J3C · Jonesboro, TNSep 13, 1964 · N6131H · Substantial damageNTSB UNK64X3971Accident · No injuriesClosedBeechcraft 65-80 · Seward Afb, TNSep 13, 1964 · N6811Q · Substantial damageNTSB UNK64X3787Accident · No injuriesClosedPiper J3 · Rock Is, TNSep 5, 1964 · N6709H · Substantial damageNTSB UNK64X3698Accident · No injuriesClosedPiper J3 · Chattanooga, TNAug 31, 1964 · N30798 · Substantial damageNTSB UNK64X3401Accident · Serious injuriesClosedCessna 172 · Crossville, TNAug 15, 1964 · N6687A · DestroyedNTSB UNK64X3299Accident · No injuriesClosedCessna 150 · Columbia, TNAug 9, 1964 · N4291U · Substantial damageNTSB UNK64X3279Accident · No injuriesClosedCessna 120 · Portland, TNAug 8, 1964 · N76008 · Substantial damageNTSB UNK64X3272Accident · No injuriesClosedNavion · Memphis, TNAug 8, 1964 · N4045X · Substantial damageNTSB UNK64X3232Accident · No injuriesClosedPiper PA23 · Memphis, TNAug 6, 1964 · N5444Y · Substantial damageNTSB UNK64X3140Accident · 2 fatalClosedBeechcraft 35-B33 · Nashville, TNJul 31, 1964 · N8972M · DestroyedNTSB UNK64X3107Accident · No injuriesClosedBeechcraft K35 · Humboldt, TNJul 29, 1964 · N3083C · Substantial damageNTSB UNK64X3080Accident · 1 fatalClosedPiper J3C-65 · Springfield, TNJul 27, 1964 · N41487 · DestroyedNTSB UNK64X3012Accident · Minor injuriesClosedCessna 150 · Ducktown, TNJul 24, 1964 · N7921E · DestroyedNTSB UNK64X2976Accident · Minor injuriesClosedStinson 108 · Madison, TNJul 22, 1964 · N8268K · DestroyedNTSB UNK64X2822Accident · No injuriesClosedCessna 175A · Memphis, TNJul 14, 1964 · N7913T · Substantial damageNTSB UNK64X2742Accident · 39 fatalClosedViscount 745D · Parrotsville, TNJul 9, 1964 · N7405 · DestroyedNTSB UNK64X2722Accident · 1 fatalClosedCaravelle · Knoxville, TNJul 8, 1964 · N1007U · No damageNTSB UNK64X2419Accident · Minor injuriesClosedAeronca 7AC · Sharon, TNJun 21, 1964 · N1547E · Substantial damageNTSB UNK64X2414Accident · No injuriesClosedPiper PA11 · Lawrenceburg, TNJun 21, 1964 · N78643 · Substantial damageNTSB UNK64X2405Accident · Serious injuriesClosedTaylorcraft BC12D · Oneida, TNJun 20, 1964 · N43475 · DestroyedNTSB UNK64X2320Accident · 2 fatalClosedCessna 175 · Clarksville, TNJun 16, 1964 · N7207M · DestroyedNTSB UNK64X2297Accident · No injuriesClosedCessna 210 · Centerville, TNJun 15, 1964 · N6546X · Substantial damageNTSB UNK64X2186Accident · No injuriesClosedBeechraft B23 · Chuckey, TNJun 8, 1964 · N2399Z · Substantial damageNTSB UNK64X2122Accident · No injuriesClosedCessna 182 · Clarksville, TNJun 5, 1964 · N3088Y · Substantial damageNTSB UNK64X2111Accident · Minor injuriesClosedPiper PA22 · Covington, TNJun 4, 1964 · N5125Z · DestroyedNTSB UNK64X2072Accident · No injuriesClosedCessna 310C · Lexington, TNJun 2, 1964 · N1797H · 2 aircraft · Minor damageNTSB UNK64X2056Accident · No injuriesClosedBeechcraft D-18S · Memphis, TNMay 31, 1964 · N80492 · DestroyedNTSB UNK64X2034Accident · No injuriesClosedCessna 182C · Chattanooga, TNMay 30, 1964 · N8625T · Substantial damageNTSB UNK64X1895Accident · No injuriesClosedPiper PA28 · Madison, TNMay 23, 1964 · N7104W · Substantial damageNTSB UNK64X1771Accident · No injuriesClosedCessna 150 · Clarkrange, TNMay 15, 1964 · N7302X · Substantial damageNTSB UNK64X1737Accident · No injuriesClosedBeechcraft 35 · Athens, TNMay 12, 1964 · N3833N · Substantial damage