NTSB investigations, 2020, Outside the U.S.

28 cases where the phase of flight was Unknown.

Cases per year

19642026
NTSB investigations, 2020, 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\") = 2020
    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 ANC21WA009Accident · 1 fatalClass 5 · ForeignRobinson R66 · Ojiro in Shimada-City, Shizuoka, JapanDec 30, 2020 · JA77ARNTSB WPR21WA065Accident · 2 fatalClass 5 · ForeignRobinson R44 · Tallong, AustraliaDec 2, 2020 · VH-HGU · DestroyedNTSB WPR21WA062Accident · 1 fatalClass 5 · ForeignCessna 172 · Katale, UgandaNov 18, 2020 · N7834M · DestroyedNTSB CEN21WA063Accident · 1 fatalClass 5 · ForeignRotorsport UK Cavalon · Avoch, United KingdomNov 12, 2020 · G-CKYT · DestroyedNTSB CEN21WA042Accident · 2 fatalClass 5 · ForeignPiper PA34 · Reus, SpainNov 3, 2020 · EC-HCA · Substantial damageNTSB CEN21WA013Accident · 1 fatalClass 5 · ForeignCessna FRA150 · Troutbeck, United KingdomOct 11, 2020 · G-CIIRNTSB GAA21WA175Accident · 5 fatalClass 5 · ForeignPioneer 300 · Loches, FranceOct 10, 2020 · 37AHH · 2 aircraftNTSB CEN21WA036Accident · 2 fatalClass 5 · ForeignCessna TU206G · Los Laureles, MexicoSep 16, 2020 · XB-LVT · DestroyedNTSB WPR20WA294Accident · No injuriesForeign investigationBell 206 · Lago, NigeriaThe government of Nigeria has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on August 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Nigeria's investigation under the provisions…Aug 28, 2020 · 5N-BQW · DestroyedNTSB CEN20WA319Accident · No injuriesForeign investigationRans S12 · Sergio Perez de Leon, MexicoThe government of Mexico has notified the NTSB of an accident involving a RANS S12 airplane that occurred on July 29, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of ICAO…Jul 29, 2020 · Unknown · Substantial damageNTSB ENG20WA038Accident · No injuriesClass 5 · ForeignPiper PA28RT · Basel, SwitzerlandJul 23, 2020 · HB-PNP · DestroyedNTSB ENG20WA037Incident · No injuriesForeign investigationAirbus A320 · Tijuana, MexicoThe Mexican government has notified the NTSB of an incident involving an Airbus A330-202 that occurred June 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the Direccion de Analisis de Accidentes e Incidentes de Aviacion (DGAC) of…Jun 16, 2020 · N526VL · No damageNTSB CEN20WA433Accident · No injuriesClass 5 · ForeignCirrus SR22 · Foreign, United KingdomMay 31, 2020 · G-CTAM · Substantial damageNTSB CEN20WA198Accident · 1 fatalForeign investigationCessna 150 · Blomberg, GermanyThe government of Germany has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on May 27, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…May 27, 2020 · D-ECVT · DestroyedNTSB CEN20WA209Accident · 2 fatalForeign investigationPiper PA38 · Kena, LithuaniaThe National Transportation Safety Board was notified of an accident involving a Piper PA-38-112 airplane, LY-ATM, near Kena, Lithuania. This investigation is under the jurisdiction of Ministry of Justice of the Republic of Lithuania, Transport Accident and…May 9, 2020 · LY-ATMNTSB CEN20WA171Accident · 3 fatalForeign investigationCessna 182 · Area Municipio De Joyabaj, GuatemalaMay 6, 2020 · TG-MOL · DestroyedNTSB ANC20WA072Accident · 2 fatalForeign investigationSikorsky S76 · Cheonwangbong, South KoreaThe government of Korea, Republic Of has notified the NTSB of an accident involving a SIKORSKY S76 helicopter that occurred on May 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea, Republic Of's investigation…May 1, 2020 · HL9646 · Substantial damageNTSB CEN20WA200Accident · 1 fatalForeign investigationPiper PA 25-235 · Angostura, MexicoApr 28, 2020 · XB-ZOZNTSB CEN20WA157Incident · No injuriesForeign investigationCessna 650 · Ciudad Juarez, MexicoOn April 7, 2020, about 1640 hours universal coordinated time, a Cessna 650 airplane, Mexican registration XA-SDU, was involved in an incident at the Abraham González International Airport (MMCS), located in Ciudad Juárez, Chihuahua, Mexico, The NTSB has…Apr 7, 2020 · XA-SDU · Minor damageNTSB CEN20WA142Accident · Serious injuriesForeign investigationLancair LC41 · Gotha, GermanyMar 30, 2020 · N6504H · Substantial damageNTSB ERA20WA137Accident · 1 fatalForeign investigationBell 206 · Chicureo, ChileMar 24, 2020 · CC-ARR · DestroyedNTSB ERA20WA136Accident · 2 fatalForeign investigationCessna 310 · Tefe, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 310 airplane that occurred on March 13, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Mar 13, 2020 · PR-GSG · Substantial damageNTSB ANC20WA031Accident · 1 fatalForeign investigationRobinson R44 · Astrakhan, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on February 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…Feb 28, 2020 · RA-04246 · Substantial damageNTSB CEN20WA121Accident · 1 fatalForeign investigationLavia Argentina PA-25-235 · Etchoja, MexicoThe government of Mexico has notified the NTSB of an accident involving a LAVIA ARGENTINA PA-25-235 airplane that occurred on February 18, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under…Feb 18, 2020 · XB-EMO · DestroyedNTSB ANC20WA019Accident · 1 fatalForeign investigationBell 407 · Laishevo, RussiaThe government of Russia has notified the NTSB of an accident involving a BELL 407 helicopter that occurred on February 07, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions…Feb 7, 2020 · RA-01893 · Substantial damageNTSB WPR20WA106Incident · No injuriesForeign investigationAerospatiale AS350 · Bankstown Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a Aerospatiale AS350 helicopter that occurred on February 05, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under…Feb 5, 2020 · VH-UAH · No damageNTSB WPR20WA083Accident · 2 fatalForeign investigationCessna 182 · Tangalooma, AustraliaThe government of Australia has notified the NTSB of an accident involving a CESSNA 182 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…Jan 22, 2020 · VH-WNR · Substantial damageNTSB CEN20WA054Accident · 4 fatalForeign investigationMooney M20 · Lifou Wanaham, New CaledoniaOn January 3, 2020, about 1430 universal coordinated time, a Mooney M20J, French registration F-OIAT, impacted terrain shortly after departing the Lifou Wanaham Airport (New Caledonia). The aircraft was destroyed, and the pilot and three passengers were…Jan 3, 2020 · F-OIAT · Destroyed