Fatal NTSB investigations: Lycoming 0-235 series, MI
11 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
| 1977 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 3 |
| 1982 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2006 | 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 c.\"eventStateOrRegion\" = 'MI' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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 c."eventStateOrRegion" = 'MI' AND c."eventCountry" = 'USA'
AND c."highestInjuryLevel" = 'Fatal'
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 CHI06LA073Accident · 2 fatalLimited investigationFinal reportBellanca 7ECA · Pontiac, MIThe excessive bank angle executed by the flight crew and their failure to maintain airspeed during the turn, which led to the inadvertent stall and subsequent impact with the ground. A factor was the low altitude.NTSB CHI03FA320Accident · 1 fatalField investigationFinal reportCessna 152 · Three Oaks, MIThe pilot not maintaining adequate airspeed resulting in a stall during takeoff. Contributing factors were the buzzing flight and trees.NTSB CHI00LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-16 · Chesaning, MIThe pilot failed to maintain clearance from the trees. A factor was the trees.NTSB CHI88FA188Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Flushing, MIPilot's physical incapacitation due to a coronary seizure, which resulted in a loss of aircraft control, and a stall/spin into the ground.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 CHI82FA236Accident · 2 fatalField investigationFinal reportCessna 152 · Morenci, MIThe flt departed the toledo surburban arpt at 1800 for a local instructional flt. One witness described the acft as flying very erratically. It was dipping from side to side & gaining & losing altitude very rapidly. He next observed the plane climb straight…NTSB CHI80DA008Accident · 1 fatalClosedPiper PA-28 · Plainwell, MINTSB CHI79FEC57Accident · 2 fatalClosedBreezy RLU-1 · Frazer, MINTSB CHI79FEM33Accident · 2 fatalClosedBreezy FGC100 · Grand Haven, MINTSB CHI78FA018Accident · 1 fatalClosedCessna 152 · Ypsilanti, MINTSB CHI77FEM22Accident · 1 fatalClosedAmer Avco AA1 · East Tawas, MI