NTSB investigations: Lycoming 0-320 series, AL
199 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\" = 'AL' 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.
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" = 'AL' 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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ATL02LA154Accident · No injuriesLimited investigationFinal reportCessna 172M · Enterprise, ALThe pilot's delayed flare on landing that resulted in a hard landing.NTSB ATL02LA061Accident · 1 fatalLimited investigationFinal reportMoore Sammie M-Breezy · Pell City, ALThe pilot's failure to maintain flying speed, followed by an inadvertent stall spin, and subsequent collision with terrain.NTSB ATL02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bessemer, ALOn ground collision with an animal during landing.NTSB ATL02LA002Accident · Minor injuriesLimited investigationFinal reportBeech 19 · St Clair Spring, ALThe pilot misjudged the touchdown point that resulted in the runway overrun.NTSB MIA00LA253Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Chatom, ALthe pilot's improper preflight planning/decision and failure to ensure an adequate supply of fuel to safely complete the flight to his destination with adequate fuel reserves, which resulted in fuel exhaustion, subsequent engine failure, and a forced landing…NTSB MIA00LA044Accident · Serious injuriesLimited investigationFinal reportAmerican AA-5 · St. Elmo, ALThe failure of the pilot to maintain airspeed resulting in the in-flight loss of control while maneuvering for a forced landing in a field after the loss of engine power. Contributing factors were the loss of engine power due to water-contaminated fuel.NTSB MIA99LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, ALthe pilot's inadequate preflight planning and preparation, which resulted in taking off with the airplane's maximum gross weight exceeded, and subsequent impact with trees. Factors in this accident were high temperatures and an in-flight encounter with a…NTSB ATL99LA090Accident · No injuriesLimited investigationFinal reportCessna 172M · Double Springs, ALThe pilot's failure to maintain directional control of the aircraft during landing. A factor was the pilot's lack of experience.NTSB MIA98LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Luvurne, ALThe loss of engine power due to a leaking engine oil seal, resulting in a forced landing, and subsequent impact with the ground. A factor in this accident was improper maintenance and checks after rebuilding and reinstalling the airplane's engine.NTSB MIA97LA199Accident · No injuriesLimited investigationFinal reportSloan RV-6 · Muscle Shoals, ALthe pilot's failure to see-and-avoid the bales of hay duirng the takeoff roll, which resulted in an in-flight collision with a bale at liftoff and subsequent in-flight collision with terrain.NTSB MIA97LA102Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Bessemer, ALthe student pilot's misjudged landing flare and the CFI's inadequate supervision by not taking timely remedial action.NTSB MIA96FA185Accident · 1 fatalField investigationFinal reportChampion Aeronca 7GCB · Fairhope, ALfailure of the pilot to maintain adequate airspeed, while manuevering at low altitude, which resulted in an inadvertent stall and uncontrolled impact with the water. The pilot's ostentatious display and the lack of altitude to recover from a stall were…NTSB ATL95LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Meridianville, ALThe failure of the student pilot to maintain directional control of the aircraft.NTSB ATL95LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Orange Beach, ALA loss of engine power for undetermined reasons.NTSB ATL94LA145Accident · No injuriesLimited investigationFinal reportChampion 7-GCBC · Hartford, ALThe pilot's improper use of the wheel brakes.NTSB ATL94LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Hartford, ALThe student pilot's inadequate compensation for gusting wind conditions during the approach to land. Factors were the instructor pilot's inadequate supervision of his student, the gusting wind conditions, and the trees located in close proximity to the runway.NTSB MIA93FA058Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brilliant, ALThe pilot-in-command's intentional flight into adverse weather which resulted in a loss of control. In addition, the pilot was overconfident in his ability. Factors which contributed to the accident were the weather conditions and the dark night.NTSB ATL92LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, ALThe pilot's improper landing flare, and his improper recovery from a bounced landing.NTSB ATL92LA041Accident · No injuriesLimited investigationFinal reportCessna 172I · Gadsden, ALThe improper recovery from a bounced landing by the pilot under examination, and his subsequent failure to maintain directional control. Inadequate supervision by the designated examiner was a factor.NTSB ATL90FA095Accident · 2 fatalField investigationFinal reportEmbraer EMB-120 · Gadsden, ALInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid oncoming traffic. A factor related to the accident was: the sun's glare, which restricted the vision of the Cessna 172 pilot.NTSB ATL90LA039Accident · No injuriesLimited investigationFinal reportBeech B19 · Muscle Shoals, ALThe premature flare initiated by the student pilot and the flight instructor's delay in taking remedial action, which led to an inadvertent stall and a hard landing.NTSB ATL88LA201Accident · No injuriesLimited investigationFinal reportCessna 172M · Meridianville, ALThe plt reported that he attempted to make a touch and go ldg at the departure arpt before heading out on the first leg of a cross-country flt. The airplane encountered a gust of wind at touchdown and veered off the side of the rwy. The airplane subsequently…NTSB ATL88LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Butler, ALThe plt rptd that he observed the engine oil pressure indication drop to zero during a low-level pipeline patrol flight. He attempted to increase engine pwr and initiate a climb, but the engine began to run rough. He subsequently landed on the pipeline…NTSB ATL87LA237Accident · No injuriesLimited investigationFinal reportCessna 172 · Jacksonville, ALThe plt departed Jacksonville in VFR conds without obtaining a wx briefing. While en route, she observed thunderstorm activity & elected to return to Jacksonville. By the time she returned, the wx had deteriorated & the wind had shifted to the south. The wind…NTSB ATL87LA206Accident · No injuriesLimited investigationFinal reportCessna 172I · Goodway, ALThe plt rprtd that he lndd long on a 2500 ft grass strip which was wet due to hvy dew. Drg the apch, he had an airspeed of 75 to 80 KTS with 30 deg of flaps. Subsequently, the acft slid off the departure end & struck a pecan tree. The recommended final apch…NTSB ATL87LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Brownsboro, ALThe student pilot was making her first supervised solo flight in the PA28-140 model aircraft. The student reported that wind and low airspeed prevented her from reaching the runway prior to landing touchdown.NTSB ATL86LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Dozier, ALThe private plt and his pax were on a night cross country flt when he ran one fuel tank dry and the eng sputtered. He switched to the other tank and the eng caught for a few seconds then quit. He let down over a heavily forested area and stalled the acft into…NTSB ATL86FKG06Accident · 2 fatalFinal reportBushby Mustang II · Brownsboro, ALThe acft collided with the ground in an inverted attitude during a forced landing after a power loss at 400 ft AGL during takeoff. The acft was observed to turn after the power loss and then the wings leveled. Power was heard to resume at about 100 ft AGL.…NTSB ATL86LA068Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Alexander City, ALThe acft was observed to make one takeoff and landing from an umimproved pasture. The second takeoff attempted was unsuccessful and the acft collided with a tree and crashed to the ground. The plt did not report any mechanical problems with the acft. There…NTSB ATL86LA030Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Gurley, ALAbout 5 min into third flt of the day, the plt reported a loss of power. During the forced ldg roll out in a pasture field acft struck a ditch causing substantial dmg. Exam of engine revealed failed exh. Value. Eng had been operated 2341 hrs without overhaul.NTSB ATL85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Athens, ALThe acft lost pwr while en route from kenosha, WI, to decatur, AL, and attempted a forced landing on an ag strip. Duringthe landing roll the acft struck a truck which was parked in the middle of the runway. During post crash examination of the acft no fuel…NTSB ATL85FA067Accident · 2 fatalField investigationFinal reportRobinson R-22 Alpha · Huntsville, ALA popping sound then a loud noise and a puff of smoke preceded the helicopter's fall to the ground, stated a 12 year old boy who said he saw the accident. Examination of the helicopter failed to disclose any trace of fire. However one main rotor blade…NTSB ATL85LKG02Accident · No injuriesFinal reportCessna 172N · Tuscaloosa, ALThe acft veered to the left during the takeoff ground run. The acft departed the rwy into a soft, plowed field where it momentarily nosed down before coming to rest on the main landing gear.NTSB ATL85LA004Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Ozark, ALThe student plt was on her fourth supervised solo flt. During the ground roll of her fourth landing the acft started to go left of the rwy centerline. The plt said she over corrected twice and ended up heading off the rwy toward a ditch. Inan attempt to…NTSB ATL84LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Leeds, ALThe plt made a flt of about 30 min to practice landings, then landed to pick up 2 passengers. About 10 min after taking off on the 2nd flt, he began having symptoms of a medical problem. He said he felt hot & the air felt stagnant & stale. The vents & a…NTSB ATL84LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Mountain, ALWhile en route, the plt arrived at a check point 18 min behind schedule. Aprx 25 min later, he tuned in an incorrect VOR frequency that he had written down on his flt plan. The station that he tuned in was east of the desired station & the geographic features…NTSB ATL84LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Cullman, ALThe student plt was on his 1st solo flt. During a touch-and-go pattern, he started to takeoff, after landing, with the elevator trim in a nearly full nose-up position. He stated that after he added power to takeoff, he had to hold the nose down by applying…NTSB ATL83LA384Accident · No injuriesLimited investigationFinal reportCessna 172K · Brundidge, ALWhile cruising at 2,000 ft the plt smelled fuel fumes & elected to make a precautionary landing. When within gliding distance of the arpt, he secured the eng with the mixture control & made an uneventful deadstick landing. After exiting the acft he noticed…NTSB ATL83LA309Accident · No injuriesLimited investigationFinal reportCessna 172N · Birmingham, ALThe instructor (CFI) reported the eng began missing when power was applied after practicing stalls. A decision was made to return to the arpt. Carburetor heat was applied & the throttle was retarded to descend. The mixture was in full rich. After a couple of…NTSB ATL83FKJ01Accident · 1 fatalFinal reportCessna 172N · Clanton, ALThe acft was observed in a high speed glide to touch down briefly in a pasture at the top of a knoll. It then dropped below the rise & crashed in a wooded area adjacent to the pasture. Examination of the eng showed a crack extending from the top forward…NTSB ATL82FA195Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Birmingham, ALDuring takeoff, the aircraft collided with rising terrain about 3/10 mile north of runway 36. The pilot reported that the airspeed decayed and the aircraft mushed into the ground. No preimpact malfunction or failure was found. The temperature and dew point…NTSB ATL82FA153Accident · 1 fatalField investigationFinal reportCessna 172M · Alabaster, ALAt 0755, the plt contacted birmingham approach control & reported 35 mi south at 2,000 ft. he was advised of the bhm wx & that it was IFR at the arpt. The pilot stated he would like to land at another arpt & was given his approximate position to three arpts.…NTSB ATL82FA057Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hytop, ALThe pilot filed and departed VFR into forecast marginal flight conditions. While en route the destination went IFR and this information was passed on to the pilot. The pilot replied that he was going to continue on and get as close to chattanooga as possible.…NTSB ATL82FKJ04Accident · No injuriesClosedCessna 172M · Selma, ALNTSB ATL82DKJ02Accident · No injuriesClosedPiper PA-28 · Hurtsboro, ALNTSB ATL81DKJ29Accident · No injuriesClosedCessna 172N · Daviston, ALNTSB MIA80DKJ30Accident · No injuriesClosedCessna 172 · Clayton, ALNTSB MIA80FKJ15Accident · No injuriesClosedCessna 172I · Foley, ALNTSB MIA80FKJ09Accident · Minor injuriesClosedPiper PA-28 · Gadsden, ALNTSB MIA80DKJ05Accident · Serious injuriesClosedCessna 172 · Alexander City, AL