NTSB investigations, 2017, Outside the U.S.
31 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 13 |
| 2010 | 12 |
| 2011 | 11 |
| 2012 | 18 |
| 2013 | 26 |
| 2014 | 25 |
| 2015 | 36 |
| 2016 | 38 |
| 2017 | 31 |
| 2018 | 35 |
| 2019 | 64 |
| 2020 | 38 |
| 2021 | 35 |
| 2022 | 45 |
| 2023 | 35 |
| 2024 | 23 |
| 2025 | 30 |
| 2026 | 5 |
Latest cases
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 year(c.\"eventDate\") = 2017
AND 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 year(c."eventDate") = 2017 AND 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 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…