The USS Kyushu (NCC-65491) was a Federation New Orleans-class frigate that was in service with Starfleet in the mid-24th century.
The Kyushu fought the Borg at the Battle of Wolf 359 in 2367, and was destroyed along with 38 other starships. It was among the ships identified in the wreckage by Commander Shelby. (TNG: "The Best of Both Worlds, Part II")
The name and registry come from the studio model. The class name, which appears in the Star Trek Encyclopedia, was provided by production sources.
In addition the Encyclopedia states, "
was named for one of the four main islands of Japan
, where a Japanese orbital launch facility was located."