NTSB investigations, 1973, MD

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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

19622026
NTSB investigations, 1973, MD per year, 1962–2026: 1,679 cases
19622
19631
196476
196581
196668
196772
196852
196969
197056
197139
197236
197335
197435
197532
197640
197741
197831
197929
198025
198122
198229
198334
198428
198530
198626
198732
198825
198933
199029
199121
199225
199316
199418
199524
199627
199725
199820
199924
200018
200119
200212
200312
200411
200511
200619
200713
200820
200913
201021
201123
201210
201315
201413
201520
201610
201714
201812
201917
202012
202110
202217
20238
20247
20255
20269

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\" = 'MD' 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 IAD74AI036Accident · 1 fatalClosedBeech D95A · Hagerstown, MDDec 27, 1973 · N8566M · DestroyedNTSB IAD74FIG18Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDDec 15, 1973 · N5663Z · Substantial damageNTSB IAD74FIG16Accident · Serious injuriesClosedCessna 150 · Laurel, MDDec 4, 1973 · N19327 · Substantial damageNTSB IAD74FIG15Accident · No injuriesClosedPiper PA-28 · Frederick, MDDec 2, 1973 · N9185W · Substantial damageNTSB IAD74FIG14Accident · 1 fatalClosedVolksplane VP-1 · Uniontown, MDNov 23, 1973 · N47244 · Substantial damageNTSB IAD74FIG13Accident · No injuriesClosedPiper PA-24 · Aldino, MDNov 13, 1973 · N6970P · Substantial damageNTSB IAD74FIG11Accident · No injuriesClosedCessna 337F · Preston, MDSep 25, 1973 · N8922M · Substantial damageNTSB IAD74FIG10Accident · No injuriesClosedPiper J-3 · College Park, MDSep 23, 1973 · N38004 · Substantial damageNTSB IAD74AI017Accident · 2 fatalClosedBell 206A · Beltsville, MDSep 18, 1973 · N6294N · DestroyedNTSB IAD74FIG08Accident · Serious injuriesClosedLake 4-200 · Betterton, MDSep 2, 1973 · N39365 · DestroyedNTSB IAD74AI012Accident · Serious injuriesClosedBritish AC 1-11 · Baltimore, MDAug 15, 1973 · N136J · No damageNTSB IAD74FIG07Accident · No injuriesClosedPiper PA-24 · Edgewater, MDAug 13, 1973 · N9209P · Substantial damageNTSB IAD74AI010Accident · No injuriesClosedPiper PA-28R · Churchville, MDAug 13, 1973 · N56086 · 2 aircraft · Substantial damageNTSB IAD74FIA02Accident · No injuriesClosedPiper PA-22 · Brandywine, MDAug 11, 1973 · N3939P · Substantial damageNTSB IAD74FIA03Accident · No injuriesClosedPiper PA-28 · Newburg, MDAug 10, 1973 · N9096J · Substantial damageNTSB IAD74II009Incident · No injuriesClosedBeech D95A · Sparks, MDAug 8, 1973 · N6141V · 2 aircraft · Minor damageNTSB IAD74FIG06Accident · Minor injuriesClosedBell 47G-5 · Berlin, MDAug 4, 1973 · N1468W · Substantial damageNTSB IAD74FIG04Accident · Minor injuriesClosedCessna 150K · Edgewater, MDJul 27, 1973 · N6476G · Substantial damageNTSB IAD74FIG03Accident · Serious injuriesClosedPiper PA-28 · Middletown, MDJul 14, 1973 · N8333R · Substantial damageNTSB IAD74FIG02Accident · No injuriesClosedBrewster FLEET7 · Gaithersburg, MDJul 14, 1973 · N9433 · Substantial damageNTSB IAD74AI003Accident · No injuriesClosedLuscombe 8E · Pasadena, MDJul 8, 1973 · N1800K · 2 aircraft · Minor damageNTSB IAD74FIG01Accident · Minor injuriesClosedAmer Avco AA1 · Stevensville, MDJul 4, 1973 · N5787L · Substantial damageNTSB IAD73AI019Accident · Serious injuriesClosedPiper PA-30B · Cordova, MDJun 26, 1973 · N8005Y · DestroyedNTSB IAD73DIG28Accident · Minor injuriesClosedPiper PA-24 · Westminster, MDJun 15, 1973 · N8385P · Substantial damageNTSB IAD73FIG27Accident · No injuriesClosedPiper PA-24 · Baltimore, MDJun 4, 1973 · N8975P · Substantial damageNTSB IAD73FIA15Accident · No injuriesClosedFleet 2 · Huntington, MDMay 12, 1973 · N678M · Substantial damageNTSB IAD73FIG25Accident · No injuriesClosedCessna 172A · Essex, MDMay 6, 1973 · N7706T · Substantial damageNTSB IAD73FIG24Accident · No injuriesClosedCessna 195 · Federalsburg, MDApr 25, 1973 · N1593D · Substantial damageNTSB IAD73AI014Accident · 1 fatalClosedPiper PA-23 · Cumberland, MDApr 24, 1973 · N5557Y · DestroyedNTSB IAD73FIG22Accident · No injuriesClosedCessna 182P · Laurel, MDApr 11, 1973 · N79459 · Substantial damageNTSB IAD73FIG23Accident · No injuriesClosedCessna 182M · Stevensville, MDApr 6, 1973 · N91604 · Substantial damageNTSB IAD73DIG21Accident · No injuriesClosedCessna 150K · Salisbury, MDMar 17, 1973 · N6093G · Substantial damageNTSB NYC73AN101Accident · Serious injuriesClosedPiper PA-22 · Edgewater, MDJan 13, 1973 · N5483Z · 2 aircraft · DestroyedNTSB NYC73IN099Incident · No injuriesClosedDouglas DC-9 · Baltimore, MDJan 8, 1973 · N1291L · Minor damageNTSB NYC73AN096Accident · 3 fatalClosedMooney M20F · Elkton, MDJan 4, 1973 · N9570M · Destroyed