Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 MIA71FLG20Accident · Minor injuriesClosedPiper PA-28 · Charleston, SCDec 16, 1970 · N7923N · Substantial damage NTSB MIA71DLG18Accident · No injuriesClosedCessna 172 · Spartanburg, SCDec 4, 1970 · N6909A · Substantial damage NTSB MIA71FLG19Accident · No injuriesClosedBeech D95A · Hampton, SCDec 3, 1970 · N5740K · Substantial damage NTSB MIA71AM044Accident · 1 fatalClosedBeech H35 · Charleston, SCNov 28, 1970 · N5464D · Destroyed NTSB MIA71DLG17Accident · No injuriesClosedPiper PA-24 · Florence, SCNov 22, 1970 · N8552P · Substantial damage NTSB MIA71DLG16Accident · No injuriesClosedCessna 210 · Clemson, SCNov 21, 1970 · N9491X · Substantial damage NTSB MIA71DLG15Accident · Minor injuriesClosedChampion 7ECA · Allendale, SCNov 15, 1970 · N11045 · Destroyed NTSB MIA71FLG14Accident · Serious injuriesClosedHelio Acft H-295 · Pelion, SCOct 2, 1970 · N6474V · Substantial damage NTSB MIA71FLG12Accident · Minor injuriesClosedCessna 172H · Greenville, SCSep 30, 1970 · N8205L · Destroyed NTSB MIA71FLG11Accident · Minor injuriesClosedPiper PA-32 · Newberry, SCSep 28, 1970 · N3399W · Destroyed NTSB MIA71FLG13Accident · No injuriesClosedCurtiss-Wrt 16K · Rock Hill, SCSep 27, 1970 · N422W · Substantial damage NTSB MIA71AM027Accident · 1 fatalClosedCessna 182B · Darlington, SCSep 17, 1970 · N2570G · Destroyed NTSB MIA71DLG10Accident · No injuriesClosedPiper PA-28 · Greenville, SCSep 1, 1970 · N7254J · Substantial damage NTSB MIA71FLG09Accident · Minor injuriesClosedHughes 269A · Lexington, SCAug 30, 1970 · N8947F · Substantial damage NTSB MIA71FLG08Accident · No injuriesClosedPiper J3C-65 · Hartsville, SCAug 23, 1970 · N98105 · Substantial damage NTSB MIA71DLG07Accident · No injuriesClosedCallair A-9 · Allendale, SCAug 19, 1970 · N3578G · Destroyed NTSB MIA71DLG06Accident · Minor injuriesClosedSchleicher ASW-15 · Chester, SCAug 16, 1970 · N291W · Substantial damage NTSB MIA71FLG05Accident · Serious injuriesClosedPiper J3C · St Charles, SCAug 15, 1970 · N88317 · Destroyed NTSB MIA71FLG04Accident · No injuriesClosedBeech 35 · Jackson, SCAug 13, 1970 · N3027V · Substantial damage NTSB MIA71AM020Accident · 2 fatalClosedPiper PA-30 · Georgetown, SCAug 4, 1970 · N8047Y · Destroyed NTSB MIA71FLG03Accident · No injuriesClosedPiper PA-23 · Charleston, SCJul 30, 1970 · N6279Y · Substantial damage NTSB MIA71FLG02Accident · No injuriesClosedBeech H35 · Cayce, SCJul 15, 1970 · N7920D · Substantial damage NTSB MIA71FLG01Accident · Serious injuriesClosedJeanies T G-W · Spartanburg, SCJul 12, 1970 · N6418 · Substantial damage NTSB MIA70FLG27Accident · No injuriesClosedCessna 175 · Charleston, SCJun 27, 1970 · N7360M · Substantial damage NTSB MIA70AM098Accident · No injuriesClosedLockheed T-33A · Myrtle Beach, SCJun 19, 1970 · AF580501 · 2 aircraft · Minor damage NTSB MIA70DLG24Accident · Serious injuriesClosedPiper PA-18A · Darlington, SCJun 17, 1970 · N1862A · Destroyed NTSB MIA70DLG23Accident · Minor injuriesClosedPiper PA-12 · Mt Pleasant, SCMay 31, 1970 · N3621M · Substantial damage NTSB MIA70DLG21Accident · No injuriesClosedBeech A23-19 · Greenville, SCMay 24, 1970 · N3609Q · Substantial damage NTSB MIA70DLG19Accident · No injuriesClosedCessna 182E · Saluda, SCMay 20, 1970 · N2939Y · Substantial damage NTSB MIA70DLG22Accident · No injuriesClosedBeech P35 · Santee, SCMay 16, 1970 · N1537Z · Substantial damage NTSB MIA70FLG18Accident · Serious injuriesClosedCessna 182B · Charleston, SCMay 8, 1970 · N2452G · Substantial damage NTSB MIA70DLG17Accident · Serious injuriesClosedMooney M20E · Prichardville, SCApr 25, 1970 · N3221F · Substantial damage NTSB MIA70DLG16Accident · Minor injuriesClosedChampion 7HC · Taxahaw, SCApr 22, 1970 · N9968Y · Substantial damage NTSB MIA70FLG15Accident · Minor injuriesClosedCessna 182K · Columbia, SCApr 9, 1970 · N2633Q · Substantial damage NTSB MIA70DLG14Accident · No injuriesClosedCessna 150 · Moncks Corner, SCApr 6, 1970 · N761MA · Substantial damage NTSB MIA70DLG13Accident · No injuriesClosedPiper J3C · Conway, SCMar 30, 1970 · N38341 · Substantial damage NTSB MIA70DLG26Accident · No injuriesClosedSchweizer 1-23 · Catawba, SCMar 29, 1970 · N2704Z · Substantial damage NTSB MIA70DLG12Accident · No injuriesClosedCessna 172 · Columbia, SCMar 24, 1970 · N3784L · Substantial damage NTSB MIA70DLG11Accident · Minor injuriesClosedGlasflugel H-301B · Clover, SCMar 23, 1970 · N1615 · Substantial damage NTSB IAD70II051Incident · No injuriesClosedDouglas DC-8 · Charleston, SCMar 21, 1970 · N4907C · Minor damage NTSB IAD70AI050Accident · 1 fatalClosedCessna 150 · Swansea, SCMar 12, 1970 · N5782G · Destroyed NTSB MIA70DLG10Accident · Minor injuriesClosedCessna 150 · Gaffney, SCMar 10, 1970 · N8356G · Substantial damage NTSB MIA70DLG09Accident · Minor injuriesClosedPiper PA-28 · Walterboro, SCMar 10, 1970 · N4923L · Substantial damage NTSB MIA70FLG08Accident · No injuriesClosedCessna 150 · Gaffney, SCMar 7, 1970 · N3931U · Substantial damage NTSB MIA70DLG07Accident · No injuriesClosedPiper PA-28 · Isle Of Palms, SCMar 7, 1970 · N406AF · Substantial damage NTSB MIA70FLG06Accident · No injuriesClosedPiper PA-12 · Calhoun Falls, SCFeb 27, 1970 · N7975H · Substantial damage NTSB MIA70DLG05Accident · Minor injuriesClosedCessna 182D · Varnville, SCFeb 18, 1970 · N8864X · Substantial damage NTSB MIA70DLG04Accident · No injuriesClosedChampion 7ECA · Allendale, SCFeb 14, 1970 · N1873G · Substantial damage NTSB MIA70DLG03Accident · No injuriesClosedPiper PA-23 · Timmonsville, SCFeb 9, 1970 · N5682Y · Substantial damage NTSB MIA70DLG02Accident · No injuriesClosedPiper PA-32 · Bamberg, SCFeb 5, 1970 · N3278W · Substantial damage