NTSB investigations, Outside the U.S.

183 cases where the defining event was Collision with terr/obj (non-CFIT).

Cases, newest first

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB GAA21WA031Accident · No injuriesClass 5 · ForeignCessna 208 · Sela, IndonesiaDec 26, 2020 · PK-SNR · Substantial damageNTSB CEN21WA061Accident · 3 fatalClass 5 · ForeignCessna 182 · Durango, MexicoNov 7, 2020 · XB-QOX · Substantial damageNTSB WPR21WA089Accident · 1 fatalClass 5 · ForeignCessna 182 · Cheworez, ZimbabweOct 23, 2020 · Z-YXY · Substantial damageNTSB CEN21WA115Accident · Serious injuriesClass 5 · ForeignCessna 185A · Romsey, United KingdomOct 7, 2020 · G-BLOS · DestroyedNTSB ERA21WA033Accident · 2 fatalClass 3 · ForeignANG 01 · Peremoha, UkraineOct 5, 2020 · UR-PNGD · DestroyedNTSB WPR21WA103AccidentClass 5 · ForeignCessna 150 · Kenitra, MoroccoAug 20, 2020 · CN-TCG · Substantial damageNTSB WPR21WA018Accident · 1 fatalClass 5 · ForeignOsprey 2 Amphibian · Maitland Aerodrome, AustraliaMay 17, 2020 · VH-WID · DestroyedNTSB ENG20WA048AccidentClass 5 · ForeignDe Havilland DHC2 · Sadiq Abad - Punjab, PakistanJan 12, 2020 · AP-AMB · DestroyedNTSB ERA19WA293Accident · 3 fatalClass 3 · ForeignBell 505 · Kazbegi, GeorgiaJun 6, 2019 · 4L-ADJ · DestroyedNTSB WPR11WA129Accident · 1 fatalForeign investigationCessna 310R · Bathurst Island, Australia, AustraliaOn February 5, 2011, at 1255 universal coordinated time, a Cessna 310R, VH-XGX, operated by a private individual, collided with terrain near Bathurst Island, Australia. The airplane was substantially damaged and the pilot, the sole occupant, was killed. The…Feb 5, 2011 · VH-XGX · Substantial damageNTSB WPR11WA127Accident · 2 fatalForeign investigationRobinson R44 · Cessnock, Australia, AustraliaOn February 4, 2011, at 0047 universal coordinated time, a Robinson R-44, VH-HFH, operated by Aero Logistics Pty, collided with terrain during an instructional flight near Cessnock, Australia. The helicopter was substantially damaged and the pilot and a…Feb 4, 2011 · VH-HFH · Substantial damageNTSB ERA11WA119Accident · 1 fatalForeign investigationAvions Robin DR400 · Guidonia Montecelio, ItalyOn January 11, 2011, about 1430 universal coordinated time, an Avions Pierre Robin, DR400/180R, Italian registration I-ITAV, crashed during takeoff, while towing a glider, and was destroyed by fire. The airplane was departing Guidonia Airport (LIRG), Guidonia…Jan 11, 2011 · I-ITAV · DestroyedNTSB ERA11WA126Accident · 1 fatalForeign investigationPiper · Corupa, BrazilOn January 03, 2011, at 1200 coordinated universal time (10:00 local time), a Piper PA-25-260, Brazilian registration PT-DJS, incurred substantial damage when it impacted terrain for unknown reasons near, Corupa, Santa Catarina, Brazil,. The pilot was fatally…Jan 3, 2011 · PT-DJS · Substantial damageNTSB WPR11WA020Accident · 2 fatalForeign investigationCessna 172 · Durham Downs, Australia, AustraliaOn October 18, 2010, at 1230 universal coordinated time, a Cessna 172S, VH-VSK, collided with the terrain near Durham Downs, Australia. The airplane was operated by S. Kidman & Co LTD. The pilot and passenger were killed and the airplane was substantially…Oct 18, 2010 · VH-VSK · Substantial damageNTSB WPR10WA484Accident · 1 fatalForeign investigationChampion 8KCAB · Bandung, Indonesia, IndonesiaOn September 24, 2010, at 0312 universal coordinated time, an American Champion Super Decathlon 8KCAB, PK-NZP, collided with terrain while performing an inverted aerobatic maneuver at low altitude during an air show at Husein Sastranegara Airport, Bandung,…Sep 24, 2010 · PK-NZP · Substantial damageNTSB ERA10WA456Accident · 1 fatalForeign investigationCessna A188 · Pista El Limon, EcuadorOn August 29, 2010, about 1300 universal coordinated time (UTC), a Cessna A188B, Ecuadorian registration HC-BCF, operated by a private owner on an agricultural spraying flight, collided with power lines and subsequently the ground near Pista El Limon,…Aug 29, 2010 · HC-BCF · DestroyedNTSB ERA10WA428Accident · 4 fatalForeign investigationRobinson R44 · Milazzo, ItalyOn August 12, 2010, about 0600 Universal Coordinated Time (UTC), a Robinson R44, Italian registration I-KOST, operated by Intesa Leasing, Rent and Fly, as a personal flight, collided with a building and the ground during takeoff from a private field at…Aug 12, 2010 · I-KOST · DestroyedNTSB ERA10WA386Accident · 2 fatalForeign investigationEmbraer EMB711 · Mato Grosso, BrazilOn July 18, 2010, about 1500 Universal Coordinated Time (UTC), an Embraer EMB-711C, Brazilian registration PT-NBE, operated by a private owner on a personal flight, collided with a hill while in cruise flight in the vicinity of Santo Antonio Do Leverger, Mato…Jul 18, 2010 · PT-NBE · No damageNTSB WPR10WA309Accident · 1 fatalClass 5 · ForeignCessna 172N · Broken Hill, AustraliaOn June 21, 2010, about 0145 coordinated universal time, a Cessna 172N, VH-UFN, registered to a private owner, collided with water during an unknown flight phase near Broken Hill, New South Wales (NSW), Australia. The airplane was reported missing and was…Jun 21, 2010 · VH-UFN · Substantial damageNTSB WPR10WA185Accident · 2 fatalForeign investigationPiper PA30 · Northam, Australia, AustraliaOn March 28, 2010, at 0900 coordinated universal time, a Piper PA-30, VH-KDS, registered to a private owner, collided with terrain near Northam, Australia. The airplane was substantially damaged and the pilot and passenger were killed. The flight departed…Mar 28, 2010 · VH-KDS · Substantial damageNTSB DCA10WA025Accident · No injuriesForeign investigationBoeing 747 · Luxembourg, LuxembourgOn January 21, 2010, a Cargolux Airlines, Boeing 747-400F, registration LX-OCV, struck the top of a maintenance van that was on the runway during CAT IIIB conditions at Luxembourg-Findel International Airport, Luxembourg. The airplane landed safely with minor…Jan 21, 2010 · LX-OCV · Minor damageNTSB ERA10WA116Accident · 3 fatalForeign investigationPiper PA-32-300 · Bimini, Bahamas, BahamasOn January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…Jan 17, 2010 · N4219R · DestroyedNTSB ERA10WA312Accident · 5 fatalForeign investigationBeech 58 · Guarico, VenezuelaOn December 13, 2009, about 2040 UTC, a Beech 58, of Venezuelan registration, YV2473, registered to and operated by Aeronaves Baron, C.A., impacted terrain during takeoff from the Mata de Juajua Airport (SVCS), near Estatdo Guárico, Venezuela. Visual…Dec 13, 2009 · YV2473 · Substantial damageNTSB CEN10WA073Accident · 1 fatalClass 5 · ForeignCirrus SR20 · Oberbarnim, GermanyOn December 10, 2009, at 1625 coordinated universal time, a Cirrus SR20, German registered D-EYAT, was destroyed when it impacted forested terrain near Oberbarnim, Germany. Instrument meteorological conditions prevailed at the time of the accident. The pilot…Dec 10, 2009 · D-EYAT · DestroyedNTSB WPR10WA080Accident · 1 fatalForeign investigationBell 206 · Dorrigo, Australia, AustraliaOn December 9, 2009, at 1225 universal coordinated time a Bell 206 L-1, VH-MJO, operated by Commercial Helicopters Pty Ltd. collided with the terrain during takeoff near Dorrigo, Australia. The flight was for the purpose of performing an aerial survey. The…Dec 9, 2009 · VH-MJO · Substantial damageNTSB WPR10WA108Accident · 1 fatalForeign investigationCessna A188 · Kojonup, Australia, AustraliaOn November 17, 2009, at 1200 coordinated universal time, a Cessna A188B, Australian registry VH-ZRR, registered to and operated by South West Aerial Services, collided with the terrain while maneuvering during an aerial application flight near Kojonup,…Nov 17, 2009 · VH-ZRR · Substantial damageNTSB WPR10WA036Accident · 1 fatalForeign investigationAir Tractor AT-502 · Narrogin, Australia, AustraliaOn October 3, 2009, at 1130 Western Standard Time, an Air Tractor AT-502, VH-ODP, operated by Agricair Pty Limited, as an agricultural flight collided with the ground while maneuvering 47 Km east northeast of Narrogin, Australia. Visual meteorological…Oct 3, 2009 · VH-ODP · Substantial damageNTSB CEN09WA506Accident · 2 fatalForeign investigationEnstrom F28 · Mont Laurier, CanadaOn August 5, 2009, at 1000 eastern daylight time, an Enstrom F28C helicopter, Canadian registered C-GVQQ, registered to a private individual and piloted by the accident pilot, was destroyed when it impacted wires and terrain near Mont-Laurier Airport (CSD4),…Aug 5, 2009 · C-GVQQ · DestroyedNTSB ERA09WA354Accident · 2 fatalForeign investigationRobinson R-44 · Vitoria da Conquista, BrazilOn May 22, 2009, at 2139 Coordinated Universal Time (UTC), a Brazilian registered Robinson R-44, PR-NDF, was destroyed when it impacted the ground during approach to land at the Vitoria da Conquista Airport (SBQV), Vitoria da Conquista, Brazil. The pilot and…May 22, 2009 · PR-NDF · DestroyedNTSB WPR09WA292Accident · No injuriesForeign investigationCessna 208 · Vientiane, Laos, LaosOn April 11, 2009, about 1035 coordinated universal time (UTC), a Cessna 208B, Laos registration RDPL-34144, owned by Helicopters of New Zealand, operated by Lao Air, was substantially damaged during a forced landing following a loss of engine power near…Apr 11, 2009 · RDPL-34144 · Substantial damageNTSB CEN09WA188Accident · Minor injuriesForeign investigationBell 212 · Aguascalientes, MexicoNot Required. Investigation is being conducted by the DGAC, Mexico.Feb 28, 2009 · XC-DES · Substantial damageNTSB ERA09WA085Accident · 1 fatalForeign investigationMaule M7 · Cobra River, Manaus, BrazilOn December 7, 2008, about 1115 universal coordinated time, a Maule M-7-235, Brazilian registration PT-ONN, was substantially damaged when it impacted trees while departing from the Taruma River, Manaus, Brazil. The floatplane subsequently came to rest in the…Dec 7, 2008 · PT-ONN · Substantial damageNTSB WPR09WA250Accident · 1 fatalForeign investigationMcdonnell Douglas 369 · Murray Bridge, AustraliaOn November 19, 2008, about 1115 Australian central daylight-saving time, a pilot and two linesmen were operating a McDonnell Douglas 369D helicopter, Australian registry VH-PLJ, to test a high-voltage power line between Mannum and Mobilong, SA. While…Nov 19, 2008 · VH-PLJ · Substantial damage