Skip to content

NTSB investigations, 2015, Outside the U.S.

27 cases where the sequence of events included Loss of engine power (total).

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") = 2015 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" = '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

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\") = 2015
    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\" = '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 year(c."eventDate") = 2015
  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" = '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 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…Dec 11, 2015 · N593FL · No damage 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.…Dec 10, 2015 · XB-GRG · Substantial damage 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,…Nov 21, 2015 · HR-AWI · Substantial damage 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…Nov 14, 2015 · EC-HKH · Substantial damage 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…Sep 24, 2015 · TG-PDF · Substantial damage 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,…Sep 20, 2015 · HB-YEA · Destroyed 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…Aug 31, 2015 · D-ESPE · Destroyed NTSB CEN15RA452Incident · No injuriesForeign investigationPiper PA28 · Bergen, NorwayimportAug 31, 2015 · LN-BGQ · No damage NTSB 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…Aug 30, 2015 · PT-EPD · Substantial damage 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…Aug 12, 2015 · N924FE · Substantial damage 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,…Jul 25, 2015 · EI-DNN · Destroyed 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…Jul 22, 2015 · P2-HCB · Substantial damage 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…Jul 19, 2015 · HC-CLR · Destroyed 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.…Jul 6, 2015 · N642RM · Substantial damage NTSB CEN15WA256Accident · No injuriesForeign investigationCessna 180 - Undesignat · Half Moon Caye, BelizeJun 2, 2015 · V3-HHT NTSB ANC15WA067Accident · 1 fatalForeign investigationKevin D. Yarnevich Kitfox · Surrey, CanadaMay 8, 2015 · N688KY · Destroyed NTSB ERA15WA195Accident · 7 fatalForeign investigationPiper PA-32-300 · Punta Cana, Dominican RepublicApr 20, 2015 · HI 957 · Destroyed NTSB 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…Apr 1, 2015 · TJ-AII · Substantial damage 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…Mar 25, 2015 · OB-1851 · No damage 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…Mar 20, 2015 · HK2327 · Substantial damage 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…Feb 15, 2015 · P2-HFZ · Substantial damage NTSB CEN15WA150Accident · Minor injuriesForeign investigationPiper PA46 500TP · Björnön, SwedenFeb 15, 2015 · N164ST · Substantial damage NTSB 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.…Feb 7, 2015 · HB-ZOK · No damage 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…Jan 22, 2015 · VT-ANL · No damage 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…Jan 20, 2015 · RA-06205 · Substantial damage 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…Jan 10, 2015 · PT-NAB · Substantial damage 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…Jan 7, 2015 · ZK-SDT · Destroyed