NTSB investigations: Lycoming 0-320 series, 1992

202 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 year(c.\"eventDate\") = 1992
    AND 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.

NTSB ANC92LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot misjudged the weather conditions for float plane operations and failed to maintain control of the airplane during the takeoff run. Factors contributing to the accident were: high gusty winds, the pilot in command's lack of recent experience, and…Sep 16, 1992 · N1299C · Substantial damageNTSB MIA92LA181Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Panacea, FLFailure of the nose landing gear push/pull rod end bearing for undetermined reasons.Sep 15, 1992 · N3791X · Substantial damageNTSB CHI92LA278Accident · No injuriesLimited investigationFinal reportCessna 172P · Yipslanti, MIThe pilot's premature flare during landing and not performing a recovery from a bounced landing.Sep 15, 1992 · N96593 · Substantial damageNTSB LAX92LA385Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ojai, CAThe pilot's failure to maintain adequate main rotor RPM to cushion the landing. Contributing to the accident was the loss of engine power for undetermined reasons and the existing high density altitude.Sep 14, 1992 · N4079S · Substantial damageNTSB ANC92LA172Accident · Minor injuriesLimited investigationFinal reportPiper PA-12-150 · Upper Yantarni, AKPilot in command inadvertant encounter with aerodynamic stall during low level approach turn. Factor affecting the accident was: the pilot's approach procedure/technique to fly VFR approach pattern at 50 feet AGL.Sep 14, 1992 · N2577M · Substantial damageNTSB CHI92LA277Accident · No injuriesLimited investigationFinal reportCessna 172N · Geneseo, ILThe pilot's attempted operation of the airplane with a known defficiency in the equipment.Sep 13, 1992 · N738KX · Substantial damageNTSB ANC92LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Pole, AKPilot's decision to attempt takeoff without removing snow from aircraft surfaces. Factor related to the accident was the snow contaminated wing and other flight surfaces.Sep 13, 1992 · N3692Z · Substantial damageNTSB LAX92LA382Accident · No injuriesLimited investigationFinal reportCessna 172N · Fillmore, CAThe first pilot's poor inflight decision to fly into a box canyon. Contributing to this accident was the box canyon and the downdraft.Sep 12, 1992 · N2212W · Substantial damageNTSB CHI92LA274Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Charles, MIThe jamming of the oil pressure pump caused by the failure of the oil pressure pump driven impeller. The lack of a suitable landing area was a factor.Sep 12, 1992 · N5361K · Substantial damageNTSB LAX92LA380Accident · No injuriesLimited investigationFinal reportCessna 172N · Stanfield, AZThe cfi's poor in-flight decision to demonstrate the simulated engine out emergency landing at too low an altitude and misjudging the altitude during the circling maneuver.Sep 10, 1992 · N734UT · Substantial damageNTSB ANC92LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Lime Village, AKThe pilot in command not maintaining control of the airplane. A factor in the accident was the wind gusts.Sep 10, 1992 · N3384Z · Substantial damageNTSB BFO92LA140Accident · No injuriesLimited investigationFinal reportBeech 19 · Revere, PAThe loss of engine power for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.Sep 9, 1992 · N24600 · Substantial damageNTSB ATL92LA178Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Boone, NCThe pilot's failure to abort the take off, and his abrupt pull up with insufficient airspeed to continue flight. Factors were the inadequate airspeed and the inadvertent stall.Sep 9, 1992 · N19797 · Substantial damageNTSB ANC92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKThe pilot in commands failure to abort the takeoff and his misjudgment of the distance required to perform a safe takeoff under the conditions present.Sep 9, 1992 · N1999P · Substantial damageNTSB CHI92LA270Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Petersburg, MIInadequate visual lookout by the pilot in command during final approach. A factor in the accident was the sunglare.Sep 8, 1992 · N3743P · Substantial damageNTSB MIA92LA176Accident · No injuriesLimited investigationFinal reportCessna 172I · Navarre, FLFailure of the pilot-in-command to maintain directional control after touchdown during the forced landing following partial loss of engine power during cruise flight. Contributing to the accident was the divertion of attention of the pilot in command to the…Sep 7, 1992 · N35302 · Substantial damageNTSB ANC92LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Sparrevohn, AKThe pilot's low pass between trees in crosswind conditions and inflight decision to conduct low altitude flight at a location that was too restricted for safe operation. Factors relating to the accident were: cross wind conditions and obstacles (trees).Sep 6, 1992 · N8699D · Substantial damageNTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.Sep 5, 1992 · N32677 · Substantial damageNTSB ANC92LA158Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Skwentna, AKPilot misjudged performance capability for tailwind condition considering aircraft load and terrain. Factors related to the accident were: terrain, takeoff airspeed not attained, aircraft performance, pilot overconfidence in aircraft and personal ability.Sep 5, 1992 · N5106H · Substantial damageNTSB MIA92LA171Accident · No injuriesLimited investigationFinal reportCessna 172M · Hernando, MSThe failure of the pilot in command to compensate for the crosswind condition, resulting in a ground loop. Contributing to the accident was the pilot's lack of experience in the type of aircraft.Sep 2, 1992 · N64001 · Substantial damageNTSB LAX92FA374Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Concord, CAThe following Probable Cause was modified on April18, 2007, as a result of new information provided to the NTSB. The improper installation of the 1.75 inch od plug in the crankshaft by unknown maintenance personnel which resulted in an inadvertent feathering…Sep 2, 1992 · N4305Y · DestroyedNTSB ANC92LA160Accident · No injuriesLimited investigationFinal reportDale Conover Tundra PUP · Beluga, AKThe inadequate preflight planning/preparation by the pilot. A factor was the pilot misjudged his clearance from the trees.Sep 2, 1992 · N2072Y · Substantial damageNTSB ANC92FA148Accident · No injuriesField investigationFinal reportPiper PA-18 · Anchorage, AKMisjudgment by the pilot to insure adequate distance from objects in the takeoff area, which resulted in damage to the main landing gear on takeoff, and the uncontrolled ground loop by the pilot during a landing with the damaged landing gear. Factors related…Sep 1, 1992 · N4493Z · Substantial damageNTSB SEA92LA193Accident · No injuriesLimited investigationFinal reportCessna 172N · Snohomish, WAInadequate visual lookout by the other pilot.Aug 31, 1992 · N737TK · 2 aircraft · DestroyedNTSB MIA92LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Oak Hill, FLFailure of the pilot-in-command to level off during the simulated forced landing.Aug 29, 1992 · N8410R · Substantial damageNTSB CHI92LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Marseilles, ILThe pilot-in-command's failure to abort the takeoff. A factor was the partial loss of engine power.Aug 25, 1992 · N5544J · Substantial damageNTSB ATL92LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greensboro, NCThe failure of the pilot in command to maintain control of the airplane, and his improper use of the rudder during a go-around.Aug 25, 1992 · N9749W · Substantial damageNTSB FTW92LA217Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Farmington, NMTotal loss of engine power due to carburetor ice and the pilot's delayed use of carburetor heat. A factor was unsuitable terrain.Aug 23, 1992 · N8841D · Substantial damageNTSB ANC92LA139Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKThe pilot's improper preflight planning/preparation, his improper compensation for wind conditions, and his failure to maintain directional control during the takeoff run. Contributing to the accident was the crosswind.Aug 22, 1992 · N63805 · Substantial damageNTSB ANC92LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Mackey Lake, AKA loss of power for undetermined reasons. A factor which contributed to the severity of the accident was the pilot inadvertently stalled the airplane.Aug 18, 1992 · N4714Y · Substantial damageNTSB LAX92FA356Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Incline Village, NVWas the pilot's in flight loss of airplane control due to physical incapacitation.Aug 17, 1992 · N2406J · DestroyedNTSB ANC92LA132Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot failed to maintain airspeed and stalled the airplane. Contributing to the accident was the unfavorable wind condition.Aug 14, 1992 · N3906Z · DestroyedNTSB ANC92LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Eisenmenger Crk, AKThe pilot's improper preflight planning/preparation, and his failure to attain clearance of the high vegetation during takeoff. A contributing factor to the accident was the high vegetation.Aug 13, 1992 · N3889P · Substantial damageNTSB NYC92LA162Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Ocean City, NJThe airplane nosing over on landing roll due to inadequate airplane handling characteristics while landing with the banner attached. Factors related to the accident were the use of rope instead of steel cable, the main landing gear mounted tow hitch, and the…Aug 12, 1992 · N9374D · Substantial damageNTSB NYC92LA154Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Keene, NHAn inadvertent stall during flap retraction, following an aborted landing.Aug 10, 1992 · N738FW · Substantial damageNTSB ANC92LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bettles, AKThe pilot's improper in flight planning/decision, and his failure to maintain a proper altitude while operating in the mountains. A contributing factor was the mountainous terrain.Aug 10, 1992 · N6592L · Substantial damageNTSB ANC92LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Cinnibar, AKThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.Aug 9, 1992 · N9557D · Substantial damageNTSB CHI92LA229Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenwood, NEThe private pilot's poor in-flight planning and decision making.Aug 6, 1992 · N30108 · Substantial damageNTSB DEN92LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Littleton, COInadvertent stall during final approach to landing.Aug 5, 1992 · N4037E · Substantial damageNTSB FTW92FA201Accident · 1 fatalField investigationFinal reportCessna 172P · Breckenridge, TXAn inadvertent stall.Aug 4, 1992 · N63930 · Substantial damageNTSB MIA92FA158Accident · 4 fatalField investigationFinal reportCessna 172K · Rockledge, FLFailure of the pilot to maintain adequate airspeed during the final approach resulting in an inadvertent stall. Contributing to the accident was the pilot's lack of recent experience in the type operation, lack of experience at the airport in the type…Aug 2, 1992 · N1196M · DestroyedNTSB CHI92LA221Accident · Minor injuriesLimited investigationFinal reportStitts SA-11A · Oshkosh, WIThe pilot's failure to maintain control of the homebuilt airplane during the landing. A related factor was the pilot's improper planned approach.Aug 2, 1992 · N6515 · Substantial damageNTSB ANC92T#A07Accident · No injuriesClass 3Final reportPiper PA-18 · Shishmaref, AKAug 1, 1992 · N2497B · Substantial damageNTSB FTW92LA195Accident · No injuriesLimited investigationFinal reportBeech 19A · Mounds, OKThe student pilot's failure to execute a go around when he realized he was going to land long.Jul 30, 1992 · N7642R · Substantial damageNTSB MIA92LA157Accident · No injuriesLimited investigationFinal reportCessna 172P · Valkaria, FLExcessive airspeed on final approach by the pilot in command resulting in failure to attain the proper touchdown point and running off the runway colliding with a tree.Jul 29, 1992 · N89900 · Substantial damageNTSB SEA92LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Sisters, ORThe improper use of flight controls by the PIC during an aborted takeoff. Factors relating to the accident were the unfavorable wind (windshift) encountered during takeoff ground roll, the tailwind and high da weather conditions.Jul 27, 1992 · N5639W · Substantial damageNTSB LAX92LA316Accident · No injuriesLimited investigationFinal reportCessna 177 · Turlock, CAThe pilots poor planning in not properly securing the aircraft with tiedowns, chocks or brakes prior to attempting to start the engine by hand propping.Jul 26, 1992 · N2279Y · Substantial damageNTSB MIA92LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Panama City, FLThe pilot-in-command's failure to stand clear of the propeller as he rotated it by hand, resulting in the propeller rotating around due to engine compression, striking the pilot, causing him to lose his balance and fall to the ramp, resulting in serious…Jul 25, 1992 · N733MX · No damageNTSB FTW92LA194Accident · No injuriesLimited investigationFinal reportCessna 172L · Ozona, TXThe pilot's failure to maintain obstacle clearance.Jul 25, 1992 · N9880G · Substantial damageNTSB SEA92FA161Accident · 1 fatalField investigationFinal reportCessna 172I · Donnelly, IDThe pilot's failure to maintain airspeed after takeoff while using improper obstacle takeoff procedures. Factors include excessive flap extension.Jul 24, 1992 · N27JF · Substantial damage