NTSB investigations, 2019, Outside the U.S.

25 cases where the phase of flight was Maneuvering.

Cases per year

19642026
NTSB investigations, 2019, 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\") = 2019
    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 GAA20WA101Accident · 1 fatalForeign investigationPiper PA25 · Rio Branco, Cerro Largo, UruguayThe government of Uruguay has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Uruguay's investigation under the provisions…Dec 24, 2019 · CX-BRE-R · Substantial damageNTSB WPR20WA044Accident · 2 fatalForeign investigationAngel 44 · Mareeba, AustraliaOn December 14, 2019, at 1115 local time, an Angel Aircraft Corporation 44 twin-engine airplane, registration VH-IAZ, collided with terrain near Mareeba Aerodrome, Mareeba Queensland, Australia. Both pilots were fatally injured, and the airplane was…Dec 14, 2019 · VH-IAZ · DestroyedNTSB GAA19WA598Accident · Serious injuriesClass 5 · ForeignAerospatiale AS350 · Kitzbühel, AustriaDec 12, 2019 · OE-XHE · No damageNTSB CEN20WA210Accident · 2 fatalForeign investigationPiper PA30 · Kaunas, LithuaniaThe government of Lithuania has notified the NTSB of an accident involving a PIPER PA30 airplane that occurred on December 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Lithuania's investigation under the…Dec 8, 2019 · LY-ARS · Substantial damageNTSB WPR20WA037Accident · 1 fatalForeign investigationRobinson R44 · Eschowe, South AfricaThe government of South Africa has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 5, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…Dec 5, 2019 · ZS-RRS · Substantial damageNTSB WPR20WA010Accident · No injuriesForeign investigationBell 412 · Port Said City, EgyptOn October 11, 2019, about 1147 coordinated universal time, a Bell Helicopter 412EP, SU-CBX, impacted the sea about 65 miles north of Port Said City, Egypt after losing control in flight. There were no injuries to the two pilots and three passengers, and the…Oct 11, 2019 · SU-CBX · Substantial damageNTSB CEN19WA294Accident · 1 fatalForeign investigationAir Tractor AT400 · Namiquipa, MexicoThe government of Mexico has notified the NTSB of an accident involving a AIR TRACTOR AT400 airplane that occurred on July 27, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…Jul 27, 2019 · XB-PNL · Substantial damageNTSB CEN19WA291Accident · No injuriesForeign investigationSikorsky S76 · Vigo, SpainOn July 26, 2019, about 2130 coordinated universal time, a Sikorsky S76 C+, EC-JES, impacted terrain at the Vigo Airport (LEVX), Vigo, Spain. The accident investigation is under the jurisdiction and control of the government of Spain. This report is for…Jul 26, 2019 · EC-JES · Substantial damageNTSB GAA19WA442Accident · 2 fatalForeign investigationSteen Skybolt · Enconada, BoliviaThe government of Bolivia has notified the NTSB of an accident involving an amateur-built STEEN Skybolt airplane that occurred on July 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under…Jul 13, 2019 · CP-X3109 · Substantial damageNTSB ENG19WA040Accident · Minor injuriesForeign investigationAir Tractor AT301 · Airdrome Jorge Efrain, MexicoOn July 10, 2019, an Air Tractor AT-301, registration XB-GBA, powered by a Pratt & Whitney R1300 radial engine, operator by the owner stuck power cables and crashed during a local flight . The Mexican Direccion De Analisis de Accidentes E Incidentes De…Jul 10, 2019 · XB-GBA · Substantial damageNTSB WPR19WA277Accident · No injuriesForeign investigationRobinson R22 · Kutchera Station, AustraliaOn June 22, 2019, at 0900 local time, a Robinson R22 helicopter, VH-HHQ, collided with terrain near Kutchera Station, Australia. The pilot was fatally injured and the helicopter was substantially damaged. The flight was conducted under the pertinent civil…Jun 22, 2019 · VH-HHQ · Substantial damageNTSB CEN19WA342Accident · 2 fatalForeign investigationBRM Aero Bristell NG5 · Belan, IrelandThe government of Ireland has notified the NTSB of an accident involving an amateur-built BRM Aero Bristell NG5 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's…Jun 13, 2019 · G-OJCS · Substantial damageNTSB WPR19WA156Accident · 2 fatalForeign investigationCessna T210 · Mount Isa, AustraliaOn May 26, 2019, at 0547 coordinated universal time, a Cessna T210M, registration VH-SUX, collided with terrain during a surveying flight near Mount Isa, Queensland, Australia. The two crew were fatally injured, and the airplane sustained substantial…May 26, 2019 · VH-SUX · Substantial damageNTSB ERA19WA168Accident · Serious injuriesForeign investigationAyres S2R · Isla Bejucal, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a AYRES S2R airplane that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions of…May 3, 2019 · HC-CHZ · DestroyedNTSB ERA19WA165Accident · 1 fatalForeign investigationRobinson R22 · Pegognaga, ItalyThe government of Italy has notified the NTSB of an accident involving a Robinson R22 Beta helicopter that occurred on May 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions…May 3, 2019 · I-GPES · Substantial damageNTSB GAA19WA201Accident · 1 fatalForeign investigationMoravan Z-50LA · Castel Viscardo, ItalyThe government of Italy has notified the NTSB of an accident involving a MORAVAN Z-50LA airplane that occurred on March 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…Mar 30, 2019 · I-DRAW · DestroyedNTSB CEN19WA118Accident · Serious injuriesForeign investigationRobinson R44 · Stavnes, NorwayThe government of Norway has notified the NTSB of an accident involving a Robinson R44 helicopter that occurred on March 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…Mar 23, 2019 · LN-OGF · Substantial damageNTSB GAA19WA179Accident · 2 fatalForeign investigationEnstrom 480 · Blazkov village, Czech Republic., CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a ENSTROM 480 helicopter that occurred on March 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…Mar 22, 2019 · OK-CLV · Substantial damageNTSB GAA19WA175Accident · 1 fatalForeign investigationCessna 188 · Rio Pardo, State of Rio Grande do sul, Brazil, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA 188 airplane that occurred on March 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Mar 11, 2019 · PR-RVO · Substantial damageNTSB CEN19WA096Accident · 2 fatalForeign investigationNorth American T28 · Escuintla, GuatemalaMar 10, 2019 · N55500 · Substantial damageNTSB CEN19WA081Accident · 2 fatalForeign investigationCessna 150 · Atizapán de Zaragoza, México, México, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 150H airplane that occurred on February 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…Feb 10, 2019 · XB-OWS · Substantial damageNTSB ERA19WA101Accident · 2 fatalForeign investigationGlobe GC1A · Dom Pedrito County, BrazilThe government of Brazil has notified the NTSB of an accident involving a GLOBE GC1A airplane that occurred on February 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Feb 6, 2019 · PT-AIG · DestroyedNTSB CEN19WA079Accident · 1 fatalForeign investigationCessna 150 · Durango, MexicoJan 30, 2019 · XB-KEJ · Substantial damageNTSB WPR19WA147Accident · Minor injuriesForeign investigationSikorsky S64 · Mount Eliza, AustraliaOn January 28, 2019, at 1956 local time, a Sikorsky S-64E, N173AC, sustained substantial damage after colliding into a pond near Mount Eliza, Australia. The pilot and two crewmembers were not injured. The investigation is under the jurisdiction of the…Jan 28, 2019 · N173AC · Substantial damageNTSB ERA19WA090Accident · 1 fatalForeign investigationPiper PA25 · Jaguaré County, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER PA-25-235 airplane that occurred on January 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…Jan 21, 2019 · PR-FBA · Substantial damage