Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 DIA69D0117Accident · No injuriesClosedMonocoupe 90AF · Asheville, NCDec 28, 1968 · N266R · Substantial damage NTSB DIA69D0118Accident · No injuriesClosedBeech 95-B55 · Winston Salem, NCDec 23, 1968 · N244UL · Substantial damage NTSB DIA69A0028Accident · 1 fatalClosedBeech D55 · Morrisville, NCDec 17, 1968 · N7701R · Substantial damage NTSB DIA69F0108Accident · No injuriesClosedPiper PA-30 · Charlotte, NCDec 2, 1968 · N8391Y · Substantial damage NTSB DIA69F0115Accident · 1 fatalClosedPiper PA-22 · Franklin, NCDec 1, 1968 · N4449A · Destroyed NTSB DIA69F0107Accident · No injuriesClosedCessna 320D · Morganton, NCNov 20, 1968 · N1968G · Substantial damage NTSB DIA69D0116Accident · Serious injuriesClosedCessna 182 · Monroe, NCNov 20, 1968 · N2570G · No damage NTSB DIA69F0126Accident · No injuriesClosedCessna P206C · Morrisville, NCNov 16, 1968 · N8644Z · Substantial damage NTSB DIA69F0106Accident · No injuriesClosedCessna 177 · Louisburg, NCNov 6, 1968 · N2271Y · Substantial damage NTSB IAD69F0104Accident · Serious injuriesClosedPiper J4E · Sharpsburg, NCNov 3, 1968 · N38011 · Substantial damage NTSB DIA69D0102Accident · No injuriesClosedPiper PA-24 · Charlotte, NCNov 3, 1968 · N7865P · Substantial damage NTSB DIA69D0095Accident · Minor injuriesClosedAeronca 7AC · Pensacola, NCNov 2, 1968 · N1129E · Substantial damage NTSB DIA69D0103Accident · Minor injuriesClosedPiper PA-22 · Chadbourn, NCOct 29, 1968 · N8004E · Substantial damage NTSB DIA69D0111Accident · Minor injuriesClosedPiper J3C-65 · Reidsville, NCOct 27, 1968 · N35055 · Substantial damage NTSB DIA69D0092Accident · Minor injuriesClosedCessna 172 · Burnsville, NCOct 25, 1968 · N8262U · Substantial damage NTSB DIA69A0021Accident · 1 fatalClosedBeech H35 · Gastonia, NCOct 15, 1968 · N5466D · Destroyed NTSB DIA69F0081Accident · Minor injuriesClosedDavis D-1-W · Gastonia, NCOct 5, 1968 · N13576 · Substantial damage NTSB DIA69F0087Accident · No injuriesClosedCessna 170B · Elm City, NCOct 4, 1968 · N3184B · Substantial damage NTSB DIA69A0020Accident · 1 fatalClosedCessna 180 · Cherokee, NCOct 3, 1968 · N3123D · Destroyed NTSB DIA69D0073Accident · No injuriesClosedCessna 182 · Greensboro, NCOct 1, 1968 · N3882D · Substantial damage NTSB DIA69A0016Accident · Serious injuriesClosedDouglas DC-7C · Cherry Point, NCSep 27, 1968 · N7466 · Destroyed NTSB DIA69F0068Accident · No injuriesClosedCessna 310K · Star, NCSep 26, 1968 · N6918L · Substantial damage NTSB DIA69D0077Accident · Minor injuriesClosedCessna 172 · Raleigh, NCSep 26, 1968 · N3976L · Substantial damage NTSB DIA69F0074Accident · Serious injuriesClosedPiper J3C-65 · Troy, NCSep 25, 1968 · N6643H · Destroyed NTSB DIA69A0014Accident · 2 fatalClosedDehavilland DH104 · Charlotte, NCSep 25, 1968 · N357G · Destroyed NTSB DIA69F0063Accident · No injuriesClosedPiper PA-28 · Charlotte, NCSep 15, 1968 · N8805W · Substantial damage NTSB DIA69F0062Accident · No injuriesClosedCessna 182 · Weddington, NCSep 14, 1968 · N42525 · Substantial damage NTSB DIA69A0011Accident · 1 fatalClosedPiper PA-12 · Monroe, NCSep 4, 1968 · N92761 · Destroyed NTSB DIA69F0054Accident · No injuriesClosedAeronca 7BCM · Charlotte, NCAug 30, 1968 · N75367 · Substantial damage NTSB DIA69D0066Accident · No injuriesClosedMooney M20C · Holly Ridge, NCAug 30, 1968 · N2592W · Substantial damage NTSB DIA69D0067Accident · No injuriesClosedCessna 210 · Greensboro, NCAug 21, 1968 · N7370E · Substantial damage NTSB DIA69D0053Accident · No injuriesClosedPiper PA-32 · Windsor, NCAug 21, 1968 · N5555J · Substantial damage NTSB DIA69D0052Accident · Minor injuriesClosedErcoupe 415-C · Lenoir, NCAug 21, 1968 · N3249H · Destroyed NTSB DIA69F0056Accident · 1 fatalClosedPiper PA-18A · Parkton, NCAug 19, 1968 · N1459C · Destroyed NTSB DIA69D0051Accident · Minor injuriesClosedCessna 150 · Bryson City, NCAug 11, 1968 · N3067S · Substantial damage NTSB DIA69F0039Accident · Minor injuriesClosedPiper PA-24 · Asheboro, NCAug 9, 1968 · N5085P · Substantial damage NTSB DIA69F0040Accident · Serious injuriesClosedAeronca 7AC · Benson, NCJul 27, 1968 · N84893 · Substantial damage NTSB DIA69D0032Accident · Minor injuriesClosedCessna 150 · Advance, NCJul 27, 1968 · N6922F · Substantial damage NTSB DIA69F0030Accident · Serious injuriesClosedPiper PA-12 · White Lake, NCJul 21, 1968 · N4435M · Substantial damage NTSB MIA69F0042Accident · Serious injuriesClosedBell 47D1 · Ocean Dr Beach, NCJul 10, 1968 · N4253A · Substantial damage NTSB DIA69D0013Accident · No injuriesClosedBellanca 14-193 · Lexington, NCJul 7, 1968 · N8884R · Substantial damage NTSB DIA69D0012Accident · No injuriesClosedPiper PA-28 · Lake Lure, NCJul 7, 1968 · N6137W · Substantial damage NTSB DIA69D0042Accident · Serious injuriesClosedBensen Hatch · Raleigh, NCJun 30, 1968 · N1253 · Substantial damage NTSB DIA69F0038Accident · Serious injuriesClosedBeech A45 · Greensboro, NCJun 29, 1968 · N7982A · Destroyed NTSB DIA69D0009Accident · No injuriesClosedCessna 150 · Hickory, NCJun 29, 1968 · N8612G · Substantial damage NTSB DIA68A0053Accident · 1 fatalClosedPiper PA-28 · Greenville, NCJun 24, 1968 · N6957W · Destroyed NTSB DIA68A0052Accident · 1 fatalClosedPiper PA-23 · New Bern, NCJun 21, 1968 · N5355Y · Destroyed NTSB DIA69D0003Accident · Minor injuriesClosedBell 47G-4A · Cherokee, NCJun 20, 1968 · N7930S · Destroyed NTSB DIA69D0004Accident · No injuriesClosedChampion 7FC · Spindale, NCJun 19, 1968 · N9096B · Substantial damage NTSB DIA68F0230Accident · No injuriesClosedPiper PA-12 · Mooresville, NCJun 4, 1968 · N3887M · Substantial damage