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 NYC01LA110Accident · No injuriesLimited investigationFinal reportCessna 172K · Honesdale, PAThe pilot's loss of directional control during the landing roll. A factor was gusting winds.NTSB NYC01LA103Accident · No injuriesLimited investigationFinal reportCessna 177 · Hampton, NHThe pilot's inadvertent encounter with a downdraft, which resulted in a collision with trees. A factor related to the accident were the downdraft wind conditions.NTSB SEA01LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172 N · Sultan, WAThe pilot's failure to maintain adequate clearance from trees and terrain during the airplane's initial climb.NTSB NYC01LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate fuel management, which resulted in fuel starvation.NTSB MIA01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chapel Hill, NCThe loss of engine power for undetermined reasons during takeoff, resulting in an inflight collision with trees during the subsequent emergency landing. A factor in the accident was the lack of suitable terrain to conduct an emergency landing.NTSB LAX01LA150Accident · No injuriesLimited investigationFinal reportCessna 172P · Torrance, CAThe failure of the pilot-in-command to execute a proper landing flare, which resulted in an improper touchdown attitude and a subsequent loss of directional control. A factor in the accident was the difference between landing characteristics of the Katana and…NTSB CHI01LA126Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Grain Valley, MOThe normal brake system was inoperative due to undetermined reasons. A factor associated with the accident was the ditch that the airplane encountered.NTSB CHI01LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Culver, INthe CFI delayed remedial action during the takeoff. Additional factors were the wrong runway was selected, the tailwind, and the trees.NTSB CHI01LA114Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Gary, INThe inadequate preflight performed by the pilot which resulted in an insufficient fuel supply and the subsequent fuel exhaustion. Factors associated with the accident were the inaccurate fuel quantity indicator, the rock which resulted in the overload failure…NTSB LAX01LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · N. Las Vegas, NVThe pilot's inadequate compensation for the existing crosswind condition, and his failure to maintain runway alignment.NTSB DEN01LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Rangely, COthe pilot's improper use of aileron and his failure to maintain directional control during landing. A contributing factor was the direct gusty crosswind.NTSB SEA01LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Scapoose, ORthe pilot's failure to maintain a speed above minimum in-flight stall speed (Vs). Factors include gusty winds at the time of the attempted landing.NTSB LAX01LA130Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Holbrook, AZFailure of the rudder lower hinge attach point resulting in a loss of rudder control and steerable tailwheel control. A factor was the crosswind condition.NTSB LAX01FA129Accident · 3 fatalField investigationFinal reportCessna 172N · Santa Monica, CAthe pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the dark night, the marine cloud layer that restricted the pilot's cruising altitude, and the pilot's lack of familiarity with nighttime flight…NTSB DEN01LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Junction, COFailure by the pilot to maintain directional control during takeoff roll. A factor was a crosswind.NTSB LAX01LA125Accident · No injuriesLimited investigationFinal reportRobinson R22B · Long Beach, CAFailure of the CFI to adequately monitor the flight, which resulted in a low airspeed autorotation and hard landing.NTSB SEA01FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Greenwater, WAFailure to maintain clearance from mountainous terrain.NTSB CHI01LA107Accident · No injuriesLimited investigationFinal reportCessna 172K · Holland, MIThe pilot failed to maintain directional control of the airplane. Factors included the soft ground and the runway lights.NTSB MIA01LA101Accident · No injuriesLimited investigationFinal reportRobinson R22 · Okeechobee, FLan in-flight collision with the ground during a simulated engine failure, and autorotation, which resulted in the tailboom separating. A contributing factor in this accident was the pilot allowed the rotor rpm to decay which resulted in inadequate rotor rpm…NTSB CHI01LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sidney, NEthe pilot's failure to maintain directional control during the landing. A factor relating to this accident was the berm.NTSB CHI01LA103Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Huron, MIThe pilot not maintaing a proper glide path during the simulated forced landing. Factors were flight instructor's inadequate supervision and the wind gusts.NTSB LAX01LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Anza, CAThe pilot's failure to maintain control of the airplane following the opening of the cockpit/cabin door. The door came open because of improperly installed upholstery, which resulted in the inability to lock the door.NTSB LAX01LA115Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe pilot's failure to maintain directional control resulting in an encounter with terrain and a nose over.NTSB FTW01LA076Accident · No injuriesLimited investigationFinal reportRobinson R22 · Alvarado, TXthe pilot's failure to maintain clearance with a marked static wire.NTSB MIA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172L · Fort Lauderdale, FLThe total failure of the yoke weld assembly due to corrosion resulting in the inability of the flight crew to maintain elevator control of the airplane. Additionally, inadequate annual inspection of the airplane by other maintenance personnel for failure to…NTSB NYC01LA080Accident · No injuriesLimited investigationFinal reportCessna 172I · Suffolk, VAThe pilot's improper in-flight planning/decision and his failure to refuel, which resulted in fuel exhaustion.NTSB NYC01LA086Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Keene, NHinadequate visual lookout by the flight instructor on the helicopter's proximity to the snowbank, and subsequent lift off, which resulted in a dynamic rollover.NTSB CHI01LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Detroit Lakes, MNAltitude/clearance not maintained from the transmission wires during a low altitude flight/maneuver performed by the pilot. A factor to the accident was the transmission wires.NTSB FTW01FA069Accident · 2 fatalField investigationFinal reportRobinson R-22 Beta · Borger, TXthe pilot's inadvertent flight into instrument meteorological conditions and failure to maintain obstacle clearance. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing and the dark night conditions.NTSB ANC01LA037Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Fairbanks, AKThe flight instructor's inadequate supervision of the flight during the landing flare. A factor in the accident was the student's abrupt airplane control.NTSB MIA01LA083Accident · No injuriesLimited investigationFinal reportPiper J5A · Hollywood, FLthe pilot's improper inflight planning/decision and inadequate fuel consumption calculations that resulted in fuel exhaustion and substantial damage to the aircraft as a result of a hard landing during the emergency descent/landing.NTSB LAX01LA102Accident · No injuriesLimited investigationFinal reportCessna 172N · San Diego, CAThe pilot's failure to maintain directional control of the airplane during landing rollout.NTSB LAX01FA101Accident · 4 fatalField investigationFinal reportCessna 152 · Long Beach, CAThe failure of the flight crews of both airplanes to maintain adequate visual lookout for traffic.NTSB MIA01LA076Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Parkland, FLThe failure of the instructor to take corrective action in a timely manner to prevent the helicopter from contacting the ground when the student allowed it to descend during hover practice which resulted in a dynamic rollover.NTSB FTW01LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Owasso, OKthe pilot's delay in switching the fuel selector, which resulted in fuel starvation in cruise flight.NTSB NYC01LA078Accident · No injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe pilot's failure to attain the proper touchdown point. Factors included the nighttime conditions, and the pilot's improper decision to leave the runway lighting at high intensity.NTSB FTW01FA058Accident · 2 fatalField investigationFinal reportCessna 152 · Platter, OKthe failure of both pilots to maintain a visual lookout, which resulted in a mid-air collision over a lake. A contributing factor to the accident was the sun glare from the setting sun.NTSB LAX01LA088Accident · No injuriesLimited investigationFinal reportFish RV6 · Georgetown, CAThe total loss of engine power due to fracture and separation of the engine crankshaft.NTSB SEA01LA045Accident · No injuriesLimited investigationFinal reportAlexander MA-5 Charger · Spanaway, WAthe pilot's failure to apply carburetor heat prior to takeoff while operating in serious carburetor icing conditions. Factors include operating in serious carburetor icing conditions, and rough/uneven terrain in the area of the forced landing.NTSB NYC01LA074Accident · No injuriesLimited investigationFinal reportBeech B-19 · Louisa, VAThe pilot's failure to maintain airspeed, which resulted in a hard landing. Factor's in this accident were the loss of electrical power due to an alternator failure and the night light conditions.NTSB MIA01LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tifton, GAThe pilot's failure to properly judge his altitude (too high) during a forced landing to a runway. The pilot made a 270-degree turn in an attempt to lose altitude resulting in a forced landing in a swampy/marshy area short of the runway. Contributing to the…NTSB LAX01LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Camarillo, CAThe failure of the pilot to maintain directional control during takeoff.NTSB CHI01LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Prairie Du Sac, WIthe improper trim setting and the pilot failed to maintain control of the airplane. A factor was the snowbank.NTSB CHI01LA069Accident · No injuriesLimited investigationFinal reportCessna 172L · Culver, INthe proper glide path not attained by both pilots during a short field landing. The snow bank was a contributing factor.NTSB LAX01FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 172N · Monterey, CAUndetermined.NTSB LAX01LA077Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Atwater, CAThe student's failure to maintain directional control while landing in a crosswind, his improper compensation for wind conditions, and the flight instructor's inadequate flight supervision.NTSB SEA01LA036Accident · No injuriesLimited investigationFinal reportCessna 172K · Troutdale, ORThe pilot's failure to adequately compensate for wind conditions while taxiing the airplane.NTSB IAD01LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NHThe flight instructor's improper decision to land downwind on the snow and ice covered runway with a tailwind, and his failure to perform a go-around. Factors in the accident were the tailwind and the snow and ice on the runway.NTSB ANC01LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Atmautluak, AKThe pilot's failure to maintain a proper glidepath during final approach. A factor associated with the accident was soft terrain.NTSB CHI01LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln, ILThe pilot's failure to maintain directional control on the runway. Factors relating to this accident were the aborted takeoff attempt, the pilot's improper in-flight planning/decision, and the snowbank.