Boatswain's whistle
From Memory Alpha, the free Star Trek reference.
The boatswain's whistle (pronounced bosun's whistle) is a small whistle that was used aboard old sailing ships since the 15th century, usually to gain the attention of the crew, and was still used on starships up to the 24th century.
Aboard starships, it is normally used when an honorary guest comes aboard or at a crew member's funeral, when their body is released into space.
The shrill whistle often plays before a ship-wide or open frequency communication, usually made by the captain or other senior officer. The actual tone of the call has varied, as some captains prefer the distinctive notes of the electronic type over the more traditional metal whistle. (TNG: "Lower Decks")
When an Excalbian replica of Abraham Lincoln came aboard the USS Enterprise, Lieutenant Dickerson blew a boatswain's whistle. (TOS: "The Savage Curtain")
An electronic boatswain's whistle was blown when Admiral James T. Kirk set foot on the USS Enterprise in 2285. (Star Trek II: The Wrath of Khan)
The boatswain's whistle was blown in the shuttlebay when Captain Jean-Luc Picard took command of the USS Enterprise-D in early 2364. (TNG: "All Good Things...")
Yeoman Burke blew a different electronic boatswain's whistle when the Klingon Chancellor Gorkon came aboard the USS Enterprise-A in 2293. (Star Trek VI: The Undiscovered Country).
The boatswain's whistle was blown in 2372 during a memorial for Kurt Bendera, killed during a Kazon-Nistrim attack. (VOY: "Alliances")
- It was blown by one of Kerry Hoyt's three characters: Grimes, Fitzpatrick or Doug Bronowski.
In 2373, Captain Janeway hallucinated her own death and funeral aboard USS Voyager when a non-corporeal being tried to convince her she was dead, at which Crewman William McKenzie blew the whistle during her memorial. (VOY: "Coda")
In 2375, Nog blew the boatswain's whistle, at the wedding of Kasidy Yates and Benjamin Sisko, right before Kasidy entered the wardroom. Odo complimented him on his playing, despite Nog only having twenty minutes to learn it. (DS9: "'Til Death Do Us Part")
The boatswain's whistle was blown at the belated funeral of Lieutenant John Kelly. (VOY: "One Small Step")
