Skip to content

NTSB investigations: Lycoming 0-235 series, ME

27 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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" = 'ME' 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

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\" = 'ME' 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" = 'ME' 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

Run 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 ERA24LA024Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Rangeley, METhe pilot’s failure to maintain directional control during the landing roll with a crosswind, after the right tailwheel spring separated.Oct 27, 2023 · N3910M · Substantial damage NTSB ERA20CA268Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Linconville, METhe pilot's improper landing flare, which resulted in a bounced landing and subsequent main landing gear collapse.Jul 18, 2020 · N4365M · Substantial damage NTSB GAA19CA213Accident · Minor injuriesData collectionFinal reportCessna 152 · Bangor, METhe pilot's improper landing flare, which resulted in a hard landing.Apr 14, 2019 · N4916B · Substantial damage NTSB ERA16CA303Accident · No injuriesData collectionFinal reportCessna 152G · Augusta, METhe pilot's failure to compensate for the gusting wind conditions during a short-field landing and the designated pilot examiner's delayed remedial action, which resulted in the wing tip contacting the runway during the go-around.Jul 1, 2016 · N4916B · Substantial damage NTSB ERA11LA501Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Monmouth, MEOperation of the airplane by a non-certificated pilot and his failure to maintain airplane control.Aug 18, 2011 · N5048Z · Substantial damage NTSB NYC06LA228Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Orient, METhe pilot's failure to maintain adequate airspeed during the initial climb which resulted in an inadvertent stall. A factor was his inadequate weight and balance calculations and the gusty wind conditions.Sep 22, 2006 · N4459M · Destroyed NTSB NYC06CA069Accident · No injuriesData collectionFinal reportCessna 152 · Augusta, METhe pilot's improper flare, which resulted in a hard landing.Feb 15, 2006 · N47105 · Substantial damage NTSB NYC03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Turner, METhe pilot's misjudgment of distance which resulted in an overrun.Nov 9, 2002 · N223T · Substantial damage NTSB NYC99LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, MEImproper recovery from a bounced landing.Sep 13, 1999 · N5337L · Substantial damage NTSB NYC96LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Castine, MEthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Factors relating to the accident were: false indication from the fuel quantity gauge, and soft terrain in the emergency…Jul 28, 1996 · N65530 · Substantial damage NTSB BFO95LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Belfast, MEthe student pilot's failure to adequately compensate for wind conditions. A related factor was the presence of high snowbanks along the sides of the runway.Mar 4, 1995 · N5554Z · Substantial damage NTSB NYC93LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Fryeburg, METhe student pilot's improper recovery from a bounced landing resulting in the collapse of the nose gear and the subsequent nose over. A factor was an improper flare.Aug 8, 1993 · N25211 · Substantial damage NTSB NYC88LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Turner, METhe pilot said he preflighted the aircraft before departure. The pilot stated that he flew in the local area taking photos, then had started back towards the airport when the engine began to sputter. The pilot called bangor air rescue, checked instruments and…May 23, 1988 · N46413 · Substantial damage NTSB NYC84LA067Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Monson, MEOn a crosscountry VFR flight the pilot inadvertently encountered instrument conditions. During a climb to clear surrounding mountains the acft struck trees and crashed. The pilot had been briefed on the deteriorating weather prior to the flight. The pilot and…Jan 6, 1984 · N86706 · Substantial damage NTSB NYC83LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · Millinocket, MEAfter a solo x-country flt, the plt misjudged the landing flare & landed on the nose wheel. The acft bounced at least twice. The prop, nosewheel & crankshaft was damaged.Jul 26, 1983 · N5357P · Substantial damage NTSB NYC80FNC35Accident · No injuriesClosedChampion 7ECA · Scarborough, MEJul 26, 1980 · N2830G · Substantial damage NTSB NYC79DNC79Accident · Minor injuriesClosedPiper PA-16 · Fayette, MEJun 16, 1979 · N6831K · Substantial damage NTSB NYC78DNC50Accident · No injuriesClosedCessna 152 · Waterville, MESep 6, 1978 · N69019 · Substantial damage NTSB NYC75FNC05Accident · Minor injuriesClosedPiper PA-16 · Bowdoinham, MEJul 16, 1974 · N5260H · Substantial damage NTSB NYC74DNC46Accident · No injuriesClosedChampion 7ECA · N.Canada Plant, MEJun 8, 1974 · N5139G · Substantial damage NTSB NYC74DNC13Accident · Minor injuriesClosedAmer Avco AA-1A · Alton, MEJul 25, 1973 · N6379L · Substantial damage NTSB NYC71FFG19Accident · No injuriesClosedChampion 7ECA · Pittsfield, MEMar 28, 1971 · N6324N · Substantial damage NTSB NYC69F0268Accident · Serious injuriesClosedPiper PA-22 · Phippsburg, MENov 3, 1968 · N5042Z · Substantial damage NTSB NYC68D0117Accident · No injuriesClosedPiper PA-22 · Augusta, MEAug 11, 1967 · N5042Z · Substantial damage NTSB NYC67F0652Accident · No injuriesClosedPiper PA-22 · Old Town, MEMay 4, 1967 · N4529Z · Substantial damage NTSB NYC67D0549Accident · No injuriesClosedPiper PA-12 · Fairfield, MEMar 3, 1967 · N4345M · Substantial damage NTSB NYC67D0063Accident · No injuriesClosedPiper PA-22 · Bristol, MEJul 7, 1966 · N5528Z · Substantial damage