NTSB investigations: Lycoming 0-235 series, 1998
13 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 | 33 |
|---|---|
| 1983 | 23 |
| 1984 | 33 |
| 1985 | 22 |
| 1986 | 27 |
| 1987 | 30 |
| 1988 | 35 |
| 1989 | 19 |
| 1990 | 15 |
| 1991 | 16 |
| 1992 | 11 |
| 1993 | 19 |
| 1994 | 17 |
| 1995 | 28 |
| 1996 | 14 |
| 1997 | 13 |
| 1998 | 13 |
| 1999 | 13 |
| 2000 | 12 |
| 2001 | 14 |
| 2002 | 11 |
| 2003 | 8 |
| 2004 | 11 |
| 2005 | 14 |
| 2006 | 7 |
| 2007 | 10 |
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 year(c.\"eventDate\") = 1998
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 year(c."eventDate") = 1998
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 CHI99LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Appleton, WIThe pilot's failure to maintain directional control. A related factor was the crosswind.NTSB FTW99LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student pilot's loss of directional control due to improper use of the rudder. A factor was the hilly terrain beyond the departure end of the runway.NTSB MIA99LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Cartersville, GAFailure of the student pilot to maintain directional control during landing resulting in the aircraft running off the left side of the runway and colliding with a parked aircraft. Factors in the accident were his distraction while raising wing flaps during…NTSB MIA99LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe student pilot's failure to maintain directional control on takeoff, resulting in the airplane's excursion off the runway and collision with trees.NTSB SEA98LA187Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Medford, ORDirectional control was not maintained.NTSB CHI98LA359Accident · No injuriesLimited investigationFinal reportCessna 152 · West Lafayette, INthe student pilot's failure to maintain directional control during the touch and go takeoff.NTSB ANC98LA135Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's selection of an unsuitable area for takeoff. A factor associated with the accident is the pilot's premature liftoff.NTSB LAX98LA257Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Van Nuys, CAThe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control that subsequently lead to a ground loop/swerve.NTSB IAD98LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Culpeper, VAFailure to maintain directional control during the takeoff roll. A related factor was wind gusts.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 FTW98LA199Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Collins, COthe student pilot's improper use of the rudder controls, which resulted in loss of directional control, a ground swerve, an encounter with soft terrain, and a nose over. The soft terrain was a related factor.NTSB FTW98LA180Accident · No injuriesLimited investigationFinal reportCessna A152 · Brigham City, UTfailure of the pilot to maintain directional control of the airplane during a touch and go landing. Related factors were: the pilot allowed his attention to be diverted into the cockpit for an excessive amount of time, and the encounter with a ditch.NTSB ATL98LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · La Belle, FLthe student pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. The gusty crosswind condition was a related factor.