Fatal NTSB investigations: Lycoming 0-235 series
18 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “In flight collision with object”. 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 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 1 |
| 2007 | 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.\"highestInjuryLevel\" = 'Fatal'
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')
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\" = 220))
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."highestInjuryLevel" = 'Fatal'
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')
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" = 220))
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 CHI07LA195Accident · 2 fatalLimited investigationFinal reportGrumman American AA-1C · Carrollton, OHThe pilot failed to maintain clearance from trees during cruise. Factors were the inadequate preflight planning, the thunderstorm in the area at the time of the accident, and the trees.NTSB NYC02FA173Accident · 1 fatalField investigationFinal reportPiper PA-22-108 · Mayville, NYThe student pilot's failure to maintain adequate altitude during the landing approach and the private pilot's inadequate supervision, which resulted in a collision with a marked utility pole. A factor in this accident was the student pilot's lack of…NTSB SEA02FA005Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sandy, ORThe pilot's failure to maintain clearance from the trees while attempting to land in a field after entering an area of instrument meteorological conditions. Factors include low ceilings, rain, fog, strong winds, mountainous/hilly terrain, the pilot's…NTSB SEA01FA015Accident · 2 fatalField investigationFinal reportCessna 152 · Corvallis, ORThe pilot's failure to maintain clearance from the terrain. Factors include a dark night, densely forested, hilly terrain near the planned route of flight, and low ceilings in the area of the accident.NTSB CHI00LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-16 · Chesaning, MIThe pilot failed to maintain clearance from the trees. A factor was the trees.NTSB CHI00FA288Accident · 2 fatalField investigationFinal reportPiper PA-22-108 · Custer, SDThe pilot not maintaining clearance from the tree. Factors relating to this accident were the pilot's inadequate preflight planning and preparation, the high density altitude, the inadequate rate of climb, the pilot's improper in-flight decision to fly into…NTSB MIA99FA208Accident · 1 fatalField investigationFinal reportGulfstream American AA-1B · Hilliard, FLthe pilot's failure to obtain notams and his improper planning and decision to use a closed runway for takeoff with tall trees on the departure end, resulting in a subsequent collision with the trees.NTSB IAD98LA038Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Castlewood, VAThe pilot's failure to achieve the proper touchdown point and the delayed execution of the go around. A contributing factor was the fence.NTSB LAX98FA009Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Tracy, CAThe pilot's low operating altitude and his failure to maintain appropriate clearance during low level maneuvering flight. Contributing factors were transmission wires and the physical impairment that resulted from the effects of the over-the-counter…NTSB FTW97LA110Accident · 2 fatalLimited investigationFinal reportCessna 152 · Plaquemine, LAThe pilot's failure to maintain proper altitude and clearance from transmission wires. Factors were, the dark night, low cloud ceiling, and fog.NTSB ATL96FA096Accident · 2 fatalField investigationFinal reportCessna 152 · Talladega, ALfailure of the pilot to see-and-avoid an antenna that was mounted on a Forest Service watch tower. The pilot's excessively low altitude flight was a related factor.NTSB SEA95LA053Accident · 2 fatalLimited investigationFinal reportBruce Tifft Varieze · Tiller, ORThe pilot's failure to maintain clearance from trees.NTSB NYC92FA133Accident · 1 fatalField investigationFinal reportCessna 152 · Pleasant Mount, PAThe pilot's decision to perform low altitude maneuvers, resulting in a loss of airplane control and collision with trees. Factors related to the accident were the ostentatious display by the pilot, and his lack of total flight experience.NTSB MIA91FA171Accident · 2 fatalField investigationFinal reportBeech 77 · Magnolia, MSThe instructor pilot's (cfi's) improper supervision of flight and a failure to maintain sufficient altitude above the trees.NTSB ANC87LA114Accident · 1 fatalLimited investigationFinal reportChampion 7ECA · Central, AKDuring an interview in the hospital with the passenger who was the pilot's son, he stated to the FAA inspector that his dad was low level flying when the aircraft struck a tree. The pilot lost control of the aircraft and crashed. At the time of the accident…NTSB DEN87FA035Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Gilcrest, COThe plt made a low pass at aprx 200 ft AGL & waved at TW0 friends who were duck hunting. He then made a 2nd pass at aprx 150 ft & left the area. About 10 min later, the acft returned & was seen flying down a river at tree top level. The acft struck 3 of 4…NTSB NYC84FA137Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Marlboro, NJPilot and pax departing 2170 ft rwy at near max gross weight pax stated it didnt appear as if they were going to clear high tension power lines located about 2400 ft from rwy end. Pilot made left turn and impacted unmarked wires about 600 ft left of extended…NTSB NYC82FA116Accident · 1 fatalField investigationFinal reportCessna 152 · Elma, NYThe pilot was performing a flight exam for a private pilot certificate. An approach was made to a field bordered by high tension lines. During the approach the aircraft collided with wires and descended nose first to the ground.