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 DCA17WA190Incident · No injuriesForeign investigationEmbraer EMB145 · Medellin, ColombiaThe government of Colombia has notified the NTSB of an incident involving a EMBRAER EMB145 airplane that occurred on August 31, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB CEN17WA384Accident · No injuriesForeign investigationDiamond DA20 · Sankt Veit, AustriaThe government of Austria has notified the NTSB of an accident involving a DIAMOND DA20 airplane that occurred on August 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Austria's investigation under the provisions…NTSB ENG17WA035Accident · Minor injuriesForeign investigationSikorsky 300 · Herzelia, IsraelThe Ministry of Transport of the State of Israel, has notified the NTSB of an accident involving a Sikorsky S-300C, registration 4X-BIM, that occurred on August 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the investigation…NTSB ERA17WA351Incident · No injuriesForeign investigationCessna 207 · Recanati, ItalyThe government of Italy has notified the NTSB of an accident involving a CESSNA 207 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB ERA17WA296Accident · 1 fatalForeign investigationCessna T210 · Ciudad Bolivar, VenezuelaOn August 27, 2017 about 2052 coordinated universal time (UTC), a Cessna T210M, Venezuelan registration YV2594, was substantially damaged during a forced landing, after a loss of engine power near Ciudad Bolivar, Venezuela. The pilot and three passengers were…NTSB DCA17WA189Incident · No injuriesForeign investigationAirbus A320 233 · Lima, PeruThe Comisión de Investigación de Accidentes de Aviación (CIAA) of Peru has notified the NTSB of an incident involving a AIRBUS A320 233 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government…NTSB ENG17WA034Accident · No injuriesForeign investigationBoeing 747 · Delhi, IndiaThe India Aircraft Accident Investigation Bureau (AAIB) has notified the NTSB of an incident involving a Boeing 747-200 which occurred on August 26, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…NTSB ERA17WA308Accident · 1 fatalForeign investigationMaule M7 · Zhideli, KazakhstanOn August 25, 2017, about 0450 coordinated universal time, a Maule M7-260C airplane, Kazakhstan registration UP-ML003, impacted terrain during a forced landing near Zhideli, Kazakhstan. The pilot was fatally injured and the passenger sustained serious…NTSB DCA17WA220Incident · No injuriesForeign investigationBoeing 767 424ER · Zurich, SwitzerlandThe Swiss Transportation Safety Investigation Board has notified the NTSB of an incident involving a BOEING 767 424ER airplane that occurred on August 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's…NTSB DCA17WA185Incident · No injuriesForeign investigationBoeing 737 · Georgetown, GuyanaThe Guyana Civil Aviation Authority (CAA) has notified the NTSB of an incident involving a Boeing 737-200, which occurred on August 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions of ICAO…NTSB CEN17WA325Accident · 2 fatalForeign investigationAviat Pitts S-2B · Holmestrand, NorwayOn August 22, 2017, at 1025 hours universal coordinated time, an Aviat Pitts S-2B, Norwegian registration LN-PTS, impacted the terrain following a loss of control while performing aerobatic maneuvers near Holmestrand, Norway. The pilot and passenger were…NTSB ERA17WA283Accident · 1 fatalForeign investigationRobinson R66 · Maly Utrish, RussiaOn July 21, 2017, about 1832 coordinated universal time, a Robinson R66 helicopter, Russian registration RA-05750, was substantially damaged when it impacted mountainous terrain near Maly Utrish township, while on a night flight from Anapa, Russia, to…NTSB CEN17WA379Incident · No injuriesForeign investigationCessna 172RG · Balchik, BulgariaOn August 21, 2017, at 1150 coordinated universal time, a Cessna 172RG, Bulgarian registration LZ-SPD, operated by Aviootryad Varna Ltd, collided with the runway during a gear-up landing at the Balchik Airfield (LBWB), Balchik, Bulgaria. The pilot and…NTSB ERA17WA289Accident · 5 fatalForeign investigationLearjet 25 · Naiguata, VenezuelaOn August 19, 2017, about 0415 universal coordinated time, a Learjet 25D, Venezuelan registration YV3191, descended and impacted the ocean about 5 nautical miles north of Naiguatá, Vargas, Venezuela. The two pilots and three passengers were fatally injured.…NTSB WPR17WA203Accident · No injuriesForeign investigationRobinson Helicopter R44 II · Darwin Aerodrome, AustraliaOn August 18, 2017, at 1400 local time, a Robinson R44 II, VH-LGN, was substantially damaged during a forced landing near Darwin Aerodrome, Australia. The helicopter was operated under the pertinent civil regulations of the government of Australia. The pilot…NTSB CEN17WA320Accident · 1 fatalForeign investigationPiper PA36 · Vejer de la Frontera, SpainOn August 15, 2017, a Piper PA-36-375 airplane (EC-EHB, s/n 36-8102001) impacted terrain during fumigation operations in the vicinity of Vejer de la Frontera, Spain. The pilot was fatally injured.This investigation is under the jurisdiction and control of the…NTSB ANC17WA048Accident · 2 fatalForeign investigationSocata TBM 700 · Zemyo, JapanOn Aug 14, 2017, at 1215 Japan standard time, a United States registered Socata TBM 700 airplane, N702AV, operated by a private individual, was destroyed when it impacted mountainous terrain under unknown circumstances near Zemyo in Nara Prefecture, Japan.…NTSB DCA17WA176Incident · Minor injuriesForeign investigationBoeing 767 332 · London, United KingdomThe Air Accident Investigation Branch (AAIB) of United Kingdom has notified the NTSB of a serious incident involving a BOEING 767 332 airplane that occurred on August 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government…NTSB ERA17WA273Accident · 4 fatalForeign investigationBell 206 · Algiers, AlgeriaOn August 10, 2017, about 0930 coordinated universal time, Bell 206L3 helicopter, Algerian registration 7T-WUF, was substantially damaged when it impacted terrain while maneuvering in Algiers, Algeria. The pilot and three passengers were fatally injured. The…NTSB DCA17WA171Incident · No injuriesForeign investigationBoeing 737 · Bacau, RomaniaThe Civil Aviation Safety Investigation and Analysis Center of Romania has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB ANC17WA045Accident · 1 fatalForeign investigationAir Tractor AT502 · La Crete, CanadaOn August 10, 2017, about 0320 Coordinated Universal Time, an Air Tractor AT-502B airplane, C-FWAS, impacted terrain while conducting an aerial application repositioning turn near La Crete, Alberta, Canada. The pilot sustained fatal injuries. The…NTSB ERA17RA315Accident · Serious injuriesForeign investigationCessna U206 · Eteringbang, GuyanaOn August 8, 2017, about 1513 coordinated universal time (UTC), a Cessna U206G, 8R-GPR, was substantially damaged during a forced landing in trees shortly after takeoff from Eteringbang Airstrip (SYET), Eteringbang, Cuyuni-Mazaruni Region, Guyana. Visual…NTSB DCA17WA225Incident · No injuriesForeign investigationBoeing 737 · Dubai, United Arab EmiratesThe GCAA of the United Arab Emirates has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation under the provisions of ICAO…NTSB DCA17WA175Incident · No injuriesForeign investigationEmbraer EMB135 · Middlemount, AustraliaThe Australian Transport Safety Board (ATSB) has notified the NTSB of a serious incident involving a EMBRAER EMB135 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB DCA17WA172Incident · No injuriesForeign investigationBoeing 787-9 · Madrid, SpainThe government of Spain has notified the NTSB of an incident involving a BOEING 787-9 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…NTSB CEN17WA310Accident · 3 fatalForeign investigationPiper PA28 · Berghaus Diavolezza, SwitzerlandOn August 4, 2017, at 0720 UTC, a Piper PA-28-181, Swiss registration HB-PER, owned and operated by a private individual, impacted mountainous terrain near Berghaus Diavolezza, Switzerland. The pilot and two passengers on board were fatally injured. A third…NTSB CEN17WA308Accident · No injuriesForeign investigationAmerican Champion 8GCBC · Dunaujvaros, HungaryThe government of Hungary has notified the National Transportation Safety Board (NTSB) of an accident involving an American Champion 8GCBC airplane that occurred on August 04, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA17WA165Accident · No injuriesForeign investigationBoeing 737 · Medan, IndonesiaThe KNKT of Indonesia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation under the provisions of ICAO Annex 13 as…NTSB WPR17WA178Accident · 1 fatalForeign investigationRobinson Helicopter R22 Beta · Cloncurry, AustraliaOn August 2, 2017, at 0740 local time, a Robinson R22, VH-HGU, was destroyed by a post-impact fire following a collision with power lines during cruise flight near Cloncurry Aerodrome, Australia. The helicopter was operated under the pertinent civil…NTSB CEN17WA321Accident · 1 fatalForeign investigationRobinson R44 · Puerto Chiapas, MexicoOn August 2, 2017, about 2115 universal coordinated time, a Robinson R44 helicopter, XB-MWZ, had a loss of engine power and subsequently impacted the Pacific Ocean near Puerto Chiapas, Mexico. Two persons were on board the helicopter. One person was reported…NTSB DCA17WA174Accident · Serious injuriesForeign investigationBoeing 777 · Singapore, SingaporeThe Transport Safety Investigation Bureau (TSIB) Ministry of Transport of Singapore has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA17WA168Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation…NTSB DCA17WA164Incident · No injuriesForeign investigationBoeing 747 · Frankfurt, GermanyThe BFU of Germany has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…NTSB CEN17RA377Accident · Minor injuriesForeign investigationMcdonnell Douglas MD900 · Heiligenblut, AustriaOn August 1, 2017, at 1815 UTC, a McDonnell Douglas MD 900 Helicopter, Austrian registration OE-XWF, impacted mountainous terrain about 8 miles west-northwest of Heiligenblut, Austria. One medical crewmember sustained minor injuries. The pilot, the other…NTSB DCA17WA163Incident · No injuriesForeign investigationBoeing Boeing 737-330 · Frankfurt-Main, GermanyThe BFU of Germany has notified the NTSB of an incident involving a Boeing 737-330 airplane that occurred on July 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…NTSB CEN17WA291Incident · No injuriesForeign investigationCessna 402 · British Virgin Islands, British Virgin IslandsOn July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…NTSB ERA17WA294Accident · No injuriesForeign investigationRaytheon Hawker · Mykonos, GreeceOn July 26, 2017, at 0727 Universal Coordinated Time (UTC), a Raytheon Aircraft Company Hawker 850XP, Turkish registration TC-MAN, operated by Genel Havacilik AS, received substantial damage following an abnormal runway contact during landing at Mykonos…NTSB ERA17RA260Accident · 1 fatalForeign investigationBritten Norman BN2A · Eteringbang, GuyanaOn July 25, 2017, about 2153 coordinated universal time, a Britten Norman BN2A-26, Guyana Registration 8R-GRA, operated by Roraima Airways Ltd., was substantially damaged when it impacted wooded terrain while on approach to Eteringbang Airstrip (SYET),…NTSB DCA17WA156Incident · No injuriesForeign investigationBoeing 737 · Bucharest, RomaniaThe Civil Aviation Safety Investigation and Analysis Center (CASIAC) of Romania has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ERA17WA291Accident · 3 fatalForeign investigationMitsubishi MU2B · San Fernando, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a MITSUBISHI MU2B airplane that occurred on July 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…NTSB DCA17WA158Incident · No injuriesForeign investigationBoeing Boeing 777-236 · London, United KingdomThe United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 777-236 airplane that occurred on July 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of the United Kingdom's investigation under the…NTSB CEN17WA289Accident · 7 fatalForeign investigationCessna U206 · Culiacan, MexicoNTSB ERA17WA343Accident · Serious injuriesForeign investigationCessna 182 · Ivano-Frankivsk, UkraineOn July 22, 2017, about 1305 coordinated universal time, a Cessna 182, Ukrainian registration UR-ORV, was substantially damaged during a forced landing near Ivano-Frankiivsk region, Ukraine. There were 5 people on board, of which 3 were seriously injured. The…NTSB DCA17WA161Incident · No injuriesForeign investigationBoeing 767 · Newcastle, United KingdomThe UK AAIB has notified the NTSB of an incident involving a Boeing767 airplane that occurred on July 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO Annex 13 as the…NTSB DCA17WA157Incident · No injuriesForeign investigationBoeing 737-86J · Belfast, United KingdomThe United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 737-86J airplane that occurred on July 21, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO…NTSB ERA17WA259Accident · 2 fatalForeign investigationCirrus Design SR20 · Santo Antonio do Leverger, BrazilOn July 20, 2017, at 1109 coordinated universal time, a Cirrus SR-20, Brazilian registration PR-PRF, was substantially damaged when it collided with terrain shortly after takeoff from Santa Edwiges farm, near the municipality of Santo Antônio do Leveger, Mato…NTSB CEN17WA279Accident · 1 fatalForeign investigationPiper Piper J3C-65 · Laukaa, FinlandOn July 19, 2017, about 0903 coordinated universal time, a Piper J3C-65 airplane, Finnish registration OH-PAD, was destroyed when it collided with the trees and terrain near Laukaa, Finland. The pilot was fatally injured. The airplane departed a private…NTSB DCA17WA160Accident · No injuriesForeign investigationBoeing 737 · Wamena, IndonesiaThe KNKT of Indonesia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 18, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions of…NTSB DCA17WA159Incident · No injuriesForeign investigationBoeing 747 422 · Frankfurt, GermanyThe BFU of Germany has notified the NTSB of an incident involving a Boeing 747 airplane that occurred on July 18, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the provisions of ICAO Annex 13 as the…NTSB ERA17WA271Accident · Serious injuriesForeign investigationCessna 172 · Khuzhir, RussiaOn July 16, 2017, at 1300 coordinated universal time, a Cessna 172M, Russian registration RA-2842G, ditched into Lake Baikal, near Khuzhir, Irkutskaya Oblast, Russia, after a total loss of engine power. The airplane incurred substantial damage during the…