Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 MIA74AM049Accident · 2 fatalClosedBeech C90 · W Columbia, SCDec 20, 1973 · N711FC · Destroyed NTSB MIA74FLG17Accident · No injuriesClosedPiper PA-28R · Winnsboro, SCDec 19, 1973 · N16361 · Substantial damage NTSB MIA74FLG16Accident · Serious injuriesClosedBeech A35 · Easley, SCNov 14, 1973 · N528B · Destroyed NTSB MIA74DLG14Accident · No injuriesClosedCessna 182 · Summerville, SCNov 11, 1973 · N2708G · Substantial damage NTSB MIA74FLG13Accident · No injuriesClosedCessna 150F · Barnwell, SCNov 4, 1973 · N8297F · Substantial damage NTSB MIA74FLG12Accident · Serious injuriesClosedPiper PA-18A · Fairfax, SCSep 1, 1973 · N9087D · Destroyed NTSB MIA74D1011Accident · Minor injuriesClosedBell 47G-2 · Dalzell, SCAug 31, 1973 · N6711D · Substantial damage NTSB MIA74DLG10Accident · No injuriesClosedAmer Avco AA-1 · Conway, SCAug 30, 1973 · N5962L · Substantial damage NTSB MIA74DLG09Accident · Minor injuriesClosedPiper PA-18A · Bishopville, SCAug 30, 1973 · N8991D · Substantial damage NTSB MIA74FLG08Accident · No injuriesClosedPiper J3C-65 · Ulmers, SCAug 25, 1973 · N7001H · Substantial damage NTSB MIA74DLG07Accident · No injuriesClosedCessna 188 · Bennettsville, SCAug 24, 1973 · N4454Q · Substantial damage NTSB MIA74AM015Accident · 1 fatalClosedAmer Avco AA-5 · Abbeville, SCAug 16, 1973 · N5478L · Destroyed NTSB MIA74FLG06Accident · No injuriesClosedBoeing A75N1 · Allendale, SCAug 13, 1973 · N64980 · Substantial damage NTSB MIA74FLG05Accident · Minor injuriesClosedCessna 182K · Abbeville, SCAug 7, 1973 · N2731Q · Substantial damage NTSB MIA74DLG04Accident · No injuriesClosedBell 47D-1 · Bennettsville, SCAug 4, 1973 · N1MH · Substantial damage NTSB MIA74FLG03Accident · No injuriesClosedPiper PA-25 · Mcclellanville, SCJul 25, 1973 · N6177Z · Substantial damage NTSB MIA74FLG02Accident · No injuriesClosedGrumman G-164A · Marion, SCJul 20, 1973 · N8497 · Destroyed NTSB MIA74AM006Accident · 3 fatalClosedCessna 150E · Andrews, SCJul 19, 1973 · N2549J · Destroyed NTSB MIA73FLG01Accident · No injuriesClosedHughes 269B · Wagener, SCJul 13, 1973 · N9380F · Substantial damage NTSB MIA74AM001Accident · 3 fatalClosedAeronca 7AC · Kershaw, SCJul 8, 1973 · N82561 · Destroyed NTSB MIA73DLG52Accident · No injuriesClosedCessna 150 · New Ellenton, SCJun 29, 1973 · N3269J · Substantial damage NTSB MIA73DLG51Accident · No injuriesClosedCessna 182J · Cross, SCJun 25, 1973 · N2630F · Substantial damage NTSB MIA73FLG50Accident · Serious injuriesClosedSchemp Cirrus · Chester, SCJun 24, 1973 · N8083 · Destroyed NTSB MIA73DLG49Accident · No injuriesClosedHelio Acft H-295 · Greenville, SCJun 20, 1973 · N275ZD · Substantial damage NTSB MIA73FLG48Accident · No injuriesClosedCessna U206C · Little River, SCJun 1, 1973 · N29147 · Substantial damage NTSB MIA73FLG47Accident · No injuriesClosedThurston TSC-1A · Florence, SCMay 18, 1973 · N2010T · Substantial damage NTSB MIA73DLG46Accident · No injuriesClosedPiper PA-22 · Rock Hill, SCMay 17, 1973 · N606A · Substantial damage NTSB MIA73FLG45Accident · No injuriesClosedAero Comdr 560F · Greer, SCApr 24, 1973 · N59JR · Substantial damage NTSB MIA73FLG44Accident · Serious injuriesClosedCessna 150B · Columbia, SCApr 18, 1973 · N2860S · Destroyed NTSB MIA73FLG43Accident · No injuriesClosedPiper PA-23 · Cameron, SCApr 6, 1973 · N681M · Destroyed NTSB MIA73FLG42Accident · No injuriesClosedBeech 95-C55 · Orangeburg, SCApr 5, 1973 · N4112 · Substantial damage NTSB MIA73DLG41Accident · No injuriesClosedPiper PA-28 · Little River, SCApr 2, 1973 · N9466W · Substantial damage NTSB MIA73DLG40Accident · No injuriesClosedPiper PA-12 · Kinards, SCMar 27, 1973 · N92536 · Substantial damage NTSB MIA73DLG39Accident · No injuriesClosedNavion A · Pelzer, SCMar 26, 1973 · N27A · Substantial damage NTSB MIA73FLG38Accident · Minor injuriesClosedCessna 170 · Georgetown, SCMar 25, 1973 · N2557V · Substantial damage NTSB MIA73DLG37Accident · No injuriesClosedCessna 150F · Timmonsville, SCMar 24, 1973 · N3086X · Substantial damage NTSB MIA73DLG36Accident · No injuriesClosedPiper PA-28 · Johns Island, SCMar 19, 1973 · N4981T · Substantial damage NTSB IAD73AI005Accident · 2 fatalClosedCessna 172F · Mcclellanville, SCMar 9, 1973 · N5310R · Destroyed NTSB MIA73FLG35Accident · No injuriesClosedPiper PA-22 · Gaffney, SCMar 4, 1973 · N6018D · Substantial damage NTSB MIA73DLG34Accident · No injuriesClosedAmer Avco AA-1B · Aiken, SCFeb 28, 1973 · N6323L · Substantial damage NTSB MIA73DLG33Accident · No injuriesClosedPiper PA-11 · Isle Of Palms, SCFeb 4, 1973 · N4827M · Substantial damage NTSB MIA73AM078Accident · 1 fatalClosedBeech 95-B55 · Mauldin, SCFeb 2, 1973 · N9427Q · Destroyed NTSB MIA73FLG32Accident · Serious injuriesClosedPiper PA-28 · No.Myrtle Bch, SCJan 21, 1973 · N5118G · Substantial damage