NRC National Guidelines on Flood Control Cost-Benefit Analysis Share Extensive Insurance Industry Loss Data Across Canada Define Flood Control Benefits

The National Research Council of Canada (NRC) has released the National Guidelines on Undertaking a Comprehensive Analysis of Benefits, Costs and Uncertainties of Storm Drainage and Flood Control Infrastructure in a Changing Climate.

The full guidelines are available here to download: https://nrc-publications.canada.ca/eng/view/object/?id=27058e87-e928-4151-8946-b9e08b44d8f7

These guidelines delve into many topics to support comprehensive benefit cost analysis. A previous post explored historical extreme rainfall trends related to flood damages (see post: https://www.cityfloodmap.com/2022/02/nrc-national-guidelines-on-flood.html). This post shares insurance industry loss data presented in the guidelines. Such data support the comprehensive assessment of direct and indirect flood losses that represent potential benefits of new and upgraded flood control infrastructure investments.

The NRC Guidelines identify two approaches for assessing flood damages for projects of various scale and detail including:

i) a bottom-up approach based on property-scale losses, and

ii) a top-down approach based on scalable national or regional insurance loss data.

Previously unavailable data was shared by several organizations including Munich Re, the Insurance Bureau of Canada, and CatIQ to support the analyses in the guidelines. Thank you!

CatIQ Property-Scale Flood Losses in Canada (Bottom-up Analysis)

Catastrophe Indices and Quantification Inc. (CatIQ) is a Toronto-based subsidiary of Zurich-based PERILS A.G. that delivers detailed analytical and meteorological information on Canadian natural and man-made catastrophes. Established in 2014, CatIQ and is supported by the majority of the Canadian insurance and reinsurance industry, allowing it to provide the most reliable source of catastrophe loss information in Canada. Data are available through CatIQ’s online subscription-based platform that includes comprehensive insured loss and exposure data used by the insurance industry and other stakeholders - we used this database to analyze regional and national flood and related water losses across Canada.

Records of flood and water loss and loss expenses analyzed were from January 2008 to January 2019 while records of sewer back-up/water losses analyzed were available from April 2013 to January 2019. 

As noted in the NRC Guidelines "Nationally, the average loss, representing closed claims is approximately $22,300 based on well over 70,000 claims – this average value is for 55 events. Due to many smaller events in the database, the median loss is lower than the average at $16,300". The following chart shows the distribution of losses across these 55 events (see Appendix D | Direct & Indirect Long Time Horizon Damages, Figure 8):

Given that CatIQ defines events and compiles loss data for those events with over $25M in losses, some small events with smaller losses. A review of CatIQ indicated that events with a higher number of claims, corresponding to more extreme and widespread events, reported higher average claims. 

CatIQ data shows regional differences in sewer-back losses as reported in the NRC Guidelines (Appendix D | Direct & Indirect Long Time Horizon Damages, Table 14):

Intact Financial has recently noted that the often-cited average cost of $43,000 represents an upper limit for certain flood events (Intact Financial, 2019) - that makes sense for an extreme event, as reported in the NRC Guidelines:

"...an extreme event average claim approaching $40,000 could be appropriate. Specifically, the June 2013 Alberta flood event characterized by extensive riverine flooding had an average claim of over $37,000 for nearly 8000 sewer back-up/water claims."

The one instance of an event with average claims of up to $60,000 per policy represented only a handful of claims. Note that some have mistakenly cited the above $43,000 value as the average cost of a flooded basement across Canada, which is not supported by available data. It could be more reflective of overall losses in some regions, including both insured and uninsured losses. 

How can this data be used to assess benefits in cost benefit analysis? The NRC Guidelines presents a case study evaluating local sewer improvement alternatives using CatIQ data to assess benefits.  See Appendix I | Case Studies | Case Study 3 -  EXISTING STORM SEWER SYSTEM DAMAGE REDUCTION.

For another example, refer to the NRC Guidelines authors 2020 WEAO fall webinar paper that illustrates how regional sewer-back-up losses can be used to derive EAD values for project areas. That example applies where the number of flooded basements is available through detailed, local modelling. See post with paper:   https://www.cityfloodmap.com/2021/12/national-guideline-development-for.html.

More examples? Infrastructure Canada's Disaster Mitigation Adaptation Fund (DMAF) requires an assessment of Return on Investment (ROI) for candidate projects, specifying a minimum ratio of benefits to costs of 2:1. Local sewer back-up flood damages may be used to better define the potential benefits of infrastructure investments that reduce losses, following the approach in the WEAO fall webinar paper above. Depending on the level of service for a flood damage reduction project, a significant portion of expected damages many be avoided, and counted as benefits in a DMAF ROI calculation.

Munich Re Insured and Overall Losses (Top-Down Analysis)


Munich Re
gratefully drilled down into previously-available North American loss data presented in its NatCatSERVICE and provided historical Canadian insured losses for hydrological and meteorological events, and estimated uninsured losses.

