Rising global temperatures will increase the number of extreme weather events, creating new challenges for cities around the world. Archaeological research on the destruction and subsequent reoccupation of ancient cities has the potential to reveal geological and social dynamics that have historically contributed to making urban settings resilient to these extreme weather events. Using a combination of archaeological and geological methods, we examine how extreme flood events at Kaifeng, a former capital of dynastic China, have shaped the city's urban resilience. Specifically, we focus on an extreme Yellow River flood event in AD 1642 that historical records suggest killed around 300,000 people living in Kaifeng. Our recent archaeological excavations have discovered compelling geological and archaeological evidence that corroborates these documents, revealing that the AD 1642 Yellow River flood destroyed Kaifeng's inner city, entombing the city and its inhabitants within meters of silt and clay. We argue that the AD 1642 flood was extraordinarily catastrophic because Kaifeng's city walls only partly collapsed, entrapping most of the flood waters within the city. Both the geology of the Yellow River floods as well as the socio-political context of Kaifeng shaped the city's resilience to extreme flood events.