# NTSB investigations, 2012: Soft surface

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 ERA13LA018](https://openairdocs.org/ntsb/ERA13LA018.md): Sikorsky S-55B · Yorktown, NY · Accident · No injuries · Limited investigation · Final report · Oct 12, 2012 · N443FD · Substantial damage
  > The pilot's improper decision to perform a downwind precautionary landing and the helicopter’s resultant settling with power and impact with terrain.
- [NTSB ANC13CA003](https://openairdocs.org/ntsb/ANC13CA003.md): Cessna 172D · Buckland, AK · Accident · No injuries · Data collection · Final report · Oct 8, 2012 · N8808 · Substantial damage
  > The pilot's loss of airplane control during takeoff from an off-airport site, which resulted in a runway excursion and collision with terrain.
- [NTSB ANC12CA104](https://openairdocs.org/ntsb/ANC12CA104.md): Stinson 108-2 · Nikiski, AK · Accident · No injuries · Data collection · Final report · Sep 9, 2012 · N9723K · Substantial damage
  > The pilot's selection of an unsuitable landing surface, which resulted in a loss of control during the landing roll.
- [NTSB WPR12LA409](https://openairdocs.org/ntsb/WPR12LA409.md): Great Lakes 2T-1A-2 · Monroe, WA · Accident · No injuries · Limited investigation · Final report · Sep 8, 2012 · N3702F · Substantial damage
  > A loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN12CA608](https://openairdocs.org/ntsb/CEN12CA608.md): Rolladen-Schneider OHG LS3-A · Navasota, TX · Accident · No injuries · Data collection · Final report · Sep 3, 2012 · N27UP · Substantial damage
  > The pilot’s inadequate compensation for landing area conditions during an off-airport landing, which resulted in a loss of directional control and a collision with terrain.
- [NTSB WPR12LA366](https://openairdocs.org/ntsb/WPR12LA366.md): Piper PA-30 B · Scappoose, OR · Accident · No injuries · Limited investigation · Final report · Aug 23, 2012 · N222BP · Substantial damage
  > The failure of the landing gear to fully extend as a result of a failure of the landing gear transmission assembly for reasons that could not be determined based on the available evidence.
- [NTSB ANC12LA058](https://openairdocs.org/ntsb/ANC12LA058.md): Piper PA-32-300 · Gustavus, AK · Accident · No injuries · Limited investigation · Final report · Jun 25, 2012 · N8908N · Substantial damage
  > The fatigue failure of the engine crankshaft for reasons that could not be determined during postaccident metallurgical examination.
- [NTSB CEN12FA188](https://openairdocs.org/ntsb/CEN12FA188.md): Piper PA-28-161 · Mexico, MO · Accident · 1 fatal · Field investigation · Final report · Mar 18, 2012 · N158EA · Substantial damage
  > The pilot’s failure to maintain airplane control during takeoff, which resulted in an aerodynamic stall and subsequent collision with trees. Contributing to the accident was the pilot’s inadequate preflight performance planning before departing on the soft,…

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

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