NTSB investigations, 2013, Outside the U.S.

9 cases where the phase of flight was Takeoff.

Cases per year

19622026
NTSB investigations, 2013, 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\") = 2013
    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 ERA14WA079Accident · 4 fatalForeign investigationCessna 172A · Teresina Municipality, BrazilOn December 26, 2013, about 2148 universal coordinated time (UTC), a Cessna 172, Brazilian registration PT-CNL, was destroyed while conducting touch and go landings in the Teresina Municipality, State of Piauí, Brazil. The pilot, copilot, and 2 passengers…Dec 16, 2013 · PT-CNL · DestroyedNTSB DCA14WA019Accident · No injuriesForeign investigationBoeing 767 - 300ER · Madrid, SpainDec 5, 2013 · N182DN · Substantial damageNTSB CEN14WA012Accident · 1 fatalForeign investigationCessna 172R · Krems, AustriaOn October 20, 2013, about 0825 coordinated universal time, a Cessna 172R, OE-KRP, impacted terrain shortly after takeoff from the Krems Langenlois Airport, Krems, Austria. The private pilot was fatally injured and the passenger sustained serious injuries.…Oct 20, 2013 · OE-KRP · Substantial damageNTSB CEN13WA566Accident · 4 fatalForeign investigationCessna 421 - C · Colombier-Saugnieu, FranceSep 24, 2013 · N556MB · DestroyedNTSB ERA13WA334Accident · 3 fatalForeign investigationBeech 58 · Manaus, BrazilJul 16, 2013 · PR-OKK · Substantial damageNTSB DCA13WA092Accident · No injuriesForeign investigationBoeing 767 · Madrid, SpainOn April 16,2013, about 1235 UTC, an Aero Mexico B767-200, registration XA-TOJ, operated as flight 071 from Madrid-Barajas International Airport, Madrid, Spain, to Benito Juarez International Airport, Mexico City, Mexico, experienced a tail strike while…Apr 16, 2013 · XA-TOJ · Substantial damageNTSB DCA13WA072Incident · No injuriesForeign investigationBoeing B737 · Guatemala City, GuatemalaOn 5 April 2013, at approximately 1029 local time, a Boeing 737-4Q8, registration N279AD, ingested a turkey vulture in the right engine during takeoff from La Aurora Airport, Guatemala City, Guatemala. Inspection of the airplane revealed damage to the first…Apr 5, 2013 · N279AD · Minor damageNTSB DCA13WA064Incident · No injuriesForeign investigationBoeing 737 · Keflavik, IcelandThe AAIB of Iceland has notified the NTSB of an accident involving a Boeing 737 that occurred on March 06, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB Iceland's investigation under the provisions of ICAO Annex 13 as the…Mar 6, 2013 · OY-PSE · Minor damageNTSB ENG13WA014Incident · No injuriesForeign investigationMcdonnell Douglas MD-82 · Copenhagen, Denmark, DenmarkOn January 30, 2013 an MD-82, registration number SE-DIK, sustained a serious engine failure during the takeoff roll. The engine has been removed from the airplane and will undergo a teardown examination. The Danish Accident Investigation Board is…Jan 30, 2013 · SE-DIK · No damage