Well despite rumer hearsay and popular oppinion southeast Michigan is not as snowy as many would like to believe. "We get slush a mix of snow and water." But Detroit fits your Needs because it does have a major airport, it has many dive centers that are more than willing to set up charters, and best of all The wrecks are spectacular....When you can see them. Good luck in your choice.