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 MIA06IA110Incident · No injuriesIncident investigationFinal reportCessna 172S · St. Augustine, FLThe loss of engine power due to separation of the crankshaft as a result of lack of adequate oil lubrication to the #2 main bearing. The lack of oil lubrication was most likely the result of improper assembly (fitting) of the bearing shells to the crankshaft.NTSB ATL06LA077Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Hemmingway, SCA loss of engine power due to a total failure of the No.3 engine cylinder exhaust valve as a result of fatigue from over temperature resulting in a forced landing and collision with trees and the ground.NTSB NYC06LA106Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Kings Park, NYLoss of engine power due to the failure of the number 3 connecting rod bearing. A contributing factor was the lack of suitable terrain for the emrgency landing.NTSB SEA06CA080Accident · No injuriesData collectionFinal reportPitrolo GL-25 · Worden, MTThe loss of engine power due to failure of both electronic ignition systems. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06LA074Accident · No injuriesLimited investigationFinal reportCentral Copters Lancair IV-P · Belgrade, MTThe total loss of drive power to the aircraft's propeller while on a visual final approach, due to the decoupling of the quill shaft between the reduction gearbox and the engine power section. Factors include a dark night, no suitable terrain on which to…NTSB DEN06LA062Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hope, NMA loss of engine power due to failed bearings in the turbocharger and the subsequent oil seal failure leading to oil exhaustion. Factors contributing to the accident were the fractured oil seal and the road sign.NTSB ATL06LA061Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Folkston, GAThe total loss of engine power due to the failure of the compressor turbine blades due to high temperature exposure.NTSB DCA06FA033Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC10 · Memphis, TNThe rupture of a fatigue crack in the forward air seal tooth serration of the No. 3 engine low pressure turbine stage 1 disk that initiated due to an improper weld repair performed during original manufacture. The improper weld repair changed the material…NTSB MIA06LA067Accident · No injuriesLimited investigationFinal reportCirrus SR20 · Orlando, FLCatastrophic engine failure due to a low oil level brought about by excessive blow-by and cylinder detonation. Contributing factors in this accident were the inadequate instructions contained in Service Bulletin M89-9 and the ditch.NTSB MIA06LA066Accident · Minor injuriesLimited investigationFinal reportLoehle P5151 · Lakeland, FLThe pilot's delay in initiating landing flare during a forced landing following a total loss of engine power. A factor was the lack of correct venting of the carburetor float bowl.NTSB LAX06FA129Accident · 2 fatalField investigationFinal reportBeech A36 · Santa Monica, CAThe failure of an aviation maintenance technician to properly torque and cotter pin the number 2 connecting rod bolts at their attach point to the crankshaft, which resulted in the separation of the connecting rod in flight, and complete power loss.NTSB MIA06LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, FLA loss of engine power due to an oil line leak and oil exhaustion. A contributing factor was the unsuitable terrain on which to make a forced landing.NTSB ATL06LA050Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Jesup, GAThe loss of engine power due to the fatigue failure of the crankshaft, which resulted in a forced landing, and an in-flight collision with trees. A factor associated with the accident was the failure of other maintenance personnel to comply with the engine…NTSB ATL06LA049Accident · No injuriesLimited investigationFinal reportErcoupe E · Wetumpka, ALThe failure of the No. 2 exhaust, and intake valves for undetermined reasons, which resulted in a loss of engine power during cruise flight and damage to the airplane during the subsequent forced landing.NTSB DEN06LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Torreon, NMThe jammed magneto drive gear and the fractured camshaft gear, which resulted in the total engine failure. A factor contributing to the accident was the unsuitable dirt road on which the pilot had to force land the airplane.NTSB LAX06LA103Accident · No injuriesLimited investigationFinal reportHarwood Kenneth Lancair 360A · Thermal, CAA loss of engine power caused by the separation of the number three cylinder due to the improper torque on the hold down nuts.NTSB LAX06LA098Accident · No injuriesLimited investigationFinal reportEurocopter AS350D · Kahului, HIA total loss of engine power due to the internal effects on the bearings consistent with an operating event of insufficient oil supply. Contributing to the accident was the pilot’s improper flare during the autorotative descent.NTSB LAX06LA094Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Mariposa, CAThe failure of the maintenance personnel to follow the procedures in the TCM maintenance manual and adequately torque the engine through-bolts, which led to the separation of the No. 6 cylinder and the catastrophic failure of the engine.NTSB LAX06CA090Accident · Serious injuriesData collectionFinal reportQuicksilver MX II Sprint · Bouse, AZLoss of engine power after takeoff due to engine overheating and piston seizure.NTSB LAX06LA072Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350BA · Hana, HIThe total loss of engine power due to a fatigue failure of a turbine blade. A factor in the accident was the lack of a suitable forced landing site.NTSB DFW06CA050Accident · No injuriesData collectionFinal reportCessna T210 · Midland, TXThe loss of engine power due to a connecting rod failure. Contributing factors were the dark night conditions and the lack of suitable terrain for the forced landing.NTSB ATL06LA028Accident · Serious injuriesLimited investigationFinal reportCessna 177-RG · Locust Grove, GAThe total loss of engine power due to failure of the No.1 connecting rod bearing and separation of the No. 1 connecting rod.NTSB LAX06LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAThe failure of the camshaft due to fatigue of one of the gear teeth, which resulted in a loss of engine power. Factors were the fence and the fence post.NTSB NYC06LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Lincoln Park, NJThe improper installation of the helicoil by the non-certificated mechanic, and the inadequate inspection of the installation by the certificated mechanic.NTSB MIA06FA024Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Mims, FLThe loss of engine power due to improper installation of the #2 cylinder by maintenance personnel, which resulted in the separation of the cylinder as a result of fatigue cracking of the cylinder to crankcase fasteners. A contributing factor was the lack of…NTSB LAX06LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Tucson, AZthe separation of the mixture cable at the carburetor control arm, which resulted in a loss of power, and maintenance personnel's inadequate inspection of the airplane during the last annual inspection.NTSB NYC06FA027Accident · Serious injuriesField investigationFinal reportEmbraer 110P1 · Manchester, NHThe pilot’s misapplication of flight controls following an engine failure. Contributing to the accident was the failure of the sun gear, which resulted in the loss of engine power. Contributing to the sun gear failure were the engine manufacturer’s…NTSB DFW06LA027Accident · 1 fatalLimited investigationFinal reportArrow Falcon Exporters Arrow F OH-58A · West Memphis, ARThe loss of engine power due to a disconnected pneumatic (Pc) line. A contributing factor was the ravine.NTSB DFW06CA020Accident · Minor injuriesData collectionFinal reportDeussen Alexander II Rotorway Exec · Gibson, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC06LA024Accident · Minor injuriesLimited investigationFinal reportLo-N-Slo Airsports Maxair Drifter XP-50 · Cobbs Creek, VAFailure of the ignition system, which resulted in a loss of engine power.NTSB CHI06LA021Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Portland, INThe pilot's decision to operate the helicopter with a known engine deficiency, the loss of engine power due to the connecting rod failure, and the pilot's failure to maintain directional control during landing. A factor to the accident was the corn crop and…NTSB NYC06FA015Accident · 1 fatalField investigationFinal reportCessna 411 · East Hampton, NYThe pilot's failure to maintain airspeed, while maneuvering with the left engine inoperative. Contributing to the accident were the failure of the left engine, and the pilot's lack of multiengine certification.NTSB ANC06LA005Accident · No injuriesLimited investigationFinal reportCrisenbery Northman 2+2 · Nenana, AKA loss of engine power during cruise flight due to a cracked oil filter housing and subsequent loss of engine oil, which resulted in a forced landing in trees.NTSB ENG06IA001Incident · No injuriesIncident investigationFinal reportCessna Citation 650 · Madison, WIThe inadequate design of the engine's interstage transition duct that yielded after the LPT stage 3 blades had separated and allowed the uncontained release of turbine debris. A contributing factor was the separation of a turbine blade.NTSB MIA05LA164Accident · No injuriesLimited investigationFinal reportNorth American T-28C · Arcadia, FLA loss of engine power due to the failure of the master rod bearing.NTSB IAD05LA144Accident · Serious injuriesLimited investigationFinal reportHoward Whyte Nieuport 28 · Dayton, OHA loss of engine power due to the installation of incorrect spring type terminal contacts which were accidentally supplied by the engine distributor.NTSB LAX05LA319Accident · Minor injuriesLimited investigationFinal reportRose Kitfox · Hesperia, CAa loss of engine power due to a loose master ignition relay wire.NTSB DEN05LA143Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Torrington, WYfailure of the #7 connecting rod, causing engine seizure. A contributing factor was the berm.NTSB DFW05CA238Accident · No injuriesData collectionFinal reportCessna A188B · Paris, TXThe loss of engine power due the failure of a connecting rod. A contributing factor was the lack of suitable terrain for the forced landing.NTSB IAD05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Babylon, NYA broken piston and exhaust valve tappet which resulted in a total loss of engine power, and a forced landing to unsuitable terrain. A contributing factor was the failure of the operator to overhaul the engine at the manufacturer's recommended interval.NTSB SEA05LA189Accident · No injuriesLimited investigationFinal reportBallhagen/Shyrock Q-2 · Kalispell, MTThe pilot/owner's improper setting of the engine's valve clearance, leading to the failure of the exhaust valves to fully close and a total loss of power while on a VFR downwind, and the pilot/owner's failure to maintain sufficient airspeed as he tried to…NTSB NYC05LA139Accident · No injuriesLimited investigationFinal reportTerrio Pober Jr Ace · Oxford, CTA fractured oil pressure line, which resulted in the fracture of the number 3 cylinder connecting rod bearing, and subsequent loss of engine power.NTSB NYC05LA137Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-D · Sandy Lake, PAA total failure of the engine driven fuel pump, and the pilot's failure to recognize a diminishing fuel supply in the fuselage (header) fuel tank, which resulted in a total loss of engine power during cruise flight and subsequent collision with trees during a…NTSB LAX05LA273Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Palos Verdes, CAa loss of engine power due to the cyclic fatigue failure and separation of the number 4 piston.NTSB DFW05IA222Incident · No injuriesIncident investigationFinal reportAir Tractor AT-401 · Winnie, TXThe loss of engine power due to the failure of the second-stage turbine wheel as a result of low cycle fatigue.NTSB LAX05FA264Accident · 1 fatalField investigationFinal reportSan Joaquin Helicopters OH-58A+ · Lancaster, CAThe pinion to turbine shaft coupling failed in fatigue due to a misaligned turbine shaft, which resulted in a loss of engine power.NTSB CHI05LA226Accident · 2 fatalLimited investigationFinal reportPiper PA-28-161 · Culver, INThe loss of engine power while maneuvering due to partial failure of the left magneto, and the flight instructor's failure to maintain sufficient airspeed to avoid a stall. An additional cause was improper maintenance by company maintenance personnel,…NTSB NYC05LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Felton, DEThe mechanic's inadequate annual inspection, and failure to comply with an airworthiness directive, which resulted in a total failure of the second stage turbine rotor.NTSB SEA05LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Sunriver, ORThe loss of engine power as a result of both sets of magneto points failing to open due to excessive wear of the nylon cam followers. The excessive wear of the cam followers was due to maintenance personnel's failure to follow the magneto manufacturer's…NTSB ANC05LA107Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350BA · Juneau, AKA loss of engine power during takeoff initial climb due to the separation of the engine power turbine shaft, the failure of which was due to a disconnected adjacent leaf spring, which resulted in an emergency landing after takeoff and subsequent hard landing.