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 ENG20WA036Accident · No injuriesClass 5 · ForeignDornier 228 · North Brabant, NetherlandsNTSB DCA20WA112Incident · No injuriesForeign investigationMcdonnell Douglas MD11 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an accident involving a Boeing MD11 airplane that occurred on June 03, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13.All…NTSB CEN21WA076Accident · Serious injuriesClass 5 · ForeignCessna T303 · Annecy Meythetf, FranceNTSB WPR20WA114Accident · 8 fatalForeign investigationIsrael Aircraft Industries 1124A · Manilla, PhilippinesThe government of the Philippines has notified the NTSB of an accident involving an Israel Aircraft Industries 1124A airplane that occurred on March 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of the…NTSB ERA20WA193Accident · 2 fatalClass 3 · ForeignCessna 525 · El Yaque, VenezuelaNTSB DCA20RA069Accident · 3 fatalForeign investigationBoeing 737 · Istanbul, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 05, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions…NTSB DCA20WA054Incident · No injuriesForeign investigationBoeing 737 · Halifax, CanadaThe government of Canada has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on January 05, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB DCA19WA177Incident · No injuriesForeign investigationBoeing 737 · Kiev, UkraineThe NBAAI of Ukraine has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 12, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the NBAAI's investigation under the provisions of ICAO Annex 13 as…NTSB DCA19WA176Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe AAIB of India has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as State of…NTSB DCA19WA180Incident · No injuriesForeign investigationBoeing 737 · Mangalore, IndiaThe AAIB of India has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on June 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO Annex 13 as State of…NTSB DCA19WA163Accident · No injuriesForeign investigationCasa C212 · Kuinga, KenyaThe Ministry of Transport of the Republic of Kenya has notified the NTSB of an accident involving a CASA 212, which occurred on June 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under the provisions of ICAO…NTSB DCA19WA145Incident · No injuriesForeign investigationBoeing 737 · Bogota, ColombiaThe GRIAA of Colombia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on April 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA's investigation under the provisions of ICAO Annex 13 as…NTSB DCA19WA131Incident · No injuriesForeign investigationBoeing 737 · Jogyakarta, IndonesiaThe KNKT of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on March 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation under the provisions of ICAO Annex 13 as…NTSB DCA19WA108Incident · No injuriesForeign investigationBoeing 767 · Halifax, CanadaThe government of Canada has notified the NTSB of an accident involving a BOEING 767 airplane that occurred on March 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB DCA19WA087Incident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaThe National Transportation Safety Committee of Indonesia (KNKT) has notified the NTSB of an incident involving a Boeing 737, which occurred on February 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…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…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…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…NTSB DCA19WA021Accident · No injuriesForeign investigationBoeing 747 · Halifax, CanadaNTSB 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…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…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…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…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…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…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…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…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…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…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…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 CEN18RA187Accident · Minor injuriesForeign investigationIsrael Aircraft Industries Gulfstream 200 · Tegucigalpa, HondurasimportNTSB 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…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…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…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…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…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…NTSB WPR18WA086Incident · No injuriesForeign investigationHawker Beechcraft 390 · Germiston, South AfricaOn November 22, 2017, at 1423 coordinated universal time, a Hawker Premier Jet airplane, registration ZS-CBI, sustained minor damage during a runway excursion at Rand Airport (FAGM), Germiston, South Africa. The pilot and passenger were not injured. The…NTSB DCA18WA038Incident · No injuriesForeign investigationBoeing 737 · Foz do Iguacu County, BrazilThe government of Brazil has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on November 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB DCA18WA025Incident · No injuriesForeign investigationBoeing 737 · Singapore, SingaporeThe TSIB of Singapore has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSIB's investigation under the provisions of ICAO Annex 13 as…NTSB DCA18WA030Incident · No injuriesForeign investigationBoeing 747 · Maastricht, NetherlandsThe Dutch Safety Board has notified the NTSB of an incident involving a Boeing 747, which occurred on November 11, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of Manufacture and…NTSB ENG18RA002Accident · Minor injuriesForeign investigationSwearingen SA227 · Thompson, CanadaThe Transportation Safety Board of Canada has notified the NTSB of an accident involving a Fairchild SA227-AC airplane which occurred on November 3, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…NTSB CEN18WA022Accident · No injuriesForeign investigationCessna 550 · Bremen, GermanyOn October 29, 2017, about 1740 UTC, a Cessna 550/551 SP airplane, Russian Federation / RA-67560, was involved in a runway excursion at the Bremen Airport (EDDW), Bremen, Germany. Damage to the airplane was not yet known. The three crewmembers and two…NTSB ERA17WA331Accident · Minor injuriesForeign investigationCessna 650 · Istanbul, TürkiyeOn September 21, 2017, at 1820 universal coordinated time, a Cessna 650 (Citation III), Turkish registration TC-KON, operated by Avione Jet, was destroyed by postimpact fire after a runway excursion at Istanbul Atatürk Airport, Istanbul, Turkey (LTBA). The…NTSB DCA17WA201Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe government of India Ministry of Civil Aviation Aircraft Accident Investigation Bureau (AAIB) has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on September 19, 2017. The NTSB has appointed a U.S. Accredited…NTSB DCA17WA204Incident · No injuriesForeign investigationBoeing 737 · Aqaba, JordanThe Jordan Civil Aviation Regulatory Commission (CARC) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Jordan's…NTSB DCA17WA229Incident · No injuriesForeign investigationBoeing 737 · Conakry, GuineaThe government of Guinea has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guinea's investigation under the provisions…NTSB CEN17WA291Incident · No injuriesForeign investigationCessna 402 · British Virgin Islands, British Virgin IslandsOn July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…NTSB DCA17WA156Incident · No injuriesForeign investigationBoeing 737 · Bucharest, RomaniaThe Civil Aviation Safety Investigation and Analysis Center (CASIAC) of Romania has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…