NTSB investigations: Lycoming 0-235 series, 1983
9 cases on aircraft whose registry engine model is Lycoming 0-235 series, where the first occurrence was “In flight 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 | 9 |
|---|---|
| 1983 | 9 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 7 |
| 1988 | 5 |
| 1989 | 7 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 6 |
| 1993 | 3 |
| 1994 | 5 |
| 1995 | 3 |
| 1996 | 6 |
| 1997 | 3 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 1 |
| 2002 | 5 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 4 |
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\" = 220))
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" = 220))
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 ATL83LA383Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Apison, TNThe acft collided with trees and crashed during takeoff from a short grass strip in a downwind direction. The wind velocity was 9 KTS. The strip was 2300 ft long with 75 ft trees at the end. Under the existing conditions the takeoff could not be accomplished…NTSB FTW83LA368Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe acft collided with a fence and a powerline during takeoff climb. The student pilot was visiting a small field with A1300 ft rwy of sod for practice. The C-152 uses 1340 ft to clear a 50 ft obstabcle for a standard day on a surfaced rwy this day was above…NTSB LAX83LA352Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Mammoth Lakes, CAThe acft collided with trees while trying to maneuver through a mountain pass at 13000 ft MSL with the temperature at 82DEGREES. The plt stated that the acft started a high sink rate. He checked the throttle, mags and mixture but was forcedto settle into the…NTSB LAX83FVG13Accident · Serious injuriesFinal reportChampion 7ECA · Shingle Springs, CAThe acft collided with an oak tree while maneuvering at low alt. The weather was VMC. The pilot stated that he was flying to maintain a battery charge. He said he climbed to about 1600-1700 ft MSL and flew southeast. The average elevation along this route is…NTSB FTW83LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Bon Wier, TXThe acft collided with a fence during takeoff from an unimproved field. The plt and his wife had departed houston TX theday before for a 'local' flt. Due to mechanical difficulties a landing was made at Bon Wier. According to the plt, although relatives live…NTSB ANC83LA077Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Aniak, AKAccording to the plt, he was taking off downslope & downwind on bumpy muskeg/tundra with full flaps. At aprx 40 to 45 mph, the acft lifted off before reaching the edge of a deep ravine. He began a shallow left turn, then the left wing struck a tree which spun…NTSB ATL83LA152Accident · No injuriesLimited investigationFinal reportCessna 152 · Verbena, ALThe acft collided with a wire cable during a simulated emergency landing to an open field off the arpt. The pilot said he was flying locally and saw a field that looked large enough to land in so he reduced power to idle and was making a simulated emergency…NTSB MIA83LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLA student pilot on a supervised solo flight in a Cessna 152 collided with a remote controlled model airplane during climb out through 400 feet. The acft was damaged but the pilot was not injured. The model airplane was being operated from an adjacent park, by…NTSB FTW83FA134Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · La Grange, TXThe plt elected to takeoff to the north on a downsloping paved road. He reported that the wind was variable from the southwest at 2 to 4 KTS, gusting 4 to 6 KTS. At austin, TX, the wind was from 190 deg at 13 gusting 20 KTS & at college station, TX, it was…