NTSB investigations, 1969, MD

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

19622026
NTSB investigations, 1969, 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\") = 1969
    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 IAD70A0036Accident · No injuriesClosedBeech D18S · Friendship Apt, MDDec 31, 1969 · N80385 · Substantial damageNTSB IAD70F0126Accident · No injuriesClosedAero Comdr 680-FL · Gaithersburg, MDDec 18, 1969 · N6302U · Substantial damageNTSB IAD70A0035Accident · No injuriesClosedNihon YS11-A · Baltimore, MDDec 18, 1969 · N218P · No damageNTSB IAD70D0116Accident · No injuriesClosedPiper PA-28 · Clinton, MDDec 11, 1969 · N9879W · Substantial damageNTSB IAD70F0115Accident · No injuriesClosedCessna 421A · Friendshp Arpt, MDDec 1, 1969 · N540JM · Substantial damageNTSB IAD70F0120Accident · 1 fatalClosedPiper PA-28 · Rohrersville, MDNov 29, 1969 · N7204F · DestroyedNTSB IAD70F0118Accident · No injuriesClosedBeech A23-24 · White Marsh, MDNov 23, 1969 · N3699Q · Substantial damageNTSB IAD70F0111Accident · No injuriesClosedPiper PA-20 · Gaithersburg, MDNov 23, 1969 · N7002K · Substantial damageNTSB IAD70D0110Accident · No injuriesClosedChampion 7KCAB · Churchton, MDNov 16, 1969 · N5084X · Substantial damageNTSB IAD70D0105Accident · No injuriesClosedCessna 150 · Clinton, MDNov 8, 1969 · N3833J · Substantial damageNTSB IAD70A0030Accident · 2 fatalClosedCessna 172G · Accident, MDNov 7, 1969 · N5765R · DestroyedNTSB IAD70D0090Accident · Minor injuriesClosedPiper PA-22 · Andrews Afb, MDOct 19, 1969 · N7026D · Substantial damageNTSB IAD70D0087Accident · No injuriesClosedAeronca S-7CCM · Annapolis, MDOct 12, 1969 · N2398E · Substantial damageNTSB IAD70A0026Accident · 2 fatalClosedMooney M20A · Hyattstown, MDOct 11, 1969 · N8317E · DestroyedNTSB IAD70D0186Accident · No injuriesClosedPiper PA-28 · White Marsh, MDOct 4, 1969 · N8790W · Substantial damageNTSB IAD70A0023Accident · 4 fatalClosedFairchild 24 · Pomfret, MDSep 28, 1969 · N46340 · DestroyedNTSB IAD70D0070Accident · No injuriesClosedCessna 172 · Nanjemoy, MDSep 23, 1969 · N5642R · Substantial damageNTSB IAD70A0021Accident · 2 fatalClosedPiper PA-28 · Edgewater, MDSep 23, 1969 · N4204J · 2 aircraft · Minor damageNTSB IAD70D0076Accident · No injuriesClosedBeech D50C · Gaithersberg, MDSep 11, 1969 · N793A · Substantial damageNTSB IAD70D0004Accident · No injuriesClosedBeech 35 · Park Hall, MDSep 9, 1969 · N3952C · Substantial damageNTSB IAD70F006MAccident · Serious injuriesClosedBeech B23 · Maryland Line, MDAug 27, 1969 · N2377W · DestroyedNTSB IAD70F0064Accident · No injuriesClosedCessna 150F · Crisfield, MDAug 16, 1969 · N8303G · Substantial damageNTSB DIA70D0043Accident · No injuriesClosedPiper PA-22 · Mitchellville, MDAug 3, 1969 · N3630Z · Substantial damageNTSB IAD70F0046Accident · Serious injuriesClosedPiper PA-32 · Salisbury, MDAug 2, 1969 · N3257W · DestroyedNTSB DIA70F0045Accident · No injuriesClosedPiper PA-24 · Friendshp Arpt, MDAug 1, 1969 · N8375P · Substantial damageNTSB IAD70D0044Accident · No injuriesClosedPiper PA-22 · Park Hall, MDJul 22, 1969 · N5730Z · Substantial damageNTSB IAD70A0005Accident · 1 fatalClosedBeech 35-E33 · Jarrettsville, MDJul 20, 1969 · N8366N · DestroyedNTSB IAD70A0003Accident · No injuriesClosedBeech 95-B55 · Friendshp Arpt, MDJul 17, 1969 · N5621K · Substantial damageNTSB DIA70D0024Accident · No injuriesClosedPiper PA-22 · Stevensville, MDJul 11, 1969 · N5948Z · Substantial damageNTSB DIA70D0018Accident · Minor injuriesClosedCessna 177 · Darnestown, MDJun 28, 1969 · N3140T · Substantial damageNTSB DIA70F0017Accident · No injuriesClosedCessna 172 · Grantsville, MDJun 26, 1969 · N4196L · Substantial damageNTSB DIA70F0027Accident · Serious injuriesClosedPiper J3C-65 · Cambridge, MDJun 22, 1969 · N1533N · DestroyedNTSB DIA70D0016Accident · No injuriesClosedCessna 182 · Stevensville, MDJun 22, 1969 · N6481A · Substantial damageNTSB DIA70F0023Accident · No injuriesClosedPiper PA-24 · Laytonsville, MDJun 18, 1969 · N7181P · Substantial damageNTSB DIA70F0002Accident · Minor injuriesClosedCessna 172E · Laurel, MDMay 29, 1969 · N3885S · Substantial damageNTSB DIA69F0207Accident · No injuriesClosedPiper PA-28 · Gaithersburg, MDMay 10, 1969 · N7705W · Substantial damageNTSB DIA69D0204Accident · No injuriesClosedPiper PA-28 · College Park, MDMay 10, 1969 · N6337W · Substantial damageNTSB DIA69F0196Accident · No injuriesClosedCessna 177 · Gaithersburg, MDMay 2, 1969 · N29562 · Substantial damageNTSB DIA69A0061Accident · No injuriesClosedLockheed 18 · Gaithersburg, MDMay 2, 1969 · N221P · DestroyedNTSB DIA69F0194Accident · No injuriesClosedPitts SPL SC-1 · Stevensville, MDApr 27, 1969 · N1766 · Substantial damageNTSB DIA69F0193Accident · No injuriesClosedPiper PA-24 · Edgewater, MDApr 26, 1969 · N9281P · Substantial damageNTSB DIA69F0185Accident · No injuriesClosedBell 47G-2A · Mt Savage, MDApr 26, 1969 · N1200W · DestroyedNTSB DIA69D0188Accident · No injuriesClosedPiper PA-28 · Chestertown, MDApr 25, 1969 · N8976W · Substantial damageNTSB DIA69I0058Incident · No injuriesClosedDornier DO-28D · Baltimore, MDApr 23, 1969 · N6012C · Minor damageNTSB DIA69I0057Incident · No injuriesClosedBoeing 707 · Baltimore, MDApr 22, 1969 · N706PA · No damageNTSB IAD69D0179Accident · No injuriesClosedPiper PA-28R · Accokeek, MDApr 19, 1969 · N3975T · Substantial damageNTSB DIA69D0178Accident · No injuriesClosedPiper PA-28 · Clinton, MDApr 19, 1969 · N6077W · Substantial damageNTSB DIA69F0180Accident · Serious injuriesClosedCessna 140 · Ocean City, MDApr 13, 1969 · N2179V · Substantial damageNTSB DIA69F0174Accident · No injuriesClosedPiper PA-28 · Rock Hall, MDApr 9, 1969 · N5113G · Substantial damageNTSB DIA69F0181Accident · No injuriesClosedPiper PA-22 · Westminster, MDApr 7, 1969 · N4522Z · Substantial damage