Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 IAD80DLJ06Accident · No injuriesClosedBaby GRT LK 1 · Durham, NCDec 29, 1979 · N1BL · Substantial damage NTSB IAD80FKM05Accident · Minor injuriesClosedStinson 108-3 · Hendersonville, NCDec 7, 1979 · N930C · Substantial damage NTSB IAD80DKM04Accident · No injuriesClosedPiper PA-18 · Asheboro, NCNov 30, 1979 · N75PC · Substantial damage NTSB LAX80FVW06Accident · No injuriesClosedPiper PA-24 · Henderson, NCNov 22, 1979 · N8462P · Substantial damage NTSB IAD80FLJ05Accident · 1 fatalClosedPiper PA-38 · Aventon, NCNov 21, 1979 · N9310T · Destroyed NTSB IAD80FLJ04Accident · No injuriesClosedCessna 150G · Knightdale, NCNov 17, 1979 · N2268J · Substantial damage NTSB IAD80FLJ03Accident · Serious injuriesClosedPiper PA-28 · Kenly, NCNov 16, 1979 · N5565W · Destroyed NTSB IAD80DKM03Accident · No injuriesClosedPiper PA-28 · Boone, NCNov 4, 1979 · N3927X · Substantial damage NTSB IAD80AA008Accident · 3 fatalClosedCessna P337H · Benson, NCNov 2, 1979 · N5KN · Destroyed NTSB IAD80DKM02Accident · No injuriesClosedPiper PA-28 · Rockingham, NCOct 20, 1979 · N40925 · Substantial damage NTSB IAD80FKM01Accident · Serious injuriesClosedPiper PA-22 · Charlotte, NCOct 7, 1979 · N5854Z · Substantial damage NTSB IAD80FA001Accident · 1 fatalClosedPiper PA-23 · Mooresville, NCOct 2, 1979 · N12JW · Destroyed NTSB IAD80FLJ01Accident · No injuriesClosedCessna 310I · Knightdale, NCOct 1, 1979 · N2000T · Substantial damage NTSB IAD79FA092Accident · 1 fatalClosedPiper PA-23 · Greensboro, NCSep 29, 1979 · N6378Y · Destroyed NTSB IAD79FA082Accident · 1 fatalClosedPiper PA-23 · Linville, NCSep 16, 1979 · N9046J · Destroyed NTSB IAD79FA080Accident · 1 fatalClosedPiper PA-28 · Cashiers, NCSep 12, 1979 · N41413 · Destroyed NTSB IAD79FA073Accident · 4 fatalClosedCessna 172N · Pinnacle, NCSep 4, 1979 · N738FR · Destroyed NTSB IAD79DLJ15Accident · No injuriesClosedPiper PA-25 · Cove City, NCAug 22, 1979 · N9633P · Substantial damage NTSB IAD79FLJ13Accident · Serious injuriesClosedPiper PA-28R · Raliegh, NCAug 21, 1979 · N3080R · Destroyed NTSB IAD79FA068Accident · Serious injuriesClosedPiper PA-32 · Hickory, NCAug 21, 1979 · N44522 · Destroyed NTSB IAD79FLJ14Accident · No injuriesClosedCessna A188 · Merritt, NCAug 19, 1979 · N3532Q · Substantial damage NTSB IAD79DKM13Accident · No injuriesClosedPiper PA-32 · Boone, NCAug 8, 1979 · N3727W · Substantial damage NTSB IAD79DLJ12Accident · Minor injuriesClosedPiper PA-25 · Elizabeth City, NCAug 6, 1979 · N8911L · Destroyed NTSB IAD79DLJ11Accident · No injuriesClosedPiper PA-22 · Ocean Isle, NCJul 25, 1979 · N7045D · Substantial damage NTSB IAD80FA009Accident · 2 fatalClosedCessna T210 · Highlands, NCJul 8, 1979 · N6916R · Destroyed NTSB IAD79FKM18Accident · No injuriesClosedStinson 108 · Mooresville, NCJul 4, 1979 · N474C · Substantial damage NTSB IAD79FA061Accident · 5 fatalClosedCessna 172 · Kitty Hawk, NCJul 4, 1979 · N20739 · Destroyed NTSB IAD79DKM17Accident · No injuriesClosedCessna 182M · Boone, NCJul 1, 1979 · N91526 · Substantial damage NTSB IAD79DKM16Accident · Minor injuriesClosedCessna 150 · Shelby, NCJun 12, 1979 · N66031 · Substantial damage NTSB IAD79DKM15Accident · No injuriesClosedRyan Navion · Newton, NCJun 8, 1979 · N8634H · Substantial damage NTSB IAD80FA041Accident · 2 fatalClosedCessna 182 · Waynesville, NCMay 31, 1979 · N618WC · Destroyed NTSB IAD79IA052Incident · No injuriesClosedCessna 402 · Shelbyville, NCMay 30, 1979 · N87280 · No damage NTSB IAD79FKM14Accident · No injuriesClosedCessna 150 · Charlotte, NCMay 20, 1979 · N5665E · Substantial damage NTSB IAD79FLJ10Accident · No injuriesClosedPiper PA-28 · Linden, NCMay 13, 1979 · N4399J · Substantial damage NTSB IAD79FKM13Accident · No injuriesClosedCessna 340 · Advance, NCApr 21, 1979 · N911M · Substantial damage NTSB IAD79DKM12Accident · Minor injuriesClosedCessna 172 · Spruce Pine, NCApr 17, 1979 · N8222L · Substantial damage NTSB IAD79DLJ09Accident · Minor injuriesClosedCessna 150 · Roseboro, NCApr 15, 1979 · N45096 · Destroyed NTSB IAD79IA044Incident · No injuriesClosedFairchild PC-6C · Raeford, NCApr 11, 1979 · N361F · Minor damage NTSB IAD79FA041Accident · 1 fatalClosedCessna 305A · Fair Bluff, NCMar 27, 1979 · N3FS · Destroyed NTSB IAD79FLJ08Accident · Minor injuriesClosedCessna 172M · Columbia, NCMar 22, 1979 · N64341 · Substantial damage NTSB IAD79FKM11Accident · No injuriesClosedCessna 172 · Lexington, NCMar 14, 1979 · N738TD · Substantial damage NTSB IAD79FLJ07Accident · No injuriesClosedGrumman AA-5 · Oxford, NCMar 10, 1979 · N1395R · Substantial damage NTSB IAD79DKM10Accident · No injuriesClosedCessna 172 · Polkville, NCMar 10, 1979 · N46309 · Substantial damage NTSB IAD79IA039Incident · No injuriesClosedLear 24B · Greensboro, NCMar 9, 1979 · N14BC · No damage NTSB IAD79DKM05Accident · Serious injuriesClosedSchleicher KA6CR · Marion, NCMar 9, 1979 · N8614E · Destroyed NTSB IAD79RLJ06Accident · Minor injuriesClosedCessna 172 · Roseboro, NCFeb 27, 1979 · N20476 · Substantial damage NTSB IAD79DLJ05Accident · No injuriesClosedCessna 172 · Fort Bragg, NCFeb 27, 1979 · N1461V · Substantial damage NTSB IAD79DKM09Accident · No injuriesClosedPiper PA-38 · Charlotte, NCFeb 20, 1979 · N6219A · Substantial damage NTSB IAD79DKM08Accident · Minor injuriesClosedCessna 177 · Lexington, NCJan 30, 1979 · N34988 · Substantial damage NTSB IAD79FKM07Accident · Serious injuriesClosedBeech S35 · Franklin, NCJan 26, 1979 · N5792K · Substantial damage