# Final NTSB investigations, 2023: 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 DCA23LA465](https://openairdocs.org/ntsb/DCA23LA465.md): Boeing 787-8 · Lake Erie Beach, NY · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 28, 2023 · N804AN · No damage
  > Malfunctioning brakes on a service cart.
- [NTSB ERA23FA256](https://openairdocs.org/ntsb/ERA23FA256.md): Cessna 560 · Montebello, VA · Accident · 4 fatal · Class 3 · Field · Final report · Jun 4, 2023 · N611VG · Destroyed
  > Pilot incapacitation due to loss of cabin pressure for undetermined reasons. Contributing to the accident was the pilot’s and owner/operator’s decision to operate the airplane without supplemental oxygen.
- [NTSB CEN23LA178](https://openairdocs.org/ntsb/CEN23LA178.md): Airbus Helicopters EC130 · Carta Valley, TX · Accident · Serious injuries · Class 3 · Limited · Final report · May 6, 2023 · N254DM · No damage
  > The right rear-seat passenger’s improper judgement to release his restraint system and depart the helicopter while in a hover, which resulted in him sustaining serious injuries. Contributing to the accident was his impairment from effects of alcohol…
- [NTSB ERA23LA212](https://openairdocs.org/ntsb/ERA23LA212.md): Gulfstream Aerospace GVII-G500 · Dulles, VA · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 28, 2023 · N507GD · No damage
  > The initiation of the takeoff while before the flight attendant had returned to her seat, which resulted in a serious injury during takeoff.
- [NTSB ERA23LA135](https://openairdocs.org/ntsb/ERA23LA135.md): Bombardier BD-100-1A10 · Windsor Locks, CT · Accident · 1 fatal · Class 2 · Limited · Final report · Mar 3, 2023 · N300ER · Minor damage
  > The flight crew’s failure to remove the right side pitot probe cover before flight, their decision to depart with a No-Go advisory message following an aborted takeoff, and their selection of the incorrect non-normal checklist in flight, which resulted in an…

## 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") = 2023
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE 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?status=final&year=2023

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