NTSB investigations: Lycoming 0-320 series, CA
24 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power”. 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 | 3 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1990 | 2 |
| 1991 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
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\" = 'CA' 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\" = 350))
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" = 'CA' 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" = 350))
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 LAX07LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAa loss of engine power for undetermined reasons.NTSB SEA07CA085Accident · No injuriesData collectionFinal reportPiper PA-18 · Tulare, CAThe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.NTSB LAX06LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lodi, CAa loss of engine power for undetermined reasons. A factor was the trees.NTSB LAX04LA124Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Upland, CAA partial loss of engine power for undetermined reasons during takeoff.NTSB LAX04CA098Accident · No injuriesData collectionFinal reportCessna 172P · Granada Hills, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB LAX03LA265Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Avenal, CAthe pilot's failure to maintain directional control during a precautionary landing. The reason for the partial loss of engine power was undetermined.NTSB LAX02LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeside, CAThe failure of the engine to respond for undetermined reasons. Also causal was the student's decision to continue the simulated emergency maneuver to an altitude that was insufficient to allow for contingency options. The unsuitable nature of the terrain…NTSB LAX01LA221Accident · No injuriesLimited investigationFinal reportCessna 172M · Napa, CALoss of engine power due to the restricted movement of the number 1 exhaust valve that subsequently bent the exhaust push rod and push rod housing.NTSB LAX00LA321Accident · No injuriesLimited investigationFinal reportFogerson Richard D RV-6A · El Monte, CAThe loss of engine power for undetermined reasons.NTSB LAX00LA295Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newell, CAA hidden depression in the ground that resulted in the collapse of the landing gear during the forced landing roll.NTSB LAX97LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Barbara, CAthe pilot's improper planning/decision, which resulted in loss of engine power, due to fuel exhaustion. His psychological condition was a related factor.NTSB LAX96LA071Accident · No injuriesLimited investigationFinal reportCessna 172M · Palm Springs, CAthe pilot's inadequate bounced landing recovery technique, which resulted in porpoising during a downwind emergency landing. The loss of engine power for undetermined reasons was a factor.NTSB LAX94LA277Accident · No injuriesLimited investigationFinal reportCessna 172 · Hanford, CAThe failure of the pilot to stop the aircraft in a timely manner after landing back on the runway following a loss of engine power for undetermined reasons.NTSB LAX91LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Jose, CAFuel starvation due to the flight instructor's improper use of the fuel selector valve and his failure to properly supervise the conduct of the flight.NTSB LAX91LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Fullerton, CAThe pilot's improper preflight inspection. Contributing to this accident was water in the fuel tank.NTSB LAX91DUM01Accident · 1 fatalFinal reportPiper PA28-140 · El Cajon, CAThe pilot's failure to maintain flying speed. Contributing to the accident was an engine power loss for undetermined reasons.NTSB LAX90LA204Accident · No injuriesLimited investigationFinal reportRobinson R22A · Torrance, CAThis accident was a dynamic roll over due to the right skid encountering soft soil during the forced landing.NTSB LAX86FVG05Accident · Serious injuriesFinal reportBrown Pitts Special · Bridgeville, CAWitnesses reported the plt made 4 or 5 low passes over the rwy prior to the accident. During each pass the acft was rolled inverted, the eng would quit and the plt would roll the acft upright. On the last pass, according to witnesses, the eng quit again, the…NTSB LAX85LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Clovis, CAOn initial climb, at 400 ft AGL, the acft's rt engine lost fuel pressure. Then all right engie power was lost. The lt eng continued to operate normally. The plt failed to feather the rt prop & allowed the acft to slow to the point where a mvc roll commenced.…NTSB LAX85LA158Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Fremont, CAThe acft contacted a barbed wire fence and rough terrain during an emergency landing following a loss of pwr shortly after takeoff. The plt stated that two pwr interruptions occurred during the takeoff before the final pwr loss and he suspected fuel…NTSB LAX83LA463Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Tulelake, CAThe plt reported that he made a low pass over the medicine lake area, then after circling for a few minutes, he climbed back to 7500 ft, established 2000 RPM & 70 KTS, & continued the flt. Appx 5 min later, he noticed that the trees appeared to be getting…NTSB LAX83LA432Accident · Minor injuriesLimited investigationFinal reportPiper PA23-150 · San Diego, CAThe student & instructor (CFI) were practicing touch & go landings. During takeoff from the 4th touch & go, the left eng lost power while climbing thru about 200 ft AGL. The CFI took control of the acft. At about the same time, the student saw oil coming from…NTSB LAX83LA270Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Concord, CAThe acft made a forced landing on the arpt after the engine lost power at 150-200 ft AGL on takeoff. The pilot said all preflt checks were normal. Post accident examination revealed no reason for a loss of power.