Skip to content

NTSB investigations, 1978, SC

180,598 investigations by the National Transportation Safety Board since 1962: 174,578 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 MIA79FLG15Accident · No injuriesClosedCessna 152 · Mullins, SCDec 26, 1978 · N648CA · Substantial damage NTSB MIA79DLG16Accident · No injuriesClosedCessna 152 · Ridgeland, SCDec 26, 1978 · N757DT · Substantial damage NTSB MIA79FLG14Accident · No injuriesClosedCessna 150 · Mccoll, SCDec 23, 1978 · N3010S · Substantial damage NTSB MIA79FLG13Accident · Minor injuriesClosedCessna R172E · Clover, SCDec 23, 1978 · N94461 · Substantial damage NTSB MIA79DLG11Accident · No injuriesClosedCessna 172D · Johns Island, SCDec 16, 1978 · N855X · Substantial damage NTSB MIA79DLG10Accident · No injuriesClosedBeech B24 · Rock Hill, SCDec 16, 1978 · N6543R · Substantial damage NTSB MIA79DLG09Accident · No injuriesClosedCessna 152 · Manning, SCDec 6, 1978 · N714WK · Substantial damage NTSB MIA79FA028Accident · 1 fatalClosedCessna 182 · Union, SCDec 5, 1978 · N7535N · Destroyed NTSB MIA79FLG08Accident · Serious injuriesClosedM00ney M20C · Clio, SCDec 3, 1978 · N2647W · Destroyed NTSB MIA79FLG07Accident · Minor injuriesClosedHughes 269B · Camden, SCDec 3, 1978 · N9455F · Substantial damage NTSB MIA79FLG04Accident · Minor injuriesClosedBrittnorman BN-2A · Beaufort, SCDec 3, 1978 · N25DA · Substantial damage NTSB MIA79FLG06Accident · 1 fatalClosedFly Baby 1A · Moncks Corner, SCDec 2, 1978 · N8371 · Destroyed NTSB MIA79FLG17Accident · No injuriesClosedHiller FH1100 · West Columbia, SCDec 1, 1978 · N8126H · Substantial damage NTSB MIA79FLG05Accident · No injuriesClosedPiper PA-12 · N.Myrtle Bch, SCNov 29, 1978 · N3976M · Substantial damage NTSB MIA79FA022Accident · 2 fatalClosedPiper PA32RT · Charleston, SCNov 29, 1978 · N9771C · Destroyed NTSB MIA79FLG03Accident · Serious injuriesClosedCessna 182 · Clemson, SCOct 21, 1978 · N2243G · Destroyed NTSB MIA79FLG02Accident · No injuriesClosedPiper PA-28 · Columbia, SCOct 16, 1978 · N6927J · Substantial damage NTSB MIA79FLG01Accident · No injuriesClosedCessna 182P · Hilton Head, SCOct 10, 1978 · N7419Q · Substantial damage NTSB MIA78FLG39Accident · Minor injuriesClosedPiper PA-15 · Isle Of Palms, SCSep 18, 1978 · N4390H · Substantial damage NTSB MIA78FLG38Accident · No injuriesClosedCessna 310 · Gaston, SCSep 18, 1978 · N6942T · Substantial damage NTSB MIA78FLG37Accident · Serious injuriesClosedCessna 172 · Trenton, SCSep 8, 1978 · N9816V · Substantial damage NTSB MIA78FA122Accident · 2 fatalClosedPiper PA-38 · Florence, SCSep 8, 1978 · N4425E · Destroyed NTSB MIA78DLG36Accident · No injuriesClosedBell 47D1 · Summerville, SCAug 26, 1978 · N4116A · Substantial damage NTSB MIA78FLG33Accident · No injuriesClosedBellanca 8GCBC · Ulmer, SCAug 25, 1978 · N7686S · Substantial damage NTSB MIA78FLG32Accident · Serious injuriesClosedPiper PA-25 · Bennettsville, SCAug 21, 1978 · N7190Z · Destroyed NTSB MIA78FLG34Accident · No injuriesClosedBell 47G · Murrels Inlet, SCAug 16, 1978 · N25802 · Substantial damage NTSB MIA78FLG33Accident · No injuriesClosedGrumman G-164B · Little Rock, SCAug 16, 1978 · N6764Q · Destroyed NTSB MIA78DA112Accident · 1 fatalClosedSchemp Nimbus · Mt Groghan, SCAug 9, 1978 · N2WH · Destroyed NTSB MIA78DLG31Accident · Minor injuriesClosedLake LA-4 · Lexington, SCAug 6, 1978 · N6676L · Destroyed NTSB MIA78FLG30Accident · No injuriesClosedMooney M20E · Lexington, SCJul 27, 1978 · N6992U · Substantial damage NTSB MIA78FLG29Accident · Minor injuriesClosedCessna 182P · Ehrhardt, SCJul 22, 1978 · N9437M · Substantial damage NTSB MIA78DLG28Accident · No injuriesClosedCessna 310K · Landrum, SCJul 12, 1978 · N18HF · Substantial damage NTSB MIA78FLG27Accident · Minor injuriesClosedPiper PA-32 · Beaufort, SCJul 5, 1978 · N9885K · Destroyed NTSB MIA78DLG26Accident · No injuriesClosedPiper J-3 · Newberry, SCJul 2, 1978 · N2152M · Substantial damage NTSB MIA78FLG25Accident · Serious injuriesClosedPiper J3C · Harleyville, SCJun 21, 1978 · N70998 · Substantial damage NTSB MIA78DLG24Accident · No injuriesClosedCessna 177 · Hilton Head, SCJun 16, 1978 · N29607 · Substantial damage NTSB MIA78FLG23Accident · No injuriesClosedGrumman G-164B · Lane, SCJun 14, 1978 · N6648Q · Destroyed NTSB MIA78FLG21Accident · Serious injuriesClosedCessna 150L · Columbia, SCJun 12, 1978 · N6751G · Destroyed NTSB MIA78DLG12Accident · No injuriesClosedCessna 188A · Ehrhardt, SCMay 31, 1978 · N731KJ · Substantial damage NTSB MIA78FLG19Accident · Serious injuriesClosedJungster 1 · Ridgeville, SCMay 15, 1978 · N8VM · Substantial damage NTSB MIA78DLG20Accident · No injuriesClosedMolino PIK20B · York, SCApr 23, 1978 · N21AW · Substantial damage NTSB MIA78FLG18Accident · No injuriesClosedAeronca 7AC · Loris, SCApr 15, 1978 · N83649 · Substantial damage NTSB MIA78FLG17Accident · Minor injuriesClosedPiper PA-30 · Landrum, SCApr 8, 1978 · N8563Y · Destroyed NTSB MIA78FLG16Accident · Serious injuriesClosedRockwell 114 · Charleston, SCApr 1, 1978 · N4762 · Substantial damage NTSB MIA78DLG12Accident · No injuriesClosedCessna 182 · Pelzer, SCApr 1, 1978 · N58469 · Substantial damage NTSB MIA78DLG15Accident · No injuriesClosedPiper PA32 · Summerville, SCMar 26, 1978 · N1104X · Substantial damage NTSB MIA78DLG14Accident · No injuriesClosedNavion B · Abbeville, SCMar 26, 1978 · N5156K · Substantial damage NTSB MIA78FLG13Accident · No injuriesClosedBeech 65-80 · Columbia, SCMar 22, 1978 · N3YY · Substantial damage NTSB MIA78FLG11Accident · No injuriesClosedBeech E18S · West Columbia, SCMar 14, 1978 · N383B · Substantial damage NTSB MIA78FA049Accident · 1 fatalClosedPiper PA-28 · Bishopville, SCMar 5, 1978 · N8827J · Destroyed