Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 MIA71FKG55Accident · No injuriesClosedPiper PA-24 · Atlanta, GADec 19, 1970 · N8846P · Substantial damage NTSB MIA71FKG54Accident · Serious injuriesClosedGlobe GC-1B · Stone Mountain, GADec 19, 1970 · N78146 · Substantial damage NTSB MIA71AM052Accident · 2 fatalClosedPiper PA-28 · Savannah, GADec 14, 1970 · N4115J · Destroyed NTSB MIA71AM049Accident · 2 fatalClosedAeronca 11AC · Butler, GADec 12, 1970 · N3247E · Destroyed NTSB MIA71AM046Accident · 2 fatalClosedPiper PA-28 · Blakely, GADec 10, 1970 · N9827W · Destroyed NTSB MIA71AM045Accident · No injuriesClosedMartin 404 · Atlanta, GADec 10, 1970 · N143S · Minor damage NTSB MIA71FKG53Accident · No injuriesClosedHiller Acft FH1100 · Columbus, GADec 8, 1970 · N245CP · Substantial damage NTSB MIA71FKG52Accident · Serious injuriesClosedCessna 310C · St Simons Isle, GADec 4, 1970 · N1821H · Destroyed NTSB MIA71DKG51Accident · No injuriesClosedBriegleb BG12BD · Williamson, GANov 28, 1970 · N9009 · Substantial damage NTSB MIA71DKG50Accident · No injuriesClosedCessna 150J · Suwanee, GANov 26, 1970 · N60228 · Substantial damage NTSB MIA71AM040Accident · No injuriesClosedBoeing 727-35 · Savannah, GANov 4, 1970 · N4611 · Substantial damage NTSB MIA71FKG49Accident · No injuriesClosedBeech 65 · Chamblee, GANov 2, 1970 · N350GK · Substantial damage NTSB MIA71AM039Accident · 1 fatalClosedNavion A · Suwanee, GANov 1, 1970 · N1261 · Destroyed NTSB MIA71FKG48Accident · No injuriesClosedCessna 182 · Pavo, GAOct 31, 1970 · N3091Y · Substantial damage NTSB MIA71AM035Accident · 2 fatalClosedCessna 120 · Marietta, GAOct 23, 1970 · N89865 · Destroyed NTSB MIA71AM033Accident · No injuriesClosedBeech 99 · Atlanta, GAOct 22, 1970 · N845NS · Substantial damage NTSB MIA71FKG47Accident · No injuriesClosedBeech 95-C55 · Waycross, GAOct 21, 1970 · N9591Q · Substantial damage NTSB MIA71AM032Accident · 2 fatalClosedBeech J35 · Mussella, GAOct 19, 1970 · N749B · Destroyed NTSB MIA71FKG45Accident · No injuriesClosedChampion 7GCAA · Chamblee, GAOct 16, 1970 · N9026L · Substantial damage NTSB MIA71FKC46Accident · No injuriesClosedBeech 56TC · Atlanta, GAOct 13, 1970 · N680PC · Substantial damage NTSB MIA71DKG44Accident · No injuriesClosedPiper PA-28 · St Simons Isle, GAOct 9, 1970 · N5861U · Substantial damage NTSB MIA71DKG42Accident · No injuriesClosedCessna 172 · Twin City, GAOct 8, 1970 · N35368 · Substantial damage NTSB MIA71FKC43Accident · No injuriesClosedBeech 95 · Lithonia, GAOct 6, 1970 · N2052C · Substantial damage NTSB MIA71DKG40Accident · No injuriesClosedCessna 150 · Dahlonega, GASep 18, 1970 · N60344 · Substantial damage NTSB MIA71DKG39Accident · No injuriesClosedCessna 150F · Warner Robins, GASep 18, 1970 · N6809F · Substantial damage NTSB MIA71DKG37Accident · Serious injuriesClosedCessna 188 · Vidalia, GASep 7, 1970 · N8016V · Destroyed NTSB MIA71FKG38Accident · 1 fatalClosedWolf-Hirth LO-150 · Sylvania, GASep 6, 1970 · N1110V · Destroyed NTSB MIA71FKG36Accident · Minor injuriesClosedPhares Breezy · Savannah, GASep 6, 1970 · N1276 · Substantial damage NTSB MIA71FKG35Accident · No injuriesClosedCessna 150 · Dahlonega, GASep 5, 1970 · N8057S · Substantial damage NTSB MIA71DKG34Accident · No injuriesClosedPiper PA-25 · Moultrie, GASep 1, 1970 · N8581L · Substantial damage NTSB MIA71FKG32Accident · Serious injuriesClosedPiper PA-18 · Girard, GAAug 31, 1970 · N4896A · Destroyed NTSB MIA71FKG30Accident · No injuriesClosedCessna 172 · Claxton, GAAug 30, 1970 · N7267T · Substantial damage NTSB MIA71FKG31Accident · No injuriesClosedPiper PA-30 · Statesboro, GAAug 28, 1970 · N7881Y · Substantial damage NTSB MIA71FKG33Accident · No injuriesClosedChampion 7KCAB · Savannah, GAAug 27, 1970 · N6300N · Substantial damage NTSB MIA71AM019Accident · 1 fatalClosedPiper PA-18 · Macon, GAAug 27, 1970 · N3449P · Destroyed NTSB MIA71DKG28Accident · No injuriesClosedPiper PA-25 · Pinehurst, GAAug 25, 1970 · N7360Z · Destroyed NTSB MIA71FKG27Accident · Minor injuriesClosedNavion H · Blackshear, GAAug 24, 1970 · N2533T · Substantial damage NTSB MIA71DKG26Accident · No injuriesClosedMidget Must MM-1 · Warner Robins, GAAug 23, 1970 · N131D · Substantial damage NTSB MIA71FKG25Accident · Minor injuriesClosedCessna 150G · Atlanta, GAAug 22, 1970 · N4064J · Substantial damage NTSB MIA71FKG24Accident · No injuriesClosedLuscombe 8A · Perry, GAAug 21, 1970 · N45452 · Substantial damage NTSB MIA71FKG22Accident · Minor injuriesClosedPiper PA-28R · East Point, GAAug 20, 1970 · N3207R · Substantial damage NTSB MIA71FKG21Accident · Serious injuriesClosedPiper PA-25 · Unadilla, GAAug 19, 1970 · N4738Y · Destroyed NTSB MIA71FKG20Accident · Serious injuriesClosedWittman W-8 · La Grange, GAAug 10, 1970 · N1010B · Destroyed NTSB MIA71FKG18Accident · No injuriesClosedPiper PA-30 · Valdosta, GAAug 8, 1970 · N8326Y · Substantial damage NTSB MIA71FKG19Accident · No injuriesClosedCessna 188A · Leesburg, GAAug 6, 1970 · N5632J · Substantial damage NTSB MIA71FKG17Accident · No injuriesClosedCessna 182H · Dalton, GAAug 3, 1970 · N2015X · Substantial damage NTSB MIA71DKG16Accident · No injuriesClosedPiper PA-25 · Henderson, GAAug 1, 1970 · N6976Z · Substantial damage NTSB MIA71AM010Accident · 4 fatalClosedPiper PA-28 · Brunswick, GAAug 1, 1970 · N98271 · Destroyed NTSB MIA71DKG14Accident · No injuriesClosedPiper PA-25 · Ty Ty, GAJul 28, 1970 · N8596L · Substantial damage NTSB MIA71DKG23Accident · No injuriesClosedCessna 150 · Winston, GAJul 26, 1970 · N23073 · Substantial damage