NTSB investigations, 2024, Outside the U.S.

83 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 2024, 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\") = 2024
    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 DCA25WA072Accident · 173 fatalClass 2 · ForeignBoeing 737 · Muan County, South KoreaDec 29, 2024 · HL8088NTSB DCA25WA073Accident · No injuriesClass 4 · ForeignBoeing 737 · Oslo, NorwayDec 28, 2024 · PH-BXMNTSB GAA25WA050Accident · No injuriesClass 5 · ForeignBeechcraft E90 · Pucallpa, PeruDec 27, 2024 · OB-2221P · Substantial damageNTSB DCA25WA063Incident · No injuriesClass 5 · ForeignBoeing 737 · Molde, NorwayDec 19, 2024 · LN-NIP · Minor damageNTSB GAA25WA044Accident · 2 fatalClass 5 · ForeignBombardier BD100 · San Fernando, ArgentinaDec 18, 2024 · LV-GOK · Substantial damageNTSB DCA25WA064IncidentClass 5 · ForeignBoeing 737 · Crawley, United KingdomDec 18, 2024 · G-TUML · No damageNTSB DCA25WA058AccidentClass 3 · ForeignBoeing 737 · Abuja, NigeriaDec 11, 2024 · 5N-JRT · Substantial damageNTSB DCA25WA052Incident · No injuriesClass 5 · ForeignBoeing MD 10-30F · Santa Cruz, BoliviaDec 5, 2024 · CP-2791 · Minor damageNTSB GAA25WA051Accident · No injuriesClass 4 · ForeignPiper PA46 · Treviso, ItalyNov 28, 2024 · F-HYPF · Substantial damageNTSB DCA25WA048Accident · No injuriesClass 5 · ForeignBoeing 737 · Montreal, CanadaNov 27, 2024 · C-GGWX · Substantial damageNTSB DCA25WA046Accident · 1 fatalClass 3 · ForeignBoeing 737 · Vilnius, LithuaniaNov 25, 2024 · EC-MFE · Substantial damageNTSB DCA25WA042OccurrenceClass 5 · ForeignBoeing 767 · Vancouver, CanadaNov 19, 2024 · C-GAZINTSB GAA25WA019Accident · No injuriesClass 5 · ForeignViking Air DHC-2 MK 1 · Whitehaven, AustraliaOct 26, 2024 · VH-OHU · Substantial damageNTSB DCA25WA017Incident · No injuriesClass 5 · ForeignBoeing 737 · Tenerife, SpainOct 21, 2024 · EI-DYD · No damageNTSB DCA25WA016IncidentClass 4 · ForeignBoeing 787 · Guangzhou, ChinaOct 21, 2024 · B-1243 · Minor damageNTSB DCA25WA010AccidentClass 5 · ForeignAirbus A321 · Dublin, IrelandOct 18, 2024 · TC-LTL · Substantial damageNTSB DCA25WA005IncidentClass 5 · ForeignBoeing 777 · Rawalpindi, PakistanOct 14, 2024 · HZAK21 · No damageNTSB GAA25WA014Accident · No injuriesClass 5 · ForeignCessna 525 · Rio de Janeiro, BrazilOct 12, 2024 · PT-FEL · Substantial damageNTSB DCA25WA007IncidentClass 5 · ForeignBoeing 737 · Las Puntillas, SpainOct 12, 2024 · 9H-QBL · 2 aircraft · No damageNTSB DCA25WA289IncidentClass 5 · ForeignBoeing 737 · Phuket, ThailandOct 8, 2024 · HS-DBY · Minor damageNTSB DCA25WA004OccurrenceClass 5 · ForeignBoeing 737 · Milan, ItalyOct 1, 2024 · EI-IGI · Minor damageNTSB GAA24WA312AccidentClass 5 · ForeignLearjet LJ-31A · Chihuahua, MexicoSep 24, 2024 · XA-ARD · Substantial damageNTSB GAA24WA297Accident · No injuriesClass 5 · ForeignPiper PA-31 · Gloucestershire, United KingdomSep 24, 2024 · N250MD · Substantial damageNTSB GAA24WA288Accident · No injuriesClass 5 · ForeignCessna 208 · Migori, KenyaSep 16, 2024 · 5Y-ZBW · Substantial damageNTSB GAA24WA274Accident · 1 fatalClass 5 · ForeignPiper 38 · Córdoba, SpainAug 31, 2024 · EC-KYX · Substantial damageNTSB DCA24WA305AccidentClass 3 · ForeignBoeing 737 · Malabo, Equatorial GuineaAug 29, 2024 · ET-AWR · Substantial damageNTSB DCA24WA322Accident · No injuriesClass 5 · ForeignBoeing 767-300 · Milano Malpensa Airport, ItalyAug 27, 2024 · A9C-DHAA · Substantial damageNTSB GAA24WA269Incident · No injuriesClass 5 · ForeignCessna 402 · Kariba, ZimbabweAug 23, 2024 · Z-WFP · Substantial damageNTSB DCA24WA283Incident · No injuriesClass 5 · ForeignBoeing 737 · Monrovia, LiberiaAug 17, 2024 · CN-RGW · No damageNTSB GAA24WA261Accident · No injuriesClass 5 · ForeignPiper PA-34-200T · Kingston, JamaicaAug 15, 2024 · N51157 · Substantial damageNTSB GAA24WA310Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Suffolk, United KingdomAug 12, 2024 · N70DE · Substantial damageNTSB GAA24WA246Accident · 1 fatalClass 5 · ForeignZodiac CH601XL · Tambon Khok Kham, ThailandAug 3, 2024 · HS-DEV · DestroyedNTSB GAA24WA238Accident · 1 fatalClass 5 · ForeignSupermarine Spitfire MK26 · West Oxfordshire, United KingdomJul 28, 2024 · G-ENAA · Substantial damageNTSB DCA24WA251Incident · No injuriesClass 5 · ForeignAirbus A332 · Katunayake, Sri LankaJul 8, 2024 · 4R-ALS · No damageNTSB GAA24WA215Accident · No injuriesClass 5 · ForeignCessna 172 · Fukushima, JapanJul 7, 2024 · JA4101 · Substantial damageNTSB GAA24WA228Accident · No injuriesClass 5 · ForeignPiper PA-28-181 · Beccles, United KingdomJun 29, 2024 · N65JF · Substantial damageNTSB DCA24WA212OccurrenceClass 5 · ForeignBoeing 737 · Bariloche, Río Negro, ArgentinaJun 20, 2024 · LV-KAY · No damageNTSB DCA24WA215OccurrenceClass 5 · ForeignBoeing 737 · Suvarnabhumi, ThailandJun 17, 2024 · B6143 · No damageNTSB GAA24WA192Accident · No injuriesClass 5 · ForeignCessna 172 · Norfolk, United KingdomJun 16, 2024 · G-MCLYNTSB DCA24WA208Incident · No injuriesClass 5 · ForeignBoeing 747 · Incheon, South KoreaJun 11, 2024 · N429MC · Minor damageNTSB GAA24WA244AccidentClass 5 · ForeignViking DH 6 - 300 · Miriandhoo, Baa Atoll, MaldivesJun 9, 2024 · 8Q-TMO · Substantial damageNTSB ENG25WA006IncidentClass 5 · ForeignDe Havilland DHC6 · Kikori, Papua New GuineaJun 8, 2024 · P2-BBM · Minor damageNTSB DCA24WA282IncidentClass 5 · ForeignMcdonnell Douglas MD 83 · Santa Clara, CubaJun 2, 2024 · N802WA · Minor damageNTSB DCA24WA198AccidentClass 5 · ForeignAirbus A320 · Christchurch, New ZealandMay 30, 2024 · VH-VFFNTSB GAA24WA203IncidentClass 5 · ForeignCessna 210 · Bankstown, AustraliaMay 26, 2024 · VH-MYW · Substantial damageNTSB GAA24WA314Accident · No injuriesClass 5 · ForeignRobinson R22 · Municipio de Berazategui, ArgentinaMay 20, 2024 · LV-RLA · Substantial damageNTSB GAA24WA211AccidentClass 5 · ForeignBeech B200 · Williamtown, AustraliaMay 13, 2024 · VH-XDV · Substantial damageNTSB DCA24WA181Accident · No injuriesClass 5 · ForeignBoeing 737 · Antalya, TürkiyeMay 9, 2024 · 9H-TJF · Minor damageNTSB DCA24WA180Incident · No injuriesClass 2 · ForeignBoeing 767-3S2F · Istanbul, TürkiyeMay 8, 2024 · N110FE · Minor damageNTSB ENG24WA017AccidentClass 5 · ForeignBoeing 737 · Kinshasa, Congo - KinshasaMay 5, 2024 · 9S-AKK · Substantial damage