NTSB investigations, CO

88 cases where the sequence of events included Nose over/nose down.

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\" = '096' 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 CEN16LA239Accident · Minor injuriesLimited investigationFinal reportPiper J3F 65 · Strasburg, COA partial loss of engine power due to carburetor ice accumulation.Jun 27, 2016 · N29042 · Substantial damageNTSB GAA16CA270Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Mack, COThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, impact with a ditch, and nose over.May 29, 2016 · N273BC · Substantial damageNTSB GAA16CA250Accident · No injuriesData collectionFinal reportCessna 182 · Calhan, COThe pilot's incorrect pitch control during the landing flare in gusty crosswind conditions, which resulted in a hard landing and nose over.May 21, 2016 · N42553 · Substantial damageNTSB GAA16CA115Accident · No injuriesData collectionFinal reportAmerican Legend AL11C 100 · Las Animas, COThe pilot's selection of unsuitable terrain for landing, resulting in a nose over.Jan 30, 2016 · N24184 · Substantial damageNTSB CEN16LA053Accident · No injuriesLimited investigationFinal reportPipistrel Virus · Englewood, COThe total loss of engine power due to fuel starvation as a result of contamination in the right fuel tank and fuel lines, which prevented fuel from flowing to the engine.Dec 2, 2015 · N145VS · Substantial damageNTSB GAA16CA061Accident · No injuriesData collectionFinal reportMelvin K Callen Backcountry Supercub · Fort Morgan, COThe pilot's excessive braking during the landing roll, which resulted in a nose over.Nov 24, 2015 · N842MC · Substantial damageNTSB GAA15CA286Accident · No injuriesData collectionFinal reportCessna 170A · Springfield, COThe pilot's failure to maintain directional control during the landing flare, which resulted in a collision with terrain, and a nose over.Oct 1, 2015 · N9775A · Substantial damageNTSB CEN15LA430Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Glenwood Springs, COA loss of engine power during cruise flight due to carburetor icing and the pilot's failure to apply carburetor heat, which resulted in a forced landing on rough/uneven terrain.Sep 27, 2015 · N3147S · Substantial damageNTSB CEN15CA159Accident · No injuriesData collectionFinal reportArnold Zodiac CH 650 · Greeley, COThe pilot was unable to maintain directional control during the landing due to the foreign object that lodged behind the rudder.Feb 27, 2015 · N715AK · Substantial damageNTSB CEN15CA125Accident · Minor injuriesData collectionFinal reportCessna 182C · Fort Morgan, COThe pilot's improper fuel planning/management, which resulted in the total loss of engine power due to fuel exhaustion and the subsequent forced landing in a pasture.Jan 26, 2015 · N8997T · Substantial damageNTSB CEN14LA439Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Wray, COA loss of the No. 1 cylinder’s compression due to a stuck exhaust valve caused by a lack of sufficient valve clearance, which resulted in a loss of engine power and a forced landing. Contributing to the loss of engine power were the worn intake and exhaust…Aug 19, 2014 · N4542W · Substantial damageNTSB CEN14LA361Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Monte Vista, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around following impact with a barley crop, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s…Jul 12, 2014 · N91106 · Substantial damageNTSB CEN13CA532Accident · No injuriesData collectionFinal reportCessna 150G · Denver, COThe pilot's failure to maintain directional control during landing which resulted in an impact with the runway surface. A contributing factor was the certified flight instructor delayed response to the pilot's improper landing.Sep 6, 2013 · N4791X · Substantial 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 CEN13CA372Accident · Serious injuriesData collectionFinal reportKubicek BB70Z · Windsor, COThe pilots’ encounter with increased wind, which resulted in a hard and fast landing.Jun 24, 2013 · N1235J · Minor damageNTSB CEN13CA292Accident · No injuriesData collectionFinal reportCessna 162 · Erie, COThe pilot’s total lack of experience in aircraft make/model, and his failure to maintain directional control during landing. Contributing to the accident was the operator’s lack of oversight is allowing the airplane to be rented to the pilot.May 22, 2013 · N6106 · Substantial damageNTSB CEN13CA266Accident · No injuriesData collectionFinal reportCessna 140 · Glenwood Springs, COThe pilot's failure to maintain airplane control during the landing roll and his excessive use of right brake, which resulted in a noseover.May 7, 2013 · N89983 · Substantial damageNTSB CEN13CA138Accident · Minor injuriesData collectionFinal reportCessna 170B · Erie, COThe pilot’s failure to maintain control of the airplane while taking off in gusting wind conditions.Jan 20, 2013 · N2323D · Substantial damageNTSB CEN12CA537Accident · No injuriesData collectionFinal reportGage Midget Mustang MM-1 · Erie, COThe pilot's inadequate compensation for the crosswind conditions during takeoff, which resulted in a loss of directional control.Aug 11, 2012 · N41831 · Substantial damageNTSB CEN12LA493Accident · No injuriesLimited investigationFinal reportCessna 182G · Montrose, COThe pilot's improper landing flare and inadequate recovery from a bounced landing.Jul 30, 2012 · N3198S · Substantial damageNTSB CEN12LA298Accident · Minor injuriesLimited investigationFinal reportPool Murphy Moose · Steamboat Springs, COA locked left brake for reasons that could not be determined because independent observations of the postaccident condition of the airplane could not be performed, and the pilot’s subsequent loss of control.May 12, 2012 · N223DH · Substantial damageNTSB CEN12CA206Accident · Serious injuriesData collectionFinal reportHall Jeffrey Hall RV-4 · Calhan, COThe pilot's loss of airplane control while landing with a gusting tailwind condition.Mar 24, 2012 · N605RV · Substantial damageNTSB CEN12CA200Accident · Minor injuriesData collectionFinal reportCessna 172P · Colorado Springs, COThe pilot did not maintain control of the airplane during takeoff, which resulted in a hard landing and subsequent nose over.Mar 24, 2012 · N97LP · Substantial damageNTSB CEN12CA160Accident · No injuriesData collectionFinal reportCessna 180 · South Fork, COThe pilot's loss of directional control while landing on a patchy snow-covered runway.Feb 18, 2012 · N56180 · Substantial damageNTSB CEN12LA126Accident · No injuriesLimited investigationFinal reportAviat A1 · Somerset, COThe pilot's inadequate takeoff planning/preparation, which resulted in the airplane impacting a snow drift during the takeoff roll.Jan 6, 2012 · N127AK · Substantial damageNTSB CEN12CA132Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Del Norte, COThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion. Contributing to the accident were the sensitivity of the brake system and the certified flight instructor pilot's delayed remedial action.Jan 2, 2012 · N9952Q · Substantial damageNTSB CEN11CA284Accident · No injuriesData collectionFinal reportPiper PA38 · Peyton, COThe pilot's loss of directional control during landing.Apr 13, 2011 · N107WC · Substantial damageNTSB CEN11CA031Accident · No injuriesData collectionFinal reportBeech A36 · Pagosa Springs, COThe pilot's improper flare, which resulted in a hard landing.Oct 14, 2010 · N4979M · Substantial damageNTSB CEN10CA444Accident · No injuriesData collectionFinal reportBrewster Fleet 7-220 · Manzanola, COA collision with a hidden obstruction during the landing roll.Jul 28, 2010 · N798V · Substantial damageNTSB CEN10CA439Accident · No injuriesData collectionFinal reportBeers Tailwind 10 · Delta, COA loss of control on the ground due to a malfunction of the right brake caliper.Jul 26, 2010 · N375JX · Substantial damageNTSB CEN10CA327Accident · Minor injuriesData collectionFinal reportRose-Rhinehart A4-C · Longmont, COA loss of engine power due to fuel starvation as a result of the pilot's failure to open the fuel valve, resulting a loss of engine power after takeoff. Contributing to the accident was the pilot's overall lack of experience in the airplane make/model.Jun 19, 2010 · N14884 · 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 CEN09CA530Accident · No injuriesData collectionFinal reportCessna 172 · Centennial, COThe pilot's failure to maintain directional control of the airplane during the landing flare in crosswind conditions.Aug 16, 2009 · N22265 · Substantial damageNTSB CEN09CA489Accident · Minor injuriesData collectionFinal reportCessna 182P · Gateway, COThe pilot's inability to maintain directional control due to soft runway conditions.Aug 2, 2009 · N61TM · Substantial damageNTSB CEN09CA047Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Lamar, COThe student pilot's failure to maintain directional control during landing.Nov 1, 2008 · N3758P · 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 DFW08CA175Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Pueblo, COThe pilot's failure to maintain directional control during landing. Contributing to the accident were the wind gust and tailwind.Jun 28, 2008 · N2879T · Substantial damageNTSB DEN08LA070Accident · No injuriesLimited investigationFinal reportCessna 180H · Glenwood Spring, COThe pilot's failure to maintain directional control of the airplane during landing. Contributing to the accident was the strong left quartering tailwind and gust.Mar 18, 2008 · N67WW · Substantial damage