Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 IAD71DKM23Accident · No injuriesClosedCessna 401A · Winston Salem, NCDec 31, 1970 · N22AW · Substantial damage NTSB IAD71II032Incident · No injuriesClosedDouglas DC-9 · Greensboro, NCDec 29, 1970 · N895E · Minor damage NTSB IAD71DLJ19Accident · No injuriesClosedCessna 150 · Fort Bragg, NCDec 27, 1970 · N60604 · Destroyed NTSB IAD71AI031Accident · 1 fatalClosedBeech A-23 · Chadbourn, NCDec 25, 1970 · N8774M · Substantial damage NTSB IAD71DKM22Accident · Minor injuriesClosedCessna 172G · Yadkinville, NCDec 17, 1970 · N1320F · Substantial damage NTSB IAD71DKM21Accident · No injuriesClosedCessna 337C · Lincolnton, NCDec 17, 1970 · N2540S · Substantial damage NTSB IAD71DKM20Accident · No injuriesClosedPiper PA-28 · Spruce Pine, NCDec 13, 1970 · N5488W · Substantial damage NTSB IAD71FIJ18Accident · No injuriesClosedPiper PA-22 · Kinston, NCNov 15, 1970 · N9234D · Substantial damage NTSB IAD71FLJ16Accident · No injuriesClosedCessna 150 · Belhaven, NCNov 11, 1970 · N51269 · Substantial damage NTSB NYC71AN056Accident · 2 fatalClosedCessna 150H · Bahama, NCNov 8, 1970 · N6418S · Destroyed NTSB IAD71AI023Accident · 1 fatalClosedPiper PA-30 · Creston, NCNov 4, 1970 · N7736Y · Destroyed NTSB IAD71II014Incident · No injuriesClosedBoeing 727 · Charlotte, NCOct 22, 1970 · N8104N · No damage NTSB IAD71FKM19Accident · Serious injuriesClosedPiper PA-28 · Greensboro, NCOct 14, 1970 · N7433W · Substantial damage NTSB IAD71DKM16Accident · Minor injuriesClosedPiper PA-28 · Greensboro, NCOct 11, 1970 · N2549R · Substantial damage NTSB IAD71DKM17Accident · No injuriesClosedCessna 180B · Denver, NCOct 9, 1970 · N674M · Substantial damage NTSB IAD70DLJ15Accident · Serious injuriesClosedCessna 150 · Edenton, NCOct 4, 1970 · N50572 · Substantial damage NTSB IAD71DKM15Accident · No injuriesClosedLuscombe 8A · Waxhaw, NCSep 27, 1970 · N77842 · Substantial damage NTSB IAD71DKM14Accident · No injuriesClosedPiper PA-28 · Salisbury, NCSep 15, 1970 · N5839W · Substantial damage NTSB IAD71DLJ13Accident · Minor injuriesClosedCessna 182 · Whiteville, NCSep 10, 1970 · N71471 · Substantial damage NTSB IAD71DKM13Accident · Minor injuriesClosedPiper PA-28 · Lenoir, NCSep 5, 1970 · N5123L · Substantial damage NTSB IAD71FLJ11Accident · No injuriesClosedCessna 177 · Raleigh, NCAug 29, 1970 · N3271T · Substantial damage NTSB IAD71DKM12Accident · No injuriesClosedPiper PA-12 · Mooresville, NCAug 27, 1970 · N4392M · Substantial damage NTSB IAD71DKM11Accident · Serious injuriesClosedCessna 150 · Burnsville, NCAug 26, 1970 · N8612S · Substantial damage NTSB IAD71DKM10Accident · No injuriesClosedMonocoupe 90A · Monroe, NCAug 22, 1970 · N119V · Substantial damage NTSB IAD71AI009Accident · 1 fatalClosedPiper PA-28 · Garner, NCAug 20, 1970 · N7590R · Destroyed NTSB IAD71FLJ10Accident · No injuriesClosedKnight KT-115 · Clinton, NCAug 19, 1970 · N7801 · Substantial damage NTSB IAD71DLJ09Accident · No injuriesClosedBell 47G-2 · Pactolus, NCAug 14, 1970 · N73264 · Destroyed NTSB IAD71FKM09Accident · No injuriesClosedCessna 172H · Greensboro, NCAug 9, 1970 · N1726F · Substantial damage NTSB IAD71DKM08Accident · No injuriesClosedCessna 150G · Greensboro, NCAug 5, 1970 · N8597J · Substantial damage NTSB IAD71FLJ08Accident · No injuriesClosedCessna 140A · Jacksonville, NCAug 2, 1970 · N72979 · Substantial damage NTSB IAD71DKM06Accident · No injuriesClosedMooney M20G · Hickory, NCJul 25, 1970 · N9310V · Substantial damage NTSB IAD71FKM05Accident · Serious injuriesClosedPiper PA-28 · Banner Elk, NCJul 21, 1970 · N7532R · Destroyed NTSB IAD71DKM07Accident · No injuriesClosedLuscombe 8E · Wadesboro, NCJul 19, 1970 · N25295 · Substantial damage NTSB IAD71DKM03Accident · No injuriesClosedBeech V35A · Statesville, NCJul 18, 1970 · N2810A · Substantial damage NTSB IAD71DKM02Accident · No injuriesClosedMooney M20F · Winston-Salem, NCJul 16, 1970 · N3417N · Substantial damage NTSB IAD71DKM01Accident · No injuriesClosedCessna 172G · Banner Elk, NCJul 8, 1970 · N4249L · Destroyed NTSB IAD71DKM04Accident · No injuriesClosedCessna 150G · Yadkinville, NCJul 4, 1970 · N2678J · Substantial damage NTSB IAD70DKM16Accident · No injuriesClosedCessna 150K · Morgantown, NCJun 26, 1970 · N8328M · Substantial damage NTSB IAD70AI064Accident · 1 fatalClosedBeech G35 · Robbinsville, NCJun 25, 1970 · N4436D · Destroyed NTSB IAD70FKM15Accident · Minor injuriesClosedNavion A · Rutherfordton, NCJun 23, 1970 · N8880H · Substantial damage NTSB IAD70FKM14Accident · No injuriesClosedHughes 269B · Bryson City, NCJun 20, 1970 · N9457F · Substantial damage NTSB IAD70FKM13Accident · Minor injuriesClosedPiper PA-28 · Boone, NCJun 14, 1970 · N8638W · Substantial damage NTSB IAD70AI062Accident · 1 fatalClosedPiper PA-28 · Rose Hill, NCJun 14, 1970 · N3936K · Substantial damage NTSB IAD71FLJ07Accident · No injuriesClosedCessna 150G · White Lake, NCJun 13, 1970 · N4625X · Destroyed NTSB IAD70DRM12Accident · No injuriesClosedCessna 150 · Greensboro, NCJun 2, 1970 · N8638S · Substantial damage NTSB IAD70FLJ06Accident · No injuriesClosedBellanca 17-30 · Raleigh, NCMay 30, 1970 · N6622V · Substantial damage NTSB IAD70DKM11Accident · No injuriesClosedAeronca L-16 · Asheville, NCMay 28, 1970 · N75371 · Substantial damage NTSB IAD70DLJ05Accident · Minor injuriesClosedPiper J3C-65 · Knotts Island, NCMay 27, 1970 · N42425 · Destroyed NTSB IAD70AI061Accident · 1 fatalClosedCessna 401 · Spruce Pine, NCMay 27, 1970 · N4077Q · Destroyed NTSB IAD70DIJ04Accident · No injuriesClosedBell 47G4 · Terra Ceia, NCMay 25, 1970 · N1160W · Destroyed