the Pittsburgh penguins won the cup in 2009 by beating the Detroit red wings
Neither. The best team is Winnipeg Jets.
This is an oddly worded question, so I assume you mean which NHL team plays in Detroit. The NHL team in Detroit is named the Red Wings.
The Red Wings
The Pittsburgh Pirates were an NHL team from 1925-1930.
The Vancouver Caunks were first in the league midway thru the season, followed by Detroit, Philadelphia and Pittsburgh