NTSB investigations, CO

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

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\" = '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 CEN14LA393Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Pueblo, COA total loss of engine power due to fuel starvation, which resulted from the pilot’s improper fuel management and resulted in a forced landing on unsuitable terrain.Jul 27, 2014 · N72CW · Substantial damageNTSB CEN14LA267Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA20-C1 · Longmont, COA loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight inspection.Jun 1, 2014 · N206ND · Substantial damageNTSB CEN14LA261Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Boulder, COThe pilot's failure to adequately monitor the airplane's actual fuel consumption rate, which resulted in a total loss of engine power due to fuel exhaustion.May 28, 2014 · N8808L · Substantial damageNTSB CEN14IA139Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Gunnison, COThe pilot's improper decision to initiate the flight into an area with forecast icing conditions, which resulted in an encounter with in-flight icing conditions that prevented the airplane from being able to maintain altitude.Feb 14, 2014 · N18DN · Minor damageNTSB CEN13LA443Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Monte Vista, COThe partial loss of engine power due to a fatigue failure of the engine cylinder exhaust rocker housing as a result of an excessively torqued rocker assembly.Jul 29, 2013 · N5324 · Substantial damageNTSB CEN13CA334Accident · No injuriesData collectionFinal reportBeech C24R · Peyton, COThe pilot’s failure to maintain proper pitch control during takeoff.Jun 9, 2013 · N1854P · Substantial damageNTSB CEN13LA298Accident · No injuriesLimited investigationFinal reportAllen Jan A Challenger II · Greeley, COThe loss of engine power due to the engine seizure, which resulted from damage caused by the ingestion of carburetor ice into the engine intake ports.May 22, 2013 · N269MM · Substantial damageNTSB CEN13FA182Accident · Minor injuriesField investigationFinal reportAero Commander 500B · Broomfield, COLoss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the fuel gauge to indicate the actual amount of fuel on board the airplane and the design of the airplane's fuel system, which precluded a visual confirmation of the…Mar 1, 2013 · N93AA · Substantial damageNTSB CEN13CA079Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-32 · Boulder, COThe glider pilot's inability to locate an area of thermal lift.Nov 29, 2012 · N9929J · Substantial damageNTSB CEN12FA653Accident · No injuriesField investigationFinal reportPiper PA-46-350P · Kiowa, COA catastrophic engine failure due to unrecognized and unrepaired corrosion within the engine, which was consistent with engine operations after an extended period of inactivity.Sep 18, 2012 · N188SR · Substantial damageNTSB 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 CEN12FA199Accident · 2 fatalField investigationFinal reportCessna 172S · Longmont, COThe inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.Mar 23, 2012 · N10468 · 2 aircraft · 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 CEN11CA289Accident · Minor injuriesData collectionFinal reportRans S12 · Fort Collins, COThe pilot's inadvertent application of full right rudder during landing, which resulted in an aerodynamic stall and impact with terrain.Apr 9, 2011 · N3581S · Substantial damageNTSB CEN11LA266Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wellington, COThe certified flight instructor's failure to maintain directional control during the go-around.Apr 2, 2011 · N4914V · Substantial damageNTSB CEN11CA166Accident · No injuriesData collectionFinal reportMcholland C L Solitare · Wellington, COThe glider pilot’s misjudgment while approaching to land, which resulted in an off-airport landing.Jan 29, 2011 · N15XP · Substantial damageNTSB CEN11LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Durango, COA total loss of engine power due to the pilot inadvertently moving the fuel selector to the OFF position. Contributing to the accident was the pilot's unfamiliarity with this model accident airplane.Oct 3, 2010 · N2593 · 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 CEN10LA380Accident · Minor injuriesLimited investigationFinal reportChampion 8KCAB · Estes Park, COThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.Jul 8, 2010 · N56BC · Substantial damageNTSB CEN10CA376Accident · No injuriesData collectionFinal reportWells Terry Hula Girl · Wellington, COA partial loss of engine power due to the inadequate design of the engine cowling.Jul 3, 2010 · N301TW · 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 CEN10FA162Accident · No injuriesField investigationFinal reportMaule M-6-235 · Bennett, COThe pilot’s failure to maintain clearance from a utility line while maneuvering.Jan 30, 2010 · N7613X · Substantial damageNTSB CEN10LA032Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Walsh, COA partial loss of engine power due to failure of the No. 2 cylinder as a result of the failure of the repair facility to properly torque the lower four nuts on the cylinder.Oct 27, 2009 · N7464E · 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 CEN09LA075Accident · Minor injuriesLimited investigationFinal reportHauser U/Hauser J KIT FOX CL · Boulder, COA loss of engine thrust due to the pilot's inadvertent activation of the propeller controls. Contributing to the accident were the non-standard propeller controls and the pilot's lack of experience in the airplane.Nov 24, 2008 · N4JU · Substantial damageNTSB CEN09LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Whitewater, COBoth pilots' failure to see and avoid the other airplane. Contributing factors in this accident were the Cessna 180 pilot's attention being diverted and the Cessna 210 pilot's vision being affected by the sun glare.Oct 22, 2008 · N3389D · 2 aircraft · Substantial damageNTSB DFW08LA238Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Leadville, COThe flight instructor's failure to maintain control of the airplane while maneuvering at low altitude.Sep 29, 2008 · N736LN · Substantial damageNTSB DEN08CA135Accident · No injuriesData collectionFinal reportGrumman G-164A · Walsh, COThe total failure of a cylinder head assembly. Contributing to the accident was the lack of suitable terrain for a forced landing.Aug 6, 2008 · N7487 · 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 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