NTSB investigations: Lycoming 0-320 series, IL
14 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power”. 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 | 2 |
|---|---|
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1998 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 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\" = 'IL' 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 ('41508')
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\" = 350))
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" = 'IL' 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 ('41508')
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" = 350))
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 CHI07LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Columbia, ILThe certified flight instructor's (CFI's) inadequate preflight planning/preparation of a test altitude that would afford an on airport landing in the event of engine power loss. Additional causes were the CFI not flying a traffic pattern that would allow for…NTSB CHI06CA136Accident · No injuriesData collectionFinal reportMiller Rutan Long-Ez · Morris, ILThe partial loss of engine power during the final approach to landing for undetermined reasons, and the unsuitable terrain for landing encountered by the pilot. The tall grass was a factor.NTSB CHI06LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Schaumburg, ILThe loss of engine power for an undetermined reason during takeoff-initial climb.NTSB CHI06FA030Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Bloomington, ILThe aircraft control not possible by the pilot during a visual approach to the runway due to the physical impairment of the pilot.NTSB CHI04LA070Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Casey, ILThe pilot not maintaining aircraft control during the loss of engine power and his improper remedial action during the encountered uncommanded roll (VMC roll). An additional cause was the pilot's failure to obtain a maintenance inspection by a qualified…NTSB CHI02LA263Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Seneca, ILThe loss of engine power for undetermined reasons. Factors were the low altitude, the trees, and the unsuitable terrain encountered for the forced landing.NTSB CHI01LA199Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Albion, ILthe maintenance performed on the airplane by the unqualified pilot The unsuitable takeoff area selected by the pilot was an additional cause. The ditch was a contributing factor.NTSB CHI98LA335Accident · No injuriesLimited investigationFinal reportCessna 172 · Harrisburg, ILthe loss of engine power for undetermined reasons.NTSB CHI98LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · New Lenox, ILLoss of engine power for undetermined reasons.NTSB CHI91LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Freeburg, ILImproper use of the mixture control by the pic/cfi. A factor related to the accident was inadequate friction on the mixture control lever.NTSB CHI89DEE04Accident · No injuriesFinal reportRenninger Mustang II · Kirkland, ILFuel starvation (possibly from vapor lock), which resulted in loss of engine power, and the pilot's misjudgement of ground clearance during a final turn to land.NTSB CHI86FEV01Accident · Minor injuriesFinal reportCessna 177 · Canton, ILThe acft sheared the nose gear in a forced landing off arpt in a partially cultivated field. The acft had lost power at about 100 ft AGL during takeoff. The plt said that he checked the mixture, throttle, fuel selector and turned on the electric fuel pump.…NTSB CHI83LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Schaumburg, ILThe newly purchased aircraft had just been delivered and the pilot elected to fly it a short period to check its operation. He performed one takeoff and landing, then started another takeoff. He reported that during the second takeoff, the engine lost power…NTSB CHI82DA362Accident · No injuriesFinal reportCessna 172 · Park Forest, ILThe pilot stated there was a partial loss of power during the takeoff roll. He reported that there was insufficient runway remaining to stop when the power loss occurred. The available airspeed was used to "hop" over a 3-foot embankment, but the nose gear,…