OpenAirDocs.org

NTSB investigations, 2011, Outside the U.S.

18 cases where the phase of flight was Maneuvering.

Cases per year

19642026

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\") = 2011
    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 ERA12WA103Accident · 4 fatalForeign investigationCessna TU206 · Cerro Escalera, PeruOn December 1, 2011, about 2048 UTC, a Cessna TU206G, Peruvian registration OB-1299, registered to and operated by Palmas del Espino S.A., collided with mountainous terrain near Cerro Escalera, Peru. Weather conditions at the altitude, location, and time of…Dec 1, 2011 · OB-1299 · Substantial damageNTSB ERA12WA136Accident · No injuriesForeign investigationPiper PA36 · Machala, EcuadorOn November 23, 2011, about 2000 coordinated universal time, a Piper PA-36-300, Ecuadorian registration HC-BHJ, operated by Aerorient Fumigacion Aerea, was substantially damaged when the pilot made a forced landing following loss of engine power in a banana…Nov 23, 2011 · HCBHJ · Substantial damageNTSB CEN12RA052Accident · 3 fatalClass 5 · ForeignBell 206L · Kapuskasing, CanadaOn November 2, 2011, about 0958 eastern daylight time (EDT), a Bell 206L helicopter, Canadian registration C-GDQH, was substantially damaged during an in-flight collision with terrain in Kapuskasing, Ontario, Canada. The pilot and 2 passengers sustained fatal…Nov 2, 2011 · C-GDQH · Substantial damageNTSB CEN12WA033Accident · 2 fatalForeign investigationDiamond DA20 · Amurrio, SpainOn October 14, 2011, at 1040 universal coordinated time, a Diamond DA20-C1 airplane, EC-KDS, sustained substantial damage when it impacted terrain near Amurrio, Spain. The two crewmembers sustained fatal injuries. The accident investigation is under the…Oct 14, 2011 · EC-KDS · Substantial damageNTSB CEN11WA690Accident · No injuriesForeign investigationPiper PA 28 · Montpellier, FranceOn September 16, 2011, a Piper PA 28, French resistered F-HMAT, was substantially damaged during a forced landing following a loss of engine power near Montpellier, France. Visual meteorological conditions prevailed at the time of the accident. No one was…Sep 16, 2011 · F-HMAT · Substantial damageNTSB WPR11WA484Accident · No injuriesForeign investigationAerospatiale AS350 · Rockhampton, Australia, AustraliaOn September 8, 2011, at 0203 universal coordinated time, an Aerospatiale Industries AS-350BA, VH-RDU, collided with the terrain near Rockhampton, Australia. The helicopter was substantially damaged. Of the three occupants on board, two were fatally injured…Sep 8, 2011 · VH-RDU · Substantial damageNTSB WPR11WA438Accident · 1 fatalForeign investigationRobinson R44 · Plutonic Aero., Australia, AustraliaOn September 3, 2011, at 0330 universal coordinated time, a Robinson R44, Australia registry VH-HCA, collided with terrain while maneuvering near Plutonic Aerodrome, Australia. The helicopter was operated by Wieland Helicopter Company under the pertinent…Sep 3, 2011 · VH-HCA · Substantial damageNTSB WPR11WA421Accident · 1 fatalForeign investigationHughes 369D · South Malekula, Vanuatu, VanuatuOn August 28, 2011, at 1500 universal coordinated time, a Hughes 369D, Vanuatu registration YJ-HEL, collided with the ground after the attached long-line became entangled in the rotor system near Malekula, Vanuatu. The helicopter was operated by Vanuatu…Aug 28, 2011 · YJ-HEL · Substantial damageNTSB ERA11WA470Accident · 2 fatalForeign investigationPiper PA30 · Region del Bio Bio, ChileOn August 20, 2011, at 1650 universal coordinated time, a Piper PA-30, Chilean registration CC-CTT, was substantially damaged when it impacted terrain, after its right wing separated in-flight while maneuvering, over Region del Bio Bio, Chile. The pilot and…Aug 20, 2011 · CC-CTT · Substantial damageNTSB ERA11WA439Accident · 1 fatalForeign investigationRobinson R-44 · Istok, RussiaOn July 9, 2011, at 1900 universal coordinated time, a Robinson R-44, Russian registration RA-04304, registered to and operated by a private owner, collided with the Yenisei River, near Istok, Krasnoyarsk Region, Russia, during a repositioning flight at…Jul 9, 2011 · RA-04304 · Substantial damageNTSB CEN11WA458Accident · 1 fatalForeign investigationVans RV6 · Shoreham, United KingdomOn July 4, 2011, at 1528 Universal Coordinated Time (UTC), a Vans RV-6A single-engine airplane, G-RVCG, and a Diamond DA-40 single-engine airplane, G-CEZR, collided in midair while maneuvering near Shoreham, West Sussex, United Kingdom. G-RVGC was destroyed…Jul 4, 2011 · G-RVGC · 2 aircraft · DestroyedNTSB ERA11WA308Accident · 2 fatalForeign investigationBell 206L-3 · Norte de Santander, ColombiaOn May 23, 2011, about 2105 Universal Coordinated Time (UTC), a Bell 206L-3, Columbian registration HK4448, operated by Aviheco S.A., was destroyed following a collision with terrain near Norte de Santander, Columbia. The local flight originated in Bogota.…May 23, 2011 · HK4448 · DestroyedNTSB WPR11WA482Accident · 1 fatalForeign investigationRobinson R22 · Julia Creek, Australia, AustraliaOn May 9, 2011, at 0440 universal coordinated time, a Robinson R-22, Australian registry VH-DSD, operated by Versatile Helicopter Services, impacted terrain during a mustering operation near Julia Creek, Australia. The helicopter was substantially damaged and…May 9, 2011 · VH-DSD · Substantial damageNTSB ERA11WA268Accident · Minor injuriesForeign investigationGrumman G164 · Volgodonsk, RussiaOn April 20, 2011, about 1010 Universal Coordinated Time (UTC), a Grumman G-164A Agcat, Russian registration RA-1398G, operated by a private individual, was substantially damaged during a forced landing following a loss of engine power near Volgodonsk, Rostov…Apr 20, 2011 · RA-1398G · Substantial damageNTSB WPR11WA217Accident · No injuriesForeign investigationRobinson R44 · Straubing, GermanyOn March 31, 2011, at 1630 universal coordinated time, a Robinson R44 Raven II Helicopter, D-HBLT, collided with an aircraft storage hangar at Straubing-Wallmühle Airport, Straubing, Germany. The pilot and passenger sustained minor injuries; the helicopter…Mar 31, 2011 · D-HBLT · DestroyedNTSB ERA11WA215Accident · 1 fatalForeign investigationBell 205 · San Clemente, ChileMar 24, 2011 · CC-CID · DestroyedNTSB ERA11WA189Accident · 1 fatalForeign investigationCessna 182 · Calamar, ColombiaOn March 14, 2011, about 0815 universal coordinated time, a Cessna, 182N, Colombian registration, HK1084, operated by Transportes Aereos del Ariari, crashed while returning to Aerodromo Jorge E. Gonzalez- San Jose Guaviare (SKSJ), Calamar, Colombia, shortly…Mar 14, 2011 · HK1084 · Substantial damageNTSB ERA11WA111Accident · 1 fatalForeign investigationAir Tractor AT802 · Santa Juana, ChileOn January 9, 2011, at 1930 universal coordinated time, an Air Tractor AT-802, Spanish registration EC-IOE, registered to FAASA Group Aerodromo Sebastian Almagro Ctra, operated by FAASA Chile Servicios Aeros LTDA, collided with trees near Santa Juana, Chile,…Jan 9, 2011 · EC-IOE · Destroyed