The typical Sig Sauer is a good example.
Somebody will correct me if I'm wrong, of course, but I think Sig makes a series of Double-Action-Onlys, as does Glock, mainly to satisfy requirements of law enforcement agencies. Maybe military also--not sure.
I don't know how much safer a DAO is, but statistics may come into play here. A LEO handles his weapon orders of magnitude more than the average civilian owner, so every little bit of improved safety would in theory translate to measurably fewer ND incidents.
Having once owned a Sig of the aforementioned SA/DA type, and now owning a relatively cheap DAO, I find the trigger pull on my particular DAO to be strong enough and long enough to make it difficult to fire accurately. I know for sure it's not going to fire without my finger on the trigger, given just the least bit of care in handling or packing.
Sig makes all sorts of variants. I think the one you have in mind is the DAK trigger variant.
Oh, by the way, Im almost positive the pilot gun is the sig 229 in 357 sig caliber.