Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 MIA73FLG31Accident · No injuriesClosedErco 415-C · Inman, SCDec 30, 1972 · N99543 · Substantial damage NTSB MIA73DLG30Accident · No injuriesClosedCessna 140 · N Myrtle Beach, SCDec 27, 1972 · N72137 · Substantial damage NTSB MIA73DLG29Accident · No injuriesClosedCessna 172 · No.Myrtle Bch, SCDec 27, 1972 · N2610L · Substantial damage NTSB MIA73AM060Accident · 3 fatalClosedBeech 58 · Anderson, SCDec 10, 1972 · N1643W · Destroyed NTSB MIA73AM054Accident · 1 fatalClosedMitsubishi MU-2B · Alcolu, SCNov 20, 1972 · N757Q · Destroyed NTSB MIA73DLG28Accident · No injuriesClosedLuscombe 8A · Columbia, SCNov 5, 1972 · N25129 · Substantial damage NTSB MIA73FLG26Accident · No injuriesClosedCessna 310G · Union, SCOct 16, 1972 · N2920R · Substantial damage NTSB MIA73FLG25Accident · No injuriesClosedCessna 206 · Spartanburg, SCOct 12, 1972 · N5017U · Substantial damage NTSB MIA73DLG24Accident · No injuriesClosedCessna 172H · Landrum, SCOct 8, 1972 · N2881L · Substantial damage NTSB MIA73FLG23Accident · No injuriesClosedPiper PA-22 · Ridgeland, SCSep 29, 1972 · N8746D · Substantial damage NTSB MIA73FLG21Accident · Minor injuriesClosedHughes 269A · Ridge Springs, SCSep 21, 1972 · N8735F · Substantial damage NTSB NYC73ANO61Accident · 1 fatalClosedCessna 140 · Gaffney, SCSep 17, 1972 · N2218N · Destroyed NTSB MIA73AM031Accident · 4 fatalClosedBeech E18S · Sumter, SCSep 17, 1972 · N21DD · Destroyed NTSB MIA73DLG20Accident · No injuriesClosedPiper PA-28 · Johns Island, SCSep 15, 1972 · N4825T · Substantial damage NTSB MIA73DLG19Accident · No injuriesClosedBeech E33 · Greenwood, SCSep 13, 1972 · N3162 · Substantial damage NTSB MIA73DLG18Accident · No injuriesClosedPiper PA-18A · Mccoll, SCSep 4, 1972 · N4890A · Substantial damage NTSB MIA73FLG15Accident · Minor injuriesClosedStinson 108 · Pelzer, SCAug 18, 1972 · N97283 · Substantial damage NTSB MIA73FLG14Accident · No injuriesClosedHughes 269B · Rembert, SCAug 17, 1972 · N9305F · Substantial damage NTSB MIA73DLG13Accident · No injuriesClosedLuscombe 8E · Gaffney, SCAug 12, 1972 · N2489K · Substantial damage NTSB MIA73DLG12Accident · No injuriesClosedCessna 172G · Saluda, SCAug 11, 1972 · N4311L · Substantial damage NTSB MIA73DLG16Accident · No injuriesClosedCessna 150 · Waterboro, SCAug 7, 1972 · N3555L · Substantial damage NTSB MIA73FLG11Accident · No injuriesClosedCessna 182 · Conway, SCAug 5, 1972 · N5412B · Substantial damage NTSB MIA73FLG10Accident · Minor injuriesClosedCessna 188 · Kline, SCAug 4, 1972 · N3574Q · Substantial damage NTSB MIA73DLG17Accident · No injuriesClosedCessna A188 · Fairfax, SCJul 31, 1972 · N21735 · Substantial damage NTSB MIA73DLG09Accident · No injuriesClosedCessna 150G · Charleston, SCJul 30, 1972 · N6364S · Substantial damage NTSB MIA73FLG08Accident · No injuriesClosedCessna 421A · Hilton Head, SCJul 28, 1972 · N2983Q · Substantial damage NTSB MIA73FLG07Accident · No injuriesClosedBell 47G-2 · Pinewood, SCJul 22, 1972 · N6711D · Substantial damage NTSB MIA73FLG06Accident · No injuriesClosedPiper J3C · Cades, SCJul 18, 1972 · N77549 · Substantial damage NTSB MIA73DLG04Accident · No injuriesClosedCurtis-Wrt 4C-1A · Columbia, SCJul 9, 1972 · N563N · Substantial damage NTSB MIA72DLG05Accident · No injuriesClosedPiper PA-28 · Myrtle Beach, SCJul 9, 1972 · N5129S · Substantial damage NTSB MIA73FLG01Accident · No injuriesClosedHughes 269A · Gaston, SCJul 2, 1972 · N8947F · Substantial damage NTSB MIA73DLG03Accident · Minor injuriesClosedPiper J-3 · Aiken, SCJul 2, 1972 · N5147B · Substantial damage NTSB MIA72IM144Incident · No injuriesClosedBeech 65-A80 · Columbia, SCJun 27, 1972 · N32TM · Minor damage NTSB MIA72AM141Accident · 1 fatalClosedCessna 172B · Santee, SCJun 24, 1972 · N7516X · Destroyed NTSB MIA72FLG43Accident · No injuriesClosedCallair A-9 · Barnwell, SCJun 5, 1972 · N7244V · Destroyed NTSB MIA72FLG42Accident · No injuriesClosedAeronca 7AC · White Rock, SCJun 3, 1972 · N4328E · Substantial damage NTSB MIA72DLG41Accident · No injuriesClosedPiper PA-28 · Clover, SCMay 31, 1972 · N9177J · Substantial damage NTSB MIA72FLG40Accident · No injuriesClosedCessna A185E · Columbia, SCMay 16, 1972 · N4AC · Substantial damage NTSB MIA72AM120Accident · No injuriesClosedPiper PA-30 · West Columbia, SCMay 9, 1972 · N7809Y · Substantial damage NTSB MIA72FLG37Accident · Minor injuriesClosedParks Thorp T-18 · St.Matthews, SCMay 6, 1972 · N614DP · Substantial damage NTSB MIA72FLG38Accident · No injuriesClosedCessna 310K · Landrum, SCMay 4, 1972 · N3833X · Substantial damage NTSB MIA72FLG35Accident · Minor injuriesClosedHughes 269A · Johns Island, SCApr 28, 1972 · N8909F · Substantial damage NTSB MIA72DLG36Accident · No injuriesClosedCessna 150 · Liberty, SCApr 25, 1972 · N8451M · Substantial damage NTSB MIA72FLG34Accident · No injuriesClosedCessna 177B · Anderson, SCApr 22, 1972 · N34251 · Substantial damage NTSB MIA72AM110Accident · 1 fatalClosedGlobe GC-1B · Hanahan, SCApr 14, 1972 · N80716 · Destroyed NTSB MIA72FLG33Accident · Serious injuriesClosedPiper PA-24 · Greenville, SCApr 2, 1972 · N5893P · Substantial damage NTSB MIA72AM104Accident · 5 fatalClosedCessna 320E · Charleston, SCMar 31, 1972 · N3421Q · Destroyed NTSB MIA72DLG32Accident · Minor injuriesClosedCessna 140 · Laurens, SCMar 25, 1972 · N81081 · Substantial damage NTSB MIA72DLG31Accident · No injuriesClosedCessna 150 · Pelzer, SCMar 15, 1972 · N6679F · Substantial damage NTSB MIA72FLG29Accident · Minor injuriesClosedPiper PA-28 · Cheraw, SCMar 14, 1972 · N419FL · Destroyed