Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MIA69A0035Accident · No injuriesClosedCessna 337 · Chamblee, GADec 29, 1968 · N2115X · No damage NTSB MIA69A0034Accident · 4 fatalClosedSiai-Marche 205-22 · Tifton, GADec 27, 1968 · N997WA · Destroyed NTSB MIA69A0032Accident · No injuriesClosedCessna 182K · Rome, GADec 20, 1968 · N2812R · 2 aircraft · Substantial damage NTSB MIA69F0353Accident · No injuriesClosedCessna 172 · Fairburn, GADec 19, 1968 · N8134U · Substantial damage NTSB MIA69F0385Accident · No injuriesClosedBeech S35 · Dawson, GADec 11, 1968 · N5649K · Substantial damage NTSB MIA69A0030Accident · 1 fatalClosedCessna 172 · Stone Mountain, GADec 5, 1968 · N7039T · Destroyed NTSB MIA69F0301Accident · Minor injuriesClosedTaylorcraft BL · Fairburn, GANov 27, 1968 · N22608 · Substantial damage NTSB MIA69D0275Accident · No injuriesClosedCessna 172 · Brunswick, GANov 24, 1968 · N5128A · Substantial damage NTSB MIA69A0027Accident · 1 fatalClosedPiper PA-23 · Chatsworth, GANov 24, 1968 · N4401P · Destroyed NTSB MIA69F0300Accident · No injuriesClosedPiper PA-24 · Sylvania, GANov 19, 1968 · N9283P · Substantial damage NTSB MIA69D0257Accident · No injuriesClosedBeech 95-B55 · Cartersville, GANov 6, 1968 · N5839K · Substantial damage NTSB MIA69D0295Accident · Minor injuriesClosedBeech A23 · Folkston, GANov 5, 1968 · N3567R · Substantial damage NTSB MIA69F0356Accident · Serious injuriesClosedCessna 150F · Lithonia, GAOct 28, 1968 · N8217S · Destroyed NTSB MIA69F0252Accident · Serious injuriesClosedMooney M-18L · Kennesaw, GAOct 28, 1968 · N17P · Destroyed NTSB MIA69F0354Accident · No injuriesClosedConvair BT-13A · Stone Mtn, GAOct 24, 1968 · N66703 · Substantial damage NTSB MIA69F0211Accident · Serious injuriesClosedCessna 172 · Lithonia, GAOct 20, 1968 · N4105L · Substantial damage NTSB MIA69F0440Accident · No injuriesClosedCallair A-9B · Meigs, GAOct 15, 1968 · N7640V · Destroyed NTSB MIA69F0270Accident · No injuriesClosedCessna 210 · Villa Rica, GAOct 15, 1968 · N100B · Substantial damage NTSB MIA69F0327Accident · Serious injuriesClosedBoeing PT-17 · Jesup, GAOct 13, 1968 · N52143 · Substantial damage NTSB MIA69A0020Accident · 2 fatalClosedCessna 172E · Spring Place, GAOct 7, 1968 · N7732U · Destroyed NTSB MIA69D0269Accident · No injuriesClosedCessna 185 · Lawrenceville, GAOct 6, 1968 · N4005Y · Substantial damage NTSB MIA69A0019Accident · 2 fatalClosedPiper PA-22 · Mableton, GAOct 6, 1968 · N5914Z · Destroyed NTSB MIA69F0358Accident · No injuriesClosedPiper PA-25 · Madison, GAOct 4, 1968 · N7725Z · Substantial damage NTSB MIA69F0315Accident · No injuriesClosedGrumman G-164 · Edison, GASep 30, 1968 · N590Y · Substantial damage NTSB MIA69F0299Accident · Serious injuriesClosedAeronca 7AC · Lafayette, GASep 28, 1968 · N2023E · Substantial damage NTSB MIA69A0014Accident · 1 fatalClosedPiper PA-28 · Snellville, GASep 20, 1968 · N6389W · Destroyed NTSB MIA69A0013Accident · Minor injuriesClosedPiper PA-23 · Richmond Hill, GASep 13, 1968 · N4966P · Substantial damage NTSB MIA69D0212Accident · No injuriesClosedCessna 150 · Jekyll Is., GASep 5, 1968 · N82835 · Substantial damage NTSB MIA69F0195Accident · No injuriesClosedPiper PA-18 · Sylvania, GASep 4, 1968 · N1035A · Substantial damage NTSB MIA69A0011Accident · 2 fatalClosedCessna 175 · Eastman, GAAug 31, 1968 · N9302B · Destroyed NTSB MIA69F0175Accident · No injuriesClosedCulver LFA · Savannah, GAAug 28, 1968 · N41637 · Destroyed NTSB MIA69D0160Accident · Minor injuriesClosedCessna 182 · Toccoa, GAAug 18, 1968 · N6018B · Substantial damage NTSB MIA69F0267Accident · 1 fatalClosedPiper PA-18A · Sandersville, GAAug 17, 1968 · N6970B · Destroyed NTSB MIA69F0213Accident · No injuriesClosedCessna 177 · Marietta, GAAug 15, 1968 · N2931X · Substantial damage NTSB MIA69D0152Accident · No injuriesClosedHughes 269B · Arabi, GAAug 10, 1968 · N9438F · Substantial damage NTSB MIA69F0184Accident · Serious injuriesClosedCessna 320 · Pine Mountain, GAAug 9, 1968 · N6182Q · Destroyed NTSB MIA69D0161Accident · No injuriesClosedCessna 150 · Valdosta, GAAug 9, 1968 · N6529S · Destroyed NTSB MIA69D0253Accident · Minor injuriesClosedCessna 182H · Chamblee, GAAug 6, 1968 · N2402X · Substantial damage NTSB MIA69F0208Accident · Minor injuriesClosedCessna 150 · Jonesboro, GAAug 5, 1968 · N8234S · Destroyed NTSB MIA69F0185Accident · 1 fatalClosedBoeing A75 · Dawson, GAAug 4, 1968 · N52816 · Destroyed NTSB MIA69D0159Accident · No injuriesClosedPiper PA-24 · Conyers, GAAug 2, 1968 · N7612P · Substantial damage NTSB MIA69F0410Accident · No injuriesClosedStearman D75N1 · Colquitt, GAJul 30, 1968 · N69597 · Destroyed NTSB MIA69F0326Accident · No injuriesClosedAero Comdr A-9B · Unadilla, GAJul 30, 1968 · N7616V · Substantial damage NTSB MIA69D0121Accident · No injuriesClosedCessna 150 · Midway, GAJul 27, 1968 · N6137T · Substantial damage NTSB MIA69D0264Accident · Minor injuriesClosedStearman PT-17 · Colquitt, GAJul 25, 1968 · N49659 · 2 aircraft · Destroyed NTSB MIA69D0123Accident · Minor injuriesClosedAeronca 7ECA · Cedartown, GAJul 21, 1968 · N11043 · Destroyed NTSB MIA69D0229Accident · No injuriesClosedCessna 180 · Fitzgerald, GAJul 20, 1968 · N1606C · Substantial damage NTSB MIA69F0234Accident · 1 fatalClosedPiper PA-11 · Tifton, GAJul 19, 1968 · N4942H · Destroyed NTSB MIA69F0250Accident · 1 fatalClosedPiper PA-18A · Millen, GAJul 18, 1968 · N2875Z · Destroyed NTSB MIA69D0068Accident · No injuriesClosedPiper PA-25 · Tifton, GAJul 18, 1968 · N70582 · Substantial damage