OpenAirDocs.org

NTSB investigations, 2008, Outside the U.S.

9 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\") = 2008
    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 WPR09LA069Accident · 1 fatalLimited investigationFinal reportHughes 369 · Honiara, Solomon IslandsThe pilot's failure to remove the tail rotor pedal lock before attempting flight, resulting in a loss of control.Dec 28, 2008 · N104BN · DestroyedNTSB CEN09RA030Accident · 5 fatalForeign investigationCessna 310 · Ciudad Victoria, MexicoOn October 21, 2008 at approximately 1710 central daylight time a Cessna 310, Mexican Registration XB-KPF experienced a loss of power on takeoff from Pedro J. Mendez Airport, Ciudad Victoria, Tamaulipas, Mexico. The pilot attempted to return to the airport…Oct 21, 2008 · XB-KPF · DestroyedNTSB MIA08WA200Accident · Serious injuriesClass 5 · ForeignFokker F28-4000 · Quito, EcuadorOn September 22, 2008, about 1600 universal time, a Fokker F28-4000, HC-CDT, flight ICD-504, registered to and operated by Icaro Air, as a scheduled domestic passenger flight, aborted take off on runway 35 at Mariscal Surce Airport (SEQU), Quito, Ecuador. The…Sep 22, 2008 · HC-CDT · Substantial damageNTSB NYC08IA290Incident · No injuriesIncident investigationFinal reportBoeing 747-209B · Bogota, ColombiaThe combination of fan blade edge contour, variable blade trim, and the high altitude, which resulted in an engine surge.Aug 26, 2008 · N715CK · No damageNTSB DCA08WA086AccidentForeign investigationBoeing 767 - 200 · Budapest, HungaryOn July 29, 2008, at 1607 local Budapest time, a Krasnojarsky Airlines Boeing 767-200, EI-GBA, experienced an inadvertent deployment of an emergency escape slide after takeoff from Budapest, Hungary. The flight continued to its destination of Domodedovo…Jul 29, 2008 · EI-GBA · No damageNTSB DCA08RA078Accident · 2 fatalForeign investigationBoeing 747-200FM · Madrid, ColombiaOn July 7, 2008, at 0357 local time, a Boeing 747-200FM, N714CK, operated by Kalitta Air as Centurion Airlines flight 164, was destroyed during a forced landing in Madrid, Cundinamarca, Colombia, shortly after taking off from El Dorado International Airport…Jul 7, 2008 · N714CK · DestroyedNTSB DCA08WA074AccidentForeign investigationFairchild SA226 · Bergen, NorwayOn June 20, 2008, at 1032 local Norwegian time, a Helitrans AS Fairchild Aircraft Corporation SA226-T(B), registration LN-SFT, crashing into the North Sea approximately 15 NM West of Bergen Airport (ENBR), Bergen, Norway. The aircraft was on a training flight…Jun 20, 2008 · LN-SFT · DestroyedNTSB ENG08WA029IncidentForeign investigationBoeing 737-2A5 · Pucallpa, PeruOn June 6, 2008, at approximately 1810 local time, OB-1799-P, a Boeing 737-2A5, operated by Aero Condor S.A.C., returned to the FAP Captain David Abenzur Rengifo International Airport, (SPCL), Pucallpa Peru, after experiencing a very strong vibration after…Jun 6, 2008 · OB-1799-P · Minor damageNTSB DCA08RA063Accident · No injuriesForeign investigationBoeing B747-200 · Brussels, BelgiumimportMay 25, 2008 · N704CK · Destroyed