Pipe Bomb
3.3 million miles of pipeline under your feet. Some were installed before your grandparents were born. We grade every operator, track every explosion, and tell you exactly what's buried next door — with government data and no mercy.
Channel: Pipe Bomb Tagline: 3.3 million miles of pipeline under your feet. Some were installed before your grandparents were born. We grade every operator, track every explosion, and tell you exactly what’s buried next door — with government data and no mercy. Niche: Consumer-facing US pipeline safety accountability intelligence — operator safety report cards, state-level infrastructure age scorecards, incident cause analysis, enforcement action tracking, proximity risk alerts, and weekly “blast reports” translating PHMSA’s 50+ years of incident and infrastructure data into gorgeous, opinionated, data-journalism that answers the question every homeowner near a pipeline right-of-way is asking: Should I be worried? Target audience: Homeowners near pipeline corridors (tens of millions), environmental justice communities, local government officials, first responders, real estate buyers doing due diligence, journalists covering energy infrastructure, pipeline safety advocates, and anyone who saw a pipeline explosion on the news and thought “could that happen here?” PHMSA data shows ~300 significant pipeline incidents per year causing hundreds of millions in damages. Why now: America’s pipeline infrastructure is aging catastrophically. Cast iron pipes from the 1800s still deliver gas in some cities. PHMSA’s “Call to Action” (2011) to replace the most dangerous pipes is only ~60% complete. The Merrimack Valley gas explosions (2018), the East Harlem building explosion (2014), and recurring incidents keep this in the news cycle. With current deregulatory trends, safety oversight is weakening just as infrastructure deteriorates. Meanwhile, PHMSA just released updated 2024 infrastructure data showing thousands of miles of bare steel and iron pipe still in service. There is ZERO consumer-facing translation layer between this incredible government data and the public.
Content Example:
🧨 OPERATOR REPORT CARD: Pacific Gas & Electric (PG&E)
Safety Grade: D+ | Trend: ↘ Declining | Last Updated: April 2026
The Numbers That Matter
PG&E operates 42,141 miles of natural gas pipeline across California — enough to wrap around Earth nearly twice. In the last decade, PHMSA records show 47 reportable incidents on PG&E’s system, resulting in 9 fatalities, 62 injuries, and $1.84 billion in total property damage.
That last number is dominated by a single event that changed pipeline regulation in America forever.
The San Bruno Crater
On September 9, 2010, at 6:11 PM, a 30-inch transmission pipeline installed in 1956 ruptured beneath a residential neighborhood in San Bruno, California. The explosion created a crater 72 feet long and 26 feet wide. Eight people died. Thirty-eight homes were destroyed. The fireball was visible from miles away and reached temperatures exceeding 1,000°F.
The cause? A defective pipe weld from the original 1956 installation that PG&E’s integrity management program had failed to identify — for 54 years. NTSB’s investigation found that PG&E didn’t even have accurate records of what pipe material was in the ground. They thought the segment was seamless pipe. It wasn’t.
The Enforcement Aftermath
PHMSA’s enforcement response was historic:
- $1.6 million civil penalty from PHMSA (the maximum at the time — a number that looks almost absurdly small given the damage)
- $1.6 billion in criminal fines and restitution from subsequent federal prosecution
- A Corrective Action Order requiring PG&E to verify records for its entire transmission system
- The incident directly led to the Pipeline Safety, Regulatory Certainty, and Job Creation Act of 2011, raising maximum civil penalties and mandating accelerated replacement of the most dangerous infrastructure
The Infrastructure Under Your Feet
Here’s what PHMSA’s latest annual report data reveals about PG&E’s gas distribution system:
| Metric | PG&E | National Average |
|---|---|---|
| Miles installed pre-1950 | 3,847 | — |
| % bare steel pipe remaining | 2.1% | 1.4% |
| Cast/wrought iron miles | 0 | — |
| Avg leaks repaired/year | 12,400+ | — |
| Excavation damage incidents | 890/yr | — |
PG&E has eliminated its cast iron inventory (good), but still operates thousands of miles of pipe installed in the 1940s and 1950s, when manufacturing standards, welding techniques, and corrosion protection were fundamentally different from modern practice.
The Verdict
PG&E’s post-San Bruno safety improvements are real — they’ve spent billions on pipeline modernization and integrity verification. But the sheer scale of their aging system, combined with California’s seismic risk and wildfire-adjacent corridors, means the underlying risk profile remains elevated. PHMSA enforcement data shows continued violations in recent years, though the severity has decreased.
Grade methodology: Weighted composite of incident rate per mile, enforcement action frequency, infrastructure age distribution, and trend direction over 5 years.
Data Sources:
- PHMSA Incident Reports (1970-present) — downloadable tab-delimited text files from https://www.phmsa.dot.gov/data-and-statistics/pipeline/distribution-transmission-gathering-lng-and-liquid-accident-and-incident-data. Updated as operators file reports. Includes: date, location (state/county/city/lat-long), operator, cause, fatalities, injuries, property damage, commodity, barrels released. Free, no API key needed — direct ZIP file downloads.
- PHMSA Annual Reports (Mileage & Facilities) — downloadable from https://www.phmsa.dot.gov/data-and-statistics/pipeline/pipeline-mileage-and-facilities. Infrastructure inventory: miles by material type (plastic, coated steel, bare steel, cast iron), diameter, decade installed, pressure. State and operator level.
- PHMSA Enforcement Data — https://primis.phmsa.dot.gov/enforcement-data/. Enforcement actions with case details, violation descriptions, proposed and assessed penalties. Exportable.
- PHMSA 20-Year Trend Portal — https://www.phmsa.dot.gov/data-and-statistics/pipeline/pipeline-incident-20-year-trends via portalpublic.phmsa.dot.gov. Interactive (scrapable) trend reports: serious, significant, and all reported incidents. Filterable by state and system type.
- Pipeline Replacement Tracking — https://www.phmsa.dot.gov/data-and-statistics/pipeline-replacement/pipeline-replacement-background. Cast/wrought iron inventory, bare steel inventory, decade-installed inventory by state.
- NPMS (National Pipeline Mapping System) — https://www.npms.phmsa.dot.gov/. Geographic pipeline location data, searchable by county/zip.
- NTSB Pipeline Investigation Reports — https://www.ntsb.gov/investigations/ — major accident investigation reports with root cause analysis (scrape the pipeline category)
- NRC (National Response Center) — https://nrc.uscg.mil/ — hazmat release reports, many pipeline-related
- EIA Natural Gas Data — https://www.eia.gov/naturalgas/data.php — consumption, infrastructure, and capacity context
Automation Pipeline:
- Schedule: Weekly full rebuild (Sundays), daily incident check (GitHub Actions cron)
- Collect:
- Weekly: Download PHMSA incident ZIP files, annual report data, enforcement exports
- Daily: Check PHMSA newsroom RSS for new enforcement actions and incident reports
- Monthly: Scrape pipeline replacement progress data, NTSB new investigations
- Process: Parse tab-delimited PHMSA data → aggregate by operator, state, cause → compute safety scores → generate rankings → identify trend changes → flag new incidents
- Generate:
- AI writes narrative analysis for each operator report card and state scorecard
- Auto-generate D3.js/Chart.js visualizations: incident trend lines, cause breakdown charts, infrastructure age distributions, state choropleth maps
- Generate social-share card images (operator grade + key stat) via Satori/OG image generation
- AI synthesizes weekly “Blast Report” dispatch highlighting new incidents, enforcement actions, and infrastructure milestones
- Publish: Astro static site → GitHub Pages. Incremental builds (only regenerate changed operator/state pages)
Tech Stack:
- Static site: TypeScript + Astro (fast, great SEO, island architecture for interactive charts)
- Charts: D3.js for maps, Chart.js/Observable Plot for standard visualizations
- Image generation: Satori + @resvg/resvg-js for OG/social cards, AI-generated hero illustrations via DALL-E/Flux
- Data collection: Node.js scripts (fetch ZIPs, parse TSV, aggregate)
- Data storage: JSON/SQLite in repo (PHMSA data is manageable in size)
- CI/CD: GitHub Actions (cron: daily incident check + weekly full rebuild)
- Hosting: GitHub Pages (free) or Cloudflare Pages
Monetization Model:
- Donations/Tips: Buy Me a Coffee, Ko-fi — “Help us keep grading pipeline operators” (safety journalism angle drives guilt-donations)
- Newsletter premium tier: “The Blast Report” — weekly email dispatch with incident analysis, enforcement updates, and “worst operators this month” rankings. Free tier gets monthly. Paid ($5/mo) gets weekly with operator deep dives
- Real estate data licensing: Pipeline proximity risk reports for real estate platforms (B2B angle — Zillow/Redfin integrations)
- Affiliate: Home gas leak detectors ($20-80 products, 5-8% commissions), emergency preparedness kits, carbon monoxide detectors
- Consulting leads: Pipeline safety training, community emergency planning
- Sponsorship: Environmental law firms, home inspection companies, gas detector manufacturers
- Projected month-1 revenue: $50-200 (donations from early viral content, newsletter signups)
- Projected month-6 revenue: $1,500-4,000 (newsletter subs + affiliate from seasonal incident coverage + first B2B inquiries)
Launch Complexity: 3/5 — PHMSA data is well-structured (tab-delimited, documented), but the volume is substantial (50+ years of incidents) and computing meaningful safety scores requires careful methodology. Pipeline mapping integration adds moderate complexity. 2-3 weeks for MVP. Content Quality Score: 5/5 — This is genuinely life-safety information. The content is inherently valuable: every homeowner near a pipeline wants to know their operator’s safety record. The data is authoritative (federal government source), the analysis is unique (nobody else computes operator grades), and the narrative layer makes dry data riveting. Automation Score: 5/5 — PHMSA provides downloadable data files. No scraping fragile HTML — these are structured datasets in ZIP archives. Enforcement data is exportable. GitHub Actions cron handles everything. After initial setup, this runs completely hands-off. Revenue Potential: 5/5 — Pipeline safety intersects with real estate (huge market), insurance, home safety products, and legal. The B2B licensing angle (pipeline proximity risk reports) is potentially the biggest revenue channel. Newsletter has strong conversion potential because the topic is personal (literally under your house). Every major pipeline incident drives traffic spikes. Total: 18/20
Why This Will Work: Psychology: This exploits the “invisible threat” anxiety — there are literally explosive pressurized pipelines beneath residential neighborhoods, and most people have no idea what’s in the ground, how old it is, or whether the operator has a history of violations. The moment someone Googles “pipeline safety near me” and lands on an operator report card showing a D- grade for their local gas company, they’re hooked. They’ll share it, bookmark it, subscribe.
Market logic: PHMSA has been collecting pipeline data since 1970 — one of the richest public safety datasets in the US government — and NOBODY has turned it into consumer-facing content. The data downloads are literally tab-delimited text files in ZIP archives. It’s as automatable as it gets. Meanwhile, pipeline incidents generate massive news cycles (San Bruno killed 8 people, Merrimack Valley forced 30,000 evacuations) but there’s never been a persistent, always-updated resource to contextualize them.
The real estate angle is the sleeper monetization play. When people are buying a home, they research flood zones, crime rates, school ratings — but almost never pipeline proximity and operator safety records. This site becomes the “pipeline score” that real estate agents and home buyers reference.
Risk & Mitigation:
- Risk: PHMSA changes data format or removes download access → Mitigation: Store historical snapshots in repo, adapt parsers as needed. Multiple data sources provide redundancy.
- Risk: Operators challenge safety grade methodology → Mitigation: Publish methodology transparently, use only PHMSA’s own data, add disclaimers. Government data = solid legal ground.
- Risk: Low traffic between major incidents → Mitigation: Evergreen operator report cards and state scorecards provide continuous SEO value. Infrastructure age content is always relevant. Newsletter retention bridges traffic valleys.
- Risk: Real estate B2B is slow to develop → Mitigation: Donations + newsletter + affiliate provide baseline revenue while B2B matures.
Channel Soul
Name: Pipe Bomb — provocative, memorable, immediately communicates danger + data. Dual meaning: literal (pipeline explosions) and figurative (information bombshell).
Mascot: A grizzled, hard-hat-wearing badger named “Dig” — tunnels underground, knows what’s buried, doesn’t take any crap from anyone. Illustrated in a gritty, slightly vintage industrial style. Think: union construction poster meets data journalism.
Voice: Blue-collar investigative journalist. Straight-talking, slightly angry, deeply informed. Not academic or preachy — more like a veteran pipeline inspector who got fed up with the industry and decided to blow the whistle. Uses industrial metaphors. Respects workers, holds operators accountable.
Opinion: The pipeline industry’s self-reported safety record is misleading. Infrastructure replacement is decades behind schedule. Maximum civil penalties are laughably small compared to operator profits. The “Call to Action” was a good start but pace is too slow. Consumer ignorance is the industry’s best friend.
Running bits:
- “Worst Operator of the Month” — monthly operator accountability spotlight
- “Pipe Dream” — segment debunking industry safety marketing claims
- “Dig’s Dispatch” — the weekly newsletter, written “by” the badger mascot
- “Under Pressure” — profiles of the oldest, most concerning pipeline segments still in service
- “The Iron Countdown” — tracking remaining cast iron pipe miles (goal: zero)
Visual Style: Industrial-meets-data. Dark backgrounds (charcoal/navy), accent colors in safety orange and danger red. Bold condensed typography. Technical drawings and blueprint aesthetic for backgrounds. Charts use high-contrast colors. State maps use heat-map gradients (green → yellow → orange → red). Clean, authoritative, slightly menacing.