NTSB investigations, 2013, Outside the U.S.

21 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2013, Outside the U.S. per year, 1964–2026: 545 cases
19644
19653
19666
19674
19682
19691
19705
19713
19723
19733
19741
19751
19782
19871
19901
19971
19992
20031
20071
20084
20099
20109
201118
201217
201321
201419
201542
201630
201737
201836
201925
202025
202139
202241
202341
202435
202540
202612

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 = 450)
  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 WPR14WA072Accident · 1 fatalForeign investigationHughes 369E · Lake Ross, New Zealand, New ZealandOn December 15, 2013, at 0400 universal coordinated time, a Hughes 369E, ZK-HNA, collided with terrain under unknown circumstances near Lake Ross, South Island, New Zealand. The flight was operated by Milford Helicopters under the pertinent civil regulations…Dec 15, 2013 · ZK-HNA · DestroyedNTSB CEN14WA060Accident · No injuriesClass 5 · ForeignRobinson R22 - Alpha · Torreilles, FranceOn October 26, 2013, at 1226 UTC, a Robinson R22 helicopter, French registration, F-GPKA, collided with the terrain during an autorotation following a loss of power in Torreilles, France. The pilot and passenger were not injured. The helicopter was…Oct 26, 2013 · F-GPKA · Substantial damageNTSB WPR14WA034Accident · 2 fatalForeign investigationLancair Legacy · Shepparton, AustraliaOn October 25, 2013 about 1410 local time, an amateur built Lancair Legacy airplane, Australian registration VH-ICZ, collided with terrain near Shepparton, Australia. The airplane sustained substantial damage and the pilot and passenger were fatally injured.…Oct 25, 2013 · VH-ICZ · Substantial damageNTSB WPR14WA029Accident · 1 fatalForeign investigationPZL Okecie M18 · Ulladulla, AustraliaOn October 24, 2013 about 1000 local time, a PZL M18A Dromader aircraft, Australian registration VH-TZJ, collided with terrain near Ulladulla, Australia. The airplane was substantially damaged and the pilot was fatally injured. The airplane was operated as an…Oct 24, 2013 · VH-TZJ · Substantial damageNTSB WPR14WA032Accident · 1 fatalForeign investigationCessna 182 - Q · Mount Hotham, AustraliaOn October 23, 2013 about 1130 local time, a Cessna 182Q airplane, Australian registration VH-KKM, collided with terrain near Mount Hotham, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was operated as a…Oct 23, 2013 · VH - KKM · Substantial damageNTSB ERA14WA036Accident · 2 fatalForeign investigationPiper PA-34-200 · Marica, BrazilOn October 21, 2013, about 1840 universal coordinated time (UTC), a Piper PA-34-200, Brazilian registration PT-KGK, while on a local training flight, impacted in a lagoon, after a loss of control, in Marica Municipality – State of Rio de Janeiro, Brazil. The…Oct 21, 2013 · PT-KGK · DestroyedNTSB WPR14WA030Accident · 1 fatalForeign investigationAyres S2R · Wave Rock, AustraliaOn October 18, 2013 about 1500 local time, an Ayres S2R airplane, Australian registration VH-JAY, collided with terrain near Wave Rock, Australia. The airplane was destroyed and the pilot was fatally injured. The airplane was operated as an agricultural…Oct 18, 2013 · VH-JAY · DestroyedNTSB WPR13WA415Accident · 2 fatalForeign investigationLancair 360 - NO Series · Shenyang, ChinaOn September 17, 2013 about 0523 Universal Time, an experimental amateur-built Lancair, Canadian registration C-FXCK, collided with terrain while maneuvering near Shenyang, Liaoning Province, China. The airplane was participating in an aerobatic exhibition…Sep 17, 2013 · C-FXCK · Substantial damageNTSB CEN13WA548Accident · 3 fatalForeign investigationRobinson R44 · Wygonin, PolandOn September 13, 2013, about 0750 coordinated universal time, a Robinson R44 II helicopter, SP-WNP, impacted terrain near Wygonin, Poland. A postimpact fire ensued. The pilot and two passengers were fatally injured and the helicopter was destroyed. The flight…Sep 13, 2013 · SP-WNP · DestroyedNTSB CEN13WA492Accident · 1 fatalForeign investigationAerostar International S-55A · Mont-St-Grégoire, CanadaOn August 11, 2013, at 0730 eastern daylight time, an Aerostar International Inc. model S-55A, United States registration N25QL, serial number S55A1-1017, was not damaged when a member of the balloon ground-support team was fatally injured after falling to…Aug 11, 2013 · N25QL · No damageNTSB CEN13WA578Accident · 2 fatalClass 5 · ForeignCirrus Design SR20 · Poncins, FranceOn July 31, 2013, about 1420 universal coordinated time, a Cirrus SR-20 airplane, F-HCPT, impacted terrain near Poncins, France. The two occupants were fatally injured. This investigation is under the jurisdiction of the government of France. Any further…Jul 31, 2013 · F-HCPT · DestroyedNTSB ERA13WA296Accident · 1 fatalForeign investigationExtra Flugzeugbau EA-330SC · Bolshoye Gryzlovo, RussiaJun 2, 2013 · RA-0327G · Substantial damageNTSB ERA13WA403Accident · No injuriesForeign investigationCessna A188B · Dajabon, Dominican RepublicOn May 22, 2013, about 0745 universal coordinated time, a Cessna A188B, Dominican Republic registration HI 912, operated by Agriasa, was substantially damaged during a forced landing following loss of engine power near La Cangrejeria, Dajabon, Dominican…May 22, 2013 · HI 912 · Substantial damageNTSB WPR13WA435Incident · No injuriesForeign investigationRobinson R22 - Beta · New Plymouth, New Zealand, New ZealandOn March 30, 2013, at 1300 local time, a Robinson R22 Beta II, ZK-HIE, while maneuvering during an instructional flight near New Plymouth, New Zealand, experienced a sudden roll to the right and pitched down. The certified flight instructor and student pilot…Mar 30, 2013 · ZK-HIE · Minor damageNTSB ERA13WA304Accident · Minor injuriesForeign investigationEurocopter BO-105 · Granville, Cedros, Trinidad & TobagoOn March 26, 2013, about 1300 universal coordinated time, a Eurocopter BO-105 helicopter, Trinidad and Tobago registry 9Y-TIC, was substantially damaged during a forced landing to a forested area in Granville, Cedros, Trinidad and Tobago. The pilot sustained…Mar 26, 2013 · 9Y-TIC · Substantial damageNTSB ERA13WA158Accident · 9 fatalForeign investigationBeech B200 · La Libertad, PeruOn March 6, 2013, about 1245 UTC, a Beech B200, OB-1992, registered to Dearborn and Flint Aviation Co, Inc., operated by Aero Transporte Sociedad Anonima ATSA, collided with a wire then terrain during visual approach to Aerodrome Pias (SPIS), La Libertad,…Mar 6, 2013 · OB-1992 · DestroyedNTSB WPR13LA137Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Latangai Island, Papua New GuineaThe failure of both the pilot and the fish master of the vessel to adequately monitor their environment, which resulted in a collision.Mar 2, 2013 · N471M · Substantial damageNTSB ERA13WA165Accident · 1 fatalForeign investigationPiper PA-36-300 · Quevedo, EcuadorOn February 14, 2013, about 1310 coordinated universal time (UTC), a Piper PA-36-300, Ecuadorian registration HC-BJM, operated by CIA FAP S.A., was substantially damaged when it impacted the ground during an aerial application flight. The Ecuadorian pilot was…Feb 14, 2013 · HC-BJM · Substantial damageNTSB ERA13WA157Accident · 1 fatalForeign investigationCessna 172S · Mersin, TürkiyeOn February 12, 2013, at about 1414 Universal Time Coordinated, a Cessna 172S, Turkish registration TC-CDA, operated by the Turkish Aeronautical Association, impacted terrain during an instructional flight, near Mersin, Turkey. The flight instructor was…Feb 12, 2013 · TC-CDA · Substantial damageNTSB ERA13WA135Accident · 4 fatalForeign investigationCessna 172 · La Matanza, ArgentinaOn February 8, 2013, at 2250 Coordinated Universal Time (UTC), a Cessna 172, Argentine registration LV-GEU, impacted terrain while maneuvering at an altitude of approximately 500 feet in the vicinity of Matanza Airport (SADZ), La Matanza, Argentina. The local…Feb 8, 2013 · LV-GEU · Substantial damageNTSB CEN13WA126Accident · 5 fatalForeign investigationPiper PA34 · Saint Pierre de Bressieux, FranceOn January 5, 2013, at 1235 coordinated universal time, a Piper PA-34-200T airplane, Morocco registration, CN-DAY, crashed in mountainous terrain near Saint Pierre de Bressieux, France. The pilot and four passengers were fatally injured. The accident…Jan 5, 2013 · CN-DAY · Substantial damage