NTSB investigations: Lycoming 0-235 series, 1985
6 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\") = 1985
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") = 1985
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 DEN86LA052Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA-1A Yankee · Cloudcroft, NMThe plt stated that he was following a highway from alamogordo, NM to roswell, NM. The plt continued to state that the highway lead him into an area of high terrain that his acft could not climb over. The plt was unable to turn around and executed an emerg…NTSB CHI86LA027Accident · No injuriesLimited investigationFinal reportCessna 152 · Lansing, MIThe acft struck wires during the recovery phase of a simulated forced landing apch. The plt continued the flt for aprx 1 hr after the wire strike and landed without incident. Examination of the acft revealed replacement of the right wing was needed.NTSB ANC86LAG05Accident · Minor injuriesFinal reportBeech BE77 · Hope, AKThe acft struck trees and crashed during a night takeoff from a gravel strip. The plt suspected an partial pwr loss, but incomplete information precluded a thorough investigation.NTSB SEA85LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, ORThe plt descended to a low alt over a river to look for birds. While over the river the plt spotted pwr lines at an alt of aprx 75 ft AGL. An attempt was made to fly under the lines, but the tail contacted the wires severing aprx 6 inches off the top portion…NTSB BFO85LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDAfter not obtaining surface wind info and not observing the wind sock, the student plt entered final apch without observing any significant drift. When the acft was at nose-up attitude. It floated and stopped descending for a few seconds. Suddenly, the plt…NTSB MKC85LA082Accident · No injuriesLimited investigationFinal reportCessna 152 · Herington, KSAcft tookoff from a 1900 ft long, sod, farm strip. Plt said acft became airborne at mid-field but felt mushy and would not climb. Acft collided with fence and bush at end of strip and sustained substantial damage. Acft remained airborne and continued to…