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 ERA18WA052Accident · Serious injuriesForeign investigationBeech B200 · Pucallpa, PeruThe government of Peru has notified the NTSB of an accident involving a Beech B200C airplane that occurred on October 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of…NTSB ERA18WA013Accident · 1 fatalForeign investigationCessna 208 · Novo Airao, BrazilOn October 17, 2017, about 1540 universal coordinated time, an amphibious Cessna 208, Brazilian registration PR-MPE, was substantially damaged after it came to rest inverted while attempting to land on a river in Novo Airao county, State of Amazonas, Brazil.…NTSB ENG18WA038Incident · No injuriesForeign investigationEmbraer ERJ190 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an incident involving an Embraer 190-200 LR, which occurred on October 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB CEN18WA016Accident · 1 fatalForeign investigationAvid Mark IV · Jüterborg, GermanyOn October 16, 2017, about 1123 UTC, an amateur-built Avid Mark IV airplane, French registration F-JAGB, owned and operated by a private individual, crashed during a test flight near Jüterborg, Germany. The pilot on board was fatally injured and the airplane…NTSB WPR18WA025Accident · 1 fatalForeign investigationQuicksilver GT500 · Melaka, MalaysiaOn October 14, 2017, about 1130 local time, a Quicksilver Aircraft GT-500, registration 9M-EAC, was destroyed after colliding with a river shortly after takeoff from Sungai Rambai Aerodrome, Melaka, Malaysia. The airplane was operated under the pertinent…NTSB DCA18WA015Incident · No injuriesForeign investigationBoeing 777 · Adelaide, AustraliaThe government of Australia has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on October 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB DCA18WA016Incident · No injuriesForeign investigationBoeing 737 · Moscow, RussiaThe Federal Air Transport Agency (FATA) of Russia has notified the NTSB of an incident involving a Boeing 737, which occurred on October 13, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the…NTSB ERA18WA015Accident · 1 fatalForeign investigationCessna U206 · Itaituba, BrazilOn October 11, 2017, about 1600 universal coordinated time, a Cessna U206G, Brazilian registration PT-LSC, was destroyed when it collided with a tree during takeoff near Itaituba, State of Para, Brazil. The pilot was fatally injured, and one passenger…NTSB ENG18RA009Accident · No injuriesForeign investigationDe Havilland DHC8 · Belfast, IrelandThe UK AAIB has notified the NTSB of an accident involving a Bombardier DHC-8-402, which occurred on October 11, 2017. The crew diverted to Belfast International Airport and landed with the nose landing gear retracted. The NTSB has appointed a U.S. Accredited…NTSB ERA18WA014Accident · 3 fatalForeign investigationBeech E33A · São José do Rio Preto, BrazilOn September 10, 2017, about 1525 coordinated universal time, a Beechcraft E33-A, Brazilian registration PT-DDB, struck a residence while conducting a go around near São José do Rio Preto State Airport (SBSR), Brazil. The airplane was substantially damaged,…NTSB CEN18WA029Accident · Minor injuriesForeign investigationRobinson R44 · Namur, BelgiumNTSB CEN18WA007Accident · 1 fatalForeign investigationRobinson R44 · Gramzda, LatviaOn October 8, 2017, about 1014 Coordinated Universal Time (UTC), a Robinson R44 helicopter, YL-HBH, impacted a powerline after takeoff near Gramzda, Latvia. One passenger was fatally injured and the pilot and two other passengers on board were seriously…NTSB ERA18WA009Accident · 1 fatalForeign investigationZlin Z50 · Gauteng Province, South AfricaOn October 6, 2017, about 1530 coordinated universal time, a Zlin Z-50L, South African registration ZS-VAR, was destroyed when it impacted terrain shortly after takeoff from Kitty Hawk Airport (FAKT), Gauteng Province, South Africa. The pilot was fatally…NTSB CEN18WA005Accident · 1 fatalForeign investigationPiper PA25 · Cerro de Ortega, MexicoNTSB ANC18RA001Accident · 1 fatalForeign investigationRobinson R44 · Campbell River, CanadaNTSB ENG17RA039Accident · No injuriesForeign investigationAirbus A380 · Goose Bay, CanadaOn September 30, 2017, an Air France A380 operating as flight AF 66 from Paris, France to Los Angeles, California had the No. 4 engine's inlet and fan rotor separate from the remainder of the engine. The airplane diverted to Goose Bay, Canada for landing. The…NTSB DCA17WA215Incident · No injuriesForeign investigationBoeing 737 · Budapest, HungaryThe Ministry of National Development Transport Safety Bureau of Hungary has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on September 29, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB ERA17WA342Accident · 1 fatalForeign investigationRobinson R44 · Cape Town, South AfricaOn September 28, 2017, about 1000 coordinated universal time, a Robinson R44 II helicopter, South African registration ZS-OSL, was destroyed when it impacted terrain during an emergency autorotation near Cape Town, South Africa. The pilot was fatally injured.…NTSB DCA17WA216Incident · No injuriesForeign investigationBoeing 737 · Luga, MaltaThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation…NTSB DCA17WA226Incident · No injuriesForeign investigationAirbus A320 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of a serious incident involving a AIRBUS A320 airplane that occurred on September 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB ERA17WA344Accident · 2 fatalForeign investigationCessna 150 · BahamasOn September 26, 2017, a Cessna 150G, N3214X, went missing and was presumed to be substantially damaged. The private pilot and passenger were also missing, and presumed to be fatally injured. As of October 30, 2017, the airplane had not been found. A visual…NTSB CEN17WA369Accident · 1 fatalForeign investigationMD Helicopter 369 · Norrbotten, Sweden, SwedenOn September 26, 2017, about 1154 hours universal coordinated time, an MD Helicopters 369D, Swedish registration SE-JVI, impacted terrain about one-third mile from the Alvsbyn Airport (ESUV), Norrbotten, Sweden. One pilot was fatally injured and the second…NTSB DCA17WA205Incident · No injuriesForeign investigationBoeing 777 · Osaka, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 777 airplane that occurred on September 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…NTSB DCA17WA203Incident · No injuriesForeign investigationAirbus A330 · Hong Kong, Hong Kong SAR ChinaThe Civil Aviation Department of Hong Kong has notified the NTSB of an incident involving a BOEING 747-433 airplane that occurred on September 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of the Government of the…NTSB ERA17WA331Accident · Minor injuriesForeign investigationCessna 650 · Istanbul, TürkiyeOn September 21, 2017, at 1820 universal coordinated time, a Cessna 650 (Citation III), Turkish registration TC-KON, operated by Avione Jet, was destroyed by postimpact fire after a runway excursion at Istanbul Atatürk Airport, Istanbul, Turkey (LTBA). The…NTSB CEN17WA370Accident · 2 fatalForeign investigationCessna 150J · Goderich, CanadaOn September 20, 2017, about 2036 eastern daylight time, a Cessna 150J single-engine airplane, Canadian registration C-FHPU, serial number 15070602, crashed in Lake Huron about 1.1 nautical miles west of Goderich Municipal Airport (CYGD), Goderich, Ontario,…NTSB DCA17WA222Incident · No injuriesForeign investigationBoeing 737 · Bangkok, ThailandThe AAIB of Thailand has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of Thailand's investigation under the provisions of ICAO…NTSB DCA17WA201Incident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe government of India Ministry of Civil Aviation Aircraft Accident Investigation Bureau (AAIB) has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on September 19, 2017. The NTSB has appointed a U.S. Accredited…NTSB CEN17WA360Accident · 2 fatalForeign investigationVans RV4 · Stafsberg, NorwayOn September 19, 2017, at 1450 UTC, a Vans Aircraft RV-4, experimental, amateur-built airplane, Norwegian registration LN-ABF, impacted terrain near the Hamar Airport (ENHA), Stafsberg, Norway. The pilot and passenger on board were fatally injured and the…NTSB CEN17WA383Accident · 1 fatalForeign investigationBell 47G · Llano Bonito de Pococí, Costa RicaOn September 18, 2017, at 0720 central daylight time, a Bell 47G2 helicopter, Costa Rican registration TI-BGH, serial number 1459, impacted terrain during an aerial application flight, near Llano Bonito de Pococí, Costa Rica. The pilot was fatally injured,…NTSB DCA17WA204Incident · No injuriesForeign investigationBoeing 737 · Aqaba, JordanThe Jordan Civil Aviation Regulatory Commission (CARC) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on September 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Jordan's…NTSB ERA17WA345Accident · 1 fatalForeign investigationCessna U206F · Caracarai, BrazilOn September 15, 2017, about 1300 coordinated universal time, a Cessna U206F, Brazilian registration PT-JPW, was substantially damaged after ditching in the Rio Branco river, near Caracaraí, Brazil. The pilot was fatally injured. The flight was conducted…NTSB DCA17WA209Accident · No injuriesForeign investigationAirbus A321 231 · Christ Church, BarbadosThe Barbados Civil Aviation Department has notified the NTSB of an accident involving a AIRBUS A321 231 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Barbados's investigation…NTSB DCA17WA200Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…NTSB DCA17WA199Incident · No injuriesForeign investigationBoeing 737 · Caracas, VenezuelaThe DGAC of Venezuela has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB DCA17WA198Accident · Serious injuriesForeign investigationBoeing 737 · Adelaide, AustraliaThe ATSB of Australia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the provisions…NTSB CEN17WA353Accident · 2 fatalForeign investigationMooney M 20K · Braunwald, SwitzerlandNTSB ERA17WA323Accident · 1 fatalForeign investigationBritten Norman BN2A · San Salvador de Paul, VenezuelaOn September 11, 2017 about 1400 coordinated universal time, a Britten Norman BN2-A, Venezuelan registration YV1441, was landing at San Salvador de Paul, Ciudad Bolivar, Venezuela, when it struck and fatally injured a child who was on the runway. The pilot…NTSB DCA17WA229Incident · No injuriesForeign investigationBoeing 737 · Conakry, GuineaThe government of Guinea has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guinea's investigation under the provisions…NTSB CEN17WA343Accident · 2 fatalForeign investigationPiper Piper PA-28RT-201 · Wolferton, United KingdomOn September 11, 2017, at 0956 universal coordinated time (UTC), a Piper PA-28RT-201 single-engine airplane, United Kingdom registration G-BHAY, serial number 28R-7918213, was substantially damaged during a forced landing following a loss of engine power and…NTSB CEN17WA381Incident · No injuriesForeign investigationGulfstream GV · Le Bourget, FranceOn September 10, 2017, a Gulfstream GV SP 550 airplane, Monaco registration M-SAWO, experienced abnormal runway contact during landing at Le Bourget Airport, Le Bourget, France. A wingtip sustained minor damage during the landing, and the two pilots and four…NTSB ERA17WA321Accident · 1 fatalForeign investigationPiper Piper PA-34-200T · Cerrione, ItalyNTSB DCA17WA223Incident · No injuriesForeign investigationBoeing 737 · Cancun, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 06, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB ENG17RA037Incident · No injuriesForeign investigationBoeing 777 · Tokyo, JapanThe Japan Transportation Safety Board (JTSB) has notified the NTSB of an incident involving a B777-300ER that occurred September 5, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…NTSB DCA17WA218Accident · Minor injuriesForeign investigationBoeing 737 · Chochin, IndiaThe Aircraft Accident Investigation Bureau of India has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's…NTSB CEN17RA337Accident · 2 fatalForeign investigationCessna U206 · San Jose, Costa RicaimportNTSB ERA17WA320Accident · 2 fatalForeign investigationCessna 182 · Pontinia, ItalyOn September 3, 2017 about 1030 universal coordinated time, a Cessna 182P, I-SCAP, impacted terrain during initial climb after takeoff, from Pegaso Club 2000 Airfield, Pontinia, Italy. The airplane was destroyed by impact forces and a post crash fire. Five…NTSB ERA17WA318Accident · 2 fatalForeign investigationCessna 172 · Hekpoort, South AfricaOn September 3, 2017, about 0930 coordinated universal time, a Cessna 172M, South African registration ZS-JDN, was destroyed when it impacted a valley in the Magaliesberg Mountain range, near Hekpoort, South Africa. The two commercial pilots were fatally…NTSB DCA17WA196Incident · No injuriesForeign investigationBoeing 737 · Leon, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB CEN17WA378Accident · 1 fatalForeign investigationPiper PA25 · Sueco, Chihuahua, Mexico, MexicoOn September 2, 2017, about 1700 hours universal coordinated time, a Piper PA25-235, Mexican registration XB-EXZ, was substantially damaged when it impacted powerlines near Sueco, Chihuahua, Mexico. The pilot was seriously injured. The local flight departed…