NTSB investigations: Lycoming 0-320 series, 2009

155 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 year(c.\"eventDate\") = 2009
    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 WPR09FA428Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Canyonville, ORThe non-instrument-rated and non-certificated pilot’s decision to continue visual flight into instrument meteorological conditions in mountainous terrain, which resulted in controlled flight into terrain.Aug 30, 2009 · N2967P · Substantial damageNTSB ERA09CA493Accident · No injuriesData collectionFinal reportBeech B19 · Thomasville, PAA partial loss of engine power due to a partial blockage of the carburetor fuel inlet filter.Aug 30, 2009 · N6982R · Substantial damageNTSB WPR09LA419Accident · 2 fatalLimited investigationFinal reportJames B. Taplin RV-6 · Orland, CAThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall/spin.Aug 27, 2009 · N43521 · Substantial damageNTSB WPR09FA414Accident · 1 fatalField investigationFinal reportPiper PA-25 · Creswell, ORThe pilot's failure to maintain aircraft control during takeoff for a glider tow operation. Contributing to the accident were the tow pilot's impairment due to marijuana use and the low altitude of the flight that reduced the time available to recover from an…Aug 23, 2009 · N6353Z · Substantial damageNTSB CEN09LA538Accident · 2 fatalLimited investigationFinal reportBrown Joseph B JR RV-6 · Ama, LAThe pilot’s failure to maintain directional control during takeoff.Aug 23, 2009 · N352JB · Substantial damageNTSB CEN09CA537Accident · No injuriesData collectionFinal reportRewey William M CH 801 · Cottage Grove, WIA total loss of engine power during initial climb due to fuel starvation from a blocked fuel screen that resulted from the pilot/owner's inadequate inspection and maintenance of the fuel system.Aug 23, 2009 · N171WR · Substantial damageNTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.Aug 21, 2009 · N6038D · Substantial damageNTSB ERA09LA549Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe student pilot's improper flare, which resulted in a hard landing.Aug 20, 2009 · N64344 · Substantial damageNTSB CEN09CA532Accident · Serious injuriesData collectionFinal reportPiper PA-28-161 · Washington, IAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat in conditions that were conducive to carburetor icing.Aug 16, 2009 · N47539 · Substantial damageNTSB ANC09CA082Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Kaktovik, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a loss of control and collision with terrain.Aug 14, 2009 · N83278 · Substantial damageNTSB WPR09FA379Accident · 2 fatalField investigationFinal reportPiper PA-22-150 · Saint Charles, IDThe pilot’s failure to maintain terrain clearance while maneuvering.Aug 7, 2009 · N6905B · DestroyedNTSB ERA09LA456Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate preflight inspection and failure to ensure an adequate quantity of fuel was available for the flight.Aug 7, 2009 · N20977 · Substantial damageNTSB WPR09LA378Accident · 1 fatalLimited investigationFinal reportGray RV-6 · Caldwell, IDThe pilot's failure to maintain adequate airspeed that led to a stall/spin while maneuvering in the traffic pattern.Aug 1, 2009 · N69KG · DestroyedNTSB CEN09CA479Accident · Serious injuriesData collectionFinal reportPiper PA28-151 · Purcell, OKThe student pilot's failure to see and avoid the power lines.Jul 31, 2009 · N41930 · DestroyedNTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.Jul 30, 2009 · N733BS · Substantial damageNTSB ERA09CA425Accident · Minor injuriesData collectionFinal reportCessna 177 · Towanda, PAThe failure of the pilot to maintain control of the airplane during a go around following a bounced landing.Jul 27, 2009 · N2980X · Substantial damageNTSB CEN09CA455Accident · No injuriesData collectionFinal reportForster SA-300 · Iowa City, IAthe loss of engine power for undetermined reasons.Jul 22, 2009 · N7BT · Substantial damageNTSB CEN09CA453Accident · No injuriesData collectionFinal reportPiper PA28 · Malvern, ARThe pilot's failure to maintain adequate airspeed during the approach to landing.Jul 18, 2009 · N33365 · Substantial damageNTSB ANC09LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Anchorage, AKThe pilot's unfamiliarity with the airport environment, which resulted in his taxiing the airplane onto a no-taxi section of roadway and into a road sign. Contributing to the accident was the pilot's failure to avail himself of additional information that…Jul 18, 2009 · N7136Q · Substantial damageNTSB WPR09CA348Accident · Serious injuriesData collectionFinal reportCessna 172M · Thermopolis, WYThe instructor pilot's failure to ensure that his dual student maintained clearance from the terrain during a dark night visual flight rules descent.Jul 16, 2009 · N5461Q · Substantial damageNTSB CEN09LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Cincinnati, OHThe pilot's loss of situational awareness during the approach to an unfamiliar airport at night and his failure to maintain clearance from the trees. Contributing to the accident was the pilot's lack of familiarity with the airplane's navigational equipment.Jul 15, 2009 · N5519W · DestroyedNTSB CEN09CA437Accident · No injuriesData collectionFinal reportCessna 172K · Pine River, MNThe student pilot's failure to maintain directional control during landing.Jul 13, 2009 · N79908 · Substantial damageNTSB WPR09LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taylor, AZThe loss of engine power for undetermined reasons.Jul 6, 2009 · N5957U · Substantial damageNTSB ERA09LA379Accident · No injuriesLimited investigationFinal reportCessna 172M · Princeton, NJThe partial loss of engine power for undetermined reasons.Jul 4, 2009 · N64178 · Substantial damageNTSB ANC09CA111Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Homer, AKThe pilot's excessive airspeed during approach to compensate for turbulence, resulting in a hard landing and runway overrun.Jul 3, 2009 · N4299Z · Substantial damageNTSB CEN09CA422Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Hibbing, MNThe pilot mistakenly using a closed taxiway for takeoff, which resulted in the airplane striking a construction barricade.Jul 2, 2009 · N88FN · Substantial damageNTSB CEN09LA396Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Shelbyville, INThe partial loss of engine power due to the failure of the mixture control cable. Contributing to the accident was the inadequate maintenance on the airplane and the pilot's decision to operate the airplane in a condition that was not airworthy.Jun 29, 2009 · N9085L · Substantial damageNTSB WPR09FA316Accident · 2 fatalField investigationFinal reportCessna 172M · Rimrock, WAThe pilot's failure to maintain clearance from trees during a go-around. Contributing to the accident was the pilot's lack of flight experience, and his delayed initiation of a go-around.Jun 28, 2009 · N4396R · Substantial damageNTSB ERA09CA553Accident · No injuriesData collectionFinal reportChampion 7GCAA · Ware, MAThe pilot's failure to maintain control of the airplane during landing.Jun 27, 2009 · N1879G · 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 WPR09CA305Accident · Minor injuriesData collectionFinal reportCessna 172M · McCall, IDA total loss of engine power during descent due to fuel exhaustion as a result of the pilot's failure to determine the fuel quantity prior to departure.Jun 22, 2009 · N12463 · Substantial damageNTSB CEN09TA374Accident · Minor injuriesFinal reportPiper PA-18-150 · Alpine, TXThe pilot's failure to maintain control of the aircraft.Jun 22, 2009 · N2320P · 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 CEN09CA373Accident · Serious injuriesData collectionFinal reportCessna 172N · Marysville, OHThe pilot's inability to maintain directional control of the airplane during the landing roll for undetermined reasons.Jun 22, 2009 · N734EN · Substantial damageNTSB WPR09CA304Accident · No injuriesData collectionFinal reportStucker Virgil A Avid Magnu · Emmett, IDThe pilot's improper landing flare and recovery from a bounced landing.Jun 21, 2009 · N777DV · Substantial damageNTSB ERA09LA360Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Del Ray Beach, FLAn in-flight failure of the main drive vee belts.Jun 21, 2009 · N2306T · Substantial damageNTSB ERA09LA358Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Plymouth, MAThe CFI's inadequate preflight planning and delay to abort the takeoff from the soft takeoff area.Jun 20, 2009 · N29496 · Substantial damageNTSB ANC09CA054Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing.Jun 7, 2009 · N82057 · Substantial damageNTSB ERA09CA314Accident · Minor injuriesData collectionFinal reportPiper PA-22 · Aurora, WVThe pilot’s inadequate preflight planning and preparation which resulted in a low fuel condition requiring an off-airport landing.May 31, 2009 · N4824A · Substantial damageNTSB ERA09LA310Accident · No injuriesLimited investigationFinal reportCessna 172M · Sarasota, FLA loss of engine power for undetermined reasons.May 30, 2009 · N12151 · Substantial damageNTSB CEN09CA327Accident · No injuriesData collectionFinal reportCessna 177 · Houston, TXA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight fuel planning.May 30, 2009 · N2872X · Substantial damageNTSB CEN09LA329Accident · Serious injuriesLimited investigationFinal reportJohnston Coyt E T-18 · Granbury, TXThe pilot's failure to maintain directional control during landing.May 29, 2009 · N118TX · Substantial damageNTSB ERA09LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Jasper, ALA total loss of engine power due to fuel starvation as a result of the flight instructor's improper fuel management.May 26, 2009 · N1669H · Substantial damageNTSB ERA09CA301Accident · No injuriesData collectionFinal reportCessna 172N · Tunkhannock, PAThe pilot's failure to attain the proper touchdown point while landing with a tailwind.May 21, 2009 · N9492E · Substantial damageNTSB CEN09CA320Accident · No injuriesData collectionFinal reportBeech B19 · Winsted, MNThe student pilot's improper flare during the soft-field landing. Contributing to the accident was the flight instructor's inadequate supervision during the landing.May 21, 2009 · N3214L · Substantial damageNTSB WPR09FA248Accident · 3 fatalField investigationFinal reportCessna 172N · Long Beach, CAThe failure of both pilots to see and avoid each other's aircraft.May 19, 2009 · N738NN · 2 aircraft · Substantial damageNTSB WPR09FA246Accident · Minor injuriesField investigationFinal reportCessna 172 · Burlington, WAThe failure of the pilot of another airplane to maintain adequate visual lookout during the approach.May 17, 2009 · N70323 · 2 aircraft · Substantial damageNTSB CEN09CA301Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Las Cruces, NMThe pilot's failure to maintain directional control while landing in a crosswind. Contributing to the accident was the pilot's decision to land on a runway with a prevailing crosswind.May 17, 2009 · N8042D · Substantial damageNTSB WPR09LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Desert Center, CAA partial loss of engine power due to low compression from an obstructed intake valve. Contributing to the accident was the pilot’s decision to shut down the engine while in flight.May 16, 2009 · N738LF · Substantial damageNTSB ANC09CA043Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and substantial damage to the airplane.May 15, 2009 · N1999P · Substantial damage