Skip to content

NTSB investigations, 1974, 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, 1974, 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") = 1974 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\") = 1974
    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") = 1974
  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 MIA75FLG18Accident · No injuriesClosedCessna 172K · Greenville, SCNov 11, 1974 · N71036 · Substantial damage NTSB MIA75AM027Accident · 3 fatalClosedCessna 310Q · Charleston, SCNov 10, 1974 · N5985M · Destroyed NTSB MIA75DLG17Accident · No injuriesClosedHelio Acft H-295 · Cross Anchor, SCNov 2, 1974 · N68880 · Substantial damage NTSB MIA75DLG16Accident · No injuriesClosedCessna 150 · Anderson, SCOct 26, 1974 · N8668G · Substantial damage NTSB MIA75FKG15Accident · No injuriesClosedCessna 305A · Summerville, SCOct 11, 1974 · N12755 · Substantial damage NTSB MIA75DLG14Accident · No injuriesClosedPiper PA-28 · Edisto Beach, SCSep 28, 1974 · N56543 · Substantial damage NTSB MIA75FLG13Accident · Serious injuriesClosedLuscombe 8E · Chester, SCSep 12, 1974 · N2845K · Substantial damage NTSB MIA75AM019Accident · 2 fatalClosedPiper PA-12 · Summerville, SCSep 8, 1974 · N4031M · Destroyed NTSB MIA75D1G11Accident · Minor injuriesClosedPiper PA-18A · Lugoff, SCAug 15, 1974 · N4872A · Destroyed NTSB MIA75FLG10Accident · No injuriesClosedHughes 269B · Fort Motte, SCAug 12, 1974 · N9356F · Destroyed NTSB MIA75FLG12Accident · No injuriesClosedBeech A55 · Georgetown, SCAug 10, 1974 · N48C · Substantial damage NTSB MIA75DLG09Accident · Minor injuriesClosedCessna 188B · Cameron, SCAug 10, 1974 · N5754G · Destroyed NTSB MIA75AM014Accident · 1 fatalClosedErco 415-CD · Walterboro, SCAug 6, 1974 · N3836H · Destroyed NTSB MIA75DLG08Accident · No injuriesClosedChampion 7ECA · Aiken, SCJul 28, 1974 · N1814G · 2 aircraft · Substantial damage NTSB MIA75FLG06Accident · No injuriesClosedCessna A188B · Fairfax, SCJul 25, 1974 · N8438G · Substantial damage NTSB MIA74FLG05Accident · No injuriesClosedPiper J3L · Landrum, SCJul 17, 1974 · N32966 · Substantial damage NTSB MIA74FLG04Accident · No injuriesClosedErco 415-C · Carlisle, SCJul 17, 1974 · N93967 · Substantial damage NTSB MIA75FLG03Accident · Serious injuriesClosedCessna A188B · Dillon, SCJul 16, 1974 · N21703 · Destroyed NTSB MIA75DLG07Accident · No injuriesClosedBeech 58 · Santee, SCJul 6, 1974 · N1082W · Substantial damage NTSB MIA75FLG02Accident · No injuriesClosedBell 47G · Myrtle Beach, SCJul 5, 1974 · N1773 · Substantial damage NTSB MIA74FLG01Accident · No injuriesClosedPiper PA-23 · Johns Island, SCJul 3, 1974 · N4064P · Substantial damage NTSB MIA74DLG37Accident · No injuriesClosedAero Comdr A-9 · Bishopville, SCJun 28, 1974 · N7754V · Destroyed NTSB MIA74FLG36Accident · No injuriesClosedHelio Acft H-295 · Columbia, SCJun 24, 1974 · N3SC · Substantial damage NTSB DCA74AZ022Accident · 3 fatalClosedGrumman G-1159 · Kline, SCJun 24, 1974 · N720Q · Destroyed NTSB MIA74DLG38Accident · No injuriesClosedAeronca 7AC · Bennettsville, SCJun 23, 1974 · N1664E · Substantial damage NTSB MIA74DLG35Accident · No injuriesClosedPiper PA-28 · Gaffney, SCJun 18, 1974 · N41644 · Substantial damage NTSB MIA74D2G34Accident · Minor injuriesClosedCessna 188 · Florence, SCJun 17, 1974 · N1580M · Destroyed NTSB MIA74FLG31Accident · Minor injuriesClosedCessna 182N · Beauford, SCJun 15, 1974 · N92703 · Destroyed NTSB MIA74FLG32Accident · No injuriesClosedCessna 310Q · Mt Pleasant, SCJun 14, 1974 · N69796 · Destroyed NTSB MIA74DLG33Accident · No injuriesClosedCessna 150 · Mullins, SCJun 14, 1974 · N6313S · Substantial damage NTSB MIA74FLG30Accident · Serious injuriesClosedCessna 182P · Ridgeway, SCJun 9, 1974 · N7287N · Substantial damage NTSB MIA74DLG29Accident · No injuriesClosedCallair A-9B · Allendale, SCMay 30, 1974 · N7655V · Substantial damage NTSB MIA74FLG28Accident · No injuriesClosedCessna 150G · Charleston, SCMay 23, 1974 · N6364S · Substantial damage NTSB MIA74AM085Accident · 1 fatalClosedPiper PA-24 · Myrtle Beach, SCMay 4, 1974 · N8590P · Destroyed NTSB MIA74FLGI7Accident · Minor injuriesClosedCessna 172E · Beaufort, SCApr 15, 1974 · N5796T · Substantial damage NTSB IAD74II054Incident · No injuriesClosedGrumman G-159 · Charlestown, SCApr 8, 1974 · N8E · Minor damage NTSB MIA74AM084Accident · 1 fatalClosedCessna 182A · Seneca, SCApr 4, 1974 · N6044B · Destroyed NTSB MIA74FLG26Accident · Serious injuriesClosedCessna 177 · Hilton Head, SCMar 30, 1974 · N2245Y · Substantial damage NTSB MIA74FLG25Accident · Serious injuriesClosedCessna 182 · Allendale, SCMar 10, 1974 · N5412B · Substantial damage NTSB MIA74AM073Accident · 1 fatalClosedPiper PA-28 · Georgetown, SCFeb 22, 1974 · N1894J · Destroyed NTSB MIA74DLG24Accident · No injuriesClosedPiper PA-28 · Florence, SCFeb 18, 1974 · N56821 · Substantial damage NTSB MIA74DLG23Accident · Minor injuriesClosedChampion 7ECA · Plantersville, SCFeb 13, 1974 · N2986G · Substantial damage NTSB MIA74DLG22Accident · No injuriesClosedCessna 150 · N Myrtle Bch, SCJan 27, 1974 · N6551F · Substantial damage NTSB MIA74FLG21Accident · No injuriesClosedHughes 269-A · St Matthews, SCJan 22, 1974 · N8718F · Substantial damage NTSB MIA74DLG20Accident · No injuriesClosedCessna 150 · Union, SCJan 22, 1974 · N62795 · Substantial damage NTSB MIA74DLG19Accident · No injuriesClosedCessna 150 · Myrtle Beach, SCJan 14, 1974 · N6534G · Substantial damage NTSB MIA74FLG18Accident · Serious injuriesClosedPiper J-3C · Sumter, SCJan 6, 1974 · N98000 · Destroyed NTSB NYC74IN062Incident · No injuriesClosedDouglas DC-8 · Columbia, SCJan 3, 1974 · N8148PA · Minor damage NTSB MIA74AM053Accident · 2 fatalClosedPiper PA-30 · Charleston, SCJan 1, 1974 · N8546Y · Destroyed