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 ATL95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · N. Myrtle Beach, SCThe improper starting procedure used by the pilot in that he failed to use wheel chocks to preclude aircraft movement. Additionally, the throttle was not placed in the idle position.NTSB CHI95LA238Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Oshkosh, WIthe pilot's failure to maintain clearance.NTSB FTW95FA307Accident · 2 fatalField investigationFinal reportCessna 152 · Rhome, TXthe flight instructor's delay in recovery from the intentional stall/spin.NTSB ANC95LA111Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's improper use of carburetor heat which led to carburetor icing and a partial loss of engine power. Factors contributing to the accident are prevailing carburetor icing conditions, and the pilot's failure to properly judge the airplane's distance…NTSB CHI95DEX01Accident · Minor injuriesFinal reportCraig Long E-Z · Shelbyville, INthe pilot's improper recovery from a bounced landing which resulted in the nose wheel striking the runway first. A factor associated with the accident was excessive airspeed during the landing.NTSB NYC95LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Beaver Falls, PAthe failure of the student pilot to maintain directional control after touchdown.NTSB NYC95LA148Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Meriden, CTThe pilot's failure to adequately compensate for wind conditions. Contributing factors were wind gusts, crosswinds, and the pilot's lack of experience in type.NTSB MIA95LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLThe failure of the pilot to maintain directional control during a go-around from a bounced landing.NTSB FTW95LA286Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe failure of the pilot to maintain airspeed resulting in an inadvertent stall.NTSB FTW95LA268Accident · No injuriesLimited investigationFinal reportCessna 152 · Farmington, NMThe student pilot's inadequate compensation for wind conditions during the landing, which resulted in her failure to maintain proper runway alignment. The gusty crosswind was a related factor.NTSB MIA95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Agricola, MSFailure of the pilot-in-command to maintain clearance between the wing and the corn crop at the edge of the runway during the aborted takeoff from the grass runway.NTSB MIA95LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · New Port Richey, FLThe pilot landed on the wrong runway. The tailwind contributed to the loss of directional control.NTSB MIA95LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe failure of the pilot-in-command [CFI] to use carburetor heat during reduced power descent.NTSB ATL95LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Juliette, GAThe pilot's ostentatious display, resulting in a collision with the water.NTSB SEA95LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · Saratoga, WYThe pilot's improper handling of the airplane during landing.NTSB FTW95LA262Accident · No injuriesLimited investigationFinal reportBeech 77 · Mcallen, TXThe dual student's failure to properly operate the throttle and the inadequate supervision by the flight instructor. A factor was the lack of suitable terrain for the forced landing.NTSB ANC95FA078Accident · 5 fatalField investigationFinal reportde Havilland DHC-2 · Nondalton, AKThe failure of both pilots to maintain adequate visual lookout.NTSB LAX95LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Helendale, CALoss of engine power for an undetermined reason(s). A factor in the accident was the pilot's selection of unsuitable terrain for the forced landing.NTSB ATL95LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Bessemer, ALThe pilot's failure to maintain directional control during a touch and go landing.NTSB ANC95TA067Accident · No injuriesFinal reportPiper PA-18-150 · Sand Point, AKThe premature castoring of the tailwheel steering mechanism. A factor associated the accident is the added degree of difficulty in handling airplanes equipped with oversize 'tundra' tires.NTSB ATL95LA104Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Rock Hill, SCAn inoperative left main wheel brake that resulted in a loss of directional control. A factor was the wet, grass runway.NTSB FTW95LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Corpus Christi, TXThe pilot's inadequate compensation for crosswind conditions.NTSB FTW95LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Durango, COThe student pilot's improper landing flare and improper bounced landing recovery.NTSB CHI95LA145Accident · Minor injuriesLimited investigationFinal reportFranklin EAA BI-PLANE/P1 · Rockville, INthe pilot's improper maintenance installation and his inadvertent takeoff. A factor was the pilot's inadequate pre-flight planning.NTSB LAX95LA179Accident · 1 fatalLimited investigationFinal reportCessna 152 · Palos Verdes, CAthat the pilot initiated the flight into known adverse weather, and inadvertent flight into instrument meteorological conditions.NTSB ATL95LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Payne, ALThe inaequate visual lookout by both pilots. Factors were the radio reception difficulties of the 152 pilot, his failure to make position reports while maneuvering for a landing, and the failure of the 182 pilot to have a safety observer while conducting…NTSB SEA95LA084Accident · No injuriesLimited investigationFinal reportBaxter-Wilson CW CHAMP-3 · Forks, WALoss of engine power for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB FTW95LA173Accident · No injuriesLimited investigationFinal reportCessna 152 · Oakgrove, ARThe student pilot's failure to maintain clearance from power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. Factor's were the instructor's decision to allow the simulation to continue to such a low altitude and…NTSB MIA95LA119Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLThe failure of the student pilot to maintain directional control during landing. A contributing factor was the delayed remedial action to attempt a go-around.NTSB ATL95LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe pilot's failure to adequately compensate for wind conditions during landing, which resulted in a loss of directional control.NTSB MIA95LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Laurel, MSThe failure of the pilot-in-command to refuel the aircraft resulting in loss of engine power due to fuel exhaustion.NTSB CHI95LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Kokomo, INThe pilot misjudged the landing flare. Factors related to the accident were the dark light conditions and the pilot's lack of visual cues for the runway environment.NTSB ANC95LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe flight instructor's inadequate remedial action. Factors include the dual student's failure to maintain directional control, and the rear pilot's station not having brakes installed.NTSB CHI95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-108 · Kankakee, ILThe pilot's inadequate recovery from a bounced landing.NTSB CHI95LA113Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Higginsville, MOthe pilot's inadequate compensation for wind conditions during the attempted takeoff. The gusty crosswind was a factor.NTSB FTW95LA155Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Graham, TXThe pilot's failure to attain proper lift-off speed resulting in an inadvertent stall. Factors were the selection of the taxiway for take-off and the inoperative landing light.NTSB ANC95LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Anchorage, AKA failure of the instructor pilot to adequately supervise the student pilot's landing approach. The student pilot's failure to maintain a proper altitude and distance to the runway touch-down point, and a snow berm at the approach end of the runway were…NTSB LAX95LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Torrance, CAthe pilot's improper compensation for the existing wind conditions.NTSB FTW95LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roads, LAThe pilot's improper bounced landing recovery technique. Factors were his failure to execute a go-around, his improper landing flare, and the other pilot's premature taxiing onto the runway for takeoff.NTSB CHI95LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukesha, WIthe student pilot's failure to maintain directional control during an aborted takeoff. A factor was the snow covered ground which contributed to the airplane nosing over as it departed the runway.NTSB BFO95LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Belfast, MEthe student pilot's failure to adequately compensate for wind conditions. A related factor was the presence of high snowbanks along the sides of the runway.NTSB MIA95FAMS2Accident · 2 fatalMissing aircraftFinal reportCessna 152 · MissingUndetermined. The airplane and occupants have not been located.NTSB LAX95LA122Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · San Jose, CAthe student pilot's failure to maintain directional control of the conventional gear aircraft during an aborted landing attempt. Factors in the accident were the student's high and fast approach and his failure to achieve the proper touchdown point.NTSB NYC95LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · North Bergen, NJThe pilot's inadequate in-flight planning which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB CHI95LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Owosso, MIthe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the snow bank.NTSB LAX95LA114Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Pacifica, CAFailure of the Grumman pilot to maintain visual contact and clearance from the citabria, while overtaking that aircraft. Factors relating to the accident were: the hazy sky condition and the Grumman pilot's diverted attention to other traffic.NTSB SEA95LA053Accident · 2 fatalLimited investigationFinal reportBruce Tifft Varieze · Tiller, ORThe pilot's failure to maintain clearance from trees.NTSB MIA95LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's failure to perform a go-around and failure to apply power to recover from the bounced landing.NTSB LAX95LA134Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Long Beach, CAFailure of the right main tire, and subsequent failure of the pilot to maintain directional control of the airplane. A factor related to the accident was: the pilot's lack of recent flight experience.NTSB LAX95LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Rosamond, CAFailure of the pilot to maintain directional control. Soft terrain beside the runway was a related factor.