Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 MIA69D0033Accident · No injuriesClosedPiper PA-22 · Gainesville, GADec 30, 1967 · N9249D · Substantial damage NTSB MIA68F0362Accident · No injuriesClosedCessna 150 · Douglasville, GADec 26, 1967 · N4239U · Substantial damage NTSB MIA68A0058Accident · 2 fatalClosedCessna 170B · Warm Springs, GADec 22, 1967 · N1953C · Destroyed NTSB MIA68D0506Accident · Minor injuriesClosedAero Comdr 100 · Brunswick, GADec 16, 1967 · N5540M · Destroyed NTSB MIA68F0377Accident · No injuriesClosedCessna 170A · Wadley, GADec 13, 1967 · N81Z · Substantial damage NTSB MIA68D0448Accident · No injuriesClosedCessna 182 · Jefferson, GADec 12, 1967 · N6414A · Substantial damage NTSB MIA68F0292Accident · No injuriesClosedBeech A23 · Chamblee, GADec 5, 1967 · N3627Q · Substantial damage NTSB MIA68F0330Accident · No injuriesClosedBeech B35 · Atlanta, GADec 3, 1967 · N8847A · Substantial damage NTSB MIA68F0326Accident · No injuriesClosedCessna 310 · Chamblee, GADec 3, 1967 · N3684D · Substantial damage NTSB MIA68D0348Accident · No injuriesClosedCessna 150 · Douglasville, GADec 3, 1967 · N4331U · Substantial damage NTSB MIA68D0456Accident · No injuriesClosedPiper PA-28 · Moultrie, GANov 27, 1967 · N4766L · Substantial damage NTSB MIA68F0422Accident · Minor injuriesClosedCessna 185B · Chamblee, GANov 15, 1967 · N2560Z · Substantial damage NTSB MIA68D0291Accident · No injuriesClosedCessna 172 · Buena Vista, GANov 12, 1967 · N7864U · Substantial damage NTSB MIA68D0289Accident · No injuriesClosedChampion 7GCBC · Albany, GANov 12, 1967 · N8392V · Substantial damage NTSB MIA68D0285Accident · No injuriesClosedCessna 150 · Villa Rica, GANov 11, 1967 · N6254R · Substantial damage NTSB ANC68F0070Accident · No injuriesClosedPiper PA-24 · Marietta, GANov 11, 1967 · N7220P · Substantial damage NTSB MIA68D0436Accident · No injuriesClosedChampion 7EC · Senoia, GANov 5, 1967 · N7488B · Substantial damage NTSB MIA68F0309Accident · No injuriesClosedPiper PA-30 · Chamblee, GANov 4, 1967 · N7553Y · Substantial damage NTSB MIA68A0043Accident · 2 fatalClosedAero Comdr 560 · Calhoun, GANov 4, 1967 · N2677B · Destroyed NTSB MIA68F0327Accident · No injuriesClosedPiper PA-30 · Chamblee, GAOct 30, 1967 · N7615Y · Substantial damage NTSB MIA68D0381Accident · No injuriesClosedCessna 172 · Jonesboro, GAOct 29, 1967 · N8228B · Substantial damage NTSB MIA68F0343Accident · Serious injuriesClosedCessna 172 · Lithonia, GAOct 28, 1967 · N8511G · Destroyed NTSB MIA68D0331Accident · No injuriesClosedCessna 150 · Lithonia, GAOct 28, 1967 · N8122S · Substantial damage NTSB MIA68F0266Accident · No injuriesClosedHelio Acft H-391B · Lithonia, GAOct 26, 1967 · N4135D · Substantial damage NTSB MIA68D0356Accident · No injuriesClosedCessna 150 · Dahlonega, GAOct 22, 1967 · N8225F · Destroyed NTSB MIA68D0325Accident · Minor injuriesClosedPiper PA-28 · Augusta, GAOct 22, 1967 · N8347W · Substantial damage NTSB MIA68A0039Accident · No injuriesClosedAero-Comdr 200D · Albany, GAOct 21, 1967 · N2917T · Substantial damage NTSB MIA68D0247Accident · No injuriesClosedGlobe GC-1B · Kennesaw, GAOct 20, 1967 · N90310 · Substantial damage NTSB MIA68D0245Accident · No injuriesClosedMooney M20C · Lithonia, GAOct 14, 1967 · N2615W · Substantial damage NTSB MIA68F0312Accident · Serious injuriesClosedStinson L-5 · Blairsville, GAOct 8, 1967 · N64688 · Destroyed NTSB MIA68F0286Accident · Serious injuriesClosedPiper PA-28 · Macon, GAOct 8, 1967 · N4171J · Substantial damage NTSB MIA68F0272Accident · Minor injuriesClosedAero Comdr 200-D · Marietta, GAOct 8, 1967 · N2954T · Substantial damage NTSB MIA68A0035Accident · 3 fatalClosedCessna 172 · Villa Rica, GAOct 8, 1967 · N5625A · Destroyed NTSB MIA68F0235Accident · No injuriesClosedPiper PA-24 · Marietta, GAOct 4, 1967 · N6310P · Substantial damage NTSB MIA68F0306Accident · No injuriesClosedAeronca 11CC · Vidalia, GASep 22, 1967 · N4297E · Substantial damage NTSB MIA68F0213Accident · No injuriesClosedPiper PA-25 · Midville, GASep 15, 1967 · N7761Z · Substantial damage NTSB MIA68F0173Accident · No injuriesClosedAeronca 7AC · Cairo, GASep 13, 1967 · N85416 · Substantial damage NTSB MIA68F0250Accident · No injuriesClosedPiper PA-18 · Marietta, GASep 9, 1967 · N168T · Substantial damage NTSB MIA68F0241Accident · No injuriesClosedBeech H35 · Thomaston, GASep 9, 1967 · N4693D · Substantial damage NTSB MIA68F0236Accident · No injuriesClosedPiper PA-23 · Valdosta, GASep 4, 1967 · N3079P · Substantial damage NTSB MIA68F0195Accident · No injuriesClosedPiper PA-23 · Columbus, GASep 2, 1967 · N4584P · Substantial damage NTSB MIA68D0161Accident · No injuriesClosedMooney M20C · Chamberlee, GASep 2, 1967 · N2948L · Substantial damage NTSB MIA68D0166Accident · Minor injuriesClosedCessna 150 · Villa Rica, GASep 1, 1967 · N8488G · Substantial damage NTSB MIA68A0028Accident · 4 fatalClosedCessna 172H · Robertstown, GASep 1, 1967 · N2697L · Destroyed NTSB MIA68D0305Accident · No injuriesClosedPiper PA-28 · Sylvania, GAAug 27, 1967 · N9955W · Substantial damage NTSB MIA68F0208Accident · No injuriesClosedCessna 172 · Mcdonough, GAAug 26, 1967 · N8333X · Substantial damage NTSB MIA68D0201Accident · No injuriesClosedPiper PA-24 · Hinesville, GAAug 21, 1967 · N8813P · Substantial damage NTSB MIA68D0226Accident · No injuriesClosedPiper PA-25 · Douglas, GAAug 19, 1967 · N6638Z · Substantial damage NTSB MIA68D0202Accident · Minor injuriesClosedPiper PA-18 · Sylvester, GAAug 18, 1967 · N1390A · Destroyed NTSB MIA68F0180Accident · Serious injuriesClosedGrumman G-164 · Blakely, GAAug 15, 1967 · N749Y · Destroyed