Skip to content

NTSB investigations, 1978, NC

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 IAD79FA026Accident · 2 fatalClosedCessna 177B · Charlotte, NCDec 31, 1978 · N19580 · Destroyed NTSB IAD79FA024Accident · 2 fatalClosedBeech B-19 · Greensboro, NCDec 19, 1978 · N18790 · Destroyed NTSB IAD79DKM03Accident · Minor injuriesClosedCessna 172 · Linville, NCDec 14, 1978 · N4463L · Substantial damage NTSB IAD79FLJ03Accident · Serious injuriesClosedCessna 150 · Hubert, NCDec 11, 1978 · N2940S · Destroyed NTSB IAD79FA022Accident · 1 fatalClosedBellanca 8KCAB · Wade, NCDec 11, 1978 · N5026C · Destroyed NTSB IAD79FLJ02Accident · Serious injuriesClosedPiper PA-28R · Gates, NCDec 3, 1978 · N7611J · Substantial damage NTSB IAD79FA015Accident · 1 fatalClosedCessna 172 · Mt Airy, NCNov 21, 1978 · N3292L · 2 aircraft · Destroyed NTSB IAD79IA012Incident · No injuriesClosedBoeing 727 · Winston-Salem, NCNov 17, 1978 · N833N · Minor damage NTSB IAD79FKM04Accident · Minor injuriesClosedPiper PA-28 · Salisbury, NCOct 29, 1978 · N9056W · Substantial damage NTSB IAD79FLJ01Accident · Minor injuriesClosedCessna 210H · Rocky Mt, NCOct 15, 1978 · N5957F · 2 aircraft · Substantial damage NTSB IAD79DKM02Accident · No injuriesClosedPiper PA-28 · Liberty, NCOct 9, 1978 · N3931X · Substantial damage NTSB IAD79DKM01Accident · No injuriesClosedPiper PA-31 · Concord, NCOct 9, 1978 · N61369 · Substantial damage NTSB IAD78DKM27Accident · Minor injuriesClosedPiper PA-28 · Mt Mitchell, NCSep 30, 1978 · N57359 · Substantial damage NTSB IAD78DKM26Accident · No injuriesClosedStarduster SA-100 · Franklinville, NCSep 27, 1978 · N33BG · Destroyed NTSB IAD79FA109Accident · Serious injuriesClosedTed Smith 600 · Morrisville, NCSep 18, 1978 · N7547S · Substantial damage NTSB IAD78FKM25Accident · 1 fatalClosedBensen B8 · Salisbury, NCSep 15, 1978 · NONE · Destroyed NTSB IAD78DKM24Accident · No injuriesClosedGrum Amer AA-5A · Greensboro, NCSep 10, 1978 · N9905U · Substantial damage NTSB IAD78DKM23Accident · No injuriesClosedHughes 269B · Franklin, NCSep 8, 1978 · N15TR · Substantial damage NTSB IAD78DLJ25Accident · No injuriesClosedCessna 188B · Zebvlon, NCSep 5, 1978 · N22WM · Substantial damage NTSB IAD78FA104Accident · 2 fatalClosedHughes 269C · Robbinsville, NCSep 1, 1978 · N9295F · Destroyed NTSB IAD78FA103Accident · 1 fatalClosedBell 47G3 · Grissettown, NCSep 1, 1978 · N6092 · Destroyed NTSB IAD78FA101Accident · Serious injuriesClosedPiper PA-31 · Charlotte, NCAug 31, 1978 · N9173Y · Destroyed NTSB IAD78FA100Accident · No injuriesClosedCessna 172C · Creedmoor, NCAug 30, 1978 · N8471X · Substantial damage NTSB IAD78DLJ22Accident · Minor injuriesClosedCallair A-9 · Stella, NCAug 28, 1978 · N8266H · Substantial damage NTSB IAD78DKM21Accident · Minor injuriesClosedPiper PA-18 · Polkville, NCAug 27, 1978 · N309T · Substantial damage NTSB IAD78FLJ23Accident · Serious injuriesClosedAeronca 7AC · Fayetteville, NCAug 26, 1978 · N82466 · Substantial damage NTSB IAD78FA099Accident · 2 fatalClosedPiper PA-28R · Bolton, NCAug 26, 1978 · N41786 · Destroyed NTSB IAD78FLJ21Accident · Serious injuriesClosedBeech K35 · Morrisville, NCAug 23, 1978 · N600Q · Substantial damage NTSB IAD78DKM22Accident · No injuriesClosedCessna 172 · Eden, NCAug 21, 1978 · N3512Q · Substantial damage NTSB IAD78FA095Accident · No injuriesClosedBeech D-55 · Hickory, NCAug 16, 1978 · N526Q · Substantial damage NTSB IAD78DKM20Accident · Minor injuriesClosedCessna 310F · Liberty, NCAug 16, 1978 · N372WP · Substantial damage NTSB IAD78FA089Accident · 3 fatalClosedMooney M20J · Bakersville, NCAug 8, 1978 · N201FH · Destroyed NTSB IAD78DLJ19Accident · Minor injuriesClosedRyan Navion · Wilmington, NCAug 4, 1978 · N4527K · Substantial damage NTSB IAD78FLJ20Accident · No injuriesClosedCessna 172 · White Lake, NCJul 30, 1978 · N6055A · Substantial damage NTSB IAD78DKM19Accident · Minor injuriesClosedCessna 177RG · Taylorsville, NCJul 28, 1978 · N2092Q · Substantial damage NTSB IAD78DKM17Accident · No injuriesClosedGrumman G-164B · Ellerbe, NCJul 26, 1978 · N6609Q · Substantial damage NTSB IAD78DKM16Accident · No injuriesClosedCessna 170 · Statesville, NCJul 25, 1978 · N2578C · Substantial damage NTSB IAD78DKM15Accident · No injuriesClosedCessna 150 · Lucia, NCJul 24, 1978 · N6288K · Substantial damage NTSB IAD78FLJ17Accident · No injuriesClosedCessna 150 · Washington, NCJul 21, 1978 · N6922F · Substantial damage NTSB IAD78FA083Accident · 1 fatalClosedLuscombe 8A · Fairfield, NCJul 14, 1978 · N71956 · Substantial damage NTSB IAD78FA078Accident · 1 fatalClosedPiper PA-32 · Deep Gap, NCJul 6, 1978 · N43087 · Destroyed NTSB IAD78FA076Accident · 2 fatalClosedAeronca 7AC · Vanceboro, NCJul 4, 1978 · N81452 · Destroyed NTSB IAD78FLJ18Accident · Minor injuriesClosedPiper PA-25 · Vanceboro, NCJul 1, 1978 · N4791Y · Substantial damage NTSB IAD78FLJ16Accident · No injuriesClosedCessna 172 · Aulander, NCJun 29, 1978 · N46494 · Substantial damage NTSB IAD78FA074Accident · No injuriesClosedCessna 310Q · Durham, NCJun 29, 1978 · N7537Q · Substantial damage NTSB IAD78DKM14Accident · No injuriesClosedPiper PA-28 · Greensboro, NCJun 26, 1978 · N1404T · Substantial damage NTSB IAD78FLJ15Accident · Serious injuriesClosedGrum Amer AA5A · Belhaven, NCJun 20, 1978 · N9637U · Substantial damage NTSB IAD78FA072Accident · 1 fatalClosedHughes 269C · Charlotte, NCJun 15, 1978 · N8658F · Destroyed NTSB IAD78FLJ14Accident · Serious injuriesClosedTaylorcraft BC12D · Liberty, NCJun 11, 1978 · N96897 · Substantial damage NTSB IAD78DKM13Accident · No injuriesClosedPiper PA-28 · Morganton, NCJun 11, 1978 · N8451F · Substantial damage