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 CHI92DEE04Accident · No injuriesFinal reportWeatherly 201B · Chana, ILFracture of a connecting rod resulting in loss of engine power.NTSB DEN92LA090Accident · No injuriesLimited investigationFinal reportCessna A188 · Burlington, COFractured connecting rod. A factor was: the lack of suitable terrain for the forced landing.NTSB CHI92LA263Accident · No injuriesLimited investigationFinal reportCessna 402B · Almont, MIExcessive fuel system pump pressure and corresponding excessive fuel pressure and the pilot not maintaining the best single engine climb speed.NTSB LAX92LA368Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Temecula, CAThe shutdown of the engine due to the failure of the muffler and the resulting heat induced shorting of the magneto ground wires, and the inadequate maintenance inspection of the muffler and the engine exhaust system.NTSB ANC92LA142Accident · No injuriesLimited investigationFinal reportCessna 140 · Wasilla, AKThe partial loss of engine power due to the separation of the right hand exhaust stack. Contributing to the accident was the unsuitable terrain on which the forced landing was made.NTSB FTW92DPG14Accident · No injuriesFinal reportAir Tractor AT-300 · Wilmont, ARPower loss due to a failed cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB CHI92DCJ05Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Atkinson, NEA cracked engine cylinder.NTSB ATL92LA154Accident · Minor injuriesLimited investigationFinal reportWeatherly 620A · Cobb, GAThe corroded, and separated, magnetic chip detector plug which allowed the loss of all engine oil and the engine's subsequent seizure. Factors were the inadequate 100 hour inspection, and the high vegetation in the forced landing field.NTSB CHI92LA227Accident · No injuriesLimited investigationFinal reportCessna 152 · Xenia, ILImproper engine overhaul and noncompliance with an airworthiness directive by other maintenance personnel.NTSB DEN92LA080Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Karval, COAn engine failure due to improper maintenance installation. A factor was: lack of suitable terrain for the forced landing.NTSB ATL92FA152Accident · 1 fatalField investigationFinal reportPiper PA-24-400 · Dovesville, SCThe loss of engine power which resulted from an undetermined malfunction of the ignition system. A factor was fog.NTSB LAX92LA327Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Glendale, AZA loss of engine power due to excessive carbon deposits on the number one cylinder exhaust valve, and, the pilots attempted operation of the aircraft with known mechanical deficiencies.NTSB FTW92FA197Accident · 1 fatalField investigationFinal reportBoeing A75 · Cibolo, TXFailure of the engine crankshaft due fatigue and the resultant collapsing of the left wing.NTSB BFO92LA119Accident · No injuriesLimited investigationFinal reportCessna 150F · Norfolk, MAThe loss of compression in the no. 4 cylinder due to a valve stuck in the open position, which resulted in the loss of engine power.NTSB CHI92LA216Accident · No injuriesLimited investigationFinal reportCessna 150H · Bowlus, MNThe fracture of the number four cylinder's connecting rod cap.NTSB CHI92FA215Accident · 2 fatalField investigationFinal reportCessna P210N · Mineral Point, WIThe pilot's inadvertent stall and descent into terrain during a forced landing. Related factors are the manufacturer's undertorqued crankcase halves and inadequate surveillance, the pilot's delay in setting up the proper descent rate, and the altered aircraft…NTSB ANC92LA113Accident · No injuriesLimited investigationFinal reportCessna 175 · Wasilla, AKFailure of the engine crankshaft due to an oil passage hole being blocked. Contributing to the accident was the unsuitable terrain.NTSB FTW92DPG10Accident · No injuriesFinal reportRockwell S2R-R3S · Minturn, ARThe loss of engine power and the encounter with unsuitable terrain during the forced landing.NTSB ATL92LA143Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Eufaula, ALThe failure of the fuel injector servo as a result of the sticking bushing between the diaphragms.NTSB LAX92LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Las Vegas, NVThe failure of the maintenance personnel to safety the engine oil drain plug and the poor engine overhaul. Factors relating to this accident are: oil starvation; the failure of the connecting rods; the incorrect connecting rod bolts; and the connecting rod…NTSB LAX92LA310Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Sierraville, CAThe pilot's inadequate preflight of the aircraft. The contaminated fuel system and the rough terrain were factors in the accident.NTSB CHI92DEM04Accident · Serious injuriesFinal reportHauser, William C. Cassutt · Winn, MIThe ditch the airplane encountered during the landing roll phase of a forced landing.NTSB ATL92LA141Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Americus, GAA loss of engine power due to a crack in the number three cylinder. A factor was the soft terrain at the forced landing area.NTSB FTW92LA181Accident · No injuriesLimited investigationFinal reportCessna 120 · Reserve, LAThe loss of engine power due to the valve failure. A factor was the lack of suitable terrain for the forced landing.NTSB LAX92LA303Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Simi Valley, CAThe company's maintenace personnel improper adjustment of the aircraft's idle RPM and the failure of the instructor pilot to maintain adequate rotor RPM after the engine failed. The instructor pilot's lack of total experience in type of operation is a factor…NTSB SEA92IA150Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYFailure of the fuel control unit on the left engine.NTSB CHI92DCJ04Accident · No injuriesFinal reportCallair A-9 · Beaver City, NEThe inadequate maintenance overhaul of the left magneto, and subsequent failure of the left magneto/ignition system which caused a complete loss of engine power.NTSB LAX92FA289Accident · 1 fatalField investigationFinal reportCessna T210N · Superior, AZAn inadequate major engine overhaul procedure, during which previous crankshaft damage was not detected. Contributing to the accident was a surface initiated fatigue failure of the engine crankshaft.NTSB FTW92DPG08Accident · No injuriesFinal reportGrumman G-164A · Grady, ARLoss of engine power due to a failed cylinder. A factor was the unsuitable terrain.NTSB FTW92DPG07Accident · No injuriesFinal reportAyres S2R · Grady, ARThe loss of engine power due to the separation of the number one engine cylinder. A factor was the unsuitable terrain.NTSB CHI92DCG03Accident · Minor injuriesFinal reportDaniel M. Dent BD-5 B · Ft. Levenworth, KSA complete loss of engine power following an electrical short to ground in the aircraft's 'ignition kill' electric circuit.NTSB FTW92DPG05Accident · Minor injuriesFinal reportAir Tractor AT-301 · Cotton Plant, ARThe loss of engine power. A factor was the unsuitable terrain.NTSB CHI92DEM03Accident · Minor injuriesFinal reportJohansen Kitfox · Gowen, MIA total failure of the ignition system spark plugs and unsuitable terrain encountered by the pilot.NTSB FTW92DPG06Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARLoss of engine power. A factor was the lack of suitable terrain for forced landing.NTSB CHI92DCD07Accident · Serious injuriesFinal reportBernard W. Resnik ACRO-SPECIAL · Earlham, IAA loss of total engine power when a failed flapper valve in the air box blocked the flow of air through the carburetor throat.NTSB LAX92LA273Accident · No injuriesLimited investigationFinal reportCessna U206E · Mayer, AZThe failure of the engine due to the slippage of the number 2 main bearing and the resultant oil starvation failure of the number 2 connecting rod. The number 2 main bearing slippage was caused by the failure of the pilot/owner to overhaul the engine in a…NTSB BFO92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Greenville, VAThe fatigue failure of the fuel injector fuel line resulting in engine failure. Contributing to the accident was the unsuitable terrain in which the forced landing was made.NTSB MIA92LA144Accident · 1 fatalLimited investigationFinal reportDofka, Martin F. KR-2 · Homestead, FLInadvertent stall by the pilot while attempting to return to the airport following loss of engine power. Contributing to the accident was the loss of power due to a sticking exhaust valve, and failure of the pilot to assure all ignition leads were connected…NTSB NYC92IA129Incident · No injuriesIncident investigationFinal reportBoeing 767-231ER · Jamica, NYThe failure of the fifth stage low pressure turbine vanes due to fatigue.NTSB SEA92LA138Accident · Minor injuriesLimited investigationFinal reportNavion H · Gillette, WYAn engine power loss due to the collapse of the induction air ducting, inadequate maintenance, and improper approval of the modification.NTSB CHI92FA188Accident · Minor injuriesField investigationFinal reportBeech 24R · Oak Creek, WIA result of inadequate aircraft maintenance inspection on behalf of the company maintenance personnel.NTSB CHI92DCG04Accident · No injuriesFinal reportDennis L. Fetters Mini 500 · Missouri City, MOAn improper connecting rod assembly resulting in mechanical binding between the rod and the engine crankshaft.NTSB LAX92LA258Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Georgetown, CAThe under torque of the crankcase through bolts during overhaul causing; 1) the number 2 main bearing to spin, 2) the resultant blockage of the internal oil passage, and 3) the oil starvation induced failure of the number 2 connecting rod and cap. A factor in…NTSB NYC92DGM02Accident · No injuriesFinal reportPeres 5151 · Erie, PASeizure of the #2 piston which resulted in the lost of engine power and subsequent collision with trees during a forced landing.NTSB ANC92LA095Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKEngine failure due to total oil loss. Contributing to the accident were the separation of the oil filter adapter from the oil pump due to improper maintenance procedures and non adherence to recommended directives by company maintenance personnel, and the…NTSB FTW92LA164Accident · No injuriesLimited investigationFinal reportCessna 320D · Aztec, NMFailure of the right propeller to feather and inoperative gear retraction system. Factors were the high density altitude and the power loss due to connecting rod failure.NTSB LAX92LA244Accident · No injuriesLimited investigationFinal reportCessna 172 · Blythe, CAThe improper engine overhaul performed by the mechanic. Factors relating to this accident were the intake and exhaust valve leaks and the soft terrain.NTSB NYC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Denton, MDThe failure of the pilot to detect the automobile gasoline in the tanks prior to departure, and intentional refueling with improper fuel by the pilot's brother which resulted in a lose of engine power due to detonation and loss of oil pressure.NTSB SEA92LA121Accident · No injuriesLimited investigationFinal reportMooney M20E · Freeland, WABlockage of the fuel injector servo system. Factors contributing to the accident were: fuel injection system corroded and animals in the landing area.NTSB LAX92LA237Accident · Minor injuriesLimited investigationFinal reportBell 222 · Mariposa, CAThe pilot decision to takeoff and fly with a known deficiency in one of the helicopter's engines.