NTSB investigations, 2017, NC

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

Cases per year

20082026
NTSB investigations, 2017, NC per year, 2008–2026: 76 cases
20083
20095
20104
20118
20124
20136
20146
20157
20163
20175
20185
20193
20201
20212
20222
20234
20243
20253
20262

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 year(c.\"eventDate\") = 2017
    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\" = '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 ERA18TA059Accident · Minor injuriesFinal reportCessna 172 · Union Mills, NCThe pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.Dec 24, 2017 · N91SP · Substantial damageNTSB ERA18FA012Accident · 1 fatalField investigationFinal reportBeech 35C33 · Whiteville, NCThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation, and his delayed reaction to the loss of engine power, which led to impact with trees as he was attempting to switch fuel tanks.…Oct 31, 2017 · N293GC · Substantial damageNTSB ERA17MA316Accident · 4 fatalClass 2 · MajorFinal reportEurocopter Deutschland MBB BK 117 · Hertford, NCA failure of the rear bearing in the No. 2 engine, which (1) created multiple and likely unexpected and confusing cockpit indications, resulting in the pilot's improper diagnosis and subsequent erroneous shutdown of the No. 1 engine, and (2) the resulting…Sep 8, 2017 · N146DU · DestroyedNTSB ERA17TA196Accident · No injuriesFinal reportErnest T Christley Zenith Zodiac 601XL · Sanford, NCThe pilot’s selection of a threaded metal rod of insufficient strength to connect the fuel tank selector handle to the fuel valve, which resulted in his inability to switch fuel tanks and a subsequent total loss of engine power due to fuel starvation.May 29, 2017 · N167EZ · Substantial damageNTSB ERA17LA102Accident · Serious injuriesClass 3 · LimitedFinal reportShell John Super SIX · Morganton, NCA loss of engine power and impact with trees and terrain for reasons that could not be determined based on the available information.Feb 6, 2017 · N426KS · Substantial damage