(covers information from several alternate timelines)
Explosive decompression is a violent, sudden drop in ambient air pressure that occurs within one tenth of a second when in space.
Opening, disabling, or the failure of the containment fields around airlocks and external hatches, such as those found in shuttlebays and cargo bays, or a major hull breach while in any environment of substantially lower pressure, will result in an explosive decompression. Decompressing the main shuttlebay aboard a Galaxy-class starship would cause a reaction sufficient enough to move the ship. (TNG: "Contagion", "Disaster", "Cause and Effect")
In 2259, Montgomery Scott opened an airlock aboard the USS Vengeance to allow access for James T. Kirk and Khan Noonien Singh. A Section 31 security officer was blown into space as a result. (Star Trek Into Darkness)
In 2367, the USS Enterprise-D attempted to remove Junior from its dorsal section by depressurizing Shuttlebay 2. The explosive decompression failed to dislodge the alien baby though. (TNG: "Galaxy's Child")
One of Dukat's duties, when he was a Glinn serving aboard the Cardassian starship Kornaire, was to clean out a compartment where three men had been killed by explosive decompression. In 2374, told Benjamin Sisko that "I didn't sleep for a week after that". (DS9: "Waltz")
During the Battle of the Bassen Rift in 2379, the Reman warbird Scimitar launched a volley of photon torpedoes at the USS Enterprise-E's bridge, resulting in an explosive decompression which killed Lieutenant Branson. (Star Trek Nemesis)