NTSB investigations, 1973, 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, 1973, 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\") = 1973
    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 IAD74FID24Accident · Minor injuriesClosedCessna 150K · St Stephens C, VADec 15, 1973 · N5703G · Substantial damageNTSB IAD74AI034Accident · 1 fatalClosedPiper PA-23 · Millboro, VADec 11, 1973 · N1905T · DestroyedNTSB IAD74FID23Accident · No injuriesClosedCessna 172C · Moneta, VADec 6, 1973 · N1840Y · Substantial damageNTSB IAD74F1A06Accident · Minor injuriesClosedPiper PA-28 · Manassas, VANov 8, 1973 · N1590J · Substantial damageNTSB IAD74FID22Accident · No injuriesClosedPiper PA-28 · Charlottesvill, VANov 7, 1973 · N7196R · Substantial damageNTSB IAD74FIA07Accident · No injuriesClosedChampion 7GCBC · Bealton, VANov 2, 1973 · N1670G · Substantial damageNTSB IAD74FID21Accident · No injuriesClosedPiper PA-24 · Hopewell, VANov 1, 1973 · N6191P · Substantial damageNTSB IAD74FID19Accident · No injuriesClosedPiper PA-28 · Ashland, VAOct 31, 1973 · N56083 · Substantial damageNTSB IAD74FID20Accident · No injuriesClosedBeech M35B · Waynesboro, VAOct 21, 1973 · N2255K · Substantial damageNTSB IAD74DIJ07Accident · Minor injuriesClosedAeronca 15AC · Covington, VASep 30, 1973 · N1122H · Substantial damageNTSB IAD74DIJ06Accident · Minor injuriesClosedCessna 150 · Dublin, VASep 24, 1973 · N8426G · Substantial damageNTSB IAD74FID16Accident · No injuriesClosedAeronca 7AC · South Hill, VASep 23, 1973 · N2904E · Substantial damageNTSB IAD74DID15Accident · No injuriesClosedBellanca 8KCAB · Charlottesvlle, VASep 23, 1973 · N90975 · Substantial damageNTSB IADMJFID17Accident · Minor injuriesClosedPiper PA-25 · Crewe, VASep 21, 1973 · AN BJN · Substantial damageNTSB IAD74FIA05Accident · No injuriesClosedPiper PA-12 · Front Royal, VASep 16, 1973 · N2547M · Substantial damageNTSB IAD74AI015Accident · 1 fatalClosedBeech B55 · Agusta Springs, VASep 12, 1973 · N1742W · DestroyedNTSB IAD74DIJ05Accident · No injuriesClosedCessna 172 · Austinville, VASep 10, 1973 · N7405A · Substantial damageNTSB IAD74FID14Accident · No injuriesClosedCessna 170B · Eastville, VASep 5, 1973 · N8262A · Substantial damageNTSB IAD74FID13Accident · No injuriesClosedBoeing A75N1 · Clifton Forge, VASep 3, 1973 · N64794 · Substantial damageNTSB IAD74FIA04Accident · No injuriesClosedPiper PA-22 · Harrisonburg, VASep 2, 1973 · N8120D · Substantial damageNTSB IAD74FID12Accident · No injuriesClosedCessna 172B · Ashland, VASep 1, 1973 · N7505X · Substantial damageNTSB IAD74DIJ01Accident · Serious injuriesClosedBell 47-G4 · Nora, VAAug 27, 1973 · N1218W · Substantial damageNTSB IAD74DID10Accident · No injuriesClosedPiper PA-25 · Parksley, VAAug 27, 1973 · N6198Z · Substantial damageNTSB IAD74FID09Accident · Minor injuriesClosedCessna 172G · Ashland, VAAug 13, 1973 · N1164F · Substantial damageNTSB IAD74DID08Accident · Minor injuriesClosedPiper PA-28 · Lexington, VAAug 13, 1973 · N8067W · Substantial damageNTSB IAD74FIA01Accident · No injuriesClosedCessna 172K · Leesburg, VAAug 4, 1973 · N7225G · DestroyedNTSB IAD74FID07Accident · Serious injuriesClosedBeech V35B · Wakefield, VAAug 1, 1973 · N42B · DestroyedNTSB IAD74DIJ04Accident · No injuriesClosedBell 47-G2A · Pulaski, VAJul 30, 1973 · N8484E · Substantial damageNTSB IAD74DID11Accident · No injuriesClosedCessna 172E · Fort Eustis, VAJul 30, 1973 · N4208A · Substantial damageNTSB IAD74FID06Accident · No injuriesClosedErco 415-D · Ashland, VAJul 28, 1973 · N3930H · Substantial damageNTSB IAD74DID05Accident · No injuriesClosedCessna 182 · Fredricksburg, VAJul 27, 1973 · N3393F · Substantial damageNTSB IAD74FID04Accident · Minor injuriesClosedCessna 172K · Charles City, VAJul 21, 1973 · N7159G · Substantial damageNTSB IAD74FID02Accident · No injuriesClosedCessna A188B · Norfolk, VAJul 15, 1973 · N21627 · Substantial damageNTSB IAD74DID03Accident · No injuriesClosedAero Comdr A-9B · Parksley, VAJul 13, 1973 · N7778V · Substantial damageNTSB IAD73FIA17Accident · No injuriesClosedNavion G · West Haymarket, VAJun 30, 1973 · N2428T · Substantial damageNTSB IAD73DID25Accident · No injuriesClosedCessna 172 · Ashland, VAJun 24, 1973 · N20336 · Substantial damageNTSB IAD73FID24Accident · No injuriesClosedCessna 150 · Blacksburg, VAJun 3, 1973 · N4036U · Substantial damageNTSB IAD73FID20Accident · 1 fatalClosedBannick T-100 · Buckingham, VAMay 19, 1973 · N8719E · DestroyedNTSB IAD73FID22Accident · No injuriesClosedHughes 269C · Richmond, VAMay 16, 1973 · N9693F · Substantial damageNTSB IAD73FIA14Accident · No injuriesClosedCessna 172K · Luray, VAMay 5, 1973 · N78484 · Substantial damageNTSB IAD73DID21Accident · No injuriesClosedPiper PA-22 · Chesapeake, VAMay 5, 1973 · N5475Z · Substantial damageNTSB IAD733ID20Accident · No injuriesClosedPiper J3C-65 · Blairs, VAApr 29, 1973 · N70449 · Substantial damageNTSB IAD73FIA16Accident · No injuriesClosedPiper PA-28 · Manassas, VAApr 19, 1973 · N5642U · Substantial damageNTSB IAD73AI011Accident · 2 fatalClosedPiper PA-24 · Orange, VAApr 13, 1973 · N6273P · DestroyedNTSB NYC73AN140Accident · 2 fatalClosedPiper PA-24 · Floyd, VAApr 9, 1973 · N7809P · DestroyedNTSB IAD73DID19Accident · No injuriesClosedCessna 305A · Forest, VAMar 23, 1973 · N5255G · Substantial damageNTSB IAD73AI007Accident · 3 fatalClosedCessna 172E · Montvale, VAMar 16, 1973 · N38006 · DestroyedNTSB IAD73DID18Accident · No injuriesClosedHelio Acft H-250 · Lynchburg, VAMar 10, 1973 · N331X · Substantial damageNTSB NYC73FIA12Accident · No injuriesClosedCessna 172 · Richardsville, VAFeb 21, 1973 · N5149A · DestroyedNTSB NYC73FIA10Accident · No injuriesClosedCessna 150L · Manassas, VAFeb 12, 1973 · N1308Q · Substantial damage