NTSB investigations, 2013, Outside the U.S.

9 cases where the phase of flight was Unknown.

Cases per year

19642026
NTSB investigations, 2013, Outside the U.S. per year, 1964–2026: 716 cases
19644
19653
19665
19675
19681
19702
19711
19733
19746
19756
19783
19791
19821
19851
19872
19931
19951
20031
20083
20092
201013
201110
20127
20139
201418
201522
201629
201733
201838
201920
202028
202147
202260
202335
202442
202553
2026200

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 = 990)
  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 CEN14WA093Accident · 4 fatalForeign investigationRobinson Helicopter R 44 · Bordeaux, FranceOn December 20, 2013, about 1715 central European time, a Robinson R44 helicopter, French registered F-GPJG, owned and piloted by the accident pilot, was destroyed when it impacted the Dordogne River under unknown circumstances near Bordeaux, France. Visual…Dec 20, 2013 · F-GPJG · DestroyedNTSB CEN14WA001Accident · Minor injuriesForeign investigationBell 206 - B · Upper Edgebold, United KingdomOn October 4, 2013, at 1715 UTC, a Bell 206B, United Kingdom registration G-BPWI, was substantially damaged when it impacted terrain and rolled over following a loss of engine power near Upper Edgebold near Shrewsbury, Shopshire, England. The pilot, the sole…Oct 4, 2013 · G-BPWI · Substantial damageNTSB ANC13WA097Accident · 3 fatalForeign investigationMesserschmitt-Bolkow-Blohm BO 105-S · McClure Strait, CanadaOn September 9, 2013, about 1845 Mountain standard time, a Canadian Coast Guard Messerschmitt-Bolkow-Blohm (MBB) BO105-S helicopter, Canadian registration C-GCFU, crashed into ocean waters near McClure Strait, Canada. The three crew members on board were…Sep 10, 2013 · C-GCFU · Substantial damageNTSB CEN13WA516Accident · 7 fatalForeign investigationPiper PA-32T · Wickede, GermanyOn August 27, 2013, at 1521 coordinated universal time, a Piper PA-32T, German registered D-EERB, was destroyed when it impacted terrain under unknown circumstances near Wickede, Germany. Visual meteorological conditions prevailed at the time of the accident.…Aug 27, 2013 · D-EERB · DestroyedNTSB CEN13WA505Accident · 4 fatalForeign investigationCessna T210F · Culiacan, MexicoOn August 25, 2013, a Mexican registered Cessna T210F, XB-MYI, impacted terrain near Culiacan, Mexico. The pilot and three passengers received fatal injuries. The airplane was destroyed by post impact fire. The flight originated from La Noria, Mexico, but the…Aug 26, 2013 · XB-MYI · DestroyedNTSB DCA13WA104Incident · No injuriesForeign investigationBoeing 747-400 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an incident involving a Boeing 747-400 that occurred on June 9, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…Jun 9, 2013 · G-CIVANTSB WPR13WA157Accident · 4 fatalForeign investigationRobinson R44 · Bulli Tops, Australia, AustraliaOn March 21, 2013, about 1207 local time, a Robinson Helicopter R44, VH-HWQ, collided with terrain near Bulli Tops, Australia. The pilot was operating the helicopter under the provisions of the Australian Civil Aviation Regulations. The pilot and three…Mar 21, 2013 · VH-HWQ · DestroyedNTSB ERA13WA178Accident · 10 fatalForeign investigationEmbraer EMB-820C · Almeirim Municipality, BrazilOn March 12, 2013, about 2330 UTC, an Embraer Aircraft EMB-820C, PT-VAQ, operated by Fretax Taxi Aereo Ltda, crashed during approach to Monte Dourado Airport (SBMD), Almeirim, Brazil. Visual meteorological conditions prevailed at the time and flight plan…Mar 12, 2013 · PT-VAQ · DestroyedNTSB ERA13WA124Accident · 2 fatalForeign investigationBell 206B · Sao Paulo, BrazilOn January 21, 2013, at 1448 universal coordinated time, a Bell Helicopter 206B, Brazilian registration PR-JBN, sustained substantial damage when it impacted a dwelling. One crewmember and one passenger received fatal injuries and the two other passengers…Jan 21, 2013 · PR-JBN · Substantial damage