NTSB investigations, 1964, 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, 1964, 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\") = 1964
    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 UNK65X1031Accident · No injuriesClosedCessna 172 · Middleburg, VADec 16, 1964 · N7790U · Substantial damageNTSB UNK65X0837Incident · No injuriesClosedViscount V745D · Hampton Roads, VANov 25, 1964 · N7454 · Minor damageNTSB UNK65X0808Accident · 1 fatalClosedPiper PA-18 · Chase City, VANov 23, 1964 · N7373D · DestroyedNTSB UNK65X0784Accident · No injuriesClosedGlobe GC-1B · White Sulpr Sp, VANov 22, 1964 · N78110 · DestroyedNTSB UNK65X0756Accident · No injuriesClosedDouglas DC-4 · Norfolk, VANov 19, 1964 · N1437V · Substantial damageNTSB UNK65X0754Accident · No injuriesClosedCessna 172 · Louisa County, VANov 19, 1964 · N7912X · Substantial damageNTSB UNK65X0753Accident · No injuriesClosedPiper PA-22 · Moneta, VANov 18, 1964 · N3713A · Substantial damageNTSB UNK65X0722Accident · Minor injuriesClosedErcoupe 415D · Danville, VANov 15, 1964 · N94674 · Substantial damageNTSB UNK65X0631Accident · No injuriesClosedCessna 150 · Fredericksburg, VANov 9, 1964 · N1199Y · Substantial damageNTSB UNK65X0596Accident · No injuriesClosedLuscombe 8E · Bridgewater, VANov 7, 1964 · N1311B · Substantial damageNTSB UNK65X0595Accident · No injuriesClosedLuscombe 8A · Quinton, VANov 7, 1964 · N25106 · DestroyedNTSB UNK65X0554Accident · No injuriesClosedPiper PA24 · Farmville, VANov 4, 1964 · N6849P · Substantial damageNTSB UNK65X0394Accident · No injuriesClosedPiper PA22 · Roanoke, VAOct 24, 1964 · N4537Z · Substantial damageNTSB UNK65X0256Accident · No injuriesClosedVolaire 10 · Diggs, VAOct 12, 1964 · N6663D · Substantial damageNTSB UNK65X0165Accident · No injuriesClosedBeechcraft F35 · Richmond, VAOct 6, 1964 · N3330C · Substantial damageNTSB UNK64X4186Accident · No injuriesClosedCessna 172 · Quinton, VASep 27, 1964 · N5483T · Substantial damageNTSB UNK64X4105Accident · Serious injuriesClosedViscount V-700 · Springfield, VASep 22, 1964 · N7423 · No damageNTSB UNK64X4056Accident · 3 fatalClosedCulver LCA · Northfield, VASep 19, 1964 · N32487 · DestroyedNTSB UNK64X4048Accident · Minor injuriesClosedMooney M20E · Norfolk, VASep 19, 1964 · N69650 · Substantial damageNTSB UNK64X3985Accident · 3 fatalClosedBeechcraft 35A · Evington, VASep 14, 1964 · N124VW · DestroyedNTSB UNK64X3946Accident · No injuriesClosedGlobe GC1B · Richmond, VASep 12, 1964 · N80639 · Substantial damageNTSB UNK64X3785Accident · No injuriesClosedPiper PA20 · Harrisonburg, VASep 5, 1964 · N7014K · Substantial damageNTSB UNK64X3537Accident · No injuriesClosedCessna 140 · Bridgewater, VAAug 22, 1964 · N72134 · Substantial damageNTSB UNK64X3496Accident · No injuriesClosedCessna 150 · Waynesboro, VAAug 20, 1964 · N7318X · DestroyedNTSB UNK64X3450Accident · 1 fatalClosedPiper PA-28 · Danville, VAAug 18, 1964 · N8740W · DestroyedNTSB UNK64X3378Accident · No injuriesClosedCessna 172C · Williamsburg, VAAug 14, 1964 · N8249X · Substantial damageNTSB UNK64X3375Accident · No injuriesClosedPiper PA28 · Fredericksburg, VAAug 14, 1964 · N5167W · Substantial damageNTSB UNK64X3339Accident · No injuriesClosedChampion 7GC · Leesburg, VAAug 12, 1964 · N8522E · Substantial damageNTSB UNK64X3329Accident · No injuriesClosedPiper PA18 · Glebe Point, VAAug 11, 1964 · N3970A · Substantial damageNTSB UNK64X3288Accident · No injuriesClosedBeechcraft 23 · Richmond, VAAug 9, 1964 · N2349Q · Substantial damageNTSB UNK64X3243Accident · 1 fatalClosedPiper AE-1 · Hurt, VAAug 6, 1964 · N75619 · DestroyedNTSB UNK64X3157Accident · Minor injuriesClosedAeronca L16 · Buffalo, VAAug 1, 1964 · N2044A · DestroyedNTSB UNK64X3128Accident · No injuriesClosedDouglas DC-7 · Chantilly, VAJul 30, 1964 · N464 · Substantial damageNTSB UNK64X3058Accident · 2 fatalClosedForney 415C · Stanardsville, VAJul 26, 1964 · N87002 · DestroyedNTSB UNK64X2979Accident · No injuriesClosedPiper PA28 · Chantilly, VAJul 22, 1964 · N7705W · Substantial damageNTSB UNK64X2903Accident · No injuriesClosedLuscombe 8A · Broadway, VAJul 18, 1964 · N1611K · DestroyedNTSB UNK64X2891Accident · Minor injuriesClosedDouglas DC-7 · Richmond, VAJul 17, 1964 · N809D · Substantial damageNTSB UNK64X2880Accident · Minor injuriesClosedGlobe Swift · Shenandoah, VAJul 17, 1964 · N3330K · Substantial damageNTSB UNK64X2850Accident · Minor injuriesClosedGyrocopter B8M · Amelia, VAJul 15, 1964 · N944Z · DestroyedNTSB UNK64X2816Accident · No injuriesClosedPiper PA22 · Fredericksburg, VAJul 14, 1964 · N3630Z · Substantial damageNTSB UNK64X2707Accident · 5 fatalClosedLockheed 12A · Martinsville, VAJul 7, 1964 · N18946 · DestroyedNTSB UNK64X2700Accident · No injuriesClosedMooney MK20 · Newport News, VAJul 7, 1964 · N5224B · Substantial damageNTSB UNK64X2683Accident · Minor injuriesClosedPiper PA18 · Fredericksburg, VAJul 6, 1964 · N999D · Substantial damageNTSB UNK64X2656Accident · No injuriesClosedCessna 210 · Richmond, VAJul 5, 1964 · N9456X · Substantial damageNTSB UNK64X2544Accident · No injuriesClosedLuscombe 8A · Amelia, VAJun 28, 1964 · N71612 · DestroyedNTSB UNK64X2520Accident · No injuriesClosedStinson V77 · Haymarket, VAJun 27, 1964 · N70086 · Substantial damageNTSB UNK64X2499Accident · No injuriesClosedGlobe Swift GC1B · Leesburg, VAJun 26, 1964 · N77757 · Substantial damageNTSB UNK64X2429Accident · Serious injuriesClosedStinson L-5 · Newcastle, VAJun 21, 1964 · N55592 · DestroyedNTSB UNK64X2259Accident · No injuriesClosedCmnwealth 185 · Kellam Field, VAJun 13, 1964 · N92830 · Substantial damageNTSB UNK64X2254Accident · 1 fatalClosedCessna 180 · Fancy Gap, VAJun 12, 1964 · N3149C · Destroyed