# NTSB investigations, 2010: 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 CEN11LA092](https://openairdocs.org/ntsb/CEN11LA092.md): Embraer EMB-145LR · Madison, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 23, 2010 · N678AE · No damage
  > The passenger's decision to deplane without assistance despite having a preexisting condition that limited her mobility.
- [NTSB ERA10WA489](https://openairdocs.org/ntsb/ERA10WA489.md): Piper PA-31-350 · South Bimini, Bahamas · Accident · No injuries · Foreign investigation · Sep 19, 2010 · N84859 · Substantial damage
  > On September 19, 2010, at 1440 eastern daylight time, a Piper PA31-350, N84859, registered to Spirit Air Inc, and operated by Pioneer Air Services was on initial climb out when the lower half of the main cabin door came open. The pilot reversed his course and…
- [NTSB CEN10CA257](https://openairdocs.org/ntsb/CEN10CA257.md): Aerostar International S57A · Hilliard, OH · Accident · Serious injuries · Data collection · Final report · May 15, 2010 · N9002Z · No damage
  > The passenger’s inadequate brace for the balloon landing, resulting in injury.
- [NTSB CEN10LA245](https://openairdocs.org/ntsb/CEN10LA245.md): Gross Cozy · Pine Bluff, AR · Accident · Minor injuries · Limited investigation · Final report · May 9, 2010 · N144TJ · Substantial damage
  > The inadvertent opening of the cockpit canopy during cruise flight for undetermined reasons, which allowed debris to impact and damage the pusher propeller with a resulting total loss of engine power.
- [NTSB CEN10LA220](https://openairdocs.org/ntsb/CEN10LA220.md): Mcdonnell Douglas DC-9-82(MD-82) · Chicago, IL · Accident · Serious injuries · Limited investigation · Final report · Apr 17, 2010 · N461AA · No damage
  > The flight attendant's loss of balance resulting in a fall and a broken wrist.

## 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") = 2010
  AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '110')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/110/cases?year=2010

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