NTSB investigations, 2022, Outside the U.S.

41 cases where the phase of flight was Takeoff.

Cases per year

19622026
NTSB investigations, 2022, Outside the U.S. per year, 1962–2026: 646 cases
19621
19649
19658
19666
19675
19689
19696
19705
19714
19725
19734
19747
19755
19762
19772
19781
19792
19801
19951
19961
20071
20089
20097
20108
201115
201211
20139
201418
201529
201629
201742
201829
201932
202030
202139
202241
202361
202471
202555
202626

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 = 300)
  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 ENG23WA007Incident · No injuriesClass 4 · ForeignBoeing 737 · Mogadishu, SomaliaDec 26, 2022 · C5-MAB · Minor damageNTSB ENG23WA006Incident · No injuriesClass 4 · ForeignBoeing 737 · Mogadishu, SomaliaDec 26, 2022 · ET-APL · Minor damageNTSB ENG23WA008IncidentClass 3 · ForeignAirbus A320 · Guadalajara, MexicoDec 24, 2022 · XA-VIO · Minor damageNTSB GAA23WA074Accident · No injuriesClass 5 · ForeignThrush S2R · Gunung Mas Regency, IndonesiaDec 17, 2022 · PK-PND · Substantial damageNTSB GAA23WA044AccidentClass 4 · ForeignCessna 188 · InaciolâNdia, BrazilDec 8, 2022 · PR-ADK · Substantial damageNTSB DCA23WA088IncidentClass 5 · ForeignBoeing 737 · Brisbane, AustraliaNov 30, 2022 · VH-YFKNTSB GAA23WA031Accident · 2 fatalClass 5 · ForeignRobinson R66 · Kesova Gora, RussiaNov 27, 2022 · RA- 07390 · DestroyedNTSB DCA23WA076Incident · No injuriesClass 5 · ForeignBoeing 737 · Maiquetía, VenezuelaNov 24, 2022 · YV-621T · No damageNTSB DCA23WA066Accident · 2 fatalClass 5 · ForeignAirbus A320 · Lima, PeruNov 18, 2022 · CC-BHB · Substantial damageNTSB DCA23WA049Incident · Minor injuriesClass 5 · ForeignSaab 340 · Canberra, AustraliaNov 10, 2022 · VH-VEQ · Minor damageNTSB DCA23WA054IncidentClass 5 · ForeignSaab 340 · Whitemark, AustraliaNov 4, 2022 · VH-ZRC · Minor damageNTSB ENG23WA002IncidentClass 5 · ForeignAirbus A320 · Delhi, IndiaOct 28, 2022 · VT-IFM · No damageNTSB DCA23WA037Incident · No injuriesClass 5 · ForeignBoeing 777-223 · Buenos Aires, ArgentinaOct 28, 2022 · N765AN · Minor damageNTSB GAA23WA007Accident · 1 fatalClass 3 · ForeignCirrus SF50 · Santa Marta, ColombiaOct 16, 2022 · HK-5342 · Substantial damageNTSB GAA23WA002Accident · 1 fatalClass 5 · ForeignCessna 172 · Curatone, ItalyOct 2, 2022 · I-EDUK · DestroyedNTSB DCA23WA002Incident · No injuriesClass 5 · ForeignBoeing 777 · Manila, PhilippinesOct 1, 2022 · HZ-AK28 · Minor damageNTSB DCA22WA208Accident · 1 fatalClass 5 · ForeignBAE 3201EP · San Antonio del Estrecho, PeruSep 20, 2022 · OB-2152 · DestroyedNTSB DCA23WA014IncidentClass 5 · ForeignBoeing 777-222 · Schiphol, NetherlandsSep 2, 2022 · N787UA · No damageNTSB GAA22WA271Accident · No injuriesClass 5 · ForeignAyres S2R · Trangie, AustraliaAug 31, 2022 · VH-IWI · Minor damageNTSB GAA22WA283Accident · 5 fatalClass 5 · ForeignCessna 210 · Impalia, NamibiaAug 30, 2022 · V5-LMK · DestroyedNTSB DCA22WA187IncidentClass 5 · ForeignMcdonnell Douglas DC-9-83 · Maiquetia, VenezuelaAug 21, 2022 · YV3465 · No damageNTSB GAA22WA255Accident · 2 fatalClass 5 · ForeignPiper PA28 · Nipigon, CanadaAug 14, 2022 · C-FYSZ · Substantial damageNTSB GAA22WA256Accident · No injuriesClass 5 · ForeignPiper PA46 · High Wycombe, United KingdomJul 9, 2022 · G-LAMI · Substantial damageNTSB GAA22WA218Accident · 4 fatalClass 3 · ForeignLearjet 35 · Tierra del Fuego, ArgentinaJul 1, 2022 · LV-BPA · Substantial damageNTSB GAA22WA210Accident · No injuriesClass 5 · ForeignRobinson R44 · East Sussex, United KingdomJun 26, 2022 · G-CIMZ · Substantial damageNTSB GAA22WA208Accident · 1 fatalClass 5 · ForeignCessna 182 · Itaituba, BrazilJun 15, 2022 · PT-JUM · Substantial damageNTSB GAA22WA197Accident · 1 fatalClass 3 · ForeignPiper PA31 · Deadman's Cay, BahamasJun 5, 2022 · N711JW · Substantial damageNTSB GAA22WA202Accident · Serious injuriesClass 5 · ForeignSorrel SNS8 · Madrid, SpainMay 25, 2022 · EC-519 · DestroyedNTSB GAA22WA189Incident · No injuriesClass 5 · ForeignCessna 560 · Schwäbisch Hall, GermanyMay 23, 2022 · D-CSEB · No damageNTSB DCA22WA123Incident · No injuriesClass 5 · ForeignBoeing 737 · Kathmandu, NepalMay 6, 2022 · 9V-MGL · Minor damageNTSB GAA22WA120Accident · 2 fatalClass 5 · ForeignBeech A36 · Ie, JapanMar 12, 2022 · JA4577 · Substantial damageNTSB DCA22WA095Incident · No injuriesClass 5 · ForeignBoeing 737 · Manchester, United KingdomMar 9, 2022 · G-TAWY · Minor damageNTSB DCA22WA093IncidentClass 5 · ForeignMcdonnell Douglas MD82 · Maiquetia, VenezuelaMar 5, 2022 · YV2923 · No damageNTSB DCA22WA090Incident · No injuriesClass 5 · ForeignBoeing 737 · Karachi, PakistanMar 2, 2022 · AP-BNB · Minor damageNTSB ENG22WA011IncidentClass 5 · ForeignAirbus A319 · Mexico City, MexicoFeb 15, 2022 · N354NBNTSB GAA22WA091Accident · 7 fatalClass 5 · ForeignCessna 207 · Ica, PeruFeb 4, 2022 · OB-2179 · DestroyedNTSB ENG22WA008IncidentClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaFeb 3, 2022 · TN-AJYNTSB GAA22WA086AccidentClass 5 · ForeignAir Tractor AT602 · Luís Eduardo Magalhães,, BrazilJan 20, 2022 · PS-RAF · Substantial damageNTSB DCA22WA071Incident · No injuriesClass 5 · ForeignBoeing 737 · Barcelona, VenezuelaJan 15, 2022 · YV2794 · No damageNTSB GAA22WA314Accident · No injuriesClass 4 · ForeignAir Tractor AT602 · Santo Tome, Corrientes, ArgentinaJan 13, 2022 · LV-WZE · Substantial damageNTSB GAA22WA116Accident · No injuriesClass 5 · ForeignCruiser PS-28 · Casarrubios, SpainJan 10, 2022 · EC-NKP · Substantial damage