NTSB investigations, 2026, Outside the U.S.

26 cases where the phase of flight was Takeoff.

Cases per year

19622026
NTSB investigations, 2026, 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\") = 2026
    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 DCA26WA335IncidentClass 5 · ForeignAirbus A320 · Guarulhos, BrazilAug 15, 2026 · PR-MRM · 3 aircraftNTSB DCA26WA311IncidentClass 5 · ForeignBoeing 787 · Munich, GermanyAug 15, 2026 · VN-A867NTSB DCA26WA332IncidentClass 5 · ForeignBoeing 737 · Mascot, AustraliaAug 9, 2026 · VH-IJO · 2 aircraftNTSB ENG26WA033OccurrenceClass 5 · ForeignBoeing 737 · Cancun, MexicoAug 8, 2026 · N27273 · Minor damageNTSB ENG26WA038Incident · No injuriesClass 5 · ForeignEmbraer EMB145 · Luanda, AngolaAug 4, 2026 · D2-FDFNTSB DCA26WA301Incident · No injuriesClass 5 · ForeignAirbus A321 · Brasilia, BrazilJul 29, 2026 · PT-XPF · Minor damageNTSB DCA26WA296Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Hargeisa, SomaliaJul 24, 2026 · 5Y-KCB · Minor damageNTSB DCA26WA281Accident · No injuriesClass 5 · ForeignMcdonnell Douglas MD80 · Dachi Su, KyrgyzstanJul 7, 2026 · EX-80003NTSB GAA26WA241Accident · Minor injuriesClass 5 · ForeignCirrus SR22 · Neropolis, BrazilJun 28, 2026 · PR-RRC · DestroyedNTSB DCA26WA239Incident · No injuriesClass 3 · ForeignAirbus A380 · Dubai, United Arab EmiratesJun 20, 2026 · A6-EEXNTSB DCA26WA243Occurrence · No injuriesClass 5 · ForeignBombardier CL-600-2D24 · Montreal, CanadaJun 18, 2026 · N934XJ · Minor damageNTSB ENG26WA030IncidentClass 5 · ForeignAirbus A321 · Zapote del Valle, MexicoJun 13, 2026 · XA-VXJ · No damageNTSB GAA26WA223Accident · 1 fatalClass 5 · ForeignBell 206 · Lesa, ItalyJun 12, 2026 · I-CHOP · DestroyedNTSB DCA26WA209Incident · No injuriesClass 5 · ForeignAirbus 220 · Split, CroatiaMay 16, 2026 · 9A-CAN · Minor damageNTSB DCA26WA212AccidentClass 3 · ForeignBoeing 737 · Muscat, OmanMay 15, 2026 · VT---AXRNTSB ENG26WA028IncidentClass 5 · ForeignAirbus A321 · Ciudad de México, MexicoMay 4, 2026 · XA-VXK · No damageNTSB GAA26WA180Incident · Minor injuriesClass 5 · ForeignCostruzioni Aeronautiche Tecna P92 Eaglet · Dajabon, Dominican RepublicApr 29, 2026 · N577TU · DestroyedNTSB GAA26WA182IncidentClass 5 · ForeignPiper PA60 · Villavicencio, ColombiaApr 23, 2026 · HK3641G · Minor damageNTSB GAA26WA144Accident · No injuriesClass 5 · ForeignCessna 182 · Pucallpa, PeruMar 31, 2026 · N2406R · Substantial damageNTSB DCA26WA220Occurrence · No injuriesClass 5 · ForeignBoeing 737-832 · San Miguel de Cozumel, MexicoMar 25, 2026 · N3734B · 2 aircraft · No damageNTSB DCA26WA162Accident · No injuriesClass 5 · ForeignBoeing 737 · Misawa, JapanMar 13, 2026 · JA301J · Substantial damageNTSB GAA26WA115Accident · No injuriesClass 5 · ForeignPiper PA-28-140 · Abbots Bromley, United KingdomFeb 24, 2026 · G-BBBY · Minor damageNTSB DCA26WA136Incident · No injuriesClass 5 · ForeignMcdonnell Douglas DC-9 · Maiquetía, VenezuelaFeb 22, 2026 · YV2923 · No damageNTSB DCA26WA120Incident · No injuriesClass 5 · ForeignBoeing 737 · Melbourne Airport, AustraliaFeb 16, 2026 · ZK-TXB · No damageNTSB GAA26WA106Accident · Minor injuriesClass 5 · ForeignCessna 182 · Carumba, BrazilJan 31, 2026 · PT-OIKNTSB GAA26WA093Accident · No injuriesClass 5 · ForeignPiper PA-28-181 · Lelystad, NetherlandsJan 22, 2026 · PH-KAX · Substantial damage