🚗 NYC Traffic Collisions Scraper

🚀 Export NYC Department of Transportation motor vehicle collision records: date, location, injuries, fatalities, contributing factors, vehicle types.

🕒 Last updated: 2026-05-25 · 📊 25 fields per record · 🚗 NYC · 2012-present · All NYC-reported vehicle collisions across 5 boroughs

The NYC Traffic Collisions Scraper extracts records from the NYC Department of Transportation Motor Vehicle Collisions / Crashes dataset. Each record includes collision ID, crash date/time, borough, ZIP, lat/lon, street names, persons/pedestrians/cyclists/motorists injured and killed, contributing factors and vehicle types - exported as CSV, Excel, JSON, or XML.

The scraper supports filtering by borough (Manhattan, Bronx, Brooklyn, Queens, Staten Island). Coverage spans every NYPD-reported collision from 2012 to the present.

🎯 Target Audience	💡 Primary Use Cases
Insurance analysts, urban planners, traffic-safety researchers, journalists, civic-tech	Road-safety analysis, insurance underwriting, Vision-Zero reporting, urban planning, journalism

📋 What the NYC Traffic Collisions Scraper does

• Connects to the official NYC DOT Motor Vehicle Collisions dataset.
• Paginates through every record matching your filters.
• Normalises each record into a flat, analysis-ready row.
• Exports as CSV, Excel, JSON or XML - directly from your Apify dataset.
• Refreshes on demand or on schedule (hourly, daily, weekly).

💡 Why it matters: stop copy-pasting from a portal that paginates 100 records at a time. One click, full dataset, your format.

🎬 Full Demo

🚧 Coming soon

⚙️ Input

Field	Type	Description
maxItems	integer	Max collisions. Free: 10. Paid: up to 1,000,000.
borough	string (enum)	MANHATTAN · BRONX · BROOKLYN · QUEENS · STATEN ISLAND

Example 1 - Brooklyn collisions

{
  "maxItems": 500,
  "borough": "BROOKLYN"
}

Example 2 - Citywide last 1000

{
  "maxItems": 1000
}

⚠️ Good to Know: free users are capped at 10 records per run as a preview. Upgrade to any paid plan to unlock full exports (up to 1,000,000 records). Data is collected directly from the official public source - no login or API key required.

📊 Output

Field	Type	Description
🖼 imageUrl	string	Always null
📌 title	string	Display label (nullable)
🔗 url	string	Source dataset URL
🆔 id	string	NYC collision ID
🔢 collision_id	string	NYC collision ID
📅 crash_date	string	Crash date
⏰ crash_time	string	Crash time
🗺 borough	string	Borough
📮 zip_code	string	ZIP code
📍 latitude	number	Latitude
📍 longitude	number	Longitude
🛣 on_street_name	string	On-street name
🛣 off_street_name	string	Off-street name
🛣 cross_street_name	string	Cross-street name
🤕 number_of_persons_injured	integer	Persons injured
💀 number_of_persons_killed	integer	Persons killed
🚶 number_of_pedestrians_injured	integer	Pedestrians injured
🚴 number_of_cyclist_injured	integer	Cyclists injured
🚗 number_of_motorist_injured	integer	Motorists injured
📋 contributing_factor_vehicle_1	string	Contributing factor #1
📋 contributing_factor_vehicle_2	string	Contributing factor #2
🚙 vehicle_type_code1	string	Vehicle type #1
🚙 vehicle_type_code2	string	Vehicle type #2
🕒 scrapedAt	string	ISO scrape timestamp
❌ error	string	Populated on failure

Sample record (real run output):

{
  "title": null,
  "url": "https://data.cityofnewyork.us/Public-Safety/Motor-Vehicle-Collisions-Crashes/h9gi-nx95",
  "id": "4900037",
  "collision_id": "4900037",
  "crash_date": "2026-05-19T00:00:00.000",
  "crash_time": "16:30",
  "borough": "QUEENS",
  "zip_code": "11429",
  "latitude": 40.71358,
  "longitude": -73.73729,
  "cross_street_name": "218-24 HEMPSTEAD AVE",
  "number_of_persons_injured": 1,
  "number_of_pedestrians_injured": 0,
  "number_of_cyclist_injured": 0,
  "number_of_motorist_injured": 1,
  "contributing_factor_vehicle_1": "Passing or Lane Usage Improper",
  "contributing_factor_vehicle_2": "Unspecified",
  "vehicle_type_code1": "4 dr sedan",
  "vehicle_type_code2": "4 dr sedan",
  "scrapedAt": "2026-05-25T22:26:02.870Z",
  "error": null
}

✨ Why choose this Actor

