NTSB investigations, 1970, 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.

Cases per year

19632026
NTSB investigations, 1970, VA per year, 1963–2026: 2,565 cases
19631
196475
196576
196691
196775
196890
196987
197074
197153
197260
197356
197461
197553
197659
197760
197864
197965
198063
198142
198238
198352
198453
198544
198642
198735
198843
198936
199034
199133
199231
199332
199427
199530
199626
199726
199830
199931
200039
200142
200238
200331
200422
200515
200632
200736
200830
200934
201027
201130
201224
201317
201425
201521
201630
201727
201831
201924
202015
202118
202221
202325
202427
202524
202612

Latest cases

Query with SQL
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\") = 1970
    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.

NTSB IAD71FIA14Accident · Serious injuriesClosedSud Aviatio SE3130 · Alexandria, VADec 31, 1970 · N532 · DestroyedNTSB IAD71FID17Accident · No injuriesClosedCessna 175 · Sandston, VADec 28, 1970 · N9451B · DestroyedNTSB IAD71II028Incident · No injuriesClosedBoeing 737 · Lynchburg, VADec 5, 1970 · N738N · No damageNTSB IAD71DID16Accident · Minor injuriesClosedCessna 172K · Waynesboro, VANov 25, 1970 · N7069G · Substantial damageNTSB IAD71DIA13Accident · No injuriesClosedPiper PA-11 · Culpepper, VANov 15, 1970 · N4854M · Substantial damageNTSB IAD71AI026Accident · 1 fatalClosedPiper PA-28 · Missing Aircraft, VANov 13, 1970 · N9384W · DestroyedNTSB IAD71FIJ11Accident · No injuriesClosedPiper PA-24 · Independence, VANov 8, 1970 · N7690P · Substantial damageNTSB IAD71FID14Accident · 1 fatalClosedCessna 182 · Crewe, VANov 8, 1970 · N8503S · No damageNTSB IAD71AI021Accident · 3 fatalClosedCessna 172G · Providence Frg, VANov 1, 1970 · N3750L · DestroyedNTSB IAD71II019Incident · No injuriesClosedNihon YS-11A · Hot Springs, VAOct 28, 1970 · N164P · Minor damageNTSB IAD71AI018Accident · 4 fatalClosedBeech 95-C55 · Boones Mill, VAOct 26, 1970 · N5484U · DestroyedNTSB IAD71AI015Accident · 1 fatalClosedChampion 7ECA · Coles Point, VAOct 23, 1970 · N6394N · DestroyedNTSB IAD71AI027Accident · No injuriesClosedMooney M20C · Lynchburg, VAOct 21, 1970 · N9170V · Substantial damageNTSB IAD71FID10Accident · Serious injuriesClosedBeech A23-19 · Norfolk, VAOct 12, 1970 · N2382W · DestroyedNTSB IAD71FIA12Accident · No injuriesClosedCessna 150F · Manassas, VASep 27, 1970 · N8076F · Substantial damageNTSB IAD71DID09Accident · Serious injuriesClosedChampion 7GCBC · Lynchburg, VASep 26, 1970 · N9040L · DestroyedNTSB IAD71DIA11Accident · Minor injuriesClosedSchweizer SGS233 · Warrenton, VASep 13, 1970 · N2440W · Substantial damageNTSB IAD71FIA10Accident · No injuriesClosedPiper J3P · Woodbridge, VASep 12, 1970 · N21561 · Substantial damageNTSB IAD71FID06Accident · Minor injuriesClosedPiper PA-28 · Cohasset, VASep 11, 1970 · N6394R · DestroyedNTSB IAD71DID11Accident · No injuriesClosedChampion 7KCAB · Lexington, VASep 6, 1970 · N7561F · Substantial damageNTSB IAD71FID07Accident · 1 fatalClosedPiper PA-18 · Virginia Beach, VASep 4, 1970 · N7693D · DestroyedNTSB IAD71FIA09Accident · No injuriesClosedCessna 172 · Herndon, VAAug 28, 1970 · N46625 · Substantial damageNTSB IAD71DIA07Accident · No injuriesClosedBeech 35-B33 · Warrenton, VAAug 26, 1970 · N8635M · Substantial damageNTSB IAD70DIJ05Accident · No injuriesClosedCessna 120 · Dublin, VAAug 26, 1970 · N72544 · Substantial damageNTSB IAD71FID05Accident · No injuriesClosedPiper PA-24 · Norfolk, VAAug 15, 1970 · N7821P · Substantial damageNTSB IAD71FIA04Accident · No injuriesClosedGlobe GC-1B · Manassas, VAAug 15, 1970 · N78111 · Substantial damageNTSB IAD71DIA06Accident · No injuriesClosedPiper PA-22 · Woodbridge, VAAug 12, 1970 · N9734D · Substantial damageNTSB IAD71DIJ06Accident · Serious injuriesClosedHughes 269B · Big Rock, VAAug 8, 1970 · N9328F · Substantial damageNTSB IAD71FID04Accident · No injuriesClosedPiper PA-25 · Zuni, VAAug 6, 1970 · N6725Z · Substantial damageNTSB IAD71DID08Accident · No injuriesClosedHiller Acft FH1100 · Bedford, VAAug 5, 1970 · N30VA · Substantial damageNTSB IAD71AI008Accident · 5 fatalClosedPiper PA-28 · Hinton, VAJul 23, 1970 · N7943N · DestroyedNTSB IAD71FID03Accident · No injuriesClosedAlon A-2 · Disputanta, VAJul 20, 1970 · N6594Q · Substantial damageNTSB IAD71FID01Accident · Serious injuriesClosedPiper PA-28 · Boones Mill, VAJul 9, 1970 · N5196W · DestroyedNTSB IAD71AI004Accident · 3 fatalClosedPiper PA-22 · Chesapeake, VAJul 5, 1970 · N1909P · DestroyedNTSB IAD71FIA05Accident · Minor injuriesClosedBensen B-8M · Woodbridge, VAJul 1, 1970 · N5310 · DestroyedNTSB IAD70FIJ08Accident · Serious injuriesClosedBeech 65S · Dublin, VAJun 30, 1970 · N447S · DestroyedNTSB IAD70DID23Accident · No injuriesClosedLuscombe 8A · Gordonsville, VAJun 27, 1970 · N1127B · Substantial damageNTSB IAD70DID22Accident · Minor injuriesClosedAlon A-2 · Hopewell, VAJun 22, 1970 · N6597Q · Substantial damageNTSB IAD70FID24Accident · No injuriesClosedPiper J-3 · Wallops Island, VAJun 15, 1970 · N30933 · Substantial damageNTSB IAD70DID21Accident · No injuriesClosedPiper J3C · Sealston, VAMay 21, 1970 · N98889 · Substantial damageNTSB IAD70FI018Accident · Minor injuriesClosedCessna 182K · Richmond, VAMay 19, 1970 · N2527R · DestroyedNTSB IAD70AI060Accident · 1 fatalClosedGlobe GC-1B · Blue Ridge, VAMay 16, 1970 · N80792 · DestroyedNTSB IAD70FIA14Accident · Serious injuriesClosedPiper PA-28 · Baileys X-Road, VAMay 10, 1970 · N1850J · DestroyedNTSB IAD70DID20Accident · No injuriesClosedCessna 150F · Blacksburg, VAMay 8, 1970 · N8737G · Substantial damageNTSB IAD70FID17Accident · No injuriesClosedPiper PA-28 · Quinton, VAApr 22, 1970 · N6394R · Substantial damageNTSB IAD70DID16Accident · Minor injuriesClosedCessna 172 · Hopewell, VAApr 18, 1970 · N7626X · Substantial damageNTSB IAD70DIA11Accident · No injuriesClosedSchweizer 2-33 · Warrenton, VAApr 18, 1970 · N5758S · Substantial damageNTSB IAD70FIA08Accident · No injuriesClosedPiper PA-28 · Baileys X Road, VAApr 8, 1970 · N8475W · Substantial damageNTSB IAD70II056Incident · No injuriesClosedNihon YS-11A · Roanoke, VAApr 2, 1970 · N159P · Minor damageNTSB IAD70DIA07Accident · No injuriesClosedCessna 182D · Radiant, VAApr 2, 1970 · N8852X · Substantial damage