NTSB investigations, 1972, VA

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1972, 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\") = 1972
    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 NYC73AN093Accident · 2 fatalClosedBellanca 14-132 · Blairs, VADec 30, 1972 · N132K · DestroyedNTSB NYC73FIA08Accident · No injuriesClosedEnstrom F-28A · Fairfax, VADec 26, 1972 · N4469 · Substantial damageNTSB NYC73AN085Accident · 2 fatalClosedPiper PA-22 · Newsoms, VADec 19, 1972 · N183A · Substantial damageNTSB NYC73DID15Accident · No injuriesClosedErco 415-C · South Boston, VADec 17, 1972 · N87119 · DestroyedNTSB NYC73FID14Accident · Serious injuriesClosedFairchild FH1100 · Roanoke, VADec 13, 1972 · N30VA · Substantial damageNTSB NYC73DID13Accident · No injuriesClosedCessa 170B · Portsmouth, VADec 3, 1972 · N8129A · Substantial damageNTSB NYC73F1D12Accident · No injuriesClosedEnstrom F-28A · Charlottsville, VANov 28, 1972 · N9569 · Substantial damageNTSB NYC73FIJ11Accident · No injuriesClosedCessna 206D · Dublin, VANov 25, 1972 · N71964 · Substantial damageNTSB NYC73FID11Accident · No injuriesClosedPiper PA-24 · Hopewell, VANov 25, 1972 · N6946P · Substantial damageNTSB NYC73DID10Accident · No injuriesClosedCessna 150 · Amelia, VANov 18, 1972 · N4282U · Substantial damageNTSB NYC73FIJ09Accident · No injuriesClosedCessna 310J · Wise, VANov 11, 1972 · N3139L · DestroyedNTSB NYC73FID09Accident · No injuriesClosedPiper PA-22 · Richmond, VANov 5, 1972 · N3546Z · Substantial damageNTSB MIA73AM037Accident · Serious injuriesClosedBoeing 727 · Norfolk, VASep 30, 1972 · N1631 · Minor damageNTSB NYC73FID08Accident · Minor injuriesClosedCallair A-9 · Melfa, VASep 15, 1972 · N8289H · Substantial damageNTSB NYC73FIA05Accident · No injuriesClosedFairchild PT-23 · Warrenton, VAAug 31, 1972 · N11113 · DestroyedNTSB NYC73DID07Accident · No injuriesClosedPiper PA-28 · Chesapeake, VAAug 27, 1972 · N5578U · Substantial damageNTSB NYC73DIJ02Accident · Minor injuriesClosedBell 47G-2A · Richlands, VAAug 19, 1972 · N8486E · Substantial damageNTSB NYC73AN034Accident · 1 fatalClosedBellanca 17-30A · Abingdon, VAAug 18, 1972 · N6637V · DestroyedNTSB NYC73FID06Accident · No injuriesClosedCessna 182 · Jetersville, VAAug 13, 1972 · N148V · Substantial damageNTSB NYC73FID05Accident · 2 fatalClosedBell 47G-2A · Floyd, VAAug 5, 1972 · N73219 · DestroyedNTSB NYC73AN020Accident · 1 fatalClosedChampion 7KCAB · Windsor, VAJul 30, 1972 · N7564F · DestroyedNTSB NYC73FID03Accident · Minor injuriesClosedPiper PA-25 · Newsoms, VAJul 24, 1972 · N4744Y · Substantial damageNTSB NYC73FIA04Accident · Serious injuriesClosedBellanca 14-19 · Fredericksburg, VAJul 22, 1972 · N8848R · DestroyedNTSB NYC73DID04Accident · No injuriesClosedPiper PA-28 · Fredericksburg, VAJul 22, 1972 · N4355J · Substantial damageNTSB NYC73AN011Accident · 2 fatalClosedAeronca 7AC · Culpeper, VAJul 16, 1972 · N81637 · DestroyedNTSB NYC73FID02Accident · Serious injuriesClosedBeech 95-B55 · Covington, VAJul 13, 1972 · N988GM · DestroyedNTSB NYC73FIA03Accident · No injuriesClosedMaule M4220C · Winchester, VAJul 11, 1972 · N2053U · Substantial damageNTSB NYC73FID01Accident · No injuriesClosedCessna 150K · Chesapeake, VAJul 8, 1972 · N6371G · Substantial damageNTSB NYC73AN006Accident · 1 fatalClosedCessna 150G · Arcola, VAJul 6, 1972 · N8442J · DestroyedNTSB IAD73DIA01Accident · Serious injuriesClosedAmer Avco AA-1A · Syria, VAJul 2, 1972 · N9494L · DestroyedNTSB NYC73DIA02Accident · No injuriesClosedStearman A75N1 · Warrenton, VAJul 1, 1972 · N66442 · Substantial damageNTSB NYC72FIJ43Accident · Minor injuriesClosedBeech D35 · Lebanon, VAJun 29, 1972 · N220X · DestroyedNTSB NYC72DID35Accident · Minor injuriesClosedPiper PA-28 · Ashland, VAJun 18, 1972 · N7148R · Substantial damageNTSB NYC72AN151Accident · 1 fatalClosedPiper PA-22 · Winchester, VAJun 11, 1972 · N2920P · 2 aircraft · Substantial damageNTSB NYC72DID32Accident · No injuriesClosedAlon A2-A · King George, VAJun 4, 1972 · N5464F · Substantial damageNTSB NYC72AN147Accident · 1 fatalClosedLowers R-1 · Sterling, VAJun 3, 1972 · N66AN · 2 aircraft · Minor damageNTSB NYC72FID33Accident · No injuriesClosedMooney M20E · Orange, VAJun 2, 1972 · N5552Q · Substantial damageNTSB NYC72FID31Accident · Minor injuriesClosedAeronca 7AC · Ashland, VAMay 28, 1972 · N1092E · Substantial damageNTSB NYC72FIA23Accident · No injuriesClosedPiper J3C-85 · Chantilly, VAMay 25, 1972 · N30261 · Substantial damageNTSB NYC72DIA22Accident · No injuriesClosedPiper PA-12 · Warrenton, VAMay 19, 1972 · N7599H · Substantial damageNTSB NYC72FID34Accident · No injuriesClosedCessna 150H · Newport News, VAMay 16, 1972 · N22984 · Substantial damageNTSB NYC72DID29Accident · Minor injuriesClosedPitts S-1 · Crewe, VAMay 13, 1972 · N5011 · Substantial damageNTSB NYC72DID28Accident · Minor injuriesClosedBell 47G-2A · Covington, VAMay 9, 1972 · N73264 · Substantial damageNTSB NYC72DID27Accident · No injuriesClosedCessna 172D · Crittenden, VAMay 1, 1972 · N2373U · Substantial damageNTSB NYC72FID25Accident · Minor injuriesClosedCessna 150G · Chesterfield, VAApr 29, 1972 · N2604J · DestroyedNTSB NYC72IN136Incident · Minor injuriesClosedBoeing 720B · Front Royal, VAApr 26, 1972 · N736US · No damageNTSB NYC72FIJ41Accident · 1 fatalClosedSikorsky H-19G · Coeburn, VAApr 24, 1972 · N1562 · DestroyedNTSB NYC72FIA20Accident · No injuriesClosedPiper PA-24 · Manassas, VAApr 19, 1972 · N8104P · Substantial damageNTSB NYC72FID26Accident · Serious injuriesClosedPiper J3C-65 · Bedford, VAApr 16, 1972 · N6878H · Substantial damageNTSB NYC72FIA19Accident · Minor injuriesClosedPiper PA-28R · Mt Clinton, VAApr 2, 1972 · N4572J · Substantial damage