NTSB investigations: Lycoming 0-320 series, OH
13 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2002 | 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\" = 'OH' 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" = 'OH' 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 CHI07CA057Accident · Serious injuriesData collectionFinal reportBarron Thorp T18 · Edinburg, OHThe pilot's improper in-flight decision not to refuel prior to fuel exhaustion. A factor to the accident was the tree line that the airplane impacted during the forced landing.NTSB NYC02LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Huron, OHThe dual student's inadvertent shutdown of the engine and the certified flight instructor's inadequate supervision. A factor was the lack of suitable terrain.NTSB IAD02LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Port Columbus, OHThe pilot's exhaustion of his fuel supply. A factor in the accident was the pilot's inadequate preflight planning.NTSB IAD99LA001Accident · No injuriesLimited investigationFinal reportCessna 172K · Middlefield, OHThe pilot's inadequate preflight inspection which resulted in fuel exhaustion.NTSB NYC98LA067Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Brookville, OHThe pilot's misjudgment of the fuel supply.NTSB IAD97LA116Accident · Minor injuriesLimited investigationFinal reportBeech Musketeer 23 · Wauseon, OHThe pilot's fuel mismanagement by his failure to switch fuel tank positions, which resulted in the fuel starvation and the loss of engine power.NTSB CHI90DEI01Accident · No injuriesFinal reportChampion 7GCAA · Ashland, OHThe pilot's failure to adequately preflight the airplane prior to takeoff. Resulting in a fuel leak going undetected.NTSB CHI90DEK02Accident · Minor injuriesFinal reportEickmeier Pitts Special/S1C · Van Buren, OHA total loss of engine power for an undetermined reason.NTSB CHI89LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Middletown, OHFuel starvation from improper movement of the fuel selector by the pilot and his improper use of emergency procedures during the attempted engine restart. Contributing factors were the pilot's lack of experience in this type of aircraft and the terrain…NTSB ATL86LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Tiffin, OHAbout four minutes after take-off the engine lost power and the pilot attempted a forced landing in a corn field. Examination of the aircraft showed water and other contamination in the fuel system.NTSB CHI85LA066Accident · No injuriesLimited investigationFinal reportCessna 177 · Cadiz, OHThe acft was damaged during a forced landing after the eng failed inflight. The plt stated that about 10 miles west of harrison airport the eng began sputtering & running rough. When unable to regain full power the plt attempted to glide to tapan airpark, a…NTSB CHI84LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lancaster, OHThe acft landed in a plowed field during an off arpt forced landing after power loss in the traffic pattern for landing. The arpt manager reported that when he reached the acft the carburetor heat was off. The pilot said she thought she usedit but was not…NTSB CHI83LA296Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Kelleys Island, OHThe acft lost power on takeoff and collided with trees about 1/4 mile off the end of the rwy. The pilot said he prefltedand removed about 1/2 ounce of water from each tank, none from the gascolator. Inspection after the accident revealed water in the…