Skip to content

NTSB investigations, 1971, 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 MIA72DLG21Accident · No injuriesClosedCessna 172 · Lancaster, SCDec 28, 1971 · N8560X · Substantial damage NTSB MIA72FLG20Accident · Minor injuriesClosedCessna 172D · Clinton, SCDec 26, 1971 · N2441U · Destroyed NTSB MIA72FLG19Accident · Serious injuriesClosedPiper PA-28 · Charleston, SCDec 22, 1971 · N8253N · Substantial damage NTSB MIA72AM054Accident · 2 fatalClosedLuscombe 8A · Santee, SCDec 19, 1971 · N45961 · Destroyed NTSB MIA72FLG18Accident · No injuriesClosedPiper PA-24 · Florence, SCDec 13, 1971 · N8552P · Substantial damage NTSB MIA72DLG17Accident · No injuriesClosedPiper PA-28 · Greer, SCNov 27, 1971 · N98095 · Substantial damage NTSB MIA72AM043Accident · No injuriesClosedTed Smith 600 · Hilton Head Is, SCNov 14, 1971 · N7414S · Substantial damage NTSB MIA72FLG16Accident · Serious injuriesClosedPiper PA-25 · Edisto Is, SCOct 28, 1971 · N162W · Destroyed NTSB MIA72FLG12Accident · No injuriesClosedBeech 95-B55 · Greenwood, SCOct 25, 1971 · N6545L · Substantial damage NTSB MIA72FLG15Accident · Minor injuriesClosedCessna 177 · Walterboro, SCOct 15, 1971 · N3403T · Substantial damage NTSB MIA72FLG14Accident · No injuriesClosedPiper J3C-65 · Clio, SCOct 3, 1971 · N37949 · Substantial damage NTSB MIA72DLG13Accident · No injuriesClosedBeech B23 · Florence, SCSep 26, 1971 · N2311Q · Substantial damage NTSB MIA72FLG11Accident · No injuriesClosedCessna 177 · Spartanburg, SCSep 16, 1971 · N3113T · Substantial damage NTSB MIA72FLG10Accident · No injuriesClosedChampion 7ECA · West Columbia, SCSep 11, 1971 · N7599F · Substantial damage NTSB MIA72DLG09Accident · No injuriesClosedBell 47D-1 · Rembert, SCAug 20, 1971 · N586T · Substantial damage NTSB MIA72FLG08Accident · No injuriesClosedBell 47D-1 · Cheraw, SCAug 14, 1971 · N908B · Substantial damage NTSB MIA72FLG07Accident · No injuriesClosedPiper PA-28 · Greenville, SCAug 11, 1971 · N8820N · Substantial damage NTSB MIA72FLG06Accident · No injuriesClosedTaylorcraft BC12 · Sullivans Is., SCAug 10, 1971 · N36452 · Substantial damage NTSB NYC72AN019Accident · Serious injuriesClosedConvair 880 · Spartanburg, SCAug 5, 1971 · N8803E · No damage NTSB MIA72FLG05Accident · No injuriesClosedBell 47G · Sumter, SCAug 2, 1971 · N73871 · Destroyed NTSB MIA72FLG04Accident · Serious injuriesClosedEnstrom F-28A · Saluda, SCJul 31, 1971 · N22WP · Substantial damage NTSB MIA72DLG03Accident · No injuriesClosedLuscombe 8A · Timmonsville, SCJul 24, 1971 · N1342B · Substantial damage NTSB MIA72DLG02Accident · Minor injuriesClosedCessna 150F · Harleyville, SCJul 18, 1971 · N8827G · Substantial damage NTSB MIA72DLG01Accident · No injuriesClosedCessna 172C · Spartanburg, SCJul 18, 1971 · N1887Y · Substantial damage NTSB MIA71FLG34Accident · Serious injuriesClosedAero Comdr 680E · Camden, SCJun 25, 1971 · N8458C · Substantial damage NTSB MIA71DLG33Accident · No injuriesClosedCessna 177 · Greenville, SCJun 20, 1971 · N29612 · Substantial damage NTSB MIA71DLG32Accident · No injuriesClosedBeech G35 · Rock Hill, SCJun 15, 1971 · N4491D · Substantial damage NTSB MIA71FLG30Accident · Serious injuriesClosedAero Comdr 100 · Allendale, SCJun 14, 1971 · N3624X · Destroyed NTSB MIA71FLG31Accident · No injuriesClosedCessna 175B · Rock Hill, SCJun 10, 1971 · N8140T · Substantial damage NTSB MIA71DLG29Accident · No injuriesClosedPiper PA-16 · Isle Of Palms, SCMay 30, 1971 · N5906H · Substantial damage NTSB MIA71FLG28Accident · Serious injuriesClosedCessna 337 · Hilton Head Is., SCMay 10, 1971 · N6343F · Destroyed NTSB MIA71AM093Accident · 4 fatalClosedCessna 421A · Conestee, SCMay 2, 1971 · N3194K · Destroyed NTSB MIA71FLG27Accident · No injuriesClosedPiper J3C-65 · Pageland, SCApr 7, 1971 · N92308 · Substantial damage NTSB MIA71FLG26Accident · No injuriesClosedPitts S1S · Pelion, SCApr 7, 1971 · N2788 · Substantial damage NTSB MIA71FLG25Accident · No injuriesClosedCessna 210E · Fort Lawn, SCMar 23, 1971 · N2322T · Substantial damage NTSB MIA71FLG24Accident · No injuriesClosedPiper PA-24 · Florence, SCMar 18, 1971 · N8552P · Substantial damage NTSB MIA71DLG23Accident · No injuriesClosedPiper J-5A · Georgetown, SCMar 14, 1971 · N31172 · Substantial damage NTSB MIA71DLG22Accident · No injuriesClosedLuscombe 8A · Johns Is., SCMar 7, 1971 · N1352K · Substantial damage NTSB MIA71AM076Accident · 8 fatalClosedVolpar E18S · Columbia, SCFeb 26, 1971 · N47A · Destroyed NTSB MIA71AM068Accident · 2 fatalClosedBoeing A75N1 · Beaufort, SCFeb 6, 1971 · N49784 · Destroyed NTSB MIA71AM065Accident · 6 fatalClosedAero Comdr 520 · Columbia, SCFeb 3, 1971 · N4190B · Destroyed NTSB MIA71FLG21Accident · Minor injuriesClosedPiper PA-22 · Calhoun Falls, SCJan 3, 1971 · N802A · Substantial damage