NTSB investigations, 2009, Outside the U.S.

7 cases where the phase of flight was Takeoff.

Cases per year

19622026
NTSB investigations, 2009, 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\") = 2009
    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 ERA10WA312Accident · 5 fatalForeign investigationBeech 58 · Guarico, VenezuelaOn December 13, 2009, about 2040 UTC, a Beech 58, of Venezuelan registration, YV2473, registered to and operated by Aeronaves Baron, C.A., impacted terrain during takeoff from the Mata de Juajua Airport (SVCS), near Estatdo Guárico, Venezuela. Visual…Dec 13, 2009 · YV2473 · Substantial damageNTSB WPR10WA080Accident · 1 fatalForeign investigationBell 206 · Dorrigo, Australia, AustraliaOn December 9, 2009, at 1225 universal coordinated time a Bell 206 L-1, VH-MJO, operated by Commercial Helicopters Pty Ltd. collided with the terrain during takeoff near Dorrigo, Australia. The flight was for the purpose of performing an aerial survey. The…Dec 9, 2009 · VH-MJO · Substantial damageNTSB CEN10WA058Accident · 2 fatalForeign investigationPilatus PC12 · Weert, NetherlandsOn October 16, 2009, at 0730 universal coordinated time, a Pilatus PC-12/47 airplane, Dutch registered PH-RUL, registered to E.S. Management BV, was destroyed when it impacted terrain near Weert, The Netherlands. Visual meteorological conditions prevailed at…Oct 16, 2009 · PH-RUL · DestroyedNTSB ANC09WA071Accident · 2 fatalForeign investigationPiper PA-46-31P · Kamsack, CanadaOn July 19, 2009, about 2100 central standard time, a Piper PA-46-31P airplane, Canadian registration C-GUZZ, crashed on takeoff from Kamsack, Saskatchewan, Canada. Two people aboard received fatal injuries, and the remaining two people aboard received…Jul 20, 2009 · C-GUZZ · Substantial damageNTSB CEN09WA612Accident · 2 fatalForeign investigationEurocopter AS350 · Barcelona, SpainOn June 22, 2009 a Eurocopter AS350B3, Spanish registration EC-IOJ was destroyed while filling the fire attack system with water during a fire extinguishing operation. The pilot and passenger both were killed. According to several witness statements, the…Jun 22, 2009 · EC-IOJ · DestroyedNTSB ERA09WA253Accident · 1 fatalForeign investigationCessna 208 · Canaima, VenezuelaNone.Apr 17, 2009 · YV1181 · Substantial damageNTSB CEN09WA188Accident · Minor injuriesForeign investigationBell 212 · Aguascalientes, MexicoNot Required. Investigation is being conducted by the DGAC, Mexico.Feb 28, 2009 · XC-DES · Substantial damage