NTSB investigations, 2010, Outside the U.S.
12 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\") = 2010
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") = 2010 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 ERA11WA098Accident · 1 fatalForeign investigationBell 206 · Aracuju, BrazilOn December 21, 2010, about 1300 universal coordinated time, a Bell 206B, Brazilian registration PR-HQB, during an approach for landing; encountered a strong wind gust, impacted the terrain, and was substantially damaged in Aracaju, Segripe, Brazil. The pilot…NTSB ERA11WA075Accident · 1 fatalForeign investigationPiper PA-25 · Tapurah City, BrazilOn November 18, 2010, about 1700 Universal Coordinated Time (UTC), a Piper PA-25-235, Brazilian registration PT-WOP, operated by Aeroagricola Boa Safra Ltda, lost control and crashed into trees during an agricultural flight at the Marape Farm, Tapurah City,…NTSB ERA11WA008Accident · 9 fatalForeign investigationCessna 402 · Nassau, BahamasOn October 5, 2010, about 1236 Atlantic standard time, a Cessna 402C, Bahamian registration C6-NLH, registered to and operated by Lebocruise Air Limited, crashed into Lake Killarney shortly after takeoff from the Lynden Pindling International Airport (MYNN),…NTSB CEN10RA319Accident · 9 fatalForeign investigationCessna 208 · Felipe Carrillo Puerto, MexicoOn June 13, 2010, approximately 1800 central daylight time, a Cessna 208B, XA-TWK, was substantially damaged upon impact with terrain following a loss of control during the initial climb from the Felipe Carrillo Puerto airstrip, Felipe Carrillo Puerto,…NTSB CEN10WA150Accident · 3 fatalForeign investigationCessna 421 · Tegucigalpa, HondurasThis investigation is under the jurisdiction and control of the Honduran government.NTSB CEN10WA148Accident · 2 fatalForeign investigationAlon Aircoupe A2-A · Ciborro, Montemor-o-Novo, PortugalThis accident is under the jurisdiction and control of the Portuguese government.NTSB CEN10WA134Accident · 2 fatalForeign investigationCessna 150 · Waldzell, AustriaThis accident is under the jurisdiction and control of the Austrian government.NTSB CEN10WA121Accident · 2 fatalForeign investigationCessna 550B · Reinhardtsdorf-Schöna, GermanyThis investigation is under the jurisdiction and control of the German Government.NTSB CEN10WA309Accident · 4 fatalForeign investigationRobinson Helicopter R44 · Horten, Norway, NorwayOn January 27, 2010, at 1323 coordinated universal time (UTC), a Robinson Helicopter Company model R44, s/n 0024, Norwegian registration LN-OCV, was substantially damaged when it impacted Oslofjord, near Horten, Norway. The pilot and 3 passengers were fatally…NTSB DCA10RA023Accident · 90 fatalForeign investigationBoeing 737 · Beirut, LebanonOn January 25, 2010, about 0041 UTC, Ethiopian Airlines flight 409, Boeing 737-800, ET-ANB, crashed into the Mediterranean Sea shortly after takeoff from Beirut-Rafic Hairiri International Airport, Beirut, Lebanon. Night instrument meteorological conditions…NTSB ERA10WA116Accident · 3 fatalForeign investigationPiper PA-32-300 · Bimini, Bahamas, BahamasOn January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…NTSB CEN10WA096Accident · 2 fatalForeign investigationPiper PA-31P · Kidlington, United Kingdom