NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 MIA66F0362Accident · No injuriesClosedMooney M20C · Jackson, TNDec 26, 1965 · N5565Q · Substantial damageNTSB MIA66F0372Accident · Minor injuriesClosedNavion A · Cumblnd City, TNDec 23, 1965 · N4896K · Substantial damageNTSB MIA66D0385Accident · No injuriesClosedBellanca 14-13 · Knoxville, TNDec 23, 1965 · N86835 · Substantial damageNTSB MIA66F0345Accident · Minor injuriesClosedCessna 310C · Memphis, TNDec 22, 1965 · N627W · Substantial damageNTSB MIA66F0386Accident · No injuriesClosedBeechcraft 23 · Knoxville, TNDec 14, 1965 · N2399Z · Substantial damageNTSB MIA66F0378Accident · No injuriesClosedPiper PA-24 · Nashville, TNDec 10, 1965 · N8719P · Substantial damageNTSB MIA66F0335Accident · No injuriesClosedBeechcraft H35 · Crossville, TNDec 9, 1965 · N5438D · Substantial damageNTSB MIA66F0323Accident · No injuriesClosedPiper PA-24 · Memphis, TNNov 30, 1965 · N7524P · Substantial damageNTSB MIA66F0336Accident · No injuriesClosedErcoupe 415-C · Winchester, TNNov 28, 1965 · N3084H · Substantial damageNTSB MIA66F0329Accident · No injuriesClosedPiper PA-28 · Columbia, TNNov 25, 1965 · N7918W · Substantial damageNTSB MIA66D0322Accident · No injuriesClosedPiper PA-28 · Bolivar, TNNov 20, 1965 · N8685P · Substantial damageNTSB MIA66F0334Accident · Serious injuriesClosedCessna 172D · Lake City, TNNov 16, 1965 · N2545Y · DestroyedNTSB MIA66D0330Accident · No injuriesClosedPitt S-1-C · Nashville, TNNov 13, 1965 · N14T · Substantial damageNTSB MIA66D0290Accident · No injuriesClosedMooney M20B · Waverly, TNOct 29, 1965 · N74517 · Substantial damageNTSB MIA66D0302Accident · No injuriesClosedPiper PA-24 · Chattanooga, TNOct 24, 1965 · N6871P · Substantial damageNTSB MIA66F0291Accident · No injuriesClosedLuscombe 8A · Fayetteville, TNOct 15, 1965 · N1137K · Substantial damageNTSB MIA66D0259Accident · No injuriesClosedPiper PA-22 · Tullahoma, TNOct 11, 1965 · N4918Z · Substantial damageNTSB MIA66F0258Accident · No injuriesClosedCessna 140 · Fayetteville, TNOct 10, 1965 · N72849 · Substantial damageNTSB MIA66F0236Accident · No injuriesClosedBeechcraft 95-B55 · Nashville, TNSep 23, 1965 · N481A · Substantial damageNTSB MIA66F0204Accident · No injuriesClosedPiper PA-23 · Memphis, TNSep 13, 1965 · N338WS · Substantial damageNTSB MIA66F0220Accident · 1 fatalClosedPiper PA-11 · Jackson, TNSep 7, 1965 · N5571H · DestroyedNTSB MIA66F0228Accident · No injuriesClosedCessna 210 · Dayton, TNSep 5, 1965 · N3643Y · Substantial damageNTSB MIA66D0234Accident · No injuriesClosedPiper PA-22 · White Pine, TNSep 2, 1965 · N9338D · Substantial damageNTSB MIA66D0200Accident · No injuriesClosedAeronca 11AC · Sneedville, TNAug 22, 1965 · N9752E · Substantial damageNTSB MIA66D0129Accident · No injuriesClosedCessna 182 · Nashville, TNAug 15, 1965 · N6343A · Substantial damageNTSB MIA66D0141Accident · Minor injuriesClosedErcoupe 415-G · Baxter, TNAug 14, 1965 · N94434 · Substantial damageNTSB MIA66D0120Accident · No injuriesClosedPiper PA-22 · Memphis, TNAug 8, 1965 · N9593D · Substantial damageNTSB MIA66D0117Accident · No injuriesClosedPiper PA-12 · Murfreesboro, TNAug 2, 1965 · N3619M · Substantial damageNTSB MIA66D0125Accident · No injuriesClosedAeronca 7AC · Athens, TNJul 20, 1965 · N85243 · Substantial damageNTSB MIA66A0012Accident · 1 fatalClosedStinson 108-3 · Oliver Sprgs, TNJul 19, 1965 · N6773M · DestroyedNTSB MIA66F0161Accident · No injuriesClosedBeechcraft E-35 · Pressman Home, TNJul 10, 1965 · N3356C · Substantial damageNTSB MIA66D0062Accident · No injuriesClosedCessna 150D · Columbia, TNJul 8, 1965 · N4486U · Substantial damageNTSB MIA66F0081Accident · No injuriesClosedPiper PA-28 · Gallatin, TNJul 6, 1965 · N5310W · Substantial damageNTSB MIA66F0080Accident · Minor injuriesClosedCessna 150 · Tiptonville, TNJul 5, 1965 · N7094X · Substantial damageNTSB MIA66F0078Accident · No injuriesClosedPiper PA-30 · Shelbyville, TNJul 1, 1965 · N7739Y · Substantial damageNTSB MIA66F0045Accident · 1 fatalClosedCessna 210-5 · Del Rio, TNJun 22, 1965 · N8424Z · DestroyedNTSB MIA66F0041Accident · No injuriesClosedBeechcraft B33 · Powell, TNJun 20, 1965 · N864R · Substantial damageNTSB MIA66D0043Accident · Minor injuriesClosedCessna 140 · Chattanooga, TNJun 20, 1965 · N72386 · Substantial damageNTSB MIA66F0133Accident · No injuriesClosedPiper PA-28 · Ooltewah, TNJun 11, 1965 · N8658W · Substantial damageNTSB MIA65F0124Accident · Serious injuriesClosedCessna 172 · Rutherford, TNJun 5, 1965 · N6073A · Substantial damageNTSB MIA65A0117Accident · 3 fatalClosedPiper PA-24 · Chattanooga, TNJun 5, 1965 · N8379P · DestroyedNTSB MIA65F0123Accident · No injuriesClosedPiper J3L · Chattanooga, TNJun 1, 1965 · N30798 · Substantial damageNTSB MIA65F0096Accident · No injuriesClosedCessna 337 · Alcoa, TNMay 15, 1965 · N2111X · Substantial damageNTSB MIA66D0238Accident · No injuriesClosedBeechcraft C-35 · Mcminnville, TNMay 7, 1965 · N707D · Substantial damageNTSB MIA65D0074Accident · No injuriesClosedCessna 140 · Knoxville, TNMay 5, 1965 · N2388N · Substantial damageNTSB MIA65F0053Accident · No injuriesClosedPiper PA-28 · Memphis, TNApr 23, 1965 · N8904W · Substantial damageNTSB MIA65D0045Accident · No injuriesClosedPiper PA-25 · Trenton, TNApr 22, 1965 · N6208Z · Substantial damageNTSB MIA65F0040Accident · No injuriesClosedPiper PA-22 · Lavinia, TNApr 12, 1965 · N5113Z · DestroyedNTSB MIA65F0050Accident · No injuriesClosedCessna 182 · Murfreesboro, TNApr 11, 1965 · N3176Y · Substantial damageNTSB MIA65F0025Accident · No injuriesClosedPiper PA-24 · Knoxville, TNApr 3, 1965 · N5185 · Substantial damage