{"dot_number":"3072474","summary":{"total":3,"fatalities":0,"injuries":1},"crashes":[{"crash_id":"4819246","dot_number":"3072474","report_state":"TX","report_date":"20240924","report_time":"1737","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJGLBG4BSAW3505","vehicle_license":"1M19298","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TEJAS TUBULAR OILFIELD SERVICES LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:34"},{"crash_id":"4771268","dot_number":"3072474","report_state":"LA","report_date":"20240620","report_time":"1507","city":"RURAL","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FD0W5HT5HEE85160","vehicle_license":"MBT5721","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TEJAS TUBULAR OILFIELD SERVICES LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"3836413","dot_number":"3072474","report_state":"TX","report_date":"20190812","report_time":"1300","city":"HOUSTON","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1GB7KZBK4AF142687","vehicle_license":"JXY4510","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TEJAS TUBULAR OILFIELD SERVICES LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:22"}]}