✅	What you get
🎯	Direct extraction from the official NYC DOT Motor Vehicle Collisions portal
📊	25 normalised fields per record
⚡	Run on-demand or on schedule
📁	CSV, Excel, JSON, XML - your choice
🔌	Integrates with Make, Zapier, Slack, Airbyte, Google Drive
🆓	Free preview (10 records) - no credit card
🌍	Public data only - no login or API key required
🚀	Maintained and updated as the source schema evolves

📈 How it compares to alternatives

Approach	Speed	Maintenance	Cost	Export formats
Copy-paste from portal	🐌 Hours	🛠 High	Free	Limited
Build your own scraper	🐢 Days	🛠 Ongoing	Dev time	DIY
Generic SaaS scraper	🚶 Slow	🛠 Manual config	$$$	Generic
This Actor	🚀 Minutes	✅ Maintained	💸 From free	CSV / Excel / JSON / XML

🚀 How to use

1. Create a free Apify account with $5 credit - no credit card required.
2. Open the NYC Traffic Collisions Scraper page in Apify Store and click Try for free.
3. Configure the input (see Input section above).
4. Click Start - the run will produce a downloadable dataset.
5. Export as CSV, Excel, JSON or XML, or stream to your destination via integrations.

💼 Business use cases

Lead generation & sales

🎯	Example
📞	Build target lists filtered by category, region, or status
🧠	Enrich CRM records with up-to-date public attributes

Compliance & risk

🎯	Example
🔍	Continuous monitoring of changes in official records
📋	Audit-trail-friendly exports for compliance teams

Market research

🎯	Example
📊	Track market dynamics over time
🌍	Benchmark across regions, categories, or operators

Operations & automation

🎯	Example
🔄	Schedule recurring pulls and pipe straight into your BI tool
🚨	Alert on threshold or status changes

🔌 Automating NYC Traffic Collisions Scraper

• Make - receive new records into a scenario and route them anywhere.
• Zapier - trigger on new dataset rows and push to 6,000+ apps.
• Slack - post fresh records into a channel for the team.
• Airbyte - sync the dataset into your warehouse (BigQuery, Snowflake, Redshift, Postgres).
• GitHub - store snapshots in a repo for diffing over time.
• Google Drive / Sheets - auto-append rows to a spreadsheet.

🌟 Beyond business use cases

Research

• Academic studies on NYC DOT Motor Vehicle Collisions trends, distributions and outliers.

Personal projects

• Hobbyist data viz, dashboards, blog posts and side-projects.

Non-profit

• Open-data journalism, transparency audits, civic-tech tools.

Experimentation

• Train ML models on a clean, structured slice of public data.

🤖 Ask an AI assistant about this scraper

• ChatGPT
• Claude
• Perplexity
• Microsoft Copilot

Paste this README into any of them and ask: "How would I use the NYC Traffic Collisions Scraper to solve X?"

❓ Frequently Asked Questions

❓ Is the data accurate?

Yes - the scraper pulls directly from the official NYC DOT Motor Vehicle Collisions public dataset. Accuracy mirrors the source.

❓ Do I need an API key or login?

No. Everything is public data. Just run the actor.

❓ How fresh is the data?

Each run fetches the latest available records from data.cityofnewyork.us at request time.

❓ How many records can I export?

Free users: 10 (preview). Paid users: up to 1,000,000 per run.

❓ Can I export to Excel?

Yes - choose CSV, Excel, JSON or XML on the dataset page.

❓ Can I schedule recurring runs?

Yes - Apify Schedules supports hourly/daily/weekly/cron. Pair with integrations for auto-delivery.

❓ Is this affiliated with NYC DOT Motor Vehicle Collisions?

No. This is an independent tool that exposes publicly available data via a structured interface.

❓ What happens if the source goes down?

The actor surfaces a clean error record. Re-run when the source is back up.

❓ Can I filter the output?

Yes - the input section above lists every supported filter, exposed as a typed input field.

❓ Can I use it for commercial purposes?

Yes, subject to the source dataset's terms of use. Always review the original publisher's license.

❓ Where can I get help?

Open our contact form - we usually respond within one business day.

🔌 Integrate with any app

Make · Zapier · Slack · Airbyte · GitHub · Google Drive · Google Sheets · BigQuery · Snowflake · Redshift · Postgres · MySQL · MongoDB · Kafka · Webhooks · REST API.

🔗 Recommended Actors

Actor	What it does
OurAirports Global Airport Database Scraper	Worldwide airport reference dataset
FINRA BrokerCheck Scraper	US broker & advisor licensing records
FAA Aircraft Registry Scraper	US civil aircraft registration records
SEC EDGAR Filings Scraper	Public company filings & financials

💡 Pro Tip: browse the complete ParseForge collection for 50+ data-export actors.

🆘 Need Help? Open our contact form

⚠️ Disclaimer: This is an independent tool and is not affiliated with, endorsed by, or sponsored by NYC DOT Motor Vehicle Collisions. It only collects publicly available data published by the source. Always review the source's terms of use before commercial deployment.