OpenAirDocs.org

NTSB investigations, 2010, Outside the U.S.

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

Cases per year

20082026

Latest cases

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 year(c.\"eventDate\") = 2010
    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.

NTSB ERA11WA086Accident · 1 fatalForeign investigationEurocopter AS 350 B2 · Taltal, ChileOn November 6, 2010, at 2330 universal coordinated time, a Eurocopter, AS 350 B2 helicopter, Chilean registration CC-AAN, collided with terrain while in low level cruise flight near Taltal, Chile. The flight was operated by Servicios y Transporte Aereos…Nov 6, 2010 · CC-AAN · DestroyedNTSB ERA10WA509Accident · 4 fatalForeign investigationRobinson R44 · Lagoa do Triunfo, Para, BrazilOn September 15, 2010, about 2150 universal coordinated time, a Robinson R-44 II helicopter, Brazilian registration PR-DAN, was substantially damaged when it impacted the terrain in Lagoa do Triunfo, Para, Brazil. The pilot and three passengers were fatally…Sep 15, 2010 · PR-DAN · Substantial damageNTSB ERA11WA051Accident · 2 fatalForeign investigationCessna 182 · Rio Negro, Bolivar, VenezuelaOn May 21, 2010, about 1737 universal coordinated time, a Cessna 182F, Venezuelan registration YV158E, operated by Corona's Pilot Escuela de Aviacion, was destroyed after it impacted an electrical cable during a training flight in Rio Negro, Estado Bolivar,…May 21, 2010 · YV158E · DestroyedNTSB WPR10WA249Accident · 1 fatalForeign investigationBell 206 · Traralgon, Australia, AustraliaOn May 20, 2010, about 0415 Universal Coordinated Time, a Bell 206 L-3, VH-OSU, operated by a pilot from New Zealand doing crop spraying operations struck a power line and subsequently collided with terrain near Latrobe Valley Aerodrome, Traralgon, Australia.…May 20, 2010 · VH-OSU · DestroyedNTSB ENG10RA025Accident · 89 fatalForeign investigationTupolev TU154 · Smolensk, RussiaOn April 10, 2010, about 0656 Coordinated Universal Time (UTC), a Tupolev Tu-154M, Tail Number 101, operated by the Polish Air Force as flight PLF101, crashed during approach to the Military Aerodrom Smolensk "Severnyi", Russia. All 89 passengers and 7…Apr 10, 2010 · N101 · DestroyedNTSB ERA10WA160Accident · 2 fatalForeign investigationCessna 310R · Nova Lima, BrazilOn Feburary 26, 2010, about 1119 UTC, a Cessna 310R, Brazilian registration PT-OID, was destroyed when it collided with mountainous terrain near Nova Lima, Brazil. The pilot and one passenger were killed. The flight originated from Leopoldina, Brazil (SNDN)…Feb 26, 2010 · PT-OID · DestroyedNTSB CEN10RA133Accident · 5 fatalForeign investigationCessna 206 · San Pedro, BelizeFeb 26, 2010 · V3-HDR · Substantial damageNTSB ERA10WA133Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Restauracion, Dominican Republic, Dominican RepublicOn February 4, 2010, about 1940 Atlantic standard time, a Robinson R44II helicopter, N7535F, impacted the side of Mount Jina Mocha, in the city of Restauracion, Dominican Republic, at night, while en route from Port Au Prince, Haiti to Cibao International…Feb 4, 2010 · N7535F · Destroyed