NTSB investigations: Lycoming 0-320 series, ID
9 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
| 1984 | 2 |
|---|---|
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 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\" = 'ID' 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" = 'ID' 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 SEA07LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, IDThe pilot's inadequate in-flight planning by failing to refuel while en route which resulted in fuel exhaustion and loss of engine power while on approach to the airport. Rough/uneven terrain was a factor.NTSB SEA06CA032Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Emmett, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor was the fence post.NTSB SEA05CA082Accident · No injuriesData collectionFinal reportPiper PA-28-140 · McCammon, IDA loss of engine power due to the pilot's inadequate in-flight decision/planning by failing to refuel while en route, resulting in fuel exhaustion. Factors contributing to the accident included the trees and fence.NTSB SEA04LA071Accident · Serious injuriesLimited investigationFinal reportKeller Prospector FK1 · Gibbonsville, IDThe pilot's failure to apply carburetor heat in icing conditions which resulted in a loss of engine power while in cruise flight. Factors contributing to the accident are unsuitable terrain for an emergency landing , trees and mountainous terrain.NTSB SEA94LA107Accident · No injuriesLimited investigationFinal reportRich RV-4 · Weston, IDThe pilot's failure to use carburetor heat. Factors include carburetor icing conditions, and no suitable site for a forced landing.NTSB SEA92LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Burley, IDFuel exhaustion when anticipated fuel consumption was not adequately calculated.NTSB SEA89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Meridian, IDThe pilot's failure to properly position the fuel selector, which resulted in fuel starvation, his failure to follow the emergency procedure, and his inadequate visual lookout (failure to see & avoid obstructions). The power line was a related factor.NTSB SEA84LA118Accident · Minor injuriesLimited investigationFinal reportVarga 2150-A · Mountain Home, IDThe student plt became lost on the last leg of his x-country, solo flt. He final determined that his position was over boise, ID, about 35 mi from his destination. He turned to follow railroad tracks. About 15 min later, the eng ceased operating due to fuel…NTSB SEA84LA079Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Idaho Falls, IDThe student plt was on a solo x-country flt & had refueled at twin Falls, ID. When she took off, both fuel tanks were full. While descending thru about 6000 ft, near the destination arpt, the eng sputtered & quit running. The student enriched the mixture,…