NTSB investigations, 1968, VA

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1968, 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\") = 1968
    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 DIA69D0124Accident · No injuriesClosedPiper PA-28 · Lexington, VADec 22, 1968 · N6577W · Substantial damageNTSB DIA69F0132Accident · Serious injuriesClosedCessna 177 · Waynesboro, VADec 20, 1968 · N3165T · Substantial damageNTSB DIA69F0129Accident · No injuriesClosedPiper PA-24 · Sandston, VADec 18, 1968 · N5379P · Substantial damageNTSB DIA69F0122Accident · No injuriesClosedCessna T337B · Sandston, VADec 16, 1968 · N2400S · Substantial damageNTSB DIA69F0110Accident · Minor injuriesClosedBell 47G-5 · Roanoke, VANov 22, 1968 · N1201W · Substantial damageNTSB DIA69A0027Accident · 2 fatalClosedPiper PA-30 · Damascus, VANov 19, 1968 · N7141Y · DestroyedNTSB DIA69A0025Accident · 1 fatalClosedPiper PA-23 · Charlottesvlle, VANov 18, 1968 · N5943Y · DestroyedNTSB DIA69F0097Accident · No injuriesClosedN American SNJ-5 · Bailey Crosrds, VANov 5, 1968 · N7986C · Substantial damageNTSB DIA69F0105Accident · No injuriesClosedBellanca 17-30 · Mine Run, VANov 4, 1968 · N4772V · Substantial damageNTSB DIA69F0109Accident · No injuriesClosedPiper PA-28 · Fredericksburg, VAOct 27, 1968 · N424AS · Substantial damageNTSB DIA69D0101Accident · No injuriesClosedCessna 172 · Chantilly, VAOct 26, 1968 · N6011R · Substantial damageNTSB DIA69F0096Accident · No injuriesClosedBoeing A75N1 · Chesapeake, VAOct 24, 1968 · N17211 · Substantial damageNTSB DIA69F0094Accident · Serious injuriesClosedCessna 401 · Hopewell, VAOct 24, 1968 · N348E · DestroyedNTSB DIA69F0098Accident · No injuriesClosedCessna 150 · Topping, VAOct 23, 1968 · N8678J · Substantial damageNTSB DIA69A0022Accident · 4 fatalClosedCessna 182J · Front Royal, VAOct 17, 1968 · N3524F · DestroyedNTSB DIA69F0088Accident · No injuriesClosedNavion A · Culpeper, VAOct 12, 1968 · N4216A · Substantial damageNTSB DIA69F0082Accident · No injuriesClosedCarson-Bell 47-G · Sandston, VAOct 8, 1968 · N617X · Substantial damageNTSB DIA69A0017Accident · No injuriesClosedLear Jet 23 · Dulles Itl Apt, VAOct 6, 1968 · N430EJ · Substantial damageNTSB DIA69F0080Accident · No injuriesClosedPiper PA-31 · Fredericksburg, VAOct 3, 1968 · N9054Y · Substantial damageNTSB DIA69D0079Accident · No injuriesClosedBeech S35 · Hot Springs, VAOct 2, 1968 · N6019F · Substantial damageNTSB DIA69D0072Accident · No injuriesClosedMooney M20C · Baileys Xroads, VAOct 2, 1968 · N6770U · Substantial damageNTSB DIA69F0076Accident · No injuriesClosedHughes 269B · Alexandria, VAOct 1, 1968 · N9428F · DestroyedNTSB DIA69I0015Incident · Minor injuriesClosedDouglas DC-6B · Norfolk, VASep 26, 1968 · N37567 · No damageNTSB DIA69F0084Accident · No injuriesClosedPiper PA-28 · Chatham, VASep 20, 1968 · N6324J · Substantial damageNTSB DIA69F0069Accident · No injuriesClosedPiper PA-24 · Richmond, VASep 14, 1968 · N8905P · Substantial damageNTSB DIA69A0012Accident · 2 fatalClosedPiper PA-24 · Rocky Gap, VASep 10, 1968 · N6537P · DestroyedNTSB DIA69D0083Accident · Minor injuriesClosedPiper PA-15 · Grayson County, VASep 7, 1968 · N4542H · Substantial damageNTSB DIA69D0065Accident · No injuriesClosedCessna 182 · Norfolk, VASep 2, 1968 · N4738D · Substantial damageNTSB DIA69D0060Accident · No injuriesClosedSchweizer SGS126 · Leesburg, VAAug 27, 1968 · N5705S · Substantial damageNTSB DIA69D0058Accident · No injuriesClosedPiper PA-28 · Weirwood, VAAug 25, 1968 · N7148R · Substantial damageNTSB DIA69D0064Accident · No injuriesClosedSchwiezer SGS233 · Leesburg, VAAug 24, 1968 · N2440W · Substantial damageNTSB DIA69F0048Accident · No injuriesClosedCessna 195B · Fredericksburg, VAAug 18, 1968 · N3051B · Substantial damageNTSB DIA69F0055Accident · No injuriesClosedPiper PA-24 · Alexandria, VAAug 16, 1968 · N6171P · Substantial damageNTSB DIA69D0047Accident · No injuriesClosedPiper PA-25 · Surry, VAAug 15, 1968 · N4791Y · Substantial damageNTSB DIA69F0044Accident · Minor injuriesClosedPiper PA-28 · Fredericksburg, VAAug 10, 1968 · N1824J · DestroyedNTSB DIA69D0043Accident · No injuriesClosedAeronca 7AC · Leesburg, VAAug 10, 1968 · N1810E · Substantial damageNTSB DIA69A0008Accident · Serious injuriesClosedBoeing 737 · Herndon, VAAug 10, 1968 · N9011U · No damageNTSB DIA69D0041Accident · No injuriesClosedMooney M20C · Culpeper, VAAug 8, 1968 · N9324M · Substantial damageNTSB DIA69A0006Accident · 2 fatalClosedPiper PA-22 · Chesapeake, VAAug 6, 1968 · N5929Z · 2 aircraft · DestroyedNTSB DIA69F0037Accident · No injuriesClosedPiper PA-22 · Earlysville, VAAug 2, 1968 · N7009B · Substantial damageNTSB DIA69A0007Accident · 5 fatalClosedBeech A23-24 · Cana, VAAug 2, 1968 · N4748J · DestroyedNTSB DIA69F0036Accident · No injuriesClosedCessna 172 · Richmond, VAJul 30, 1968 · N7509X · Substantial damageNTSB DIA69F0035Accident · 1 fatalClosedBensen Bowles · Leesburg, VAJul 26, 1968 · N2090 · DestroyedNTSB DIA69A0003Accident · 3 fatalClosedCessna 195 · Stuart, VAJul 19, 1968 · N3054B · DestroyedNTSB DIA69F0034Accident · No injuriesClosedAeronca 7AC · South Hill, VAJul 16, 1968 · N1522E · Substantial damageNTSB DIA69D0033Accident · No injuriesClosedCessna 172 · Warsaw, VAJul 12, 1968 · N7535T · Substantial damageNTSB DIA69A0002Accident · 2 fatalClosedPiper PA-18S · Swords Creek, VAJul 10, 1968 · N3951Z · DestroyedNTSB DIA69F0014Accident · No injuriesClosedErcoupe 415-C · B.Crossroads, VAJul 7, 1968 · N99783 · Substantial damageNTSB DIA69F0046Accident · No injuriesClosedAeronca 7CCM · Abingdon, VAJul 6, 1968 · N83249 · DestroyedNTSB DIA69F0019Accident · No injuriesClosedCessna 170 · Richmond, VAJul 1, 1968 · N2416D · Substantial damage