NTSB investigations: Lycoming 0-320 series
14,589 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 MIA00FA163Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Titusville, FLThe failure of the PIC to maintain control of the aircraft while in the simulated engine inoperative configuration in the landing pattern during a checkout flight resulting in an uncontrolled descent and collision with trees. A factor in the accident is the…NTSB IAD00LA043Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Tappahannock, VAthe pilots's inability to maintain aircraft control after a loss of consciosness.NTSB MIA00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Highlands, NCTotal loss of engine power due to the obstruction (insect larva) of the left wing aft fuel system line resulting in a forced landing to non suitable terrain.NTSB NYC00LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Moneta, VALoss of power for undetermined reasons.NTSB ANC00LA058Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of an unsuitable taxi area, and excessive taxi speed. A factor associated with this accident was a ditch in the taxi area.NTSB MIA00LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fernandina Bch, FLThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed resulting in an inadvertent stall., in-flight collision with terrain, and subsequent nose over.NTSB CHI00LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Fulton, MOthe pilot's poor inflight planning which resulted in exceeded the proper touchdown point on the runway. A factor associated with the accident was the ditch that the airplane contacted.NTSB LAX00LA182Accident · No injuriesLimited investigationFinal reportSmith Arthur Fox Long EZ · Fallon, NVThe pilot's failure to maintain runway alignment and directional control during a crosswind landing that resulted in a touchdown off the runway surface in soft sand. A factor in the accident was an earlier improper repair, which weakened the landing gear…NTSB ATL00LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marco Island, FLThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a nose over.NTSB ANC00FA052Accident · 1 fatalField investigationFinal reportPiper PA-18 · Kotzebue, AKThe pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in the accident were weather conditions consisting of low ceilings, fog, a whiteout, and the…NTSB ATL00LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Clinton, TNThe pilot's inadequate in-flight planning necessitating an intentional ground loop maneuver on landing. Contributing factors were the pilot's misjudgment of distance/airspeed, the high terrain surrounding the runway, and the tailwind condition.NTSB ANC00LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Seldovia, AKThe pilot's failure to maintain directional control of the airplane. A factor in the accident was an inadvertent ground swerve.NTSB LAX00FA178Accident · 4 fatalField investigationFinal reportCessna 172P · Chester, CAThe pilot's encounter with a wind shear at low altitude, which resulted in a loss of control and a stall/spin. Factors in the accident were the high density altitude and the pilot's lack of experience and training in high density altitude operations. The…NTSB DEN00LA081Accident · No injuriesLimited investigationFinal reportHutchins RV4 · Los Alamos, NMThe pilot's failure to maintain control of the aircraft after initiating a go-around following a hard bounced landing. Factors were variable shifting winds and a high-density altitude.NTSB LAX00LA155Accident · Minor injuriesLimited investigationFinal reportSmith RV-4 · Willows, CADisconnection of the elevator push rod due to the owner/builder's improper installation of the rear jam nut on the elevator pushrod.NTSB LAX00LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAThe loss of engine power for undetermined reasons during takeoff climb.NTSB CHI00LA117Accident · No injuriesLimited investigationFinal reportCessna 172N · Chesterfield, MOthe pilot misjudged the landing flare which resulted in the airplane porpoising on the runway during the landing.NTSB ANC00LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's intentional flight into known adverse weather. Factors associated with the accident were the variable crosswind conditions, and the pilot's inadequate compensation for those wind conditions.NTSB ANC00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Aleknagik, AKThe first pilot's (pilot-in-command) inadequate evaluation of the weather, and failure to maintain an adequate altitude above the ground. Factors in the accident were low ceilings, and snow-covered terrain.NTSB SEA00LA067Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seattle, WAThe pilot's failure to attain proper alignment with the landing runway, and her failure to maintain proper glide path for the landing runway, resulting in an encounter with vortex turbulence from a preceding heavy aircraft landing on a parallel runway and…NTSB LAX00LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeport, CAThe pilot's decision to continue with a high, steep, and fast approach, which resulted in a touchdown beyond the halfway point of the runway and the inability to stop on the remaining pavement, and, his delayed decision to initiate a landing abort. Also…NTSB DEN00LA070Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Collins, COOn ground loss of control resulting in collision with airport markings due to inadequate compensation for wind conditions during landing roll. Factors were inaccurate in flight planning by landing with a tail wind component and lack of total pilot experience.NTSB CHI00LA106Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Saint Joseph, MOthe pilot's inadequate compensation for the wind condition. A factor to the accident was the high winds.NTSB NYC00LA109Accident · No injuriesLimited investigationFinal reportCessna 172 · North Adams, MAThe pilot's failure to obtain the proper touchdown point. A factor was a tailwind.NTSB LAX00LA143Accident · No injuriesLimited investigationFinal reportMuxlow Pitts S-1C · Phoenix, AZA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain on which the airplane landed.NTSB NYC00LA107Accident · Minor injuriesLimited investigationFinal reportPagan RV-8A · East Liverpool, OHThe pilot's loss of control during the landing.NTSB CHI00LA108Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Arlington, SDthe CFI's improper use of the throttle control during a simulated loss of engine power emergency. A factor associated with the accident was the rough terrain on which the forced landing was conducted.NTSB MIA00LA124Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Petersburg, FLThe failure of the pilot to maintain clearance between the left wingtip and a hangar door resulting in the on-ground collision.NTSB NYC00LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Keene, NHThe CFI's failure to perform remedial action in a timely manner which resulted in a hard landing during the practice autorotation. A factor in this accident was the CFI's lack of total experience as a flight instructor.NTSB LAX00FA134Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Rialto, CAThe pilot's in-flight loss of control for undetermined reasons.NTSB FTW00LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Maud, OKthe loss of engine power while maneuvering as a result of the separation of the exhaust rocker arm retaining stud due to fatigue, which resulted in a precautionary landing.NTSB SEA00LA054Accident · No injuriesLimited investigationFinal reportCessna 172N · Quincy, WAFailure to maintain terrain clearance. Factors include mountainous/hilly terrain.NTSB MIA00LA113Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ocean Springs, MSThe pilot's failure to maintain control of the aircraft while making a forced landing following loss of engine power for undetermined reasons, resulting in the aircraft impacting hard on the runway, bouncing into the air, and colliding with powerlines off the…NTSB NYC00LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Farmingdale, NYa power loss over unsuitable terrain, for undetermined reason(s).NTSB SEA00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Three Forks, MTThe pilot's failure to maintain directional control of the tailwheel equipped airplane.NTSB LAX00LA128Accident · Serious injuriesLimited investigationFinal reportAero Commander 100 · Buckeye, AZThe pilot's improper judgment and his failure to maintain clearance from the ground. A factor was the pilot's lack of recent experience.NTSB LAX00TA125Accident · Serious injuriesFinal reportPiper PA-18-150 · Rio Vista, CAfailure of the pilot to maintain clearance from power lines while maneuvering at a low altitude. A factor was glare from the sun.NTSB DEN00LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Belen, NMA loss of engine power due to low cylinder compression from an open exhaust valve, and the pilot's failure to lean the fuel mixture.NTSB MIA00LA214Accident · No injuriesLimited investigationFinal reportCessna 172L · Beaufort, NCThe failure of the pilot to initiate a go-around after the airplane began to porpoise, resulting in a hard landing and structural damage to the airplane.NTSB NYC00LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-22 · Conesus, NYThe contamination of the aircraft's fuel. Contributing factors were the pilot's failure to maintain adequate altitude and his diversion of attention during the base turn, dark night conditions, and the tree.NTSB FTW00LA090Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Manilla, ARThe pilot's performance of low altitude flight and his failure to maintain clearance with the power lines.NTSB NYC00LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · West Milford, NJThe pilot's failure to maintain directional control during landing. A factor in this accident was the gusty crosswind conditions.NTSB ATL00LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Titusville, FLThe pilot's improper decision to attempt a flight on minimal fuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the closed fuel pumps at the departure airport.NTSB ANC00LA028Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were soft, snow covered terrain.NTSB LAX00FA101Accident · Minor injuriesField investigationFinal reportCessna 172N · Palm Springs, CAthe failure of both flight crews to see and avoid the other airplane while operating in the traffic pattern, which resulted in a mid-air collision. A contributing factor was the failure of the arriving aircraft to comply with air traffic control requests by…NTSB NYC00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Parkertown, OHThe inadequate visual lookout by the pilots of both airplanes.NTSB LAX00LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bermuda Dunes, CAFailure of the student pilot to maintain directional control of the airplane during takeoff.NTSB NYC00LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Vincentown, NJThe CFI's delay in remedial action after the student pilot lost control of the airplane. A factor in the accident was the CFI's lack of total experience in flight instruction.NTSB LAX00LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Honolulu, HIThe pilot's improper use of the brakes during the landing rollout. The pilot's self induced pressure and the quartering tailwind were factors in the accident.NTSB CHI00LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Chesterfield, MOThe pilot failed to maintain directional control during the takeoff portion of a touch and go landing.