NTSB investigations: Lycoming 0-320 series, NM

203 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.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
    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 FTW96LA246Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMfailure of the pilot to maintain directional control during a touch-and-go landing, which resulted in a ground swerve and subsequent collision with a parked airplane.Jun 12, 1996 · N3535E · Substantial damageNTSB FTW95LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's delayed landing flare and the improper bounced landing recovery.Feb 23, 1995 · N737TC · Substantial damageNTSB FTW95LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during a touch-and-go landing.Dec 29, 1994 · N737ZJ · Substantial damageNTSB FTW95LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmington, NMThe pilot's inadequate compensation for wind conditions. Factors were wind shear, crosswinds, and gusts.Oct 13, 1994 · N20384 · Substantial damageNTSB FTW93FA274Accident · Serious injuriesField investigationFinal reportRobinson R22 Beta · Deming, NMThe pilot's inadequate preflight planning and preparation. Factors were high density altitude and the over gross weight condition of the aircraft.Sep 30, 1993 · N2360B · Substantial damageNTSB FTW93LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's failure to maintain directional control. A factor was the snow conditionsJan 12, 1993 · N734GD · Substantial damageNTSB DEN93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe pilot's failure to maintain aircraft control and the instructor's inadequate supervision.Nov 8, 1992 · N4069Z · 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 FTW92LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Truth Or Cons, NMThe pilot's inability to stop due to worn brakes and low brake fluid.Jun 5, 1992 · N4547A · Substantial damageNTSB FTW92LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during landing. A factor was his lack of total experience.Jan 14, 1992 · N4885G · Substantial damageNTSB FTW92LA021Accident · No injuriesLimited investigationFinal reportCessna 177 · Santa Teresa, NMThe pilot's failure to initiate corrective action in a timely fashion.Nov 7, 1991 · N29348 · Substantial damageNTSB FTW92LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Springer, NMThe pilot's poor judgement in attempting flight into forcasted adverse weather, his disregard for the hazardous weather advisory received which resulted in partial loss of engine power as a result of a blocked induction system due to ice and snow, and the…Nov 2, 1991 · N61539 · Substantial damageNTSB DEN90LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Las Vegas, NMThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.Aug 26, 1990 · N3163Z · Substantial damageNTSB DEN90LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Grants, NMThe pilot's failure to maintain directional control.Jul 16, 1990 · N46593 · Substantial damageNTSB DEN90TL#01Accident · Serious injuriesClass 3Final reportPiper PA-18-150 · Alamagordo, NMNov 8, 1989 · N726 · DestroyedNTSB DEN89LA214Accident · Serious injuriesLimited investigationFinal reportPiper PA-18A-150 · Winston, NMDeteriorated carburetor float. Factors related to the accident were: high density altitude and the terrain conditions in the emergency landing area.Sep 12, 1989 · N9496D · DestroyedNTSB DEN89FA184Accident · 1 fatalField investigationFinal reportCessna 172M · Albuquerque, NMThe pilot deliberately flew his aircraft into the face of a mountain. A contributing factor was: the psychological condition of the pilot.Aug 6, 1989 · N64263 · DestroyedNTSB DEN89LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ruidoso, NMThe pilot's improper use of the mixture control and carburetor heat during a takeoff in high density altitude conditions. Contributing to the accident was the high density altitude.Aug 5, 1989 · N9183H · DestroyedNTSB DEN89FA093Accident · 2 fatalField investigationFinal reportCessna 177RG · Albuquerque, NMThe pilot's improper use of flaps during takeoff which resulted in inadequate airspeed, a stall, and loss of control.Mar 25, 1989 · N2972X · DestroyedNTSB DEN89LA052Accident · No injuriesLimited investigationFinal reportBeech 19 · Santa Fe, NMThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.Jan 2, 1989 · N9739L · Substantial damageNTSB DEN89LA015Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Edgewood, NMThe acft had just been overhauled & a new prop (hartzell model 7636D-4) had been installed in place of the old prop. The plt rprtd that after takeoff, the acft failed to climb, although he was using full power. He said he headed for lower terrain & circled…Oct 14, 1988 · N7258D · Substantial damageNTSB DEN88FA119Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Maljamar, NMWhile in slow flt at low level on a oil pipeline patrol demonstration flt, the acft entered a left turn and, according to witnesses, the nose suddenly dropped and the acft crashed in a vertical attitude. The acft was destroyed in the accident and both…Jun 2, 1988 · N1393R · DestroyedNTSB DEN88FA084Accident · 1 fatalField investigationFinal reportPiper PA-22 · Angel Fire, NMAfter takeoff, the acft could not outclimb rapidly rising terrain off the end of the rwy and collided with trees/terrain. Exam of wreckage disclosed fouled plugs from rich mixture and low cyl compression. Exam of airport info did not describe topography…Mar 19, 1988 · N3254Z · DestroyedNTSB DEN88LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMThe private plt and two pax attempted takeoff at or near max gwt at a density alt of 6,500 ft MSL. Full fuel had been loaded in the right tank and the plt indicated that the left tank was empty. Rwy 24 was in use with a 70 degree x-wind reported from 310…Mar 13, 1988 · N32982 · Substantial damageNTSB DEN88DQA03Accident · 2 fatalFinal reportSurline Sidewinder · Moriarty, NMWitnesses heard the acft eng sound increase dramatically as the acft passed over a gen aviation airport. The acft was seen by another witness at low atl, estimated to be about 200 ft, as the nose pitched up. The acft then entered a spin and impacted the…Mar 12, 1988 · N185SA · DestroyedNTSB DEN87LA191Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Portales, NMThe plt was practicing aerial application maneuvers without chemicals onboard. During a turn, the plt reported that the engine lost power. The plt leveled the wings and lowered the nose to gain airspeed. The plt selected a landing site and after touchdown,…Jul 20, 1987 · N6419Z · Substantial damageNTSB DEN87LA180Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Tierra Amrilla, NMNo witnesses were found who had seen the accident. The man believed to be the plt gave the investigating police officer an assumed name. The wreckage dissappeared soon after the crash and has not been found to date. The acft attempted a takeoff with four…Jul 13, 1987 · N84704 · Substantial damageNTSB DEN87LA166Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Las Vegas, NMThe plt reported that he experienced a departure stall after take off. A witness reported that the plt attempted a steep turn immediately after takeoff and that the acft appeared to stall. The left wing went down and the acft began an uncontrolled descent…Jul 4, 1987 · N9406P · Substantial damageNTSB DEN87LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Los Lunas, NMThe plt reported that after touchdown, the acft swerved to the right and went into a water filled irrigation ditch. The acft nosed over and came to rest inverted. A post accident inspection revealed a deflated tail wheel which appeared to have blown out. It…Jun 14, 1987 · N8924D · Substantial damageNTSB DEN86LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Quemado, NMThe plt said the wind was variable and gusty. When the takeoff was started there was a quartering headwind but as takeoff speed was reached the wind switched to a tailwind. The acft lifted off but immediately settled back to the rwy. The plt then added flaps…Feb 26, 1986 · N8935V · Substantial damageNTSB DEN85LA248Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Deming, NMWhile practicing touch and go landings the plt added pwr for takeoff and the eng quit. The plt veered the acft to the left to avoid hitting farm machinery and collided with a tree stump. Post accident exam of the eng revealed the eng mostlikely failed as a…Sep 24, 1985 · N7467D · Substantial damageNTSB DEN85LQA01Accident · No injuriesFinal reportPetracca Glasair SH-2 · Aztec, NMThe acft sustained substantial damage after it stalled and contacted the ground during takeoff. Plt stated lift off was made with minimal airspeed and the right wing dropped shortly after becoming airborne. Plt overcorrected for the right bank, the acft…Jul 10, 1985 · N272CP · Substantial damageNTSB DEN85LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Rio Rancho, NMDuring a pleasure flt, with his parents as pax, the plt decided to demonstrate a glide down to aprx 500 ft AGL. When he added power for recovery, he stalled the acft. Before complete recovery was possible, the acft struck the ground.Jul 7, 1985 · N53410 · Substantial damageNTSB DEN85LA211Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Lordsburg, NMThe plt said he had encountered moderate turbulence while en route & his passengers became air sick. He decided to land at the nearest suitable arpt. The landing was made without incident. However, while taxiing to the ramp, the aircraft encountered what one…Jul 4, 1985 · N4349Q · Substantial damageNTSB DEN85LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Silver City, NMThe plt stated after the accident that he was attempting to land on rwy 33. He continued to state that immediately prior to the landing flare, a 'terrific downdraft' forced the acft down on the rwy. The acft landed hard and the plt attempted a go-around. He…Oct 5, 1984 · N707FL · DestroyedNTSB DEN84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe acft swerved off the rwy and collapsed the left main landing gear during landing. The plt said he believes he misused the heel brakes during the landing roll since he was more familiar with acft with toe brakes.Feb 4, 1984 · N57528 · Substantial damageNTSB FTW84LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Gallup, NMThe plt reported that he was taking off from a dirt road when the eng lost power shortly after lift-off. Subsequently, the left main gear collapsed during a hard/forced landing.Dec 12, 1983 · N3957P · Substantial damageNTSB FTW84LA043Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Capitan, NMThe plt reported that the acft bounced on landing, resulting in the collapse of the main gear & damage to the prop & left wing. An exam revealed that the u-bolt which attaches the left main gear strut to the fuselage had failed due to tensile overload.…Oct 17, 1983 · N9109L · Substantial damageNTSB FTW83LA216Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Roswell, NMThe CFI stated, the acft was lined up on the center line at the end of runway 17. The student pilot applied power and the acft veered to the left, he over-corrected to the right. He further stated, 'I reduced the power to idle as the right landing gear…Apr 30, 1983 · N82946 · Substantial damageNTSB FTW83LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Los Lunas, NMDuring the landing roll, the plt lost directional control of the acft & it went off the right side of the rwy & hit an irrigation ditch. Reportedly, there was no acft malfunction or failure prior to the mishap.Mar 30, 1983 · N2421S · Substantial damageNTSB FTW83LA156Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ramon, NMThe flt departed Oklahoma city, ok with en route stops planned at amarillo, TX tucumcari, NM. At tucumcari, the occupants found themselves 'staggering a little' & concluded this was from exposure to hi alt (en route 6500 ft, tucumcari, 4065 ft). After…Mar 15, 1983 · N1841P · Substantial damageNTSB FTW82DA380Accident · No injuriesFinal reportCessna 172N · Hobbs, NMPilot collided with power line while on pipeline patrol. A sucessful landing was made at hobb, NM airport after accident.Sep 15, 1982 · N6553E · Substantial damageNTSB FTW82DA348Accident · No injuriesFinal reportCessna 172P · Albuquerque, NMThe student pilot lost control of the aircraft after a bounced landing. The aircraft ran off the side of the runway, encountered sandy terrain, and was damaged. The density altitude was about 7000 ft.Aug 15, 1982 · N5404K · Substantial damageNTSB FTW82DA312Accident · No injuriesFinal reportCessna 177 · Springer, NMWhile en route on a flight from gallup, NM to dalhart, TX, the left fuel tank would not feed. The pilot made a precautionary landing on rough, grassy terrain with no damage. An examination revealed that the tab for the left filler cap was broken and the cap…Jul 31, 1982 · N30157 · Substantial damageNTSB FTW82FQA22Accident · 4 fatalFinal reportCessna 172N · Santa Fe, NMThe acft struck the ground at a 40-45 deg angle & left wing down 1/2 mi from the departure end of rwy 20. No discrepancies were noted in aircraft systems. An eng disassembly revealed no malfunction. It was known the four occupants had a total weight of 857…Jul 18, 1982 · N6215D · DestroyedNTSB FTW82DA184Accident · No injuriesFinal reportCessna 172P · Las Cruces, NMThe student pilot reported that during landing, the airspeed was too high. Reportedly, the aircraft touched down hard on all three gear, propoised, and subsequently, the plane was damaged. The wind was reported as light and variable.May 19, 1982 · N54488 · Substantial damageNTSB FTW82DQD01Accident · Minor injuriesClosedBeech 19A · Sunland Park, NMOct 18, 1981 · N6058N · Substantial damageNTSB FTW81DQD29Accident · Minor injuriesClosedCessna 172 · Silver City, NMJul 17, 1981 · N6368G · Substantial damageNTSB FTW81DQA30Accident · No injuriesClosedMooney M20 · Farmington, NMMay 12, 1981 · N5218B · Substantial damageNTSB FTW81FQA26Accident · No injuriesClosedCessna 172 · Santa Rosa, NMApr 27, 1981 · N733YM · Substantial damage