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 CEN15WA173Accident · 1 fatalForeign investigationEipper Quicksilver - GT500 · Illes Balears, SpainThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On March 14, 2015, about 1145 UTC, an Eipper Quicksilver GT-500 airplane, EC-DK6, (s/n 0085) impacted terrain after an…NTSB CEN15WA176Accident · No injuriesForeign investigationBeech 390 · Lancashire, United KingdomOn March 12, 2015, at 1148 universal coordinated time (UTC), a United Kingdom registered Beech 390 airplane, G-OOMC, overran the runway end, at the Blackpool Airport, Lancashire, United Kingdom. The two crewmembers and two passengers were not injured. The…NTSB DCA15WA090Accident · 1 fatalForeign investigationBell UH1H - NO Series · Cape Town, South AfricaThe government of South Africa has notified the NTSB of an accident involving a Bell UH-1H helicopter that occurred on March 08, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB ENG15WA016Incident · No injuriesForeign investigationFokker F28 - 0070 · Amsterdam, NetherlandsOn March 05, 2015, about 1215 LCL, a Fokker F28, PH-WXC, On March 5, 2015, a Fokker F28 experienced a braking failure while on the ramp and struck a ground power unit (GPU) at Schiphol Airport (EHAM), Amsterdam, the Netherlands.The incident is being…NTSB CEN15WA450Accident · 1 fatalForeign investigationPiper PA28 · Witzenhausen, Germany, GermanyOn March 4, 2015, about 0718 UTC, a Piper PA28, German registration D-ERIF, owned by a private individual, was substantially damaged when it impacted heavily wooded terrain near Witzenhausen, Germany, under unknown circumstances. The pilot was fataly injured.…NTSB CEN15WA161Accident · No injuriesForeign investigationCirrus SR22 · Ljubljana, Moste, Slovenia, SloveniaThe accident investigation is under the jurisdiction and control of the Slovenian government. This report is for information purposes only and contains only information released by or obtained from the Slovenian government. Further information pertaining to…NTSB DCA15WA080Accident · Serious injuriesForeign investigationBoeing 737 - 8AS · Bordeaux, FranceThe Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) of France has notified the NTSB of an accident involving a Boeing 737-800, which occurred on February 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist…NTSB DCA15WA075Accident · No injuriesForeign investigationBoeing 747 - 468 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau of the Kingdom of Saudi Arabia has notified the NTSB of an accident involving a Boeing 747-400, which occurred on February 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under…NTSB CEN15WA152Accident · 2 fatalForeign investigationAvions Robin Robin DR 400/140 B · Yverdon LSGY, SwitzerlandNTSB WPR15WA108Accident · 2 fatalForeign investigationRobinson R44 II · Queenstown, New Zealand, New ZealandOn February 19, 2015, at 0244 universal coordinated time, a Robinson R44 II, ZK-IPY, operated by Over the Top Limited, collided with terrain under unknown circumstances near Queenstown, New Zealand. The two occupants on board were fatally injured and the…NTSB ERA15WA137Accident · 4 fatalForeign investigationCessna 182P · Bueno Brandao, BrazilOn February 19, 2015, about 1340 Universal Coordinated Time (UTC), a Cessna 182P, Brazilian registration PT-KBV, was destroyed when it broke up inflight and impacted terrain near the Bueno Brandao Municipality, in the State of Minas Gerais, Brazil. The pilot,…NTSB ENG15RA015Incident · No injuriesForeign investigationBoeing 767 - 204ER · Islamabad, Pakistan, PakistanOn February 15, 2015, a Jordan Air Boeing 767-204ER, leased by Shaheen Air International (SAI), experienced a failure of the No. 1 engine, a General Electric CF6-80A2 turbofan engine, during the takeoff roll from the Islamabad International Airport (ISB),…NTSB WPR15WA124Accident · No injuriesForeign investigationBell 206 - L4 · Wabo, Papua New Guinea, Papua New GuineaOn February 15, 2015, at 1020 local time, a Bell 206 L4, P2-HFZ, experienced a loss of engine power while maneuvering with an external load and subsequently landed hard near Wabo, Papua New Guinea. The helicopter was operated by Helifax Operations Limited…NTSB ENG15WA034Incident · No injuriesForeign investigationAirbus A320 · Tehran, IranThe Civil Aviation Organization of the Islamic Republic of Iran (CAO.IRI) has notified the NTSB of an incident involving an Airbus A320-200, which occurred on February 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAO…NTSB CEN15WA150Accident · Minor injuriesForeign investigationPiper PA46 500TP · Björnön, SwedenNTSB ENG15RA011Incident · No injuriesForeign investigationBell 206 - L4 · Remote Location, South AfricaOn February 12, 2015, a Bell 206L-4 powered by a Rolls-Royce 250-C30P turboshaft engine experienced an uncontained engine failure followed by a successful force landing. This incident is being investigated by the South Africa Civil Aviation Authority (CAA)…NTSB CEN15WA143Accident · 1 fatalForeign investigationJudr Zdenek Prazdny Rotorway · Bohušovice nad Ohrí, CzechiaNTSB CEN15WA453Accident · Minor injuriesForeign investigationMooney M20F · Avignon, FranceOn February 8, 2015, about 0845 UTC, a Mooney M20F, French registration F-BOLV, owned and operated by Chateau Avia Aero Club and piloted by a private individual, was substantially damaged when the landing gear collapsed during landing at the Avignon-Provence…NTSB ERA15WA131Accident · 1 fatalForeign investigationCessna A188 · Tapes, BrazilOn February 7, 2015, about 1100 universal coordinated time, a Cessna A188, Brazilian registration PT-LOA, was destroyed when it struck a high-tension powerline and impacted terrain while maneuvering over a soybean field near Tapes, Brazil. The pilot was…NTSB CEN15WA142Incident · No injuriesForeign investigationRobinson R66 · Bern, SwitzerlandThis is preliminary information, subject to change, and may contain errors. On February 7, 2015, between 1300-1400 UTC, a Robinson R66 helicopter, HB-ZOK, (s/n 0553) experienced a loss of engine power during recovery from an autorotation on a training flight.…NTSB CEN15WA162Accident · No injuriesForeign investigationHughes 269A · Oresten, SwedenNTSB DCA15RA059Accident · 43 fatalForeign investigationATR 72 · Taipei, TaiwanimportNTSB CEN15WA133Accident · 1 fatalForeign investigationPiper PA 46 350P · Meyrin, SwitzerlandNTSB DCA15WA054Accident · 3 fatalForeign investigationHal Dhruv · Tena, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an accident involving an Ecuadorian Air Force Hal Dhruv helicopter, which occurred on January 27, 2015. The NTSB has appointed a U.S Accredited Representative to assist. All investigative…NTSB ERA15WA119Accident · No injuriesForeign investigationNew Piper PA46 350P · Milan, ItalyOn January 26, 2015, at 1057 Coordinated Universal Time (UTC), a Piper PA-46-250P, N369ST, was substantially damaged when the landing gear collapsed during landing at Milano Linate Airport (LIML), Milan, Italy. The pilot, copilot, and two passengers were not…NTSB CEN15WA124Accident · 1 fatalForeign investigationPiper PA-30 · Rockenhausen, GermanyOn January 26, 2015, about 1032 coordinated universal time, a Piper PA-30 airplane, D-GHFW, crashed under unknown circumstances near Rockenhausen, Germany. The airplane was substantially damaged, and the pilot fatally injured. The airplane departed Annemasse…NTSB ENG15RA012Accident · No injuriesForeign investigationRobinson R44 - II · Waikaia, New ZealandOn January 23, 2015, a Robinson R44 II experienced a severe in-flight vibration, after which the pilot successfully landed the helicopter. A subsequent inspection found a crack on one of the main rotor blades. This incident is being investigated by the New…NTSB ENG15RA006Incident · No injuriesForeign investigationBoeing 787-8 · Budapest, HungaryOn January 22, 2015, about 1700 local (1600 UTC), an Air India Boeing 787-8, VT-ANL, experienced a failure of the right engine, a General Electric GEnx-1B, while in cruise flight and diverted to Budapest, Hungary. The airplane was enroute from London Heathrow…NTSB ERA15WA105Accident · No injuriesForeign investigationRobinson R66 · Tashanta, RussiaOn January 20, 2015, at an undetermined time, a Robinson Helicopter R66, Russian registration RA-06205, was substantially damaged during a forced landing near Tashanta, Russia. The pilot and two passengers were not injured. The flight originated in…NTSB CEN15WA148Accident · 2 fatalForeign investigationPiper PA-24-260 · Rechberghausen, GermanyOn January 18, 2015, about 1455 coordinated universal time, a Piper PA-24-260 airplane, German registration D-EERZ, collided with a house near Rechberghausen, Germany. The pilot and passenger were both fatally injured. The airplane was destroyed. The accident…NTSB CEN15WA120Accident · Minor injuriesForeign investigationBell 206 - L1 · Santa Catarina Ixtahuacan, GuatemalaOn January 17, 2015, about 1545 coordinated universal time (UTC), a Bell 206L-1 helicopter, TG-GOL, was destroyed after impacting terrain near Santa Catarina Ixtahuacán, Sololá, Guatemala. The pilot and three passengers received minor injuries. The accident…NTSB ERA15WA108Accident · 1 fatalForeign investigationCessna A188B · Baixa Grande do Ribeiro, BrazilOn January 14, 2015, about 1050 universal coordinated time, a Cessna A188B, Brazilian registration PT-FFH, was substantially damaged when it collided with a utility pole during an aerial application flight near Baixa Grande do Ribeiro, Brazil. The foreign…NTSB CEN15WA110Incident · No injuriesForeign investigationGulfstream G200 · Luton, United Kingdom, United KingdomOn January 14, 2015, about 2127 universal time (UTC), a Spanish registered Gulfstream G200, EC-KRN, sustained minor damage during landing at London Luton Airport, Luton, United Kingdom. The pilot, copilot, and six passengers were not injured. The four main…NTSB DCA15WA094Incident · No injuriesForeign investigationGulfstream GV - SP G550 · Hong Kong, Hong Kong SAR ChinaThe Civil Aviation Department (CAD) of Hong Kong has notified the NTSB of an incident involving a GULFSTREAM GV-SP G550 that occurred on January 13, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the CAD of Hong Kong's investigation…NTSB DCA15WA074Incident · No injuriesForeign investigationBoeing 747 - 406 · Novosibirisk, RussiaThe Republic of South Korea Aviation and Railway Accident Investigation Board (ARAIB) has notified the NTSB of an incident involving a BOEING 747 that occurred on January 13, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB in…NTSB DCA15WA053Accident · Minor injuriesForeign investigationHal Dhruv · Guayaquil, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an accident involving a HAL Dhruvhelicopter, which occurred on January 13, 2015. The NTSB has appointed a U.S Accredited Representative to assist.All investigative information will be released…NTSB ERA15WA112Accident · 2 fatalForeign investigationEmbraer EMB-710C · Luziania, BrazilOn January 10, 2015, about 2105 universal coordinated time, an Embraer EMB-710C, Brazilian registration PT-NAB, was substantially damaged when it impacted a residence, after experiencing a loss of engine power during the initial climb after takeoff from the…NTSB ERA15WA104Accident · 1 fatalForeign investigationRobinson R44 - II · Santa Monica, BrazilOn January 10, 2015, about 2000 universal coordinated time, a Robinson R44 II, Brazilian registration PR-HPR, was destroyed by impact and fire after collision with wires and terrain during cruise flight in Santa Monica, Parana, Brazil. There was a post-crash…NTSB DCA15WA049Accident · Minor injuriesForeign investigationBoeing 737 · Accra, GhanaNTSB ENG15RA030Accident · No injuriesForeign investigationPac 750XL - NO Series · Taupo, New Zealand, New ZealandOn 7 January 2015, a Pacific Aerospace Limited 750XL airplane, registration No. ZK-SDT, while performing commercial skydiving operations, experienced an engine failure while climbing through approximately 3000 feet, after take-off from Taupo Aerodrome in the…NTSB CEN15WA145Accident · 2 fatalForeign investigationPioneer 400 · Blackwood Forest, Hampshire, U.K., United KingdomOn January 3, 2015, about 1530 UTC, a Pioneer 400 airplane, G-CVGO (s/n LAA 364-15006) impacted terrain near Blackwood Forest, Hampshire. Two persons on board were fatally injured and one was seriously injured. The airplane was destroyed. This investigation…NTSB CEN15WA455Accident · Serious injuriesForeign investigationRans S6 · Beja, PortugalOn January 1, 2015, about 1700 local time, a Rans S-6 Coyote II, Portuguese registration CS-UJF, impacted terrain after departure from the Beja Civil Aerodrome (LPBE), Beja, Portugal. The pilot and passenger were seriously injured and the airplane was…NTSB DCA15WA212Incident · No injuriesForeign investigationBoeing 737 · Lahore, PakistanThe Pakistan Civil Aviation Authority (PCAA) has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on December 30, 2014. The NTSB has appointed a U.S. Accredited Representative to assist PCAA's investigation under the provisions…NTSB WPR15WA075Accident · 2 fatalForeign investigationCessna 172 - S · Port Arthur, Australia, AustraliaOn December 29, 2014, at 1747 local, a Cessna 172S, VH-PFT, collided with water near Port Arthur, Australia during an aerial photography flight. The airplane was operating under the pertinent civil regulations of the government of Australia. The airplane was…NTSB DCA15WA046Accident · 162 fatalForeign investigationAirbus A320 - 216 · Pangkalan Bun, IndonesiaThe National Transportation Safety Committee (NTSC) of Indonesia, has notified the NTSB of an accident involving an Airbus A320-216 that occurred on December 28, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation…NTSB ERA15WA098Accident · 5 fatalForeign investigationAerospatiale AS350B · Bertioga, BrazilOn December 27, 2014, about 1240 UTC, an Aerospatiale AS350B, Brazil registration PT-HNC, collided with trees near Rio-Santos, Bertioga, Brazil. The pilot and 4 passengers were fatally injured, and the helicopter was destroyed. The helicopter was registered…NTSB ENG15WA019Incident · No injuriesForeign investigationAirbus A330 - 201 · Athens, Greece, GreeceOn 12/26/2014 an Airbus A330 operated by XL Airways took off from La Réunion (Indian Ocean) to Marseille (France). The information provided by the three inertial reference systems became successively unavailable, leading autopilot + auto-thrust to disconnect,…NTSB ERA15WA082Accident · 7 fatalForeign investigationCessna T207 - A · Piedecuesta, ColombiaOn December 24, 2014, about 1950 UTC, a Cessna T207A, HK4892, collided with mountainous terrain near Vereda Cabreras, Punto el Guanabanazo, Pescadero Piedecuesta, Santander, Colombia. The commercial pilot and six passengers were fatally injured. The airplane…NTSB CEN15WA096Accident · No injuriesForeign investigationPiper PA-32-260 · Lorrha, Tipperary, Ireland, IrelandOn December 24, 2014, at 1410 universal coordinated time (UTC), a Piper PA-32-260, United Kingdom registration G-OCTI, sustained substantial damage during an forced landing near Lorrha, Tipperary, Ireland, after experiencing an engine failure. There were no…NTSB ERA15LA091Accident · Minor injuriesLimited investigationFinal reportCessna 172M · South Bimini, BahamasThe total loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation, which resulted in a subsequent ditching in the ocean.