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

Cases per year

19632026
NTSB investigations, 1981, 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\") = 1981
    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 ATL82FIA04Accident · Minor injuriesClosedBellanca 7ECA · Warrenton, VADec 13, 1981 · N88466 · Substantial damageNTSB MIA82FA015Accident · 2 fatalClosedMooney M20F · Richmond, VADec 1, 1981 · N7439V · DestroyedNTSB ATL82FID04Accident · 1 fatalClosedCessna 150 · Chesapeake, VADec 1, 1981 · N19291 · DestroyedNTSB ATL82FA026Accident · 2 fatalClosedBeech A24R · The Plains, VADec 1, 1981 · N8019R · DestroyedNTSB ATL82FIA03Accident · Serious injuriesClosedPiper PA-28 · Pender, VANov 27, 1981 · N3072F · Substantial damageNTSB ATL82FA021Accident · 2 fatalClosedBell 206B · Honaker, VANov 24, 1981 · N500NN · DestroyedNTSB ATL82DID03Accident · No injuriesClosedChampion 7ECA · Virginia Beach, VANov 22, 1981 · N1834G · DestroyedNTSB ATL82AA019Accident · 3 fatalClosedPiper Advcd PAT-1 · Mathews, VANov 19, 1981 · N15PT · DestroyedNTSB ATL82FID02Accident · No injuriesClosedPiper PA600A · Oak Grove, VAOct 25, 1981 · N8208J · Substantial damageNTSB ATL81FIA02Accident · No injuriesClosedPiper J-3 · Leesburg, VAOct 25, 1981 · N4239 · Substantial damageNTSB ATL82DID01Accident · No injuriesClosedBeech 77 · Boones Mill, VAOct 21, 1981 · N6721F · DestroyedNTSB ATL82FA004Accident · 2 fatalClosedPiper PA-32 · Winchester, VAOct 6, 1981 · N8398N · DestroyedNTSB ATL81FIA11Accident · Serious injuriesClosedBede BD-5B · Brandy Station, VASep 27, 1981 · N469HF · Substantial damageNTSB ATL81FIA10Accident · Minor injuriesClosedCessna 150 · Luray, VASep 19, 1981 · N18736 · DestroyedNTSB ATL81FID21Accident · No injuriesClosedBell 47G-2A · Charles City, VASep 11, 1981 · N64690 · Substantial damageNTSB ATL81DID18Accident · No injuriesClosedPiper PA-25 · Carrolton, VASep 11, 1981 · N9558P · Substantial damageNTSB ATL81FID20Accident · 1 fatalClosedPiper PA-25 · Sandston, VASep 5, 1981 · N8633L · DestroyedNTSB ATL81FID17Accident · No injuriesClosedBeech B60 · Danville, VASep 3, 1981 · N1820M · Substantial damageNTSB ATL81FID16Accident · Serious injuriesClosedCessna 188B · Pungo, VAAug 24, 1981 · N731NE · Substantial damageNTSB ATL81FIA09Accident · No injuriesClosedPiper PA-28R · Woodbridge, VAAug 10, 1981 · N2887Q · Substantial damageNTSB ATL82FA107Accident · 2 fatalClosedCessna 182 · Berryville, VAAug 6, 1981 · N58448 · DestroyedNTSB ATL81FIA08Accident · Minor injuriesClosedAeronca 7AC · Woodbridge, VAJul 31, 1981 · N83045 · Substantial damageNTSB ATL81FA103Accident · 3 fatalClosedPiper PA-31T · Richlands, VAJul 29, 1981 · N47CC · DestroyedNTSB ATL81FA081Accident · No injuriesClosedPiper PA-23 · Manassas, VAJun 10, 1981 · N222WB · 2 aircraft · Substantial damageNTSB ATL81FID15Accident · No injuriesClosedPiper PA-28 · Lawrenceville, VAMay 23, 1981 · N7153R · Substantial damageNTSB ATL81FIA07Accident · No injuriesClosedCessna 320 · Culpeper, VAMay 23, 1981 · N9805L · Substantial damageNTSB ATL81IID14Accident · No injuriesClosedPiper PA-28R · Williamsburg, VAMay 5, 1981 · N55546 · Substantial damageNTSB ATL81FIA05Accident · Minor injuriesClosedBellanca 7GCBC · Hartwood, VAMay 3, 1981 · N6HM · Substantial damageNTSB ATL81DID13Accident · No injuriesClosedCessna 305E · Forest, VAMay 3, 1981 · N95495 · Substantial damageNTSB ATL81DIA04Accident · No injuriesClosedGrum Amer AA1A · Culpeper, VAApr 12, 1981 · N81YB · Substantial damageNTSB ATL81FA063Accident · 1 fatalClosedGrumman AA-5 · No.Sandbridge, VAApr 11, 1981 · N28457 · DestroyedNTSB ATL81FA057Accident · 1 fatalClosedAerostar 601P · Roanoke, VAMar 23, 1981 · N3641U · DestroyedNTSB ATL81DID12Accident · Serious injuriesClosedCessna 172N · Northampton Co, VAMar 10, 1981 · N6382E · Substantial damageNTSB ATL81FIA03Accident · No injuriesClosedPiper PA-18 · Warrenton, VAMar 1, 1981 · N87869 · Substantial damageNTSB ATL81FID11Accident · Serious injuriesClosedCessna 172 · Chesapeake, VAFeb 15, 1981 · N9133B · DestroyedNTSB ATL81FIJ03Accident · Serious injuriesClosedPiper PA-28 · Abingdon, VAFeb 14, 1981 · N75318 · Substantial damageNTSB ATL81FA046Accident · Serious injuriesClosedBoeing 737 · Newport News, VAFeb 10, 1981 · N9019V · No damageNTSB DCA81AA008Incident · No injuriesClosedDouglas DC-10 · Leesburg, VAJan 31, 1981 · N143US · Minor damageNTSB ATL81FA042Accident · No injuriesClosedCessna 182Q · Abbingdon, VAJan 30, 1981 · N4798N · Substantial damageNTSB ATL81IA038Incident · No injuriesClosedAvions Mrcl Falcon · Chantilly, VAJan 21, 1981 · N85162 · No damageNTSB ATL81FID10Accident · No injuriesClosedBeech E90 · Chesterfield, VAJan 15, 1981 · N122MM · Substantial damageNTSB ATL81IA033Incident · No injuriesClosedMitsubishi MU-2B · Norfolk, VAJan 6, 1981 · N755Q · Minor damage