# NTSB investigations, MO: 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 DCA18CA049](https://openairdocs.org/ntsb/DCA18CA049.md): Embraer S A ERJ170-200LR · Saint Louis, MO · Accident · Serious injuries · Data collection · Final report · Dec 18, 2017 · N128SY · No damage
  > the abrupt pitch up maneuver which caused the flight attendant to lose her balance and injure her ankle.
- [NTSB CEN15LA077](https://openairdocs.org/ntsb/CEN15LA077.md): New Piper PA 32R-301T · Springfield, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 2014 · N3127R · Substantial damage
  > The pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…
- [NTSB CEN15LA050](https://openairdocs.org/ntsb/CEN15LA050.md): Cessna 401A · Fulton, MO · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 2014 · N401ME · Substantial damage
  > A failure of the right engine magneto distributor drive gears, which resulted in a total loss of engine power during takeoff. Contributing to the accident was the operator’s failure to inspect and maintain the magnetos in accordance with the engine…
- [NTSB CEN10CA258](https://openairdocs.org/ntsb/CEN10CA258.md): Calcote Clarence E Glasair RG · Lee's Summit, MO · Accident · No injuries · Data collection · Final report · May 18, 2010 · N236CC · Substantial damage
  > The failure of the landing gear to fully extend and lock in the down position for unknown reasons.
- [NTSB CHI08IA182](https://openairdocs.org/ntsb/CHI08IA182.md): Mcdonnell Douglas MD-81 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Jul 7, 2008 · N804ME · Minor damage
  > The inadvertent partial inflation of the evacuation slide within the tailcone during takeoff and subsequent binding of the elevator control cables. The partial inflation resulted from the tailcone evacuation slide cover failing to be secured to the floor…

## 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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
  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?state=MO

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