Crash File
The FMCSA Crash File contains data from state police crash reports involving drivers and vehicles of motor carriers operating in the U.S. Each report contains about 80 data elements pertaining to the motor carrier, driver, vehicles, and circumstances of a crash. Due to sensitive and/or privacy restrictions, driver, and hazardous materials data are not included in any crash files released to the public.
The Crash File may contain multiple records for a crash. Separate reports are entered for each commercial motor vehicle involved in a crash. These multiple reports can be distinguished by the Crash Report Number field.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"datahub-transportation-gov/crash-file-aayw-vxb3\".\"crash_file\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
