Skip to content

NTSB investigations, 1978, VA

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 IAD79FIA05Accident · No injuriesClosedCessna 172 · Manassas, VADec 23, 1978 · N1628E · Substantial damage NTSB IAD79DA025Accident · Serious injuriesClosedBoeing 737 · Norfolk, VADec 21, 1978 · N9009U · No damage NTSB IAD79FID04Accident · Minor injuriesClosedCessna 172 · Newport News, VANov 29, 1978 · N9850Q · Destroyed NTSB IAD79DIA04Accident · Serious injuriesClosedSchweizer SGS233 · Warrenton, VANov 25, 1978 · N33978 · Destroyed NTSB IAD79FA019Accident · 3 fatalClosedBeech G35 · Bridgewater, VANov 22, 1978 · N4291D · Destroyed NTSB IAD79FA016Accident · 1 fatalClosedCessna 175B · Rileyville, VANov 21, 1978 · N8140T · Destroyed NTSB IAD79FID03Accident · Minor injuriesClosedMooney M20G · Chesapeake, VANov 19, 1978 · N9127V · Destroyed NTSB IAD79FA014Accident · No injuriesClosedPiper PA-32 · South Boston, VANov 18, 1978 · N3940W · Substantial damage NTSB IAD79FA010Accident · 4 fatalClosedPiper PA-32 · Melfa, VANov 8, 1978 · N1104X · Destroyed NTSB IAD79FID02Accident · Minor injuriesClosedBeech D45 · Norfolk, VANov 5, 1978 · N3363F · Destroyed NTSB IAD79FIA03Accident · Serious injuriesClosedPiper PA-28R · Standardsville, VAOct 27, 1978 · N7604J · Substantial damage NTSB IAD79FIJ01Accident · Serious injuriesClosedMooney M20C · Grundy, VAOct 20, 1978 · N1348W · Substantial damage NTSB IAD79FID01Accident · No injuriesClosedCessna 150 · Blacksburg, VAOct 12, 1978 · N5709E · Substantial damage NTSB IAD79FIA01Accident · No injuriesClosedCessna 172 · Woodbridge, VAOct 12, 1978 · N3881Q · Substantial damage NTSB IAD79FA004Accident · Minor injuriesClosedPiper PA-32R · White Gate, VAOct 12, 1978 · N9797C · Destroyed NTSB IAD78PIJ20Accident · No injuriesClosedPiper PA-32R · Wise, VASep 23, 1978 · N43941 · Substantial damage NTSB IAD78IA110Incident · No injuriesClosedCessna 310Q · Roanoke, VASep 17, 1978 · N1315G · 2 aircraft · No damage NTSB IAD78FID24Accident · No injuriesClosedCessna 182RG · Williamsburg, VASep 16, 1978 · N3353C · Substantial damage NTSB IAD78DIA18Accident · No injuriesClosedSchweizer SGS233 · Warrenton, VASep 13, 1978 · N2039T · Substantial damage NTSB IAD78FA098Accident · 2 fatalClosedCessna 210L · Hot Springs, VAAug 25, 1978 · N3JE · Destroyed NTSB IAD78FID22Accident · Minor injuriesClosedPiper PA-22 · Danville, VAAug 22, 1978 · N5361Z · Substantial damage NTSB IAD79DIA17Accident · No injuriesClosedCessna 210 · Basye, VAAug 21, 1978 · N6579X · Substantial damage NTSB IAD78FA096Accident · No injuriesClosedCessna 180 · Roanoke, VAAug 21, 1978 · N7827K · 2 aircraft · Substantial damage NTSB IAD78DID23Accident · Minor injuriesClosedTeenie TWO · Forest, VAAug 21, 1978 · N38929 · Substantial damage NTSB IAD78FID21Accident · No injuriesClosedHiller Acft UH-12B · Roanoke, VAAug 17, 1978 · N67699 · Substantial damage NTSB IAD78FID20Accident · No injuriesClosedAyers 600S2R · Boykins, VAAug 15, 1978 · N7797V · Destroyed NTSB IAD78FA093Accident · No injuriesClosedPiper PA-32 · Norfolk, VAAug 10, 1978 · N8997N · Destroyed NTSB IAD78FID19Accident · Minor injuriesClosedPiper PA-22 · Chesterfield, VAAug 8, 1978 · N1812P · Substantial damage NTSB IAD78FIA16Accident · Serious injuriesClosedPazmany PL-4 · Leesburg, VAAug 8, 1978 · N78HS · Substantial damage NTSB IAD78FID18Accident · Serious injuriesClosedBellanca 8KCAB · Norfolk, VAAug 6, 1978 · N5537K · 2 aircraft · Destroyed NTSB IAD78FA088Accident · 3 fatalClosedPiper PA-34 · Chesterfield, VAAug 2, 1978 · N56122 · Destroyed NTSB IAD78FID17Accident · No injuriesClosedN American SNJ-5 · Langley Afb, VAJul 29, 1978 · N3673F · Substantial damage NTSB IAD78DID16Accident · No injuriesClosedCessna 172 · Augusta Spring, VAJul 27, 1978 · N4286L · Substantial damage NTSB IAD78FA086Accident · No injuriesClosedCessna 150 · Leesburg, VAJul 26, 1978 · N704ZB · 2 aircraft · Substantial damage NTSB IAD78DID15Accident · No injuriesClosedCessna 172 · Chesapeake, VAJul 22, 1978 · N61676 · Substantial damage NTSB IAD78FID14Accident · No injuriesClosedPiper PA-32R · Richmond, VAJul 18, 1978 · N3929X · Substantial damage NTSB IAD78FA081Accident · No injuriesClosedPiper PA-32 · Severn, VAJul 13, 1978 · N3905W · Substantial damage NTSB IAD78FID13Accident · No injuriesClosedCessna 172M · Gloucester, VAJul 12, 1978 · N411LB · Substantial damage NTSB IAD78FID11Accident · Serious injuriesClosedCessna 150 · Farmville, VAJul 6, 1978 · N9209U · Substantial damage NTSB IAD78FA077Accident · 3 fatalClosedPiper PA-24 · Deerfield, VAJul 4, 1978 · N5991P · Destroyed NTSB IAD78DID12Accident · No injuriesClosedCessna 120 · Richmond, VAJul 1, 1978 · N1885N · Substantial damage NTSB IAD78FID10Accident · Minor injuriesClosedCessna 150D · Williamsburg, VAJun 28, 1978 · N5971T · Destroyed NTSB IAD78FIA13Accident · Minor injuriesClosedBalloon WKS Frfy 7 · Catlett, VAJun 27, 1978 · N2348H · Substantial damage NTSB IAD78FIA10Accident · Serious injuriesClosedBalloon WKS Fire 7 · Catlett, VAJun 27, 1978 · N27138 · Minor damage NTSB IAD78DIA11Accident · Serious injuriesClosedBalloon WKS Frfy 7 · Casanova, VAJun 27, 1978 · N2091F · Substantial damage NTSB IAD78FID09Accident · Serious injuriesClosedBellanca 8KCAB · Mechanicsville, VAJun 24, 1978 · N68546 · Destroyed NTSB IAD78FIA09Accident · No injuriesClosedCessna 152 · Culpeper, VAJun 11, 1978 · N65408 · Substantial damage NTSB IAD78DID08Accident · No injuriesClosedBeech T-34B · Dillwyn, VAJun 8, 1978 · N31810 · Substantial damage NTSB IAD78FID07Accident · Minor injuriesClosedPitts S-1 · Fredericksburg, VAJun 4, 1978 · N6160 · Substantial damage NTSB IAD78FA068Accident · 1 fatalClosedTed Smith 601P · Bumpass, VAMay 26, 1978 · N10HF · Substantial damage