NTSB investigations: Lycoming 0-320 series, 2006

188 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\") = 2006
    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 MIA06CA134Accident · Minor injuriesData collectionFinal reportCessna 172N · Pensacola, FLThe student pilot's failure to raise the wing flaps for a go-around resulting in the airplane not climbing and an in-flight collision with trees.Sep 3, 2006 · N1210F · Substantial damageNTSB DEN07CA032Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Riverton, WYthe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop.Sep 3, 2006 · N82236 · Substantial damageNTSB CHI06CA253Accident · No injuriesData collectionFinal reportHedeman Tailwind W8 · Platteville, WIThe loss of engine power as a result of the pilot's inadequate preflight which resulted in a blocked fuel vent that led to fuel starvation.Sep 3, 2006 · N4FD · Substantial damageNTSB LAX06CA282Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Auburn, CAthe pilot's failure to comply with weight and balance limitations and failure to attain an adequate airspeed, which resulted in a stall and loss of control.Sep 2, 2006 · N4813T · Substantial damageNTSB LAX06CA281Accident · No injuriesData collectionFinal reportCessna 172P · Spanish Springs, NVthe pilot's failure to initiate a timely go-around and to attain an adequate climb rate. Factors in the accident were the high density altitude and the likely quartering tail wind that may have affected the aircraft's climb gradient.Sep 1, 2006 · N97306 · Substantial damageNTSB NYC06CA217Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · White Lake, NYThe flight instructor's failure to ensure the landing gear was retracted prior to attempting a water landing.Aug 31, 2006 · N6774B · Substantial damageNTSB ANC06CA127Accident · No injuriesData collectionFinal reportCessna 172 · Healy, AKThe pilot's failure to maintain adequate altitude/clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident were rising terrain, and the pilot's low altitude flight.Aug 30, 2006 · N5375R · Substantial damageNTSB NYC06CA213Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Frederick, MDThe flight instructor's delayed remedial action during a hovering autorotation, which resulted in a hard landing and inadvertent dynamic rollover.Aug 28, 2006 · N2649D · Substantial damageNTSB LAX06LA275Accident · 2 fatalLimited investigationFinal reportTerry Tevis RV-6A · Novato, CAThe pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, fog and dark night conditions were factors.Aug 28, 2006 · N312RV · Substantial damageNTSB ANC06CA123Accident · Minor injuriesData collectionFinal reportFrisby CH801 · Palmer, AKThe pilot's inadequate compensation for wind conditions, which resulted in an in-flight collision with trees during takeoff. Factors associated with the accident were wind gusts, and trees bordering the airstrip.Aug 27, 2006 · N801ZA · Substantial damageNTSB SEA06CA170Accident · No injuriesData collectionFinal reportPiper PA-22-20-150 · Auburn, WAThe flight instructor's delayed remedial action during the landing roll in response to the student's loss of directional control, which resulted in a ground loop. A factor associated with the accident was the student's failure to maintain directional control.Aug 24, 2006 · N8042D · Substantial damageNTSB DEN06LA116Accident · 1 fatalLimited investigationFinal reportBaker RV-3AB · Laramie, WYThe in-flight failure of the right wing spar during aerobatic flight. Contributing to the accident was the owner/operator's failure to comply with the service bulletin issued by the kit manufacturer.Aug 24, 2006 · N43EM · DestroyedNTSB CHI06FA275Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Kulm, NDThe non-instrument rated pilot's continued flight into instrument meteorological conditions which resulted in his inadvertent encounter with a thunderstorm and his loss of aircraft control. A factor to the accident was the thunderstorm.Aug 24, 2006 · N9714W · DestroyedNTSB DEN06WA121Accident · No injuriesForeign investigationPiper PA-23-160 · Neresheim, GermanyAug 23, 2006 · N4067P · Substantial damageNTSB ANC06CA124Accident · No injuriesData collectionFinal reportChampion 7GCBC · Clear, AKThe pilot's failure to maintain clearance from trees during the landing flare, which resulted in an in-flight collision with the trees.Aug 20, 2006 · N1655G · Substantial damageNTSB DFW06LA199Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Houston, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Aug 19, 2006 · N82078 · Substantial damageNTSB ATL06CA123Accident · No injuriesData collectionFinal reportCessna 172P · Chester, SCThe CFI's failure to initiate a go-around when he noticed the flight was high and fast during the approach resulting in the flight landing long, overrunning the runway, and colliding with trees. Factors in the accident were a tail wind and a wet runway.Aug 19, 2006 · N51887 · Substantial damageNTSB LAX06LA264Accident · 1 fatalLimited investigationFinal reportSchifferer Breezy RLU-1 · Ramona, CAThe pilot's failure to maintain adequate airspeed during the takeoff climb, that resulted in a stall/spin.Aug 17, 2006 · N577JS · Substantial damageNTSB CHI06CA234Accident · No injuriesData collectionFinal reportBeech 19A · Yankton, SDThe dual student's premature retraction of the flaps during the attempted go-around which resulted in the impact with the ground. The flight instructor's delay in calling for the go-around was an additional cause.Aug 16, 2006 · N6544T · Substantial damageNTSB ANC06CA115Accident · No injuriesData collectionFinal reportPiper PA-18 · Tok, AKThe pilot's failure to compensate for the wind conditions during the takeoff roll, which resulted in a collision with a tree. A factor contributing to the accident was a crosswind.Aug 16, 2006 · N8597D · Substantial damageNTSB ANC06CA111Accident · No injuriesData collectionFinal reportPiper PA-14 · Fairbanks, AKThe pilot's selection of an unsuitable off-airport site for takeoff, which resulted in an on-ground encounter with rough-uneven terrain, a loss of control, and a collision with small trees. Factors associated with the accident were the uneven terrain, and…Aug 15, 2006 · N5402H · Substantial damageNTSB CHI06LA230Accident · 1 fatalLimited investigationFinal reportDix Acro Sport II · Coldwater, MIThe loss of engine power for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the resulting forced landing which resulted in the inadvertent stall and subsequent impact with the ground. The rising terrain was a factor.Aug 12, 2006 · N208BY · Substantial damageNTSB NYC06CA199Accident · No injuriesData collectionFinal reportStampe SV-4C · Taneytown, MDThe collapse of the right main landing gear for an undetermined reason.Aug 9, 2006 · N81RG · Substantial damageNTSB ANC06LA113Accident · Serious injuriesLimited investigationFinal reportSeales Protech PT-2B · Crestview, FLThe pilot's failure to correct for torque/p-factor during takeoff initial climb, which resulted in a loss of control and a collision with trees and a power line. Factors contributing to the accident were the pilot's lack of familiarity with the airplane, and…Aug 9, 2006 · N333PT · Substantial damageNTSB ANC06CA117Accident · No injuriesData collectionFinal reportPiper PA-14 · Talkeetna, AKThe pilot's failure to compensate for wind conditions during the landing roll, which resulted in a loss of control and subsequent collision with a ditch. Factors contributing to the accident were a crosswind, and an inadvertent ground loop.Aug 8, 2006 · N5114H · Substantial damageNTSB CHI06CA261Accident · No injuriesData collectionFinal reportBeech B19 · Eden Prarie, MNThe pilot not maintaining directional control of the airplane during the landing. A factor was the ditch.Aug 7, 2006 · N214RS · Substantial damageNTSB CHI06CA228Accident · No injuriesData collectionFinal reportPiper PA-18 · Waukesha, WIThe pilot's inadequate compensation for the crosswind and failure to maintain directional control which resulted in a groundloop. Factors included the closed runway and the crosswind condition.Aug 7, 2006 · N2396J · Substantial damageNTSB SEA06LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Ontario, ORThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors were the en route high wind condition and the soft terrain.Aug 4, 2006 · N1221P · Substantial damageNTSB LAX06CA253Accident · Serious injuriesData collectionFinal reportCessna 172M · Gasquet, CAthe pilot's selection of a runway favoring tailwind conditions, his delayed decision to go around, and his failure to attain and maintain an adequate airspeed during the aborted landing. Contributing factors were the tailwind and wind shear conditions…Aug 4, 2006 · N5262R · Substantial damageNTSB CHI06FA215Accident · No injuriesField investigationFinal reportManarin/Johnson Lancair IVP · Omaha, NEThe selection of an unsuitable landing area by the pilot of the other airplane, and his failure to maintain separation during landing.Aug 4, 2006 · N330RM · 2 aircraft · Substantial damageNTSB LAX06CA252Accident · No injuriesData collectionFinal reportCessna 172M · San Andreas, CAthe student pilot's improper soft-field takeoff technique and failure to obtain and maintain an adequate airspeed, which resulted in a stall mush. The certificated flight instructor's inadequate supervision of the maneuver was also causal.Aug 3, 2006 · N12626 · Substantial damageNTSB ATL06CA116Accident · No injuriesData collectionFinal reportCessna 172M · Augusta, GAThe pilot's improper flare on landing with excessive altitude resulting in a hard landing.Aug 3, 2006 · N20965 · Substantial damageNTSB ANC06LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKThe possible loss of engine power during takeoff/initial climb for an unknown reason, which resulted in a forced landing in rough terrain and a nose over.Jul 31, 2006 · N738LJ · Substantial damageNTSB NYC06CA189Accident · No injuriesData collectionFinal reportCessna 172P · Poughkeepsie, NYThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a hard landing.Jul 29, 2006 · N97650 · Substantial damageNTSB 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 LAX06LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grass Valley, CAThe loss of available engine power due to vapor lock. A contributing factor was the high temperature.Jul 23, 2006 · N2115R · Substantial damageNTSB DFW06CA192Accident · No injuriesData collectionFinal reportBeech BE23 · Bowie, TXThe student pilot's failure to maintain clearance from trees. Contributing factors were the prevailing crosswind and improper supervision of the flight by the flight instructor.Jul 23, 2006 · N2326Z · Substantial damageNTSB DFW06CA190Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Woodworth, LAThe pilot's failure to maintain clearance from a tree. Contributing factors were the sudden wind shift and the gusty wind conditions.Jul 22, 2006 · N9952W · Substantial damageNTSB CHI06CA198Accident · Minor injuriesData collectionFinal reportSargent Bushby Mustang II · Troy, MIThe pilot's delayed decision to go-around leading to the impact with the fence during the go-around. A factor was the fence.Jul 22, 2006 · N6186C · DestroyedNTSB DFW06FA187Accident · 2 fatalField investigationFinal reportCessna 172N · Petal, MSThe pilot's improper use of flaps, which resulted in an impact with trees during takeoff-initial climb.Jul 19, 2006 · N738KE · DestroyedNTSB CHI06LA190Accident · 1 fatalLimited investigationFinal reportArmpriest Breezy · South Haven, MIThe inadvertent stall by pilot during climb following propeller blade damage from the compartment door separation after takeoff. The low altitude and airspeed not maintained by the pilot were additional causes. Contributing factors were the compartment door…Jul 15, 2006 · N316DA · Substantial damageNTSB NYC06LA179Accident · 1 fatalLimited investigationFinal reportCessna 172N · Pompton Lakes, NJImproper maintenance of the throttle shaft, which resulted in a partial loss of engine power during cruise flight, and subsequent impact with trees during a forced landing.Jul 14, 2006 · N4792D · DestroyedNTSB ATL06CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Griffin, GAThe pilot's failure to maintain direction control of the airplane during the landing roll.Jul 14, 2006 · N546CA · Substantial damageNTSB CHI06CA227Accident · No injuriesData collectionFinal reportCessna 172M · Cahokia, ILThe pilot's inadequate flare. A factor was the night light conditions.Jul 12, 2006 · N1725V · Substantial damageNTSB DFW06CA179Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Georgetown, TXThe flight instructor's inadequate supervision of the flight, which resulted in a loss of engine power due to fuel starvation after the private pilot inadvertently positioned the fuel selector to the OFF position. Contributor factors were the lack of suitable…Jul 10, 2006 · N8164J · 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 CHI06CA185Accident · Minor injuriesData collectionFinal reportCessna 172K · Sullivan, ILThe pilot's misjudged flare and his improper recovery from the bounced landing which led to a loss of directional control and subsequent collision with crops and the ground.Jul 7, 2006 · N7349G · Substantial damageNTSB ANC06CA085Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing roll, and an on ground encounter with terrain. Factors associated with the accident are the pilot's failure to maintain directional control, and…Jul 7, 2006 · N9488D · Substantial damageNTSB CHI06CA180Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Jefferson City, MOThe dual student's excessive landing flare and his failure to maintain adequate airspeed, which resulted in the airplane stalling. A factor to the accident was the flight instructor's delayed remedial action and the runway edge light that the airplane struck.Jul 3, 2006 · N43060 · Substantial damageNTSB NYC06LA167Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Toms River, NJCarburetor icing, and the pilot's delayed application of carburetor heat, which resulted in a loss of engine power, and subsequent force landing. A factor in the accident was carburetor icing conditions.Jul 1, 2006 · N50619 · Substantial damage