Canadian pipeline incident safety intelligence (annual)

Name: Canadian pipeline incident safety intelligence (annual)
Creator: Canada Energy Regulator
License: https://open.canada.ca/data/en/dataset/7dffedc4-23fa-440c-a36d-adf5a6cc09f1
Keywords: canada, pipelines, incidents, energy, environment, quarterly, rankings

Commercial use OKFresh

Query in workbench

The full snapshot isn't published yet — check back after the next refresh.Download sample CSV Download sample JSONSample rows only (up to 20) — not the complete dataset.

Operator-by-year pipeline safety intelligence for Canada from the Canada Energy Regulator's comprehensive incident file (2008 to present, quarterly vintage): 63 raw company names entity-resolved to canonical pipeline systems with parent companies, a documented 0-100 per-incident severity score aggregated to operator-year means with deterministic ranks, and CER cause categories consolidated into cause groups with fractional attribution. Counts cover significant incidents, ruptures, fatalities, injuries, evacuations, and released volumes. Quarterly.

Source: Canada Energy Regulator
Rows: 247
Columns: 32
Source cadence: Quarterly
Last refreshed: Sep 27, 2026
Theme: energy

Column	Type	Description
year	integer	Incident year (2008 to present). Join key.
operator_canonical	string	Canonical pipeline-system operator after entity resolution of the 63 raw CER company-name variants. Primary key with year.
parent_company	string	Best-effort ultimate parent (September 2026). 'Not mapped' means ownership was not verified, not independence.
operator_aliases	string	Raw CER Company names resolved to this operator, '; '-joined.
country_code	string	ISO 3166-1 alpha-3 country code (constant CAN).
provinces	string	Provinces with incidents this year, '; '-joined.
n_provinces	integer	Count of provinces with incidents.
incident_count	integer	CER incidents for this operator-year.
incident_rank	integer	Within-year rank by incident_count (1 = most incidents).
significant_count	integer	Incidents flagged Significant by the CER.
significant_share	float	significant_count / incident_count, 0-1. (unit: ratio)
rupture_count	integer	Incidents involving a pipeline rupture.
fatalities	integer	Deaths recorded across incidents.
injuries	integer	Individuals injured across incidents.
evacuations	integer	People evacuated across incidents.
volume_released_m3	float	Sum of reported released volumes. Blank upstream volumes are excluded (see n_volume_reported), never imputed. (unit: m3)
n_volume_reported	integer	Incidents with a numeric released volume this operator-year.
fire_explosion_count	integer	Incidents whose type includes Fire or Explosion.
release_count	integer	Incidents whose type includes Release of Substance.
n_open	integer	Incidents not yet marked Closed by the CER.
severity_mean	float	Mean of the documented 0-100 per-incident severity scores (+15 Significant, +25 rupture, +30 fatality, +15 injury, +10 fire/explosion, +10 release, +min(15, 5*log10(1+m3))).
severity_max	float	Maximum per-incident severity this operator-year.
severity_rank	integer	Within-year rank by severity_mean (1 = highest mean severity; operator_canonical asc tie-break).
top_what_group	string	Dominant consolidated 'what happened' cause group by fractional attribution.
top_what_share	float	Fractional share of the top what-group, 0-1. (unit: ratio)
top_why_group	string	Dominant consolidated 'why it happened' cause group by fractional attribution.
top_why_share	float	Fractional share of the top why-group, 0-1. (unit: ratio)
substances	string	Distinct substances involved, '; '-joined.
substance_top	string	Most frequent substance this operator-year.
pipeline_types	string	Distinct CER pipeline/facility types, '; '-joined.
vintage	string	Fetch date (YYYY-MM-DD) of the CER file behind this snapshot.
row_hash	string	Deterministic 16-hex hash of vintage + operator + year + rounded numerics; identical input hashes identically.

First 10 sample rows — a preview, not the complete dataset.

