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 CHI89LA141Accident · No injuriesLimited investigationFinal reportCessna R172K · Wisconsin Dells, WIFailure of the pilot to insure the oil filler cap was properly secured when he serviced the aircraft before takeoff, and subsequent loss of oil and oil exhaustion. The tree was considered to be a contributing factor.NTSB LAX89IA242Incident · Minor injuriesIncident investigationFinal reportAerospatiale AS350D · Long Beach, CAThe failure of the engine driven fuel pump.NTSB BFO89FA060Accident · 1 fatalField investigationFinal reportBeech V35TC · Charlottesville, VAImproper installation of the throttle and variable absolute controller assemblies by maintenance personnel which resulted in a total loss of engine power.NTSB SEA89LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · American Falls, IDAn engine failure due to stripped and broken teeth on a magneto drive gear in the accessory gear box. A soft field caused the nose over during the forced landing.NTSB ANC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Quinhagak, AKPowerplant failure for an unknown reason, which resulted in an engine vibration, oil leak and a fire.NTSB NYC89LA165Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lancaster, NYWater contamination of the fuel, and an inadequate preflight by the pilot-in-command.NTSB MIA89LA190Accident · No injuriesLimited investigationFinal reportCessna 172M · Perry, FLFailure of the number three exhaust valve which necessitated a forced landing. The trees were considered to be a contributing factor.NTSB MIA89IA186Incident · No injuriesIncident investigationFinal reportBell 206L-1 · Chiefland, FLEngine failure due to failure of the first stage turbine wheel disk.NTSB ANC89LA114Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKA blocked fuel line between the fuel selector and the engine which caused fuel starvation.NTSB MKC89LA152Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Excelsor Sprgs, MOThe catastrophic failure of the aircraft engine and the pilots failure to maintain directional control of the aircraft during the landing roll. Improper maintenance, the dark night conditions, and restricted visibility due to oil on the windscreen were…NTSB DEN89LA165Accident · Minor injuriesLimited investigationFinal reportHenry Vickers HCV-110 · Newcastle, WYThe failure to the magneto. The selection of a powerplant with a single magneto system was an improper choice and directly contributed to the cause. The pilot's misjudgement of the wind for the approach to a forced landing resulted in an improper ground…NTSB MKC89LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Stockville, NETotal failure of the powerplant caused by a broken cylinder.NTSB NYC89LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Middletown, RIThe failure of both magnetos shortly after takeoff. .NTSB BFO89LA053Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Ocean City, MDLoss of engine power from exhaust gas leakage into the carburetor inlet, causing engine air starvation, and material failure of the exhaust manifold. .NTSB SEA89LA121Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Colfax, WAImproper installation of the cylinder assembly. The terrain was not suitable for a successful forced landing.NTSB ATL89LA169Accident · No injuriesLimited investigationFinal reportCessna 401 · Raleigh, NCImproper maintenance by other maintenance personnel and excessive fuel pressure to the right engine (rich mixture). A possible contributing factor was the worn/unserviceable internal lock nut in the fuel pump.NTSB ANC89LA103Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Iliamna, AKInadequate annual inspection by maintenance personnel.NTSB SEA89FA118Accident · 1 fatalField investigationFinal reportColonial C-1 · Bremerton, WAMalfunction of both magnetos due to deterioration of the coils, which resulted in the loss of engine power. Factors related to the accident were: an inadequate airworthiness directive (no calendar time limits), and the lack of suitable terrain (rough/uneven)…NTSB ANC89LA102Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Tuntutuliak, AKFailure of the engine crankshaft. A contributing factor to aircraft damage was a mud (dirt) bank which the aircraft hit during the emergency landing.NTSB MKC89LA143Accident · No injuriesLimited investigationFinal reportCessna 172 · Sauk Rapids, MNFailure of the pilot to properly secure the oil cap when he serviced the aircraft and oil starvation. Contributing factors were the terrain conditions.NTSB SEA89LA115Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Battle Mountain, NVThe loss of engine power in flight due to a broken number two rocker arm. Contributing to the accident was the vehicle on the road which resulted in the pilot flaring prematurely.NTSB NYC89LA150Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Niagara Falls, NYEngine failure due to oil starvation and collision with terrain during the forced landing. The oil starvation was caused by the oil leaking out of the drain because maintenance personnel failed to install the drain plug.NTSB FTW89DRD08Accident · Minor injuriesFinal reportSchweizer G-164B · Kaplan, LALoss of engine power due to a cracked cylinder.NTSB ATL89DKJ05Accident · Minor injuriesFinal reportHadley Teenie TWO · Guntersville, ALUndetermined. Factors related to the accident were: lack of a suitable landing area, high obstructions, and a dirt bank.NTSB FTW89DRD06Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Ville Platte, LAWear and/or failure of the carburetor/float. Factors related to the accident were: the terrain conditions.NTSB MIA89LA168Accident · No injuriesLimited investigationFinal reportBeech A24R · Gulfport, MSFailure of a #2 connecting rod assembly, which resulted in separation of the #2 cylinder and subsequent loss of engine power. Contributing factors were: inadequate maintenance, the transmission (power) line, and trees.NTSB DEN89LA132Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Monticello, UTInadequate preflight of the aircraft by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. The terrain condition was considered to be a factor.NTSB FTW89DPJ05Accident · No injuriesFinal reportNord Stampe SV4C · Bartlesville, OKTotal failure of the engine connecting rod.NTSB CHI89DET06Accident · No injuriesFinal reportDilley P51R · Hamilton, INThe failure of the #3 connecting rod. A factor was the unsuitable terrain.NTSB CHI89DEX04Accident · Serious injuriesFinal reportNorth American SNJ-5 · Sellersburg, INThe ingestion of a foreign object and subsequent supercharger impeller failure.NTSB MKC89LA119Accident · Minor injuriesLimited investigationFinal reportRockwell Thrush S2R · Carlisle, ARThe engine failed due to a cracked cylinder and the pilot was forced to attempt a landing in a rice field where the gear collapsed.NTSB ANC89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKA crack on the left side of the engine crankcase which resulted in a loss of lubricating oil and which forced the pilot to land on a gravel bar which resulted in a nose over during landing.NTSB MIA89LA166Accident · Serious injuriesLimited investigationFinal reportAyres S2R · Lambert, MSFailure of the engine impeller. The ditch in the emergency landing area was a related factor.NTSB MKC89LA114Accident · No injuriesLimited investigationFinal reportCessna 188 · Table Rock, NEThe catastrophic failure of the internal engine components due to oil starvation. Contributing to the severity of the accident was the rough terrain the pilot was forced to land on.NTSB FTW89LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Edmond, OKImproper maintenance performed by the company mechanic who failed to tighten the oil sump plug, and also failed to safety it.NTSB CHI89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Houghton, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion from lack of fuel. Factors related to the accident were: obstructions (road sign & guard rail) in the emergency landing area.NTSB DEN89DQA01Accident · No injuriesFinal reportMccoy BD-5 · Farmington, NMThe malfunction of the aircraft electrical system due to a faulty circuit breaker. The subsequent failure of the electrical system resulted in failure of the engine ignition system and loss of engine power.NTSB CHI89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Waunakee, WISlippage of a bearing, which resulted in blockage of the lubrication system, and subsequent failure of a connecting rod.NTSB LAX89LA146Accident · No injuriesLimited investigationFinal reportBeech A36 · Sacramento, CAFailure of the number four piston assembly. A factor related to the accident was: the soft/uneven terrain in the emergency landing area.NTSB DEN89LA115Accident · No injuriesLimited investigationFinal reportCessna 182G · St. Xavier, MTThe pilot's failure to maintain airspeed while maneuvering for a forced landing following a failure of the number two piston. Contributing to the accident was smoke in the cockpit.NTSB NYC89FA129Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Herkimer, NYA forced landing in unsuitable terrain due to an internal engine failure. The engine failure sequence was initiated by a failed oil pressure relief spring which had failed in fatigue due to improper plating of the spring. The spring failure caused oil…NTSB LAX89LA180Accident · No injuriesLimited investigationFinal reportMooney M20C · Hesperia, CAThe pilot, the operator of the airplane, improperly maintained the airplane, and during the ensuing forced landing the pilot's inflight planning was poor and that he misjudeged the airplane's altitude.NTSB ATL89LA126Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Siler City, NCImproper engine overhaul procedures which resulted in the catastrophic failure of the engine crankshaft. Contributing to the accident was the lack of a suitable forced landing area.NTSB DEN89LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Alamosa, COFatigue failure of the engine crankshaft. A factor related to the accident was: the terrain condition in the emergency landing area.NTSB LAX89DUQ03Accident · No injuriesFinal reportMartin Sorrell Hiperlight · Liano, CAEngine failure due to a seized piston.NTSB LAX89LA141Accident · No injuriesLimited investigationFinal reportHughes 369D · Vallejo, CAFatigue failure of a defective pc tube assembly resulting in a loss of engine power. A contributing factor was the unsuitable terrain.NTSB LAX89FA140Accident · 5 fatalField investigationFinal reportPiper PA-60-601P · Newport Beach, CAFailure of the pilot to attain adequate airspeed before maneuvering (turning) back toward the airport, which resulted in a loss of aircraft control. A factor related to the accident was: improper maintenance/installation of a fuel injector reference air line,…NTSB CHI89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Monee, ILInadequate maintenance/inspection of the aircraft after metal fragments were found in the oil, and worn cam lobes/followers/piston pin plugs, which resulted in oil contamination, restriction (blockage) in the oil system, oil starvation, and subsequent engine…NTSB CHI89LA063Accident · Minor injuriesLimited investigationFinal reportBeech 95-B-55 · Crothersville, INA failure of the engine due to a crankshaft counterweight failure. The pilot performed emergency procedures and executed a forced landing in an open field, where the aircraft encountered a large muddy area, bogged down and nosed over.NTSB MIA89LA114Accident · Minor injuriesLimited investigationFinal reportDyar KIT FOX · Purvis, MSFailure of the engine's rear piston. Factors related to the accident were: the pilot's lack of altitude for a forced landing and trees in the emergency landing area.