NTSB investigations: Lycoming 0-320 series, CO
12 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1999 | 1 |
| 2004 | 2 |
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\" = 'CO' 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\" = 353))
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" = 'CO' 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" = 353))
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 DEN05LA017Accident · Serious injuriesLimited investigationFinal reportMiller Vans RV4 · Dotsero, COthe pilot's improper in-flight planning and decision making and the loss of engine power due to carburetor ice. Contributing factors include the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB DEN04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Lyons, COa loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing and the road sign.NTSB DEN00LA035Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Brighton, COThe pilot's not following preflight procedures, the starvation of fuel to the engine, and the lack of suitable terrain for a forced landing.NTSB DEN90LA185Accident · No injuriesLimited investigationFinal reportCessna 172M · Parker, COThe dual student pilot's improper use of the aircraft power plant controls, resulted in a complete loss of engine power.NTSB DEN89LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Erie, COThe pilot said that he made a normal preflight and engine runup prior to takeoff on runway 33 at the tri-county airport, Erie, Colorado. A normal takeoff was made but he said that as the aircraft reached 200 feet, the engine lost about 400 RPM. When he…NTSB DEN86LA001Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Cortez, COAfter 3.9 hrs flt time on a x-country flt from cheyenne, WY, to Cortez, CO, the plt experienced an eng failure due to fuel exahustion. He executed a forced landing in a mountain meadow that was not adequate in length for the landing. The acft impacted trees…NTSB DEN84LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Kiowa, COWhile practicing a simulated engine failure the student plt inavertantly shut off the fuel. During the actual forced landing in a rough field, the acft contacted a yucca plant and a gear collapse resulted. The CFI later reported the spring loaded safty stop…NTSB DEN84LA291Accident · No injuriesLimited investigationFinal reportCessna 172P · Longmont, COThe plt was making a low pass over a strip he wanted certified. During an attempted go-around the eng would not respond so the plt landed. The acft ran off the end of the wet sod airstrip and nosed over. The plt said after the accident that the carburetor…NTSB DEN83LA176Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Elbert, COThe acft engine quit while the plt was performing aerobatics, an airstart was unsuccessful and a forced landing was madein an open field surrounded by trees. During the landing one wing hit a tree causing the acft to veer into a creek. The plt said he had…NTSB DEN83LA151Accident · No injuriesLimited investigationFinal reportCessna 172 · Ellicott, COThe acft collided with a fence during a forced landing after the engine quit. The plt was descending from airwork at 10800 ft MSL to return to the arpt. The engine was reduced to idle and the carburetor heat was on but the engine would not respond when the…NTSB DEN83LA020Accident · No injuriesLimited investigationFinal reportPiper 28-140 · Fort Collins, COThe pilot failed to enrich mixture during descent from 10,000 feet. Power was lost during the approach and a forced landing made in a pasture. During the landing the aircraft collided with a fence and ground-looped collapsing the landing gear.NTSB DEN82DA163Accident · No injuriesFinal reportPiper PA-28-140 · 5nm Colorado Sp, COThe pilot on a cross-country landed after 2.4 hrs. No refueling crew was found so he measured 15 gals into each tank forabout 25 gals each. The next leg was 3.5 hours. At 3.3 hrs both tanks were out of useable fuel 6 miles from the destination. A forced…