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.
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" 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 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.NTSB 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.NTSB 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.NTSB IAD05CA059Accident · No injuriesData collectionFinal reportCessna 152 · Millville, NJThe pilot's misjudgment of the airplane's distance to the restaurant sundeck.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB DFW05CA101Accident · No injuriesData collectionFinal reportCessna 152 · Stillwater, OKThe student pilot's failure to maintain directional control during landing.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB DEN05LA060Accident · 2 fatalLimited investigationFinal reportPiel Emeraude CP-305 · Del Norte, COThe pilot's failure to maintain clearance with the terrain for undetermined reasons.NTSB 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.NTSB 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.NTSB NYC05CA050Accident · No injuriesData collectionFinal reportCessna 152 · Kelleys Island, OHThe pilot's failure to maintain obstacle clearance during landing.NTSB 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.NTSB ATL05CA045Accident · Minor injuriesData collectionFinal reportCessna 152 · Nashville, TNA loss of engine power due to fuel starvation as a result of fuel system blockage.NTSB 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.