NTSB investigations
4,618 cases where the first occurrence was “Loss of engine power”.
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\" = 350) 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" = 350) 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 MIA98LA220Accident · No injuriesLimited investigationFinal reportCessna 188 · Atlantic Ocean (Atlantic Ocean)A complete loss of engine power due to loss of oil pressure, resulting in a force landing on non suitable terrain, and the subsequent sinking of the airplane in deep water.NTSB CHI98LA307Accident · No injuriesLimited investigationFinal reportCessna 150L · Philip, SDthe fuel exhaustion due to the pilot's inadequate preflight inspection. A factor was the soft field.NTSB FTW98LA355Accident · No injuriesLimited investigationFinal reportCrane Quicksilver Sport 2 · Glenn Heights, TXThe loss of engine power as the result of the owner/pilot's failure to install and adjust the proper carburetor jets. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA107Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Dothan, ALFuel Exhaustion due to the pilot's improper fuel consumption calculations. A factor was the power line.NTSB FTW98LA349Accident · No injuriesLimited investigationFinal reportCessna 210M · Albuquerque, NMA power loss for reasons undetermined. A factor was unsuitable terrain on which to make a forced landing.NTSB FTW98LA345Accident · Minor injuriesLimited investigationFinal reportFennell VP2 · Collinsville, OKThe loose throttle control cable resulting in the loss of engine power. A factor was the pilot's decision to intentionally stall the airplane close to the ground during the forced landing to an open field.NTSB CHI98FA300Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Rosemount, MNThe loss of engine power due to water-contaminated fuel and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB CHI98LA301Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · La Moure, NDa loss of engine power due to undetermined reasons.NTSB MIA98LA217Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLA loss of engine power due to undetermined reasons, resulting in an inadvertent stall at too low an altitude to allow recovery.NTSB CHI98LA294Accident · Minor injuriesLimited investigationFinal reportPiper 20 · Andover, KSa loss of engine power for undetermined reasons. A factor associated with the accident were the trees which the airplane contacted and the low altitude at which the loss of power occurred.NTSB NYC98LA159Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1A · Point Of Woods, NYImproper maintenance which resulted in the installation of an incorrect venturi and the subsequent loss of engine power.NTSB MIA98TA215Accident · No injuriesFinal reportHughes TH-55A · Savannah, GAThe loss of engine power for an undetermined reason, resulting in a forced landing, and an in-flight collision with a ditch. A factor in this accident was a high density altitude.NTSB CHI98LA293Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Salina, KSinadequate maintenance which failed to detect corrosion in the fuel injector system and the fuel pump. Factors related to the accident were the low altitude and airspeed at which the loss of engine power occurred.NTSB CHI98LA292Accident · No injuriesLimited investigationFinal reportBell M74L · Grand Forks, NDThe worn rotor clutch shoes, and subsequent loss of main rotor rpm.NTSB CHI98FA286Accident · Minor injuriesField investigationFinal reportMonocoupe 70 · New Holstein, WIThe pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing.NTSB SEA98TA152Accident · Minor injuriesFinal reportCessna TU206G · Burns, ORFatigue failure of the crankshaft.NTSB CHI98LA278Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Bloomington, INA loss of engine power due to a fractured number 5 and number 6 cylinder connecting rods for undetermined reasons.NTSB SEA98LA150Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Columbus, MTPartial loss of power for undetermined reasons. Factors include the pilot's selection of unsuitable terrain for a precautionary landing.NTSB NYC98LA154Accident · No injuriesLimited investigationFinal reportJohnson Revolution MINI-500 · Shermans Dale, PAThe builder/pilot's carburetor modification that did not allow for rapid fuel demand, which resulted in a loss of engine power of final approach.NTSB CHI98LA255Accident · Minor injuriesLimited investigationFinal reportCessna 172N · New Lenox, ILLoss of engine power for undetermined reasons.NTSB LAX98LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Baker, CAA loss of engine power for undetermined reasons.NTSB FTW98LA321Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Bridgeport, TXThe flight instructor's delay in recognizing and responding to the loss of right engine power which resulted in the airplane landing short of the runway. A factor was the loss of right engine power for undetermined reasons.NTSB CHI98LA267Accident · No injuriesLimited investigationFinal reportCessna 150M · Litchfield, ILLoss of engine power due to an open exhaust valve and low cylinder compression. A related factor was the tailwind.NTSB MIA98LA201Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Belzoni, MSThe malfunction in the engine blower section, resulting in oil starvation, the seizure of the engine.NTSB CHI98LA256Accident · No injuriesLimited investigationFinal reportCessna 177 · Cassville, WIan undetermined event which resulted in engine failure on landing roll out during attempted restart fuel ignited and an undetermined event in the airplane's fuel system which resulted in a fire.NTSB IAD98LA079Accident · No injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · West Milford, NJLoss of engine power for undetermined reasons.NTSB ANC98LA098Accident · No injuriesLimited investigationFinal reportCessna 185E · Mcgrath, AKThe loss of engine power for a undetermined reasons. A contributing factor was the trees.NTSB LAX98LA232Accident · No injuriesLimited investigationFinal reportBeech A36TC · Boulder City, NVloss of engine power for undetermined reasons over unsuitable terrain.NTSB CHI98LA250Accident · Minor injuriesLimited investigationFinal reportCanadian Car & Foundry Harvard MK IV · Dyersville, IAthe pilot in command's not maintaining control of the airplane and his inadvertently allowing the airplane to enter a stall. A factor was the undetermined loss of engine power.NTSB SEA98LA133Accident · No injuriesLimited investigationFinal reportBeech 23 · Oakville, WALoss of power due to the failure of an exhaust valve, and overloading of the landing gear. Factors include the failure of maintenance personnel to verify proper compliance with an Airworthiness Directive related to the exhaust valve, and soft terrain.NTSB CHI98LA247Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Nehawka, NEthe pilot's improper fuel management and his improper use of the fuel tank selector. Factors were fuel starvation and crops.NTSB LAX98FA219Accident · Minor injuriesField investigationFinal reportCessna 150 · Apple Valley, CAThe improper installation of unvented fuel caps that resulted in fuel starvation and loss of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB CHI98LA271Accident · Minor injuriesLimited investigationFinal reportVollmers Sonerai II L · Lincoln, NDLoss of engine power due to a corroded ignition wire. Related factors were the tailwind, and ditch.NTSB CHI98LA245Accident · No injuriesLimited investigationFinal reportCessna 188B · Atlanta, NEA loss of engine power due to a loose 'B' nut on the fuel line fitting. Contributing to the accident was the inadequate maintain and the soft terrain.NTSB NYC98LA142Accident · No injuriesLimited investigationFinal reportCessna 180 · Wadsworth, OHA loss of engine power for undetermined reasons.NTSB IAD98LA078Accident · Serious injuriesLimited investigationFinal reportMastopietro Rans S12 · Phillips, MELoss of engine power due to a separated oil line. A related factor was the unsuitable field.NTSB CHI98LA240Accident · No injuriesLimited investigationFinal reportCessna T188C · Austin, MNthe improper maintenance by other maintenance personnel. Factors were the throttle control not safetied, the crops, and unsuitable terrain encountered by the pilotNTSB FTW98LA293Accident · No injuriesLimited investigationFinal reportCessna T188C · Weslaco, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain.NTSB SEA98LA120Accident · No injuriesLimited investigationFinal reportBeech D35 · Driggs, IDExcessive pressure in the fuel control unit. A foreign material/substance found on the fuel system screens was a factor.NTSB ATL98LA091Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Zellwood, FLThe loss of engine power for undetermined reasons which led to a forced landing and nose over. A factor affecting the severity of the damage was the soft terrain.NTSB NYC98LA140Accident · Serious injuriesLimited investigationFinal reportFithian Falcon XP · Mahopac, NYThe failure of the engine crankshaft, which resulted in a loss of engine power, and the pilot's improper decision to conduct flight over terrain unsuitable for the completion of a forced landing.NTSB FTW98LA296Accident · No injuriesLimited investigationFinal reportGrumman G164A · Stratton, COA power loss for reasons undetermined. A factor was the muddy corn field.NTSB CHI98LA236Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Langdon, NDthe total loss of engine power for reasons undetermined. A factor was rough and uneven terrain.NTSB FTW98LA292Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Lubbock, TXThe loss of engine power due to the collapsed of the engine induction air ducting. Factors were the inadequate maintenance inspection and the lack of suitable terrain for the pilot to execute the forced landing.NTSB CHI98LA233Accident · Minor injuriesLimited investigationFinal reportWicks FLY Baby · Blissfield, MIthe pilot's misjudging of the fuel supply and his inadequate aircraft preflight. A factor was fuel exhaustion,NTSB FTW98FA291Accident · 1 fatalField investigationFinal reportCessna 140A · Edgewood, TXThe pilot's failure to maintain minimum required airspeed for flight. Factors were the worn fuel line, which separated, and the failure of the maintenance personnel to locate the worn fuel line during the annual inspection.NTSB CHI98LA227Accident · Minor injuriesLimited investigationFinal reportCommonwealth 185 · Oregon, WIthe improper adjustment of the carburetor by an unqualified person. Factors to the accident were the annual inspection not being complied with and the lack of recent experience of the pilot.NTSB MIA98LA189Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Perry, FLThe improper repair of the no. 2 engine cylinder, which resulted in the loss of engine power.NTSB IAD98LA075Accident · Minor injuriesLimited investigationFinal reportHoffmann Fisher FP 404 · Louisa, VALoss of engine power for undetermined reasons.NTSB IAD98LA073Accident · No injuriesLimited investigationFinal reportSaab-Scania F-35 Draken · Oceana, VAThe pilot-in-command's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. A related factor was the pilot's unfamiliarity with the fuel system.