Skip to content

NTSB investigations, 1969, 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 IAD70D0121Accident · No injuriesClosedCessna 172 · Monroe, NCDec 29, 1969 · N5775A · Substantial damage NTSB IAD70F0119Accident · No injuriesClosedMooney M20C · Charlotte, NCDec 28, 1969 · CF-PZN · Substantial damage NTSB IAD70D0123Accident · Serious injuriesClosedCessna 150 · Sanford, NCDec 28, 1969 · N7817Z · Substantial damage NTSB IAD70D0117Accident · No injuriesClosedPiper PA-32 · Morganton, NCDec 26, 1969 · N4238R · Substantial damage NTSB IAD70D0114Accident · No injuriesClosedPiper PA-32 · Mint Hill, NCDec 14, 1969 · N3502W · Substantial damage NTSB IAD70A0034Accident · 1 fatalClosedPiper J3C · Apex, NCNov 29, 1969 · N42348 · Destroyed NTSB IAD70D0109Accident · No injuriesClosedMooney M20F · Hendersonville, NCNov 27, 1969 · N9396M · Substantial damage NTSB IAD70D0107Accident · No injuriesClosedPiper PA-22 · Vale, NCNov 23, 1969 · N3212B · Substantial damage NTSB IAD70D0113Accident · No injuriesClosedCessna 195 · Banner Elk, NCNov 6, 1969 · N117DH · Substantial damage NTSB IAD70F0100Accident · No injuriesClosedLuscombe 8A · Durham, NCOct 25, 1969 · N71307 · Substantial damage NTSB IAD70A0027Accident · 2 fatalClosedCessna 182L · Dana, NCOct 15, 1969 · N3379R · Destroyed NTSB IAD70F0081Accident · No injuriesClosedMooney M20C · Fletcher, NCOct 11, 1969 · N6010Q · Substantial damage NTSB IAD70D0134Accident · No injuriesClosedCessna 150 · Swannanoa, NCOct 11, 1969 · N6690S · Substantial damage NTSB IAD70D0071Accident · No injuriesClosedPiper PA-22 · Indian Trail, NCSep 21, 1969 · N8445D · Substantial damage NTSB IAD70D0085Accident · Serious injuriesClosedLuscombe 8C · Wilmington, NCSep 18, 1969 · N71419 · Destroyed NTSB IAD70D0104Accident · No injuriesClosedCessna 172 · Benson, NCSep 17, 1969 · N2070Y · Substantial damage NTSB IAD70F0065Accident · No injuriesClosedPiper PA-28R · Statesville, NCSep 16, 1969 · N9302N · Substantial damage NTSB IAD70A0019Accident · 1 fatalClosedPiper PA-23 · Wake Forest, NCSep 16, 1969 · N6265Y · Destroyed NTSB IAD70A0018Accident · 1 fatalClosedCessna 172 · Hendersonville, NCSep 8, 1969 · N6444E · Substantial damage NTSB IAD70D0063Accident · No injuriesClosedCessna 150G · Advance, NCSep 7, 1969 · N2678J · Substantial damage NTSB IAD70F0073Accident · No injuriesClosedGrumman G-164A · Creswell, NCSep 2, 1969 · N927X · Substantial damage NTSB IAD70F0066Accident · No injuriesClosedPiper PA-23 · Greensboro, NCAug 30, 1969 · N5885Y · Substantial damage NTSB IAD70D0055Accident · No injuriesClosedPiper PA-22 · Advance, NCAug 30, 1969 · N891A · Substantial damage NTSB IAD70D0054Accident · Serious injuriesClosedPiper PA-28 · Robbinsville, NCAug 26, 1969 · N8099N · Substantial damage NTSB IAD70A0017Accident · 1 fatalClosedCessna 150G · Gastonia, NCAug 26, 1969 · N3187J · 2 aircraft · Minor damage NTSB IAD70F0062Accident · No injuriesClosedPiper J3C-65 · Sanford, NCAug 25, 1969 · N71063 · Substantial damage NTSB DIA70D0052Accident · No injuriesClosedSchweizer SGS232 · Banner Elk, NCAug 24, 1969 · N7746S · Substantial damage NTSB IAD70A0016Accident · 4 fatalClosedPiper PA-28 · Salisbury, NCAug 21, 1969 · N7910W · Destroyed NTSB IAD70D0059Accident · No injuriesClosedPiper PA-18A · Johns, NCAug 19, 1969 · N8154C · Substantial damage NTSB IAD70F0058Accident · No injuriesClosedPiper PA-28 · Charlotte, NCAug 18, 1969 · N5258W · Substantial damage NTSB IAD70F0042Accident · No injuriesClosedPiper PA-25 · Maxton, NCAug 12, 1969 · N8656L · Substantial damage NTSB IAD70A0013Accident · 1 fatalClosedBell 47D1 · Cherokee, NCAug 12, 1969 · N2794A · Destroyed NTSB DIA70F0048Accident · No injuriesClosedPiper J3C-65 · Mt Airy, NCAug 12, 1969 · N38449 · Substantial damage NTSB DIA70D0037Accident · No injuriesClosedPiper PA-28 · Franklin, NCAug 2, 1969 · N7532J · Substantial damage NTSB IAD70A0011Accident · 1 fatalClosedCessna 120 · Spruce Pine, NCAug 1, 1969 · N90109 · Destroyed NTSB DIA70D0032Accident · No injuriesClosedPiper PA-20 · Advance, NCJul 28, 1969 · N4944M · Substantial damage NTSB DIA70F0025Accident · No injuriesClosedCallair A-9 · Parkton, NCJul 12, 1969 · N7227V · Substantial damage NTSB DIA70F0034Accident · 1 fatalClosedPiper J3C-65 · Clayton, NCJul 10, 1969 · N70684 · Destroyed NTSB DIA70F0031Accident · Serious injuriesClosedPiper PA-22 · Grantham, NCJul 5, 1969 · N3862P · Destroyed NTSB DIA70F0021Accident · No injuriesClosedHughes 269A · Wadesboro, NCJul 2, 1969 · N8853F · Substantial damage NTSB DIA70D0041Accident · No injuriesClosedPitts Spec S1C · Hendersonville, NCJul 2, 1969 · N2215 · Substantial damage NTSB DIA70F0020Accident · Serious injuriesClosedCessna 172 · Greenmountain, NCJun 28, 1969 · N8038X · Substantial damage NTSB DIA70F0010Accident · No injuriesClosedCessna 170 · Harrells, NCJun 24, 1969 · N4198V · Substantial damage NTSB DIA69F0009Accident · Serious injuriesClosedStearman B75N1 · Jacksonville, NCJun 19, 1969 · N73583 · Substantial damage NTSB DIA70D0011Accident · No injuriesClosedCessna 150 · Salemburg, NCJun 17, 1969 · N3584L · Substantial damage NTSB DIA70D0008Accident · No injuriesClosedLittle Toot WP-1 · Washington, NCJun 17, 1969 · N11994 · Substantial damage NTSB DIA69A0069Accident · No injuriesClosedCessna 195B · Mayodan, NCJun 17, 1969 · N3012B · Substantial damage NTSB DIA70D0007Accident · No injuriesClosedHughes 269A · Raeford, NCJun 16, 1969 · N8913F · Substantial damage NTSB DIA70F0033Accident · No injuriesClosedPiper PA-18A · Parkton, NCJun 14, 1969 · N4575A · Destroyed NTSB DIA70D0003Accident · Minor injuriesClosedSchweizer 2-33A · Elk Park, NCJun 14, 1969 · N7783S · Substantial damage