# NTSB investigations, 2012: Physical workspace

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 CEN13CA117](https://openairdocs.org/ntsb/CEN13CA117.md): Embraer EMB-145LR · Chicago, IL · Accident · Serious injuries · Data collection · Final report · Dec 29, 2012 · N619AE · No damage
  > The presence of deice fluid on the floor, which resulted in a slip hazard and an injury to the flight attendant.
- [NTSB WPR13GA044](https://openairdocs.org/ntsb/WPR13GA044.md): Bell OH-58 · Altadena, CA · Accident · Minor injuries · Final report · Nov 17, 2012 · N911FA · 2 aircraft · Substantial damage
  > The landing pilot's failure to maintain clearance with from obstacles a parked prior to landinghelicopter and the other pilot's failure to park the helicopter inside of a marked parking pad. Contributing to the accident was the landing pilot's obscured…
- [NTSB WPR13CA016](https://openairdocs.org/ntsb/WPR13CA016.md): Boeing 737-3H4 · Las Vegas, NV · Accident · Serious injuries · Data collection · Final report · Oct 17, 2012 · N625SW · No damage
  > The flight attendant's encounter with an unseen obstruction in the aisle, which resulted in a fall.
- [NTSB ERA12FA484](https://openairdocs.org/ntsb/ERA12FA484.md): Cessna 172M · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Jul 25, 2012 · N73115 · Substantial damage
  > Maintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…
- [NTSB CEN12LA457](https://openairdocs.org/ntsb/CEN12LA457.md): Bombardier CL-600-2C10 · Peoria, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2012 · N502AE · No damage
  > The emergency ground egress during which a passenger broke her ankle. Contributing to the accident was the failure of the environmental system, which allowed smoke from a nearby house fire to enter the airplane.

## 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") = 2012
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '030410'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/030410/cases?year=2012

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