Skip to content

NTSB investigations, 1975, GA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1975, GA per year, 1962–2026: 4,091 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	27

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") = 1975 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\") = 1975
    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") = 1975
  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 MIA76AM103Accident · Serious injuriesClosedBoeing 727 · Atlanta, GADec 22, 1975 · N454DA · No damage NTSB MIA76FKG38Accident · Serious injuriesClosedLake LA4200 · Ringgold, GADec 21, 1975 · N1082L · Substantial damage NTSB MIA76FKG37Accident · No injuriesClosedPiper PA-28R · Brunswick, GANov 29, 1975 · N3874T · Substantial damage NTSB MIA76FKG36Accident · No injuriesClosedCessna 170B · Fayetteville, GANov 28, 1975 · N3140A · Substantial damage NTSB MIA76AM045Accident · 2 fatalClosedCessna 120 · Warner Robins, GANov 22, 1975 · N3593V · Destroyed NTSB MIA76FKG35Accident · No injuriesClosedCessna 140 · Newnan, GANov 21, 1975 · N5373C · Substantial damage NTSB MIA76FKG33Accident · No injuriesClosedPiper PA-16 · Pitts, GANov 9, 1975 · N5207H · Substantial damage NTSB MIA76FKG31Accident · No injuriesClosedCessna 182 · Atlanta, GANov 9, 1975 · N7380N · Substantial damage NTSB MIA76FKG34Accident · No injuriesClosedPiper PA-24 · Peachtree City, GAOct 31, 1975 · N8124P · Substantial damage NTSB MIA76FKG32Accident · No injuriesClosedCessna 172 · Shannon, GAOct 26, 1975 · N4030F · Substantial damage NTSB MIA76FKG29Accident · No injuriesClosedMooney M20E · Valdosta, GAOct 21, 1975 · N79346 · Substantial damage NTSB MIA76FKG28Accident · Serious injuriesClosedCessna 120 · Athens, GAOct 20, 1975 · N1809N · Substantial damage NTSB MIA76FKG27Accident · Serious injuriesClosedBellanca 17-30 · Atlanta, GAOct 11, 1975 · N109CB · Substantial damage NTSB MIA76DKG30Accident · No injuriesClosedBensen B-8M · Jasper, GAOct 11, 1975 · N7457 · Substantial damage NTSB MIA76FKG26Accident · No injuriesClosedMaule M-5 · Stone Mountain, GAOct 10, 1975 · N51641 · Substantial damage NTSB MIA76DKG25Accident · No injuriesClosedCessna 150 · Glenville, GAOct 9, 1975 · N66403 · Substantial damage NTSB MIA76FKG24Accident · No injuriesClosedPiper PA-23 · Ringgold, GAOct 3, 1975 · N54772 · Substantial damage NTSB MIA76IM029Incident · No injuriesClosedDouglas DC-9 · Atlanta, GASep 29, 1975 · N1265L · Minor damage NTSB MIA76FKG23Accident · Serious injuriesClosedGrum-Amer AA1A · Subligna, GASep 15, 1975 · N9281L · Substantial damage NTSB MIA76FKG21Accident · No injuriesClosedAeronca 7AC · Stone Mountain, GASep 1, 1975 · N81939 · Substantial damage NTSB MIA76FKG20Accident · No injuriesClosedBellanca 8GCBC · Waynesboro, GASep 1, 1975 · N86756 · Substantial damage NTSB MIA76DKG22Accident · Minor injuriesClosedPiper PA-22 · Claxton, GASep 1, 1975 · N3346B · Substantial damage NTSB MIA76FKG19Accident · No injuriesClosedSchweizer SGS2 · Williamson, GAAug 23, 1975 · N1181S · Substantial damage NTSB MIA76FKG18Accident · No injuriesClosedPiper PA-23 · Jonesboro, GAAug 22, 1975 · N2068P · Substantial damage NTSB MIA76FKG17Accident · Minor injuriesClosedSchemp SD-CRS · Cordele, GAAug 20, 1975 · N230XF · Substantial damage NTSB MIA7LFKG13Accident · Minor injuriesClosedAero Comdr 600S2R · Albany, GAAug 19, 1975 · AN-BOM · Substantial damage NTSB MIA7LDKG11Accident · No injuriesClosedBerkshire C70 · Cordele, GAAug 19, 1975 · N29BW · Substantial damage NTSB MIA76FKG16Accident · No injuriesClosedCessna A188B · Hawkinsville, GAAug 19, 1975 · N53286 · Destroyed NTSB MIA76FKG14Accident · No injuriesClosedCessna 188 · Hawkinsville, GAAug 19, 1975 · N91497 · Substantial damage NTSB MIA76FKG15Accident · No injuriesClosedMooney M20A · Ft Oglethorpe, GAAug 18, 1975 · N8109E · Substantial damage NTSB MIA76FKG12Accident · No injuriesClosedPiper PA-25 · Oglethorpe, GAAug 18, 1975 · N9722P · Destroyed NTSB MIA76FKG10Accident · No injuriesClosedBoeing A75N1 · Chamblee, GAJul 28, 1975 · N52756 · Substantial damage NTSB MIA76DKG09Accident · Minor injuriesClosedCessna 172N · Bremen, GAJul 28, 1975 · N91990 · Substantial damage NTSB MIA76AM010Accident · 5 fatalClosedCessna 320B · Darien, GAJul 25, 1975 · N9854L · Destroyed NTSB MIA76FKG07Accident · Serious injuriesClosedHughes 269C · Atlanta, GAJul 24, 1975 · N8991F · Destroyed NTSB MIA76AM007Accident · 2 fatalClosedAero Comdr 500B · Red Hill, GAJul 22, 1975 · N181Z · Destroyed NTSB MIA76DKG04Accident · No injuriesClosedPiper PA-28 · St George, GAJul 17, 1975 · N32548 · Substantial damage NTSB MIA76AM005Accident · 2 fatalClosedBeech 35 · Dublin, GAJul 16, 1975 · N3408V · Destroyed NTSB MIA76FKG05Accident · No injuriesClosedBeech T-34 · Marietta, GAJul 15, 1975 · N4900S · Substantial damage NTSB MIA76FKG02Accident · No injuriesClosedCessna 182 · Atlanta, GAJul 14, 1975 · N3468U · Substantial damage NTSB MIA76DKG03Accident · Minor injuriesClosedMaule M-4 · Bowdon, GAJul 11, 1975 · N12019 · Substantial damage NTSB MIA76DKG01Accident · No injuriesClosedHughes 369 · Savannah, GAJul 2, 1975 · N9071F · Substantial damage NTSB MIA75AM092Accident · 2 fatalClosedAeronca 7DC · Cedartown, GAJun 27, 1975 · N1057E · Destroyed NTSB MIA75DKC81Accident · No injuriesClosedCessna 182 · St Marys, GAJun 22, 1975 · N70577 · Substantial damage NTSB MIA75FKG80Accident · Minor injuriesClosedHughes 269B · Atlanta, GAJun 20, 1975 · N9564F · Substantial damage NTSB NYC75FKG79Accident · No injuriesClosedHughes 269A · Brooklet, GAJun 17, 1975 · N8731F · Substantial damage NTSB MIA75FKG78Accident · No injuriesClosedCessna 150K · Ellaville, GAJun 13, 1975 · N5720G · Substantial damage NTSB MIA75FKG76Accident · No injuriesClosedPiper PA-28 · Atlanta, GAJun 5, 1975 · N9411N · Substantial damage NTSB MIA75FKG77Accident · 2 fatalClosedN.American B-25H · Dawsonville, GAJun 3, 1975 · N96GC · Destroyed NTSB MIA75FKG75Accident · No injuriesClosedCessna 150 · Sparta, GAJun 1, 1975 · N6204G · Substantial damage