# NTSB investigations, 2021, Outside the U.S.: Pressure/environ sys malf/fail

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 DCA22WA051](https://openairdocs.org/ntsb/DCA22WA051.md): Boeing 737 · West Sumatera, Indonesia · Incident · No injuries · Class 5 · Foreign · Dec 13, 2021 · PK-LQR · No damage
- [NTSB DCA22WA033](https://openairdocs.org/ntsb/DCA22WA033.md): Boeing 737 · Patna, India · Incident · Class 5 · Foreign · Nov 17, 2021 · VT-SYZ · No damage
- [NTSB DCA22WA025](https://openairdocs.org/ntsb/DCA22WA025.md): Boeing 737 · Darwin, Australia · Incident · Class 5 · Foreign · Nov 3, 2021 · ZK-FXJ · No damage
- [NTSB DCA22WA020](https://openairdocs.org/ntsb/DCA22WA020.md): Boeing 787-9 · Baradero, Argentina · Incident · No injuries · Class 5 · Foreign · Nov 3, 2021 · N36962 · No damage
- [NTSB DCA22WA022](https://openairdocs.org/ntsb/DCA22WA022.md): Boeing 737 · Casablanca, Morocco · Incident · Class 5 · Foreign · Oct 10, 2021 · CN-ROR · No damage
- [NTSB DCA21WA222](https://openairdocs.org/ntsb/DCA21WA222.md): Boeing 737 · Katowice, Poland · Incident · Class 5 · Foreign · Sep 13, 2021 · EI-STL · No damage
- [NTSB DCA21WA180](https://openairdocs.org/ntsb/DCA21WA180.md): Boeing 737 · Ballarat, Australia · Incident · No injuries · Class 5 · Foreign · Jul 6, 2021 · VH-XMO · No damage
- [NTSB DCA21WA173](https://openairdocs.org/ntsb/DCA21WA173.md): Boeing 737 · Caracas, Venezuela · Incident · Class 5 · Foreign · Jun 28, 2021 · YV-3158 · No damage
- [NTSB DCA21WA100](https://openairdocs.org/ntsb/DCA21WA100.md): Boeing 737 · Tijuana, Mexico · Incident · Class 5 · Foreign · Mar 16, 2021 · XA-AMM · No damage
- [NTSB DCA21WA075](https://openairdocs.org/ntsb/DCA21WA075.md): Boeing 737 · Durban, South Africa · Incident · Class 5 · Foreign · Jan 25, 2021 · ZS-SJF · No damage

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

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

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