NTSB investigations: Lycoming 0-235 series
4,598 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.\"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.
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."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" 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 LAX82DVM14Accident · Serious injuriesFinal reportCessna 152 · San Carlos, CAThe student pilot was practicing short field landings. On final the pilot lowered the nose of the aircraft and leveled the wings, the nose wheel struck the runway callapsing the nose gear.NTSB NYC82DA108Accident · No injuriesFinal reportCessna 152 · Burlington, CTThe student pilot was on her second supervised solo flight. While landing, she flared high and subsequently landed hard, collapsing the nose gear. The pilot reported that she did not have a good mental attitude since her children had been involved in a car…NTSB DEN82DA097Accident · No injuriesFinal reportCessna 152 · Grand Forks, NDDuring landing, the student pilot bounced and then touched down hard. The nose gear failed and the firewall and propeller were damaged. The fixed base operator reported light turbulence.NTSB MKC82DA084Accident · No injuriesFinal reportCessna 152 · Ainsworth, NEThe pilot elected to taxi on a closed runway that was used to store piles of corn. The pilot stated that a gust of wind forced the aircraft into a pile of corn causing substantial damage to the nose gear. Wind gusts were reported to 22 knots.NTSB FTW82FQA19Accident · Minor injuriesFinal reportPiper PA-16 · Albuquerque, NMBoth of the occupants were rated pilots and had just purchased the aircraft. They were ferrying the plane from new york state to California. The pilot reported that during takeoff, he lifted off near the mid-point of the runway and held a flat attitude to…NTSB NYC82DA093Accident · No injuriesFinal reportPiper PA-38-112 · Endicott, NYDuring takeoff roll the aircraft veered to the left. The pilot stated that he applied right rudder and aileron into the wind, however; the aicraft continued to the left. The pilot then closed the throttle and the aircraft collided with runway lights causing…NTSB FTW82DA170Accident · No injuriesFinal reportCessna 152 · Coahama, TXThe pilot was on a cross country flight for his commercial pilot's license. He became lost, landed in a plowed open field and the aircraft nosed over. There was no evidence of propeller rotation or fuel at the scene of the accident.NTSB MIA82DA117Accident · No injuriesFinal reportPiper PA-38-112 · Gainesville, FLThe student pilot stated that on his third landing, the crosswind was more noticeable. During the landing roll, he lost directional control while he was applying brakes. The aircraft went off the runway, collided with a ditch, and was substantially damaged.NTSB LAX82DA160Accident · No injuriesFinal reportPiper PA-38 · Willcox, AZStudent pilot on first solo cross-country ground looped during an en route landing. The pilot's flight bag had fallen off the right seat and lodged itself between the rudder pedals. Rudder control was lost.NTSB ATL82DA125Accident · No injuriesFinal reportPiper PA-38-112 · Jonesboro, TNAfter utilizing the southwest runway for takeoff and landing the pilot noted that the limp windsock had shifted to indicate use of the northeast runway. The next takeoff was therefore made to the northeast, with an uphill gradient to the runway. After a…NTSB LAX82FA156Accident · Minor injuriesField investigationFinal reportBeech A24R · Camarillo, CAThe pilot took off from the Camarillo airport on a local flight to practice touch and go landings. He had made two touch and go patterns and was on his third and final landing when the collision occurred. He had transmitted his position on downwind and base…NTSB FTW82DA159Accident · Minor injuriesFinal reportPiper PA-18 · Victoria, TXThe pilot tookoff at about 1535 to fly in the local area and then to proceed to his home at edna, TX. He flew to a ball field to observe some friends playing ball. After circling the field 3 times, he applied power and began a climb. He stated that about 30…NTSB CHI82DA138Accident · No injuriesFinal reportCessna 152 · New London, WIThe pilot elected to land on a private strip he was not familiar with. He was not aware of the 3-4 inches of standing water on the sod surface when he touched down. The aircraft nosed over during landing roll.NTSB MKC82DA061Accident · No injuriesFinal reportCessna 152 · Grain Valley, MODuring landing roll the aircraft went off the runway and ended up in a ditch.NTSB MKC82DA060Accident · No injuriesFinal reportPiper PA-38-112 · Dubuque, IAThe student pilot was on a solo cross-country flight. After arriving at Dubuque, he landed on runway 18. The student stated that the wind was from 230 degrees at 16, gusting 23 knots. He reported that during the landing, the plane was lifted off two times by…NTSB CHI82DA136Accident · No injuriesFinal reportBellanca 7ECA · Maple Lake, MNThe pilot lost directional control during landing in strong crosswind conditions with gusts to 22 knots. The aircraft departed the runway and collided with a parked aircraft. The pilot stated that he was not currently proficient in crosswind landing, should…NTSB DEN82DA070Accident · No injuriesFinal reportBellanca 7ECA · Spearfish, SDThe student pilot departed on runway 30 to practice touch and go landings. He immediately entered the traffic pattern for runway 26. He said he made a power on, soft field landing, touching down at 65 knots IAS, and then immediately started a takeoff.…NTSB MIA82DA107Accident · No injuriesFinal reportCessna 152 · New Port Richey, FLThe pilot reported that she landed with 30 degrees of flaps on runway 23. She reported that the wind was gusting from 15 to 20 knots and the wind sock seemed to fluctuate from westerly to northwesterly. The pilot related that the aircraftbounced twice upon…NTSB LAX82DA146Accident · 1 fatalFinal reportPiper PA-38-112 · Apple Valley, CAWitnesses observed the aircraft to be gliding on final approach with the engine at idle when it abruptly pitched nose down and struck the ground. The engine and both leading edges of the wings contacted the ground at the same time with no turning movement.…NTSB MKC82IA047Incident · No injuriesIncident investigationFinal reportCessna 152 · Cottonwood Fall, KSAfter executing two landings on runway 36, the pilot noticed a wind shift from 360 degrees to 260 degrees and he taxied back up the runway and started a takeoff on runway 18. The pilot stated that about 1300 from the departure end of the runway, he…NTSB LAX82FUA13Accident · No injuriesFinal reportCessna 152 · Long Beach, CADuring the landing roll, the nose gear collapsed and the plane veered off the runway. The student pilot and a witness stated that the gear collasped after a normal landing. The nosewheel tire had uneven wear characerics. There was substantial damage to the…NTSB LAX82DA145Accident · No injuriesFinal reportPiper PA-38-112 · Santa Monica, CADuring landing, the student pilot allowed the aircraft to bounce. After about the third bounce, the nose gear buckled and the aircraft skidded off the runway.NTSB FTW82DA124Accident · No injuriesFinal reportCessna 152 · Lafayette, LAEn route to Lafayette, LA on a cross country the engine quit. A forced landing in a soft plowed field caused the landing gear to separate and the aircraft to nose over.NTSB CHI82DA116Accident · No injuriesFinal reportCessna 152 · Pontiac, MIWhile the student pilot was on his fifth touch and go pattern, the plane veered to the left after touchdown. The left main gear then encountered snow and pulled the aircraft further left into a snowbank. The student claimed that the owners had advised him to…NTSB FTW82DA102Accident · No injuriesFinal reportCessna 152 · New Orleans, LAThe student pilot was doing touch and go landings on runway 36. The wind was 290 degrees at 10 KTS. During a landing roll the student lost control and departed the left side of the runway. The aircraft sank into the mud and nosed over.NTSB MIA82DA076Accident · No injuriesFinal reportCessna 152 · Brooksville, FLThe student pilot was on a solo cross-country flight. While landing at an en route airport, he encountered a gusty, right quartering, headwind. During touchdown, the plane bounced and the pilot applied power. However, he was unable to prevent the plane from…NTSB FTW82DA096Accident · Minor injuriesFinal reportPiper PA-38-112 · Farmington, NMThe aircraft lost power during a cross country flight. During the subsequent forced landing on a dirt road the aircraft collided with a ditch and nosed over.NTSB ATL82DA070Accident · Minor injuriesFinal reportCessna 152 · Lusby, MDThe student was on a cross-country flight from leonardtown, MD to cumberland, MD to lancaster, pa and then return to leonardtown. Before takeoff, the student was instructed to refuel at cumberland or lancaster before continuing. The student stated that he had…NTSB LAX82FVD11Accident · No injuriesFinal reportCessna 152 · Navato, CAAfter returning to the airport, the student pilot made one touch and go landing and noticed gusty crosswind conditions. He elected to make the next landing to a full stop. He reported that during the landing flare, he lost control and the aircraft was blown…NTSB LAX82AA106Accident · 6 fatalFinal reportBoeing KC-135A · Glendale, AZThe USAF KC-135 was on an IFR flt plan & executing a tacan 3L apch to luke afb. The AA-1 had departed sky harbour arpt &had been released by phoenix trsa. The AA-1 was heading westerly in airspace designated as a special traffic area & was required to have…NTSB CHI82DA083Accident · No injuriesFinal reportCessna 152 · Milwaukee, WIThe student was practicing touch and go landings on a snow covered runway. After applying power for takeoff during the third touch and go, the aircraft veered left and hit a snowbank.NTSB ANC82DA024Accident · No injuriesFinal reportPiper PA-38-112 · Anchorage, AKStudent pilot rounded out too high,aircraft bounced and became airborne. The student did not apply power and the CFI added power for a go-around. However he stated he waited too long before applying power and the right wing stalled. The aircraft veered right…NTSB NYC82FGT08Accident · 2 fatalFinal reportCessna A152 · Scotland, PAThe aircraft crashed after the pilot made a low pass over runway 13. At the departure end of the runway, the aircraft was observed to pull up into a 40 to 45 degree climb, then stall and enter a spin. It crashed in a near vertical descent.NTSB FTW82DA077Accident · No injuriesFinal reportCessna 152 · Arkadelphia, ARThe pilot elected to practice a forced landing pattern to a large rice field. As he passed over a stand of pine trees on final approach, he heard a loud thump. He increased power and returned to the airport. En route, he noted a dent on the leading edge of…NTSB MIA82DA058Accident · No injuriesFinal reportCessna 152 · Miami Beach, FLThe pilot stated that while flying approximately 10 miles southeast of the airport over the ocean the engine started to vibrate. The pilot elected to return to the airport however. A few minutes later the engine oil pressure dropped to zero and the aircraft…NTSB CHI82DA074Accident · No injuriesFinal reportCessna 152 · Williamsburg, MIDuring a VFR approach the pilot stated he was concentrating on not landing long. The aircraft touched down in snow about 50 feet short of the landing area and slid, nose down, for approximately 50 feet. The pilot had flown a total of 3.2 hours in the last 90…NTSB MKC82DA040Accident · No injuriesFinal reportCessna 152 · Mcpherson, KSAfter returning from a local flight, the student pilot landed on runway 36 with a wind from 070 degrees at 13 knots. He reported that he lost control on the landing roll and departed the left side of the runway. The aircraft ran into muddy terrain and nosed…NTSB CHI82DA070Accident · No injuriesFinal reportCessna 152II · Oxford, OHAfter a normal landing the pilot retracted the flaps and opened the throttle. As the aircraft gained speed it started drifting off the runway. The pilot attempted to correct with rudder but the aircraft veered off the runway. Power was reduced before the nose…NTSB CHI82DA065Accident · No injuriesFinal reportPiper PA-38-112 · Elyria, OHDuring the landing flare the student overcorrected with full aft elevator. The aircraft pitched up, the instructor applied full power, and the aircraft bounced and drifted into a snow bank. The instructor was reported to have about 20 hours instructing.NTSB MIA82DA054Accident · No injuriesFinal reportCessna 152 · St. Petersburg, FLThe student pilot was on her first supervised solo flight. During the second landing the aircraft bounced and while attempting to recover the pilot first added power then cut it. The aircraft dropped down on its nose and the nose gear collapsed.NTSB MIA82DA065Accident · No injuriesFinal reportCessna 152 · Opa Locka, FLWhile doing touch and go landings the pilot observed a squall line approaching the airport. He proceeded to make a full stop landing and was taxiing to operations, when a strong gust of wind picked up the tail of the aircraft and flipped it over. The pilot…NTSB FTW82DA060Accident · No injuriesFinal reportBellanca 7ECA · Henderson, TXAfter reducing power to idle, gliding for some distance, and then applying carburetor heat he realized that additional power would be needed to reach the runway. Power was added with no results and the aircraft was set down in a rough field approximately 1/4…NTSB FTW82DA058Accident · No injuriesFinal reportCessna 152 · Cleveland, TXOn the second landing of a supervised solo flight, the aircraft veered and the student pilot lost control. The aircraft collided with the wind sock pole and was substantially damaged.NTSB CHI82DA055Accident · No injuriesFinal reportPiper PA-38-112 · Lebanon, INWhile the instructor was demonstrating recovery procedures from a low approach, the main gear struck snow on a small rise about 400 feet short of the runway. Subsequently, the pilot was forced to land in about 18 inches of snow and the gear failed. The…NTSB CHI82DA054Accident · Minor injuriesFinal reportCessna 152 · Elyria, OHThe student was practicing takeoffs & landings. While taxiing after the first landing he detected a noticably bad shimmy. He continued his takeoffs & landings, and during the last landing he was unable to maintain directional control and collided with a…NTSB MKC82DA030Accident · No injuriesFinal reportCessna 152 · Chesterfield, MODuring takeoff from a touch and go landing, the engine lost power at about 300 ft AGL. The student pilot was unable to restart the engine. The aircraft was damaged during a forced landing off of the runway. No pre-impact engine malfunctions or failures were…NTSB CHI82DEE13Accident · No injuriesFinal reportCessna 152 · Lansing, ILWhile on a supervised solo the acft drifted to the left during rollout on rwy 9. The left main gear was caught in snow at the side of the rwy causing the acft to nose into a snowbank.NTSB MKC82DA029Accident · No injuriesFinal reportCessna 152 · Cape Girardeau, MODuring his second solo flight, the student pilot landed in a slight left quartering headwind. He stated that he had left rudder applied on touchdown and the aircraft veered left into a snowbank and nose over.NTSB CHI82DA040Accident · No injuriesFinal reportCessna 152 · Canton, MIThe student pilot was on the second leg of his cross-country flight when the engine lost power. He landed in a snow covered, plowed field. After about 60 feet of ground roll, the plane nosed over. The student stated that the engine started running rough until…NTSB LAX82FVD09Accident · No injuriesFinal reportBellanca 7ECA · Sonoma, CAControl was lost during takeoff when, according to the pilot's statement, a sudden extreme wind gust caused the aircraftto change its heading. The aircraft contacted water at the side of the runway and came to rest nose down. Winds were reportedly gusting to…