NTSB investigations, 2010, Outside the U.S.

10 cases where the defining event was Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2010, Outside the U.S. per year, 2008–2026: 504 cases
20085
200912
201010
201110
201218
201325
201422
201535
201637
201730
201833
201963
202037
202134
202243
202334
202422
202529
20265

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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240')
  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.

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…Dec 21, 2010 · PR-HQB · Substantial damageNTSB 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,…Nov 18, 2010 · PT-WOP · DestroyedNTSB 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),…Oct 5, 2010 · C6NLH · Substantial damageNTSB 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,…Jun 13, 2010 · XA-TWK · Substantial damageNTSB CEN10WA148Accident · 2 fatalForeign investigationAlon Aircoupe A2-A · Ciborro, Montemor-o-Novo, PortugalThis accident is under the jurisdiction and control of the Portuguese government.Mar 6, 2010 · CS-AIG · DestroyedNTSB CEN10WA134Accident · 2 fatalForeign investigationCessna 150 · Waldzell, AustriaThis accident is under the jurisdiction and control of the Austrian government.Feb 28, 2010 · OE-CFT · Substantial damageNTSB CEN10WA121Accident · 2 fatalForeign investigationCessna 550B · Reinhardtsdorf-Schöna, GermanyThis investigation is under the jurisdiction and control of the German Government.Feb 14, 2010 · OK-ACH · DestroyedNTSB 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…Jan 27, 2010 · LN-OCV · Substantial damageNTSB 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…Jan 25, 2010 · ET-ANB · DestroyedNTSB CEN10WA096Accident · 2 fatalForeign investigationPiper PA-31P · Kidlington, United KingdomJan 15, 2010 · N95RS · Destroyed