NTSB investigations, 1964, 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, 1964, 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\") = 1964
    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 UNK65X1128Accident · Minor injuriesClosedPiper PA22 · Piney Point, MDDec 25, 1964 · N5730Z · Substantial damageNTSB UNK65X0984Accident · No injuriesClosedPiper PA22 · Piney Point, MDDec 12, 1964 · N5015Z · Substantial damageNTSB UNK65X0593Accident · No injuriesClosedPiper PA28 · Friendly, MDNov 7, 1964 · N6010W · Substantial damageNTSB UNK65X0487Accident · No injuriesClosedPiper PA22 · Randallstown, MDOct 30, 1964 · N5894Z · Substantial damageNTSB UNK65X0486Accident · Minor injuriesClosedPiper PA17 · College Park, MDOct 30, 1964 · N4844H · Substantial damageNTSB UNK65X0424Accident · No injuriesClosedNo American SNJ5 · Gaithersburg, MDOct 25, 1964 · N8209E · Substantial damageNTSB UNK65X0245Accident · No injuriesClosedMooney M21 · Mitchelville, MDOct 11, 1964 · N1233X · Substantial damageNTSB UNK65X0206Accident · No injuriesClosedPiper PA24 · Snow Hill, MDOct 9, 1964 · N7982P · Substantial damageNTSB UNK64X4212Accident · No injuriesClosedPiper PA22 · Ft Meade, MDSep 30, 1964 · N5780Z · Substantial damageNTSB UNK64X4165Accident · No injuriesClosedBeechcraft M23 · Laytonsville, MDSep 26, 1964 · N23372 · Substantial damageNTSB UNK64X4129Accident · No injuriesClosedBoeing A75 · Parsonsburg, MDSep 24, 1964 · N53488 · Substantial damageNTSB UNK64X4101Accident · No injuriesClosedPiper PA28 · Edgewater, MDSep 22, 1964 · N7747W · Substantial damageNTSB UNK64X4047Accident · Minor injuriesClosedCessna 172 · Hagerstown, MDSep 19, 1964 · N3703S · Substantial damageNTSB UNK64X3805Accident · 1 fatalClosedHomebuilt P-64 · Edgewater, MDSep 5, 1964 · N884Z · DestroyedNTSB UNK64X3769Accident · No injuriesClosedErcoupe 415C · Indian Head, MDSep 4, 1964 · N2166H · Substantial damageNTSB UNK64X3660Accident · No injuriesClosedCessna 180 · Aberdeen, MDAug 29, 1964 · N3122C · Substantial damageNTSB UNK64X3625Accident · No injuriesClosedRyan Navion · Crystal Beach, MDAug 27, 1964 · N4611K · Substantial damageNTSB UNK64X3602Accident · No injuriesClosedCessna 170 · Knoxville, MDAug 26, 1964 · N4046V · Substantial damageNTSB UNK64X3579Incident · No injuriesClosedLockheed L-749A · Baltimore, MDAug 25, 1964 · N6015C · No damageNTSB UNK64X3543Accident · No injuriesClosedBeechcraft A55 · Baltimore, MDAug 22, 1964 · N7501S · Substantial damageNTSB UNK64X3471Accident · No injuriesClosedErcoupe 415C · Westminister, MDAug 19, 1964 · N93406 · Substantial damageNTSB UNK64X3392Accident · No injuriesClosedPiper PA16 · Baltimore, MDAug 15, 1964 · N5928H · Substantial damageNTSB UNK64X3275Accident · No injuriesClosedPiper PA23 · Park Hall, MDAug 8, 1964 · N4946P · Substantial damageNTSB UNK64X3220Accident · No injuriesClosedPiper J3 · Issue, MDAug 5, 1964 · N6993H · Substantial damageNTSB UNK64X3203Accident · 1 fatalClosedPiper PA-30 · Lothian, MDAug 3, 1964 · N7341Y · DestroyedNTSB UNK64X2975Accident · No injuriesClosedPiper PA28 · Baltimore, MDJul 22, 1964 · N7735W · Substantial damageNTSB UNK64X2913Accident · No injuriesClosedCessna 172 · Beltsville, MDJul 19, 1964 · N2434U · Substantial damageNTSB UNK64X2840Accident · Minor injuriesClosedPiper PA11 · Edgewater, MDJul 15, 1964 · N78747 · DestroyedNTSB UNK64X2801Accident · No injuriesClosedBeechcraft D18S · Baltimore, MDJul 13, 1964 · N1812D · Substantial damageNTSB UNK64X2727Accident · No injuriesClosedPiper PA22 · Annapolis, MDJul 9, 1964 · N1429A · Substantial damageNTSB UNK64X2725Accident · Minor injuriesClosedCessna 120 · Laytonsville, MDJul 9, 1964 · N2714N · DestroyedNTSB UNK64X2697Accident · No injuriesClosedPiper PA23 · Ocean City, MDJul 7, 1964 · N3479P · Substantial damageNTSB UNK64X2662Accident · No injuriesClosedCessna 180 · Cockeysville, MDJul 5, 1964 · N3122C · Substantial damageNTSB UNK64X2593Accident · Minor injuriesClosedCessna 172B · Ocean City, MDJul 1, 1964 · N8052X · Substantial damageNTSB UNK64X2477Accident · No injuriesClosedCessna 182 · Severn, MDJun 25, 1964 · N6099B · Substantial damageNTSB UNK64X2413Accident · No injuriesClosedPiper PA22 · Ft Meade, MDJun 21, 1964 · N5780Z · Substantial damageNTSB UNK64X2384Accident · Minor injuriesClosedPiper PA28 · Baltimore, MDJun 20, 1964 · N5647W · Substantial damageNTSB UNK64X2343Accident · No injuriesClosedCont Copter M2 · Gaithersburg, MDJun 17, 1964 · N6590D · Substantial damageNTSB UNK64X2331Accident · No injuriesClosedCessna 182 · Church Hill, MDJun 17, 1964 · N2435G · Substantial damageNTSB UNK64X2283Accident · No injuriesClosedCessna 182 · Westminister, MDJun 14, 1964 · N8680T · DestroyedNTSB UNK64X2218Accident · No injuriesClosedPiper PA22 · Rockville, MDJun 10, 1964 · N3323Z · Substantial damageNTSB UNK64X2174Accident · No injuriesClosedBeechcraft 35 · Beltsville, MDJun 7, 1964 · N5530D · Substantial damageNTSB UNK64X2048Accident · No injuriesClosedAeronca 11AC · Balto Harbor, MDMay 31, 1964 · N86107 · DestroyedNTSB UNK64X1968Accident · No injuriesClosedChampion 402 · Friendly, MDMay 27, 1964 · N9954Y · Substantial damageNTSB UNK64X1844Accident · No injuriesClosedCessna 170B · Gaithersburg, MDMay 19, 1964 · N2730C · DestroyedNTSB UNK64X1801Accident · No injuriesClosedPiper PA25 · Preston, MDMay 17, 1964 · N6079Z · Substantial damageNTSB UNK64X1796Accident · No injuriesClosedPiper PA22 · Woodland Beach, MDMay 17, 1964 · N5510Z · Substantial damageNTSB UNK64X1756Accident · Minor injuriesClosedStinson 108 · Barnesville, MDMay 13, 1964 · N40190 · DestroyedNTSB UNK64X1680Accident · No injuriesClosedPiper PA24 · Laurel, MDMay 9, 1964 · N5574P · Substantial damageNTSB UNK64X1679Accident · No injuriesClosedPiper PA22 · Baltimore, MDMay 9, 1964 · N3315B · Substantial damage