# NTSB investigations, 2012: Lack of sleep

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 WPR13FA010](https://openairdocs.org/ntsb/WPR13FA010.md): Piper PA-28-151 · Marana, AZ · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2012 · N151SV · Substantial damage
  > The pilot’s flight in dark night conditions with no visual reference and his subsequent spatial disorientation.
- [NTSB ERA12FA572](https://openairdocs.org/ntsb/ERA12FA572.md): Cessna 172S · Land O'Lakes, FL · Accident · 1 fatal · Field investigation · Final report · Sep 22, 2012 · N21750 · Substantial damage
  > The pilot’s decision to continue the cross-country flight while fatigued, which resulted in him falling asleep during the initial descent for landing.
- [NTSB CEN12FA521](https://openairdocs.org/ntsb/CEN12FA521.md): Ayres S2R-T34 · Lakin, KS · Accident · No injuries · Field investigation · Final report · Aug 6, 2012 · N365SM · Substantial damage
  > The pilot's failure to maintain clearance from the corn during an aerial application flight.
- [NTSB DCA12FA051](https://openairdocs.org/ntsb/DCA12FA051.md): Convair 440 - NO Series · San Juan, PR · Accident · 2 fatal · Class 1 · Field · Final report · Mar 15, 2012 · N153JR · Destroyed
  > the flight crew's failure to maintain adequate airspeed after shutting down the right engine due to an in-flight fire in one of the right augmentors. The failure to maintain airspeed resulted in either an aerodynamic stall or a loss of directional control.

## 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", '02013510'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/02013510/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.
