NTSB investigations, Outside the U.S.
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 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 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 DCA16WA025Accident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an accident involving a Boeing 737 that occurred on November 26, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as the State of…NTSB DCA16WA024Accident · No injuriesForeign investigationBoeing 737 · Osh, KyrgyzstanThe government of Kyrgyzstan has notified the NTSB of an accident involving a Boeing 737-300 airplane that occurred on November 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Kyrgyzstan's investigation under the…NTSB ANC16WA008Accident · 2 fatalForeign investigationRobinson R22 · Annaka City, JapanOn November 22, 2015, at 0157 coordinated universal time, a Japanese registered Robinson R22 helicopter, JA7963, operated by a private individual, impacted the slope face of a speedway in Annaka City, Gunma Prefecture, Japan. The pilot and sole passenger…NTSB ANC16WA007Accident · 2 fatalForeign investigationBell 206 · New Taipei City, TaiwanOn November 22, 2015, about 0302 Coordinated Universal Time, a Bell 206 helicopter, Taiwan Island registration number B-31127, operated by Emerald Pacific Airlines, was destroyed following an impact with terrain about 7 nautical miles southwest of Taipei…NTSB WPR16WA034Accident · 7 fatalForeign investigationEurocopter AS350 · Fox Glacier, New ZealandThe Civil Aviation Authority of New Zealand has notified the NTSB of an accident involving a Eurocopter AS350BA helicopter, which occurred on November 21, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the New Zealand Transport Safety…NTSB CEN16WA049Accident · No injuriesForeign investigationPiper PA31 · Guatemala City, GuatemalaOn November 21, 2015, at 1800 universal coordinated time, a Piper PA-31, C6-TAK, was destroyed on impact with a house following a loss of control during takeoff from La Aurora International Airport, Guatemala City, Guatemala. The airplane was destroyed. The…NTSB CEN16WA048Accident · No injuriesForeign investigationBell 407 · Justo Romero, NicaraguaOn November 21, 2015, at 1000 central standard time (cst), a Bell model 407 helicopter, Honduran registration HR-AWI, serial number 53978, sustained substantial damage during a forced landing following a total loss of engine power near Justo Romero,…NTSB ERA16WA047Accident · 2 fatalForeign investigationCessna 402B · Choco, ColombiaOn November 17, 2015, about 1550 coordinated universal time, a Cessna 402B, Colombian registration HK4981G, was destroyed when it descended and impacted the ground in a residential area, during takeoff from Acandi Airport (SKAD), Choco, Colombia. The pilot…NTSB CEN16WA044Accident · 3 fatalForeign investigationBell 206 · San Carlos, NicaraguaOn November 17, 2015, about 1140 coordinated universal time, a Bell 206L4 helicopter, Nicaraguan registered YN-ISA, impacted the San Juan River near San Carlos, Rio San Juan, Nicaragua. The pilot and three passengers were fatally injured and the helicopter…NTSB CEN16WA075Accident · No injuriesForeign investigationLearjet 60 · Zihuatanejo, MexicoThe Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 60, XA-UQP, that occurred on November 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the…NTSB CEN16WA046Accident · Serious injuriesForeign investigationCessna 172N · Gorliz, SpainOn November 14, 2015, at 1157 UTC, a Cessna 172, Spanish registration EC-HKH, collided with the water in the Astondo Bay off the coast of Gorliz, Spain, following a loss of engine power. The pilot and one passenger received minor injuries and a second…NTSB CEN16WA045Accident · 4 fatalForeign investigationPiper PA 46 350P · Taunton, United KingdomNTSB ERA16WA048Accident · No injuriesForeign investigationRobinson R66 · Sirinhaem Municipality, BrazilOn November 11, 2015, about 1755 coordinated universal time, a Robinson R66, Brazilian registration PR-EDL, was substantially damaged during an emergency autorotation near Sirinhaem, State of Pernambuco, Brazil, when the main rotor blades contacted and…NTSB ERA16WA037Accident · 4 fatalForeign investigationCessna 650 · Guarda-Mor, BrazilOn November 10, 2015, at 2030 Universal Coordinated Time (UTC), a Cessna 650 Citation VII, Brazilian registration PT-WQH, operated by a private owner, was destroyed following an in-flight loss of control and collision with terrain near Guarda-mor…NTSB CEN16WA041Accident · 2 fatalForeign investigationCessna 182 · Parry Sound, CanadaOn November 10, 2015, at 0020 universal coordinated time, a Canadian registered Cessna 182H airplane, C-GKNZ, impacted terrain shortly after takeoff from the Parry Sound Area Municipal Airport (CNK4), Parry Sound, Ontario, Canada. The pilot and passenger were…NTSB ERA16WA038Accident · 1 fatalForeign investigationAir Tractor AT-502B · Balsas, BrazilOn November 11, 2015, about 1930 universal coordinated time, an Air Tractor AT502B, Brazilian registration PR-RSA, was destroyed when it impacted terrain shortly after takeoff from Balsas Airport, Balsas Brazil. The pilot was fatally injured. The flight was…NTSB WPR16WA026Accident · 1 fatalForeign investigationCessna 310 · Mildura, Australia, AustraliaOn November 6, 2015, at 1840 local time, a Cessna 310R, VH-BWZ, operating under the pertinent civil regulation of the Government of Australia, collided with terrain near Mildura, Australia, while on approach. The airplane was destroyed in the post-impact fire…NTSB DCA16WA020Accident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Civil Aviation Authority (CAA) of Pakistan has notified the NTSB of an accident involving a Boeing 737-400, registration AP-BJO, which occurred on November 3, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation…NTSB DCA16WA103Accident · No injuriesForeign investigationBoeing 737 · Dublin, IrelandThe Ireland Air Accident Investigation Unit (AAIU) has notified the NTSB of an accident involving a Boeing 737-800 that occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions…NTSB DCA16WA017Incident · No injuriesForeign investigationMcdonnell Douglas DC 9 82(MD-82) · San Luis Potosi, MexicoThe Dirección General de Aeronáutica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a McDonnell Douglas DC-9-82, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC…NTSB DCA16WA016Incident · No injuriesForeign investigationBoeing 737 · Nicosia, CyprusThe Accident Investigation Board of Turkey (AAIB) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…NTSB DCA16WA081Accident · No injuriesForeign investigationGulfstream G1159 · Kinshasa, Congo - KinshasaThe government of Democratic Republic of Congo (DRC) has notified the NTSB of an accident involving a Gulfstream G1159 airplane that occurred on November 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of DRC's…NTSB DCA16WA015Accident · 224 fatalForeign investigationAirbus A321 · Sinai Peninsula, EgyptThe Egyptian Ministry of Civil Aviation has notified the NTSB of an accident involving a AIRBUS A321 airplane, with IAE V2533 engines, that occurred on October 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Egyptian's…NTSB DCA16RA014Accident · 2 fatalForeign investigationBell Helicopter Textron 609 · Tronzano Vercellese, ItalyimportNTSB ANC16WA002Accident · 1 fatalForeign investigationBell 206B · Asquinth, CanadaOn October 27, 2015, about 2043 central daylight time, a Bell 206B helicopter, C-GIFY, impacted terrain near Asquinth, Saskatchewan, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of Canada is…NTSB DCA16WA012Accident · No injuriesForeign investigationBoeing 737 · Johannesburg, South AfricaThe government of South Africa has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on October 26, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…NTSB ERA16WA049Accident · 1 fatalForeign investigationRobinson R44 · Guarani Municipality, BrazilOn October 25, 2015, at 1730 local time (1930 coordinated universal time), a Robinson R44, Brazilian registration PP-BAO, was substantially damaged when it impacted trees and a lake after takeoff in the Guarani Municipality, State of Minas Gerais, Brazil. The…NTSB ENG16WA016Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe Comisión de Investigación de Accidentes de Aviación – CIAA of Peru has notified the NTSB of an incident involving a Peruvian Airlines Boeing 737, which occurred on October 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ERA16WA050Accident · 2 fatalForeign investigationCessna 150H · Rondonopolis Municipality, BrazilOn October 22, 2015, about 1130 coordinated universal time , a Cessna 150H, Brazilian registration PR-DMT, was destroyed when it impacted terrain while on approach to land at Rondonopolis Airport, Rondonopolis, Mato Grosso, Brazil. The two occupants were…NTSB CEN16WA020Accident · 4 fatalForeign investigationLearjet 31 · La Tinaja, MexicoThe Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 31A, XB-GYB, that occurred on October 22, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the…NTSB GAA16CA071Accident · No injuriesData collectionFinal reportBell 206 · Christmas Island, KiribatiThe pilot's inadequate preflight inspection and the maintenance crew's failure to remove the tie down.NTSB DCA16WA007Incident · No injuriesForeign investigationBoeing 737 · Paderborn, GermanyThe German Federal Bureau of Aircraft Accidents Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on October 20, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…NTSB ERA16WA020Accident · No injuriesForeign investigationLearjet 35A · Buenos Aires, ArgentinaNTSB ERA16RA021Accident · 10 fatalForeign investigationBeech 60 · Bogota, ColombiaOn October 18, 2015 at 2119 UTC, a Beechcraft B60, Colombian registration HK3917G, registered to and operated by Sky Hub Aviation, was destroyed during a collision with a building in Barrio El Lujan, Bogota, Colombia. The pilot, three passengers, and six…NTSB ANC16WA004Accident · 2 fatalForeign investigationCessna 207 · Taylor, CanadaOn October 16, 2015, about 2330 Coordinated Universal Time, a Cessna 207 airplane, C-GNVZ, impacted terrain near Taylor, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation Safety Board…NTSB ERA16WA013Accident · 3 fatalForeign investigationCessna 208B · Yumbillo, ColombiaOn October 14, 2016, about 1645 coordinated universal time, a Cessna 208B, Brazilian registration PR-MIC, operated by Microsurvey Aerogeofisica E Consultoria Cientifica of Brazil, was destroyed when it impacted mountainous terrain during a survey flight near…NTSB ERA16WA025Accident · 2 fatalForeign investigationPiper PA-28R-200 · Brazil, BrazilOn October 6, 2015, about 1433 UTC, A Piper PA-28R-200 (Embraer EMB711C); Brazilian registration PT-NKU, was destroyed when it impacted terrain while flying from Caratinga, Minas Gerais, Brazil to Serra do Caraca, Minas Gerais, Brazil. The two occupants were…NTSB ERA16WA017Accident · 1 fatalForeign investigationEmbraer EMB721C · Corumba, BrazilOn October 6, 2015, about 1200 universal coordinated time, an Embraer EMB721C, Brazilian registration PT-RAM, was substantially damaged when it encountered a wind gust and struck a tree, during takeoff from Guanabara Farm, Corumba, Brazil. The pilot and one…NTSB CEN16WA009Accident · 2 fatalForeign investigationBell 430 · Xalapa, MexicoOn October 6, 2015, at 2355 coordinated universal time (UTC), a Bell 430 helicopter, Mexican registration XC-VER, collided with terrain after departure from the El Lencero Airport, Xalapa, Mexico. A postimpact fire ensued. The pilot and co-pilot were fatally…NTSB ERA16WA002Accident · 2 fatalForeign investigationPiper PA-31-325 · Chia, ColombiaOn October 3, 2015, about 1715 UTC, a Piper PA-31-325, Colombian registration HK3909G, registered to and operated by El Caminante Air S.A., collided with a structure then rolled inverted during a forced landing in a field near Hipodromo de los Andes, Chia,…NTSB CEN16WA002Accident · 2 fatalForeign investigationBeech 200 · Chigwell, United KingdomThe Air Accidents Investigation Branch (AAIB) United Kingdom has notified the NTSB of an incident involving a Beech B200 that occurred on October 3, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under 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 CEN16WA010Accident · 1 fatalForeign investigationPiper PA31 · Veracruz, NicaraguaNTSB DCA16CA001Accident · Serious injuriesData collectionFinal reportAirbus A319 · Nassau, Bahamasan inadvertent encounter with convective turbulence.NTSB DCA15WA204Accident · No injuriesForeign investigationDe Havilland DHC8 · Saarbrucken, GermanyThe government of Germany has notified the NTSB of an accident involving a DE HAVILLAND DHC8 airplane that occurred on September 30, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…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 CEN15WA429Accident · 4 fatalForeign investigationPiper PA28 · Sandstedt, GermanyOn September 26, 2015, at 1138 universal coordinated time, a Piper PA-28, German registration D-EBVM and a Reims F172, German registration D-EGJA, collided over Sandstedt, Germany. The pilot on board the PA-28 was fatally injured. The pilot and two passengers…NTSB CEN15WA447Accident · No injuriesForeign investigationBell 407 · San Agustine Guatemala, GuatemalaThe Direccion General de Aeronutica Civil (DGAC) of Guatemala has notified the NTSB of a non-fatal accident involving a Bell 407GX Helicopter, registration TG-PDF, that occurred on September 24, 2015. The NTSB has appointed a U.S. Accredited Representative to…NTSB ERA15WA370Accident · 4 fatalForeign investigationBell 206 · Maceio, BrazilOn September 23, 2015, at 1350 universal coordinated time, a Bell 206L-3, Brazilian registration PP-ELA, was destroyed when it impacted terrain in Maceio, Brazil. The four occupants were fatally injured. The local police patrol flight originated at Zumbi dos…NTSB CEN15WA456Accident · 1 fatalForeign investigationAmateur Construction Glasair RG · Muhen, SwitzerlandOn September 20, 2015, about 1000 hours universal coordinated time, a Glassair RG airplane, Swiss registration HB-YEA was destroyed when it impacted an automobile and burst into flames during a forced landing following a loss of engine power near Muhen,…