NTSB investigations: Lycoming 0-320 series
14,588 cases on aircraft whose registry engine model is Lycoming 0-320 series. 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'))
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'))
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 ATL05FA082Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nashville, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an in flight loss of control, stall, and collision with trees and the ground. A factor was the pilot's impairment due to drugs.NTSB ANC05CA077Accident · No injuriesData collectionFinal reportPiper PA-18 · Dillingham, AKThe instructor pilot's inadequate supervision, and the dual student's failure to maintain directional control. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB SEA05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Puyallup, WAThe fatigue cracking of the upper torque link attach lugs on the right main landing gear strut, which resulted in separation of the right main landing gear.NTSB IAD05LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Dover, DEThe separated baffle which blocked the tailpipe resulting in a subsequent total loss of engine power.NTSB ATL05LA091Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Newnan, GAThe improper repair to the main landing gear assembly resulted in the actuator bracket failure and the right main gear collapse. A factor was the inadequate inspection of the right main landing gear.NTSB SEA05LA100Accident · No injuriesLimited investigationFinal reportCessna 152TW · Missoula, MTThe pilot's failure to maintain clearance from a taxiway identification sign as he attempted to turn off the runway onto the taxiway during the last part of the landing roll. Factors include a taxiway identification sign in the vicinity of the intersection of…NTSB MIA05CA100Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Fort Pierce, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. A contributing factor in the accident was the pilot's inadequate preflight planning/preparation to ensure an adequate fuel supply was available for the intended flight.NTSB LAX05LA159Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Tucson, AZa loss of engine power due to the fatigue fracture and separation of the mixture control cable. The fatigue crack resulted from inadequate installation techniques by unknown maintenance personnel.NTSB ANC05LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain control of the airplane, which resulted in a nose over during the landing roll. A factor contributing to the accident was uneven terrain.NTSB ANC05CA067Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing roll, and a collision with willows and a creek bank. A factor associated with the accident was the soft landing area.NTSB DFW05FA111Accident · 2 fatalField investigationFinal reportCessna 172 · Midland, TXThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the low altitude.NTSB NYC05CA076Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Indian Head, MDThe pilot's failure to maintain adequate altitude/clearance while on final approach, which resulted in an in-flight collision with trees. A factor in this accident was the gusty wind conditions.NTSB LAX05CA148Accident · No injuriesData collectionFinal reportCessna 172N · Palo Alto, CAThe student's failure to maintain directional control and the CFI's failure to adequately supervise the flight.NTSB CHI05CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · South Bend, INThe student pilot failed to compensate for the crosswind condition and failed to maintain directional control. Factors included the crosswind and the windsock.NTSB LAX05LA146Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22A · Kailua-Kona, HIa total loss of engine power due to the failure of the engine's #3 exhaust valve due to an excessive valve guide clearance. Contributing to the accident was the failure of maintenance personnel to adequately check the valve guide clearance during the last…NTSB IAD05LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Hampton, NHThe pilot's improper decision to depart with a tailwind, and his failure to perform preflight performance calculations.NTSB CHI05CA101Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Gordon, NEThe student pilot's failure to maintain direction control during landing. The pilot lack of familiarity with the airplane was a factor.NTSB NYC05CA073Accident · No injuriesData collectionFinal reportCessna 172N · Wellington, OHThe pilot's failure to obtain the proper touchdown point, and his failure to initiate a go-around, which resulted in an overrun during landing. A factor in the accident was the tail wind.NTSB ATL05LA073Accident · 1 fatalLimited investigationFinal reportAnderson Mini Mustang · Mullins, SCThe pilot's inadequate visual lookout and the pilot's failure to maintain clearance from trees while maneuvering.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 MIA05LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Groveland, FLThe pilot's poorly planned approach during a precautionary landing following partial loss of engine power resulting in a go-around and subsequent in-flight collision with trees. A contributing factor in the accident was the inadequate maintenance by the…NTSB DFW05LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Olney, TXThe loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.NTSB LAX05LA134Accident · Minor injuriesLimited investigationFinal reportNewell Thomas RV6-A · Hayward, CAA loss of engine power due to fuel system contamination. A factor in the accident was the fuel system not being flushed out after it was involved in a previous accident where the fuel tanks were damaged.NTSB IAD05LA060Accident · No injuriesLimited investigationFinal reportCessna 172 · Pikeville, KYThe pilot's improper flare, which resulted in a hard landing.NTSB ANC05LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKThe pilot's selection of an unsuitable landing site, which resulted in a loss of control and the airplane nosing over during the landing roll.NTSB SEA05CA080Accident · No injuriesData collectionFinal reportCessna 172 · Yamhill, ORThe pilot's failure to maintain aircraft control while on final approach for landing. A crosswind, a fence post and the pilot's inadequate compensation for the crosswind condition were contributing factors.NTSB SEA05LA070Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Corvallis, ORThe student pilot's failure to maintain directional control while attempting to turn in the direction necessary to air-taxi to the landing pad, and the flight instructor's failure to take remedial action soon enough to correct the problems created when the…NTSB ANC05CA054Accident · No injuriesData collectionFinal reportPiper PA-18 · Bethel, AKThe pilot's failure to compensate for a crosswind during an aborted landing, which resulted in a loss of directional control. A factor associated with the accident was a crosswind.NTSB DFW05CA100Accident · No injuriesData collectionFinal reportCessna 172L · Stephenville, TXThe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the prevailing crosswind.NTSB CHI05LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Waunakee, WIThe pilot's inadequate preflight planning and the delay in aborting the landing which resulted in the subsequent insufficient airspeed. Factors associated with the accident were the night light conditions, the fence, and the pole which the airplane contacted.NTSB LAX05CA127Accident · No injuriesData collectionFinal reportCessna 172L · Chino, CAthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB LAX05LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6C · Chino, CAthe pilot of the other airplane's failure to maintain an adequate clearance from obstacles while taxiing.NTSB LAX05CA121Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's failure to maintain directional control.NTSB ATL05CA064Accident · No injuriesData collectionFinal reportPiper PA28-151 · Eastman, GAThe certified flight instructors failure to maintain a visual look out while demonstrating a simulated emergency landing resulting in an in-flight collision with a known transmission wire.NTSB ANC05LA051Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Anchorage, AKA main landing gear collapse during the landing touch down due to a non-secured clevis bolt at the common attach point on the landing gear oleo shock.NTSB ANC05CA050Accident · Minor injuriesData collectionFinal reportPiper PA-18 · False Pass, AKThe pilot's inadequate compensation for the wind conditions during the initial climb after takeoff, which resulted in a collision with the ground and subsequent nose over. Factors contributing to the accident were a downdraft, and the pilot's inadequate…NTSB DFW05CA093Accident · Minor injuriesData collectionFinal reportCessna 172M · Spring, TXThe pilot's inadequate use of carburetor heat, which resulted in carburetor ice and the loss of engine power. A contributing factor was conditions conducive to carburetor icing.NTSB DFW05CA091Accident · No injuriesData collectionFinal reportCessna 172N · Rio Grande City, TXThe pilot's failure to maintain clearance from objects, and his improper compensation for wind conditions while landing. A contributing factor was the gusty wind condition.NTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.NTSB LAX05FA114Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Big Bear City, CAThe pilot's failure to maintain adequate airspeed that resulted in an inadvertent stall/mush during initial climb. Contributing factors were the pilot's inadequate preflight preparations and the high density altitude.NTSB SEA05CA063Accident · No injuriesData collectionFinal reportJeffs J-Bird · St. Paul, ORThe pilot's failure to maintain airspeed while maneuvering at low altitude, which resulted in an inadvertent stall and subsequent collision with terrain. A contributing factor was the pilot's decision to fly at low altitude.NTSB ATL05CA062Accident · Minor injuriesData collectionFinal reportCessna 172P · Redstone Arsnl, ALThe pilot's failure to maintain adequate airspeed during approach, which resulted in an inadvertent stall and subsequent collision with the runway. Factors were the turbulence and crosswind conditions.NTSB NYC05LA059Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Cameron, WVA loss of engine power due to carburetor icing, which resulted in a forced landing. A factor in this accident was the carburetor icing conditions.NTSB SEA05LA054Accident · 1 fatalLimited investigationFinal reportSimpkins RV-6A · Yamhill, ORThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in a nose over. Factors contributing to the accident included the wet runway and the embankment.NTSB ATL05CA058Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Suches, GAThe pilot's premature liftoff and failure to maintain adequate airspeed during takeoff, which resulted in an inadvertent stall/mush to the runway and subsequent collision with a fence during aborted takeoff.NTSB ANC05LA044Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's excessive taxi speed during a turn while taxiing from landing, which resulted in the collapse of the left main landing gear, and structural damage to the fuselage.NTSB CHI05CA075Accident · Serious injuriesData collectionFinal reportCessna 172K · Portage, WIThe pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…NTSB CHI05LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Macon, MOThe loss of engine power due to failure of the engine exhaust valve. The pilot's inability to maintain clearance from obstacles, the trees, the residence and the pilot's evasive maneuver were factors in the accident.NTSB ANC05FA037Accident · 1 fatalField investigationFinal reportCessna 172 · Cedar Key, FLThe pilot's continued flight into instrument meteorological conditions (IMC), and his failure to maintain adequate airspeed during an abrupt maneuver to avoid a power line, which resulted in an inadvertent stall, a loss of control, and subsequent collision…NTSB LAX05CA098Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Chandler, AZthe students pilot's failure to maintain directional control resulting in a collision with the taxiway sign.