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.
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
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 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB DCA16WA240Accident · No injuriesForeign investigationCessna 401 · Antalaha, MadagascarNTSB 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…NTSB 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…NTSB 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 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 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 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 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB ERA16WA020Accident · No injuriesForeign investigationLearjet 35A · Buenos Aires, ArgentinaNTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB DCA14WA020Accident · No injuriesForeign investigationBoeing 747 · Abuja, NigeriaNTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB ERA13WA334Accident · 3 fatalForeign investigationBeech 58 · Manaus, BrazilNTSB DCA13WA123Incident · No injuriesClass 5 · ForeignEmbraer 145 · Shanghai, ChinaNTSB 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…NTSB 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…