Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 IAD78FIA02Accident · No injuriesClosedCessna 150 · Leesburg, VADec 11, 1977 · N9373U · Substantial damage NTSB IAD78FIA01Accident · Minor injuriesClosedCessna 177 · Nokesville, VADec 4, 1977 · N35104 · Substantial damage NTSB IAD78DIJ06Accident · No injuriesClosedCessna 150 · Abingdon, VADec 2, 1977 · N7735G · Substantial damage NTSB IAD78FA016Accident · 1 fatalClosedPiper PA-23 · Reston, VANov 30, 1977 · N6241Y · Destroyed NTSB IAD78FA013Accident · 1 fatalClosedCessna 182 · Richmond, VANov 23, 1977 · N2686R · Destroyed NTSB IAD78FID04Accident · No injuriesClosedAeronca 7CCM · Petersburg, VANov 13, 1977 · N85478 · Substantial damage NTSB IAD78FID03Accident · No injuriesClosedBeech 60 · Newport News, VANov 7, 1977 · N399TL · Substantial damage NTSB IAD78FID02Accident · Serious injuriesClosedPiper PA-32 · Prospect, VAOct 28, 1977 · N8613N · Destroyed NTSB IAD78FA004Accident · Serious injuriesClosedMooney M20E · Chesapeake, VAOct 15, 1977 · N1276X · 2 aircraft · Substantial damage NTSB IAD78DIJ01Accident · Serious injuriesClosedPiper PA-28 · Abingdon, VAOct 13, 1977 · N38531 · Destroyed NTSB IAD78FA002Accident · 4 fatalClosedCessna 182P · Wise, VAOct 9, 1977 · N7049S · Destroyed NTSB IAD78DID01Accident · Serious injuriesClosedCessna 150L · Wintergreen, VAOct 8, 1977 · N2602Q · Destroyed NTSB IAD78FA001Accident · No injuriesClosedFairchild M62A · Bealton, VAOct 2, 1977 · N51874 · 2 aircraft · Substantial damage NTSB IAD77FIA26Accident · No injuriesClosedPiper PA-32 · Harrisonburg, VASep 23, 1977 · N3460W · Substantial damage NTSB IAD77DID31Accident · No injuriesClosedPiper PA-28 · Boydton, VASep 21, 1977 · N2838T · Substantial damage NTSB IAD77;ID30Accident · Minor injuriesClosedPiper PA-22 · Pungo, VASep 18, 1977 · N4323A · Destroyed NTSB IAD77FID29Accident · Minor injuriesClosedBoeing A75N1 · Fredericksburg, VASep 10, 1977 · N17PT · Substantial damage NTSB IAD77DIA25Accident · Minor injuriesClosedCessna 172 · Warrenton, VASep 10, 1977 · N84262 · Substantial damage NTSB IAD77DIA24Accident · No injuriesClosedCessna 150 · Warrenton, VASep 5, 1977 · C-GOMV · Substantial damage NTSB IAD77FA060Accident · 1 fatalClosedAero Comdr A-9 · Petersburg, VAAug 13, 1977 · N7739V · Destroyed NTSB IAD77FID28Accident · Serious injuriesClosedPiper PA-24 · Newport News, VAAug 6, 1977 · N9173P · Substantial damage NTSB IAD77FID27Accident · No injuriesClosedCessna R172E · Powhatan, VAAug 6, 1977 · N5755T · Substantial damage NTSB IAD77DIJ09Accident · No injuriesClosedBellanca 7GCBC · Richlands, VAAug 5, 1977 · N88421 · Substantial damage NTSB IAD77FIA22Accident · Serious injuriesClosedPiper PA-28 · Basye, VAJul 31, 1977 · N1832J · Destroyed NTSB IAD77DID26Accident · No injuriesClosedPiper PA-22 · Capron, VAJul 29, 1977 · N1681P · Substantial damage NTSB IAD77DID25Accident · Minor injuriesClosedPiper PA22 · Blackstone, VAJul 22, 1977 · N9512D · Substantial damage NTSB IAD77FIA21Accident · No injuriesClosedPiper PA-18 · Midland, VAJul 12, 1977 · N9147D · Substantial damage NTSB IAD77FA051Accident · 1 fatalClosedGrum Amer AA5-A · Warrenton, VAJul 10, 1977 · N9836U · Destroyed NTSB IAD77DID24Accident · Serious injuriesClosedCessna 182 · Wicomico Chur, VAJul 3, 1977 · N3467S · Substantial damage NTSB IAD77DID23Accident · Minor injuriesClosedPiper J3C-65 · Woolwine, VAJul 3, 1977 · N7157H · Substantial damage NTSB IAD77DA049Incident · No injuriesClosedAerostar 600 · Abingdon, VAJul 1, 1977 · N72HB · Minor damage NTSB IAD77DID22Accident · No injuriesClosedCessna 140 · Leedsville, VAJun 24, 1977 · N72595 · Substantial damage NTSB IAD77FLJ21Accident · Minor injuriesClosedPiper PA-28R · Danville, VAJun 22, 1977 · N9302N · Substantial damage NTSB IAD77FID21Accident · No injuriesClosedAerostar 600 · South Hill, VAJun 21, 1977 · N97CC · Substantial damage NTSB IAD77FIA18Accident · Serious injuriesClosedMaule M-4 · Woodbridge, VAJun 16, 1977 · N20344 · Substantial damage NTSB IAD77FIA17Accident · No injuriesClosedBoeing E75 · Midland, VAJun 12, 1977 · N52143 · Substantial damage NTSB IAD77FIA16Accident · No injuriesClosedFleet 1 · Bealton, VAJun 5, 1977 · N1980M · Substantial damage NTSB IAD77DID20Accident · Minor injuriesClosedPiper PA-28 · Lyells, VAJun 5, 1977 · N6903W · Substantial damage NTSB IAD77DIA15Accident · No injuriesClosedPiper PA-18 · Nokesville, VAMay 20, 1977 · N703CB · Substantial damage NTSB IAD77DID19Accident · No injuriesClosedCessna 177 · Waynesboro, VAMay 14, 1977 · N29306 · Substantial damage NTSB IAD77FA040Accident · 1 fatalClosedPiper PA-28 · Alexandria, VAMay 12, 1977 · N5382L · Substantial damage NTSB IAD77FID18Accident · No injuriesClosedHughes 269 · Richmond, VAMay 5, 1977 · N7451F · Substantial damage NTSB IAD77FID17Accident · No injuriesClosedPiper PA-20 · Suffolk, VAApr 30, 1977 · N1712A · 2 aircraft · Substantial damage NTSB IAD77AA038Accident · 4 fatalClosedBeech HS.125 · Mclean, VAApr 28, 1977 · N40PC · Destroyed NTSB IAD77FIA12Accident · No injuriesClosedPiper PA-28R · Woodbridge, VAApr 24, 1977 · N5271T · Substantial damage NTSB IAD77FID16Accident · 1 fatalClosedSchweizer 1-26B · Windsor, VAApr 9, 1977 · N680U · Substantial damage NTSB IAD77FIA11Accident · Minor injuriesClosedStampe SV4C · Bealeton, VAApr 8, 1977 · N47SV · Destroyed NTSB IAD77FA030Accident · 1 fatalClosedBeech 35 · Boones Mill, VAMar 12, 1977 · N4459V · Destroyed NTSB IAD77FA029Accident · 1 fatalClosedCessna A150L · Lovettsvile, VAMar 9, 1977 · N44GV · Destroyed NTSB IAD77FA027Accident · 1 fatalClosedMooney M20C · Forest, VAMar 5, 1977 · N6755U · Destroyed