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 CEN18WA154Accident · 2 fatalForeign investigationAmateur Construction Vari EZE · Innsbruck, AustriaOn April 29, 2018, about 0819 hours universal coordinated time, an amateur-built Vari-Eze airplane, Swiss registration HB-YCM, impacted terrain shortly after takeoff from the Innsbruck Airport (LOWI), Innsbruck, Austria. The pilot and passenger were fatally…NTSB DCA18WA161Incident · No injuriesForeign investigationBoeing 737 · Perth, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB CEN18WA401Accident · No injuriesForeign investigationBeech 58 · Hautes-Alpes, FranceOn April 28, 2018, about 0720 UTC, a Beechcraft BE-58P, Swiss registry HB-GGP, operated by a private individual, experienced an uncontained engine failure while in cruise flight near the Hautes-Alpes, France. The pilot, the sole person on board was not…NTSB CEN18WA155Incident · No injuriesForeign investigationDassault-Breguet Falcon 900 · Bremgarten, GermanyOn April 28, 2018, 2015, about 1505 universal time (UTC), a United States registered Dassault-Breguet Falcon-900, N670JD, was involved in an incident in Bremgarten, Germany. The pilot, copilot, and 2 passengers were not injured. The investigation is under the…NTSB CEN18WA153Accident · 2 fatalForeign investigationCessna 172 · Corozalito, Nandayure, Costa RicaOn April 28, 2018, about 1800 UTC, a Cessna 172S airplane, TI-BIL, impacted terrain during an instructional flight near Corozalito, Nandayure. Both crewmembers on board were fatally injured.This investigation is under the jurisdiction and control of the Costa…NTSB WPR18WA126Accident · 1 fatalForeign investigationWells Elgin M Starjammer · HeNan Province, ChinaOn April 25, 2018, at 1814 local time, an experimental Wells StarJammar airplane, N49EW, crashed during the rehearsal flight for an aerobatic performance at ShangJie general aviation Airport, HeNan Province, P.R. China. The owner/pilot, the sole occupant, was…NTSB CEN18WA161Accident · No injuriesForeign investigationCessna 172 · Hagfors, SwedenOn April 22, 2018, at 1240 coordinated universal time, a Cessna F172E single-engine airplane, Swedish registration SE-EHI, serial number F172-0039, encountered soft terrain and nosed over upon landing at Hagfors Airport (ESOH), near Hagfors, Sweden. The…NTSB ERA18WA274Accident · 2 fatalForeign investigationPiper PA28 · Nafpaktos, GreeceThe government of Greece has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on April 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's investigation under the provisions of…NTSB CEN18WA145Accident · 2 fatalForeign investigationCessna Cessna 152 · Crumlin, IrelandOn April 19, 2018, at 1230 UTC, a Cessna 152 airplane, G-UFCO, collided with the terrain in Crumlin, Northern Ireland. The pilot and passenger were fatally injured, and the airplane was substantially damage by impact and postimpact fire. The wreckage was…NTSB DCA18WA155Incident · No injuriesForeign investigationBoeing 737 · MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA18WA149Incident · No injuriesForeign investigationBoeing 737 500 · Cuzco, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 500 airplane that occurred on April 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of…NTSB WPR18WA134Accident · Serious injuriesForeign investigationGarlick UH1H · Talbingo NSW, AustraliaOn April 17, 2018, about 1510 local time, a Garlick, Australian registration VH-HUE, operated as a freight charter and equipped with a Textron Lycoming T-53 engine, impacted terrain near Talbingo, Australia. The pilot, sole occupant onboard, was seriously…NTSB ERA18WA173Accident · No injuriesForeign investigationBell Helicopter 407 · Nova Esperanca, BrazilThe government of Brazil has notified the NTSB of an accident involving a BELL 407 helicopter that occurred on April 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ERA18WA133Accident · 1 fatalForeign investigationBell 206L-4 · Vereda Plateado, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BELL 206L-4 helicopter that occurred on April 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB CEN18WA141Accident · 2 fatalForeign investigationCirrus SR20 · Adolf Wurth Airport, GermanyOn April 15, 2018, at 1300 UTC, a Cirrus SR-20, D-EWTG, and a Dallach D4b Fascination, D-MJEK, encountered a midair collision under unknown circumstances near Adolf Würth Airport (EDTY), Schwäbisch Hall, Germany. Both aircraft were destroyed; and the pilots,…NTSB ENG18WA025Incident · No injuriesForeign investigationAirbus A330 · Brisbane, QLD, AustraliaThe Australian Government has notified the NTSB of an incident involving an Airbus A330-202 that occurred April 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the Australian Transport Safety Bureau (ATSB) investigation under the…NTSB DCA18WA308Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB DCA18WA151Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ERA18WA132Accident · No injuriesForeign investigationBell 206 · Vereda Plateado, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…NTSB DCA18WA157Incident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Pakistan Safety Investigation Board has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under…NTSB DCA18WA154Incident · No injuriesForeign investigationEmbraer S A ERJ170-200LR · MexicoThe government of Mexico has notified the NTSB of an incident involving a EMBRAER S A ERJ170-200LR airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…NTSB ERA18WA130Accident · 4 fatalForeign investigationBeech 58 · Tucuman, ArgentinaNTSB DCA18WA153Incident · No injuriesForeign investigationAirbus A319 115 · MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A319 115 airplane that occurred on April 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…NTSB DCA18WA138Incident · No injuriesForeign investigationBoeing 737 · Brasilia City, BrazilThe government of Brazil has notified the NTSB of a serious incident involving a EMBRAER EMB110 airplane that occurred on April 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB DCA18WA123Accident · No injuriesForeign investigationBoeing 737 · Osaka, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the…NTSB ERA18WA131Accident · No injuriesForeign investigationPiper PA34-200T · La Pampa, ArgentinaNTSB DCA18WA130Incident · No injuriesForeign investigationBoeing 737 · Rio de Janeiro, BrazilThe government of Brazil has notified the NTSB of an serious incident involving a BOEING 737 airplane that occurred on April 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB DCA18WA137Incident · No injuriesForeign investigationBoeing 737 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation…NTSB CEN18WA402Accident · 1 fatalForeign investigationRotorway Exec · Crestet, FranceThe government of France has notified the NTSB of an accident involving an amateur-built ROTORWAY EXEC helicopter that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under…NTSB CEN18WA184Accident · No injuriesForeign investigationCessna 525 · Santiago, SpainOn April 5, 2018, about 1810 universal coordinated time (UTC), a Cessna 525C, Spanish registration EC-MOQ, was involved in an accident at the Santiago Airport (A Coruha, Spain). The left main landing gear collapsed while exiting the runway after landing. Two…NTSB CEN18WA136Accident · 2 fatalForeign investigationBell 47G · Libourne, FranceThe government of France has notified the NTSB of an accident involving a BELL 47G helicopter that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB WPR18WA117Incident · No injuriesForeign investigationBeech 58 · East London, South AfricaOn April 3, 2018, at 0612 coordinated universal time, a Beechcraft 58 Baron airplane, registration ZS-JYD, sustained minor damage after the nose gear collapsed during landing at East London (FAEL), Eastern Cape, South Africa. The pilot, sole occupant, was not…NTSB ERA18WA123Accident · 4 fatalForeign investigationRobinson R44 · Rosario, BrazilNTSB CEN18WA380Accident · No injuriesForeign investigationRobin DR-400 · St. Chamont, FranceOn March 31, 2018, a Robin DR400-120 airplane, French registration F-GIKQ, experienced a runway excursion during takeoff from Saint Chamond - L'Horme airport (LFHG), near L'Horme, France. The airplane departed then end of runway 28 and came to rest along a…NTSB ENG18WA021Incident · No injuriesForeign investigationBoeing 747 · Chek Lap Kok, Hong Kong SAR ChinaThe Hong Kong Civil Aviation Department (HKCAD) has notified the NTSB of an incident involving a Boeing 747-8F airplane which occurred on March 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the HKCAD investigation under the…NTSB DCA18WA124Incident · No injuriesForeign investigationBoeing 757 · Mexico City, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a BOEING 757 airplane that occurred on March 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…NTSB DCA18WA156Incident · No injuriesForeign investigationBoeing 767 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 767 airplane that occurred on March 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN18WA135Accident · No injuriesForeign investigationRotorway Exec · Koblenz-Winningen, GermanyThe government of Germany has notified the NTSB of an accident involving an amateur-built ROTORWAY EXEC helicopter that occurred on March 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation…NTSB CEN18WA130Accident · 2 fatalForeign investigationMaule M 7-235 · Arosa, SwitzerlandNTSB DCA18WA317Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Budapest, HungaryNTSB WPR18WA110Accident · 2 fatalForeign investigationEurocopter EC120 · Hardy Reef, Queensland, AustraliaOn March 21, 2018, about 1500 local time, a Eurocopter (Airbus Helicopters) EC120B helicopter, VH-WII, sustained substantial damage when it impacted water during an aborted landing attempt on a floating helicopter landing site (HLS) located between Hardy Reef…NTSB WPR18WA115Accident · No injuriesForeign investigationRobinson R22 · Bloemfontein, South AfricaNTSB DCA18WA106Accident · 11 fatalForeign investigationCanadair CL600 2B16 · Shahr-e Kurd, IranThe Transportation Safety Board of Canada has informed the NTSB of an accident involving a Challenger 604, which occurred on March 11, 2018, in the Islamic Republic of Iran. All investigative information will be released by the government of Iran.NTSB WPR18WA240Accident · No injuriesForeign investigationCessna 206 · Southport, AustraliaOn March 4, 2018, about 1040 local time, a Cessna U206G airplane, VH-LHQ, was substantially damaged when it impacted water during takeoff near Southport, Queensland, Australia. The pilot and two passengers were not injured. The investigation is under the…NTSB DCA18WA103Incident · No injuriesForeign investigationBoeing 737 · Guayaquil, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an incident involving a Boeing 737-400, which occurred on March 4, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13. All investigative…NTSB ENG18RA018Incident · No injuriesForeign investigationCessna 441 · Broome, Australia, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Cessna 441 which occurred on March 2, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of ICAO…NTSB ENG18RA020Incident · No injuriesForeign investigationAvro RJ85 · Bishkek, KyrgyzstanOn March 1, 2018, a Tez Jet Airline Avro RJ85, powered by four Honeywell (formally Lycoming) LF507-1F turbofan engines experienced an uncontained No. 1 (left most) engine turbine failure during climb. The airplane returned to the Bishkek-Manas International…NTSB WPR18WA097Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Ogies, South AfricaOn February 28, 2018, at 0945 Universal Coordinated Time (UTC), a South African registered Robinson Helicopter Company R44 Raven II, ZS-HKZ, lost engine power while maneuvering near Truter Boerdery Farm, Ogies, Mpumalana Province, South Africa. The helicopter…NTSB DCA18WA315Accident · No injuriesForeign investigationAirbus A320 · Tallinn, EstoniaThe Estonian Safety Investigation Bureau (AIB) has notified the NTSB of an accident involving a Airbus 320, which occurred on February 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…NTSB CEN18WA133Incident · No injuriesForeign investigationCessna 182P · Abbeville, FranceOn February 28, 2018, about 0845 universal coordinated time (UTC), a Cessna 182P airplane, N609PC, had an inflight engine failure and subsequent forced landing near Abbeville, France. The pilot and passenger were uninjured, and the airplane sustained minor…