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 ERA14WA207Accident · 4 fatalForeign investigationEmbraer EMB-720D · Aripuanã, BrazilOn April 6, 2014, about 1130 universal coordinated time, an Embraer EMB-720D, Brazilian registration PT-ROS, was destroyed when it impacted trees and terrain near Aripuanã, Brazil. The pilot and three passengers were fatally injured. The flight originated…NTSB ERA14WA187Accident · 1 fatalForeign investigationPiper PA-30 · Collagna, ItalyOn April 4, 2014, at 0920 Coordinated Universal Time (UTC), a Piper PA-30, N678AL, was destroyed when it impacted terrain during cruise flight near Collagna, Italy. The pilot, the sole occupant, was fatally injured. The flight was operated by a private…NTSB CEN14WA184Accident · 2 fatalForeign investigationCessna T210L · San Marcos, GuatemalaOn April 1, 2014, about 1340 local time, a Cessna T210L, single engine airplane, N732JY, was destroyed after impacting mountainous terrain near San Marcos, Guatemala. The pilot and passenger were fatally injured. About 1318 the airplane departed from…NTSB WPR14WA311Accident · Serious injuriesForeign investigationRobinson Helicopter R22 Beta · Borroloola, Australia, AustraliaOn March 27, 2014, at 0900 universal coordinated time, a Robinson R22 Beta, VH-HRX, collided with terrain near Borroloola, Australia during an aerial mustering flight. The helicopter was operated by the pilot under the pertinent civil regulations of the…NTSB ERA14WA092Accident · 5 fatalForeign investigationBell 206 - L3 · Antioquia, ColombiaNTSB ANC14WA006Accident · 2 fatalForeign investigationSikorsky S76-C++ · Seoul, South KoreaOn November 16, 2013, about 2354 Coordinated Universal Time, a Sikorsky S76 C++ helicopter, Korean registration HL9294, operated by LG Electronics Co. Ltd., sustained substantial damage after colliding with a 26-story apartment building in Seoul, Korea. Both…NTSB ERA14WA063Accident · 3 fatalForeign investigationPiper PA-34-220T · Parati, Brazil, BrazilOn November 10, 2013 about 1600 universal coordinated time, a Piper PA-34-220T, Brazilian registration PR-EAG, was destroyed when it collided during a climb with the peak of Corisco Mountain, located in the Serra do Mar mountain range, near Parati…NTSB WPR14WA034Accident · 2 fatalForeign investigationLancair Legacy · Shepparton, AustraliaOn October 25, 2013 about 1410 local time, an amateur built Lancair Legacy airplane, Australian registration VH-ICZ, collided with terrain near Shepparton, Australia. The airplane sustained substantial damage and the pilot and passenger were fatally injured.…NTSB WPR14WA029Accident · 1 fatalForeign investigationPZL Okecie M18 · Ulladulla, AustraliaOn October 24, 2013 about 1000 local time, a PZL M18A Dromader aircraft, Australian registration VH-TZJ, collided with terrain near Ulladulla, Australia. The airplane was substantially damaged and the pilot was fatally injured. The airplane was operated as an…NTSB WPR14WA032Accident · 1 fatalForeign investigationCessna 182 - Q · Mount Hotham, AustraliaOn October 23, 2013 about 1130 local time, a Cessna 182Q airplane, Australian registration VH-KKM, collided with terrain near Mount Hotham, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was operated as a…NTSB WPR14WA030Accident · 1 fatalForeign investigationAyres S2R · Wave Rock, AustraliaOn October 18, 2013 about 1500 local time, an Ayres S2R airplane, Australian registration VH-JAY, collided with terrain near Wave Rock, Australia. The airplane was destroyed and the pilot was fatally injured. The airplane was operated as an agricultural…NTSB ERA14WA026Accident · 2 fatalForeign investigationLuscombe 8 - E · Buenos Aires, ArgentinaOn October 14, 2013, about 1134 coordinated universal time, a Luscombe 8E, Argentina registration LV-RTS, was substantially damaged, during descent in thick fog, when it impacted terrain in an industrial park. The flight had departed Zarate Airport (SATE),…NTSB ERA14WA020Accident · 1 fatalForeign investigationBell 407 - NO Series · Gobierno, ArgentinaOn October 11, 2013, at 1900 universal coordinated time, a Bell 407, Argentinian registration LQ-BHT, impacted power lines after takeoff near Gobierno, in the province of San Juan, Argentina. The pilot and three passengers were injured and one passenger was…NTSB CEN14WA115Accident · No injuriesForeign investigationGulfstream 550 · London, United KingdomOn October 12, 2013, at 0325 Universal Coordinated Time, a Saudi Arabia registered Gulfstream 550, HZ-A6, collided with the ILS antenna and localizer array while landing at Stanstead Airport (EGSS), London, United Kingdom. There were no injuries to the…NTSB WPR13WA433Accident · 5 fatalForeign investigationBell 212 - NO Series · Murbad, Thane District, India, IndiaOn September 29, 2013, at 0820 universal coordinated time, a Bell 212, VT-HGB, collided with terrain during cruise flight near Murbad (Thane District), India. The helicopter was destroyed and two flight crew and three passengers were fatally injured. The…NTSB WPR13WA423Accident · 1 fatalForeign investigationCessna 182 - R · Hamilton Aerodrome, Australia, AustraliaOn September 23, 2013, at 1950 universal coordinated time, a Cessna 182R, VH-AUT, collided with terrain near Hamilton Aerodrome, Australia. The flight was being operated under the pertinent civil regulations of Australia. The solo student pilot was fatally…NTSB WPR13WA410Accident · 2 fatalForeign investigationCessna U206 - G · Croydon, AustraliaOn September 15, 2013, about 1530 Eastern standard time, an Australian registered Cessna 206, VH-WAV, impacted terrain about 95 miles Southeast of Croydon, Queensland, Australia. The airplane was destroyed and the pilot and passenger were fatally injured. The…NTSB ERA13WA411Accident · 2 fatalForeign investigationDornier 228 · Valparaiso, ChileOn September 9, 2013, about 0940 universal coordinated time (UTC), a Dornier 228-202K CC-CNW impacted terrain while on approach for landing at Viña del Mar Airfield/NAS Base Aeronaval Viña del Mar in Chile. The airplane was destroyed, and the commercial pilot…NTSB ERA13WA367Accident · 4 fatalForeign investigationCessna 172 · Bolzano, ItalyOn August 17, 2013, at 1400 Universal Coordinated Time (UTC), a Cessna FR172J, German registration D-EDQL, operated by a flying club, was destroyed following a collision with mountainous terrain near San Pellegrino, Italy. The local flight originated in…NTSB ERA13WA359Accident · 2 fatalForeign investigationRobinson R-44 · Davidovo, RussiaOn August 6, 2013, at 1506 coordinated universal time (August 7, 2013, 0006 local time), an emergency locator beacon signal was detected for a Robinson R44, RA-06302, which was subsequently found destroyed on rising terrain about 7 nautical miles southwest of…NTSB ERA13WA322Accident · Serious injuriesForeign investigationCessna 208B · Mathews Ridge, GuyanaOn July 15, 2013, about 1157 coordinated universal time, a Cessna 208B, Guyana registration 8R-AMS, operated by Air Services Limited, was substantially damaged when it impacted terrain during approach at Matthew's Ridge Airport (SYMR), Matthew's Ridge,…NTSB ERA13WA319Accident · 2 fatalForeign investigationDiamond DA40-180 · Ticlio, PeruNTSB ERA13WA293Accident · 2 fatalForeign investigationPiper PA-28-161 · Barcis, ItalyOn June 18, 2013 at 1655 Universal Coordinated Time (UTC), a Piper PA-28, French registration F-GHLY, privately operated, was substantially damaged when it impacted with the slope of a mountain near Barcis, Italy during a cross-country flight from Locarno…NTSB ERA13WA290Accident · 1 fatalForeign investigationBeech 58 · Albenga, ItalyNTSB ERA13WA289Accident · 2 fatalForeign investigationBell 212 · Tefe, BrazilOn June 14, 2013, about 0810 universal coordinated time, a Bell 212 helicopter, Brazilian registration PR-HRZ, operated by an oil and gas exploration and production company, was destroyed when it impacted terrain shortly after takeoff from a support base…NTSB ERA13WA158Accident · 9 fatalForeign investigationBeech B200 · La Libertad, PeruOn March 6, 2013, about 1245 UTC, a Beech B200, OB-1992, registered to Dearborn and Flint Aviation Co, Inc., operated by Aero Transporte Sociedad Anonima ATSA, collided with a wire then terrain during visual approach to Aerodrome Pias (SPIS), La Libertad,…NTSB CEN13WA572Accident · 1 fatalForeign investigationPiper PA28 - 161 · Persan, FranceOn March 6, 2013, about 1920 universal coordinated time, a Piper PA28-161 airplane, F-GHPN, impacted terrain during final approach to land on runway 10, at the Persan-Beaumont Airport (LFPA), near Persan, France. The pilot was fatally injured. This…NTSB ERA13WA157Accident · 1 fatalForeign investigationCessna 172S · Mersin, TürkiyeOn February 12, 2013, at about 1414 Universal Time Coordinated, a Cessna 172S, Turkish registration TC-CDA, operated by the Turkish Aeronautical Association, impacted terrain during an instructional flight, near Mersin, Turkey. The flight instructor was…NTSB DCA13WA041Accident · Serious injuriesForeign investigationFokker 100 · Heho, Myanmar (Burma)On December 25, 2102, at 08:50 local time, a Fokker 100, registration XY-AGC operated by Air Bagan as flight W9-11 crashed short of the runway at Heho Myanmar (Burma). The flight was a scheduled passenger flight from Mandalay. There was one fatality and…NTSB ERA13WA089Accident · 4 fatalForeign investigationPiper PA34 · Zulia, ColombiaOn December 12, 2012, about 1530 universal coordinated time (1030 local time), a Piper PA-34-200T, Colombian registration HK4477G, was destroyed when it impacted rising mountainous terrain in the vicinity of La Cuchilla, near Zulia, Norte de Santander,…NTSB ERA13WA078Accident · 1 fatalForeign investigationCessna R172K · Cuchilla La Laja, ColombiaOn November 19, 2012, about 1030 hours local, a Cessna R172K, Colombian registration HK4890G, collided with mountainous terrain near Cuchilla La Laja – Municipio de San Francisco, Departmento de Cundinamarca, Colombia. Instrument meteorological conditions…NTSB ANC13WA010Accident · 1 fatalForeign investigationCessna 208 · Snow Lake, CanadaOn November 18, 2012, about 1000 central standard time, a Cessna 208B airplane, (Canadian Registration C-GAGP) was on a VFR flight plan from Snow Lake (CJE4) to Winnipeg (CYWG), Manitoba, Canada. The airplane crashed in a wooded area near the Snow Lake…NTSB ERA13WA074Accident · 4 fatalForeign investigationPiper PA-31T · Curitiba, BrazilOn November 6, 2012, at 2030 Coordinated Universal Time (UTC), a Piper PA-31T, Brazilian registration PT-MFW, was destroyed when it impacted terrain while approaching Bacacheri Airport (SBBI), Curitiba, Brazil. The flight was operated by Taxi Aereo Hercules,…NTSB ERA13WA068Accident · 4 fatalForeign investigationEmbraer 810D · Chapada dos Guimaraes, BrazilOn November 1, 2012, at 1950 Universal Coordinated Time (UTC), an Embraer Aircraft model EMB-810D (Piper Design PA-34-220T), Brazilian registration PT-VRV, operated by a private owner, was substantially damaged following an encounter with weather and a…NTSB ERA13WA031Accident · 1 fatalForeign investigationRobinson R-44 · Moscow, RussiaNoneNTSB ERA13WA156Accident · 1 fatalForeign investigationCessna 172S · Izmir, TürkiyeOn October 6, 2012, at 0915 Coordinated Universal Time (UTC), a Cessna 172S, Turkish registration TC-CBI, operated by the Turkish Aeronautical Association, impacted mountainous terrain during an instructional flight, near Izmir, Turkey. The flight instructor…NTSB WPR13WA014Accident · 1 fatalForeign investigationRobinson R22 · Halls Creek, Australia, AustraliaOn October 3, 2012, at about 1100 universal coordinated time, a Robinson Helicopter Company, R-22 Beta, VH-LLF, sustained substantial damage when it collided with the side of a canyon near the Halls Creek Aerodrome, Australia. The pilot was fatally injured.…NTSB ERA12WA488Accident · 8 fatalForeign investigationBeech 200 · Juiz de Fora, BrazilThis investigation is being conducted by the Brazilian Aeronautical Accident Prevention and Investigation Center This report is for information purposes only and contains only information released by the government Brazil. All inquiries should be directed to…NTSB WPR12WA334Accident · 1 fatalForeign investigationPiper PA34 · Broome, Australia, AustraliaOn July 11, 2012, at 2020 universal coordinated time, a Piper PA-34-200, VH-LCK, collided with terrain near Broome, Australia. The airplane was a charter flight operating under the pertinent civil regulations of Australia. The pilot was fatally injured and…NTSB ERA12WA463Accident · 1 fatalClass 5 · ForeignPiper PA36 · San Alberto, ColombiaOn July 10, 2012, about 1230 universal coordinated time, a Piper PA-36-375, Colombian registration HK2210, operated by Aeropenort LTDA. Agropecuaria del Norte, was substantially damaged when it collided with trees, during an aerial application flight near San…NTSB ERA12WA444Accident · 2 fatalForeign investigationLancair · Concepcio, ArgentinaOn July 3, 2012, about 1230 coordinated universal time (0930 local time), a Lancair IV-P, Argentine registration LV-X243, was substantially damaged when it impacted terrain in Concepcion, Corrientes Province, Argentina. The pilot and the passenger were…NTSB DCA12WA071Accident · 44 fatalForeign investigationSukhoi SJ100 · Mt. Salak, IndonesiaOn May 9, 2012, at 1450 local time, a Sukhoi SJ100-95, Russian registration RP97004, collided with terrain about 35 miles south of Jakarta, Indonesia. The airplane was on a demonstration flight. The 40 passengers and 4 crew were fatally injured, and the…NTSB ERA12WA301Accident · 2 fatalForeign investigationCessna T206H · Macapá, BrazilOn April 20, 2012, about 0855 universal coordinated time, a Cessna T206H, Brazilian registration PR-CRR, was substantially damaged when it collided with terrain approximately five minutes after takeoff from Macapa International Airport (SBMQ), Macapa, Brazil.…NTSB CEN12WA679Accident · 2 fatalForeign investigationRobinson R22 · Huy, BelgiumThis accident is under the jurisdiction and control of the Belgium government.NTSB ERA12WA255Accident · 4 fatalForeign investigationPiper PA-32R-300 · Treasure Cay, BahamasOn March 25, 2012, at 1830 UTC, a Piper PA-32R-300, N8415C, was substantially damaged when it crashed shortly after takeoff from Treasure Cay International Airport (MYAT), Abaco, Bahamas. The two certificated private pilots and two passengers were fatally…NTSB ERA12WA240Accident · 3 fatalForeign investigationCessna 182 · Barrancabermeja, ColombiaOn March 17, 2012, about 2145 universal coordinated time (1645 local time), a Cessna 182M, Colombian registration HK1441G, was substantially damaged when it impacted transmission lines, then terrain, about 3 nautical miles south of Aeropuerto Yariguies…NTSB ERA12WA212Accident · 1 fatalForeign investigationCessna 172N · Miranda, VenezuelaOn March 3, 2012, about 1259 universal coordinated time, a Cessna 172N, Venezuelan registration, YV105E, was destroyed when it impacted into terrain while in cruise flight near Municipio Zamora Parroquia Bolivar, Miranda, Venezuela. The pilot was fatally…NTSB ERA12WA202Accident · 1 fatalForeign investigationCessna 208 · Manaus, BrazilOn February 28, 2012, about 1020 universal coordinated time, a Cessna 208B, Brazilian registration PT-PTB, operated by Cleiton Taxi Aereo Ltda., was substantially damaged when it impacted a lamppost and terrain, during the initial climb after takeoff from…NTSB ERA12WA155Accident · 5 fatalForeign investigationBell 206 · Montana Auyantepui, VenezuelaOn January 18, 2012, about 1715 universal coordinated time, a Bell 206 L-4 helicopter, Venezuelan registration YV1985, was destroyed when it collided with a mountain during a sightseeing flight near Montaña Auyantepui, Parque Nacional Canaima, in the State of…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.…