NTSB investigations, 1965, 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, 1965, 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\") = 1965
    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 NYC66F0443Accident · No injuriesClosedErcoupe 415-C · Laytonsville, MDDec 31, 1965 · N2527H · Substantial damageNTSB NYC66F0398Accident · No injuriesClosedCessna 172 · Gaithersburg, MDDec 11, 1965 · N6836X · Substantial damageNTSB NYC66F0388Accident · Serious injuriesClosedCessna 172 · Stevensville, MDDec 4, 1965 · N2560U · DestroyedNTSB NYC66D0425Accident · No injuriesClosedCessna 175 · Rockville, MDNov 28, 1965 · N7373M · Substantial damageNTSB NYC66D0342Accident · No injuriesClosedCessna 172 · College Park, MDNov 13, 1965 · N6225E · Substantial damageNTSB NYC66D0337Accident · No injuriesClosedChampion 7ECA · Clinton, MDOct 31, 1965 · N9539S · Substantial damageNTSB NYC66D0331Accident · Minor injuriesClosedCessna 150 · Gaithersburg, MDOct 30, 1965 · N8748S · Substantial damageNTSB NYC66F0359Accident · No injuriesClosedCessna 210B · Clinton, MDOct 26, 1965 · N9741X · Substantial damageNTSB NYC66D0316Accident · No injuriesClosedCessna 170B · Baltimore, MDOct 18, 1965 · N3483D · Substantial damageNTSB NYC66D0315Accident · No injuriesClosedCessna 150 · Pocomoke City, MDOct 17, 1965 · N7335X · Substantial damageNTSB NYC66F0322Accident · No injuriesClosedPiper PA-23 · Reverdale, MDOct 14, 1965 · N4622P · Substantial damageNTSB NYC66D0304Accident · No injuriesClosedCessna 150 · Clinton, MDOct 13, 1965 · N5830E · Substantial damageNTSB NYC66F0306Accident · No injuriesClosedCessna 140 · Gaithersburg, MDOct 10, 1965 · N2318N · Substantial damageNTSB NYC66D0281Accident · Minor injuriesClosedPiper PA-22 · Stevensville, MDOct 10, 1965 · N1425C · Substantial damageNTSB NYC66F0285Accident · No injuriesClosedPiper PA-12 · College Park, MDOct 9, 1965 · N2573M · Substantial damageNTSB NYC66D0303Accident · No injuriesClosedPiper PA-28 · Annapolis, MDOct 9, 1965 · N6297W · Substantial damageNTSB NYC66F0305Accident · Minor injuriesClosedRyan ST-3KR · Laurel, MDOct 8, 1965 · N1144 · Substantial damageNTSB NYC66D0280Accident · No injuriesClosedCessna 170 · Gaithersburg, MDOct 3, 1965 · N707F · Substantial damageNTSB NYC66A0044Accident · Minor injuriesClosedBell 47H-1 · Clinton, MDOct 2, 1965 · N996B · Substantial damageNTSB NYC66F0259Accident · No injuriesClosedStinson 108 · Ocean City, MDSep 26, 1965 · N9209K · Substantial damageNTSB NYC66A0036Accident · 1 fatalClosedPiper PA-23 · Glen Burnie, MDSep 20, 1965 · N5759Y · DestroyedNTSB NYC66D0250Accident · No injuriesClosedPiper PA-22 · Baltimore, MDSep 19, 1965 · N5863Z · Substantial damageNTSB NYC66D0239Accident · No injuriesClosedLeister-K 10-A · Frizzelburg, MDSep 6, 1965 · N58179 · Substantial damageNTSB NYC66F0223Accident · No injuriesClosedPiper PA-24 · Gaithersburg, MDSep 5, 1965 · N7162P · Substantial damageNTSB NYC66F0202Accident · Minor injuriesClosedPiper PA-22 · Edgewater, MDAug 31, 1965 · N1429A · Substantial damageNTSB NYC66D0173Accident · No injuriesClosedPiper PA-22 · Laytonsville, MDAug 20, 1965 · N4796Z · Substantial damageNTSB NYC66F0217Accident · Minor injuriesClosedBeechcraft C-45H · Cambridge, MDAug 17, 1965 · N159L · DestroyedNTSB NYC66F0142Accident · No injuriesClosedBeechcraft A35 · Elkton, MDAug 13, 1965 · N693B · Substantial damageNTSB NYC66D0149Accident · No injuriesClosedCessna 172 · Essex, MDAug 10, 1965 · N2553U · Substantial damageNTSB NYC66A0020Accident · Serious injuriesClosedBrantly B-2B · Cumberland, MDAug 9, 1965 · N2263U · Substantial damageNTSB NYC66A0019Accident · No injuriesClosedBrantly B-2B · Silver Spring, MDAug 8, 1965 · N2261U · Substantial damageNTSB NYC66D0147Accident · No injuriesClosedPiper PA-22 · Ft Meade, MDAug 7, 1965 · N5780Z · Substantial damageNTSB NYC66D0141Accident · No injuriesClosedBeechcraft 23 · Gaithersburg, MDAug 5, 1965 · N2335Q · Substantial damageNTSB NYC66A0018Accident · 2 fatalClosedPiper PA-23 · Union Bridge, MDAug 4, 1965 · N4778P · DestroyedNTSB NYC66A0016Accident · 4 fatalClosedCessna 172F · Newburg, MDJul 29, 1965 · N5469R · DestroyedNTSB NYC66A0014Accident · No injuriesClosedBell 47G2 · Hollywood, MDJul 27, 1965 · N6752D · Substantial damageNTSB NYC66D0140Accident · No injuriesClosedCessna 172 · Princess Anne, MDJul 26, 1965 · N6325E · Substantial damageNTSB NYC66F0148Accident · No injuriesClosedPiper PA-22 · Salisbury, MDJul 25, 1965 · N943A · Substantial damageNTSB NYC66D0159Accident · Minor injuriesClosedChampion 7FC · Easton, MDJul 21, 1965 · N9863Y · Substantial damageNTSB NYC66F0060Accident · No injuriesClosedCessna 172 · Still Pond, MDJul 19, 1965 · N3670S · Substantial damageNTSB NYC66F0064Accident · Serious injuriesClosedPiper J3C · Baltimore, MDJul 17, 1965 · N70429 · Substantial damageNTSB NYC66A0009Accident · No injuriesClosedBrantly B-2 · Suitland, MDJul 12, 1965 · N2277U · Substantial damageNTSB NYC66A0003Accident · 1 fatalClosedHughes 269B · Waldorf, MDJul 8, 1965 · N942OF · DestroyedNTSB NYC66F0070Accident · No injuriesClosedPiper PA-22 · Cumberland, MDJul 3, 1965 · N8816D · Substantial damageNTSB NYC66D0058Accident · No injuriesClosedCessna 150 · Friendly, MDJun 29, 1965 · N6193T · Substantial damageNTSB NYC66D0059Accident · Minor injuriesClosedCessna 140 · Odenton, MDJun 27, 1965 · N72455 · DestroyedNTSB NYC66F0097Accident · No injuriesClosedMoonraker 100 · Gaithersburg, MDJun 22, 1965 · N8669E · Substantial damageNTSB NYC66F0071Accident · No injuriesClosedNavion L-17A · Potomac, MDJun 17, 1965 · N999S · Substantial damageNTSB NYC66F0003Accident · Serious injuriesClosedLuscombe 8A · Mitchellville, MDJun 11, 1965 · N77Q · Substantial damageNTSB NYC65A0147Accident · No injuriesClosedBell 47G2 · Laurel, MDJun 11, 1965 · N6758D · Substantial damage