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 MIA94LA138Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Belleair, FLImproper maintenance inspection of the crankcase breather tube resulting in failure to detect blockage of the tube.NTSB LAX94LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZthe student pilot's failure to maintain directional control of the aircraft.NTSB SEA94LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Auburn, WAClearance was not maintained by an other person. A factor to the accident was: procedures/directives were inadequate.NTSB ANC94LA044Accident · No injuriesLimited investigationFinal reportPiper J3 · Denali Nat'L Pk, AKThe failure of the landing gear bolt attachment fitting due to fatigue.NTSB MIA94FA114Accident · 1 fatalField investigationFinal reportPiper PA-12 · Merritt Island, FLThe loss of elevator control due to jamming by the tow rope which prevented the pilot from being able to control the airplane.NTSB BFO94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, DEInadequate clearance from obstacles, which resulted in birds strike. A factor was night conditions.NTSB CHI94LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAthe student pilot's improper recovery from a bounced landing. The student pilot's lack of total flight experience was a factor.NTSB NYC94LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Amherst, MAThe student pilot's inadvertently becoming lost, and the subsequent precautionary landing in a field, resulting in a collision with soft terrain and nose over.NTSB FTW94LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Rayville, LAThe pilot's failure to maintain adequate airspeed during the turn to final approach.NTSB CHI94LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Wheeling, ILthe student pilot's improper recovery from a bounced landing.NTSB LAX94LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Angwin, CAthe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the pilots lack of total experience.NTSB ATL94LA058Accident · Minor injuriesLimited investigationFinal reportRutan Rutan Long EZ · Kill Devil Hill, NCWas the pilot's failure to adequately sump the fuel system during the preflight inspection.NTSB ANC94LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Chugiak, AKThe failure of the student pilot to maintain directional control of the aircraft. Factors contributing to the accident were the frozen main landing gear brake shoe, the uncontrolled airport operations by airport personnel and extreme low temperature…NTSB LAX94LA151Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Concord, CAThe pilot's failure to maintain directional control during a touch-and-go landing. A factor in the accident was the pilot's limited expereince in tailwheel aircraft.NTSB FTW94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eagle Lake, TXThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ATL94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Smithfield, NCThe pilot's failure to maintain adequate clearance from power lines. Factors were the unmarked power lines located under the final approach path, and the sun glare that existed at the time of the accident.NTSB MIA94LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Port St. Lucie, FLThe failure of the pilot-in-command to properly preflight the airplane and ensure there was adequate fuel on board, and his improper in-flight planning/decision to continue the flight.NTSB LAX94LA121Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Bishop, CAfuel exhaustion due to the pilot's inadequate preflight planning and en route fuel consumption monitoring.NTSB ANC94FA032Accident · 1 fatalField investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's failure to maintain airspeed while maneuvering at low altitude. A factor in the accident was the student pilot's inadequate training.NTSB CHI94LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Sebewaing, MIwas the pilot-in-command's failure to maintain directional control. Factors were the icy runway and a snowbank.NTSB BFO94WA125Accident · No injuriesForeign investigationGrumman AA1B · Bayreuth, GermanyNTSB BFO94LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Plymouth, MAthe pilot's failure to maintain directional control during the flare/touchdown.NTSB MIA94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Osprey, FLUnsuitable terrain encountered during the forced landing following fatigue failure of the crankshaft during cruise flight.NTSB BFO94LA033Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Georgetown, DEThe failure of ground personnel to maintain clearance from the engine propeller.NTSB ATL94LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Pelion, SCInadequate supervision by the instructor and inadequate compensation for wind conditions by the student pilot. The unfavorable wind condition for supervised solo landing training was a factor.NTSB CHI94LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Casselton, NDthe student's failure to attain proper runway alignment and to maintain directional control. A factor related to the accident was the snow covered runway.NTSB LAX94LA088Accident · Minor injuriesLimited investigationFinal reportGrumman AA1B-TR2 · Riverside, CAThe pilot's improper recovery from a bounced landing. A factor related to the accident was: the pilot's improper flare for landing.NTSB ATL94LA032Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edisto Island, SCFailure of the pilot to use carburetor heat, while maneuvering and changing altitudes, which resulted in carburetor ice. A factor related to the accident was that weather conditions were favorable for the formation of carburetor ice.NTSB CHI94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, MOthe failure of the pilot to refuel prior to fuel exhaustion.NTSB NYC94LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Christianburg, VAThe pilot's improper use of carburetor heat which prevented the accumulation of carburetor ice and resulted in the loss of engine power. A factor was unsuitable terrain.NTSB LAX94LA070Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Santa Paula, CAA failure of the pilot to maintain directional control of the tailwheel airplane following touchdown. The pilot's lack of total experience in the type of airplane was a factor in the accident.NTSB LAX94LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Compton, CAwere the noncertificated student pilot's misjudged flare altitude, improper recovery from a bounced landing, and improper use of the left brake. The student pilot's lack of total experience and panic were factors in this accident.NTSB LAX94LA049Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAwas the student pilot's improper use of the rudder. The student pilot's lack of total experience was a factor in this accident.NTSB SEA94LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAThe student pilot failed to flare. His diverted attention was a factor.NTSB CHI94LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Arcadia, WIthe loss of engine power for an undetermined reason(s).NTSB MIA94LA022Accident · Minor injuriesLimited investigationFinal reportScott LONG-EZ · Hernando, FLThe failure of the nose gear down relay on the landing gear retraction/extension assembly for undetermined reasons, resulting in the collapse of the nose wheel on landing, and subsequent nose over.NTSB SEA94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hamilton, MTThe pilot's improper recovery from a bounced landing, and failure to maintain directional control of the airplane. Factors related to the accident were: the pilot's improper flare for landing, the resultant porpoise, and the ditch near the side of the runway.NTSB SEA94LA002Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orting, WAThe pilot in command's failure to maintain aircraft control.NTSB CHI93LA374Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot-in-command's failure to maintain airspeed. Factors were his lack of total experience and his premature retraction of the flaps.NTSB ANC93LA181Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Iliamna, AKTotal loss of engine power due to fuel exhaustion and the pilot's improper fuel consumption calculations. Factor was the unsuitable terrain.NTSB LAX93LA354Accident · No injuriesLimited investigationFinal reportCessna 152 · Hesperia, CAThe pilot in command not maintaining a proper glidepath. Factors pertaining to this accident were: the pilot in command not obtaining a weather forecast for the return flight, and the lack of total experieince in night flying.NTSB ANC93LA171Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Ptarmigan Pass, AKThe pilot inadvertently walked into a turning propeller. Factors in the accident were the soft runway which mired the airplane and the pilot's diverted attention during the attempt to free the airplane.NTSB ATL93LA149Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Tuscaloosa, ALFouled spark plugs on the number 2 and 3 cylinders, and a lack of compression on the number 1 and 4 cylinders, which resulted in a loss of engine power. A factor was the high vegetation at the forced landing site.NTSB MIA93LA192Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Greenwood, MSOperation of the airplane by the pilot-in-command/cfi with known deficiencies in equipment and the worn condition of the tailwheel assembly.NTSB ATL93LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108/U · Mccaysville, GAThe loss of engine power for undetermined reasons.NTSB LAX93LA332Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendale, AZThe student pilot's improper flare and recovery from the ensuing bounced landing.NTSB ATL93LA144Accident · No injuriesLimited investigationFinal reportCessna 152 · Cleveland, TNThe pilot's failure to maintain directional control of the airplane while taxiing.NTSB SEA93LA173Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sheridan, WYThe dual student's failure to maintain directional control. A factor contributing to the accident was the instructor's delayed remedial action.NTSB CHI93LA315Accident · No injuriesLimited investigationFinal reportCessna 152 · Montgomery, ILThe pilot became disoriented resulting in loss of engine power due to fuel exhaustion. The dark night light condition was a factor.NTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.