NTSB investigations: Lycoming O&VO-360 series, SC
9 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
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2007 | 1 |
Where
Open the mapLatest 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\" = 'SC' 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" = 'SC' 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 ATL07CA055Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Myrtle Beach, SCThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot's failure to follow emergency procedures when he failed to jettison the advertising banner prior to his forced landing in water.NTSB ATL04CA193Accident · No injuriesData collectionFinal reportCessna 177 · Anderson, SCThe pilot's inadequate preflight planning of fuel required for the flight and his improper in-flight decision, which resulted in a loss of engine power due to fuel exhaustion.NTSB MIA02FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cheraw, SCThe misrouting of the fuel lines to the fuel selector, which resulted in the use of a fuel tank with inadequate fuel supply, fuel starvation, and the loss of engine power. Contributing was the pilot's inadequate remedial action for conducting an emergency…NTSB ATL99LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Spartanburg, SCThe pilot's failure to manage the fuel supply which resulted in fuel starvation to the engine.NTSB ATL92LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soccastee, SCThe pilot's mismanagement of his fuel in that he exhausted fuel in one tank, then failed to select the tank with fuel.NTSB ATL90LA057Accident · No injuriesLimited investigationFinal reportMooney M20A · Parris Island, SCThe failure of the pilot to insure that sufficient fuel was aboard for the flight, resulting in fuel exhaustion.NTSB ATL87LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Greer, SCEngine quit during descent for landing. PIC lnded in field, left wing struck tree and was separated from acft. PIC rpted no mechanical malfunctions. On post crash exam eng ran properly and right wing fuel quantity sys was operable. No fuel stains were seen on…NTSB ATL86LA072Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Charleston, SCWhile on a personal cross-country flight the aircraft experienced a complete loss of power and made an emergency landing on a road 2.5 miles east of the airport. The pilot stated that the aircraft ran out of fuel.NTSB ATL82DA222Accident · Serious injuriesFinal reportBeech C23 · Greer, SCThe student pilot had received about three hours in this make and model of aircraft. After about 45 minutes of dual instruction, he was indorsed for solo flight, the instructor deplaned, and the student took off to fly locally. About 25 minutes later, the…