NTSB investigations, Outside the U.S.
525 cases where the sequence of events included Loss of control in flight.
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'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN18WA169Accident · 2 fatalForeign investigationCessna 208B · Clonbullogue, IrelandNTSB ERA18WA153Accident · 1 fatalClass 5 · ForeignBell Helicopter 206 · Barra da Tijuca, BrazilNTSB ERA18WA133Accident · 1 fatalForeign investigationBell 206L-4 · Vereda Plateado, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BELL 206L-4 helicopter that occurred on April 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…NTSB CEN18WA130Accident · 2 fatalForeign investigationMaule M 7-235 · Arosa, SwitzerlandNTSB ERA18WA100Accident · 1 fatalForeign investigationBeech V35B · Brasilandia, Mato Grosso do Sul, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech V35B airplane that occurred on February 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA18WA090Accident · 4 fatalForeign investigationNeiva EMB-720D · Manaus City, BrazilThe government of Brazil has notified the NTSB of an accident involving a NEIVA EMB-720D airplane that occurred on February 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…NTSB CEN18WA096Accident · 2 fatalForeign investigationPiper PA-28-161 · Helle, NorwayOn February 11, 2018, about 2000 UTC, a Piper Aircraft, Inc. PA-28-161 airplane, Norwegian registration LN-TOS, impacted the waters near the Svolvaer Airport (ENSH), Helle, Norway. The pilot and passenger on board were fatally injured and the airplane was…NTSB ERA18WA081Accident · 2 fatalForeign investigationReims F150L · Abrizzano di Negrar, ItalyThe government of Italy has notified the NTSB of an accident involving a Reims Aviation F150L airplane that occurred on January 31, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…NTSB CEN18WA091Accident · 1 fatalForeign investigationPiper PA25 · Mocorito, MexicoOn January 26, 2018, at 1930 UTC, a Piper PA25-150, XB-FBN, impacted terrain under unknown circumstances in the Community el Recoveco in Mocorito, Mexico. The aircraft was destroyed, and the pilot was fatally injured. The flight had departed airdrome "El…NTSB ERA18WA063Accident · 6 fatalForeign investigationPiper PA-23-250 · Nicholls Town, BahamasThe government of Bahamas has notified the NTSB of an accident involving a PIPER PA 23-250 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…NTSB WPR18WA060Accident · 6 fatalForeign investigationDe Havilland DHC2 · Cottage Point, AustraliaOn December 31, 2017, at 1515 local time, a De Havilland DHC-2, VH-NOO, collided with water during takeoff initial climb near Cottage Point, Australia. The airplane was destroyed and the pilot and five passengers were fatally injured. The flight was operated…NTSB CEN18FA063Accident · 12 fatalField investigationFinal reportCessna 208 · Punta Islita, Costa RicaThe flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…NTSB WPR18WA054Accident · Serious injuriesForeign investigationBell UH1H · Bredasdorp, South AfricaOn December 21, 2017, about 1105 Coordinated Universal time, a Bell UH-1H helicopter, ZS-HLI, was substantially damaged when it impacted terrain shortly after liftoff from Bredasdorp fire station, Western Cape Province, South Africa. The helicopter was…NTSB ERA18WA160Accident · 1 fatalForeign investigationPiper PA-25-235 · Itapolis, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER AIRCRAFT PA-25-235 airplane that occurred on November 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…NTSB ANC18WA076Accident · 2 fatalForeign investigationPiper PA34 · Calgary Springbank, CanadaOn October 26, 2017, about 0952 mountain daylight time, a Piper PA-34-200T airplane, C-GCCM, departed controlled flight and impacted terrain shortly after takeoff from Calgary Springbank Airport (CYBW), Alberta, Canada. The flight instructor and pilot…NTSB ERA18WA029Accident · 1 fatalForeign investigationCessna A188 · Sao Felix do Xingu, BrazilThe government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on October 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA18WA017Accident · 5 fatalForeign investigationCessna 210 · Itaituba, BrazilOn October 22, 2017, about 2105 universal coordinated time, a Cessna 210N, Brazilian registration PT-ORU, operated by a private individual, was destroyed when it collided with terrain following a low altitude maneuver near Itaituba, Brazil. The two foreign…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 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 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 CEN17WA353Accident · 2 fatalForeign investigationMooney M 20K · Braunwald, SwitzerlandNTSB CEN17RA337Accident · 2 fatalForeign investigationCessna U206 · San Jose, Costa RicaimportNTSB 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 CEN17WA325Accident · 2 fatalForeign investigationAviat Pitts S-2B · Holmestrand, NorwayOn August 22, 2017, at 1025 hours universal coordinated time, an Aviat Pitts S-2B, Norwegian registration LN-PTS, impacted the terrain following a loss of control while performing aerobatic maneuvers near Holmestrand, Norway. The pilot and passenger were…NTSB ERA17WA289Accident · 5 fatalForeign investigationLearjet 25 · Naiguata, VenezuelaOn August 19, 2017, about 0415 universal coordinated time, a Learjet 25D, Venezuelan registration YV3191, descended and impacted the ocean about 5 nautical miles north of Naiguatá, Vargas, Venezuela. The two pilots and three passengers were fatally injured.…NTSB CEN17WA320Accident · 1 fatalForeign investigationPiper PA36 · Vejer de la Frontera, SpainOn August 15, 2017, a Piper PA-36-375 airplane (EC-EHB, s/n 36-8102001) impacted terrain during fumigation operations in the vicinity of Vejer de la Frontera, Spain. The pilot was fatally injured.This investigation is under the jurisdiction and control of the…NTSB ERA17WA291Accident · 3 fatalForeign investigationMitsubishi MU2B · San Fernando, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a MITSUBISHI MU2B airplane that occurred on July 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…NTSB ERA17WA228Accident · 1 fatalForeign investigationBell 206 · Republic of Buryatia, RussiaThe government of Russia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on July 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of…NTSB CEN17WA243Accident · 2 fatalForeign investigationPiper L4 · Liberecký, CzechiaOn June 25, 2017, at 1200 Coordinated Universal Time, a Piper L4, OM-M038, impacted terrain after takeoff from Hodkovice Airport (LKHD), Liberecký, Czech Republic. The airplane was destroyed. The pilot sustained serious injuries, and the passenger sustained…NTSB CEN17WA237Accident · 1 fatalForeign investigationAmateur Construction Kolb Firefly · Luffenhall, United KingdomOn June 20, 2017, about 0920 Coordinated Universal Time (UTC), a Kolb Firefly ultralite, British registration G-CEPN, impacted terrain under unknown circumstances near Newell Lane, Luffenhall, Hertfordshire, England. The pilot, the sole occupant on board, was…NTSB CEN17WA211Accident · 2 fatalForeign investigationLake LA-4-200 · Muskoka, Ontario, CanadaOn June 2, 2017, at 2113 coordinated universal time, a Lake LA-4-200 Buccaneer, C-GZSW, was destroyed on impact with terrain after takeoff from Muskoka Airport (CYQA), Muskoka, Ontario, Canada. After takeoff, the pilot attempted to return to the airport, and…NTSB ERA17WA191Accident · 2 fatalForeign investigationRobinson R44 · Heilbron, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R44 II helicopter that occurred on May 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB ERA17FA181Accident · 4 fatalField investigationFinal reportMitsubishi MU2B · Eleuthera, BahamasThe pilot's intentional flight into an area of known icing and convective thunderstorm activity, which resulted in a loss of control of the airplane.NTSB ERA17WA179Accident · 2 fatalForeign investigationPiper PA30 · Sao Paulo, BrazilOn April 28, 2017, about 1930 coordinated universal time, a Piper PA30, Brazilian registration PT-CHT, was substantially damaged when it impacted terrain during an instructional flight near Sao Paulo, Brazil. The pilot and copilot were fatally injured. The…NTSB CEN17RA158Accident · 5 fatalForeign investigationPiper PA31T · Cascais, PortugalOn April 17, 2017, about 1104 hours universal coordinated time, a Piper PA-31T, serial number 31T-8020091, Swiss registration HB-LTI, was destroyed during impact and a postimpact fire following a loss of control during initial climb from runway 17 at the…NTSB CEN17WA161Accident · 1 fatalForeign investigationChampion 8KCAB · Cancun, MexicoThe accident investigation is under the jurisdiction and control of the Mexican government. This report is for informational purposes only and contains only information released by or obtained from the Mexican government. Further information pertaining to…NTSB ERA17WA142Accident · Serious injuriesForeign investigationQuest Kodiak · Moretecocha, EcuadorOn March 28, 2017, at 1600 Universal Coordinated Time (UTC), a Quest Kodiak 100, Ecuadorian registration HC-CRF, operated by Alas De Socorro, received substantial damage following a collision with trees and terrain during takeoff at Moretecocha Airstrip,…NTSB CEN17WA125Accident · Serious injuriesForeign investigationRobinson Helicopter Robinson R44 II · Carlingford, IrelandOn March 12, 2017, about 1715 coordinated universal time (UTC), a Robinson Helicopter Company Inc. R44 II helicopter, G-DORM, was destroyed when it impacted terrain during an approach to landing near Carlingford, County Louth, Ireland. The pilot and one…NTSB CEN17RA106Accident · 5 fatalForeign investigationRaytheon B200 · Melbourne, AustraliaOn February 20, 2017, at 2159 hours universal coordinated time (0859 hours Australian eastern daylight time on February 21, 2017), a Raytheon model B200 (King Air) airplane, Australian registration VH-ZCR, impacted a building and roadway shortly after takeoff…NTSB WPR17WA060Accident · 2 fatalForeign investigationGrumman American G-73 · Perth, AustraliaOn January 26, 2017, at 1708 local time, a Grumman American Aviation Corp. G-73, VH-CQA, collided with water while maneuvering near Perth, Australia. The airplane and the pilot and passenger were fatally injured. The flight was operated under the pertinent…NTSB ERA17WA086Accident · 2 fatalForeign investigationCessna 172 · Tangara da Serra, BrazilOn January 5, 2017, at 1420 universal time coordinated, a Cessna 172S airplane, Brazilian registration PR-GRS, sustained substantial damage when it struck high-tension power-lines while attempting to land at the Tangara da Serra Airport (TGQ), State of Mato…NTSB ERA17WA076Accident · 1 fatalForeign investigationAir Tractor AT802 · Santa Juana, ChileNTSB ERA17WA079Accident · 1 fatalForeign investigationAir Tractor AT502 · Primavera do Leste, BrazilOn December 13, 2016, about 1930 coordinated universal time, an Air Tractor AT-502B, Brazilian registration PR-AJF, was destroyed after it impacted terrain and was subject to a postcrash fire, during an agricultural spraying operation near Primavera do Leste,…NTSB CEN17WA051Accident · 1 fatalForeign investigationPiper PA-34-200T · Alsace, FranceOn December 7, 2016, at 1644 coordinated universal time, a Piper PA-34-200T airplane, Switzerland registration HB-LSD, was destroyed when it collided with the terrain near Alsace, France. The pilot was fatally injured. The airplane departed the Nurnberg…NTSB CEN17WA086Accident · 1 fatalForeign investigationMooney M20K · Saarbrucken, GermanyOn October 27, 2016, about 0946 UTC, a Mooney M20T, N400MW, owned and operated by a private individual, impacted on the runway at the Saarbrucken-Ensheim Airport (EDDR), Saarbrucken, Germany. The pilot on board was fatally injured and the airplane was…NTSB ANC17WA030Accident · 4 fatalForeign investigationCessna 500 · Kelowna, CanadaOn October 14, 2016, a Cessna C500 (Citation) departed Kelowna Airport (CYLW) at 0510 Universal Coordinated Time (UTC) for a flight to Calgary/Springbank Airport (CYBW), with a pilot and three passengers aboard. Shortly after departure, the aircraft…NTSB DCA17WA010Accident · No injuriesForeign investigationPiper PA28 · Jozini, South AfricaThe government of South Africa has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on October 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…NTSB CEN17WA008Accident · 1 fatalForeign investigationNorth American P-51D · East Anglia, United KingdomThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On October 2, 2016, at 1438 Coordinated Universal Time (UTC), a North American P-51D, British registration G-MSTG, impacted…NTSB CEN16WA384Accident · 2 fatalForeign investigationCessna 206 · Lake Kuashkuapishiu, CanadaOn September 25, 2016, a Cessna U206F airplane, C-FWBQ, collided with terrain after departing from Lake Kuashkuapishiu, Quebec. The pilot was seriously injured and two passengers were fatally injured. This investigation is under the jurisdiction and control…NTSB ERA16WA334Accident · 4 fatalForeign investigationBeech E55 · Campinapolis, BrazilOn September 22, 2016, about 2210 universal time coordinated, a Beech E55, Brazilian registration PR-DTA, was destroyed when it impacted terrain near Campinapolis, Brazil. The airplane departed the Santa Genoveva Airport (SBGO), Goiana, Brazil, and was…