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 LAX90LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Scottsdale, AZThe failure of the pilot to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's improper use of the airplane brakes.NTSB CHI90FA193Accident · 2 fatalField investigationFinal reportPiper PA-38 · Hinckley, ILThe instructor pilot's inability to recover from a stall/spin. Factors were: acft wt & balance exceeded, and the instructor's and student pilot's lack of familiarity with acft.NTSB FTW90LA144Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Terrell, TXWrong runway selected by second pilot. Factors were: tailwind and inadequate supervision by pilot-cfi.NTSB CHI90LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · California, MOFuel exhaustion due to the student pilots lack of fuel use awareness and inadequate training regarding cross country fuel consumption planning and awareness.NTSB CHI90LA186Accident · Minor injuriesLimited investigationFinal reportCessna 152 II · Grand Marais, MNUndetermined partial loss of engine power during the initial climbout. A factor was the lack of suitable terrain for a forced landing.NTSB LAX90LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hickman, CAThe pilot's improper planning & decision, an inadequate fuel supply, and fuel exhaustion. A contributing factor was related to the false indication of the fuel quantity gages.NTSB ANC90LA110Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cantwell, AKThe pilot failed to understand the performance parameters of the airplane and his lack of total experience. A contributing factor to the accident was operating the airplane at a greater than allowable gross weight.NTSB ATL90FA139Accident · 4 fatalField investigationFinal reportPiper PA-38-112 · Florence, ALFailure of the pilot-in-command of N2409K to maintain safe separation from N2437K during unauthorized formation maneuvering. Overconfidence in personal ability and the execution of unauthorized formation flight on the part of both pilots-in-command were…NTSB SEA90LA113Accident · No injuriesLimited investigationFinal reportCessna 152 · Reno, NVThe pilot's use of an inappropriate runway. The gusty tailwind and the pilot's lack of experience were factors related to the accident.NTSB CHI90FA161Accident · 1 fatalField investigationFinal reportCessna 152 · Hagerstown, INThe pilot's failure to use all available runway and failure to abort the takeoff.NTSB SEA90LA095Accident · 1 fatalLimited investigationFinal reportGrace Long EZ · La Grande, ORLoss of engine power due to fuel contamination which resulted from the pilot's inadequate preflight inspection of the aircraft.NTSB NYC90LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln Park, NJThe accident was a inflight collision with an vehicle while the airplane was on final approach for a landing.NTSB CHI90LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, MIStudent pilot's failure to maintain directional control while landing in a crosswind. The student's lack of flight experience and the crosswind were factors.NTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.NTSB DEN90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Delta, UTThe pilot's loss of directional control during landing. Factors were gusting tailwinds and the pilot selected the wrong runway.NTSB NYC90LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · West Milford, NJImproper planning/decision by the flight instructor (CFI). Related to the accident was the cfi's lack of experience as an instructor.NTSB FTW90LA108Accident · No injuriesLimited investigationFinal reportCessna 152 II · Katy, TXThe cfi's inadequate supervision of the student and the airplane.NTSB LAX90DVG05Accident · No injuriesFinal reportLerstang Long EZE · Willows, CAThe pilots misjudgement of the correct landing spot and allowed the aircraft to descend into the ground without taking proper and timely corrective action.NTSB NYC90LA088Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Blossvale, NYFailure of the pilot to maintain directional control during landing. Factors related to the accident were: a gusty quartering tailwind.NTSB NYC90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · New Castle, PAInadequate supervision of the student pilot by the flight instructor which resulted in a hard landing. Factors related to the accident was the improper use of the flight controls by a student pilot.NTSB MIA90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Marco Island, FLFuel exhaustion due to improper planning & decision by the pilot, and an inadvertent stall/spin while maneuvering for a forced landing.NTSB DEN90LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Whitewater, MTPilot's delayed use of carburetor heat and the subsequent induction icing related partial power loss. Contributing factors were the carburetor icing conditions and the unsuitable terrain in which the forced landing was performed.NTSB MIA90LA092Accident · Minor injuriesLimited investigationFinal reportTalmadge Scott Longez · St. Petersburg, FLThe failure of maintenance personnel to properly secure the carburetor throttle cable housing.NTSB DEN90LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe fuel exhaustion induced power loss.NTSB MIA90LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Mims, FLPilot's poor inflight monitoring of the a/c fuel state which resulted in fuel exhaustion and subsequent engine failure.NTSB NYC90LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Glens Falls, NYPilot factor in that he lost directional control during takeoff and subsequently collided with a snowbank.NTSB MIA90LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Juan, PRFailure of the student pilot to maintain directional control of the aircraft while taxiing.NTSB CHI90LA095Accident · No injuriesLimited investigationFinal reportCessna 152 · Alpena, MIStudent pilot's failure to maintain positive directional control during the takeoff roll. The student pilot's lack of flight experience was a contributing factor in this accident.NTSB BFO90LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Grafton, WVThe pilot's improper use of carburetor heat, when operating at reduced power in conditions which were conducive to carburetor ice.NTSB LAX90LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Lucerne Valley, CAThe pilot's failure to use carburetor heat and improper emergency procedures. Contributing to the accident was the pilot's lack of total experience.NTSB SEA90LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's selection of unsuitable terrain. Factors related to the accident were: the runway conditions and the tree.NTSB CHI90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrett, INThe student pilot's failure to maintain directional control which resulted in a ground swerve. The crosswind and soft runway were related factors.NTSB MKC90LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, MOExcessive taxi speed and inadequate visual outlook by the pilot. Factors related to the accident were: dark night and the ditch.NTSB ATL90LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Peewee Valley, KYThe pilot's improper precautionary landings. The pilot's improper planning/decisions, the low fuel level, and the terrain conditions at the airstrip were related factors.NTSB LAX90FA062Accident · No injuriesField investigationFinal reportPiper PA-28 · Lincoln, CAInadequate visual lookout by the pilot of the Cessna, which resulted in his failure to see-and-avoid the Piper.NTSB LAX90LA079Accident · No injuriesLimited investigationFinal reportCessna 152 · Bermuda Dunes, CAThe student pilot's improper flare, and failure to avoid or correct the resultant porpoise.NTSB LAX90LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · El Cajon, CAThe student pilot's failure to maintain directional control during a full stop landing in calm winds.NTSB MKC90LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · St Charles, MOFailure of the pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind condition, the student's lack of total experience, and the building (hangar).NTSB ANC90LA023Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Tanana, AKFailure of the right main gear axle bolt.NTSB ATL90LA046Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selmer, TNThe failure of the instructor to place the engine mixture control in the rich position prior to beginning traffic pattern maneuvers. As a result, the engine quit because of the lean fuel mixture at the high power setting required for the go-around and…NTSB DEN90LA034Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Firestone, COPremature liftoff by the pilot which resulted in insufficient airspeed.NTSB MIA90LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Zephyrhills, FLThe student pilot not obtaining the current wind information which resulted in selecting the wrong runway for landing; improper recovery from a bounced landing. Contributing factor(s) was: the student pilot's lack of experience and the tailwind conditions.NTSB MIA90LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Cocoa, FLFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground swerve. Factors related to the accident were the crosswind condition and ditch.NTSB CHI90LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Eau Claire, WIFailure of the student pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind, the student's lack of total experience, his diversion of too much attention to…NTSB NYC90LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Dunkirk, NYPilot in command failed to maintain airspeed during a forced landing resulting in a stall and hard landing after a engine power failure due to carburetor ice and improper use of the carburetor heat control by the pilot.NTSB CHI90LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe student pilot's inadequate compensation for wind conditions. Factors related to the accident were: inadequate supervision by the student's flight instructor (CFI), the student's failure to obtain weather information (use a preflight briefing service)…NTSB BFO90LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Front Royal, VAFailure of the instructor pilot (CFI) to maintain proper runway alignment with the runway. Contributing factors were: the student pilot's high and fast approach, the cfi's delay in initiating remedial action, the crosswind, and the runwaylight.NTSB MKC90LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Girardeau, MOPoor planning by the pilot in not refueling enroute which resulted in fuel exhaustion.NTSB MKC90LA022Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Toledo, IAThe pilot became lost/disorientated and attempted a landing at the wrong airport. Factors related to the accident were: darkness, unfavorable wind condition, and the student pilot's lack of experience in the type of operation.NTSB LAX90FA019Accident · 1 fatalField investigationFinal reportBeech 77 · Kalihi, HIVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.