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.
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
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 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,…NTSB 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…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 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…NTSB 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…NTSB 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…NTSB 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.…NTSB 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…NTSB DCA09RA052Accident · 228 fatalForeign investigationAirbus A330 · Atlantic, France.NTSB CEN09WA333Accident · 1 fatalForeign investigationCessna 172H · Uddevalla, SwedenUnder the jurisdiction and control of the Swedish government.NTSB CEN09WA617Accident · 2 fatalForeign investigationAtec 321 Faeta · Strovíkion, GreeceNTSB 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…NTSB CEN09WA390Accident · 1 fatalForeign investigationEnstrom Helicopter 480B · Dominican Republic, Dominican RepublicNTSB 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.…NTSB 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…NTSB 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.NTSB ERA09LA418Accident · Serious injuriesLimited investigationFinal reportBoeing 757 · Cuba, CubaAn unanticipated inflight encounter with turbulence.NTSB 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"…NTSB 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…NTSB 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…NTSB 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…NTSB 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.…NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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…NTSB 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…NTSB ERA09WA279Accident · 2 fatalForeign investigationCirrus Design SR22 · Mt. Ainos, GreeceNone.NTSB 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…NTSB 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).…NTSB ERA09WA253Accident · 1 fatalForeign investigationCessna 208 · Canaima, VenezuelaNone.NTSB 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…NTSB 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…NTSB 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…NTSB CEN09WA248Accident · 2 fatalForeign investigationPiper PA-28-181 · Steep, United KingdomNTSB 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…NTSB DCA09WA043Accident · 6 fatalForeign investigationBAE Avro 146RJ · Wamena, Indonesia.NTSB 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…NTSB ERA09WA237Accident · 1 fatalForeign investigationPiper PA-34 · Valdivia, ChileNone.NTSB CEN09WA240Accident · 2 fatalForeign investigationSchweizer 269C · Kilshanchoe, IrelandThis is under the jurisdiction and control of the Irish government.NTSB ERA09WA226Accident · No injuriesForeign investigationCirrus Design SR22 · Lugo, ItalyNTSB 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.NTSB 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…NTSB 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…NTSB DCA09WA044Incident · No injuriesForeign investigationMcdonnell Douglas MD88 · Trelew, Argentina.NTSB 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…NTSB ERA09WA218Accident · 7 fatalForeign investigationBeech BE-200 · Quito, EcuadorNone.NTSB CEN09RA205Accident · 17 fatalForeign investigationSikorsky S-92A · St. John's, Newfoundland, CanadaNot required for RA.NTSB DCA09WA038Accident · No injuriesForeign investigationMcdonnell Douglas MD-90 · Jakarta, Indonesia.