Skip to content

NTSB investigations, 1967, SC

180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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

19642026

NTSB investigations, 1967, SC per year, 1964–2026: 1,853 cases
1964	46
1965	41
1966	58
1967	49
1968	62
1969	39
1970	51
1971	42
1972	58
1973	43
1974	49
1975	51
1976	39
1977	44
1978	56
1979	28
1980	29
1981	32
1982	52
1983	40
1984	35
1985	36
1986	25
1987	35
1988	41
1989	27
1990	23
1991	20
1992	31
1993	24
1994	30
1995	32
1996	19
1997	28
1998	28
1999	26
2000	19
2001	13
2002	21
2003	22
2004	20
2005	22
2006	17
2007	15
2008	20
2009	29
2010	19
2011	21
2012	21
2013	13
2014	13
2015	12
2016	15
2017	12
2018	21
2019	18
2020	13
2021	22
2022	21
2023	21
2024	10
2025	19
2026	15

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" = 'SC' 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\" = 'SC' 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" = 'SC' 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 MIA68D0430Accident · Minor injuriesClosedCessna 172D · Chester, SCDec 7, 1967 · N2839U · Destroyed NTSB MIA68D0336Accident · No injuriesClosedMooney M20C · Coosawhatchie, SCNov 27, 1967 · N6961U · Substantial damage NTSB MIA68D0357Accident · No injuriesClosedCessna 150F · Clemson, SCNov 26, 1967 · N7711F · Substantial damage NTSB MIA68D0288Accident · No injuriesClosedCessna 150 · Lancaster, SCNov 12, 1967 · N2504J · Substantial damage NTSB MIA68A0045Accident · Serious injuriesClosedHughes 269B · Greenwood, SCNov 5, 1967 · N9413F · Destroyed NTSB MIA68D0284Accident · No injuriesClosedPiper PA-24 · Sumter, SCOct 16, 1967 · N5043P · Substantial damage NTSB MIA68F0358Accident · No injuriesClosedPiper PA-24 · Charleston, SCOct 14, 1967 · N5953P · Substantial damage NTSB MIA68D0276Accident · No injuriesClosedBeech 35-B33 · Florence, SCOct 13, 1967 · N9615Y · Substantial damage NTSB MIA68A0033Accident · 2 fatalClosedBeech E50 · Greenwood, SCOct 7, 1967 · N828B · Destroyed NTSB MIA68D0205Accident · Serious injuriesClosedErco 415-C · Columbia, SCSep 17, 1967 · N94654 · No damage NTSB MIA68F0234Accident · No injuriesClosedBeech B95 · Orangeburg, SCSep 16, 1967 · N1506R · Substantial damage NTSB MIA68D0257Accident · No injuriesClosedBoeing A75N1 · Florence, SCSep 12, 1967 · N55590 · Substantial damage NTSB MIA68D0237Accident · Serious injuriesClosedCessna 210 · Camden, SCAug 30, 1967 · N6796R · Destroyed NTSB MIA68F0220Accident · Minor injuriesClosedPiper PA-23 · Aiken, SCAug 22, 1967 · N5766Y · Substantial damage NTSB MIA68F0187Accident · No injuriesClosedErco 415-C · Barnwell, SCAug 22, 1967 · N99047 · Substantial damage NTSB MIA68F0270Accident · Serious injuriesClosedPiper PA-28 · Greenwood, SCAug 21, 1967 · N8612W · Destroyed NTSB MIA68F0278Accident · No injuriesClosedCessna 337 · Pontiac, SCAug 11, 1967 · N2122X · Substantial damage NTSB MIA68F0221Accident · No injuriesClosedPiper PA-24 · Greenville, SCAug 11, 1967 · N7140P · Substantial damage NTSB MIA68D0238Accident · No injuriesClosedCessna 150 · Jackson, SCAug 5, 1967 · N7722E · Substantial damage NTSB MIA68F0203Accident · Minor injuriesClosedErco 415-C · Pelion, SCAug 1, 1967 · N99019 · Substantial damage NTSB MIA68D0230Accident · No injuriesClosedWaco ASO · Timmonsville, SCJul 26, 1967 · N9500 · Substantial damage NTSB DIA68D0038Accident · Minor injuriesClosedCessna 150 · Little River, SCJul 21, 1967 · N8479G · Destroyed NTSB MIA68F0025Accident · No injuriesClosedCessna 172A · Winnsboro, SCJul 14, 1967 · N7550T · Substantial damage NTSB DIA68F0012Accident · No injuriesClosedPiper PA-28 · Rock Hill, SCJun 17, 1967 · N8375R · Substantial damage NTSB MIA68D0204Accident · No injuriesClosedLuscombe 8E · Lancaster, SCJun 10, 1967 · N2424K · Substantial damage NTSB MIA68F0207Accident · No injuriesClosedErco 415-D · Pamplico, SCMay 28, 1967 · N99642 · Substantial damage NTSB MIA67A0121Accident · 2 fatalClosedPiper PA-28 · Isle Of Palms, SCMay 17, 1967 · N9006W · Destroyed NTSB MIA68D0190Accident · No injuriesClosedCessna 182J · Camden, SCMay 16, 1967 · N825MD · Substantial damage NTSB MIA67A0120Accident · Serious injuriesClosedHughes 269B · Saluda, SCMay 13, 1967 · N9417F · Substantial damage NTSB MIA67A0118Accident · 2 fatalClosedPiper J3-90 · Lake City, SCMay 3, 1967 · N6052H · Destroyed NTSB MIA67A0114Accident · 2 fatalClosedPiper PA-24 · Darlington, SCApr 24, 1967 · N9036P · Destroyed NTSB MIA67A0110Accident · 1 fatalClosedCessna 172F · Jackson, SCApr 23, 1967 · N5504R · Substantial damage NTSB MIA68D0206Accident · Minor injuriesClosedAeronca 7BCM · Sumter, SCApr 19, 1967 · N1720M · Substantial damage NTSB MIA68F0184Accident · No injuriesClosedPiper PA-18 · Crescent Beach, SCApr 9, 1967 · N335T · Destroyed NTSB MIA67F0498Accident · Minor injuriesClosedCessna 150F · Charleston, SCApr 8, 1967 · N6956F · Substantial damage NTSB MIA68F0189Accident · No injuriesClosedPiper PA-22 · West Columbia, SCApr 7, 1967 · N5880Z · Substantial damage NTSB MIA68D0188Accident · No injuriesClosedBeech 95-A55 · Marion, SCApr 5, 1967 · N1559S · Substantial damage NTSB MIA67D0513Accident · No injuriesClosedBeech A45 · Hartsville, SCMar 30, 1967 · N6450D · Substantial damage NTSB MIA68F0185Accident · No injuriesClosedPiper PA-28 · Andrews, SCMar 26, 1967 · N7175W · Substantial damage NTSB MIA67F0026Accident · No injuriesClosedBeech A23 · West Columbia, SCMar 23, 1967 · N5998S · Substantial damage NTSB MIA67A0092Accident · No injuriesClosedPiper PA-23 · Allendale, SCMar 10, 1967 · N6162Y · Substantial damage NTSB MIA68F0186Accident · No injuriesClosedCessna 182B · Greenville, SCFeb 23, 1967 · N7230E · Minor damage NTSB MIA67D0544Accident · No injuriesClosedBeech A23 · Batesburg, SCFeb 23, 1967 · N8863M · Destroyed NTSB MIA67A0088Accident · 1 fatalClosedCessna 401 · Anderson, SCFeb 22, 1967 · N3212Q · Destroyed NTSB MIA67F0467Accident · No injuriesClosedPiper PA-23 · Cayce, SCFeb 13, 1967 · N1189P · Substantial damage NTSB MIA68D0192Accident · Minor injuriesClosedNavion B · Lane, SCFeb 5, 1967 · N5345K · Substantial damage NTSB MIA67D0537Accident · Minor injuriesClosedCessna 150G · Winnsboro, SCJan 28, 1967 · N4095J · Substantial damage NTSB MIA67D0001Accident · Minor injuriesClosedCessna 172D · Ridgeland, SCJan 22, 1967 · N2732U · Substantial damage NTSB MIA67D0551Accident · Minor injuriesClosedCessna 172B · Allendale, SCJan 21, 1967 · N7651X · Destroyed