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 MKC90LA137Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Goddard, KSFuel starvation due to a loose fuel strainer screen. A factor related to this accident was lack of suitable terrain for a forced landing.NTSB MKC90LA129Accident · No injuriesLimited investigationFinal reportRockwell S2R · Tilton, ARFailure of the engine blower(supercharger). Related to the accident was the soft/wet terrain, where the forced landing was performed.NTSB LAX90FA213Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Havasu Landing, CAFailure of the pilot to properly secure an oil supply line b-nut fitting after an oil change, which allowed the oil line to become disconnected and led to oil exhaustion and subsequent engine failure. A factor related to the accident was: unsuitable terrain…NTSB LAX90DVA04Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Buttonwillow, CAFailure of the #7 cylinder due to a pre-existing crack. The terrain condition was a related factor.NTSB SEA90LA116Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Camas, WAThe failure of a sprag clutch in the rotor-drive mechanism, at an altitude and position that precluded or limited the possibility of a successful outcome.NTSB LAX90FA209Accident · Serious injuriesField investigationFinal reportCessna 208A · Fresno, CAA loss of engine oil pressure due to improper maintenance performed on the engine oil filler cap by an unknown person. In addition, the pilot misjudged his landing approach to the runway during the forced landing which resulted in an overshoot and collision…NTSB SEA90LA094Accident · No injuriesLimited investigationFinal reportCessna A150M · Seattle, WAThe fuel starvation caused by carburetor contaminants blocking the accelerator pump inlet check valve assembly and main nozzle assembly.NTSB NYC90LA122Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Becket, MAA power loss due to oil starvation, after maintenance personnel failed to comply with Lycoming directives during the engine overhaul. Factors related to the accident were: improper adjustment of the engine oil pressure by maintenance personnel and unsuitable…NTSB LAX90LA198Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Glendale, AZFuel exhaustion. Resulting from the pilot's failure to perform refueling.NTSB FTW90LA109Accident · No injuriesLimited investigationFinal reportCessna 172XP · Leona, TXEngine power loss due to a totally obstructed air intake manifold. Contributing to the accident was the unsuitable terrain in which the forced landing had to be performed.NTSB NYC90LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fraconia, PAThe pilot failed to maintain sufficient airspeed to flare for landing. Factors related to the accident were: a power loss due to oil exhaustion, the failure of the pilot to conduct an adequate pre-flight and departing with the oil dip stick loose.NTSB MKC90LA112Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Little Rock, ARThe failure of the powerplant due to a sheared timing gear. Contributing factors were unsuitable terrain and restricted vision due to fog.NTSB LAX90DUM02Accident · 1 fatalFinal reportCunningham Prescott Pusher · San Diego, CAEngine failure due to mechanical failure of he internal components to the engine.NTSB LAX90LA171Accident · No injuriesLimited investigationFinal reportHughes 369E · Firebaugh, CAFailure by company maintenance to perform a mandatory compressor section inspection that resulted in the undetected erosion of the compressor vanes and engine failure. Contributing to the accident was the failure of the pilot to maintain adequate main rotor…NTSB LAX90DVG07Accident · Serious injuriesFinal reportGrumman G-164A · Gridley, CAFailure of the no.7 cylinder head which led to a forced landing and substantial damage to the aircraft when it nosed over after colliding with a ditch.NTSB FTW90LA103Accident · No injuriesLimited investigationFinal reportBeech BE-35M · Tomball, TXAn engine failure due to detonation and subsequent piston overtemperature and erosion. A factor related to the accident was the lack of suitable terrain.NTSB FTW90LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Tulsa, OKAn engine failure due to a disconnect in the magneto drive train caused by the crankshaft gear not being properly installed and secured during a recent engine overhaul.NTSB BFO90IA039Incident · No injuriesIncident investigationFinal reportBellanca 17-30 · Davis, WVThe improper installation of the connecting rod bearings on the number one cylinder.NTSB ANC90LA063Accident · No injuriesLimited investigationFinal reportBell 206B3 · Williamsport, AKThe manufacturer's inadequate part design and the improper maintenance techniques by the operator.NTSB FTW90DRA04Accident · No injuriesFinal reportGrumman 164A · Garwood, TXFailure of the number 8 cylinder.NTSB FTW90LA096Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · E. Island Blk15The loss of continuity in the compressor section of the engine due to a fatique failure of the spur adapter gear shaft.NTSB ATL90FA099Accident · No injuriesField investigationFinal reportAirship Industries Airship 600 · Creswell, NCThe failure of the electronic ignition units as the Airship traversed the directional antenna beam of a high intensity radiated electromagnetic field (hirf). Factors related to the accident were: the unfavorable wind and the lack of hirf certification…NTSB ANC90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKImproper installation of the fuel valve.NTSB MKC90LA081Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hornersville, MOFailure of an engine cylinder.NTSB ATL90LA091Accident · No injuriesLimited investigationFinal reportPZL 80 · Wilmington, NCPilot's failure to properly adjust the throttle friction which resulted in the disconnection of the entire assembly.NTSB NYC90LA081Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Limington, MEFuel starvation, due to carburetor contamination, which resulted in a forced landing in unsuitable terrain.NTSB MIA90LA096Accident · No injuriesLimited investigationFinal reportBell 47D1 · Rockledge, FLFailure of a connecting rod.NTSB CHI90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Monee, ILEngine failure due to oil starvation resulting from improper maintenance and directive compliance associated with the failed part.NTSB MKC90IA070Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Wichita, KSImproper installation of level arm.NTSB FTW90LA084Accident · No injuriesLimited investigationFinal reportCessna 172G · Rio Hondo, TXOil starvation induced power loss due to improper maintenance procedures. Contributing to the accident were inadequate maintenance inspection and the soft terrain in which the forced landing was performed.NTSB MIA90FA090Accident · Minor injuriesField investigationFinal reportButler Aerostar 601 · Lake Butler, FLInflight failure of the left engine which was caused by inadequate maintenance and inspection by company maintenance personnel resulting in heat damaged magneto leads as a result of a missing exhaust flange-to-turbocharger seal. In addition, the inflight…NTSB MIA90IA086Incident · No injuriesIncident investigationFinal reportStinson AT-19 · Titusville, FLTotal loss of engine power was undetermined.NTSB MIA90FA081Accident · 2 fatalField investigationFinal reportAerospatiale 350D · Miami, FLFatigue failure of an engine turbine blade, which resulted in a loss of power. Rough ocean water in the emergency landing area was a related factor.NTSB MKC90LA061Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Monette, ARFailure of the engine exhaust valve.NTSB DEN90IA072Incident · No injuriesIncident investigationFinal reportCessna 208A · Wright, WYThe incident was engine failure due to gas producer turbine disc blade failure caused by stress rupture.NTSB FTW90LA078Accident · Minor injuriesLimited investigationFinal reportCessna T50-A17 · Brackettville, TXAn engine failure caused by a malfunctioning carburetor and the pilot's misjudging his obstacle clearance which resulted in a wire strike while maneuvering to land. Factors in the accident were the uncommanded deployment of carburetor heat on both engines, an…NTSB NYC90LA074Accident · No injuriesLimited investigationFinal reportCessna 177B · Oxford, MAAn off airport landing in unsuitable terrain following a power loss due to a delaminated ceet duct between the air intake screen and carburetor air box.NTSB MIA90FA074Accident · Serious injuriesField investigationFinal reportCessna 210-M · Sarasota, FLThe total loss of engine power caused by crankshaft failure, due to fatigue cracking of undetermined origin.NTSB SEA90LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Vancouver, WAEngine loss of power was due to moisture damage to the coils in the magnetoes. During the forced landing in an open field, the airplane collided with a fence which resulted in substantial damage. The airplane had not undergone current maintenance inspections…NTSB DEN90LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gallup, NMImproper operation of the engine during preflight preparation, which resulted in overheating of the engine and damage to internal components.NTSB DEN90LA060Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Hungry Horse, MTFailure of the #4 connecting rod. Factors related to the accident were: the adverse weather conditions and lack of suitable terrain for a forced landing.NTSB MKC90LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Crane Lake, MNFailure of the connecting rod assembly. Factors related to the accident were: terrain conditions in the emergency landing area.NTSB CHI90IA084Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Chicago, ILFatigue failure of a first stage power turbine blade.NTSB NYC90LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Worcester, MAA power loss due to an oil pump failure while operating over unsuitable terrain. A factor related to the accident was night conditions.NTSB MIA90FA071Accident · No injuriesField investigationFinal reportPiper PA-28-161 · Roseland, FLThe engine failure due to fuel starvation caused by a needle valve in the carburetor which allows fuel to enter the carburetor bowl, stuck in the closed position for undetermined reasons resulting in the forced landing.NTSB DEN90FA055Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Rapid City, SDFailure of the pilot to maintain adequate airspeed (VMC), which resulted in a loss of aircraft control. A factor related to the accident was: fatigue failure of a coupling shaft in the #1 engine, which resulted in loss of power in that engine.NTSB CHI90LA076Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · South Webster, OHAn engine failure. Soft terrain in the forced landing area is a factor.NTSB FTW90LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Austin, TXFailure of the rocker arm in the engine driven fuel pump.NTSB NYC90LA053Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Brogue, PAOff airport landing due to an engine power loss due to failure of the no. 2 crankshaft bearing.NTSB FTW90LA055Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Liberty, TXLoss of engine power due to failure of the tappet faces. A factor in the accident was the unsuitable terrain in which the forced landing was made.