Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 MIA80FA021Accident · 5 fatalClosedPiper PA-32 · Woodbine, GADec 21, 1979 · N3802W · Destroyed NTSB MIA80FLA12Accident · 1 fatalClosedNavion H · Waycross, GADec 18, 1979 · N2552T · Destroyed NTSB MIA80FKG14Accident · Minor injuriesClosedAeronca 11AC · Fitzgerald, GADec 12, 1979 · N9552E · Substantial damage NTSB MIA79FLA10Accident · No injuriesClosedBell 206B · Sea Island, GADec 10, 1979 · N59530 · Substantial damage NTSB MIA80FKG13Accident · Serious injuriesClosedCessna T337F · Athens, GADec 8, 1979 · N1119M · Substantial damage NTSB MIA80FKG12Accident · Minor injuriesClosedCessna 310K · Jesup, GADec 6, 1979 · N6983L · Substantial damage NTSB MIA80FKG11Accident · No injuriesClosedBeech 58 · Atlanta, GANov 25, 1979 · N66839 · Substantial damage NTSB MIA80FKG10Accident · No injuriesClosedCessna 182 · Dawson, GANov 21, 1979 · N738CE · Substantial damage NTSB MIA80DKG09Accident · No injuriesClosedPiper PA-38 · Statesboro, GANov 10, 1979 · N2317B · Substantial damage NTSB MIA80FKG07Accident · Serious injuriesClosedPiper PA-28 · Jonesboro, GANov 3, 1979 · N3038Q · Substantial damage NTSB MIA80DKG08Accident · No injuriesClosedGrumman G-164 · Springfield, GANov 1, 1979 · N8057K · Substantial damage NTSB MIA80FKG05Accident · No injuriesClosedBeech 60 · Montezuma, GAOct 30, 1979 · N4762M · Substantial damage NTSB MIA80FKG06Accident · No injuriesClosedBeech A45 · Fayetteville, GAOct 27, 1979 · N5240V · Substantial damage NTSB MIA80FLA04Accident · No injuriesClosedErco 415-C · Camila, GAOct 21, 1979 · N99982 · Substantial damage NTSB MIA80FKG04Accident · No injuriesClosedCessna 152 · Athens, GAOct 13, 1979 · N25889 · Substantial damage NTSB MIA80FKG03Accident · No injuriesClosedCessna 152 · Snellville, GAOct 13, 1979 · N67825 · Substantial damage NTSB MIA80FKG01Accident · No injuriesClosedCessna 150 · Jonesboro, GAOct 7, 1979 · N11791 · Substantial damage NTSB MIA80FKG02Accident · Serious injuriesClosedAdams,Md AX-6 · Helen, GAOct 6, 1979 · N5659 · Destroyed NTSB MIA79DKG71Accident · No injuriesClosedCessna 182Q · Brooklet, GASep 20, 1979 · N759EG · Substantial damage NTSB MIA79FKG70Accident · No injuriesClosedCessna 172M · Atlanta, GASep 16, 1979 · N8177L · Substantial damage NTSB MIA79FKG68Accident · No injuriesClosedCessna 172 · Marietta, GASep 16, 1979 · N696IH · Substantial damage NTSB MIA79FA123Accident · 2 fatalClosedCessna 182P · Folkston, GASep 16, 1979 · N9197M · Destroyed NTSB MIA79FA122Accident · 2 fatalClosedPiper PA-28 · Alma, GASep 16, 1979 · N15029 · Destroyed NTSB MIA79DLA52Accident · Serious injuriesClosedCessna 150 · Brunswick, GASep 7, 1979 · N5603G · No damage NTSB MIA79FKG69Accident · 2 fatalClosedCavalier SA-102 · Cumming, GASep 2, 1979 · N2892 · Destroyed NTSB MIA79FLA48Accident · No injuriesClosedBell 47D1 · Hahira, GASep 1, 1979 · N908B · Destroyed NTSB MIA79FKG67Accident · Minor injuriesClosedCessna 182P · Chamblee, GASep 1, 1979 · N1442M · Substantial damage NTSB MIA79DLA51Accident · Minor injuriesClosedPiper PA-25 · Nashville, GASep 1, 1979 · N6842Z · Substantial damage NTSB MIA79FKG66Accident · Minor injuriesClosedMooney M20D · Atlanta, GAAug 31, 1979 · N6638U · Substantial damage NTSB MIA79DLA49Accident · Serious injuriesClosedPiper PA-25 · Moultire, GAAug 31, 1979 · N9512P · Destroyed NTSB MIA79FKG65Accident · Minor injuriesClosedAero Cmndr S2R600 · Narabi, GAAug 29, 1979 · N8816Q · Destroyed NTSB MIA79DLA47Accident · Minor injuriesClosedPiper PA-25 · Norman Park, GAAug 29, 1979 · N8581L · Substantial damage NTSB MIA79DLA45Accident · No injuriesClosedCessna 170B · Willacoochee, GAAug 25, 1979 · N3115B · Substantial damage NTSB MIA79FKG63Accident · Serious injuriesClosedCessna 150L · Kennesaw, GAAug 21, 1979 · N18036 · Destroyed NTSB MIA79DLA44Accident · No injuriesClosedCessna 152 · Nashville, GAAug 19, 1979 · N89803 · Substantial damage NTSB MIA79DKG62Accident · Minor injuriesClosedCallair A9A · Mcrae, GAAug 14, 1979 · N8412V · Destroyed NTSB MIA79FA112Accident · 1 fatalClosedPiper PA-28 · Canton, GAAug 12, 1979 · N6322R · Destroyed NTSB MIA79FKG59Accident · Minor injuriesClosedChampion 7ECA · Social Circle, GAAug 10, 1979 · N2550F · Destroyed NTSB MIA79DKG60Accident · Serious injuriesClosedCessna 188B · Waynesboro, GAAug 10, 1979 · N4800Q · Substantial damage NTSB MIA79FKG64Accident · Minor injuriesClosedPiper PA-23 · Atlanta, GAAug 8, 1979 · C-GAKE · Substantial damage NTSB MIA79FKG61Accident · No injuriesClosedCessna 188T · Albany, GAAug 8, 1979 · N9822G · Substantial damage NTSB MIA79DKG57Accident · No injuriesClosedHughes 269C · Montezuma, GAAug 7, 1979 · N7422F · Substantial damage NTSB MIA79FKG58Accident · Serious injuriesClosedAyres S2R · Leesburg, GAAug 4, 1979 · N4004U · Destroyed NTSB MIA79DLA42Accident · No injuriesClosedSnow S-2R · Camilla, GAAug 1, 1979 · N4887X · Substantial damage NTSB MIA79DLA41Accident · No injuriesClosedCessna 150 · Camilla, GAJul 27, 1979 · N50635 · Substantial damage NTSB MIA79DKG56Accident · No injuriesClosedPiper PA-36 · Denton, GAJul 25, 1979 · N57880 · Substantial damage NTSB MIA79FLA40Accident · No injuriesClosedLockheed 18 · Brunswick, GAJul 24, 1979 · N33LM · Substantial damage NTSB MIA79FKG55Accident · No injuriesClosedCessna 310C · Chamblee, GAJul 18, 1979 · N1DY · Substantial damage NTSB MIA79DLA38Accident · No injuriesClosedCessna 150 · Waycross, GAJul 14, 1979 · N18646 · Substantial damage NTSB MIA79FKG53Accident · No injuriesClosedPiper PA-23 · Sapelo Island, GAJul 9, 1979 · N4026P · Substantial damage