Attachment B - Sinister Statistics.xlsx

XLSX spreadsheet 25 KB Posted

Attached to
Official Government Owned vehicles insurance CY2027
Solicitation number
19FR6326Q0107
Issued by

About this file

This is a statistical attachment containing insurance claims data for official U.S. Mission France government-owned vehicles covering the period 2023-2026 under RFQ 19FR6326Q0107. The spreadsheet details individual claim records with 30+ data fields tracking incident characteristics, costs, and settlements across two to three dozen claims. Key data elements include incident dates, vehicle type classifications (VP and CTTE designations), damage locations (bumpers, doors, fenders, etc.), claim status (ongoing, archived, pending), liability percentages, claim types (third-party liability and damages, comprehensive coverage), incident descriptions (collision types, hit-and-run incidents, vehicle maneuvers), and associated financial metrics. Financial tracking includes insurer provisions and settlements broken down by category: third-party property liability, third-party bodily injury liability, material damages, driver security, and professional fees, with total provisions and settlements recorded for each claim. Claim values range from under EUR 5,000 to between EUR 5,000-10,000, with most claims falling in the lower range. Summary totals indicate approximately EUR 16,596 in total provisions and EUR 25,251 in total settlements across the dataset. This attachment serves as baseline claims history data for the solicitation, enabling potential insurance contractors to evaluate historical loss patterns, claim frequency, damage types, and cost experience for pricing and risk assessment purposes.

View the file

Other files

File Type Posted
19FR6326Q0107.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

LAL ensemble des sinistres Ligne à ligne ensemble des sinistres ATTACHMENT B- SINISTER STATISTICS - 2023- 2026 RFQ 19FR6326Q0107

