NTSB investigations, 2013, Outside the U.S.
4 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 8 |
|---|---|
| 2009 | 1 |
| 2010 | 4 |
| 2011 | 2 |
| 2012 | 6 |
| 2013 | 4 |
| 2014 | 8 |
| 2015 | 7 |
| 2016 | 6 |
| 2017 | 9 |
| 2018 | 9 |
| 2019 | 20 |
| 2020 | 4 |
| 2021 | 28 |
| 2022 | 17 |
| 2023 | 27 |
| 2024 | 31 |
| 2025 | 33 |
| 2026 | 8 |
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\") = 2013
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\" = '342' 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") = 2013 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" = '342' 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 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 ERA13WA203Accident · 2 fatalClass 5 · ForeignPiper PA-23-250 · Georgetown, GuyanaOn April 13, 2013, about 1854 coordinated universal time, a Piper PA-23-250, N27FT, was destroyed when it impacted a residence shortly after departing from Ogle International Airport (SYGO), Georgetown, Guyana. The certificated airline transport pilot and one…NTSB ERA13WA304Accident · Minor injuriesForeign investigationEurocopter BO-105 · Granville, Cedros, Trinidad & TobagoOn March 26, 2013, about 1300 universal coordinated time, a Eurocopter BO-105 helicopter, Trinidad and Tobago registry 9Y-TIC, was substantially damaged during a forced landing to a forested area in Granville, Cedros, Trinidad and Tobago. The pilot sustained…NTSB ENG13WA014Incident · No injuriesForeign investigationMcdonnell Douglas MD-82 · Copenhagen, Denmark, DenmarkOn January 30, 2013 an MD-82, registration number SE-DIK, sustained a serious engine failure during the takeoff roll. The engine has been removed from the airplane and will undergo a teardown examination. The Danish Accident Investigation Board is…