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 ANC05LA127Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tyonek, AKThe instructor pilot's inadvertent touchdown during a low pass, and attempted go-around, which resulted in an in-flight collision with terrain, and nose over.NTSB SEA05LA162Accident · 2 fatalLimited investigationFinal reportHarmon/Lance RV-4 · Coolin, IDThe pilot's failure to maintain clearance from trees while maneuvering to base leg for landing. Trees and inadequate in-flight planning were factors.NTSB CHI05CA219Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Watertown, WIThe flightcrew's failure to maintain directional control during landing rollout.NTSB SEA05LA163Accident · No injuriesLimited investigationFinal reportSteele Safari · Leavenworth, WAThe failure of the tail rotor drive shaft during cruise flight. Factors include soft, grassy terrain at the location where the pilot executed the autorotational landing.NTSB SEA05CA159Accident · No injuriesData collectionFinal reportCessna 172M · Hoquiam, WAThe pilot's failure to maintain clearance from a fence. The fence was a factor.NTSB LAX05FA255Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · San Luis Obispo, CAThe pilot's continued flight into instrument meteorological conditions, and his failure to maintain clearance from the rising hilly terrain. Contributing factors were the pilot's inexperience regarding flying during the dark, nighttime condition, and the low…NTSB DFW05CA203Accident · No injuriesData collectionFinal reportCessna 172M · El Dorado, ARThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.NTSB NYC05LA125Accident · No injuriesLimited investigationFinal reportCessna 172P · Caldwell, NJThe pilot's improper flare, which resulted in a hard landing. A factor was a partial loss of engine power, as reported by the pilot, for undetermined reasons.NTSB CHI05CA205Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Holland, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.NTSB ANC05CA108Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Aleknagik, AKThe pilot's inadequate compensation for the gusty crosswind conditions during an aborted takeoff, which resulted in an on ground collision with a tree. Factors associated with the accident are the gusty crosswind, and the pilot's failure to maintain…NTSB IAD05LA113Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chatham, VAThe pilot's failure to ensure that the fuel selector valve was properly engaged, which resulted in fuel starvation and subsequent loss of engine power.NTSB IAD05LA108Accident · No injuriesLimited investigationFinal reportRobinson R22 · Nashua, NHThe flight instructor's failure to maintain aircraft control during a introductory flight and his inadequate remedial actions.NTSB NYC05CA122Accident · No injuriesData collectionFinal reportGulfstream American AA-5A · Schroon Lake, NYThe pilot's misjudgment of speed/distance which resulted in an overrun.NTSB ANC05CA103Accident · No injuriesData collectionFinal reportCessna 172 · Kenai, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was swampy terrain.NTSB LAX05CA240Accident · No injuriesData collectionFinal reportCessna 172N · North Las Vegas, NVthe student pilot's failure to maintain directional control.NTSB CHI05FA194Accident · 1 fatalField investigationFinal reportCessna 172P · Jackson, WIThe pilot not maintaining aircraft control for undetermined reasons while maneuvering.NTSB ATL05CA132Accident · No injuriesData collectionFinal reportCessna 172P · Savannah, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop, and on ground collision of the right wing with the ground.NTSB SEA05LA147Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Yellow Pine, IDThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain directional control after the aircraft's right main gear contacted a small dirt mound during the takeoff roll at the remote grass airstrip. Factors include the pilot's…NTSB SEA05LA145Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bonners Ferry, IDThe pilot's failure to maintain terrain clearance while maneuvering. Mountainous terrain was a factor.NTSB MIA05LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Gulfport, MSA loss engine power for undetermined reasons, that resulted in a forced landing, and damage to the helicopter during the landing.NTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.NTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.NTSB ANC05CA099Accident · No injuriesData collectionFinal reportCessna 172 · Akiachak, AKThe pilot's delay in aborting the landing, which resulted in the airplane running off the end of the runway and nosing over. A factor associated with the accident was the rough/uneven terrain off the end of the runway.NTSB IAD05LA096Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cape May, NJA partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.NTSB IAD05LA095Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Branchville, NJAn electrical fire of unknown origin. A factor in the accident was the pilot's failure to perform the In-Flight Electrical Fires checklist.NTSB SEA05CA140Accident · No injuriesData collectionFinal reportPiper PA-22 · Kamaih, IDFuel starvation due to the pilot's improper placement of the fuel selector, resulting in a loss of engine power, and collision with terrain.NTSB ANC05LA094Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Whittier, AKThe pilot's becoming lost/disoriented while maneuvering due to inadequate in-flight planning/decision making, which resulted in fuel exhaustion and a forced landing in tree-covered terrain. A factor contributing to the accident was fuel exhaustion.NTSB ANC05LA093Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Anchorage, AKThe pilot's failure to maintain adequate airspeed during takeoff initial climb, which resulted in a loss of control and subsequent uncontrolled descent into a lake. A factor contributing to the accident was an inadvertent stall.NTSB LAX05LA221Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Honolulu, HIthe flight crew's failure to ensure that the landing gear lever was in the full down position prior to utilizing the hand pump, and the certified flight instructor's failure to utilize the blow down emergency landing gear system. The instructor's inadequate…NTSB CHI05LA173Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Crete, ILThe separation of the drive belt, during cruise, leading to the puncturing of the oil cooler and subsequent fire. An additional cause was the pilot's restricted lookout during the emergency landing resulting in the hard landing.NTSB NYC05CA107Accident · No injuriesData collectionFinal reportCessna 172L · Tangier, VAThe pilot's failure to maintain directional control during landing.NTSB IAD05LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Marysville, OHThe pilot's failure to maintain directional control during landing.NTSB CHI05CA174Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Willmar, MNThe pilot's improper flare which resulted in a hard landing.NTSB SEA05FA125Accident · 2 fatalField investigationFinal reportCessna 172M · Yamhill, ORThe flight instructor's excessive climb and failure to maintain adequate airspeed during an attempted go-around, which resulted in an inadvertent stall and subsequent collision with the ground. Contributing factors were the flight instructor's improper…NTSB NYC05LA106Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Edgartown, MAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall and subsequent impact with terrain. [This report was modified on June 10, 2008]NTSB ATL05CA112Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Dunnellon, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control during the landing roll. The crosswind was a contributing factor.NTSB DEN05LA093Accident · No injuriesLimited investigationFinal reportCessna 172N · Hudson, COThe flight instructor's improper use raising of the flaps. Contributing factors were the student pilot's misunderstanding of the instructor's intentions, the instructor's inadequate supervision of the student pilot, the density altitude, and the soft terrain.NTSB CHI05CA150Accident · No injuriesData collectionFinal reportCessna 172P · St. Francis, KSThe pilot's failure to compensate for the crosswind conditions during landing and the unsuccessful go-around. A factor was the crosswind.NTSB CHI05CA152Accident · No injuriesData collectionFinal reportCessna 172M · Rochester, MNThe pilot flared improperly and failed to recover from a bounced landing.NTSB ATL05CA099Accident · Minor injuriesData collectionFinal reportCessna 150M · Panama City, FLThe pilot's misjudgment of distance/altitude while on final approach with a tailwind, which resulted in an undershoot of the runway.NTSB LAX05LA204Accident · 1 fatalLimited investigationFinal reportBellanca 7GCBC · Woodfords, CAthe pilot's failure to maintain an adequate airspeed while turning in strong wind conditions, which resulted in a stall/spin. A factor in the accident was the high density altitude.NTSB LAX05LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Carlsbad, CAthe other pilot's inadequate visual lookout and failure to maintain separation while taxiing.NTSB ATL05CA096Accident · Serious injuriesData collectionFinal reportPiper PA-18A-150 · Griffin, GAThe pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was the pilot's inadequate preflight preparation which failed to verify the fuel amount.NTSB SEA05CA123Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ontario, ORThe pilot's failure to maintain aircraft control during landing roll. A contributing factor was the cross wind weather condition.NTSB LAX05LA197Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Santa Ynez, CAthe pilot's failure to maintain adequate airspeed during a go-around in gusty wind conditions, which resulted in a stall and collision with terrain.NTSB LAX05CA191Accident · No injuriesData collectionFinal reportCessna 172N · Stockton, CAthe pilot's improper use of the brakes, and his failure to maintain directional control during the landing rollout.NTSB ATL05FA086Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Conway, SCThe pilot's failure to maintain airspeed while maneuvering after releasing a banner aerial sign, resulting in an inadvertent stall and collision with the ground. A factor in the accident was the flight instructor's improper supervision of the pilot receiving…NTSB NYC05FA086Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edinburg, OHThe pilot's failure to maintain aircraft control.NTSB LAX05LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZThe student pilot's improper flare that induced a porpoise, which resulted in the overload failure of the nose wheel assembly.NTSB NYC05LA123Accident · No injuriesLimited investigationFinal reportCessna 172P · Islip, NYThe pilot's failure to maintain clearance from a parked vehicle while taxiing.