2-02 - Appendix II Insurance Loss History.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Insurance Broker of Record
- Solicitation number
- 26-50RFP
- Issued by
- Collin County, Texas
About this file
This file is an Insurance Loss History document for the City of McKinney, Texas, detailing property claims data relevant to a Request for Proposals for an Insurance Broker of Record. The loss run spans from December 2021 through September 2025 and encompasses 24 property damage claims across multiple city departments including Parks and Recreation, Public Works and Utilities, Aviation, Administrative and General Services, and Public Safety. Claims include wind damage, water damage, fire losses, mobile equipment accidents, freezing pipe damage, mold issues, product failures, and theft. The document categorizes each claim by loss date, fund year, close date, claim status (open or closed), employment class code, loss cause, and responsible department, providing a comprehensive record of the city's insurance claims history.
The loss history reveals significant financial exposure, with total incurred claims exceeding $3.6 million across the documented period. Notable high-value claims include a foam release incident in an aviation hangar totaling $1,887,508.24, a wind-related multi-facility power outage and damage event at $502,064.74, a park concession stand total building loss by fire at $390,589.66, and a freezing-related loss at the aviation facility at $243,927.57. Claims are managed by multiple adjusters including Mike Myers, Patti Bratz, Lisa Kutch, Jennifer Bolger, and David Goldston. The majority of claims have been closed with specific recovery amounts, though several remain open with outstanding reserve amounts, indicating ongoing claims management and potential additional cost exposure for the city.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 1-01 - Appendix I Schedule of Insurance.pdf | ||
| 5-00 - 26-50RFP Solicitation - FINAL.pdf | ||
| 3-03 - Appendix Ill Insured Property Schedule Summary.xlsx | XLSX spreadsheet | |
| 4-04 - Exhibit A - Cost Proposal Form 26-50RFP.xlsx | XLSX spreadsheet |
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
Loss Run_1
| Member ID | Contract Type | Site Code | Claim Number | Claimant | Claim State | Employment Class Code | Loss Cause | Claim dept. code | Claim dept. detail | Loss Date - Date Value | Loss Date - Fund Year | Close Date - Date Value | Total Paid | Open Reserves | Non-deductible Recovery | Total Incurred Net Non-Deductible Recovery Reserves | Deductible Recovery Reserves | Deductible Recovery | Open Deductible Recovery Reserves | Severity | Coverage | Claim Description | Adjuster | |||||
| 4946 | Property | TX0000000248916 | McKinney | Closed | Boiler and machinery | Parks/Recreation | Pools | Sep 23, 2025 | 2024/2025 | Oct 1, 2025 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Splash pad pipe blew apart and got control panel wet and it will not come on. | Sattie Peinado | |||||||
| 4946 | Property | TX0000000250074 | McKinney | Closed | Fire | Parks/Recreation | Parks | Sep 5, 2025 | 2024/2025 | Oct 23, 2025 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Fire set in the bathroom at Gabe Nesbit - Skate park | Jennifer Bolger | |||||||
| 4946 | Property | TX0000000245144 | McKinney | Closed | Mobile equipment | Public Works & Utility | Public Works & Utility | Jul 28, 2025 | 2024/2025 | Sep 29, 2025 | $18,548.45 | $0.00 | $0.00 | $18,548.45 | $0.00 | $0.00 | $0.00 | UNKNOWN | Mobile Equipment | ME ID 15 | ||||||||
| Emplee operating the skid steer- doing training. Emp flipped the unit over backwards-final | Lisa Kutch | |||||||||||||||||||||||||||
| 4946 | Property | TX0000000240898 | McKinney | Closed | Wind | Public Works & Utility | Water | May 25, 2025 | 2024/2025 | Jun 4, 2025 | $10,438.00 | $0.00 | $0.00 | $10,438.00 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Wind storm blew through and damaged the gate at the Virginia and Bellegrove water tower. | Mike Myers | |||||||
| 4946 | Property | TX0000000238742 | McKinney | Open | Collision with other object | Aviation | Maintenance | Apr 24, 2025 | 2024/2025 | $58,389.63 | $0.00 | $0.00 | $58,389.63 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Pursuit chase with Princeton police ended in claimant crashing his 2015 Toyota Camry into Airport Gate 12 which gains entry into a portion of restricted Airport tarmac. Gate 12 sustained very heavy damage and as a result was inoperable. | Mike Myers | ||||||||
| 4946 | Property | TX0000000234844 | McKinney | Closed | Wind | Public Works & Utility | Public Works & Utility | Mar 4, 2025 | 2024/2025 | Oct 13, 2025 | $502,064.74 | $0.00 | $0.00 | $502,064.74 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Multiple power outages - PW north, PW south, City Hall, F.S. #2, Sr. Center, Downtown Bldgs., •New City Hall - power outage and multiple circuits that should be backed up are not working properly i.e. elevators and badge access. • | Fire Station 2 - Generator failed to start (got generator started)• | Redbud Pump Station - Gate off track and bent/damaged - wedged close for now. • | Airport - Two Hangar doors knocked off track• | Old Settlers - A large tree feel on the attached pavilion. | Mike Myers | |||
| 4946 | Property | TX0000000234322 | McKinney | Closed | Freezing | Public Works & Utility | Public Works & Utility | Feb 20, 2025 | 2024/2025 | May 2, 2025 | $26,577.81 | $0.00 | $0.00 | $26,577.81 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Freeze - pipe break in the fire suppression systems at Corp 9. and FBO terminal buildings. | Patti Bratz | |||||||
| 4946 | Property | TX0000000234172 | McKinney | Closed | Mold, Mildew and Fungus | Parks/Recreation | Rec. Centers/Athletics | Jan 24, 2024 | 2023/2024 | Oct 1, 2025 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | The dehumidifier in the pool area of the senior center malfunctioned which caused mold to grow. | Mike Myers | |||||||
| 4946 | Property | PR0000000208620 | McKinney | Open | Fire | Parks/Recreation | Parks/Recreation | Jan 21, 2024 | 2023/2024 | $390,589.66 | $0.00 | $0.00 | $390,589.66 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Total building loss due to fire- Park Concession Stand | Mike Myers | ||||||||
| 4946 | Property | PR0000000208292 | McKinney | Closed | Freezing | Aviation | Aviation | Jan 15, 2024 | 2023/2024 | Jun 13, 2024 | $243,927.57 | $0.00 | $0.00 | $243,927.57 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Freeze | Patti Bratz | |||||||
| 4946 | Property | PR0000000207271 | McKinney | Closed | Water damage | Administrative & General Services | Administrative & General Services | Dec 24, 2023 | 2023/2024 | Dec 4, 2025 | $223,570.14 | $0.00 | $178,856.11 | $44,714.03 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | ID 221 | ||||||||
| There is a common area kitchen in this old FBO building. Coffee Services runs a filter from the sink to the coffee machine. It came off-final. | Lisa Kutch | |||||||||||||||||||||||||||
| 4946 | Property | PR0000000210419 | McKinney | Closed | Mold, Mildew and Fungus | Public Safety | Fire | Nov 18, 2023 | 2023/2024 | Sep 16, 2024 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Overflow of a drain caused flooding in 3 bunk rooms and the bunker gear wash room. Facilities got it cleaned up but Fire complained of a "smell". Facilities had Ensolum come out and test and found minute traces of mold. Fire wants it cleaned. | Patti Bratz | |||||||
| 4946 | Property | PR0000000207941 | McKinney | Open | Water damage | Administrative & General Services | Codes/Inspection | Nov 6, 2023 | 2023/2024 | $62,551.88 | $0.00 | $0.00 | $62,551.88 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Code Enforcement Building had a water leak due to a water line failure in the ceiling. | David Goldston | ||||||||
| 4946 | Property | PR0000000204155 | McKinney | Open | Product failure | Aviation | Aviation | Oct 28, 2023 | 2023/2024 | $1,792,507.37 | $95,000.87 | $0.00 | $1,887,508.24 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | At approximately 1pm this afternoon there was a foam release into Corp Hangar #3, ID # 329. There were seven planes and four vehicles inside the hangar and five outside the hangar. | Mike Myers | ||||||||
| 4946 | Property | PR0000000202104 | McKinney | Closed | Water damage | Public Works & Utility | Water | Sep 25, 2023 | 2022/2023 | Jan 30, 2025 | $91,189.97 | $0.00 | $91,189.92 | $0.05 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | ID 364 | ||||||||
| Water dmg to airport term bldg due to a faulty valve on 2nd floor | Lisa Kutch | |||||||||||||||||||||||||||
| 4946 | Property | PR0000000215721 | McKinney | Closed | Fire | Public Works & Utility | Public Works & Utility | May 25, 2023 | 2022/2023 | Aug 21, 2024 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | T7 Truck was a total loss due to the fire. This is for replacement of items inside the truck. | Patti Bratz | |||||||
| 4946 | Property | PR0000000193591 | McKinney | Closed | Theft | Public Works & Utility | Public Works - General | May 10, 2023 | 2022/2023 | Jun 8, 2023 | $6,778.69 | $0.00 | $0.00 | $6,778.69 | $0.00 | $0.00 | $0.00 | UNKNOWN | Mobile Equipment | Lawn mower was stolen from public works yard. | Patti Bratz | |||||||
| 4946 | Property | PR0000000189149 | McKinney | Closed | Wind | Parks/Recreation | Parks/Recreation | Mar 2, 2023 | 2022/2023 | Jul 31, 2024 | $117,269.79 | $0.00 | $0.00 | $117,269.79 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Winds caused fence to blow over. | Doug Gronli | |||||||
| 4946 | Property | PR0000000166241 | McKinney | Closed | Wind | Public Works & Utility | Public Works & Utility | Jan 25, 2022 | 2021/2022 | Apr 1, 2022 | $27,665.77 | $0.00 | $0.00 | $27,665.77 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Emergency Sire/Pole that dropped 50 feet during high winds | Patti Bratz | |||||||
| 4946 | Property | PR0000000168350 | McKinney | Closed | Product failure | Parks/Recreation | Parks/Recreation | Dec 6, 2021 | 2021/2022 | Jun 21, 2022 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | UNKNOWN | Real & Personal Property | Contractor messed up concrete project twice now the City needs to pay another contractor to do the job right. | Patti Bratz |
File details come from the government source that posted it. Updated .