NTSB investigations, 2009, Outside the U.S.

15 cases where the phase of flight was Approach.

Cases per year

19622026
NTSB investigations, 2009, 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\") = 2009
    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 ERA10WA106Accident · 1 fatalForeign investigationHughes 369 · Pitalito, ColombiaOn December 29, 2009, about 1655 universal coordinated time (1155 local time), a Hughes 369D, Colombian registration HK4177, operated by Sociedad Aerea de Ibague, was substantially damaged during a forced landing in Pitalito, Huila, Colombia. The Colombian…Dec 29, 2009 · HK4177 · Substantial damageNTSB ERA10WA096Accident · 1 fatalForeign investigationHuber Hartmut Express · Berry Island, BahamasOn December 12, 2009, at 1300 UTC, an experimental, amateur-built Harmut Huber Express, N93HE, operated by a private individual, crashed into the water on short final approach to Chub Cay Airport (MYBC), Berry Island, Bahamas. The pilot was killed and the…Dec 12, 2009 · N93HE · Substantial damageNTSB CEN10WA073Accident · 1 fatalClass 5 · ForeignCirrus SR20 · Oberbarnim, GermanyOn December 10, 2009, at 1625 coordinated universal time, a Cirrus SR20, German registered D-EYAT, was destroyed when it impacted forested terrain near Oberbarnim, Germany. Instrument meteorological conditions prevailed at the time of the accident. The pilot…Dec 10, 2009 · D-EYAT · DestroyedNTSB DCA10RA031Accident · No injuriesForeign investigationBeech 1900 - D · Nairobi, KenyaOn November 9, 2009 about 0517 UTC, Kenyan registry 5Y-VVQ, a Beech 1900D, a chartered cargo flight, had a loss of control and collided with the ground during a visual approach for landing at Wilson Airport, Nairobi, Kenya. The airplane had turned back to…Nov 9, 2009 · 5Y-VVQ · DestroyedNTSB ERA10WA035Accident · 5 fatalForeign investigationHawker BAe-125-800B · Minsk, BelarusOn October 26, 2009, at 1934 universal coordinated time (2134 local standard time), a Hawker-Beech BAe-125-800, Russian registration RA-02807, operated by S-Air, was destroyed when it impacted forested terrain during a go-around attempt at Minsk-2…Oct 26, 2009 · RA-02807 · DestroyedNTSB ERA09WA546Accident · 2 fatalForeign investigationPiper PA18 · Barbones, Ecuador, EcuadorOn September 25, 2009, about 1330 central standard time, a Piper PA-18-150, Ecuadorian registration HC-AHD, registered to and operated by FumiPalma S.A., crashed following a loss of engine power, while on an approach for landing at the Pista Bardones, El Oro,…Sep 25, 2009 · HC-AHD · DestroyedNTSB ERA09WA551Accident · No injuriesForeign investigationCessna 172 · Palazzolo dello Stella, ItalyJun 24, 2009 · D-EBFO · Substantial damageNTSB ERA09WA335Accident · 1 fatalForeign investigationPiper Aerostar 6 · Minga Guazu, ParaguayOn June 9, 2009, at 1903 local time, a Piper PA-60, N601RP, was destroyed during collision with terrain and a post crash fire on approach to Guarani International Airport (SGES), Minga Guazu, Paraguay. The pilot was fatally injured. Instrument meteorological…Jun 9, 2009 · N601RP · Substantial damageNTSB DCA09WA058Incident · No injuriesForeign investigationBoeing 767 · Taipei, Taiwan, TaiwanOn June 6, 2009, Japan Airlines flight 653, a Boeing 767-300, registration JA-613J, experienced a cabin fire during approach to Taoyuan International Airport (TPE/RCTP), Taipei, Taiwan. The remains of a charred lighter were found in the nook between a seat…Jun 5, 2009 · JA-613J · Minor damageNTSB ERA09WA354Accident · 2 fatalForeign investigationRobinson R-44 · Vitoria da Conquista, BrazilOn May 22, 2009, at 2139 Coordinated Universal Time (UTC), a Brazilian registered Robinson R-44, PR-NDF, was destroyed when it impacted the ground during approach to land at the Vitoria da Conquista Airport (SBQV), Vitoria da Conquista, Brazil. The pilot and…May 22, 2009 · PR-NDF · DestroyedNTSB ERA09WA288Accident · 5 fatalForeign investigationCessna 172 RG · Santa Cruz, BoliviaOn May 11, 2008, about 1930 Atlantic standard time, a Cessna 172 RG, Bolivian registration CP-2492, , registered to and operated by a private individual, impacted a tree with its left’s wing and then the ground, where a fire ensued. The accident sight was…May 11, 2009 · CP-2492 · DestroyedNTSB ERA09WA237Accident · 1 fatalForeign investigationPiper PA-34 · Valdivia, ChileNone.Apr 6, 2009 · CC-CJK · Substantial damageNTSB ERA09WA218Accident · 7 fatalForeign investigationBeech BE-200 · Quito, EcuadorNone.Mar 19, 2009 · AEE-101 · DestroyedNTSB DCA09WA031Incident · No injuriesForeign investigationBombardier CL-600 · Santander, SpainOn February 24, 2009, about 1750 coordinated universal time, an Air Nostrum CL-600-2B19, registration EC-IKZ, experienced a duel engine failure while on approach to Santander Airport (LEXJ), Santander, Spain. The flight crew were able to restart both engines…Feb 24, 2009 · EC-IKZ · No damageNTSB ERA09WA153Accident · Minor injuriesForeign investigationCessna 421B · Nassau, BahamasOn January 29, 2009, at 2130 eastern daylight time, a Cessna 421B, Bahamian registration C6-DXL, operated by a private individual as an air ambulance, experienced a loss of engine power while on approach to the Lynden Pindling International Airport (MYNN),…Jan 30, 2009 · C6-DXL · Substantial damage