Skip to content

NTSB investigations, 1974, GA

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1974, GA per year, 1962–2026: 4,093 cases
1962	1
1963	2
1964	77
1965	114
1966	113
1967	140
1968	101
1969	126
1970	117
1971	131
1972	142
1973	89
1974	117
1975	77
1976	103
1977	113
1978	120
1979	95
1980	92
1981	83
1982	82
1983	84
1984	79
1985	75
1986	56
1987	63
1988	61
1989	51
1990	60
1991	61
1992	54
1993	38
1994	49
1995	47
1996	48
1997	49
1998	54
1999	38
2000	42
2001	49
2002	49
2003	51
2004	46
2005	32
2006	44
2007	54
2008	49
2009	47
2010	48
2011	44
2012	39
2013	30
2014	34
2015	33
2016	42
2017	35
2018	35
2019	39
2020	36
2021	37
2022	42
2023	37
2024	44
2025	24
2026	29

Where

Latest cases

Query with SQL

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") = 1974 AND c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1974
    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.

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") = 1974
  AND c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MIA75AM040Accident · 2 fatalClosedPiper PA-30 · Atlanta, GADec 30, 1974 · N7007Y · Destroyed NTSB MIA75FKG53Accident · Serious injuriesClosedCessna 310K · Atlanta, GADec 20, 1974 · N7056L · Destroyed NTSB MIA75AM037Accident · 1 fatalClosedTemco GC1B · Lafayette, GADec 20, 1974 · N3881K · Destroyed NTSB MIA75AM035Accident · 2 fatalClosedBeech 95-B55 · Atlanta, GADec 20, 1974 · N1633A · Destroyed NTSB MIA75FKG52Accident · No injuriesClosedCessna 182G · St Marys, GADec 14, 1974 · N3725U · Substantial damage NTSB MIA75FKG51Accident · No injuriesClosedBeech K35 · Dalton, GADec 4, 1974 · N6025E · Substantial damage NTSB MIA75FKG50Accident · No injuriesClosedCessna P206 · Augusta, GADec 2, 1974 · N8776Z · Substantial damage NTSB MIA75DKG49Accident · Minor injuriesClosedBell 205A1 · Homerville, GANov 29, 1974 · N59441 · Substantial damage NTSB MIA75DKG47Accident · No injuriesClosedCessna 172 · Stone Mountain, GANov 28, 1974 · N7051Q · Substantial damage NTSB MIA75DKG45Accident · No injuriesClosedCessna 182 · Hillsboro, GANov 15, 1974 · N3368F · Substantial damage NTSB MIA75FKG31Accident · No injuriesClosedCessna 150 · Marietta, GANov 13, 1974 · N8511J · Substantial damage NTSB MIA75FKG38Accident · No injuriesClosedBeech 55 · Augusta, GANov 9, 1974 · N14MB · Substantial damage NTSB MIA75DKG46Accident · No injuriesClosedPiper PA-18 · Resaca, GANov 5, 1974 · N9099D · Substantial damage NTSB MIA75FKG43Accident · Minor injuriesClosedPiper PA-28 · Thomasville, GAOct 28, 1974 · CG-MRN · Substantial damage NTSB MIA75FKG41Accident · No injuriesClosedCessna 310 · Chamblee, GAOct 24, 1974 · N3684D · Substantial damage NTSB MIA74DKG42Accident · No injuriesClosedBellanca 7GCA · Griffin, GAOct 24, 1974 · N8921R · Substantial damage NTSB MIA75FKG40Accident · Serious injuriesClosedLuscombe 8E · Brooks, GAOct 20, 1974 · N1181K · Destroyed NTSB MIA75DKG37Accident · No injuriesClosedCessna 310G · Albany, GAOct 18, 1974 · N2906R · Substantial damage NTSB MIA75FKG39Accident · Serious injuriesClosedPiper PA-32 · Atlanta, GAOct 17, 1974 · N8901N · Substantial damage NTSB MIA75AM022Accident · No injuriesClosedMitsubishi MU-2B · Savannah, GAOct 14, 1974 · N222HH · Minor damage NTSB MIA75FKG36Accident · No injuriesClosedAeronca 7AC · Jonesboro, GAOct 13, 1974 · N83644 · Substantial damage NTSB MIA75DKG35Accident · Minor injuriesClosedPiper PA-18 · Brooklet, GAOct 9, 1974 · N5777D · Destroyed NTSB MIA75FKG31Accident · No injuriesClosedCessna 120 · Stockbridge, GAOct 6, 1974 · N2481N · Substantial damage NTSB MIA75FKG33Accident · Minor injuriesClosedCessna 120 · Dawson, GASep 23, 1974 · N1875N · Substantial damage NTSB MIA75FKG27Accident · No injuriesClosedCallair A-9 · Newington, GASep 23, 1974 · N96252 · Destroyed NTSB MIA75FKG32Accident · 1 fatalClosedFlag Scootr HEC-1 · Claxton, GASep 21, 1974 · N3443 · Destroyed NTSB MIA75AM021Accident · No injuriesClosedBeech D18S · Atlanta, GASep 18, 1974 · N7002 · Substantial damage NTSB MIA74DKG44Accident · No injuriesClosedCessna 150H · Carrollton, GASep 18, 1974 · N22514 · Substantial damage NTSB MIA75DKG30Accident · No injuriesClosedStinson 108-2 · Stone Mountain, GASep 17, 1974 · N888D · Substantial damage NTSB MIA75DKG28Accident · No injuriesClosedBreezy DP2 · Claxton, GASep 11, 1974 · N1276 · Substantial damage NTSB MIA75AM017Accident · 1 fatalClosedBellanca 14-193 · Jeffersonville, GASep 3, 1974 · N8840R · Destroyed NTSB MIA75FKG25Accident · 1 fatalClosedAero Comdr A-9B · Sylvania, GASep 1, 1974 · N7748V · Destroyed NTSB MIA75DKG29Accident · Minor injuriesClosedHughes 269B · Alma, GAAug 30, 1974 · N9301F · Destroyed NTSB MIA75DKG26Accident · No injuriesClosedCessna 172 · Jonesboro, GAAug 29, 1974 · N1622F · Destroyed NTSB MIA75DKG24Accident · No injuriesClosedChampion 7GCA · Stockbridge, GAAug 27, 1974 · N86752 · Substantial damage NTSB MIA75DKG23Accident · Minor injuriesClosedAero Comdr A-9B · Whigham, GAAug 23, 1974 · N7728V · Substantial damage NTSB MIA75DKG22Accident · No injuriesClosedPiper PA-25 · Climax, GAAug 22, 1974 · N4682Y · Substantial damage NTSB MIA75FKG21Accident · Serious injuriesClosedSchempp SH · Perry, GAAug 21, 1974 · N15PE · Destroyed NTSB MIA75FKG20Accident · No injuriesClosedHelio Acft H-295 · Macon, GAAug 20, 1974 · N6475V · Substantial damage NTSB MIA75FKG19Accident · Minor injuriesClosedBoeing A75N1 · Blakely, GAAug 20, 1974 · N65871 · Substantial damage NTSB MIA75FKG17Accident · No injuriesClosedGrumman G-164A · Perry, GAAug 20, 1974 · N7996 · Destroyed NTSB MIA75FKG18Accident · No injuriesClosedCessna 182C · Hampton, GAAug 19, 1974 · N8776T · Substantial damage NTSB MIA74FKG11Accident · Minor injuriesClosedCallair A-9B · Monroe, GAAug 19, 1974 · N7636V · Destroyed NTSB MIA75FKG16Accident · No injuriesClosedAmer Avco AA1-B · Fairburn, GAAug 2, 1974 · N6526L · Substantial damage NTSB MIA75FKG15Accident · No injuriesClosedBeech 65 · Atlanta, GAAug 2, 1974 · N9865 · Substantial damage NTSB MIA75DKG14Accident · No injuriesClosedGrumman G-164A · Edison, GAAug 2, 1974 · N6659 · Substantial damage NTSB MIA75FKG13Accident · Serious injuriesClosedCessna 150 · Stockbridge, GAAug 1, 1974 · N1751Q · Substantial damage NTSB MIA75FKG12Accident · No injuriesClosedCessna 150J · Baxley, GAJul 31, 1974 · N60549 · Substantial damage NTSB MIA74FKG10Accident · Minor injuriesClosedEnstrom F-28A · Atlanta, GAJul 31, 1974 · N9582 · Substantial damage NTSB MIA75FKG07Accident · Minor injuriesClosedCessna 182J · Cumming, GAJul 28, 1974 · N3519F · Destroyed