The NRC Guidelines present the following figure showing these historical losses for meteorological and hydrological ‘event families’ including meteorological events (tropical storms, extra-tropical storms, convective storms and local windstorms) and hydrological events (flood and mass movement)  (see Appendix D | Direct & Indirect Long Time Horizon Damages, Figure 5): 

Munich Re data were then analyzed to derive return-period and Expected Annual Damages (EAD) across Canada. The analysis revealed 'average' 2-year losses of $426M and rare 100-year losses of $2.29B. The EAD was $697M for insured losses (the blue bars in the figure above), showing that expected losses that factor in occasional extreme losses is higher than the average.

Obviously such flood losses are significant and need to be managed. Expected annual insured losses of $695M represent about 0.4% of the Canadian GDP of $1.6T. 

Overall losses that include uninsured losses are higher and are represented by the green bars in the chart above. Munich Re estimates this as described in NatCatSERVICE documentation and considers insurance market penetration and reported disaster assistance payouts. The following chart shows the relation between overall and insured losses (ratio of green to blue bars above)(see (see Appendix D | Direct & Indirect Long Time Horizon Damages, Figure 7):


The overall losses in an individual year could be 3 times the insured losses. On average from 1983 to 2017, overall losses were 1.94 times insured losses. Why is there variability? Well, different types of hazards in Canada have different levels of insurance coverage. Sewer back-up has a relatively high degree of coverage and in years dominated by severe urban flooding events (e.g., Toronto and GTA in 2005) there would be relatively lower uninsured losses. In contrast, riverine flood insurance is was previously not available for residential properties in Canada until about 2015, and may not be available for high risk non-residential properties in floodplains - so in 2013, Calgary riverine flooding would not have been insurable (although many companies may still have granted claims in that instance as a 'goodwill measure' as noted by KPMG in 2014).  

How can Munich RE loss data be used to assess benefits of adaptation to flooding and inform funding policies? The overall losses can guide us as to how much we should invest to reduce these damages. 

The NRC Guidelines include case studies that apply Munich RE loss data including (see Appendix I | Case Studies):

i) CASE STUDY 1 – NATIONAL-LEVEL POLICY DEVELOPMENT, and

ii) CASE STUDY 2 – MUNICIPALITY-LEVEL PROJECT PLANNING

Case Study 1 conclusions note broadly how insurance loss information may be used: "This case study demonstrates that high-level policy decisions may be sufficiently informed through available information sources for future benefits (using insurance industry data to guide the estimation of avoided future losses), and the setting of target economic performance (using a benefit-cost ratio approach or some other relevant measure of return on investment) to establish, in this case, appropriate funding levels for allocation."

In the Case Study 1 example analysis, based on a i) Munich RE overall (insured and uninsured) EAD value of $1.347B (2017 dollars) for water damage (hydrological and meteorological events), and ii) CatIQ EAD of $819 million (2018 dollars) for insured flood loss and loss expense, a representative EAD of $1.0B was considered. This values was used to estimate an annual funding allocation noting:

 "Accordingly, based on the parameters assumed in this analysis relating to the estimation of benefits, time value of money and acceptable benefit-cost ratio (return on investment), a national flood protection policy could allocate about $2.8 billion annually (in 2020 dollars) for a 10-year period on projects that would achieve the technical performance objectives sought."

Case Study 2 conclusions note how insurance loss data was applied at a municipal and project-scale assessment of damages and benefits: "This case study demonstrates the downscaling of broad-scale insurance industry loss data to more granular levels for application to a municipality-level program and further down to the level of a collection of projects within the municipality. This “top down” approach to estimating future benefits (avoided losses) negates the need for highly detailed “bottom-up” methods for urban drainage system damage and benefit estimation when such approaches might be impractical or require excessive efforts relative to the accuracy they might produce. That is, estimation of urban drainage system damages on a bottom-up (property scale) basis, considering minor and major storm system risk, wastewater system risk, system interactions, and property-scale grading and construction factors has not been shown to be feasible or correlated to reported damages."

Munich RE loss data was used in Case Study 2, based on the City of Markham, Ontario to determine the following expected annual damages (and potential benefits of infrastructure investments):

• EAD for City-Wide Level Assessment: $13.2 million

• EAD for Assessment of Study Area: $5.1 million

• EAD for Assessment of Project Area: $0.8 million

The scaling of national Munich RE loss data and EAD considered proportion of population in Case Study 2. Regional loss data from IBC or CatIQ, excluding uninsured losses, could similarly be scaled. A review of proportion of GDP, as part of DMAF ROI assessments in Markham, indicated a similar proportion to population. The NRC Guidelines illustrate how several economic, demographic, built-form and infrastructure parameters are closely correlated across regions of Canada, and are related to regional expected losses. This is the basis of top-down loss scaling considered where bottom-up property scale analysis is impractical.

