NTSB investigations, 2023, Outside the U.S.

83 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 2023, 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\") = 2023
    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 GAA24WA079Accident · No injuriesClass 5 · ForeignCessna 560 · Diyarbakir, TürkiyeDec 30, 2023 · TC-LLL · Substantial damageNTSB GAA24WA058AccidentClass 5 · ForeignBeech A45 · Guatemala City, GuatemalaDec 21, 2023 · N334LS · Substantial damageNTSB DCA24WA054Incident · No injuriesClass 5 · ForeignBoeing 787 · Birmingham, United KingdomDec 21, 2023 · G-TUIB · No damageNTSB DCA24WA033IncidentClass 5 · ForeignBoeing 737 · Glasgow, United KingdomNov 28, 2023 · G-JZHU · Minor damageNTSB GAA24WA040Accident · No injuriesClass 5 · ForeignPiper PA46 · Brno, CzechiaNov 24, 2023 · D-EGIE · Substantial damageNTSB GAA24WA037Accident · No injuriesClass 5 · ForeignMaule M5 · Spanish Wells, Eleuthera, BahamasNov 21, 2023 · C-GCWINTSB GAA24WA038AccidentClass 5 · ForeignBeech A100 · Québec, CanadaNov 16, 2023 · C-GIZX · Substantial damageNTSB DCA24WA026IncidentClass 5 · ForeignBoeing 787 · New Delhi, IndiaNov 10, 2023 · ETATL · No damageNTSB GAA24WA306Accident · No injuriesClass 5 · ForeignRaytheon Hawker · Ibadan, NigeriaNov 3, 2023 · 5N-AMM · Substantial damageNTSB GAA24WA031AccidentClass 5 · ForeignLearjet 35 · Cuernavaca, MexicoNov 1, 2023 · XA-IRE · DestroyedNTSB GAA24WA055AccidentClass 5 · ForeignRobinson R44 · Groenvlei, South AfricaOct 26, 2023 · ZT-RBU · Substantial damageNTSB GAA24WA014Accident · 1 fatalClass 4 · ForeignCessna 172 · Barrancabermeja, ColombiaOct 19, 2023 · HK-2465G · Substantial damageNTSB GAA24WA017Accident · No injuriesClass 5 · ForeignCessna 170B · Duxford, United KingdomOct 9, 2023 · N2366D · Substantial damageNTSB GAA24WA015Accident · 2 fatalClass 5 · ForeignCessna 172N · Merriton, AustraliaOct 8, 2023 · VH-RSBNTSB GAA24WA016Accident · No injuriesClass 5 · ForeignChristen Industries A1 · Hida Air Park, JapanOct 7, 2023 · JA4083 · Substantial damageNTSB GAA24WA012Accident · No injuriesClass 5 · ForeignCirrus SR22 · Dubai, United Arab EmiratesOct 5, 2023 · A6-CTG · Substantial damageNTSB GAA24WA008AccidentClass 4 · ForeignLearjet 45 · Veracruz, MexicoOct 4, 2023 · XA-JAONTSB GAA23WA267AccidentClass 5 · ForeignBell 407 · Madang Province, Papua New GuineaSep 22, 2023 · P2-HSN · DestroyedNTSB DCA23WA467OccurrenceClass 5 · ForeignBoeing 767 · Beirut, LebanonSep 18, 2023 · A9C-OHAB · Substantial damageNTSB DCA23WA453IncidentClass 5 · ForeignBoeing 777 · Thalang - Phuket, ThailandSep 15, 2023 · RA--73141 · Minor damageNTSB GAA23WA256Accident · Serious injuriesClass 5 · ForeignLearjet 45XR · Mumbai, IndiaSep 14, 2023 · VT-DBL · Substantial damageNTSB GAA23WA263Accident · No injuriesClass 5 · ForeignFairchild 24 G · Trier-Föhren, GermanySep 12, 2023 · N19109 · Substantial damageNTSB GAA23WA275AccidentClass 5 · ForeignFairchild 227-DC · Detour Lake, CanadaSep 7, 2023 · C-GJVWNTSB GAA23WA248Accident · No injuriesClass 5 · ForeignBeech 200C · Port Moresby, Papua New GuineaSep 1, 2023 · P2-JAU · Substantial damageNTSB DCA23WA444Incident · No injuriesClass 5 · ForeignAirbus A319 · Samui, ThailandAug 29, 2023 · HS-PGN · No damageNTSB DCA23WA424AccidentClass 5 · ForeignBeech 99 · Black Point, BahamasAug 25, 2023 · C6-FLRNTSB DCA23WA436IncidentClass 5 · ForeignAerospatiale/Aeritalia ATR 42-300 · Freeport, BahamasAug 21, 2023 · N920FX · No damageNTSB GAA23WA266Accident · No injuriesClass 5 · ForeignBeecraft G58 · Oita airoprt, JapanAug 14, 2023 · JA51HA · Substantial damageNTSB GAA23WA236Accident · No injuriesClass 5 · ForeignCessna 350 · Barcelona, SpainAug 11, 2023 · N1097L · Substantial damageNTSB DCA23WA422Accident · No injuriesClass 5 · ForeignATR ATR72 · Gran Canaria, SpainAug 9, 2023 · EC-MVINTSB GAA23WA241AccidentClass 5 · ForeignCessna 208 · Limpopo Province, South AfricaAug 7, 2023 · ZS-JEM · Minor damageNTSB DCA23WA398Incident · No injuriesClass 5 · ForeignBoeing 747-481F · Ningbo, ChinaAug 7, 2023 · N401KZ · No damageNTSB DCA23WA401Accident · No injuriesClass 5 · ForeignBoeing 737 · South Kalimantan, IndonesiaAug 6, 2023 · PK-GNM · Substantial damageNTSB GAA23WA232Accident · No injuriesClass 5 · ForeignCessna 180H · Lolland, DenmarkAug 5, 2023 · N9902V · Substantial damageNTSB ENG23WA038Incident · No injuriesClass 5 · ForeignSocata TBM700 · Kota Bharu, MalaysiaAug 4, 2023 · N188SJ · Minor damageNTSB GAA23WA224Accident · No injuriesClass 5 · ForeignPiper 25 · Caboolture, AustraliaJul 28, 2023 · VH-SPA · Substantial damageNTSB DCA24WA196Incident · No injuriesClass 5 · ForeignBoeing 737 · Osaka, JapanJul 20, 2023 · B-5156 · No damageNTSB GAA23WA219Accident · Serious injuriesClass 5 · ForeignCessna 206 · Tuzla, RomaniaJul 15, 2023 · F-HGAZ · DestroyedNTSB DCA23WA361Incident · No injuriesClass 5 · ForeignBoeing 767-300 · Chitose, JapanJul 12, 2023 · JA614J · No damageNTSB GAA23WA206Accident · No injuriesClass 5 · ForeignBeecraft 1A · Bengaluru, IndiaJul 11, 2023 · VT-KBN · Substantial damageNTSB DCA23WA379Occurrence · No injuriesClass 5 · ForeignBoeing 767 · Manaus, BrazilJul 6, 2023 · PR-ABB · Minor damageNTSB GAA23WA195AccidentClass 5 · ForeignPiper PA-23-250 · The Valley, AnguillaJul 4, 2023 · N15YPNTSB GAA23WA188Accident · 2 fatalClass 5 · ForeignCessna 206 · Gracias A Dios, HondurasJul 3, 2023 · HR-NCH · Substantial damageNTSB DCA23WA345OccurrenceClass 5 · ForeignBoeing 777 · Dhaka, BangladeshJun 28, 2023 · HZ-AK28 · No damageNTSB GAA23WA201Incident · No injuriesClass 5 · ForeignLearjet 45 · Estado La Guaira, VenezuelaJun 27, 2023 · YV2716 · Minor damageNTSB GAA23WA186Accident · No injuriesClass 5 · ForeignGulfstream II · Zumpango, MexicoJun 27, 2023 · XC-LPY · Substantial damageNTSB GAA23WA176Accident · Minor injuriesClass 5 · ForeignCessna 182 · Jelenia Góra, PolandJun 25, 2023 · D-EDYP · Substantial damageNTSB DCA23WA325IncidentClass 5 · ForeignBoeing 747 · Bangkok, ThailandMay 29, 2023 · B-2425 · Minor damageNTSB DCA23WA301Incident · No injuriesClass 5 · ForeignBoeing 737 · Jeddah, Saudi ArabiaMay 27, 2023 · SU-GEMNTSB GAA23WA154Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Norman's Cay, BahamasMay 26, 2023 · N522AR · Substantial damage