Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 NYC73DLJ16Accident · No injuriesClosedPiper PA-28 · Cape Lookout, NCDec 31, 1972 · N9410W · Substantial damage NTSB NYC73IN092Incident · No injuriesClosedBoeing 737 · Fayetteville, NCDec 30, 1972 · N749N · Minor damage NTSB NYC73FLJ15Accident · Minor injuriesClosedCessna 172 · Morrisville, NCDec 24, 1972 · N3956Q · Substantial damage NTSB NYC73FKM20Accident · 1 fatalClosedCessna 205A · Taylorsville, NCDec 24, 1972 · N8448Z · Destroyed NTSB NYC73DKM19Accident · No injuriesClosedSikorsky S-61L · Black Mtn, NCDec 14, 1972 · N402S · Substantial damage NTSB NYC73FLJ14Accident · 1 fatalClosedPiper PA-22 · Whitakers, NCDec 9, 1972 · N6930B · Substantial damage NTSB NYC73AN077Accident · 1 fatalClosedCessna 210 · Greensboro, NCDec 1, 1972 · N20EA · Minor damage NTSB NYC73IN073Incident · Minor injuriesClosedBeech A65-88 · Rocky Mount, NCNov 25, 1972 · N887J · Minor damage NTSB NYC73DKM18Accident · No injuriesClosedCessna 206 · Lenoir, NCNov 22, 1972 · N5012U · Substantial damage NTSB NYC73AN066Accident · 4 fatalClosedBeech G33 · Colfax, NCNov 7, 1972 · N9496Q · Destroyed NTSB NYC73AN065Accident · Serious injuriesClosedFairchild FH227B · Winston-Salem, NCNov 1, 1972 · N701U · No damage NTSB NYC73FLJ13Accident · No injuriesClosedCessna 170B · Winterville, NCOct 18, 1972 · CF-FYL · Substantial damage NTSB NYC73FCJ12Incident · No injuriesClosedCessna 182P · Morrisville, NCOct 14, 1972 · N21067 · Minor damage NTSB NYC73FFJ11Accident · No injuriesClosedPiper PA-28 · Roanoke Rapids, NCOct 8, 1972 · N1450T · Substantial damage NTSB NYC73FKM16Accident · No injuriesClosedCessna 150L · Indian Trail, NCOct 7, 1972 · N16005 · Substantial damage NTSB NYCA3FKM14Accident · No injuriesClosedBell 47D1 · Charlotte, NCOct 6, 1972 · N13012 · Substantial damage NTSB NYC73DKM15Accident · No injuriesClosedCessna 182J · Brevard, NCSep 29, 1972 · N3413F · Substantial damage NTSB NYC73DKM13Accident · No injuriesClosedCessna 172 · Maiden, NCSep 27, 1972 · N7163Q · Substantial damage NTSB MIA73FLG22Accident · No injuriesClosedHelio H-391B · Hilton Head, NCSep 27, 1972 · N4141D · Substantial damage NTSB NYC73FLJ10Accident · No injuriesClosedPiper PA-22 · Maple Hill, NCSep 24, 1972 · N3380B · Substantial damage NTSB NYC73DKM12Accident · No injuriesClosedPiper PA-22 · Reidsville, NCSep 22, 1972 · N5361Z · Substantial damage NTSB NYC73FKM17Accident · Minor injuriesClosedPiper J3C-65 · Indian Trail, NCSep 20, 1972 · N22841 · Destroyed NTSB NYC73DKM10Accident · Minor injuriesClosedPiper PA-28 · Murphy, NCSep 16, 1972 · N7225F · Destroyed NTSB NYC73DKM09Accident · No injuriesClosedCessna 310J · Lincolnton, NCSep 10, 1972 · N3162L · Substantial damage NTSB NYC73DKM08Accident · Minor injuriesClosedCessna 150 · Columbus, NCSep 9, 1972 · N60419 · Destroyed NTSB NYC73AN044Accident · No injuriesClosedCessna 210L · Davis, NCSep 8, 1972 · N5145Q · Substantial damage NTSB NYC73AN041Accident · 2 fatalClosedBeech V35A · Pollocksville, NCSep 1, 1972 · N789KB · Destroyed NTSB NYC73FLJ09Accident · Serious injuriesClosedAero Comdr A-9 · Whitakers, NCAug 29, 1972 · N8409V · Destroyed NTSB NYC73AN035Accident · 1 fatalClosedAmer Avco AA-1A · Madison, NCAug 26, 1972 · N9385L · Destroyed NTSB NYC73DLJ08Accident · Minor injuriesClosedPiper PA-28R · Hatteras, NCAug 25, 1972 · N3721T · Substantial damage NTSB NYC73DKM08Accident · No injuriesClosedCessna 170A · Concord, NCAug 24, 1972 · N9988A · Substantial damage NTSB NYC73DLJ07Accident · No injuriesClosedCessna 150J · Menola, NCAug 23, 1972 · N60110 · Substantial damage NTSB NYC73FLJ06Accident · Minor injuriesClosedPiper PA-28 · Morrisville, NCAug 19, 1972 · N5934U · Substantial damage NTSB NYC73DKM06Accident · No injuriesClosedPiper J-3 · Lincolnton, NCAug 19, 1972 · N5145B · Substantial damage NTSB NYC73DKM07Accident · No injuriesClosedPiper PA-22 · Boone, NCAug 13, 1972 · N33622 · Substantial damage NTSB NYC73DLJ04Accident · No injuriesClosedPiper PA-30 · Swansboro, NCAug 12, 1972 · N8486Y · Substantial damage NTSB NYC73AN025Accident · 1 fatalClosedChampion 7GCAA · Sherrills Ford, NCAug 12, 1972 · N6398N · Destroyed NTSB NYC73DKM04Accident · Minor injuriesClosedCessna 150L · Indian Trail, NCAug 4, 1972 · N6921G · Substantial damage NTSB NYC73DKM03Accident · No injuriesClosedCessna 150 · Hendersonville, NCJul 28, 1972 · N8328M · Substantial damage NTSB NYC73DKM02Accident · No injuriesClosedCessna 172K · Hickory, NCJul 28, 1972 · N78472 · Substantial damage NTSB NYC73DKM01Accident · No injuriesClosedPiper PA-28 · Lenoir, NCJul 25, 1972 · N9538J · Substantial damage NTSB NYC73FLJ03Accident · Serious injuriesClosedCessna 182 · Cary, NCJul 22, 1972 · N92266 · Substantial damage NTSB NYC73FLJ02Accident · Minor injuriesClosedCessna 170B · Scotland Neck, NCJul 10, 1972 · N8209A · Substantial damage NTSB MIA73DLG02Accident · No injuriesClosedBell 47D1 · Dalzell, NCJul 5, 1972 · N586T · Substantial damage NTSB NYC73AN004Accident · 1 fatalClosedCessna 172 · Cherokee, NCJul 4, 1972 · N7434G · Substantial damage NTSB NYC73FLJ01Accident · Serious injuriesClosedWoods Windy TOO · Holly Springs, NCJul 1, 1972 · N2550 · Substantial damage NTSB NYC72DKM38Accident · No injuriesClosedPiper PA-32 · Charlotte, NCJun 29, 1972 · N1071U · Substantial damage NTSB NYC72AN160Accident · 4 fatalClosedBeech A23-24 · Sapphire, NCJun 25, 1972 · N3627Q · Destroyed NTSB NYC72FLJ36Accident · No injuriesClosedCessna 172K · Freemont, NCJun 16, 1972 · N46632 · Substantial damage NTSB NYC72FLJ35Accident · No injuriesClosedBellanca 14-13 · Goldsboro, NCJun 14, 1972 · N74232 · Substantial damage