NTSB investigations: Lycoming 0-540 series, FL

222 cases on aircraft whose registry engine model is Lycoming 0-540 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\" = 'FL' 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 ('41532'))
  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 MIA03LA145Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Fort Pierce, FLThe pilot's failure to maintain directional control of the airplane during landing roll resulting in collision with trees after the airplane departed the runway.Jul 20, 2003 · N5224Y · Substantial damageNTSB MIA03LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Gulf Hammock, FLThe insufficient information provided to the pilot by the mechanic that installed the auxiliary fuel tank for his failure to install a placard to indicate that both fuel on/off valves should not be on at the same time resulting in a total loss of engine power…Jun 12, 2003 · N6981Z · Substantial damageNTSB MIA03LA111Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Meade, FLThew failure of the pilot to abort the takeoff after travelling past the estimated point of liftoff, and failure of the pilot to maintain airspeed during the initial climb resulting in inadvertent stall and uncontrolled descent with subsequent impact onto the…May 23, 2003 · N3921W · Substantial damageNTSB MIA03CA091Accident · No injuriesData collectionFinal reportMaule M-5-235C · Jay, FLThe failure of the pilot to perform a go-around after bouncing following touchdown, resulting in the airplane nosing over during the landing roll.Mar 27, 2003 · N366X · Substantial damageNTSB MIA02LA056Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Sarasota, FLThe poor in-flight planning decision by the pilot-in-command for his failure to request the runway most aligned with the wind and his failure to maintain directional control during the landing roll.Jan 20, 2002 · N235AL · Substantial damageNTSB MIA01LA212Accident · 2 fatalLimited investigationFinal reportPiper PA-32-260 · Key West, FLThe inadvertent disabling of the throttle in the idle position during a cockpit disturbance created when an armed hijacker forcibly attempted to cause the aircraft to fly to Cuba, resulting in a loss of controllability of power for sustainable flight and an…Aug 9, 2001 · N5569J · Substantial damageNTSB MIA00LA173Accident · No injuriesLimited investigationFinal reportRawdon T1 · North Miami Bch, FLThe failure of the pilot to change the fuel selector position after experiencing surging of the engine. Contributing to the accident was the partial loss of engine power due to fuel starvation and the incorrect reading of the left fuel gauge.May 27, 2000 · N2706D · Substantial damageNTSB MIA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, FLThe pilot's failure to complete the before landing checklist and extend the landing gear, resulting in a gear up landing. A factor in the accident is the failure of the landing gear warning circuit to activate the cockpit warning horn.Nov 30, 1999 · N1818R · Substantial damageNTSB MIA00LA011Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Ft. Lauderdale, FLThe PIC's improper use of cyclic control during landing which resulted in a main rotor strike of the terrain and the rotorcraft's tail boom.Oct 19, 1999 · N8364Z · Substantial damageNTSB MIA99LA274Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · St. Augustine, FLThe inadvertent inflight collision with a bird resulting in substantial damage to the right wing outboard leading edge.Sep 25, 1999 · N9123P · Substantial damageNTSB MIA99LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · St. Petersburg, FLthe pilots improper use of the hand brake during the landing roll out and his failure to maintain directional control, which resulted in the airplane exiting the runway and incurring substantial damage.Sep 12, 1999 · N8051P · Substantial damageNTSB MIA99LA116Accident · Serious injuriesLimited investigationFinal reportMaule M-7-235B · Boca Grande, FLThe pilots failure to maintain a visual lookout on landing resulting in an in-flight collision with a wave.Apr 3, 1999 · N10430 · Substantial damageNTSB MIA99LA089Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Everglades City, FLThe failure of the PIC to maintain directional control on takeoff roll following a loss of power brought about by fuel starvation due to the PIC's failure to verify the proper setting of the fuel selector valve, and the subsequent collision with trees during…Feb 21, 1999 · N8309P · Substantial damageNTSB MIA99LA073Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Orlando, FLA loss of engine power due to an engine assembly overload for undetermined reasons. A related factor was the pilot exceeded the airplane's maximum allowable weight.Feb 3, 1999 · N5528J · DestroyedNTSB MIA99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Clearwater, FLThe delay by the pilot-in-command (CFI) to take control of the airplane and inadvertent stall/mush resulting in the uncontrolled descent and impact with the runway.Dec 19, 1998 · N5836P · Substantial damageNTSB ATL99LA032Accident · No injuriesLimited investigationFinal reportCessna 310C · Ft Myers, FLThe inadequate preflight inspection of the airplane by the pilot and subsequent malfunction of the nose gear strut, and the pilot's failure to follow the landing checklist.Dec 9, 1998 · N218S · Substantial damageNTSB MIA98LA211Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Panama City Bch, FLThe pilot's inadequate inflight planning, which resulted in fuel exhaustion and the loss of engine power.Jul 26, 1998 · N8807L · Substantial damageNTSB ATL98IA039Incident · No injuriesIncident investigationFinal reportRobinson R-44 · Miami, FLAn inadequate service bulletin which did not require measurement of the cyclic trim assembly shaft and did not identify all helicopters in which shaft wear could lead to restricted movement of the lateral cyclic trim.Jan 23, 1998 · N972SA · No damageNTSB ATL97FA118Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Palm Bch Garden, FLloss of engine power for undetermined reasons and the pilot's failure to maintain flying speed.Aug 11, 1997 · N8213P · DestroyedNTSB MIA97LA042Accident · No injuriesLimited investigationFinal reportSiai-Marchetti F206C · Kissimmee, FLthe pilot misjudged the flare resulting in a hard landing.Oct 25, 1996 · N61FD · Substantial damageNTSB MIA96FA115Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Lakeland, FLthe pilot's failure to maintain airspeed (Vs) while turning on approach from base to final resulting in an inadvertent stall.Apr 12, 1996 · N6243P · DestroyedNTSB MIA96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Lake City, FLFailure of the pilot to select a fuel tank with adequate fuel for takeoff, which resulted in a loss of engine power due to fuel starvation during the initial climb, and improper flare by the pilot during the subsequent forced land.Jan 13, 1996 · N7498P · Substantial damageNTSB MIA96LA005Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Opa Locka, FLThe pilot's failure to maintain directional control of the airplane on landing resulted in a loss of control, sliding off the runway into a rock collapsing the landing gear.Oct 10, 1995 · N4587P · Substantial damageNTSB MIA95FA145Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Gainesville, FLThe pilot's loss of aircraft control due to spatial disorientation after continuing the VFR flight into instrument meteorological conditions. Factors relating to the accident were: the existing weather conditions and dark night that contributed to the pilot's…Jun 7, 1995 · N41481 · DestroyedNTSB MIA95LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · N. Miami Beach, FLInadequate annual inspection by maintenance personnel for failure to identify a hardened oil hose from the oil pump to the oil cooler inlet inside a protective fire sleeve. Additionally, unsuitable terrain encountered during the forced landing contributed to…May 5, 1995 · N3482W · Substantial damageNTSB MIA95LA081Accident · No injuriesLimited investigationFinal reportCessna R182 · Orlando, FLthe failure of the pilot-in-command to insure the landing gear was extended before landing.Mar 5, 1995 · N47U · Substantial damageNTSB MIA94LA122Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Margate, FLFailure of the pilot-in-command to position the fuel selectors to the fullest tank before landing resulting in the total loss of engine power from both engines due to fuel starvation.Apr 16, 1994 · N4857P · Substantial damageNTSB MIA94LA026Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Labelle, FLThe pilot-in-command exceeding the structural limits of the airplane's design limits by in-flight over-stress that resulted in damage to the gear extension system, fuselage and control surfaces.Nov 21, 1993 · N5755P · Substantial damageNTSB MIA93IA083Incident · No injuriesIncident investigationFinal reportAero Commander 500 · Everglades City, FLThe preexisting fatigue cracking of the propeller hub arm in the bearing retention radius due to polishing and wear of the radius from contact with the split rings, resulting in a propeller blade separating from the propeller hub on the takeoff ground run,…Mar 7, 1993 · N3836C · Minor damageNTSB MIA92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Brooksville, FLThe pilot-in-command's failure to maintain alignment with the runway during landing. This resulted in an in-flight collision with a runway marker, collapse of the right main landing gear, and subsequent collision with terrain.Aug 10, 1992 · N119Q · Substantial damageNTSB MIA91FA155Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Long Boat Key, FLAn inflight loss of control and subsequent collision with the water for unknown reasons.May 31, 1991 · N6376P · DestroyedNTSB MIA91LA081Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plant City, FLFailure of the pilot to maintain proper alignment during the landing roll, excessive rudder input, and loss of directional control resulting in the collapse of the right main landing gear.Feb 13, 1991 · N95T · Substantial damageNTSB MIA91LA041Accident · No injuriesLimited investigationFinal reportCessna 182RG · Orlando, FLFailure of the pilot to maintain directional control during the landing roll.Dec 9, 1990 · N5157T · Substantial damageNTSB MIA90LA140Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Boca Raton, FLThe pilots failure to flare the airplane for landing resulting in the hard landing.Jun 15, 1990 · N3822W · Substantial damageNTSB MIA89LA242Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Perry, FLFuel starvation due to wear and restricted movement of the carburetor float, which resulted in loss of engine power. Soft terrain in the emergency landing area contributed to overload failure of the nose gear.Sep 3, 1989 · N4CD · Substantial damageNTSB MIA89LA045Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile in cruise flt near an arpt, the prop separated. Plt was given vectors to arpt & entered pattern for lndg. Downwind leg was extended due to strong tailwind. Strong headwind on final caused acft to land short. During landing roll acft collided with two…Nov 28, 1988 · N8226P · Substantial damageNTSB MIA88DL001Accident · Serious injuriesFinal reportFalcon Special S/R · Lakeland, FLThe pilot experienced an in flight fire in the exhaust system while performing acrobatic maneuvers at an airshow. The aircraft is equipped with a pump that injects oil into the exhaust system to produce a visible smoke trail when vaporized by the exhaust…Apr 10, 1988 · N82RC · Substantial damageNTSB MIA88LA037Accident · No injuriesLimited investigationFinal reportMandley Steen Skybolt · Placida, FLWhen attempting to start the eng the plt heard it backfire & then observed smoke coming from under the eng cowling. He then immediately exited the acft & left the scene to summon the fire department. He later returned to find the aircraft consumed by fire.…Nov 16, 1987 · N44JM · DestroyedNTSB MIA87LA178Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kissimmee, FLThe plt failed to lower the landing gear prior to touchdown. Insp of the acft revealed that the landing gear warning horn & gear down & locked light were inoperative.Jun 10, 1987 · N6529P · Substantial damageNTSB MIA87LA104Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Navarre, FLShortly after take off with the fuel selector positioned to the rt tank, at an alt of aprx 250 feet, the eng quit. The plt force landed the acft in an inter coastal waterway with the landing gear extended. Insp of the acft revealed that the eng quit due to…Mar 11, 1987 · N7645P · Substantial damageNTSB MIA87LA075Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Ft.Lauderdale, FLThe plt repositioned the fuel selector from the left tip tank to the right main tank when the flt entered the traffic pattern. The eng then quit & a forced landing was made in an open field. Upon touchdown the left & right main landing gear were pushed…Jan 17, 1987 · N3743W · Substantial damageNTSB MIA87LA026Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marathon, FLWhile being followed at a low altitude by a united states customs service aircraft, the aircraft was observed entering a left turn. The left wing tip of the aircraft struck the water and it cartwheeled. After the crash, bales of an unknown substance floated…Nov 7, 1986 · N2107C · DestroyedNTSB MIA86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Crestview, FLWhile on final aprch with the ldg gear extended for ldg, the plt observed another acft ahead of him which he felt he was overtaking. He elected to execute a go-around & while on downwind leg, the plt retracted the gear absent-mindedly thinking he was…Aug 2, 1986 · N7992P · Substantial damageNTSB MIA86LA123Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Ocala, FLPurpose of the flight was to calibrate the spray equipment. The plt loaded the hopper with about 70 gallons of water and initiated a takeoff. At about 100 ft AGL on initial climb the cockpit filled with smoke and the eng failed. The acft struck a tree on…Apr 16, 1986 · N9592P · Substantial damageNTSB MIA86FA028Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Sorrento, FLThe flt was on a VFR x-country at 9500 ft with ATC flt following. The non-instrument rated plt advised ATC that he was unable to maintain VFR & climbed to 11,000 ft. he again avised he was unable to maintain VFR & was going to descend. The acft was observed…Nov 9, 1985 · N4862S · DestroyedNTSB MIA85IA211Incident · No injuriesIncident investigationFinal reportCessna R182 · Jacksonville, FLThe plt stated that he made a normal touchdown & on his landing rollout the nose gear collapsed. The landing gear was cycled several times after this occurrence & no abnormality was observed. No determination could be made of the malfunction of the landing…Jul 15, 1985 · N6289T · Minor damageNTSB MIA85IA156Incident · No injuriesIncident investigationFinal reportRockwell AC-500 · Palm Beach, FLOn final apch, the acft was advised twice by the tower to go around because his landing gear was not extended, the acft did not respond & landed gear up on rwy 13. Examination of the landing gear system after the occurrence revealed the warning horn was…Apr 24, 1985 · N3836C · Minor damageNTSB MIA85LA149Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Fellsmere, FLThe acft made a forced landing due to fuel exhaustion in an open field. On the landing roll, the nosewheel struck a ditch causing it to fold and the acft came to a stop resting on it's nose. The plt had determined the amount of fuel on board prior to takeoff…Apr 19, 1985 · N5836P · Substantial damageNTSB MIA85LA130Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Everglades, FLThe acft was on a flt over the Everglades at aprx 500 ft AGL, when the eng began to run rough & decreased to about 1200 RPM. During a forced landing, the acft fuel system burst before the acft came to rest & a fire erupted. The plt exited the acft & attempted…Mar 24, 1985 · N8773L · DestroyedNTSB MIA85FA112Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Jacksonvile, FLThe single eng land, pvt plt had an instrument rating, but had no rating to fly multi-eng acft. While on an illegal flt with marijuana on board, he contacted jacksonville apch control & advised that he could not see the ground due to dense ground fog, the…Mar 4, 1985 · N100DT · Destroyed