NTSB investigations, 2022, Outside the U.S.

75 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 2022, 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\") = 2022
    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 GAA23WA047Incident · No injuriesClass 3 · ForeignCessna 750 · Rionegro, ColombiaDec 29, 2022 · N156VP · No damageNTSB GAA23WA084Accident · 1 fatalClass 5 · ForeignSocata TB21 · Saint-Pons, FranceDec 28, 2022 · N229GC · DestroyedNTSB GAA23WA094Accident · No injuriesClass 5 · ForeignMooney M20R · Vélez-Málaga, SpainDec 20, 2022 · N78VE · Substantial damageNTSB DCA23WA474OccurrenceClass 5 · ForeignBoeing 737 · Dortmund, GermanyDec 5, 2022 · EI-DLV · No damageNTSB DCA23WA091AccidentClass 5 · ForeignBoeing 737 · Dortmund, GermanyDec 5, 2022 · EI-DLV · Substantial damageNTSB ERA23LA081Accident · No injuriesClass 4 · LimitedFinal reportLearjet 35 · Guantanamo Bay, CubaThe flight crew’s continuation of an unstable approach which resulted in abnormal runway contact during the landing flare and touchdown.Dec 2, 2022 · N979RF · Substantial damageNTSB DCA23WA099Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Bangkok, ThailandNov 26, 2022 · HS-DBO · No damageNTSB DCA23WA075Incident · No injuriesClass 5 · ForeignBoeing 737 · Breslau, CanadaNov 25, 2022 · C-FFLC · No damageNTSB GAA23WA040Accident · No injuriesClass 5 · ForeignCessna P206D · La Familia, BelizeNov 21, 2022 · N8725Z · No damageNTSB DCA23WA062Occurrence · No injuriesClass 5 · ForeignDouglas DC3 · Balikpapan, IndonesiaNov 13, 2022 · C-FTGX · Minor damageNTSB DCA23WA051IncidentClass 5 · ForeignBoeing 737 · Amman, JordanNov 6, 2022 · JY-JAD · Minor damageNTSB DCA23WA042Incident · No injuriesClass 5 · ForeignBoeing 737 · Kitchener, CanadaOct 30, 2022 · C-FLWJ · No damageNTSB ENG23WA003IncidentClass 5 · ForeignBombardier BD-700-2A12 · Nanjing Lukou International Airport, Hong Kong SAR ChinaOct 27, 2022 · N899ST · Minor damageNTSB DCA23WA029Accident · No injuriesClass 5 · ForeignAirbus A330 · Mactan-Cebu, PhilippinesOct 23, 2022 · HL7525 · Substantial damageNTSB DCA23WA025IncidentClass 5 · ForeignBoeing 737 · Dhaka, BangladeshOct 21, 2022 · S2-AJD · Minor damageNTSB DCA23WA031Incident · No injuriesClass 5 · ForeignEmbraer EMB145 · Paris, FranceOct 20, 2022 · F-HYOG · Minor damageNTSB GAA23WA017Accident · 2 fatalClass 5 · ForeignCessna T206G · Guayaquil, EcuadorOct 18, 2022 · HC-CLR · DestroyedNTSB GAA23WA014Incident · No injuriesClass 3 · ForeignCessna 172 · Yao, JapanOct 18, 2022 · JA80AP · No damageNTSB GAA23WA015Accident · 1 fatalClass 3 · ForeignCessna 172 · Ulsan, South KoreaOct 13, 2022 · HL1174 · Substantial damageNTSB GAA23WA006Incident · No injuriesClass 5 · ForeignLearjet 45 · Sao Paulo, BrazilOct 9, 2022 · PP-MIX · Minor damageNTSB DCA23WA473IncidentClass 5 · ForeignBoeing 737 · Hatay, TürkiyeOct 6, 2022 · TC-JVN · Minor damageNTSB DCA23WA013IncidentClass 5 · ForeignBoeing 737 · Hatay, TürkiyeOct 6, 2022 · TC-JVN · Minor damageNTSB DCA23WA001Accident · No injuriesClass 5 · ForeignBoeing 737 · Nantes, FranceOct 1, 2022 · F-GZHA · Substantial damageNTSB DCA22WA213Incident · No injuriesClass 5 · ForeignBoeing 737 · Panama City, PanamaSep 25, 2022 · HP-1539 CMP · Substantial damageNTSB DCA22WA209Accident · Minor injuriesClass 4 · ForeignBoeing 737 · Montpellier, FranceSep 24, 2022 · EC-NLSNTSB GAA22WA317Accident · No injuriesClass 4 · ForeignPiper PA38 · Jujuy, ArgentinaSep 22, 2022 · LV-OIB · Substantial damageNTSB DCA22WA205OccurrenceClass 5 · ForeignBeech 1900 · Brazzaville, Congo - KinshasaSep 19, 2022 · TN-AIQNTSB GAA22WA316Accident · Serious injuriesClass 5 · ForeignCessna 208 · Al Ajban, United Arab EmiratesAug 31, 2022 · N208JM · DestroyedNTSB GAA22WA296AccidentClass 4 · ForeignCessna 208B · Timika, IndonesiaAug 30, 2022 · PK-SNW · Substantial damageNTSB GAA22WA260Accident · No injuriesClass 5 · ForeignCessna 172 · Malloca, SpainAug 21, 2022 · EC-ETC · Substantial damageNTSB DCA22WA184Incident · No injuriesClass 5 · ForeignBoeing 737 · Banjarmasin, IndonesiaAug 14, 2022 · PK-YGV · Minor damageNTSB GAA22WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Sungai Pinji, MalaysiaAug 1, 2022 · 9M-BAA · DestroyedNTSB DCA22WA164Accident · No injuriesClass 5 · ForeignBoeing 737-800 · Chiang Rai, ThailandJul 30, 2022 · HS-DBR · Substantial damageNTSB GAA22WA312Accident · No injuriesClass 5 · ForeignCessna 172P · Mukuchi - Sangar, RussiaJul 28, 2022 · RA-67332 · Substantial damageNTSB GAA22WA315Incident · No injuriesClass 5 · ForeignCessna 560 · Salta, ArgentinaJul 24, 2022 · LV-KFB · Minor damageNTSB GAA22WA239Accident · No injuriesClass 5 · ForeignCessna 152 · Baramati, IndiaJul 22, 2022 · VT-ALI · Substantial damageNTSB GAA22WA236Accident · No injuriesClass 3 · ForeignGulfstream GIV · Jeddah, Saudi ArabiaJul 13, 2022 · HZ-A23 · Substantial damageNTSB GAA23WA010IncidentClass 5 · ForeignBeech 400A · Cornwall, United KingdomJul 10, 2022 · N709ELNTSB GAA22WA230Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Oktyabsky, RussiaJul 9, 2022 · RA-04373 · Substantial damageNTSB GAA22WA224Accident · No injuriesClass 5 · ForeignRobinson R44 · Novy township, RussiaJul 1, 2022 · RA-06228 · Substantial damageNTSB DCA22WA137Incident · No injuriesClass 5 · Foreign737 800 · Cairo, EgyptJun 25, 2022 · SU-GCZ · Minor damageNTSB DCA22WA136Incident · No injuriesClass 5 · Foreign737 800 · Dubrovnik, CroatiaJun 25, 2022 · G-JZBC · Minor damageNTSB GAA22WA207Accident · No injuriesClass 5 · ForeignPiper PA-23-250 · The Settlement, British Virgin IslandsJun 23, 2022 · N13987 · Substantial damageNTSB GAA22WA184AccidentClass 5 · ForeignRans S6-ES · Hampshire, United KingdomMay 17, 2022 · G-CCTV · Substantial damageNTSB GAA22WA276Accident · No injuriesClass 4 · ForeignTecnam P2006T · Bhiwani, IndiaMay 12, 2022 · VT-VDB · Substantial damageNTSB GAA22WA174AccidentClass 4 · ForeignBeech 200 · Pudahuel, ChileMay 6, 2022 · CC-CDY · Substantial damageNTSB DCA22WA122Accident · No injuriesClass 5 · ForeignBoeing 737 · Naples, ItalyMay 6, 2022 · YR-BMM · Substantial damageNTSB GAA22WA170AccidentClass 5 · ForeignCessna U206 · Camanaos, ColombiaMay 1, 2022 · HK4228 · Minor damageNTSB GAA22WA169Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Konstanz, GermanyApr 27, 2022 · N241PKNTSB GAA22WA157Accident · Serious injuriesClass 5 · ForeignBeech BE58 · Kununurra, AustraliaApr 16, 2022 · VH-NPT · Destroyed