NTSB investigations, Outside the U.S.
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 CEN18RA397Incident · No injuriesForeign investigationCirrus SF50 · Zurich, SwitzerlandOn September 22, 2018, about 1615 UTC, a Cirrus Design Corporation SF50 VisionJet, N474CG, owned by Southern Aircraft Consultancy Incorporated Trustee, and operated I-FLY AG, c/o Aximos Treuhand AG, experienced an electrical fire in the air conditioning unit…NTSB CEN18WA388Accident · 3 fatalForeign investigationCessna 210 · Pico de Orizaba, MexicoOn September 21, 2018, about 1440 hours universal coordinated time, a Cessna T210L single-engine airplane, serial number 21060532, Mexican registration XB-NVG, impacted terrain on mount Pico de Orizaba near Veracruz and Puebla, Mexico. The three occupants…NTSB DCA18WA304Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of India's investigation under the provisions of ICAO Annex…NTSB DCA18WA288Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyThe BFU of Germany has notified the NTSB of an accident involving a Boeing 747 airplane that occurred on September 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the BFU of Germany's investigation under the provisions of ICAO…NTSB ERA18WA252Accident · 1 fatalForeign investigationBeech C90 · Ipumirim County, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on September 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB WPR18WA277Incident · No injuriesForeign investigationGulfstream GIV · Abuja, NigeriaOn September 12, 2018, at 2110 coordinated universal time, a Gulfstream GIV airplane, registration 5N-BOD, was not damaged during a runway excursion at Nnamdi Akizkiwe International Airport (DNAA), Abuja, Nigeria. The flight crew and passenger were not…NTSB DCA18WA306Incident · No injuriesForeign investigationBoeing 737 · Belgrade, SerbiaThe CIAT of Serbia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CIAT of Serbia's investigation under the provisions of ICAO…NTSB ERA18WA248Accident · No injuriesForeign investigationBell 206 · Bartica, GuyanaThe government of Guyana has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions…NTSB DCA18WA302Incident · No injuriesForeign investigationBoeing 737 · Edinburgh, United KingdomThe Air Accidents Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB WPR18WA258Accident · 1 fatalForeign investigationYakovlev YAK-9UM · Victoria, AustraliaOn September 7, 2018, about 1933 coordinated universal time a Yakovlev Aircraft YAK-9UM airplane, VH-YIX, impacted terrain during a local flight that departed from the Latrobe Valley Airport, Victoria, Australia. The pilot in command was fatally injured, and…NTSB ERA18WA245Accident · 1 fatalForeign investigationBell 430 · Bostanci, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a Bell 430 that occurred on September 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of ICAO…NTSB ENG18RA040Accident · Serious injuriesForeign investigationMBB BK117 · Kyiv, UkraineOn September 6, 2018, a Eurocopter EC-145 experienced an anomaly during the takeoff near Trukhaniv Island, Kyiv, Ukraine. The incident is being investigated by the Ukrainian National Bureau of Air Accidents and Incidents (NBAAI) of Ukraine. All inquiries…NTSB CEN18WA376Accident · 4 fatalForeign investigationRobinson R44 · Domažlická 1059, Plzen - Skvrnany, CzechiaOn September 5, 2018, at 1533 Coordinated Universal Time, a Robinson R44, I-CCNI, impacted terrain while maneuvering at low altitude, Plzen-Skvmany, Czech Republic. The pilot and three passengers sustained fatal injuries.The investigation is under the…NTSB GAA18WA585Accident · No injuriesForeign investigationPiper PA28R · Cuatro Vientos, Spain, SpainThe government of Spain has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on September 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions…NTSB CEN18WA403Accident · No injuriesForeign investigationRobin DR400 · Benodet, FranceOn September 3, 2018, about 1005 UTC, a Robin DR400 airplane, French registration F-GSBK, sustained a loss of engine power while in cruise flight near Benodet, France. The three occupants onboard sustained no injury. The airplane was destroyed. The accident…NTSB WPR18WA254Accident · Serious injuriesForeign investigationCessna 182M · Leshiba Wilderness, South AfricaOn September 1, 2018, at 1247 universal coordinated time, a Cessna 182M, ZS-IAM, collided with trees while on final approach to land at Leshiba Wilderness, South Africa. The pilot and passenger were seriously injured. The airplane was substantially damaged.…NTSB ERA18WA247Accident · 1 fatalForeign investigationBeech 33 · Taquaraçu de Minas, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech 33 airplane that occurred on September 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB DCA18WA277Accident · Minor injuriesForeign investigationBoeing 737 · Sochi, RussiaThe Interstate Aviation Committee (MAK) of Russia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the MAK of Russia's investigation…NTSB CEN18WA404Accident · No injuriesClass 5 · ForeignCessna 680 · Burgas, BulgariaNTSB CEN18WA396Accident · No injuriesForeign investigationAero Designs Pulsar · Heapham, United KingdomOn August 31, 2018, about 1700 coordinated universal time (UTC), an amateur-built Aero Designs Pulsar 1 airplane, United Kingdom registration G-LUED, serial number PFA 202-12122, was substantially damaged when it nosed-over after it overran the runway while…NTSB DCA18WA287Incident · No injuriesForeign investigationBoeing 747 · Hong Kong, Hong Kong SAR ChinaThe AAIA of Hong Kong has notified the NTSB of an accident involving a Boeing 747 airplane that occurred on August 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIA's investigation under the provisions of ICAO Annex 13 as…NTSB CEN18WA379Accident · No injuriesForeign investigationPiper PA32 · Belize City, BelizeOn August 29, about 1804 local time (LCL), a Piper PA32 300 airplane, N3073W, operated by Wings of Hope, had a hard landing at the Sir Barry Bowen Municipal Airport, in Belize City, Belize. The airplane originated from the San Pedro Airport.This investigation…NTSB CEN18WA367Accident · 1 fatalForeign investigationCessna 310 · Villa Zaragoza, MexicoThe government of Mexico has notified the NTSB of an accident involving a Cessna 310, XB-KQF that occurred on August 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA18WA313Incident · No injuriesForeign investigationHarbin Y12 · Antioq, ColombiaThe Civil Aviation Authority (CAA) of Colombia has notified the NTSB of an incident involving a HAIC Harbin Y12E, which occurred on August 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions…NTSB CEN18WA366Accident · 1 fatalForeign investigationCirrus SR22 · Balchik, BulgariaOn August 24, 2018, at 1608 coordinated universal time, a Cirrus SR22, LZ-SEV, impacted terrain at the Balchik Airfield (LBWB), Balchik, Bulgaria. The airplane was destroyed. The pilot was fatally injured. The flight originated from Lesnovo Airport (LBLS),…NTSB CEN18WA353Accident · 1 fatalForeign investigationPiper PA34 · Loma Linda, Costa RicaNTSB DCA18WA279Incident · No injuriesForeign investigationBoeing 737 · Guadalajara, MexicoThe government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA18WA278Incident · No injuriesForeign investigationAirbus A321-271N · Tapachula, MexicoThe government of Mexico has notified the NTSB of an accident involving a AIRBUS A321-271N airplane that occurred on August 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB ERA18WA223Accident · 2 fatalForeign investigationStemme S12 · Santo Domingo Norte, Dominican RepublicThe government of Dominican Republic has notified the NTSB of an accident involving a STEMME S12 glider that occurred on August 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's investigation…NTSB DCA18WA314Accident · No injuriesForeign investigationDe Havilland DHC8 · Callao, PeruThe Peru Comisión de Investigación de Accidentes Aviación ((CIAA) has notified the NTSB of an accident involving a De Havilland DHC8 that occurred on August 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA'S investigation…NTSB DCA18WA280Incident · No injuriesForeign investigationBoeing 737 · Los Cabos, MexicoThe government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB WPR18WA230Accident · 1 fatalForeign investigationKawasaki Heavy Industries BK117 B-2 · Ulladulla, AustraliaOn August 17, 2018, about 1400 local time, a Kawasaki Heavy Industries Ltd. BK117 B-2 helicopter, VH-JWB, was destroyed when it impacted terrain during aerial firefighting operations near Ulladulla, New South Wales, Australia. The helicopter was operated by…NTSB ANC18WA077Accident · 3 fatalForeign investigationCessna U206 · Fort Simpson, CanadaOn August 17, 2018, about 0035 Coordinated Universal Time, an amphibious float-equipped Cessna U206G airplane, C-FNEQ, nosed over while landing at Little Doctor Lake near Fort Simpson, Northwest Territories, Canada. Of the five souls onboard, the pilot and…NTSB DCA18WA268Accident · No injuriesForeign investigationBoeing 737 · Manila, PhilippinesThe CAA of the Philippines has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CAA's investigation under the provisions of ICAO Annex 13…NTSB WPR18WA225Accident · 1 fatalForeign investigationRobinson R22 · Queenstown, South AfricaOn August 15, 2018, at 0830 Universal Coordinated Time, a Robinson R22 Beta helicopter, ZS-HBP, impacted power lines while conducting a game capturing flight near Queenstown, South Africa. The pilot sustained serious injuries and the passenger was fatally…NTSB DCA18WA271Incident · No injuriesForeign investigationBoeing 737 · Narrandera, AustraliaThe ATSB of Australia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO Annex 13 as…NTSB ANC18WA074Accident · 1 fatalForeign investigationCessna 172 · Edson, CanadaOn August 12, 2018, about 1645 Coordinated Universal Time, a Cessna 172 airplane, C-FJCP, impacted terrain near Edson, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries.The Transportation Safety Board (TSB) of Canada is…NTSB ANC18WA065Accident · 9 fatalForeign investigationBell 412EP · Nakanojo, JapanThe government of Japan has notified the NTSB of an accident involving a BELL 412EP helicopter that occurred on August 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of…NTSB DCA21WA225AccidentClass 5 · ForeignBoeing 787 · Istanbul, TürkiyeNTSB CEN18WA325Accident · 2 fatalForeign investigationBeech 58 · Munster, GermanyOn August 9, 2018, about 1000 UTC, a Beechcraft Baron 58 airplane, Hungarian registration PH-CJX, impacted terrain under unknown circumstances near Münster, Germany. The two occupants inside the airplane sustained fatal injuries. The airplane sustained…NTSB WPR18WA235Accident · 1 fatalForeign investigationAyres S2R · Diatar, MauritaniaOn August 8, 2018, at an unknown time, an Ayres S2R T34 airplane, F-GOKZ, impacted terrain during an agricultural operation near Diatar, Mauritania. The pilot was fatally injured. The airplane was being operated under the pertinent civil regulations of the…NTSB DCA18WA284Incident · No injuriesForeign investigationBoeing 777 · Lahore, PakistanThe Safety Investigation Board (SIB) Pakistan has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on August 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation…NTSB ERA18WA275Incident · No injuriesClass 4 · ForeignPiper PA42 · Contamana, PeruNTSB DCA24WA108IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoNTSB CEN18WA318Accident · 3 fatalForeign investigationCessna 172 · Puy-de-Dome Mazoires, FranceOn August 6, 2018, about 1045 coordinated universal time, a Cessna 172S airplane, French registration F-GTNV, lost radio and radar contact; the wreckage was located near Puy-de-Dôme Mazoires, France. The airplane was destroyed, and the three occupants…NTSB CEN18WA312Accident · 1 fatalForeign investigationSteen Skybolt · Fratauti, RomaniaNTSB CEN18WA394Accident · No injuriesForeign investigationPiper PA28 · Décines, FranceOn August 2, 2018, about 1930 UTC, a Piper PA-28-181 airplane, French registration F-GKEC, sustained a loss of engine power while on approach to the Lyon-Bron Airport (LFLY), near Décines, France. The two occupants onboard sustained no injury. The airplane…NTSB DCA18WA258Incident · No injuriesForeign investigationBoeing 737 · Pardubice, CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…NTSB CEN18WA372Accident · No injuriesForeign investigationRobinson R22 · Naunton Beauchamp, Worcestershire, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a ROBINSON R22 helicopter that occurred on August 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation…NTSB CEN18WA343Accident · 1 fatalForeign investigationPiper PA25 · Namiquipa, MexicoOn August 1, 2018, about 0956 hours mountain daylight time, a Piper PA-25-235 single-engine airplane, serial number 25-4177, Mexican registration XB-FMA, crashed in an agricultural field near Namiquipa, Mexico. The pilot was fatally injured. The local aerial…