Skip to content

NTSB investigations, 1969, VA

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

19632026

NTSB investigations, 1969, VA per year, 1963–2026: 2,565 cases
1963	1
1964	75
1965	76
1966	91
1967	75
1968	90
1969	87
1970	74
1971	53
1972	60
1973	56
1974	61
1975	53
1976	59
1977	60
1978	64
1979	65
1980	63
1981	42
1982	38
1983	52
1984	53
1985	44
1986	42
1987	35
1988	43
1989	36
1990	34
1991	33
1992	31
1993	32
1994	27
1995	30
1996	26
1997	26
1998	30
1999	31
2000	39
2001	42
2002	38
2003	31
2004	22
2005	15
2006	32
2007	36
2008	30
2009	34
2010	27
2011	30
2012	24
2013	17
2014	25
2015	21
2016	30
2017	27
2018	31
2019	24
2020	15
2021	18
2022	21
2023	25
2024	27
2025	24
2026	12

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" = 'VA' 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\" = 'VA' 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" = 'VA' 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 IAD70D0130Accident · No injuriesClosedCessna 195A · Lynchburg, VADec 27, 1969 · N4360N · Substantial damage NTSB IAD70D0131Accident · No injuriesClosedPiper PA-28 · S Boston, VADec 26, 1969 · N9712J · Substantial damage NTSB IAD70D0125Accident · No injuriesClosedCessna 195 · Mt Jackson, VADec 20, 1969 · N10PB · Substantial damage NTSB IAD70D0128Accident · No injuriesClosedBeech B35 · Norfolk, VANov 26, 1969 · N5168C · Substantial damage NTSB IAD70D0122Accident · No injuriesClosedLuscombe 8A · Norfolk, VANov 22, 1969 · N2114K · Substantial damage NTSB IAD70A0033Accident · 1 fatalClosedPiper PA-20 · Woodbridge, VANov 15, 1969 · N7015K · Destroyed NTSB IAD70A0032Accident · 4 fatalClosedPiper PA-28 · Eagle Rock, VANov 14, 1969 · N9475J · Destroyed NTSB IAD70F0106Accident · No injuriesClosedChampion 7GCBC · Warrenton, VANov 11, 1969 · N83684 · Substantial damage NTSB IAD69I0068Incident · No injuriesClosedNihon YS-11A · Quantico, VANov 10, 1969 · N214P · No damage NTSB IAD70I0031Incident · No injuriesClosedBoeing 737 · Dulles Arpt, VANov 7, 1969 · N741N · No damage NTSB IAD70A0029Accident · 1 fatalClosedPiper PA-28 · Round Hill, VANov 3, 1969 · N7679W · Destroyed NTSB IAD70F0103Accident · No injuriesClosedBensen B-8M · Petersburg, VANov 2, 1969 · N1707 · Substantial damage NTSB IAD70F0112Accident · Serious injuriesClosedCessna 172 · Surry, VANov 1, 1969 · N6325E · Destroyed NTSB IAD70A0028Accident · 3 fatalClosedAero Comdr 1121 · Rural Retreat, VAOct 31, 1969 · N236JP · Destroyed NTSB IAD70D0099Accident · No injuriesClosedCessna 150 · Pound, VAOct 16, 1969 · N22648 · Substantial damage NTSB IAD70A0025Accident · 1 fatalClosedPiper J-3 · Topping, VAOct 11, 1969 · N92437 · Substantial damage NTSB IAD70F0097Accident · No injuriesClosedPiper PA-28 · Fredericksburg, VAOct 9, 1969 · N1872J · Substantial damage NTSB IAD70D0095Accident · No injuriesClosedAlon A-2 · Franklin, VAOct 4, 1969 · N6594Q · Substantial damage NTSB IAD70D0088Accident · No injuriesClosedCessna 150 · Chase City, VAOct 2, 1969 · N8462J · Substantial damage NTSB IAD70F0089Accident · No injuriesClosedPiper PA-32 · Norfolk, VASep 28, 1969 · N5555J · Substantial damage NTSB IAD70A0020Accident · No injuriesClosedBell 206A · Falls Church, VASep 21, 1969 · N6296N · Substantial damage NTSB IAD70F0083Accident · Serious injuriesClosedStinson 108-1 · Prince George, VASep 13, 1969 · N8503K · Destroyed NTSB IAD70D0084Accident · No injuriesClosedSwearingen SA26T · Norfolk, VASep 9, 1969 · N1014T · Substantial damage NTSB IAD70D0079Accident · No injuriesClosedChampion 7GCBC · Reedville, VASep 8, 1969 · N562DH · Substantial damage NTSB IAD70F0078Accident · No injuriesClosedBeech 35 · Norfolk, VASep 5, 1969 · N2731V · Substantial damage NTSB IAD70F0082Accident · 1 fatalClosedPiper PA-18A · Browns Store, VASep 4, 1969 · N8158C · Destroyed NTSB IAD70F0072Accident · No injuriesClosedBrantly B-2 · Centerville, VAAug 29, 1969 · N2125U · Destroyed NTSB IAD70I0075Incident · No injuriesClosedCessna 182 · Lovingston, VAAug 26, 1969 · N2527R · Substantial damage NTSB IAD70F0060Accident · No injuriesClosedPiper PA-23 · Alexandria, VAAug 20, 1969 · N6389Y · Substantial damage NTSB DIA70D0053Accident · No injuriesClosedBellanca 14-13 · Newport News, VAAug 19, 1969 · N74287 · Substantial damage NTSB IAD70D0057Accident · No injuriesClosedPiper J3C-65 · Virginia Beach, VAAug 17, 1969 · N58462 · Destroyed NTSB IAD70I0015Incident · No injuriesClosedDouglas DC-9 · Chantilly, VAAug 15, 1969 · N977Z · Minor damage NTSB IAD70F0056Accident · Serious injuriesClosedPiper PA-22 · Hot Springs, VAAug 15, 1969 · N3832P · Destroyed NTSB DIA70D0051Accident · No injuriesClosedCessna 150 · Fredericksburg, VAAug 11, 1969 · N23491 · Substantial damage NTSB IAD70A0012Accident · 1 fatalClosedBeech N35 · Suffolk, VAAug 10, 1969 · N9463Y · Destroyed NTSB DIA70D0050Accident · No injuriesClosedCessna 180 · Stafford, VAAug 10, 1969 · N3143D · Substantial damage NTSB DIA70D0040Accident · Minor injuriesClosedPiper PA-28 · Capron, VAJul 28, 1969 · N6438W · Substantial damage NTSB DIA70F0047Accident · Minor injuriesClosedStinson 108 · Alexandria, VAJul 26, 1969 · N9594K · Destroyed NTSB DIA70F0036Accident · No injuriesClosedBeech A23-19 · Leesburg, VAJul 19, 1969 · N4777J · Substantial damage NTSB DIA70F0029Accident · No injuriesClosedPiper PA-28 · Fredericksburg, VAJul 12, 1969 · N424AS · Substantial damage NTSB DIA70D0030Accident · No injuriesClosedCessna 182 · Reedville, VAJul 12, 1969 · N3131U · Substantial damage NTSB DIA70A0002Accident · 1 fatalClosedN.American AT-6 · Midland, VAJul 12, 1969 · N869FU · Destroyed NTSB DIA70F0019Accident · No injuriesClosedBell 47G · Newsoms, VAJun 30, 1969 · N138B · Substantial damage NTSB DIA70D0014Accident · No injuriesClosedPiper PA-28 · Danville, VAJun 24, 1969 · N7202J · Substantial damage NTSB DIA70D0004Accident · No injuriesClosedCessna 150 · Front Royal, VAJun 16, 1969 · N4099J · Substantial damage NTSB DIA69D0210Accident · No injuriesClosedCessna 150 · Norfolk, VAJun 5, 1969 · N7995F · Substantial damage NTSB DIA70D0001Accident · No injuriesClosedLuscombe 8C · Seneca, VAMay 30, 1969 · N1169K · Substantial damage NTSB DIA69A0066Accident · No injuriesClosedBeech 95-A55 · Petersburg, VAMay 21, 1969 · N2448C · Substantial damage NTSB DIA69D0205Accident · No injuriesClosedCessna 150 · Midland, VAMay 17, 1969 · N8047S · Substantial damage NTSB DIA69D0189Accident · No injuriesClosedCessna 140 · Baileys Xroads, VAMay 14, 1969 · N89711 · Substantial damage