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 NYC07LA086Accident · Minor injuriesLimited investigationFinal reportBellanca 7ECA · Wawayanda, NYA failure of the crankshaft idler gear, which resulted in a total loss of engine power while maneuvering.NTSB MIA07LA055Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Miami, FLThe pilot-in-command's (CFI) continued operation of the airplane with known deficiencies (rough running engine). A factor in the accident was no suitable terrain for a forced landing.NTSB DFW07LA078Accident · Serious injuriesLimited investigationFinal reportCessna T182T · Athens, TXThe loss of engine power as result of the failure of a mechanic to properly check the torque on the input and output fuel lines to the fuel transducer during the manufacturing process. A contributing factor was the lack of suitable terrain for the forced…NTSB DFW07LA076Accident · No injuriesLimited investigationFinal reportAyres S2R-T41 · Turrell, ARThe loss of engine power due to a separated fuel line. A contributing factor was the lack of suitable terrain for the forced landing.NTSB MIA07LA050Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Fountain, FLA loss of engine power due to a cracked engine exhaust muffler. Contributing to the accident were the inadequate inspection procedures of the muffler system and the routing of the "P" leads wiring for the magnetos.NTSB CHI07LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Pellston, MIThe fatigue failure of the engine cylinder which resulted in a complete loss of engine power, and the unsuitable terrain encountered by the pilot during the subsequent forced landing. Contributing to the accident were the night lighting condition, and trees.NTSB DFW07CA065Accident · No injuriesData collectionFinal reportMcDonnell Douglas 600N · Vicksburg, MSThe loss of engine power due to fuel starvation as result of a fuel transfer check valve stuck in the closed position. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ENG07IA009Incident · No injuriesIncident investigationFinal reportMitsubishi MU-2B-36 · Chicago, ILComplete loss of No. 2 engine power due to a partial rim failure of the 2nd stage turbine wheel, resulting in No. 2 engine shutdown and turbine debris exiting the side of the engine. The wheel failure mechanism could not be determined due to missing turbine…NTSB ANC07FA013Accident · 1 fatalField investigationFinal reportCessna 207A · Kenai, AKThe total loss of engine power during cruise flight due to the disintegration of engine bearings and the fracture of a connecting rod, which resulted in a ditching into ice covered ocean water. Factors contributing to the survivability of the accident were…NTSB ANC07LA011Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Albany, GAThe loss of engine power during cruise flight due to a fractured crankshaft, resulting in an off-airport forced landing in a muddy field.NTSB LAX07CA063Accident · No injuriesData collectionFinal reportBelcher Helicycle · Boulder City, NVa loss of engine power due to a fractured fuel line.NTSB LAX07LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Chandler, AZa loss of engine power due to oil starvation to the number 3 cylinder crankpin and connecting rod bearing. The underlying cause of the oil starvation to the number 3 cylinder components could not be ascertained.NTSB CHI07IA042Incident · No injuriesIncident investigationFinal reportBell 407 · Raytown, MOThe loss of engine power during cruise flight due to third stage turbine wheel blade fatigue and subsequent separation, which resulted in an emergency landing.NTSB CHI07LA039Accident · No injuriesLimited investigationFinal reportCessna 140 · Vienna, MOThe loss of engine power during cruise flight due to fatigued crankshaft cluster gear bolts and the inadequate major overhaul of the engine that was last performed by other maintenance personnel. An additional cause was a subsequent major engine overhaul not…NTSB ATL07LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-15 · Conyers, GALoss of engine oil for undetermined reasons resulting in oil starvation, failure of the No. 1 connecting rod resulting in the total loss of engine power.NTSB DFW07LA027Accident · No injuriesLimited investigationFinal reportBell BH 206L-3 · Brownwood, TXThe fracture of the turbine-to-compressor coupling and subsequent overspeed failure of the first stage turbine wheel as result of the improper re-assembly of the engine by maintenance personnel. A contributing factor was the lack of suitable terrain for the…NTSB DFW07LA029Accident · No injuriesLimited investigationFinal reportBeech V35 · Mountain View, ARThe loss of engine power due to oil starvation as a result of a broken oil pressure line. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07LA031Accident · No injuriesLimited investigationFinal reportRyan Navion B · Riverside, CAA leak in the fuel selector valve and gascolator that resulted in fuel starvation on takeoff due to air leakage into the fuel system. A contributing factor in the accident was the inadequate annual inspection performed by other maintenance personnel.NTSB NYC07LA026Accident · 1 fatalLimited investigationFinal reportVogel Glastar 41 · Snow Shoe, PAThe builder's improper installation of an additional alternator. Contributing to the accident were the night lighting conditions.NTSB DFW07FA020Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Danville, ARFailure of the number 5 cylinder which resulted in oil starvation and the subsequent loss of engine power, and the pilot's inability to see the transmission line during the forced landing. Factors Contributing to the accident were the dark night and the…NTSB CHI07IA017Incident · No injuriesIncident investigationFinal reportPiper PA-24-250 · Sherman, ILThe loose connecting rod bolt due to a loss of torque and subsequent failure of the connecting rod during cruise flight.NTSB LAX07LA016Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Prunedale, CATotal loss of engine power due to failure of connecting rod cap during cruise flight for undetermined reasons.NTSB DFW07FA007Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Dry Prong, LAThe loss of engine power during cruise flight due to oil starvation, resulting in an emergency off-airport forced landing. A factor associated with the accident was the instructor's improper in-flight decision in delaying to seek an emergency landing site…NTSB LAX07LA011Accident · Minor injuriesLimited investigationFinal reportMorrisey 2150A · Chandler, AZLoss of engine power during cruise flight due to a crack in the oil cooler and subsequent loss of engine oil.NTSB LAX07LA005Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Upland, CADisconnection of the throttle control linkage due to improper maintenance, which resulted in a loss of engine power during initial climb.NTSB LAX07LA004Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Oakdale, CAA total loss of engine power resulting from lubrication deprivation for undetermined reasons.NTSB NYC07LA001Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hammonton, NJDisplacement of the idler gear assembly, which resulted in a loss of camshaft timing, and a subsequent engine failure. Contributing to the accident was the swampy terrain condition.NTSB ANC06LA144Accident · No injuriesLimited investigationFinal reportCessna TU206A · Juneau, AKThe separation of the number 6 cylinder assembly from the engine during cruise flight, which resulted in a hard forced landing in rough ocean swells. A factor contributing to the accident was the rough ocean swells.NTSB SEA06CA190Accident · No injuriesData collectionFinal reportColtrin RV-6 · Burley, IDA loss of engine power due to the malfunctioning of the carburetor. A factor was the airplane nosing over due to the rough/uneven terrain.NTSB ATL06LA127Accident · No injuriesLimited investigationFinal reportStinson 108 · Holladay, TNA total loss of engine power in cruise flight due to the fatigue failure of the crankshaft gear resulting in a forced landing and subsequent nose over.NTSB LAX06LA273Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Casa Grande, AZInternal damage to the stop electro valve which resulted in fuel starvation and subsequent loss of engine power during takeoff.NTSB SEA06LA167Accident · Minor injuriesLimited investigationFinal reportKinnson Lancair IV-P Turbine · Helena, MTThe total loss of engine power as a result of turbine over temperature due to the pilot's failure to follow proper procedures for engine operation. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB CHI06GA241Accident · No injuriesFinal reportMcDonnell Douglas Helicopters 369E · Columbus, OHThe uncontained engine failure due to the fatigue failure of the gas producer turbine tie bolt.NTSB SEA06LA162Accident · 1 fatalLimited investigationFinal reportKaman HH-43F · Metaline Falls, WAThe failure of the left-hand cross-shaft input internal spline while the helicopter was in a hover, which resulted in the loss of gear box timing, in-flight blade contact and separation, and the subsequent loss of control and impact with a log deck.NTSB ATL06LA121Accident · Minor injuriesLimited investigationFinal reportKirkpatrick Rans S-6 · Roseboro, NCThe pilot's failure to maintain ground clearance while maneuvering for a forced landing following loss of engine power.NTSB DFW06LA198Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Parkdale, ARThe failure of a compressor turbine blade for undetermined reasons, which resulted in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN06LA112Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Harrisburg, NEThe loss of engine power resulting from mechanical failure of a connecting rod for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI06CA237Accident · No injuriesData collectionFinal reportSpittler Rans S-16 · Plattsmouth, NEA loss of engine power due to fuel starvation which resulted from a binding within the fuel servo. A factor associated with the accident was the high vegetation that was encountered during the forced landing.NTSB SEA06TA153Accident · No injuriesFinal reportBell 206L-1 · Busby, MTThe improper overhaul of the turbine assembly by maintenance personnel, which resulted in failure of the turbine and a total loss of engine power. A contributing factor was the pilot's misjudgment of the landing flare at the termination of the autorotation.NTSB CHI06FA210Accident · 6 fatalClass 1 · FieldFinal reportde Havilland DHC-6-100 · Sullivan, MOthe pilot's failure to maintain airspeed following a loss of power in the right engine due to the fracturing of compressor turbine blades for undetermined reasons. Contributing to some parachutists' injuries was the lack of a more effective restraint system…NTSB MIA06LA121Accident · No injuriesLimited investigationFinal reportCessna T210 · Crestview, FLSpinning of the crankshaft No. 2 main bearing for undetermined reasons resulting in damage to the aft cheek of the No. 2 main bearing journal and fatigue failure of the crankshaft.NTSB LAX06LA232Accident · Minor injuriesLimited investigationFinal reportCessna R172K II · HagatnaThe failure of the number four connecting rod during takeoff-initial climb.NTSB NYC06LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Frederick, MDA failure of the masterod, due to a hydraulic lock on a previous flight, which resulted in a total loss of engine power.NTSB SEA06LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Grantsville, UTA lack of lubrication for undetermined reasons, which resulted in the failure of the Nos. 2, 3, 4, 5 and 6 connecting rods, a subsequent total loss of engine power during descent, which resulted in a forced landing. A factor in the accident was the soft sand.NTSB ATL06LA101Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Milledgeville, GAThe improper fabrication of the oil pressure gauge line by maintenance personnel, which resulted in a loss of engine oil and total loss of engine power during cruise flight.NTSB ANC06LA084Accident · No injuriesLimited investigationFinal reportBeech P35 · Gustavus, AKThe fracture of an engine connecting rod during cruise flight, which resulted in a forced landing on a beach, a collapsed nose landing gear, and substantial damage to the fuselage.NTSB ATL06LA093Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Selma, ALThe loss of engine power during the approach to land due to an uncontained turbine failure, which resulted in an in-flight fire.NTSB DFW06LA154Accident · No injuriesLimited investigationFinal reportMcClung Christian Eagle I · Pocahontas, ARThe loss of engine power as a result of a fractured crankshaft due to fatigue. A factor was the engine modifications to increase engine horsepower.NTSB ENG06IA018Incident · No injuriesIncident investigationFinal reportBoeing 767-223(ER) · Los Angeles, CAThe HPT stage 1 disk failed from an intergranular fatigue crack because of GE's inadequate design of the CF6-80 series HPT stage 1 disk. The inadequate design of the disk resulted in a high stress area in the blade slot bottom aft corner that was at or nearly…NTSB DEN06CA081Accident · Minor injuriesData collectionFinal reportGrumman G-164B · Dighton, KSThe broken rocker arm boss causing the number 1 cylinder exhaust valve to stay closed and subsequently the engine failed. A factor contributing to the accident was the soft field the airplane set down in.