NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 NYC66D0448Accident · No injuriesClosedChampion 7GC · Leesburg, VADec 30, 1965 · N8522E · Substantial damageNTSB NYC66F0395Accident · No injuriesClosedPiper PA-24 · Lunenburg, VADec 29, 1965 · N5911Z · Substantial damageNTSB NYC66F0394Accident · No injuriesClosedPiper PA-24 · Richmond, VADec 26, 1965 · N7720P · Substantial damageNTSB NYC66F0458Accident · No injuriesClosedCessna 210 · Chantilly, VADec 24, 1965 · N3922Y · Substantial damageNTSB NYC66A0069Accident · 2 fatalClosedBeech D35 · Louisa, VADec 24, 1965 · N526M · DestroyedNTSB NYC66D0373Accident · No injuriesClosedStinson L-5E · Mechanicsville, VADec 15, 1965 · N3707C · Substantial damageNTSB NYC66F0387Accident · No injuriesClosedCessna 182 · Fork Union, VADec 7, 1965 · N3208U · Substantial damageNTSB NYC66F0536Accident · No injuriesClosedBeechcraft G35 · Roanoke, VANov 28, 1965 · N4428D · Substantial damageNTSB NYC66F0402Accident · No injuriesClosedPiper PA-23 · Leesburg, VANov 24, 1965 · N198MC · Substantial damageNTSB NYC66F0386Accident · Minor injuriesClosedErcoupe 415C · Rustburg, VANov 14, 1965 · N2195H · Substantial damageNTSB NYC66F0378Accident · No injuriesClosedCessna 182 · Portsmouth, VANov 14, 1965 · N2152G · Substantial damageNTSB NYC66A0056Accident · 1 fatalClosedPiper PA-23 · Covington, VANov 12, 1965 · N4970P · DestroyedNTSB NYC66F0356Accident · No injuriesClosedCessna 182E · Petersburg, VANov 3, 1965 · N3336Y · Substantial damageNTSB NYC66F0308Accident · No injuriesClosedErcoupe 415C · South Boston, VAOct 30, 1965 · N2757H · Substantial damageNTSB NYC66F0320Accident · No injuriesClosedPiper PA-18 · Brookneal, VAOct 24, 1965 · N2979Z · Substantial damageNTSB NYC66D0321Accident · No injuriesClosedCessna 172 · Pennington Gap, VAOct 17, 1965 · N2741U · Substantial damageNTSB NYC66A0043Accident · 4 fatalClosedCessna 182 · Chantilly, VAOct 1, 1965 · N2068X · DestroyedNTSB NYC66F0276Accident · No injuriesClosedPiper PA-24 · Martinsville, VASep 26, 1965 · N6335P · Substantial damageNTSB NYC66A0039Accident · Minor injuriesClosedAir & Space 18A · Rocky Mt., VASep 26, 1965 · N6133S · Substantial damageNTSB NYC66F0272Accident · No injuriesClosedPiper PA-28 · Farmville, VASep 19, 1965 · N7818W · Substantial damageNTSB NYC66F0333Accident · No injuriesClosedCessna 150B · Chesapeake, VASep 18, 1965 · N7393X · Substantial damageNTSB NYC66F0271Accident · No injuriesClosedPiper PA-28 · Gloucester, VASep 18, 1965 · N7838W · Substantial damageNTSB NYC66F0268Accident · Minor injuriesClosedBeech 35 · Union Hall, VASep 17, 1965 · N143X · Substantial damageNTSB NYC66F0263Accident · No injuriesClosedStinson 108-2 · Alexandria, VASep 16, 1965 · N9774K · Substantial damageNTSB NYC66A0033Accident · 2 fatalClosedPiper PA-28 · Elkwood, VASep 11, 1965 · N8501W · DestroyedNTSB UNK65X1532Accident · No injuriesClosedPiper PA-22 · Clarksville, VASep 9, 1965 · N964A · Substantial damageNTSB NYC66F0216Accident · No injuriesClosedPiper PA-22 · West Point, VASep 9, 1965 · N5837Z · Substantial damageNTSB NYC66D0179Accident · No injuriesClosedPiper PA-28 · Midlothian, VASep 5, 1965 · N6155W · Substantial damageNTSB NYC66F0224Accident · No injuriesClosedChampion 7ECA · Foxwells, VASep 2, 1965 · N2502F · 2 aircraft · Substantial damageNTSB NYC66F0242Accident · No injuriesClosedBeechcraft F-35 · Richmond, VAAug 30, 1965 · N3343C · Substantial damageNTSB NYC66F0249Accident · Minor injuriesClosedCessna 140 · Victoria, VAAug 28, 1965 · N89491 · Substantial damageNTSB NYC66A0031Accident · 3 fatalClosedPiper PA-24 · Clintwood, VAAug 25, 1965 · N6930P · DestroyedNTSB NYC66F0162Accident · No injuriesClosedPiper PA-28 · Richmond, VAAug 24, 1965 · N7108W · Substantial damageNTSB NYC66D0121Accident · Minor injuriesClosedWren 460 · Pound, VAJul 18, 1965 · N2012X · Substantial damageNTSB NYC66F0085Accident · No injuriesClosedErcoupe 415C · Blacksburg, VAJul 14, 1965 · N93949 · Substantial damageNTSB NYC66D0090Accident · Serious injuriesClosedSchweizer SGU222 · Newcastle, VAJul 5, 1965 · N10330 · Substantial damageNTSB UNK65X1510Accident · No injuriesClosedPiper PA-18 · Martinsville, VAJul 1, 1965 · N4096Z · Substantial damageNTSB NYC65A0154Accident · 1 fatalClosedPiper PA-24 · Winchester, VAJun 26, 1965 · N7360P · Substantial damageNTSB NYC66F0126Accident · Serious injuriesClosedBeechcraft C45H · E.Bigstone Gap, VAJun 22, 1965 · N9522Z · Substantial damageNTSB NYC66F0043Accident · No injuriesClosedCessna 310B · Leesburg, VAJun 20, 1965 · N295C · Substantial damageNTSB NYC65A0151Accident · No injuriesClosedBell 47G-2A · Denbigh, VAJun 19, 1965 · N73961 · No damageNTSB NYC66F0079Accident · No injuriesClosedCessna 182 · Woodbridge, VAJun 18, 1965 · N3772D · Substantial damageNTSB NYC65A0148Accident · 1 fatalClosedPiper PA12 · Cape Charles, VAJun 14, 1965 · N7773H · DestroyedNTSB NYC66D0248Accident · No injuriesClosedCessna 182E · Sandston, VAJun 13, 1965 · N3172Y · Substantial damageNTSB NYC66F0009Accident · No injuriesClosedPiper PA-23 · Manassas, VAJun 4, 1965 · N1215P · Substantial damageNTSB NYC65D0242Accident · Minor injuriesClosedSchemp SH1 · Strasburg, VAMay 31, 1965 · N814Z · Substantial damageNTSB NYC65F0211Accident · No injuriesClosedCessna 182 · Dulles Arpt, VAMay 26, 1965 · N9911B · Substantial damageNTSB NYC66D0039Accident · No injuriesClosedErcoupe 415C · Castlewood, VAMay 25, 1965 · N99638 · DestroyedNTSB NYC66F0006Accident · Minor injuriesClosedCurtiss J1D · Fredericksburg, VAMay 16, 1965 · N532N · Substantial damageNTSB NYC65F0215Accident · No injuriesClosedPiper PA-24 · Leesburg, VAMay 15, 1965 · N7374P · Substantial damage