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 DCA17WA166Incident · No injuriesForeign investigationBoeing 747-87UF · Narita, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 747-87UF airplane that occurred on July 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…NTSB CEN17WA276Accident · 2 fatalForeign investigationCessna T210 · Cerro Viejo, MexicoOn July 15, 2017, at 1616 coordinated universal time, a Cessna T210N, Mexican registration XB-LJK, collided with the terrain in Cerro Viejo, Mexico, following a loss of engine power. The pilot and passenger were fatally injured. The airplane was substantially…NTSB DCA17WA149Incident · No injuriesForeign investigationBoeing 737 · Helsinki, FinlandThe government of Finland has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Finland's investigation under the provisions of…NTSB ERA17WA228Accident · 1 fatalForeign investigationBell 206 · Republic of Buryatia, RussiaThe government of Russia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on July 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of…NTSB DCA17WA153Incident · No injuriesForeign investigationBoeing 737 · Ciudad Juárez, MexicoThe government of Mexico has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN17WA339Accident · No injuriesForeign investigationSchweizer Schweizer 269C · Bonvilliers, FranceOn July 5, 2017, a Schweizer 269C helicopter, French registration F-GHAF, experienced a dynamic rollover near Boinvilliers, France. During a simulated engine failure, the engine lost power. The instructor attempted to restart the engine unsuccessfully three…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 ERA17WA238Accident · 4 fatalForeign investigationCessna 210M · Cantá Municipality, State, BrazilOn July 3, 2017, about 1500 universal time coordinated, a Cessna 210M, Brazilian registration PR-MFR, was destroyed when it impacted terrain near Canta Municipality, State of Roraima, Brazil. The pilot and three passengers were fatally injured and one…NTSB DCA17WA170Incident · No injuriesForeign investigationAirbus A320 214 · Cali, ColombiaThe Grupo de Investigacion de Accidentes of Colombia has notified the NTSB of an incident involving a AIRBUS A320 214 airplane that occurred on July 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's…NTSB CEN17WA373Accident · No injuriesForeign investigationCessna Cessna U 206 G · Granville Mont-Saint Michel, FranceOn July 3, 2017, a Cessna 206 airplane, F-GAMJ, conducted a forced landing after experiencing an inflight fire in the cabin. The pilot was not injured and the airplane sustained substantial damage during the landing. The accident investigation is under the…NTSB DCA17WA154Accident · Serious injuriesForeign investigationBoeing 787-9 · Fukushima, JapanThe Japanese Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 787-9 airplane that occurred on July 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB's investigation under the provisions…NTSB CEN17WA296Accident · No injuriesForeign investigationCessna 182 · Aeródromo de la Isla de Utila, HondurasNTSB CEN17WA299Accident · No injuriesForeign investigationPiper PA23 · West Sussex, United KingdomOn June 30, 2017, at 1542 hours universal coordinated time, a Piper PA-23-250, United Kingdom registration G-BCCE, experienced a landing gear system failure while landing at the Shoreham Airport, West Sussex, United Kingdom. The two occupants on-board were…NTSB CEN17WA269Accident · 1 fatalForeign investigationCessna TU206 · Surutato, MexicoOn June 30, 2017, about 1907 hours universal coordinated time, a Cessna TU206G single-engine airplane, serial number U20606684, Mexican registration XB-NWL, collided with terrain near Surutato, Mexico. The pilot was fatally injured. The flight's origin and…NTSB CEN17WA262Incident · No injuriesForeign investigationEmbraer ERJ190 · Mérida, Yucatán, MexicoOn June 30, 2017, at 2133 universal coordinated time, an Embraer ERJ190 airplane, XA-GAH, experienced an engine problem and returned to the Manuel Crescencio Rejón International Airport (MMMD), Mérida, Yucatán. The aircrew performed a precautionary landing…NTSB ERA17WA255Accident · No injuriesForeign investigationCessna 210 · Germiston, South AfricaOn June 29, 2017, about 0602 coordinated universal time, Cessna 210A, South African registration ZS-SOK, was substantially damaged after the left main landing gear collapsed during landing at Rand Airport (FAGM), Germiston, South Africa. The pilot and a…NTSB DCA17WA192Incident · No injuriesForeign investigationBoeing 737 · Monterrey, MexicoThe government of Mexico has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB WPR17WA135Accident · 3 fatalForeign investigationSocata TB10 · Suttontown, AustraliaNTSB CEN17WA243Accident · 2 fatalForeign investigationPiper L4 · Liberecký, CzechiaOn June 25, 2017, at 1200 Coordinated Universal Time, a Piper L4, OM-M038, impacted terrain after takeoff from Hodkovice Airport (LKHD), Liberecký, Czech Republic. The airplane was destroyed. The pilot sustained serious injuries, and the passenger sustained…NTSB ERA17WA224Accident · 2 fatalForeign investigationMD Helicopter 500 · Schinias Marathonas, GreeceOn June 23, 2017, about 0645 universal coordinated time, a MD Helicopter 500E, Greek registration SX-HBB, was substantially damaged when it struck a power line and impacted terrain near Schinias Marathonas, Greece. The Greek certificated pilot and one…NTSB CEN17WA245Accident · No injuriesForeign investigationBell 204 · Alpbach, AustriaNTSB CEN17WA237Accident · 1 fatalForeign investigationAmateur Construction Kolb Firefly · Luffenhall, United KingdomOn June 20, 2017, about 0920 Coordinated Universal Time (UTC), a Kolb Firefly ultralite, British registration G-CEPN, impacted terrain under unknown circumstances near Newell Lane, Luffenhall, Hertfordshire, England. The pilot, the sole occupant on board, was…NTSB WPR17WA129Accident · 1 fatalForeign investigationAirparts NZ FU 24 Stallion · Bathurst, AustraliaNTSB WPR17WA127Accident · 1 fatalForeign investigationCessna 172 · Ballina, AustraliaNTSB WPR17WA130Incident · No injuriesForeign investigationTurbo Thrush S2R · Megiddo, IsraelOn June 14, 2017, about 1600 universal coordinated time (UTC), a Turbo Thrush AG S2R, 4X-AQS made an off-airport landing following an engine shutdown during flight at Megiddo Airport, Megiddo, Israel. The pilot was operating the airplane under the provisions…NTSB ERA17WA207Accident · No injuriesForeign investigationMD Helicopter 369 · Bultfontein, South AfricaOn June 14, 2017, about 1045 coordinated universal time, an MD Helicopter 369E, South African registration ZT-RAC, was substantially damaged during a forced landing near Bulfontein, South Africa. The pilot and two passengers were not injured. The personal…NTSB DCA17WA141Incident · No injuriesForeign investigationBoeing 737 · Jakarta, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions…NTSB ANC17WA031Accident · Serious injuriesForeign investigationBell 214 · Dongducheon, South KoreaOn June 13, 2017, about 1810 local time, a Republic of Korea registered Bell 214B helicopter, HL9157, operated by UB Air, impacted remote mountainous terrain about 3 miles northeast of Dongducheon, Republic of Korea, during the approach to a drop zone while…NTSB ANC17WA029Accident · 3 fatalForeign investigationBell 206 · Fengbin, TaiwanOn June 10, 2017, about 1255 Taipei local time (0455 UTC), a Taiwanese registered Bell 206B3 helicopter, B-31118, operated by Emerald Pacific Airlines, impacted remote mountainous terrain about 8 miles south of Fengbin, Hualien County, under unknown…NTSB CEN17WA349Accident · 1 fatalForeign investigationPiper PA31 · Caernarfon, Gwynedd, United KingdomOn June 9, 2017, at 1705 coordinated universal time, a Piper PA31, N250AC, impacted terrain during landing at Caernarfon Airport (EGCK), Caernarfon, Gwynedd, Wales. The airplane was destroyed by impact forces and fire. The pilot, who was the sole occupant,…NTSB ENG17IA026Incident · No injuriesIncident investigationFinal reportBoeing 747 451 · Tokyo, JapanThe PW4056 engine lost power due to the fatigue fracture of a 5th stage compressor blade. The cause of the fatigue fracture could not be determined.NTSB DCA17WA136Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…NTSB DCA17WA228Accident · No injuriesForeign investigationFokker F27 Mk 600 · Garbaharey, SomaliaThe Ministry of Transport for the Republic of Kenya has notified the NTSB of an accident involving a Fokker F27, which occurred on July 14, 2016. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13. All…NTSB DCA17WA138Incident · No injuriesForeign investigationBoeing 737 · Lima, PeruThe Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…NTSB ANC17WA027Accident · 4 fatalForeign investigationCessna 172 · Tateyama, JapanOn June 3, 2017, about 1450 Japan standard time (UTC +9), a Japanese registered Cessna 172P airplane, JA3989, operated by New Central Air Service, impacted snow-covered mountainous terrain near Tateyama, Toyama Prefecture, under unknown circumstances about 27…NTSB CEN17WA211Accident · 2 fatalForeign investigationLake LA-4-200 · Muskoka, Ontario, CanadaOn June 2, 2017, at 2113 coordinated universal time, a Lake LA-4-200 Buccaneer, C-GZSW, was destroyed on impact with terrain after takeoff from Muskoka Airport (CYQA), Muskoka, Ontario, Canada. After takeoff, the pilot attempted to return to the airport, and…NTSB CEN17WA214Accident · 1 fatalForeign investigationPiper PA-28-140 · Sacatepequez, GuatemalaOn June 1, 2017, at 1824 coordinated universal time, a Piper PA-24-140, Guatemalan registration TG-GYV, owned by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Volcán de Agua, Departamento de…NTSB CEN17WA278Incident · No injuriesForeign investigationAmateur Construction Titan T-51 Mustang · Gloucestershire, United KingdomOn May 31, 2017, about 1433 hours universal coordinated time, a Titan T-51 Mustang, United Kingdom registration G-DHYS, had a landing gear collapse during landing at the Gloucestershire Airport, near Gloucestershire, United Kingdom. The pilot was not injured.…NTSB WPR17WA115Accident · 3 fatalForeign investigationCessna 441 · Renmark, AustraliaOn May 30, 2017, about 1630 Australian central standard time, a Cessna 441, equipped with Garret TPE331 series turboprop engines, registration VH-XMJ, collided with terrain shortly after takeoff from Renmark Aerodrome, Renmark, SA, Australia. The three crew…NTSB CEN17WA240Incident · No injuriesForeign investigationReims F150 M · Charleroi, BelgiumOn May 30, 2017, about 1730 hours universal coordinated time, a Reims Aviation F150M, Belgium registration OO-PRG, sustained minor damage during a forced landing at Brussels South - Charleroi Airport (EBCI), Charleroi, Belgium. The flight instructor and…NTSB ERA17WA199Accident · 2 fatalForeign investigationPiper PA34 · Coxim Municipality, BrazilOn May 28, 2017, about 1540 coordinated universal time, a Piper PA-34-220T, Brazilian registration PT-WPD, was destroyed when it impacted terrain in Coxim Municipality, State of Mato Grosso so Sul, Brazil. The Brazilian pilot and passenger were fatally…NTSB CEN17WA203Accident · 1 fatalForeign investigationCessna 182 · Palmar Norte de Osa, Puntarenas, Costa RicaOn May 28, 2017, a Panamanian-flagged Cessna 182, serial number FT34567, and reported false registration HP-1760FT, was located crashed in an African palm seeding field on a farm near Palmar Norte of Osa, Puntarenas, Costa Rica. The pilot, the sole person on…NTSB ERA17WA193Accident · 1 fatalForeign investigationCessna 172 · Chernihiv, UkraineOn May 26, 2017, about 1200 coordinated universal time, a Cessna 172M, Ukrainian registration UR-WTA, was substantially damaged when it impacted a one-story building after takeoff from the Pivtsi Airport, Chernihiv, Ukraine. The pilot was fatally injured. The…NTSB WPR17WA132Accident · No injuriesForeign investigationSikorsky S76 · Nilanga, IndiaOn May 25, 2017, at 0625 Universal Coordinated Time, a Sikorsky S76, VT-CMM, was substantially damaged when it impacted the ground following a collision with powerlines near the Nilana Helipad, Nilanga, Maharashtra, India. The helicopter was operated under…NTSB DCA17WA132Incident · No injuriesForeign investigationBoeing 737 · Santa Cruz, BoliviaThe government of Bolivia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the provisions of…NTSB CEN17WA199Accident · 2 fatalForeign investigationPiper PA28R · Skipness/Kintyre, Scotland, United KingdomOn May 25, 2017, about 1300 hours universal coordinated time, a Piper PA-28R-201, United Kingdom registration G-CEOF, impacted the sea near Skipness/Kintyre, Scotland, United Kingdom. The two occupants on-board were fatally injured. The flight departed Oban…NTSB DCA17WA126Incident · No injuriesForeign investigationBoeing 777 · Multan, PakistanThe government of Pakistan has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on May 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the provisions of…NTSB ERA17WA192Accident · 1 fatalForeign investigationRobinson R22 · Kwa-Zulu Natal, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R22 helicopter that occurred on May 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB CEN17WA193Accident · 1 fatalForeign investigationQuicksilver GT500 · Barcelona, SpainOn May 20, 2017, at 1000 local time, a Quicksilver GT-500, EC-BQ3, impacted terrain after making a steep left turn during takeoff from Gurb Aerodrome in Barcelona, Spain. The aircraft was destroyed, and the pilot was fatally injured. The flight was being…NTSB ERA17WA191Accident · 2 fatalForeign investigationRobinson R44 · Heilbron, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R44 II helicopter that occurred on May 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…