NTSB investigations, 2023, Outside the U.S.

35 cases where the phase of flight was Unknown.

Cases per year

19642026
NTSB investigations, 2023, 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\") = 2023
    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 GAA24WA062Accident · 1 fatalClass 5 · ForeignCessna A185 · Dorotea, ColombiaDec 30, 2023 · HK1658G · Substantial damageNTSB GAA24WA049Accident · 5 fatalClass 5 · ForeignPiper PA-32-260 · Terre-de-Haut, GuadeloupeDec 4, 2023 · N15902NTSB GAA24WA036Accident · 1 fatalClass 5 · ForeignCessna 172 · Dinslaken, GermanyNov 17, 2023 · D-EDJL · DestroyedNTSB GAA24WA025Accident · 4 fatalClass 5 · ForeignCirrus SR20 · St. Andrä im Lunga, AustriaNov 2, 2023 · D-ESFB · DestroyedNTSB GAA24WA023Accident · 2 fatalClass 5 · ForeignRobinson R66 · Williamtown, AustraliaOct 26, 2023 · VH-KFT · DestroyedNTSB GAA24WA033Accident · 2 fatalClass 5 · ForeignPiper PA-24-250 · San Juan de la Costa, MexicoOct 9, 2023 · N6518P · Substantial damageNTSB GAA24WA006Accident · 4 fatalClass 4 · ForeignCirrus SR22 · Canberra, AustraliaOct 6, 2023 · VH-MSF · DestroyedNTSB GAA24WA003Accident · Serious injuriesClass 5 · ForeignCessna P210 · Venice, ItalyOct 4, 2023 · OK-TKN · Substantial damageNTSB GAA23WA282Accident · 5 fatalClass 5 · ForeignCessna 206G · Mashava, ZimbabweSep 29, 2023 · Z-CAM · Substantial damageNTSB GAA23WA272Accident · Minor injuriesClass 5 · ForeignPiper PA-28-140 · Herbert's Beach, St. Kitts & NevisSep 20, 2023 · N8716N · Substantial damageNTSB GAA23WA257AccidentClass 5 · ForeignRobinson R44 · Guatemala City, GuatemalaSep 15, 2023 · YS-1000P · Substantial damageNTSB GAA23WA280Accident · 3 fatalClass 5 · ForeignCessna 172N · Mountains, IcelandAug 31, 2023 · TF-KLO · DestroyedNTSB GAA23WA242Accident · 1 fatalClass 5 · ForeignPiper PA28 · Holstead Hall, Essex, United KingdomAug 21, 2023 · G-AYUH · DestroyedNTSB GAA23WA233Accident · No injuriesClass 5 · ForeignPiper 28 · Seaton, United KingdomAug 1, 2023 · G-AVSC · Substantial damageNTSB GAA23WA227Accident · No injuriesClass 5 · ForeignCessna 177 · Frejus (in water), FranceJul 30, 2023 · F-HKLA · DestroyedNTSB GAA23WA221AccidentClass 5 · ForeignCessna 150 · Alexandria, CanadaJul 26, 2023 · C-GFFG · Substantial damageNTSB GAA23WA207Accident · 1 fatalClass 5 · ForeignCessna 210 · Bradda Head, United KingdomJul 17, 2023 · G-TOTN · Substantial damageNTSB GAA23WA194Accident · 2 fatalClass 5 · ForeignLancair 360 · Habsheim, FranceJul 5, 2023 · PH-KER · DestroyedNTSB GAA23WA193Accident · 1 fatalClass 5 · ForeignBell 47 · Sainte-Marthe, FranceJul 4, 2023 · F-GKTR · DestroyedNTSB GAA23WA173Accident · 2 fatalClass 5 · ForeignBell 412 · Gom, MexicoJun 21, 2023 · XA-EHI · Substantial damageNTSB GAA23WA172Accident · No injuriesClass 5 · ForeignRobinson R44 · San Carlos de Boliva-Buenos Aires, ArgentinaJun 18, 2023 · LV-KBH · Substantial damageNTSB GAA23WA171Accident · No injuriesClass 5 · ForeignReims F · Herten-Rheinfelden, GermanyJun 17, 2023 · D-EGLP · Substantial damageNTSB GAA23WA153Accident · 3 fatalClass 5 · ForeignAvions Robin DR400 · Les Ponts-de-Martel, SwitzerlandMay 20, 2023 · HB-EQD · DestroyedNTSB GAA23WA146Accident · 2 fatalClass 5 · ForeignEngineering & Research 415-C · St. Mary, JamaicaMay 5, 2023 · N3254B · Substantial damageNTSB GAA23WA145Accident · No injuriesClass 5 · ForeignCirrus SR22 · Joanopolis, BrazilApr 28, 2023 · PR-DSC · Substantial damageNTSB GAA23WA135AccidentClass 5 · ForeignCessna 150 · St-Rémi-de-Laprairie, FranceApr 21, 2023 · C-FWGF · DestroyedNTSB GAA23WA093Accident · 1 fatalClass 5 · ForeignRobinson 44 · Boro Area, Okavango Delta, BotswanaMar 12, 2023 · A2-HEX · DestroyedNTSB DCA23WA225Incident · No injuriesClass 5 · ForeignBoeing 737 · Nuremberg, GermanyMar 11, 2023 · PH-BGF · No damageNTSB GAA23WA118Accident · 4 fatalClass 5 · ForeignSud Aviation/Eurocopter Alouette II SE313B · Mangsee Island, PhilippinesMar 1, 2023 · N45VXNTSB GAA23WA082Accident · 1 fatalClass 5 · ForeignRobinson 44 · Xian, ChinaFeb 17, 2023 · B-7683 · Substantial damageNTSB GAA23WA073AccidentClass 5 · ForeignCessna 340 · Mount Mayon, PhilippinesFeb 17, 2023 · RP-C2080 · DestroyedNTSB GAA23WA091Accident · 6 fatalClass 5 · ForeignCessna 206 · Barangay Ditarum, PhilippinesJan 24, 2023 · RP-C1174 · Substantial damageNTSB GAA23WA056Accident · 1 fatalClass 5 · ForeignAero Eli Servizi Yoyo · Lesna Jania, PolandJan 10, 2023 · SP HEYO · DestroyedNTSB GAA23WA063AccidentClass 5 · ForeignEurocopter EC130 B4 · Gold Coast, AustraliaJan 2, 2023 · VH-XKQ · 2 aircraft · Substantial damageNTSB GAA23WA062Accident · 2 fatalClass 5 · ForeignSling 4 TSI · Meyerton, South AfricaJan 2, 2023 · ZU-PPA · Substantial damage