Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MIA78FA026Accident · 3 fatalClosedCessna 177 · Albany, GADec 31, 1977 · N3296T · Destroyed NTSB MIA78FKG10Accident · No injuriesClosedPiper PA-32R · Ila, GADec 26, 1977 · N8475F · Substantial damage NTSB MIA78FA022Accident · 2 fatalClosedCessna 172 · Blairsville, GADec 24, 1977 · N4183L · Destroyed NTSB MIA78FA015Accident · 1 fatalClosedPiper PA-18 · Jeffersonville, GADec 15, 1977 · N4890P · Destroyed NTSB MIA78DLA09Accident · No injuriesClosedCessna 150 · Cairo, GADec 7, 1977 · N19195 · Substantial damage NTSB MIA78FLA08Accident · No injuriesClosedCessna 150 · Thomasville, GADec 2, 1977 · N704HX · Destroyed NTSB MIA78FKG07Accident · Serious injuriesClosedBellanca 17-30A · Marietta, GANov 30, 1977 · N6611V · Destroyed NTSB MIA78DLA07Accident · Minor injuriesClosedCessna 150 · Whigham, GANov 25, 1977 · N6546T · Substantial damage NTSB MIA78FKG06Accident · Minor injuriesClosedCessna 182Q · Albany, GANov 10, 1977 · N735CN · Substantial damage NTSB MIA78FKG05Accident · No injuriesClosedCessna 310J · Rome, GANov 8, 1977 · N3078L · Substantial damage NTSB MIA78DKG04Accident · No injuriesClosedCessna 170 · Hazelhurst, GANov 7, 1977 · N90906 · Substantial damage NTSB MIA77FA009Accident · 2 fatalClosedCessna 182K · Atlanta, GAOct 28, 1977 · N2842R · Destroyed NTSB MIA78FKG03Accident · Serious injuriesClosedCessna 140 · Calhoun, GAOct 21, 1977 · N2222V · Substantial damage NTSB MIA77FLA05Accident · No injuriesClosedPiper PA24 · Camilla, GAOct 14, 1977 · N6746P · Substantial damage NTSB MIA77FA005Accident · 2 fatalClosedPiper PA-28 · Brunswick, GAOct 14, 1977 · N8097N · Destroyed NTSB MIA78FA003Accident · No injuriesClosedCessna 207 · Atlanta, GAOct 13, 1977 · N91048 · Substantial damage NTSB MIA78DKG02Accident · No injuriesClosedCessna 140 · Tifton, GAOct 9, 1977 · N76817 · Destroyed NTSB MIA78FLA05Accident · No injuriesClosedCessna 310B · Cairo, GAOct 5, 1977 · N5387A · Substantial damage NTSB MIA78DKG01Accident · No injuriesClosedRogers Grow Triace · Warner Robbins, GAOct 5, 1977 · N185RG · Substantial damage NTSB MIA77FA095Accident · 1 fatalClosedCessna 182P · Stone Mountain, GASep 30, 1977 · N1833M · Destroyed NTSB MIA77DKG83Accident · No injuriesClosedPiper PA-24 · Jefferson, GASep 26, 1977 · N5339P · Substantial damage NTSB MIA77FKG68Accident · No injuriesClosedBeech 18S · Atlanta, GASep 23, 1977 · N72V · Substantial damage NTSB MIA77FKG81Accident · 1 fatalClosedAero Comdr 600S2R · Albany, GASep 22, 1977 · N8493V · Destroyed NTSB MIA77FKG77Accident · No injuriesClosedCessna 337 · Atlanta, GASep 14, 1977 · N225X · Substantial damage NTSB MIA77FLA54Accident · 2 fatalClosedCessna 188-B · Nashville, GASep 13, 1977 · N9600G · Destroyed NTSB MIA77FKG79Accident · Minor injuriesClosedAero Comdr S2R · Cordele, GASep 12, 1977 · N8834Q · Substantial damage NTSB MIA77FKG76Accident · No injuriesClosedPiper PA36 · Byromville, GASep 12, 1977 · N57831 · Substantial damage NTSB MIA77DKG80Accident · No injuriesClosedCessna 140 · Blairsville, GASep 12, 1977 · N2458N · Substantial damage NTSB MIA77FKG75Accident · Serious injuriesClosedCessna 210 · Columbus, GASep 11, 1977 · N2271S · Destroyed NTSB MIA77FKG78Accident · No injuriesClosedHughes 269 · Montezuma, GASep 10, 1977 · N7404F · Substantial damage NTSB MIA77FKG74Accident · No injuriesClosedPiper PA-25 · Dudley, GASep 8, 1977 · N7571Z · Substantial damage NTSB MIA77FA085Accident · 3 fatalClosedPiper PA-28 · Danville, GASep 7, 1977 · N43485 · Destroyed NTSB MIA77FLA53Accident · Serious injuriesClosedPiper PA-23 · Valdosta, GASep 6, 1977 · N2063P · Substantial damage NTSB MIA77FKG72Accident · No injuriesClosedGrumman G-164A · Cuthbert, GASep 6, 1977 · N9829 · Substantial damage NTSB MIA77FKG73Accident · No injuriesClosedPiper PA-28 · Albany, GASep 1, 1977 · N32122 · Substantial damage NTSB MIA77DKG71Accident · No injuriesClosedBellanca 7KACB · Tunnel Hill, GASep 1, 1977 · N8728 · Substantial damage NTSB MIA77FKG65Accident · Minor injuriesClosedPiper PA-32R · Atlanta, GAAug 31, 1977 · N8498F · Substantial damage NTSB MIA77DLA48Accident · No injuriesClosedGrumman G-164A · Colquitt, GAAug 24, 1977 · N15289 · Destroyed NTSB MIA77DKG70Accident · No injuriesClosedHughes 269A · Royston, GAAug 24, 1977 · N8869F · Destroyed NTSB MIA77FLA47Accident · No injuriesClosedCessna 188B · Enigma, GAAug 21, 1977 · N9392G · Destroyed NTSB MIA77FKG67Accident · No injuriesClosedHughes 269B · Montezuma, GAAug 20, 1977 · N9318F · Substantial damage NTSB MIA77FKG69Accident · No injuriesClosedHughes 269C · Montezuma, GAAug 19, 1977 · N7404F · Substantial damage NTSB MIA77FKG66Accident · No injuriesClosedBeech B23 · Hazelhurst, GAAug 17, 1977 · N7733R · Destroyed NTSB MIA77DKG63Accident · No injuriesClosedCessna A188B · Rocky Ford, GAAug 16, 1977 · N8279G · Destroyed NTSB MIA77DKG64Accident · No injuriesClosedAero Comdr A-9 · Sylvania, GAAug 12, 1977 · N8032V · Substantial damage NTSB MIA77FKG62Accident · No injuriesClosedBell 47G-2 · Brookfield, GAAug 8, 1977 · N6729D · Destroyed NTSB MIA77DLA45Accident · No injuriesClosedCessna 150 · Nashville, GAAug 6, 1977 · N6428T · Substantial damage NTSB MIA77FKG61Accident · No injuriesClosedStinson 108-1 · Stanfordville, GAAug 4, 1977 · N97885 · Substantial damage NTSB MIA77FA074Accident · 1 fatalClosedCessna 182D · Cusseta, GAAug 3, 1977 · N9127X · Destroyed NTSB MIA77DKG60Accident · Minor injuriesClosedPiper PA-25 · Rebecca, GAAug 3, 1977 · N4414Y · Destroyed