# NTSB investigations, NC: Oversight

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 DCA23FA339](https://openairdocs.org/ntsb/DCA23FA339.md): Boeing 717-200 · Charlotte, NC · Accident · No injuries · Class 3 · Field · Final report · Jun 28, 2023 · N955AT · Substantial damage
  > A fatigue fracture of the upper lock link that initiated along scratch features on the lower surface at the parting line of the forged aluminum component. Contributing to the accident was the overhaul facilities noncompliance with Service Bulletin 717-32-002.
- [NTSB ERA21LA390](https://openairdocs.org/ntsb/ERA21LA390.md): Eurocopter AS 350 B3 · Kinston, NC · Accident · No injuries · Class 4 · Limited · Final report · Sep 29, 2021 · N370NC · Substantial damage
  > The buckling of the tail boom as a result of a hard landing event of undetermined time and location.
- [NTSB ERA16LA209](https://openairdocs.org/ntsb/ERA16LA209.md): WSK PZL Mielec M 18A · Brunswick, NC · Accident · 1 fatal · Limited investigation · Final report · Jun 10, 2016 · N2283M · Destroyed
  > The failure of the right wing due to a fatigue fracture of the right outboard wing forward spar lower fitting. Contributing to the accident was the routine operation of the airplane over its certificated maximum gross weight and the operator's improper or…
- [NTSB ERA15FA128](https://openairdocs.org/ntsb/ERA15FA128.md): Piper PA28 · Greensboro, NC · Accident · 1 fatal · Field investigation · Final report · Feb 11, 2015 · N5985U · Substantial damage
  > A total loss of engine power after takeoff due to fuel starvation as a result of excessive wear of the fuel selector valve. Also causal was the owner/operator and maintenance personnel's inadequate maintenance, and inadequate postmaintenance inspection.
- [NTSB ERA13LA075](https://openairdocs.org/ntsb/ERA13LA075.md): Cessna 172F · Albemarle, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 2012 · N8475U · Minor damage
  > The student pilot's failure to remain clear of the airplane’s rotating propeller.
- [NTSB ERA11LA106](https://openairdocs.org/ntsb/ERA11LA106.md): Eurocopter MBB-BK · Cherry Point, NC · Accident · No injuries · Limited investigation · Final report · Dec 29, 2010 · N854EC · Substantial damage
  > The pilot's impairment during cruise flight due to a recurring stroke. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of the pilot's known medical condition.

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

This list as a web page: https://openairdocs.org/ntsb-findings/040320/cases?state=NC

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