NTSB investigations, 1976, GA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1976, GA per year, 1962–2026: 4,092 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
202628

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\") = 1976
    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 MIA77FKG14Accident · Serious injuriesClosedPiper PA-28 · Cleveland, GADec 30, 1976 · N5922W · DestroyedNTSB MIA77DKG10Accident · No injuriesClosedCessna 150F · Elberton, GADec 24, 1976 · N7804F · Substantial damageNTSB MIA77FKG12Accident · Serious injuriesClosedPiper J3 · Greensboro, GADec 19, 1976 · N42595 · DestroyedNTSB MIA77FKG09Accident · No injuriesClosedPiper PA-30 · Macon, GADec 19, 1976 · N8983Y · Substantial damageNTSB MIA77DKG13Accident · No injuriesClosedGrum Amer AA-5 · Fairmont, GADec 19, 1976 · N71921 · Substantial damageNTSB MIA77FKG11Accident · No injuriesClosedCessna U206A · Palmetto, GADec 17, 1976 · N4819F · Substantial damageNTSB MIA77FKG01Accident · No injuriesClosedCessna 210L · Marietta, GADec 14, 1976 · N2440S · Substantial damageNTSB MIA77DKG08Accident · No injuriesClosedBell 47D1 · Vanceville, GADec 12, 1976 · N3575 · Substantial damageNTSB MIA77FA012Accident · 2 fatalClosedCessna 182P · Savannah, GANov 26, 1976 · N21311 · DestroyedNTSB MIA77FKG07Accident · No injuriesClosedAero Comdr 500B · Savannah, GANov 18, 1976 · N22MC · Substantial damageNTSB MIA77DKG06Accident · No injuriesClosedErco 415-D · St.Mary'S, GANov 8, 1976 · N94677 · Substantial damageNTSB MIA77FA005Accident · 1 fatalClosedCessna R172E · Jonesboro, GAOct 29, 1976 · N3CD · DestroyedNTSB MIA77DKG05Accident · No injuriesClosedGrumman G-164 · Midville, GAOct 14, 1976 · N48596 · DestroyedNTSB MIA77FKG04Accident · No injuriesClosedGlobe GC-1B · Zebulon, GAOct 10, 1976 · N3320K · Substantial damageNTSB MIA77FA001Accident · 2 fatalClosedCessna 210L · Villanow, GAOct 7, 1976 · N2135S · DestroyedNTSB MIA77FKG03Accident · No injuriesClosedBeech B55 · Atlanta, GAOct 6, 1976 · N9299Q · Substantial damageNTSB MIA77DKG02Accident · No injuriesClosedPiper PA-32 · Valdosta, GAOct 3, 1976 · N3866W · Substantial damageNTSB MIA76FKH11Accident · No injuriesClosedCessna 180 · Fort Valley, GASep 29, 1976 · N1580C · Substantial damageNTSB MIA76DKH10Accident · No injuriesClosedStearman A75N1 · Albany, GASep 16, 1976 · N74188 · Substantial damageNTSB MIA76FKH09Accident · No injuriesClosedGrum Amer AA-1B · Brooks, GASep 10, 1976 · N1413R · Substantial damageNTSB MIA76DKH08Accident · No injuriesClosedCessna 150 · Columbus, GASep 6, 1976 · N45256 · Substantial damageNTSB MIA76FKH07Accident · No injuriesClosedCessna 150 · Stone Mountain, GASep 5, 1976 · N66651 · Substantial damageNTSB MIA76FKH05Accident · Minor injuriesClosedPiper J3C-65 · Atlanta, GASep 5, 1976 · N70546 · Substantial damageNTSB MIA76FKH06Accident · Minor injuriesClosedCessna 177RG · Dahonega, GASep 3, 1976 · N2546V · Substantial damageNTSB MIA76DKH04Accident · Minor injuriesClosedCessna 188B · Quitman, GASep 1, 1976 · N9070R · DestroyedNTSB MIA76DKH03Accident · Minor injuriesClosedNavion L17B · Kennesaw, GASep 1, 1976 · N9509Z · Substantial damageNTSB MIA76DKH02Accident · Minor injuriesClosedWeatherly 201B · Shellman, GAAug 30, 1976 · N1285W · Substantial damageNTSB MIA76FKH01Accident · No injuriesClosedBell 47 · Augusta, GAAug 27, 1976 · N995D · Substantial damageNTSB MIA76FKG99Accident · Minor injuriesClosedPiper PA-25 · Albany, GAAug 26, 1976 · N9706P · Substantial damageNTSB MIA76FKG98Accident · Serious injuriesClosedCessna 172 · Shannon, GAAug 23, 1976 · N8494X · Substantial damageNTSB MIA76FKG96Accident · No injuriesClosedBoeing B-17G · Cordele, GAAug 17, 1976 · N3701G · Substantial damageNTSB MIA76FKG97Accident · Minor injuriesClosedCessna 310F · Columbus, GAAug 13, 1976 · N310Z · Substantial damageNTSB MIA76DKG95Accident · No injuriesClosedCessna 188 · Albany, GAAug 10, 1976 · N9822G · Substantial damageNTSB MIA76AM102Accident · 1 fatalClosedAero Comdr 680T · Alapaha, GAAug 8, 1976 · N601G · DestroyedNTSB MIA76FKG93Accident · 1 fatalClosedCessna A188B · Waynesboro, GAAug 6, 1976 · N53128 · DestroyedNTSB MIA76FKG94Accident · Minor injuriesClosedBoeing B-17G · Rochelle, GAAug 5, 1976 · N4710C · DestroyedNTSB MIA76AM100Accident · Serious injuriesClosedBoeing 727 · Atlanta, GAAug 2, 1976 · N8155G · No damageNTSB MIA76AM099Accident · 1 fatalClosedAero Comdr 100 · Donaldsonville, GAAug 2, 1976 · N4043X · DestroyedNTSB MIA76FKG91Accident · 1 fatalClosedPiper PA-36 · Blakely, GAJul 29, 1976 · N56322 · DestroyedNTSB MIA76FKG90Accident · Minor injuriesClosedCessna 188 · Butler, GAJul 29, 1976 · N91214 · DestroyedNTSB MIA76FKG91Accident · No injuriesClosedCessna 182M · Hampton, GAJul 27, 1976 · N70916 · Substantial damageNTSB MIA76DKG89Accident · No injuriesClosedCessna 150 · Gainesville, GAJul 27, 1976 · N22626 · Substantial damageNTSB MIA76FKG88Accident · No injuriesClosedGrumman G-164A · Hatley, GAJul 15, 1976 · N7904 · Substantial damageNTSB MIA76DKG87Accident · No injuriesClosedCessna 188B · Hawkinsville, GAJul 12, 1976 · N9136R · Substantial damageNTSB MIA76DKG86Accident · No injuriesClosedPiper PA-25 · Americus, GAJul 10, 1976 · N4460Y · Substantial damageNTSB MIA76FKG85Accident · No injuriesClosedPiper PA-36 · Blakely, GAJul 8, 1976 · N56498 · Substantial damageNTSB MIA76DKG84Accident · No injuriesClosedAero-Comdr 600S2R · Albany, GAJul 8, 1976 · N5584X · DestroyedNTSB MIA76AM076Accident · 1 fatalClosedPiper J3C-65 · Cartersville, GAJul 7, 1976 · N70419 · DestroyedNTSB MIA76AM095Accident · 1 fatalClosedCessna 337B · Augusta, GAJul 6, 1976 · N5464S · DestroyedNTSB MIA76FKG83Accident · No injuriesClosedPiper PA-28 · Ochlocknee, GAJul 4, 1976 · N15282 · Substantial damage