NTSB investigations, 2009, Outside the U.S.

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

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 year(c.\"eventDate\") = 2009
    AND c.\"eventCountry\" <> 'USA'
  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.

NTSB WPR09RA402Incident · No injuriesForeign investigationBoeing 757 · Keflavík, IcelandOn June 15, 2009, a Boeing 757-200, TF-FIA, experienced heat and smoke emanating from the in-flight entertainment system audio jacks, located in two passenger armrests. The incident occurred prior to takeoff from Keflavík International Airport, Reykjanesbaer,…Jun 15, 2009 · TF FIA · Minor damageNTSB ERA09WA353Accident · 2 fatalForeign investigationCessna 150 · Urmantany, RussiaOn June 15, 2009, at approximately 0605 universal time coordinated, a Cessna 150L, Russian registration RA-0848G, impacted terrain during a force landing shortly after takeoff. The accident location was approximately 1 kilometer east of Urmantany, in the…Jun 15, 2009 · RA-0848G · Substantial damageNTSB 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,…Jun 14, 2009 · TC-TLA · No damageNTSB ENG09WA013Incident · No injuriesForeign investigationFlorence, ItalyOn June, 13, 2009, a Cimber Air Boeing 737-700 airplane, registered in Denmark as OY-MRG, had the left engine, a CFMI CFM56-7B22, flameout on approach to the Florence, Italy airport. The investigation of this incident is under the jurisdiction of the Agenzia…Jun 13, 2009 · OY-MRG · No damageNTSB ENG09WA021Incident · No injuriesForeign investigationBoeing 737 · Marrakesh Airport, MoroccoOn June 12, 2009, at 0502 UTC, a Boeing 737-400, Morrocan registration CN-RMX, operated by Atlas Blue, fractured a right main landing gear upon landing on runway 28 at Marrakesh Airport. The number 3 main wheel separated. The airplane was on a scheduled…Jun 12, 2009 · CN-RMX · No damageNTSB ERA09WA335Accident · 1 fatalForeign investigationPiper Aerostar 6 · Minga Guazu, ParaguayOn June 9, 2009, at 1903 local time, a Piper PA-60, N601RP, was destroyed during collision with terrain and a post crash fire on approach to Guarani International Airport (SGES), Minga Guazu, Paraguay. The pilot was fatally injured. Instrument meteorological…Jun 9, 2009 · N601RP · Substantial damageNTSB DCA09WA059Accident · No injuriesForeign investigationMcdonnell Douglas MD11 · Khartoum, SudanOn June 9, 2009, about 0235 UTC, a McDonnell Douglas MD-11, HZ-ANB, a cargo flight operated by Saudi Arabian Airlines, landed hard on runway 18 at Khartoum International Airport. The 4 crewmembers were not injured and the airplane was substantially damaged.…Jun 9, 2009 · HZ-ANB · Substantial damageNTSB DCA09WA058Incident · No injuriesForeign investigationBoeing 767 · Taipei, Taiwan, TaiwanOn June 6, 2009, Japan Airlines flight 653, a Boeing 767-300, registration JA-613J, experienced a cabin fire during approach to Taoyuan International Airport (TPE/RCTP), Taipei, Taiwan. The remains of a charred lighter were found in the nook between a seat…Jun 5, 2009 · JA-613J · Minor damageNTSB DCA09RA052Accident · 228 fatalForeign investigationAirbus A330 · Atlantic, France.Jun 1, 2009 · F-GZCP · DestroyedNTSB CEN09WA333Accident · 1 fatalForeign investigationCessna 172H · Uddevalla, SwedenUnder the jurisdiction and control of the Swedish government.Jun 1, 2009 · SE-GUP · DestroyedNTSB CEN09WA617Accident · 2 fatalForeign investigationAtec 321 Faeta · Strovíkion, GreeceMay 31, 2009 · OK-JUG19 · Substantial damageNTSB DCA09WA073Incident · No injuriesForeign investigationBoeing MD82 · Cagliari Airport, ItalyOn May 28, 2009, at 5:49 UTC, a Meridiana Boeing MD82, registration number I-SMEB, was not able to pressurize the cabin after take-off from Cagliari Airport, Italy. The automatic standby pressurization system was not operative before the flight and after…May 28, 2009 · I-SMEB · No damageNTSB CEN09WA390Accident · 1 fatalForeign investigationEnstrom Helicopter 480B · Dominican Republic, Dominican RepublicMay 28, 2009 · N878EE · Substantial damageNTSB ERA09WA305Accident · 14 fatalForeign investigationRaytheon B-350 · Porto Segura, BrazilOn May 23, 2009, at 0030 universal time coordinated, a Raytheon B-350, Brazil registration PR-MOZ, operated by Metered Holdings LTDA, impacted the ground 200 meters from the threshold to runway 15 at the Terra Vista/Porto Seguro (SBTV), Porto Segura, Brazil.…May 23, 2009 · PR-MOZ · Substantial damageNTSB ERA09WA354Accident · 2 fatalForeign investigationRobinson R-44 · Vitoria da Conquista, BrazilOn May 22, 2009, at 2139 Coordinated Universal Time (UTC), a Brazilian registered Robinson R-44, PR-NDF, was destroyed when it impacted the ground during approach to land at the Vitoria da Conquista Airport (SBQV), Vitoria da Conquista, Brazil. The pilot and…May 22, 2009 · PR-NDF · DestroyedNTSB DCA09IA055Incident · No injuriesIncident investigationFinal reportAirbus A330 · Los Cayes, HaitiThe final report for this incident was combined with and can be found under NTSB Investigation number, DCA09IA064.May 22, 2009 · PT-MVB · No damageNTSB ERA09LA418Accident · Serious injuriesLimited investigationFinal reportBoeing 757 · Cuba, CubaAn unanticipated inflight encounter with turbulence.May 16, 2009 · N657DL · No damageNTSB CEN09WA306Accident · 6 fatalForeign investigationPiper PA-23-250 · Guatemala City, GuatemalaThe accident investigation is under the jurisdiction and control of the Government of the Republic of Guatemala. Further information may be obtained from: Republica de Guatemala Direccion General de Aviacion Civil (DGAC) Aeropuerto Internacional "La Aurora"…May 14, 2009 · TG-ALD · Substantial damageNTSB ERA09WA288Accident · 5 fatalForeign investigationCessna 172 RG · Santa Cruz, BoliviaOn May 11, 2008, about 1930 Atlantic standard time, a Cessna 172 RG, Bolivian registration CP-2492, , registered to and operated by a private individual, impacted a tree with its left’s wing and then the ground, where a fire ensued. The accident sight was…May 11, 2009 · CP-2492 · DestroyedNTSB ENG09WA005Incident · No injuriesForeign investigationBoeing 747-436 · Johannesburg, South AfricaOn May 11, 2009 at 18:37 UTC, a British Airways Boeing 747, powered by Rolls-Royce RB211-524H2-T engines, experienced a No. 3 thrust reverser unlock light illumination during the takeoff roll from the Tambo International Airport (FAJS - formerly known as…May 11, 2009 · G-BYGA · No damageNTSB ERA09WA291Accident · 2 fatalForeign investigationPiper PA-30 · Port Sudan, SudanOn May 10, 2009, at 0530 universal coordinated time (0830 local time), a Piper PA-30, N502TC, was destroyed when it impacted mountainous terrain about 26 nautical miles northwest of Port Sudan, Sudan. The two Yemani pilots onboard were fatally injured. The…May 10, 2009 · N502TC · DestroyedNTSB ERA09WA286Accident · 9 fatalClass 5 · ForeignBell 407 · Malyshkino, RussiaOn May 10, 2009, approximately 1001 universal time coordinated, a Bell 407 helicopter, Russian registration RA-01895AO, impacted terrain in the Irkutsk region approximately 3 kilometers from Malyshkino, Cheremshanka. The helicopter was substantially damaged.…May 10, 2009 · RA-01895AO · Substantial damageNTSB DCA09WA050Accident · No injuriesForeign investigationFrankfurt, GermanyOn May 8, 2009, at 1959 UTC a Boeing 747-400, Korean registration HL7419, operated by Asiana Airlines lost an inboard trailing edge flap during approach to Frankfurt/Main Airport, Germany. There were no injuries on the scheduled flight from Seoul, South…May 8, 2009 · HL7419 · Substantial damageNTSB DCA09WA049Accident · No injuriesForeign investigationMcdonnell Douglas MD90 · Riyadh, Saudi ArabiaOn May 8, 2009, at 1558 local time, a Boeing McDonnell Douglas MD90, Saudi Arabian registration HZ-APW; S/N 53513, operated by Saudi Arabian Airlines was damaged when exiting a high-speed taxiway after landing on runway 15R at Riyadh Airport. The laft main…May 8, 2009 · HZ-APW · Substantial damageNTSB CEN09WA286Accident · 3 fatalForeign investigationCessna 340 · Veracruz, MexicoOn May 5, 2009 at about 0900 central daylight time a Cessna 340, Mexican Registration XB-CUC crashed while returning to land after takeoff at General Heriberto Jara Corona International Airport, Veracruz, Veracruz, Mexico. The pilot requested to return to the…May 7, 2009 · XB-CUC · DestroyedNTSB DCA10WA008Incident · No injuriesForeign investigationBoeing 737 · Antalya, TürkiyeOn May 2, 2009, a Boeing 737, registration FG-FUF, operated by Europe Airpost, encountered turbulence and possibly entered an unusual attitude north of Antalya, Turkey. The BEA France is conducting an investigation.May 2, 2009 · F-GFUF · Minor damageNTSB ENG09WA006Incident · No injuriesForeign investigationBoeing 757-236 · Guayaquil, EcuadorOn May 1, 2009, 1315 local time, a AEROGAL Boeing 757, powered by Rolls-Royce RB211-535E4 engines experienced a compressor stall after takeoff from the Simon Bolivar International, Guayaquil Ecuador. While climbing through 700 feet, the pilot heard a noise…May 1, 2009 · HC-CHC · No damageNTSB DCA09WA060Accident · 7 fatalForeign investigationBoeing 737 · Kwilu, Bandundu, Congo - KinshasaOn April 29, 2009, about 0800 UTC, TL-ADM, a Boeing 737-200, operated by Bako Air of the Central African Republic, a ferry flight, crashed at the locality of Massamba, District of Kwilu, province of Bandundu, Democratic Republic of Congo. All seven occupants…Apr 29, 2009 · TL-ADM · DestroyedNTSB ERA09WA279Accident · 2 fatalForeign investigationCirrus Design SR22 · Mt. Ainos, GreeceNone.Apr 28, 2009 · 4X-CWN · DestroyedNTSB DCA09WA046Accident · Minor injuriesForeign investigationBoeing 737 · Guadalajara, MexicoOn April 27, 2009, at approximately 1638 local time, a Boeing 737-2K9, serial number 22505/815, Mexican registration XA-MAF, operated by Magnicharters as flight 585 landed with main gear retracted on runway 28 at the Guadalajara-Don Miguel Hidalgo y Costilla…Apr 27, 2009 · XA-MAF · Substantial damageNTSB DCA10WA044Accident · No injuriesForeign investigationGoma, Congo - KinshasaOn November 19, 2010, about 0900 UTC, 9Q-CAB, an MD-80 operated by Compagnie Africaine d'Aviation, a domestic scheduled passenger flight, overran runway 36 during landing and struck obstacles at Goma International Airport, Democratic Republic of Congo (DRC).…Apr 19, 2009 · Substantial damageNTSB ERA09WA253Accident · 1 fatalForeign investigationCessna 208 · Canaima, VenezuelaNone.Apr 17, 2009 · YV1181 · Substantial damageNTSB DCA09WA075Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Batco, ChileOn April 16, 2009, an Arrow Cargo, MD-11F, registration N384WA, experienced a left nosewheel separation during its approach to Arturo Merino Benitez Airport (SCEL), Santiago, Chile. There were no injuries to the 5 crew members onboard, and the airplane was…Apr 17, 2009 · N384WA · No damageNTSB ERA09WA241Accident · 4 fatalForeign investigationCessna 210 · Concepcion, BoliviaOn April 11, 2009, at 2305 universal coordinated time (1905 local time), a Cessna 210M, Bolivian registration CP-1373, was destroyed when it impacted terrain shortly after taking off from Concepcion Airport (SLCP), Concepcion, Bolivia. The certificated…Apr 13, 2009 · CP-1373 · DestroyedNTSB WPR09WA292Accident · No injuriesForeign investigationCessna 208 · Vientiane, Laos, LaosOn April 11, 2009, about 1035 coordinated universal time (UTC), a Cessna 208B, Laos registration RDPL-34144, owned by Helicopters of New Zealand, operated by Lao Air, was substantially damaged during a forced landing following a loss of engine power near…Apr 11, 2009 · RDPL-34144 · Substantial damageNTSB CEN09WA248Accident · 2 fatalForeign investigationPiper PA-28-181 · Steep, United KingdomApr 10, 2009 · N2405Y · DestroyedNTSB DCA09WA061Accident · 4 fatalForeign investigationCirrus SR-22 · Tizintichka, MoroccoOn April 9, 2009, about 1030 UTC, a Cirrus SR-22, a personal flight, collided with high terrain at an elevation of about 6700 feet, at Tizintichka, Morocco. Visual meteorological conditions prevailed and the airplane was on a VFR flight plan. The pilot and 3…Apr 9, 2009 · N45GH · DestroyedNTSB DCA09WA043Accident · 6 fatalForeign investigationBAE Avro 146RJ · Wamena, Indonesia.Apr 9, 2009 · PK-BRD · DestroyedNTSB CEN09WA370Accident · 3 fatalForeign investigationEurocopter AS350B2 · Cubiri, MexicoOn April 8, 2009 at approximately 0800 pacific daylight time a Eurocopter single engine helicopter crashed in mountainous terrain after departing from the Culiacan International Airport, Sinaloa, Mexico. The mission was to take aerial photographs. Several…Apr 8, 2009 · XC-MIN · DestroyedNTSB ERA09WA237Accident · 1 fatalForeign investigationPiper PA-34 · Valdivia, ChileNone.Apr 6, 2009 · CC-CJK · Substantial damageNTSB CEN09WA240Accident · 2 fatalForeign investigationSchweizer 269C · Kilshanchoe, IrelandThis is under the jurisdiction and control of the Irish government.Apr 1, 2009 · EI-CZL · DestroyedNTSB ERA09WA226Accident · No injuriesForeign investigationCirrus Design SR22 · Lugo, ItalyMar 27, 2009 · N221LD · Substantial damageNTSB ENG09IA004Incident · No injuriesIncident investigationFinal reportMcdonnell-Douglas DC-10-30 · Bogota, ColombiaFailure of the low pressure turbine stage 3 disk due to a design that is vulnerable to high pressure turbine unbalance-induced synchronous vibration that cannot be detected in flight, and the subsequent uncontained engine failure.Mar 26, 2009 · N526MD · Minor damageNTSB DCA09WA042Incident · No injuriesForeign investigationBoeing B727 · Eldorado, ColombiaOn March 26, 2009, at approximately 0355 local time, a Boeing 727, registration HK4407, operated by Cosmos Air Transport of Colombia, struck trees on approach to runway 13 to Eldorado airport, Bogota (SKBO). The crew conducted a missed approach and landed…Mar 26, 2009 · HK4407 · Minor damageNTSB DCA09WA067Accident · 6 fatalForeign investigationBell 206 · Kahramanmaras City, TürkiyeOn March 25, 2009, an Bell 206, registration TC-HEK, crashed in mountainous terrain near Kahramanmaras City, Turkey. The pilot and five passengers onboard were fatally injured and aircraft was destroyed. The investigation is being conducted by the Turkish…Mar 25, 2009 · TC-HEK · DestroyedNTSB DCA09WA044Incident · No injuriesForeign investigationMcdonnell Douglas MD88 · Trelew, Argentina.Mar 25, 2009 · LV-VBZ · No damageNTSB DCA09RA041Accident · 2 fatalClass 5 · ForeignMcdonnell Douglas MD11 · Narita, JapanOn March 23, 2009, at 0649 local time, a FedEx Boeing (McDonnell Douglas) MD-11 crashed upon landing at Narita International Airport (NRT), Narita, Japan. The flight originated at Guangzho Baiyun International Airport (CAN), Guangzho, China. Both pilots were…Mar 23, 2009 · N526FE · DestroyedNTSB ERA09WA218Accident · 7 fatalForeign investigationBeech BE-200 · Quito, EcuadorNone.Mar 19, 2009 · AEE-101 · DestroyedNTSB CEN09RA205Accident · 17 fatalForeign investigationSikorsky S-92A · St. John's, Newfoundland, CanadaNot required for RA.Mar 12, 2009 · G-GZCH · DestroyedNTSB DCA09WA038Accident · No injuriesForeign investigationMcdonnell Douglas MD-90 · Jakarta, Indonesia.Mar 9, 2009 · PK-LIL · Substantial damage