NTSB investigations, 2019, Outside the U.S.

124 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2019, Outside the U.S. per year, 1962–2026: 1,774 cases
19623
19632
196423
196521
196618
196726
19689
196922
197015
197111
197219
197316
197414
197519
19763
19778
19788
19794
19812
19823
19843
19861
19871
19886
19891
19901
19912
19941
19972
19981
20001
20022
20032
20041
20071
200810
200930
201031
201139
201253
201357
201451
201571
201689
201777
2018100
2019124
202071
2021119
2022106
2023112
2024152
2025138
202672

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 = 400)
  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 ERA20WA067Accident · No injuriesForeign investigationCessna 560 · Cmte Nicanor Otamendi, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a CESSNA 560XLS airplane that occurred on December 28, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…Dec 28, 2019 · LV-FQD · Substantial damageNTSB CEN20WA045Accident · No injuriesForeign investigationCessna 208 · San Rafael, MexicoOn December 24, 2019, about 1529 coordinated universal time, a Cessna 208B airplane, XA-TWN, impacted desert terrain near San Rafael, Sonoroa, Mexico, while enroute to the Guerrero Negro Airport (MMGR), Baja California, Mexico. The two occupants sustained…Dec 24, 2019 · XA-TWN · DestroyedNTSB ENG20WA011Incident · No injuriesForeign investigationAirbus A320 · Guwahati, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 23, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced an inflight shutdown…Dec 23, 2019 · VT-WGL · No damageNTSB ENG20WA009Incident · No injuriesForeign investigationAirbus A320 · Mumbai, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on December 22, 2019. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced high engine…Dec 22, 2019 · VT-WJE · No damageNTSB ERA20WA066Accident · 9 fatalClass 3 · ForeignBeech A100 · Charallave, VenezuelaDec 19, 2019 · YV1104 · DestroyedNTSB ENG20WA035Accident · Serious injuriesForeign investigationCessna P210 · Moruya, AustraliaDec 19, 2019 · N210BA · Substantial damageNTSB CEN20WA056Incident · No injuriesForeign investigationLearjet 45 · Geneva, SwitzerlandThe government of Switzerland has notified the NTSB of an incident involving a LEARJET 45 airplane that occurred on December 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the…Dec 18, 2019 · D-CNMB · No damageNTSB DCA20WA039Incident · No injuriesForeign investigationBoeing 767 · Shannon, IrelandThe government of Ireland has notified the NTSB of an incident involving a Boeing 767 airplane that occurred on December 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the provisions…Dec 16, 2019 · N642UA · No damageNTSB GAA20WA103Accident · 1 fatalForeign investigationCessna 150 · Region del Bio Bio, ChileThe government of Chile has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on December 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…Dec 13, 2019 · CC-PGU · DestroyedNTSB ANC20WA009Accident · 3 fatalForeign investigationPiper PA60 · Nanaimo, CanadaThe government of Canada has notified the NTSB of an accident involving a Piper PA60 airplane that occurred on December 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…Dec 11, 2019 · C-FQYW · DestroyedNTSB WPR20WA081Accident · Minor injuriesForeign investigationOas UH-1H · Williamtown Aerodrome, AustraliaThe government of Australia has notified the NTSB of an accident involving a OAS UH-1H helicopter that occurred on December 07, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…Dec 7, 2019 · VH-OXI · Substantial damageNTSB GAA20WA102Accident · 1 fatalForeign investigationBeech C90 · Caieiras, SP, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on December 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Dec 2, 2019 · PP-BSS · DestroyedNTSB ANC20WA008Accident · 1 fatalForeign investigationRobinson R66 · Krasnodarsky Krai, RussiaThe government of Russia has notified the NTSB of an accident involving a ROBINSON R66 helicopter that occurred on November 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…Nov 30, 2019 · RA-05795 · DestroyedNTSB CEN20WA024Accident · 7 fatalForeign investigationPiper PA32 · Kingston, CanadaNov 28, 2019 · N50DK · DestroyedNTSB GAA20WA097Accident · 1 fatalForeign investigationCessna 172 · Near Puffin Island, Anglesey, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 25, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…Nov 25, 2019 · G-CBXJ · DestroyedNTSB CEN20WA080Accident · No injuriesForeign investigationBeech 95-B55 · Malmo, SwedenThe government of Sweden has notified the NTSB of an accident involving a Beech 95-B55 airplane that occurred on November 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Sweden's investigation under the provisions…Nov 17, 2019 · SE-LUX · Substantial damageNTSB WPR20WA021Accident · 1 fatalForeign investigationRobinson R44 · Tunis, TunisiaThe government of Tunisia has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on November 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the…Nov 11, 2019 · TS-HAE · DestroyedNTSB GAA20WA123Incident · No injuriesForeign investigationBombardier CL600 2B19 · Madrid, SpainThe government of Spain has notified the NTSB of an accident involving a BOMBARDIER CL600 2B19 airplane that occurred on November 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the…Nov 10, 2019 · N227WG · Minor damageNTSB ENG20WA008Incident · No injuriesForeign investigationAirbus A321 · Raipur, IndiaThe AAIB of India has notified the NTSB of an incident involving an Airbus A321 airplane with CFMI CFM56-5 engines that occurred on November 8, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…Nov 8, 2019 · VT-PPT · Minor damageNTSB WPR20WA020Incident · No injuriesForeign investigationCessna 172 · Vereeniging, South AfricaOn November 6, 2019, about 1740 coordinated universal time, a Cessna 172L, South African registration ZS-DAC, was enroute to the VOR beacon GAV, near Vereeniging, and reported a loss of engine power. The pilot forced landed the airplane in a field. The pilot…Nov 6, 2019 · ZS-DAC · No damageNTSB ENG20WA049Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Owerri, NigeriaNov 5, 2019 · 5N-BUJ · No damageNTSB ENG20WA023Incident · No injuriesForeign investigationAirbus A320 · Kolkata, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on October 30, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 1 (left)…Oct 30, 2019 · VT-ITM · No damageNTSB ENG20WA028Incident · No injuriesForeign investigationAirbus A320 · Delhi, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on October 26, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…Oct 26, 2019 · VT-IZT · No damageNTSB WPR20WA023Incident · No injuriesForeign investigationSikorsky S92 · Port Harcourt NAS, NigeriaOn October 25, 2019, about 1419, time zone unknown, a Sikorsky S-92 helicopter, 5N-BOA, experienced an in-flight engine shutdown near Port Harcourt NAS, Nigeria. Their were no injuries. The helicopter was operated under the pertinent civil regulations of the…Oct 25, 2019 · 5N-BOANTSB ENG20WA022Incident · No injuriesForeign investigationAirbus A320 · Mumbai Airport, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on October 25, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…Oct 25, 2019 · VT-ITA · No damageNTSB ENG20WA026Incident · No injuriesForeign investigationAirbus A320 · Kolkata, IndiaThe government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on October 24, 2019. An IndiGo Air Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced a No. 2 (right)…Oct 24, 2019 · VT-IVX · No damageNTSB GAA20WA078Accident · 6 fatalForeign investigationCessna 401 · Madero, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a CESSNA 401 airplane that occurred on October 23, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Oct 23, 2019 · XB-JZF · Substantial damageNTSB GAA20WA065Accident · 2 fatalForeign investigationCirrus SR20 · Belo Horizonte, BrazilThe government of Brazil has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on October 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Oct 21, 2019 · PR-ETJ · DestroyedNTSB GAA20WA047Accident · 1 fatalForeign investigationRobinson R44 · Tarasenkove, UkraineThe government of Ukraine has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on October 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the…Oct 21, 2019 · UR-KTB · DestroyedNTSB CEN20WA011Accident · 2 fatalForeign investigationCessna 172 · San Salvador, El SalvadorOct 19, 2019 · N7381G · DestroyedNTSB ERA20WA015Accident · Minor injuriesForeign investigationDouglas DC3C S1C3G · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Douglas DC3C S1C3G airplane that occurred on October 18, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…Oct 18, 2019 · N437GB · Substantial damageNTSB ENG20LA001IncidentClass 3 · LimitedFinal reportAirbus BD-500-1A11 (CS300) · West Flanders Province, BelgiumA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed because of a…Oct 15, 2019 · HB-JCC · Minor damageNTSB DCA20WA012Incident · No injuriesForeign investigationBoeing 737 · Malta, MaltaThe AAIU of Ireland has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU of Ireland's investigation under the provisions of ICAO…Oct 15, 2019 · EI-EMA · No damageNTSB DCA20WA001Incident · No injuriesClass 4 · ForeignBoeing 767 · Bamako, MaliOct 8, 2019 · ET-AMG · Minor damageNTSB WPR20WA003Accident · 2 fatalForeign investigationCessna 172 · Sultanpur, IndiaOn October 6, 2019, about 0750 coordinated universal time, a Cessna 172, VT-RGF, impacted terrain near Sultanpur, India after requesting to turn back due to bad weather. The student pilot and passenger were fatally injured, and the airplane was destroyed. The…Oct 6, 2019 · VT-RGF · Substantial damageNTSB GAA19WA588Accident · 2 fatalForeign investigationPiper PA22 · Petrovice, CzechiaThe government of Czech Republic has notified the NTSB of an accident involving a PIPER PA22 airplane that occurred on September 26, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Czech Republic's investigation under…Sep 26, 2019 · D-EIRY · DestroyedNTSB ANC19WA056Accident · 1 fatalForeign investigationBell 206 · Campbell River, CanadaThe government of Canada has notified the NTSB of an accident involving a Bell 206 helicopter that occurred on September 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…Sep 24, 2019 · C-GEBYNTSB GAA19WA589Accident · No injuriesForeign investigationCessna 172 · Baska, Krk Island, CroatiaThe government of Croatia has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on September 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Croatia's investigation under the…Sep 21, 2019 · 9A-DMG · Substantial damageNTSB WPR19WA264Accident · 2 fatalForeign investigationMooney M20J · Coffs Harbour, AustraliaThe government of Australia has notified the NTSB of an accident involving a MOONEY M20J airplane that occurred on September 20, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…Sep 20, 2019 · VH-DJU · DestroyedNTSB ERA19WA292Accident · 2 fatalForeign investigationVans RV-10 · Guaranta do Norte, BrazilThe government of Brazil has notified the NTSB of an accident involving an amateur-built Vans RV-10 airplane that occurred on September 16, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…Sep 16, 2019 · PP-ZOJ · DestroyedNTSB ENG19IA034Incident · No injuriesClass 3 · IncidentFinal reportAirbus A220 · Côte-d'Or Region, FranceA No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed because of a…Sep 16, 2019 · HB-JCA · No damageNTSB GAA19WA574Accident · 2 fatalForeign investigationCirrus SR22 · Pedreguer, SpainThe government of Spain has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on September 15, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions…Sep 15, 2019 · F-HAMP · DestroyedNTSB ENG19WA035Incident · No injuriesForeign investigationBoeing B777 200ER · Lahore, Pakistan, PakistanOn September 15, 2019, while in flight at approximately 5 miles northwest of Lahore, Pakistan, the pilot of a Pakistani International Airlines Boeing 777-200ER, registration AP-BGK, powered by two General Electric GE90 turbofan engines, initiated a Mayday…Sep 15, 2019 · AP-BGKNTSB DCA19WA216Incident · No injuriesForeign investigationAirbus A321 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Airbus A321 airplane that occurred on September 11, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…Sep 11, 2019 · N958JB · No damageNTSB GAA19WA553Accident · 1 fatalForeign investigationCessna 208 · Gransee, GermanyThe government of Germany has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on September 09, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the…Sep 9, 2019 · D-FIDI · DestroyedNTSB GAA19WA593Accident · No injuriesForeign investigationPiper PA25 · Mazatan, Chiapas, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…Sep 5, 2019 · XB-LEDNTSB GAA19WA565Accident · 1 fatalForeign investigationCessna 172 · Racine, CanadaThe government of Canada has notified the NTSB of an accident involving a CESSNA 172 that occurred on September 05, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of ICAO…Sep 5, 2019 · C-GSEN · DestroyedNTSB DCA19WA212Incident · No injuriesForeign investigationBoeing 737 · South AfricaThe government of South Africa has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 02, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…Sep 2, 2019 · ZS-SJD · No damageNTSB GAA19WA594Accident · 1 fatalForeign investigationAirbus A350 · Alta city, NorwayThe government of Norway has notified the NTSB of an accident involving a AIRBUS A350 helicopter that occurred on August 31, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Norway's investigation under the provisions…Aug 31, 2019 · LN-OFU · DestroyedNTSB WPR19WA260Accident · 1 fatalForeign investigationAir Tractor AT502 · Gusap, Papua New GuineaOn August 29, 2019, an Air Tractor AT-502B aircraft, registered P2-SET, operated by Ramu Agriculture Industries, collided with a tree near Gusap, Papua New Guinea. The pilot was fatally injured and the airplane was destroyed. The Papua New Guinea (PNG)…Aug 29, 2019 · P2-SET · Destroyed