Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 IAD76FIA08Accident · Serious injuriesClosedBellanca 7KCAB · Woodstock, VADec 24, 1975 · N53743 · Destroyed NTSB IAD76FID17Accident · Minor injuriesClosedHughes 269C · Richmond, VADec 22, 1975 · N9693F · Destroyed NTSB IAD76DID17Accident · Minor injuriesClosedPiper PA-28 · Gordonsville, VADec 14, 1975 · N15915 · Substantial damage NTSB IAD76AI038Accident · 1 fatalClosedPiper PA-32R · Topping, VADec 6, 1975 · N200HM · Destroyed NTSB IAD76II040Incident · No injuriesClosedPiper PA-31 · Chantilly, VANov 15, 1975 · N4FA · No damage NTSB IAD76AI030Accident · 2 fatalClosedBeech D55 · Front Royal, VANov 7, 1975 · N8906G · Destroyed NTSB IAD76FID16Accident · No injuriesClosedCessna 150F · Richmond, VANov 5, 1975 · N8099F · Substantial damage NTSB IAD76FID15Accident · Minor injuriesClosedAmer Avco AA-1A · Ashland, VANov 1, 1975 · N9458L · Destroyed NTSB IAD76II027Incident · No injuriesClosedSmith A600 · Lynchburg, VAOct 28, 1975 · N702HB · Minor damage NTSB IAD76DIJ08Accident · No injuriesClosedSmith DSA1 · Abingdon, VAOct 25, 1975 · N138L · Substantial damage NTSB IAD76FIA03Accident · Serious injuriesClosedCessna P206D · Fredericksburg, VAOct 19, 1975 · N8728Z · Destroyed NTSB IAD76AI026Accident · 1 fatalClosedBeech C23 · Afton, VAOct 18, 1975 · N8061R · Destroyed NTSB IAD76FID14Accident · Minor injuriesClosedPiper PA-32 · South Boston, VAOct 14, 1975 · N3698W · Destroyed NTSB IAD76II024Incident · Minor injuriesClosedBoeing 727 · Chantilly, VAOct 11, 1975 · N1905 · Minor damage NTSB IAD76FID13Accident · Serious injuriesClosedPiper PA-28 · Hampton, VAOct 11, 1975 · N8804W · Destroyed NTSB IAD76FID12Accident · Minor injuriesClosedCessna 206 · Saluda, VAOct 5, 1975 · N5071U · Destroyed NTSB IAD76II020Incident · No injuriesClosedCessna 310F · Nokesville, VAOct 1, 1975 · N250PP · Minor damage NTSB IAD76FID11Accident · No injuriesClosedPiper PA-24 · Blacksburg, VASep 28, 1975 · N7189P · Substantial damage NTSB IAD76FID10Accident · No injuriesClosedPiper PA-24 · South Hill, VASep 15, 1975 · N7571P · Substantial damage NTSB IAD76FID08Accident · No injuriesClosedCessna 172M · Crozet, VASep 6, 1975 · N19889 · Substantial damage NTSB IAD7LFID09Accident · No injuriesClosedCessna 180A · Norfolk, VASep 5, 1975 · N7777V · Substantial damage NTSB IAD76FID07Accident · No injuriesClosedPiper PA-25 · Virginia Beach, VAAug 30, 1975 · N4866Y · Substantial damage NTSB IAD76FID06Accident · No injuriesClosedPiper PA-23 · Petersburg, VAAug 26, 1975 · N270X · Destroyed NTSB IAD76FID05Accident · Minor injuriesClosedCessna 140 · Bassett, VAAug 17, 1975 · N2522N · Substantial damage NTSB IAD76FID04Accident · No injuriesClosedCessna 150L · Waynesboro, VAAug 10, 1975 · N1486Q · Substantial damage NTSB IAD76FID03Accident · No injuriesClosedTennie TWO · Lynchburg, VAAug 5, 1975 · N38929 · Substantial damage NTSB IAD76DIA01Accident · No injuriesClosedSopwith PUP · Bealeton, VAAug 3, 1975 · N1612U · Substantial damage NTSB IAD76FID02Accident · No injuriesClosedPiper PA-23 · Lynchburg, VAJul 30, 1975 · N2085P · Substantial damage NTSB NYC76IN009Incident · Minor injuriesClosedDouglas DC-10 · Richmond, VAJul 18, 1975 · N64NA · No damage NTSB IAD76FID01Accident · No injuriesClosedAmer Avco AA1 · Dillwyn, VAJul 1, 1975 · N6147L · Substantial damage NTSB IAD75AI066Accident · Serious injuriesClosedCessna 150L · Manassas, VAJun 28, 1975 · N1308Q · 2 aircraft · Destroyed NTSB IAD75FID26Accident · No injuriesClosedCessna 172H · Quinton, VAJun 22, 1975 · N8057L · Substantial damage NTSB IAD75FID25Accident · No injuriesClosedBellanca 14-19 · New London, VAJun 9, 1975 · N74388 · Substantial damage NTSB IAD75DIA24Accident · No injuriesClosedCessna 177 · Woodbridge, VAJun 6, 1975 · N3022C · Substantial damage NTSB IAD75DID24Accident · No injuriesClosedCessna 150 · Chesterfield, VAMay 28, 1975 · N8099F · Substantial damage NTSB IAD75DID23Accident · No injuriesClosedBoeing A75 · Hallwood, VAMay 27, 1975 · N68461 · Substantial damage NTSB IAD75FID21Accident · Minor injuriesClosedBell 47G4 · Creeds, VAMay 23, 1975 · N7764 · Destroyed NTSB IAD75FID20Accident · Serious injuriesClosedPiper PA-12 · Newport News, VAMay 9, 1975 · N3167M · Substantial damage NTSB IAD75FID18Accident · Serious injuriesClosedPiper PA-28R · Chesapeake, VAMay 1, 1975 · N2090T · Destroyed NTSB IAD75FIA20Accident · Minor injuriesClosedEnstrom F28A · Clifton, VAApr 24, 1975 · N4469 · Destroyed NTSB IAD75DIA21Accident · No injuriesClosedCessna 150 · Clifton, VAApr 22, 1975 · N66078 · Substantial damage NTSB IAD75FIA16Accident · No injuriesClosedPiper PA-32 · Warrenton, VAApr 9, 1975 · N4225R · Substantial damage NTSB IAD75FID17Accident · Serious injuriesClosedPiper PA-22 · Cape Charles, VAApr 5, 1975 · N1645B · Substantial damage NTSB IAD75FID16Accident · Minor injuriesClosedCessna 150L · Ashland, VAMar 27, 1975 · N1629Q · Substantial damage NTSB IAD75FIA17Accident · Serious injuriesClosedMooney M20C · New Market, VAMar 15, 1975 · N6705U · Substantial damage NTSB IAD75FID15Accident · Minor injuriesClosedTaylorcraft BC1265 · Gloucester, VAMar 9, 1975 · N71T · Substantial damage NTSB IAD75AI050Accident · 3 fatalClosedBell 206B · Wise, VAMar 8, 1975 · N370AF · Destroyed NTSB IAD75FIJ15Accident · Serious injuriesClosedAero Comdr 200D · Jonesville, VAMar 2, 1975 · N321AJ · Substantial damage NTSB IAD75FID14Accident · No injuriesClosedCessna 150 · Forest, VAFeb 28, 1975 · N7996Z · Substantial damage NTSB IAD75FIA13Accident · Minor injuriesClosedPiper PA-28 · Leesburg, VAFeb 16, 1975 · N1504T · Substantial damage