# NTSB investigations, 2016: 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 ENG16WA038](https://openairdocs.org/ntsb/ENG16WA038.md): Boeing 737 · Toulouse, France, France · Incident · No injuries · Foreign investigation · Jun 8, 2016 · EI-CSG
  > The Accident Investigation Bureau of Mongolia (AAIB) has notified the NTSB of an incident involving a Boeing 737-800, which occurred on June 8, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…
- [NTSB DCA16WA167](https://openairdocs.org/ntsb/DCA16WA167.md): Boeing 737 · tokyo, Japan · Incident · Minor injuries · Foreign investigation · May 27, 2016 · JA85AN · No damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of serious incident involving a BOEING 737 airplane that occurred on May 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under…
- [NTSB CEN16LA197](https://openairdocs.org/ntsb/CEN16LA197.md): Cessna 501 · Texarkana, AR · Accident · Minor injuries · Limited investigation · Final report · May 24, 2016 · N804ST · Substantial damage
  > The pilot's failure to use supplemental oxygen as required during high-altitude flight, which resulted in his loss of consciousness following a loss of cabin pressurization. Contributing to the accident was the separation of the air conditioning system's…
- [NTSB DCA16WA138](https://openairdocs.org/ntsb/DCA16WA138.md): Boeing 737 · Chiang Mai, Thailand · Incident · No injuries · Foreign investigation · Apr 10, 2016 · HS-LTB · No damage
  > Ministry of Transport of Thailand has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's investigation under 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") = 2016
  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?year=2016

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