NTSB investigations, Outside the U.S.
82 cases where the sequence of events included Flight control sys 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\" = '333' 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" = '333' 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 ENG20WA034Incident · No injuriesForeign investigationBombardier CL600 2C10 · Lyon Saint Exupéry Airport, FranceThe BEA of France has notified the NTSB of an incident involving a Bombardier CL600-2C10 airplane that occurred on January 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the BEA of France's investigation under the provisions of…NTSB CEN20WA056Incident · No injuriesForeign investigationLearjet 45 · Geneva, SwitzerlandThe government of Switzerland has notified the NTSB of an incident involving a LEARJET 45 airplane that occurred on December 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…NTSB DCA19WA212Incident · No injuriesForeign investigationBoeing 737 · South AfricaThe government of South Africa has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB DCA19WA023Incident · No injuriesForeign investigationEmbraer 190 · Bara, PortugalThe GPIA of Portugal has notified the NTSB of an incident involving a Embraer 190 airplane that occurred on November 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GPIA of Portugal's investigation under the provisions of ICAO…NTSB CEN19WA042Accident · No injuriesForeign investigationPiper PA34 · Uk, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a PIPER PA34 airplane that occurred on November 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…NTSB CEN18WA399Accident · Minor injuriesForeign investigationCessna 172 · Hamilton, BermudaOn April 30, 2018, about 2045 universal coordinated time (UTC), a Cessna 172 M airplane, N9085H, was substantially damaged during a landing at the L. F. Wade International Airport, near Hamilton, Bermuda. The pilot sustained minor injuries.The accident…NTSB DCA18WA315Accident · No injuriesForeign investigationAirbus A320 · Tallinn, EstoniaThe Estonian Safety Investigation Bureau (AIB) has notified the NTSB of an accident involving a Airbus 320, which occurred on February 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…NTSB ANC18LA020Accident · No injuriesLimited investigationFinal reportEurocopter France SA330J Puma · Pacific Ocean, JapanThe worn rear bearing of the freewheel unit. Contributing to the accident was the delay in analyzing an oil sample, which would have detected the increase in metal contaminants from the worn bearing.NTSB DCA17WA199Incident · No injuriesForeign investigationBoeing 737 · Caracas, VenezuelaThe DGAC of Venezuela has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB ERA17WA230Accident · 9 fatalForeign investigationGulfstream G1159A · Nueva Esparta, VenezuelaOn July 4, 2017, about 1745 coordinated universal time (UTC), a Gulfstream 1159A, Venezuela registration YV2895, descended into the Caribbean Sea northwest of Nueva Esparta, Venezuela, and was presumed to be destroyed. Visual meteorological conditions…NTSB ENG17RA040Incident · No injuriesForeign investigationATR ATR72 · Guarulhos, BrazilThe Centro de Investigação e Prevenção de Acidentes Aeronáuticos (CENIPA) of Brazil has notified the NTSB of an incident involving an Aerospatiale and Alenia ATR-72-212A, which occurred on March 21, 2017. The NTSB has appointed a U.S. Accredited…NTSB DCA17WA056Incident · No injuriesForeign investigationBoeing 737 · Paris, FranceThe Bureau d'Enquêtes et d'Analyses (BEA) of France has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on December 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's…NTSB WPR17WA039Accident · 1 fatalForeign investigationRobinson R44 · Juhu, IndiaNTSB DCA16WA229Incident · No injuriesForeign investigationPulse Vapor 55 · Ballina, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Pulse Vapor 55 unmanned helicopter that occurred on September 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation…NTSB DCA16WA104Incident · No injuriesForeign investigationBoeing 747 · Jeddah, Saudi ArabiaThe government of Saudi Arabia has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on March 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi Arabia's investigation under the…NTSB CEN16WA110Accident · No injuriesForeign investigationPiper PA23 · Saint François, GuadeloupeOn February 22, 2016, a Piper PA-23-250 airplane, N539EG, sank after ditching near the Saint François Airport (TFFC), Saint François, Guadeloupe (France). The pilot was not injured.This investigation is under the jurisdiction and control of the French…NTSB ANC16WA070Accident · No injuriesForeign investigationPiper PA-28-140 · St Andrews, CanadaOn February 13, 2016, about 2039 Coordinated Universal Time (UTC), a Piper PA-28-140 airplane, (Canadian Registration C-GQPN) was on approach to St. Andrews, MB (CYAV) with an instructor and a student on board. Prior to touch down at approximately 50 feet…NTSB CEN15WA449Accident · 1 fatalForeign investigationTrendak Tercel · Odorheiul Secuiesc City, RomaniaThis is preliminary information, subject to change, and may contain errors. On September 26, 2015, at an unknown time, a Trendak Tercel gyroplane, A11-DUN, impacted terrain after takeoff from an airfield near Odorheiul Secuiesc city, Harghita County, Romania.…NTSB ENG15WA021Incident · No injuriesForeign investigationBoeing 737 - 683 · Oslo, NorwayOn March 25, 2015, at approximately 0730 Coordinated Universal Time (UTC), a Boeing 737-683, Norwegian registration LN-RPA, operated by Scandinavian Airlines System (SAS), experienced a pitch control problem while landing on Runway 01R at Oslo Airport,…NTSB CEN15WA115Accident · No injuriesForeign investigationRans S7 · Cambaie, Reunion Island, FranceNTSB ENG13WA044Incident · No injuriesForeign investigationBombardier CL600 2B19 · Moscow, RussiaOn September 7, 2013 a MNG Jet charter flight, a Bombardier Canadair CL-600-2B19-7763, registration TC-EJA, landed at Vnukovo International Airport, Moscow, Russian Federation, with the nose landing gear extended and both main gear retracted. The…NTSB DCA13WA157Incident · No injuriesForeign investigationBoeing 777 · Melbourne, AustraliaThe Australian Transportation Safety Board (ATSB) has notified the NTSB of an incident involving a Boeing 777 that occurred on August 15, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…NTSB DCA13MA081Accident · 7 fatalClass 1 · MajorFinal reportBoeing 747-400 BCF · Bagram, AfghanistanNational Airlines' inadequate procedures for restraining special cargo loads, which resulted in the loadmaster's improper restraint of the cargo, which moved aft and damaged hydraulic systems Nos. 1 and 2 and horizontal stabilizer drive mechanism components,…NTSB ENG13WA001Incident · No injuriesForeign investigationBeech 1900 · Lyon, FranceOn October 09, 2012, at 9:40 am local time, a Beechcraft 1900, F-GOPE, operated by Hex'Air, experienced a elevator trim system failure after take-off at Lyon-Saint Exupery airport(LFLL), France. A post flight inspection revealed that the elevator trim forward…NTSB WPR12WA167Incident · No injuriesForeign investigationSaab 2000 · Copenhagen, DenmarkOn March 20, 2012, about 0610 UTC, a Saab 2000, registered in Sweden as SE-LOM, experienced an elevator flight control malfunction during landing at Copenhagen Airport (EKCH), Denmark. None of the three flight crew or 47 passengers were injured. The airplane…NTSB DCA12FA024Accident · 3 fatalField investigationFinal reportBell 214 · Camp Bastion, Afghanistanthe overtravel of the collective sleeve, which led to a severe and sudden reduction in main rotor blade collective pitch, resulting in a loss of control of the helicopter. The reason for the collective sleeve overtravel could not be determined since much of…NTSB DCA13WA052Incident · No injuriesForeign investigationBeech 1900 · Goose Bay, CanadaOn 10 December 2011, at 1028 Newfoundland Standard Time, an Exploits Valley Air Services Hawker Beechcraft 1900D aircraft (registration C-GLHO, serial number UE-266), operating as Air Canada Express flight EV7645, was conducting a scheduled passenger flight…NTSB DCA12WA007Accident · No injuriesForeign investigationBoeing 737 - 800 · Faro, PortugalTheAir AccidentInvestigation Unit (AAIU) ofIrelandhas notified the NTSB of an accidentinvolving a B737-8AS that occurred on October 20, 2011. The NTSBhas appointed a U.S. Accredited Representative to assist the AAIU investigationunder the provisions of ICAO…NTSB CEN11WA070Accident · 8 fatalForeign investigationBell 212 · Minatitlan Veracruz, MexicoThe government of Mexico has notified the NTSB of an accident involving a BELL 212 helicopter that occurred on October 15, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN10RA345Accident · No injuriesForeign investigationBell 412 · Campeche, MexicoOn June 1, 2010, approximately 1123 central daylight time, a Bell Helicopter model 412EP, Mexican registration XA-HSI, made a successful water landing after a loss of tail rotor control in the Gulf of Mexico near Campeche, Mexico. The helicopter was en route…NTSB ENG09IA011Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Diyarbakir, TürkiyeAn uncommanded elevator surface deflection as a result of a left elevator PCU input arm assembly jam due to FOD lodged between the input arm assembly and the PCU housing. The FOD was a roller element from an elevator upper torque tube output crank bearing,…NTSB ENG08WA029IncidentForeign investigationBoeing 737-2A5 · Pucallpa, PeruOn June 6, 2008, at approximately 1810 local time, OB-1799-P, a Boeing 737-2A5, operated by Aero Condor S.A.C., returned to the FAP Captain David Abenzur Rengifo International Airport, (SPCL), Pucallpa Peru, after experiencing a very strong vibration after…