NTSB investigations, 2013, KS

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

Cases per year

20082026
NTSB investigations, 2013, KS per year, 2008–2026: 48 cases
200811
20093
20102
20111
20122
20135
20141
20156
20162
20173
20183
20191
20222
20232
20264

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\") = 2013
    AND c.\"eventStateOrRegion\" = 'KS' 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 CEN14LA033Accident · No injuriesLimited investigationFinal reportClevenger Jimmie B Pitts S 1S · Wellington, KSThe loss of engine power due to a malfunctioning fuel pump.Oct 31, 2013 · N67JC · Substantial damageNTSB CEN13LA561Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Ulysses, KSAn in-flight fire and subsequent loss of engine power for reasons that could not be determined due to extensive fire damage to the airplane and its fuel and electrical systems.Sep 25, 2013 · N4623M · DestroyedNTSB CEN13LA346Accident · No injuriesLimited investigationFinal reportRogers T-51 Mustang KIT · St Francis, KSForeign debris in the propeller governor, which led to excessive wear in the governor and its subsequent in-flight failure.Jun 11, 2013 · N548RR · Substantial damageNTSB CEN13LA280Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Galena, KSThe loss of engine power due to improper maintenance by an unknown individual that led to the degradation and deterioration of the No. 2 piston, which was undetected because of overdue maintenance.May 14, 2013 · N57719 · Substantial damageNTSB CEN13LA245Accident · No injuriesLimited investigationFinal reportRaytheon G36 · Hoxie, KSThe loss of engine power due to fuel starvation for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Apr 26, 2013 · N222GL · Substantial damage