Skip to content

NTSB investigations, 1969, GA

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 MIA70D0301Accident · No injuriesClosedPiper PA-23 · Cedartown, GADec 27, 1969 · N3079P · Substantial damage NTSB MIA70F0303Accident · No injuriesClosedCessna 170A · Palmetto, GADec 25, 1969 · N9196A · Substantial damage NTSB MIA70D0302Accident · No injuriesClosedAero Comdr A-9B · Colquitt, GADec 24, 1969 · N7656V · Substantial damage NTSB MIA70D0313Accident · No injuriesClosedCessna 140 · Crawford, GADec 22, 1969 · N81046 · Substantial damage NTSB MIA70F0300Accident · No injuriesClosedCessna 150H · Kennesaw, GADec 18, 1969 · N7078S · Substantial damage NTSB MIA70F0307Accident · No injuriesClosedCessna 172F · Chamblee, GADec 14, 1969 · N8555U · Substantial damage NTSB MIA70F0306Accident · Minor injuriesClosedAero Comdr 200-D · Ashburn, GADec 12, 1969 · N2900T · Substantial damage NTSB MIA70A0044Accident · 2 fatalClosedCessna 210G · Valdosta, GADec 9, 1969 · N5919F · Destroyed NTSB MIA70F0311Accident · No injuriesClosedMooney M20A · Savannah, GADec 5, 1969 · N6005X · Substantial damage NTSB MIA70D0267Accident · No injuriesClosedAeronca 65-CA · Dallas, GANov 28, 1969 · N36527 · Substantial damage NTSB MIA70A0040Accident · 2 fatalClosedChampion 7FC · Midville, GANov 22, 1969 · N8508E · Destroyed NTSB MIA70F0239Accident · No injuriesClosedCessna 170A · Marietta, GANov 15, 1969 · N9913A · Substantial damage NTSB MIA70F0291Accident · No injuriesClosedBeech C-45H · Albany, GANov 14, 1969 · N9818Z · Destroyed NTSB MIA70F0238Accident · Serious injuriesClosedCessna 150 · Jonesboro, GANov 9, 1969 · N4157U · Destroyed NTSB MIA70D0235Accident · No injuriesClosedPiper PA-22 · Athens, GANov 6, 1969 · N4406A · Substantial damage NTSB MIA70F0297Accident · No injuriesClosedBeech V35 · Chamblee, GAOct 31, 1969 · N5622S · Substantial damage NTSB MIA70A0035Accident · 1 fatalClosedBeech 35 · Thomasville, GAOct 25, 1969 · N2817V · Destroyed NTSB MIA70D0310Accident · No injuriesClosedPiper PA-28 · Brunswick, GAOct 20, 1969 · N6925W · Substantial damage NTSB MIA70A0033Accident · 1 fatalClosedBeech V35 · Fort Gaines, GAOct 18, 1969 · N7944M · Destroyed NTSB MIA70F0285Accident · Serious injuriesClosedGrumman G-164 · Morgan, GAOct 17, 1969 · N651U · Destroyed NTSB MIA70A0032Accident · 4 fatalClosedBeech D18S · Macon, GAOct 17, 1969 · N5000S · Destroyed NTSB MIA70D0275Accident · No injuriesClosedCessna 120 · Savannah, GAOct 16, 1969 · N1600V · Substantial damage NTSB MIA71D0001Accident · No injuriesClosedCessna 177 · Valdosta, GAOct 14, 1969 · N3177T · Substantial damage NTSB MIA70F0251Accident · No injuriesClosedPiper PA-28 · Cochran, GAOct 11, 1969 · N8263W · Substantial damage NTSB MIA70D0312Accident · No injuriesClosedStinson 108-1 · Alma, GAOct 5, 1969 · N8518K · Substantial damage NTSB MIA70A0028Accident · 1 fatalClosedPiper PA-28 · Jessup, GAOct 1, 1969 · N6585J · Destroyed NTSB MIA70D0296Accident · No injuriesClosedPiper J-3 · Hopetn Plntion, GASep 28, 1969 · N46917 · Substantial damage NTSB MIA70A0022Accident · 1 fatalClosedNavion A · Williamson, GASep 19, 1969 · N8593H · Destroyed NTSB MIA70F0305Accident · No injuriesClosedCessna 182B · Ashburn, GASep 13, 1969 · N7187E · Substantial damage NTSB MIA70F0284Accident · Serious injuriesClosedPiper PA-25 · Rutledge, GASep 12, 1969 · N6109Z · Destroyed NTSB MIA70D0292Accident · No injuriesClosedPiper PA-28 · St.Simons, GASep 10, 1969 · N6392W · Substantial damage NTSB MIA70D0290Accident · Serious injuriesClosedCessna 172 · Canton, GASep 6, 1969 · N7067T · Substantial damage NTSB MIA70F0308Accident · Serious injuriesClosedPiper PA-23 · Canton, GASep 4, 1969 · N4344P · Destroyed NTSB MIA70F0223Accident · No injuriesClosedAero Comdr A-9B · Waynesboro, GASep 4, 1969 · N7743V · Substantial damage NTSB MIA70D0249Accident · Serious injuriesClosedCessna 140 · Cleveland, GAAug 30, 1969 · N77142 · Substantial damage NTSB MIA70F0140Accident · Minor injuriesClosedCessna 170A · Valdosta, GAAug 28, 1969 · N5502C · Destroyed NTSB MIA70D0314Accident · No injuriesClosedCallair A-9 · Davisboro, GAAug 26, 1969 · N8297H · Substantial damage NTSB MIA70A0015Accident · No injuriesClosedBeech E18S · Albany, GAAug 25, 1969 · N4641A · Substantial damage NTSB MIA70D0214Accident · No injuriesClosedCessna 172 · Fort Gaines, GAAug 23, 1969 · CF-RHT · Substantial damage NTSB MIA70D0287Accident · No injuriesClosedChampion 7GCBC · Lafayette, GAAug 13, 1969 · N5074X · Substantial damage NTSB MIA70F0248Accident · No injuriesClosedHughes 269B · Arlington, GAAug 11, 1969 · N9489F · Substantial damage NTSB MIA70D0299Accident · Minor injuriesClosedAero Comdr A-9B · Gough, GAAug 11, 1969 · N7747V · Destroyed NTSB MIA70D0200Accident · No injuriesClosedCessna A188 · Louisville, GAAug 11, 1969 · N3532Q · Substantial damage NTSB MIA70F0286Accident · Serious injuriesClosedNavion A · Savannah, GAAug 4, 1969 · N4208A · Substantial damage NTSB MIA70F0167Accident · No injuriesClosedPiper PA-25 · Taylorsville, GAAug 4, 1969 · N8596L · Substantial damage NTSB MIA70A0007Accident · Serious injuriesClosedDouglas DC-8 · Atlanta, GAAug 2, 1969 · N1302L · No damage NTSB MIA70F0204Accident · No injuriesClosedBeech D17S · Lawrenceville, GAJul 29, 1969 · N1609 · Substantial damage NTSB DCA70I0001Incident · No injuriesClosedBeech 99 · Atlanta, GAJul 29, 1969 · N651EX · No damage NTSB MIA70F0271Accident · No injuriesClosedAero Comdr A9-B · Smithville, GAJul 28, 1969 · N7725V · Substantial damage NTSB MIA70F0191Accident · No injuriesClosedCessna 337D · Kensington, GAJul 27, 1969 · N85947 · Substantial damage