Skip to content

NTSB investigations, 1978, 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 MIA79FA034Accident · 1 fatalClosedPiper PA-30 · Lafayette, GADec 31, 1978 · N7031Y · Destroyed NTSB MIA79FKG12Accident · No injuriesClosedCessna 152 · Atlanta, GADec 12, 1978 · N67309 · Substantial damage NTSB MIA79DKG11Accident · No injuriesClosedPiper PA-28 · Dawson, GADec 4, 1978 · N9632J · Substantial damage NTSB MIA79FKG09Accident · Minor injuriesClosedCessna 177 · Augusta, GADec 3, 1978 · N30839 · Substantial damage NTSB MIA79FA025Accident · 5 fatalClosedPiper PA-32R · Albany, GANov 30, 1978 · N7063F · Destroyed NTSB MIA79DLA10Accident · No injuriesClosedCessna A188A · Hortence, GANov 19, 1978 · N1566M · Substantial damage NTSB MIA79FLA08Accident · No injuriesClosedCessna 210M · St.Marys, GANov 8, 1978 · N761AX · Substantial damage NTSB MIA79FKG10Accident · No injuriesClosedCessna 172 · Chamblee, GANov 8, 1978 · N7208G · Substantial damage NTSB MIA79FKG08Accident · Minor injuriesClosedAerospatle SA315B · Atlanta, GANov 4, 1978 · N62339 · Substantial damage NTSB MIA79FKG07Accident · No injuriesClosedAeronca 7AC · Hampton, GAOct 28, 1978 · N1823E · Substantial damage NTSB MIA79DLA05Accident · No injuriesClosedCessna 310 · Cairo, GAOct 20, 1978 · N5387A · Substantial damage NTSB MIA79FKG06Accident · No injuriesClosedCessna 150 · Madison, GAOct 18, 1978 · N60791 · Substantial damage NTSB MIA79FKG04Accident · No injuriesClosedCessna 337G · Chamblee, GAOct 15, 1978 · N53620 · Substantial damage NTSB MIA79FKG05Accident · No injuriesClosedCessna 140 · Sugar Valley, GAOct 12, 1978 · N2511N · Substantial damage NTSB MIA79FKG03Accident · No injuriesClosedHelio Acft H-295 · Atlanta, GAOct 11, 1978 · N275ZD · Destroyed NTSB MIA79DLA03Accident · Minor injuriesClosedCessna A188B · Waycross, GAOct 11, 1978 · N4771Q · Destroyed NTSB MIA79FKG01Accident · Serious injuriesClosedGlobe Swift GC-1B · Hampton, GAOct 2, 1978 · N78327 · Substantial damage NTSB MIA79FKG02Accident · Serious injuriesClosedPiper PA-22 · Stone Mountain, GAOct 1, 1978 · N7846D · Minor damage NTSB MIA78FA126Accident · 2 fatalClosedCessna 337G · Atlanta, GASep 22, 1978 · N1309L · Destroyed NTSB MIA78FKG82Accident · No injuriesClosedCessna 188B · Brooklett, GASep 20, 1978 · N4962Q · Substantial damage NTSB MIA78FKG81Accident · Minor injuriesClosedBeech A23-19 · Juniper, GASep 19, 1978 · N5988S · Substantial damage NTSB MIA78FKG80Accident · No injuriesClosedPiper PA-24 · Dawson, GASep 14, 1978 · N7632P · Substantial damage NTSB MIA78FKG79Accident · Serious injuriesClosedPiper PA-28R · Stockbridge, GASep 14, 1978 · N2649Q · Destroyed NTSB MIA78FKG78Accident · Minor injuriesClosedGrumman G164A · Albany, GASep 13, 1978 · N7929 · Substantial damage NTSB MIA78DLA51Accident · No injuriesClosedAero Comdr S2R · Camilla, GASep 13, 1978 · N8480V · Substantial damage NTSB MIA78FKG76Accident · Serious injuriesClosedCessna 152 · Birmingham, GAAug 29, 1978 · N49143 · Destroyed NTSB MIA78FKG75Accident · Serious injuriesClosedAero Comdr S2R · Summer, GAAug 25, 1978 · N4863X · Substantial damage NTSB MIA78DLA47Accident · No injuriesClosedGrumman G-164A · Cairo, GAAug 21, 1978 · N5186 · Destroyed NTSB MIA78FKG73Accident · Serious injuriesClosedBellanca 7GCBC · Monroe, GAAug 20, 1978 · N9511S · Destroyed NTSB MIA78FKG74Accident · No injuriesClosedBell 47D1 · Hartwell, GAAug 19, 1978 · N74123 · Substantial damage NTSB MIA78DKG77Accident · No injuriesClosedHoak TR-1 · Stockbridge, GAAug 19, 1978 · N26112 · Substantial damage NTSB MIA78DLA48Accident · No injuriesClosedCessna 188B · Colquitt, GAAug 18, 1978 · N9094R · Substantial damage NTSB MIA78FKG72Accident · No injuriesClosedCessna 188B · Broxton, GAAug 17, 1978 · N5622G · Substantial damage NTSB MIA78FKG53Accident · No injuriesClosedCessna 188B · Cordele, GAAug 16, 1978 · N9449R · Destroyed NTSB MIA78FKG71Accident · Minor injuriesClosedPiper PA-36 · Cordele, GAAug 13, 1978 · N59692 · Destroyed NTSB MIA78FA113Accident · No injuriesClosedPiper PA-28 · Statenville, GAAug 13, 1978 · N6301W · Substantial damage NTSB MIA79FLA34Accident · 1 fatalClosedBell 47G2 · Omega, GAAug 12, 1978 · N6729D · Destroyed NTSB MIA78FKG70Accident · No injuriesClosedCessna 150 · Savannah, GAAug 7, 1978 · N5699E · Substantial damage NTSB MIA78DKG69Accident · No injuriesClosedCessna A188B · Pineview, GAAug 5, 1978 · N731KE · Substantial damage NTSB MIA78FKG68Accident · No injuriesClosedHunting-Pem MK-51 · Sylvester, GAAug 3, 1978 · N51951 · Destroyed NTSB MIA78FKG67Accident · Serious injuriesClosedHughes 269C · Buena Vista, GAJul 30, 1978 · N7413F · Destroyed NTSB MIA78FKG65Accident · No injuriesClosedHughes 269B · Swainboro, GAJul 29, 1978 · N9457F · Substantial damage NTSB MIA78DLA46Accident · No injuriesClosedCessna A188B · Moultrie, GAJul 25, 1978 · N48570 · Substantial damage NTSB MIA78FKG66Accident · No injuriesClosedPiper PA-20 · Millen, GAJul 23, 1978 · N1145C · Substantial damage NTSB MIA78FKG64Accident · Minor injuriesClosedCessna 150 · Athens, GAJul 22, 1978 · N60746 · Substantial damage NTSB MIA78FKG62Accident · No injuriesClosedMooney M20J · Atlanta, GAJul 21, 1978 · N201PC · Substantial damage NTSB MIA78FKG63Accident · Minor injuriesClosedGrumman G-164A · Lumpkin, GAJul 18, 1978 · N9829 · Destroyed NTSB MIA78FA103Accident · 3 fatalClosedPiper PA-30 · Albany, GAJul 10, 1978 · N41AC · Destroyed NTSB MIA78FKG58Accident · No injuriesClosedPDQ 2 · Marietta, GAJul 9, 1978 · N2279D · Substantial damage NTSB MIA78FKG59Accident · Serious injuriesClosedPiper PA-28 · Toccoa, GAJul 8, 1978 · N75313 · Destroyed