{"dot_number":"1200897","summary":{"total":34,"fatalities":1,"injuries":21},"crashes":[{"crash_id":"4946126","dot_number":"1200897","report_state":"AL","report_date":"20250514","report_time":"1250","city":"RURAL DALLAS","state":"AL","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XP5DB9X25N861324","vehicle_license":"R683589","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:15"},{"crash_id":"4645288","dot_number":"1200897","report_state":"TX","report_date":"20231017","report_time":"0354","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AA13YXXW118766","vehicle_license":"R486490","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:10"},{"crash_id":"4532919","dot_number":"1200897","report_state":"TX","report_date":"20230315","report_time":"2010","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AA18Y74N157440","vehicle_license":"R518108","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:53"},{"crash_id":"4417231","dot_number":"1200897","report_state":"TX","report_date":"20220826","report_time":"1600","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1AA18Y74N157440","vehicle_license":"R518108","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:16"},{"crash_id":"4131043","dot_number":"1200897","report_state":"TX","report_date":"20210318","report_time":"1231","city":"MOUNT ENTERPRISE","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKWD49XXAJ269726","vehicle_license":"R415573","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:14"},{"crash_id":"4003912","dot_number":"1200897","report_state":"LA","report_date":"20200716","report_time":"0742","city":"5800","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M2AA18Y94N155720","vehicle_license":"R451047","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:42"},{"crash_id":"3925794","dot_number":"1200897","report_state":"TX","report_date":"20200127","report_time":"0715","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUJA6CG35LU32271","vehicle_license":"R386998","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3908368","dot_number":"1200897","report_state":"TX","report_date":"20191214","report_time":"1250","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"2WKPDCCHXTK941451","vehicle_license":"R458619","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:11"},{"crash_id":"3705772","dot_number":"1200897","report_state":"TX","report_date":"20181129","report_time":"1120","city":"RURAL PANOLA COUNTY","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FVJA6CK47LY85205","vehicle_license":"R393509","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:24"},{"crash_id":"3371529","dot_number":"1200897","report_state":"TX","report_date":"20170301","report_time":"1942","city":"CONROE","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPWDP9X6DD179147","vehicle_license":"R269255","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:54"},{"crash_id":"2736315","dot_number":"1200897","report_state":"TX","report_date":"20130715","report_time":"1221","city":"RURAL LIBERTY COUNTY","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1AK07Y96N006319","vehicle_license":"RR6J56","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:24"},{"crash_id":"2606229","dot_number":"1200897","report_state":"LA","report_date":"20120924","report_time":"0807","city":"1605","state":"LA","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XP5DB9X55N850723","vehicle_license":"RP1T38","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2574270","dot_number":"1200897","report_state":"TX","report_date":"20111108","report_time":"1310","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPXD49X8BD115935","vehicle_license":"RH8Y41","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:33"},{"crash_id":"2483784","dot_number":"1200897","report_state":"TX","report_date":"20110914","report_time":"1725","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"2FWJA3CV67AX59616","vehicle_license":"RK9X95","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:33"},{"crash_id":"2420122","dot_number":"1200897","report_state":"TX","report_date":"20110425","report_time":"1400","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2AA18Y6TW066258","vehicle_license":"R14353","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:43"},{"crash_id":"2349704","dot_number":"1200897","report_state":"TX","report_date":"20101229","report_time":"1315","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2AJ07Y97N006921","vehicle_license":"RC9M31","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:55"},{"crash_id":"2209854","dot_number":"1200897","report_state":"TX","report_date":"20091127","report_time":"0500","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2AN09Y29N003640","vehicle_license":"RC9J95","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:55"},{"crash_id":"2148982","dot_number":"1200897","report_state":"LA","report_date":"20090721","report_time":"0503","city":"904","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPXD49XX9D774304","vehicle_license":"RC9M57","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:56"},{"crash_id":"2138005","dot_number":"1200897","report_state":"LA","report_date":"20090623","report_time":"0908","city":"1600","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M2AN09YX9N004485","vehicle_license":"RC9J99","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2146676","dot_number":"1200897","report_state":"TX","report_date":"20090623","report_time":"1115","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"2HSFHAER2XC080413","vehicle_license":"RD5C47","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2127783","dot_number":"1200897","report_state":"LA","report_date":"20090522","report_time":"0623","city":"1605","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2N187Y6KW027387","vehicle_license":"R14368","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2114786","dot_number":"1200897","report_state":"LA","report_date":"20090407","report_time":"2143","city":"1600","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2AJ06Y16N004516","vehicle_license":"R14363","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2095179","dot_number":"1200897","report_state":"TX","report_date":"20090204","report_time":"0900","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AJ06Y87N007273","vehicle_license":"R14370","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:19"},{"crash_id":"2079222","dot_number":"1200897","report_state":"TX","report_date":"20081126","report_time":"1050","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2AJ07Y77N006920","vehicle_license":"R14366","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:20"},{"crash_id":"2050743","dot_number":"1200897","report_state":"TX","report_date":"20081025","report_time":"0846","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M2AJ07Y97N006921","vehicle_license":"R14365","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:20"},{"crash_id":"2039764","dot_number":"1200897","report_state":"TX","report_date":"20081007","report_time":"0507","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X0XD466146","vehicle_license":"RB4K03","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:20"},{"crash_id":"2024487","dot_number":"1200897","report_state":"TX","report_date":"20080825","report_time":"1300","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M2P267Y7UM027294","vehicle_license":"RB4K07","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:33"},{"crash_id":"2024087","dot_number":"1200897","report_state":"TX","report_date":"20080812","report_time":"1215","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1AJ06Y87N007273","vehicle_license":"R9GG80","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:33"},{"crash_id":"2004903","dot_number":"1200897","report_state":"TX","report_date":"20080505","report_time":"1018","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M2AA18Y6TW066258","vehicle_license":"R14353","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:42"},{"crash_id":"1896375","dot_number":"1200897","report_state":"LA","report_date":"20071012","report_time":"0838","city":"","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AA08X8YW020203","vehicle_license":"R9ST18","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1764257","dot_number":"1200897","report_state":"TX","report_date":"20070205","report_time":"1619","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1M1AJ06Y46N003624","vehicle_license":"R7SR34","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:27"},{"crash_id":"1746402","dot_number":"1200897","report_state":"LA","report_date":"20061208","report_time":"0300","city":"","state":"LA","fatalities":1,"injuries":0,"tow_away":0,"vin":"1M2AJ06Y16N004516","vehicle_license":"R7XR67","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:37"},{"crash_id":"1576941","dot_number":"1200897","report_state":"TX","report_date":"20051126","report_time":"1500","city":"","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1M1AJ06Y46N003624","vehicle_license":"R7SR34","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:09"},{"crash_id":"1561169","dot_number":"1200897","report_state":"TX","report_date":"20051026","report_time":"0750","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1M1AJ06Y26N003623","vehicle_license":"R7SR33","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"SAND HILL FOUNDATION LLC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:28"}]}