NTSB investigations: Lycoming 0-320 series, OH

426 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\" = 'OH' 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 CHI07CA057Accident · Serious injuriesData collectionFinal reportBarron Thorp T18 · Edinburg, OHThe pilot's improper in-flight decision not to refuel prior to fuel exhaustion. A factor to the accident was the tree line that the airplane impacted during the forced landing.Jan 9, 2007 · N54DT · DestroyedNTSB CHI06CA204Accident · Minor injuriesData collectionFinal reportCessna 172N · Wadsworth, OHThe pilot used an improper aborted takeoff procedure in that she failed to reduce the engine power. Factors associated with the accident were the tailwind, the wrong runway selection, the pilot's lack of experience, the guard rail, and the embankment.Jul 26, 2006 · N739TG · Substantial damageNTSB CHI06CA182Accident · No injuriesData collectionFinal reportCessna 172L · Waterford, OHThe pilot's selection of unsuitable terrain for landing. The runway's downhill slope, the wet grass, the fence, and the embankment were factors.Jul 8, 2006 · N7805G · Substantial damageNTSB CHI06CA151Accident · No injuriesData collectionFinal reportCessna 172N · Athens, OHThe student pilot's inadequate compensation for the wind conditions. Factors associated with the accident were the gusty crosswind, and the ditch.Jun 9, 2006 · N240U · 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 IAD05LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Marysville, OHThe pilot's failure to maintain directional control during landing.Jun 26, 2005 · N80802 · Substantial damageNTSB NYC05FA086Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edinburg, OHThe pilot's failure to maintain aircraft control.May 22, 2005 · N217AW · Substantial damageNTSB NYC05CA073Accident · No injuriesData collectionFinal reportCessna 172N · Wellington, OHThe pilot's failure to obtain the proper touchdown point, and his failure to initiate a go-around, which resulted in an overrun during landing. A factor in the accident was the tail wind.Apr 17, 2005 · N1086F · Substantial damageNTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.Mar 13, 2005 · N6511L · DestroyedNTSB NYC05LA033Accident · 3 fatalLimited investigationFinal reportCessna 172N · Mount Gilead, OHThe pilot's failure to maintain control of the airplane following an inadvertent encounter with instrument meteorological conditions. A factor in the accident was the rapidly deteriorating weather.Dec 30, 2004 · N737AZ · Substantial damageNTSB NYC05LA002Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Harrison, OHThe Cessna 152 pilot's improper traffic pattern procedure and improper radio communication, which resulted in a mid-air collision with a Cessna 172. A factor in the accident was both pilots' failure to maintain an adequate visual lookout.Oct 10, 2004 · N68298 · 2 aircraft · Substantial damageNTSB NYC04LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Medina, OHThe partial loss of engine power due to inadequate maintenance and by failure to comply with service instruction for low engine compression.Sep 10, 2004 · N172WW · Substantial damageNTSB NYC04FA171Accident · 1 fatalField investigationFinal reportCessna 172M · Brookville, OHThe student pilot's control interference while the flight instructor was maneuvering to avoid a tree, which resulted in a failure to maintain airspeed and a stall/mush.Jul 18, 2004 · N9731V · Substantial damageNTSB NYC04CA076Accident · No injuriesData collectionFinal reportCessna 172N · Youngstown, OHAn inadvertent collision with a deer while landing.Feb 23, 2004 · N738EK · Substantial damageNTSB NYC04CA028Accident · No injuriesData collectionFinal reportCessna 172K · Kilbourne, OHThe pilot's failure to obtain the proper touchdown point which resulted in an overrun and subsequent nose over.Nov 8, 2003 · N78203 · Substantial damageNTSB NYC03LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot under instruction's failure to maintain directional control, and the flight instructor's delayed remedial action.Mar 23, 2003 · N2968Z · Substantial damageNTSB NYC03LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Cincinnati, OHThe student pilot's failure to maintain directional control.Feb 26, 2003 · N733XP · Substantial damageNTSB IAD03LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · New Middleton, OHA jammed throttle control assembly for undetermined reasons.Jan 11, 2003 · N573PA · Substantial damageNTSB NYC02LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Huron, OHThe dual student's inadvertent shutdown of the engine and the certified flight instructor's inadequate supervision. A factor was the lack of suitable terrain.Jun 18, 2002 · N5369W · Substantial damageNTSB IAD02LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Port Columbus, OHThe pilot's exhaustion of his fuel supply. A factor in the accident was the pilot's inadequate preflight planning.May 16, 2002 · N75303 · Substantial damageNTSB NYC02LA075Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Mount Vernon, OHThe pilot's failure to maintain directional control while landing.Mar 27, 2002 · N961CL · Substantial damageNTSB NYC02LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Ravenna, OHThe student pilot's failure to maintain directional control.Dec 8, 2001 · N12521 · Substantial damageNTSB NYC01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kenton, OHThe pilot's failure to stop the airplane within the available runway. Factors included the uneven braking and the pilot's lack of experience in airplane make and model.Sep 22, 2001 · N7630D · Substantial damageNTSB NYC01LA185Accident · No injuriesLimited investigationFinal reportCessna 172 · Dayton, OHThe pilot excessive flare, which resulted in a hard landing.Jul 23, 2001 · N52012 · Substantial damageNTSB IAD01LA101Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Columbus, OHThe pilot's loss of control after turning his head into the slipstream outside of the helicopter.Jul 2, 2001 · N9077Q · Substantial damageNTSB IAD01LA071Accident · Serious injuriesLimited investigationFinal reportRobinson R-22A · Atwater, OHThe pilot's improper remedial response to a dynamic rollover event, which resulted in the helicopter rolling over on its side.Jun 16, 2001 · N2242P · Substantial damageNTSB NYC01LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe pilot's failure to attain the proper touchdown point. Factors included the nighttime conditions, and the pilot's improper decision to leave the runway lighting at high intensity.Feb 9, 2001 · N62332 · Substantial damageNTSB NYC01LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Lebanon, OHThe flight instructor's failure to maintain aircraft control during an aborted takeoff. A factor in the accident was a partial loss of engine power.Nov 28, 2000 · N5035W · Substantial damageNTSB NYC00LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot's improper recovery from a bounced landing.Aug 14, 2000 · N2968Z · Substantial damageNTSB NYC00LA203Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Columbus, OHa partial power loss for undetermined reason(s).Jul 19, 2000 · N80624 · Substantial damageNTSB IAD00LA050Accident · Serious injuriesLimited investigationFinal reportBakeng Double Deuce · West Alexandria, OHthe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's failure to properly brief/communicate transfer of the flight controls to the pilot-rated passenger.Jun 11, 2000 · N1056G · Substantial damageNTSB NYC00LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Miamisburg, OHThe CFI's delayed remedial action.Jun 2, 2000 · N8234L · Substantial damageNTSB NYC00LA107Accident · Minor injuriesLimited investigationFinal reportPagan RV-8A · East Liverpool, OHThe pilot's loss of control during the landing.Apr 1, 2000 · N565BW · Substantial damageNTSB NYC00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Parkertown, OHThe inadequate visual lookout by the pilots of both airplanes.Feb 15, 2000 · N8264G · 2 aircraft · Substantial damageNTSB NYC00LA049Accident · No injuriesLimited investigationFinal reportCessna 172L · Wooster, OHThe pilot's inadvertent taxi onto unsuitable terrain. A factor was the burnt out landing/taxi light.Dec 8, 1999 · N7565G · Substantial damageNTSB NYC99LA137Accident · No injuriesLimited investigationFinal reportCessna 172 · Ravenna, OHThe pilot-in-command's failure to maintain aircraft control during landing.Jun 11, 1999 · N62953 · Substantial damageNTSB NYC99LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Alliance, OHThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were the crosswind conditions and wind gusts.May 29, 1999 · N9654W · Substantial damageNTSB IAD99LA001Accident · No injuriesLimited investigationFinal reportCessna 172K · Middlefield, OHThe pilot's inadequate preflight inspection which resulted in fuel exhaustion.Oct 2, 1998 · N78624 · Substantial damageNTSB IAD98LA087Accident · No injuriesLimited investigationFinal reportCessna 172N · Lebanon, OHThe pilot's delay in aborting the landing, which resulted in inadequate obstacle (car) clearance during initial takeoff climb. A contributing factor is the pilot's decision to perform a tailwind landing.Aug 1, 1998 · N733LK · Substantial damageNTSB NYC98LA067Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Brookville, OHThe pilot's misjudgment of the fuel supply.Feb 22, 1998 · N5625L · DestroyedNTSB NYC98LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Middlefield, OHloss of engine power for undetermined reasons.Nov 25, 1997 · N1816J · Substantial damageNTSB IAD97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Zanesville, OHThe pilot's failure to perform the published short/soft field takeoff procedures.Sep 27, 1997 · N6308W · DestroyedNTSB IAD97LA116Accident · Minor injuriesLimited investigationFinal reportBeech Musketeer 23 · Wauseon, OHThe pilot's fuel mismanagement by his failure to switch fuel tank positions, which resulted in the fuel starvation and the loss of engine power.Aug 31, 1997 · N2372L · Substantial damageNTSB NYC97LA096Accident · No injuriesLimited investigationFinal reportCessna 172M · Galion, OHThe inadvertent encounter with the helicopter main rotor downwash during the initial takeoff climb. Subsequently, the airplane descended and impacted the ground.May 18, 1997 · N4430R · Substantial damageNTSB NYC97LA087Accident · Minor injuriesLimited investigationFinal reportPitts S1C · Salem, OHthe pilot's failure to maintain aircraft control during the initial takeoff climb. Factors relating to the accident were the pilot's lack of experience in the make and model of airplane, and the gusty crosswind conditions.May 7, 1997 · N12073 · Substantial damageNTSB NYC97LA086Accident · No injuriesLimited investigationFinal reportCessna 177 · Lancaster, OHThe flight instructor's inadequate supervision and his failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway and striking the precision approach path indicator lights.Apr 30, 1997 · N2921X · Substantial damageNTSB IAD97LA059Accident · No injuriesLimited investigationFinal reportCessna 172M · Cincinnati, OHthe pilot's inadequate compensation for wind conditions and failure to maintain directional control during takeoff, which resulted in a collision with tree(s) and a ditch.Mar 31, 1997 · N73455 · Substantial damageNTSB NYC97LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Middletown, OHthe pilot's improper decision to taxi on a motor vehicle access road at night, and his inadequate visual look out which resulted in the collision with an aluminum lamp post. A factor in this accident was the night condition.Mar 22, 1997 · N733LK · Substantial damageNTSB IAD97LA055Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Harrison, OHthe student pilot's failure to maintain directional control, and his improper operation of the throttle for regain control, which resulted in the airplane veering off the runway and colliding with a tree.Mar 16, 1997 · N737ZC · Substantial damageNTSB IAD97LA046Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHthe pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.Feb 4, 1997 · N62332 · Substantial damage