NTSB investigations, NC

76 cases where the sequence of events included Loss of engine power (total).

Cases, newest first

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '341' 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 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 ERA13LA167Accident · Serious injuriesLimited investigationFinal reportAllen BD-5 · Mount Airy, NCA total loss of engine power due to the pilot's inadvertent closing of the engine choke. Contributing to the accident was the improper rigging of the engine choke cable.Mar 14, 2013 · N30BA · Substantial damageNTSB 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 ERA12LA545Accident · Minor injuriesLimited investigationFinal reportCessna 172E · East Bend, NCA total loss of engine power during the initial climb after takeoff for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.Sep 1, 2012 · N377SP · Substantial damageNTSB ERA12LA489Accident · No injuriesLimited investigationFinal reportBeech A36TC · Fayetteville, NCThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 28, 2012 · N6672X · Substantial damageNTSB ERA12LA432Accident · Minor injuriesLimited investigationFinal reportPiel Emeraude · Banner Elk, NCThe total loss of engine power for reasons that could not be determined because the engine was not examined.Jul 6, 2012 · C-FBZZ · Substantial damageNTSB ERA12LA112Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Merry Hill, NCOperation of the airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s failure to maintain airspeed while making a forced landing following a total loss of engine power at low altitude, which resulted in an…Dec 16, 2011 · N9279T · Substantial damageNTSB ERA12LA101Accident · No injuriesLimited investigationFinal reportCessna 172D · Belhaven, NCA total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Dec 4, 2011 · N2344U · Substantial damageNTSB ERA11CA485Accident · Minor injuriesData collectionFinal reportHaines Joseph E SHA-GLASAIR · Beaufort, NCThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.Sep 5, 2011 · N334JH · Substantial damageNTSB ERA11LA457Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Graham, NCThe individual's fuel mismanagement, which resulted in fuel exhaustion and a subsequent engine failure. Contributing the accident was the individual’s failure to maintain adequate airspeed following the engine failure, which resulted in an aerodynamic stall.Aug 16, 2011 · N492ST · Substantial damageNTSB ERA11LA461Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Elizabethtown, NCThe improper securing of a “B” nut on the power turbine control (Py) line by unknown maintenance personnel, which resulted in a total loss of engine power. Contributing to the accident was the pilot's failure to use the manual fuel override switch.Aug 6, 2011 · N469CC · Substantial damageNTSB ERA11CA364Accident · Minor injuriesData collectionFinal reportHelio H-295 · Brasstown, NCThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.Jun 25, 2011 · N99PM · Substantial damageNTSB ERA11LA359Accident · Serious injuriesLimited investigationFinal reportNavion Navion B · Red Oak, NCThe pilot's inadvertent movement of the fuel tank selector handle to the off position, resulting in a total loss of engine power due to fuel starvation.Jun 23, 2011 · N75394 · 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 ERA10LA504Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Mocksville, NCThe pilot’s failure to attain the proper touchdown point, following a loss of engine power due to carburetor icing.Aug 28, 2010 · N85929 · Substantial damageNTSB ERA10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · New Bern, NCInadequate quality control at the fuel servo overhaul facility, which resulted in contamination of the fuel servo and a subsequent loss of engine power due to fuel starvation.Jul 20, 2010 · N8900E · Substantial damageNTSB ERA10LA349Accident · No injuriesLimited investigationFinal reportBeech F33A · Mooresville, NCA loss of engine power for undetermined reasons.Jul 6, 2010 · N350NW · Substantial damageNTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.Feb 18, 2010 · N731DS · Substantial damageNTSB ERA10LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Durham, NCThe total loss of engine power in flight and a fire in the engine compartment for undetermined reasons.Nov 25, 2009 · N2758D · DestroyedNTSB ERA09LA356Accident · 1 fatalLimited investigationFinal reportChris Mitchell Titan Tornado · Chadbourn, NCThe pilot’s failure to maintain aircraft control during initial climb following a loss of engine power. The reason for the power loss was not determined.Jun 18, 2009 · N259CM · Substantial damageNTSB ERA09IA331Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Elkin, NCA total loss of engine power due to the failure of the No. 2 piston as a result of a fatigue crack of undetermined origin.Jun 9, 2009 · N34TG · Minor damageNTSB ERA09LA329Accident · 2 fatalLimited investigationFinal reportSorenson Lightning · Brevard, NCBoth pilots failure to maintain adequate airspeed while maneuvering after a loss of engine power for undetermined reasons, which resulted in an aerodynamic stall.Jun 8, 2009 · N130DS · Substantial damageNTSB ERA09LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Wilmington, NCA loss of engine power due to the crew's inadequate in-flight fuel monitoring.Jan 4, 2009 · N815MA · Substantial damageNTSB ERA09LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · New Bern, NCA loss of engine power for undetermined reasons.Dec 12, 2008 · N38558 · 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 damageNTSB ANC08LA063Accident · Serious injuriesLimited investigationFinal reportShaffstall Kolb Firestar II · Concord, NCA loss of engine power for an undetermined reason, which resulted in a forced landing and collision with terrain.May 6, 2008 · N40737 · Substantial damage