Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MIA78DLG06Accident · Minor injuriesClosedPiper PA-28 · Sheldon, SCNov 30, 1977 · N2047M · Destroyed NTSB MIA78DA033Accident · No injuriesClosedBeech B90 · Charleston, SCNov 26, 1977 · N55MG · Destroyed NTSB MIA78FLG04Accident · No injuriesClosedBeech 58 · Hilton Head, SCNov 25, 1977 · N10VS · Substantial damage NTSB MIA78FLG03Accident · No injuriesClosedCessna 182D · Summerville, SCNov 20, 1977 · N9994T · Substantial damage NTSB MIA78FLG02Accident · No injuriesClosedBeech A23-A · Iva, SCOct 30, 1977 · N2308W · Substantial damage NTSB MIA78FA002Accident · 2 fatalClosedPiper PA-30 · Charleston, SCOct 10, 1977 · N7585Y · Destroyed NTSB UNK78X0100Accident · No injuriesClosedCessna 188B · St Matthews, SCOct 1, 1977 · N53354 · Substantial damage NTSB MIA77FLG38Accident · No injuriesClosedPiper PA-32 · Beaufort, SCSep 25, 1977 · N7744J · Substantial damage NTSB MIA77FLG37Accident · Minor injuriesClosedCessna 305A · Aiken, SCSep 18, 1977 · N5257G · Substantial damage NTSB MIA77FLG36Accident · No injuriesClosedCessna A188B · Bennettsville, SCSep 5, 1977 · N4454Q · Substantial damage NTSB MIA77FA083Accident · 2 fatalClosedPiper PA-28 · Lodge, SCSep 4, 1977 · N6334W · Destroyed NTSB MIA77FLG35Accident · Minor injuriesClosedAmateur ACE-E · Allendale, SCSep 2, 1977 · N91706 · Substantial damage NTSB MIA77FLG34Accident · No injuriesClosedPiper PA-25 · Ehrhardt, SCAug 29, 1977 · N82313 · Substantial damage NTSB MIA77FLG33Accident · 1 fatalClosedCessna 182 · Myrtle Beach, SCAug 22, 1977 · N3256U · Destroyed NTSB MIA77FLG30Accident · No injuriesClosedCessna 188 · Edgemoor, SCAug 17, 1977 · N8014V · Substantial damage NTSB MIA77FLG32Accident · No injuriesClosedPiper PA-25 · Belton, SCAug 13, 1977 · N6370Z · Substantial damage NTSB MIA77FLG29Accident · No injuriesClosedHughes 269B · Johnston, SCAug 8, 1977 · N9325F · Substantial damage NTSB MIA77FLG27Accident · Minor injuriesClosedPiper PA-36 · Darlington, SCAug 7, 1977 · N59655 · Substantial damage NTSB MIA77FA076Accident · 2 fatalClosedChampion 7ECA · Greenville, SCAug 7, 1977 · N9103L · Destroyed NTSB MIA77DLG31Accident · No injuriesClosedSchweizer SGS135 · Rock Hill, SCAug 7, 1977 · N34176 · Substantial damage NTSB MIA77FLG28Accident · No injuriesClosedCessna A188B · Lynchburg, SCAug 6, 1977 · N5619G · Substantial damage NTSB MIA77FLG26Accident · No injuriesClosedCessna A188B · Livingston, SCAug 6, 1977 · N5854G · Destroyed NTSB MIA77DLG25Accident · No injuriesClosedLake LA-4 · Charleston, SCJul 25, 1977 · N6058V · Substantial damage NTSB MIA77FLG24Accident · No injuriesClosedBeech E33 · St Matthews, SCJul 18, 1977 · N7842R · Destroyed NTSB MIA77FLG23Accident · Serious injuriesClosedCessna 140 · Isle Of Palms, SCJul 17, 1977 · N2418N · Destroyed NTSB MIA77DLG22Accident · No injuriesClosedBeech 95-A55 · Greenville, SCJul 13, 1977 · N48C · Substantial damage NTSB MIA77DLG21Accident · Minor injuriesClosedMooney M20C · Darlington, SCJul 1, 1977 · N6857N · Substantial damage NTSB MIA77DA066Accident · 2 fatalClosedDavis D-1-W · Camden, SCJun 29, 1977 · N13576 · Destroyed NTSB MIA77DLG20Accident · No injuriesClosedBell 47D · Oswego, SCJun 25, 1977 · N586T · Substantial damage NTSB MIA77FLG19Accident · No injuriesClosedPiper PA-23 · Charleston, SCJun 21, 1977 · N444VM · Substantial damage NTSB MIA77FLG18Accident · No injuriesClosedPiper PA-28 · Barnwell, SCJun 4, 1977 · N56648 · Substantial damage NTSB MIA77DLG17Accident · No injuriesClosedPiper PA-24 · N.Myrtle Beach, SCMay 22, 1977 · N8350P · Substantial damage NTSB MIA77FLG16Accident · Minor injuriesClosedCessna A188B · Hampton, SCMay 7, 1977 · N21675 · Destroyed NTSB MIA77FLG15Accident · 2 fatalClosedStarduster 2 · Camden, SCApr 30, 1977 · N2JL · Destroyed NTSB MIA77FLG14Accident · No injuriesClosedAero Comdr 112A · Union, SCApr 18, 1977 · N1368J · Substantial damage NTSB MIA77DLG13Accident · No injuriesClosedCessna 180 · Chester, SCApr 17, 1977 · N6500A · Substantial damage NTSB MIA77FA046Accident · 1 fatalClosedPiper PA-32 · Charleston, SCMar 15, 1977 · N43216 · Destroyed NTSB MIA77DLG12Accident · Minor injuriesClosedPiper PA-28 · Conway, SCMar 12, 1977 · N75037 · Substantial damage NTSB MIA77FLG11Accident · No injuriesClosedMooney M20F · Whitmire, SCMar 1, 1977 · N6479Q · Substantial damage NTSB MIA77DLG10Accident · No injuriesClosedCessna 150 · Moncks Corner, SCFeb 14, 1977 · N11545 · Substantial damage NTSB MIA77FLG09Accident · No injuriesClosedCessna 210T · Charleston, SCJan 26, 1977 · N732HZ · Substantial damage NTSB MIA77FLG08Accident · No injuriesClosedAero Comdr 100 · Georgetown, SCJan 23, 1977 · N4046X · Destroyed NTSB MIA77DLG07Accident · No injuriesClosedCessna 205 · Charleston, SCJan 10, 1977 · N4831U · Substantial damage NTSB MIA77FLG06Accident · No injuriesClosedCessna 150M · Isle Of Palms, SCJan 8, 1977 · N8805U · Substantial damage