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 LAX89LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Concord, CAStudent pilot had not attained compensation for the crosswind, and lost control of the airplane.NTSB CHI89LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Necedah, WIPilot-in-command's improper use of the fuel selector.NTSB MIA89FA154Accident · Minor injuriesField investigationFinal reportCessna 152 · Fort Pierce, FLFailure of the student pilot to maintain airspeed which resulted in an inadvertent stall. Contributing factors were: the weather conditions (smoke & haze), the student becoming lost, her lack of total experience, and her inability to understand ATC…NTSB MIA89LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco, FLFailure of the pilot to control the approach speed which resulted in a bounced landing. No recovery was made from the bounced landing, and the airplane was allowed to stall. The airplane then landed on the nose landing gear, which resulted in its overload…NTSB MKC89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MOThe failure of the CFI to visually acquire and maintain clearance from power lines, which the airplane subsequently contacted.NTSB MKC89FA107Accident · Serious injuriesField investigationFinal reportCessna 152 · Cottage Grove, MNPoor judgement of the pilot by flying while physically impaired from consumption of alcohol; and his failure to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall and collision with wooded/hilly terrain.NTSB CHI89LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Flint, MIThe pilot-in-command's failure to follow proper procedures and directives and his premature decision to initiate an emergency procedure. Contributing factors were the pilot's lack of total experience and his selection of unsuitable terrain for the emergency…NTSB MKC89LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Buffalo, MNThe pilot's failure to maintain directional control. Factors related to the accident were: the crosswind, the pilot's improper compensation for wind conditions, his improper use of the throttle, and the ditch.NTSB DEN89LA113Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Albuquerque, NMInadequate compensation for the wind conditions by the pilot, resulting in a loss of control during landing roll. Variable and gusting winds are considered a contributing factor.NTSB NYC89LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, VTThe student pilot's failure to maintain directional control of the aircraft.NTSB NYC89LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Hanover, PAThe failure of the student pilot to maintain airspeed and directional control during an attempted go around.NTSB DEN89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Ogden, UTThe student pilot's improper flare which resulted in a hard landing & separation of the nose landing wheel. Contributing to the accident was the pilot's lack of total experience.NTSB CHI89DEC04Accident · Minor injuriesFinal reportBridges LONG-EZ · Rochester Hills, MIThe pilot's decision to takeoff from unsuitable terrain which resulted in damage to the propeller and nose gear.NTSB CHI89LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Brazil, INFailure to establish a proper glidepath. Contributing to the accident was the dark night condition, the pilot's overconfidence in his personal ability, and his lack of familiarity with the airplane.NTSB ANC89LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Kenai, AKImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion.NTSB CHI89LA074Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INThe student pilot's failure to compensate for the crosswind condition and maintain directional control during the landing. The airplane departed the runway and nosed over in soft terrain. Contributing to the accident was the student's lack of recent…NTSB ATL89LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Gratis, OHThe foreign material (bird nest) in the engine compartment, and failure of the dual student or instructor pilot (CFI) to identify and remove it during their preflight inspection of the aircraft. Soft terrain in the emergency landing area and smoke from the…NTSB LAX89FA157Accident · Serious injuriesField investigationFinal reportCessna 152 · Chino, CAThe pilot's failure to obtain an appropriate weather briefing in preparation for the cross country flight and his failure to maintain an altitude sufficient to clear the terrain along the indended route after entering reduced visibility conditions.NTSB NYC89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bedford, MAImproper use of throttle and flight controls by the student and inadequate supervision by the CFI which resulted in a stall. The student's lack of total flying experience and the instructor's lack of experience in the type of operation (instructing) were…NTSB LAX89LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilots improper use of carburetor heat in weather conditions which were conducive to the formation of carburetor ice.NTSB DEN89LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Devils Lake, NDInadequate compensation for wind conditions by the pilot, which resulted in loss of directional control and an inadvertent ground loop/swerve. Contributing factors were: the crosswind and the pilot's lack of familiarity with the aircraft.NTSB CHI89LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Allegan, MIImproper use of flight controls by the student pilot, which resulted in his loss of directional control and an inadvertent ground swerve; and the instructor pilot's (cfi's) inadequate supervision. Factors related to the accident were: the crosswind condition,…NTSB ATL89LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe pilot's failure to properly plan required fuel for this flight which resulting in fuel exhaustion and a forced landing in a field.NTSB ATL89LA117Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Timmonsville, SCThe pilot's failure to remain aware of the local wind conditions. Additionally, he executed the approach and landing with excessive speed, combined with a tailwind, which resulted in the runway overrun.NTSB LAX89LA128Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Jose, CAImproper in-flight planning/decision by the pilot and subsequent fuel exhaustion. Contributing factors were: dark night,trees, and the building.NTSB MIA89LA099Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ocala, FLFailure of the vehicle driver to see and yield to the acft that was landing on rwy 27. Contributing factors were: vehicle on the runway and inadequate visual lookout by the pilot.NTSB BFO89FA020Accident · 1 fatalField investigationFinal reportCessna 152 · Townsend, DELoss of aircraft control for unknown reasons.NTSB LAX89LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZThe failure of the instructor pilot to properly evaluate the weather conditions resulting in an encounter with an unanticipated downdraft condition and failure of the student pilot to maintain a proper descent rate.NTSB MKC89LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was the icy/snow covered runway.NTSB ANC89LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe pilot's failure to maintain directional control during a touch and go landing. A contributing factor is the pilot's lack of total flight experience.NTSB MIA89LA083Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fernandina Bch, FLLocking of the left brake, which resulted in a ground swerve and loss of control during the landing roll.NTSB DEN89LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Forks, NDThe failure of the pilot to correct a ground loop swerve. A lack of total flight experience is considered to be a contributing factor.NTSB MIA89LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLFailure of the pilot to flare for landing and improper recovery from a bounced landing.NTSB MIA89LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe Cessna 152 pilot misjudged clearance between his aircraft and the parked Piper PA-28.NTSB LAX89LA084Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Westlake, CAImproper planning and decision by the pilot which resulted in fuel exhaustion. Contributing factors were: faulty fuel indication, utility pole & uneven terrain.NTSB CHI89DEX03Accident · No injuriesFinal reportGrumman American AA-1C · Richmond, INThe pilot's attempt to continue the takeoff with a partial loss of power. Contributing to the accident were the carburetor icing conditions.NTSB LAX89LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Long Beach, CAThe excessive speed which the pilot was maintaining and his improper operation of the brake system. Contributing to the accident was the inexperience of the student pilot.NTSB ATL89LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Theodore, ALPilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall, and subsequent collision with the ground.NTSB DEN89LA050Accident · No injuriesLimited investigationFinal reportCessna 152 II · Gilcrest, COThe plt, with his wife as a pax, departed greeley, CO, on a cross-country flt to clayton, NM. After landing, the pilot had his aircraft refueled. It took 23.5 gallons of fuel to fill the fuel tanks. The plt then took off, flew 46 miles southeast, then turned…NTSB NYC89LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Pedricktown, NJDuring landing the pilot lost directional control of the aircraft and ran off the left side of the runway, hit a dirt bank and flipped over.NTSB MKC89LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Creve Coeur, MOThe student pilot said that after practicing locally and returning to the base airport, he discovered the winds to be greater than anticipated. On his third attempt to land, he bounced twice, then lost control and hit nose first on the runway. An eighty…NTSB SEA89LA026Accident · No injuriesLimited investigationFinal reportCessna 152 · Medford, ORThe pilot departed the airport without obtaining fuel. Approximately 15 gallons of fuel was on board which would make the fuel tanks about one-half full. At the time of the accident the aircraft had been airborne for over 2 hours and 10 minutes. Dark visual…NTSB DEN89LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe plt was flying a cross-country flight. She said that 3 miles from her destination, the engine quit when the plane ran out of fuel. A landing on an ice covered asphalt road was performed. During roll out, the left main gear went off the road and the left…NTSB MKC89LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Hibbing, MNWhile practicing takeoffs and landings on a patchy snow and ice covered runway, the student pilot lost directional control on takeoff and veered off the runway into a snow bank. The acft nosed down and damaged the prop and right wing.NTSB DEN89LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Watkins, COThe student plt was practicing touch and go landings during an unsupervised solo flight. Runway 26 was in use, with winds reported as 320 deg at 5 KTS. At the first landing, the acft touched down nose first, thirty feet left of the center line. The acft…NTSB FTW89FA028Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Tomball, TXThe airplane was being used for touch and go landings by an instructor and a low time student. It was on a base leg to land to the south when the instructor told the tower she had lost the engine and was going down. There were no witnesses to the accident.…NTSB ATL89LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Salisbury, NCThe accident occurred during the student pilot's first supervised-solo flight. The student reported that she pushed the acft's nose down while on final appch after realizing she was too high, which led to an increase in airspeed. The student's instructor…NTSB NYC89LA040Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Erwinna, PAOff airport landing in unsuitable terrain due to a power loss caused by carburetor icing.NTSB ANC89LA020Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot misjudged the approach and failed to maintain a proper descent rate. A related factor was trees.NTSB CHI89DEV01Accident · No injuriesFinal reportCessna 152 · Vandalia, ILThe eng began running rough aprx 5 min after the plt took off from an en route arpt drg a night, x-country training flt. He reversed course back toward the departure arpt with the eng providing partial power. While maneuvering to land on rwy 18, the eng…