NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 DIA67D0006Accident · No injuriesClosedBeech D35 · Waynesboro, VADec 31, 1966 · N3000V · Substantial damageNTSB DIA67F0016Accident · No injuriesClosedCessna 172 · Richmond, VADec 30, 1966 · N8556U · Substantial damageNTSB NYC67A0095Accident · No injuriesClosedGrumman G-159 · Richmond, VADec 28, 1966 · N908LN · Substantial damageNTSB NYC67D0470Accident · No injuriesClosedCessna 182A · Turbeville, VADec 20, 1966 · N5161D · Substantial damageNTSB DIA67F0011Accident · No injuriesClosedBeech D18S · Ampthill, VADec 18, 1966 · N80361 · Substantial damageNTSB DIA67D0013Accident · No injuriesClosedPiper PA-12 · Lynchburg, VADec 17, 1966 · N3248M · Substantial damageNTSB DIA67D0005Accident · No injuriesClosedPiper PA-28 · Newport News, VADec 17, 1966 · N6438W · Substantial damageNTSB DIA67F0018Accident · Minor injuriesClosedCessna 182E · Stony Point, VADec 12, 1966 · N2994Y · DestroyedNTSB NYC67F0413Accident · No injuriesClosedBeech A23 · Woodbridge, VADec 11, 1966 · N2395W · Substantial damageNTSB DIA67F0001Accident · No injuriesClosedPiper PA-15 · Wakefield, VADec 11, 1966 · N4477H · Substantial damageNTSB NYC67D0412Accident · No injuriesClosedCessna 182J · Warrenton, VADec 2, 1966 · N3360F · DestroyedNTSB NYC67F0380Accident · No injuriesClosedAeronca 7DC · Williamsburg, VADec 1, 1966 · N4486E · Substantial damageNTSB DIA67A0002Accident · No injuriesClosedCessna 310F · Chantilly, VANov 30, 1966 · N6778X · Substantial damageNTSB DIA67A0001Accident · Minor injuriesClosedBrantly 305 · Manassas, VANov 23, 1966 · N2204U · Substantial damageNTSB DIA67F0072Accident · No injuriesClosedCessna 185 · Baileys Xroad, VANov 20, 1966 · N9851X · Substantial damageNTSB NYC67A0081Accident · 3 fatalClosedPiper PA-28 · Crewe, VANov 19, 1966 · N8458W · DestroyedNTSB NYC67D0363Accident · No injuriesClosedAlon A2 · Elk Creek, VANov 6, 1966 · N6593Q · Substantial damageNTSB NYC67D0346Accident · No injuriesClosedCessna 120 · Waynesboro, VANov 5, 1966 · N1805N · Substantial damageNTSB DIA67D0008Accident · No injuriesClosedMorrisey 2150A · New Castle, VAOct 29, 1966 · N5142V · Substantial damageNTSB NYC67F0357Accident · Minor injuriesClosedCessna 150E · Leesburg, VAOct 27, 1966 · N6287T · Substantial damageNTSB NYC67F0344Accident · Serious injuriesClosedPiper PA-12 · Waynesboro, VAOct 23, 1966 · N2890M · Substantial damageNTSB NYC67D0345Accident · No injuriesClosedCessna 150 · South Norfolk, VAOct 23, 1966 · N6829F · Substantial damageNTSB NYC67F0414Accident · No injuriesClosedPiper PA-24 · Baileys Xroads, VAOct 16, 1966 · N6641P · Substantial damageNTSB NYC67F0306Accident · Minor injuriesClosedChampion 7ECA · Quinton, VAOct 16, 1966 · N11076 · Substantial damageNTSB NYC67F0398Incident · 1 fatalClosedPiaggio P136L1 · Sandston, VAOct 10, 1966 · N16160 · No damageNTSB NYC67F0348Accident · Serious injuriesClosedLuscombe 8A · Richmond, VAOct 10, 1966 · N45807 · DestroyedNTSB NYC67A0058Accident · Minor injuriesClosedBensen B8M · Suffolk, VAOct 8, 1966 · N7709G · DestroyedNTSB NYC67F0332Accident · No injuriesClosedPiper PA-23 · Hot Springs, VAOct 2, 1966 · N5366Y · Substantial damageNTSB NYC67D0294Accident · Minor injuriesClosedPiper J3L-65 · Grottoes, VASep 30, 1966 · N38686 · Substantial damageNTSB MIA67A0042Accident · No injuriesClosedConvair 440 · Richmond, VASep 28, 1966 · N9313 · Substantial damageNTSB NYC67A0053Accident · Minor injuriesClosedBell Carson · Richmond, VASep 25, 1966 · N866Z · Substantial damageNTSB NYC67F0303Accident · Minor injuriesClosedCessna 175C · Alton, VASep 24, 1966 · N8316T · Substantial damageNTSB NYC67F0262Accident · No injuriesClosedCessna 172D · Leesburg, VASep 24, 1966 · N2486Y · Substantial damageNTSB NYC67F0240Accident · No injuriesClosedPiper PA-28 · Langley Afb, VASep 12, 1966 · N6577W · Substantial damageNTSB NYC67F0187Accident · No injuriesClosedPiper PA-28 · Sandston, VASep 10, 1966 · N6155W · Substantial damageNTSB NYC67F0203Accident · No injuriesClosedCessna 310C · Alexandria, VASep 5, 1966 · N1729H · Substantial damageNTSB NYC67D0226Accident · No injuriesClosedAeronca 11AC · Marion, VAAug 28, 1966 · N9450E · Substantial damageNTSB NYC67F0340Accident · No injuriesClosedPiper PA-30 · Franklin, VAAug 27, 1966 · N7280Y · Substantial damageNTSB NYC67D0235Accident · Minor injuriesClosedMooney M21 · Monterey, VAAug 27, 1966 · N78876 · DestroyedNTSB NYC67F0227Accident · No injuriesClosedBeech 23 · Newport News, VAAug 26, 1966 · N2315J · Substantial damageNTSB NYC67F0342Accident · No injuriesClosedFairchild M-62 · Gum Spring, VAAug 21, 1966 · N75463 · Substantial damageNTSB NYC67A0031Accident · 2 fatalClosedPiper PA-24 · Buena Vista, VAAug 18, 1966 · N8555P · DestroyedNTSB NYC67F0304Accident · Minor injuriesClosedPiper PA-30 · Chesapeake, VAAug 14, 1966 · N7456Y · DestroyedNTSB NYC67F0178Accident · Minor injuriesClosedCessna 150F · Dillwyn, VAAug 14, 1966 · N8147S · Substantial damageNTSB NYC67F0134Accident · No injuriesClosedCessna 310F · Chantilly, VAAug 13, 1966 · N6778X · Substantial damageNTSB NYC67F0165Accident · No injuriesClosedBeech S35 · Waynesboro, VAJul 29, 1966 · N654AJ · Substantial damageNTSB NYC67F0091Accident · No injuriesClosedBeech M23 · Baileys Crosrd, VAJul 25, 1966 · N2374J · Substantial damageNTSB NYC67A0014Accident · Serious injuriesClosedBell 47G-2A · Kimballton, VAJul 16, 1966 · N1200W · DestroyedNTSB NYC67D0056Accident · No injuriesClosedAlon A-2 · Hopewell, VAJul 9, 1966 · N6506Q · Substantial damageNTSB NYC67A0007Accident · Serious injuriesClosedMartin M-404 · Roanoke, VAJul 9, 1966 · N40446 · Substantial damage