NTSB investigations, 1964, GA

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, 1964, GA per year, 1962–2026: 4,091 cases
19621
19632
196477
1965114
1966113
1967140
1968101
1969126
1970117
1971131
1972142
197389
1974117
197577
1976103
1977113
1978120
197995
198092
198183
198282
198384
198479
198575
198656
198763
198861
198951
199060
199161
199254
199338
199449
199547
199648
199749
199854
199938
200042
200149
200249
200351
200446
200532
200644
200754
200849
200947
201048
201144
201239
201330
201434
201533
201642
201735
201835
201939
202036
202137
202242
202337
202444
202524
202627

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\" = 'GA' 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 UNK65X1042Accident · No injuriesClosedPiper PA24 · Savannah, GADec 18, 1964 · N7781P · Substantial damageNTSB UNK65X0999Accident · No injuriesClosedBeechraft B50A · Atlanta, GADec 13, 1964 · N1378Z · Substantial damageNTSB UNK65X0931Accident · No injuriesClosedPiper PA24 · Athens, GADec 5, 1964 · N6993P · Substantial damageNTSB UNK65X0915Accident · No injuriesClosedCessna 172 · Jonesboro, GADec 4, 1964 · N5625A · Substantial damageNTSB UNK65X0871Accident · No injuriesClosedCessna 210 · Macon, GANov 28, 1964 · N7429E · Substantial damageNTSB UNK65X0745Accident · 6 fatalClosedBeechcraft A35 · Chatsworth, GANov 16, 1964 · N730B · DestroyedNTSB UNK65X0696Accident · Minor injuriesClosedChampion 7EC · Villa Rica, GANov 14, 1964 · N7598E · Substantial damageNTSB UNK65X0564Accident · No injuriesClosedCessna 150 · Jonesboro, GANov 5, 1964 · N1148Y · Substantial damageNTSB UNK65X0378Accident · No injuriesClosedPiper PA24 · Marietta, GAOct 22, 1964 · N7622P · Substantial damageNTSB UNK64X4143Accident · No injuriesClosedCallair A9 · Fort Valley, GASep 25, 1964 · N3612G · DestroyedNTSB UNK64X4071Accident · No injuriesClosedBeechcraft N35 · Atlanta, GASep 20, 1964 · N9450Y · Substantial damageNTSB UNK64X4033Accident · No injuriesClosedCallair A9 · Mill Haven, GASep 18, 1964 · N3579G · Substantial damageNTSB UNK64X3995Accident · Minor injuriesClosedGrumman G164 · Shellnan, GASep 15, 1964 · N597Y · Substantial damageNTSB UNK64X3931Accident · 1 fatalClosedCessna 140 · Darien, GASep 12, 1964 · N76246 · Substantial damageNTSB UNK64X3849Accident · No injuriesClosedCessna 180 · Centralhatchee, GASep 7, 1964 · N2493C · Substantial damageNTSB UNK64X3833Accident · 2 fatalClosedAero Comm 560 · Norcross, GASep 6, 1964 · N2680B · DestroyedNTSB UNK64X3762Accident · Minor injuriesClosedPiper PA18A · Winder, GASep 4, 1964 · N7294D · Substantial damageNTSB UNK64X3718Accident · Minor injuriesClosedPiper J3 · Unadilla, GASep 1, 1964 · N42819 · Substantial damageNTSB UNK64X3633Accident · No injuriesClosedHughes 269A · Waynesboro, GAAug 27, 1964 · N8758F · Substantial damageNTSB UNK64X3594Accident · Serious injuriesClosedPiper J3 · Senoia, GAAug 25, 1964 · N2220M · DestroyedNTSB UNK64X3577Accident · No injuriesClosedCallair A5T · Bainbridge, GAAug 24, 1964 · N2960G · Substantial damageNTSB UNK64X3557Accident · No injuriesClosedBeechcraft T34 · Jesup, GAAug 23, 1964 · N4946C · Substantial damageNTSB UNK64X3554Accident · No injuriesClosedCessna 175 · Cohutta, GAAug 23, 1964 · N6792E · Substantial damageNTSB UNK64X3541Accident · Minor injuriesClosedCallair A5 · Camillia, GAAug 22, 1964 · N9970C · DestroyedNTSB UNK64X3524Accident · 1 fatalClosedCessna 172 · Macon, GAAug 21, 1964 · N7364T · DestroyedNTSB UNK64X3515Accident · Minor injuriesClosedBoeing A75N1 · Edison, GAAug 21, 1964 · N54554 · Substantial damageNTSB UNK64X3497Accident · Serious injuriesClosedPiper J3C · Cassville, GAAug 20, 1964 · N70615 · Substantial damageNTSB UNK64X3445Accident · No injuriesClosedMooney M18C · Cuthbert, GAAug 18, 1964 · N4133 · Substantial damageNTSB UNK64X3420Accident · No injuriesClosedPiper PA12 · Carrolton, GAAug 16, 1964 · N2846M · Substantial damageNTSB UNK64X3414Accident · No injuriesClosedPiper PA24 · Cochran, GAAug 16, 1964 · N6394P · Substantial damageNTSB UNK64X3404Accident · 1 fatalClosedPiper PA-22 · Dalton, GAAug 15, 1964 · N3575A · DestroyedNTSB UNK64X3350Accident · Serious injuriesClosedBell 47G4 · Blakely, GAAug 12, 1964 · N3064G · Substantial damageNTSB UNK64X3218Accident · Serious injuriesClosedPiper PA25 · Berlin, GAAug 4, 1964 · N11984 · DestroyedNTSB UNK64X3217Accident · No injuriesClosedPiper PA24 · Rochelle, GAAug 4, 1964 · N7035P · Substantial damageNTSB UNK64X3214Accident · No injuriesClosedPiper PA11 · Tifton, GAAug 4, 1964 · N4649N · Substantial damageNTSB UNK64X3121Accident · No injuriesClosedBeechcraft G35 · Nashville, GAJul 30, 1964 · N4287D · Substantial damageNTSB UNK64X3076Accident · Minor injuriesClosedHughes 269A · Tennille, GAJul 27, 1964 · N8852F · Substantial damageNTSB UNK64X3057Accident · Serious injuriesClosedBoeing A75N1 · Americus, GAJul 26, 1964 · N73611 · Substantial damageNTSB UNK64X3011Accident · Minor injuriesClosedPiper PA18 · Lenox, GAJul 24, 1964 · N7285K · Substantial damageNTSB UNK64X2972Accident · No injuriesClosedBoeing A75N1 · Dawson, GAJul 22, 1964 · N53793 · Substantial damageNTSB UNK64X2971Accident · No injuriesClosedPiper PA25 · Screvin, GAJul 22, 1964 · N6776Z · DestroyedNTSB UNK64X2957Accident · Minor injuriesClosedBoing A75N1 · Damascus, GAJul 21, 1964 · N62288 · DestroyedNTSB UNK64X2893Accident · No injuriesClosedPiper PA23 · Atlanta, GAJul 18, 1964 · N4594P · Substantial damageNTSB UNK64X2857Accident · No injuriesClosedMooney MK20A · Atlanta, GAJul 16, 1964 · N6031X · Substantial damageNTSB UNK64X2846Accident · Minor injuriesClosedCessna 210 · Chamblee, GAJul 15, 1964 · N9678X · Substantial damageNTSB UNK64X2818Accident · No injuriesClosedBeechcraft 23 · Columbus, GAJul 14, 1964 · N2325J · Substantial damageNTSB UNK64X2736Accident · No injuriesClosedAeronca 7BM · Augusta, GAJul 9, 1964 · N81545 · Substantial damageNTSB UNK64X2553Accident · No injuriesClosedPiper PA18 · Atlanta, GAJun 28, 1964 · N723C · Substantial damageNTSB UNK64X2478Accident · No injuriesClosedCessna 172 · Cloudland, GAJun 25, 1964 · N2492U · Substantial damageNTSB UNK64X2318Accident · No injuriesClosedCessna 150 · Butler, GAJun 16, 1964 · N7204X · Substantial damage