NTSB investigations, 1970, MD

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1970, 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\") = 1970
    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 IAD71FIG27Accident · Minor injuriesClosedLuscombe 8A · Laytonsville, MDDec 19, 1970 · N45526 · DestroyedNTSB IAD71FIG23Accident · No injuriesClosedCessna 150 · White Marsh, MDDec 7, 1970 · N5114G · Substantial damageNTSB IAD71FIG22Accident · Minor injuriesClosedCessna 172K · Baltimore, MDDec 4, 1970 · N78437 · Substantial damageNTSB IAD71FIG21Accident · Minor injuriesClosedCessna 172 · Reistertown, MDNov 14, 1970 · N1174F · Substantial damageNTSB IAD71FIG19Accident · No injuriesClosedPiper J-3 · College Park, MDNov 7, 1970 · N1399V · Substantial damageNTSB IAD71AI017Accident · 4 fatalClosedBeech A23-24 · Ocean City, MDOct 24, 1970 · N7955L · DestroyedNTSB IAD71FIG16Accident · No injuriesClosedCessna 310 · Frienship Arpt, MDSep 21, 1970 · N670R · Substantial damageNTSB IAD71FIG15Accident · No injuriesClosedCessna 175 · Edgewater, MDSep 21, 1970 · N7417M · Substantial damageNTSB IAD71FIA08Accident · No injuriesClosedPiper PA-32 · Rose Haven, MDSep 3, 1970 · N3398W · Substantial damageNTSB IAD71FIG10Accident · No injuriesClosedPiper PA-28 · Chestertown, MDAug 31, 1970 · N6455J · Substantial damageNTSB IAD71FIG12Accident · No injuriesClosedCessna 195B · Stevensville, MDAug 30, 1970 · N3015B · Substantial damageNTSB IAD71DIG11Accident · No injuriesClosedPiper PA-28 · Fallston, MDAug 30, 1970 · N8047N · Substantial damageNTSB IAD71FIG14Accident · No injuriesClosedCessna 210 · Churchville, MDAug 26, 1970 · N7366E · Substantial damageNTSB IAD71FIG08Accident · Serious injuriesClosedLuscombe 8A · Frederick, MDAug 23, 1970 · N71478 · DestroyedNTSB IAD71FIG09Accident · No injuriesClosedCessna 170B · Taneytown, MDAug 21, 1970 · N1648D · DestroyedNTSB IAD71FIG07Accident · No injuriesClosedPiper PA-23 · Friendshp Arpt, MDAug 13, 1970 · N3325P · Substantial damageNTSB IAD71FIG13Accident · No injuriesClosedPiper PA-24 · Edgewater, MDAug 10, 1970 · N6558P · Substantial damageNTSB IAD71FIA02Accident · No injuriesClosedCessna 177 · Clinton, MDAug 4, 1970 · N2978X · Substantial damageNTSB IAD71FIG06Accident · Serious injuriesClosedErco 415-C · Cumberland, MDAug 2, 1970 · N2154H · Substantial damageNTSB IAD71FIG05Accident · No injuriesClosedBeech A23-19 · Whiteford, MDAug 1, 1970 · N6902Q · Substantial damageNTSB IAD71FIA01Accident · No injuriesClosedCessna 172D · Lothian, MDJul 23, 1970 · N2383U · Substantial damageNTSB IAD71AI006Accident · 2 fatalClosedPiper PA-18 · Clear Spring, MDJul 18, 1970 · N341T · DestroyedNTSB IAD71FIG03Accident · Minor injuriesClosedPiper PA-22 · Sykesville, MDJul 11, 1970 · N4522Z · Substantial damageNTSB IAD71FIG02Accident · Serious injuriesClosedPiper PA-28 · Sykesville, MDJul 2, 1970 · N8009N · Substantial damageNTSB IAD70AI063Accident · No injuriesClosedBeech 99 · Hagerstown, MDJun 17, 1970 · N7899R · Substantial damageNTSB IAD70FIG18Accident · Minor injuriesClosedTaylorcraft DCO-65 · Cumberland, MDJun 11, 1970 · N46113 · DestroyedNTSB IAD71FIG17Accident · No injuriesClosedFairchild M-62C · Baltimore, MDMay 24, 1970 · N52020 · Substantial damageNTSB IAD70DIG19Accident · No injuriesClosedChampion L-16 · Davidsonville, MDMay 24, 1970 · N3948A · Substantial damageNTSB IAD70FIG16Accident · No injuriesClosedMooney M20E · Mitchellville, MDMay 12, 1970 · N1988Y · Substantial damageNTSB IAD70DIG15Accident · No injuriesClosedErco 415-C · College Park, MDMay 2, 1970 · N2237H · Substantial damageNTSB IAD70FIA13Accident · Serious injuriesClosedPiper PA-23 · Clinton, MDApr 30, 1970 · N2045P · Substantial damageNTSB IAD70AI059Accident · 2 fatalClosedPiper PA-28 · Frederick, MDApr 25, 1970 · N5113G · DestroyedNTSB IAD70DIG14Accident · No injuriesClosedCessna 172 · Friendsville, MDApr 19, 1970 · N1324F · Substantial damageNTSB NYC70FHG05Accident · No injuriesClosedPiper PA-28 · Woodland Beach, MDApr 12, 1970 · N5336L · Substantial damageNTSB IAD70FIA09Accident · Serious injuriesClosedPiper PA-24 · Lusby, MDApr 12, 1970 · N8188P · DestroyedNTSB IAD70DIG13Accident · No injuriesClosedEnstrom F-28A · Silver Springs, MDApr 10, 1970 · N4886 · Substantial damageNTSB IAD70FIG12Accident · No injuriesClosedAero Comdr 100 · Friendshp Arpt, MDApr 5, 1970 · N5533M · Substantial damageNTSB IAD70AI054Accident · 3 fatalClosedPiper PA-32 · Cambridge, MDApr 2, 1970 · N3241W · DestroyedNTSB IAD70DIA10Accident · No injuriesClosedPiper PA-24 · Accokeek, MDMar 31, 1970 · N5038P · Substantial damageNTSB IAD70FIG09Accident · Minor injuriesClosedCessna 150G · Hagerstown, MDMar 17, 1970 · N4678X · DestroyedNTSB IAD70DIG11Accident · No injuriesClosedAero Comdr 100 · Centreville, MDMar 14, 1970 · N3783X · Substantial damageNTSB IAD70DIG10Accident · No injuriesClosedCallair A-9 · Massey, MDMar 12, 1970 · N7220V · Substantial damageNTSB IAD70FIG07Accident · No injuriesClosedPiper PA-28 · Laurel, MDMar 8, 1970 · N9624W · Substantial damageNTSB IAD70FI608Accident · No injuriesClosedCessna 182 · Ridgely, MDMar 8, 1970 · N8862X · Substantial damageNTSB IAD70DIA06Accident · Minor injuriesClosedPiper PA-28 · Clinton, MDMar 7, 1970 · N4225J · Substantial damageNTSB IAD70FIG06Accident · No injuriesClosedCessna 120 · Gaithersburg, MDMar 2, 1970 · N76478 · Substantial damageNTSB IAD70FIG05Accident · No injuriesClosedCessna 170B · Friendship Apt, MDFeb 12, 1970 · N3244A · Substantial damageNTSB IAD70FIA03Accident · 1 fatalClosedCessna 172K · Chesapeake Bch, MDFeb 7, 1970 · N84262 · Substantial damageNTSB IAD70AI04IAccident · Serious injuriesClosedHiller Acft FH1100 · Bowie, MDFeb 2, 1970 · N371FH · Substantial damageNTSB IAD70FIA04Accident · 2 fatalClosedH.O.Beckett T-18 · Helen, MDJan 31, 1970 · N829Z · Substantial damage