Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 MIA73FKG54Accident · 2 fatalClosedN. American F-51D · Flowery Branch, GADec 30, 1972 · N9149R · Destroyed NTSB MIA73FKG56Accident · Serious injuriesClosedPiper PA-22 · Peachtree City, GADec 29, 1972 · N3649A · Substantial damage NTSB MIA73DKG55Accident · Minor injuriesClosedSidewinder Smith · Milledgeville, GADec 28, 1972 · N2285 · Substantial damage NTSB MIA73AMO64Accident · 2 fatalClosedCessna 310 · Shellman, GADec 20, 1972 · N2691C · Destroyed NTSB MIA73FKG53Accident · No injuriesClosedCessna 150G · Chamblee, GADec 19, 1972 · N8392J · Substantial damage NTSB MIA73FKG52Accident · Minor injuriesClosedBeech A23 · Jefferson, GADec 17, 1972 · N3559R · Destroyed NTSB MIA73AM059Accident · 1 fatalClosedAero Comdr 680V · Augusta, GADec 9, 1972 · N1195Z · Destroyed NTSB MIA73FKG51Accident · No injuriesClosedPiper J3C-65 · Cordele, GADec 3, 1972 · N3545N · Substantial damage NTSB MIA73FKG50Accident · Minor injuriesClosedCessna 150H · Reidsville, GADec 2, 1972 · N6982S · Substantial damage NTSB MIA73FKG49Accident · Minor injuriesClosedCessna 150J · Hartwell, GANov 27, 1972 · N50572 · Destroyed NTSB MIA73DKG57Accident · No injuriesClosedEaa Biplane P · Macon, GANov 23, 1972 · N1419 · Destroyed NTSB MIA73FKG48Accident · Minor injuriesClosedCessna 310N · Macon, GANov 19, 1972 · N4116Q · Substantial damage NTSB MIA73AMO52Accident · 2 fatalClosedCessna 182P · Porterdale, GANov 19, 1972 · N9397G · Destroyed NTSB MIA73DKGH7Accident · Minor injuriesClosedChampion 7BCM · Richmond Hill, GANov 12, 1972 · N2552B · Substantial damage NTSB MIA73AM048Accident · No injuriesClosedBoeing 727 · Atlanta, GANov 8, 1972 · N8156G · Substantial damage NTSB MIA73AM047Accident · 1 fatalClosedNavion A · Brunswick, GANov 5, 1972 · N4340K · Destroyed NTSB MIA73IM046Incident · No injuriesClosedDouglas DC-8 · Atlanta, GANov 1, 1972 · N801E · Minor damage NTSB MIA73AMO43Accident · No injuriesClosedBeech D18S · Oglethorpe, GAOct 22, 1972 · N270QS · Substantial damage NTSB MIA73FKG45Accident · Minor injuriesClosedHughes 269C · Chamblee, GAOct 19, 1972 · N9670F · Substantial damage NTSB MIA73FKG44Accident · No injuriesClosedCessna 150 · Atlanta, GAOct 16, 1972 · N7075F · Substantial damage NTSB MIA73DLG27Accident · No injuriesClosedPiper PA-23 · No.Myrtle Bch, GAOct 14, 1972 · N6281Y · Substantial damage NTSB MIA73DKG46Accident · No injuriesClosedGrumman G-164A · Quitman, GAOct 14, 1972 · N7833 · Substantial damage NTSB MIA73DKG42Accident · No injuriesClosedCessna 150H · Canton, GAOct 11, 1972 · N23486 · Substantial damage NTSB MIA73DKG41Accident · No injuriesClosedCallair A-9 · Fairmount, GAOct 8, 1972 · N7233V · Substantial damage NTSB MIA73FKG43Accident · 1 fatalClosedPiper J3C-65 · Lagrange, GAOct 7, 1972 · N7398H · No damage NTSB MIA73FKG38Accident · No injuriesClosedPiper PA-28 · Jonesboro, GASep 26, 1972 · N2660T · Substantial damage NTSB MIA73FKG40Accident · Serious injuriesClosedCessna 336 · Augusta, GASep 25, 1972 · N1794Z · Destroyed NTSB MIA73FKG36Accident · No injuriesClosedCessna 401 · Gainesville, GASep 20, 1972 · N7822F · Substantial damage NTSB MIA73DKG39Accident · No injuriesClosedCessna 180 · Augusta, GASep 20, 1972 · N92CP · Substantial damage NTSB MIA73FKG37Accident · Minor injuriesClosedPiper PA-28 · Kennesaw, GASep 17, 1972 · N5096T · 2 aircraft · Substantial damage NTSB MIA73FKG35Accident · No injuriesClosedPiper PA-24 · Augusta, GASep 16, 1972 · N8552P · Substantial damage NTSB MIA73FKG33Accident · Serious injuriesClosedHughes 269A · Elberton, GASep 6, 1972 · N8917F · Destroyed NTSB MIA73DKG18Accident · No injuriesClosedAmer Avco AA1A · Ft Benning, GASep 6, 1972 · N9305L · Substantial damage NTSB MIA73AM024Accident · 2 fatalClosedPiper PA-28 · Alma, GAAug 29, 1972 · N95391 · Destroyed NTSB MIA73DKG31Accident · No injuriesClosedMooney M20 · Stone Mountain, GAAug 25, 1972 · N3595X · Substantial damage NTSB MIA73AM022Accident · 3 fatalClosedCessna 337C · Mount Vernon, GAAug 24, 1972 · N2584S · Destroyed NTSB MIA73AM020Accident · No injuriesClosedFord MTR 5-AT-B · Peachtree City, GAAug 23, 1972 · N9637 · Substantial damage NTSB MIA73DKG30Accident · No injuriesClosedPiper J-3C · Quitman, GAAug 22, 1972 · N98483 · Substantial damage NTSB MIA73DKG28Accident · No injuriesClosedTaylorcraft BC-65 · Monteith, GAAug 20, 1972 · N23606 · Substantial damage NTSB MIA73FKG26Accident · No injuriesClosedAero Comdr 520 · Thomson, GAAug 18, 1972 · N2636B · Substantial damage NTSB MIA73DKG27Accident · No injuriesClosedCessna 310 · Atlanta, GAAug 16, 1972 · N1310 · Substantial damage NTSB MIA73DKG23Accident · No injuriesClosedPiper PA-24 · Hartwell, GAAug 15, 1972 · N6145P · Destroyed NTSB MIA73FKG24Accident · Serious injuriesClosedThorp T-18 · Marietta, GAAug 13, 1972 · N110JH · Destroyed NTSB MIA73DKG25Accident · No injuriesClosedCessna 150 · Hortense, GAAug 13, 1972 · N8715S · Substantial damage NTSB MIA73FKG22Accident · No injuriesClosedPiper PA-18 · Cordele, GAAug 12, 1972 · N7266K · Substantial damage NTSB MIA73FKG21Accident · 1 fatalClosedCessna A188A · Sylvester, GAAug 5, 1972 · N4409Q · Destroyed NTSB MIA73DKG20Accident · No injuriesClosedAero Comdr A-9B · Vienna, GAAug 4, 1972 · N8021V · Destroyed NTSB MIA73FKG19Accident · No injuriesClosedBeech 58 · Lithonia, GAAug 1, 1972 · N8400C · Substantial damage NTSB MIA73FKG17Accident · No injuriesClosedPiper PA-25 · Chula, GAJul 30, 1972 · N8596L · Substantial damage NTSB MIA73FKG16Accident · No injuriesClosedPiper PA-22 · Lithonia, GAJul 29, 1972 · N1518P · Substantial damage