NTSB investigations, Outside the U.S.
232 cases where the sequence of events included Loss of engine power (partial).
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\" = '342' 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" = '342' 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 ENG20WA009Incident · No injuriesForeign investigationAirbus A320 · Mumbai, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 22, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced high engine…NTSB GAA20WA108Incident · No injuriesForeign investigationDe Havilland DHC6 · Pau Pyrenesse, FranceThe government of France has notified the NTSB of an accident involving a DE HAVILLAND DHC6 airplane that occurred on December 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the…NTSB ENG20WA049Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Owerri, NigeriaNTSB CEN19WA274Accident · No injuriesForeign investigationBell 206 · Vuoggatjålme, SwedenOn August 10, 2019, about 0855 hours universal coordinated time, a Bell 206-L1, Swedish registration SE-JOA, was damaged when the rotor blades struck the tail boom during an emergency landing following a loss of engine power after takeoff near Vuoggatjålme,…NTSB GAA19WA458Incident · No injuriesForeign investigationSikorsky S92 · Sable Island, CanadaThe government of Canada has notified the NTSB of an accident involving a SIKORSKY S92 helicopter that occurred on July 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB GAA19WA592Accident · No injuriesForeign investigationBeech B36 · Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a BEECH B36 airplane that occurred on July 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB GAA19WA414Incident · No injuriesForeign investigationCessna 207 · Birtingarholt, IcelandNTSB CEN19WA254Accident · Minor injuriesForeign investigationCirrus SR22 · Abergavenny, United KingdomOn May 12, 2019, about 0930 coordinated universal time (UTC), a Cirrus Aircraft SR22T airplane, Guernsey registration 2-RORO, serial number 701, was destroyed during a forced landing and postimpact fire following a loss of engine power shortly after takeoff…NTSB ENG19WA017Incident · No injuriesForeign investigationAirbus A320 · Pune, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 2, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…NTSB ENG19WA018Incident · No injuriesForeign investigationAirbus A320 · Jaipur, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 1, 2019. An Indigo Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure…NTSB ERA19WA121Accident · 14 fatalForeign investigationDouglas DC3 · Vereda La Bendicion, ColombiaThe government of Colombia has notified the NTSB of an accident involving a DOUGLAS DC3 airplane that occurred on March 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…NTSB ENG19WA020Incident · No injuriesForeign investigationAirbus A320 · Lucknow, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on March 7, 2019. A GoAir Airbus A320 powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left) engine failure while…NTSB CEN19WA089Incident · No injuriesForeign investigationPiper PA19 · Brustem Airfield, Belgium, BelgiumThe government of Belgium has notified the NTSB of an accident involving a PIPER PA19 airplane that occurred on February 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Belgium's investigation under the provisions…NTSB ENG19WA012Incident · No injuriesForeign investigationAirbus A321 · Lahore, PakistanOn February 2, 2019, a Vietnam Airlines A321-272N Neo, powered by two P&W PW1130G-JM geared fan engines experienced an No. 2 (right ) engine failure while in cruise. It was reported that a stall warning was detected followed by high vibration and an exhaust…NTSB CEN19WA079Accident · 1 fatalForeign investigationCessna 150 · Durango, MexicoNTSB ENG19WA009Incident · No injuriesForeign investigationAirbus A320 · Lucknow, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 21, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing through FL120 after departure from Lucknow Airport…NTSB ENG21WA016Incident · No injuriesClass 5 · ForeignBoeing 737 · Lagos, NigeriaNTSB ENG19WA010Incident · No injuriesForeign investigationAirbus A320 · Chennai, IndiaThe government of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on January 3, 2019. An Indigo Airbus A320 experienced a No. 2 (right) engine failure while climbing while climbing after departure from Chennai Airport…NTSB CEN19WA080Accident · No injuriesForeign investigationCirrus SR22 · Toussus-Le-Noble, FranceThe government of France has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…NTSB ENG19WA005Incident · No injuriesForeign investigationBoeing 767 · Addis Ababa, EthiopiaOn November 26, 2018, a Boeing 767-300 airplane, operated by Ethiopian Airlines, experienced a right engine (No. 2) fan blade failure during takeoff from the Addis Ababa Bole International Airport (ADD), Ethiopia. The airplane returned to ADD where an…NTSB ERA19WA046Accident · Serious injuriesForeign investigationGarlick UH1D · Valparaiso, ChileThe government of Chile has notified the NTSB of an accident involving a GARLICK UH1D helicopter that occurred on October 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions…NTSB CEN19WA012Accident · 2 fatalForeign investigationCessna 150M · La Paz, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150M airplane that occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB ERA18WA248Accident · No injuriesForeign investigationBell 206 · Bartica, GuyanaThe government of Guyana has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions…NTSB CEN18WA327Accident · No injuriesForeign investigationColumbia LC41-550FG · Vallecillos, MexicoOn July 4, 2018, about 1910 UTC, a Mexican registered Columbia LC41-550FG airplane, XB-OHG, sustained substantial damage during a forced landing due to a loss of engine power near Vallecillos, Nuevo Leon, Mexico. The pilot was not injured. The flight…NTSB DCA18WA174Incident · No injuriesForeign investigationBoeing 737 · Arequipa, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB ENG18WA011Incident · No injuriesForeign investigationAirbus A330 · Alice Springs, AustraliaOn January 18, 2018, about 14:25 Western Australian standard time, a Malaysian-registered Airbus A330-323 airplane had the No. 1 engine, a Pratt & Whitney PW4168A engine shutdown by the flight crew after it had compressor stalls. The airplane, which was…NTSB WPR18WA159Accident · Serious injuriesForeign investigationRobinson R44 · Ayers Rock, AustraliaOn January 17, 2018, at 1800 local time, a Robinson R44 helicopter, VH-HGX, experienced a partial loss of engine power shortly after takeoff. The pilot subsequently initiated an autorotation, landed hard and rolled over near Ayres Rock, Australia. The pilot…NTSB ERA18WA061Accident · 1 fatalForeign investigationCessna A188 · Dom Pedrito, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR18WA061Accident · Minor injuriesForeign investigationEnstrom 480 · Bacoor, PhilippinesOn December 2, 2017, at 0900 universal time coordinated, a Enstrom Helicopter Corporation 480B, RP-C8955, was substantially damaged during a precautionary landing near Bacoor, Cavite, Philippines. The pilot was not injured, and the passenger sustained minor…NTSB CEN17WA343Accident · 2 fatalForeign investigationPiper Piper PA-28RT-201 · Wolferton, United KingdomOn September 11, 2017, at 0956 universal coordinated time (UTC), a Piper PA-28RT-201 single-engine airplane, United Kingdom registration G-BHAY, serial number 28R-7918213, was substantially damaged during a forced landing following a loss of engine power and…NTSB CEN17WA221Accident · Serious injuriesForeign investigationSilence Twister · Abingdon, United KingdomOn May 14, 2017, at 1330 universal coordinated time (UTC), a Silence model Twister single-engine airplane, United Kingdom registration G-JINX, serial number LAA 329-15102, was substantially damaged during a forced landing following a loss of engine power…NTSB CEN17WA256Accident · No injuriesForeign investigationLancair IV · Grenaa, DenmarkOn May 12, 2017, about 0635 coordinated universal time, a Lancair IV P airplane, Swiss registration SE-XRU, was substantially damaged when it impacted terrain near Grenaa, Denmark. The airplane was registered to and operated by a private individual as a…NTSB ENG17WA020Incident · No injuriesForeign investigationBAE JETSTREAM3100 · Monteria, ColombiaOn April 15, 2017, a Colombian-registered BAE Jetstream J32, HK4820, operated by Aerolinea de Antioquia ADA experienced a loss of power from the No. 2 engine, a Honeywell TPE331 turbopropeller. The engine was shutdown in flight and the airplane diverted to…NTSB ERA17WA132Accident · Serious injuriesForeign investigationBell 206 · Araucária Municipality, BrazilThe government of Brazil has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on March 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ENG17WA015Incident · No injuriesForeign investigationAirbus A320 · Sao Paulo, BrazilOn February 23, 2017, during takeoff from São Paulo airport, the right hand engine of a Brazilian registered Airbus 320, registration number PT–MZY, lost power, causing a rejected takeoff and a temporary excursion from the runway. The Brazilian Centro de…NTSB CEN17WA380Incident · No injuriesForeign investigationSchweizer 269C · Locarno, SwitzerlandOn February 7, 2017, about 1016 universal coordinated time (UTC), a Schweizer 269C helicopter, Swiss registration HB-XFQ, conducted a precautionary landing near Locarno (LSZL), Switzerland, after the engine oil pressure was at minimum pressure and the oil…NTSB ERA17WA080Accident · 6 fatalForeign investigationNeiva EMB-721D · Manaus, BrazilOn December 7, 2016, about 1150 UTC, an Industria Aeronautica Neiva S/A EMB 721D, Brazilian registration PT-REI, registered to and operated by a foreign individual, collided with trees then terrain shortly after takeoff. Visual meteorological conditions…NTSB DCA16WA241Accident · No injuriesForeign investigationCessna 152 · Nairobi, KenyaThe Kenya Air Accident Investigation Division (AAID) has notified the NTSB of an accident involving a Cessna 152 airplane that occurred on September 12, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAID investigation under the…NTSB CEN16WA340Accident · 1 fatalForeign investigationQuad City Challenger II · Amos, CanadaOn August 9, 2016, at 1530 UTC, a Quad City Challenger II (S/N CH2-0903-2368), C-IIJW, impacted terrain near the runway end at Amos/Magny Airport (CYEY), Amos, Quebec, Canada. The aircraft was destroyed and sole occupant on board was fatally injured. The…NTSB DCA16WA112Incident · No injuriesForeign investigationBeech 1900 · Karachi, PakistanThe Pakistan Safety Investigation Board (PSIB) has notified the NTSB of an incident involving an Hawker Beechcraft 1900D that occurred on March 18, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the PSIB investigation under the…NTSB ENG16RA026Incident · No injuriesForeign investigationCessna 208 · Georgetown, GuyanaThe Guyana Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving a Cessna 208B, which occurred on March 3, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO…NTSB DCA16WA087Incident · No injuriesForeign investigationBoeing 777 · Punta Cana, Dominican RepublicThe Dominican Republic Comisión Investigadora de Accidentes de Aviación (CIAA) has notified the NTSB of an incident involving a BOEING 777-200 that occurred on February 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB DCA16WA049Incident · No injuriesForeign investigationBombardier BD100 1A10 · Le Bourget, FranceThe BEA of France has notified the NTSB of an incident involving a Bombardier BD100 1A10 that occurred on December 02, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA's investigation under the provisions of ICAO Annex 13 as the…NTSB ENG16IA001Incident · No injuriesIncident investigationFinal reportBoeing 747 · Russian airspace, JapanThe PW4056 engine experienced an in-flight loss of power because of damage to the low-pressure turbine (LPT) because of the inadequate overhaul inspection and repair instructions that existed at the time of the LPT module's last overhaul. A vane hook in the…NTSB ENG15WA040Incident · No injuriesForeign investigationBell 407 · Morobe Province, Papua New GuineaOn May 2, 2015, a Bell Helicopters 407 powered by a Roll-Royce M250-C47B turboshaft experienced an unexpected uncommanded high rate of descent while on approach to the helipad with an external load of two diesel fuel drums. The pilot jettisoned his load and…NTSB ENG15RA023Incident · No injuriesForeign investigationBoeing 400 · Islamabad, Pakistan, PakistanOn April 21, 2015, a Shaheen Air International (SAI) Boeing 737-400, powered by CFMI CFM56-3C1 turbofan engines, experienced a No. 1 (left engine) failure while climbing through 3,200 feet. The flight crew heard a loud band and high exhaust gas temperature…NTSB CEN15WA161Accident · No injuriesForeign investigationCirrus SR22 · Ljubljana, Moste, Slovenia, SloveniaThe accident investigation is under the jurisdiction and control of the Slovenian government. This report is for information purposes only and contains only information released by or obtained from the Slovenian government. Further information pertaining to…NTSB ENG15RA015Incident · No injuriesForeign investigationBoeing 767 - 204ER · Islamabad, Pakistan, PakistanOn February 15, 2015, a Jordan Air Boeing 767-204ER, leased by Shaheen Air International (SAI), experienced a failure of the No. 1 engine, a General Electric CF6-80A2 turbofan engine, during the takeoff roll from the Islamabad International Airport (ISB),…NTSB DCA15RA059Accident · 43 fatalForeign investigationATR 72 · Taipei, TaiwanimportNTSB ENG15WA008Incident · No injuriesForeign investigationAirbus A319 - 132 · Zurich, SwitzerlandOn October 17, 2014, an Air Serbia Airbus 319-132, registration umber YU-APA, powered by two IAE V2524-A5 turbofan engines experienced a right engine oil leak shortly after departure. The flight crew performed an inflight shutdown of the engine and an air…