NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 MIA67F0381Accident · No injuriesClosedChampion 7ECA · Bainbridge, GADec 31, 1966 · N2570F · Substantial damageNTSB MIA67A0069Accident · 2 fatalClosedBeech 35 · St.Marys, GADec 31, 1966 · N3279V · DestroyedNTSB MIA67D0347Accident · No injuriesClosedCessna 150 · Montrose, GADec 25, 1966 · N8600S · Substantial damageNTSB MIA67D0341Accident · No injuriesClosedErco 415-D · Logansville, GADec 19, 1966 · N99143 · Substantial damageNTSB MIA67D0324Accident · Minor injuriesClosedCessna 172 · Lakeland, GADec 3, 1966 · N7752X · Substantial damageNTSB MIA67F0321Accident · No injuriesClosedCessna 210 · Atlanta, GADec 2, 1966 · N2340F · Substantial damageNTSB MIA67A0063Accident · No injuriesClosedCessna 320D · Mcrae, GADec 2, 1966 · N4124T · Substantial damageNTSB MIA67A0061Accident · Minor injuriesClosedDouglas A-26B · Dorchester, GANov 26, 1966 · N3157G · DestroyedNTSB MIA67F0279Accident · No injuriesClosedBellanca 14-13 · T. Simons Isle, GANov 8, 1966 · N74384 · Substantial damageNTSB MIA67F0274Accident · Serious injuriesClosedBoeing A75N1 · Vienna, GAOct 21, 1966 · N9906H · Substantial damageNTSB MIA67F0275Accident · No injuriesClosedPiper PA-23 · Atlanta, GAOct 20, 1966 · N3050P · Substantial damageNTSB MIA67F0239Accident · No injuriesClosedBeech 35 · Jonesboro, GAOct 20, 1966 · N3129V · Substantial damageNTSB MIA67A0047Accident · 3 fatalClosedCessna 210 · Fairburn, GAOct 18, 1966 · N6534X · DestroyedNTSB MIA67D0227Accident · No injuriesClosedPiper J4A · Warner Robins, GAOct 15, 1966 · N26730 · Substantial damageNTSB MIA67D0223Accident · No injuriesClosedCessna 182 · Carrollton, GAOct 10, 1966 · N3516U · Substantial damageNTSB MIA67F0291Accident · Minor injuriesClosedN.American P-51D · Chamblee, GAOct 2, 1966 · N13410 · Substantial damageNTSB MIA67F0246Accident · No injuriesClosedCessna 182A · Cairo, GASep 28, 1966 · N2150G · Substantial damageNTSB MIA67D0197Accident · No injuriesClosedPiper PA-32 · Calhoun, GASep 23, 1966 · N3518W · Substantial damageNTSB MIA67D0205Accident · No injuriesClosedCessna 210 · Elberton, GASep 22, 1966 · N2389F · Substantial damageNTSB MIA67A0036Accident · Serious injuriesClosedDouglas DC-8 · Macon, GASep 22, 1966 · N820E · No damageNTSB MIA67D0196Accident · No injuriesClosedPiper PA-30 · Milledgeville, GASep 20, 1966 · N8123Y · Substantial damageNTSB MIA67F0209Accident · No injuriesClosedStinson 108-3 · Marietta, GASep 10, 1966 · N885C · Substantial damageNTSB MIA67D0177Accident · No injuriesClosedBeech 95-B55 · Douglas, GASep 8, 1966 · N455HC · Substantial damageNTSB MIA67F0250Accident · No injuriesClosedMooney M20C · Augusta, GASep 3, 1966 · N6281U · Substantial damageNTSB MIA67F0179Accident · Minor injuriesClosedCessna 150 · Milan, GASep 3, 1966 · N8966S · Substantial damageNTSB MIA67D0178Accident · No injuriesClosedCessna 172 · Lithonia, GASep 2, 1966 · N5588R · Substantial damageNTSB MIA67D0204Accident · No injuriesClosedCessna 150 · Plains, GAAug 28, 1966 · N6924F · Substantial damageNTSB MIA67D0149Accident · No injuriesClosedPiper PA-22 · Villa Rica, GAAug 28, 1966 · N9249D · Substantial damageNTSB CHI67F0195Accident · Serious injuriesClosedPiper PA-25 · Sylvania, GAAug 26, 1966 · N7525Z · DestroyedNTSB MIA67F0202Accident · Serious injuriesClosedPiper PA-25 · Sylvester, GAAug 25, 1966 · N7683Z · DestroyedNTSB MIA67F0159Accident · No injuriesClosedCessna 172F · Cochran, GAAug 23, 1966 · N8309U · Substantial damageNTSB MIA67F0226Accident · Serious injuriesClosedPiper J3C-65 · Millen, GAAug 22, 1966 · N98711 · Substantial damageNTSB MIA67F0237Accident · No injuriesClosedPiper PA-25 · Rosier, GAAug 18, 1966 · N6606Z · Substantial damageNTSB MIA67F0176Accident · Minor injuriesClosedPiper J3 · Roberta, GAAug 18, 1966 · N7218H · Substantial damageNTSB MIA67F0172Accident · No injuriesClosedPiper PA-25 · Cordele, GAAug 18, 1966 · N4419Y · DestroyedNTSB MIA67F0133Accident · No injuriesClosedPiper PA-22 · Claxton, GAAug 18, 1966 · N4335A · Substantial damageNTSB MIA67F0194Accident · No injuriesClosedPiper PA-25 · Shellman, GAAug 17, 1966 · N6406Z · Substantial damageNTSB MIA67F0170Accident · No injuriesClosedPiper PA-24 · Townsend, GAAug 17, 1966 · N5307P · Substantial damageNTSB MIA67D0135Accident · No injuriesClosedCessna 310 · Tifton, GAAug 14, 1966 · N4875B · Substantial damageNTSB MIA67F0173Accident · No injuriesClosedAero Cmdr 200-D · Albany, GAAug 10, 1966 · N2900T · Substantial damageNTSB MIA67D0150Accident · No injuriesClosedCessna 210-5A · Columbus, GAAug 3, 1966 · N4869U · Substantial damageNTSB MIA67D0116Accident · Minor injuriesClosedPiper PA-28 · Autreyville, GAJul 30, 1966 · N9115J · Substantial damageNTSB MIA67D0117Accident · No injuriesClosedCessna 172 · Nashville, GAJul 29, 1966 · N3971L · Substantial damageNTSB MIA67A0018Accident · 1 fatalClosedStearman A75N1 · Edison, GAJul 29, 1966 · N64807 · DestroyedNTSB MIA67F0146Accident · No injuriesClosedCallair A-5T · Oliver, GAJul 25, 1966 · N2965G · Substantial damageNTSB MIA67F0107Accident · No injuriesClosedCessna 310 · Atlanta, GAJul 25, 1966 · N3684D · Substantial damageNTSB MIA67F0092Accident · Serious injuriesClosedPiper PA-25 · Metter, GAJul 23, 1966 · N7246Z · DestroyedNTSB MIA67F0083Accident · No injuriesClosedCallair A-6 · Baconton, GAJul 23, 1966 · N2930G · DestroyedNTSB MIA67F0076Accident · No injuriesClosedPiper PA-24 · Marietta, GAJul 19, 1966 · N8613P · Substantial damageNTSB MIA67A0010Accident · No injuriesClosedHughes 269B · Americus, GAJul 19, 1966 · N9438F · Substantial damage