NTSB investigations, 2025, Outside the U.S.

63 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 2025, 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\") = 2025
    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 GAA26WA081AccidentClass 5 · ForeignGulfstream G-VSP · Bibi, JapanDec 12, 2025 · VH-PFL · Minor damageNTSB GAA26WA069Accident · No injuriesClass 5 · ForeignCessna A188 · Boca de Mao, Dominican RepublicDec 7, 2025 · HI799 · Substantial damageNTSB DCA26WA051Incident · No injuriesClass 5 · ForeignBAE BAE146 · Región de Magallanes y de la Antártica Chilena, ChileDec 3, 2025 · CC-ARNNTSB GAA26WA040Accident · No injuriesClass 4 · ForeignBoeing DC3C-S1C3G · Rio Grande, ArgentinaDec 1, 2025 · LV-VYL · Substantial damageNTSB GAA26WA034Accident · 1 fatalClass 5 · ForeignVans RV7 · New South Wales, AustraliaNov 30, 2025 · VH-EWS · 2 aircraft · Substantial damageNTSB DCA26WA052Incident · No injuriesClass 5 · ForeignAirbus A320 · El Aaroui (Nador), MoroccoNov 30, 2025 · CN-NMHNTSB DCA26WA045Incident · No injuriesClass 5 · ForeignBoeing 737 · Kuantan, MalaysiaNov 27, 2025 · 9M-MXU · No damageNTSB DCA26WA046IncidentClass 5 · ForeignGeneral Atomics MQ9 · Kitakyushu, JapanNov 23, 2025 · JA382A · Minor damageNTSB ENG26WA009Accident · No injuriesClass 5 · ForeignEmbraer EMB145 · Kolwezi, Congo - KinshasaNov 17, 2025 · D2-AJB · DestroyedNTSB DCA26WA079Accident · No injuriesClass 5 · ForeignBoeing 737 · Val-D'Or, CanadaNov 17, 2025 · C-GNLE · No damageNTSB GAA26WA028Accident · No injuriesClass 5 · ForeignPiper PA28 · Cambridgeshire, United KingdomNov 16, 2025 · G-BOHONTSB DCA26WA031Incident · No injuriesClass 5 · ForeignBoeing 747 · N'Djamena, ChadNov 13, 2025 · ER-BAR · Minor damageNTSB GAA26WA029Accident · No injuriesClass 5 · ForeignPiper PA46 · Santa Cruz, BoliviaNov 11, 2025 · CP-2768 · Substantial damageNTSB DCA26WA044Incident · No injuriesClass 5 · ForeignBoeing 737 · Riyadh, Saudi ArabiaNov 8, 2025 · A4O-BAANTSB DCA26WA017Accident · 2 fatalClass 3 · ForeignBoeing 747 · Hong Kong, Hong Kong SAR ChinaOct 19, 2025 · TC-ACF · Substantial damageNTSB GAA25WA265Accident · 1 fatalClass 5 · ForeignPiper PA18 · Cham, SwitzerlandSep 19, 2025 · HB-ORK · DestroyedNTSB GAA25WA273Accident · No injuriesClass 5 · ForeignBeech A45 · Guatemala City, GuatemalaSep 17, 2025 · N334LS · Substantial damageNTSB DCA25WA328Incident · No injuriesClass 5 · ForeignBoeing 737 · Krakow, PolandSep 14, 2025 · OM-FEX · No damageNTSB DCA25WA338IncidentClass 5 · ForeignBoeing 737 · Lipjan, KosovoSep 11, 2025 · GPX5AS · Minor damageNTSB GAA25WA253AccidentClass 5 · ForeignThrush S2R · Castellón, SpainSep 7, 2025 · EC-MXF · Substantial damageNTSB DCA25WA320AccidentClass 3 · ForeignBoeing 737 · Simpson Bay, Sint MaartenSep 7, 2025 · C-GWSR · Substantial damageNTSB DCA25WA319Incident · No injuriesClass 5 · ForeignBoeing 737 · Munster, GermanySep 3, 2025 · TC-MGC · No damageNTSB DCA25WA299IncidentClass 5 · ForeignBoeing 737 · Bickenhill, United KingdomAug 14, 2025 · G-TUKR · No damageNTSB GAA25WA241Accident · No injuriesClass 5 · ForeignMooney M20M · Innsbruck, AustriaAug 13, 2025 · N42FA · Substantial damageNTSB DCA25WA297Incident · No injuriesClass 5 · ForeignBoeing 747-8F · Taipei, TaiwanAug 13, 2025 · N613UP · Minor damageNTSB GAA25WA235AccidentClass 5 · ForeignRaytheon B36TC · Norwich, United KingdomAug 8, 2025 · N5073C · Substantial damageNTSB GAA25WA233Incident · No injuriesClass 5 · ForeignBeech B200 · Birmingham, United KingdomAug 6, 2025 · G-NIAANTSB GAA25WA230AccidentClass 5 · ForeignBeech A36 · Montevideo, UruguayAug 5, 2025 · N4970MNTSB DCA25WA264Accident · No injuriesClass 4 · ForeignBoeing 737 · Kun Ming Shi, ChinaJul 14, 2025 · XY-ALV · No damageNTSB ENG25WA043Incident · No injuriesClass 5 · ForeignBoeing 737 · Richmond, CanadaJul 13, 2025 · C-FNWD · No damageNTSB DCA25WA273Incident · No injuriesClass 5 · ForeignBoeing 737 · Port Harcourt, NigeriaJul 13, 2025 · 5N-BQQ · No damageNTSB GAA25WA206Accident · No injuriesClass 5 · ForeignLearjet 45 · Cairo, EgyptJul 1, 2025 · 5N-BLW · Minor damageNTSB DCA25WA253IncidentClass 5 · ForeignAirbus A321 · Dublin, IrelandJul 1, 2025 · TC-LTG · Substantial damageNTSB GAA25WA194Accident · No injuriesClass 5 · ForeignCessna 402 · Salvador, BrazilJun 18, 2025 · PT-LKCNTSB DCA25WA236Incident · No injuriesClass 5 · ForeignBoeing 737 · Pusan City, South KoreaJun 12, 2025 · Not reported · No damageNTSB GAA25WA179Accident · No injuriesClass 5 · ForeignCessna 310 · Lake Evella Aerodrome, AustraliaMay 29, 2025 · VH-NXA · Substantial damageNTSB GAA25WA279Occurrence · No injuriesClass 5 · ForeignBeech 1900 · Aix-les-Milles, FranceMay 27, 2025 · F-GLNE · No damageNTSB DCA25WA221IncidentClass 5 · ForeignBoeing 767 · Xi An Shi, ComorosMay 27, 2025 · 4L-GMCNTSB GAA25WA175AccidentClass 5 · ForeignGulfstream Aerospace G-IV · Robertsfield, LiberiaMay 26, 2025 · N770KS · Minor damageNTSB DCA25WA225IncidentClass 5 · ForeignBoeing 777 · Singapore, SingaporeMay 19, 2025 · B-7868 · 2 aircraftNTSB DCA25WA211Accident · No injuriesClass 5 · ForeignBoeing 737 · Kos, GreeceMay 15, 2025 · SP-ESG · Minor damageNTSB GAA25WA160Accident · No injuriesClass 5 · ForeignPiper PA-22-150 · Mosbach, GermanyMay 14, 2025 · N3870P · Substantial damageNTSB DCA25WA192Incident · No injuriesClass 5 · ForeignBoeing 737 · Ras Al Khaimah, United Arab EmiratesApr 22, 2025 · VT-AXZ · Minor damageNTSB GAA25WA146Incident · No injuriesClass 5 · ForeignHonda HA420 · Chubu, JapanApr 13, 2025 · JA01HJ · No damageNTSB GAA25WA143Accident · Minor injuriesClass 5 · ForeignHawker 800XPi · Fes, MoroccoApr 11, 2025 · CN-TKC · DestroyedNTSB GAA25WA137Accident · Serious injuriesClass 5 · ForeignGulfstream Aerospace G-V · Cabo San Lucas, MexicoApr 10, 2025 · N1948Z · Substantial damageNTSB ENG25WA033Accident · Serious injuriesClass 5 · ForeignBell 505 · Petersgrat Mountain, SwitzerlandApr 10, 2025 · HB-ZWF · DestroyedNTSB DCA25WA199IncidentClass 5 · ForeignBoeing 737-400 · Puerto Inírida, ColombiaApr 10, 2025 · HK5447NTSB DCA25WA193Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Dushanbe, TajikistanApr 10, 2025 · EP-VAINTSB DCA25WA181IncidentClass 5 · ForeignBoeing 737 · Mexico City, MexicoApr 2, 2025 · XA-MFO · No damage