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 ERA18WA237Accident · 2 fatalForeign investigationAgusta A109 · Espírito Santo, BrazilThe government of Brazil has notified the NTSB of an accident involving a Agusta A109 helicopter that occurred on June 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB DCA18WA223Accident · No injuriesForeign investigationMcdonnell Douglas MD80 · Zhuliany, UkraineThe government of Ukraine has notified the NTSB of an accident involving a MCDONNELL DOUGLAS MD80 airplane that occurred on June 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the…NTSB WPR18WA169Accident · Serious injuriesForeign investigationMD Helicopter 600 · Waiouru, New ZealandOn June 13, 2018, at 2048 Universal Coordinated time, an MD 600N helicopter, ZK-ILD crashed in a remote area for unknown reasons near Waiouru, New Zealand. The pilot and four passengers were seriously injured. The helicopter was substantially damaged. The…NTSB DCA18WA207Incident · No injuriesForeign investigationBoeing 737 · Otopeni, RomaniaThe Romania Civil Aviation Safety Investigation and Analysis Center has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB CEN18WA231Accident · 1 fatalForeign investigationAir Tractor AT802 · Mallorca, SpainOn June 12, 2018, about 1600 hours universal coordinated time, an Air Tractor AT-802 airplane, Spanish registration EC-GVN, was substantially damaged during an agricultural application flight near Mallorca, Spain. The pilot sustained fatal injuries. The local…NTSB DCA18CA219Accident · Serious injuriesData collectionFinal reportBoeing 787-9 · Harbin, Chinathe accidental tipping over of a beverage service cart, when there was no turbulence, which caused pots of hot water to burn two flight attendants.NTSB DCA21WA027IncidentClass 5 · ForeignBoeing 737 · Amsterdam, NetherlandsNTSB DCA18WA222Accident · No injuriesForeign investigationBoeing 737 800 · Crete, GreeceNTSB CEN18WA355Accident · Minor injuriesForeign investigationCessna R172 · Aude Fraisse-Cabardes, FranceThe government of France has notified the NTSB of an accident involving a Cessna R172 airplane that occurred on June 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…NTSB WPR18WA187Accident · 1 fatalForeign investigationCessna 172 · Moorabbin, AustraliaNTSB CEN18WA234Accident · 1 fatalForeign investigationPiper PA-25 · Cajeme, Sonora, MexicoOn June 7, 2018, a Mexican registered Piper PA-25, XB-YEI, impacted electrical cables and terrain near Cajeme, Sonora, Mexico. The pilot received fatal injuries. The airplane sustained substantial damage. The flight departed Cajeme, Mexico, on a local aerial…NTSB CEN18WA212Accident · No injuriesForeign investigationCessna 525 · La Môle, FranceOn June 6, 2018, about 1100 UTC, a Cessna 525A airplane, German registration D-IULI, had a runway excursion on landing at the La Môle – Saint-Tropez Airport (LFTZ), La Môle, France. Two of the three occupants inside the airplane sustained serious injuries.…NTSB WPR18WA165Accident · 10 fatalForeign investigationCessna 208 · Njabini, KenyaOn June 5, 2018, about 1705 local time, a Cessna 208, 5Y-CAC, collided into a mountain in the Aberdare mountain range near Njabini, Kenya. The 2 pilots and 8 passengers were fatally injured; the airplane was destroyed. The airplane was owned and operated by…NTSB ERA18WA159Accident · 3 fatalForeign investigationCessna 421B · Rock Sound, BahamasNTSB CEN18WA203Accident · 1 fatalForeign investigationPiper PA25 · Bosschenhoofd, NetherlandsOn May 31, 2018, a Piper PA-25-135 airplane (SE-KHF), crashed while attempting to pick up a banner near Bosschenhoofd, Netherlands. The pilot, who was the sole occupant, was fatally injured. This investigation is under the jurisdiction and control of the…NTSB WPR18WA208Incident · No injuriesForeign investigationPiper PA28 · Pretoria, South AfricaNTSB CEN18WA202Accident · 1 fatalForeign investigationBell Helicopter Textron Bell 206B · North Aldborough, United KingdomOn May 30, 2018, about 1225 coordinated universal time (UTC), a Bell 206B helicopter, registration G-OPEN, s/n 4300, impacted terrain and was destroyed near North Aldborough, North Yorkshire in the United Kingdom. The pilot was the sole occupant and was…NTSB ERA18WA212Accident · No injuriesForeign investigationCessna 172 · Macas, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on May 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…NTSB ERA18WA156Incident · No injuriesForeign investigationCessna 152 · Tulua, ColombiaThe government of Colombia has notified the NTSB of an accident involving a CESSNA 152 airplane that occurred on May 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions of…NTSB CEN18WA196Accident · 1 fatalForeign investigationAvid Avid Flyer · Granada, SpainOn May 26, 2018, at 1030 UTC, an Avid Flyer Stol, EC-YFP, encountered a loss of climb during initial climb out and subsequent impact with terrain near Loja Aerodrome, Granada, Spain. The experimental airplane was destroyed; the pilot suffered serious injuries…NTSB CEN18WA214Accident · 1 fatalForeign investigationBell 47 · Ciudad Valles, MexicoOn May 25, 2018, at 0030 hours universal coordinated time, a Scotts Bell 47 helicopter, Mexican registration XB-OSS, impacted terrain following a loss of engine power during an aerial application flight in San Luis Potosi, Mexico. The pilot was fatally…NTSB ENG18RA029Incident · No injuriesForeign investigationBoeing 767 · Kumamoto, Japan, JapanThe Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a B767-300 that occurred May 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO Annex 13…NTSB CEN18WA190Accident · 2 fatalForeign investigationReims F172N · Stolwijk, NetherlandsOn May 22, 2018, about 0930 UTC, a Reims Aviation, F172N airplane, PH-SBM, was destroyed when it impacted trees and terrain near Stolwijk, The Netherlands. The two pilots on board the airplane were fatally injured. The foreign, local personal flight departed…NTSB CEN18RA187Accident · Minor injuriesForeign investigationIsrael Aircraft Industries Gulfstream 200 · Tegucigalpa, HondurasimportNTSB DCA18RA186Accident · 112 fatalForeign investigationBoeing 737 · Havana, CubaThe government of Cuba has notified the NTSB of an accident involving a Boeing 737-200 that occurred on May 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Cuba's investigation under the provisions of ICAO Annex…NTSB ENG18WA034Accident · No injuriesForeign investigationSikorsky S76 · Valle Nuevo, Dominican RepublicNTSB ERA18WA151Accident · 2 fatalForeign investigationCessna 210 · Itacoatiara, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA 210 airplane that occurred on May 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ENG18WA027Incident · No injuriesForeign investigationBombardier CL600 2B19 · Geuteng, South Africa, South AfricaThe Government of South Africa has notified the NTSB of an incident involving a Bombardier CL-600-2B19 that occurred May 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the South African Civil Aviation Authority (CAA) investigation…NTSB ERA18WA147Accident · 4 fatalForeign investigationMaule M7 · Abayt, Saudi ArabiaThe government of Saudi Arabia has notified the NTSB of an accident involving a Maule, M-7-235C, airplane that occurred on May 15, 2018 near Abayt, Saudi Arabia. The NTSB has appointed a U.S. Accredited Representative to assist the government of Saudi…NTSB CEN18WA188Accident · 3 fatalForeign investigationCessna 208 · Tuzantan, MexicoOn May 15, 2018, about 1300 coordinated universal time, a Cessna 208 airplane, N149CD, crashed in jungle terrain under unknown circumstances near Tuzantan, Mexico. The three occupants were fatally injured. The flight departure and destination were unknown.…NTSB CEN18WA169Accident · 2 fatalForeign investigationCessna 208B · Clonbullogue, IrelandNTSB WPR18WA281Accident · No injuriesForeign investigationZenith CH610 HD · Germiston, South AfricaOn May 12, 2018, about 0730 Universal Coordinated time, a Zenith Zodiac CH 610 HD airplane, ZU-FFA, touched down and overturned about 100 meters short of runway 11 at Rand Airport, Germiston, South Africa, following a loss of engine power. The pilot sustained…NTSB CEN18WA289Accident · 3 fatalForeign investigationMooney M20K · Flix, SpainOn May 12, 2018, at 1340 universal coordinated time, a Mooney M20K airplane, D-ETFT, impacted terrain near Flix, Tarragona, Spain. The pilot and 2 passengers were fatally injured and the airplane was destroyed.The accident investigation is under the…NTSB CEN18WA191Accident · 3 fatalForeign investigationMooney M20K · Tarragona, PortugalOn May 12, 2018, about 1340 coordinated universal time, a Mooney M20K airplane, D-EFTF, impacted terrain near Tarragone, Portugal, after reporting an engine issue to air traffic control. The pilot and two passengers were fatally injured. The airplane was…NTSB ERA18WA153Accident · 1 fatalClass 5 · ForeignBell Helicopter 206 · Barra da Tijuca, BrazilNTSB CEN18WA166Accident · No injuriesForeign investigationAyres S2R · Morales, GuatemalaOn May 9, 2018, about 1415 coordinated universal time, an Ayres Thrush S2R-T34 airplane TG-FDM, was destroyed when it impacted terrain under unknown circumstances near the municipality of Morales in Izabal Department of Guatemala. The pilot was fatally…NTSB DCA18WA174Incident · No injuriesForeign investigationBoeing 737 · Arequipa, PeruThe government of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB ERA18WA166Accident · No injuriesForeign investigationPZL Swidnik SW4 · Curitibanos, BrazilThe government of Brazil has notified the NTSB of an accident involving a PZL Swidnik, SW4, helicopter that occurred on May 4, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB ERA18WA143Accident · 3 fatalForeign investigationCessna U206F · Trelawny, JamaicaThe government of Jamaica has notified the NTSB of an accident involving a CESSNA U206F airplane that occurred on May 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Jamaica's investigation under the provisions of…NTSB DCA18WA180Incident · No injuriesForeign investigationBoeing 737 · Port Elizabeth, South AfricaThe Civil Aviation Authority (CAA) of South Africa has informed the NTSB of an incident involving a Boeing 737-300, which occurred on May 4, 2018. The NTSB has appointed a U.S Accredited Representative to assist the CAA investigation under the provisions of…NTSB DCA18WA173Incident · No injuriesForeign investigationBoeing 767 323 · Guayaquil, EcuadorThe government of Ecuador has notified the NTSB of an incident involving a BOEING 767 323 airplane that occurred on May 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB ERA18WA139Accident · 2 fatalForeign investigationAgusta Bell AB206B · Cacao, French GuianaThe government of France has notified the NTSB of an accident involving a Agusta Bell AB206B helicopter that occurred on May 2, 2018 near Cacao, French Guiana. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's…NTSB DCA18WA171Incident · No injuriesForeign investigationBoeing 737 · Bangkok, ThailandThe Air Accident Investigation Committee of Thailand has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on May 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's…NTSB CEN18WA253Incident · No injuriesForeign investigationBeech 400 · Geneva, SwitzerlandOn May 2, 2018, about 1035 Universal Coordinated Time, a Beech 400, United Kingdom registration G-FXAR, experienced a cabin depressurization event and landed without further incident at the Geneva International Airport (LSGG), Geneva, Switzerland. There were…NTSB WPR18WA160Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Mabula, South AfricaOn May 1, 2018, at 0940 Universal Coordinated Time, a Robinson R44 Raven II helicopter, ZS-MZS, impacted an open field for unknown reasons near Mabula, South Africa. The pilot and one passenger were fatally injured. The helicopter was destroyed. The…NTSB ENG18WA041Incident · No injuriesForeign investigationBoeing 777 · Bangkok, ThailandThe Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving a Boeing 777-212 airplane on April 30, 2018. The NTSB has appointed an Accredited Representative in accordance with the provisions of ICAO Annex 13 as the…NTSB DCA18WA179Accident · No injuriesForeign investigationBoeing 737 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an accident involving a Boeing 737-800, which occurred on April 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…NTSB CEN18WA399Accident · Minor injuriesForeign investigationCessna 172 · Hamilton, BermudaOn April 30, 2018, about 2045 universal coordinated time (UTC), a Cessna 172 M airplane, N9085H, was substantially damaged during a landing at the L. F. Wade International Airport, near Hamilton, Bermuda. The pilot sustained minor injuries.The accident…NTSB WPR18WA138Accident · 2 fatalForeign investigationTaylorcraft BC12 · Vryheid, South AfricaOn April 29, 2018, at 1110 coordinated universal time, a Taylorcraft BC 12-D airplane, registration ZS-BLD, sustained substantial damage under unknown circumstances following a departure from Vryheid Aerodrome (FAVY), Kwa-Zulu Natal, South Africa. Both…NTSB DCA18WA160Incident · No injuriesForeign investigationBoeing 737 · Gorontalo, IndonesiaThe National Transportation Safety Committee of Indonesia has notified the NTSB of an incident involving a Boeing 737, which occurred on April 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the…