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 SEA00LA180Accident · No injuriesLimited investigationFinal reportCessna 172L · Everett, WAThe other pilot's improper use (inadvertent release) of the brakes. Contributing factors were, a standing aircraft and the other pilot's diverting his attention from outside his aircraft.NTSB MIA00LA263Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Zephyrhills, FLthe intentional stall/mush by the pilot-in-command due to obstructions ahead resulting in a hard landing. Contributing to the accident was the partial loss of engine power due to fuel starvation caused by wear, fatigue, then overstress separation of the…NTSB CHI00LA299Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Morris, ILThe improper servicing of the left main landing gear tire which resulted in it having low air pressure and the pilot's inability to maintain directional control on landing. A factor associated with the accident was the ditch.NTSB ANC00LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Lake, AKThe pilot's application of excessive braking. A factor in the accident was the installation of boosted (oversize) type master brake cylinders.NTSB ANC00LA135Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Sparrevohn, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable winds, and a crosswind.NTSB ANC00LA122Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKA malfunctioning main landing gear brake, which precipitated a ground-loop.NTSB SEA00LA179Accident · No injuriesLimited investigationFinal reportCessna 172P · Friday Harbor, WAThe Cessna 172 pilot's failure to maintain clearance with the Cessna 182. Factors included aircraft parked/standing on the taxiway and the refueling area, and a congested/confined taxiway.NTSB LAX00LA335Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Novato, CAFailure of the student pilot to maintain directional control of the airplane during the landing rollout resulting in a collision with a berm.NTSB ANC00LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was a tree stump not observed by the pilot.NTSB ANC00LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe loss of aircraft control precipitated by the pilot's inadvertent stall. Factors associated with the accident are the disengagement of the stabilizer trim system, which resulted in reduced aircraft control, an inadvertent stall by the pilot, and a large…NTSB ANC00LA118Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Sparrevohn, AKThe pilot's inadvertent stall/mush during the final approach to land. Factors associated with the accident are the pilot's misjudged flare, and the rough and uneven terrain.NTSB CHI00LA308Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hallock, MNthe pilot not maintaining directional control of the airplane. Factors were the gusts, the crosswind weather conditions, and the ditch terrain condition.NTSB ATL00LA089Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · St. Augustine, FLThe loss of engine power due to fuel system contamination.NTSB NYC00LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Cross Keys, NJThe operator's inadequate 100-hour inspection of the airplane, and the pilot's continued operation with known deficiencies in equipment.NTSB CHI00LA290Accident · No injuriesLimited investigationFinal reportBeech B19 · Dodge Center, MNthe student pilot not maintaining aircraft control and the instructor pilot's delayed remedial action. A factor relating to the accident was the ditch.NTSB ANC00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ruby, AKThe pilot's inadvertent ground loop/swerve during the landing roll.NTSB LAX00LA330Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAThe failure of maintenance personnel to detect and correct loose attachment fasteners and fretting at the landing gear attachment during maintenance inspections.NTSB SEA00LA177Accident · No injuriesLimited investigationFinal reportCessna 172P · Auburn, WADamage to aircraft under unknown circumstances.NTSB LAX00LA323Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe failure of the pilot-in-command to maintain proper airspeed during the aborted landing go-around which resulted in a stall/mush and impact with terrain.NTSB CHI00LA281Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Blakesburg, IAThe pilot failed to add full power during a go around which resulted in descreased airspeed and a subsequent stall. A factor associated with the accident was the airplane stopped on the edge of the airstrip.NTSB SEA00LA174Accident · No injuriesLimited investigationFinal reportBeard Lancair 320 · Bend, ORThe pilot's failure to take adequate remedial action upon encountering aircraft control difficulties during landing. Factors included gusty wind conditions and the pilot's failure to maintain aircraft control during landing.NTSB NYC00LA244Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Windsor, NHthe pilot's improper preflight planning to make a takeoff toward obstacles, and his delayed decision to abort the takeoff, which resulted in an overrun into unsuitable terrain.NTSB MIA00LA253Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Chatom, ALthe pilot's improper preflight planning/decision and failure to ensure an adequate supply of fuel to safely complete the flight to his destination with adequate fuel reserves, which resulted in fuel exhaustion, subsequent engine failure, and a forced landing…NTSB LAX00LA321Accident · No injuriesLimited investigationFinal reportFogerson Richard D RV-6A · El Monte, CAThe loss of engine power for undetermined reasons.NTSB ANC00LA111Accident · No injuriesLimited investigationFinal reportCessna 172 · Alexander Creek, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were gusty winds, and a downdraft.NTSB LAX00LA309Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Scottsdale, AZFailure of the pilot to maintain directional control on the landing rollout. Also causal to the accident was his failure to retract flaps during the aborted landing attempt, which lead to a loss of lift and a hard landing followed by a ground loop.NTSB FTW00LA240Accident · No injuriesLimited investigationFinal reportCessna 172P · San Antonio, TXThe pilot's failure to maintain control during landing. A factor was the reported wind gust.NTSB SEA00LA167Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A-150 · North Plains, ORThe pilot's excessive use of brakes. Contributing factors were the pilot's misjudgment of distance/speed (landing long and fast) and lack of experience in the make/model of aircraft.NTSB NYC00LA236Accident · No injuriesLimited investigationFinal reportCessna 172K · Warwick, RIThe pilot's delayed recovery from a bounced landing.NTSB MIA00LA243Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · St. Petersburg, FLThe pilot's improper judgment not to sit in the pilot's seat (rear seat) and improper use of brakes on landing roll resulting in a loss of directional control and subsequent nose over.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.NTSB LAX00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZThe pilot's improper go-around procedure and his failure to maintain directional control on landing.NTSB CHI00LA259Accident · No injuriesLimited investigationFinal reportCessna 172M · Harbor Springs, MIthe pilot's long touchdown, and inadequate braking to stop on the runway. Factors relating to this accident were the pilot's improper in-flight planning and decision resulting in the long touchdown, and the fence.NTSB ANC00LA100Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Arctic Village, AKThe pilot's inadequate compensation for wind conditions, resulting in an inadvertent stall. A factor in the accident was the gusty winds.NTSB NYC00LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot's improper recovery from a bounced landing.NTSB LAX00LA295Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Newell, CAA hidden depression in the ground that resulted in the collapse of the landing gear during the forced landing roll.NTSB LAX00LA294Accident · No injuriesLimited investigationFinal reportDickenson Avid Magnum · Ely, NVThe pilot's inadequate compensation for a gusting crosswind that resulted in a loss of directional control and subsequent collision with the ground.NTSB CHI00LA254Accident · No injuriesLimited investigationFinal reportCessna 208B · North Platte, NEthe pilot of the other airplane not maintaining clearance while taxiing. A factor was the dark night.NTSB SEA00LA155Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gleneden Beach, ORThe pilot's failure to remove the control lock during his preflight inspection. Factors contributing to the accident were the pilot's failure to follow the BEFORE TAKEOFF checklist, trees beyond the upwind end of the runway, and the pilot's self-induced…NTSB ANC00LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe pilot's inadequate preflight planning/preparation. Factors in the accident were an uphill takeoff, high vegetation, and a short runway area.NTSB ATL00LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Manteo, NCThe pilot's failure of preflight planning preparation, which resulted in the fuel exhaustion, and the subsequent loss of engine power.NTSB NYC00LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · E. Stroudsburg, PAThe pilot's decision to takeoff with only partial engine power available.NTSB NYC00LA220Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Westhampton, NYThe pilot's inadequate flare during the landing. Factors were the entanglement of the tow rope with the rudder horn, and restricted rudder movement.NTSB ANC00LA095Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilots selection of unsuitable terrain for landing. A factor was high brush along side the landing area.NTSB NYC00LA214Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Wildwood, NJThe partial loss of power caused by detonation of the #3 piston.NTSB IAD00LA068Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Princeton, NJthe student pilot's failure to maintain control of the airplane during the aborted landing.NTSB FTW00LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Calico Rock, ARthe pilot's inability to maintain airplane control during the landing roll due to the airplane hydroplaning on the wet runway.NTSB LAX00LA299Accident · No injuriesLimited investigationFinal reportCessna 172M · Oakland, CAThe pilot's improper landing flare.NTSB ANC00LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's excessive application of the airplane's brakes.NTSB NYC00LA203Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Columbus, OHa partial power loss for undetermined reason(s).