Fatal NTSB investigations, NC

11 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
Fatal NTSB investigations, NC per year, 2008–2026: 11 cases
20081
20091
20112
20121
20131
20141
20161
20233

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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' 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"

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 ERA24FA078Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46R-350T · Mooresville, NCA missing induction clamp, which allowed the induction hose to the left side intercooler to become disconnected, resulting in a total loss of engine power due to an overly rich fuel/air mixture.Dec 31, 2023 · N539MA · Substantial damageNTSB ERA23FA273Accident · 1 fatalClass 3 · FieldFinal reportMooney M20R · Southport, NCThe pilot’s improper decision to fly a known unairworthy airplane, which resulted in a total loss of engine power due to oil starvation.Jun 25, 2023 · N13LV · DestroyedNTSB ERA23FA238Accident · 1 fatalClass 3 · FieldFinal reportBeech V35 · Rougemont, NCA total loss of engine power due to oil starvation. The source of the oil starvation could not be determined.May 21, 2023 · N272S · DestroyedNTSB ERA16FA108Accident · 1 fatalField investigationFinal reportBeech A36 · Marshville, NCThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the severity of the pilot's injuries was his failure to have a properly secured shoulder harness at the time of the accident.Feb 19, 2016 · N61WB · Substantial damageNTSB ERA14FA313Accident · 1 fatalField investigationFinal reportCessna 182 · Littleton, NCMaintenance personnel's application of sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in internal failure of the engine due to the loss of case bolt torque.Jun 27, 2014 · N182PE · Substantial damageNTSB ERA13FA184Accident · 2 fatalField investigationFinal reportLancair LC42 - 550FG · Winston-Salem, NCThe pilot's failure to detect multiple indications and cues in the cockpit of the steady loss of engine oil pressure, which resulted in a catastrophic engine failure over terrain unsuitable for landing. Also causal was the loss of internal engine lubrication…Mar 31, 2013 · N6506L · DestroyedNTSB ERA12LA584Accident · 1 fatalLimited investigationFinal reportKeuthan Buccaneer II · Granite Quarry, NCThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Sep 30, 2012 · N710WP · Substantial damageNTSB ERA12FA021Accident · 1 fatalField investigationFinal reportElkind Bruce Cozy MK IV · Lexington, NCThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Oct 23, 2011 · N795DB · Substantial damageNTSB ERA11FA285Accident · 2 fatalField investigationFinal reportHebert Peter J Lancair Legacy · Richlands, NCThe pilot's improper in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.May 6, 2011 · N23PH · Substantial damageNTSB ERA09LA182Accident · 1 fatalLimited investigationFinal reportMoore Glenn Moronca · Burgaw, NCA partial loss of engine power due to fuel contamination as a result of the pilot's operation of the airplane with a deteriorated fuel tank.Mar 5, 2009 · N404AF · Substantial damageNTSB ERA09LA025Accident · 1 fatalLimited investigationFinal reportMoses Tim C Quicksilver · Wingate, NCA loss of engine power due to a fractured crankshaft.Oct 21, 2008 · N184GT · Substantial damage