NTSB investigations, Outside the U.S.
249 cases where the sequence of events included Controlled flight into terr/obj (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 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 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 WPR17WA178Accident · 1 fatalForeign investigationRobinson Helicopter R22 Beta · Cloncurry, AustraliaOn August 2, 2017, at 0740 local time, a Robinson R22, VH-HGU, was destroyed by a post-impact fire following a collision with power lines during cruise flight near Cloncurry Aerodrome, Australia. The helicopter was operated under the pertinent civil…NTSB CEN17WA289Accident · 7 fatalForeign investigationCessna U206 · Culiacan, MexicoNTSB CEN17WA214Accident · 1 fatalForeign investigationPiper PA-28-140 · Sacatepequez, GuatemalaOn June 1, 2017, at 1824 coordinated universal time, a Piper PA-24-140, Guatemalan registration TG-GYV, owned by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Volcán de Agua, Departamento de…NTSB ERA17WA192Accident · 1 fatalForeign investigationRobinson R22 · Kwa-Zulu Natal, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R22 helicopter that occurred on May 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB CEN17WA175Accident · 3 fatalForeign investigationSocata-Groupe Aerospatiale TB 20 · Malaga, SpainOn April 29, 2017, at 1632 UTC, a Socata TB-20, D-ECJP, impacted terrain near Canillas de Aceituno in Malaga, Spain. The aircraft was destroyed, and the pilot and two passengers were fatally injured. The flight departed Mutxamel Airfield (LEMU) in Alicante,…NTSB CEN17WA143Accident · 5 fatalForeign investigationAerospatiale AS355 · Snowdonia, United KingdomOn March 29, 2017, about 1500 coordinated universal time, an Aerospatiale AS355 F1 helicopter, G-OHCP, collided with Rhinog Fawr mountain in Snowdonia, Wales, United Kingdom. The pilot and four passengers were fatally injured.The accident investigation is…NTSB CEN17WA130Accident · 1 fatalForeign investigationBell 206 · Figeac, FranceOn March 15, 2017, about 2100 universal coordinated time (UTC), a Bell 206 helicopter, F-GPPH, impacted terrain near Figeac, France. The pilot was fatally injured and the helicopter was destroyed. The flight originated from Poiters Biard (LFBI), France, and…NTSB CEN17WA213Accident · 1 fatalForeign investigationPiper PA28 · Petit Bourg, GuadeloupeOn February 20, 2017, about 1225 UTC, a Piper PA-28-161, French registration F-OGPJ, owned and operated by Aeroclub Les Ailes Guadeloupeenes, collided with a house while conducting low altitude cruise flight near Petit Bourg, Guadeloupe, French Antilles. The…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…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…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…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…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…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…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…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…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…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.…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…NTSB CEN16WA351Accident · 1 fatalForeign investigationRobinson R22 · Aube, FranceNTSB CEN16WA402Accident · Serious injuriesForeign investigationBell 206 · Mexico City, MexicoNTSB 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…NTSB ENG16WA018Accident · 25 fatalForeign investigationViking Air DHC-6 · Soli Ghoptevir, NepalNTSB 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,…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,…NTSB DCA16WA236Accident · No injuriesForeign investigationCessna 182 · Plettenberg, Western Cape Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna 182@ airplane that occurred on December 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the…NTSB CEN16WA056Accident · 1 fatalForeign investigationPiper PA28R · Ljubljana, Slovenia, SloveniaOn December 3, 2015, a Piper PA-28R-201 airplane, OE-DYM, was destroyed after impact with terrain while on approach to the Ljubljana Airport, Slovenia. The pilot was fatally injured. This investigation is under the jurisdiction and control of the Republic of…NTSB WPR16WA026Accident · 1 fatalForeign investigationCessna 310 · Mildura, Australia, AustraliaOn November 6, 2015, at 1840 local time, a Cessna 310R, VH-BWZ, operating under the pertinent civil regulation of the Government of Australia, collided with terrain near Mildura, Australia, while on approach. The airplane was destroyed in the post-impact fire…NTSB ERA16WA025Accident · 2 fatalForeign investigationPiper PA-28R-200 · Brazil, BrazilOn October 6, 2015, about 1433 UTC, A Piper PA-28R-200 (Embraer EMB711C); Brazilian registration PT-NKU, was destroyed when it impacted terrain while flying from Caratinga, Minas Gerais, Brazil to Serra do Caraca, Minas Gerais, Brazil. The two occupants were…NTSB ERA15WA347Accident · 3 fatalForeign investigationCessna TU206B · Lib Mandy, PeruNTSB DCA15WA187Accident · 7 fatalForeign investigationCessna 441 · Cape Town, South AfricaThe government of South Africa has notified the NTSB of an accident involving a Cessna 441 airplane that occurred on August 17, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB CEN15RA352Accident · 1 fatalForeign investigationDehavilland DHC 2 · Akureyri, IcelandOn August 9, 2015, at an unknown time, a De Havilland DHC-2 airplane, United States registration N610LC, was substantially damaged when it impacted mountainous terrain near Akureyri, Iceland. One occupant sustained fatal injuries, and one occupant sustained…NTSB CEN15WA339Accident · No injuriesForeign investigationKitfox Series 7 · Hundwil, SwitzerlandOn August 5, 2015 about 0840 UTC, a Kitfox Series 7 airplane, Swiss registration HB-YMG, impacted into a forest near Hundwil-Appenzell, Switzerland. The pilot and the passenger were killed, and the airplane was destroyed. Visual Meteorological conditions…NTSB CEN15WA338Accident · 1 fatalForeign investigation3xtrim 450 Ultra · Golub-Dobrzyn City, PolandOn July 17, 2015 about 1615 UTC, a 3Xtrim 450 Ultra, light sport airplane, Poland registration SP-SPRL, impacted terrain while on a sightseeing flight near Golub-Dobrzyn, Poland. The pilot was seriously injured and the passenger was killed. The airplane was…NTSB ERA15WA250Accident · 3 fatalForeign investigationBell 206B · Ouro Preto, Minas Gerais, BrazilOn June 16, 2015, at 1910 Universal Coordinated Time (UTC), a Bell 206B helicopter, Brazilian registration PT-YDY, operated by a private owner, was destroyed following a controlled flight into terrain near Ouro Preto municipality, State of Minas Gerais,…NTSB CEN15WA273Accident · 3 fatalForeign investigationPiper PA-23-250 · Kangirsuk, CanadaOn June 11, 2015, about 2340 eastern daylight time, a Canadian registered PA-23-250, C-FXPS, impacted terrain about 1.2 nautical miles from the Kangirsuk Airport, Kangirsuk, Quebec, Canada. The pilot and two passengers were fatally injured. The investigation…NTSB ANC15WA036Accident · 2 fatalForeign investigationCessna 182 · Sikanni Chief, CanadaNTSB CEN15WA254Accident · 2 fatalForeign investigationCessna T182 - T · Carlow, IrelandNTSB WPR15WA145Accident · 1 fatalForeign investigationBell 206 - B · Ziyang City, China, ChinaOn April 13, 2015, at 0800 local time, a Bell 206 BIII, B-7607, collided with a wire during an aerial application flight near Ziyang City, Sichuan Province, China. The helicopter was operated by Hubei Tongcheng General Aviation Ltd under the pertinent civil…NTSB ERA15WA182Accident · 3 fatalForeign investigationCessna 172S · Santander, ColombiaOn April 12, 2015, about 1915 coordinated universal time, a Cessna 172S, Colombian registration HK5064G, and a Cessna 150M, Colombian registration HK1912G, were substantially damaged after impacting mountainous terrain in the vicinity of the Serrania Los…NTSB ERA15WA180Accident · 4 fatalForeign investigationBell 206 - L4 · Diego de Almagro, ChileOn March 31, 2015, about 2210 universal coordinated time (UTC), a Bell 206L4, Chilean registration CC-APP, operated by a private individual, was destroyed during a collision with power lines and a subsequent postcrash fire, while maneuvering near Diego de…NTSB ENG15WA026Accident · Minor injuriesForeign investigationAirbus A320 - 211 · Halifax, CanadaOn 29 March 2015, an Air Canada Airbus A320-200 aircraft (registration C-FTJP) clipped a power line and approach lights short of Runway 05 at the Halifax Stanfield International Airport. The Transportation Safety Board (TSB) of Canada is investigating the…NTSB ERA15WA131Accident · 1 fatalForeign investigationCessna A188 · Tapes, BrazilOn February 7, 2015, about 1100 universal coordinated time, a Cessna A188, Brazilian registration PT-LOA, was destroyed when it struck a high-tension powerline and impacted terrain while maneuvering over a soybean field near Tapes, Brazil. The pilot was…NTSB ERA15WA108Accident · 1 fatalForeign investigationCessna A188B · Baixa Grande do Ribeiro, BrazilOn January 14, 2015, about 1050 universal coordinated time, a Cessna A188B, Brazilian registration PT-FFH, was substantially damaged when it collided with a utility pole during an aerial application flight near Baixa Grande do Ribeiro, Brazil. The foreign…NTSB ERA15WA104Accident · 1 fatalForeign investigationRobinson R44 - II · Santa Monica, BrazilOn January 10, 2015, about 2000 universal coordinated time, a Robinson R44 II, Brazilian registration PR-HPR, was destroyed by impact and fire after collision with wires and terrain during cruise flight in Santa Monica, Parana, Brazil. There was a post-crash…NTSB ERA15RA047Accident · 9 fatalForeign investigationGates Learjet 35A · Freeport, BahamasNTSB WPR14WA318Accident · 1 fatalForeign investigationCessna T210N · Inverell, Australia, AustraliaOn July 4, 2014, at 1325 local time, a Cessna T210N, VH-ZFW, collided with terrain shortly after takeoff from Inverell, Australia. The airplane was operated by the pilot under the pertinent civil regulations of the government of Australia. The airplane was…NTSB ERA14WA287Accident · 3 fatalForeign investigationCessna 172N · Premana Lecco, ItalyNTSB ERA14WA246Accident · Serious injuriesForeign investigationCessna T206H · Macas, EcuadorOn May 14, 2014, about 1600 local time, a Cessna T206H, Ecuadorian registration HC-CFE, was substantially damaged when it impacted power lines while returning to land at Edmundo Carvajal Airport (SEMC), Macas, Ecuador, with smoke in the cockpit. The…NTSB ERA14WA221Accident · 2 fatalForeign investigationPiper PA-31 · Santander, ColombiaOn May 3, 2014, about 1500 coordinated universal time, a Piper PA-31, Canadian registration C-GSVM, was substantially damaged when it impacted terrain near Santander, Colombia. The pilot and passenger were fatally injured. The local survey flight departed…