OpenAirDocs.org

NTSB investigations, 2010, Outside the U.S.

8 cases where the phase of flight was Takeoff.

Cases per year

19622026

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 = 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 WPR10WA460Accident · 1 fatalForeign investigationCessna 188 · Geraldton Aerodrome, Australia, AustraliaOn September 14, 2010, at 0745 universal coordinated time, a Cessna 188 Agwagon, VH-KZF, collided with terrain during takeoff for an aerial application flight near Geraldton Aerodrome, Australia. The airplane was operated by Prestige Helicopters PTY LTD. The…Sep 14, 2010 · VH-KZF · Substantial damageNTSB ERA10WA428Accident · 4 fatalForeign investigationRobinson R44 · Milazzo, ItalyOn August 12, 2010, about 0600 Universal Coordinated Time (UTC), a Robinson R44, Italian registration I-KOST, operated by Intesa Leasing, Rent and Fly, as a personal flight, collided with a building and the ground during takeoff from a private field at…Aug 12, 2010 · I-KOST · DestroyedNTSB DCA10WA078Incident · No injuriesForeign investigationBoeing 757 - 212 · London, United KingdomThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B757-200 that occurred on July 16, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of ICAO…Jul 16, 2010 · G-CPES · No damageNTSB CEN10WA413Accident · Minor injuriesForeign investigationBell 206 · La Tuna, MexicoThe government of Mexico has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on July 03, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Jul 3, 2010 · XC-BAM · Substantial damageNTSB ERA10WA430Accident · No injuriesForeign investigationPiper PA42 · Mercedes, ArgentinaOn June 13, 2010, about 1840 coordinated universal time (1540 local time), a Piper PA-42-1000, Argentine registration LQ-BLU, was substantially damaged when it overran the end of the runway and impacted a perimeter fence during a takeoff attempt from Mercedes…Jun 13, 2010 · LQ-BLU · Substantial damageNTSB DCA10WA043Incident · No injuriesForeign investigationBoeing 757 - 236 · Bacelona, SpainThe UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a B757-236 that occurred on February 21, 2010. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…Feb 21, 2010 · G-CPET · No damageNTSB DCA10WA035Incident · No injuriesForeign investigationBoeing 737 · Surabaya, IndonesiaOn February 12, 2010, a Metro Batavia Boeing 737-200, registration PK-YTR, aborted the takeoff from runway 10 at Juanda Airport, Surabaya, Indonesia. There were no injuries to the 5 crew members and 120 passengers onboard and the airplane received minor…Feb 13, 2010 · PK-YTR · Minor damageNTSB CEN10WA096Accident · 2 fatalForeign investigationPiper PA-31P · Kidlington, United KingdomJan 15, 2010 · N95RS · Destroyed