The following tables summarize the benefits (based on scaled Munich RE losses), costs (see a future post on costing data), and achieved benefit-cost ratios at a municipal, broad study area, and at a sub-project scale.


NRC National Guidelines on Flood Control Cost-Benefit Analysis Indicate 100-Year Storm Intensities Not Increasing

The National Research Council of Canada (NRC) has released the National Guidelines on Undertaking a Comprehensive Analysis of Benefits, Costs and Uncertainties of Storm Drainage and Flood Control Infrastructure in a Changing Climate.

The full guidelines are available here to download: https://nrc-publications.canada.ca/eng/view/object/?id=27058e87-e928-4151-8946-b9e08b44d8f7

These guidelines delve into many topics to support comprehensive benefit cost analysis. As the effects of a changing climate on flood damages (and adaptation benefits of reducing them) are considered, trends in extreme rainfall across Canada are reviewed in the foundation research. The review shows that on average extreme rainfall intensities have not increased when the most recently observed data is considered.

Extreme rainfall intensities can be characterized by the high return period values in Intensity-Duration-Frequency (IDF) statistics. For example the 100-year rainfall intensity would be the rate of rainfall over a range of durations that has a 1% chance (i.e., 1/100) of occurring in a single year, based on the statistical analysis of past observations.   Similarly 50-year storm rainfall rates have a 2% change of occurring during any year (i.e., 1/50), 25-year rainfall has a 4% chance, 10-year has a 10% chance, etc..

The guidelines present the following table showing 2-year to 100-year design rainfall intensity trends at 226 climate stations across Canada for durations of 5 minutes to 24 hours (Appendix E, Table 17):


As shown, 100-year storm intensities have decreased on average by 0.5% from the v2.00 to the v3.10 Engineering Climate Datasets. On average the derived 10-year to 50-year rainfall rates have decreased as well.

IDF intensity values are derived from observed annual maximum rainfall values, called an annual maximum series (AMS). One can look at the trends in AMS values to understand how derived 'return period' intensities are changing over time. The NRC guidelines summarized Environment and Climate Change Canada's analysis of these trends across Canada in the following table (Appendix E, Table 11):


The table counts instances where observed rainfall has decreased significantly (i.e., a statistically strong trend), has decreased (a weaker trend), has not changed, has increased (a weak trend), or has increased significantly (a strong trend).  Across Canada the totals show decreasing trends in 131+2235=2366 data points and increasing trends in 2526+251=2777 data points. And 266 data points showed no change. This summary indicates that both decreases and increases are occurring, with slightly more increases.

The NRC guidelines present additional analysis of more regional trends as well. This can help practitioners understand recent changes in extreme rainfall affecting local flood damages. For example the AMS trends in southern and northern Ontario are presented in the following two tables (Appendix E, Annex E1, Table A Part 3 & Part 4):

Ontario is shown to have increasing and decreasing AMS values (i.e., annual maximum observed rainfall) that varies by location (climate station) and duration. In some cases annual maximum rainfall is decreasing/unchanged or increasing/unchanged for all durations while in others short duration values have increased while long duration values have decreased - or vise versa. For example:  

Stations with all decreasing/unchanged trends for all durations:

  • Elora RCS
  • Hamilton A
  • Toronto City
Stations with all increasing/unchanged trends for all durations:
  • Toronto North York
  • Sioux Lookouk
  • Geralton A
  • Thunderbay CS
  • Belleville
Overall there are more decreasing AMS trends in southern Ontario (top table) than in northern Ontario. (Note the divide for southern and northern climate stations was taken as latitude of 44 degrees so Brockville, Kingston, Kemptville and Ottawa stations are in the northern group.)

The changes in IDF design intensity values for southern Ontario follow the regional trends in AMS values. This is what is expected since IDF statistics are derived from the observed AMS data. While Table 17 above showed changes in IDF values between the v2.00 and 3.10 datasets, essentially the difference resulting from accounting for the last 10 years of observations, southern Ontario IDF changes over a longer period were assessed in the NRC guidelines. The following figure shows the range in design intensities at long term stations since 1990 (Appendix E, Figure 2): 


Overall 2-year rainfall intensities, representing smaller storm severity, have decreased. Meanhile 100-year intensities have increased and decreased. This analysis aggregates all durations. Given the variability from station to station shown earlier (e.g., Toronto City has decreasing trends while Toronto North York has increasing trends, trends in long and short durations are inconsistent at individual stations), there is a benefit in aggregating larger sets of data (across durations and geography) to estimate overall regional trends.

(Aside - the analysis of southern Ontario IDF trends in the NRC guideline presented above were recently updated to reflect the v3.20 datasets and average trends for durations within each return period were analyzed as well. Results are presented in this post: https://www.cityfloodmap.com/2021/10/rainfall-design-intensities-in-southern.html


The figure above shows more consistent decreases across durations for the small storm intensities (i.e., 2 to 5-year return periods.)