NTSB investigations, Outside the U.S.
63 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 8 |
| 2011 | 8 |
| 2012 | 5 |
| 2013 | 4 |
| 2014 | 5 |
| 2017 | 1 |
| 2021 | 6 |
| 2022 | 4 |
| 2023 | 8 |
| 2024 | 2 |
| 2025 | 6 |
| 2026 | 3 |
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 c.\"eventCountry\" <> 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' 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" = '440' 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 GAA27WA005Accident · No injuriesClass 5 · ForeignCessna R172 · Tarija, BoliviaNTSB GAA26WA121Accident · No injuriesClass 5 · ForeignCessna 172 · Barreirinhas, BrazilNTSB GAA26WA079Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Barreiras, BrazilNTSB GAA26WA031Accident · No injuriesClass 5 · ForeignBell 206 · Uruyen, VenezuelaNTSB GAA26WA053Accident · No injuriesClass 5 · ForeignCessna 172 · Uljin, South KoreaNTSB GAA26WA018Accident · No injuriesClass 5 · ForeignRobinson R22 · Colombo, BrazilNTSB GAA25WA177Accident · No injuriesClass 5 · ForeignCessna U206 · Santa Elena de Uairén, VenezuelaNTSB GAA25WA162Accident · Minor injuriesClass 5 · ForeignCessna 150 · Ucharpi, IndiaNTSB GAA25WA074Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Paracatu, BrazilNTSB GAA24WA135Accident · No injuriesClass 5 · ForeignCessna 152 · Balneario Laguna de Gómez, ArgentinaNTSB GAA24WA146AccidentClass 5 · ForeignCessna 182 · Manuel Urbano, BrazilNTSB GAA24WA053AccidentClass 5 · ForeignAir Tractor AT301 · Orihueca, ColombiaNTSB GAA24WA001Accident · No injuriesClass 3 · ForeignRobinson R44 · Vamdrup, DenmarkNTSB GAA24WA007Accident · No injuriesClass 5 · ForeignCessna 210 · Campo Grande, BrazilNTSB GAA23WA251Accident · No injuriesClass 5 · ForeignRobinson R44 · Manta, EcuadorNTSB GAA23WA176Accident · Minor injuriesClass 5 · ForeignCessna 182 · Jelenia Góra, PolandNTSB GAA23WA166Accident · No injuriesClass 5 · ForeignBeech A36 · Teresina, Pi, BrazilNTSB GAA23WA160Accident · No injuriesClass 5 · ForeignPiper PA-34-220T · São Pedro da Água Branca,, BrazilNTSB GAA23WA102Accident · Serious injuriesClass 5 · ForeignQuicksilver GT500 · Flaminio Suárez, ColombiaNTSB GAA22WA281AccidentClass 5 · ForeignCessna A188B · Santa Helena de Goias, BrazilNTSB GAA22WA214Accident · No injuriesClass 5 · ForeignCessna 182P · Benevides, BrazilNTSB GAA22WA215Accident · Minor injuriesClass 4 · ForeignRobinson R44 · Rio das Ostras, BrazilNTSB GAA22WA108Accident · Minor injuriesClass 5 · ForeignPiper PA23 · Treasure Cay, BahamasNTSB GAA21WA198Accident · No injuriesClass 5 · ForeignCessna 182 · Tannheim, GermanyNTSB GAA21WA077Accident · No injuriesClass 5 · ForeignAir Tractor AT301 · Vereda La Pedrera, ColombiaNTSB GAA21WA057AccidentClass 5 · ForeignPartenavia P68 · Bhopal, IndiaNTSB GAA21WA056Accident · 2 fatalClass 5 · ForeignCessna 208 · Ndetani, KenyaNTSB GAA21WA070Accident · Serious injuriesClass 3 · ForeignBell 212 · Región del Libertador Bernardo O´Higgins, ChileNTSB WPR21WA090Accident · Serious injuriesClass 5 · ForeignCessna 210 · Chibuya, ZimbabweNTSB ERA18WA047Accident · 1 fatalClass 5 · ForeignCessna T210 · West End, BahamasNTSB ERA14WA393Accident · 4 fatalForeign investigationCessna 340A · Freeport, BahamasNTSB CEN14WA394Accident · No injuriesForeign investigationMD Helicopter 600N · Kungsangen, SwedenOn July 14, 2014, at 1333 coordinated universal time, an MD Helicopters MD600N, SE-JKJ, was substantially damaged following an autorotation near Kungsängen, Stockholm, Sweden. The pilot was not injured. Visual meteorological conditions prevailed for the…NTSB CEN14WA332Accident · No injuriesForeign investigationCessna U206 · Abbeyshrule, IrelandOn June 21, 2014, about 1115 hours universal coordinated time, a Cessna model U206 Turbo Stationair, United Kingdom registration G-SKYE, was substantially damaged during a forced landing following a loss of engine power after takeoff from the Abbeyshrule…NTSB ERA14WA245Accident · Minor injuriesForeign investigationCessna T188C · Canton Naranjal, EcuadorOn March 13, 2014, a Cessna T188C, Ecuadorian registration HC-BTA, was substantially damaged when it lost engine power and impacted terrain near Canton Naranjal, Ecuador. A postaccident fire ensued. The foreign certificated pilot received minor injuries. The…NTSB ERA14WA090Incident · No injuriesForeign investigationPiper PA-32RT-300T · Margarita, VenezuelaOn January 5, 2014, about 1900 universal coordinated time, a Piper PA-32RT-300T, Venezuelan registration YV2070, operated by a private individual, made an emergency landing on a road due a total loss of engine power. The pilot was not injured. The flight…NTSB ERA14WA041Accident · 4 fatalForeign investigationCirrus Design SR22 · Freeport, BahamasNTSB CEN13WA576Accident · No injuriesForeign investigationSocata TB10 - NO Series · Zamora, SpainOn August 9, 2013, about 0930 UTC, a Socata TB-10 airplane, EC-FPN, (s/n 1485) was involved in a forced landing following an engine failure. The airplane was substantially damaged and there were no injuries. This investigation is under the jurisdiction and…NTSB CEN13WA477Accident · Minor injuriesForeign investigationBeech 100 · Saint-Mathieu-de-Beloeil, CanadaOn June 10, 2013, at 1726 eastern daylight time, a Beech model 100 (King Air 100), Canadian registration C-GJSU, serial number B-88, experienced a dual loss of engine power and collided with terrain about 1/2 mile west of St-Mathieu-De-Beloeil Airport (CSB3),…NTSB ERA13WA226Accident · 2 fatalForeign investigationCessna 210L · Belem, BrazilOn April 26, 2013, about 1215 universal coordinated time, a Cessna 210L, Brazilian registration PR-LJI, operated by Brabo Taxi Aereo Ltda., was substantially damaged during a forced landing while on approach to the Brigadeiro Protasio de Oliveira Airport…NTSB ERA13WA050Accident · Serious injuriesForeign investigationCessna 206 · Kiim, EcuadorOn October 31, 2012, about 1545 coordinated universal time (1045 local time), a Cessna 206, Ecuadorian registration HC-CBG, was substantially damaged during a forced landing in Kiim, Ecuador. The Ecuadorian commercial pilot was seriously injured. The airplane…NTSB ERA13WA085Accident · No injuriesForeign investigationThrush S2R-T34 · Naranjal, EcuadorOn October 2, 2012, a Thrush S2R-T34, Ecuadorian registration HC-CFU, operated by a private owner, was substantially damaged following an engine failure and collision with terrain near Naranjal Province, Guayas, Ecuador. The flight's last departure point and…NTSB ERA12WA451Accident · 1 fatalForeign investigationEmbraer EMB820 · Espinosa Municipality, BrazilOn July 6, 2012, at 1340 Universal Coordinated Time (UTC), a Piper PA-31-350 (Embraer 820C), Brazilian registration PT-ENG, operated by Microsurvev Aerogeof. E Cons. Cient. Ltda, was destroyed during a forced landing following a loss of power to both engines.…NTSB ERA12WA504Accident · Minor injuriesForeign investigationPiper PA-28-235 · Tartu, EstoniaOn May 4, 2012, about 2055 universal coordinated time, a Piper PA-28-235, Latvian registration YL-MED, was substantially damaged when it impacted a ditch, during a forced landing at night after a loss of power near Tartu Ulenurme Airport (EETU), Tartu,…NTSB CEN13WA102Incident · No injuriesForeign investigationRobinson Helicopter R44 · Oosterschelde, NetherlandsOn January 21, 2012, at 1430 universal coordinated time, a Robinson Helicopter Company model R44, Dutch registration PH-WMW, made an uneventful forced landing after experiencing a partial loss of engine power near Oosterschelde, The Netherlands. The pilot and…NTSB ERA12LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA 46-350P · Caribbean Sea, A1The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…NTSB ERA12WA136Accident · No injuriesForeign investigationPiper PA36 · Machala, EcuadorOn November 23, 2011, about 2000 coordinated universal time, a Piper PA-36-300, Ecuadorian registration HC-BHJ, operated by Aerorient Fumigacion Aerea, was substantially damaged when the pilot made a forced landing following loss of engine power in a banana…NTSB ERA12WA092Accident · No injuriesForeign investigationPiper PA-25 · Meteropolitana, ChileOn November 11, 2011, at 1345 UTC, a Piper PA-25-260, Chilean registration CC-ABM, registered to and operated by Sociedad De Ttrabajos Aeros Aeropacifico LTDA as a personal flight experienced a partial loss of engine power on initial takeoff climb, in the…NTSB WPR11WA488Accident · No injuriesForeign investigationEurocopter BO105 · Tari, Papua New GuineaOn July 7, 2011, about 1200 local time, a Eurocopter BO-105C, Papua New Guinea registry P2-LAE, sustained an uncontained engine failure in one of its Rolls-Ropyce 250-C20B engines. A fire consumed the helicopter following a forced landing. The helicopter was…NTSB CEN11WA412Accident · Serious injuriesForeign investigationMcDonnell Douglas Helicopter 369E · Glastonbury, United KingdomOn June 19, 2011, at 1420 universal coordinated time (UTC), a McDonnell Douglas Helicopter Company model 369E, United Kingdom registration G-KSWI, s/n 0204E, was substantially damaged during an emergency landing after experiencing a mechanical failure of the…NTSB ERA11WA268Accident · Minor injuriesForeign investigationGrumman G164 · Volgodonsk, RussiaOn April 20, 2011, about 1010 Universal Coordinated Time (UTC), a Grumman G-164A Agcat, Russian registration RA-1398G, operated by a private individual, was substantially damaged during a forced landing following a loss of engine power near Volgodonsk, Rostov…