NTSB investigations, 1968, 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, 1968, 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\") = 1968
    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 DIA69D0120Accident · No injuriesClosedPiper PA-30 · Friendship, MDDec 21, 1968 · N8017Y · DestroyedNTSB DIA69D0125Accident · No injuriesClosedAero Comdr 100 · White Marsh, MDNov 29, 1968 · N3742X · Substantial damageNTSB DIA69D0114Accident · No injuriesClosedCessna 150 · Brookeville, MDNov 28, 1968 · N3029J · Substantial damageNTSB DIA69F0112Accident · No injuriesClosedAeronca 7EC · Gaithersburg, MDNov 16, 1968 · N1292H · Substantial damageNTSB DIA69D0100Accident · Minor injuriesClosedPiper PA-28 · Chester, MDNov 1, 1968 · N6543W · Substantial damageNTSB DIA69I0023Incident · No injuriesClosedBoeing 727 · Baltimore, MDOct 24, 1968 · N4616 · No damageNTSB DIA69D0089Accident · No injuriesClosedBeech A23 · Piney Point, MDOct 23, 1968 · N2379Z · Substantial damageNTSB DIA69F0090Accident · No injuriesClosedPiper PA-28 · Linthicum, MDOct 13, 1968 · N6274W · DestroyedNTSB DIA69A0019Accident · 2 fatalClosedPiper PA-28 · Blu Rdge Summt, MDOct 10, 1968 · N4561J · DestroyedNTSB DIA69F0099Accident · No injuriesClosedBeech 65-80 · Friendship, MDOct 8, 1968 · N51025 · Substantial damageNTSB DIA69F0085Accident · No injuriesClosedPiper PA-22 · Cumberland, MDSep 29, 1968 · N8816D · Substantial damageNTSB DIA69D0070Accident · No injuriesClosedCessna 182 · Harmony Hall, MDSep 19, 1968 · N3078F · DestroyedNTSB DIA69D0078Accident · No injuriesClosedBell 47G · Gaithersburg, MDSep 18, 1968 · N616X · Substantial damageNTSB DIA69F0071Accident · No injuriesClosedNavion L-17A · Edgewood, MDSep 15, 1968 · N333P · DestroyedNTSB DIA69A0013Accident · 1 fatalClosedMooney M20E · White Marsh, MDSep 11, 1968 · N79852 · DestroyedNTSB DIA69F0061Accident · No injuriesClosedMooney M20C · Mitchellville, MDSep 2, 1968 · N5808Q · DestroyedNTSB DIA69F0057Accident · No injuriesClosedMooney M21 · Mitchellville, MDSep 2, 1968 · N3360X · Substantial damageNTSB DIA69A0010Accident · 2 fatalClosedCessna 172C · Rock Hall, MDAug 23, 1968 · N1505Y · DestroyedNTSB DIA69A0009Accident · No injuriesClosedBeech C-45G · Cambridge, MDAug 23, 1968 · N115V · Substantial damageNTSB DIA69D0045Accident · No injuriesClosedPiper PA-28 · Mitchellville, MDAug 14, 1968 · N5772W · Substantial damageNTSB DIA69F0059Accident · No injuriesClosedBeech 35-B33 · Ocean City, MDJul 30, 1968 · N1782G · Substantial damageNTSB DIA69F0028Accident · Serious injuriesClosedCessna 150 · Oxon Hill, MDJul 15, 1968 · N4172U · DestroyedNTSB DIA69D0025Accident · No injuriesClosedPiper PA-24 · Ocean City, MDJul 8, 1968 · N8687P · Substantial damageNTSB DIA69F0019Accident · No injuriesClosedN.American SNJ4 · Frederick, MDJul 7, 1968 · N4140A · Substantial damageNTSB DIA69A0001Accident · 1 fatalClosedPiper PA-28 · Chase, MDJul 5, 1968 · N9399J · DestroyedNTSB DIA69F0022Accident · Minor injuriesClosedPiper PA-12 · Ocean City, MDJun 28, 1968 · N7794H · DestroyedNTSB DIA69D0016Accident · No injuriesClosedPiper J-3 · Waldorf, MDJun 23, 1968 · N30589 · Substantial damageNTSB DIA69D0010Accident · No injuriesClosedCessna 150 · Solomons, MDJun 22, 1968 · N7874Z · Substantial damageNTSB DIA69F0007Accident · Minor injuriesClosedPiper PA-22 · Chestertown, MDJun 7, 1968 · N3637Z · Substantial damageNTSB DIA69F0006Accident · No injuriesClosedCessna 150 · Fallston, MDJun 6, 1968 · N23450 · DestroyedNTSB DIA69D0002Accident · No injuriesClosedCessna 182G · Lexington Park, MDMay 30, 1968 · N3170S · Substantial damageNTSB DIA68D0236Accident · Minor injuriesClosedCessna 172 · Sykesville, MDMay 30, 1968 · N7064A · DestroyedNTSB DIA68F0226Accident · Minor injuriesClosedPiper PA-17 · Edgewater, MDMay 18, 1968 · N4844H · DestroyedNTSB DIA68A0049Accident · 4 fatalClosedPiper PA-28 · Myersville, MDMay 15, 1968 · N9215W · DestroyedNTSB DIA68F0229Accident · No injuriesClosedCessna 195 · Gaithersburg, MDMay 12, 1968 · N1565D · Substantial damageNTSB DIA68F0195Accident · Minor injuriesClosedMooney M20C · Mitchellville, MDApr 21, 1968 · N4030N · Substantial damageNTSB DIA68F0213Accident · Minor injuriesClosedPiper PA-22 · Rising Sun, MDApr 20, 1968 · N3611A · Substantial damageNTSB DIA68F0206Accident · Minor injuriesClosedCessna 172 · Queenstown, MDApr 14, 1968 · N6714A · Substantial damageNTSB DIA68F0199Accident · Minor injuriesClosedCessna 182 · Stevensville, MDApr 14, 1968 · N8911T · Substantial damageNTSB DIA68F0207Accident · No injuriesClosedPiper J5A · College Park, MDApr 13, 1968 · N38710 · Substantial damageNTSB DIA68A0040Accident · 2 fatalClosedCessna 150F · Churchville, MDMar 28, 1968 · N8120F · DestroyedNTSB DIA68F0192Accident · Minor injuriesClosedPiper PA-22 · Laurel, MDMar 27, 1968 · N3126Z · Substantial damageNTSB DIA68F0188Accident · No injuriesClosedN American P-51D · Frederick, MDMar 21, 1968 · N3751D · DestroyedNTSB DIA68A0039Accident · 2 fatalClosedHughes 300 · Marlow Heights, MDMar 21, 1968 · N9502F · DestroyedNTSB DIA68F0183Accident · No injuriesClosedErco 415-C · Gaithersburg, MDMar 15, 1968 · N2541H · Substantial damageNTSB DIA68F0176Accident · Minor injuriesClosedPiper PA-22 · Simpsonville, MDMar 9, 1968 · N1411A · Substantial damageNTSB DIA68F0179Accident · Minor injuriesClosedCessna 170B · Friendship Apt, MDMar 2, 1968 · N8055A · DestroyedNTSB DIA68F0168Accident · No injuriesClosedCessna 182 · Friendship Apt, MDFeb 17, 1968 · N8310S · Substantial damageNTSB DIA68F0163Accident · No injuriesClosedPiper PA-24 · Crisfield, MDFeb 6, 1968 · N7009P · Substantial damageNTSB DIA68D0146Accident · Serious injuriesClosedNavion A · Lusby, MDJan 21, 1968 · N91666 · No damage