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 DCA13WA007Accident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaOn October 19, 2012, Sriwijaya Air flight SJ182, a Boeing 737-4Q8, registration PK-CKN (msn 26281 built 1992), sustained damage after it overran the runway on landing at Supadio Airport, Pontianak, Indonesia, and reportedly suffered a nose undercarriage…NTSB DCA12RA110Accident · 3 fatalForeign investigationGulfstream GIV · Le Castellet, FranceNTSB DCA12WA099Incident · No injuriesForeign investigationBoeing 737 · Taoyuan, TaiwanThe Taiwan Aviation Safety Council (ASC) has notified the NTSB of an accident involving a Boeing 737 that occurred on June 20th, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO Annex…NTSB DCA12WA083Accident · No injuriesForeign investigationBoeing 727 - 221F · Accra, GhanaThe Ghana Civil Aviation Authority (GCAA) has notified the NTSB of an accident involving a B727 that occurred on June 2, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO Annex 13 as…NTSB DCA12WA093Accident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaThe Indonesian National Transportation Safety Committee (NTSC) has notified the NTSB of an accident involving a Boeing 737-400 that occurred on June 1, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation under the…NTSB WPR12WA335Accident · No injuriesForeign investigationHawker Beechcraft G58 · Auckland, New ZealandNTSB DCA12WA019Accident · No injuriesForeign investigationGulfstream American G 1159 · Huambo, AngolaOn November 26, 2011, about 1300 UTC, N811DE, a Grumman G-1159 Gulfstream G-II, a private flight operated by Wings Over Africa, was involved in a runway excursion following a rejected takeoff. None of the 10 persons aboard were injured. The aircraft was…NTSB DCA12WA011Incident · No injuriesForeign investigationBoeing 777 · Munich, GermanyOn November 3, 2011, at about 1210 local time (1110 UTC), a Boeing 777-300, 9V-SWQ, experienced a runway excursion upon landing on runway 08R at Franz Joseph Strauss Munich Airport (EDDM), Munich, Germany. None of the 143 passengers or 15 crewmembers were…NTSB ERA11WA518Accident · No injuriesForeign investigationGates Lear Jet 35 · Valencia, Carabobo, VenezuelaOn September 17, 2011, about 2135 universal coordinated time, a Gates Lear Jet 35, N535LC, was substantially damaged while landing at the Arturo Michelena Airport (SVVA), Valencia, Carabobo, Venezuela. The two pilots and five passengers were not injured. The…NTSB DCA11RA100Accident · Serious injuriesForeign investigationEmbraer E190 · Quito, EcuadorOn September 16, 2011, an Ecuadoran Embraer EMB-190, registration HC-CEZ, overran runway 35 while landing at Quito, Ecuador. The airplane was substantially damaged and there were 5 serious injuries among the 97 passengers and 5 crew. The investigation is…NTSB CEN11WA628Accident · No injuriesForeign investigationEmbraer EMB-145LR · Ottawa, CanadaNTSB DCA11RA092Accident · Serious injuriesForeign investigationBoeing 737 · Georgetown, GuyanaOn July 30, 2011, at 1:25 am local time (0525 UTC), a Boeing 737-800, Trinidad & Tobago registration 9Y-PBM, operated by Caribbean Airlines as flight 523, overran the runway upon landing at Cheddi Jagan International Airport, Georgetown, Guyana. Of the 156…NTSB DCA11WA120Incident · No injuriesForeign investigationCessna 560 - XL · Port Harcout, NigeriaOn July 14, 2011 about 1853 UTC, 5N-BMM, Cessna 560XLS, operated by Bristow Helicopters Limited, was involved in a runway excursion while landing at Port Harcourt, Nigeria. There was no injuries to the six persons on board. The aircraft received minor damage.…NTSB DCA11WA061Incident · No injuriesForeign investigationBoeing MD-90 · Tao-Yuan, TaiwanThe Taiwan Aviation Safety Council (ASC) has notified the NTSB of an incident involving an MD-90 that occurred on May 12, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of ICAO Annex 13 as…NTSB DCA11WA068Incident · No injuriesForeign investigationBombardier BD-100-1A10 · Iqaluit, CanadaOn March 12, 2011, a Bombardier BD100, registration N818RC, operated by Tri Marine Logistics, departed the runway to the right while landing on runway 35 at Iqaluit Airport (CYFB), Iqaluit, Nunavut, Canada. The airplane stopped about 100 feet from the edge of…NTSB DCA11WA067Incident · No injuriesForeign investigationBoeing 747 · Medina, Saudi ArabiaOn December 12, 2010, a Boeing 747-400, Saudi registration HZ-AWA1, serial number 27672, operated by Alwafeer Air as flight 1336, exited the left side of the runway after landing at Prince Mohammed Airport, Medina, Saudi Arabia. Two of the right hand main…NTSB DCA11WA010Incident · No injuriesForeign investigationBoeing 737-823 · Montreal, CanadaOn November 30, 2010, American Airlines flight AAL802, a Boeing 737-800, N901AN, departed the left side of runway 24R and stopped in the grass approximately 6600 feet down the runway while completing its landing roll at Montreal Pierre Elliott Trudeau…NTSB DCA10WA093Incident · No injuriesForeign investigationBoeing 747 · Taipei, TaiwanOn September 2, 2010, at 1337 UTC, an Eva Airways Boeing 747-400 ran off the edge of runway 24 upon landing at Tao Yuan International Airport, Taipei, Taiwan. The aircraft was registered in Taiwan a B-16410 and was on a scheduled passenger flight from Poo…NTSB DCA10RA069Accident · Minor injuriesForeign investigationEmbraer EMB-145LR · Ottawa, CanadaNTSB ERA10WA514Accident · No injuriesForeign investigationPiper PA42 · Jundiaí, BrazilOn May 20, 2010, about 1935 universal coordinated time (1735 local time), a Piper PA-42-1000, N313PC, was substantially damaged during a runway excursion after the application of reverse thrust during landing at Rolim Adolfo Amaro Airport (SBJD), Jundiai,…