select id from content where statusid=1 and siteid=3 and id in(select contentid from content_properties where typeid=5 and propertyid =144047) order by publisheddate desc limit 0,20;select count(*) totalcount from content where statusid=1 and siteid=3 and id in(select contentid from content_properties where typeid=5 and propertyid =144047) order by publisheddate desc
Search «air crash» - Result Count 2 Item

VIDEO: Moment Aircraft Hit the Ground in China; 4 People Killed

Fri Sep 16, 2016 18:24:37

At the General Aviation Exhibition 2016 and Avclub Flight Carnival, a light aircraft LE-500 Little Eagle has crashed into a field beside the Luancheng Airport. The pilot and three passengers have killed.

Aftermath of Air Show’s Jet Crash in England, 11 Killed +VIDEO&PICS

Tue Aug 25, 2015 15:15:14

During Shoreham Airshow, “Hurricane G-HURR” crashed and 11 people lost their life, according to police 9 people are 'highly likely' to have died as dramatic dashcam footage of crash emerges.

2017 Alalam News Network. Islamic Republic of Iran Broadcasting. All Rights Reserved.