NTSB investigations: Lycoming 0-235 series, NE
40 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 per year
| 1964 | 3 |
|---|---|
| 1965 | 1 |
| 1968 | 1 |
| 1970 | 2 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1976 | 1 |
| 1978 | 2 |
| 1980 | 3 |
| 1981 | 2 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1996 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 1 |
Where
Latest 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.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'NE' AND c."eventCountry" = 'USA'
AND 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 FTW02FA233Accident · 1 fatalField investigationFinal reportCessna 152 · Ithaca, NEThe pilot's intentional flight of the airplane into terrain in an act of suicide.NTSB CHI02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · O'Neill, NEThe inadequate preflight planning by the pilot resulting in the exhaustion of the fuel supply, and the pilot not maintaining directional control during the forced landing. A factor was the unsuitable landing area selected by the pilot, and the ditch.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 CHI01LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Overton, NEThe open exhaust valve. Factors relating to the accident were the sticking exhaust valve guide and the snow drift the airplane encountered during the precautionary landing.NTSB CHI00LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, NEthe misjudged flare and the inadequate recovery from the bounced landing performed by the student pilot.NTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.NTSB CHI96LA298Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Fairbury, NEinadequate airspeed and an inadvertant stall during the initial takeoff climb. Factors associated with the accident were the rough terrain used for takeoff and the ditch at the departure end on the field.NTSB CHI92LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Crete, NEA premature lift-off and failure to perform remedial action. Lack of expereince in short field takeoffs was a factor.NTSB CHI91LA138Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Millard, NEImproper use of APU by unknown personnel which resulted in the airplane's electrical wiring melting and subsequent short.NTSB CHI91DCJ02Accident · No injuriesFinal reportFagerberg Longeze · Wahoo, NEThe improper installation/maintenance of the carburetor heat control. A factor was the pilot's restricted visual outlook.NTSB MKC89LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Marion, NEShortly after takeoff from a farm field, the acft's left wing dropped & the acft descended striking the terrain. Witnesses said that immediately after takeoff, the plt attempted to make a steep climbing, left turn. A post acdnt inspn revealed no preimpact…NTSB MKC88LA179Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bertrand, NEThe plt rprtd that while practicing takeoffs & ldgs, he believed he had excessive ground speed & elected to go around. He said he waited to long to go around, so he decided to fly under power lines, located at the dep end of the strip. Shortly after lift-off,…NTSB MKC87LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Gretna, NEThe instructor stated that this training flight would emphasize power reduction manuevers, to include: slow flight, power-off stalls, and flight at minimum controllable airspeed. Thirty minutes into the flight, and during the application of power for…NTSB MKC85LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · Adams, NEPlt was making first landing at an ag strip and collided with 30 foot high utility wires which cross the apch end of thestrip. The wires are not marked.NTSB MKC84LA286Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Beatrice, NEDuring the flare an uncontrolled rate of descent developed resulting in a touchdown short of the rwy threshold. The mainldg gear struck the 5 inch exposed rwy lip. Density alt was aprx 4,200 ft.NTSB MKC84LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · David City, NEThe instructor plt (CFI) & his student departed on a round robin x-country flt & had planned to make a soft field landing at David City, NE. During arrival at David City, they made a visual check of the rwy because they were unable to contact the arpt UNICOM.…NTSB MKC83LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Sidney, NEThe student plt was on a solo x-country flt. As he approached Sidney, NE, he was unable to contact anyone on the radio & continued to the arpt at cruise alt. He descended while circling the arpt. Before reaching traffic pattern alt, he applied power, but the…NTSB MKC83LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Ord, NEThe student pilot reported that on his third touch-and-go, he was momentarily distracted and looked down inside the aircraft. He inadvertentently pushed the left rudder and was unable to regain directional control before the left main wheel ran off the side…NTSB MKC83LA030Accident · No injuriesLimited investigationFinal reportCessna 152 · 1nm N. Or Mcgre, NEUpon discovering his intended point of landing was closed, the pilot chose to land the aircraft on a nearby road. During his final approach the pilot saw a power line and dove under it landing short. The aircraft collided with road signs during the landing…NTSB MKC82DA084Accident · No injuriesFinal reportCessna 152 · Ainsworth, NEThe pilot elected to taxi on a closed runway that was used to store piles of corn. The pilot stated that a gust of wind forced the aircraft into a pile of corn causing substantial damage to the nose gear. Wind gusts were reported to 22 knots.NTSB MKC81DCJ34Accident · No injuriesClosedPiper PA-38 · Kearney, NENTSB MKC81DCJ05Accident · No injuriesClosedCessna 152 · Omaha, NENTSB MKC80DCJ29Accident · No injuriesClosedCessna 152 · Columbus, NENTSB MKC80DCJ11Accident · No injuriesClosedCessna 152 · Omaha, NENTSB MKC80FCJ08Accident · No injuriesClosedCessna 152 · Imperial, NENTSB MKC79DCJ05Accident · No injuriesClosedPiper PA-20 · Brunswick, NENTSB MKC78DCJ16Accident · Minor injuriesClosedCessna 152 · Crete, NENTSB MKC77FCJ08Accident · Minor injuriesClosedBellanca 7ECA · Tecumseh, NENTSB MKC75DCJ03Accident · No injuriesClosedAmer Avco AA1-B · Utica, NENTSB MKC74DCJ42Accident · No injuriesClosedAmer Avco AA1-A · Auburn, NENTSB MKC73DCJ37Accident · No injuriesClosedPiper PA-16 · Atkinson, NENTSB MKC73FCJ02Accident · Minor injuriesClosedCessna 140 · North Platte, NENTSB MKC72FCJ35Accident · No injuriesClosedPiper PA-22 · Ayr, NENTSB MKC70DCJ16Accident · No injuriesClosedPiper PA-22 · Chadron, NENTSB MKC70FCJ06Accident · No injuriesClosedStits SA-3A · Lincoln, NENTSB MKC68D0474Accident · No injuriesClosedPiper PA-12 · Grand Island, NENTSB MKC66D0046Accident · No injuriesClosedPiper PA-22 · Gibbon, NENTSB UNK64X2568Accident · No injuriesClosedPiper PA22 · Sidney, NENTSB UNK64X1296Accident · No injuriesClosedPiper PA16 · Lincoln, NENTSB UNK64X0318Accident · No injuriesClosedPiper PA22 · Crawford, NE