NTSB investigations: Lycoming 0-235 series
70 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “In flight collision with terrain/water”. 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 per year
| 1982 | 5 |
|---|---|
| 1983 | 7 |
| 1984 | 7 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 3 |
| 1990 | 4 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 5 |
| 2001 | 6 |
| 2002 | 3 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
Where
Open the mapLatest cases
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
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 ANC06CA110Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Coldfoot, AKThe pilot's selection of an unsuitable landing area, which resulted in an in-flight collision with terrain during an aborted landing. Factors associated with the accident were wind gusts, and rough and uneven terrain.NTSB DEN05LA060Accident · 2 fatalLimited investigationFinal reportPiel Emeraude CP-305 · Del Norte, COThe pilot's failure to maintain clearance with the terrain for undetermined reasons.NTSB CHI04LA112Accident · 1 fatalLimited investigationFinal reportGrumman American AA-1B · Dodge Center, MNThe pilot's failure maintain climb and his failure to maintain clearance from the terrain during initial climb out after takeoff. The aircraft's low altitude, high gusty winds and low level turbulence were contributing factors.NTSB LAX04LA156Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Selma, CAThe pilot's inadequate preflight planning, which failed to assure adequate takeoff performance, and his failure to abort the takeoff. The aircraft inadequate weight and balance was a contributing factor.NTSB DEN03LA027Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Dev. CH2000 · Milford, UTthe inadequate altitude chosen by the flight instructor, resulting in inadequate clearance and subsequent collision with mountainous terrain. Contributing factors were the instructor's failure to consult pertinent VFR sectional charts for the area, and the…NTSB FTW02FA233Accident · 1 fatalField investigationFinal reportCessna 152 · Ithaca, NEThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB SEA02LA102Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Umpqua, ORThe pilot's failure to adequately compensate for unfavorable wind conditions and maintain clearance from the terrain during an attempted VFR go-around. Factors include an encounter with unfavorable wind conditions during the landing flare and the attempted…NTSB LAX02FA059Accident · 1 fatalField investigationFinal reportCessna 152 · Petaluma, CAThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB ATL02LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Elberton, GAThe student pilot's in-flight decision to land in a field, which resulted in an on-ground collision with a berm. Factors were the student's inadequate training and inadequate supervision by the flight instructor on the ground.NTSB CHI01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Patriot, INthe inadequate rotation speed and compensation for wind conditions by the pilot. Contributing factors were the crosswind and gust.NTSB SEA01LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-18-105 Special · Wilbur, WAA collision with terrain for undetermined reasons.NTSB CHI01LA122Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Kimball, NEThe pilot not maintaining clearance from the terrain. A factor was that the pilot misjudged the low altitude flight maneuver.NTSB MIA01LA113Accident · 1 fatalLimited investigationFinal reportLarry R. Kinsey Variez O-235 · Pinson, ALThe pilot's continued visual flight rules flight into instrument meteorological conditions resulting in the airplane colliding with mountainous terrain.NTSB FTW01LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Bristow, OKThe pilot's inadequate compensation for the crosswind conditions, which resulted in the airplane striking a snow bank during the landing flare/touchdown. A factor was the crosswind weather condition.NTSB CHI01LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Sturtevant, WIThe unsuitable terrain for landing selected by the student pilot, the inadequate initial training by the flight instructor, and the flight instructor's decision to send the student pilot on a solo flight in known adverse weather conditions. Factors to the…NTSB ANC00LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Slana, AKThe pilot's inadvertent touch down. A factor associated with the accident was deep snow on the airstrip.NTSB ANC00LA104Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Chenega Bay, AKThe pilot's failure to maintain an adequate lookout. Factors involved in this accident were sunglare, and a tall bush next to the airstrip.NTSB MIA00LA183Accident · No injuriesLimited investigationFinal reportHayes LONG-EZ · Collegedale, TNThe pilot's failure to maintain the proper glide path on final approach to insure arrival at the proper runway touchdown point. A factor in the accident is the pilot's unfamiliarity with the cockpit spoiler control's location and operation.NTSB ANC00LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Delta Junction, AKThe pilot's failure to maintain altitude/clearance. Factors associated with the accident were flat light conditions, and snow-covered terrain.NTSB CHI99LA249Accident · No injuriesLimited investigationFinal reportCessna 152 · Berrien Springs, MIFailure to obtain a proper climb rate and the delayed remedial action by the certified flight instructor. Contributing factors were the uphill terrain and trees.NTSB LAX99FA129Accident · 1 fatalField investigationFinal reportCessna 152 · Rancho Cucamong, CAthe pilot's failure to maintain altitude/clearance from mountainous terrain for unknown reasons.NTSB ANC99LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's misjudgment of a proper touchdown point. Factors associated with the accident were darkness, and the pilot's inadequate preflight planning.NTSB LAX99LA002Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Jose, CAContinued VFR flight by the pilot into instrument meteorological conditions (IMC) at night over mountainous terrain. The pilot's use of unclear language when stating his intentions to air traffic control was a factor.NTSB SEA98LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Miltonfreewater, ORThe pilots failure to maintain proper terrain clearance. Factors contributing to the accident are high density altitude and rising terrain.NTSB SEA97LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Fruitland, UTThe pilot's failure to maintain clearance from mountainous terrain. Factors include his improper inflight decision to attempt to fly through a mountain pass under high density altitude conditions in an aircraft that was operating near the limits of its…NTSB LAX97FA148Accident · 1 fatalField investigationFinal reportCessna 152 · S. Lake Tahoe, CAThe pilot's collision with mountainous terrain due to his failure to follow published high density altitude departure procedures during climb out, and route selection which exceeded the airplane's maximum climb performance specifications. Also causal was the…NTSB CHI96LA242Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Belle Plaine, MNthe pilot's misjudgment of the distance and speed during the landing, and his delay in initiating a go-around. Factors relating to the accident were: the tall grass and ravine at the end of the runway.NTSB CHI96LA220Accident · 1 fatalLimited investigationFinal reportGrumman AA5B · Fryburg, NDthe pilot's VFR flight into instrument meteorological conditions. Factors were the fog, low ceiling, and rising terrain.NTSB SEA96FA022Accident · 1 fatalField investigationFinal reportCessna 152 · Provo, UTpilot suicide (intentional in-flight collision with rising terrain). A factor relating to the accident was: pilot anxiety/apprehension.NTSB ATL95LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Juliette, GAThe pilot's ostentatious display, resulting in a collision with the water.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 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 BFO95LA008Accident · Serious injuriesLimited investigationFinal reportAmerican General AA1 · Beach City, OHthe pilot-in-command's failure to maintain adequate control of the aircraft during the takeoff. The pilot's inadequate compensation for unfavorable wind conditions is a related 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 NYC93LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Quaker Street, NYThe failure of the pilot to determine runway conditions prior to landing which resulted in the airplane being damaged upon touchdown on the snow covered runway.NTSB FTW92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Las Cruces, NMThe pilot's misjudgment of the airplane's performance which led to a situation where it could not climb above the rising terrain. A factor was the high density altitude which existed in the mountains at the time of the accident.NTSB FTW91DRD08Accident · No injuriesFinal reportCessna 152 · Ruston, LAThe cfi's exceeding the airplane's takeoff performance capability.NTSB LAX91FA022Accident · 3 fatalField investigationFinal reportPiper PA-22-108 · Oceanside, CAThe pilot initiating an instrument flight without operating air/ground communications equipment, and his failure to maintain adequate terrain clearance after apparently deciding to return to the airport. Factors contributing to the accident were inoperative…NTSB CHI91LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Hannibal, MOThe pilot's improper recovery from a bounced landing. Factors were: excessive airspeed and the pilot's lack of total experience.NTSB CHI90LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe pilot in command attempting to force the airplane onto the runway.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 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 ANC89LA015Accident · No injuriesLimited investigationFinal reportCessna 152 · Nenana, AKThe instructor pilot was demonstrating a soft-field landing to his student pilot when he flared the airplane too high, and allowed the crosswind to carry the airplane off the left side of the runway where it hit a runway light and a snow berm, then nosed…NTSB ATL88LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · Center Village, OHThe CFI attempted to demonstrate a short-field takeoff to his student, with a tailwind. He reported believing at the time that a light cross-wind/quartering tailwind was blowing. He elected to depart from rwy 27, because rwy 09 had utility wires at the…NTSB LAX87FA167Accident · 2 fatalField investigationFinal reportChampion 7ECA · Upland, CAThe pilot took off from his home airport for a sight-seeing, local flight over nearby mountains. Although the rear seat passenger weighed 270 lbs and the aircraft's fuel tanks were assumed to be full, there is no evidence that the pilot calculated the…NTSB LAX86FA289Accident · 1 fatalField investigationFinal reportAmerican AA-1A · Santa Paula, CAAfter working for over 13.5 hours the pilot attempted to fly 160 miles to his home. The 1.3 hour flt was initiated between 0100 and 0200. It was a dark night and according to persons in the accident area a 200-400 ft broken/overcast cloud layer was present.…NTSB DEN86FA149Accident · Serious injuriesField investigationFinal reportAmerican AA-1 Yankee · Cheyenne, WYDuring takeoff on a 4,997 foot long rwy, the acft became airborne, settled back onto the rwy and lifted off again just prior to reaching the end of the rwy. After takeoff the plt was not able to maintain flt. The acft impacted on a street, traveled 30 feet,…NTSB ANC86LA043Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Fairbanks, AKThe pilot stated that during the takeoff on a public road the aircraft struck the road side with the right wing.NTSB DEN86FA070Accident · 2 fatalField investigationFinal reportCessna 152 · Berthoud, COStudent plt rented acft from flying club, acft was observed by witnesses to approach the lake from the south end at a low alt. Acft struck water with right main lnd gear and rt wing tip, and nosed over. The water was described as being 'glassy' and the sun…NTSB LAX86FA024Accident · 1 fatalField investigationFinal reportChampion 7ECA · Seal Beach, CABased upon prearranged plans, the plt & pax flew over the water for the purpose of photographing friends of theirs in sail boats. The plt rolled his acft into a medium bank & circled over the specified boat while his pax commenced taking photos. The plt,…