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 LAX97LA247Accident · No injuriesLimited investigationFinal reportSikorsky S-58T · Page, AZan engine failure resulting from the fracture of two power turbine blades, which had been previously subjected to a hot or hung start.NTSB ATL97LA104Accident · No injuriesLimited investigationFinal reportCessna 177RG · Knoxville, TNthe pilot's inadequate preflight by failing to ensure the oil filler cap was secured during his preflight inspection, and loss of engine oil (oil exhaustion), which resulted in subsequent engine failure. A factor relating to the accident was: the lack of…NTSB LAX97LA242Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Lake Mead, NVFailure of the number 4 piston for undetermined reasons.NTSB ANC97FA097Accident · 4 fatalField investigationFinal reportPiper PA-32 · Skagway, AKjamming/failure of the left magneto impulse coupling, which stopped rotation of the magneto gear, and resulted in subsequent shearing of the accessory intermediate idler gear. Factors relating to the accident were: the lack of suitable terrain for a forced…NTSB ATL97LA091Accident · Serious injuriesLimited investigationFinal reportBeech E50 · Tullahoma, TNimproper operation of the engine that produced internal damage, and improper servicing of the airplane by the owner/pilot mechanic that resulted in the subsequent mechanical failure of the engine crankshaft counterweight. Contributing to the accident was the…NTSB LAX97IA209Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-83 · Las Vegas, NVthe maintenance/overhaul facility's improper repair, which led to obstructed oil supply hole(s) at the #5 bearing inner race, then oil starvation and subsequent uncontained engine failure.NTSB FTW97LA223Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400A · Black Oak, ARThe loss of engine power due to compressor turbine blade failure. A factor was the lack of suitable terrain for the forced landing.NTSB ATL97LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Columbus, MSinadequate maintenance/inspection and subsequent corrosion of the air filter, which resulted in pieces of the air filter to block the intake to the carburetor and result in loss of engine power. A factor relating to the accident was: failure of maintenance…NTSB ANC97LA084Accident · No injuriesLimited investigationFinal reportAnderson Kitfox IV-1200 · Fairbanks, AKa seized crankshaft connecting rod bearing. A factor relating to the acciden was: the lack of suitable terrain for an emergency landing.NTSB FTW97LA202Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Lamar, COFailure of the left magneto and crank shaft idler drive gears. Factors were failure to perform a 100 hour inspection and unsuitable terrain for a forced landing.NTSB CHI97LA145Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-G · Colusa, ILimproper installation of the rocker arm assembly by maintenance personnel which led to the failure of the rocker arm. A factor was the soft terrain.NTSB LAX97LA192Accident · Minor injuriesLimited investigationFinal reportCrosby GEE BEE Sportster · Watsonville, CAan unknown failure of the engine oil system, which resulted in loss of oil and a seized engine.NTSB MIA97LA174Accident · No injuriesLimited investigationFinal reportConvair CV-240 · San Juan, PRfailure of the aft master rod in the right engine, and failure of the front master rod bearing in the left engine, which resulted in a forced landing on a beach and a subsequent encounter with ocean water.NTSB CHI97LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Fulton, MOa malfunction of the engine's carburetor that was associated with a spalled carburetor float fulcrum pin which resulted in fuel starvation.NTSB LAX97LA176Accident · 2 fatalLimited investigationFinal reportHughes 369D · Puako, HIerosion of second stage stator vanes, inadequate maintenance inspection for the erosion, and subsequent fatigue failure of a stator vane, which resulted in loss of engine power and a forced landing on mountainous/hilly terrain. Also causal was: the pilot's…NTSB FTW97LA189Accident · No injuriesLimited investigationFinal reportTownsend Kitfox · Greeley, COThe engine manufacturer's inadequate quality control by failing to install the harmonic balancer, causing the engine to fail catastrophically. A factor was the lack of suitable terrain on which to make a forced landing.NTSB LAX97LA182Accident · No injuriesLimited investigationFinal reportAyres S2R-T-34 · Tonopah, AZthe failure of the power turbine due to an overtemperature condition created by an improperly adjusted fuel control. A factor in the accident was the tripped circuit breaker which prevented the wing lights from operating during the forced night landing.NTSB CHI97IA127Incident · No injuriesIncident investigationFinal reportCessna T210 · Winona, MNLoss of engine power due to improper maintenance installation.NTSB ANC97LA068Accident · No injuriesLimited investigationFinal reportHammer Avid Flyer · Chitina, AKimproper overhaul of the engine, which resulted in a seized piston and resultant loss of engine power. Rough terrain in the emergency landing area was a related factor.NTSB FTW97LA170Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · El Dorado, ARThe pilot misjudging his altitude above the airport, resulting in not attaining the proper touchdown point. A factor was the separation of teeth from the aft gear of the spur gear assembly, which resulted in the interruption of fuel.NTSB LAX97IA170Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Tucson, AZan undetermined failure in the #1 (left) engine turbine assembly, which resulted in a fracture of the first stage nozzle guide vane (NGV) and subsequent damage to the turbine blades.NTSB MIA97LA144Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Smithfield, NCa fracture in the crankshaft, which resulted in a total loss of engine power, a forced landing, and a nose over.NTSB FTW97LA169Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Fluvanna, TXThe loss of engine power due to the failure of the reduction gear box. A factor was the lack of suitable terrain for the forced landing.NTSB CHI97LA105Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Elk Falls, KSfracture of the fuel selector assembly which resulted in fuel starvation.NTSB ANC97LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Alsworth, AKloss of engine power, due to failure of the number 2 connecting rod assembly (rod, bearing, & bolts). The lack of suitable terrain for a forced landing was a related factor.NTSB MIA97LA123Accident · No injuriesLimited investigationFinal reportCumberland Skybolt · Smithfield, NCInstallation by a student mechanic of a counterweight retaining washer that did not meet engine manufacturers specifications resulting in partial separation of the counterweight, failure of the No.5 connecting rod adjacent to the counterweight, and seizure of…NTSB LAX97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Furnace Creek, CAFuel starvation resulting from disconnection of the fuel selector valve. Factors which contributed to the accident were the pilot's intentional operation with known airplane deficiencies and the rough terrain.NTSB IAD97LA061Accident · Minor injuriesLimited investigationFinal reportTheis Quickie · Fostoria, OHa disconnect of electrical wires to the engine ignition, which resulted in loss of engine power and a forced landing. Factors relating to the accident were: the lack of suitable terrain for a forced landing, and the wheat (crop) that was encountered during…NTSB CHI97LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Des Moines, IAoil contamination and starvation due to the inadequate maintenance inspection of the pilot/owner. Factors included the deterioration of the piston pin plug, the connecting rod failure, and the unsuitable terrain for landing.NTSB ATL97LA053Accident · Minor injuriesLimited investigationFinal reportCatchot Hauler · Centerville, ALthe engine manufacturer's failure to install ballast resistors in the ignition system, which resulted in an electrical short in the dual ignition system and subsequent loss of engine power.NTSB LAX97LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Continental, AZloss of engine power as a result of detonation in the number 2 cylinder for undetermined reasons. A factor in the accident was the unsuitable nature of the forced landing area.NTSB FTW97LA147Accident · No injuriesLimited investigationFinal reportBeech M35 · Iowa Park, TXThe pilot's refueling of the airplane with automotive grade fuel which resulted in engine failure due to detonation. A factor was the lack of suitable terrain for the forced landing.NTSB LAX97LA134Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Oroville, CAa loss of engine power due to connecting rod bolt failure. The reason for the bolt failure was not determined. A contributing factor was the presence of trees in the emergency landing path.NTSB FTW97LA146Accident · No injuriesLimited investigationFinal reportBeech G33 · Bixby, OKfailure of a number two connecting rod bolt, possibly from being either over-torqued or under-torqued during installation, and failure of the pilot to see-and-avoid the transmission line, while performing a forced landing.NTSB FTW97LA141Accident · No injuriesLimited investigationFinal reportPiper PA-17 · N Little Rock, ARloss of engine power due to failure of the crankshaft. A factor relating to the accident was: the lack of suitable terrain for the forced landing.NTSB CHI97LA091Accident · No injuriesLimited investigationFinal reportCessna 152 · Ft. Leavenworth, KSfatigue failure and separation of the number 2 cylinder. A factor was the rough terrain.NTSB ANC97LA036Accident · Minor injuriesLimited investigationFinal reportWilliams Kitfox · Wasilla, AKa broken electrical wire, which resulted in an inoperative electrical fuel pump, an overly lean mixture, fuel starvation, and loss of engine power.NTSB IAD97GA054Accident · No injuriesFinal reportSchweizer 269C · Cleveland, OHThe engine failure from the rod cap bolt being sheared and the separation of the number two cylinder separating from the crankcase.NTSB FTW97IA128Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-32 · Houston, TXThe failure of company maintenance personnel to perform a proper inspection of the combustion chamber outer case, thus allowing a detectable crack to grow to a length at which the case ruptured.NTSB LAX97LA121Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Winters, CAthe failure of the engine cylinder head assembly due to operational fatigue.NTSB LAX97LA120Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD 369HS · Pacific Ocean (Pacific Ocean)A loss of engine power due to a deteriorated compressor air seal, which resulted from inadequate maintenance inspection of the helicopter to detect corrosion in the compressor case while being operated in a marine environment.NTSB CHI97LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Marquette, MImultiple oil leaks in the engine lubrication system. Factors were the disconnected wet vacuum pump line and the oil exhaustion.NTSB ATL97LA045Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Aikens, SCexcessive wear of the fuel metering unit/shaft, which resulted in a fuel leak and premature exhaustion of the fuel supply.NTSB MIA97LA093Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Nashville, GAa stuck (jammed) fuel selector valve, due to corrosion from a fuel drain spring, which resulted in fuel starvation, loss of engine power, a forced landing, and subsequent impact with trees. A factor relating to the accident was: the pilot's inadequate…NTSB FTW97LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Thibodaux, LAThe failure of maintenance personnel to comply with an airworthiness directive which specified the correct type of oil quick drain valve for this airplane, the installation of an incorrect oil quick drain valve by maintenance personnel, and the subsequent…NTSB LAX97LA116Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Morristown, AZfailure of the crankshaft due to improper inspection/overhaul procedures.NTSB LAX97LA114Accident · No injuriesLimited investigationFinal reportHoac Austria DV-20 · Galt, CAa disconnect of a fuel line fitting, due to the manufacturer's inadequate design and/or lack of adequate installation procedure for replacement of the fuel filter; which resulted in fuel starvation, loss of engine power, and a forced landing. Soft terrain in…NTSB FTW97LA094Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Lake Jackson, TXThe failure of the #2 cylinder for an undetermined reason which resulted in an exhaust leak that melted an oil line.NTSB MIA97LA076Accident · No injuriesLimited investigationFinal reportCessna U206D · Tampa, FLInadequate torque of the cylinder base nuts and through bolt nuts by company maintenance personnel which allowed movement of the crankcase halves. As a result the No. 2 main bearing failed which allowed excessive movement of the crankshaft resulting in…NTSB MIA97LA066Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fort Lauderdale, FLFailure of other maintenance personnel to properly torque a connecting rod bolt and nut for the No. 3 cylinder during engine overhaul.