Caractéristiques métiersCoûts assureurCoût total
Provisions assureurRèglements assureur
Date de survenance du sinistreLibellé positionConformité constatGenre du véhiculeType d'OrientationEligible OrientationOrientéTaux de responsabilitéDommage client 1Dommage client 2TypologieNatureEvénementIDAPerte totaleNombre de blessés corporelProfil de coûtProvision RC matérielProvision RC corporelProvision Dommages matérielProvision Sécurité du conducteurProvision HonorairesTotal provisionRèglement RC matérielRèglement RC corporelRèglement Dommages matérielRèglement Sécurité du conducteurRèglement HonorairesTotal règlementFranchise contractuelleCoût de l'assureurDommage au 1er €Recours reçusCoût total
06/03/2023En cours, non régléOuiVPCAR/REP000NEANTAvec tiers (Responsabilité civile et Dommages)MatérielTiers change de file000Sinistre < 5 000 €1,710.00 €0.00 €0.00 €0.00 €0.00 €1,710.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €1,710.00 €0.00 €0.00 €1,710.00 €
07/04/2023Terminé, ArchivéVPCAR/REP100PARE CHOCSAVDAvec tiers (Responsabilité civile et Dommages)MatérielAssuré prioritaire de droite/carrefour100Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €2,017.37 €0.00 €0.00 €0.00 €0.00 €2,017.37 €0.00 €2,017.37 €0.00 €1,776.00 €2,017.37 €
21/03/2023Terminé, ArchivéVPCAR/REP10100PARE CHOCSAVTAvec tiers (Responsabilité civile et Dommages)MatérielChoc/struct fixe/manoeuvre avant000Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €
05/05/2023Terminé, ArchivéVPCAR/REP100PARE CHOCSAVTAvec tiers (Responsabilité civile et Dommages)MatérielTiers recule / fait demi tour / se met en travers100Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €-233.78 €0.00 €0.00 €0.00 €0.00 €-233.78 €0.00 €-233.78 €0.00 €1,776.00 €-233.78 €
10/05/2023En cours, non régléOuiVPCAR/REP110PARE CHOCSARDAvec tiers (Responsabilité civile et Dommages)MatérielTiers heurte ass. en stat régulier100Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €
04/06/2023Partiellement règléOuiVPCAR/REP100LATERAL (TOUT LE COTE)DROITAvec tiers (Responsabilité civile et Dommages)MatérielCarambolage 3 à 7 véhicules (RC 0%)000Sinistre < 5 000 €-6,873.40 €0.00 €0.00 €0.00 €0.00 €-6,873.40 €6,873.40 €0.00 €0.00 €0.00 €0.00 €6,873.40 €0.00 €0.00 €0.00 €34,367.01 €0.00 €
14/06/2023Terminé, ArchivéVPCAR/REP00100NEANTAvec tiers (Responsabilité civile et Dommages)MatérielAss. heurte tiers en stat régulier000Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €
14/06/2023RC RepousséeCTTECAR/REP0099LATERAL (TOUT LE COTE)DROITAvec tiers (Responsabilité civile et Dommages)MatérielDélit de fuite du tiers000Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €
21/06/2023En cours, non régléOuiCTTECAR/REP100ARRAvec tiers (Responsabilité civile et Dommages)CorporelCollision en chaine (milieu de file avec projection)000Sinistre entre 5 000 et 10 000 €2,318.52 €4,637.04 €0.00 €0.00 €0.00 €6,955.56 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €6,955.56 €0.00 €0.00 €6,955.56 €
07/07/2023Terminé, ArchivéVPCAR/REP00100LATERAL (TOUT LE COTE)DROITAvec tiers (Responsabilité civile et Dommages)MatérielAss. heurte tiers en stat régulier100Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €1,776.00 €0.00 €0.00 €0.00 €0.00 €1,776.00 €0.00 €1,776.00 €0.00 €0.00 €1,776.00 €
23/06/2023Terminé, ArchivéVPCAR/REP100AILE + PARE-CHOCSAVGAvec tiers (Responsabilité civile et Dommages)MatérielTiers change de file100Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €4,931.14 €0.00 €0.00 €0.00 €0.00 €4,931.14 €0.00 €4,931.14 €0.00 €1,776.00 €4,931.14 €
08/11/2023En cours, non régléOuiVPCAR/REP00100NEANTAvec tiers (Responsabilité civile et Dommages)MatérielAssuré change de file000Sinistre < 5 000 €1,776.00 €0.00 €0.00 €0.00 €0.00 €1,776.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €1,776.00 €0.00 €0.00 €1,776.00 €
09/04/2024Garantie non souscriteVPCAR/REP000AILEARDSans tiersDommages tous accidentsDélit de fuite du tiers000Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €
17/05/2024Absence de réponse clientVPCAR/REP10100AILEARGAvec tiers (Responsabilité civile et Dommages)MatérielDélit de fuite du tiers000Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €
03/06/2024Terminé, ArchivéVPCAR/REP1050ARGAvec tiers (Responsabilité civile et Dommages)MatérielCumul interdictions de même nature100Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €478.80 €0.00 €0.00 €0.00 €0.00 €478.80 €0.00 €478.80 €0.00 €975.00 €478.80 €
26/06/2024En cours, non régléOuiCTTECAR/REP100PORTEARDAvec tiers (Responsabilité civile et Dommages)MatérielTiers change de file100Sinistre < 5 000 €-1,357.80 €0.00 €0.00 €0.00 €0.00 €-1,357.80 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €-1,357.80 €0.00 €0.00 €-1,357.80 €
29/10/2024Terminé, ArchivéCTTECAR/REP00100NEANTAvec tiers (Responsabilité civile et Dommages)MatérielAssuré heurte tiers à l'arrière100Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €1,950.00 €0.00 €0.00 €0.00 €0.00 €1,950.00 €0.00 €1,950.00 €0.00 €0.00 €1,950.00 €
13/12/2024Terminé, ArchivéVPCAR/REP110PARE CHOCSARRAvec tiers (Responsabilité civile et Dommages)MatérielTiers heurte ass. en stat régulier100Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €-273.65 €0.00 €0.00 €0.00 €0.00 €-273.65 €0.00 €-273.65 €0.00 €1,950.00 €-273.65 €
22/02/2025Garantie non souscriteVPCAR/REP000AILE + PARE-CHOCSAVGAvec tiers (Responsabilité civile et Dommages)MatérielDélit de fuite du tiers000Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €
18/03/2025En cours, non régléOuiVPCAR/REP00100NEANTAvec tiers (Responsabilité civile et Dommages)MatérielAssuré recule / fait demi tour / se met en travers000Sinistre < 5 000 €2,030.00 €0.00 €0.00 €0.00 €0.00 €2,030.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €2,030.00 €0.00 €0.00 €2,030.00 €
09/04/2025Terminé, ArchivéCTTECAR/REP100AILEAVDAvec tiers (Responsabilité civile et Dommages)MatérielTiers change de file100Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €-923.00 €0.00 €0.00 €0.00 €0.00 €-923.00 €0.00 €-923.00 €0.00 €2,030.00 €-923.00 €
06/08/2025Clôturé, abandon de recoursVPCAR/REP100PORTEARDAvec tiers (Responsabilité civile et Dommages)MatérielTiers heurte ass. en stat régulier000Sinistre < 5 000 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €
11/12/2025En cours, non régléOuiCTTECAR/REP00100NEANTAvec tiers (Responsabilité civile et Dommages)MatérielAssuré heurte tiers à l'arrière000Sinistre < 5 000 €2,030.00 €0.00 €0.00 €0.00 €0.00 €2,030.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €2,030.00 €0.00 €0.00 €2,030.00 €
08/04/2026En cours, non régléOuiCTTECAR/REP100AILE + PORTEARDAvec tiers (Responsabilité civile et Dommages)MatérielTiers change de file000Sinistre < 5 000 €354.38 €0.00 €0.00 €0.00 €0.00 €354.38 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €354.38 €0.00 €0.00 €354.38 €
01/05/2026En cours, non régléOuiVPCAR/REP00100NEANTAvec tiers (Responsabilité civile et Dommages)MatérielAssuré heurte tiers à l'arrière100Sinistre < 5 000 €2,030.00 €0.00 €0.00 €0.00 €0.00 €2,030.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €0.00 €2,030.00 €0.00 €0.00 €2,030.00 €
4,018 €4,637 €0 €0 €0 €16,596 €0 €0 €0 €0 €0 €25,251 €25,251 €

File details come from the government source that posted it. Updated .