NTSB investigations, 2022, Outside the U.S.

60 cases where the phase of flight was Unknown.

Cases per year

19642026
NTSB investigations, 2022, Outside the U.S. per year, 1964–2026: 716 cases
19644
19653
19665
19675
19681
19702
19711
19733
19746
19756
19783
19791
19821
19851
19872
19931
19951
20031
20083
20092
201013
201110
20127
20139
201418
201522
201629
201733
201838
201920
202028
202147
202260
202335
202442
202553
2026200

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 = 990)
  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 GAA23WA051Accident · 2 fatalClass 5 · ForeignCessna 210N · Bulman, AustraliaDec 25, 2022 · VH-TFT · DestroyedNTSB GAA23WA045Accident · 2 fatalClass 5 · ForeignBell 412EP · Ocean, MexicoDec 22, 2022 · XA-BNANTSB GAA23WA038Accident · No injuriesClass 5 · ForeignBeech 95-B55 · Jraber township, ArmeniaDec 1, 2022 · OM-KVV · DestroyedNTSB GAA23WA037Accident · 1 fatalClass 5 · ForeignRobinson R22 · Ramingining, AustraliaNov 14, 2022 · VH-LOS · Substantial damageNTSB GAA23WA026AccidentClass 5 · ForeignBeech 33 · San Felipe, VenezuelaNov 3, 2022 · YV-2052 · Substantial damageNTSB GAA23WA060Accident · 2 fatalClass 5 · ForeignAirbus AS350 · Trøndelag county, NorwayNov 1, 2022 · LN-OBP · Substantial damageNTSB GAA23WA012Accident · 1 fatalClass 5 · ForeignThrush S2R-T660 · Sierra Segundera, SpainOct 19, 2022 · EC-MXL · Substantial damageNTSB GAA23WA009Accident · 7 fatalClass 5 · ForeignBell 407 · Rudraprayag, IndiaOct 18, 2022 · VT-RPN · DestroyedNTSB GAA23WA008Accident · Serious injuriesClass 5 · ForeignMooney M20J · Luskintyre, AustraliaOct 17, 2022 · VH-UDQ · DestroyedNTSB GAA23WA020Accident · No injuriesClass 5 · ForeignEurocopter AS350 · Los Jaramillos, PanamaOct 8, 2022 · HP-1806RK · Substantial damageNTSB GAA23WA005Accident · 1 fatalClass 5 · ForeignBell 206 · Maitland, AustraliaOct 6, 2022 · VH-PHP · DestroyedNTSB GAA23WA001Accident · 1 fatalClass 5 · ForeignCessna 206 · Vielbrunn, GermanyOct 3, 2022 · F-HMDRNTSB GAA23WA003Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cunderdin, AustraliaOct 2, 2022 · VH-RAS · DestroyedNTSB GAA22WA302Accident · 2 fatalClass 5 · ForeignRobinson R44 · Joyabaj, GuatemalaSep 29, 2022 · TG-UMG · DestroyedNTSB GAA22WA301Accident · 2 fatalClass 5 · ForeignWagaero Sportsman · Champais, Quebec, CanadaSep 23, 2022 · C-FFDA · Substantial damageNTSB GAA22WA287Accident · 2 fatalClass 5 · ForeignCessna 172 · Shaunavon, CanadaSep 18, 2022 · C-GZLU · Substantial damageNTSB GAA22WA297AccidentClass 5 · ForeignDan Hawken Titan T-51 · Soest, GermanySep 17, 2022 · N132MK · Substantial damageNTSB GAA22WA280Accident · 1 fatalClass 4 · ForeignAir Tractor AT502 · Camrose, CanadaSep 12, 2022 · C-FJVL · Substantial damageNTSB GAA22WA282Accident · 1 fatalClass 5 · ForeignEurocopter EC120B · Bidor, MalaysiaSep 11, 2022 · N409HH · DestroyedNTSB GAA22WA278Accident · 1 fatalClass 5 · ForeignCessna 208B · Oriximina, BrazilSep 10, 2022 · PT-MES · Substantial damageNTSB GAA22WA273Accident · Minor injuriesClass 5 · ForeignCessna 172 · Barrancominas, ColombiaSep 9, 2022 · HK2573 · Substantial damageNTSB GAA22WA292AccidentClass 3 · ForeignAgusta A119 · Mount Cusna, ItalySep 6, 2022 · I-ELOP · Substantial damageNTSB GAA22WA252Accident · No injuriesClass 5 · ForeignMooney M20E · Augsburg, GermanyAug 17, 2022 · F-BRHA · Substantial damageNTSB GAA22WA245Accident · 1 fatalClass 5 · ForeignPiper PA11 · Aeródromo Chañar Ladeado, Santa Fe, ArgentinaAug 9, 2022 · LV-NIG · Substantial damageNTSB GAA22WA248Accident · 1 fatalClass 5 · ForeignRobinson R44 · Lanzhou, ChinaAug 7, 2022 · B-70F2 · Substantial damageNTSB GAA22WA254Accident · 1 fatalClass 5 · ForeignRobinson R44 · Loanda, BrazilJul 19, 2022 · PR-EGD · DestroyedNTSB GAA22WA231Accident · 2 fatalClass 5 · ForeignUnited Consultants UC-1 · Lake Siljan, SwedenJul 18, 2022 · N747HJNTSB GAA22WA241AccidentClass 5 · ForeignCessna 172RG · Aaachen, GermanyJul 16, 2022 · D-EWAE · 2 aircraft · Substantial damageNTSB GAA22WA233Accident · 3 fatalClass 4 · ForeignRobinson R44 · Kronotsky Nature Reserve, RussiaJul 16, 2022 · RA-07350 · DestroyedNTSB GAA22WA227Accident · 2 fatalClass 5 · ForeignPiper PA-31-325 · Queretaro, MexicoJul 12, 2022 · N28DF · Substantial damageNTSB GAA22WA225Accident · 2 fatalClass 4 · ForeignBell 206 · Boa Vista, BrazilJul 12, 2022 · PT-HQU · Substantial damageNTSB GAA22WA222Accident · 1 fatalClass 5 · ForeignBell 206 · Richmond, AustraliaJul 9, 2022 · VH-ZMF · DestroyedNTSB DCA22WA172IncidentClass 5 · ForeignAirbus A320 · Tbd, OmanJul 4, 2022 · A4O-OVH · 2 aircraft · No damageNTSB GAA22WA299Accident · 2 fatalClass 5 · ForeignBlackshape BS115 · Zwarte Meer, NetherlandsJun 28, 2022 · PH-TRC · Substantial damageNTSB GAA22WA204Accident · 1 fatalClass 5 · ForeignBell 412 · Timika, IndonesiaJun 8, 2022 · PK-DAR · Substantial damageNTSB DCA22WA130IncidentClass 5 · ForeignAirbus A320 · Peshawar, PakistanJun 5, 2022 · EX32009 · 2 aircraft · No damageNTSB GAA22WA195Accident · 1 fatalClass 5 · ForeignCessna 182 · Chirijox, GuatemalaJun 4, 2022 · TG-PIM · DestroyedNTSB GAA22WA196Accident · 2 fatalClass 5 · ForeignCessna 152 · Klobuck, PolandJun 2, 2022 · SP-AKW · DestroyedNTSB GAA22WA191Accident · 1 fatalClass 5 · ForeignCessna U206G · Sandy Lake First Nation, CanadaMay 26, 2022 · C-GBGJ · Substantial damageNTSB GAA22WA187Accident · 2 fatalClass 5 · ForeignSmith Aerostar 601P · Ceballos, MexicoMay 23, 2022 · N66CG · DestroyedNTSB GAA22WA298Accident · 5 fatalClass 5 · ForeignRobin D140 · Grenoble, FranceMay 21, 2022 · F-HJLB · Substantial damageNTSB GAA22WA190Accident · 2 fatalClass 5 · ForeignPiper PA25 · Brasilandia De Minas, BrazilMay 17, 2022 · PR-CTD · Substantial damageNTSB GAA22WA185Accident · 1 fatalClass 5 · ForeignSikorsky S61N · Tongyeong-si, KiribatiMay 16, 2022 · HL9490NTSB GAA22WA220Accident · No injuriesClass 5 · ForeignCessna 172 · Augsburg, GermanyMay 2, 2022 · D-EOYS · Substantial damageNTSB GAA22WA162Accident · 1 fatalClass 5 · ForeignMooney M20K · Springbank, AB, CanadaApr 22, 2022 · C-GQMS · Substantial damageNTSB GAA22WA161Accident · Serious injuriesClass 5 · ForeignReims F172 · Hodenhagen, GermanyApr 17, 2022 · D-ELEO · Substantial damageNTSB GAA22WA158Accident · No injuriesClass 5 · ForeignMonnett Sonerai · Jyväskylä, FinlandApr 17, 2022 · OH-XMA · DestroyedNTSB ENG22WA019Accident · 3 fatalClass 5 · ForeignSikorsky S92 · Jeju Island, South KoreaApr 8, 2022 · B519NTSB GAA22WA147Accident · 1 fatalClass 4 · ForeignHughes 369 · Port McNeil, CanadaApr 6, 2022 · C-GJLC · Substantial damageNTSB GAA22WA144Accident · 2 fatalClass 5 · ForeignBell 206 · Adaminaby, AustraliaApr 4, 2022 · VH-PRW · Destroyed