NTSB investigations: Lycoming 0-320 series, PA
17 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 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1994 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
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\" = 'PA' 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" = 'PA' 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 NYC07LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · E.Stroudsburg, PAThe pilot's improper fuel management resulting in loss of engine power.NTSB NYC07LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Catherine Twp., PAThe pilot's improper use of carburetor heat. Contributing to the accident were the weather conditions conducive to the formation of carburetor ice.NTSB NYC06LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Smoketown, PAThe pilot's improper pre-flight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB NYC06LA028Accident · No injuriesLimited investigationFinal reportCessna 172L · Lehighton, PAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power during takeoff due to fuel contamination, and a subsequent forced landing to a field.NTSB IAD01LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Lewisberg, PAThe loss of engine power for undetermined reasons.NTSB NYC98LA173Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Duncannon, PAThe pilot's disregard of the fuel condition during the preflight which resulted in a takeoff with contaminated fuel and a loss of power. A factor was the pilot's lack of recent experience.NTSB BFO94LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Butler, PAThe pilot's failure to select the proper fuel tank, which resulted in fuel starvation and the loss of engine power.NTSB NYC92LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Blaine Hill, PAA leaking fuel line which resulted in a power loss and inflight fire. A factor related to the accident was the rolling terrain.NTSB NYC91LA241Accident · No injuriesLimited investigationFinal reportRobinson R22B · Wexford, PAThe pilot's improper procedures during a practice autorotation, and selection of unsuitable terrain. Contributing to the accident was a loss of engine power for undetermined reasons, at a low altitude.NTSB NYC91LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PADue to failure of the induction air control/air filter/screen, which blocked airflow through the carburetor throat.NTSB NYC91LA026Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Saxton, PAAn engine failure due to fuel starvation and the subsequent forced landing in unsuitable terrain. Factors related to the accident were the cfi's inadequate execution of emergency procedures.NTSB NYC90LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Coatesville, PAImproper planning/decision by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB NYC88LA054Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Honesdale, PAShortly after takeoff from runway 35 at cherry ridge airport, Honesdale, Pennsylvania, the aircraft experienced an engine power loss and crashed about 200 feet off the end of the runway. Examination of the aircraft after the accident revealed no fuel in the…NTSB NYC84FGM07Accident · Serious injuriesFinal reportPiper PA-28-140 · South Fork, PAUpon departure the plt estimated 25 gal of fuel. The total power loss occurred 1 hr and 55 min later. After the forced ldg on unimproved terrain no evidence of fuel remained in the fuel system. There was no indication of any full spill from the ruptured left…NTSB NYC84LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Wilkes-Barre, PADuring flt, the eng lost power from fuel exhaustion & the plt tried to land on a highway. According to witnesses, when he tried to maneuver into the northbound land, while traveling south, the right main gear hit the side of a bank. The wing fuel tanks were…NTSB NYC83LA068Accident · No injuriesLimited investigationFinal reportCessna 177 · Reading, PAThe flt departed belfast at 1100. After passing Reading the plt noticed the right tank gauge rise from 1/2 to full. Approximately 3 mi from Reading a 180 deg turn was made to return to Reading. About 1 mi from the arpt the eng surged. A call was made to the…NTSB NYC82FGM14Accident · Serious injuriesFinal reportPiper PA-28-140 · Shanksville, PADuring preflight the plt estimated he had about 18 gals of fuel on board. Approximately 10 min after takeoff the eng quit due to fuel exhaustion. The acft collided with a power line pole during the forced landing. The arpt's FBO stated that fuel was not…