Skip to content

NTSB investigations, 2016, Outside the U.S.

17 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") = 2016 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\") = 2016
    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") = 2016
  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 ERA17WA085Accident · 3 fatalForeign investigationBeech 58 · Tabatinga, BrazilOn December 23, 2016, about 1830 universal coordinated time, a Beech 58, Brazilian registration PT-ICU, was destroyed when it impacted wooded terrain while on approach to Tabatinga International Airport (SBTT), Tabatinga, State of Amazonas, Brazil. The two…Dec 23, 2016 · PT-ICU · Destroyed NTSB CEN17WA054Accident · 2 fatalForeign investigationGrumman AA1 · Pintendre, CanadaOn December 10, 2016, a Grumman American AA-1B airplane, C-FJEX, impacted terrain near Pintendre, Quebec. The pilot and passenger were fatality injured. The accident investigation is under the jurisdiction and control of the Canadian government. This report…Dec 10, 2016 · C-FJEX NTSB ERA17WA060Accident · 1 fatalForeign investigationAgusta A109A II · Varese, ItalyOn November 19, 2016, at 1316 universal coordinated time, an Augusta A109 A II, N109W, was destroyed when it impacted terrain while navigating near Varese, Italy. An Italian passenger was fatally injured and the Italian certificated pilot and Swiss passenger…Nov 19, 2016 · N109W · Destroyed NTSB WPR17WA027Accident · 1 fatalForeign investigationRobinson R44 · Mount Windsor, AustraliaOn November 18, 2016, at 1244 local time, a Robinson R44 II, Australian registration VH-ZNZ, collided with terrain near Mount Windsor, Australia. The helicopter was destroyed by a post impact fire. The pilot sustained serious injuries and the passenger was…Nov 18, 2016 · VH-ZNZ · Destroyed NTSB ERA17WA021Accident · 2 fatalForeign investigationCessna 172 · Peloponnese, GreeceOn October 16, 2016, about 1415 universal coordinated time, a Cessna 172P, Greek registration 5B-CLB, was destroyed when it impacted mountainous terrain while performing a cross-country training flight near Peloponnese, Greece. The Greek certificated…Oct 16, 2016 · 5B-CLB · Destroyed NTSB ERA16WA307Accident · 1 fatalForeign investigationPiper PA25 · Finca, ColombiaOn August 26, 2016, about 1250 coordinated universal time, a Piper PA-25-260, Colombian registration HK588, operated by Fumigaciones Aereas Del Norte S.A.S., was destroyed when it collided with an electrical wire and terrain near Finca, Colombia. The…Aug 26, 2016 · HK588 · Destroyed NTSB ERA16WA287Accident · 2 fatalForeign investigationCessna 172 · Fredonia, ColombiaOn August 9, 2016, about 2156 universal coordinated time, a Cessna 172N, Colombian registration HK4822G, was substantially damaged when it impacted terrain near Fredonia, Antioquia, Colombia. The flight instructor and student pilot were fatally injured and…Aug 9, 2016 · HK4822G · Substantial damage NTSB CEN16WA272Accident · 2 fatalForeign investigationRobinson R22 · Madrid, SpainOn July 16, 2016, about 1240 hours universal coordinated time, a Robinson R-22 Beta helicopter, Spain registration EC-IGG, was substantially damaged when it impacted the Valmayor Reservoir near Valdemorillo, Madrid, Spain. Witnesses reported that the…Jul 16, 2016 · EC-IGG · Substantial damage NTSB ERA16WA243Accident · 1 fatalForeign investigationCessna A188 · Puerto Lopez, ColombiaOn July 2, 2016, about 1810 coordinated universal time, a Cessna A188, Colombian registration HK1398, operated by Comercializadora de Aviacion Agricola - ECO, was destroyed when it collided with a utility tower near Puerto Lopez, Colombia. The certificated…Jul 2, 2016 · HK1398 · Destroyed NTSB ERA16WA245Accident · 2 fatalForeign investigationLake LA4 · Región de Los Lagos, ChileOn June 25, 2016, about 2045 coordinated universal time (1645 local time), a Lake L-4-200, amphibious airplane, Chilean registration CC-POK, was substantially damaged when it collided with a powerline during a local flight over the Región de Los Lagos, Chile.…Jun 25, 2016 · CC-POK · Substantial damage NTSB ERA16WA273Accident · No injuriesForeign investigationBAE BAE125 · Yakutia, RussiaOn June 5, 2016, about 1425 coordinated universal time (2325 local time), a British Aerospace (BAE) Hawker 125-800, Russian registration RA-02773, was substantially damaged when it impacted terrain while on approach to Neryungri Airport, Yakutia, Russia, and…Jun 5, 2016 · RA-02773 · Substantial damage NTSB CEN16WA351Accident · 1 fatalForeign investigationRobinson R22 · Aube, FranceMay 9, 2016 · G-SPEE · Destroyed NTSB CEN16WA402Accident · Serious injuriesForeign investigationBell 206 · Mexico City, MexicoMay 8, 2016 · N531RR · Substantial damage NTSB ERA16WA180Accident · 2 fatalForeign investigationRobinson R22 · Sao Paulo, BrazilOn May 5, 2016, about 1515 universal coordinated time, a Robinson R22 Beta, Brazilian registration PR-RCA, operated by AGD Aviation, was substantially damaged when it impacted wires and then terrain while maneuvering in Sao Paulo, Brazil. The flight…May 2, 2016 · PR-RCA · Substantial damage NTSB ENG16WA018Accident · 25 fatalForeign investigationViking Air DHC-6 · Soli Ghoptevir, NepalFeb 24, 2016 · 9N-AHH · Destroyed NTSB CEN16WA109Accident · 1 fatalForeign investigationPiper PA28 · Palin, GuatemalaOn February 23, 2016, at 1805 coordinated universal time, a Piper PA28-140, Guatemalian registration TG-PEW, was destroyed when it impacted the terrain near Palin, Guatemala. The pilot was fatally injured. The flight originated from La Aurora Airport,…Feb 23, 2016 · TG-PEW · Destroyed NTSB ERA16WA083Accident · 2 fatalForeign investigationBeech C90 · Parati, BrazilOn January 3, 2016, about 1730 Coordinated Universal Time (UTC), a Beech C90GTi, PP-LMM, registered to Bradesco Leasing S.A., operated by Supermercado Shibata Ltda, experienced controlled flight into mountainous terrain near Parati Airport (SDTK), Parati,…Jan 3, 2016 · PP-LMM · Destroyed