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 DEN92LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Glenwood, NMPartial failure of the spark plugs. Factors were inadequate annual inspection and unsuitable mountainous terrain.NTSB CHI92LA051Accident · No injuriesLimited investigationFinal reportLuscombe 8-F · Chapin, IAFailed connecting rod which resulted in a catastrophic engine failure. A factor related to the accident was unsuitable terrain.NTSB CHI92DEV01Accident · Serious injuriesFinal reportQuickie Quickie 1 · Carmi, ILAn engine bearing seizure and a premature forced landing flare.NTSB ATL92FA029Accident · 3 fatalField investigationFinal reportAerospatiale AS350D Astar · Fuquay-Varina, NCThe pilot's improper decision in continuing the flight with a known engine problem, and the subsequent seizure of the number two engine bearing, resulting in engine stoppage. Darkness was a related factor.NTSB DEN92LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Siebert, COTotal loss of engine power due to a plugged vent in the tank filler cap, resulting in fuel starvation. Factors related to the accident were: darkness and the lack of suitable terrain for a forced landing.NTSB DEN92IA013Incident · No injuriesIncident investigationFinal reportCessna T210M · La Veta, COFailure of the no 1 connecting rod due to lack of lubrication from blocked oil ports.NTSB FTW92FA029Accident · Serious injuriesField investigationFinal reportCessna 402B · Roanoke, TXThe operation of the airplane with known deficiencies, a missing air cooling baffle, and inadequate maintenance. Factors were the frozen propeller, inability of the pilot to feather the propeller, inoperative landing gear, the inability of the pilot to…NTSB CHI92LA034Accident · Serious injuriesLimited investigationFinal reportAero Commander 685 · Brainerd, MNAn engine failure due to a seized fuel pump rotor shaft.NTSB DEN92LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Greeley, COA partial loss of engine power on initial takeoff climb due to a bent and loose carburetor heat control mechanism.NTSB SEA92FA019Accident · 2 fatalField investigationFinal reportCessna C-402B · Boise, IDThe loss of power on the right engine during initial climb after takeoff due to inadequate maintenance inspection and adjustment of the engine by company maintenance personnel, and the loss of control by the pilot due to his failure to properly configure the…NTSB LAX92LA042Accident · No injuriesLimited investigationFinal reportBeech D18S · Hilo, HIThe aircraft's lack of single engine performance to maintain altitude after the engine lost power. Factors related to the accident were: displacement/mechanical interference within the accessory drive gear system of the left engine, failure of the left engine…NTSB MIA92IA020Incident · No injuriesIncident investigationFinal reportBoeing 727-31 · Gulf Of MexicoThe overfilling of the forward lavatory during servicing and the failure to replace the fill/rinse line cap after servicing by the ground service personnel which resulted in the lavatory venting fluid through the fill/rinse line during flight and the…NTSB ANC92LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Beluga, AKAn exhaust valve failure. Contributing to the accident was the rough, uneven terrain, and trees.NTSB ATL92LA018Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1D · Brewton, ALA blockage of the fuel vent system which prevented the pilot from topping off the fuel system. A factor in this accident was the inadequate design by the manufacturer of the fuel vent system.NTSB SEA92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Monticello, UTInadequate maintenance/overhaul of the engine, and subsequent failure of the #5 piston (hole burned in piston), due to pre-ignition and/or detonation. Rough/uneven terrain in the emergency landing area was a related factor.NTSB CHI92LA015Accident · No injuriesLimited investigationFinal reportNorth American Navion D · Lake Geneva, WIFatigue failure of the crankshaft. A factor in the accident was inadequate quality control by other maintenance personnel.NTSB ATL92LA010Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Selma, ALThe fatigue failure of the engine crankshaft counterweight blade, which resulted from excessive wear of the counterweight pin bushings, due to corrosion from an unknown source.NTSB ANC92FA005Accident · Minor injuriesField investigationFinal reportPiper PA-18 · Montague Island, AKThe power loss due to the crankshaft failure. Contributing to the accident was improper maintenance during the last engine overhaul.NTSB CHI92LA010Accident · No injuriesLimited investigationFinal reportMooney M20K · Knox, INThe overload failure of the #2 cylinder connecting rod. Contributing to the accident was the night light conditions and the pilot's inability to reach a suitable landing area.NTSB SEA92LA007Accident · Minor injuriesLimited investigationFinal reportPiper PA24-180 · Marysville, WAThe slippage of the accessary drive gear due to improper maintenance by other maintenance personnel. Factors include a forced landing in unsuitable terrain.NTSB FTW92LA008Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31 · Big Spring, TXThe complete loss of engine power due to a failed piston rod. A factor was the lack of suitable terrain for the forced landing.NTSB CHI92LA003Accident · No injuriesLimited investigationFinal reportCessna 150M · Marion, WIThe failure of the exhaust and intake valves. Factors contributing to the accident were downhill terrain and a collapsed nosegear.NTSB ANC92FA002Accident · No injuriesField investigationFinal reportCessna 172M · Bethel, AKA power loss over unsuitable terrain which resulted in a nose over.NTSB ANC92IA001Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Fairbanks, AKIncorrect installation of crankshaft counterwweight rollers by the manufacturer during remanufacture of the engine. Factor was the inadequate surveillance of the engine assembly process by the manufacturer.NTSB LAX91LA410Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Carlos, CAThe failure of the number 3 intake valve resulting in a total loss of engine power. A factor in this accident was the unsuitable terrain for landing the aircraft.NTSB SEA91LA253Accident · No injuriesLimited investigationFinal reportCessna 172N · Chiloquin, ORThe loss of engine power in flight due to improper maintenance inspections. A factor relating to the accident was the rough terrain at the accident site.NTSB CHI91LA298Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Sunset Hills, MOA blocked fuel system line and inadequate maintenance of the airplane by other maintenance personnel.NTSB MIA91LA219Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Sumner, MSFailure of the no. 1 cylinder assembly.NTSB LAX91LA382Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Redwood City, CAThe fatigue failure of the number two connecting rod and rod cap due to an engine overspeed condition which the rods and rod caps were exposed at some undetermined historical point.NTSB ANC91FA142Accident · No injuriesField investigationFinal reportCessna 208 · Dillingham, AKThe pilot's inattentive preflight inspection which resulted in his failure to properly secure the engine oil tube filler cap resulting in the loss of engine oil and oil pressure and the pilot's failure to properly compensate for wind conditions during the…NTSB SEA91LA227Accident · Serious injuriesLimited investigationFinal reportNorth American Navion A · Chehalis, WATotal loss of engine power on initial takeoff climb due to the fatigue fracture of the number one piston connecting rod resulting in a forced landing and in flight collision with trees.NTSB LAX91IA376Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Los Angeles, CAThe fracture of the number 1 high pressure turbine wheel due to fatigue, from an undetermined origin.NTSB ANC91LA134Accident · No injuriesLimited investigationFinal reportCessna T-207A · Coville Lake, AKA total failure of the power output shaft bolts due to fatigue. Contributing to the accident was the rough and uneven terrain.NTSB SEA91LA221Accident · Minor injuriesLimited investigationFinal reportCessna C-210L · Cheyenne, WYMaintenance personnel did not perform a proper top overhaul. This resulted in engine failure due to the failure of a connecting rod bearing. Factors include the hard landing resulting from the premature landing flare by the pilot.NTSB SEA91LA217Accident · Serious injuriesLimited investigationFinal reportBeech B24R · Shady Cove, ORImproper re-installation of an oil line by maintenance personnel, which resulted in an oil leak from a loose line and subsequent seizure of the engine. Uneven terrain in the emergency landing area was a related factor.NTSB SEA91LA212Accident · No injuriesLimited investigationFinal reportCessna U206F · Nimrod, ORThe fractured crankshaft resulting in engine seizure followed by a forced landing on rough and uneven terrain resulting in separation of the nose gear.NTSB ATL91LA162Accident · 1 fatalLimited investigationFinal reportHarold J. Eagen Pitts Special S-1C · Monroe, GAContamination and water existing in the fuel system which resulted in engine stoppage and the pilot's continued flight with a known aircraft deficiency.NTSB LAX91LA358Accident · No injuriesLimited investigationFinal reportBeech J35 · San Jose, CAThe failure of the crankshaft counterweight retaining clip due to improper maintenance installation of the part.NTSB CHI91LA230Accident · No injuriesLimited investigationFinal reportCessna 172 · Metropolis, ILMiscellaneous equipment not removed (foam rubber) and inadequate preflight by the pilot.NTSB ATL91LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Roxobel, NCThe failure of the left magneto stop pin, resulting in the seizure of the magneto and the failure of the magneto drive gear, and ultimately engine stoppage. A factor in this accident was: the presence of trees at the forced landing area.NTSB LAX91LA364Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Wasco, CAA total loss of engine power due to a fracture of the camshaft and the subsequent forced landing into a soft field.NTSB LAX91LA353Accident · No injuriesLimited investigationFinal reportCessna 172B · King City, CAThe total loss of engine power in cruise flight due to the failure of the number 3 cylinder exhaust valve, resulting in a forced landing, and subsequent nose over on landing roll out.NTSB LAX91LA347Accident · No injuriesLimited investigationFinal reportExperimental RV4 · Napa, CAThe installation of a non compatiable oil filter and system plumbing changes which induced the oil exhaustion event resulting in a forced landing and in flight collision with terrain.NTSB NYC91FA199Accident · 3 fatalField investigationFinal reportBeech C23 · Pleasantville, NJA power loss due to a failed crankshaft, while operating over unsuitable terrain. Factors related to the accident were, the night conditions, the failure of maintenance personnel to detect the cracks using magnaflux inspections, the lack of adequate…NTSB DEN91LA108Accident · No injuriesLimited investigationFinal reportCessna 172 · Slaton, TXFailure of the engine's number three piston. A related factor was: collision with a ditch during the landing roll.NTSB NYC91DNC04Accident · Minor injuriesFinal reportLaurent A. Cloutier BD-5B · Gilford, NHEngine failure due to a faulty oil pressure relief valve resulting in an emergency landing on unsuitable terrain.NTSB FTW91LA140Accident · Minor injuriesLimited investigationFinal reportBeech K35 · Laredo, TXThe improper installation of the oil filter adaptor 'o' ring (seal) by other maintenance personnel who distorted it. A factor was the rough, uneven terrain.NTSB FTW91LA141Accident · No injuriesLimited investigationFinal reportCessna 172F · Cumby, TXPower loss due to a blocked fuel vent system. A factor was the lack of suitable terrain for the forced landing.NTSB ANC91LA113Accident · No injuriesLimited investigationFinal reportMooney M-20F · Wood River, AKThe failure of the number 4 cylinder connecting rod cop due to fatigue. Contributing to the accident was the rough surface of the forced landing area.NTSB FTW91LA129Accident · No injuriesLimited investigationFinal reportCessna 150 · Cut And Shoot, TXThe total loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.