NTSB investigations: Lycoming 0-235 series, 2009

50 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 per year

19642026
NTSB investigations: Lycoming 0-235 series, 2009 per year, 1964–2026: 4,597 cases
1964137
1965122
196698
196792
196878
196954
197074
197182
197273
197368
197468
197569
197664
197786
1978152
1979167
1980153
1981147
1982148
1983149
1984148
1985101
198699
1987120
1988111
1989100
199086
199185
199268
199373
199472
199584
199674
199777
199869
199958
200076
200176
200267
200353
200461
200572
200647
200755
200846
200950
201030
201136
201239
201335
201419
201523
201642
201733
201840
201933
202030
202123
202232
202325
202410
202523
202615

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 year(c.\"eventDate\") = 2009
    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 WPR10FA078Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Ojai, CAAirspeed was not maintained, which resulted in a loss of control and the airplane entering into a stall/spin to the ground. Contributing to the accident was a loss of engine power due to carburetor icing.Dec 10, 2009 · N2463K · Substantial damageNTSB WPR10LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAA total loss of engine power for undetermined reasons.Dec 8, 2009 · N2539D · Substantial damageNTSB ERA10CA090Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Patillas, PRThe pilot's inadequate visual lookout and failure to maintain clearance from a tree.Dec 2, 2009 · N2539K · Substantial damageNTSB ERA10CA046Accident · Minor injuriesData collectionFinal reportAmerican AA1 · Lake Placid, FLThe pilot's failure to maintain clearance from a power line.Nov 3, 2009 · N7266L · Substantial damageNTSB ERA10CA045Accident · No injuriesData collectionFinal reportBeech 77 · Gainesville, FLThe pilot's failure to maintain aircraft control during landing.Nov 1, 2009 · N6715V · Substantial damageNTSB CEN09LA597Accident · 1 fatalLimited investigationFinal reportPiper PA-12 · Columbia, MOThe pilot's continued visual flight into instrument meteorological conditions, which included low ceilings and fog, and his failure to maintain control of the airplane. Contributing to the accident was the partial loss of engine power as a result of water…Sep 22, 2009 · N3234M · Substantial damageNTSB ANC09LA102Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Lime Village, AKThe passenger's inadvertent interference with, and application of the right brake pedal during takeoff.Sep 16, 2009 · N2594M · Substantial damageNTSB ERA09CA522Accident · No injuriesData collectionFinal reportCessna 152 · Merritt Island, FLThe student pilots failure to maintain directional control after landing.Sep 15, 2009 · N93772 · Substantial damageNTSB WPR09LA446Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. AA-1B · Creswell, ORA partial loss of engine power due to the malfunction of the engine's right magneto.Sep 12, 2009 · N9682L · Substantial damageNTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.Sep 9, 2009 · N94741 · 2 aircraft · Substantial damageNTSB CEN09CA568Accident · No injuriesData collectionFinal reportGrumman American Avn. AA-1C · Holland, MIThe pilot's failure to maintain control of the airplane during the landing and subsequent go-around.Sep 2, 2009 · N9649U · Substantial damageNTSB WPR09CA430Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear strut.Aug 31, 2009 · N5155B · Substantial damageNTSB ERA09CA504Accident · No injuriesData collectionFinal reportCessna 152 · Harrisburg, PAThe student pilot’s delayed decision to abort the takeoff, resulting in an overrun.Aug 31, 2009 · N69124 · Substantial damageNTSB CEN09CA560Accident · No injuriesData collectionFinal reportPiper PA-12 · Gonvick, MNA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Aug 28, 2009 · N2409M · Substantial damageNTSB ANC09CA087Accident · No injuriesData collectionFinal reportPiper PA-12 · Dillingham, AKThe pilot's decision to land on unsuitable soft, wet terrain, which resulted in a nose-over on landing.Aug 23, 2009 · N92770 · Substantial damageNTSB ERA09LA468Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Mount Holly, NJA loss of directional control during landing for undetermined reasons.Aug 18, 2009 · N7556H · Substantial damageNTSB WPR09FA398Accident · 2 fatalField investigationFinal reportCessna 152 · Hesperia, CAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall/spin. Also causal was the failure of the left magneto due to improper assembly of the drive gear during installation on the…Aug 16, 2009 · N67361 · Substantial damageNTSB WPR09CA392Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Kamiah, IDThe failure of the student pilot to maintain directional control during landing.Aug 11, 2009 · N939RG · Substantial damageNTSB WPR09CA394Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Sisters, ORThe pilot's failure to maintain directional control during the landing roll.Aug 9, 2009 · N7670H · Substantial damageNTSB CEN09LA490Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Whitney, TXA partial loss of engine power for undetermined reasons.Aug 3, 2009 · N1644R · Substantial damageNTSB WPR09LA380Accident · Serious injuriesLimited investigationFinal reportDavenport DAVE-EZ · Santa Monica, CAThe loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control during the forced landing.Aug 2, 2009 · N7CE · Substantial damageNTSB ERA09LA413Accident · 1 fatalLimited investigationFinal reportCessna 152 · Ponce, PRThe airplane’s impact with water for undetermined reasons.Jul 19, 2009 · N5518P · DestroyedNTSB ERA09CA373Accident · No injuriesData collectionFinal reportCessna 152 · Mt. Pleasant, SCThe pilot's improper recovery from a bounced landing.Jun 28, 2009 · N49897 · Substantial damageNTSB CEN09CA387Accident · No injuriesData collectionFinal reportCessna 152 · Oklahoma City, OKThe pilot's failure to maintain control of the airplane during landing.Jun 24, 2009 · N67797 · Substantial damageNTSB CEN09CA367Accident · No injuriesData collectionFinal reportCessna 152 · Fort Collins, COThe pilot's failure to control the airplane after engine startup, resulting in a ground collision with a nearby airplane.Jun 18, 2009 · N95144 · Substantial damageNTSB WPR09LA293Accident · 2 fatalLimited investigationFinal reportChampion 7ECA · Lake Elsinore, CAA loss of airplane control for undetermined reasons.Jun 17, 2009 · N8339V · Substantial damageNTSB WPR09CA274Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Grangeville, IDThe pilot's failure to maintain clearance from an obstacle during taxi.May 28, 2009 · N25353 · Substantial damageNTSB ERA09CA306Accident · Minor injuriesData collectionFinal reportCessna 152 · Lumberton, NJThe pilot's failure to maintain aircraft control during initial climb, which resulted in a loss of adequate airspeed and a subsequent aerodynamic stall.May 25, 2009 · N49396 · Substantial damageNTSB ERA09CA292Accident · No injuriesData collectionFinal reportCessna 152 · Memphis, TNThe pilots' decision to fly at a low altitude and their inadequate visual lookout while maneuvering.May 15, 2009 · N6529M · Substantial damageNTSB CEN09LA277Accident · 2 fatalLimited investigationFinal reportChampion 7GCBC · Surrey, NDThe pilot’s failure to maintain control of the airplane during an abrupt pull-up maneuver, which resulted in an aerodynammic stall at low altitude.May 3, 2009 · N5106T · DestroyedNTSB CEN09CA279Accident · Minor injuriesData collectionFinal reportAmerican AA-1 · Cumberland, WIThe pilot's failure to maintain control of the aircraft during takeoff in crosswind conditions.May 3, 2009 · N5905L · Substantial damageNTSB ERA09CA275Accident · No injuriesData collectionFinal reportPiper PA-12 · Georgetown, SCThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot’s lack of experience in the make and model airplane.Apr 29, 2009 · N3036M · Substantial damageNTSB WPR09LA205Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAA partial loss of engine power during takeoff due to carbon fouling of a spark plug.Apr 20, 2009 · N48259 · Substantial damageNTSB WPR09FA200Accident · 2 fatalField investigationFinal reportChampion 7ECA · San Jose, CAThe pilot's failure to maintain airspeed while maneuvering within a canyon in mountainous terrain, which resulted in an inadvertent stall/spin.Apr 18, 2009 · N5174X · Substantial damageNTSB ANC09LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Talkeetna, AKThe pilot's failure to maintain adequate airspeed to avoid an aerodynamic stall while maneuvering at a high density altitude.Apr 17, 2009 · N46326 · Substantial damageNTSB WPR09LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Glendale, AZA loss of engine power due to the failure of both magnetos resulting from an improper maintenance repair by maintenance personnel.Apr 15, 2009 · N6285M · Substantial damageNTSB ERA09FA235Accident · 1 fatalField investigationFinal reportGrumman AA-1B · Chesnee, SCA loss of engine power in flight due to fuel starvation as a result of the pilot's inadequate inflight fuel planning and the pilot's failure to maintain airspeed while descending for a forced landing.Apr 7, 2009 · N8998L · Substantial damageNTSB WPR09CA172Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's improper flare and improper recovery from a bounced landing.Mar 19, 2009 · N95429 · Substantial damageNTSB CEN09CA215Accident · Minor injuriesData collectionFinal reportMcCurdy Pro Star PT-2 · Springfield, ILThe pilot's failure to maintain directional control during the landing roll.Mar 16, 2009 · N2102 · Substantial damageNTSB ERA09LA199Accident · No injuriesLimited investigationFinal reportShniderman Ervin Stanley LONG-EZ · Manassas, VAA fire of undetermined origin in the engine compartment.Mar 14, 2009 · N770EZ · Substantial damageNTSB CEN09FA195Accident · 2 fatalField investigationFinal reportGrumman American Avn. AA-1B · Golden, NMThe pilot's continued visual flight into instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of alcohol and his subsequent impairment.Mar 9, 2009 · N9646L · DestroyedNTSB ERA09CA181Accident · No injuriesData collectionFinal reportCessna 152 · Crystal River, FLThe student pilot's improper recovery from a bounced landing.Mar 5, 2009 · N94563 · Substantial damageNTSB CEN09CA200Accident · No injuriesData collectionFinal reportCessna 152 · Fort Wayne, INThe student pilot's improper flare and recovery from a bounced landing.Feb 24, 2009 · N94626 · Substantial damageNTSB WPR09LA124Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Salinas, CAThe pilot's failure to maintain clearance from a wire while intentionally maneuvering at a low altitude.Feb 22, 2009 · N2835G · Substantial damageNTSB WPR09LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Turlock, CAThe loss of engine power due to carburetor icing resulting from the pilot's failure to apply carburetor heat. Contributing to the accident was the instructor's inadequate supervision of the flight.Feb 18, 2009 · N48761 · Substantial damageNTSB CEN09LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilot's improper flare and recovery from a bounced landing.Feb 14, 2009 · N6300Q · Substantial damageNTSB WPR09CA107Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's failure to maintain directional control during the takeoff roll.Contributing to the accident was the student pilot's decision to initiate the takeoff with the airplane positioned near the left edge of the runway.Feb 2, 2009 · N95606 · Substantial damageNTSB ERA09CA142Accident · No injuriesData collectionFinal reportCessna 152 · Titusville, FLA loss of engine power during approach due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Jan 25, 2009 · N48570 · Substantial damageNTSB ERA09LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Wauchula, FLA loss of engine power due to failure of the Number 3 connecting rod due to oil contamination. Contributing to the accident was the insufficient oil change time intervals performed by company personnel.Jan 18, 2009 · N6566P · Substantial damageNTSB WPR09CA073Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's failuire to maintain directional control during takeoff.Jan 5, 2009 · N45969 · Destroyed