NTSB investigations: Lycoming 0-235 series, 2002
67 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\") = 2002
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") = 2002
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 CHI02LA107Accident · No injuriesLimited investigationFinal reportCessna 152 · Maple Lake, MNThe student pilot's inadequate flare and compensation for the crosswind condition during landing. A factor to the accident was the crosswind condition.NTSB ATL02FA074Accident · 1 fatalField investigationFinal reportPiper PA-16 · Lakeland, FLThe failure of the PA-16 pilot to maintain a visual lookout and to yield the right-of-way to a lower aircraft while on final approach resulting in a midair collision. Contributing to the accident was the failure of both pilot's to adhere to an ATC clearance…NTSB LAX02LA124Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lake Elsinore, CAThe pilot lost awareness of his location and collided with trees. Factors in the accident were the mountainous terrain and night conditions.NTSB LAX02LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Boulder City, NVa loss of engine power due to an undetermined malfunction of the carburetor.NTSB ATL02LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe students pilot's failure to perform a go-around after a bounced landing condition that resulted in the on-ground collision with a ditch.NTSB CHI02LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Christopher, ILThe in-flight collision with a Canadian goose, which caused substantial damage to the airplane's right wing. A factor to the accident was the dark night light condition.NTSB FTW02LA093Accident · No injuriesLimited investigationFinal reportTillman Long EZ · Lockhart, TXthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA02LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Longmont, COThe pilot's failure to maintain directional control of the aircraft during landing. Factors were a contaminated runway, which was icy and covered with snow, and a snow bank.NTSB LAX02FA097Accident · 1 fatalField investigationFinal reportGrumman American AA1B · Pomona, CAa total loss of engine power due to an excessively rich mixture setting in the carburetor. The overly rich operation of the carburetor was due to the overhaul shop's failure to obtain the proper clearance between the float and chamber walls, which allowed the…NTSB ATL02LA052Accident · No injuriesLimited investigationFinal reportCessna 152 · Hudson, FLTotal loss of engine power due to oil starvation to the No. 3 connecting rod preceded by aft displacement of the center main bearing due to excessive wear. This resulted in a forced landing to none suitable terrain and subsequent on-ground collision with a…NTSB LAX02LA089Accident · No injuriesLimited investigationFinal reportBeech 77 · Long Beach, CAA loss of directional control due to the pilot's inadequate compensation for the existing crosswind condition.NTSB ATL02LA050Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Blowing Rock, NCThe pilot's in-flight decision to continue flight into an area with high winds that resulted in an in-flight encounter with a downdraft and subsequent loss of control of the airplane and collision with terrain.NTSB FTW02LA073Accident · No injuriesLimited investigationFinal reportCessna 152 · Ardmore, OKthe instructor pilot's delayed go-around which resulted in an in-flight collision with trees. A contributing factor to the accident was the instructor pilot's fatigued condition due to lack of sleep.NTSB DEN02LA021Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Logan, UTthe pilot's failure to maintain aircraft control during landing roll. Contributing factors were the runway's patchy snow and ice conditions and a snow bank along the side of the runway.NTSB LAX02LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Tehachapi, CAthe pilot's failure to maintain an adequate airspeed while maneuvering in an attempt to gain altitude, which resulted in an inadvertent stall/mush. The high density altitude was a factor in the accident.NTSB ATL02LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Clewiston, FLThe student pilot's inadequate compensation for wind, and failure to maintain directional control. A contributing factor was a crosswind.NTSB LAX02FA059Accident · 1 fatalField investigationFinal reportCessna 152 · Petaluma, CAThe pilot's intentional flight of the airplane into terrain in an act of suicide.