NTSB investigations, Outside the U.S.
576 cases where the sequence of events included Loss of engine power (total).
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\" = '341' 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" = '341' 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 ERA16WA298Accident · 2 fatalClass 3 · ForeignCessna 550 · Charallave, VenezuelaNTSB CEN16WA325Accident · 1 fatalForeign investigationPiper PA38 · Peterborough, CanadaOn August 11, 2016, at 0520 coordinated universal time, a Piper PA-38-112, Canadian-registered C-FSYH, was damaged when it struck several metal poles during a forced landing near Peterborough, Ontario, Canada. Visual meteorological conditions prevailed at the…NTSB ERA16WA306Accident · 8 fatalForeign investigationEmbraer EMB820 · Londrina City, BrazilOn July 31, 2016, at 2357 universal coordinated time, an Embraer EMB820C (Piper PA-31-350), Brazilian registration PT-EFQ, was destroyed when it impacted a power line and terrain following a loss of power in the left engine, while on approach to Londrina…NTSB CEN16WA298Accident · Minor injuriesForeign investigationHughes 369 · Senheim, GermanyOn July 26, 2016, about 1407 hours coordinated universal time, a Hughes model 500E helicopter, German registration D-HMIC, sustained substantial damage during a hard landing following a loss of engine power near Senheim, Germany. The pilot received minor…NTSB ERA16WA275Accident · Serious injuriesForeign investigationCessna TU206 · San Martin, ColombiaOn July 23, 2016, at 1910 coordinated universal time, a Cessna TU206G, Columbian registration HK2787, was substantially damaged following an in-flight loss of engine power and subsequent forced landing in the Municipality of San Martin, Colombia. The pilot…NTSB CEN16RA233Accident · No injuriesForeign investigationBell 407 · Kassel, Hesse, Germany, GermanyOn June 26, 2016, about 1420 hours universal coordinated time, a Bell model 407 helicopter, German registration D-HEAB, sustained substantial damage during a hard landing following a loss of engine power near Kassel, Hesse, Germany. The pilot was not injured.…NTSB ERA16WA232Accident · No injuriesForeign investigationCessna U206 · Fresh Creek, BahamasOn June 25, 2016, about 2106 Universal Coordinated Time (UTC), a Cessna U206F, N9662G, operated by Chrimat Inc., was substantially damaged following a loss of engine power and forced landing at Fresh Creek, Bahamas. The pilot was not injured. The airplane…NTSB CEN16WA262Accident · 2 fatalForeign investigationLiberty XL · La Lima, HondurasOn June 23, 2016, about 2259 UTC, a Discovery Aviation, Incorporated, Liberty XL-2, Honduran registration HR-HZT, owned and operated by Horizontes Flight School was destroyed when it impacted the roof of a house in a residential neighborhood near La Lima,…NTSB DCA16WA178Incident · No injuriesForeign investigationAirbus A320 · Lisbon, PortugalGabinete de Prerencao e Investigacao de Acidentes com Aeronaves (GPIAA) Portugal has notified the NTSB of an accident involving a AIRBUS A320 airplane that occurred on May 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceNTSB ERA16WA196Accident · No injuriesForeign investigationSikorsky S76 · Campos dos Goytacazes, BrazilOn April 28, 2016, about 1330 coordinated universal time, a Sikorsky S76A, Brazilian registration PR-EMR, was substantially damaged during an emergency landing after a fire indication and precautionary engine shutdown on the right engine followed shortly by a…NTSB ENG16RA021Incident · No injuriesForeign investigationATR ATR72 · Trapani, ItalyThe Agenzia Nazionale per la Sicurrezza del Volo (ANSV) has notified the NTSB of an incident involving an ATR 72 that occurred April 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the provisions of ICAO…NTSB ERA16WA155Accident · Minor injuriesForeign investigationDouglas DC3 · Puerto Gaitan, ColombiaOn April 7, 2016, about 1200 coordinated universal time, a Douglas DC3-C, Colombian registration HK2663, was destroyed during a postimpact fire, following a forced landing to a field due to a loss of power on the left engine during initial climb from Puerto…NTSB CEN16WA144Accident · 3 fatalForeign investigationCessna 208 · Tayoltita, Dgo, Mexico, MexicoOn April 1, 2016, about 0900 local time, a Cessna 208B single engine airplane, serial number 208B2104, registry XA-ULU, was substantially damaged during an off-airport forced landing near Tayoltita, San Dimas, Durango, Mexico. There were ten persons on-board…NTSB ERA16WA206Accident · No injuriesForeign investigationCessna 150 · Daule, EcuadorOn March 20, 2016, at 1730 Universal Coordinated Time (UTC), a Cessna 150L, Ecuadorian registration HC-CJS, operated by Sky Ecuador, received substantial damage following a loss of engine power and forced landing in a rice field near Daule, Ecuador. The…NTSB ERA16WA339Accident · 2 fatalForeign investigationPiper PA28 · Johannesburg, South AfricaOn March 7, 2016, about 1410 coordinated universal time, Piper PA28-140, South African registration ZS-EXV, was destroyed when it impacted terrain during an emergency landing to Mountain View Airfield (FAMV), Johannesburg, South Africa. The pilot and a…NTSB WPR16WA191Accident · No injuriesForeign investigationVans RV8 · Chiang Mai, ThailandOn January 24, 2016, about 1030 local time, a Van RV-8, HS-GMC, initiated a forced landing near Chiang Mai, Thailand after experiencing a total loss of engine power during cruise flight. The owner/pilot, and one passenger, were not injured; the airplane…NTSB ERA16WA095Accident · 6 fatalForeign investigationAir Tractor AT401 · Londrina, BrazilOn January 20, 2016, about 1910 universal coordinated time, an Air Tractor AT401B, Brazilian registration PT-WFX, was destroyed by collision with a motor vehicle and terrain in Londrina Municipality, State of Parana, Brazil. The Brazilian certificated pilot…NTSB ENG16WA008Incident · No injuriesForeign investigationBoeing 767 · Lima, PeruOn January 11, 2016, a Boeing 767-316ER, powered by two General Electric CF6-80C2B6F turbofan engines experienced an inflight uncommnaded shutdown of the right engine. The engine was successfully restarted and the flight continued to its intended destination.…NTSB ENG16WA006Incident · No injuriesForeign investigationAirbus A319 · Bogota, ColombiaOn December 11, 2015, an Avianca Airbus A318-111, N593EL, equipped with CFMI CFM56-5 engines, experienced a loss of power from the No. 1 (left) engine. The airplane was operating as Avianca flight AV9398 from Bogota, Colombia to Pasto, Colombia when the…NTSB CEN16WA065Accident · No injuriesForeign investigationEnstrom 280 · Salinas Victoria, MexicoOn December 10, 2015, about 1710 universal coordinated time, an Enstrom 280FX helicopter, XB-GRG, sustained substantial damage on impact with terrain near Salenas Victoria, Mexico. The pilot sustained a serious injury and the two passengers were uninjured.…NTSB CEN16WA048Accident · No injuriesForeign investigationBell 407 · Justo Romero, NicaraguaOn November 21, 2015, at 1000 central standard time (cst), a Bell model 407 helicopter, Honduran registration HR-AWI, serial number 53978, sustained substantial damage during a forced landing following a total loss of engine power near Justo Romero,…NTSB CEN16WA046Accident · Serious injuriesForeign investigationCessna 172N · Gorliz, SpainOn November 14, 2015, at 1157 UTC, a Cessna 172, Spanish registration EC-HKH, collided with the water in the Astondo Bay off the coast of Gorliz, Spain, following a loss of engine power. The pilot and one passenger received minor injuries and a second…NTSB CEN15WA447Accident · No injuriesForeign investigationBell 407 · San Agustine Guatemala, GuatemalaThe Direccion General de Aeronutica Civil (DGAC) of Guatemala has notified the NTSB of a non-fatal accident involving a Bell 407GX Helicopter, registration TG-PDF, that occurred on September 24, 2015. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN15WA456Accident · 1 fatalForeign investigationAmateur Construction Glasair RG · Muhen, SwitzerlandOn September 20, 2015, about 1000 hours universal coordinated time, a Glassair RG airplane, Swiss registration HB-YEA was destroyed when it impacted an automobile and burst into flames during a forced landing following a loss of engine power near Muhen,…NTSB CEN15WA408Accident · Minor injuriesForeign investigationPiper PA-46-350P · Cannes, FranceOn August 31, 2015, about 0655 coordinated universal time, a Piper PA-46-350P airplane, D-ESPE, landed in the bay near Cannes, France, following a loss of engine power after takeoff from the Cannes-Mandelieu Airport (LFMD), Cannes, France. The pilot and…NTSB CEN15RA452Incident · No injuriesForeign investigationPiper PA28 · Bergen, NorwayimportNTSB ERA15WA371Accident · 2 fatalForeign investigationEmbraer EMB721 · Sao Felix do Xingu, BrazilOn August 30, 2015, about 1830 universal coordinated time, an Embraer EMB721, Brazilian registration PT-EPD, was substantially damaged during a forced landing after a loss of engine power near São Félix do Xingu Municipality, State of Pará, Brazil. The…NTSB ERA15WA310Accident · Minor injuriesForeign investigationCessna 208B · Saba, NTOn August 12, 2015, at 1630 Universal Coordinated Time (UTC), a Cessna 208B, U.S. Registration N924FE, operated by Mountain Air Cargo, was substantially damaged following a loss of engine power and ditching in the Caribbean Sea near Saba, Netherlands…NTSB CEN15WA317Accident · 1 fatalForeign investigationCox Bede BD-5G · Garranbane, IrelandOn July 25, 2015, at 1745 universal coordinated time (UTC), a Cox model Bede BD-5G amateur-built airplane, Irish registration EI-DNN, serial number HJC4523, was destroyed during a postimpact fire following a forced landing near Garranbane, Ireland. The pilot,…NTSB WPR15WA231Accident · Minor injuriesForeign investigationBell 407 - NO Series · Tifalmin Village Papua New Guinea, Papua New GuineaOn July 22, 2015, at 1325 local time, a Bell 407, P2-HCB, registered to and operated by Hevilift, experienced a loss of engine power while maneuvering away from a drilling/exploration camp near Tifalmin Village, Papua New Guinea. The helicopter subsequently…NTSB ERA15WA275Accident · Serious injuriesForeign investigationCessna 206G · Sucua, EcuadorOn July 19, 2015, about 1515 universal coordinated time, a Cessna 206G, HC-CLR, was destroyed by collision with terrain during a forced landing following a loss of engine power during descent to Edmund Carvajal Airport (XMS), Macas, Santiago, Ecuador. The…NTSB ERA15WA260Accident · No injuriesForeign investigationQuest Kodiac 100 · Pskov, RussiaOn July 6, 2015, about 1312 universal coordinated time, Quest Kodiak 100, U.S. registration N642RM, was substantially damaged by collision with terrain during a forced landing following a loss of engine power after takeoff from Pskov Airport, Pskov, Russia.…NTSB CEN15WA256Accident · No injuriesForeign investigationCessna 180 - Undesignat · Half Moon Caye, BelizeNTSB ANC15WA067Accident · 1 fatalForeign investigationKevin D. Yarnevich Kitfox · Surrey, CanadaNTSB ERA15WA195Accident · 7 fatalForeign investigationPiper PA-32-300 · Punta Cana, Dominican RepublicNTSB DCA15WA211Accident · No injuriesForeign investigationAyres S2R · Penja, CameroonThe Cameroon Civil Aviation Authority (CCAA) has notified the NTSB of an accident involving a Ayres S2R-T34 airplane that occurred on April 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CCAA's investigation under the…NTSB DCA15WA103Incident · No injuriesForeign investigationBoeing 737 · Tarapoto, PeruThe CIAA of Peru has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA's investigation under the provisions of ICAO Annex 13 as the…NTSB ERA15WA167Accident · 2 fatalForeign investigationCessna TU206 - G · Mitu, ColombiaOn March 20, 2015, about 1805 coordinated universal time, a Cessna TU206G, Colombian registration HK-2327, was substantially damaged while ditching into the Vaupés River near the Fabio Alberto León Bentley Airport (SKMU), Mitú, Columbia. The pilot and a…NTSB WPR15WA124Accident · No injuriesForeign investigationBell 206 - L4 · Wabo, Papua New Guinea, Papua New GuineaOn February 15, 2015, at 1020 local time, a Bell 206 L4, P2-HFZ, experienced a loss of engine power while maneuvering with an external load and subsequently landed hard near Wabo, Papua New Guinea. The helicopter was operated by Helifax Operations Limited…NTSB CEN15WA150Accident · Minor injuriesForeign investigationPiper PA46 500TP · Björnön, SwedenNTSB CEN15WA142Incident · No injuriesForeign investigationRobinson R66 · Bern, SwitzerlandThis is preliminary information, subject to change, and may contain errors. On February 7, 2015, between 1300-1400 UTC, a Robinson R66 helicopter, HB-ZOK, (s/n 0553) experienced a loss of engine power during recovery from an autorotation on a training flight.…NTSB ENG15RA006Incident · No injuriesForeign investigationBoeing 787-8 · Budapest, HungaryOn January 22, 2015, about 1700 local (1600 UTC), an Air India Boeing 787-8, VT-ANL, experienced a failure of the right engine, a General Electric GEnx-1B, while in cruise flight and diverted to Budapest, Hungary. The airplane was enroute from London Heathrow…NTSB ERA15WA105Accident · No injuriesForeign investigationRobinson R66 · Tashanta, RussiaOn January 20, 2015, at an undetermined time, a Robinson Helicopter R66, Russian registration RA-06205, was substantially damaged during a forced landing near Tashanta, Russia. The pilot and two passengers were not injured. The flight originated in…NTSB ERA15WA112Accident · 2 fatalForeign investigationEmbraer EMB-710C · Luziania, BrazilOn January 10, 2015, about 2105 universal coordinated time, an Embraer EMB-710C, Brazilian registration PT-NAB, was substantially damaged when it impacted a residence, after experiencing a loss of engine power during the initial climb after takeoff from the…NTSB ENG15RA030Accident · No injuriesForeign investigationPac 750XL - NO Series · Taupo, New Zealand, New ZealandOn 7 January 2015, a Pacific Aerospace Limited 750XL airplane, registration No. ZK-SDT, while performing commercial skydiving operations, experienced an engine failure while climbing through approximately 3000 feet, after take-off from Taupo Aerodrome in the…NTSB ERA15WA098Accident · 5 fatalForeign investigationAerospatiale AS350B · Bertioga, BrazilOn December 27, 2014, about 1240 UTC, an Aerospatiale AS350B, Brazil registration PT-HNC, collided with trees near Rio-Santos, Bertioga, Brazil. The pilot and 4 passengers were fatally injured, and the helicopter was destroyed. The helicopter was registered…NTSB CEN15WA096Accident · No injuriesForeign investigationPiper PA-32-260 · Lorrha, Tipperary, Ireland, IrelandOn December 24, 2014, at 1410 universal coordinated time (UTC), a Piper PA-32-260, United Kingdom registration G-OCTI, sustained substantial damage during an forced landing near Lorrha, Tipperary, Ireland, after experiencing an engine failure. There were no…NTSB ERA15LA091Accident · Minor injuriesLimited investigationFinal reportCessna 172M · South Bimini, BahamasThe total loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation, which resulted in a subsequent ditching in the ocean.NTSB ANC15WA017Accident · Minor injuriesForeign investigationCirrus Design SR20 · Ibusuki City, JapanOn October 12, 2014, about 0530 coordinated universal time, a US registered Cirrus SR-20 airplane, N176CD, experienced a total loss of engine power near Ibusuki City, Kagoshima Prefecture, Japan. The pilot made a emergency landing, and received minor…