NTSB investigations: Lycoming 0-235 series, 2002
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 | 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
Open the mapLatest 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\") = 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')
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") = 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')
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 CHI03LA042Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Faulkton, SDThe directional control not maintained during an after landing taxi on the runway by the student pilot. The student pilot's lack of experience and downhill terrain off the runway were contributing factors.NTSB LAX03LA035Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Livermore, CAThe pilot's failure to maintain directional control during landing. A factor in the accident was the crosswind.NTSB LAX03LA002Accident · No injuriesLimited investigationFinal reportKline KSE5A · Sedona, AZthe pilot's failure to compensate for the wind conditions resulting in a loss of directional control during the takeoff roll. A contributing factor was the pilot's incorrect installation of the left wheel, which resulted in a locked left wheel when the brakes…NTSB NYC02LA179Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Stow, MAThe pilot's improper recover from a bounce landing, which resulted in a loss of directional control and collision with a vehicle. A factor in this accident was the crosswind condition.NTSB MIA02LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe student pilot's failure to maintain control of the airplane during the takeoff roll/run which resulted in the airplane departing the runway and into a ditch where it nosed over incurring substantial damage.NTSB MIA02LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Hialeah, FLThe failure of the pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch and subsequent nose over of the airplane.NTSB ATL02LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Immokalee, FLThe student pilot's failure to maintain directional control while attempting a touch and go landing resulted in an on-ground collision with a ditch. A factor in this accident was the student pilot's lack of experience.NTSB MIA02LA120Accident · No injuriesLimited investigationFinal reportCessna 152 · Valdosta, GAThe failure of the student pilot to maintain directional control during takeoff, resulting in an on ground encounter with an adjacent ditch and a collapsed nose gear strut during the attempt to abort the takeoff.NTSB SEA02LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Troutdale, ORImproper compensation for wind conditions while landing. Factors include a taxiway marker.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 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.