Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 MIA76IM055Incident · No injuriesClosedDouglas DC9-31 · Greer, SCDec 31, 1975 · N8933E · Minor damage NTSB MIA76FLG19Accident · Minor injuriesClosedPiper PA-28 · Darlington, SCNov 22, 1975 · N55083 · Substantial damage NTSB MIA76DLG23Accident · No injuriesClosedCessna 172 · Blair, SCOct 25, 1975 · N6439E · Substantial damage NTSB MIA76DLG22Accident · No injuriesClosedPiper PA-28 · Ridgeland, SCOct 21, 1975 · N40714 · Substantial damage NTSB MIA76FLG21Accident · Serious injuriesClosedCessna 210L · Greer, SCOct 19, 1975 · N210EM · Destroyed NTSB MIA76DLG20Accident · Minor injuriesClosedPiper PA-28R · Florence, SCOct 17, 1975 · N3988X · Destroyed NTSB MIA76FLG16Accident · Minor injuriesClosedPiper PA-28R · Surfside, SCOct 4, 1975 · N4822T · Substantial damage NTSB MIA76AM030Accident · 1 fatalClosedPiper PA-28 · Angelus, SCSep 29, 1975 · N7484R · Destroyed NTSB MIA76DLG18Accident · Minor injuriesClosedPiper J3 · Mauldin, SCSep 28, 1975 · N4504H · Substantial damage NTSB MIA76FLG17Accident · Serious injuriesClosedBantam W-3 · Georgetown, SCSep 21, 1975 · N422 · Destroyed NTSB MIA76AM028Accident · No injuriesClosedPiper PA-31 · Greenwood, SCSep 10, 1975 · N59982 · Substantial damage NTSB MIA75ALG15Accident · Minor injuriesClosedCessna 188B · Barnwell, SCAug 31, 1975 · N21800 · Destroyed NTSB MIA76FLG13Accident · Minor injuriesClosedBell 47G-2 · Elliott, SCAug 26, 1975 · N6711D · Substantial damage NTSB MIA76DLG12Accident · No injuriesClosedHughes 269B · Saluda, SCAug 23, 1975 · N9560F · Destroyed NTSB MIA76FLG11Accident · No injuriesClosedHughes 269A · Lexington, SCAug 20, 1975 · N8872F · Substantial damage NTSB MIA76DLG10Accident · Minor injuriesClosedCessna 172H · Nichols, SCAug 19, 1975 · N3292L · Substantial damage NTSB MIA76FLG09Accident · No injuriesClosedDehavilland DHC-1B · Columbia, SCAug 15, 1975 · N33BR · Substantial damage NTSB MIA76FLG08Accident · No injuriesClosedAero Comdr 600S2R · Latta, SCAug 13, 1975 · N4248X · Substantial damage NTSB MIA76FLG07Accident · No injuriesClosedBell 47G · Pinewood, SCAug 12, 1975 · N73871 · Substantial damage NTSB MIA76AM014Accident · 2 fatalClosedCessna 170B · Isle Of Palms, SCAug 9, 1975 · N562DH · Destroyed NTSB MIA76FLG06Accident · No injuriesClosedPiper PA-22 · Dovesville, SCAug 4, 1975 · N8126C · Substantial damage NTSB MIA76FLG05Accident · No injuriesClosedStinson 108-3 · Ridgeland, SCJul 27, 1975 · N6173M · Substantial damage NTSB MIA76FLG04Accident · No injuriesClosedBell 47G · Myrtle Beach, SCJul 26, 1975 · N1773 · Substantial damage NTSB MIA76FLG03Accident · No injuriesClosedCessna 172K · Greenville, SCJul 8, 1975 · N84434 · Substantial damage NTSB MIA76FLG02Accident · No injuriesClosedPiper PA-32 · Beech Island, SCJul 4, 1975 · N121MB · Substantial damage NTSB MIA76FLG01Accident · Minor injuriesClosedCessna P206 · Winnsboro, SCJul 4, 1975 · N2599X · Destroyed NTSB MIA75FLG40Accident · No injuriesClosedBoeing A75N1 · Fairfax, SCJun 30, 1975 · N63624 · Substantial damage NTSB MIA75FLG41Accident · Serious injuriesClosedHughes 269A · Reidville, SCJun 8, 1975 · N8853F · Substantial damage NTSB MIA75DLG36Accident · No injuriesClosedSchweizer 2-33 · Chester, SCJun 8, 1975 · N5767S · Substantial damage NTSB MIA75AM082Accident · 1 fatalClosedPiper PA-22 · Conway, SCMay 23, 1975 · N5723Z · Destroyed NTSB MIA75DLG39Accident · No injuriesClosedCessna 150M · Mcclellanville, SCMay 19, 1975 · N45363 · Substantial damage NTSB MIA75DLG38Accident · No injuriesClosedPiper PA-28 · Chester, SCMay 18, 1975 · N1775J · Substantial damage NTSB MIA7KDLG37Accident · No injuriesClosedCessna 150 · Walterboro, SCMay 16, 1975 · N5912J · Substantial damage NTSB MIA75FLG35Accident · No injuriesClosedHughes 269A · Ridge Springs, SCMay 12, 1975 · N8735F · Substantial damage NTSB NYC75AN104Accident · 1 fatalClosedChampion 7KCAB · Chester, SCMay 4, 1975 · N1643G · Destroyed NTSB MIA75DLG34Accident · Minor injuriesClosedCessna 182 · Lugoff, SCApr 30, 1975 · N5300B · Substantial damage NTSB MIA75DLG33Accident · No injuriesClosedPiper J4E · Easley, SCApr 27, 1975 · N37976 · Substantial damage NTSB MIA75AM016Accident · 6 fatalClosedBeech A100 · Hilton Head Is, SCApr 26, 1975 · N700SP · Destroyed NTSB MIA76FLG31Accident · No injuriesClosedAero Comdr 200-D · Charlestown, SCApr 10, 1975 · N202GM · Substantial damage NTSB MIA75FLG30Accident · Minor injuriesClosedPiper PA-28R · North, SCApr 6, 1975 · N4585J · Substantial damage NTSB MIA75DLG29Accident · No injuriesClosedPiper PA-28 · Johns Island, SCApr 5, 1975 · N55864 · Substantial damage NTSB MIA75FLG28Accident · No injuriesClosedCessna 177 · Blacksburg, SCMar 31, 1975 · N2995X · Substantial damage NTSB MIA75FLG27Accident · Minor injuriesClosedBoeing E75 · Barnwell, SCMar 13, 1975 · N54731 · Destroyed NTSB MIA75DLG26Accident · No injuriesClosedEnstrom F-28A · Columbia, SCMar 8, 1975 · N9244 · Substantial damage NTSB MIA75DLG25Accident · Minor injuriesClosedCessna 140 · Manning, SCMar 2, 1975 · N76371 · Substantial damage NTSB MIA75DLG24Accident · No injuriesClosedCessna 172 · Hilton Head, SCFeb 22, 1975 · N13237 · Substantial damage NTSB MIA75FLG23Accident · Minor injuriesClosedStinson 108-3 · Anderson, SCFeb 7, 1975 · N6655N · Substantial damage NTSB MIA75FLG22Accident · No injuriesClosedPiper PA-28R · Myrtle Beach, SCFeb 7, 1975 · N5107S · Substantial damage NTSB MIA75DLG21Accident · No injuriesClosedAmer Avco AA1-A · Aiken, SCJan 18, 1975 · N6424L · Substantial damage NTSB MIA75FLG20Accident · No injuriesClosedPiper PA-25 · Laurens, SCJan 8, 1975 · N9765P · Substantial damage