Skip to content

NTSB investigations, 1971, GA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 MIA72AM061Accident · 3 fatalClosedSiai-Marche S205 · Carters, GADec 28, 1971 · N995WA · Destroyed NTSB MIA72FKG62Accident · Serious injuriesClosedMooney M-20F · Columbus, GADec 25, 1971 · N9592M · Substantial damage NTSB MIA72FKG70Accident · No injuriesClosedMaule M-4 · Statesboro, GADec 24, 1971 · N2052U · Substantial damage NTSB MIA72FKG63Accident · Minor injuriesClosedPiper PA-28 · Homerville, GADec 24, 1971 · N7260F · Substantial damage NTSB MIA72DKG61Accident · Minor injuriesClosedCessna 172H · Athens, GADec 23, 1971 · N3852R · Substantial damage NTSB MIA72IM055Incident · No injuriesClosedBoeing 727 · Atlanta, GADec 21, 1971 · N8168G · Minor damage NTSB MIA72AM056Accident · 2 fatalClosedCessna 150F · Dalton, GADec 21, 1971 · N8014F · Destroyed NTSB MIA72AM052Accident · 1 fatalClosedSchweizer SGS233 · Williamson, GADec 12, 1971 · N1201S · Substantial damage NTSB MIA72FKG60Accident · 1 fatalClosedFly Baby Swords · Winder, GADec 11, 1971 · N2011 · Destroyed NTSB MIA72FKG58Accident · Minor injuriesClosedPiper PA-22 · Lafayette, GADec 4, 1971 · N5961D · Substantial damage NTSB MIA72FKG59Accident · No injuriesClosedAeronca 7AC · Hampton, GANov 30, 1971 · N83644 · Substantial damage NTSB MIA72FKG56Accident · No injuriesClosedBellanca 14-19 · Cairo, GANov 28, 1971 · N7655B · Substantial damage NTSB MIA72FKG57Accident · Serious injuriesClosedPiper J3C-65 · Cedartown, GANov 26, 1971 · N3586N · Substantial damage NTSB MIA72DKG48Accident · No injuriesClosedSchweizer 2-33A · Sylvania, GANov 21, 1971 · N7537 · Substantial damage NTSB MIA72FKG53Accident · No injuriesClosedPitts Spcl SC-1 · Douglasville, GANov 15, 1971 · N6119 · Substantial damage NTSB MIA72FKG55Accident · Minor injuriesClosedPiper PA-22 · Wrens, GANov 14, 1971 · N884A · Substantial damage NTSB MIA72FKG54Accident · No injuriesClosedAerostar 601 · Rome, GANov 7, 1971 · N7431S · Substantial damage NTSB MIA72AM042Accident · 2 fatalClosedPiper PA-22 · Watkinsville, GANov 7, 1971 · N5443Z · Destroyed NTSB MIA72FKG51Accident · Serious injuriesClosedCessna 180H · Hartwell, GAOct 26, 1971 · N75L · Destroyed NTSB MIA72FKG50Accident · 1 fatalClosedAero Comdr 112 · Albany, GAOct 25, 1971 · N112AC · Destroyed NTSB MIA72FKG49Accident · Serious injuriesClosedGlobe GC-1B · Cordele, GAOct 23, 1971 · N3351K · Substantial damage NTSB MIA72AM036Accident · 2 fatalClosedBeech A35 · Homerville, GAOct 17, 1971 · N8544A · Destroyed NTSB MIA72DKG47Accident · No injuriesClosedGlobe GC-1B · Albany, GAOct 16, 1971 · N2414B · Substantial damage NTSB MIA72AM037Accident · 2 fatalClosedCessna U206C · Waleska, GAOct 15, 1971 · N29223 · Destroyed NTSB MIA72AM034Accident · 1 fatalClosedCessna 172H · Fitzgerald, GAOct 10, 1971 · N1448F · Minor damage NTSB MIA72DKG46Accident · No injuriesClosedPiper PA-28 · Waycross, GAOct 3, 1971 · N6954W · Substantial damage NTSB MIA72FKG45Accident · Minor injuriesClosedAero-Comdr S2R · Albany, GASep 28, 1971 · N29A · Destroyed NTSB MIA72AM031Accident · 2 fatalClosedCessna 337F · Cherrylog, GASep 26, 1971 · N1743M · Destroyed NTSB MIA72AM030Accident · 3 fatalClosedMaule M4210C · Eatonton, GASep 25, 1971 · N2004U · Destroyed NTSB MIA72FKG44Accident · No injuriesClosedHughes 269B · Arlington, GASep 23, 1971 · N9489F · Substantial damage NTSB MIA72AM029Accident · 1 fatalClosedPiper PA-28 · Augusta, GASep 22, 1971 · N8439R · Destroyed NTSB MIA72DKG43Accident · No injuriesClosedPiper PA-18 · Valdosta, GASep 16, 1971 · N1891A · Substantial damage NTSB MIA72FKG42Accident · No injuriesClosedCessna 172G · Dahlonega, GASep 15, 1971 · N3714L · Substantial damage NTSB MIA72FKG41Accident · Serious injuriesClosedErco 415-C · Allenhurst, GASep 14, 1971 · N94889 · Destroyed NTSB MIA72DKG39Accident · No injuriesClosedPiper PA-22 · Loganville, GASep 13, 1971 · N4352A · Substantial damage NTSB MIA72FKG40Accident · Serious injuriesClosedBeech A35 · St.Marys, GASep 12, 1971 · N8499A · Substantial damage NTSB MIA72FKG38Accident · No injuriesClosedPiper J-3 · Hiram, GASep 8, 1971 · N6454H · Destroyed NTSB MIA72FKG36Accident · Minor injuriesClosedCessna 170B · Palmetto, GASep 6, 1971 · N8323A · Substantial damage NTSB MIA72DKG37Accident · Minor injuriesClosedCessna 150 · Thomaston, GASep 3, 1971 · N8800G · Substantial damage NTSB MIA72FKG33Accident · No injuriesClosedPiper PA-25 · Thomasville, GAAug 27, 1971 · N8615L · Destroyed NTSB MIA72FKG35Accident · No injuriesClosedPiper PA-28 · Newnan, GAAug 25, 1971 · N3929K · Substantial damage NTSB MIA72FKG31Accident · 1 fatalClosedCallair A-9 · Buena Vista, GAAug 23, 1971 · N3562G · Destroyed NTSB MIA72FKG30Accident · No injuriesClosedCessna 190 · Brunswick, GAAug 23, 1971 · N4310V · Destroyed NTSB MIA72FKG27Accident · Serious injuriesClosedCessna 172I · Marietta, GAAug 22, 1971 · N35683 · Substantial damage NTSB MIA72DKG32Accident · No injuriesClosedSchemp Cirrus · Unadilla, GAAug 22, 1971 · N26TE · Substantial damage NTSB MIA72DKG28Accident · No injuriesClosedCessna 172 · Lafayette, GAAug 22, 1971 · N5188A · Substantial damage NTSB MIA72IM020Incident · No injuriesClosedCessna 310 · Peachtree City, GAAug 21, 1971 · N3606D · Minor damage NTSB MIA72FKG26Accident · Serious injuriesClosedPiper PA-28 · Lithonia, GAAug 21, 1971 · N1715T · Destroyed NTSB MIA72FKG24Accident · Minor injuriesClosedCessna 210E · Clayton, GAAug 20, 1971 · N731JH · Destroyed NTSB MIA72DKG25Accident · No injuriesClosedCallair A9 · Waynesboro, GAAug 20, 1971 · N3579G · Substantial damage