NTSB investigations, CO

73 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\" = 'CO' 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 CEN12LA543Accident · Serious injuriesLimited investigationFinal reportCross David L Glasair III · Westcliffe, COThe loss of oil pressure due to the failure of an oil filter gasket, which resulted in a total loss of engine power.Aug 7, 2012 · N71AJ · Substantial damageNTSB CEN12LA513Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor G-164A · La Salle, COThe loss of engine power due to the detached distributor rotor.Aug 1, 2012 · N9822 · Substantial damageNTSB CEN12LA389Accident · No injuriesLimited investigationFinal reportHoyle Fighter Escort Wings · Pueblo, COAn internal failure of one of the electrical system’s two batteries combined with the inadequate electrical system design, which resulted in a total loss of engine power.Jun 23, 2012 · N2051P · Substantial damageNTSB CEN12CA075Accident · No injuriesData collectionFinal reportGlobe GC-1B · Denver, COA loss of engine power due to fuel starvation as a result of a loose fuel line fitting.Nov 19, 2011 · N80775 · Substantial damageNTSB CEN11FA559Accident · Minor injuriesField investigationFinal reportCessna 182C · Boulder, COThe malfunction of the throttle linkage to the induction air box, which resulted in a loss of engine power and subsequent forced landing.Aug 9, 2011 · N8717T · Substantial damageNTSB CEN11LA487Accident · No injuriesLimited investigationFinal reportAyres S2R · Burlington, COA loss of engine power for undetermined reasons.Jul 18, 2011 · N70216 · Substantial damageNTSB CEN11LA490Accident · No injuriesLimited investigationFinal reportDarrow Stephen AL-6 · Peyton, COThe loss of engine power during the descent for reasons that could not be determined because a thorough examination of the engine could not be completed due to the remote accident site.Jul 13, 2011 · N61262 · Substantial damageNTSB CEN11CA410Accident · No injuriesData collectionFinal reportTaft, Malcolm J SR Glastar · Canon City, COA loss of engine power due to an overheated engine as a result of a malfunction of the modified engine cooling system, necessitating a forced landing on unsuitable terrain.Jun 6, 2011 · N238W · Substantial damageNTSB CEN10LA524Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Greeley, COA loss of engine power for undetermined reasons.Aug 24, 2010 · N4167A · Substantial damageNTSB CEN10FA458Accident · 3 fatalField investigationFinal reportBeech C35 · Rollinsville, COA loss of engine power for undetermined reasons.Aug 4, 2010 · N8974A · Substantial damageNTSB CEN10CA362Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Grand Junction, COThe total loss of engine power for undetermined reasons.Jun 25, 2010 · N9754C · Substantial damageNTSB CEN10CA326Accident · Minor injuriesData collectionFinal reportRemos G3/600 · Trinidad, COA total loss of engine power in flight due to fuel exhaustion for unknown reasons.Jun 19, 2010 · N134LS · Substantial damageNTSB CEN10LA242Accident · No injuriesLimited investigationFinal reportJorritsma Jerrold S Berkut · Loveland, COA loss of engine power due to a malfunction of the fuel controller resulting in a compressor stall.May 9, 2010 · N3255U · Substantial damageNTSB CEN10LA056Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Montrose, COA loss of engine power due to the pilot’s inadequate preflight planning.Nov 18, 2009 · N2493T · Substantial damageNTSB CEN10FA021Accident · Minor injuriesField investigationFinal reportCessna P210N · Rifle, COThe pilot’s failure to properly identify the power lever and, instead, manipulating the propeller condition lever.Oct 18, 2009 · N7217S · Substantial damageNTSB CEN09LA214Accident · Minor injuriesLimited investigationFinal reportMarlman Stol CH 801 · Fort Morgan, COThe complete loss of engine power, as reported by the pilot, for undetermined reasons.Mar 14, 2009 · N130WM · Substantial damageNTSB CEN09LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28C-235 · Falcon, COA loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel management.Feb 22, 2009 · N9487W · Substantial damageNTSB CEN09CA123Accident · No injuriesData collectionFinal reportCessna T210M · Fort Collins, COA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank before landing.Dec 31, 2008 · N732YK · Substantial damageNTSB DEN08CA134Accident · No injuriesData collectionFinal reportEnstrom 280FX · Aurora, COThe pilot's improper planning and decision making resulting in the loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's premature application of collective resulting in a hard landing and substantial damage.Aug 6, 2008 · N285SH · Substantial damageNTSB DEN08LA128Accident · No injuriesLimited investigationFinal reportBeech 35-C33A · Longmont, COA total loss of engine power for reasons undetermined. Contributing to the accident was the unsuitable terrain on which to make a forced landing.Jul 23, 2008 · N7965M · Substantial damageNTSB DEN08LA090Accident · No injuriesLimited investigationFinal reportDeHavilland DH112 Venom · Hudson, COThe loss of engine power for reasons undetermined. Contributing to the damage of the airplane were the three ditches and the lack of suitable terrain for a forced landing.May 17, 2008 · N21MJ · DestroyedNTSB DEN08LA085Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-5 · Wolcott, COThe failure of the engine driven fuel pump flange due to oil starvation, resulting in the loss of engine power due to fuel starvation. Contributing to the accident was the lack of suitable terrain for a forced landing.May 5, 2008 · N12KY · Substantial damageNTSB DEN08LA069Accident · No injuriesLimited investigationFinal reportCessna P210N · Elizabeth, COthe loss of engine power due to the fatigue failure of the camshaft gear. Contributing to the accident was the lack of suitable terrain for the forced landing.Mar 29, 2008 · N4839P · Substantial damage