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 GAA24WA008AccidentClass 4 · ForeignLearjet 45 · Veracruz, MexicoOct 4, 2023 · XA-JAONTSB DCA23WA453IncidentClass 5 · ForeignBoeing 777 · Thalang - Phuket, ThailandSep 15, 2023 · RA--73141 · Minor damageNTSB GAA23WA241AccidentClass 5 · ForeignCessna 208 · Limpopo Province, South AfricaAug 7, 2023 · ZS-JEM · Minor damageNTSB DCA23WA398Incident · No injuriesClass 5 · ForeignBoeing 747-481F · Ningbo, ChinaAug 7, 2023 · N401KZ · No damageNTSB DCA23WA345OccurrenceClass 5 · ForeignBoeing 777 · Dhaka, BangladeshJun 28, 2023 · HZ-AK28 · No damageNTSB GAA23WA167Accident · No injuriesClass 5 · ForeignSocata TBM 700 · Narsarsuaq, GreenlandJun 17, 2023 · N44WN · Substantial damageNTSB DCA23WA317IncidentClass 5 · ForeignBoeing 737 · Perth Airport, AustraliaJun 11, 2023 · VH-IWQ · No damageNTSB DCA23WA325IncidentClass 5 · ForeignBoeing 747 · Bangkok, ThailandMay 29, 2023 · B-2425 · Minor damageNTSB DCA23WA367Incident · No injuriesClass 5 · ForeignEmbraer 195 · Salvador, BrazilMay 10, 2023 · PS-AED · Minor damageNTSB GAA23WA144AccidentClass 5 · ForeignBeechcraft C90 · Bareilly, IndiaMay 2, 2023 · VT-RSL · Substantial damageNTSB DCA23WA204Incident · No injuriesClass 5 · ForeignBombardier BD500 · Riga, LatviaMar 8, 2023 · YL-AAPNTSB GAA23WA088AccidentClass 5 · ForeignCessna 337G · Itzehoe, GermanyFeb 28, 2023 · N337BQ · Substantial damageNTSB GAA23WA064Accident · No injuriesClass 5 · ForeignLearjet 60 · Buenos Aires, ArgentinaFeb 2, 2023 · LV-JJQ · Substantial damageNTSB DCA23WA143IncidentClass 5 · ForeignBoeing 777-319ER · Auckland, New ZealandJan 27, 2023 · ZK-OKN · Minor damageNTSB DCA23WA127IncidentClass 5 · ForeignAirbus A330-323 · Amsterdam, NetherlandsJan 12, 2023 · N802NW · Minor damageNTSB GAA23WA094Accident · No injuriesClass 5 · ForeignMooney M20R · Vélez-Málaga, SpainDec 20, 2022 · N78VE · Substantial damageNTSB DCA23WA474OccurrenceClass 5 · ForeignBoeing 737 · Dortmund, GermanyDec 5, 2022 · EI-DLV · No damageNTSB DCA23WA091AccidentClass 5 · ForeignBoeing 737 · Dortmund, GermanyDec 5, 2022 · EI-DLV · Substantial damageNTSB DCA23WA088IncidentClass 5 · ForeignBoeing 737 · Brisbane, AustraliaNov 30, 2022 · VH-YFKNTSB DCA23WA075Incident · No injuriesClass 5 · ForeignBoeing 737 · Breslau, CanadaNov 25, 2022 · C-FFLC · No damageNTSB DCA23WA031Incident · No injuriesClass 5 · ForeignEmbraer EMB145 · Paris, FranceOct 20, 2022 · F-HYOG · Minor damageNTSB GAA23WA007Accident · 1 fatalClass 3 · ForeignCirrus SF50 · Santa Marta, ColombiaOct 16, 2022 · HK-5342 · Substantial damageNTSB GAA23WA006Incident · No injuriesClass 5 · ForeignLearjet 45 · Sao Paulo, BrazilOct 9, 2022 · PP-MIX · Minor damageNTSB DCA22WA213Incident · No injuriesClass 5 · ForeignBoeing 737 · Panama City, PanamaSep 25, 2022 · HP-1539 CMP · Substantial damageNTSB DCA22WA209Accident · Minor injuriesClass 4 · ForeignBoeing 737 · Montpellier, FranceSep 24, 2022 · EC-NLSNTSB DCA22WA208Accident · 1 fatalClass 5 · ForeignBAE 3201EP · San Antonio del Estrecho, PeruSep 20, 2022 · OB-2152 · DestroyedNTSB GAA22WA297AccidentClass 5 · ForeignDan Hawken Titan T-51 · Soest, GermanySep 17, 2022 · N132MK · Substantial damageNTSB DCA22WA164Accident · No injuriesClass 5 · ForeignBoeing 737-800 · Chiang Rai, ThailandJul 30, 2022 · HS-DBR · Substantial damageNTSB GAA22WA236Accident · No injuriesClass 3 · ForeignGulfstream GIV · Jeddah, Saudi ArabiaJul 13, 2022 · HZ-A23 · Substantial damageNTSB GAA22WA189Incident · No injuriesClass 5 · ForeignCessna 560 · Schwäbisch Hall, GermanyMay 23, 2022 · D-CSEB · No damageNTSB DCA22WA109Accident · No injuriesClass 5 · ForeignBoeing 757 · San Jose, Costa RicaApr 7, 2022 · HP-2010DAE · Substantial damageNTSB ENG22WA011IncidentClass 5 · ForeignAirbus A319 · Mexico City, MexicoFeb 15, 2022 · N354NBNTSB GAA22WA106Incident · No injuriesClass 5 · ForeignTextron 208B · Cuenca, EcuadorFeb 10, 2022 · N94ZW · No damageNTSB DCA22WA072IncidentClass 5 · ForeignBoeing 737 · Pyrzowice, PolandFeb 1, 2022 · SP-RSB · No damageNTSB ENG22WA048Accident · No injuriesClass 4 · ForeignEmbraer EMB500 · Santa Rosa, BrazilDec 14, 2021 · PR-TDV · Substantial damageNTSB GAA22WA036Accident · Minor injuriesClass 5 · ForeignPiper PA31 · Caroebe, BrazilNov 19, 2021 · PT-DQU · Substantial damageNTSB GAA22WA031AccidentClass 5 · ForeignCessna 172N · Worms, GermanyNov 14, 2021 · N884CA · Substantial damageNTSB DCA22WA013Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Jayapura, IndonesiaOct 22, 2021 · PK-JRB · No damageNTSB GAA21WA196Accident · No injuriesClass 5 · ForeignRockwell 681 · Apui, BrazilAug 1, 2021 · PT-IEC · Substantial damageNTSB GAA21WA090Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Buckinghamshire, United KingdomApr 26, 2021 · N222SW · Substantial damageNTSB GAA21WA082Accident · 1 fatalClass 5 · ForeignLearjet 35 · Belo Horizonte, BrazilApr 20, 2021 · PR-MLA · Substantial damageNTSB DCA21WA099Accident · No injuriesClass 5 · ForeignBoeing 737 · Jakarta, IndonesiaMar 20, 2021 · PK-YSF · DestroyedNTSB GAA21WA046Incident · No injuriesClass 4 · ForeignHawker Beechcraft 4000 · Plettenburg Bay Airfield, South AfricaMar 3, 2021 · ZS-DDTNTSB GAA21WA073Accident · No injuriesClass 5 · ForeignCessna 525 · Antwerp, BelgiumJan 30, 2021 · 9A-JSC · Substantial damageNTSB DCA21WA061Incident · No injuriesClass 5 · ForeignBoeing 737-824 · San Jose, Costa RicaDec 30, 2020 · N73275 · Minor damageNTSB GAA21WA013Accident · No injuriesClass 3 · ForeignCessna 525 · Uberlandia, BrazilDec 22, 2020 · PR-HFT · Substantial damageNTSB ENG21WA006Accident · Minor injuriesClass 5 · ForeignATR ATR42 · Nunavut, CanadaNov 26, 2020 · C-FAFS · Minor damageNTSB DCA21WA008Incident · No injuriesClass 5 · ForeignBoeing 727 · Valencia, VenezuelaOct 20, 2020 · HK-4367 · No damageNTSB DCA20WA139Incident · No injuriesForeign investigationDouglas DC3 · San Jose del Guaviere, ColombiaThe GRIAA of Colombia has notified the NTSB of an incident involving a Douglas (Boeing) DC3 airplane that occurred on August 26, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the GRIAA of Colombia's investigation under the provisions…Aug 26, 2020 · HK2006 · Minor damageNTSB CEN20WA439Accident · Serious injuriesClass 4 · ForeignCessna F-172 · Nabern-Teck, GermanyAug 19, 2020 · D-ECKT · Substantial damage