Skip to content

NTSB investigations, 1976, SC

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1976, 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") = 1976 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\") = 1976
    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") = 1976
  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 MIA77FLG05Accident · No injuriesClosedCessna 172 · Columbia, SCDec 29, 1976 · N5529T · Substantial damage NTSB MIA77FLG04Accident · No injuriesClosedBeech D55 · Charleston, SCDec 27, 1976 · N535Q · Substantial damage NTSB MIA77DLG03Accident · No injuriesClosedPiper PA-28 · Liberty, SCDec 16, 1976 · N5272T · Substantial damage NTSB MIA77FA009Accident · 3 fatalClosedPiper PA-28 · Beaufort, SCNov 15, 1976 · N7286J · Destroyed NTSB MIA77FLG02Accident · No injuriesClosedCessna U206E · Lancaster, SCOct 25, 1976 · N9427G · Destroyed NTSB MIA77FL901Accident · 1 fatalClosedBensen B-8M · Laurens, SCOct 16, 1976 · N6536 · Destroyed NTSB MIA76DLG54Accident · No injuriesClosedCessna 172 · Landrum, SCSep 26, 1976 · N5895R · Substantial damage NTSB MIA76FLG53Accident · Serious injuriesClosedHughes 269B · Batesburg, SCSep 11, 1976 · N9380F · Substantial damage NTSB MIA76FLG51Accident · No injuriesClosedBell 47G · Ridge Spring, SCSep 8, 1976 · N1273 · Substantial damage NTSB MIA76 LG52Accident · No injuriesClosedPiper PA-34 · Timmonsville, SCSep 8, 1976 · N1135X · Substantial damage NTSB MIA76FLG50Accident · Minor injuriesClosedPiper PA-22 · Mcclellanville, SCSep 5, 1976 · N7890D · Destroyed NTSB MIA76FLG49Accident · No injuriesClosedChampion 7ECA · Charleston, SCSep 4, 1976 · N2953G · Substantial damage NTSB MIA76DLG48Accident · No injuriesClosedCessna 188 · Irmo, SCAug 29, 1976 · N21664 · Substantial damage NTSB MIA76DLG39Accident · No injuriesClosedCessna 172 · Neeses, SCAug 29, 1976 · N6482E · Substantial damage NTSB MIA76DLG47Accident · No injuriesClosedCessna 188 · Sumter, SCAug 18, 1976 · N9888V · Substantial damage NTSB MIA76FLG46Accident · No injuriesClosedCessna 195A · Charleston, SCAug 12, 1976 · N1009D · Substantial damage NTSB MIA76FLG45Accident · Minor injuriesClosedPiper PA-30 · Summerton, SCAug 5, 1976 · N1139T · Destroyed NTSB MIA76FLG44Accident · Minor injuriesClosedCessna 180 · Clinton, SCJul 26, 1976 · N9029C · Substantial damage NTSB MIA76FLG43Accident · No injuriesClosedPiper J-3 · Aiken, SCJul 21, 1976 · N35096 · Substantial damage NTSB MIA76DLG42Accident · No injuriesClosedCessna 188 · St Matthews, SCJul 20, 1976 · N53168 · Substantial damage NTSB MIA76FLG41Accident · No injuriesClosedHughes 269B · Orangeburg, SCJul 15, 1976 · N9436F · Destroyed NTSB MIA76FLG40Accident · No injuriesClosedPiper PA-24 · Columbia, SCJul 13, 1976 · N9374P · Substantial damage NTSB MIA76FLG38Accident · Minor injuriesClosedHughes 269A · Fair Play, SCJul 12, 1976 · N8718F · Substantial damage NTSB MIA76FLG37Accident · No injuriesClosedCessna 150 · Rock Hill, SCJul 8, 1976 · N18019 · Substantial damage NTSB MIA76DLG36Accident · No injuriesClosedCessna 182 · Ridgeland, SCJun 25, 1976 · N6479F · Substantial damage NTSB MIA76DLG35Accident · No injuriesClosedCitabria 7ECA · Summerton, SCJun 19, 1976 · N11066 · Substantial damage NTSB MIA76DLG34Accident · Minor injuriesClosedSchweizer SGS233 · Aiken, SCJun 15, 1976 · N7537 · Substantial damage NTSB MIA76DLG33Accident · No injuriesClosedChampion 7ECA · Batesburg, SCJun 1, 1976 · N9696S · Substantial damage NTSB MIA76FLG32Accident · Serious injuriesClosedAero Comdr 112 · Greenville, SCMay 26, 1976 · N1266J · Substantial damage NTSB MIA76FLG31Accident · No injuriesClosedPiper PA-32 · Simpsonville, SCMay 12, 1976 · N41579 · Substantial damage NTSB MIA76FLG30Accident · No injuriesClosedPiper PA-24 · Greenwood, SCMay 10, 1976 · N8758P · Substantial damage NTSB MIA76AM082Accident · 1 fatalClosedPiper J3C · New Ellenton, SCMay 6, 1976 · N51524 · Destroyed NTSB MIA76AM081Accident · 1 fatalClosedGrumman G-1159 · Hilton Head Is, SCMay 3, 1976 · N4CP · Minor damage NTSB MIA76DLG29Accident · No injuriesClosedPiper PA-28 · Catawba, SCApr 24, 1976 · N55598 · Substantial damage NTSB MIA76FLG28Accident · No injuriesClosedGlasflugel H-201B · Chester, SCApr 20, 1976 · N7190 · Substantial damage NTSB MIA76DLG27Accident · No injuriesClosedCessna 150J · Georgetown, SCMar 28, 1976 · N60696 · Substantial damage NTSB MIA76FLG26Accident · No injuriesClosedCessna U206F · Hardeeville, SCFeb 16, 1976 · N8273Q · Substantial damage NTSB MIA76FLG25Accident · Minor injuriesClosedCessna A150L · Bath, SCJan 24, 1976 · N6032J · Substantial damage NTSB MIA76DLG24Accident · No injuriesClosedPiper PA-18 · Chester, SCJan 4, 1976 · N7682D · Substantial damage