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 SEA06LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Laurel, MTThe failure of maintenance personnel to properly reinstall the left-hand control yoke to the left-hand control column, and the failure of other maintenance personnel to properly verify the installation, which resulted in the pilot's loss of control in flight…NTSB ANC06CA065Accident · No injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate compensation for a tailwind during the landing flare, which resulted in an in-flight collision with snow-covered terrain during an aborted landing. Factors contributing to the accident were a tailwind and rising terrain.NTSB NYC06LA124Accident · Minor injuriesLimited investigationFinal reportCessna C-172N · Vineyard Haven, MAThe pilot's improper preflight planning and improper fuel consumption calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB NYC06CA125Accident · No injuriesData collectionFinal reportRobinson R-22 · Sanford, METhe flight instructor's inadvertent encounter with settling-with-power, which resulted in a hard landing, and subsequent roll-over. A factor in the accident was the tailwind.NTSB LAX06LA183Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Oxnard, CAThe loss of engine power for undetermined reasons.NTSB LAX06LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Eagar, AZthe flight instructor's failure to attain and maintain the proper climb airspeed, which resulted in a stall/mush.NTSB CHI06CA136Accident · No injuriesData collectionFinal reportMiller Rutan Long-Ez · Morris, ILThe partial loss of engine power during the final approach to landing for undetermined reasons, and the unsuitable terrain for landing encountered by the pilot. The tall grass was a factor.NTSB ATL06CA084Accident · No injuriesData collectionFinal reportCessna 172L · Lexington, TNThe pilot's failure to attain the proper touchdown point during landing.NTSB DFW06CA132Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the dark night conditions and the pilot's inadequate preflight planning and preparation.NTSB SEA06CA103Accident · No injuriesData collectionFinal reportCessna 172M · Hamilton, MTThe pilot's inadequate compensation for the wind conditions during the landing roll which resulted in his failure to maintain directional control. Factors included variable winds and gusty crosswinds.NTSB ANC06LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Naknek, AKA loss of engine power during cruise flight for an undetermined reason, which resulted in a forced landing and subsequent collision with high vegetation and the ground.NTSB ATL06CA081Accident · No injuriesData collectionFinal reportPiper PA28-140 · Murfreesboro, TNThe student pilot's failure to maintain directional control during landing roll.NTSB SEA06CA095Accident · No injuriesData collectionFinal reportHelmer Avid Magnum · Big Timber, MTThe pilot's failure to maintain directional control after he diverted his attention to close the aircraft's door during the takeoff roll. Factors include a fence and fence post along the side of the runway.NTSB MIA06CA111Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Ormond Beach, FLA loss of engine power due to the student pilot's improper positioning of the fuel selector during takeoff. A contributing factor was the pilot's failure to abort the takeoff.NTSB ANC06CA052Accident · No injuriesData collectionFinal reportPiper PA-18 · Iliamna, AKThe pilot's misjudged distance and altitude, which resulted in an undershoot during final approach to a beach, and subsequent in-flight collision with water and a nose over.NTSB CHI06CA134Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grayslake, ILThe student pilot's failure to maintain clearance from the parked vehicle during taxi and the flight instructor's inadequate operational oversight. A factor to the accident was the parked vehicle.NTSB SEA06CA097Accident · No injuriesData collectionFinal reportRupp Rutan Defiant · Coeur d'Alene, IDThe pilot's failure to put the nose wheel landing gear down for landing.NTSB LAX06CA162Accident · No injuriesData collectionFinal reportBeech BE23 · Kingman, AZthe student pilot's failure to attain/maintain a proper glide path, which resulted in an encounter with wake turbulence and subsequent hard landing.NTSB DEN06CA071Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Rangely, COthe pilot's inadvertent application of the brake during the landing roll. A contributing factor was the pilot's failure to maintain directional control and the flight instructor's inadequate supervision during the landing.NTSB MIA06CA101Accident · No injuriesData collectionFinal reportCessna 172N · Miami, FLThe improper flare by the pilot resulting in a hard landing and substantial damage to the airplane.NTSB SEA06CA098Accident · No injuriesData collectionFinal reportCessna 172N · Billings, MTThe pilot's failure to maintain clearance from a sign while taxiing to parking.NTSB LAX06CA149Accident · Minor injuriesData collectionFinal reportM.C. Thomas Thorpe T-18 · Reno, NVthe pilot's failure to maintain directional control. A contributing factor was the certified flight instructor's inadequate supervision of the flight.NTSB ANC06LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tuluksak, AKThe pilot's inadvertent stall/mush during takeoff-initial climb, which resulted in an in-flight collision with trees and terrain. Factors associated with the accident were the pilot's excessive loading of the airplane, his inadequate preflight planning, and a…NTSB NYC06FA104Accident · 1 fatalField investigationFinal reportCessna 172L · Montgomery Twp, PAAn impact with mountainous terrain for an undetermined reason.NTSB LAX06CA144Accident · No injuriesData collectionFinal reportAviat A-1B · Chandler, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout. A contributing factor was the pilot's excessive use of the flight controls.NTSB MIA06CA095Accident · Minor injuriesData collectionFinal reportMarland E Davis RV-6A · Live Oak, FLFailure of the pilot to maintain directional control of the airplane during landing resulting in a nose over.NTSB ANC06CA046Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain directional control of the airplane during takeoff initial climb, which resulted in an in-flight collision with trees.NTSB NYC06LA097Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Avondale, PASeparation of the propeller blade due to fatigue.NTSB ATL06CA065Accident · No injuriesData collectionFinal reportCessna 172 M · Griffin, GAThe pilot's failure to achieve the proper touchdown point, which resulted in an overrun of the runway, collision with an embankment, and subsequent nose over.NTSB DEN06CA064Accident · No injuriesData collectionFinal reportRobinson R-22 · Santa Fe, NMthe pilot's improper preflight planning and his failure to maintain control of the helicopter during takeoff. Factors contributing to the accident were the helicopter exceeding its maximum gross weight for takeoff and the high density altitude.NTSB ANC06CA045Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Birchwood, AKThe flight instructor's delayed remedial action during the landing roll, which resulted in the loss of directional control by the student, a ground-loop, and collapse of the main landing gear. A factor associated with the accident was the student's failure to…NTSB CHI06CA114Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Drayton, NDThe pilot's failure to maintain directional control during takeoff. A related factor was the high wind condition.NTSB NYC06CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout.NTSB MIA06CA084Accident · No injuriesData collectionFinal reportLinwood R. Lawrence Van's Aircraft RV-9A · Venice, FLThe pilot's improper landing flare/touchdown which resulted in a hard landing and damage to the airplane.NTSB MIA06CA083Accident · No injuriesData collectionFinal reportCessna 172M · Vero Beach, FLThe pilot's failure to maintain directional control while executing a go-around in gusty conditions which resulted in the airplane veering off the runway, colliding with a ditch and nosing over.NTSB DFW06CA096Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Lakeview, ARThe pilot's inadequate weather evaluation and failure to maintain airspeed, which resulted in an inadvertent stall. A contributing factor was the prevailing tailwind.NTSB NYC06CA088Accident · No injuriesData collectionFinal reportCessna 172-P · Cambridge, MDThe student pilot's improper recovery from a bounced landing.NTSB MIA06CA080Accident · Minor injuriesData collectionFinal reportAero Commander 100 · Englewood, FLThe pilot's failure to abort the takeoff in time to stop on the remaining runway, which resulted in the airplane overrunning the runway.NTSB DFW06FA095Accident · 2 fatalField investigationFinal reportPiper/Stevens PA18A-150 · Hollandale, MSThe pilots failure to maintain control of the airplane. A contributing factor was the pilots impairment.NTSB MIA06CA088Accident · No injuriesData collectionFinal reportCessna 172N · Daytona Beach, FLThe pilot's improper landing flare/touchdown, which resulted in the airplane porpoising and incurring damage.NTSB ATL06CA057Accident · No injuriesData collectionFinal reportCessna 172M · Newnan, GAThe student pilot's failure to maintain directional control on the landing roll out, resulting in the airplane veering off the right side of the runway and colliding with an airport runway sign.NTSB SEA06CA082Accident · No injuriesData collectionFinal reportCessna 172 · Aurora, ORThe student pilot's misjudgment of the landing flare resulting in a hard landing. A related factor was the crosswind.NTSB LAX06CA138Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Paso Robles, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB ANC06CA034Accident · No injuriesData collectionFinal reportPiper PA-22 · Grand Canyon, AZThe pilot's improper recovery from a bounced landing during touchdown, which resulted in a loss of control and encounter with terrain. Factors associated with the accident are the pilot's misjudged flare, and a gusty wind.NTSB ANC06LA028Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Kailua-Kona, HIThe flight instructor's delayed remedial action while conducting hover practice with a student pilot, which resulted in the helicopter contacting the ground and rolling over. A factor contributing to the accident was an inadvertent dynamic roll over.NTSB ANC06LA027Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKThe pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in a loss of control and collision with snow-covered terrain. A factor contributing to the accident was an inadvertent stall.NTSB DFW06CA084Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Cherokee City, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06LA052Accident · Minor injuriesLimited investigationFinal reportE Newton Newton RV-6A · Mooresville, NCThe collapse of the nose landing gear for undetermined reasons, which resulted in a nose over.NTSB LAX06CA125Accident · Minor injuriesData collectionFinal reportCessna 172N · Compton, CAcontrol interference by the student pilot during a go-around that resulted in an in-flight collision with power lines.NTSB ANC06CA033Accident · No injuriesData collectionFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane colliding with a snowbank and nosing over.