The Kate Logan Affair is a 2010 Canadian drama film starring Alexis Bledel and Laurent Lucas, written and directed by Nol Mitrani about a young psychologically unstable police woman named Kate Logan and a married Frenchman who find themselves caught up in a dramatic twisted affair. Based on the true story of a 2002 crime committed by an Alberta policewoman.
In a subsequent encounter, Kate shows Benoit how to hold and aim her service revolver. While he playfully does this, never having handled one before, the revolver goes off and a bullet is lodged in the wall of the motel room. Fearing the loss of her job, Kate drags Benoit deeper into the affair and both are now on the run. Benoit just wants to go to the police and tell them the truth that it was just an accident. She keeps him hooked by threatening to tell his wife that they slept together. She tells him that they will come up with a better solution.The outcome of the situation is tragic, for everyone but Kate. This woman manages to destroy many lives yet comes out of it unscathed. ........
Source: Wikipedia