There's practically a minute by minute account of the IJN CAP at Midway in "Shattered Sword".
"Shattered Sword" doesn't list the 3 B-26s that attacked Junyo with torps on 6/4/42 near Unmak Island in the Aleutians. All torps missed. I've found you can't rely on just one source, you need several. Preferably from all participants.
The Japanese raids into the Bay of Bengal also produced some torpedo hits. Ryujo alone sank over a dozen ships with her Kates and damaged at least 5 more. Some were with bombs, some with torps. KB, strangely enough, used only bombs on the Hermes, Cornwal, Dorsetshire, Vampire and others. (I wonder why)
There are also several other ships torpedoed by Japanese aircraft that don't appear in most of the books covering the US side.
For example, the USAT ships John H. Couch and George Bliss were attacked by two Kates with torpedoes near Guadalcanal on 10/11/43. Both were hit but neither were sunk.
The SS John Penn was doubly unlucky at Guadalcanal on 9/13/43. 3 Kates attacked the convoy. The John Penn shot down the Kate that attacked her but the Kate crashed into the bridge area and then the torp the Kate dropped struck the ship. The ship sank in Ironbottom Sound.
The SS Antoine Saugrain was sunk by an aerial torpedo dropped from a single aircraft near the Philippines on 12/5/44. The plane type was not reported.
The main point here is that there are many aerial torpedo attacks conducted by Japan, America and Britain that were just footnotes to history because they had little impact on the course of the war. Most books tend to just provide details about the major naval battles and very little about merchants and other vessels that suffered torpedo attack.
Chez