NTSB investigations, 2022, Outside the U.S.

41 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2022, Outside the U.S. per year, 1964–2026: 545 cases
19644
19653
19666
19674
19682
19691
19705
19713
19723
19733
19741
19751
19782
19871
19901
19971
19992
20031
20071
20084
20099
20109
201118
201217
201321
201419
201542
201630
201737
201836
201925
202025
202139
202241
202341
202435
202540
202612

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 = 450)
  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 GAA23WA039Accident · 5 fatalClass 5 · ForeignCenterpoint Aerospace S-58T · Yang Yang, South KoreaNov 27, 2022 · HL9678NTSB GAA23WA032Accident · Serious injuriesClass 5 · ForeignRobinson R44 · Richmond, AustraliaNov 19, 2022 · VH-TKI · Substantial damageNTSB GAA23WA041Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Vera, BrazilNov 18, 2022 · PP-OBL · Substantial damageNTSB GAA23WA025Accident · 1 fatalClass 3 · ForeignBell UH-1 · San Clemente, ChileNov 3, 2022 · CC-CXZ · Substantial damageNTSB ENG23WA017Accident · 3 fatalClass 5 · ForeignAirbus Helicopters MBB BK117 · Tabasco, MexicoOct 1, 2022 · XB-NWY · Substantial damageNTSB GAA22WA290Accident · 1 fatalClass 5 · ForeignMeriwether Jon Arion Lightning · Kenora, CanadaSep 21, 2022 · N638JM · DestroyedNTSB GAA22WA285Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Chinchilla, AustraliaSep 19, 2022 · VH-KHD · Substantial damageNTSB GAA22WA264AccidentClass 5 · ForeignMooney M20J · Braunschweig, GermanyAug 30, 2022 · D-EKPC · Substantial damageNTSB GAA22WA263Accident · 1 fatalClass 5 · ForeignPitts S1S · Shobdon, United KingdomAug 26, 2022 · G-BOXV · DestroyedNTSB GAA22WA261Accident · 1 fatalClass 5 · ForeignRobinson R22 · Albosaggia, ItalyAug 10, 2022 · I-JADE · Substantial damageNTSB GAA22WA257Accident · 1 fatalClass 5 · ForeignAyres S2R · Morden Reginao, CanadaAug 3, 2022 · C-GOKD · DestroyedNTSB GAA22WA307Accident · 2 fatalClass 5 · ForeignRobinson R44 · Off shore, EcuadorJul 28, 2022 · HC-CLZ · Substantial damageNTSB GAA22WA313Accident · Serious injuriesClass 5 · ForeignPiper PA25 · Trinidad, ColombiaJul 26, 2022 · HK 1207 · DestroyedNTSB GAA22WA235Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Tiquisate, GuatemalaJul 20, 2022 · TG-OLM · Substantial damageNTSB GAA22WA259Accident · No injuriesClass 5 · ForeignMXR Technologies MXS · Hajdúszoboszló, HungaryJul 16, 2022 · N540XX · Substantial damageNTSB GAA22WA228Accident · 1 fatalClass 5 · ForeignAir Tractor AT-802F · Vila Nova de Foz Côa-Guarda, PortugalJul 15, 2022 · CS-EDY · DestroyedNTSB GAA22WA226Accident · 1 fatalClass 5 · ForeignCessna A188 · Puerto Lopez, ColombiaJul 15, 2022 · HK1368 · DestroyedNTSB GAA22WA221Accident · No injuriesClass 5 · ForeignRobin DR400 · Lyon-Bron, FranceJul 8, 2022 · HB-KBX · DestroyedNTSB GAA22WA303OccurrenceClass 5 · ForeignUas Sea Fly Alta-X · South Oxfordshire, United KingdomJun 29, 2022 · UNREGNTSB GAA22WA213Accident · No injuriesClass 4 · ForeignGrumman G164 · Cayo, BelizeJun 23, 2022 · V3-BEN · Substantial damageNTSB GAA22WA206Accident · 6 fatalClass 3 · ForeignLearjet 55 · Caracas, VenezuelaJun 22, 2022 · YV3304 · Substantial damageNTSB GAA22WA198AccidentClass 5 · ForeignCessna 206 · Punaauia, French PolynesiaJun 7, 2022 · F-BXAM · Substantial damageNTSB GAA22WA199Accident · 3 fatalClass 5 · ForeignBell 206 · Currais Novos, BrazilJun 5, 2022 · PP-MCJ · DestroyedNTSB GAA22WA194Accident · No injuriesClass 5 · ForeignBell 206 · Riohacha, Guajira, ColombiaMay 27, 2022 · HK5268 · Substantial damageNTSB GAA22WA175Accident · Minor injuriesClass 5 · ForeignPiper PA25 · Clan Airfield, South AfricaMay 3, 2022 · ZS-AWX · Substantial damageNTSB GAA22WA171Accident · 4 fatalClass 5 · ForeignPiper PA28 · Sioux Lookout Ontario, CanadaApr 30, 2022 · C-GLKD · Substantial damageNTSB GAA22WA166AccidentClass 4 · ForeignPiper PA25 · Cabeceiras, BrazilApr 18, 2022 · PT-WCQ · Substantial damageNTSB GAA22WA165Accident · 1 fatalClass 5 · ForeignCessna 188 · Mineiros, BrazilApr 14, 2022 · PR-AAM · Substantial damageNTSB GAA22WA132Accident · 1 fatalClass 5 · ForeignSukhoi SU-31 · Ploiesti, RomaniaMar 26, 2022 · N131BT · DestroyedNTSB GAA22WA126Accident · Serious injuriesClass 5 · ForeignAyres SRT34 · Antioquia, ColombiaMar 20, 2022 · HK3282 · Substantial damageNTSB GAA22WA201Accident · Serious injuriesClass 5 · ForeignBell 206L-1 · Cooma, AustraliaMar 11, 2022 · VH-BHFNTSB GAA22WA156Accident · No injuriesClass 5 · ForeignBell 412 · Coelemu, ChileMar 11, 2022 · CC-APK · Substantial damageNTSB GAA22WA113Accident · 1 fatalClass 5 · ForeignCessna U206G · Norseman, AustraliaMar 3, 2022 · VH-JVR · DestroyedNTSB GAA22WA119Accident · 1 fatalClass 5 · ForeignPiper PA25 · Eldorado, BrazilMar 1, 2022 · PP-IAI · Substantial damageNTSB GAA22WA110Accident · No injuriesClass 5 · ForeignRobinson R22 · Bilinga, AustraliaFeb 25, 2022 · VH-THM · Substantial damageNTSB GAA22WA109Accident · 1 fatalClass 5 · ForeignPiper PA-25-235 · Leongatha, AustraliaFeb 22, 2022 · VH-SEH · DestroyedNTSB GAA22WA103AccidentClass 5 · ForeignGarlick UH1H · Devonport, AustraliaFeb 14, 2022 · VH-UHX · DestroyedNTSB GAA22WA098AccidentClass 5 · ForeignPiper PA-32-300 · Wiston East Sussex, United KingdomFeb 10, 2022 · G-KNOW · DestroyedNTSB GAA22WA101Accident · 1 fatalClass 5 · ForeignAir Tractor AT402 · Chapadão do Sul, BrazilFeb 5, 2022 · PR-JPY · DestroyedNTSB GAA22WA094Incident · No injuriesClass 4 · ForeignRobinson R22 · Mitchell, AustraliaJan 11, 2022 · VH-VHE · Minor damageNTSB GAA22WA067Accident · 2 fatalClass 5 · ForeignPiper PA-32-260 · Chame, PanamaJan 3, 2022 · N5535J