# NTSB investigations, 2010, Outside the U.S.: Loss of engine power (partial)

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB DCA11WA008](https://openairdocs.org/ntsb/DCA11WA008.md): Beech 1900 · Karachi, Pakistan · Accident · 21 fatal · Foreign investigation · Nov 5, 2010 · AP-BJD · Destroyed
  > On November 5, 2010, a JS Air Pakistan, a Hawker Beechcraft B-1900, registration AP-BJD, crashed shortly after takeoff from Karachi-Jinnah International Airport (KHI), Karachi, Pakistan. All 17 passengers and 4 crewmembers onboard were fatally injured, and…
- [NTSB CEN10WA534](https://openairdocs.org/ntsb/CEN10WA534.md): Cessna 208 · Pointe a Pitre, Guadeloupe · Accident · Minor injuries · Foreign investigation · Sep 5, 2010 · F-OIXZ · Substantial damage
  > On September 5, 2010, at 1919 coordinated universal time, a Cessna 208B, French registered F-OIXZ, operated by Tropic Airlines, was substantially damaged during a forced landing near Pointe a Pitre, Guadeloupe. Visual meteorological conditions prevailed at…
- [NTSB CEN10WA150](https://openairdocs.org/ntsb/CEN10WA150.md): Cessna 421 · Tegucigalpa, Honduras · Accident · 3 fatal · Foreign investigation · Mar 10, 2010 · TG-JYM · Destroyed
  > This investigation is under the jurisdiction and control of the Honduran government.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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" = '342')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/342/cases?state=OF&year=2010

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.
