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 CEN19WA285Accident · 1 fatalForeign investigationRotorway Exec 162F · Herisau, SwitzerlandOn August 24, 2019, about 1400 universal coordinated time, a Rotorway Exec 162F helicopter, Swiss registration HB-YKJ, was destroyed when it crashed in a meadow during an autorotation and caught fire, about 3 miles south of Herisau, Switzerland. The pilot was…NTSB GAA19WA532Accident · 4 fatalForeign investigationCessna 182 · Warintza, Morona Santiago, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on August 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB CEN19WA289Accident · 1 fatalForeign investigationCapella XS · San Juan del Puerto, SpainOn August 23, 2019, about 1905 hours universal coordinated time, an amateur-built Capella XS airplane, Spanish registration EC-YTA, impacted terrain after an inflight separation of a wing near San Juan del Puerto, Spain. The pilot was fatally injured, and the…NTSB CEN19WA284Accident · 1 fatalForeign investigationReims F172 · Schneizlreuth, GermanyThe government of Germany has notified the NTSB of an accident involving a REIMS F172 airplane that occurred on August 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions…NTSB CEN19WA282Accident · 1 fatalForeign investigationCessna 150 · Diepholz, GermanyOn August 22, 2019, at an 1120 UTC, a Cessna 150, D-EHLG, impacted with terrain in cornfield in Steinfeld, Germany. The pilot, the sole occupant, suffered fatal injuries and the airplane was destroyed. The flight had departed Flugplatz Diepholz-Dümmerland on…NTSB ERA19WA261Accident · 3 fatalForeign investigationAgusta A109 · Poros, GreeceThe government of the Hellenic Republic, Greece, has notified the NTSB of an accident involving an Agusta A-109C helicopter that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's…NTSB DCA19WA217Incident · No injuriesForeign investigationBoeing 737 · Cape Town, South AfricaThe CAA of South Africa has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAA of South Africa's investigation under the provisions of…NTSB ENG19WA044Incident · No injuriesForeign investigationAirbus A320 · Guwahati, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on August 19, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left)…NTSB DCA19WA201Incident · No injuriesForeign investigationBoeing 757 · Ponta Delgada, PortugalThe government of Portugal has notified the NTSB of an accident involving a Boeing 757 airplane that occurred on August 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the provisions…NTSB ENG19WA032Incident · No injuriesForeign investigationAirbus A320 · Nassau, BahamasThe Air Accident Investigation Department (AAID) of the Bahamas has notified the NTSB of an incident involving an Airbus A320-212 that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB under the provisions…NTSB CEN19WA341Accident · No injuriesForeign investigationCessna 150 · Ravna Gora, CroatiaThe government of Croatia has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on August 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Croatia's investigation under the provisions…NTSB WPR19WA274Accident · 2 fatalForeign investigationCessna 172 · Pretoria, South AfricaOn August 16, 2019, at 1810 universal coordinated time, a Cessna 172M, ZS-LMI, collided with terrain near Pretoria, South Africa. Both occupants were fatally injured and the airplane was substantially damaged. The airplane was being operated under the…NTSB ENG19WA030Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Warsaw, PolandThe government of Poland has notified the NTSB of an incident involving a Boeing (McDonnel-Douglas) MD-11F operated by UPS and powered by three Pratt & Whitney PW 4460 turbofan engines. During cruise, the No. 2 engine (right) experienced fluctuations and…NTSB DCA19WA203Accident · Serious injuriesForeign investigationBoeing 787 · Beijing, ChinaThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 797, which occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex…NTSB DCA19WA202Incident · Minor injuriesForeign investigationBoeing 767 · Shannon, IrelandThe AAIU of Ireland has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions of ICAO…NTSB CEN19WA272Incident · No injuriesForeign investigationReims Aviation Cessna F172N · Lesnovo, BulgariaOn August 14, 2018, about 0750 coordinated universal time, a Reims Aviation Cessna F172N airplane, Bulgarian registration number LZ-SPB, had a forced landing at the Lesnovo Airport (LBLS), Lesnovo, Bulgaria, following an inflight loss of engine power. The…NTSB ERA19WA270Accident · 3 fatalClass 5 · ForeignEmbraer EMB710 · Itaituba, BrazilNTSB DCA19WA197Incident · No injuriesForeign investigationBoeing 787 · Rome, ItalyThe government of Italy has notified the NTSB of an incident involving a BOEING 787 airplane that occurred on August 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB CEN19WA274Accident · No injuriesForeign investigationBell 206 · Vuoggatjålme, SwedenOn August 10, 2019, about 0855 hours universal coordinated time, a Bell 206-L1, Swedish registration SE-JOA, was damaged when the rotor blades struck the tail boom during an emergency landing following a loss of engine power after takeoff near Vuoggatjålme,…NTSB WPR21WA102AccidentClass 5 · ForeignCessna 150 · Gan International Airport, MaldivesNTSB GAA19WA573Accident · Serious injuriesForeign investigationBeech 36 · Corse-du-Sud, FranceThe government of France has notified the NTSB of an accident involving a BEECH 36 airplane that occurred on August 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB ENG19WA042Incident · No injuriesForeign investigationAirbus A320 · Varanasi, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on August 9, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…NTSB ERA19WA242Accident · No injuriesForeign investigationPiper PA34 · Bimini, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on August 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB ENG19RA038Incident · No injuriesForeign investigationRaytheon 390 · Hamburg, GermanyOn August 7, 2019, about 1408 coordinated universal time (UTC), a Raytheon 390 Premier 1A airplane, Czech Republic registration OK-EJH, experienced smoke/fire in the cockpit from the windshield heat system during takeoff from Hamburg Airport, Hamburg,…NTSB WPR19WA210Accident · 1 fatalForeign investigationLiberty Aerospace XL-2 · Braidwood, AustraliaOn August 6, 2019, at 0138 coordinated universal time, a Liberty Aerospace XL-2, registration VH-XLK, collided with terrain during a landing attempt near Braidwood, New South Wales, Australia. The pilot and sole occupant was fatally injured, and the airplane…NTSB GAA19WA533Accident · 1 fatalForeign investigationPiper PA25 · Totatlan, Jalisco, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ANC19WA052Accident · 2 fatalForeign investigationCessna 208 · Mayo, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on August 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB GAA19WA583Accident · No injuriesForeign investigationCessna 560 · Aarhus airport, DenmarkThe government of Denmark has notified the NTSB of an accident involving a CESSNA 560 airplane that occurred on August 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions…NTSB GAA19WA547Accident · No injuriesForeign investigationPiper PA28R · Sligo, IrelandThe government of Ireland has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on August 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…NTSB ENG19WA031Incident · No injuriesForeign investigationAirbus A321 · Valencia, SpainThe government of Spain has notified the NTSB of an incident involving a AIRBUS A321 airplane that occurred on August 5, 2019 operated by British Airways. The airplane was powered by two International Aero Engines V2533-A5 turbofan engines. During landing, it…NTSB CEN19WA256Accident · 1 fatalForeign investigationCessna A185 · Upper Raft Lake, CanadaNTSB DCA19WA195Incident · No injuriesForeign investigationBoeing 737 · El Alto, BoliviaThe government of Bolivia has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the provisions…NTSB WPR19WA234Accident · 3 fatalForeign investigationRobinson R44 · Korotasere, Cakaudrove, FijiOn August 2, 2019, about 1830 local time, a Robinson R44 Helicopter, DQ-HPT, impacted the ocean about 4 nautical miles east of Korotasere, Cakaudrove, Fiji under unknown circumstances. The commercial pilot and two passengers are presumed to be fatally…NTSB ERA19WA241Accident · 1 fatalForeign investigationCessna 510 · Los Angeles, ChileThe government of Chile has notified the NTSB of an accident involving a Cessna 510 airplane that occurred on August 2, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB CEN19WA301Accident · 2 fatalForeign investigationCessna TU206 · Guachochi, MexicoOn August 2, 2019, about 1600 universal coordinated time, a Cessna TU206G airplane, XB-FZN, impacted terrain near Guachochi, Mexico. The two people on board sustained fatal injuries. The accident investigation is under the jurisdiction and control of the…NTSB GAA19WA579Accident · No injuriesForeign investigationHughes 369 · Follebu, NorwayThe government of Norway has notified the NTSB of an accident involving a HUGHES 369 helicopter that occurred on August 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…NTSB WPR19WA206Accident · 1 fatalForeign investigationBell 47G · Limpopo Province, South AfricaOn July 30, 2019, about 0900 coordinated universal time, a Bell 47G-3B-1 helicopter, ZS-HGY, impacted terrain following a total loss of engine power near Alldays, Limpopo Province, South Africa. The pilot was fatally injured, and the passenger was seriously…NTSB CEN19WA268Accident · 1 fatalForeign investigationBeech V35 · Senneterre, Quebec, CanadaNTSB GAA19WA578Accident · No injuriesForeign investigationCirrus SR22 · Norrtalje, Stickhome, SwedenThe government of Sweden has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on July 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions of…NTSB WPR19WA208Accident · Serious injuriesForeign investigationVans RV6 · Williams Creek, AustraliaOn July 28, 2019, at 0537 coordinated universal time, a Van's RV-6A , registration VH-ANU, experienced a collapse of the nose landing gear, nosed over and came to rest near William Creek, Southern Australia. The pilot and passenger were seriously injured, and…NTSB CEN19WA294Accident · 1 fatalForeign investigationAir Tractor AT400 · Namiquipa, MexicoThe government of Mexico has notified the NTSB of an accident involving a AIR TRACTOR AT400 airplane that occurred on July 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB CEN19WA291Accident · No injuriesForeign investigationSikorsky S76 · Vigo, SpainOn July 26, 2019, about 2130 coordinated universal time, a Sikorsky S76 C+, EC-JES, impacted terrain at the Vigo Airport (LEVX), Vigo, Spain. The accident investigation is under the jurisdiction and control of the government of Spain. This report is for…NTSB ANC19WA043Accident · 4 fatalForeign investigationCessna 208 · Bella Bella, CanadaOn July 26, 2019, about 1100 pacific daylight time, a Canadian registered Cessna 208 airplane, C-GURL, owned and operated by Seair Seaplanes Ltd., was destroyed when it collided with terrain in the vicinity of Addenbroke Island, British Columbia (BC), Canada,…NTSB ENG19IA029Incident · No injuriesClass 3 · IncidentFinal reportAirbus A220 · Perrigny-sur-Armançon, FranceA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed as a result of a…NTSB GAA19WA458Incident · No injuriesForeign investigationSikorsky S92 · Sable Island, CanadaThe government of Canada has notified the NTSB of an accident involving a SIKORSKY S92 helicopter that occurred on July 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…NTSB WPR19WA203Accident · No injuriesForeign investigationRIchards Heavylift UH-1H · Limpopo Province, South AfricaOn July 23, 2019, about 1107 coordinated universal time, a Richards Heavylift Helo Inc., UH-1H, South African registration ZS-HLJ, operated for fire fighting, and equipped with a Textron Lycoming T-53 engine, reported a loss of engine power near Woodbush…NTSB WPR19WA199Accident · 1 fatalForeign investigationCessna 172 · Cangkring, IndonesiaOn July 22, 2019, about 0810 coordinated universal time, a Cessna 172 airplane, PK-WUG, impacted a river and sunk under unknown circumstances about 2.5 nautical miles northeast of Cangkring, Indonesia. One pilot was seriously injured, and the second was…NTSB OPS19WA018Incident · No injuriesForeign investigationAirbus A321 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A-321-231, which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB ERA19WA236Accident · 2 fatalForeign investigationRobinson R66 · Gorgona Island, ItalyThe government of Italy has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB ENG19WA036Incident · No injuriesForeign investigationAirbus A330 · Islamabad, PakistanThe Aircraft Accident Investigation Board (AAIB) of Pakistan has notified the NTSB of an incident involving an Airbus A330-200 airplane which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…