NTSB investigations, Outside the U.S.

220 cases where the defining event was Runway excursion.

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'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '300')
  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.

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…Jul 21, 2017 · C-FWGHNTSB DCA17WA166Incident · No injuriesForeign investigationBoeing 747-87UF · Narita, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 747-87UF airplane that occurred on July 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…Jul 15, 2017 · N852GT · Minor damageNTSB DCA17WA149Incident · No injuriesForeign investigationBoeing 737 · Helsinki, FinlandThe government of Finland has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Finland's investigation under the provisions of…Jul 11, 2017 · LN-NHF · Minor damageNTSB DCA17WA141Incident · No injuriesForeign investigationBoeing 737 · Jakarta, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the provisions…Jun 13, 2017 · 9M-MXH · Minor damageNTSB DCA17WA106Accident · No injuriesForeign investigationBoeing 737 · Keflavik, IcelandThe AAIB of Iceland has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on April 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of Iceland's investigation under the provisions of ICAO Annex…Apr 28, 2017 · YL-PSH · Minor damageNTSB DCA17WA105Accident · No injuriesForeign investigationBoeing 737 · Sibu Warawak, MalaysiaThe Malaysian Department of Civil Aviation (DCA) has notified the NTSB of an accident involving a Boeing 737, which occurred on April 8, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DCA investigation under the provisions of ICAO…Apr 8, 2017 · 9M-MXX · Substantial damageNTSB DCA17WA221Incident · No injuriesForeign investigationBoeing 737 · Riga, LatviaThe Transport Accident and Incident Investigation Bureau of Latvia has notified the NTSB of an incident involving a Boeing 737, which occurred on February 17, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…Feb 17, 2017 · VP-BVS · No damageNTSB DCA17WA069Incident · No injuriesForeign investigationBoeing 737 · Yogykarta, IndonesiaThe National Transportation Safety Committee (NTSC) of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC's…Feb 1, 2017 · PK-GNK · No damageNTSB DCA17WA061Accident · No injuriesForeign investigationBoeing 737 · Leticia, ColombiaThe Civil Aviation Authority (CAA) of Colombia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on January 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation…Jan 28, 2017 · HK-5197 · Substantial damageNTSB DCA17WA066Incident · No injuriesForeign investigationAvro 146 · Darlot, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an accident involving a AVRO RJ146 airplane equipped with Lycoming LF507 engines that occurred on January 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…Jan 20, 2017 · UNK · Minor damageNTSB DCA17WA044Accident · 3 fatalForeign investigationBoeing 727 · Puerto Carreno, ColombiaThe Accident Investigation Group (AIG) of Colombia has notified the NTSB of an accident involving a Boeing 727 airplane that occurred on December 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AIG of Colombia's investigation…Dec 20, 2016 · HK4544 · DestroyedNTSB DCA17WA045Incident · No injuriesForeign investigationBoeing 737 · Darwin, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 06, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the…Dec 6, 2016 · VH-VUI · Minor damageNTSB CEN17WA040Incident · No injuriesForeign investigationBombardier BD 100-1A10 · Albrook, PanamaOn November 14, 2016, about 1630 eastern standard time, a Bombardier BD-100-1A10, N303CZ, experienced a runway excursion while landing at Albrook-Marcos A. Gelabert International Airport (MPMG), Panama City, Panama. The airplane was registered to Delaware…Nov 14, 2016 · N303CZ · Minor damageNTSB WPR17WA095Incident · No injuriesForeign investigationCessna 500 · Banswara, IndiaOn October 27, 2016, at 0745 universal coordinated time (1315 local time), a Cessna 500 SII Citation, VT-KMB, sustained minor damage following a runway excursion in Banswara, India. The airplane was operated under the pertinent regulations of the Government…Oct 27, 2016 · VH-KMB · Minor damageNTSB DCA16WA233Accident · No injuriesForeign investigationBeech 1900 · Mavivi, Congo - KinshasaThe government of Congo has notified the NTSB of an accident involving a BEECH 1900 airplane that occurred on September 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Congo's investigation under the provisions of…Sep 29, 2016 · ZS-PZE · Substantial damageNTSB ENG16RA042Accident · No injuriesForeign investigationBAE JETSTREAM4100 · Siddharthanagar, NepalThe Government of Nepal Ministry of Culture, Tourism and Civil Aviation has notified the NTSB of an accident involving a BAE Systems (Operations) Limited Jetstream 41 which occurred on September 24, 2016. The NTSB has appointed a U.S. Accredited…Sep 24, 2016 · 9N-AIB · Substantial damageNTSB CEN16WA396Incident · No injuriesForeign investigationSwearingen SA227 · Cologne, GermanyOn September 20, 2016, at 1725 UTC, a Fairchild Swearingen Corporation SA-227-AC Metroliner, German registration D-CPSW, owned and operated by BINAIR Aero, sustained minor damage when the airplane veered off the runway while landing at the Cologne/Bonn…Sep 20, 2016 · D-CPSW · Minor damageNTSB ERA16WA310Accident · No injuriesForeign investigationLearjet 55 · Eleuthera, BahamasOn August 25, 2016, about 1903 universal coordinated time, a Learjet 55, N666TK, operated by RCR7 LLC, was substantially damaged during a runway excursion following an aborted takeoff at North Eleuthera Airport, Eleuthera, Bahamas. The two pilots and seven…Aug 25, 2016 · N666TK · Substantial damageNTSB DCA16WA240Accident · No injuriesForeign investigationCessna 401 · Antalaha, MadagascarAug 16, 2016 · 5R-MEK · Substantial damageNTSB DCA16WA210Accident · No injuriesForeign investigationBoeing 737 · Bergamo, ItalyThe Agenzia Nazionale per la sicurezza del volo (ANSV) of Italy has notified the NTSB of an accident involving a Boeing 737 that occurred on August 05, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV's investigation under the…Aug 5, 2016 · HA-FAX · Substantial damageNTSB ERA16WA340Accident · Minor injuriesForeign investigationCessna 172 · Valday-avia, RussiaOn July 16, 2016, about 1024 universal coordinated time, a Cessna 172K, Russian registration RA-67480, was substantially damaged when it experienced a runway excursion during takeoff from Valday-Avia Airfield, Valday, Novgorod, Russia. The pilot and two…Jul 16, 2016 · RA-67480 · Substantial damageNTSB 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…May 12, 2016 · YV589T · Substantial damageNTSB 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…May 3, 2016 · EI-CXVNTSB 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…May 2, 2016 · TC-JFY · No damageNTSB 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…Apr 28, 2016 · HC-COX · Substantial damageNTSB 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…Apr 27, 2016 · B-2117 · Minor damageNTSB 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…Mar 28, 2016 · EC-MGE · No damageNTSB DCA16WA140Accident · No injuriesForeign investigationFairchild SA227 · Tierra del Fuego, ArgentinaThe Argentina Junta de Investigacion de Acidentes de Aviacion Civil (JIAAC) has notified the NTSB of an accident involving a Fairchild SA-226 that occurred on March 22, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the JIAAC…Mar 22, 2016 · LV-ZEB · Substantial damageNTSB DCA16WA115Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe government of Peru has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on March 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…Mar 20, 2016 · OB-2041P · Minor damageNTSB DCA16WA102Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaThe government of Indonesia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Indonesia's investigation under the…Feb 20, 2016 · PK-LFG · No damageNTSB DCA16WA098Incident · No injuriesForeign investigationBoeing 737 · Iquitos, PeruThe Peru Comisión de Investigación de Accidentes de Aviación (CIAA) has notified the NTSB of an incident involving a BOEING 737-300 that occurred on February 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA investigation…Feb 11, 2016 · OB-2037P · No damageNTSB DCA16WA095Incident · No injuriesForeign investigationBoeing 737 · Kiev, UkraineThe National Bureau of Air Accident Investigation (NBAAI) of Ukraine has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on January 16, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the NBAAI's…Jan 16, 2016 · UR-GBA · Minor damageNTSB DCA16WA042Incident · No injuriesForeign investigationBoeing 737 · Cluj-Napoca, RomaniaThe government of Romania has notified the NTSB of an incident involving a Boeing B737-400 airplane that occurred on January 07, 2016. The NTSB has appointed a U.S. Accreditd Representative to assist the government of Romania's investigation under the…Jan 7, 2016 · YR-BASNTSB CEN16WA075Accident · No injuriesForeign investigationLearjet 60 · Zihuatanejo, MexicoThe Direccion General de Aeronutica Civil (DGAC) of Mexico has notified the NTSB of an fatal accident involving a LearJet 60, XA-UQP, that occurred on November 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC under the…Nov 16, 2015 · XA-UQP · Substantial damageNTSB DCA16WA017Incident · No injuriesForeign investigationMcdonnell Douglas DC 9 82(MD-82) · San Luis Potosi, MexicoThe Dirección General de Aeronáutica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a McDonnell Douglas DC-9-82, which occurred on November 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC…Nov 2, 2015 · N73444 · Minor damageNTSB ERA16WA020Accident · No injuriesForeign investigationLearjet 35A · Buenos Aires, ArgentinaOct 19, 2015 · LV-ZSZ · DestroyedNTSB DCA15WA209Incident · No injuriesForeign investigationBoeing 737 · Monterrey, MexicoThe government of Mexico has notified the NTSB of an incident involving a Boeing 737 that occurred on July 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of ICAO Annex…Jul 23, 2015 · XA-UTENTSB ANC15RA074Accident · No injuriesForeign investigationCessna 525 · Okayama Preffecture, JapanOn June 23, 2015, a privately owned Cessna 525A, registered JA021R, took off from Tokyo International Airport at about 14:41 (JST: UTC+9hrs) and landed at Kohnan Aerodrome in Okayama prefecture at about 15:46. The landing ended up a runway overrun. It rested…Jun 10, 2015 · JA021R · Substantial damageNTSB DCA15WA127Incident · No injuriesForeign investigationBoeing 737 - 883 · Oslo, NorwayThe Accident Investigation Board Norway (AIBN) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on May 27, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AIBN investigation under the provisions of…May 25, 2015 · LN-RCZ · No damageNTSB DCA14WA115Accident · Minor injuriesForeign investigationBoeing 737-400 · Kabul, AfghanistanThe Afghanistan Civil Aviation Authority (ACAA) has notified the NTSB of an accident involving a Boeing 737-400 that occurred on May 8, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the ACAA investigation under the provisions of ICAO…May 8, 2014 · YA-PIB · Substantial damageNTSB DCA14WA050Incident · No injuriesForeign investigationFairchild Industries SA226-TC · Archerfield, AustraliaOn January 23, 2014, a Fairchild Industries SA226-TC, registration number VH-OGX, experienced a runway excursion following landing at the Archerfield Airport (YBAF), Archerfield, Queensland, Australia. The airplane sustained minor damage and there were no…Jan 23, 2014 · VH-OGX · No damageNTSB DCA14WA020Accident · No injuriesForeign investigationBoeing 747 · Abuja, NigeriaDec 4, 2013 · EK-74798 · Substantial damageNTSB DCA14WA013Accident · No injuriesForeign investigationEmbraer ERJ190 - Undesignat · Buenos Aires, ArgentinaThe Junta de Investigaciones de Accidentes de Aviacion Civil (JIAAC) of the Republic of Argentina has notified the NTSB of an accident involving an Embraer E-190, which occurred on November 15, 2013. The NTSB has appointed a U.S. Accredited Representative to…Nov 15, 2013 · LV-CKZNTSB CEN14WA083Accident · No injuriesForeign investigationRockwell Commander · Stockholm, Sweden, SwedenOn October 4, 2013, about 1250 UTC, a Rockwell Commander 112, SE-FLS (s/n 350) was involved in a runway excursion after landing when the pilot was unable to maintain directional control during roll out. The airplane was substantially damaged and there were no…Oct 4, 2013 · SE-FLS · Substantial damageNTSB DCA13WA137Accident · No injuriesForeign investigationFairchild SA227 · Sucre, BoliviaThe Direccion General De Aeronautica Civil (DGAC) has notified the NTSB of an incident involving a Fairchild SA227-DC, registration CP-2655, which occurred on August 20, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC…Aug 20, 2013 · CP-2655 · Substantial damageNTSB DCA13WA135Accident · No injuriesForeign investigationBoeing 737 · Surat Thani, ThailandThe Thailand Civil Aviation Authority (TCAA) has notified the NTSB of an accident involving a Boeing 737-300 airplane that occurred on July 31, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the TCAA's investigation under the…Jul 31, 2013 · HS-BRA · Substantial damageNTSB ERA13WA334Accident · 3 fatalForeign investigationBeech 58 · Manaus, BrazilJul 16, 2013 · PR-OKK · Substantial damageNTSB DCA13WA123Incident · No injuriesClass 5 · ForeignEmbraer 145 · Shanghai, ChinaJun 7, 2013 · B-3052 · Minor damageNTSB DCA13WA069Incident · No injuriesForeign investigationBoeing 727 · Porto Velho, BrazilThe Aeronautical Accident Prevention and Investigation Center (CENIPA) of Brazil has notified the NTSB of an accident involving a Boeing 727 that occurred on March 05, 2013. The NTSB has appointed a U.S. Accredited Representative to assist CENIPA's…Mar 5, 2013 · PR-IOD · No damageNTSB DCA13WA033Incident · No injuriesForeign investigationBoeing 737 · Shonai, JapanOn 8 December 2012, at approximately 1326 UTC (2236 local time), a Boeing 737-800, registration JA57AN, operated by All Nippon Airways, overran the runway after landing at Shonai Airport (RJSY), Yamagata, Japan, and came to rest in the grass area past the end…Dec 8, 2012 · JA57AN · No damage