NTSB investigations, 1965, GA

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 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\") = 1965
    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 MIA66F0389Accident · No injuriesClosedBoeing PT-13 · Atlanta, GADec 20, 1965 · N1714M · Substantial damageNTSB MIA66A0069Accident · 2 fatalClosedPiper J3C-65 · Metter, GADec 17, 1965 · N7060H · Substantial damageNTSB MIA66D0373Accident · No injuriesClosedPiper PA-28 · Savannah, GADec 10, 1965 · N5797W · Substantial damageNTSB MIA66F0387Accident · 1 fatalClosedAeronca 7AC · Claxton, GADec 5, 1965 · N81509 · DestroyedNTSB MIA66D0380Accident · Minor injuriesClosedAeronca L-16 · Clyattville, GADec 5, 1965 · N2555B · Substantial damageNTSB MIA66A0062Accident · 1 fatalClosedCessna 172 · St Marys, GANov 27, 1965 · N6232E · DestroyedNTSB MIA66F0381Accident · Serious injuriesClosedCessna 172 · Baxley, GANov 26, 1965 · N9709T · DestroyedNTSB MIA66A0058Accident · No injuriesClosedBrantly B-2B · Fort Valley, GANov 20, 1965 · N2164U · Substantial damageNTSB MIA66F0388Accident · No injuriesClosedPiper PA-24 · Columbus, GANov 19, 1965 · N5210P · Substantial damageNTSB MIA66F0327Accident · No injuriesClosedWaco UEC · Macon, GANov 19, 1965 · N13037 · Substantial damageNTSB MIA66A0055Accident · 4 fatalClosedBeechcraft M35 · Red Oak, GANov 11, 1965 · N9742R · DestroyedNTSB MIA66I0053Incident · No injuriesClosedDouglas DC-7 · Atlanta, GANov 5, 1965 · N8215H · Substantial damageNTSB MIA66D0316Accident · No injuriesClosedBeechcraft M-23 · Milledgeville, GANov 4, 1965 · N8723M · Substantial damageNTSB MIA66A0052Accident · Minor injuriesClosedPiper PA-24 · Homer, GANov 4, 1965 · N6579P · Substantial damageNTSB MIA66A0048Accident · No injuriesClosedMartin B-26C · Atlanta, GAOct 29, 1965 · N5546N · Substantial damageNTSB MIA66A0045Accident · 2 fatalClosedCessna 205 · St Simons Isle, GAOct 22, 1965 · N4819U · DestroyedNTSB MIA66F0314Accident · No injuriesClosedCessna 172 · Ludowici, GAOct 21, 1965 · N7367T · Substantial damageNTSB MIA66F0319Accident · Serious injuriesClosedPiper PA-28 · Chamblee, GAOct 17, 1965 · N6209W · DestroyedNTSB MIA66A0041Accident · 2 fatalClosedBrantly B-2 · Griffin, GAOct 13, 1965 · N5975X · DestroyedNTSB MIA66D0265Accident · No injuriesClosedCessna 120 · Chamblee, GAOct 3, 1965 · N3185N · Substantial damageNTSB MIA66D0268Accident · No injuriesClosedPiper PA-28 · Jonesboro, GAOct 2, 1965 · N5824W · Substantial damageNTSB MIA66F0271Accident · No injuriesClosedBeechcraft 35 · Pine Mountain, GASep 25, 1965 · N2962V · Substantial damageNTSB MIA66A0033Accident · 1 fatalClosedCessna 170B · Chamblee, GASep 22, 1965 · N3513C · Substantial damageNTSB MIA66F0269Accident · No injuriesClosedPiper PA-25 · Pinehurst, GASep 21, 1965 · N6976Z · Substantial damageNTSB MIA66F0272Accident · Serious injuriesClosedPiper PA28 · Valdosta, GASep 18, 1965 · N6336W · No damageNTSB MIA66A0032Accident · 2 fatalClosedCessna 150 · Resaca, GASep 16, 1965 · N7960E · DestroyedNTSB MIA66D0242Accident · No injuriesClosedCommonwelth 185 · Jonesboro, GASep 11, 1965 · N60966 · Substantial damageNTSB MIA66F0220Accident · No injuriesClosedCessna 150 · Griffin, GASep 10, 1965 · N3080J · Substantial damageNTSB MIA66A0029Accident · No injuriesClosedBeechcraft D-18S · Atlanta, GASep 8, 1965 · N57CC · Substantial damageNTSB MIA66D0230Accident · No injuriesClosedPiper PA-28 · Columbus, GASep 5, 1965 · N6673W · Substantial damageNTSB MIA66D0219Accident · Minor injuriesClosedPiper PA-22 · Savannah, GASep 4, 1965 · N977A · DestroyedNTSB MIA66F0197Accident · No injuriesClosedPiper PA-22 · Chamblee, GASep 1, 1965 · N8915C · Substantial damageNTSB MIA66D0203Accident · No injuriesClosedBellanca 14-13 · Dawson, GASep 1, 1965 · N7614E · Substantial damageNTSB MIA66D0235Accident · No injuriesClosedCessna 182 · Hartwell, GAAug 31, 1965 · N2072D · Substantial damageNTSB MIA66A0024Accident · No injuriesClosedCurtis C-46F · Atlanta, GAAug 31, 1965 · N606Z · Substantial damageNTSB MIA66F0157Accident · No injuriesClosedCallair A-5 · Pelham, GAAug 28, 1965 · N9970C · Substantial damageNTSB MIA66F0202Accident · No injuriesClosedPiper PA-25 · Cochran, GAAug 23, 1965 · N7390Z · Substantial damageNTSB MIA66D0199Accident · No injuriesClosedPiper PA-28 · Chamblee, GAAug 22, 1965 · N7027W · Substantial damageNTSB MIA66F0171Accident · No injuriesClosedPiper PA-25 · Harrison, GAAug 21, 1965 · N7497Z · DestroyedNTSB MIA66F0168Accident · No injuriesClosedCessna 175 · Rhine, GAAug 21, 1965 · N9443B · Substantial damageNTSB MIA66F0172Accident · No injuriesClosedLuscombe 8A · Macon, GAAug 20, 1965 · N1706K · Substantial damageNTSB MIA66F0160Accident · No injuriesClosedPiper PA-25 · Girard, GAAug 16, 1965 · N7246Z · Substantial damageNTSB MIA66F0148Accident · No injuriesClosedGrumman G-164 · Smithville, GAAug 16, 1965 · N609U · DestroyedNTSB MIA66F0181Accident · Serious injuriesClosedPiper PA-18 · Lenox, GAAug 5, 1965 · N1316A · DestroyedNTSB MIA66F0092Accident · No injuriesClosedPiper PA-25 · Pinehurst, GAAug 2, 1965 · N6510Z · Substantial damageNTSB MIA66F0155Accident · No injuriesClosedPiper PA-18 · Tifton, GAJul 19, 1965 · N9469D · Substantial damageNTSB MIA66F0089Accident · No injuriesClosedAeronca 15AC · Atlanta, GAJul 19, 1965 · N1217H · Substantial damageNTSB MIA66F0110Accident · Serious injuriesClosedTaylorcraft BC12D1 · Savannah, GAJul 18, 1965 · N44214 · DestroyedNTSB MIA66D0111Accident · No injuriesClosedSlingsby SL4 · Madison, GAJul 18, 1965 · N256JB · Substantial damageNTSB MIA66F0109Accident · Minor injuriesClosedBoeing A-75N1 · Bronwood, GAJul 15, 1965 · N62142 · Substantial damage