NTSB investigations, 2014, Outside the U.S.
16 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 14 |
| 2010 | 8 |
| 2011 | 12 |
| 2012 | 8 |
| 2013 | 19 |
| 2014 | 16 |
| 2015 | 27 |
| 2016 | 31 |
| 2017 | 28 |
| 2018 | 26 |
| 2019 | 24 |
| 2020 | 20 |
| 2021 | 85 |
| 2022 | 49 |
| 2023 | 62 |
| 2024 | 59 |
| 2025 | 61 |
| 2026 | 24 |
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\") = 2014
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\" = '341' 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") = 2014 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" = '341' 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 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 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.NTSB ANC15WA017Accident · Minor injuriesForeign investigationCirrus Design SR20 · Ibusuki City, JapanOn October 12, 2014, about 0530 coordinated universal time, a US registered Cirrus SR-20 airplane, N176CD, experienced a total loss of engine power near Ibusuki City, Kagoshima Prefecture, Japan. The pilot made a emergency landing, and received minor…NTSB ERA15WA050Accident · No injuriesForeign investigationCessna A188B · Rozo, ColombiaNTSB DCA15WA042Incident · No injuriesForeign investigationBoeing 737-800 · Geneva, SwitzerlandThe Directorate General of Civil Aviation (DGCA) of the Republic of Turkey, has notified the NTSB of an incident involving a Boeing 737-800 that occurred on September 29, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DGCA…NTSB ERA14WA393Accident · 4 fatalForeign investigationCessna 340A · Freeport, BahamasNTSB 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 CEN14WA294Accident · No injuriesForeign investigationPiper J3C 65 · Rolleville, FranceNTSB CEN14WA176Accident · No injuriesForeign investigationCessna 205 - Undesignat · Albacete, SpainThis is preliminary information, subject to change, and may contain errors. The foreign authority was the source of this information. On March 22, 2014, about 1630 UTC, a Cessna 205 airplane, EC-GQB, (s/n 205-0277) was involved in a forced landing following…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 ERA14WA135Accident · 1 fatalForeign investigationCessna T210L · Araguaina, BrazilOn February 19, 2014, about 1920 universal coordinated time, a Cessna T210L, Brazilian registration PR-VPI, operated by Talla Taxi Aereo Ltda., was substantially damaged during a forced landing, after it experienced a loss of engine power during takeoff from…NTSB ERA14WA125Accident · 3 fatalForeign investigationCessna 210N · Palmas, BrazilOn February 9, 2014, about 1330 universal coordinated time, a Cessna 210N, Brazilian registration PT-OMX, operated by a private individual, was substantially damaged after it experienced a loss of engine power and impacted terrain while on approach to the…NTSB CEN14WA105Accident · No injuriesForeign investigationCirrus Design SR22 · Le Pin, FranceOn January 6, 2014, approximately 0700 coordinated universal time, a Cirrus SR22 airplane, F-HAPH, lost engine power, deployed the parachute system, and touched down near Le Pin, France. The pilot and passenger were not injured. The flight departed the…NTSB CEN14RA113Accident · Serious injuriesForeign investigationGippsland GA8 · Cayenne, French GuianaOn January 6, 2014, about 1508 local time, a Gippsland GA-8 Airvan, single engine airplane, F-ORPH, was destroyed during a forced landing following a total loss of engine power at Cayenne – Félix Eboué Airport (SOCA), Cayenne, French Guiana. The pilot…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…