# NTSB investigations, 2012: Rain

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 WPR13LA062](https://openairdocs.org/ntsb/WPR13LA062.md): Cessna 172S · Kahului, HI · Accident · 1 fatal · Limited investigation · Final report · Dec 2, 2012 · N3554Y · Substantial damage
  > The noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.
- [NTSB CEN13FA012](https://openairdocs.org/ntsb/CEN13FA012.md): Cessna 172R · Simpson, LA · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2012 · N2126R · Substantial damage
  > The pilot’s loss of airplane control while maneuvering between areas of precipitation during a night cross-country flight.
- [NTSB ERA12FA566](https://openairdocs.org/ntsb/ERA12FA566.md): Mooney M20M · Crane Hill, AL · Accident · 2 fatal · Field investigation · Final report · Sep 17, 2012 · N1085A · Substantial damage
  > The pilot’s loss of control in moderate-to-heavy rain. Contributing to the accident was the pilot’s reliance on ADS-B for tactical weather avoidance.

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

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