Skip to content

NTSB investigations, 1974, VA

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1974, 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") = 1974 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\") = 1974
    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") = 1974
  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 NYC75AN077Accident · Serious injuriesClosedBoeing 707 · Richmond, VADec 28, 1974 · N8432 · No damage NTSB IAD75DIJ09Accident · No injuriesClosedCessna 177B · Volney, VADec 17, 1974 · N34477 · Destroyed NTSB IAD75DID12Accident · No injuriesClosedCessna 182 · Weyers Cave, VADec 10, 1974 · N1957X · Substantial damage NTSB IAD75AI035Accident · Serious injuriesClosedBoeing 727 · Gordonsville, VADec 1, 1974 · N8123N · No damage NTSB DCA75AZ005Accident · 92 fatalClosedBoeing 727 · Berryville, VADec 1, 1974 · N54328 · Destroyed NTSB IAD75FID11Accident · No injuriesClosedCessna 172 · Highland Spgs, VANov 14, 1974 · N2369U · Destroyed NTSB IAD75FID10Accident · No injuriesClosedCessna 305A · Hopewell, VAOct 26, 1974 · N5299G · Substantial damage NTSB IAD75F2A08Accident · No injuriesClosedCessna 150 · Fulks Run, VAOct 25, 1974 · N10102 · Substantial damage NTSB IAD75FID07Accident · No injuriesClosedBeech S35 · Staunton, VAOct 19, 1974 · N724TG · Substantial damage NTSB IAD75DID08Accident · Serious injuriesClosedLake LA4200 · Weems, VAOct 13, 1974 · N5045L · Substantial damage NTSB IAD75AI022Accident · 3 fatalClosedPiper PA-24 · Saxis, VAOct 11, 1974 · N6876P · 2 aircraft · Destroyed NTSB IAD75FIG06Accident · Serious injuriesClosedCessna 150L · Sterling, VAOct 9, 1974 · N10093 · Substantial damage NTSB IAD75FID06Accident · Minor injuriesClosedChampion 7FC · Martinsville, VASep 28, 1974 · N7591B · Substantial damage NTSB IAD75DID05Accident · No injuriesClosedBell 47G-2A · Horntown, VASep 13, 1974 · N74098 · Substantial damage NTSB IAD75AI011Accident · No injuriesClosedBeech C23 · Norfolk, VASep 8, 1974 · N2120W · No damage NTSB IAD75FIA02Accident · Serious injuriesClosedPiper PA-22 · Bayse, VASep 2, 1974 · N3541A · Substantial damage NTSB NYC07LA005Accident · 3 fatalLimited investigationClosedCessna 172M · Saltville, VAThe pilot's continued VFR flight into known night instrument meteorological conditions. Factors in the accident included mountainous terrain obscured by clouds, and dark night conditions.Aug 31, 1974 · N5142R · Destroyed NTSB IAD75FID04Accident · No injuriesClosedPiper PA-28 · Chesterfield, VAAug 29, 1974 · N8283N · Substantial damage NTSB IAD75II006Incident · No injuriesClosedBeech V35 · Culpeper, VAAug 13, 1974 · N9007V · Minor damage NTSB IAD75FIA05Accident · Minor injuriesClosedPiper PA-28 · Woodbridge, VAAug 12, 1974 · N15854 · Substantial damage NTSB IAD75FID02Accident · No injuriesClosedPiper PA-18 · Skippers, VAJul 22, 1974 · N2754P · Substantial damage NTSB IAD75FID01Accident · No injuriesClosedCallair A-9B · Temperancevl, VAJul 18, 1974 · N7791V · Substantial damage NTSB IAD75FIA03Accident · No injuriesClosedSchweizer SGS233 · Bridgewater, VAJul 4, 1974 · N17941 · Substantial damage NTSB IAD74FID42Accident · No injuriesClosedCessna 150L · Ashland, VAJun 30, 1974 · N10574 · Substantial damage NTSB IAD74AI070Accident · 2 fatalClosedCessna 402B · Petersburg, VAJun 22, 1974 · N69379 · Destroyed NTSB IAD74FID41Accident · Serious injuriesClosedBeech C35 · Norfolk, VAJun 21, 1974 · N5803C · Substantial damage NTSB IAD74FIA19Accident · Serious injuriesClosedGlasfugel H301B · Midland, VAJun 12, 1974 · N66SC · Substantial damage NTSB IAD74AI064Accident · 1 fatalClosedBellanca 8KCAB · Scottsville, VAMay 24, 1974 · N68559 · Destroyed NTSB IAD74AI063Accident · 2 fatalClosedBell 47J · Richmond, VAMay 24, 1974 · N5199B · Destroyed NTSB IAD74FID40Accident · No injuriesClosedCessna 182 · Danville, VAMay 22, 1974 · N4782D · Substantial damage NTSB IAD74FIA17Accident · No injuriesClosedBoeing E75 · Manassas, VAMay 14, 1974 · N52143 · Substantial damage NTSB IAD74FIA14Accident · No injuriesClosedBell 47D1 · Stephens City, VAMay 8, 1974 · N919B · Substantial damage NTSB IAD74FID39Accident · No injuriesClosedCessna 182K · Chesterfield, VAMay 6, 1974 · N2850R · Substantial damage NTSB IAD74FIA15Accident · Minor injuriesClosedCessna 177B · Winchester, VAMay 6, 1974 · N34636 · Substantial damage NTSB IAD74FID38Accident · No injuriesClosedPiper PA-22 · Forest, VAMay 5, 1974 · N8587D · Substantial damage NTSB IAD74AI058Accident · 2 fatalClosedCessna 170A · Newport News, VAMay 3, 1974 · N9503A · Destroyed NTSB IAD74FID37Accident · No injuriesClosedBellanca 7ECA · Gloucester, VAMay 2, 1974 · N8644 · Substantial damage NTSB IAD74FID36Accident · Minor injuriesClosedBell 47G-2 · Norfolk, VAMay 1, 1974 · N6752D · Destroyed NTSB IAD74FID34Accident · Serious injuriesClosedBellanca 7ECA · Gloucester, VAApr 29, 1974 · N86626 · Destroyed NTSB IAD74FIA13Accident · No injuriesClosedCessna 172M · Luray, VAApr 28, 1974 · N12195 · Substantial damage NTSB IAD74FID35Accident · No injuriesClosedPiper PA-39 · Tangier Isl, VAApr 27, 1974 · N8844Y · Substantial damage NTSB IAD74FID33Accident · No injuriesClosedBrewster Fleet · Portsmouth, VAApr 27, 1974 · N1980M · Substantial damage NTSB IAD74AI057Accident · 1 fatalClosedPiper PA-32 · Luray, VAApr 24, 1974 · N5507J · Destroyed NTSB IAD74AI050Accident · 1 fatalClosedBeech D55 · Roanoke, VAApr 23, 1974 · N6270V · Substantial damage NTSB IAD74FID32Accident · No injuriesClosedForney F1A · Tappahannock, VAApr 21, 1974 · N3029G · Substantial damage NTSB IAD74FIA12Accident · Minor injuriesClosedBeech V35B · New Market, VAApr 21, 1974 · N4651A · Substantial damage NTSB IAD74FIA11Accident · No injuriesClosedCessna U206A · Mclean, VAApr 20, 1974 · N4819F · Substantial damage NTSB IAD74FID31Accident · Minor injuriesClosedPiper PA-28 · Richmond, VAApr 18, 1974 · N8543W · Destroyed NTSB IAD74FIA09Accident · No injuriesClosedCessna 172E · Fort Belvoir, VAApr 10, 1974 · N5406T · Substantial damage NTSB IAD74FID30Accident · No injuriesClosedBeech T-34 · Assateague Isl, VAApr 2, 1974 · N9014R · Substantial damage