Skip to content

NTSB investigations, 2018, Outside the U.S.

23 cases where the sequence of events included Runway excursion.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Latest cases

Query with SQL

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 year(c."eventDate") = 2018 AND c."eventCountry" <> 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 year(c.\"eventDate\") = 2018
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 year(c."eventDate") = 2018
  AND c."eventCountry" <> 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
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 DCA19WA028Incident · No injuriesForeign investigationBoeing 737 · Manaus, BrazilThe government of Brazil has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Nov 28, 2018 · YV-2937 · Minor damage NTSB DCA19WA068Incident · No injuriesForeign investigationBoeing 737 · Yogyakarta, IndonesiaThe National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an incident involving a Boeing 737, which occurred on November 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…Nov 25, 2018 · PK-GFY · No damage NTSB DCA19RA025Accident · No injuriesForeign investigationBoeing 757 · Georgetown, GuyanaThe Guyana Civil Aviation Authority (GCAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 9, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO…Nov 9, 2018 · N524AT NTSB DCA19WA021Accident · No injuriesForeign investigationBoeing 747 · Halifax, CanadaNov 7, 2018 · N908AR · Substantial damage NTSB CEN19WA010Accident · 3 fatalForeign investigationCessna F172 · Wasserkuppe, GermanyOn October 14, 2018, about 1345 coordinated universal time, a Cessna F172N, D-EFJX, experienced a runway excursion during landing which resulted in 3 ground fatalities.This investigation is under the jurisdiction and control of the German Federal Bureau of…Oct 14, 2018 · D-EFJX · Substantial damage NTSB DCA19WA083Incident · No injuriesForeign investigationBoeing 747 · Bangkok, ThailandThe government of Thailand has notified the NTSB of an accident involving a BOEING 747 airplane that occurred on October 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's investigation under the…Oct 8, 2018 · HS-TGF · Minor damage NTSB ENG18WA037Accident · No injuriesForeign investigationHonda HA-420 · Foz do Iguacu, BrazilThe government of Brazil has notified the NTSB of an accident involving a Honda HA-420, which occurred on September 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Sep 24, 2018 · PR-TLZ · Substantial damage NTSB WPR18WA277Incident · No injuriesForeign investigationGulfstream GIV · Abuja, NigeriaOn September 12, 2018, at 2110 coordinated universal time, a Gulfstream GIV airplane, registration 5N-BOD, was not damaged during a runway excursion at Nnamdi Akizkiwe International Airport (DNAA), Abuja, Nigeria. The flight crew and passenger were not…Sep 12, 2018 · 5N-BOD · No damage NTSB DCA18WA277Accident · Minor injuriesForeign investigationBoeing 737 · Sochi, RussiaThe Interstate Aviation Committee (MAK) of Russia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the MAK of Russia's investigation…Sep 1, 2018 · VQ-BJI · Substantial damage NTSB CEN18WA396Accident · No injuriesForeign investigationAero Designs Pulsar · Heapham, United KingdomOn August 31, 2018, about 1700 coordinated universal time (UTC), an amateur-built Aero Designs Pulsar 1 airplane, United Kingdom registration G-LUED, serial number PFA 202-12122, was substantially damaged when it nosed-over after it overran the runway while…Aug 31, 2018 · G-LUED NTSB DCA18WA268Accident · No injuriesForeign investigationBoeing 737 · Manila, PhilippinesThe CAA of the Philippines has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CAA's investigation under the provisions of ICAO Annex 13…Aug 16, 2018 · B-5498 · Minor damage NTSB DCA18WA258Incident · No injuriesForeign investigationBoeing 737 · Pardubice, CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…Aug 1, 2018 · N624XA · No damage NTSB DCA18WA245Accident · Minor injuriesForeign investigationDouglas DC3 · Guainia, ColombiaThe government of Colombia has notified the NTSB of an accident involving a DOUGLAS DC3 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…Jul 11, 2018 · HK3293 · Substantial damage NTSB DCA18WA241Incident · No injuriesForeign investigationBoeing 737 · Djerba, TunisiaThe government of Tunisia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the provisions of…Jul 11, 2018 · LY-GGC · No damage NTSB ENG18WA042Incident · No injuriesForeign investigationHonda HA-420 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau (AIB) of the Kingdom of Saudi Arabia has notified the NTSB of an incident involving a Honda HA-420, which occurred on July 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation…Jul 10, 2018 · VP-CEF · Minor damage 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.…Jun 6, 2018 · DIULI · Substantial damage NTSB CEN18RA187Accident · Minor injuriesForeign investigationIsrael Aircraft Industries Gulfstream 200 · Tegucigalpa, HondurasimportMay 22, 2018 · N813WM · Substantial damage 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…Apr 29, 2018 · PK-LOO · Minor damage NTSB 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…Mar 31, 2018 · F-GIKQ · Substantial damage 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…Mar 4, 2018 · YV3158 · Minor damage NTSB DCA18WA226Accident · No injuriesForeign investigationMcdonnell Douglas MD83 · Omagwa, NigeriaThe Accident Investigation Bureau (AIB) of Nigeria has notified the NTSB of an accident involving a McDonnel Douglas MD-83, which occurred on February 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation under the…Feb 20, 2018 · 5N-SRI · Minor damage NTSB WPR18WA083Accident · No injuriesForeign investigationGulfstream GULFSTREAM200 · Abuja, NigeriaOn January 25, 2018, at 1818 Universal Coordinated Time (UTC), a Nigerian registered Gulfstream G-200, 5N-BTF experienced a runway excursion during the landing rollout at Nnamdi Azikiwe International Airport (DNAA), Abuja, Nigeria. The airplane departed the…Jan 25, 2018 · 5N-BTF NTSB WPR18WA068Accident · No injuriesForeign investigationGulfstream GULFSTREAM200 · Albay, PhilippinesJanuary 10, 2018, at 1132 local time, a Gulfstream 200, RP-C280, was substantially damaged while landing at the Legazpi City Airport, Lagazpi, Albay, Philippines. The airplane was owned by the Asian Aerospace Corporation and operated under the pertinent civil…Jan 10, 2018 · RP-C280 · Substantial damage