NTSB investigations: Lycoming 0-320 series
461 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, newest first
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.\"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."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 DEN04LA011Accident · No injuriesLimited investigationFinal reportCessna 177 · Nageezi, NMthe pilot's inadequate preflight planning, inadequate fuel consumption calculations, and improper fuel management. Contributing factors include fuel exhaustion resulting in the loss of power, the lack of suitable terrain for a forced landing and the tree.NTSB NYC04CA001Accident · No injuriesData collectionFinal reportWilliams RV-4 · Metz, WVThe pilot's improper decision to operate without accurate fuel gauges, which resulted in a power loss due to fuel exhaustion, and an off airport landingNTSB MIA03TA175Accident · Serious injuriesFinal reportCessna 172P · Jay, FL**This case was modified on 2/18/2016. Refer to the public docket for this accident to view the changes.** Loss of engine power for undetermined reasons.NTSB ATL03LA120Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Canon, GAThe loss of engine power due to water and corrosion in the fuel system. A factor was the collision with a ditch.NTSB LAX03LA238Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lomita, CAThe partial loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat. Also causal was the pilot's failure to attain and maintain an adequate airspeed during the aborted landing, which resulted in a stall/mush.NTSB NYC03LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172K · White Marsh, MDThe pilot's in-flight decision to not land and refuel, which resulted in fuel exhaustion. A factor in the accident was the pilot's inadequate communications.NTSB CHI03LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Gridley, ILThe checklist not followed by the pilot and the fuel starvation of the engine. The incorrect fuel tank selector position by the pilot,, and the lack of recurrent training were contributing factors.NTSB LAX03LA184Accident · No injuriesLimited investigationFinal reportCessna 172K · Early, TXThe student pilot's inadequate in-flight planning/decision, which resulted in a loss of engine power while on approach to land, and subsequent off-airport landing.NTSB ATL03LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hamilton, ALThe pilot's inadequate preflight inspection by his failure to ensure adequate oil supply, which resulted in oil exhaustion and the failure of the connecting rod cap.NTSB LAX03LA171Accident · No injuriesLimited investigationFinal reportDenis Cozy · Kailua-Kona, HIA clogged fuel filter, which resulted in fuel starvation and a total loss of engine power during takeoff-initial climb.NTSB FTW03LA124Accident · No injuriesLimited investigationFinal reportRobinson R22 · Freer, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel en route. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB MIA03LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Potts Camp, MSThe pilot's inadequate planning which resulted in fuel exhaustion, a forced landing to a field, and damage to the airplane during the landing rollout.NTSB ANC03LA035Accident · No injuriesLimited investigationFinal reportAero Commander 100 · North Pole, AKThe flight instructor's improper usage of the airplane's fuel mixture control, resulting in a loss of engine power during takeoff.NTSB LAX03LA101Accident · No injuriesLimited investigationFinal reportCreitz, Robert D RV-3 · Deer Valley, AZThe pilot's improper use of carburetor heat, which resulted in carburetor icing and loss of engine power.NTSB LAX03LA047Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Scottsdale, AZThe pilot's inadequate preflight inspection and failure to refuel the airplane resulting in a loss of engine power due to fuel starvation.NTSB NYC03LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lakewood, NJThe pilot's improper use of carburetor heat which resulted in a failure to remove carburetor ice, and loss of engine power. A factor was the carburetor icing conditions.NTSB CHI02LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Moorhead, MNThe inadequate fuel management by the certified flight instructor.NTSB LAX02LA296Accident · Minor injuriesLimited investigationFinal reportWhetzel Thorpe T-18 · Valley Center, CAthe pilot's inadequate preflight planning/preparation by not verifying the fuel supply, and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor in the accident was the pilot's decision to initiate…NTSB IAD02LA095Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Edinburg, VAA loss of engine power for undetermined reasons.NTSB FTW02LA225Accident · Minor injuriesLimited investigationFinal reportSouthworth EAA Bi-Plane May Bee · West, TXThe pilot's inadequate preflight/planning inspection which resulted in fuel exhaustion and subsequent loss of engine power.NTSB LAX02LA237Accident · No injuriesLimited investigationFinal reportCessna 172P · Creston, CAthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor in the accident was the dark night conditions.NTSB CHI02LA185Accident · Minor injuriesLimited investigationFinal reportEskildsen P · Olathe, KSThe pilot's improper planning and decision making during the emergency descent and landing. The total loss of engine power due to fuel exhaustion and the pilot's inadvertent stall were contributing factors.NTSB DEN02LA066Accident · No injuriesLimited investigationFinal reportCessna 172M · Hite, UTthe pilot's improper in-flight planning resulting in fuel exhaustion. A factor relating to the accident was the unsuitable terrain encountered during the forced landing attempt.NTSB SEA02LA113Accident · No injuriesLimited investigationFinal reportCessna 177 · Mt. Vernon, WAThe pilot's failure to accurately determine the amount of fuel onboard. Factors included trees, and a portable restroom.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 LAX02LA182Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Mountain Ranch, CAthe pilot's inadequate preflight planning/preparation and his in-flight planning/decision resulting in fuel exhaustion and loss of engine power.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 CHI02LA114Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe pilot's improper fuel management resulting in the total loss of engine power due to fuel starvation and the pilot's failure to use the checklist.NTSB LAX02LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Diego, CAfuel starvation due to the pilot's mismanagement of the fuel system.NTSB NYC02LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Newbolds Corner, NJImproper maintenance which resulted in a loss of fuel and subsequent loss of engine power due to fuel exhaustion. Factors were the pilot's failure to monitor the fuel quantity gauges, and the gusty wind conditions.NTSB FTW02LA078Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Houston, TXthe loss of engine power due to fuel starvation as a result of the pilot's failure to switch fuel tanks. A factor was the lack of suitable terrain for the forced landing.NTSB FTW02FA072Accident · 1 fatalField investigationFinal reportCessna 177 · Farmington, NMthe pilot's inadequate in-flight planning decision which resulted in fuel exhaustion while in the traffic pattern at the destination airport.NTSB NYC02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Nantucket, MAa loss of engine power for undetermined reasons.NTSB MIA02LA015Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Gainesville, FLThe failure of both pilots to insure the airplane contained adequate fuel to complete the flight resulting in loss of engine power due to fuel exhaustion and collision with trees during a forced landing.NTSB MIA01LA226Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Daytona Beach, FLa total loss of engine power due to the pilot's improper procedures by not placing the fuel selector on the tank with the most fuel, after a reported restricted movement of the flight controls for undetermined reasons, which resulted in fuel starvation and a…NTSB LAX01LA265Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-150 · Hesperia, CAthe loss of engine power due to fuel exhaustion while maneuvering in an attempt to locate the runway. Contributing factors were the inadequate runway maintenance that resulted in inoperative runway edge lights, and the night light conditions.NTSB FTW01LA162Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Caldwell, TXthe solo student pilot's intentional engine shutdown, while practicing emergency landing prodecures. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC01LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rochester, NYFuel exhaustion, due to the student pilot's failure to monitor his fuel supply.NTSB LAX01LA180Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Tucson, AZThe pilot's inadequate preflight inspection, which included verifying the position of the fuel selector handle, which subsequently led to fuel starvation and a forced landing.NTSB FTW01LA112Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Marfa, TXfuel exhaustion resulting in a total loss of engine power in cruise flight due to the pilot's failure to refuel the aircraft. Contributing factors were the lack of suitable terrain for the forced landing, and the dark night condition.NTSB NYC01LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate fuel management, which resulted in fuel starvation.NTSB CHI01LA114Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Gary, INThe inadequate preflight performed by the pilot which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. Factors associated with the accident were the inaccurate fuel quantity indicator, the rock which resulted in the overload failure…NTSB NYC01LA080Accident · No injuriesLimited investigationFinal reportCessna 172I · Suffolk, VAThe pilot's improper in-flight planning/decision and his failure to refuel, which resulted in fuel exhaustion.NTSB FTW01LA022Accident · No injuriesLimited investigationFinal reportCessna 172K · Belcher, LAthe total loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive to carburetor icing and the lack of suitable terrain available for the forced landing.NTSB NYC01LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Winchester, VAThe pilot's failure to obtain a pre-departure or en route weather briefing, which led to fuel exhaustion, after his destination and alternate airports were covered by fog. A factor was the fog.NTSB LAX01LA033Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Livermore, CAThe pilot's lack of familiarity with the airplane's fuel system. This lead to the pilot inadvertently switching the fuel selector handle to the "OFF" position and subsequently to a loss of engine power due to fuel starvation.NTSB DEN01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Jensen, UTan undershoot due to misjudging distance/altitude during an emergency landing. Factors were: inadequate preflight, failure to refuel, fuel exhaustion, operating with an inoperative fuel gauge, and failure to attain a proper glide path during approach.NTSB IAD01LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Lewisberg, PAThe loss of engine power for undetermined reasons.NTSB ATL00LA089Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · St. Augustine, FLThe loss of engine power due to fuel system contamination.NTSB FTW00LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ennis, TXThe loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel selector positioning.