NTSB investigations: Lycoming 0-320 series, CO

416 cases on aircraft whose registry engine model is Lycoming 0-320 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508'))
  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 CEN10LA198Accident · No injuriesLimited investigationFinal reportAmerican Champion 7KCAB · Greeley, COAn in-flight failure of the wing fabric for undetermined reasons.Feb 23, 2010 · N5065X · Substantial damageNTSB CEN09CA459Accident · Minor injuriesData collectionFinal reportCessna 172P · Usafa, COThe pilot's failure to maintain a safe flying airspeed resulting in an inadvertent stall during the go-around.Jun 27, 2009 · N52298 · Substantial damageNTSB CEN09CA376Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Fort Collins, COThe pilot's failure to maintain control of the airplane during a crosswind landing. Contributing to the accident was the instructor's delayed action in regaining control of the airplane.Jun 22, 2009 · N5824D · Substantial damageNTSB CEN09CA181Accident · No injuriesData collectionFinal reportCessna 172N · Broomfield, COThe pilot and airplane's inability to compensate for the unforecasted gusting wind conditions.Feb 26, 2009 · N737KR · Substantial damageNTSB CEN09CA085Accident · No injuriesData collectionFinal reportDavis Daniel T Cozy · Monte Vista, COThe flight instructor's failure to maintain control of the airplane during landing.Nov 15, 2008 · N149CZ · Substantial damageNTSB CEN09CA079Accident · No injuriesData collectionFinal reportPiper PA18-150 · Colorado Springs, COLoss of directional control due to an encounter with a weather phenomena at rotation.Nov 2, 2008 · N18338 · 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 CEN09LA035Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Broomfield, COThe pilot's failure to maintain control of the airplane, resulting in an inadvertent stall, during a landing attempt. Contributing to the accident was the gusty crosswinds.Oct 24, 2008 · N64055 · DestroyedNTSB DEN08FA152Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Baxter Pass, COThe pilot's failure to maintain adequate airspeed during a turn, resulting in an unrecoverable aerodynamic stall.Sep 7, 2008 · N26930 · DestroyedNTSB DFW08CA200Accident · No injuriesData collectionFinal reportCurtiss-Wright 12Q · Erie, COFailure of the tail wheel control cable during landing roll out, which resulted in a loss of control.Jul 27, 2008 · N496W · Substantial damageNTSB DEN08CA025Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cortez, COThe passenger's inadvertent application of brakes, causing the airplane to nose over on landing. A contributing factor was the pilot's failure top adequately brief the passenger.Nov 5, 2007 · N6ZT · Substantial damageNTSB DEN08LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Canon City, COthe failure of the landing gear hinge point attachment for undetermined reasons.Oct 29, 2007 · N2736P · Substantial damageNTSB DEN08CA020Accident · No injuriesData collectionFinal reportCessna 172N · Grand Junction, COthe pilot's improper flare resulting in a hard landing.Oct 24, 2007 · N1422E · Substantial damageNTSB DEN08CA002Accident · Minor injuriesData collectionFinal reportCessna 172N · Calhan, COThe student pilot's failure to maintain directional control during the takeoff roll.Oct 4, 2007 · N2263E · Substantial damageNTSB DEN07LA108Accident · 2 fatalLimited investigationFinal reportSchwarz RV-6A · Greeley, COthe pilot's failure to maintain airspeed resulting in an inadvertent stall and impact with terrain.Jun 25, 2007 · N94KA · DestroyedNTSB DEN07CA007Accident · Minor injuriesData collectionFinal reportHuff Acro Sport I · Delta, COthe pilot's failure to select a touchdown point a safe distance from the construction crew, and his failure to maintain directional control of the airplane. Contributing factors in this accident included the pilot's limited forward visibility when the…Oct 11, 2006 · N511SH · Substantial damageNTSB DEN06CA084Accident · No injuriesData collectionFinal reportMalott Mustang II · Peyton, COthe pilot's failure to maintain control of the airplane. A contributing factor was the wind gust.Jun 10, 2006 · N299TL · Substantial damageNTSB DEN06CA071Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Rangely, COthe pilot's inadvertent application of the brake during the landing roll. A contributing factor was the pilot's failure to maintain directional control and the flight instructor's inadequate supervision during the landing.May 3, 2006 · N6946B · Substantial damageNTSB DEN06CA033Accident · No injuriesData collectionFinal reportCessna 172M · Denver, COthe pilot's failure to align the airplane's nose into the direction of the wind while performing the pre-takeoff checklist. A contributing factor was the gusty wind conditions.Jan 18, 2006 · N1322U · Substantial damageNTSB DEN06CA030Accident · No injuriesData collectionFinal reportAppel Mustang II · Erie, COthe pilot's inadequate preflight decision to depart in gusty winds, and the pilot's failure to maintain direction control during the departure roll. The high gusty crosswind contributed to the accident.Jan 6, 2006 · N747MD · Substantial damageNTSB DEN06LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Cortez, COthe pilot's failure to maintain directional control of the airplane, resulting in a ground loop. Contributing factors were the excessive descent rate, the obstacle (horse), the high density altitude, and the tailwind.Oct 26, 2005 · N4055Z · Substantial damageNTSB DEN05LA093Accident · No injuriesLimited investigationFinal reportCessna 172N · Hudson, COThe flight instructor's improper use raising of the flaps. Contributing factors were the student pilot's misunderstanding of the instructor's intentions, the instructor's inadequate supervision of the student pilot, the density altitude, and the soft terrain.Jun 19, 2005 · N733RL · Substantial damageNTSB DEN05LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Loveland, COThe dual student's improper flare and the flight instructor's inadequate supervision.. A contributing factor was the inadequate communication between the flight instructor and the dual student,Feb 2, 2005 · N618MN · Substantial damageNTSB DEN05LA041Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Steamboat Spngs, COthe loss of engine power due to carburetor icing. Contributing factors include the conditions conducive for carburetor icing, the lack of suitable terrain for a forced landing, the inadequate preflight planning and decision making and the fence.Dec 18, 2004 · N78AT · Substantial damageNTSB DEN05LA031Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe student pilot's failure to maintain directional control during landing.Dec 4, 2004 · N55250 · Substantial damageNTSB DEN05LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Loveland, COthe student pilot's failure to maintain directional control during landing and the student pilot's inadequate in-flight planning and decision making. Contributing factors include the quartering tail wind, the high airspeed, and the airport sign.Nov 16, 2004 · N54165 · Substantial damageNTSB DEN05LA017Accident · Serious injuriesLimited investigationFinal reportMiller Vans RV4 · Dotsero, COthe pilot's improper in-flight planning and decision making and the loss of engine power due to carburetor ice. Contributing factors include the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.Oct 31, 2004 · N25HM · DestroyedNTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.Aug 9, 2004 · N911JR · DestroyedNTSB DEN04LA081Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Peyton, COthe pilot's inadequate in-flight planning and decision making and his failure to maintain aircraft control during the landing flare which resulted in impact with terrain. Contributing factors include the pilot's failure to perform a go-around and the wind…May 26, 2004 · N4173Y · Substantial damageNTSB DEN04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Lyons, COa loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing and the road sign.Apr 24, 2004 · N5048E · Substantial damageNTSB DEN04LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glade Park, COthe pilot's inadequate in-flight planning/decision. Contributing factors include the pilot's selection of unsuitable terrain for landing and the snow covered terrain.Jan 8, 2004 · N57534 · Substantial damageNTSB DEN03LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COthe right seat shifting aft during the take off roll, rendering aircraft control not possible by the flight instructor. Contributing factors include the inboard seat pin which did not engage fully, the outboard seat pin which was installed incorrectly, the…Jul 17, 2003 · N98969 · Substantial damageNTSB DEN03LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Colo. Springs, COthe student pilot's failure to obtain and maintain adequate altitude during the go-around. Factors contributing to the accident were the encountered windshear, the student pilot's premature raising of the flaps, the instructor pilot's inadequate supervision,…Apr 26, 2003 · N54202 · Substantial damageNTSB DEN03MA035Accident · 5 fatalMajor investigationFinal reportPiper PA-31T · Denver, COBoth pilots' inadequate visual lookout. A contributing factor was the Cheyenne pilot operating the airplane with a known transponder deficiency.Jan 25, 2003 · N360LL · 2 aircraft · DestroyedNTSB DEN03LA003Accident · No injuriesLimited investigationFinal reportCessna 172P · Broomfield, COthe pilot misjudging the clearance between the airplane and a fixed object during taxi. Contributing factors were the pilot's attention being diverted and sunglare.Oct 6, 2002 · N65312 · Substantial damageNTSB DEN02FA106Accident · 1 fatalField investigationFinal reportBeech B19 · Delta, COthe pilot's failure to properly plan and compensate for the high density altitude conditions, resulting in partial engine power during takeoff, his failure to abort the takeoff, and his failure to maintain aircraft control on initial climb. Contributing…Sep 14, 2002 · N5119R · DestroyedNTSB DEN02LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · Fort Collins, COthe student pilot's failure to maintain aircraft control and subsequent inadvertent stall/mush into terrain during a soft field take off. Contributing factors include the pilot's lack of experience and the high density altitude conditions.Jul 31, 2002 · N5088K · Substantial damageNTSB DEN02FA084Accident · 1 fatalField investigationFinal reportCessna 172K · Greeley, COthe student pilot's improper handling of the airplane's controls (for reason undetermined), and the inadequate supervision of the flight instructor. A contributing factor was the high density altitude weather condition.Jul 31, 2002 · N7383G · DestroyedNTSB DEN02LA063Accident · 1 fatalLimited investigationFinal reportRich RV-4 · Grand Junction, COthe pilot failing to maintain aircraft control during the pull up maneuver. A factor relating to the accident was the inadvertent stall spin.Jun 30, 2002 · N3344E · DestroyedNTSB DEN02LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Telluride, COthe pilot not maintaining proper aircraft control resulting in a hard landing. Factors contributing to this accident were the high airspeed, the porpoise encountered during the landing, and the pilot's delayed remedial action resulting in the damage to the…Jun 19, 2002 · N9089H · Substantial damageNTSB FTW02LA101Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Lamar, COthe pilot's delay in taking immediate remedial action after the flight encountered icing conditions, which resulted in a collision with terrain. A contributing factor to the accident was the icing condition.Mar 24, 2002 · N9265L · Substantial damageNTSB SEA02LA047Accident · No injuriesLimited investigationFinal reportCessna 172N · Longmont, COThe student pilot's failure to maintain directional control during landing. Factors included the student pilot's lack of experience, an icy runway, and a mound of snow adjacent to the runway.Mar 3, 2002 · N5413J · Substantial damageNTSB DEN02LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors were the crosswind and the pilot's fatigue from lack of sleep.Feb 17, 2002 · N4642J · Substantial damageNTSB FTW02LA063Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain clearance with the trees and mountainous terrain while maneuvering. A contributing factor was the pilot's delay in taking remedial action.Jan 9, 2002 · N3535E · Substantial damageNTSB DEN02FA017Accident · 1 fatalField investigationFinal reportCessna 172K · Boulder, COthe pilot's intentional suicidal flight into terrain. Contributing factors were the pilot's psychological depressive state, and his use of inappropriate medication.Jan 5, 2002 · N78035 · DestroyedNTSB DEN02LA005Accident · No injuriesLimited investigationFinal reportIrwin Thorp T-18 · Longmont, COThe loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landingOct 26, 2001 · N2819L · Substantial damageNTSB DEN02LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Colo Springs, COthe pilot's inadequate landing flare, which resulted in a hard landing. A contributing factor was the pilot's excessive airspeed on final approach.Oct 8, 2001 · N2364E · Substantial damageNTSB DEN01LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Peyton, COThe pilot's improper go-around procedure and his failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was the pilot's lack of total experience.Aug 15, 2001 · N733BW · Substantial damageNTSB DEN01LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Akron, COthe pilot's failure to adequately compensate for wind conditions, resulting in a loss of directional control during landing roll. A contributing factor was the crosswind.Jun 6, 2001 · N2970P · Substantial damageNTSB DEN01FA111Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · Meeker, COthe pilot's failure to maintain terrain clearance as a result of his drug induced impairment. A factor was his exceeding the airplane's gross weight limits.May 29, 2001 · N5999V · Destroyed