NTSB investigations, 2010, Outside the U.S.

12 cases where the phase of flight was Initial climb.

Cases per year

19642026
NTSB investigations, 2010, Outside the U.S. per year, 1964–2026: 565 cases
196417
196511
196611
196716
19686
19695
197011
19716
19728
19736
19748
19755
19761
19772
19782
19791
19851
19871
19901
19921
19971
20041
20061
200810
20095
201012
20118
201213
201313
201413
201522
201626
201724
201821
201939
202022
202140
202242
202339
202433
202541
202619

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\") = 2010
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 350)
  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 ERA11WA088Accident · 1 fatalForeign investigationPiper PA-32R-301T · Roma, ItalyDec 8, 2010 · N58SE · DestroyedNTSB WPR11LA071Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Pago Pago, AntarcticaThe airplane’s encounter with convectively-induced turbulence, which resulted in serious injury to one flight attendant.Dec 3, 2010 · N584HA · No damageNTSB CEN11WA094Accident · 1 fatalForeign investigationCessna F150 · Linköping, SwedenOn December 1, 2010, at 1711 coordinate universal time, a Cessna F150H, SE-IGU, was substantially damaged upon impact with terrain after initial takeoff from the Linköping Airport (ESSL), Linköping, Sweden. The pilot was fatally injured. The airplane was…Dec 1, 2010 · SE-IGU · Substantial damageNTSB DCA11WA008Accident · 21 fatalForeign investigationBeech 1900 · Karachi, PakistanOn November 5, 2010, a JS Air Pakistan, a Hawker Beechcraft B-1900, registration AP-BJD, crashed shortly after takeoff from Karachi-Jinnah International Airport (KHI), Karachi, Pakistan. All 17 passengers and 4 crewmembers onboard were fatally injured, and…Nov 5, 2010 · AP-BJD · DestroyedNTSB ERA11WA004Accident · 6 fatalForeign investigationCessna 185 · Nazca, PeruOn October 2, 2010, about 2102 Universal Coordinated Time (UTC), a Cessna 185, Peruvian registration OB-1808, operated by Air Nasca S.A.C., on a commercial air tour flight, was substantially damaged, when it impacted terrain after a loss of power during…Oct 2, 2010 · OB-1808 · Substantial damageNTSB ERA10WA489Accident · No injuriesForeign investigationPiper PA-31-350 · South Bimini, BahamasOn September 19, 2010, at 1440 eastern daylight time, a Piper PA31-350, N84859, registered to Spirit Air Inc, and operated by Pioneer Air Services was on initial climb out when the lower half of the main cabin door came open. The pilot reversed his course and…Sep 19, 2010 · N84859 · Substantial damageNTSB CEN10WA534Accident · Minor injuriesForeign investigationCessna 208 · Pointe a Pitre, GuadeloupeOn September 5, 2010, at 1919 coordinated universal time, a Cessna 208B, French registered F-OIXZ, operated by Tropic Airlines, was substantially damaged during a forced landing near Pointe a Pitre, Guadeloupe. Visual meteorological conditions prevailed at…Sep 5, 2010 · F-OIXZ · Substantial damageNTSB ERA11WA157Incident · No injuriesForeign investigationBeech 300 · Jundiai, BrazilOn June 29, 2010, about 1910 UTC, a Beech 300, Brazilian registration PP-EPD, operated by The Government of the State of Amazonas, Brazil had a blown tire during the landing roll following a forced landing shortly after takeoff from Jundiai Airport (SBJD),…Jun 29, 2010 · PP-EPD · Minor damageNTSB CEN10RA319Accident · 9 fatalForeign investigationCessna 208 · Felipe Carrillo Puerto, MexicoOn June 13, 2010, approximately 1800 central daylight time, a Cessna 208B, XA-TWK, was substantially damaged upon impact with terrain following a loss of control during the initial climb from the Felipe Carrillo Puerto airstrip, Felipe Carrillo Puerto,…Jun 13, 2010 · XA-TWK · Substantial damageNTSB DCA10WA071Incident · No injuriesForeign investigationBoeing 737 · Amsterdam Schiphol IAP, NetherlandsOn June 6, 2010, a Royal Air Maroc Boeing 737-400 experienced a bird strike during takeoff from Amsterdam Schiphol International Airport (EHAM), Amsterdam, the Netherlands. One engine lost power. The airplane returned to Schiphol and made an uneventful…Jun 6, 2010 · CN-RMF · Minor damageNTSB DCA10WA040Incident · No injuriesForeign investigationBoeing 727 · Torino, ItalyOn February 21, 2010, a Thomas Cook Boeing 757-200, registration G-TCBA, experienced an uncommanded fuel dump during initial climb after takeoff from Turin International Airport (LIMF), Torino, Italy. There were no injuries to the 8 crew members and 231…Feb 21, 2010 · G-TCBA · No damageNTSB DCA10RA023Accident · 90 fatalForeign investigationBoeing 737 · Beirut, LebanonOn January 25, 2010, about 0041 UTC, Ethiopian Airlines flight 409, Boeing 737-800, ET-ANB, crashed into the Mediterranean Sea shortly after takeoff from Beirut-Rafic Hairiri International Airport, Beirut, Lebanon. Night instrument meteorological conditions…Jan 25, 2010 · ET-ANB · Destroyed