Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MIA69D0366Accident · No injuriesClosedPiper PA-32 · Walterboro, SCDec 28, 1968 · N3256W · Substantial damage NTSB MIA69F0318Accident · No injuriesClosedLuscombe 8E · Blenheim, SCDec 26, 1968 · N944BL · Substantial damage NTSB MIA69D0334Accident · Minor injuriesClosedPiper PA-28 · Charleston, SCDec 13, 1968 · N5186L · Substantial damage NTSB MIA69F0277Accident · No injuriesClosedCessna 150G · Fountain Inn, SCDec 8, 1968 · N2991J · Substantial damage NTSB MIA69D0306Accident · Minor injuriesClosedPiper PA-28 · Clemson, SCNov 15, 1968 · N5110L · Substantial damage NTSB MIA69D0273Accident · No injuriesClosedCessna 182 · Timmonsville, SCOct 27, 1968 · N2512Q · Substantial damage NTSB MIA69D0272Accident · No injuriesClosedCessna 170 · Pickens, SCOct 27, 1968 · N4117V · Substantial damage NTSB MIA69F0271Accident · No injuriesClosedBeech A23-19 · West Columbia, SCOct 25, 1968 · N5081T · Substantial damage NTSB MIA69A0024Accident · 2 fatalClosedCessna 150 · Orangeburg, SCOct 23, 1968 · N8984S · Destroyed NTSB MIA69F0296Accident · No injuriesClosedCessna 177 · Spartanburg, SCOct 22, 1968 · N3107T · Substantial damage NTSB MIA69F0249Accident · No injuriesClosedEaa Biplane PF · St.George, SCOct 13, 1968 · N155F · Substantial damage NTSB MIA69A0021Accident · 6 fatalClosedPiper PA-32 · Charleston, SCOct 7, 1968 · N3583W · Destroyed NTSB MIA69F0245Accident · No injuriesClosedBellanca 14-13 · Mccormick, SCOct 1, 1968 · N74498 · Substantial damage NTSB MIA69F0244Accident · No injuriesClosedPiper PA-24 · Columbia, SCSep 29, 1968 · N120JS · Substantial damage NTSB MIA69D0186Accident · No injuriesClosedPiper PA-22 · Newberry, SCSep 29, 1968 · N5386Z · Substantial damage NTSB MIA69F0189Accident · Minor injuriesClosedHughes 269A · Camden, SCSep 14, 1968 · N8917F · Substantial damage NTSB MIA69D0171Accident · Serious injuriesClosedAeronca 7AC · Pelzer, SCSep 7, 1968 · N83460 · Substantial damage NTSB MIA69F0183Accident · Minor injuriesClosedPiper PA-28 · West Columbia, SCSep 4, 1968 · N7524J · Destroyed NTSB MIA69F0190Accident · No injuriesClosedBeech 23 · Hartsville, SCSep 2, 1968 · N2394J · Substantial damage NTSB MIA69F0319Accident · Minor injuriesClosedPiper PA-28 · Blackville, SCAug 31, 1968 · N5516W · Substantial damage NTSB MIA69F0164Accident · No injuriesClosedBeech B90 · Greer, SCAug 30, 1968 · N1154S · Substantial damage NTSB MIA69D0173Accident · No injuriesClosedMooney M20E · West Columbia, SCAug 27, 1968 · N79362 · Substantial damage NTSB MIA69F0255Accident · No injuriesClosedBeech 23 · Boykin, SCAug 23, 1968 · N2363J · Substantial damage NTSB MIA69F0268Accident · Minor injuriesClosedAero Comdr 680-FL · Crescent Beach, SCAug 19, 1968 · N6379U · Substantial damage NTSB MIA69D0122Accident · Minor injuriesClosedPiper PA-18 · Cheraw, SCAug 17, 1968 · N960W · Destroyed NTSB MIA69F0162Accident · No injuriesClosedCessna 182K · York, SCAug 9, 1968 · N2705Q · Substantial damage NTSB MIA69F0153Accident · Minor injuriesClosedHughes 269A · Saluda, SCAug 2, 1968 · N8935F · Substantial damage NTSB MIA69D0147Accident · No injuriesClosedPiper PA-28 · Summerton, SCAug 2, 1968 · N4920L · Substantial damage NTSB MIA69F0155Accident · No injuriesClosedHughes 269A · Cope, SCJul 24, 1968 · N8893F · Substantial damage NTSB MIA69F0139Accident · 1 fatalClosedAero Comdr A-9B · Fairfax, SCJul 24, 1968 · N7663V · Destroyed NTSB MIA69D0136Accident · No injuriesClosedCallair A-9 · Estill, SCJul 22, 1968 · N7244V · Destroyed NTSB MIA69D0065Accident · No injuriesClosedCessna 182G · Newberry, SCJul 5, 1968 · N3223S · Substantial damage NTSB MIA69A0002Accident · 1 fatalClosedCessna 320D · Belton, SCJul 3, 1968 · N4124T · Destroyed NTSB MIA69F0074Accident · No injuriesClosedHughes 269A · Manning, SCJul 1, 1968 · N8917F · Substantial damage NTSB MIA69D0095Accident · No injuriesClosedPiper PA-28 · Georgetown, SCJun 18, 1968 · N5203W · Substantial damage NTSB MIA68I0106Incident · Minor injuriesClosedConvair 440 · Spartanburg, SCJun 12, 1968 · N8305 · No damage NTSB MIA68A0101Accident · 1 fatalClosedPiper PA-28 · Pomaria, SCJun 2, 1968 · N6090W · Destroyed NTSB MIA68A0100Accident · 2 fatalClosedPiper PA-24 · Lancaster, SCJun 2, 1968 · N5680P · Destroyed NTSB MIA69D0011Accident · No injuriesClosedPiper PA-22 · Troy, SCJun 1, 1968 · N8714D · Destroyed NTSB MIA69D0088Accident · No injuriesClosedCessna 185 · Moncks Corner, SCMay 31, 1968 · N9930X · Substantial damage NTSB MIA68A0095Accident · 1 fatalClosedPiper PA-17 · West Columbia, SCMay 17, 1968 · N4869H · Destroyed NTSB MIA68D0519Accident · Minor injuriesClosedCessna 182 · Easley, SCMay 13, 1968 · N3627U · Substantial damage NTSB MIA68D0526Accident · No injuriesClosedPiper PA-22 · Beaufort, SCApr 28, 1968 · N5808Z · Substantial damage NTSB MIA68D0499Accident · No injuriesClosedPiper PA-24 · Anderson, SCApr 28, 1968 · N7027P · Substantial damage NTSB MIA68D0530Accident · No injuriesClosedBeech G35 · Beaufort, SCApr 26, 1968 · N4655D · Substantial damage NTSB MIA68D0517Accident · Minor injuriesClosedCessna 140 · Charleston, SCApr 13, 1968 · N2418N · Substantial damage NTSB MIA68D0509Accident · Minor injuriesClosedCessna 150G · Lancaster, SCApr 7, 1968 · N3187J · Substantial damage NTSB MIA68F0513Accident · Minor injuriesClosedCessna 206 · Spartanburg, SCMar 29, 1968 · N5017U · Substantial damage NTSB MIA68D0479Accident · No injuriesClosedCessna 150 · Hardeeville, SCMar 26, 1968 · N6943S · Substantial damage NTSB MIA68F0471Accident · No injuriesClosedBeech A23 · Greer, SCMar 19, 1968 · N5985S · Substantial damage