# NTSB investigations, 2011: Fence/fence post

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 CEN12CA035](https://openairdocs.org/ntsb/CEN12CA035.md): Houts Avid Mark IV · Hibbing, MN · Accident · Minor injuries · Data collection · Final report · Oct 21, 2011 · N43280 · Substantial damage
  > The improper installation of a hose clamp, which resulted in an oil line rupture and subsequent loss of engine oil pressure.
- [NTSB ERA12LA009](https://openairdocs.org/ntsb/ERA12LA009.md): Cessna 150L · Punta Gorda, FL · Accident · No injuries · Limited investigation · Final report · Oct 5, 2011 · N11280 · Substantial damage
  > The partial loss of engine power due to contamination of the fuel system that was not detected because of the pilot’s inadequate preflight inspection.
- [NTSB WPR11LA400](https://openairdocs.org/ntsb/WPR11LA400.md): Cessna 182Q · Alton, UT · Accident · No injuries · Limited investigation · Final report · Aug 21, 2011 · N79ES · Substantial damage
  > The pilot’s failure to abort the takeoff in a timely manner, which resulted in insufficient altitude to clear obstructions.
- [NTSB ERA11CA445](https://openairdocs.org/ntsb/ERA11CA445.md): Piper PA-32RT-300 · Charleston, SC · Accident · No injuries · Data collection · Final report · Aug 9, 2011 · N30731 · Substantial damage
  > The pilot's decision to continue the approach and landing at a high airspeed, which resulted in an improper touchdown point and subsequent runway excursion.
- [NTSB WPR11LA340](https://openairdocs.org/ntsb/WPR11LA340.md): Piper PA-24-250 · Lopez, WA · Accident · No injuries · Limited investigation · Final report · Jul 17, 2011 · N5532P · Substantial damage
  > A partial loss of engine power due to a cracked engine case near the rear cylinder.
- [NTSB WPR11LA131](https://openairdocs.org/ntsb/WPR11LA131.md): Aeronca 7AC · Novato, CA · Accident · No injuries · Limited investigation · Final report · Feb 10, 2011 · N2659E · Substantial damage
  > The pilot's use of a non-vented fuel cap, which resulted in a total loss of engine power due to fuel starvation.

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

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

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