{"dot_number":"2380512","summary":{"total":4,"fatalities":0,"injuries":0},"crashes":[{"crash_id":"4926726","dot_number":"2380512","report_state":"TN","report_date":"20250415","report_time":"1318","city":"CHATTANOOGA","state":"TN","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X07D731017","vehicle_license":"H3152HY","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MAGIC PIPE TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4549403","dot_number":"2380512","report_state":"MS","report_date":"20230213","report_time":"1406","city":"CENTERVILLE","state":"MS","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X47D655124","vehicle_license":"H3243HY","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MAGIC PIPE LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:53"},{"crash_id":"4375577","dot_number":"2380512","report_state":"TN","report_date":"20220626","report_time":"0120","city":"CHATTANOOGA","state":"TN","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGEBG6DLFH5626","vehicle_license":"P5613HY","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MAGIC PIPE LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:22"},{"crash_id":"3884116","dot_number":"2380512","report_state":"MS","report_date":"20191031","report_time":"1248","city":"PELAHATCHIE","state":"MS","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X75D854729","vehicle_license":"H1956HY","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"MAGIC PIPE LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:11"}]}