NTSB investigations, 2018, Outside the U.S.

100 cases where the phase of flight was Enroute.

Cases per year

19622026
NTSB investigations, 2018, 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\") = 2018
    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 ENG19IA008IncidentClass 3 · IncidentFinal reportAirbus A220 · Busan, South KoreaThe manufacturer’s inadequate cleaning of the crucible before melting the nickel alloy used in casting the low pressure turbine stage 3 blades that resulted in a casting anomaly from where an intergranular crack occurred became the origin of a fatigue crack…Dec 26, 2018 · HL8314 · No damageNTSB ERA19RA077Accident · 5 fatalForeign investigationAgusta A109 · Santa Maria Coronango, State of Puebla, MexicoThe government of Mexico has notified the NTSB of an accident involving a AGUSTA A109S helicopter that occurred on December 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…Dec 24, 2018 · XA-BON · DestroyedNTSB DCA19WA057Incident · No injuriesForeign investigationBoeing 747-428 · Delhi Airspace, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on December 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…Dec 21, 2018 · N919CA · No damageNTSB CEN19WA080Accident · No injuriesForeign investigationCirrus SR22 · Toussus-Le-Noble, FranceThe government of France has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on December 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…Dec 18, 2018 · N842CD · DestroyedNTSB CEN19WA102Accident · 3 fatalForeign investigationCirrus SR22 · Beauberry, FranceThe government of France has notified the NTSB of an accident involving a Cirrus SR22 airplane that occurred on December 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions…Dec 10, 2018 · F-HUGE · Substantial damageNTSB DCA19CA034Accident · Serious injuriesClass 4 · Data collectionFinal reportBoeing 767 · SUNNS intersection, Osaka, JapanThe airplane’s encounter with severe turbulence.Dec 4, 2018 · N193DN · No damageNTSB CEN19WA040Accident · 4 fatalForeign investigationCessna U206 · Culiacan, Sinaloa, MexicoDec 3, 2018 · XB-NGU · Substantial damageNTSB WPR19WA033Accident · Serious injuriesForeign investigationCessna U206 · Machadodorp, South AfricaOn November 29, 2018, about 1606 universal coordinated time, a Cessna U206D airplane, South African registration ZS-DIV, impacted terrain near the Skoonman Kloff in the Machadodorp area in Mpumalanga Province, South Africa. The pilot and 4 passengers were…Nov 29, 2018 · ZS-DIV · Substantial damageNTSB WPR19WA038Accident · No injuriesForeign investigationBell 407 GX · West Bangkala, IndonesiaOn November 28, 2018, about 0850 coordinated universal time, a Bell Helicopter 407 GX, PK-JPB, executed a precautionary landing following the illumination of the engine chip detector caution light near West Bangkala, Indonesia. There were no injuries to the…Nov 28, 2018 · PK-JPB · Substantial damageNTSB ERA19WA104Accident · 6 fatalForeign investigationAgusta AW109 · Campos do Jordao, BrazilThe government of Brazil has notified the NTSB of an accident involving a Agusta AW109 helicopter that occurred on November 24, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…Nov 24, 2018 · PT-FPS · DestroyedNTSB WPR19WA081Accident · 5 fatalForeign investigationCessna U206 · Chemajenjera Hill, ZimbabweOn November 23, 2018, about 0530 coordinated universal time, a Cessna U206C airplane, Z-BRS, was destroyed when it impacted terrain near Chemajenjera Hill, Zimbabwe. The pilot and four passengers were fatally injured. The airplane was operated under the…Nov 23, 2018 · Z-BRS · DestroyedNTSB ERA19WA053Accident · 2 fatalClass 5 · ForeignCessna TU206 · Puente Alto, ChileNov 21, 2018 · CC-CXS · DestroyedNTSB DCA21WA112Incident · No injuriesClass 5 · ForeignBoeing 737 · Buenos Aires, ArgentinaNov 17, 2018 · LV-HFR · No damageNTSB ERA19WA045Accident · No injuriesForeign investigationPiper PA25 · Ezperanza, Dominican RepublicThe government of the Dominican Republic has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of the Dominican Republic's…Nov 14, 2018 · HI191 · Substantial damageNTSB CEN19WA041Accident · 2 fatalForeign investigationCessna T206H · Tampico, MexicoOn November 12, 2018, about 2016 UTC, a Mexican registered Cessna T206H airplane, XB-ILM, sustained substantial damage during a forced landing to a highway due to a loss of engine power near Tampico, Tamaulipas, Mexico. The pilot and passenger were not…Nov 12, 2018 · XB-ILM · Substantial damageNTSB DCA19WA023Incident · No injuriesForeign investigationEmbraer 190 · Bara, PortugalThe GPIA of Portugal has notified the NTSB of an incident involving a Embraer 190 airplane that occurred on November 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the GPIA of Portugal's investigation under the provisions of ICAO…Nov 11, 2018 · P4-KCJ · No damageNTSB CEN19WA038Accident · 1 fatalForeign investigationPiper PA25 · Pachuca, Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…Nov 8, 2018 · XB-FRCNTSB CEN19WA037Accident · 1 fatalForeign investigationRotorway Exec · Saint Pierre, St. Pierre & MiquelonNov 5, 2018 · F-PSPM · DestroyedNTSB CEN19WA042Accident · No injuriesForeign investigationPiper PA34 · Uk, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a PIPER PA34 airplane that occurred on November 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…Nov 2, 2018 · G-OXFFNTSB DCA19WA015Incident · No injuriesForeign investigationBoeing 787 · Hong Kong, ChinaThe government of China has notified the NTSB of an accident involving a BOEING 787 airplane that occurred on October 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of China's investigation under the provisions of…Oct 20, 2018 · VT-ANE · No damageNTSB DCA19WA027Incident · No injuriesForeign investigationBoeing 737 · Bangkok, ThailandThe AAIC of Thailand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIC of Thailand's investigation under the provisions of ICAO…Oct 19, 2018 · HS-LTJ · No damageNTSB WPR19WA012Accident · 3 fatalClass 5 · ForeignHughes 369 · Wanaka, New ZealandOct 17, 2018 · ZK-H0J · DestroyedNTSB DCA19WA071Incident · No injuriesForeign investigationBoeing 747 · Kolkata, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Boeing 747, which occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…Oct 16, 2018 · N578UP · No damageNTSB DCA19WA013Incident · No injuriesForeign investigationBoeing 737 · East Midlands, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on October 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under…Oct 12, 2018 · G-JMCR · No damageNTSB DCA19WA009Incident · Minor injuriesForeign investigationBoeing 737 · Zagreb, CroatiaThe AIN of Croatia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on October 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIN of Croatia's investigation under the provisions of ICAO Annex…Oct 2, 2018 · TC-AMP · No damageNTSB CEN19WA001Accident · 3 fatalForeign investigationCessna 210 5 · Yécora, MexicoOn October 1, 2018, about 2110 universal coordinated time (UTC), a Cessna 210, US registration N8388Z, impacted terrain under unknown circumstances near Sonora, Mexico. Under the provisions of ICAO Annex 13, the NTSB has assigned an accredited representative…Oct 1, 2018 · N8388Z · Substantial damageNTSB DCA18WA300Incident · No injuriesForeign investigationBoeing 737 · Diagoras, HungaryThe government of Hungary has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Hungary's investigation under the…Sep 28, 2018 · N917XA · No damageNTSB ANC18WA078Accident · 1 fatalForeign investigationCessna 208 · Narita, JapanOn September 27, 2018, at 0626 universal coordinated time, a Cessna 208B airplane, VH-FAY, disappeared from radar during cruise flight over international waters, about 185Km northeast of Narita International Airport. Parts from the destroyed airplane were…Sep 27, 2018 · VH-FAY · DestroyedNTSB DCA18WA296Incident · Minor injuriesForeign investigationAirbus A320 · Tijuana, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on September 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…Sep 26, 2018 · XA-VOWNTSB CEN18WA390Accident · 1 fatalForeign investigationRobinson R44 · Buttonville, CanadaOn September 25, 2018, about 1800 hours universal coordinated time, a Robinson R44 II helicopter, Canadian registration C-GMCT, impacted terrain while diverting due to deteriorating weather conditions near the Toronto/Buttonville Municipal Airport (CYKZ),…Sep 25, 2018 · C-GMCT · Substantial damageNTSB WPR18WA282Accident · Minor injuriesForeign investigationBell 206 · Yarraden, AustraliaOn September 22, 2018, at 2045 coordinated universal time, a Bell 206B helicopter, registration VH-HZO, sustained substantial damage after colliding with the ground following a total loss of power near Yarraden, Australia. The pilot was not injured. The three…Sep 22, 2018 · VH-HZO · Substantial damageNTSB ERA18WA252Accident · 1 fatalForeign investigationBeech C90 · Ipumirim County, BrazilThe government of Brazil has notified the NTSB of an accident involving a BEECH C90 airplane that occurred on September 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…Sep 15, 2018 · PR-RFB. · DestroyedNTSB DCA18WA302Incident · No injuriesForeign investigationBoeing 737 · Edinburgh, United KingdomThe Air Accidents Investigation Branch (AAIB) of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of…Sep 10, 2018 · EI-GJT · No damageNTSB ERA18WA245Accident · 1 fatalForeign investigationBell 430 · Bostanci, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a Bell 430 that occurred on September 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of ICAO…Sep 6, 2018 · TC-HYU · Substantial damageNTSB CEN18WA403Accident · No injuriesForeign investigationRobin DR400 · Benodet, FranceOn September 3, 2018, about 1005 UTC, a Robin DR400 airplane, French registration F-GSBK, sustained a loss of engine power while in cruise flight near Benodet, France. The three occupants onboard sustained no injury. The airplane was destroyed. The accident…Sep 3, 2018 · F-GSBK · DestroyedNTSB ERA18WA247Accident · 1 fatalForeign investigationBeech 33 · Taquaraçu de Minas, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech 33 airplane that occurred on September 01, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…Sep 1, 2018 · PT-OCB · DestroyedNTSB DCA18WA313Incident · No injuriesForeign investigationHarbin Y12 · Antioq, ColombiaThe Civil Aviation Authority (CAA) of Colombia has notified the NTSB of an incident involving a HAIC Harbin Y12E, which occurred on August 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CAA investigation under the provisions…Aug 26, 2018 · HK5036 · Minor damageNTSB CEN18WA353Accident · 1 fatalForeign investigationPiper PA34 · Loma Linda, Costa RicaAug 22, 2018 · TI-BDH · Substantial damageNTSB DCA18WA279Incident · No injuriesForeign investigationBoeing 737 · Guadalajara, MexicoThe government of Mexico has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 20, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Aug 20, 2018 · N520AM · No damageNTSB DCA18WA271Incident · No injuriesForeign investigationBoeing 737 · Narrandera, AustraliaThe ATSB of Australia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB's investigation under the provisions of ICAO Annex 13 as…Aug 15, 2018 · VH-XMO · No damageNTSB DCA24WA108IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoAug 6, 2018 · CN-RNJ · No damageNTSB CEN18WA318Accident · 3 fatalForeign investigationCessna 172 · Puy-de-Dome Mazoires, FranceOn August 6, 2018, about 1045 coordinated universal time, a Cessna 172S airplane, French registration F-GTNV, lost radio and radar contact; the wreckage was located near Puy-de-Dôme Mazoires, France. The airplane was destroyed, and the three occupants…Aug 6, 2018 · F-GTNV · DestroyedNTSB ANC18WA061Accident · 2 fatalForeign investigationPiper PA-31 · Calgary, CanadaOn August 1, 2018, at 1336 mountain daylight time, a Canadian registered Piper PA-31, C-FNCI, operated by Aries Aviation Services Corp., was substantially damaged after impacting terrain under unknown circumstances 35 miles southwest of Calgary, Canada. The…Aug 1, 2018 · C-FNCINTSB CEN18WA304Accident · 1 fatalForeign investigationQuad City Challenger · North Bay, CanadaOn July 30, 2018, about 1500 Coordinated Universal Time, a Quad City Challenger II airplane, Canadian registration C-IGKT, crashed near Talon Lake, North Bay, Ontario, Canada. The pilot was fatally injured. The flight departed North Bay (CYYB), Ontario, and…Jul 30, 2018 · C-IGKT · Substantial damageNTSB ERA18WA218Accident · 3 fatalForeign investigationPiper PA34 · Irineopolis, BrazilThe government of Brazil has notified the NTSB of an accident involving a Piper PA-34-220T that occurred on July 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO…Jul 26, 2018 · PR-DMC · DestroyedNTSB DCA18WA243Incident · No injuriesForeign investigationBoeing 737 · Frankfurt, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…Jul 13, 2018 · EI-ENMNTSB ERA18WA216Incident · No injuriesForeign investigationCessna 501 · Catamarca, ArgentinaThe government of Argentina has notified the NTSB of an incident involving a CESSNA 501 airplane that occurred on July 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the provisions…Jul 12, 2018 · LV-CGO · Minor damageNTSB DCA18WA232IncidentClass 5 · ForeignBoeing 737 · Multan, PakistanJul 12, 2018 · A6-FGB · No damageNTSB DCA18WA247Incident · No injuriesForeign investigationDouglas DC9 · Chichen Itza, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a Douglas DC9 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…Jul 11, 2018 · N802WA · No damageNTSB CEN18WA327Accident · No injuriesForeign investigationColumbia LC41-550FG · Vallecillos, MexicoOn July 4, 2018, about 1910 UTC, a Mexican registered Columbia LC41-550FG airplane, XB-OHG, sustained substantial damage during a forced landing due to a loss of engine power near Vallecillos, Nuevo Leon, Mexico. The pilot was not injured. The flight…Jul 4, 2018 · XB-OHG · Substantial damage