year	operator_canonical	parent_company	operator_aliases	country_code	provinces	n_provinces	incident_count	incident_rank	significant_count	significant_share	fatalities	injuries	volume_released_m3	n_volume_reported	fire_explosion_count	release_count	severity_mean	severity_max	severity_rank	top_what_group	top_what_share	top_why_group	top_why_share	substances	substance_top	pipeline_types	vintage	row_hash
2,008	Alliance Pipeline	Enbridge Inc. / Pembina Pipeline Corp. JV	Alliance Pipeline Ltd.	CAN	Alberta; Saskatchewan	2	2	4	0	0	0	0	800	2	0	2	17.25	24.5	4	Corrosion & cracking	0.5	Maintenance	1	Natural Gas - Sweet	Natural Gas - Sweet	Transmission	2026-09-27	da4eb0f828ac95cd
2,008	Emera Brunswick Pipeline	Emera Inc.	Emera Brunswick Pipeline Company Ltd.	CAN	New Brunswick	1	2	4	2	1	0	1	0	0	0	0	22.5	30	2	Equipment failure	0.5	Maintenance	0.5	—	Not Applicable	—	2026-09-27	fecf6b608ca03138
2,008	EnCana (Ovintiv)	Ovintiv Inc.	EnCana Corporation	CAN	Nova Scotia	1	1	7	1	1	0	0	0	0	0	0	15	15	6	Equipment failure	1	Maintenance	1	—	Not Applicable	—	2026-09-27	a69f0f6b9c8d798c
2,008	Enbridge Pipelines	Enbridge Inc.	Enbridge Pipelines Inc.	CAN	Alberta; Manitoba; Saskatchewan	3	13	2	2	0.154	2	0	174.4	7	4	7	18.44	45	3	Equipment failure	0.385	Maintenance	0.577	Crude Oil - Sweet; Crude Oil - Synthetic; Diesel Fuel	Not Applicable	Transmission	2026-09-27	cae1392fb0795e64
2,008	Foothills Pipe Lines	TC Energy	Foothills Pipe Lines Ltd.	CAN	Alberta	1	1	7	0	0	0	0	0	1	0	1	10	10	10	Material defect & deterioration	1	Maintenance	1	Natural Gas - Sweet	Natural Gas - Sweet	—	2026-09-27	0ec5c005e8a5a400
2,008	Plains Midstream	Plains All American Pipeline	Plains Marketing Canada, L.P.	CAN	Saskatchewan	1	1	7	0	0	0	0	4	1	0	1	13.5	13.5	7	Equipment failure	1	Maintenance	1	Crude Oil - Sweet	Crude Oil - Sweet	—	2026-09-27	cd14b10a2b66a6b8
2,008	Spectra Energy (Empress/Midstream)	Enbridge Inc.	Spectra Energy Empress Management Inc. as General Partner and Agent for Spectra Energy Empress L.P.	CAN	Saskatchewan	1	1	7	0	0	0	0	0.5	1	0	1	10.9	10.9	9	Equipment failure	1	Maintenance	1	Propane	Propane	—	2026-09-27	128aceb1b0918c4d
2,008	Trans Mountain Pipeline	Trans Mountain Corporation (federal Crown)	Trans Mountain Pipeline Inc.; Trans Mountain Pipeline ULC	CAN	British Columbia	1	2	4	2	1	0	2	0	0	0	0	30	30	1	Operations & human factors	0.75	Human factors	0.25	—	Not Applicable	—	2026-09-27	0f62c634f55d6e90
2,008	TransCanada PipeLines	TC Energy	TransCanada PipeLines Limited	CAN	British Columbia; Manitoba; Ontario; Saskatchewan	4	19	1	0	0	0	0	388	16	3	16	11.51	22.2	8	Corrosion & cracking	0.316	Maintenance	0.474	Natural Gas - Sweet	Natural Gas - Sweet	Transmission	2026-09-27	781c53e60673befb
2,008	Westcoast Energy (Spectra)	Enbridge Inc.	Westcoast Energy Inc., carrying on business as Spectra Energy Transmission	CAN	British Columbia	1	13	2	5	0.385	0	0	22.105	10	3	10	16.77	27.4	5	Material defect & deterioration	0.462	Maintenance	0.603	Amine; Butane; Condensate; Glycol; Mixed HVP Hydrocarbons; Natural Gas - Sour; Natural Gas - Sweet; Potassium Hydroxide (caustic solution)	Not Applicable	—	2026-09-27	bf9d394171482a7f

Profiled Sep 27, 2026 from snapshot 20260927T203036Z-2a9054a63817

Measured

Completeness: 100%
Rows: 247
Columns: 32
Columns with gaps: 0

Rows per yearyear · 2008–2026 · 19 years

20082026

