NTSB investigations, 2026, Outside the U.S.

24 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 2026, Outside the U.S. per year, 1962–2026: 1,170 cases
19621
19631
196438
196537
196640
196735
196824
196920
197021
197118
197226
197318
197422
197518
19764
19776
197812
19794
19802
19821
19911
19931
19941
19961
19974
19991
20001
20081
200910
201021
201123
201227
201322
201421
201534
201655
201751
201860
201939
202048
202172
202275
202383
202483
202563
202624

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 = 550)
  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 DCA27WA023Incident · No injuriesClass 5 · ForeignBoeing 737 · Birmingham, United KingdomOct 25, 2026 · G-JZHENTSB DCA27WA012Incident · No injuriesClass 5 · ForeignAirbus A320 · Townsville, AustraliaOct 7, 2026 · VH-VGO · No damageNTSB DCA26WA369IncidentClass 5 · ForeignBoeing 737 · Aeropuerto de Lanzarote, SpainSep 28, 2026 · EI-IKJ · 2 aircraft · No damageNTSB DCA26WA363Accident · No injuriesClass 5 · ForeignBoeing 737 · Kindu, Congo - KinshasaSep 17, 2026 · 9S-AAI · Substantial damageNTSB DCA26WA362Incident · No injuriesClass 5 · ForeignBoeing 737 · Tiouilit, MauritaniaSep 10, 2026 · NxxxxNTSB GAA26WA321Accident · No injuriesClass 5 · ForeignTextron C680A · Misrata, LibyaSep 9, 2026 · N · DestroyedNTSB DCA26WA355Accident · No injuriesClass 3 · ForeignBoeing 767-338 · Guatemala City, GuatemalaSep 6, 2026 · N373CM · Substantial damageNTSB DCA26WA291OccurrenceClass 5 · ForeignBoeing 737 · Mascot, AustraliaJul 26, 2026 · VH-XZG · 2 aircraft · No damageNTSB DCA26WA336Incident · No injuriesClass 5 · ForeignBoeing 737 · Kuching, MalaysiaJul 21, 2026 · 9M-LRH · Minor damageNTSB DCA26WA309Incident · No injuriesClass 5 · ForeignAirbus A320 · Balmaceda, ChileJul 17, 2026 · CC-BAZ · No damageNTSB DCA26WA262Incident · No injuriesClass 4 · ForeignBoeing 737 · Bogotá, ColombiaJul 5, 2026 · HK5447 · Minor damageNTSB DCA26WA248Incident · No injuriesClass 5 · ForeignBoeing 747 · Birmingham, United KingdomJun 22, 2026 · 4K-SW888NTSB DCA26WA235IncidentClass 5 · ForeignAirbus A321 · Horley, United KingdomJun 3, 2026 · C-GOIONTSB GAA26WA289Accident · No injuriesClass 4 · ForeignBeech B200 · Rio de Janeiro, BrazilJun 2, 2026 · PS-AKT · Substantial damageNTSB GAA26WA287Incident · No injuriesClass 5 · ForeignCessna 182 · San Antonio, ColombiaMay 28, 2026 · HK1519 · Substantial damageNTSB GAA26WA247Accident · No injuriesClass 5 · ForeignPiper PA28 · Roszczep, PolandMay 21, 2026 · SE-EOT · Substantial damageNTSB DCA26WA198Incident · No injuriesClass 5 · ForeignBoeing 737 · Salvador, BrazilMay 9, 2026 · PS-GFCNTSB GAA26WA175Accident · No injuriesClass 5 · ForeignCessna 140 · Región de Antofagasta, ChileApr 26, 2026 · N2187V · Substantial damageNTSB GAA26WA291Accident · No injuriesClass 5 · ForeignPiper PA32R · Nakuru, KenyaApr 19, 2026 · 5Y-BRJ · Minor damageNTSB GAA26WA141Accident · No injuriesClass 5 · ForeignEmbraer EMB-145XR · Les Cayes, HaitiMar 20, 2026 · N271BC · No damageNTSB DCA26WA156Accident · No injuriesClass 5 · ForeignBoeing 737 · Phuket, ThailandMar 11, 2026 · VT-BWQ · Substantial damageNTSB GAA26WA104Accident · No injuriesClass 5 · ForeignCessna 510 · Barretos City, BrazilFeb 8, 2026 · PR-DRINTSB DCA26WA160Accident · No injuriesClass 5 · ForeignATR ATR42 · Simberi, Papua New GuineaJan 15, 2026 · P2-KSA · Substantial damageNTSB GAA26WA071Accident · No injuriesClass 5 · ForeignCessna 208 · Nuwara Eliya, Sri LankaJan 7, 2026 · 4R-CAE · Substantial damage