NTSB investigations, 1967, 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, 1967, 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\") = 1967
    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 DIA68D0133Accident · No injuriesClosedBeech D95A · Salisbury, MDDec 5, 1967 · N5609S · Substantial damageNTSB DIA68F0131Accident · No injuriesClosedPiper PA-22 · Odenton, MDNov 26, 1967 · N5974Z · Substantial damageNTSB DIA68D0126Accident · No injuriesClosedCessna 170 · Laurel, MDNov 18, 1967 · N2541V · Substantial damageNTSB DIA68A0020Accident · 3 fatalClosedPiper PA-18 · Conowingo, MDNov 18, 1967 · N3193Z · DestroyedNTSB DIA68D0119Accident · No injuriesClosedBeech D35 · College Park, MDNov 11, 1967 · N2109D · Substantial damageNTSB DIA68F0098Accident · No injuriesClosedCessna 182J · Clinton, MDOct 26, 1967 · N3512F · Substantial damageNTSB DIA68F0104Accident · No injuriesClosedPiper PA-28 · College Park, MDOct 25, 1967 · N6337W · Substantial damageNTSB DIA68D0116Accident · No injuriesClosedChampion 7KC · Lothian, MDOct 24, 1967 · N2574G · Substantial damageNTSB DIA68D0087Accident · No injuriesClosedPiper PA-28 · Laurel, MDOct 9, 1967 · N9611J · Substantial damageNTSB DIA68D0084Accident · No injuriesClosedWaco RNF · Huntington, MDSep 24, 1967 · N11206 · Substantial damageNTSB DIA68D0085Accident · No injuriesClosedN American P-51 · Frederick, MDSep 16, 1967 · N3751D · Substantial damageNTSB DIA68F0077Accident · Serious injuriesClosedPiper PA-28 · Federalsburg, MDSep 7, 1967 · N6515W · Substantial damageNTSB DIA68D0076Accident · No injuriesClosedPiper PA-24 · Mitchelville, MDSep 1, 1967 · N740W · Substantial damageNTSB DIA68D0071Accident · No injuriesClosedPiper PA-28 · Edgewater, MDAug 29, 1967 · N4156J · 2 aircraft · Substantial damageNTSB DIA68F0072Accident · No injuriesClosedMooney M20E · Friendship Int., MDAug 28, 1967 · N9348M · Substantial damageNTSB DIA68A0008Accident · 1 fatalClosedNavion NAV-A · Maugansville, MDAug 26, 1967 · N8792H · DestroyedNTSB DIA68A0005Accident · No injuriesClosedBeech E18S · Friendship, MDAug 20, 1967 · N39L · Substantial damageNTSB DIA68D0056Accident · No injuriesClosedBeech D18S · Baltimore, MDAug 14, 1967 · N3531B · Substantial damageNTSB DIA68F0059Accident · Minor injuriesClosedCessna 140 · Davidsonville, MDAug 11, 1967 · N76539 · Substantial damageNTSB DIA68F0061Accident · Minor injuriesClosedPiper PA-28 · Laurel, MDAug 9, 1967 · N9399J · Substantial damageNTSB DIA68D0040Accident · No injuriesClosedLuscombe 8E · Edgewater, MDJul 25, 1967 · N1311B · Substantial damageNTSB DIA68D0048Accident · No injuriesClosedPiper PA-28 · Baltimore, MDJul 22, 1967 · N9682W · Substantial damageNTSB DIA68F0057Accident · No injuriesClosedPiper J3L-65 · Fallston, MDJul 16, 1967 · N38118 · DestroyedNTSB DIA68A0001Accident · No injuriesClosedHughes 269B · Silver Spring, MDJul 14, 1967 · N9474F · Substantial damageNTSB DIA68D0037Accident · No injuriesClosedPiper PA-18 · Fort Meade, MDJul 12, 1967 · N1005A · Substantial damageNTSB DIA68F0027Accident · No injuriesClosedCessna 172G · Clinton, MDJul 5, 1967 · N3876L · Substantial damageNTSB DIA68F0026Accident · No injuriesClosedPiper PA-28 · Aberdeen, MDJun 23, 1967 · N6614W · Substantial damageNTSB DIA68F0030Accident · Serious injuriesClosedBoeing A75N1 · Kennedyville, MDJun 21, 1967 · N60700 · DestroyedNTSB DIA67A0022Accident · No injuriesClosedBeech 65 · Baltimore, MDJun 20, 1967 · N3666B · Substantial damageNTSB DIA68F0020Accident · Serious injuriesClosedBeech F35 · Oxon Hill, MDJun 17, 1967 · N4256B · DestroyedNTSB DIA68F0001Accident · No injuriesClosedPiper PA-22 · Mitchelville, MDJun 17, 1967 · N8811C · Substantial damageNTSB DIA68F0024Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDJun 16, 1967 · N3496J · Substantial damageNTSB DIA68D0019Accident · No injuriesClosedErco 415-C · Mitchellville, MDJun 13, 1967 · N94394 · Substantial damageNTSB DIA68F0017Accident · No injuriesClosedBoeing YL-15 · Westminster, MDJun 1, 1967 · N4210A · Substantial damageNTSB DIA68F0002Accident · Minor injuriesClosedCessna 150 · Michellville, MDMay 29, 1967 · N8692S · Substantial damageNTSB DIA67D0111Accident · No injuriesClosedBeech 35C · Cecilton, MDMay 29, 1967 · N822M · Substantial damageNTSB DIA68D0018Accident · No injuriesClosedCessna U206B · Friendship, MDMay 24, 1967 · N3495L · Substantial damageNTSB DIA68F0010Accident · No injuriesClosedBeech 35 · Easton, MDMay 19, 1967 · N4204D · Substantial damageNTSB DIA67D0099Accident · No injuriesClosedPiper PA-24 · Aberdeen, MDMay 19, 1967 · N9006P · Substantial damageNTSB DIA67F0103Accident · Minor injuriesClosedPiper J3C · Cumberland, MDMay 10, 1967 · N22831 · Substantial damageNTSB DIA68D0008Accident · No injuriesClosedPiper PA-28 · Laurel, MDMay 7, 1967 · N6511W · Substantial damageNTSB DIA67A0016Accident · 1 fatalClosedBeech D18S · Baltimore, MDMay 2, 1967 · N44596 · DestroyedNTSB DIA67F0105Accident · No injuriesClosedPiper PA-30 · Baltimore, MDApr 30, 1967 · N7435Y · Substantial damageNTSB DIA67F0094Accident · No injuriesClosedPiper PA-24 · Silesia, MDApr 30, 1967 · N6385P · Substantial damageNTSB DIA67D0083Accident · No injuriesClosedCessna 172 · Cambridge, MDApr 21, 1967 · N1713F · Substantial damageNTSB DIA67D0093Accident · No injuriesClosedCessna 182 · Clinton, MDApr 19, 1967 · N381LA · Substantial damageNTSB DIA67D0090Accident · No injuriesClosedBeech 95-B55 · Gaithersburg, MDApr 17, 1967 · N4314Y · Substantial damageNTSB DIA67F0089Accident · No injuriesClosedBeech H35 · Smithberg, MDApr 16, 1967 · N7970D · DestroyedNTSB DIA67D0078Accident · No injuriesClosedCessna 182 · Clinton, MDApr 12, 1967 · N7172E · Substantial damageNTSB DIA67D0081Accident · No injuriesClosedCessna 172 · Pittsville, MDApr 3, 1967 · N8852B · Substantial damage