Column	Missing	Distinct	Range	Distribution
yearbigint	0%	21	2,008 → 2,026median 2,017
operator_canonicalvarchar	0%	36	—	Enbridge Pipelines19 Trans Mountain Pipeline19 TransCanada PipeLines19
parent_companyvarchar	0%	21	—	Not mapped51 TC Energy50 Enbridge Inc.49
operator_aliasesvarchar	0%	61	—	Trans Mountain Pipeline ULC18 TransCanada PipeLines Limited17 Trans-Northern Pipelines Inc.16
country_codevarchar	0%	1	—	CAN247
provincesvarchar	0%	40	—	British Columbia31 Alberta30 Alberta; British Columbia29
n_provincesbigint	0%	6	1 → 6median 1	1 outside 1st–99th percentile
incident_countbigint	0%	35	1 → 68median 3	3 outside 1st–99th percentile
incident_rankbigint	0%	14	1 → 13median 6
significant_countbigint	0%	16	0 → 34median 0	2 outside 1st–99th percentile
significant_sharedouble	0%	49	0 → 1median 0
rupture_countbigint	0%	5	0 → 5median 0	2 outside 1st–99th percentile
fatalitiesbigint	0%	3	0 → 2median 0	1 outside 1st–99th percentile
injuriesbigint	0%	11	0 → 19median 0	3 outside 1st–99th percentile
evacuationsbigint	0%	17	0 → 405median 0	3 outside 1st–99th percentile
volume_released_m3double	0%	162	0 → 20,800,000median 5	3 outside 1st–99th percentile
n_volume_reportedbigint	0%	23	0 → 35median 1	3 outside 1st–99th percentile
fire_explosion_countbigint	0%	18	0 → 28median 0	3 outside 1st–99th percentile
release_countbigint	0%	22	0 → 35median 1	2 outside 1st–99th percentile
n_openbigint	0%	6	0 → 11median 0	3 outside 1st–99th percentile
severity_meandouble	0%	165	0 → 65median 12	3 outside 1st–99th percentile
severity_maxdouble	0%	73	0 → 75median 22.4
severity_rankbigint	0%	18	1 → 17median 7	1 outside 1st–99th percentile
top_what_groupvarchar	0%	9	—	External interference98 Equipment failure63 Corrosion & cracking21
top_what_sharedouble	0%	68	0.214 → 1median 0.5	2 outside 1st–99th percentile
top_why_groupvarchar	0%	10	—	Maintenance92 Engineering & planning52 Natural / environmental51
top_why_sharedouble	0%	94	0.2 → 1median 0.548	3 outside 1st–99th percentile
substancesvarchar	0%	43	—	Natural Gas - Sweet78 75 Crude Oil - Sweet18
substance_topvarchar	0%	14	—	Not Applicable142 Natural Gas - Sweet64 Crude Oil - Sweet13
pipeline_typesvarchar	0%	12	—	Transmission153 51 Distribution8
vintagevarchar	0%	1	—	2026-09-27247
row_hashvarchar	0%	284	—	023dd4d99b20993b1 025564c35e83b4b21 0598919c655976941

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/cer_pipeline_safety_intel/ca_pipeline_incident_intel_annual" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/cer_pipeline_safety_intel/ca_pipeline_incident_intel_annual").json()
print(ds["title"], ds["rows"], "rows")

# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
    print(row)

API endpoint: https://datazimuts.com/v1/datasets/cer_pipeline_safety_intel/ca_pipeline_incident_intel_annual

Tip: fetch /llms.txt for the full machine-readable catalog.

Cite this snapshot

Pinned to snapshot 20260927T203036Z-2a9054a63817 and its content hash, so readers get exactly the data you used.

APA

Canada Energy Regulator. (2026). Canadian pipeline incident safety intelligence (annual) [Data set, snapshot 20260927T203036Z-2a9054a63817, sha256 2a9054a63817]. Datazimuts. Retrieved 2026-09-27, from https://datazimuts.com/en/datasets/cer_pipeline_safety_intel/ca_pipeline_incident_intel_annual?snapshot=20260927T203036Z-2a9054a63817

BibTeX

@misc{dz_cer_pipeline_safety_intel_ca_pipeline_in_2a9054a6,
  title        = {{Canadian pipeline incident safety intelligence (annual)}},
  author       = {{Canada Energy Regulator}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/cer_pipeline_safety_intel/ca_pipeline_incident_intel_annual?snapshot=20260927T203036Z-2a9054a63817}},
  note         = {Snapshot 20260927T203036Z-2a9054a63817, sha256 2a9054a63817a4585f9f34f047dd97d6b8622adaf03cc870950c38c5963c1d4b; accessed 2026-09-27}
}

Embed a table or a chart

Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=cer_pipeline_safety_intel%2Fca_pipeline_incident_intel_annual&lang=en&theme=auto&snapshot=20260927T203036Z-2a9054a63817&x=year&y=year&agg=avg" title="Canadian pipeline incident safety intelligence (annual)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

Canadian pipeline incident safety intelligence (annual)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key