# NTSB investigations, 2010, Outside the U.S.: Hard landing

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 DCA11WA002](https://openairdocs.org/ntsb/DCA11WA002.md): Boeing 767 · Bristol, United Kingdom · Accident · No injuries · Foreign investigation · Oct 3, 2010 · G-OOBK · No damage
  > On October 3, 2010, at 0541 UTC, a Thompson Airways Boeing 767 experienced a hard landing at Bristol International Airport (BRS), Bristol, England. The aircraft was completing a flight from Cancun International Airport (CUN), Cancun, Mexico. Upon parking,…
- [NTSB DCA10RA085](https://openairdocs.org/ntsb/DCA10RA085.md): Boeing 737 · San Andres Island, Colombia · Accident · 1 fatal · Foreign investigation · Aug 16, 2010 · HK-4682 · Substantial damage
  > On August 16, 2010, at 0150 UTC, an Aires B737-700, registration HK4682, crashed on approach to the San Andres Island Airport in San Andres Island, Colombia. Of the 121 passengers and 6 crew on board, preliminary reports indicate that there was one fatality…
- [NTSB WPR10WA114](https://openairdocs.org/ntsb/WPR10WA114.md): Cessna 182 · Palau International Airport, Palau · Accident · No injuries · Class 5 · Foreign · Jan 4, 2010 · T8A182P · Substantial damage
  > On January 4, 2010, about 1300 Palau standard time, a Cessna 182P, registered T8A182P, with amphibian floats, landed hard on runway 09 at Palau International Airport, Republic of Palau. The airplane was registered to, and operated by, ABA Sky, Inc. The…

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '092' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/092/sequence?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.