NTSB investigations: Lycoming 0-235 series
88 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “On ground/water 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, 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')
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\" = 310))
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" = 310))
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 BFO91LA005Accident · No injuriesLimited investigationFinal reportCessna C152 · Bridgeport, WVThe pilot's inability to avoid a collision with deer which had moved onto the runway during their takeoff roll. The dark night contributed to the accident by limiting the pilots' visual outlook.NTSB CHI90LA129Accident · No injuriesLimited investigationFinal reportCecil, Richard C. Starduster II · Indianapolis, INThe other pilot's inadequate visual lookout during ground taxi operations.NTSB MIA90LA084Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · San Juan, PRFailure of the student pilot to maintain directional control of the aircraft while taxiing.NTSB MIA89LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, FLThe Cessna 152 pilot misjudged clearance between his aircraft and the parked Piper PA-28.NTSB FTW89LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Muskogee, OKAcft's left wing struck a truck that was parked adjacent to the taxiway. After initial impact, the acft veered left and the nose also struck the truck. The plt stated that he was concentrating on a ramp sweeper that was moving down the taxiway in front of the…NTSB ATL88IA144Incident · No injuriesIncident investigationFinal reportCessna 152 · York, SCThe acft was to be ferried back to the home arpt after an eng overhaul. The plt rprtd it was located on rough/sod & required full power to taxi from the parking area. After the acft began moving, he attempted to make a rgt turn onto the taxiway. However, he…NTSB LAX87LA308Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Ehrenberg, AZWhile on a x-country flt, the student plt elected to land on a road aprx 12 mi short of his destn to 'check on a job.' He said he was familiar with the road & decided to make a straight-in apch w/o first flying over it to look for obstructions. After making…NTSB CHI87LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Jenison, MIOn takeoff roll, while practicing touch and go landings, the training flight collided with a deer. The instructor reported that after landing, full power was applied for takeoff and during rotation, a deer ran onto the runway and collided with the left side…NTSB FTW87LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Farris, OKThe plt rprtd that drg a x-country flt, he got lost & the acft ran low on fuel. At dusk, he elected to make a precautionary landing in a open field. Drg the landing, the acft struck a tree & was damaged.NTSB SEA87LA057Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyssa, ORDuring takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted.NTSB ANC86FA118Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKA ground control (gnd ctl) trainee clrd Cessna 152 (C-152), N757WV, to taxi to rwy 6, then relinquished the gnd ctl psn to a full performance level (fpl) ctlr, who had just signed on duty. The fpl ctlr was aware of the lctn & taxi destn of the C-152, the fpl…NTSB ATL86FLT05Accident · No injuriesFinal reportPiper PA-14 · Memphis, TNThe acft collided with an air compressor and a hangar door during taxi after the plt hand-propped the unoccupied acft. The ptl said that the thought the 'switches were off'.he was pulling the prop to 'loosen' the oil when the eng started and the acft started…NTSB ATL86LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Mocksville, NCDuring landing the student pilot failed to correct for the crosswind. The aircraft drifted off the runway and collided with sock support post.NTSB ANC86LA023Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot stated that during the landing roll he lost directional control of the aircraft. The aircraft struck a row of trees of the end of the landing area.NTSB MIA86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that he was completing his run-up prior to takeoff, looked up & was only able to pull the power off before he was struck by N2361D.NTSB LAX86LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAOn December 9, 1985 at 0730 PST a Cessna 152 registered to walter d. cable of upand, California collided with a parked truck while taxiing for takeoff on the paralellel taxiway of rwy 24 at cable airport, Upland, CA. VMC prevailed at the time. The airport was…NTSB CHI86LA019Accident · No injuriesLimited investigationFinal reportCessna 150 · Clinton, INBoth student plts were making an apch to the same rwy at the time. The Cessna 152 touched down and was in its landing roll when the Cessna 150 landed on top with its nose wheel and prop in the 152'S rear window.NTSB LAX85LA364Accident · No injuriesLimited investigationFinal reportCessna 152 · Monterey, CAFollowing an uneventful flt,the pilot taxied towards his parking area. He said as he looked to his right for a parking space the acfts left wing impacted a hanger and the acft turned left nosing into the hanger door.NTSB DEN85LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverton, WYThe student plt attempted to land on rwy 17. The wind was reported to be from 010 degs at 13 KTS. The acft touched down halfway down the rwy. The plt attempted to go around but aborted because of the tailwind. The acft ran off the end of the rwy and collided…NTSB MKC85LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Queen City, MOThe plt was turning into takeoff position at the end of the rwy when the rt wheel encountered a low spot and the rt wingdipped down and hit a fence post.NTSB CHI85LA215Accident · No injuriesLimited investigationFinal reportCessna 152 · Marshfield, WIThe pilot made a precautionary landing in a field. After checking the acft fuel tanks he attempted to takeoff on a gravel road. During the ground run the acft collided with trees & skidded into a field.NTSB LAX85LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Sahuarita, AZAcft veered to the right during landing roll on an abandoned airstrip. Right wing contacted a tree aprx 1 ft inboard on right wing tip deforming the main spar. Trees lined both sides of the airstrip.NTSB MIA84LA243Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Miami, FLWhile taxiing for takeoff the acft veered to the left and collided with a parked acft. The plt stated a gust of wind caused the acft to veer. The acft operator reported the plt was helping the pax with a seatbelt when the accident occurred.NTSB DEN84LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COAfter receiving clearance to rwy 16L, the plt began taxiing thru a congested area where the taxiway & an arpt road were routed thru a hangar/parking area. In that area, the roadway was adjacent to the taxiway & to the right of the plt as he was taxiing. The…NTSB NYC84LA100Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Haven, CTWhile taxiing in from landing and maneuvering for parking the acft contacted a light pole. The CFI was reportedly at theacft controls at the time of the collision. The right wing was damaged in the collision.NTSB MIA84LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe plt of the C-172 stated that as he entered the landing pattern he observed another company C-172 making landings & took an appropriate interval behind the observed traffic. The plt of the C-152 stated he made his approach behind an acft he observed in the…NTSB MKC84LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft collided with a truck while taxiing out for takeoff. The plt said that when he saw the truck coming from the opposite direction along the side of the rwy he slowed down and steered to the opposite side of the taxiway. The driver of the truck made no…NTSB ATL83LA296Accident · No injuriesLimited investigationFinal reportCessna T210N · N. Myrtle Beach, SCCessna T-210N, N6190C was struck by Piper J-3C, N42183, while taxiing at grand strand arpt. N6190C was not in motion at the time of collision and had taxied into the grass and turned off the acft eng in anticipation of the collision. The plt of N42183 stated…NTSB LAX83LUQ05Accident · No injuriesFinal reportPiper PA-38-112 · Rosamond, CAA Piper PA-38, N9905T, and a Bellanca 8GCBC, N8667V, collided at the intersection of rwys 22 & 25, while the acft were landing. The Piper PA-38 was on a dual instructional flt while the Bellanca was being used to tow gliders. The aircrew in the PA-38 saw the…NTSB CHI83LA275Accident · No injuriesLimited investigationFinal reportCessna 152 · Kalamazoo, MIThe aircrew of a Cessna 152, N93407, landed on rwy 17 & turned off on taxiway e. they were instructed to hold short of rwy 23 & they complied. Shorly after the Cessna landed, the plt of a Boeing A75 stearman, N801RB, also landed on rwy 17 & turned off on the…NTSB CHI83LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paris, ILThe plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned…NTSB ANC83FAG04Accident · No injuriesFinal reportCessna 140 · Iliamna, AKThe aircraft collided with some hidden obstructions during an aborted takeoff. Th pilot realized his heavily loaded aircraft was not accelerating fast enough and aborted the takeoff. After turning left to avoid some metal drums, the aircraft collided with a…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 MKC83LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140B · Emporia, KSThe instructor pilot (ip) and a student were practicing stop-and-go landings in a Cessna 152, N89585, at an uncontrolled airport. The ip reported that they were monitoring the UNICOM frequency and had announced their intentions before each stop-and-go. The ip…NTSB NYC82DA231Accident · No injuriesFinal reportPiper PA-38-112 · Pomona, NJWhile taxiing from landing, the pilot attempted to pass between a parked aircraft and a parked fuel truck. The wingtip of the taxiing aircraft hit a fender on the truck.NTSB NYC82DA190Accident · No injuriesFinal reportCessna 152 · Lebanon, NHThe pilot landed at the uncontrolled airport to refuel. After receiving an in-person weather briefing, he filed a VFR flight plan. He contacted the fss on the airport advisory frequency and advised that he ws taxiing and would be making an intersection…NTSB ATL82IA218Incident · No injuriesIncident investigationFinal reportCessna 152 · Hampton, GADuring taxi after landing, this aircraft struck 3 aircraft positioned on the northside of the taxiway. The parked aircraft were normally tied down on the south side of the taxiway, but had been repositioned by airport personnel to facilitate cutting the grass…NTSB CHI82FEV06Accident · No injuriesFinal reportCessna 152 · Jacksonville, ILLanding was made on sod rwy 4. Touchdown was approximately 60 ft prior to crossing the hard surface parallel taxiway for rwy 13/31. The nose wheel broke off upon contact with the hard surface of the parallel taxiway. There was an approximate 2 inch lip…