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.
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" 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 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…NTSB 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…NTSB 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…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 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB ATL81FLJ01Accident · No injuriesClosedCessna 152 · Fort Bragg, NCNTSB ATL80DKM25Accident · Minor injuriesClosedPiper PA-38 · Morganton, NCNTSB IAD80FKM12Accident · Minor injuriesClosedCessna 152 · Mayodan, NCNTSB IAD79DKM09Accident · No injuriesClosedPiper PA-38 · Charlotte, NCNTSB IAD79FLJ04Accident · No injuriesClosedCessna 152 · Durham, NCNTSB IAD78DKM21Accident · Minor injuriesClosedPiper PA-18 · Polkville, NCNTSB IAD78DKM11Accident · Serious injuriesClosedAeronca 7ECA · Burnsville, NCNTSB IAD78DLJ07Accident · No injuriesClosedCessna 152 · Ft.Bragg, NCNTSB IAD76FLJ14Accident · No injuriesClosedBellanca 7ECA · Knightdale, NCNTSB IAD75DLJ33Accident · No injuriesClosedPiper PA-16 · Jacksonville, NCNTSB IAD74DKM05Accident · No injuriesClosedPiper PA-12 · Indian Trail, NCNTSB IAD73DKM28Accident · No injuriesClosedPiper PA-18 · Burnsville, NCNTSB NYC72FKM32Accident · No injuriesClosedPiper PA-12 · Rockingham, NCNTSB NYC72FLJ14Accident · Minor injuriesClosedPiper PA-12 · Beaufort, NCNTSB IAD71FKM33Accident · No injuriesClosedChampion 7ECA · Star, NCNTSB IAD71DKM31Accident · No injuriesClosedPiper PA-16 · Greensboro, NCNTSB IAD71FLJ10Accident · No injuriesClosedKnight KT-115 · Clinton, NCNTSB DIA70D0041Accident · No injuriesClosedPitts Spec S1C · Hendersonville, NCNTSB DIA69F0177Accident · No injuriesClosedPiper PA-12 · Burlington, NCNTSB DIA69F0030Accident · Serious injuriesClosedPiper PA-12 · White Lake, NCNTSB DIA68D0174Accident · No injuriesClosedPiper PA-22 · Hickory, NCNTSB DIA68F0155Accident · Minor injuriesClosedPiper PA-16 · Boone, NCNTSB DIA68F0079Accident · No injuriesClosedStinson HW-75 · Clinton, NCNTSB DIA68D0033Accident · No injuriesClosedPiper PA-18 · King, NCNTSB DIA68F0016Accident · No injuriesClosedPiper PA-12 · Winston-Salem, NCNTSB DIA67D0067Accident · No injuriesClosedPiper PA-22 · Winston-Salem, NCNTSB MIA67F0266Accident · Minor injuriesClosedPiper PA-12 · Whitsett, NCNTSB MIA67F0006Accident · Minor injuriesClosedPiper PA12 · China Grove, NCNTSB MIA66F0353Accident · No injuriesClosedPiper PA-22 · Greensboro, NCNTSB MIA65F0076Accident · Minor injuriesClosedPiper PA-22 · Etowah, NCNTSB UNK65X1358Accident · No injuriesClosedPiper PA22 · Greensboro, NCNTSB UNK65X1276Accident · Minor injuriesClosedPiper PA22 · Winston Salem, NCNTSB UNK65X0639Accident · No injuriesClosedPiper PA22 · Winston Salem, NCNTSB UNK65X0492Accident · Serious injuriesClosedPiper PA22 · Pilot, NCNTSB UNK65X0384Accident · No injuriesClosedPiper PA16 · Ft Bragg, NCNTSB UNK64X1374Accident · No injuriesClosedPiper PA22 · Sunbury, NC