NTSB investigations
2,878 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 351) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 DEN00IA075Incident · No injuriesIncident investigationFinal reportBeech A60 · Boulder, COThe fatigue failure of the #6 cylinder connecting rod cap.NTSB SEA00FA015Accident · No injuriesField investigationFinal reportKaman K-1200 · Emida, IDFailure of the splined engine adaptor as a result of torsional overstress. Factors include a worn freewheeling clutch assembly.NTSB NYC00FA023Accident · Serious injuriesField investigationFinal reportCessna T303 · Binghampton, NYThe pilot's improper in-flight decision to descend below the decision height without the runway environment in sight, and his failure to execute a missed approach. A factor in the accident was the failed crankshaft.NTSB FTW00LA028Accident · No injuriesLimited investigationFinal reportCessna 210K · Ponca City, OKInadequate quality control by the manufacturer of the throttle control cable, which resulted in failure of the cable due to fatigue. A factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA010Accident · No injuriesLimited investigationFinal reportMintz Vari EZE · Jean, NVThe failure of the engine cylinder head due to detonation and subsequent over temperature for undetermined reasons.NTSB FTW00LA009Accident · Minor injuriesLimited investigationFinal reportCessna 150G · El Reno, OKThe total loss of engine power resulting from a fatigue failure of the intake rocker arm for the #4 cylinder. A factor was the soft terrain encountered during the forced landing.NTSB LAX00LA055Accident · No injuriesLimited investigationFinal reportBell 206B · Apache Junction, AZOil starvation and seizure of the engines Nos. 6 and 7 bearings due to a clogged oil jet, which resulted in a total loss of engine power.NTSB IAD99FA070Accident · Serious injuriesField investigationFinal reportCessna 310Q · Salisbury, MDThe improper installation of the #2 cylinder that resulted in a fractured crankshaft and a total loss of engine power. Factors in the accident were the premature deployment of the landing gear and flaps by the pilot.NTSB NYC99IA239Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries 1124 · Nantucket, MAA fractured turbine wheel.NTSB LAX99LA314Accident · No injuriesLimited investigationFinal reportCessna 177A · Big Bear City, CAA loss of engine power due to fuel system contamination, which resulted from the mechanic's failure to fully inspect and verify the serviceability of the fuel system before returning the aircraft to service for a maintenance ferry flight. The pilot's decision…NTSB ATL99LA129Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Caledonia, MSThe failure of the fuel control gear train due to oil contamination. A factor was Inadequate maintenance.NTSB LAX99LA304Accident · Minor injuriesLimited investigationFinal reportGlover Teenie TWO · Chino, CAThe in-flight separation and loss of the carburetor fuel jet resulting from the pilot's improper installation of the component. Also causal was the pilot's failure to maintain an adequate airspeed margin following the loss of power, which resulted in an…NTSB CHI99LA340Accident · No injuriesLimited investigationFinal reportNavion A · Utica, NEthe failure of the fuel pump and the misjudged touchdown point by the pilot. A factor was the high vegetation.NTSB DEN99LA160Accident · Minor injuriesLimited investigationFinal reportBell UH-1H · Silverton, COThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI99LA319Accident · No injuriesLimited investigationFinal reportVan Grouw White Lightning · Greenfield, INimproper installation of the oil quick drain plug which resulted in oil exhaustion to the engine. A factor was the corn crop encountered during the forced landing.NTSB LAX99LA295Accident · No injuriesLimited investigationFinal reportCessna 150M · Menlo Park, CAThe fatigue failure of the left muffler rear wall, which resulted in hot exhaust gasses being ported onto, and shorting, the magneto p-lead wires. The failure of maintenance personnel to detect the impending failure of the muffler during the recent engine…NTSB NYC99LA219Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Andover, NJFatigue failure of the crankshaft.NTSB LAX99LA287Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Emigrant Gap, CAThe fatigue failure and separation of the number three cylinder due to the cylinder overhaul facility's improper inspection and quality control processes.NTSB MIA99LA234Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Robbins, TNThe total loss of engine power due to failure of maintenance personnel to assure that the thru bolt nut at the Nos. 2 and 3 cylinders was adequately torqued following removal and replacement of the No. 3 cylinder approximately 328 hours earlier. Also, the…NTSB FTW99FA235Accident · 1 fatalField investigationFinal reportBeech D-35 · Seminole, OKThe loss of engine power caused by oil starvation, which resulted in the failure of the #6 cylinder connecting rod bolts. A factor was the pilot's performance of an evasive maneuver to avoid impacting buildings, trees, people on the ground, and power lines.NTSB LAX99LA279Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Livermore, CAThe failure of the no. 3 cylinder exhaust valve due to the operator's failure to adhere to recommended overhaul periods set by the engine manufacturer. A factor in the accident was the operator's failure to comply with the manufacturer's mandatory service…NTSB LAX99LA277Accident · No injuriesLimited investigationFinal reportCessna T210L · Byron, CAThe failure of the operator's maintenance personnel to properly torque the cylinder and engine case through bolts during the replacement of five cylinders, which led to the spinning of the No. 2 main bearing and the resultant oil starvation induced…NTSB LAX99LA276Accident · Serious injuriesLimited investigationFinal reportMooney M20E · Lakeport, CAThe failure of engine shop maintenance personnel to tighten the fuel line fitting during assembly of the engine, and failure of the installing maintenance personnel to detect and tighten the loose fitting during the engine installation and annual inspection.NTSB LAX99FA270Accident · Serious injuriesField investigationFinal reportBeech J35 · Marysville, CAA loss of engine power due to improperly torque cylinder base nuts by maintenance personnel during a top overhaul.NTSB ANC99LA114Accident · No injuriesLimited investigationFinal reportCessna 206A · Cordova, AKA loss of engine power due to corrosion/blockage of the fuel flow divider vent hole. A factor was unsuitable terrain for a forced landing.NTSB FTW99LA227Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Rockwall, TXThe mechanic's improper machining of the crankshaft during a major overhaul, which resulted in a fatigue crack and subsequent failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.NTSB SEA99FA138Accident · Serious injuriesField investigationFinal reportBeech H-35 · Swan Lake, MTDetonation/pre-ignition due to use of improper grade and type of fuel (automotive) and the pilot-in-command's failure to use proper fuel specified by manufacturer's directives.NTSB CHI99LA297Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Oberlin, KSEngine failure due to an undertorqued carburetor fulcrum screw. Contributing factors were the muddy terrain and the low altitude of the aerial operation.NTSB MIA99LA213Accident · No injuriesLimited investigationFinal reportWilliam Jay Kinney Challenger II · Pahokee, FLfailure of the engine to propeller drive belt for undetermined reasons, resulting in loss of engine power, and a forced landing to unsuitable terrain.NTSB ANC99LA099Accident · No injuriesLimited investigationFinal reportBoeing 747-269B · Anchorage, AKThe failure of a turbine blade, and subsequent penetration of the shroud (containment ring). A factor associated with the accident was the FAA's insufficient design standards/requirements addressed in an FAA Air Worthiness Directive, which called for a…NTSB MIA99LA204Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Isola, MSFailure of the No. 4 cylinder due to a leaking intake valve resulting in loss of engine power and collision with a ditch while making a forced landing on unsuitable terrain. Contributing to the accident was improper maintenance adjustment of the engine valves…NTSB CHI99LA253Accident · No injuriesLimited investigationFinal reportBeech B36TC · Brookfield, MOthe total mechanical failure of the engine crankshaft due to fatigue. A factor was the ditch encountered on landing.NTSB ATL99LA112Accident · No injuriesLimited investigationFinal reportBeech 77 · Dawson, GAThe loss of engine power due to fuel starvation that resulted from a blocked fuel line check valve.NTSB ATL99LA109Accident · 1 fatalLimited investigationFinal reportBlackburn John D. Jr. Bushby M II · Daytona Beach, FLThe pilot's failure to securely reconnect the distributor coil wire during routine maintenance. Factors were the unsuitable terrain and trees.NTSB MIA99LA196Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Boca Raton, FLa total loss of engine power due to a failed oil pump impeller which resulted in a forced landing and a subsequent hard landing on a golf course.NTSB NYC99LA172Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Isle Of Wight, VAThe improper visual inspection of overhauled engine components by maintenance personnel.NTSB LAX99LA248Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · San Luis Obispo, CAThe failure/separation of the crankshaft idler gear and the fatigue failure and subsequent separation of the crankshaft dowel pin due to the improper static and dynamic balance of the propeller by maintenance personnel.NTSB LAX99LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Luis Obispo, CAA loss of engine power due to contamination of the induction system and the carburetor throat. Factors in the accident were a prior undetected carburetor fire, which caused a deterioration in the air duct material.NTSB CHI99LA226Accident · No injuriesLimited investigationFinal reportCessna 177RG · Weldon Springs, MOthe loss of engine oil for undetermined reasons. A factor was the trees.NTSB LAX99LA233Accident · No injuriesLimited investigationFinal reportErcoupe E · Winnemucca, NVAn improperly installed and maintained float needle in the carburetor, which would not seat sufficiently to stop fuel flow and caused the engine to run excessively rich, resulting in a complete loss of engine power.NTSB LAX99LA236Accident · Serious injuriesLimited investigationFinal reportMiller Rotorway Exec 162F · Pacoima, CAThe pilot's improper valve adjustments and failure to follow the manufacturer's instructions, which resulted in a loose number 3 cylinder rocker arm and a loss of engine power.NTSB LAX99IA230Incident · No injuriesIncident investigationFinal reportBoeing DC-9-82 · San Diego, CAfailure of the number three bearing. The resulting oil leak from the bearing led to coke/carbon buildup, which resulted in chafing of the turbine's low-pressure compressor drive shaft on the rear compressor seal tube and subsequent fracture of the drive shaft.NTSB NYC99LA153Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Rising Sun, MDThe failure of the connecting rod end bolts, due to an overtemperature condition.NTSB CHI99LA183Accident · No injuriesLimited investigationFinal reportGrumman American G-164B · Goodland, KSthe fracture of the rocker arm bolt. Contributing factors were the pilot's low altitude and the crops.NTSB MIA99LA164Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Timmonsville, SCThe loss of engine power due to the improper installation and in-flight separation of an engine cylinder.NTSB FTW99LA155Accident · No injuriesLimited investigationFinal reportBell 206B · Venice, LAThe pilot's improper touchdown procedure, resulting in a main rotor blade contacting the tailboom. Factors were the soft and wet terrain conditions, and the loss of engine power due to the spiral fatigue failure of the gas generator turbine shafting due to…NTSB LAX99LA202Accident · No injuriesLimited investigationFinal reportBeech D-45 · Lake Berryessa, CALoss of engine power due to a loose adjustment nut on the engine driven fuel pump that allowed for a decrease in fuel flow and fuel pressure, and the subsequent failure of the electric fuel boost pump due to loose bearings decreasing fuel flow and fuel…NTSB LAX99LA201Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Valley Springs, CAThe fatigue failure and separation of the No. 6 connecting rod end cap, which led to a catastrophic failure of the engine. The fatigue crack initiation was due to galling on the rod end cap, which was most likely caused by an undetermined factory…NTSB NYC99LA112Accident · Serious injuriesLimited investigationFinal reportAbrams Titan Tornado · Monroe, CTThe failure of the magneto (mag) cylinder bearing resulting in a total loss of power and subsequent forced landing.NTSB ATL99LA087Accident · No injuriesLimited investigationFinal reportCessna T188C · Bruce, MSThe loss of lubrication to the number 2 connecting rod due to the shifted bearing that resulted in the total loss of engine power.