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 FTW99LA128Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Conroe, TXThe loss of engine power due to fuel starvation as a result of a blocked fuel vent. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA143Accident · No injuriesLimited investigationFinal reportNarzinski Avid Flyer Mark IV · West Alton, MOThe failure of the connecting rod bearing, and the rough/uneven terrain condition.NTSB ANC99LA052Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Juneau, AKThe failure of the engine driven fuel pump for undetermined reasons. Factors associated with this accident were the low altitude at which the failure occurred resulting in task overload of the pilot, and landing the amphibious airplane in the swampy terrain…NTSB LAX99LA157Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAA loss of engine power due to a leaking surge bleed valve which induced compressor stalls within the engine.NTSB LAX99LA155Accident · No injuriesLimited investigationFinal reportCessna 150H · Yuba City, CAA total loss of engine power resulting from the fatigue failure of a cylinder's exhaust valve. A contributing factor was the uneven terrain at the forced landing site. The reason for the fatigue could not be determined.NTSB LAX99LA153Accident · Serious injuriesLimited investigationFinal reportVentura Rans S-12 · El Cajon, CAEngine power loss due to an interruption of fuel to or within a carburetor, and the resultant overheating of its associated cylinder. The reason for the fuel flow interruption could not be determined.NTSB LAX99LA165Accident · No injuriesLimited investigationFinal reportParker Vans RV-4 · Red Bluff, CAA crack which developed in the automotive-type oil cooler of the experimental, amateur built aircraft and permitted the engine oil supply to flow overboard.NTSB FTW99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Turrell, ARThe total loss of engine power as the result of improper maintenance which led to the number one cylinder intake valve rocker assembly stud bolt backing out rendering the valve inoperative. A factor was the lack of suitable terrain for the forced landing.NTSB CHI99LA122Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Vienna, ILThe worn ignition points/cam follower assembly, and uneven landing terrain.NTSB LAX99LA140Accident · Minor injuriesLimited investigationFinal reportCessna 210D · El Monte, CAA loss of engine power due to the fatigue failure of the mixture control cable, which was due to the improper installation and adjustment of the cable 99 hours prior to the accident.NTSB ANC99LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe loss of engine power due to the failure of maintenance personnel to properly torque a connecting rod bolt during an engine overhaul, and the subsequent disconnection of the connecting rod bolt and connecting rod.NTSB LAX99LA134Accident · No injuriesLimited investigationFinal reportCessna 172RG · Moorpark, CAThe failure and separation of the number two cylinder for undetermined reasons. A factor was the soft terrain at the forced landing site.NTSB NYC99LA081Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pottstown, PAThe failure of maintenance personnel to properly inspect and torque the crankcase bolts.NTSB NYC99FA078Accident · 1 fatalField investigationFinal reportDeleeuw Sprint 1000 · Lakewood, NJThe pilot's loss of control, which resulted in an unintentional stall/spin after an engine failure. A factor in the accident was the engine failure, which occurred when the magneto piston seized within the cylinder sleeve during an overtemp event.NTSB ATL99LA055Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Bay Springs, MSThe fuel control drive bearing failure at the intermediate gear resulted in fuel starvation and the subsequent loss of engine power.NTSB NYC99FA074Accident · 2 fatalField investigationFinal reportCessna 340A · Chesapeake, VAThe pilot's failure to maintain control of the airplane during a single engine emergency landing, after experiencing a failure of the left engine. A factor in this accident was the failure of the left engine's camshaft due to a fatigue crack.NTSB DEN99LA056Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Evanston, WYA total loss of engine power for undetermined reasons.NTSB FTW99LA088Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Denton, TXThe total loss of engine power on takeoff resulting from the failure of an incorrect throttle control cable clamp, which was installed by an unknown person. A factor was the lack of suitable terrain for the forced landing.NTSB LAX99LA113Accident · 1 fatalLimited investigationFinal reportCessna P210N · Pacific Ocean (Pacific Ocean)A loss of engine oil pressure and ensuing loss of engine power for undetermined reasons.NTSB LAX99LA111Accident · Minor injuriesLimited investigationFinal reportCooper Vans RV-6 · Vacaville, CAThe failure of the engine assembler to apply the proper torque on the connecting rods bolts, which led to fatigue cracking and ultimately fracture of the rod bolts.NTSB CHI99IA096Incident · No injuriesIncident investigationFinal reportCessna T210R · Tinley Park, ILthe improper installation of the pressure oil line 'B' nut by maintenance personnel. Contributing to the incident were the loose pressure oil line 'B' nut and separation of the propeller from the aircraft.NTSB LAX99LA103Accident · No injuriesLimited investigationFinal reportZivko Aeronautics Edge 540 · Livermore, CAThe manufacturer's inadequate quality control procedures, which allowed an improperly manufactured crankshaft to be shipped, resulting in the separation of one counterweight from the crankshaft lug and the subsequent catastrophic internal failure of the…NTSB DEN99LA040Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Baggs, WYA hard landing resulting from rotor rpm decay. Factors were the improper replacement of the turbine by company maintenance personnel resulting in the PC line nut becoming loose, and the pilot operating outside the normal height/velocity curve.NTSB MIA99LA081Accident · Minor injuriesLimited investigationFinal reportCessna 210G · Lake Placid, FLa total loss of engine power due to an in-flight separation of the crankshaft, caused by a fatigue crack that originated from the aft fillet radius of the No. 2 main journal, resulting in a forced landing in a field and impact with a tree.NTSB DEN99IA038Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE 146-200A · Aspen, COThe inadequate maintenance overhaul of the number four turbine disc by the manufacturer. A factor was the turbine blade's failure due to high cycle fatigue fracture.NTSB MIA99LA079Accident · Minor injuriesLimited investigationFinal reportWolf Seawind 3000 · Bradenton, FLTotal loss of engine power due to a burned piston for undetermined reasons resulting in a forced landing to unsuitable terrain and the subsequent crash landing onto a golf course.NTSB LAX99GA083Accident · Serious injuriesFinal reportMcDonnell Douglas 369E · Lake Elsinore, CAThe pilot's failure to maintain main rotor rpm and her misjudged flare. Also causal was the failure of the company maintenance personnel to follow the procedures/directives in the engine manufacturer's operation and maintenance manual and their improper…NTSB MIA99LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Charleston, SCthe total loss of engine power caused by an oil leak at the oil filter adapter, resulting in a broken connecting rod, a subsequent forced landing and impact with rough terrain.NTSB LAX99LA081Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Lemoore, CAThe inadequate nature of the operator's maintenance, which failed to detect the primer and magneto discrepancies. An overly lean fuel mixture and/or magneto cross firing resulted in detonation, an ensuing connecting rod failure, and a total loss of engine…NTSB LAX99LA075Accident · No injuriesLimited investigationFinal reportHanson Hanson Tailwind W-8 · Chula Vista, CAThe loss of lubrication to the number 3 rod bearing and the resulting failure of the number 3 connecting rod. A contributing factor to the accident was the soft terrain at the accident location.NTSB LAX99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Santa Barbara, CAA loss of engine power due to an internal left magneto coil primary circuit short. Factors were insufficient altitude and inadequate terrain to make an emergency landing.NTSB IAD99FA025Accident · 1 fatalField investigationFinal reportLake LA-4-250 · Laconia, NHA loss of engine power during initial climb due to oil starvation. Contributing to the accident was the failure to perform an engine overhaul.NTSB LAX99TA066Accident · Serious injuriesFinal reportBell 205A-1 · Van Nuys, CAA loss of engine power due to an undetermined component failure in the second stage power turbine nozzle area. Factors in the accident were the mountainous/hilly nature of the terrain and the dark night lighting conditions which precluded the pilot from…NTSB LAX99LA065Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Delano, CAThe fatigue failure and separation of the oil pump drive from the accessory gear section, which induced an oil starvation failure of the engine. The fatigue failure of the oil pump drive gear was caused by improper machining of the gear's fillet radius during…NTSB LAX99FA057Accident · 1 fatalField investigationFinal reportBell UH-1H · Quincy, CAAn inaccurate exhaust gas temperature gauge, that allowed the engine to be run over-temperature unknowingly by the pilot, which resulted in the subsequent failure of the turbine sections. Also causal was the pilot's failure to maintain rotor RPM during the…NTSB FTW99LA052Accident · No injuriesLimited investigationFinal reportCessna 182 · Umpire, ARCatastrophic engine failure due to failures of the #5 piston, #5 connecting rod, and the camshaft. A factor was the lack of suitable terrain for a forced landing.NTSB ATL99LA023Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Locust Grove, GALoss of engine power due to a gear train failure in the accessory gearbox for undetermined reasons. A factor was the rough and uneven terrain.NTSB LAX99LA054Accident · No injuriesLimited investigationFinal reportWilliams Hurrican HP · Corona, CAThe seizure of the engine due to a cylinder/piston overheat condition for undetermined reasons.NTSB FTW99LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA32-300 · New Iberia, LAThe mechanic's failure to properly torque the connecting rod's bolt and nut during engine overhaul. A factor was the lack of suitable terrain for the forced landing.NTSB MIA99LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe loss of engine power due to a connecting rod failure for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.NTSB LAX99LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Gila Bend, AZThe crankshaft gear attach bolt loosening and backing out of its crankshaft bore, which led to the fatigue failure of the crankshaft gear dowel pin due to excessive working of the gear. The sequence of failures was the result of the engine overhaul shop's…NTSB IAD99LA015Accident · Minor injuriesLimited investigationFinal reportBell 206-B · Louisville, KYA loose 'B' nut on the aircraft's PC Air line which resulted in fuel starvation, and the pilot's abrupt application of aft cyclic to prevent a nose over. Contributing factors were soft terrain and dark night conditions.NTSB ATL99LA017Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G164B · Cuthbert, GAThe fatigue failure of the accessory gear shaft which resulted in fuel starvation and the loss of engine power. A factors was the fuel system filter restriction.NTSB FTW99LA023Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33 · Tulsa, OKThe loss of engine power due to detonation for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB IAD99GA013Accident · 1 fatalFinal reportSchweizer 269C · Baltimore, MDinadequate assembly instructions from the engine manufacturer which resulted in improper engine assembly, and subsequent power loss over unsuitable terrain, with insufficient altitude for a successful autorotation.NTSB MIA99LA025Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Hartselle, ALImproper modification of the carburetor float by maintenance personnel resulting in the float sticking in the full needle valve open position and failure of the engine due to excessive fuel flow.NTSB MIA99LA019Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Douglasville, GAFailure of the no. 1 cylinder exhaust valve guide due to erosion, which resulted in separation of the exhaust valve head, loss of engine power, and collision with a power pole during a forced landing on unsuitable terrain.NTSB MIA99LA017Accident · No injuriesLimited investigationFinal reportReinhold Revolution Mini 500 · Hickory, NCThe seizure of the rear piston in the cylinder barrel resulting in total loss of engine power and an autorotation which resulted in main rotor contact with the tail boom while touching down on unsuitable terrain.NTSB ATL99LA006Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Fayette, MSThe fuel filter contamination which resulted in the loss of engine power. The air leak in the fuel system was a factor.NTSB ATL99LA005Accident · No injuriesLimited investigationFinal reportCessna 188 · Patrick, SCThe failure of the number 2 piston for undetermined reasons.