# NTSB investigations: Boeing 737-7H4: Cabin safety event

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 DCA22LA134](https://openairdocs.org/ntsb/DCA22LA134.md): Boeing 737-700 · Tacoma, WA · Accident · Serious injuries · Class 4 · Limited · Final report · May 22, 2022 · N256WN · No damage
  > During cruise flight with no reported turbulence a passenger sustained a serious injury for an unknown reason.
- [NTSB DCA19CA006](https://openairdocs.org/ntsb/DCA19CA006.md): Boeing 737 · San Jose, CA · Accident · Serious injuries · Class 4 · Data collection · Final report · Oct 11, 2018 · N734SA · No damage
  > A passenger falling while returning to her seat which resulted in a serious injury.
- [NTSB DCA19CA005](https://openairdocs.org/ntsb/DCA19CA005.md): Boeing 737 · Nashville, TN · Accident · Serious injuries · Class 4 · Data collection · Final report · Oct 10, 2018 · N287WN · No damage
  > flight attendant tripping over a passenger's knee that resulted in hot liquid splashing on the flight attendant.
- [NTSB DCA14CA120](https://openairdocs.org/ntsb/DCA14CA120.md): Boeing 737 7H4 · Dallas, TX · Accident · Serious injuries · Data collection · Final report · Jun 17, 2014 · N968WN · No damage
  > A buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the potlocking handle was raised, which resulted in 2nd and 3rd degree burns.
- [NTSB DCA14CA035](https://openairdocs.org/ntsb/DCA14CA035.md): Boeing 737 7H4 · Nashville, TN · Accident · Serious injuries · Data collection · Final report · Jan 9, 2014 · N966WN · No damage
  > A buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the potlocking lever was raised, which resulted in 2nd degree burns.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1384404')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '110' 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/110/sequence?model=1384404

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