Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 IAD78FA026Accident · Minor injuriesClosedPiper PA-32 · Raeford, NCDec 28, 1977 · N121MB · Substantial damage NTSB IAD78DLJ08Accident · No injuriesClosedCessna 172 · Raeford, NCDec 26, 1977 · N75600 · Substantial damage NTSB IAD78FA025Accident · 2 fatalClosedCessna 206F · Sylva, NCDec 24, 1977 · N8290Q · Destroyed NTSB IAD78DLJ04Accident · No injuriesClosedAeronca 7AC · Watha, NCDec 18, 1977 · N2406E · Substantial damage NTSB IAD78FA022Accident · 2 fatalClosedPiper PA-28 · Ocracoke, NCDec 14, 1977 · N7285W · Destroyed NTSB IAD78DKM03Accident · No injuriesClosedLuscombe 8F · Charlotte, NCDec 1, 1977 · N71307 · Substantial damage NTSB IAD78FA015Accident · 2 fatalClosedBeech 58 · Pinehurst, NCNov 29, 1977 · N4461S · Destroyed NTSB IAD78FLJ03Accident · No injuriesClosedSikorsky S58E · Washington, NCNov 28, 1977 · N8294 · Substantial damage NTSB IAD78FLJ02Accident · No injuriesClosedCessna 175 · Tabor City, NCNov 27, 1977 · N9327B · Substantial damage NTSB IAD78FA009Accident · 1 fatalClosedCessna 150L · Ash, NCOct 30, 1977 · N16175 · Destroyed NTSB IAD78FKM02Accident · No injuriesClosedCessna 150F · Andrews, NCOct 28, 1977 · N7776F · Substantial damage NTSB IAD78FA008Accident · 1 fatalClosedPiper PA-23 · Morganton, NCOct 27, 1977 · N5250Y · Destroyed NTSB IAD77DKM01Accident · No injuriesClosedCessna 401 · Hickory, NCOct 16, 1977 · N32060 · Substantial damage NTSB IAD78FLJ01Accident · No injuriesClosedCessna 188B · Roanoke Rapids, NCSep 30, 1977 · N4496Q · Substantial damage NTSB IAD77FLJ40Accident · No injuriesClosedCessna 150 · Elizabeth City, NCSep 25, 1977 · N1282Q · Substantial damage NTSB IAD77DKM33Accident · Minor injuriesClosedCessna 120 · Bryson City, NCSep 23, 1977 · N1373Z · Destroyed NTSB IAD77FLJ39Accident · No injuriesClosedCessna 150 · Beulahville, NCSep 22, 1977 · N10960 · Substantial damage NTSB IAD77FKM34Accident · No injuriesClosedBellanca 17-30 · Elkin, NCSep 21, 1977 · N8247R · Substantial damage NTSB IAD77FLJ38Accident · No injuriesClosedEnstrom F28A · Fayetteville, NCSep 13, 1977 · N297Q · Substantial damage NTSB IAD77FKM31Accident · Minor injuriesClosedAero Comdr 112TC · Charlotte, NCSep 8, 1977 · N4598W · Destroyed NTSB IAD77AA065Accident · 5 fatalClosedLearjet 25B · Sanford, NCSep 8, 1977 · N999HG · Destroyed NTSB IAD77FKM30Accident · Serious injuriesClosedCessna 150B · Taylorsville, NCSep 2, 1977 · N1240Y · Substantial damage NTSB IAD77DKM32Accident · No injuriesClosedCallair A-9 · Charlotte, NCAug 26, 1977 · N7728V · Substantial damage NTSB IAD77FLJ36Accident · No injuriesClosedCessna 150 · Raleigh, NCAug 25, 1977 · N704ZU · Substantial damage NTSB IAD77IA061Incident · No injuriesClosedBoeing 737 · Winston Salem, NCAug 23, 1977 · N758 · Minor damage NTSB IAD77FLJ34Accident · Minor injuriesClosedPiper PA-28 · Beaufort, NCAug 22, 1977 · N33867 · 2 aircraft · Substantial damage NTSB IAD77FLJ33Accident · Minor injuriesClosedCessna A188A · Edenton, NCAug 22, 1977 · N9960G · Destroyed NTSB IAD77DLJ32Accident · No injuriesClosedPiper PA-18 · Edenton, NCAug 21, 1977 · N8285C · Substantial damage NTSB IAD77FLJ35Accident · No injuriesClosedMooney M20E · Knightdale, NCAug 19, 1977 · N1328W · Destroyed NTSB IAD77FLJ28Accident · Serious injuriesClosedLuscombe 8F · Louisburg, NCAug 14, 1977 · N2725K · Substantial damage NTSB IAD77FLJ30Accident · No injuriesClosedRockwell S2R · Elizabeth City, NCAug 9, 1977 · N4980X · Substantial damage NTSB IAD77FLJ29Accident · No injuriesClosedCessna 188C · Clayton, NCAug 5, 1977 · N4449Q · Substantial damage NTSB IAD77DLJ27Accident · No injuriesClosedCessna 188B · Elizabeth City, NCAug 2, 1977 · N9212R · Substantial damage NTSB IAD77DKM28Accident · Minor injuriesClosedCessna 172N · Charlotte, NCJul 30, 1977 · N734LR · Substantial damage NTSB IAD77FA054Accident · 3 fatalClosedBeech 95 · Fletcher, NCJul 29, 1977 · N771B · Destroyed NTSB IAD77FLJ26Accident · No injuriesClosedCessna 188 · Columbia, NCJul 27, 1977 · N9095G · Destroyed NTSB IAD77DKM26Accident · No injuriesClosedGrum Amer AA5 · Rutherfordton, NCJul 4, 1977 · N920JL · Substantial damage NTSB IAD77FA050Accident · 1 fatalClosedCessna 182 · Bryson City, NCJul 3, 1977 · N5478B · Destroyed NTSB IAD77FLJ23Accident · No injuriesClosedPiper PA-25 · Mt Olive, NCJul 2, 1977 · N6764Z · Destroyed NTSB IAD77DKM27Accident · Minor injuriesClosedBeech 58P · Winston Salem, NCJun 28, 1977 · N78SC · Destroyed NTSB IAD77FLJ24Accident · Serious injuriesClosedPiper PA-24 · Parkton, NCJun 26, 1977 · N5790P · Destroyed NTSB IAD77FA048Accident · 3 fatalClosedNa Rockwell 114 · Littleton, NCJun 24, 1977 · N4721W · Destroyed NTSB IAD77DLJ31Accident · No injuriesClosedCessna A188B · Merritt, NCJun 24, 1977 · N4756R · Substantial damage NTSB IAD77FKM29Accident · No injuriesClosedPiper PA-40 · Asheville, NCJun 22, 1977 · N9997P · Substantial damage NTSB IAD77FA046Accident · 1 fatalClosedCessna 150E · Raleigh, NCJun 19, 1977 · N629M · Destroyed NTSB IAD77FLJ20Accident · Minor injuriesClosedPiper PA-28R · Chapel Hill, NCJun 13, 1977 · N3177R · Substantial damage NTSB IAD77FA045Accident · Serious injuriesClosedPiper PA-32 · Raleigh, NCJun 13, 1977 · N33373 · Destroyed NTSB IAD77DKM25Accident · No injuriesClosedCessna 182 · Shelby, NCJun 12, 1977 · N52922 · Substantial damage NTSB IAD77FLJ19Accident · Minor injuriesClosedPiper PA-28R · Selma, NCJun 11, 1977 · N6711J · Substantial damage NTSB IAD77DKM23Accident · No injuriesClosedPiper PA-28 · Greensboro, NCJun 10, 1977 · N4846L · Substantial damage