Skip to content

NTSB investigations, 1975, NC

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 IAD76AI043Accident · No injuriesClosedBell 47G3 · Jacksonville, NCDec 20, 1975 · N6092 · Substantial damage NTSB IAD76FLJ10Accident · Minor injuriesClosedBeech A23 · Milton, NCDec 13, 1975 · N5076T · Substantial damage NTSB IAD76AI039Accident · No injuriesClosedCessna 170 · Salter Path, NCDec 10, 1975 · N2747C · 2 aircraft · Substantial damage NTSB IAD76DKM20Accident · Minor injuriesClosedGreat Lakes Baby · Greensboro, NCDec 6, 1975 · N1BL · Substantial damage NTSB IAD76DKM21Accident · Serious injuriesClosedCessna 182 · Mooresville, NCDec 5, 1975 · N5652B · Substantial damage NTSB IAD76FKM19Accident · No injuriesClosedCessna 210 · Gastonia, NCNov 30, 1975 · N5863F · Substantial damage NTSB IAD76AI037Accident · 4 fatalClosedPiper PA-32 · Robbinsville, NCNov 26, 1975 · N55661 · Destroyed NTSB IAD76FKM18Accident · Minor injuriesClosedErco 415-D · Witsett, NCNov 18, 1975 · N3864H · Substantial damage NTSB IAD76AI034Accident · 1 fatalClosedRepublic RC-3 · Gastonia, NCNov 16, 1975 · N87505 · Destroyed NTSB DCA76AZ011Accident · Serious injuriesClosedBoeing 727 · Raleigh, NCNov 12, 1975 · N8838E · Substantial damage NTSB IAD76II031Incident · No injuriesClosedNihon YS-11 · Jacksonville, NCNov 10, 1975 · N7218 · Minor damage NTSB IAD76DKM17Accident · No injuriesClosedPiper PA-28R · Winston Salem, NCNov 6, 1975 · N16361 · Substantial damage NTSB IAD76FKM16Accident · Serious injuriesClosedCessna 172 · Wadesboro, NCNov 4, 1975 · N21850 · Destroyed NTSB IAD76FLQ16Accident · No injuriesClosedMorrisey 2150A · Carrboro, NCNov 3, 1975 · N917JL · Substantial damage NTSB IAD76DKM14Accident · No injuriesClosedTaylorcraft BCL2-D · Wilkesboro, NCNov 1, 1975 · N44158 · Substantial damage NTSB IAD76DKM15Accident · No injuriesClosedCessna 182K · Horseshoe, NCOct 30, 1975 · N3207S · Substantial damage NTSB IAD76FLJ14Accident · No injuriesClosedBellanca 7ECA · Knightdale, NCOct 25, 1975 · N57674 · Substantial damage NTSB IAD76FLJ15Accident · No injuriesClosedCessna 305A · Elizabethtown, NCOct 18, 1975 · N5295G · Substantial damage NTSB IAD76DKM13Accident · No injuriesClosedAero Comdr 100 · Shelby, NCOct 15, 1975 · N3612X · Substantial damage NTSB IAD76AI023Accident · 2 fatalClosedPiper PA-28 · Harrisburg, NCOct 10, 1975 · N8893W · Destroyed NTSB IAD76FLJ13Accident · No injuriesClosedCessna 185 · Sanford, NCOct 4, 1975 · N1823B · Substantial damage NTSB IAD76AI021Accident · Serious injuriesClosedCessna 310Q · Wilmington, NCOct 4, 1975 · N2956Q · Substantial damage NTSB IAD76DLJ12Accident · No injuriesClosedCessna 172L · Angier, NCOct 3, 1975 · N7890G · Substantial damage NTSB IAD76DKM11Accident · No injuriesClosedPiper PA-32 · Charlotte, NCOct 3, 1975 · N7740J · Substantial damage NTSB NYC76AN038Accident · 1 fatalClosedBeech E18S · Charlotte, NCOct 1, 1975 · N882L · Destroyed NTSB IAD76DKM10Accident · No injuriesClosedCessna 172 · Boone, NCOct 1, 1975 · N3841R · Substantial damage NTSB IAD76FLJ11Accident · No injuriesClosedCessna 188B · Laurinburg, NCSep 30, 1975 · N53162 · Substantial damage NTSB IAD76DKM09Accident · No injuriesClosedCessna 182 · Midland, NCSep 21, 1975 · N5175D · Substantial damage NTSB IAD76DKM12Accident · No injuriesClosedPiper PA-28 · Franklin, NCSep 13, 1975 · N593FL · Substantial damage NTSB IAD7LFLJ09Accident · 1 fatalClosedWoods WT-17 · Holly Springs, NCSep 5, 1975 · N17WT · Destroyed NTSB IAD76ALJ08Accident · No injuriesClosedStarduster SA-300 · Chapel Hill, NCSep 3, 1975 · N3589 · Substantial damage NTSB IAD76AI012Accident · 2 fatalClosedCessna 210J · Charlotte, NCSep 1, 1975 · N6177F · Destroyed NTSB IAD76DKM07Accident · No injuriesClosedCessna 150 · Ashoboo, NCAug 30, 1975 · N11208 · Substantial damage NTSB IAD76DLJ07Accident · No injuriesClosedPiper PA-28 · Fayetteville, NCAug 16, 1975 · N5984U · Substantial damage NTSB IAD76FLJ06Accident · 1 fatalClosedPiper PA-18A · Kinston, NCAug 12, 1975 · N3696A · Destroyed NTSB IAD76AI008Accident · 2 fatalClosedPiper PA-28 · Charlotte, NCAug 11, 1975 · N5423W · Destroyed NTSB IAD76FLJ05Accident · Serious injuriesClosedCallair A-9 · Kenansville, NCAug 9, 1975 · N7219V · Destroyed NTSB IAD75AI005Accident · 4 fatalClosedPiper PA-28R · Boone, NCAug 3, 1975 · N7628J · Destroyed NTSB IAD76DKM08Accident · No injuriesClosedCessna 150 · Yadkinville, NCJul 30, 1975 · N6548T · Substantial damage NTSB IAD76DKM05Accident · No injuriesClosedPiper PA-32 · Franklin, NCJul 30, 1975 · N15126 · Substantial damage NTSB IAD76AKM06Accident · No injuriesClosedPiper PA-22 · Ashville, NCJul 29, 1975 · N3504Z · Substantial damage NTSB IAD76DKM02Accident · No injuriesClosedAeronca 11CC · Midland, NCJul 27, 1975 · N988E · Substantial damage NTSB IAD7LDKM03Accident · No injuriesClosedCessna 172 · Statesville, NCJul 26, 1975 · N61901 · Substantial damage NTSB IAD76FLJ04Accident · No injuriesClosedPiper PA-24 · Manteo, NCJul 26, 1975 · N8383P · Substantial damage NTSB IAD76DKM04Accident · Minor injuriesClosedCessna 177 · Greensboro, NCJul 24, 1975 · N3210T · Substantial damage NTSB IAD76FLJ03Accident · Serious injuriesClosedCessna 172F · Burlington, NCJul 22, 1975 · N8845U · Substantial damage NTSB IAD76FLJ02Accident · No injuriesClosedCessna 182P · Raeford, NCJul 21, 1975 · N21508 · Substantial damage NTSB IAD76AI003Accident · 1 fatalClosedCessna 182 · Edneyville, NCJul 17, 1975 · N52208 · Destroyed NTSB IAD76FKM01Accident · 1 fatalClosedTeenie TWO · Marion, NCJul 13, 1975 · N223 · Destroyed NTSB IAD76FLJ01Accident · No injuriesClosedPiper PA-28 · Sanford, NCJul 3, 1975 · N41268 · Substantial damage