NTSB investigations, 2011, Outside the U.S.
12 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\") = 2011
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") = 2011 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 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 ERA12WA102Accident · 1 fatalForeign investigationCessna 210 · Alto Alegre, BrazilOn November 22, 2011, at 1740 universal time coordinated, a Cessna Aircraft, Model 210L, Brazilian registration PT-IOT, impacted the ground after reporting an engine failure near Aldeia Hali Katu, in the Alto Alegre Municipality, Roraima, Brazil. The airplane…NTSB WPR12WA186Accident · No injuriesForeign investigationPiper PA-34-220T · Karachi, PakistanOn October 20, 2011, at 1138 local time, a Piper PA-34-220T, Pakistan registry AP-BDK, was substantially damaged during a forced landing following a dual engine failure while in cruise flight. The aircraft was operated by M/S Schon Air Limited of Karachi,…NTSB CEN12WA033Accident · 2 fatalForeign investigationDiamond DA20 · Amurrio, SpainOn October 14, 2011, at 1040 universal coordinated time, a Diamond DA20-C1 airplane, EC-KDS, sustained substantial damage when it impacted terrain near Amurrio, Spain. The two crewmembers sustained fatal injuries. The accident investigation is under the…NTSB CEN11WA690Accident · No injuriesForeign investigationPiper PA 28 · Montpellier, FranceOn September 16, 2011, a Piper PA 28, French resistered F-HMAT, was substantially damaged during a forced landing following a loss of engine power near Montpellier, France. Visual meteorological conditions prevailed at the time of the accident. No one was…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…NTSB ERA11WA252Incident · No injuriesForeign investigationReims-Cessna F-150 · Sotttomarina di Chioggia, ItalyOn March 25, 2011, about 1200 universal coordinated time, a Reims-Cessna F-150 airplane, Italian registration I-NOLV, had a reported engine failure while in cruise flight. The pilot decided to land on the shoreline in the vicinity of Sottomarina di Chioggia,…NTSB ERA11WA220Incident · No injuriesForeign investigationBeech B200 · Vichada, ColombiaOn March 6, 2011, about 2140 Universal Coordinated Time (UTC), a Beech BE-200, Columbian registration HK-4108, operated by Servicio Aereo de Capurgana (SEARCA S.A.), was substantially damaged during landing at Vichada, Columbia, following loss of engine…NTSB ERA11WA362Accident · Minor injuriesForeign investigationCessna 152 · Kingston, JamaicaOn March 4, 2011, about 1000 eastern standard time, a Cessna 152, Jamaican registration 6Y-JGA, was substantially damaged during a forced landing, following a total loss of engine power during initial climb from Norman Manley International Airport (MKJP),…NTSB ERA11WA164Accident · No injuriesForeign investigationCessna 208B · Rio Branco, BrazilOn January 21, 2011, about 1735 Universal Coordinated Time (UTC), a Cessna 208B, Brazilian registration PR-RMI, operated by Carlos Madeira Aerotaxi Ltda, had an engine failure during a go-around, and made a forced landing near the Rio Branco International…NTSB ERA11WA120Accident · No injuriesForeign investigationBell 206B III · Ocho Rios, JamaicaOn January 14, 2011, about 1600 eastern standard time, a Bell 206B III, Jamaican registration 6Y-JCA, operated by Captain's Aviation Services Limited, was substantially damaged during a forced landing in Ocho Rios, Jamaica. The pilot and two passengers were…