NTSB investigations: Lycoming 0-235 series, 1983, MI
6 cases on aircraft whose registry engine model is Lycoming 0-235 series. 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
| 1964 | 4 |
|---|---|
| 1965 | 4 |
| 1966 | 3 |
| 1967 | 1 |
| 1968 | 4 |
| 1969 | 2 |
| 1970 | 5 |
| 1971 | 2 |
| 1972 | 4 |
| 1973 | 3 |
| 1974 | 4 |
| 1975 | 2 |
| 1976 | 3 |
| 1977 | 2 |
| 1978 | 8 |
| 1979 | 11 |
| 1980 | 3 |
| 1981 | 9 |
| 1982 | 7 |
| 1983 | 6 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 5 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 3 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 1 |
| 2006 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
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.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
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'))
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."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA'
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'))
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 CHI84FA037Accident · 2 fatalField investigationFinal reportCessna 152 II · Decatur, MIThe acft impacted trees and the ground during a night x-country in deterotiated weather about 3/4 of a mi ssw of keeler,MI, VOR. Witnesses heard the acft circling at low alt but did see the acft due to clouds, drizzle and fog. The sound of the eng was…NTSB CHI84LA005Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Portage, MIThe student plt was on his 1st solo flt. He stated that during the 1st landing, the acft turned right while it was still a few feet off the ground. The plt reported that he had a bad landing so he attempted to go around. During the go-around, the acft turned…NTSB CHI83LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe acft bounced during landing and collapsed the nose gear. The student pilot was practicing landings and had been successful on 4. The fifth in the series was intended to be the last one. The pilots recommendation for prevention was to go around as soon as…NTSB CHI83LA307Accident · No injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Leslie, MIThe acft landed hard and bounced. The acft drifted left off the rwy and nosed over in a plowed area. The landing was on rwy 18 and the wind was from 270 degrees at 8 KTS. The student pilot said he needed more dual time in crosswind landings. He had 11 hours…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 CHI83LA072Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Detroit, MIThe plt stated that as she was crossing the threshold she noticed that the acft had been blown over too FAR to the rightof the rwy. After correcting for this, she leveled off too high & the acft nosed down onto the rwy.