# NTSB investigations, 2012, NC: Miscellaneous/other

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 ERA13LA072](https://openairdocs.org/ntsb/ERA13LA072.md): Hansen David Daniel RV-4 · Carthage, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2012 · N416DH · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examinations of the engine and fuel system revealed no anomalies that would have precluded normal operation. Contributing to the severity of the accident was the…
- [NTSB ERA13LA037](https://openairdocs.org/ntsb/ERA13LA037.md): Cessna 172D · Indian Trail, NC · Accident · No injuries · Limited investigation · Final report · Oct 20, 2012 · N2879U · Substantial damage
  > The pilot’s improper use of flaps for takeoff, which resulted in the airplane’s failure to attain adequate climb airspeed and subsequent collision will trees during takeoff.
- [NTSB ERA12LA362](https://openairdocs.org/ntsb/ERA12LA362.md): Schweizer 269C · Asheville, NC · Accident · No injuries · Limited investigation · Final report · May 24, 2012 · N7505Y · Substantial damage
  > The use of an aftermarket skid shoe, which resulted in the skid shoe becoming caught on a runway centerline light during the run-on landing.
- [NTSB ERA12LA309](https://openairdocs.org/ntsb/ERA12LA309.md): Piper PA-18 · Pilot Mountain, NC · Accident · No injuries · Limited investigation · Final report · Apr 29, 2012 · N5769D · Substantial damage
  > The pilot's failure to abort the takeoff in a timely manner. Contributing to the accident was the airplane’s reduced takeoff performance.

## 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."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/900/sequence?state=NC&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.
