# NTSB investigations, 2020, 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 GAA21WA135](https://openairdocs.org/ntsb/GAA21WA135.md): Embraer EMB-550 · Mérida, Mexico · Accident · No injuries · Class 5 · Foreign · Dec 28, 2020 · N24YP · Substantial damage
- [NTSB GAA20WA145](https://openairdocs.org/ntsb/GAA20WA145.md): Piper PA34 · Cork, Ireland · Accident · Minor injuries · Class 5 · Foreign · Sep 21, 2020 · EI-CMT · Substantial damage
- [NTSB DCA20WA119](https://openairdocs.org/ntsb/DCA20WA119.md): Boeing 737 · Banjarmasin, Indonesia · Incident · No injuries · Foreign investigation · Jun 11, 2020 · PK-GML · Minor damage
  > The government of Indonesia has notified the NTSB of an incident involving a Boeing 737-800 airplane that occurred on June 11, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ireland's investigation under the…
- [NTSB DCA20WA093](https://openairdocs.org/ntsb/DCA20WA093.md): Boeing 767 · Shannon, Ireland · Accident · No injuries · Class 5 · Foreign · Mar 8, 2020 · N477AX · Substantial damage
- [NTSB ENG20WA020](https://openairdocs.org/ntsb/ENG20WA020.md): Airbus A321 · Antalya, Türkiye · Incident · No injuries · Foreign investigation · Jan 10, 2020 · VQ-BRS
  > The NTSB has received notification of an incident investigation by the Interstate Aviation Committee (MAK) of Russia of an Airbus A321, Registration VQ-BRS, that experienced a nose landing gear (NLG) failure while landing at the Antalya airport (LTAI) on…

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

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

---
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.
