NTSB investigations, Outside the U.S.
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "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 c.\"eventCountry\" <> 'USA' 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.
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 c."eventCountry" <> 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN18WA343Accident · 1 fatalForeign investigationPiper PA25 · Namiquipa, MexicoOn August 1, 2018, about 0956 hours mountain daylight time, a Piper PA-25-235 single-engine airplane, serial number 25-4177, Mexican registration XB-FMA, crashed in an agricultural field near Namiquipa, Mexico. The pilot was fatally injured. The local aerial…NTSB ANC18WA062Accident · 2 fatalForeign investigationCessna 180 · Gold Bridge, CanadaOn August 1, 2018, about 1245 Pacific daylight time, a Canadian registered float-equipped Cessna 180, C-FCDQ, operated by Fort Langley Air Ltd., was substantially damaged after impacting the surface of Lake Tyaughton, British Columbia, shortly after takeoff.…NTSB 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…NTSB DCA18RA253Accident · Serious injuriesForeign investigationEmbraer ERJ190 · Durango, MexicoThe Director General of Civil Aviation (DGAC) of Mexico has notified the NTSB of an accident involving an Embraer E-190, which occurred on July 31, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation under the…NTSB 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…NTSB ANC18WA075Accident · 1 fatalForeign investigationPiper PA28 · Black Diamond, CanadaOn July 30, 2018, about 0133 Coordinated Universal Time, a Piper PA-28-161 airplane, C-GVZJ, was departing a cut hay field and collided with hay bales near Black Diamond, Alberta, Canada, under unknown circumstances. Of the two occupants onboard, 1 sustained…NTSB ERA18WA209Accident · 1 fatalForeign investigationBeech 90 · Sao Paulo, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech C90 that occurred on July 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of ICAO Annex…NTSB DCA18WA263Incident · No injuriesForeign investigationBoeing 737 · Birmingham, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB GAA18WA590Accident · No injuriesForeign investigationAero Commander 500 · Canefield Airoprt, DominicaThe government of Dominica has notified the NTSB of an accident involving a AERO COMMANDER 500 airplane that occurred on July 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominica's investigation under the…NTSB ERA18WA219Accident · 3 fatalForeign investigationCessna 210 · Sao Felix do Xingu, BrazilThe government of Brazil has notified the NTSB of an accident involving a Cessna 210 airplane that occurred on July 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB 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…NTSB ERA18WA198Accident · 4 fatalForeign investigationBeech 58 · Ayolas, ParaguayThe government of Paraguay has notified the NTSB of an accident involving a BEECH 58 airplane that occurred on July 25, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Paraguay's investigation under the provisions of…NTSB CEN18WA308Accident · 1 fatalForeign investigationAir Tractor AT301 · Ascension, Chihuahua, MexicoOn July 25, 2018, about 1600 coordinated universal time, a Mexican registered Air Tractor AT 301 airplane, XB-OVB, impacted terrain near Ascension, Chihuahua, Mexico. The pilot was fatally injured and the airplane sustained substantial damage. The local…NTSB DCA18WA297Incident · No injuriesForeign investigationAirbus A330 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a AIRBUS A330 airplane that occurred on July 23, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB CEN18WA324Accident · No injuriesForeign investigationCessna 750 · Cork, IrelandOn July 23, 2018, about 1741 hours universal coordinated time, a Cessna 750, United States registration N752TX, was substantially damaged during takeoff at the Cork International Airport (EICK), Cork, Ireland. The two pilots and six passengers were not…NTSB CEN18WA305Accident · 1 fatalForeign investigationLavia Argentina PA-25-260 · Namiquipa, Chihuahua, MexicoOn July 22, 2018, about 1500 coordinated universal time, a Lavia Argentina S.A. PA-25-260 airplane, XB-EGL and Lavia Argentina S.A. PA-25-235 airplane, XB-DVX, collided during aerial application maneuvers near Namiquipa, Chihuahua, Mexico. The pilot of XB-EGL…NTSB CEN18WA393Accident · Minor injuriesForeign investigationAerospatiale AS350 · Wolfsberg, AustriaNTSB CEN18WA279Accident · 1 fatalForeign investigationCessna 150 · Tortola, British Virgin IslandsNTSB CEN18WA375Accident · No injuriesForeign investigationCessna Cessna R182 · Les Rabassieres, FranceOn July 17, 2018, at 1300 UTC, a Cessna 182, G-BHYA, S/N R182-00532, experienced an engine failure on a local flight from a private airfield in Les Rabassières, France. The pilot declared an emergency landing and the airplane experienced a runway excursion…NTSB DCA18WA270Accident · No injuriesForeign investigationBoeing 737 · Iguazu Province of Misiones, ArgentinaThe Junta de Investigacion de Accidentes de Aviacion Civil (JIAAC) of Argentina has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB DCA18WA248Accident · No injuriesForeign investigationBoeing 737 · Confins county, BrazilThe government of Brazil has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB ERA18WA196Accident · 2 fatalForeign investigationPiper PA28R · Santiago, ChileThe government of Chile has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on July 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…NTSB ERA18WA207Accident · 1 fatalForeign investigationAero Eli Servizi Yo-Yo 222 · Musile del Piave, ItalyThe government of Italy has notified the NTSB of an accident involving a Aero Eli Servizi Yo-Yo 222 helicopter that occurred on July 13, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB 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…NTSB GAA18WA586Accident · Serious injuriesForeign investigationBeagle B121 · Bembridge, Isle of Wight, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a BEAGLE B121 airplane that occurred on July 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB 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…NTSB DCA18WA232IncidentClass 5 · ForeignBoeing 737 · Multan, PakistanNTSB CEN18WA320Accident · 1 fatalForeign investigationChampion 8KCAB · Toronto, CanadaOn July 12, 2018, at 2359 universal coordinated time, a Bellanca 8KCAB, Canadian registration C-GDLP, declared an emergency and impacted terrain shortly after takeoff from the Toronto/Buttonville Airport (CYKZ), Ontario, Canada. The pilot was fatally injured.…NTSB 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…NTSB DCA18WA245Accident · Minor injuriesForeign investigationDouglas DC3 · Guainia, ColombiaThe government of Colombia has notified the NTSB of an accident involving a DOUGLAS DC3 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…NTSB DCA18WA241Incident · No injuriesForeign investigationBoeing 737 · Djerba, TunisiaThe government of Tunisia has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Tunisia's investigation under the provisions of…NTSB CEN18WA395Accident · No injuriesForeign investigationPiper PA34 · Kemble, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB CEN18WA268Accident · 2 fatalForeign investigationRobinson R44 · Domecko, PolandOn July 11, 2018, at 0736 coordinated universal time (UTC), a Robinson Helicopter R-44 II helicopter, SP-MAP, impacted terrain near Opole, Poland. 2 occupants were fatally injured, and 1 occupant was seriously injured.The investigation is under the…NTSB ENG18WA042Incident · No injuriesForeign investigationHonda HA-420 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau (AIB) of the Kingdom of Saudi Arabia has notified the NTSB of an incident involving a Honda HA-420, which occurred on July 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation…NTSB CEN18WA264Accident · 1 fatalForeign investigationCessna 152 · Ponte de Sor, PortugalThe government of Portugal has notified the NTSB of an accident involving a Cessna 152 airplane that occurred on July 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Portugal's investigation under the provisions…NTSB CEN18WA261Accident · 1 fatalForeign investigationRobinson R44 Raven I · Kanaš, SlovakiaOn July 7, 2018, at 1640 coordinated universal time, a Robinson R22 Raven 1, OM-TTM, impacted powerlines during takeoff near Kanaš, Slovak Republic. The helicopter was destroyed. The pilot sustained fatal injuries. The flight was originating at the time of…NTSB 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…NTSB CEN18WA256Accident · 2 fatalForeign investigationCessna 172 · Bad Voslau, AustriaOn June 4, 2018, about 0815 coordinated universal time, a Cessna 172S airplane, F-HFPL, impacted terrain at Bad Voslau Airport, Bad Voslau, Austria. The pilot in command and passenger were fatally injured, and the airplane was destroyed. The flight was…NTSB DCA18WA246Incident · No injuriesForeign investigationBoeing 737 300 · Nassau, BahamasThe Air Accident Investigation Department (AAID) - Ministry of Tourism, Aviation & Bahamasair has notified the NTSB of an incident involving a Boeing 737 300 airplane that occurred on July 03, 2018. The NTSB has appointed a U.S. Accredited Representative to…NTSB ENG18WA039Incident · No injuriesForeign investigationMcdonnell Douglas MD80 · Songshan, Taipei, China, TaiwanOn July 2, 2018, Far Eastern Air Transport, flight FE8026, an MD82 aircraft, registration number B-28035, took off from Penghu Airport for Songsang Airport. The aircraft declared PAN PAN at 7 miles from the runway of Songshan Airport at an altitude of 2,800…NTSB CEN18WA254Accident · No injuriesForeign investigationBritten Norman BN2A · Ambergris Caye, BelizeNTSB DCA18WA238Incident · Minor injuriesForeign investigationAirbus A330 · Gander, CanadaThe government of Canada has notified the NTSB of an accident involving a Airbus A330 airplane that occurred on June 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…NTSB DCA18WA234Incident · No injuriesForeign investigationBoeing 777 · Narita, JapanThe government of Japan has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on June 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of ICAO…NTSB WPR18WA185Accident · 5 fatalForeign investigationBeech C90 · Mumbai, IndiaOn June 28, 2018, at 0740 Universal Coordinated Time, a King Air C90 airplane, VT-UPZ, was destroyed when it impacted the ground near Mumbai, India. The airplane was operated under the pertinent regulations of the Government of India. The two pilots, two…NTSB ERA18WA272Accident · 1 fatalForeign investigationCessna 172 · Adiyaman, TürkiyeThe government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on June 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of…NTSB ANC18WA060Accident · No injuriesForeign investigationBell 205 · Hudson Bay, CanadaOn June 27, 2018, at 1713 central standard time, a Canadian registered Bell 205A helicopter, C-FYHD, operated by Transwest Air Ltd Partnership, was substantially damaged during a precautionary landing due to severe airframe vibration at Buckmayer Lake,…NTSB DCA18WA229Incident · No injuriesForeign investigationBoeing 737 · Koln, GermanyThe government of Germany has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on June 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…NTSB ENG18RA032Incident · No injuriesForeign investigationDassault FALCON7X · Singapore, SingaporeThe Singapore TSIB has notified the NTSB of an incident involving a Dassault Falcon 7X, VQ-BLP, which occurred on June 25, 2018. There was a fire in the mechanical service compartment while passengers were on board. The NTSB has appointed a U.S. Accredited…NTSB WPR18WA202Accident · Serious injuriesForeign investigationZlin Z242L · Hong Kong, ChinaOn June 24, 2018, at 1638 local time, a Zlin Z 242 L airplane, B-LUK, was substantially damaged when it collided with the ground near Ma Shi Chau, Hong Kong, China. The private pilot was seriously injured. The airplane was operated in accordance with the…NTSB WPR18WA180Accident · 5 fatalForeign investigationPiper PA31 · Antananarivo, MadagascarOn June 18, 2018, about 0615 local time, a Piper PA-31 airplane, 5R-MKF, impacted terrain about 5 nautical miles from the Ivato International Airport, Antananarivo, Madagascar. The pilot in command, two pilot observers, pilot monitor, and one passenger were…