NTSB investigations: Lycoming IO-540 series
1,056 cases on aircraft whose registry engine model is Lycoming IO-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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41530', '41585'))
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 ('41530', '41585'))
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 CHI04LA034Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Superior, WIThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the ditch that the airplane contacted.NTSB DEN04LA022Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Truth or Conseq, NMthe pilot's inadequate flare and his failure to maintain directional control. A contributing factor was the night light conditions.NTSB CHI04FA025Accident · 1 fatalField investigationFinal reportCommander 114TC · Hutchinson, KSThe pilot's diverted attention during the missed approach which resulted in aircraft control not being maintained. Factors to the accident included the pilot not being current for instrument operations and the low cloud ceiling at night.NTSB ATL04FA023Accident · 1 fatalField investigationFinal reportPiper PA-32R-301 · Spencer, TNThe pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and the subsequent collision with the ground.NTSB ATL04LA014Accident · Minor injuriesLimited investigationFinal reportMcCan Velox Revolution II · Mooresville, NCThe pilot's inadequate in-flight planning/decision to conduct an aerobatic maneuver at an altitude too low to initiate a recovery.NTSB LAX04CA008Accident · No injuriesData collectionFinal reportVelocity XL · Casa Grande, AZthe pilot's misjudged landing flare and inadequate compensation for crosswind conditions, which resulted in his failure to maintain runway alignment.NTSB NYC04CA002Accident · No injuriesData collectionFinal reportLake LA250 · Laconia, NHThe pilot's improper starting procedure. A factor in the accident was the pilot's lack of recent experience in make and model airplane.NTSB FTW04LA001Accident · Serious injuriesLimited investigationFinal reportBratton Experimental Homebuilt Swearingen SX300 · Floresville, TXThe separation of one propeller blade while in cruise flight. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB NYC03FA205Accident · 2 fatalField investigationFinal reportCessna 182T · Concord, MAThe pilot's failure to maintain aircraft control due to spatial disorientation. A factor was the low ceilings.NTSB CHI03LA314Accident · No injuriesLimited investigationFinal reportCessna 182S · Joliet, ILThe pilot not performing a go-around when the other airplane taxied onto the landing runway, which resulted in the pilot not attaining the proper touchdown point. Factors to the accident include the failure of the alternator, the complete loss of electrical…NTSB ANC03LA119Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · McGrath, AKFuel starvation due to the pilot's improper placement of the fuel selector to a nearly empty fuel tank prior to takeoff, resulting in a loss of engine power, and an in-flight collision with trees.NTSB SEA03FA179Accident · No injuriesField investigationFinal reportAero Commander Callair A-9B · Driggs, IDA loss of engine power due to the improper installation of a counterweight roller pin retaining washer circlip, leading to the circlip coming out of its groove and the counterweight roller pin coming in contact with two of the engines connecting rods.…NTSB NYC03LA178Accident · No injuriesLimited investigationFinal reportAerofab Lake 250 · Phippsburg, METhe airplane's collision with a submerged object during a water landing.NTSB IAD03FA070Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Factoryville, PAThe pilot's improper in-flight decision to descend below the published minimum descent altitude while executing a non-precision approach in instrument meteorological conditions, which resulted in collision with trees. A factor was the fog.NTSB NYC03WA174Accident · 1 fatalForeign investigationCessna 182T · Buckinghamshire, United KingdomNTSB NYC03LA166Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Newburyport, MAThe pilot's inadequate compensation for the wind conditions and his inadequate flare.NTSB DEN03LA134Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Logan, UTthe loss of engine power due to partial mechanical failure, which resulted in a forced landing. Contributing factors include the pilot's improper preflight planning/preparation, the improper rigging of the propeller governor control, the high density altitude…NTSB MIA03WA142Accident · 3 fatalForeign investigationBeech S-35 · San Vito Java, Costa RicaNTSB CHI03FA181Accident · 3 fatalField investigationFinal reportRobinson R44 II · Coleta, ILThe pilot not maintaining main rotor RPM during cruise flight. The factor in the two passenger's fatal injuries was the pilot not following directives concerning the prohibition of carrying passengers while a student pilot. Other factors were the pilot's use…NTSB FTW03LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-300 · Gruver, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA03LA066Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Plummer, IDThe jamming of the left parking brake locking tab on a burr on the left brake master cylinder activation rod during the landing roll, resulting in the left brake becoming locked in a position where excessive braking was applied.NTSB MIA03LA088Accident · 1 fatalLimited investigationFinal reportAir Tractor 502B · Belle Glade, FLThe failure of both pilots to use on-board communication radios to advise takeoff and landing intentions, the reduction of visibility of the pilot-in-command of N6037H due to sun glare during takeoff, and the poor in-flight planning by the pilot-in-command of…NTSB LAX03LA123Accident · No injuriesLimited investigationFinal reportRobinson R-44 II · Willcox, AZThe failure of the alternator belt which resulted in the failure of the main drive belt.NTSB FTW03FA120Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Broken Arrow, OKFailure of the engine due to the blow-by condition in the number six cylinder for undetermined reasons, which resulted in oil starvation and eventual failure of the associated connecting rod end cap. Also causal was the pilot's failure to maintain airspeed…NTSB MIA03FA065Accident · 1 fatalField investigationFinal reportAerofab Lake 250 · Weirsdale, FLThe inadequate flare by the pilot-in-command on the calm water resulting in the in-flight collision with the water and subsequent nose over.NTSB CHI03LA236Accident · 1 fatalLimited investigationFinal reportPolsgrove Bluegrass Express · Grafton, ILUndetermined.NTSB FTW03LA077Accident · No injuriesLimited investigationFinal reportCarlisle Comp Air 6 · Groesbeck, TXThe pilot's improper fuel selector position which resulted in the loss of engine power due to fuel starvation. A contributing factor was the soft terrain for the forced landing.NTSB CHI03FA047Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Barrington Hill, ILThe pilot's improper fuel management, which resulted in fuel starvation. An inadequate preflight inspection and the trees encountered during the forced landing were contributing factors.NTSB CHI03LA045Accident · No injuriesLimited investigationFinal reportCessna 182S · Alton, ILFailure of the pilot-in-command to maintain directional control during the takeoff roll. Contributing factors were the wet, icy runway conditions and the presence of the snowbank.NTSB ATL03LA027Accident · Minor injuriesLimited investigationFinal reportCessna 182S · Nashville, TNThe pilot's failure to maintain visual lookout and his inattentiveness during taxi that resulted in an on ground collision with an embankment. A factor was the fog.NTSB ATL03FA025Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Macon, GAThe loss of engine power due to oil starvation.NTSB FTW03LA061Accident · 1 fatalLimited investigationFinal reportCreekmore Team Rocket F-1 · Rosenberg, TXThe in-flight separation of the vertical stabilizer as a result of the builder's failure to install the upper attachment fitting for the vertical fin aft spar.NTSB MIA03WA031Accident · 2 fatalForeign investigationPiper PA-23-250 · Freeport, BahamasNTSB IAD03WA023Accident · Minor injuriesForeign investigationCessna 206H · Lawa Antino, SurinameNTSB SEA03FA015Accident · 2 fatalField investigationFinal reportCaron Seawind · Bryant, WAA loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain.NTSB NYC03FA024Accident · 1 fatalField investigationFinal reportSocata TB-20 · Massena, NYThe pilot's failure to maintain airspeed, which resulted in a stall. Factors in this accident were the icing conditions, deteriorated airplane performance due to ice accumulation, and control interference by the passenger as reported by the pilot.NTSB MIA03LA019Accident · 3 fatalLimited investigationFinal reportJohn H. Heiring Express · Moncks Corner, SCThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons, resulting in an inadvertent stall and subsequent uncontrolled descent and in-flight collision with water.NTSB FTW03WA032Accident · 1 fatalForeign investigationPiper PA-31-350 · Cambita, Dominican RepublicNTSB NYC03FA015Accident · 1 fatalField investigationFinal reportCessna 182S · Accident, MDThe pilots improper in-flight decision to continue flight into known adverse weather conditions. A factor related to the accident was the icing conditions.NTSB ANC03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Bethel, AKThe failure of both pilot's to maintain a visual outlook during taxi operations on the ramp.NTSB FTW03FA016Accident · 6 fatalField investigationFinal reportPiper PA-32-301 · Paron, ARThe pilot's failure to maintain altitude/clearance from terrain. Contributing factors were the low ceiling, the pilot's decision to fly in known adverse weather conditions, and his lack of an instrument rating.NTSB IAD03FA004Accident · 1 fatalField investigationFinal reportCessna 182S · Brownville Jct, METhe pilot's failure to maintain sufficient altitude while flying in mountainous terrain at night. A factor was the night lighting conditions.NTSB IAD03FA001Accident · 1 fatalField investigationFinal reportPiper Aerostar 602P · Bradford, PAThe pilot's failure to follow the published instrument approach procedure, which resulted in an early descent into trees and terrain. A factor was the night, instrument meteorological conditions.NTSB FTW03FA003Accident · 1 fatalField investigationFinal reportSocata TB-20 · Texarkana, ARThe inadvertamt stall by the student pilot, and the inadequate supervision by the flight instructor.NTSB CHI02FA294Accident · 2 fatalField investigationFinal reportAviat S-2C · Sheridan, INThe pilot's failure to maintain adequate altitude and airspeed while performing an aerobatic maneuver. Contributing factors were the pilot-in-command exceeding the aircraft weight and balance, and his inadequate preflight planning/preparation.NTSB ATL02LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · St. Simons Island, GAThe pilot's failure to maintain airspeed during a simulated emergency landing, and his delayed remedial action that resulted in a stall, and an uncontrolled collision with trees. A factor was the check pilot's inadaquate supervision of the check ride.NTSB MIA02FAMS3Accident · 1 fatalMissing aircraftFinal reportPiper PA-36-300 · MissingThe falure of the pilot to arrive at the intended destination for undetermined reasons. A finding in the investigation was the fact that clouds with tops to 44,000 feet were noted 38 miles south of the airplane's last position.NTSB LAX02LA275Accident · No injuriesLimited investigationFinal reportHuene Velocity XL-RG · Fresno, CAAn in-flight exhaust stack separation during descent for landing resulting in loss of engine power and a forced landing to an open field.NTSB NYC02LA167Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Chatham, MAThe pilot's improper in-flight decision to continue the landing after losing visual contact with the runway, which resulted in his failure to obtain the proper touchdown point, and the subsequent overrun. Factors in this accident were the clouds and low…NTSB ATL02LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Ft. Lauderdale, FLPilot in command failed to maintain directional control of the airplane during the landing roll that resulted in a ground loop and the overload failure of the right main landing gear.