Skip to content

NTSB investigations, 2011, Outside the U.S.

27 cases where the sequence of events included Controlled flight into terr/obj (CFIT).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Latest cases

Query with SQL

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 year(c."eventDate") = 2011 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 year(c.\"eventDate\") = 2011
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

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 year(c."eventDate") = 2011
  AND c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ERA12WA133Accident · 2 fatalForeign investigationPiper PA28 · Andres Bello,Tachira, VenezuelaOn December 29, 2011, about 1415 universal coordinated time, a Piper PA28-161, Columbian registration HK3934, was substantially damaged when it impacted terrain while in cruise flight near Andres Bello, Tachira, Venezuela. The two pilots were fatally injured.…Dec 29, 2011 · HK3934 · Substantial damage NTSB ERA12WA113Accident · 1 fatalForeign investigationRobinson R44 · Sao Bento do Sul, BrazilOn December 9, 2011 at 1630 universal coordinated time, a Robinson R44, Brazilian registration PR-KLA, operated by SASH Locacao de Veiculos LTDA, as a personal flight, impacted terrain in the vicinity of Fazenda Coqueiros, Sao Bento do Sul, Santa Catarina,…Dec 9, 2011 · PR-KLA · Substantial damage NTSB ERA12WA104Accident · No injuriesForeign investigationPiper PA28 · Bogota, ColombiaOn December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…Dec 6, 2011 · HK2308 · Substantial damage NTSB ERA12WA103Accident · 4 fatalForeign investigationCessna TU206 · Cerro Escalera, PeruOn December 1, 2011, about 2048 UTC, a Cessna TU206G, Peruvian registration OB-1299, registered to and operated by Palmas del Espino S.A., collided with mountainous terrain near Cerro Escalera, Peru. Weather conditions at the altitude, location, and time of…Dec 1, 2011 · OB-1299 · Substantial damage NTSB ERA12WA073Accident · 2 fatalForeign investigationCessna 150 · Santa Rosa, EcuadorOn November 14, 2011, about 2020 coordinated universal time (1520 local time), a Cessna 150M, Ecuadorian registration HC-BJA, was substantially damaged when it impacted rising terrain in the Girón Alto mountains near Santa Rosa, Ecuador. The Ecuadorian pilot…Nov 14, 2011 · HC-BJA · Substantial damage NTSB ERA12WA026Accident · 4 fatalForeign investigationBeech V35 · Maraba Paulista, BrazilOn October 1, 2011, about 2345 coordinated universal time (2045 local time), a Beechcraft V35, Brazilian registration PT-CTL, was substantially damaged when it impacted terrain between the cities of Maraba Paulista and Presidente Venceslau, Sao Paulo State,…Oct 1, 2011 · PT-CTL · Substantial damage NTSB ERA11WA520Accident · 2 fatalForeign investigationBeech D35 · Avare, BrazilOn September 29, 2011, about 1824 Universal Coordinated Time (UTC), a Beech D35, Brazilian registration PT-AVK, operated by a private owner, was destroyed following a collision with terrain at Santarém Municipality, State of Pará, Brazil. The local flight…Sep 29, 2011 · PT-AVK · Substantial damage NTSB ERA11WA499Accident · 3 fatalForeign investigationBeech 99 · Cap Haitien, HaitiOn September 20, 2011, at 2130 universal coordinated time, a Hawker Beechcraft BE-99A, registered in Haiti as HH-APA, was substantially damaged when it impacted terrain while on approach to the Cap Haitien International Airport (MTCH), Cap Haitien, Haiti. The…Sep 20, 2011 · HH-APA · Substantial damage NTSB WPR11WA475Accident · 2 fatalForeign investigationCessna 208B · Wamean, West Papua, IndonesiaOn September 9, 2011, at 1223 local time (0323 UTC) a Cessna 208B, Indonesia registry PK-VVE, collided with mountainous terrain 8 nautical miles north east of Wamena Airport, Wamena, West Papau, Indonesia. The aircraft was operated by Susi Air under the…Sep 9, 2011 · PK-VVE · Substantial damage NTSB WPR11WA484Accident · No injuriesForeign investigationAerospatiale AS350 · Rockhampton, Australia, AustraliaOn September 8, 2011, at 0203 universal coordinated time, an Aerospatiale Industries AS-350BA, VH-RDU, collided with the terrain near Rockhampton, Australia. The helicopter was substantially damaged. Of the three occupants on board, two were fatally injured…Sep 8, 2011 · VH-RDU · Substantial damage NTSB DCA11RA098Accident · 8 fatalForeign investigationM7Aero SW3 · Trinidad, BoliviaOn September 6, 2011, an Aerocon Swearingen SA-227 Metroliner, registration CP-2548 performing flight A4-238 from Santa Cruz to Trinidad (Bolivia) with 7 passengers and 2 crew, was on approach to Trinidad when radio contact was lost. The airplane was located…Sep 6, 2011 · CP2548 · Substantial damage NTSB WPR11WA438Accident · 1 fatalForeign investigationRobinson R44 · Plutonic Aero., Australia, AustraliaOn September 3, 2011, at 0330 universal coordinated time, a Robinson R44, Australia registry VH-HCA, collided with terrain while maneuvering near Plutonic Aerodrome, Australia. The helicopter was operated by Wieland Helicopter Company under the pertinent…Sep 3, 2011 · VH-HCA · Substantial damage NTSB CEN11WA592Accident · 1 fatalForeign investigationSocata TB10 · Kufstein, AustriaUnder the jurisdiction and control of the Austrian government.Jul 30, 2011 · PH-RCV · Substantial damage NTSB ERA11WA439Accident · 1 fatalForeign investigationRobinson R-44 · Istok, RussiaOn July 9, 2011, at 1900 universal coordinated time, a Robinson R-44, Russian registration RA-04304, registered to and operated by a private owner, collided with the Yenisei River, near Istok, Krasnoyarsk Region, Russia, during a repositioning flight at…Jul 9, 2011 · RA-04304 · Substantial damage NTSB ERA11WA368Accident · 3 fatalForeign investigationCirrus SR20 · Cairo Montenotte, ItalyOn June 23, 2011, about 1000 UTC, a Cirrus SR20, Luxembourg registration LX-MPR, operated by a private individual, collided with mountainous terrain near Cairo Montenotte, Italy. Instrument meteorological conditions prevailed in the area at the time and…Jun 23, 2011 · LX-MPR · Substantial damage NTSB CEN11WA407Accident · 2 fatalForeign investigationPiper PA-39 · Mont Agel, FranceUnder the jurisdiction and control of the French government.Jun 17, 2011 · G-AYZE · Destroyed NTSB ERA11WA308Accident · 2 fatalForeign investigationBell 206L-3 · Norte de Santander, ColombiaOn May 23, 2011, about 2105 Universal Coordinated Time (UTC), a Bell 206L-3, Columbian registration HK4448, operated by Aviheco S.A., was destroyed following a collision with terrain near Norte de Santander, Columbia. The local flight originated in Bogota.…May 23, 2011 · HK4448 · Destroyed NTSB WPR11WA482Accident · 1 fatalForeign investigationRobinson R22 · Julia Creek, Australia, AustraliaOn May 9, 2011, at 0440 universal coordinated time, a Robinson R-22, Australian registry VH-DSD, operated by Versatile Helicopter Services, impacted terrain during a mustering operation near Julia Creek, Australia. The helicopter was substantially damaged and…May 9, 2011 · VH-DSD · Substantial damage NTSB ERA11WA276Accident · 2 fatalForeign investigationRobinson R22 · Sulmona, ItalyOn April 26, 2011, at 1743 coordinated universal time (1843 local time), a Robinson R22, Italian registration I-ETEC, was destroyed when it impacted power lines near Sulmona, L'Aquila, Italy. The pilot and the observer were fatally injured. The flight, which…Apr 26, 2011 · I-ETEC · Destroyed NTSB WPR11WA217Accident · No injuriesForeign investigationRobinson R44 · Straubing, GermanyOn March 31, 2011, at 1630 universal coordinated time, a Robinson R44 Raven II Helicopter, D-HBLT, collided with an aircraft storage hangar at Straubing-Wallmühle Airport, Straubing, Germany. The pilot and passenger sustained minor injuries; the helicopter…Mar 31, 2011 · D-HBLT · Destroyed NTSB ERA11WA211Accident · 6 fatalForeign investigationCessna 340 · Tachira, VenezuelaOn February 22, 2011, about 1915 UTC, a Cessna 340A, Venezulian registration YV2402, operated by Premezolados Agreconsa C.A., collided with mountainous terrain near Tachira, Venezuela. Visual meteorological conditions prevailed at the destination airport…Feb 22, 2011 · YV2402 · Destroyed NTSB ERA11WA155Accident · 4 fatalForeign investigationBell 206 · Vereda Galan, ColombiaOn February 18, 2011, about 0415 universal coordinated time, a Bell 206-B, Colombian registration HK-4594, operated by Heliservice LTDA, crashed in mountainous terrain near Vereda Galan, Colombia, and was consumed by a post crash fire. Instrument…Feb 18, 2011 · HK-4594 · Destroyed NTSB ERA11WA145Accident · 1 fatalForeign investigationScotts-Bell 47 47G-4A · El Tocuyo, VenezuelaOn February 9, 2011, about 1300 UTC, a Scotts-Bell 47, Inc., 47G-4A, YV-447A, collided into mountainous terrain near El Tocuyo, Venezuela. Visual meteorological conditions prevailed at the time and flight plan information is unknown for the foreign non-U.S.…Feb 9, 2011 · YV447A · Destroyed NTSB ERA11WA160Accident · 2 fatalForeign investigationCessna 182 · Novo Repartimento, BrazilOn January 31, 2011, about 1410 Universal Coordinated Time (UTC), a Cessna, 182P, Brazilian registration PT-KAS, operated by a private individual, collided with a tree during a balked landing at the Uniáo Farm, Novo Repartimento, Pará, Brazil. Visual…Jan 31, 2011 · PT-KAS · Destroyed NTSB ERA11WA136Accident · 1 fatalForeign investigationCessna 172 · Isola Fossara, Perugia, ItalyOn January 27, 2011, at 1410 universal coordinated time, a Cessna 172N, Italian registration I-AMCO, was substantially damaged when it impacted terrain during cruise flight near Isola Fossara, Perugia, Italy. The certificated private pilot was fatally…Jan 27, 2011 · I-AMCO · Substantial damage NTSB ERA11WA121Accident · 6 fatalForeign investigationBeech B200 · Senador Canedo City, BrazilOn January 14, 2011, at 2010 coordinated universal time (1810 local time), a Beechcraft B200, Brazilian registration PR-ART, was destroyed when it impacted terrain near Senador Canedo City, Goias, Brazil, while approaching Santa Genoveva Airport (SBGO),…Jan 14, 2011 · PR-ART · Destroyed NTSB ERA11WA111Accident · 1 fatalForeign investigationAir Tractor AT802 · Santa Juana, ChileOn January 9, 2011, at 1930 universal coordinated time, an Air Tractor AT-802, Spanish registration EC-IOE, registered to FAASA Group Aerodromo Sebastian Almagro Ctra, operated by FAASA Chile Servicios Aeros LTDA, collided with trees near Santa Juana, Chile,…Jan 9, 2011 · EC-IOE · Destroyed