NTSB investigations: Lycoming 0-235 series, MO
11 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2005 | 1 |
| 2007 | 1 |
Where
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 c.\"eventStateOrRegion\" = 'MO' 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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" = 'MO' 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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 CHI07CA247Accident · No injuriesData collectionFinal reportPiper PA-18-135 · Kansas City, MOThe pilot's failure to manitain directional control during landing which resulted in the airplane striking a taxiway sign during the aborted landing. The crosswind and the sign were factors.NTSB CHI06CA017Accident · No injuriesData collectionFinal reportBellanca 7ECA · Cuba, MOThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB CHI98LA234Accident · No injuriesLimited investigationFinal reportAmerican AA-1TW · Point Lookout, MOthe failure of the tailwheel assembly due to corrosion. A factor associated with the accident was the overload failure of the right main landing gear.NTSB CHI97LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Chesterfield, MOthe student pilot's failure to maintain directional control of the airplane by overcompensating with the rudder. Factors associated with the accident were the excessive airspeed and the soft terrain.NTSB CHI95LA113Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Higginsville, MOthe pilot's inadequate compensation for wind conditions during the attempted takeoff. The gusty crosswind was a factor.NTSB CHI91LA289Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kansas City, MOThe pilot's misjudgement of the landing flare and not maintaining directional control during a landing touchdown and roll. A factor was the pilot's lack of total expereince.NTSB MKC90LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · St Charles, MOFailure of the pilot to maintain directional control of the aircraft, which resulted in an inadvertent ground swerve. Factors related to the accident were: the crosswind condition, the student's lack of total experience, and the building (hangar).NTSB MKC90LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · St Louis, MODirectional control not maintained by the pilot in command. A contributing factor was the gusty crosswind.NTSB MKC87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Marshfield, MOThe PIC made an uneventful cross country flt and touchdown to his destination arpt. During the rollout aft lndg, the PIC rptd a gust 90 degrees fm the left forced the acft to veer left and off the rwy. Tall grass was encountered aft the acft dptd the rwy…NTSB MKC86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fulton, MOThe pilot and his passenger were on a short flight to check the operation of a VOR receiver. While they were on the landing roll, a gust of wind turned the nose of the airplane to the left and the airplane ran off the runway and the right gear hit a runway…NTSB MKC82DA029Accident · No injuriesFinal reportCessna 152 · Cape Girardeau, MODuring his second solo flight, the student pilot landed in a slight left quartering headwind. He stated that he had left rudder applied on touchdown and the aircraft veered left into a snowbank and nose over.