# Final NTSB investigations: 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 CEN21LA268](https://openairdocs.org/ntsb/CEN21LA268.md): Cessna 172S · Saint James, LA · Accident · No injuries · Class 4 · Limited · Final report · Jun 10, 2021 · N365CP · Substantial damage
  > The in-flight fatigue failure of an air-conditioning system hose which resulted in a precautionary landing and impact with a road sign.
- [NTSB WPR18LA269](https://openairdocs.org/ntsb/WPR18LA269.md): Robinson R44 · Wahiawa, HI · Accident · No injuries · Class 3 · Limited · Final report · Sep 18, 2018 · N632NV · Substantial damage
  > Loss of oil in flight as a result of a loose oil filter adapter which resulted in the pilot initiating an immediate landing to an open field. Contributing to the accident was the pilot's manipulation of the throttle that led to a reduction in rotor rpm, which…
- [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 ERA15LA328](https://openairdocs.org/ntsb/ERA15LA328.md): Gulfstream Aerospace G IV · Caribbean Sea, A1 · Accident · No injuries · Limited investigation · Final report · Apr 10, 2015 · N450KK · Substantial damage
  > The in-flight failure of the cabin pressurization relief/safety valve (CPRV) due to an obstruction of the CPRV static port, which allowed the airplane to overpressurize. The reason for the initial overpressurization condition could not be determined.
- [NTSB ERA14LA424](https://openairdocs.org/ntsb/ERA14LA424.md): Socata TBM 700 · Caribbean Sea, A1 · Accident · 2 fatal · Limited investigation · Final report · Sep 5, 2014 · N900KN · Destroyed
  > The design of the cabin pressurization system, which made it prone to unnecessary shutdown, combined with a checklist design that prioritized troubleshooting over ensuring that the pilot was sufficiently protected from hypoxia. This resulted in a loss of…

## 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 c."completionStatus" = 'Completed'
  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?status=final

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