NTSB investigations, 1967, 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, 1967, 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\") = 1967
    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 DIA68D0143Accident · No injuriesClosedCessna 150G · Crewe, VADec 31, 1967 · N8535J · Substantial damageNTSB DIA68D0196Accident · No injuriesClosedCessna 310 · Grundy, VADec 29, 1967 · N2615C · Substantial damageNTSB DIA68D0141Accident · No injuriesClosedLuscombe 8A · Melfa, VADec 23, 1967 · N72039 · Substantial damageNTSB DIA68A0027Accident · No injuriesClosedSikorsky H-19G · Lebanon, VADec 21, 1967 · N1562 · Substantial damageNTSB DIA68A0025Accident · 2 fatalClosedCessna 310F · Norfolk, VADec 5, 1967 · N6704X · DestroyedNTSB DIA68F0122Accident · No injuriesClosedCessna 310 · Sandston, VANov 26, 1967 · N3762D · Substantial damageNTSB DIA68A0023Incident · 1 fatalClosedBensen B8MWBH · Stafford, VANov 26, 1967 · N2129 · Substantial damageNTSB DIA68D0123Accident · No injuriesClosedSierradyne S-1 · Langley Afb, VANov 24, 1967 · N12K · Substantial damageNTSB DIA68A0022Accident · Serious injuriesClosedPiper PA-23 · Sandston, VANov 24, 1967 · N6106Y · DestroyedNTSB DIA68F0129Accident · Minor injuriesClosedBeech 35 · Ringgold, VANov 20, 1967 · N2774V · DestroyedNTSB DIA68D0117Accident · Minor injuriesClosedCessna 150 · Basye, VAOct 29, 1967 · N7842Z · Substantial damageNTSB DIA68A0017Accident · 3 fatalClosedNavion A · Lynchburg, VAOct 29, 1967 · N999P · DestroyedNTSB DIA68D0115Accident · No injuriesClosedCessna 150G · Basye, VAOct 24, 1967 · N3711J · Substantial damageNTSB DIA68D0100Accident · No injuriesClosedBeech 23 · Winchester, VAOct 20, 1967 · N2395J · Substantial damageNTSB DIA68F0097Accident · No injuriesClosedLuscombe 8A · Richmond, VAOct 9, 1967 · N1378K · Substantial damageNTSB DIA68D0153Accident · No injuriesClosedAeronca 11AC · Marion, VAOct 7, 1967 · N9450E · Substantial damageNTSB DIA68D0125Accident · No injuriesClosedPiper PA-22 · Boston, VAOct 6, 1967 · N2920P · Substantial damageNTSB DIA68D0086Accident · No injuriesClosedErco 415-C · Cartersville, VAOct 6, 1967 · N99538 · Substantial damageNTSB DIA68D0091Accident · No injuriesClosedPiper PA-20 · Oyster, VAOct 4, 1967 · N2247A · Substantial damageNTSB DIA68D0080Accident · No injuriesClosedCessna 150 · New Kent, VAOct 3, 1967 · N6287S · Substantial damageNTSB DIA68A0014Accident · 2 fatalClosedCessna 150G · Fincastle, VAOct 2, 1967 · N8665J · DestroyedNTSB DIA68F0092Accident · No injuriesClosedBeech 35-B33 · Weyers Cave, VASep 25, 1967 · N8956M · Substantial damageNTSB DIA68D0073Accident · No injuriesClosedCessna 337 · Roanoke, VASep 25, 1967 · N2314S · Substantial damageNTSB DIA68F0081Accident · No injuriesClosedPiper J-3C · Va.Beach, VASep 19, 1967 · N70684 · Substantial damageNTSB DIA68D0114Accident · No injuriesClosedPiper J4A · Jeffersonton, VASep 3, 1967 · N24850 · Substantial damageNTSB DIA68D0065Accident · No injuriesClosedCessna 195 · Richmond, VAAug 30, 1967 · N4415C · Substantial damageNTSB DIA68A0010Accident · 2 fatalClosedCessna 182 · Tangier, VAAug 28, 1967 · N3546U · 2 aircraft · DestroyedNTSB UNK67X0150Accident · No injuriesClosedPiper PA-25 · Cross Junction, VAAug 24, 1967 · XB-BIY · Substantial damageNTSB DIA68D0058Accident · No injuriesClosedPiper PA-28 · Chesapeake, VAAug 2, 1967 · N4115J · Substantial damageNTSB DIA68F0049Accident · No injuriesClosedNavion C · Roanoke, VAJul 29, 1967 · N3972A · Substantial damageNTSB DIA68A0004Accident · Serious injuriesClosedCessna 140 · Baileys Crsrds, VAJul 27, 1967 · N76124 · Substantial damageNTSB DIA68D0043Accident · Minor injuriesClosedGoodyear FG-1D · Norfolk, VAJul 15, 1967 · N448AG · Substantial damageNTSB DIA68F0035Accident · Minor injuriesClosedCessna 172G · Virginia Beach, VAJul 6, 1967 · N5759R · Substantial damageNTSB DIA68D0031Accident · No injuriesClosedPiper PA-28 · Bowling Green, VAJul 4, 1967 · N9710W · Substantial damageNTSB DIA68D0042Accident · No injuriesClosedStits SA-3 · Staunton, VAJun 24, 1967 · N7798C · Substantial damageNTSB DIA67A0023Accident · 1 fatalClosedCessna 185 · Etlan, VAJun 22, 1967 · N4002Y · DestroyedNTSB DIA68D0025Accident · No injuriesClosedPiper PA-18 · Brookneal, VAJun 21, 1967 · N7693D · Substantial damageNTSB DIA68F0005Accident · No injuriesClosedCessna 182 · Quinton, VAJun 3, 1967 · N6257A · Substantial damageNTSB DIA68D0014Accident · No injuriesClosedCessna 172 · Breaks, VAMay 26, 1967 · N3714R · Substantial damageNTSB DIA67F0112Accident · No injuriesClosedPitcairn PA-5 · Fredericksburg, VAMay 25, 1967 · N3835 · Substantial damageNTSB DIA67F0015Accident · No injuriesClosedPiper PA-28 · Sandston, VAMay 25, 1967 · N6155W · Substantial damageNTSB DIA67D0113Accident · No injuriesClosedPiper PA-32 · Lynchburg, VAMay 24, 1967 · N3613W · Substantial damageNTSB DIA67F0110Accident · No injuriesClosedCessna 150G · Sandston, VAMay 23, 1967 · N4629X · Substantial damageNTSB DIA67D0108Accident · No injuriesClosedCessna 172 · Fork Union, VAMay 16, 1967 · N2776L · Substantial damageNTSB DIA68F0036Accident · Serious injuriesClosedPiper PA-28 · Haymarket, VAMay 14, 1967 · N7193W · Substantial damageNTSB DIA67A0017Accident · 4 fatalClosedCessna 205 · New Castle, VAMay 4, 1967 · N1301G · DestroyedNTSB DIA67F0082Accident · Minor injuriesClosedPiper PA-24 · Alexandria, VAMay 1, 1967 · N7566P · Substantial damageNTSB DIA68F0066Accident · No injuriesClosedCessna 150 · Woodbridge, VAApr 30, 1967 · N7007X · Substantial damageNTSB DIA67D0087Accident · No injuriesClosedAeronca 7AC · Pennington Gap, VAApr 26, 1967 · N83762 · Substantial damageNTSB DIA67F0086Accident · No injuriesClosedBeech 95 · Richmond, VAApr 24, 1967 · N667T · Substantial damage