NTSB investigations: Lycoming 0-235 series, 1983
7 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “On ground/water collision with object”. 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 | 6 |
|---|---|
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 4 |
| 1997 | 6 |
| 1998 | 4 |
| 1999 | 1 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 3 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 2 |
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\") = 1983
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\" = 310))
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") = 1983
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" = 310))
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 MIA84LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Bunnell, FLThe plt of the C-172 stated that as he entered the landing pattern he observed another company C-172 making landings & took an appropriate interval behind the observed traffic. The plt of the C-152 stated he made his approach behind an acft he observed in the…NTSB MKC84LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Augusta, KSThe acft collided with a truck while taxiing out for takeoff. The plt said that when he saw the truck coming from the opposite direction along the side of the rwy he slowed down and steered to the opposite side of the taxiway. The driver of the truck made no…NTSB ATL83LA296Accident · No injuriesLimited investigationFinal reportCessna T210N · N. Myrtle Beach, SCCessna T-210N, N6190C was struck by Piper J-3C, N42183, while taxiing at grand strand arpt. N6190C was not in motion at the time of collision and had taxied into the grass and turned off the acft eng in anticipation of the collision. The plt of N42183 stated…NTSB LAX83LUQ05Accident · No injuriesFinal reportPiper PA-38-112 · Rosamond, CAA Piper PA-38, N9905T, and a Bellanca 8GCBC, N8667V, collided at the intersection of rwys 22 & 25, while the acft were landing. The Piper PA-38 was on a dual instructional flt while the Bellanca was being used to tow gliders. The aircrew in the PA-38 saw the…NTSB CHI83LA275Accident · No injuriesLimited investigationFinal reportCessna 152 · Kalamazoo, MIThe aircrew of a Cessna 152, N93407, landed on rwy 17 & turned off on taxiway e. they were instructed to hold short of rwy 23 & they complied. Shorly after the Cessna landed, the plt of a Boeing A75 stearman, N801RB, also landed on rwy 17 & turned off on the…NTSB CHI83LA270Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paris, ILThe plt of the Grumman G-164A, N952X, reported that after the acft was loaded & fueled, he started to taxi northbound on a taxiway from the ramp to the rwy. At about the same time, a student plt in a Cessna 152, N67449, had landed on the rwy & turned…NTSB ANC83FAG04Accident · No injuriesFinal reportCessna 140 · Iliamna, AKThe aircraft collided with some hidden obstructions during an aborted takeoff. Th pilot realized his heavily loaded aircraft was not accelerating fast enough and aborted the takeoff. After turning left to avoid some metal drums, the aircraft collided with a…