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

Cases per year

19632026
NTSB investigations, 1971, 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\") = 1971
    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 NYC72FIA11Accident · Minor injuriesClosedPiper PA-28 · Front Royal, VADec 29, 1971 · N1953T · Substantial damageNTSB NYC72FID17Accident · Minor injuriesClosedBeech H18 · Charlottsville, VANov 29, 1971 · N717Z · DestroyedNTSB NYC72DID18Accident · No injuriesClosedCessna 172K · Reedville, VANov 25, 1971 · N7211G · Substantial damageNTSB NYC72AN066Accident · 3 fatalClosedBeech B23 · Chesapeake, VANov 12, 1971 · N6115N · DestroyedNTSB NYC72FID16Accident · No injuriesClosedPiper PA-32 · Lynchburg, VAOct 30, 1971 · N4129W · Substantial damageNTSB NYC72AN060Accident · 3 fatalClosedPiper PA-23 · Berlin, VAOct 29, 1971 · N3308P · DestroyedNTSB NYC72FID15Accident · No injuriesClosedPiper PA-30 · Fredericksburg, VAOct 17, 1971 · N8079Y · Substantial damageNTSB NYC72AN053Accident · 6 fatalClosedSwearingen SA26AT · Hot Springs, VAOct 16, 1971 · N20DE · DestroyedNTSB NYC72DIA08Accident · No injuriesClosedPiper PA-28 · Culpeper, VAOct 15, 1971 · N8803J · Substantial damageNTSB NYC72FIA07Accident · Minor injuriesClosedPiper PA-22 · Elkton, VAOct 10, 1971 · N8699C · Substantial damageNTSB NYC72FIA06Accident · No injuriesClosedBeech V35TC · Browntown, VASep 23, 1971 · N1500F · Substantial damageNTSB NYC72FID14Accident · Serious injuriesClosedAero Comdr A-9B · Melfa, VASep 15, 1971 · N7721V · DestroyedNTSB NYC72FID13Accident · 1 fatalClosedBell 47D-1 · Millers Tavern, VASep 14, 1971 · N9115R · DestroyedNTSB NYC72DIA05Accident · No injuriesClosedCessna 177 · Manassas, VASep 9, 1971 · N29562 · Substantial damageNTSB NYC72FIJ29Accident · Serious injuriesClosedCessna 150 · Abingdon, VASep 4, 1971 · N5994G · DestroyedNTSB NYC72FID12Accident · No injuriesClosedN.American SNJ-4 · Fredericksburg, VASep 4, 1971 · N6414D · Substantial damageNTSB NYC72AN033Accident · 1 fatalClosedTaylorcraft BC12-D · Arcola, VASep 4, 1971 · N39284 · DestroyedNTSB NYC72DID11Accident · No injuriesClosedPiper PA-28R · Wingina, VASep 2, 1971 · N4699J · Substantial damageNTSB NYC72DID09Accident · No injuriesClosedCessna 182J · Ashland, VAAug 28, 1971 · N2723F · Substantial damageNTSB NYC72DID08Accident · No injuriesClosedCessna 337 · Lynchburg, VAAug 22, 1971 · N6369F · Substantial damageNTSB NYC72FID07Accident · No injuriesClosedCessna 150 · Ft Eustis, VAAug 20, 1971 · N6260G · Substantial damageNTSB NYC72FID06Accident · Serious injuriesClosedPiper PA-22 · Montvale, VAAug 18, 1971 · N8555D · DestroyedNTSB NYC72DID04Accident · No injuriesClosedCessna 150 · Portsmouth, VAAug 15, 1971 · N8622S · Substantial damageNTSB NYC72FIA03Accident · No injuriesClosedStearman PT-17 · Bealeton, VAAug 14, 1971 · N53414 · 2 aircraft · Substantial damageNTSB NYC72DID03Accident · No injuriesClosedCessna 210H · Bedford, VAAug 8, 1971 · N5969F · Substantial damageNTSB NYC72AN020Accident · No injuriesClosedBeech 3TM · Dublin, VAAug 7, 1971 · N6127 · Substantial damageNTSB NYC72AN021Accident · 1 fatalClosedBeech V35 · Tazewell, VAAug 6, 1971 · N490B · DestroyedNTSB NYC72FIA02Accident · No injuriesClosedPiper PA-28 · Winchester, VAAug 5, 1971 · N7783W · Substantial damageNTSB NYC72FIA01Accident · No injuriesClosedPiper PA-12 · Arcola, VAJul 25, 1971 · N3424M · Substantial damageNTSB IAD72FID02Accident · Minor injuriesClosedCessna 182 · Headwaters, VAJul 25, 1971 · N1855X · DestroyedNTSB IAD72DID01Accident · No injuriesClosedGrumman G-164A · Blacksburg, VAJul 14, 1971 · N7953 · Substantial damageNTSB IAD71FIA23Accident · Minor injuriesClosedBeechy Pusher · Bealton, VAJun 27, 1971 · N631WB · DestroyedNTSB IAD71DID27Accident · No injuriesClosedChampion 7ECA · Clarksville, VAJun 20, 1971 · N8376V · Substantial damageNTSB IAD71DID26Accident · No injuriesClosedChampion 7KCAB · Virginia Beach, VAJun 19, 1971 · N5073X · Substantial damageNTSB IAD71AI055Accident · 6 fatalClosedAero Comdr 680E · Roanoke, VAMay 28, 1971 · N601JJ · DestroyedNTSB IAD71AI053Accident · 4 fatalClosedCessna 177 · New Castle, VAMay 27, 1971 · N2271Y · DestroyedNTSB IAD71FIA20Accident · Serious injuriesClosedCessna 175 · Hillsboro, VAMay 13, 1971 · N7193M · Substantial damageNTSB IAD71FIA19Accident · Minor injuriesClosedDehavilland 60GM · Bealeton, VAMay 9, 1971 · N939M · Substantial damageNTSB IAD71FIJ18Accident · Minor injuriesClosedPiper PA-28 · Glen Lyn, VAApr 24, 1971 · N256W · Substantial damageNTSB IAD71FID22Accident · No injuriesClosedCessna 182 · Lively, VAApr 13, 1971 · N3500U · Substantial damageNTSB IAD71FIA17Accident · Minor injuriesClosedLuscombe 8F · Woodbridge, VAApr 7, 1971 · N802B · Substantial damageNTSB IAD71FIJ17Accident · Serious injuriesClosedMooney M20C · Rocky Gap, VAApr 6, 1971 · N6692U · Substantial damageNTSB IAD71DID22Accident · No injuriesClosedPiper PA-22 · Monterey, VAMar 31, 1971 · N5703Z · Substantial damageNTSB IAD71FIJ16Accident · No injuriesClosedCessna 180 · Abingdon, VAMar 23, 1971 · N11JW · Substantial damageNTSB IAD71FIA16Accident · Serious injuriesClosedPiper PA-23 · Upperville, VAMar 20, 1971 · N1318P · DestroyedNTSB IAD71AI043Accident · 1 fatalClosedPiper PA-28 · Basye, VAMar 17, 1971 · N4773L · DestroyedNTSB IAD71FID21Accident · No injuriesClosedCessna 150J · Amelia, VAMar 5, 1971 · N50682 · Substantial damageNTSB IAD71DIA15Accident · No injuriesClosedPiper PA-28 · Quantico, VAFeb 15, 1971 · N4249J · Substantial damageNTSB IAD71DID20Accident · Minor injuriesClosedTaylorcraft BC12-D · Ararat, VAFeb 6, 1971 · N95867 · DestroyedNTSB IAD71AI038Accident · 1 fatalClosedBellanca 14-193 · Jamesville, VAJan 28, 1971 · N8815R · Substantial damage