NTSB investigations, Outside the U.S.
200 cases where the sequence of events included Powerplant sys/comp malf/fail.
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\" = '340' 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" = '340' 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 ENG19IA008IncidentClass 3 · IncidentFinal reportAirbus A220 · Busan, South KoreaThe manufacturer’s inadequate cleaning of the crucible before melting the nickel alloy used in casting the low pressure turbine stage 3 blades that resulted in a casting anomaly from where an intergranular crack occurred became the origin of a fatigue crack…NTSB WPR19WA038Accident · No injuriesForeign investigationBell 407 GX · West Bangkala, IndonesiaOn November 28, 2018, about 0850 coordinated universal time, a Bell Helicopter 407 GX, PK-JPB, executed a precautionary landing following the illumination of the engine chip detector caution light near West Bangkala, Indonesia. There were no injuries to the…NTSB ENG18RA029Incident · No injuriesForeign investigationBoeing 767 · Kumamoto, Japan, JapanThe Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a B767-300 that occurred May 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex 13…NTSB ENG18WA027Incident · No injuriesForeign investigationBombardier CL600 2B19 · Geuteng, South Africa, South AfricaThe Government of South Africa has notified the NTSB of an incident involving a Bombardier CL-600-2B19 that occurred May 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the South African Civil Aviation Authority (CAA) investigation…NTSB WPR18WA281Accident · No injuriesForeign investigationZenith CH610 HD · Germiston, South AfricaOn May 12, 2018, about 0730 Universal Coordinated time, a Zenith Zodiac CH 610 HD airplane, ZU-FFA, touched down and overturned about 100 meters short of runway 11 at Rand Airport, Germiston, South Africa, following a loss of engine power. The pilot sustained…NTSB ENG18WA025Incident · No injuriesForeign investigationAirbus A330 · Brisbane, QLD, AustraliaThe Australian Government has notified the NTSB of an incident involving an Airbus A330-202 that occurred April 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Australian Transport Safety Bureau (ATSB) investigation under the…NTSB ENG18WA021Incident · No injuriesForeign investigationBoeing 747 · Chek Lap Kok, Hong Kong SAR ChinaThe Hong Kong Civil Aviation Department (HKCAD) has notified the NTSB of an incident involving a Boeing 747-8F airplane which occurred on March 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the HKCAD investigation under the…NTSB ENG18RA018Incident · No injuriesForeign investigationCessna 441 · Broome, Australia, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Cessna 441 which occurred on March 2, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of ICAO…NTSB DCA18RA093Incident · Minor injuriesForeign investigationAirbus A330 · Lagos, NigeriaThe AIB of Nigeria has notified the NTSB of an incident involving a Airbus A330 airplane that occurred on February 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB of Nigeria's investigation under the provisions of ICAO…NTSB ENG18WA010Incident · No injuriesForeign investigationBoeing 737 · Lima, PeruOn January 25, 2018, a Peruvian Air Lines Boeing 737-530, registered in Peru as OB-2140P, had an uncommanded shutdown of the No. 2 engine, a CFMI CFM56-3B1, after leveling off at FL370. The flight crew declared an emergency and diverted back to Lima, Peru.…NTSB ENG18WA005Incident · No injuriesForeign investigationBoeing 767 · Karachi, PakistanThe Safety Investigation Board of Pakistan has notified the NTSB of an incident involving a Boeing 767-200 airplane which occurred on November 1, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the SIB investigation under the…NTSB CEN17WA160Accident · Minor injuriesForeign investigationCessna U206 · Seine-Maritime, FranceOn April 9, 2017, about 1430 universal coordinated time (UTC), a Cessna U206-F airplane, F-HNCM, flipped on it back during a forced landing near Seine-Maritime, France, following a loss of engine power. The pilot and four passengers received minor injuries…NTSB ENG17WA019Incident · No injuriesForeign investigationSaab 340 · Dubbo, AustraliaOn March 23, 2017, a Saab 340B, registered in Australia as VH-RXS, had an in-flight shutdown of the right engine, a General Electric CT7-9B. During the climb, the crew detected abnormal turbine temperatures and vibrations from the right engine. The crew shut…NTSB ENG17WA016Incident · No injuriesForeign investigationSaab 340 · Sydney, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Saab 340B which occurred on March 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of ICAO…NTSB ENG16WA040Incident · No injuriesForeign investigationAirbus A319 · Chiclayo, PeruThe Comisión de investigación de accidentes de aviación (CIAA) of Peru has notified the NTSB of an incident involving an Airbus A319-132, which occurred on September 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA…NTSB ENG16WA036Incident · No injuriesForeign investigationBoeing 777 · Tarcoola, Australia, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 777-31HER which occurred on September 7, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions…NTSB ENG16WA032Incident · No injuriesForeign investigationBoeing 787 · Over the Pacific, A1On August 7, 2016, a Jetstar Boeing 787, powered by 2 General Electric (GE) GEnx-1B64/P2 engines experienced a right engine (No. 2) low oil quantity indication while cruising over the Pacific. The engine was shutdown and the airplane was diverted to Guam…NTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceNTSB CEN16WA159Incident · No injuriesForeign investigationCessna 550 · Geneva, SwitzerlandThe Swiss Accident Investigation Board (SAIB) of Switzerland has notified the National Transportation Safety Board (NTSB) of an incident involving a Cessna Aircraft Company S550 Citation S/2, EC-LQF, that occurred on April 9, 2016. The NTSB has appointed a…NTSB ENG16WA013Incident · No injuriesForeign investigationAirbus A320 · Rome, ItalyThe Italian Agenzia Nazionale per la Sicurezza del Volo (ANSV) has notified the NTSB of an incident involving an Airbus 320-216, which occurred on March 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under…NTSB ENG16WA014Incident · No injuriesForeign investigationFairchild SA-227-AT · Brisbane, AustraliaDuring a post-flight inspection of a Fairchild SA227-AT, Registration Number VH-UZI, powered by two TPE331-11U-611G Honeywell Turbine engines, evidence of a fuel leak was detected on the left-hand engine. Further investigation revealed a fire on the left-hand…NTSB ENG16RA011Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoThe Dirección General de Aviación Civil of Mexico has notified the NTSB of an accident involving a AIRBUS A320-233 that occurred on March 13, 2016. The NTSB has designated a U.S. Accredited Representative to assist the DGAC investigation under the provisions…NTSB ENG16WA009Incident · No injuriesForeign investigationZurich, SwitzerlandOn March 10, 2016, about 1611 UTC, a Swiss Global Air Lines AVRO 146-RJ100 airplane, Swiss registration HB-IYT, rejected its takeoff at Zurich, Switzerland at 45 knots because of sparks coming from the No. 2 engine. The investigation of this incident is under…NTSB ENG16RA024Incident · No injuriesForeign investigationAirbus A320 · Suvarnabhumi Airport, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving an A320-232 that occurred January 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the provisions of…NTSB CEN16WA057Accident · No injuriesForeign investigationCessna 560 · Farnborough, United KingdomThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On November 29, 2015, at 1350 UTC, a Cessna Citation 560XL, SE-RHJ, experienced an in-flight cowling departure during descent…NTSB ENG15RA038Incident · No injuriesForeign investigationATR ATR72 · Lampedusa, ItalyThe Agenzia Nazionale per la Sicurrezza del Volo (ANSV) has notified the NTSB of an incident involving an ATR 72 that occurred August 7, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the provisions of…NTSB DCA15WA182Incident · No injuriesForeign investigationBombardier CL600 2E25 · Makassar, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a CRJ-1000, which occurred on August 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under the…NTSB ENG15RA028Incident · No injuriesForeign investigationAirbus A330 - 223 · Riyadh, Saudi Arabia, Saudi ArabiaOn July 23, 2015, at about 12:23 UTC, a Korean Air Airbus A330-223, registration number HL8211, experienced a No. 1 (left engine) stall after initial takeoff from the King Khalid International Airport (KSA) in Riyadh, Saudi Arabia. The flight crew received a…NTSB ENG15WA022Incident · Minor injuriesForeign investigationBoeing 727-2F9 · Bogotá, Colombia, ColombiaOn May 6, 2015 at about 1215 coordinated universal time, a Boeing 727-200F, operated by Líneas Aéreas Suramericanas experienced an uncontained No.1 engine failure shortly after takeoff from El Dorado International Airport (SKBO), Bogotá, Colombia. The…NTSB ENG15WA034Incident · No injuriesForeign investigationAirbus A320 · Tehran, IranThe Civil Aviation Organization of the Islamic Republic of Iran (CAO.IRI) has notified the NTSB of an incident involving an Airbus A320-200, which occurred on February 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAO…NTSB ENG15RA003Incident · No injuriesForeign investigationATR ATR72 - 212A · Visby, SwedenOn November 30, 2014, an ATR72-212A airplane, SE-MDB, experienced excessive vibration during approach to Visby Airport(ESSV), Gotland, Sweden. The right engine was shut down and a single-engine landing was performed. Post-incident inspection found damage to…NTSB ENG15WA002Incident · No injuriesForeign investigationBAE JETSTREAM4100 - 4100 · Medellín, Colombia, ColombiaOn October 21, 2014, at about 2005 universal coordinated time, a BAE Jetstream 41, registration HK-4503, operated by EasyFly S.A., experienced a No. 1 (left) engine stoppage during cruise after departing from Enrique Olaya Herrera Airport (EOH)- Medellin,…NTSB ENG14IA029Incident · No injuriesIncident investigationFinal reportBombardier CRJ700 · Hodeida, YemenThe probable cause of the undercowl engine fire was the burn-through of the combustion chamber inner liner from the accumulation of dust that became molten during operating and infiltrated the combustion chamber thermal barrier coating causing it to spall off…NTSB CEN14WA534Incident · No injuriesForeign investigationAgustawestland AW139 · Umea, SwedenOn September 11, 2014, at 1230 coordinated universal time, an Agusta Westland AW139, SE-JRH, experienced a detachment of the slip ring assembly for anti-icing of the tail rotor, near Umea Airport (ESNU), Umea, Sweden. The helicopter landed at ESNU without…NTSB CEN14WA180Accident · No injuriesForeign investigationChristen Industries Pitts S-2B · Meaux-Esbly, FranceOn December 8, 2013, at 1607 coordinated universal time, a Pitts S-2B airplane, F-GEAL, experienced a loss of engine power and conducted a force landing near Meaux-Esbly, France. The pilot and passenger were not injured. The airplane was substantially…NTSB ENG14RA004Incident · No injuriesForeign investigationSaab Saab 2000 · Lugano, SwitzerlandOn November 28, 2013, about 630 UTC, a SAAB 2000 airplane, HB-IZW, experienced an engine failure during climb out after takeoff in Switzerland. The location was not reported. The 2 pilots, 1 crew member and 25 passengers were not injured. Damage to the…NTSB DCA14WA005Incident · No injuriesForeign investigationBoeing 757 223 · Providenciales, Turks & Caicos IslandsThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 757, which occurred on October 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB ENG14WA002Incident · No injuriesForeign investigationAirbus A330 - 302 · Caines, Australia, AustraliaOn October 4, 2013, a China Airlines Airbus A330-302, powered by General Electric CF6-80E1A4 turbofan engines experienced a No. 1 engine starter failure while at cruise after takeoff from Sydney Airport, Sydney Australia. The flight crew shutdown the engine…NTSB ENG13RA041Incident · No injuriesForeign investigationATR 72-500 · Makassar, Indonesia, IndonesiaNTSB ENG13WA039Incident · No injuriesForeign investigationBoeing 777 - 340ER · Moscow, RussiaThe Civil Aviation Authority Safety Investigation Board of Pakistan (CAAP) has notified the NTSB of an incident involving a Pakistan International Airlines Corporation (PIAC) Boeing 777-340ER, registration number AP-BHV, powered by General Electric CF90-115BL…NTSB ENG13IA033Incident · No injuriesIncident investigationFinal reportBoeing 777 · Ugolny Airport, RussiaThe failure of the transfer gearbox resulting from the fracture and separation of the radial gearshaft from fatigue cracking as a result of a combination of high residual tensile stresses produced by local decarburization during the manufacturing process…NTSB ANC13RA061Accident · No injuriesForeign investigationDe Havilland DHC-2 MK 1 · Half Moon Bay, CanadaOn June 24, 2013, at 1544 coordinated universal time, a DeHavilland DHC-2MK 1, Canadian registered C-FPCG, owned and operated by Seair Seaplanes, was substantially damaged near Half Moon Bay, Canada. Visual meteorological conditions prevailed at the time of…NTSB CEN13WA307Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Tallard, FranceNTSB ENG13WA038Incident · No injuriesForeign investigationAirbus A310 - 308 · Karachi, PakistanThe Civil Aviation Authority Safety Investigation Board of Pakistan (CAAP) has notified the NTSB of an incident involving a Pakistan International Airlines Corporation (PIAC) Airbus A-310-308, registration number AP-BEB, powered by General Electric CF6-80C2A8…NTSB ENG15WA014Incident · No injuriesForeign investigationBoeing 737 - 73V · Incheon, South KoreaOn October 5, 2012, an Easter Jet Boeing 737-700 powered by two CFM 56-7B20 turbofan engines experienced a No. 2 engine failure while climbing through 22,500 feet after takeoff from Gimpo International Airport, Seoul, South Korean. The flight crew shutdown…NTSB ENG12WA038Incident · No injuriesForeign investigationAirbus A321 · CAM RANH, Vietnam, VietnamOn May 27, 2012, a Vietnam Airlines Airbus A-321-231, registration number VN-A356, powered by two International Aero Engines (IAE) V2500 turbofan engines experienced a engine crew and alerting message (ECAM) warning for a No. 2 engine stall and fire during…NTSB WPR10WA110Accident · Serious injuriesForeign investigationGarlick TH1F · Canowindra, AustraliaOn December 23, 2009, at 1850 local time, a Garlick TH-1F helicopter (modified Bell 204), Australian registry VH-UHD, registered to and operated by Coloundra Helicopter Center Pty, Ltd., collided with trees and terrain while maneuvering during an aerial fire…NTSB DCA10RA031Accident · No injuriesForeign investigationBeech 1900 - D · Nairobi, KenyaOn November 9, 2009 about 0517 UTC, Kenyan registry 5Y-VVQ, a Beech 1900D, a chartered cargo flight, had a loss of control and collided with the ground during a visual approach for landing at Wilson Airport, Nairobi, Kenya. The airplane had turned back to…NTSB DCA09WA078Accident · No injuriesForeign investigationRobinson R44 · Annerdale, South AfricaOn September 25, 2009, about 2100 UTC, ZS-RMN, a Robinson R44, operated by National Airways Corporation, landed hard during an autorative landing near Annerdale, South Africa. The pilot and passenger were not injured. The helicopter was substantially damaged.…NTSB ANC08WA098Accident · Serious injuriesForeign investigationBeech 65-A90 · Pitt Meadows, Canada