Skip to content

NTSB investigations, 1973, NC

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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

19622026

NTSB investigations, 1973, NC per year, 1962–2026: 3,234 cases
1962	3
1963	2
1964	102
1965	83
1966	81
1967	101
1968	85
1969	77
1970	67
1971	86
1972	89
1973	118
1974	100
1975	90
1976	76
1977	77
1978	77
1979	52
1980	59
1981	47
1982	59
1983	56
1984	53
1985	51
1986	60
1987	47
1988	52
1989	52
1990	48
1991	52
1992	50
1993	37
1994	52
1995	39
1996	32
1997	49
1998	35
1999	38
2000	42
2001	40
2002	37
2003	38
2004	27
2005	42
2006	39
2007	37
2008	33
2009	37
2010	31
2011	37
2012	28
2013	30
2014	29
2015	44
2016	25
2017	34
2018	24
2019	29
2020	30
2021	41
2022	30
2023	34
2024	33
2025	22
2026	27

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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 IAD74DKM33Accident · No injuriesClosedCessna 150 · High Point, NCDec 29, 1973 · N5958G · Substantial damage NTSB IAD74DKM32Accident · Minor injuriesClosedMooney M20B · Rosman, NCDec 26, 1973 · N74578 · Substantial damage NTSB IAD74FKM31Accident · No injuriesClosedChampion 7HC · Thomasville, NCDec 23, 1973 · N8555E · Substantial damage NTSB IAD74DKM28Accident · No injuriesClosedPiper PA-28R · Greensboro, NCDec 19, 1973 · N3951T · Substantial damage NTSB IAD74AI035Accident · Minor injuriesClosedDouglas DC-9 · Greensboro, NCDec 17, 1973 · N8978E · Substantial damage NTSB IAD74DLJ24Accident · No injuriesClosedCessna 172M · Wilmington, NCDec 2, 1973 · N20512 · Substantial damage NTSB IAD74AI030Accident · 5 fatalClosedMooney M20C · Lenoir, NCNov 26, 1973 · N5515Q · Destroyed NTSB IAD74AI029Accident · 1 fatalClosedCessna U206C · Hayesville, NCNov 25, 1973 · N29241 · Destroyed NTSB IAD74AI028Accident · 2 fatalClosedPiper PA-23 · Heaton, NCNov 25, 1973 · N1391P · Destroyed NTSB IAD74DKM29Accident · No injuriesClosedCessna 150 · Gastonia, NCNov 22, 1973 · N6314G · Substantial damage NTSB NYC74AN045Accident · 2 fatalClosedBeech T-34B · Kinston, NCNov 19, 1973 · N14514 · 2 aircraft · Destroyed NTSB IAD74FLJ22Accident · Minor injuriesClosedBell 47G-4 · Aulander, NCNov 15, 1973 · N73276 · Substantial damage NTSB IAD74DLJ21Accident · No injuriesClosedCessna 172F · Raeford, NCNov 14, 1973 · N5652R · Substantial damage NTSB IAD74FKM27Accident · Serious injuriesClosedBenson B8M · Salisbury, NCNov 6, 1973 · N6020 · Substantial damage NTSB IAD74DKM26Accident · Minor injuriesClosedSpezio Sport · Thomasville, NCNov 3, 1973 · N3695 · Substantial damage NTSB IAD74DKM24Accident · Serious injuriesClosedPiper PA-28 · Albemarle, NCNov 3, 1973 · N6449W · Substantial damage NTSB IAD74DKM25Accident · No injuriesClosedCessna 310Q · Winston Salem, NCNov 1, 1973 · N69561 · Substantial damage NTSB DCA74AZ009Accident · Minor injuriesClosedBoeing 737 · Greensboro, NCOct 28, 1973 · N751N · Substantial damage NTSB IAD74DKM23Accident · No injuriesClosedCessna 150 · High Point, NCOct 23, 1973 · N5726G · Substantial damage NTSB IAD74DLJ20Accident · No injuriesClosedMooney M20D · Portsmouth, NCOct 21, 1973 · N1922Y · Substantial damage NTSB IAD74DKM22Accident · No injuriesClosedCessna 150 · Indian Trail, NCOct 19, 1973 · N16005 · Substantial damage NTSB IAD74DKM21Accident · No injuriesClosedCessna 172 · Asheville, NCOct 7, 1973 · N5970A · Substantial damage NTSB IAD74DKM20Accident · No injuriesClosedAmer Avco AA-5 · Taylorsville, NCSep 29, 1973 · N6023L · Destroyed NTSB IAD74DIJ19Accident · No injuriesClosedPiper PA-28 · Burlington, NCSep 23, 1973 · N95069 · Substantial damage NTSB IAD74FLJ18Accident · Minor injuriesClosedCessna 172 · Sanford, NCSep 22, 1973 · N7077A · Substantial damage NTSB IAD74II016Incident · No injuriesClosedDouglas DC-9 · Charlotte, NCSep 13, 1973 · N8966E · Minor damage NTSB IAD74DKM19Accident · No injuriesClosedFairchild M-62C · Hiddenite, NCSep 12, 1973 · N9473H · Substantial damage NTSB IAD74FLJ17Accident · Minor injuriesClosedCessna 177 · Bladenboro, NCSep 9, 1973 · N2385Y · Destroyed NTSB IAD74DKM16Accident · No injuriesClosedCessna 182 · Hickory, NCSep 7, 1973 · N7379Q · Substantial damage NTSB IAD74FLJ16Accident · No injuriesClosedN.American P51D · Yanceyville, NCSep 5, 1973 · N2116 · Substantial damage NTSB IAD74DKM18Accident · No injuriesClosedCessna 140 · Greensboro, NCSep 3, 1973 · N2652N · Substantial damage NTSB IAD74DKM17Accident · No injuriesClosedBell 47G-2 · Yadkinville, NCSep 1, 1973 · N262MV · Substantial damage NTSB IAD74DLJ15Accident · No injuriesClosedBellanca 17-30 · Ocean Isle, NCAug 28, 1973 · N39909 · Substantial damage NTSB IAD74DLJ14Accident · No injuriesClosedPiper PA-22 · Burlington, NCAug 27, 1973 · N3776A · Substantial damage NTSB IAD74FLJ12Accident · Serious injuriesClosedPiper PA-28 · Riegelwood, NCAug 26, 1973 · N5177L · Substantial damage NTSB IAD74DKM14Accident · No injuriesClosedPiper PA-28 · Salisbury, NCAug 21, 1973 · N8163W · Substantial damage NTSB IAD74DKM15Accident · No injuriesClosedCessna 175 · Charlotte, NCAug 19, 1973 · N6692E · Substantial damage NTSB IAD74DKM12Accident · No injuriesClosedPiper PA-28R · Brevard, NCAug 18, 1973 · N22DB · Substantial damage NTSB IAD74FLJ10Accident · 1 fatalClosedPiper PA-18A · Grantham, NCAug 17, 1973 · N8188D · Destroyed NTSB IAD74FKM13Accident · No injuriesClosedCessna 172 · Lake Lure, NCAug 17, 1973 · N79474 · Substantial damage NTSB IAD74AI013Accident · 1 fatalClosedCessna 188B · Swan Quarter, NCAug 17, 1973 · N21689 · 2 aircraft · Minor damage NTSB IAD74DKM11Accident · No injuriesClosedCessna 310 · Greensboro, NCAug 4, 1973 · N4063Q · Substantial damage NTSB IAD74FKM09Accident · Minor injuriesClosedCessna 150 · Fuquay, NCJul 30, 1973 · N5233Q · Substantial damage NTSB IAD74FLJ06Accident · 1 fatalClosedN.American AT-6C · Clarkton, NCJul 29, 1973 · N6419D · Substantial damage NTSB IAD74DKM07Accident · No injuriesClosedAeronca 7BCM · Charlotte, NCJul 29, 1973 · N75367 · Substantial damage NTSB IAD74FLJ05Accident · Minor injuriesClosedCessna 172 · Raleigh, NCJul 28, 1973 · N5644A · Substantial damage NTSB IAD74DKM05Accident · No injuriesClosedPiper PA-12 · Indian Trail, NCJul 22, 1973 · N3289M · Substantial damage NTSB IAD74DKM06Accident · Serious injuriesClosedTaylorcraft BC12-D · Wadesboro, NCJul 21, 1973 · N95099 · Substantial damage NTSB IAD74FLJ03Accident · 1 fatalClosedPiper PA-18A · Kinston, NCJul 17, 1973 · N8154C · Destroyed NTSB IAD74AI005Accident · 3 fatalClosedPiper PA-23 · Deep Run, NCJul 17, 1973 · N3117P · Destroyed