NTSB investigations: Lycoming O&VO-360 series, CO
8 cases on aircraft whose registry engine model is Lycoming O&VO-360 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2000 | 1 |
| 2003 | 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\" = '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 ('41514')
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 ('41514')
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 DEN03LA042Accident · No injuriesLimited investigationFinal reportBeech C23 · Pagosa Springs, COthe pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight. Contributing factors were the student pilot's improper flare, the instructor's inadequate remedial actions, and terrain conditions.NTSB DEN00LA137Accident · No injuriesLimited investigationFinal reportMooney M20C · Longmont, COThe pilot's improper fuel tank selector position resulting in fuel starvation and the ditch impacted during the landing roll. A contributing factor was the pilot's failure to follow published procedures and directives.NTSB FTW96LA304Accident · No injuriesLimited investigationFinal reportBeech 76 · Falcon, COA loss of engine power due to the pilot's inaccurate fuel consumption calculation, and his failure to properly identify the area of intended landing as an airport. A factor was the misrouting of the fuel line by unknown persons.NTSB FTW95LA315Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Silvercliff, COFailure by the pilot to fuel the aircraft which resulted in fuel exhaustion. A factor was unsuitable terrain for a forced landing.NTSB DEN91LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe pilot's failure to refuel and his misjudged fuel consumption calculations which resulted in fuel exhaustion power loss.NTSB DEN89LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA28-180 · Broomfield, COThe failure of the student to properly plan the flt resulting in fuel exhaustion.NTSB DEN85LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Yoder, COEngine quit during cruise flight. Pilot made forced landing on dirt road during which the acft veered off the road and collided with a fence post. Fire department officials reported no evidence of fuel either in the fuel tanks or around the acft.NTSB DEN83LA196Accident · No injuriesLimited investigationFinal reportBeech C23 · Longmont, COThe student plt, a foreign national, and the instructor plt (CFI) took off from broomfield, CO & flew to Longmont, CO where they began practicing touch & go landings. After the 3rd touch & go landing, the acft was climbing at about 300 ft AGL when the student…