NTSB investigations, 2025, Outside the U.S.

55 cases where the phase of flight was Takeoff.

Cases per year

19622026
NTSB investigations, 2025, Outside the U.S. per year, 1962–2026: 646 cases
19621
19649
19658
19666
19675
19689
19696
19705
19714
19725
19734
19747
19755
19762
19772
19781
19792
19801
19951
19961
20071
20089
20097
20108
201115
201211
20139
201418
201529
201629
201742
201829
201932
202030
202139
202241
202361
202471
202555
202626

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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\") = 2025
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 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 DCA26WA101Incident · No injuriesClass 5 · ForeignBoeing 737 · Mexico City, MexicoDec 19, 2025 · XA-VDM · Minor damageNTSB DCA26WA257IncidentClass 5 · ForeignGippsAero GA8 · Whitemark, AustraliaDec 16, 2025 · VH-ASI · 2 aircraftNTSB DCA26WA067IncidentClass 5 · ForeignBoeing 737 · Barquisimeto, VenezuelaDec 8, 2025 · YV3063 · No damageNTSB DCA26WA072Incident · No injuriesClass 5 · ForeignBoeing 727 · Bogotá, ColombiaDec 6, 2025 · HK5216 · No damageNTSB GAA26WA036Accident · No injuriesClass 5 · ForeignBeech E90 · Para De Minas, BrazilNov 28, 2025 · PS-MGQ · Substantial damageNTSB DCA26WA049AccidentClass 5 · ForeignBoeing 737 · Seville, SpainNov 20, 2025 · SP-RKK · Substantial damageNTSB DCA26WA032IncidentClass 5 · ForeignFairchild 22C7 · South Mackay, AustraliaNov 12, 2025 · VH-HPE · No damageNTSB DCA26WA050Incident · No injuriesClass 5 · ForeignBoeing 737 · Heliopolis, EgyptNov 5, 2025 · SU-GGA · Minor damageNTSB DCA26WA022IncidentClass 5 · ForeignBoeing 737 · Bogotá, ColombiaNov 2, 2025 · HK5026 · Minor damageNTSB GAA26WA015Accident · 1 fatalClass 5 · ForeignCessna 208 · Diani, KenyaOct 28, 2025 · 5Y-CCA · DestroyedNTSB GAA25WA278AccidentClass 5 · ForeignBeechraft C90A · Sakwai, IndiaOct 9, 2025 · VT-DEJ · Substantial damageNTSB ENG26WA001IncidentClass 5 · ForeignSaab 340 · Adelaide Aerodrome, AustraliaOct 8, 2025 · VH-ZPN · Minor damageNTSB GAA25WA266Accident · 2 fatalClass 3 · ForeignLearjet 55 · La Guaira, VenezuelaSep 24, 2025 · YV3440 · DestroyedNTSB GAA25WA283AccidentClass 5 · ForeignGulfstream GIV · Singapore, SingaporeSep 19, 2025 · T7-977 · Minor damageNTSB DCA25WA337IncidentClass 4 · ForeignBoeing 737 · Cancun, MexicoSep 19, 2025 · N7723E · Minor damageNTSB GAA25WA290Accident · No injuriesClass 5 · ForeignBeech 90 · Farrukabad, IndiaSep 10, 2025 · VT-DEJ · Substantial damageNTSB DCA25WA347Incident · No injuriesClass 5 · ForeignBoeing 737 · Trelew, ArgentinaSep 10, 2025 · LV-FQY · Substantial damageNTSB GAA25WA251Accident · 2 fatalClass 5 · ForeignMooney M20J · Norrtälje, SwedenSep 5, 2025 · SE-GXI · Substantial damageNTSB DCA25WA340Incident · No injuriesClass 5 · ForeignAirbus Canada A220 · Toronto, CanadaSep 2, 2025 · C-GJYI · No damageNTSB GAA25WA261Accident · 2 fatalClass 5 · ForeignSkystar Kitfox · Casey, CanadaAug 31, 2025 · C-GMFA · Substantial damageNTSB DCA25WA317Incident · No injuriesClass 4 · ForeignBoeing 737 · Aktion, GreeceAug 28, 2025 · OK-TVW · No damageNTSB GAA25WA275AccidentClass 5 · ForeignCessna 172 · Islamabad, PakistanAug 16, 2025 · AP-BLO · DestroyedNTSB DCA25WA309IncidentClass 5 · ForeignAirbus A320-214 · Villahermosa, MexicoAug 16, 2025 · N837VA · 2 aircraft · No damageNTSB GAA25WA237Accident · No injuriesClass 5 · ForeignCessna 210 · San Lorenzo, BoliviaAug 7, 2025 · CP-3139 · Substantial damageNTSB DCA25WA292Incident · No injuriesClass 5 · ForeignBoeing 737-832 · Ciudad de México, MexicoJul 21, 2025 · N3766 · No damageNTSB ENG25WA047Accident · No injuriesClass 5 · ForeignViking DHC-2 MK. I (Beaver) · Lac du Poisson Blanc, CanadaJul 19, 2025 · C-FJAC · Substantial damageNTSB GAA25WA208Accident · 4 fatalClass 5 · ForeignBeech B200 · Southend-on-Sea, United KingdomJul 13, 2025 · PH-ZAZ · DestroyedNTSB GAA25WA215Incident · No injuriesClass 5 · ForeignCessna 650 · Mallorca, SpainJul 6, 2025 · CN-SRA · Minor damageNTSB ENG25WA054IncidentClass 5 · ForeignPilatus PC12 · Kitakyushu, JapanJul 2, 2025 · T7-12DW · No damageNTSB GAA25WA207Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Porto Dos GaúChos, BrazilJul 1, 2025 · PP-LTO · No damageNTSB GAA25WA262AccidentClass 5 · ForeignCessna P210 · Maklar, HungaryJun 24, 2025 · D-EADB · Substantial damageNTSB DCA25WA232AccidentClass 2 · ForeignBoeing 787 · Ahmedabad, IndiaJun 12, 2025 · VT-ANB · Substantial damageNTSB ENG25LA038IncidentClass 3 · LimitedPreliminary reportBoeing 777 · Beijing, ChinaOn May 26, 2025, at approximately 0925 UTC, a Boeing 777-200, registration N793UA, operated as United Airlines flight 889, executed a rejected takeoff at Beijing Capital International Airport when the crew heard a loud bang and followed by a No. 2 (right)…May 26, 2025 · N793UA · Minor damageNTSB GAA25WA169Accident · No injuriesClass 5 · ForeignCessna F182 · Šeduva, LithuaniaMay 25, 2025 · LY-TBT · Substantial damageNTSB GAA25WA167Accident · Serious injuriesClass 5 · ForeignCessna 188 · Pasaje, EcuadorMay 23, 2025 · HC-CMM · DestroyedNTSB GAA25WA165AccidentClass 5 · ForeignPiper PA-22-108 · Norfolk, United KingdomMay 23, 2025 · G-ARNE · Substantial damageNTSB GAA25WA170Accident · No injuriesClass 5 · ForeignPiper PA 46-350P · Kilkeel, United KingdomMay 18, 2025 · N3117J · Substantial damageNTSB GAA25WA182Accident · 1 fatalClass 3 · ForeignTecnam P2008 · Amreli, IndiaApr 22, 2025 · VT-VDF · DestroyedNTSB ENG25WA030Incident · No injuriesClass 5 · ForeignBoeing 737 · Budapest, HungaryApr 22, 2025 · SP-RZUNTSB DCA25WA301IncidentClass 5 · ForeignBoeing 737 · Luton, United KingdomApr 22, 2025 · G-CRUX · No damageNTSB GAA25WA148AccidentClass 5 · ForeignCessna F150 · Gliwice, PolandApr 16, 2025 · SP-PIA · Substantial damageNTSB GAA25WA140Accident · Minor injuriesClass 5 · ForeignCessna 150 · Campina Grande, BrazilApr 9, 2025 · PT-WVL · Substantial damageNTSB GAA25WA130Accident · 2 fatalClass 5 · ForeignCessna 152 · Lingayen, PhilippinesMar 30, 2025 · RP-C8595 · DestroyedNTSB GAA25WA124Accident · No injuriesClass 5 · ForeignCessna T188 · La Concordia, EcuadorMar 26, 2025 · HC-BOR · Substantial damageNTSB DCA25WA124OccurrenceClass 5 · ForeignBoeing 737 · Rio de janiero, BrazilFeb 11, 2025 · PS-GPPNTSB GAA25WA094Accident · 2 fatalClass 5 · ForeignBeecraft F90 · São Paulo city, BrazilFeb 7, 2025 · PS-FEM · DestroyedNTSB GAA25WA077Accident · 1 fatalClass 5 · ForeignRobinson R44 · Pacific Ocean, EcuadorFeb 1, 2025 · HC-CQY · Substantial damageNTSB DCA25WA118Accident · 20 fatalClass 5 · ForeignBeech 1900 · Juba, SudanJan 29, 2025 · 5X-RHB · DestroyedNTSB ENG25WA018Incident · No injuriesClass 3 · ForeignBoeing 737 · Cochabamba, BoliviaJan 27, 2025 · CP-2923 · Minor damageNTSB GAA25WA087Accident · No injuriesClass 5 · ForeignCessna 172 · Pará De Minas - Minas Gerais, BrazilJan 25, 2025 · PR-NEI · Destroyed