NTSB investigations: Lycoming 0-235 series, NC

102 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.\"eventStateOrRegion\" = 'NC' 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.

NTSB ATL87LA156Accident · No injuriesLimited investigationFinal reportCessna C-152 · Bunn, NCThe airplane nosed over during a precautionary ldg in a soft, dirt field. The plt and a mechanic had been ferrying the airplane back to its base after replacing the starter and battery solenoids, and the battery. The pre-flt run-up had revealed no problems…Jun 2, 1987 · N46411 · Substantial damageNTSB ATL87LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay Varina, NCThe student plt reported that the lt main wheel rolled off the rwy into mud during ldg rollout. This pulled the acft off the rwy and down an embankment into a ditch. The nose gear subsequently sank into the mud and the acft nosed down. The acft came to rest…Feb 1, 1987 · N64823 · Substantial damageNTSB ATL86LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Mocksville, NCDuring a landing attempt at a private grass airstrip, the acft bounced several times and the student plt initiated a go-around before the plt instructor was prepared. The acft cleared departure threshold powerlines in a nose high attitude at low airspeed and…May 31, 1986 · N49037 · Substantial damageNTSB 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.Mar 9, 1986 · N5276M · Substantial damageNTSB ATL85LA264Accident · No injuriesLimited investigationFinal reportPiper PA-18 105 · Hendersonville, NCDuring the takeoff phase of a touch & go landing, the CFR and private pilot lost directional control and ran off the side of the runway.Sep 1, 1985 · N323T · Substantial damageNTSB ATL85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hickory, NCDuring the landing roll, the plt lost directional control of the acft & it ground looped & ran off the rwy. The plt reported that the left tire went flat, the left gear collapsed & the left wing was damaged.May 27, 1985 · N2378M · Substantial damageNTSB ATL85FA147Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Monroe, NCThe acft collided with rwy 23 (aprx 120 ft from the departure end) following a loss of control during an initial takeoff climb. The acft was observed to enter a steep climb on takeoff after which the right wing dropped. The acft then entered a spin prior to…Apr 26, 1985 · N2490A · DestroyedNTSB ATL85LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Reidsville, NCThe plt was making a full stop landing and after bouncing a few times the acft nosed over. The plt said the acft porpoised and his attempts to recover were unsuccessful. The winds were calm and no mechanical malfunctions were reported.Nov 8, 1984 · N93152 · Substantial damageNTSB ATL85LA015Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charlotte, NCDuring attempted go-around from a bounced landing, the plt allowed the acft to drift off center line and into trees paralling the runway. Directional control was compromised by low flying speed.Oct 20, 1984 · N2388V · Substantial damageNTSB ATL85FA007Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Morgantown, NCN2553A was in traffic pattern conducting touch and go landings. N32828 was maneuvering below the traffic pattern and was seen climbing in direction of N2553A. N32828 was flying westerly into the sun. N2553A was seen in a shallow left turn from crosswind to…Oct 11, 1984 · N32828 · 2 aircraft · DestroyedNTSB ATL84LA244Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Liberty, NCThe instructor pilot retarted the throttle to simulate an engine failure on daownwind at 800 ft AGL after his student had completed a touch and go landing. The CFI then turned to land in the direction opposite the last takeoff, but was unable to achieve…Aug 6, 1984 · N9549T · Substantial damageNTSB ATL84LA243Accident · No injuriesLimited investigationFinal reportCessna 152 · Franklin, NCPlt stated an encounter with a downdraft at 3800 ft MSL caused acft collision with 2300 ft elevation of rising terrain. FBO overflew area within the hour and reported calm winds and no turbulence. Witnesses heard acft maneuvering at low altitude in valley…Aug 5, 1984 · N5406B · Substantial damageNTSB ATL84LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student reported that he flared too high & the acft bounced about 4 times after which it left the rwy. The nose gear collapsed as it contacted mud beside the rwy.May 5, 1984 · N757AS · Substantial damageNTSB ATL84LA113Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Rockingham, NCN92792 was being taxied from a tie down area when the prop struck the right wing on an unoccupied B-35, N8813A. The plt stated the brakes failed as he was attempting to taxi between two rows of parked acft and directional control was lost.Mar 4, 1984 · N92792 · Substantial damageNTSB ATL81FLJ01Accident · No injuriesClosedCessna 152 · Fort Bragg, NCDec 6, 1980 · N24327 · Substantial damageNTSB ATL80DKM25Accident · Minor injuriesClosedPiper PA-38 · Morganton, NCAug 1, 1980 · N9362T · DestroyedNTSB IAD80FKM12Accident · Minor injuriesClosedCessna 152 · Mayodan, NCMar 19, 1980 · N89192 · Substantial damageNTSB IAD79DKM09Accident · No injuriesClosedPiper PA-38 · Charlotte, NCFeb 20, 1979 · N6219A · Substantial damageNTSB IAD79FLJ04Accident · No injuriesClosedCessna 152 · Durham, NCJan 17, 1979 · N66944 · Substantial damageNTSB IAD78DKM21Accident · Minor injuriesClosedPiper PA-18 · Polkville, NCAug 27, 1978 · N309T · Substantial damageNTSB IAD78DKM11Accident · Serious injuriesClosedAeronca 7ECA · Burnsville, NCMay 15, 1978 · N68515 · Substantial damageNTSB IAD78DLJ07Accident · No injuriesClosedCessna 152 · Ft.Bragg, NCFeb 23, 1978 · N757QA · Substantial damageNTSB IAD76FLJ14Accident · No injuriesClosedBellanca 7ECA · Knightdale, NCOct 25, 1975 · N57674 · Substantial damageNTSB IAD75DLJ33Accident · No injuriesClosedPiper PA-16 · Jacksonville, NCJun 20, 1975 · N6830K · Substantial damageNTSB IAD74DKM05Accident · No injuriesClosedPiper PA-12 · Indian Trail, NCJul 22, 1973 · N3289M · Substantial damageNTSB IAD73DKM28Accident · No injuriesClosedPiper PA-18 · Burnsville, NCJan 1, 1973 · N252T · Substantial damageNTSB NYC72FKM32Accident · No injuriesClosedPiper PA-12 · Rockingham, NCApr 15, 1972 · N92792 · Substantial damageNTSB NYC72FLJ14Accident · Minor injuriesClosedPiper PA-12 · Beaufort, NCNov 7, 1971 · N3222M · Substantial damageNTSB IAD71FKM33Accident · No injuriesClosedChampion 7ECA · Star, NCApr 20, 1971 · N9007L · Substantial damageNTSB IAD71DKM31Accident · No injuriesClosedPiper PA-16 · Greensboro, NCMar 13, 1971 · N5623H · Substantial damageNTSB IAD71FLJ10Accident · No injuriesClosedKnight KT-115 · Clinton, NCAug 19, 1970 · N7801 · Substantial damageNTSB DIA70D0041Accident · No injuriesClosedPitts Spec S1C · Hendersonville, NCJul 2, 1969 · N2215 · Substantial damageNTSB DIA69F0177Accident · No injuriesClosedPiper PA-12 · Burlington, NCMay 4, 1969 · N3348M · Substantial damageNTSB DIA69F0030Accident · Serious injuriesClosedPiper PA-12 · White Lake, NCJul 21, 1968 · N4435M · Substantial damageNTSB DIA68D0174Accident · No injuriesClosedPiper PA-22 · Hickory, NCFeb 25, 1968 · N5265Z · Substantial damageNTSB DIA68F0155Accident · Minor injuriesClosedPiper PA-16 · Boone, NCFeb 4, 1968 · N5816H · Substantial damageNTSB DIA68F0079Accident · No injuriesClosedStinson HW-75 · Clinton, NCAug 30, 1967 · N21138 · Substantial damageNTSB DIA68D0033Accident · No injuriesClosedPiper PA-18 · King, NCJul 29, 1967 · N7158K · Substantial damageNTSB DIA68F0016Accident · No injuriesClosedPiper PA-12 · Winston-Salem, NCJun 11, 1967 · N4296M · Substantial damageNTSB DIA67D0067Accident · No injuriesClosedPiper PA-22 · Winston-Salem, NCApr 8, 1967 · N5837Z · Substantial damageNTSB MIA67F0266Accident · Minor injuriesClosedPiper PA-12 · Whitsett, NCNov 5, 1966 · N4459M · Substantial damageNTSB MIA67F0006Accident · Minor injuriesClosedPiper PA12 · China Grove, NCJun 15, 1966 · N3656M · Substantial damageNTSB MIA66F0353Accident · No injuriesClosedPiper PA-22 · Greensboro, NCDec 17, 1965 · N4836Z · Substantial damageNTSB MIA65F0076Accident · Minor injuriesClosedPiper PA-22 · Etowah, NCApr 30, 1965 · N5852Z · Substantial damageNTSB UNK65X1358Accident · No injuriesClosedPiper PA22 · Greensboro, NCJan 27, 1965 · N4836Z · Substantial damageNTSB UNK65X1276Accident · Minor injuriesClosedPiper PA22 · Winston Salem, NCJan 12, 1965 · N5947Z · DestroyedNTSB UNK65X0639Accident · No injuriesClosedPiper PA22 · Winston Salem, NCNov 10, 1964 · N5911Z · Substantial damageNTSB UNK65X0492Accident · Serious injuriesClosedPiper PA22 · Pilot, NCOct 30, 1964 · N4750Z · Substantial damageNTSB UNK65X0384Accident · No injuriesClosedPiper PA16 · Ft Bragg, NCOct 23, 1964 · N5342H · DestroyedNTSB UNK64X1374Accident · No injuriesClosedPiper PA22 · Sunbury, NCApr 19, 1964 · N4759Z · Substantial damage