NTSB investigations, 2022, Outside the U.S.

32 cases where the phase of flight was Approach.

Cases per year

19622026
NTSB investigations, 2022, Outside the U.S. per year, 1962–2026: 596 cases
19623
19649
196511
196613
19678
196810
19698
19706
19718
197213
197310
19745
19752
19763
19772
19784
19791
19802
19841
19881
19931
19951
19972
19991
20021
20041
20083
200915
20107
201115
201211
201330
201418
201516
201634
201723
201832
201930
202016
202135
202232
202349
202439
202543
202621

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 = 500)
  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 GAA23WA076Accident · 2 fatalClass 5 · ForeignBanus Mark Glasair Super II FT · Wedderburn, AustraliaDec 26, 2022 · N600 · DestroyedNTSB GAA23WA042Accident · 1 fatalClass 5 · ForeignPiper PA 46-350P · Happy Valley-Goose Bay, CanadaDec 14, 2022 · N5EQ · DestroyedNTSB GAA23WA043Accident · Minor injuriesClass 4 · ForeignPiper PA25 · Ponta Grossa, BrazilDec 5, 2022 · PT-WBH · Substantial damageNTSB DCA23WA071IncidentClass 5 · ForeignAirbus A320 · Marrakech, MoroccoNov 18, 2022 · G-MIDT · 2 aircraft · No damageNTSB GAA23WA023Accident · No injuriesClass 5 · ForeignCessna 182 · Igarassu, BrazilOct 29, 2022 · PT-DAB · Substantial damageNTSB DCA23WA045IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaOct 25, 2022 · VH-VZA · No damageNTSB DCA23WA033IncidentClass 5 · ForeignSaab 340 · Sydney, AustraliaOct 24, 2022 · VH-VEQ · No damageNTSB DCA23WA032IncidentClass 5 · ForeignBoeing 737 · Cairns, AustraliaOct 24, 2022 · VH-VUT · No damageNTSB DCA23WA046IncidentClass 5 · ForeignBoeing 737 · Sydney, AustraliaOct 19, 2022 · VH-YFT · No damageNTSB GAA23WA011Incident · No injuriesClass 5 · ForeignCessna 402 · Bahia Solano, ColombiaOct 14, 2022 · HK-3065 · No damageNTSB GAA22WA294Accident · 3 fatalClass 5 · ForeignCirrus SR22 · Toluca, MexicoSep 30, 2022 · XB-NGT · DestroyedNTSB ENG22WA045Incident · No injuriesClass 5 · ForeignATR ATR72 · Belfast, United KingdomSep 19, 2022 · EI-GPN · No damageNTSB GAA22WA284AccidentClass 5 · ForeignPiper PA 46-350P · Glisy, FranceSep 14, 2022 · N9190X · Substantial damageNTSB GAA22WA295AccidentClass 5 · ForeignKodiak 100 · Rendsburg-Schachtholm, GermanySep 12, 2022 · 2-RUFF · Substantial damageNTSB GAA22WA277Accident · No injuriesClass 5 · ForeignPiper PA-28-140 · Gloucestershire, United KingdomAug 4, 2022 · G-BCJN · Substantial damageNTSB GAA22WA269Accident · 2 fatalClass 5 · ForeignShort SC7 · Piotrków Trybunalski, PolandAug 3, 2022 · SP-SIP · DestroyedNTSB GAA22WA266Accident · Serious injuriesClass 5 · ForeignCessna 172 · Qualicum Beach, CanadaJul 25, 2022 · C-GGSN · Substantial damageNTSB GAA22WA238Accident · 1 fatalClass 5 · ForeignCessna T210L · Puerto Plata, Dominican RepublicJul 23, 2022 · N210DE · Substantial damageNTSB GAA22WA247Accident · Serious injuriesClass 5 · ForeignPilatus PC6 · Papua, IndonesiaJun 22, 2022 · PK-BVM · Substantial damageNTSB GAA22WA274AccidentClass 5 · ForeignBeech 90 · Le Bourget, FranceMay 23, 2022 · F-HHAM · No damageNTSB DCA22WA146IncidentClass 5 · ForeignAirbus A320 · Paris, FranceMay 23, 2022 · 9H-EMU · No damageNTSB GAA22WA203Accident · No injuriesClass 5 · ForeignPiper PA28 · Kastrup, DenmarkMay 3, 2022 · UNREG · Substantial damageNTSB GAA22WA173Accident · 1 fatalClass 3 · ForeignRockwell 690 · Charallave, VenezuelaApr 30, 2022 · YV3502 · Substantial damageNTSB DCA22WA107IncidentClass 5 · ForeignBoeing 777 · Paris, FranceApr 5, 2022 · F-GSQJ · No damageNTSB DCA22WA221Occurrence · No injuriesClass 5 · ForeignBoeing 777 · Islamabad, PakistanMar 21, 2022 · SVA724 · No damageNTSB GAA22WA122Accident · No injuriesClass 5 · ForeignCessna 182 · Tumeremo, VenezuelaMar 9, 2022 · YV-1618 · DestroyedNTSB DCA22WA092IncidentClass 5 · ForeignBoeing 737 · Malaga, SpainMar 6, 2022 · EI-EVR · No damageNTSB DCA22WA119IncidentClass 5 · ForeignAirbus A320 · Pointe-a-Pitre, GuadeloupeFeb 10, 2022 · F-HEPB · No damageNTSB GAA22WA087Accident · No injuriesClass 5 · ForeignBeech 58 · Curitiba, BrazilJan 19, 2022 · PR-JGV · Substantial damageNTSB GAA22WA085Accident · No injuriesClass 5 · ForeignMD Helicopter 369 · International Waters, PanamaJan 14, 2022 · HP-1645PA · DestroyedNTSB GAA22WA068Accident · Minor injuriesClass 4 · ForeignCessna 402B · Berry Islands, BahamasJan 5, 2022 · N145TT · Substantial damageNTSB DCA22WA067Incident · No injuriesClass 5 · ForeignBoeing 787 · Warsaw, PolandJan 2, 2022 · SP-LRA · No damage