NTSB investigations, 2020, Outside the U.S.

25 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2020, 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\") = 2020
    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 GAA21WA173Accident · 2 fatalClass 5 · ForeignPiper PA11 · Open Door, ArgentinaNov 17, 2020 · LV-YNN · Substantial damageNTSB ERA21WA064Accident · Serious injuriesClass 5 · ForeignCessna 188 · Esperanza, Dominican RepublicNov 15, 2020 · HI-923 · Substantial damageNTSB WPR21WA036Accident · 1 fatalClass 5 · ForeignPiper PA-25-235 · Kirkwood, South AfricaOct 31, 2020 · ZS-MAD · DestroyedNTSB ERA21WA033Accident · 2 fatalClass 3 · ForeignANG 01 · Peremoha, UkraineOct 5, 2020 · UR-PNGD · DestroyedNTSB WPR21WA047Accident · Minor injuriesClass 5 · ForeignAir Tractor AT502 · Semera, EthiopiaOct 2, 2020 · ET-AYJ · DestroyedNTSB GAA20WA149AccidentClass 5 · ForeignCessna 182 · Minas City, UruguaySep 24, 2020 · CX-AYENTSB CEN20WA409Accident · 1 fatalClass 5 · ForeignPitts S1 · Kulmbach, GermanySep 20, 2020 · N25LM · DestroyedNTSB WPR20WA329Accident · No injuriesClass 5 · ForeignRobinson R44 · Rooibok-Kraal, South AfricaSep 19, 2020 · ZS-RKZ · Substantial damageNTSB WPR20WA281Accident · No injuriesForeign investigationRobinson R22 · McArthur River Mine, AustraliaAug 16, 2020 · VH-YMU · Substantial damageNTSB GAA21WA004Accident · No injuriesClass 5 · ForeignVans RV7 · Little Bassetts Farm, Bentwood, United KingdomAug 9, 2020 · G-CGJN · Substantial damageNTSB GAA20WA151Accident · Serious injuriesClass 5 · ForeignCessna 182 · Steiermark, AustriaAug 2, 2020 · OE-DON · Substantial damageNTSB WPR20WA248Accident · Serious injuriesForeign investigationRobinson R44 · Steam Plains, AustraliaThe government of Australia has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on July 31, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…Jul 31, 2020 · VH-HNF · Substantial damageNTSB CEN20WA438Accident · 1 fatalClass 5 · ForeignPitts S2 · Carcassonne, FranceMay 30, 2020 · F-GIZZ · DestroyedNTSB ERA20WA174Accident · 2 fatalForeign investigationVans RV7 · Toledo, BrazilThe government of Brazil has notified the NTSB of an accident involving an amateur-built VANS RV7 airplane that occurred on April 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…Apr 23, 2020 · PP-ZCA · DestroyedNTSB DCA20LA100Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S61 · Camp Dwyer, AfghanistanFatigue cracking of the auxiliary servo cylinder’s pedal damper check valve housing and its bolts, which caused the sudden and uncommanded movement of the helicopter’s left pedal and a subsequent left yaw that continued until ground impact. Contributing to…Apr 20, 2020 · N908CH · Substantial damageNTSB GAA21WA049Accident · 1 fatalClass 4 · ForeignCessna 177 · Ebermannstadt, GermanyMar 16, 2020 · D-EDRB · DestroyedNTSB CEN20WA135Accident · 1 fatalForeign investigationPiper PA25 · Tepalcatepec, Michoacán, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on March 15, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Mar 15, 2020 · XB-VOO · DestroyedNTSB WPR20WA091Accident · 4 fatalForeign investigationPiper PA44 · Mangalore, AustraliaFeb 19, 2020 · VH-JQF · 2 aircraft · DestroyedNTSB GAA20WA110Accident · 1 fatalForeign investigationExtra E54T · Iztapa, GuatemalaJan 24, 2020 · N540ZA · Substantial damageNTSB WPR20WA082Accident · 3 fatalForeign investigationCessna S550 · George, South AfricaOn January 23, 2020, about 0853 coordinated universal time, a Cessna S550, ZS-CAR, impacted mountainous terrain under unknown circumstances while conducting aerial surveying operations near George, South Africa. The two crew members and one passenger were…Jan 23, 2020 · ZS-CAR · Substantial damageNTSB WPR20WA076Accident · 3 fatalClass 5 · ForeignLockheed C130 · Cooma, AustraliaJan 23, 2020 · N134CG · DestroyedNTSB GAA20WA109Accident · 1 fatalForeign investigationAir Tractor AT402 · Guiratinga, MT, BrazilThe government of Brazil has notified the NTSB of an accident involving a AIR TRACTOR AT402 airplane that occurred on January 17, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…Jan 17, 2020 · PR-ASN · DestroyedNTSB ENG20WA014Accident · No injuriesForeign investigationBell 407 · Lautaro, ChileThe government of Chile has notified the NTSB of the an accident involving a Bell 407 helicopter at Lautaro, Chile on January 13, 2020. The NTSB has appointed an Accredited Representative for the State of Design and Manufacture of the installed Honeywell…Jan 13, 2020 · CC-AEC · Substantial damageNTSB ENG20WA048AccidentClass 5 · ForeignDe Havilland DHC2 · Sadiq Abad - Punjab, PakistanJan 12, 2020 · AP-AMB · DestroyedNTSB WPR20WA078Accident · Minor injuriesForeign investigationGarlick UH1H · Boydtown, AustraliaOn January 9, 2020 about 1620 universal coordinated time, a Garlick Helicopters Inc., UH-1H helicopter, VH-ONZ, lost power and collided with water during an aerial fire control operation at Ben Boyd Reservoir, Boydtown, Merimbula, Australia. The pilot…Jan 9, 2020 · VH-ONZ · Substantial damage