NTSB investigations, 1980, 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, 1980, 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\") = 1980
    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 ATL81FKG06Accident · No injuriesClosedCessna 152 · Americus, GADec 30, 1980 · N4737B · Substantial damageNTSB ATL81FKG05Accident · No injuriesClosedBeech 200 · Alma, GADec 16, 1980 · N300CP · Substantial damageNTSB ATL81FA027Accident · Serious injuriesClosedBeech G-185 · Atlanta, GADec 13, 1980 · N9684R · DestroyedNTSB ATL81FA028Accident · 1 fatalClosedPiper PA-28 · Valdosta, GADec 12, 1980 · N9115J · DestroyedNTSB ATL81FKG04Accident · Minor injuriesClosedAeronca 7CCM · Douglasville, GADec 4, 1980 · N2558B · Substantial damageNTSB ATL81IA023Incident · No injuriesClosedDouglas DC-8 · Atlanta, GADec 3, 1980 · N864FT · Minor damageNTSB ATL81IA017Incident · No injuriesClosedCessna 340A · Rome, GANov 20, 1980 · N44RK · Minor damageNTSB ATL81FKG03Accident · No injuriesClosedChampion 7ECA · Madison, GANov 19, 1980 · N5114X · Substantial damageNTSB NYC81FKG02Accident · Minor injuriesClosedCessna 140 · Stockbridge, GANov 15, 1980 · N76151 · Substantial damageNTSB ATL81FA013Accident · 2 fatalClosedCessna T210N · Baxley, GANov 7, 1980 · N5392A · DestroyedNTSB ATL81FA011Accident · 1 fatalClosedCessna T210M · Pearson, GAOct 31, 1980 · N761HK · DestroyedNTSB ATL81FA010Accident · 1 fatalClosedBellanca 8KCAB · Woodland, GAOct 30, 1980 · N4108Y · DestroyedNTSB ATL81FA008Accident · 4 fatalClosedCessna 310 · Milledgeville, GAOct 23, 1980 · N5882M · DestroyedNTSB ATL81DLA01Accident · No injuriesClosedMustang II · Nashville, GAOct 13, 1980 · N363RD · Substantial damageNTSB ATL81FKG01Accident · No injuriesClosedCessna A188B · Buena Vista, GAOct 7, 1980 · N6369G · Substantial damageNTSB ATL81FA001Accident · 1 fatalClosedCessna 210 · Cartersville, GAOct 1, 1980 · N6956N · DestroyedNTSB ATL80FKG29Accident · No injuriesClosedBellanca 17-31 · Hampton, GASep 21, 1980 · N7374V · Substantial damageNTSB ATL80FKG30Accident · Minor injuriesClosedPiper PA-25 · Claxton, GASep 20, 1980 · N6571Z · DestroyedNTSB ATL80FKG28Accident · Minor injuriesClosedPiper PA-23 · Cartersville, GASep 19, 1980 · N1482P · Substantial damageNTSB ATL80IA098Incident · No injuriesClosedConvair 440 · Brunswick, GASep 18, 1980 · N477KW · Minor damageNTSB ATL80FKG27Accident · Minor injuriesClosedAerostar 601P · Peachtree City, GASep 15, 1980 · N333BM · Substantial damageNTSB ATL80FKG26Accident · Minor injuriesClosedCessna 150 · Covington, GASep 15, 1980 · N2934V · DestroyedNTSB ATL80DKG25Accident · No injuriesClosedCessna 172A · Athens, GASep 14, 1980 · N7584T · Substantial damageNTSB ATL80FA094Accident · Minor injuriesClosedLear Jet 24 · Chamblee, GASep 10, 1980 · N127DM · Substantial damageNTSB ATL80DLA15Accident · Serious injuriesClosedCessna T188C · Moultrie, GASep 8, 1980 · N2288J · DestroyedNTSB ATL80FKG24Accident · Serious injuriesClosedCessna 172N · Atlanta, GASep 6, 1980 · N738FE · DestroyedNTSB ATL80FA090Accident · 1 fatalClosedCessna 172 · Milledgeville, GASep 6, 1980 · N13268 · Substantial damageNTSB ATL80DLA14Accident · No injuriesClosedGrumman G-164A · Berlin, GASep 5, 1980 · N8939H · Substantial damageNTSB ATL80FKG22Accident · No injuriesClosedPiper PA-38 · Jefferson, GASep 3, 1980 · N2446F · Substantial damageNTSB ATL80DLA13Accident · No injuriesClosedHughes 269B · Meigs, GASep 3, 1980 · N9303F · Substantial damageNTSB ATL80FA088Accident · 1 fatalClosedAerostar 601P · Summerville, GASep 2, 1980 · N90463 · DestroyedNTSB ATL80FKG23Accident · No injuriesClosedCessna T210N · Jonesboro, GAAug 30, 1980 · N4966C · DestroyedNTSB ATL80DLA12Accident · No injuriesClosedCessna 172 · Jekyll Island, GAAug 30, 1980 · N739FX · Substantial damageNTSB ATL80FLA10Accident · No injuriesClosedPiper PA-30 · Valdosta, GAAug 28, 1980 · N8353Y · Substantial damageNTSB ATL80FLA11Accident · No injuriesClosedCessna A188 · Hopeful, GAAug 26, 1980 · N8179V · Substantial damageNTSB ATL80FKG21Accident · No injuriesClosedCessna 182 · Douglas, GAAug 22, 1980 · N229C · Substantial damageNTSB ATL80DKG20Accident · No injuriesClosedCessna 152 · Lawrenceville, GAAug 21, 1980 · N25843 · Substantial damageNTSB ATL80DLA08Accident · No injuriesClosedRockwell S-2R · Colquitt, GAAug 20, 1980 · N4926X · Substantial damageNTSB ATL80DLA07Accident · No injuriesClosedGrumman G-164A · Cairo, GAAug 19, 1980 · N8528 · Substantial damageNTSB ATL80DLA09Accident · Serious injuriesClosedBell 47G · Blakely, GAAug 16, 1980 · N1159W · Substantial damageNTSB ATL80FLA06Accident · No injuriesClosedTom Cat MK-5A · Quitman, GAAug 15, 1980 · N3575B · Substantial damageNTSB ATL80DKG19Accident · No injuriesClosedCessna 188 · Albany, GAAug 13, 1980 · N9822G · Substantial damageNTSB ATL80FKG18Accident · Minor injuriesClosedCessna R182 · Chamblee, GAAug 6, 1980 · N78RG · Substantial damageNTSB ATL80FLA05Accident · No injuriesClosedCessna A188B · Moultrie, GAAug 2, 1980 · N9364R · Substantial damageNTSB ATL80FKG16Accident · Serious injuriesClosedPiper PA-25 · Unadilla, GAJul 26, 1980 · N4970Y · DestroyedNTSB ATL80DKG15Accident · Minor injuriesClosedCessna 177B · Stone Mt, GAJul 22, 1980 · N13589 · Substantial damageNTSB ATL80DKG14Accident · No injuriesClosedPiper PA-25 · Dudley, GAJul 22, 1980 · N9529P · DestroyedNTSB ATL80DKG11Accident · No injuriesClosedCessna 152 · Griffin, GAJul 19, 1980 · N66934 · Substantial damageNTSB ATL80FKG13Accident · No injuriesClosedCessna 310G · Jasper, GAJul 17, 1980 · N8936Z · Substantial damageNTSB ATL80FKG10Accident · No injuriesClosedCessna 150H · Stockbridge, GAJul 17, 1980 · N6581S · Substantial damage