Fatal NTSB investigations: Lycoming 0-235 series

356 cases on aircraft whose registry engine model is Lycoming 0-235 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505'))
  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 CEN12FA594Accident · 2 fatalField investigationFinal reportPiper PA-12 · Rye, COThe pilot’s selection of a flightpath toward rising terrain that exceeded the climb capability of the airplane.Aug 31, 2012 · N3031M · Substantial damageNTSB WPR12FA378Accident · 2 fatalField investigationFinal reportAircraft Mfg & Development CH 2000 · Nephi, UTThe pilot's inability to maintain airplane control due to an encounter with a microburst/downdraft that exceeded the climb performance capabilities of the airplane.Aug 30, 2012 · N651AM · Substantial damageNTSB CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…Aug 25, 2012 · N5796L · Substantial damageNTSB ERA12FA280Accident · 1 fatalField investigationFinal reportManzitto Michael A Mwlancair 235 · Hudson, KYThe pilot's decision to operate the airplane with known electrical system problems, which resulted in the in-flight failure of the electrical wiring interconnect system, loss of electrical power, and subsequent fuel starvation and loss of engine power.Apr 14, 2012 · N235MW · Substantial damageNTSB WPR11FA383Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Silver Bow, MTThe pilot's failure to maintain airplane control while maneuvering.Aug 15, 2011 · N2584N · Substantial damageNTSB WPR11FA344Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Corona, CAAn aggressive flight maneuver performed by the pilot during low altitude flight, which resulted in an aerodynamic stall.Jul 23, 2011 · N34299 · Substantial damageNTSB ANC11FA065Accident · 1 fatalField investigationFinal reportPiper PA-12 · Delta, AKThe pilot's decision to make a low-altitude turn back to the airport following a loss of engine power, which resulted in an aerodynamic stall and loss of control. Contributing to the severity of the pilot's injuries was the separation of the pilot's seat…Jul 17, 2011 · N92770 · Substantial damageNTSB ERA11FA332Accident · 2 fatalField investigationFinal reportCessna 152 · Vero Beach, FLThe pilot’s failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall and subsequent spin.Jun 9, 2011 · N48869 · Substantial damageNTSB WPR10FA325Accident · 1 fatalField investigationFinal reportCessna 152 · Venice, CAThe pilot's failure to maintain adequate airspeed and airplane control during initial climb, which resulted in an aerodynamic stall/spin and subsequent impact with the ground.Jul 2, 2010 · N94838 · Substantial damageNTSB ERA10LA277Accident · 1 fatalLimited investigationFinal reportRutter Herbert G Long EZ · Wakefield, VAThe pilot’s failure to properly align the airplane with the final approach path to the runway and his subsequent loss of control during his attempts to correct the flight path. Contributing to the accident was the pilot’s progressive cognitive decline due to…May 21, 2010 · N91HR · Substantial damageNTSB WPR10FA078Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Ojai, CAAirspeed was not maintained, which resulted in a loss of control and the airplane entering into a stall/spin to the ground. Contributing to the accident was a loss of engine power due to carburetor icing.Dec 10, 2009 · N2463K · Substantial damageNTSB CEN09LA597Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Columbia, MOThe pilot's continued visual flight into instrument meteorological conditions, which included low ceilings and fog, and his failure to maintain control of the airplane. Contributing to the accident was the partial loss of engine power as a result of water…Sep 22, 2009 · N3234M · Substantial damageNTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.Sep 9, 2009 · N94741 · 2 aircraft · Substantial damageNTSB WPR09FA398Accident · 2 fatalField investigationFinal reportCessna 152 · Hesperia, CAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall/spin. Also causal was the failure of the left magneto due to improper assembly of the drive gear during installation on the…Aug 16, 2009 · N67361 · Substantial damageNTSB ERA09LA413Accident · 1 fatalLimited investigationFinal reportCessna 152 · Ponce, PRThe airplane’s impact with water for undetermined reasons.Jul 19, 2009 · N5518P · DestroyedNTSB WPR09LA293Accident · 2 fatalLimited investigationFinal reportChampion 7ECA · Lake Elsinore, CAA loss of airplane control for undetermined reasons.Jun 17, 2009 · N8339V · Substantial damageNTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.May 3, 2009 · N5106T · DestroyedNTSB WPR09FA200Accident · 2 fatalField investigationFinal reportChampion 7ECA · San Jose, CAThe pilot's failure to maintain airspeed while maneuvering within a canyon in mountainous terrain, which resulted in an inadvertent stall/spin.Apr 18, 2009 · N5174X · Substantial damageNTSB ERA09FA235Accident · 1 fatalField investigationFinal reportGrumman AA-1B · Chesnee, SCA loss of engine power in flight due to fuel starvation as a result of the pilot's inadequate inflight fuel planning and the pilot's failure to maintain airspeed while descending for a forced landing.Apr 7, 2009 · N8998L · Substantial damageNTSB CEN09FA195Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Golden, NMThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of alcohol and his subsequent impairment.Mar 9, 2009 · N9646L · DestroyedNTSB ERA09FA060Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIThe pilot's improper descent below the published minimum descent altitude during the approach, which resulted in controlled flight into terrain.Nov 17, 2008 · N2316P · Substantial damageNTSB WPR09LA040Accident · 1 fatalLimited investigationFinal reportCessna 152 · Atwater, CAThe second pilot's failure to see and avoid the rotating propeller after exiting the airplane.Nov 16, 2008 · N45994 · No damageNTSB NYC08LA270Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Brownsboro, ALThe pilot’s failure to ensure the fuel valve was on prior taxi and takeoff. Contributing to the accident was the pilot’s failure to maintain airspeed following loss of engine power due to fuel starvation.Aug 5, 2008 · N7820H · Substantial damageNTSB NYC08FA238Accident · 1 fatalField investigationFinal reportCessna 152 · Rossville, TNUndetermined.Jul 5, 2008 · N5372B · DestroyedNTSB LAX08LA211Accident · 1 fatalLimited investigationFinal reportCessna 152 · Piru, CAThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.Jul 2, 2008 · N25490 · DestroyedNTSB NYC08FA189Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Philadelphia, PAThe flight instructor's failure to maintain airspeed which resulted in an inadvertent stall.May 22, 2008 · N9555U · DestroyedNTSB NYC08FA054Accident · 2 fatalField investigationFinal reportPiper PA-30 · Parkland, FLBoth pilots' failure to see and avoid the other airplane. Contributing to the accident were the erroneous readouts from the Cessna's altitude encoder.Dec 8, 2007 · N766CC · 2 aircraft · DestroyedNTSB NYC08LA001Accident · 1 fatalLimited investigationFinal reportLambert John G Varieze · Chesapeake, VAA loss of control in flight for undetermined reasons.Oct 3, 2007 · N8VE · DestroyedNTSB CHI07LA195Accident · 2 fatalLimited investigationFinal reportGrumman American AA-1C · Carrollton, OHThe pilot failed to maintain clearance from trees during cruise. Factors were the inadequate preflight planning, the thunderstorm in the area at the time of the accident, and the trees.Jul 5, 2007 · N200JA · Substantial damageNTSB ATL07FA081Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Dawsonville, GAThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, with a low cloud ceiling, over mountainous terrain.Apr 26, 2007 · N9247T · Substantial damageNTSB CHI07LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-22-108 · Ava, MOThe failure of the aileron cable eye splice during cruise flight. Contributing to the accident were improper installation and service of the crimped cable sleeve, which rendered the airplane uncontrollable.Apr 16, 2007 · N4712Z · Substantial damageNTSB ANC06FA080Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cooper Landing, AKThe pilot's failure to maintain adequate airspeed while performing a low level pass, which resulted in an uncontrolled descent and collision with terrain. A factor contributing to the accident was an inadvertent stall.Jun 28, 2006 · N7658H · Substantial damageNTSB LAX06FA200Accident · 2 fatalField investigationFinal reportCessna 152 · Peoria, AZthe failure of both the flight instructor and student pilot to regain control of the airplane in a timely manner during an intentional spin maneuver, resulting in a collision with terrain. A factor in the accident was the instructor's inadequate supervision…Jun 8, 2006 · N627PA · Substantial damageNTSB DFW06LA074Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Forrest City, ARThe pilot's failure to follow proper procedures while attempting to start the engine by hand-proping the engine.Feb 24, 2006 · N9007L · Substantial damageNTSB CHI06LA073Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Pontiac, MIThe excessive bank angle executed by the flight crew and their failure to maintain airspeed during the turn, which led to the inadvertent stall and subsequent impact with the ground. A factor was the low altitude.Jan 27, 2006 · N55CW · DestroyedNTSB NYC06FA025Accident · 1 fatalField investigationFinal reportCessna 172A · Pohatcong, NJThe inadequate visual lookout of the pilots in both airplanes, which resulted in a midair collision during descent.Nov 5, 2005 · N7467T · 2 aircraft · Substantial damageNTSB CHI06FA010Accident · 4 fatalField investigationFinal reportPlavcan Lancair 235 · Rootstown, OHThe failure of both pilots to maintain an adequate visual lookout during cruise flight, which resulted in their failure to see and avoid each other and a midair collision.Oct 14, 2005 · N235U · 2 aircraft · DestroyedNTSB DEN05LA141Accident · 2 fatalLimited investigationFinal reportDenight 100D2 · Hudson, COthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.Sep 16, 2005 · N197D · DestroyedNTSB LAX05FA296Accident · 2 fatalField investigationFinal reportCessna 152 · Lakewood, CAthe certified flight instructor's failure to maintain an adequate airspeed resulting in a stall and loss of control. Also causal was the engine's loss of partial power due to inadequate maintenance, worn spark plugs, worn pistons, and broken piston rings.Sep 11, 2005 · N6565L · DestroyedNTSB SEA05FA181Accident · 2 fatalField investigationFinal reportPiper PA-14 · Challis, IDThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin to the ground. A contributing factor was the pilot's diverted attention while spotting/locating Rocky Mountain Bighorn sheep.Aug 27, 2005 · N5104H · DestroyedNTSB MIA05FA152Accident · 2 fatalField investigationFinal reportBellanca 7ECA · Freeport, FLThe failure of the pilot to maintain airspeed resulting in inadvertent stall, uncontrolled descent, and in-flight collision with terrain.Aug 20, 2005 · N90914 · Substantial damageNTSB SEA05LA134Accident · 1 fatalLimited investigationFinal reportJones Long EZ · Marsing, IDThe pilot's failure to maintain airspeed during landing, and his subsequent delay in attempting a recovery from a bounced landing. A contributing factor was the taxiway berm.Jun 28, 2005 · N58LD · Substantial damageNTSB IAD05FA069Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Levittown, PAThe pilot's improper in-flight planning which resulted in a total loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and uncontrolled…May 28, 2005 · N9346L · Substantial damageNTSB NYC05FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Williamsburg, OHAn improperly installed rudder bumper, which resulted in a rudder jam during spin training and subsequent uncontrolled descent into terrain. A factor was the operator did not comply with the service bulletin.Apr 11, 2005 · N24779 · Substantial damageNTSB DEN05LA060Accident · 2 fatalLimited investigationFinal reportPiel Emeraude CP-305 · Del Norte, COThe pilot's failure to maintain clearance with the terrain for undetermined reasons.Mar 1, 2005 · N9091 · DestroyedNTSB ATL05LA018Accident · 2 fatalLimited investigationFinal reportBellanca Citabria 7ECA · Summerville, SCThe loss of engine power due to undetermined reasons.Oct 30, 2004 · N57388 · Substantial damageNTSB ANC04FA102Accident · 2 fatalField investigationFinal reportPiper PA-12 · Koliganek, AKThe pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an inadvertent stall and an uncontrolled descent.Sep 4, 2004 · N2899M · DestroyedNTSB LAX04FA301Accident · 3 fatalField investigationFinal reportBellanca 7ECA · Malibu, CAThe failure of both pilots to maintain an adequate visual lookout and their failure to see and avoid the other aircraft.Aug 23, 2004 · N53879 · 2 aircraft · DestroyedNTSB CHI04LA112Accident · 1 fatalLimited investigationFinal reportGrumman American AA-1B · Dodge Center, MNThe pilot's failure maintain climb and his failure to maintain clearance from the terrain during initial climb out after takeoff. The aircraft's low altitude, high gusty winds and low level turbulence were contributing factors.Apr 28, 2004 · N9919L · DestroyedNTSB LAX04FA167Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jean, NVThe student pilot's failure to regain control of the aircraft following an upset due to the disconnected primary right aileron control cable. The failure of the company maintenance personnel to detect and correct the improperly secured turnbuckle fitting at…Mar 19, 2004 · N2421D · Destroyed