Skip to content

NTSB investigations, 1979, VA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 IAD80DID07Accident · No injuriesClosedLuscombe 8E · Indian Valley, VADec 30, 1979 · N45765 · Substantial damage NTSB IAD80FIA03Accident · No injuriesClosedCessna 182F · Brandy Station, VADec 15, 1979 · N3139U · Substantial damage NTSB IAD80DID05Accident · Minor injuriesClosedPiper PA-28 · Lexington, VADec 12, 1979 · N5059S · Substantial damage NTSB IAD80DID04Accident · No injuriesClosedPiper PA-28 · Lynchburg, VADec 7, 1979 · N6410J · Substantial damage NTSB IAD80FA013Accident · 1 fatalClosedPiper PA-23 · Locust Grove, VANov 25, 1979 · N7650D · Destroyed NTSB IAD80DID03Accident · No injuriesClosedPiper PA-28 · Charlottesvlle, VANov 23, 1979 · N55811 · Substantial damage NTSB IAD80FA010Accident · Serious injuriesClosedCessna 172N · Vienna, VANov 15, 1979 · N739TJ · Substantial damage NTSB IAD80DID02Accident · No injuriesClosedCessna T-41 · Richmond, VANov 9, 1979 · N31FL · Substantial damage NTSB IAD80DID01Accident · No injuriesClosedGrum Amer AA1-C · Cheasapeake, VANov 9, 1979 · N9552U · Substantial damage NTSB IAD80FIA01Accident · No injuriesClosedBoeing E75 · Bealton, VAOct 28, 1979 · N47964 · Substantial damage NTSB IAD80FA004Accident · 2 fatalClosedCessna T210N · Lawrenceville, VAOct 5, 1979 · N6483N · Destroyed NTSB IAD80FA003Accident · 3 fatalClosedHughes 369HS · Mt Crawford, VAOct 4, 1979 · N9076F · Destroyed NTSB IAD79FA095Accident · No injuriesClosedPiper PA-31 · Lynchburg, VASep 29, 1979 · N27678 · Substantial damage NTSB IAD79FA089Accident · 1 fatalClosedPiper PA-38 · Chesterfield, VASep 26, 1979 · N4433E · Destroyed NTSB IAD79DKM01Accident · No injuriesClosedPiper PA-22 · Port Royal, VASep 26, 1979 · N5894Z · Substantial damage NTSB IAD79FA087Accident · No injuriesClosedCessna 140 · Luray, VASep 20, 1979 · N89327 · Substantial damage NTSB IAD79FID37Accident · Serious injuriesClosedHiller FH1100 · Champlain, VASep 19, 1979 · N421FH · Substantial damage NTSB IAD79FID36Accident · No injuriesClosedMaule M5-236 · Richmond, VASep 18, 1979 · N5636N · Substantial damage NTSB ATL80DID27Accident · No injuriesClosedPiper PA-28R · Norfolk, VASep 18, 1979 · N4608J · Substantial damage NTSB IAD79FID33Accident · No injuriesClosedCessna 182H · Ashland, VASep 11, 1979 · N2358X · Substantial damage NTSB IAD79FID35Accident · Minor injuriesClosedPiper PA-12 · Chesapeake, VASep 8, 1979 · N72HW · Substantial damage NTSB IAD79FA076Accident · 1 fatalClosedPiper PA-18 · Warrenton, VASep 8, 1979 · N8228P · Substantial damage NTSB IAD79FID32Accident · No injuriesClosedCessna 177RG · Gordonsville, VASep 7, 1979 · N34969 · Substantial damage NTSB IAD79FID31Accident · No injuriesClosedGrumman G-164A · Glouster, VASep 4, 1979 · N9873 · Substantial damage NTSB IAD79FA077Accident · 1 fatalClosedMooney M-20F · Troutdale, VASep 2, 1979 · N7747M · Destroyed NTSB IAD79FID30Accident · No injuriesClosedCessna 172K · Hopewell, VAAug 30, 1979 · N4714K · Substantial damage NTSB IAD79FID29Accident · Minor injuriesClosedPiper PA-28 · Urbanna, VAAug 28, 1979 · N4815T · Substantial damage NTSB IAD79FID28Accident · No injuriesClosedWeimer RV3 · Hanover, VAAug 25, 1979 · N90516 · Substantial damage NTSB IAD79DIJ12Accident · Serious injuriesClosedBarnes FF-7 · Eagle'S Nest, VAAug 18, 1979 · N40452 · No damage NTSB IAD79FID27Accident · No injuriesClosedStarduster SA300 · Weirwood, VAAug 17, 1979 · N17FP · Destroyed NTSB IAD79DID25Accident · Minor injuriesClosedPiper PA-28 · Roanoke, VAAug 15, 1979 · N41856 · Destroyed NTSB IAD79FID24Accident · Serious injuriesClosedCessna 421 · Norfolk, VAAug 5, 1979 · N3126K · Destroyed NTSB IAD79FID23Accident · No injuriesClosedGrum Amer AA1B · Bowling Green, VAJul 29, 1979 · N96451 · Substantial damage NTSB IAD79DIA15Accident · No injuriesClosedCessna 182 · Luray, VAJul 29, 1979 · N2879F · Substantial damage NTSB IAD79FID22Accident · Serious injuriesClosedCessna 172 · Montebello, VAJul 25, 1979 · N2860L · Destroyed NTSB IAD79IA064Incident · No injuriesClosedNamc YS-11A · Charlottesvlle, VAJul 18, 1979 · N259P · Minor damage NTSB IAD79FIA14Accident · No injuriesClosedGrum Amer AA-5 · Warrenton, VAJul 8, 1979 · N9629U · Substantial damage NTSB IAD79DID21Accident · No injuriesClosedCessna 172N · Lexington, VAJul 8, 1979 · N734DD · Substantial damage NTSB IAD79DIJ08Accident · No injuriesClosedPiper PA-28R · Clinchport, VAJun 22, 1979 · N41855 · Substantial damage NTSB IAD79FID20Accident · No injuriesClosedBeech 58 · Keysville, VAJun 15, 1979 · N2018T · Substantial damage NTSB IAD79DID26Accident · No injuriesClosedPiper PA-28 · Flat Rock, VAJun 13, 1979 · N43243 · Substantial damage NTSB IAD79FA056Accident · 3 fatalClosedBeech C24R · Woodbridge, VAJun 7, 1979 · N18969 · Destroyed NTSB IAD79FID19Accident · No injuriesClosedChampion 7GCAA · Pungo, VAJun 6, 1979 · N6347N · Substantial damage NTSB IAD79DID18Accident · No injuriesClosedCessna 150L · Lexington, VAMay 30, 1979 · N21961 · Substantial damage NTSB IAD79DID16Accident · No injuriesClosedLake LA4 · Oak Grove, VAMay 20, 1979 · N2596P · Substantial damage NTSB IAD79FID15Accident · No injuriesClosedCessna 150 · Chesapeake, VAMay 17, 1979 · N8805U · Substantial damage NTSB IAD79FID17Accident · No injuriesClosedCessna 152 · Walkerton, VAMay 16, 1979 · N757YV · Substantial damage NTSB IAD79FID14Accident · No injuriesClosedBellanca 17-30 · Quinton, VAApr 30, 1979 · N4862V · Substantial damage NTSB IAD79FA047Accident · 2 fatalClosedCessna 182J · Hillsboro, VAApr 26, 1979 · N2738F · Destroyed NTSB IAD79FIA10Accident · No injuriesClosedPiper PA-28 · Bayse, VAApr 19, 1979 · N2083G · Destroyed