NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 DIA67F0009Accident · No injuriesClosedLuscombe 8F · Gaithersburg, MDDec 31, 1966 · N802B · Substantial damageNTSB DIA67F0015Accident · No injuriesClosedPiper PA-28 · Frederick, MDDec 30, 1966 · N6496W · Substantial damageNTSB DIA67D0019Accident · No injuriesClosedPiper PA-22 · Laurel, MDDec 27, 1966 · N5413Z · Substantial damageNTSB NYC67A0094Accident · No injuriesClosedBrantly B-2B · Riverdale, MDDec 23, 1966 · N2277U · Substantial damageNTSB DIA67F0003Accident · No injuriesClosedPiper PA-23 · Stevensville, MDDec 18, 1966 · N5472Y · Substantial damageNTSB NYC67A0093Accident · 1 fatalClosedPiper PA-22 · Frederick, MDDec 10, 1966 · N8813D · DestroyedNTSB DIA67F0014Accident · No injuriesClosedPiper PA-28 · Friendship, MDDec 10, 1966 · N7959W · Substantial damageNTSB DIA67D0051Accident · No injuriesClosedBeech G35 · Rising Sun, MDDec 8, 1966 · N4619D · Substantial damageNTSB NYC67F0393Accident · No injuriesClosedBeech G35 · Gaithersburg, MDDec 1, 1966 · N227B · Substantial damageNTSB NYC67D0386Accident · No injuriesClosedPiper PA-23 · Waldorf, MDNov 30, 1966 · N5574Y · Substantial damageNTSB DIA67F0002Accident · Minor injuriesClosedCessna 150F · Hagerstown, MDNov 21, 1966 · N8075S · Substantial damageNTSB NYC67F0352Accident · No injuriesClosedAlon A-2 · Deale, MDNov 13, 1966 · N5616F · Substantial damageNTSB NYC67D0362Accident · No injuriesClosedCessna 150 · Lower Marlboro, MDNov 13, 1966 · N2553J · Substantial damageNTSB DCA67I0008Incident · No injuriesClosedLockheed 1049G · Andrews Afb, MDOct 26, 1966 · N6204G · No damageNTSB NYC67F0315Accident · No injuriesClosedCessna 210E · Newburg, MDOct 16, 1966 · N4974U · Substantial damageNTSB NYC67F0302Accident · No injuriesClosedPiper PA-23 · Baltimore, MDOct 16, 1966 · N244AP · Substantial damageNTSB NYC67F0301Accident · Minor injuriesClosedMooney M20C · Mitchellville, MDOct 11, 1966 · N78958 · Substantial damageNTSB NYC67D0269Accident · No injuriesClosedPiper PA-28 · College Park, MDOct 8, 1966 · N6453R · Substantial damageNTSB NYC67F0291Accident · Minor injuriesClosedChampion 7EC · Friendly, MDOct 2, 1966 · N7476B · Substantial damageNTSB NYC67A0050Accident · No injuriesClosedHiller 1100 · Hagerstown, MDSep 24, 1966 · N512FH · Substantial damageNTSB NYC67F0237Accident · No injuriesClosedStinson 108-1 · Clinton, MDSep 9, 1966 · N97749 · Substantial damageNTSB NYC67F0245Accident · Serious injuriesClosedCassutt Q SPL · Frederick, MDSep 5, 1966 · N190A · 2 aircraft · DestroyedNTSB NYC67A0044Accident · 1 fatalClosedArquilla WBB · Frederick, MDSep 4, 1966 · N88M · DestroyedNTSB NYC67A0042Accident · 2 fatalClosedHughes 269B · Tuxedo, MDSep 1, 1966 · N9359F · DestroyedNTSB NYC67D0214Accident · No injuriesClosedPiper PA-28 · Laurel, MDAug 31, 1966 · N8913W · Substantial damageNTSB NYC67D0215Accident · No injuriesClosedCessna 150 · Clinton, MDAug 27, 1966 · N8615F · Substantial damageNTSB NYC67A0032Accident · 1 fatalClosedPiper PA-22 · Ocean City, MDAug 19, 1966 · N2415A · DestroyedNTSB NYC67F0188Accident · Minor injuriesClosedCessna 140 · Princess Anne, MDAug 15, 1966 · N76942 · Substantial damageNTSB NYC67D0177Accident · No injuriesClosedCessna 150F · Hurlock, MDAug 13, 1966 · N8946S · Substantial damageNTSB NYC67D0157Accident · No injuriesClosedCessna 182E · Hagerstown, MDAug 7, 1966 · N3369Y · Substantial damageNTSB NYC67D0101Accident · No injuriesClosedCessna 182J · Rock Hall, MDJul 22, 1966 · N2899F · Substantial damageNTSB NYC67D0084Accident · No injuriesClosedCessna 150 · Clinton, MDJul 20, 1966 · N7007X · Substantial damageNTSB NYC67F0107Accident · No injuriesClosedPiper PA-18A · Huntington, MDJul 18, 1966 · N8158C · Substantial damageNTSB NYC67D0102Accident · No injuriesClosedCessna 150 · Gaithersburg, MDJul 12, 1966 · N7811E · Substantial damageNTSB NYC67F0088Accident · Minor injuriesClosedPiper PA-24 · Chester, MDJul 10, 1966 · N8361P · Substantial damageNTSB NYC67F0050Accident · No injuriesClosedBeech N35 · Hestertown, MDJun 26, 1966 · N376TE · Substantial damageNTSB NYC67F0030Accident · Serious injuriesClosedPiper J3 · Ellicott City, MDJun 23, 1966 · N98093 · DestroyedNTSB NYC67D0049Accident · No injuriesClosedLuscombe 8F · Newburg, MDJun 19, 1966 · N9926C · Substantial damageNTSB NYC67D0065Accident · No injuriesClosedCessna 150 · Frederick, MDJun 18, 1966 · N8052F · Substantial damageNTSB NYC66A0149Accident · No injuriesClosedBell 47D1 · Newark, MDJun 7, 1966 · N4227A · Substantial damageNTSB NYC66F0718Accident · No injuriesClosedPiper PA23 · Salisbury, MDJun 3, 1966 · N1067P · Substantial damageNTSB NYC66D0683Accident · Minor injuriesClosedCessna 182 · White Plains, MDJun 3, 1966 · N3312Y · Substantial damageNTSB NYC66D0684Accident · No injuriesClosedPiper PA-22 · Frederick, MDMay 29, 1966 · N8937D · Substantial damageNTSB NYC66F0712Accident · No injuriesClosedCessna 150 · Friendly, MDMay 24, 1966 · N8759S · Substantial damageNTSB NYC66A0714Accident · Serious injuriesClosedCessna 172 · Clinton, MDMay 20, 1966 · N6117E · DestroyedNTSB NYC66A0132Accident · No injuriesClosedBrantly 305 · Annapolis, MDMay 18, 1966 · N2214U · Substantial damageNTSB NYC66F0681Accident · Minor injuriesClosedPiper PA-17 · Frederick, MDMay 15, 1966 · N4693H · Substantial damageNTSB NYC66D0693Accident · No injuriesClosedBeech 95 · Drayden, MDMay 14, 1966 · N667T · Substantial damageNTSB NYC66F0633Accident · No injuriesClosedCessna 150 · Gaithersburg, MDMay 7, 1966 · N8612S · Substantial damageNTSB NYC66D0606Accident · No injuriesClosedPiper PA-28 · Laurel, MDApr 8, 1966 · N6378W · Substantial damage