NTSB investigations: Lycoming 0-235 series, 2005

72 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 year(c.\"eventDate\") = 2005
    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 SEA05LA099Accident · No injuriesLimited investigationFinal reportHorvath Pitts S-1C · Creswell, ORLoss of engine power as a result of a carburetor float drop restriction during cruise flight. Tall grass in the landing area was a factor in the accident.May 14, 2005 · N81PU · Substantial damageNTSB SEA05CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Snohomish, WAThe pilot's failure to maintain aircraft control during the landing roll on a sandbar which resulted in the aircraft nosing over.May 11, 2005 · N7755H · Substantial damageNTSB LAX05LA158Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · San Luis Obispo, CAa loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.May 7, 2005 · N42LC · Substantial damageNTSB IAD05CA059Accident · No injuriesData collectionFinal reportCessna 152 · Millville, NJThe pilot's misjudgment of the airplane's distance to the restaurant sundeck.May 4, 2005 · N5150B · Substantial damageNTSB CHI05CA107Accident · No injuriesData collectionFinal reportWhittman Tailwind · Lyndon, KSThe pilot improper recovery from a bounced landing, and his inadequate compensation for a tailwind, which resulted in a loss of control and subsequent collision with the ground. Contributing to the accident was the pilot's selection of a wrong runway, the…Apr 27, 2005 · N74849 · Substantial damageNTSB DFW05CA108Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH-2000 · Panhandle, TXThe student pilot's improper compensation for existing wind conditions. Contributing factors were the crosswind and inadequate supervision by the flight instructor.Apr 25, 2005 · N215LF · Substantial damageNTSB DFW05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Perry, OKA loss of engine power for undetermined reasons. A contributing factor was collision with a piece of farm equipment.Apr 21, 2005 · N228T · Substantial damageNTSB NYC05FA069Accident · 2 fatalField investigationFinal reportCessna 152 · Williamsburg, OHAn improperly installed rudder bumper, which resulted in a rudder jam during spin training and subsequent uncontrolled descent into terrain. A factor was the operator did not comply with the service bulletin.Apr 11, 2005 · N24779 · Substantial damageNTSB DFW05CA101Accident · No injuriesData collectionFinal reportCessna 152 · Stillwater, OKThe student pilot's failure to maintain directional control during landing.Apr 8, 2005 · N68472 · Substantial damageNTSB ATL05LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, NCThe loss of engine power due to the failure of the carburetor mixture cable which resulted in fuel starvation.Apr 5, 2005 · N48820 · Substantial damageNTSB DFW05CA097Accident · No injuriesData collectionFinal reportCessna 152 · Shawnee, OKThe pilot's improper landing flare and his inadequate recovery from a bounced landing. A factor was the prevailing crosswind.Apr 2, 2005 · N5086Q · Substantial damageNTSB ATL05CA070Accident · No injuriesData collectionFinal reportCessna 152 · Goose Creek, NCThe student pilot's failure to maintain direction control, which resulted in a loss of control and collision with a berm.Mar 30, 2005 · N714TK · Substantial damageNTSB IAD05LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Royal, VAA loss of engine power due to the pilot's inadequate preflight planning which resulted in fuel exhaustion.Mar 16, 2005 · N64986 · Substantial damageNTSB SEA05LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Covington, WAThe failure of connecting rods during cruise flight resulting in a loss of engine power. Trees were a factor.Mar 8, 2005 · N65579 · Substantial damageNTSB DFW05LA083Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Austin, TXThe loss of engine power due to the failure of the number three connecting rod. Contributing factors were the foreign object located within the engine lubrication system, inadequate inspection of the engine by other maintenance personal, and the lack of…Mar 8, 2005 · N3870W · Substantial damageNTSB DEN05LA060Accident · 2 fatalLimited investigationFinal reportPiel Emeraude CP-305 · Del Norte, COThe pilot's failure to maintain clearance with the terrain for undetermined reasons.Mar 1, 2005 · N9091 · DestroyedNTSB DFW05CA068Accident · No injuriesData collectionFinal reportBeech BE77 · Angleton, TXThe loss of engine power as result of fuel exhaustion due to the pilot's improper in-flight planning. A contributing factor was the lack of suitable terrain for the forced landing.Feb 13, 2005 · N6717S · Substantial damageNTSB LAX05LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Hana, HIForeign object damage inside an engine cylinder, which resulted in a loss of engine power during climb to cruise, and an off-airport forced landing.Feb 6, 2005 · N7332L · Substantial damageNTSB NYC05CA050Accident · No injuriesData collectionFinal reportCessna 152 · Kelleys Island, OHThe pilot's failure to maintain obstacle clearance during landing.Feb 5, 2005 · N4649M · Substantial damageNTSB CHI05LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Sturtevant, WIThe pilot's failure to identify the electrical system failure and to maintain adequate airspeed during the landing approach. Factors associated with the accident were the electrical system failure, the snow covered terrain, and the pilot's lack of experience.Feb 3, 2005 · N68714 · Substantial damageNTSB ATL05CA045Accident · Minor injuriesData collectionFinal reportCessna 152 · Nashville, TNA loss of engine power due to fuel starvation as a result of fuel system blockage.Jan 17, 2005 · N24218 · Substantial damageNTSB CHI05CA054Accident · No injuriesData collectionFinal reportCessna 152 · Stockton, MOthe pilot's failure to attain the proper touchdown point, which resulted in an overrun. Contributing factors were the tailwind and dusk light conditions.Jan 13, 2005 · N714UV · Substantial damage