NTSB investigations, NC

6 cases where NTSB found Oversight.

Cases per year

20102026
NTSB investigations, NC per year, 2010–2026: 6 cases
20101
20121
20151
20161
20211
20231

Latest cases

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB DCA23FA339Accident · No injuriesClass 3 · FieldFinal reportBoeing 717-200 · Charlotte, NCA 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.Jun 28, 2023 · N955AT · Substantial damageNTSB ERA21LA390Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · Kinston, NCThe buckling of the tail boom as a result of a hard landing event of undetermined time and location.Sep 29, 2021 · N370NC · Substantial damageNTSB ERA16LA209Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M 18A · Brunswick, NCThe 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…Jun 10, 2016 · N2283M · DestroyedNTSB ERA15FA128Accident · 1 fatalField investigationFinal reportPiper PA28 · Greensboro, NCA 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.Feb 11, 2015 · N5985U · Substantial damageNTSB ERA13LA075Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Albemarle, NCThe student pilot's failure to remain clear of the airplane’s rotating propeller.Dec 2, 2012 · N8475U · Minor damageNTSB ERA11LA106Accident · No injuriesLimited investigationFinal reportEurocopter MBB-BK · Cherry Point, NCThe 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.Dec 29, 2010 · N854EC · Substantial damage