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 GAA24WA008AccidentClass 4 · ForeignLearjet 45 · Veracruz, MexicoNTSB DCA23WA453IncidentClass 5 · ForeignBoeing 777 · Thalang - Phuket, ThailandNTSB GAA23WA241AccidentClass 5 · ForeignCessna 208 · Limpopo Province, South AfricaNTSB DCA23WA398Incident · No injuriesClass 5 · ForeignBoeing 747-481F · Ningbo, ChinaNTSB DCA23WA345OccurrenceClass 5 · ForeignBoeing 777 · Dhaka, BangladeshNTSB GAA23WA167Accident · No injuriesClass 5 · ForeignSocata TBM 700 · Narsarsuaq, GreenlandNTSB DCA23WA317IncidentClass 5 · ForeignBoeing 737 · Perth Airport, AustraliaNTSB DCA23WA325IncidentClass 5 · ForeignBoeing 747 · Bangkok, ThailandNTSB DCA23WA367Incident · No injuriesClass 5 · ForeignEmbraer 195 · Salvador, BrazilNTSB GAA23WA144AccidentClass 5 · ForeignBeechcraft C90 · Bareilly, IndiaNTSB DCA23WA204Incident · No injuriesClass 5 · ForeignBombardier BD500 · Riga, LatviaNTSB GAA23WA088AccidentClass 5 · ForeignCessna 337G · Itzehoe, GermanyNTSB GAA23WA064Accident · No injuriesClass 5 · ForeignLearjet 60 · Buenos Aires, ArgentinaNTSB DCA23WA143IncidentClass 5 · ForeignBoeing 777-319ER · Auckland, New ZealandNTSB DCA23WA127IncidentClass 5 · ForeignAirbus A330-323 · Amsterdam, NetherlandsNTSB GAA23WA094Accident · No injuriesClass 5 · ForeignMooney M20R · Vélez-Málaga, SpainNTSB DCA23WA474OccurrenceClass 5 · ForeignBoeing 737 · Dortmund, GermanyNTSB DCA23WA091AccidentClass 5 · ForeignBoeing 737 · Dortmund, GermanyNTSB DCA23WA088IncidentClass 5 · ForeignBoeing 737 · Brisbane, AustraliaNTSB DCA23WA075Incident · No injuriesClass 5 · ForeignBoeing 737 · Breslau, CanadaNTSB DCA23WA031Incident · No injuriesClass 5 · ForeignEmbraer EMB145 · Paris, FranceNTSB GAA23WA007Accident · 1 fatalClass 3 · ForeignCirrus SF50 · Santa Marta, ColombiaNTSB GAA23WA006Incident · No injuriesClass 5 · ForeignLearjet 45 · Sao Paulo, BrazilNTSB DCA22WA213Incident · No injuriesClass 5 · ForeignBoeing 737 · Panama City, PanamaNTSB DCA22WA209Accident · Minor injuriesClass 4 · ForeignBoeing 737 · Montpellier, FranceNTSB DCA22WA208Accident · 1 fatalClass 5 · ForeignBAE 3201EP · San Antonio del Estrecho, PeruNTSB GAA22WA297AccidentClass 5 · ForeignDan Hawken Titan T-51 · Soest, GermanyNTSB DCA22WA164Accident · No injuriesClass 5 · ForeignBoeing 737-800 · Chiang Rai, ThailandNTSB GAA22WA236Accident · No injuriesClass 3 · ForeignGulfstream GIV · Jeddah, Saudi ArabiaNTSB GAA22WA189Incident · No injuriesClass 5 · ForeignCessna 560 · Schwäbisch Hall, GermanyNTSB DCA22WA109Accident · No injuriesClass 5 · ForeignBoeing 757 · San Jose, Costa RicaNTSB ENG22WA011IncidentClass 5 · ForeignAirbus A319 · Mexico City, MexicoNTSB GAA22WA106Incident · No injuriesClass 5 · ForeignTextron 208B · Cuenca, EcuadorNTSB DCA22WA072IncidentClass 5 · ForeignBoeing 737 · Pyrzowice, PolandNTSB ENG22WA048Accident · No injuriesClass 4 · ForeignEmbraer EMB500 · Santa Rosa, BrazilNTSB GAA22WA036Accident · Minor injuriesClass 5 · ForeignPiper PA31 · Caroebe, BrazilNTSB GAA22WA031AccidentClass 5 · ForeignCessna 172N · Worms, GermanyNTSB DCA22WA013Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Jayapura, IndonesiaNTSB GAA21WA196Accident · No injuriesClass 5 · ForeignRockwell 681 · Apui, BrazilNTSB GAA21WA090Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Buckinghamshire, United KingdomNTSB GAA21WA082Accident · 1 fatalClass 5 · ForeignLearjet 35 · Belo Horizonte, BrazilNTSB DCA21WA099Accident · No injuriesClass 5 · ForeignBoeing 737 · Jakarta, IndonesiaNTSB GAA21WA046Incident · No injuriesClass 4 · ForeignHawker Beechcraft 4000 · Plettenburg Bay Airfield, South AfricaNTSB GAA21WA073Accident · No injuriesClass 5 · ForeignCessna 525 · Antwerp, BelgiumNTSB DCA21WA061Incident · No injuriesClass 5 · ForeignBoeing 737-824 · San Jose, Costa RicaNTSB GAA21WA013Accident · No injuriesClass 3 · ForeignCessna 525 · Uberlandia, BrazilNTSB ENG21WA006Accident · Minor injuriesClass 5 · ForeignATR ATR42 · Nunavut, CanadaNTSB DCA21WA008Incident · No injuriesClass 5 · ForeignBoeing 727 · Valencia, VenezuelaNTSB 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…NTSB CEN20WA439Accident · Serious injuriesClass 4 · ForeignCessna F-172 · Nabern-Teck, Germany