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 CEN16WA205Accident · 1 fatalForeign investigationVans RV4 · Coex, FranceOn June 1, 2016, at 2100 local time, a Vans RV4, Netherlands registration PH-EIL, was destroyed when it collided with the terrain in Coex, France. The pilot was fatally injured and the passenger received serious injuries. At the time of this report, it is…NTSB CEN16WA198Accident · 2 fatalForeign investigationAmateur Construction Rans S6-ESD (Modifie · Shropshire, United KingdomThe United Kingdom Air Accidents Investigation Branch (AAIB) has notified the NTSB of a fatal accident involving a Rans S-6ESD, registration G-MYES, which occurred on May 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…NTSB ERA16WA207Accident · 4 fatalForeign investigationPiper PA-28-160 · Corumbaiba, BrazilNTSB ENG16RA023Incident · No injuriesForeign investigationBoeing 777 · Tokyo, JapanOn May 27, 2016 about 1238 Japan standard time, Korean Air flight 2708, a Boeing 777-300, HL7534, rejected the takeoff from Tokyo Haneda International Airport, Tokyo, Japan, after the left engine lost power and caught fire. The investigation is under the…NTSB DCA16WA167Incident · Minor injuriesForeign investigationBoeing 737 · tokyo, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of serious incident involving a BOEING 737 airplane that occurred on May 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under…NTSB DCA16WA178Incident · No injuriesForeign investigationAirbus A320 · Lisbon, PortugalGabinete de Prerencao e Investigacao de Acidentes com Aeronaves (GPIAA) Portugal has notified the NTSB of an accident involving a AIRBUS A320 airplane that occurred on May 21, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ERA16WA321Accident · 2 fatalForeign investigationVans RV7 · Cordoba, ArgentinaOn May 19, 2016, about 2015 coordinated universal time, an experimental, amateur-built Vans RV-7, Argentine registration LV-X566, operated by a private individual, was destroyed when it impacted terrain during aerobatic maneuvers near Cordoba, Argentina. The…NTSB DCA16RA156Accident · 66 fatalForeign investigationAirbus A320 · Cairo, EgyptThe Egyptian Ministry of Civil Aviation (EMCA) has notified the NTSB of an accident involving an AIRBUS A320, equipped with IAE V2500 engines, that occurred on May 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the EMCA's…NTSB ERA16WA205Accident · No injuriesForeign investigationPiper PA-25-235 · Unai, BrazilOn May 17, 2016, about 0830 local time, a Piper PA-25-235, Brazilian registration PR-TAC, was substantially damaged when it impacted the ground while crop dusting near Unaí, Minas Gerais, Brazil. The Brazilian pilot was fatally injured. The local aerial…NTSB CEN16WA199Accident · 1 fatalForeign investigationPiper PA-28R-200 · Halden, NorwayOn May 17, 2016, about 1615 coordinated universal time (UTC), a Piper Aircraft, Inc. PA-28R-200 airplane, Norwegian registration LN-AAM, impacted trees and terrain, near Halden, Norway. The airplane was destroyed during impact and the pilot, the sole…NTSB CEN16WA398Accident · Serious injuriesForeign investigationCirrus SR22 · Ailly-sur-Somme, FranceNTSB ERA16WA223Accident · No injuriesForeign investigationCessna 550 · Charallave, VenezuelaOn May 12, 2016, about 2330 coordinated universal time (UTC), a Cessna 550, Venezuelan registration YV589T, veered off the runway during landing roll and was substantially damaged at the Oscar Machado Zuloaga Airport (SVCS), Charallave, Venezuela. The two…NTSB DCA16WA159Incident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe government of Pakistan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 09, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the provisions of…NTSB CEN16WA351Accident · 1 fatalForeign investigationRobinson R22 · Aube, FranceNTSB CEN16WA402Accident · Serious injuriesForeign investigationBell 206 · Mexico City, MexicoNTSB ANC16WA028Accident · 1 fatalForeign investigationVans RV4 · Eckville, CanadaOn May 07, 2016, about 2000 Coordinated Universal Time, an amateur-built Van's Thiessen RV-4 airplane, C-GGYT, impacted terrain near Eckville, Alberta, Canada, under unknown circumstances. The pilot sustained fatal injuries. The Transportation Safety Board…NTSB DCA16WA150Incident · No injuriesForeign investigationBoeing 767 · Cologne, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 767 airplane that occurred on May 06, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…NTSB CEN16WA176Accident · 2 fatalForeign investigationRans S12 · Wiener Neustadt, Austria, AustriaOn May 6, 2016, about 1625 coordinated universal time (UTC), a Rans S-12, D-MOHA, was destroyed when it impacted terrain after a loss of control during the initial climb from Loan Airport, Wiener Neustadt, Austria. The pilot and passenger were killed. The…NTSB DCA16WA152Incident · No injuriesForeign investigationAirbus A320 · Buenos Aires, ArgentinaThe JIAAC of Argentina has notified the NTSB of an incident involving a AIRBUS A320 airplane and a Boeing B737 airplane that occurred on May 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's…NTSB ERA16WA175Accident · 3 fatalForeign investigationRobinson R44 · Avacha`, RussiaOn May 3, 2016, about 0347 UTC, a Robinson Helicopter R44, Russian registered RA-2118G was destroyed when it impacted mountainous terrain near Kamchatka, Russia, while on a flight from Khalaktyrka, Russia to Karymshina, Russia. The pilot and two passengers…NTSB DCA16WA149Accident · No injuriesForeign investigationBoeing 737 · Ulaanbaatar, MongoliaThe government of Mongolia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mongolia's investigation under the provisions of…NTSB ERA16WA180Accident · 2 fatalForeign investigationRobinson R22 · Sao Paulo, BrazilOn May 5, 2016, about 1515 universal coordinated time, a Robinson R22 Beta, Brazilian registration PR-RCA, operated by AGD Aviation, was substantially damaged when it impacted wires and then terrain while maneuvering in Sao Paulo, Brazil. The flight…NTSB DCA16WA144Incident · No injuriesForeign investigationBoeing 737 · Prishtina, SerbiaThe government of Serbia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on May 02, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Serbia's investigation under the provisions of…NTSB ERA16WA196Accident · No injuriesForeign investigationSikorsky S76 · Campos dos Goytacazes, BrazilOn April 28, 2016, about 1330 coordinated universal time, a Sikorsky S76A, Brazilian registration PR-EMR, was substantially damaged during an emergency landing after a fire indication and precautionary engine shutdown on the right engine followed shortly by a…NTSB DCA16WA155Accident · No injuriesForeign investigationEmbraer ERJ190 · Cuenca, EcuadorThe Ecuador Direccion General de Aviacion Civil (DGAC) has notified the NTSB of an accident involving an Embraer E-190 that occurred on April 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation under the…NTSB DCA16WA160Incident · No injuriesForeign investigationBoeing 737 · Guangzhou, ChinaThe Civil Aviation Administration of China (CAAC) has notified the NTSB of an accident involving a Boeing 737 that occurred on April 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CAAC's investigation under the provisions of…NTSB DCA16WA143Accident · No injuriesForeign investigationRobinson R44 · Pretoria, South AfricaThe South African CAA has notified the NTSB of an accident involving a Robinson R44 helicopter and Aeroprakt A-22 Foxbat ultralight that occurred on April 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation…NTSB CEN16WA179Accident · No injuriesForeign investigationSwearingen SA 226T · Andorra, Lleida, Spain, SpainOn April 26, 2016, about 1535 hours universal coordinated time, a Swearingen SA-226T airplane, United States registration N125WG, was substantially damaged during landing at the Andorra – La Seu d'Urgell Airport (LESU); Andorra, Lleida, Spain. The airplane…NTSB DCA16WA142Incident · No injuriesForeign investigationBoeing 767 · Frankfurt, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a BOEING 767 that occurred on April 24, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the BFU's investigation under the…NTSB DCA16WA244Incident · No injuriesForeign investigationBoeing 737 · Apia, AntarcticaThe government of American Samoa has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 23, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of American Samoa's investigation under the…NTSB ENG16WA022Accident · Minor injuriesForeign investigationBeech 1900 · Gander, CanadaThe Transportation Safety Board of Canada has notified the NTSB of an accident involving a Beechcraft 1900D, which occurred on April 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Transportation Safety Board of Canada…NTSB CEN16WA174Accident · 1 fatalForeign investigationCessna 150 · Strakonice, CzechiaOn April 20, 2016, at 1253 universal coordinated time (UTC), a Cessna 150 airplane, Czech Republic registration OK-OKA, serial number 150741140, sustained substantial damage when it impacted terrain near the Strakonice Airport (LKST), Strakonice, Czech…NTSB ERA16WA163Accident · 3 fatalForeign investigationRobinson R66 · Bely Island, RussiaNTSB ENG16RA028Incident · No injuriesForeign investigationBombardier CL600 2C10 · Fukuoka, JapanThe Japan Transport Safety Board has notified the NTSB of an incident involving a Bombardier CL-600-2C10, JA06RJ, which took off from Fukuoka Airport at 07:48 local time to Komatsu Airport and during return back to Fukuoka Airport due to weather condition of…NTSB CEN16WA160Accident · 1 fatalForeign investigationExtra Flugzeugbau EA 300/L · Cozumel, MexicoOn April 17, 2016, at 1940 UTC, an Extra EA300, N13DK, impacted terrain at Cozumel International Airport (MMCZ) in Cozumel, Mexico. The aircraft was destroyed and the pilot, the sole occupant, was fatally injured. This investigation is under the jurisdiction…NTSB DCA16WA131Accident · 12 fatalForeign investigationBritten Norman BN2 · Kiunga, Papua New GuineaThe government of Papua New Guinea has notified the NTSB of an accident involving a BRITTEN NORMAN BN2 airplane that occurred on April 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Papua New Guinea's…NTSB CEN16WA152Accident · Minor injuriesForeign investigationPiper PA32R · Hampshire, United KingdomOn April 12, 2016, at 1300 coordinated universal time, a Piper PA-32R-301T airplane, G-MAIE, experienced a hard landing at the Daedalus Airfield (EGHF), Hampshire, United Kingdom. The pilot was not seriously injured, and the airplane sustained damage to the…NTSB ANC16WA018Accident · 2 fatalForeign investigationRockwell 112 · Revelstoke, CanadaOn April 11, 2016, about 2000 Coordinated Universal Time, a Rockwell Commander 112B airplane, CGQJN, impacted terrain near Revelstoke, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation…NTSB DCA16WA138Incident · No injuriesForeign investigationBoeing 737 · Chiang Mai, ThailandMinistry of Transport of Thailand has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's investigation under the…NTSB ENG16RA021Incident · No injuriesForeign investigationATR ATR72 · Trapani, ItalyThe Agenzia Nazionale per la Sicurrezza del Volo (ANSV) has notified the NTSB of an incident involving an ATR 72 that occurred April 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the provisions of ICAO…NTSB CEN16WA159Incident · No injuriesForeign investigationCessna 550 · Geneva, SwitzerlandThe Swiss Accident Investigation Board (SAIB) of Switzerland has notified the National Transportation Safety Board (NTSB) of an incident involving a Cessna Aircraft Company S550 Citation S/2, EC-LQF, that occurred on April 9, 2016. The NTSB has appointed a…NTSB ERA16WA155Accident · Minor injuriesForeign investigationDouglas DC3 · Puerto Gaitan, ColombiaOn April 7, 2016, about 1200 coordinated universal time, a Douglas DC3-C, Colombian registration HK2663, was destroyed during a postimpact fire, following a forced landing to a field due to a loss of power on the left engine during initial climb from Puerto…NTSB CEN16WA147Accident · Serious injuriesForeign investigationMcdonnell Douglas Helicopter 369E · Suwalki, PolandOn April 7, 2016, at 1613 Central European Daylight Time, a McDonnell Douglas Helicopter 369E, N60EA, registered to EPC Industries, Inc., and operated by a private entity was substantially damaged when it impacted terrain under unknown circumstances near…NTSB CEN16WA150Incident · No injuriesForeign investigationRobinson R22 Beta · Bern, SwitzerlandOn April 6, 2016, about 1330 Universal Coordinated Time (UTC), the crew of a Robinson R22 BETA, Swiss registration HB-ZGO, made a precautionary landing at Bern Airport (LSZB), Bern, Switzerland, after they smelled smoke. They noted the alternator had failed…NTSB DCA16WA126Accident · Minor injuriesForeign investigationBoeing 737 · Jakarta, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 04, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…NTSB CEN16WA149Accident · Serious injuriesForeign investigationRobinson Helicopter R44 II · Atemajac de Brizuela, MexicoOn April 2, 2015, about 2120 universal coordinated time, a Robinson Helicopter Company R44 II helicopter, N565AC, impacted terrain near Atemajac de Brizuela, Mexico. The pilot and two passengers were uninjured and one passenger sustained a serious injury. The…NTSB CEN16WA144Accident · 3 fatalForeign investigationCessna 208 · Tayoltita, Dgo, Mexico, MexicoOn April 1, 2016, about 0900 local time, a Cessna 208B single engine airplane, serial number 208B2104, registry XA-ULU, was substantially damaged during an off-airport forced landing near Tayoltita, San Dimas, Durango, Mexico. There were ten persons on-board…NTSB CEN16WA141Accident · 3 fatalForeign investigationCessna 172 · Madrid, SpainOn March 31, 2016, about 1200 coordinated universal time (UTC), a Cessna 172 airplane, Spanish registration EC-JSM, collided with the terrain following a bird strike near Madrid, Spain. The pilot and two passengers sustained fatal injuries, and the airplane…NTSB CEN16RA136Accident · 7 fatalForeign investigationMitsubishi MU 2B · Iles-de-la-Madeleine, CanadaimportNTSB DCA16WA118Incident · No injuriesForeign investigationAirbus A320 · Bilbao, SpainThe government of Spain has notified the NTSB of an accident involving a AIRBUS A320 airplane that occurred on March 28, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of…