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 BFO93LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Monticello, MEA disconnection of the fuel line, which resulted in fuel starvation and loss of engine power. A related factor was the lack of suitable terrain for an emergency landing.NTSB BFO93LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Babylon, NYThe loss of engine power due to the intake valve failure.NTSB MIA93LA086Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Madison, MSInduction air control/system partial failure, induction air control/system leak, and the lack of suitable terrain for the forced landing.NTSB LAX93LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lake Havasu, AZThe improper welding of the inboard boss by an unknown person resulting in a fatigue failure on the inboard boss. A factor related to the accident was the vehicle that was struck during the forced landing.NTSB FTW93LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Houston, TXFuel starvation power loss due to carburetor restriction from a foreign object, the inadequate inspection and improper overhaul of the carburetor by other maintenance personnelNTSB DEN93LA030Accident · No injuriesLimited investigationFinal reportCessna T210N · Walsh, COA complete power loss from mechanical failure. A factor was: a pond, which the aircraft entered during landing roll.NTSB SEA93LA070Accident · No injuriesLimited investigationFinal reportCessna 172M · Salem, ORThe failure of the engine oil pump impeller.NTSB MIA93LA077Accident · No injuriesLimited investigationFinal reportBeech N35 · Fort Meade, FLThe collision with a road sign during a forced landing. Contributing to the accident was the total loss of engine power due to fatigue failure of the crankshaft.NTSB MIA93FA073Accident · No injuriesField investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLThe improper use of elevator flight control during the landing by the pilot in command.NTSB MIA93LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Raleigh, MSThe fatigue failure of the no. 1 exhaust valve for undetermined reasons, and the lack of suitable terrain for the forced landing.NTSB MIA93LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Bunnell, FLThe rupture of the oil cooler line at the adel clamp for undetermined reasons, resulting in a loss of engine oil, and a subsequent engine seizure.NTSB LAX93LA111Accident · No injuriesLimited investigationFinal reportCobb Intl Exec 90 · Chandler, AZThe manufacturer's inadequate quality control which resulted in the fatigue of the valve stem. The soft terrain contributed to this accident.NTSB LAX93LA099Accident · No injuriesLimited investigationFinal reportCessna 172L · Ramona, CAA loss of engine power related to inadequate and improper maintenance practices concerning the carburetor.NTSB SEA93LA055Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Medicine Bow, WYFailure of the #7 cylinder rocker arm. Factors contributing to the accident were unsuitable terrain and dark night conditions.NTSB FTW93IA067Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC8-55 · Dfw Airport, TXFailure of an engine turbine wheel for undetermined reasons.NTSB CHI93IA068Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Detroit, MIThe manufacturer's inadequate design of the fuel transfer tube system, which loosened/disconnected during engine operation.NTSB CHI93LA064Accident · No injuriesLimited investigationFinal reportCessna T210K · Metropolis, ILThe fatigue failure of the exhaust valve.NTSB MIA93LA037Accident · Serious injuriesLimited investigationFinal reportBunn, Richard B. Swearingen SX300 · Montgomery, ALThe pilot in command's decision to operate the aircraft with known fuel leaks and his failure to monitor fuel quantity en route which resulted in loss of engine power due to fuel exhaustion.NTSB DEN93LA018Accident · No injuriesLimited investigationFinal reportCessna 172E · Ramah, COA total loss of engine power due to mechanical failure of the number one connecting rod. A factor was: a forced landing onto unsuitable terrain.NTSB LAX93LA071Accident · No injuriesLimited investigationFinal reportHughes 369D · Hilo, HIThe bearing failures due to the operator's use of improper maintenance inspection and overhaul procedures by installing an unserviceable compressor module in the helicopter engine. Factors in the accident were the unsuitable nature of the terrain for the…NTSB ATL93LA040Accident · No injuriesLimited investigationFinal reportShaw Velocity HXB · Savannah, GAThe disengagement of the idler gear, which interrupted fuel pump operation, and resulted in the total loss of engine power. Factors were the lack of suitable terrain and the water.NTSB CHI93DET01Accident · No injuriesFinal reportCarlson Sparrow II · Lafontaine, INFuel starvation due to a blocked fuel line which was caused by improper gasket sealing compound.NTSB MIA93LA029Accident · Minor injuriesLimited investigationFinal reportHighcraft Buccaneer II · Rockledge, FLThe total failure of the engine-driven fuel pump on takeoff initial climb. A factor was unsuitable terrain.NTSB SEA93LA034Accident · No injuriesLimited investigationFinal reportBell 47G3-B2A · Montpelier, IDThe loss of engine power due to leaking internal carburetor seals, resulting from improper repair of the carburetor by an acft repair station.NTSB LAX93LA062Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Kamuela, HIThe inadequate 100-hour inspection performed by company maintenance personnel. Factors contributing to this accident are the fuel control exceeding the manufacturers' service limits; the inoperative fuel filter; the overtemperature of the gas generator…NTSB ANC93LA016Accident · No injuriesLimited investigationFinal reportCessna 185 · Point Hope, AKThe failure of the no. two cylinder connecting rod due to a slipped (spun) main crankshaft bearing which blocked off the oil hole to the connecting rod. A factor in the accident was the unsuitable terrain on which to perform a forced landing.NTSB LAX93LA054Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Rialto, CAThe pilot's poor preflight inspection and his failure to maintain flying speed during the forced landing. Conributing to this accident was the inadvertent stall, the preceding sand/dust storm, the engine assembly low compression due to sand in the intake and…NTSB LAX93LA051Accident · Serious injuriesLimited investigationFinal reportCessna 421C · Santa Maria, CA1) The internal failure of the left engine, left magneto due to inadequate maintenance and non compliance with the manufacturers service bulletins and recommendations, and 2) the failure of the pilot to attain the proper touchdown point during the landing…NTSB BFO93LA009Accident · Serious injuriesLimited investigationFinal reportRyan Navion · Dublin, VAImproper adjustment of the fuel pressure regulator which produced an inadequate fuel flow and subsequent fuel starvation. Factors related to the accident were: the rough terrain and trees in the emergency landing area.NTSB LAX93FA042Accident · 2 fatalField investigationFinal reportCessna TU-206F · Clearlake, CAThe exhaust valve failing due to a complete fracture which resulted in the total lose of engine power. Factors in this accident were: 1) the terrain not being suitable for a forced landing, and 2) low ambient light which hampered the pilot's ability to see…NTSB CHI93LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Kechi, KSMaintenance not performed (gasket deteriorated), other maintenance personnel.NTSB FTW93LA036Accident · No injuriesLimited investigationFinal reportCessna 210B · Mountain View, ARThe collapsed right main gear due to the gear locking mechanism not being engaged. A factor was the failed crankshaft.NTSB ATL93LA022Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Columbia, SCThe loss of engine power which resulted from fuel starvation when the carburetor float valve stuck in the closed position. A factor was the soft field .NTSB FTW93LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Liverpool, TXThe loss of engine power due to the failure of the engine blower. A factor was the lack of suitable terrain at the pilot's disposal.NTSB MIA93LA012Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Pierce, FLAn engine failure over unsuitable terrain. The cause of the engine failure was fuel contamination by ferrous metal particles that prevented the fuel servo from operating properly. The origin of the contamination is unknown.NTSB LAX93LA016Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Globe, AZMaintenance personnel failing to comply with airworthiness directives pertaining to the airplane's fuel bladders resulting in fuel capacity being decreased causing fuel exhaustion and subsequent loss of engine power.NTSB SEA92LA218Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Troutdale, ORSeparation of the number 3 cylinder exhaust valve head and overloading of the nose gear strut. A factor contributing to the accident was the uneven terrain.NTSB SEA92LA216Accident · No injuriesLimited investigationFinal reportCessna 182L · Vancouver, WAThe partial loss of engine power from failure of the no 5 piston, and the soft terrain at the forced ldg site, resulting in collapse of the nose landing gear.NTSB LAX92IA397Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC 10-10 · San Francisco, CAA fractured compressor assembly.NTSB BFO92FA152Accident · 2 fatalField investigationFinal reportMooney M20K · Weston, WVTotal loss of engine power due to the inadequate torque of the no. 1 cylinder attach bolts and studs, fatique failure of the bolts/studs, and separation of the no. 1 cylinder. Factors related to the accident were: darkness and hilly terrain, which were…NTSB ATL92LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Jasper, TNThe fractured valve which resulted in a total loss of engine power, while flying over terrain that was not suitable for a forced landing. A factor was the densely wooded, mountainous terrain.NTSB CHI92DTG06Accident · No injuriesFinal reportCessna 188B · Cogswell, NDLoss of engine power as a result of a complete piston failure.NTSB SEA92LA198Accident · No injuriesLimited investigationFinal reportSlade H. Holmes SOL Kitfox II · Baker, ORThe engine seized and the airplane encountered unsuitable terrain during the forced landing.NTSB CHI92DCA04Accident · Serious injuriesFinal reportTinsman RV6 · Foristell, MOThe partial failure of the fuel injection system. Factors related to the accident are the pilot's insufficient altitude to reach the runway from the downwind leg, and the presence of transmission wires in the off airport landing site.NTSB CHI92LA274Accident · No injuriesLimited investigationFinal reportCessna 172P · St. Charles, MIThe jamming of the oil pressure pump caused by the failure of the oil pressure pump driven impeller. The lack of a suitable landing area was a factor.NTSB CHI92DTG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Alice, NDComplete loss of engine power as a result of the partial failure of four pistons.NTSB LAX92LA377Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, CAThe unknown pilots improper use of the throttles which resulted in the overboosting of the engine. Contributing to the accident was the maintenance personnel improper maintenance in adjusting the turbocharger wastegate and the oil leaking from the engine…NTSB DCA92MA048Accident · 12 fatalMajor investigationFinal reportBeech C-45H · Hinckley, ILInadequate maintenance and inspection by the operator which resulted in an engine power loss during the critical takeoff phase of flight. In addition, the pilot did not, or was unable to, attain a full-feather position on the left engine propeller, which…NTSB SEA92LA196Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cokeville, WYFatigue failure of the crankshaft. Factors include non suitable terrain for a forced landing and an improper propeller.NTSB FTW92LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sallisaw, OKTotal loss of power from a seized oil pump and resulting oil starvation to the engine. Factors were the noncompliance with an engine service bulletin and the dark night condition.