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 SEA93LA085Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Walla Walla, WAA loss of engine power for undetermined reasons. The lack of a suitable landing area was a factor.NTSB SEA93LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Laurel, MTThe loss of engine power, undetermined.NTSB FTW93LA111Accident · No injuriesLimited investigationFinal reportCessna 182 · Washington, OKLoss of engine power for undetermined reason(s).NTSB BFO93LA052Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · New Gloucester, MELoss of engine power during takeoff due to undetermined reasons, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB ANC93LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12-150 · Anchorage, AKThe complete loss of engine power due to undetermined reasons. Factor was the deep water forced landing area.NTSB SEA93LA076Accident · No injuriesLimited investigationFinal reportBarr Kitfox II · Sheridan, WYA partial power loss for undetermined reasons. Factors include a strong crosswind on landing.NTSB MIA93LA084Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Village Of Golf, FLThe pilot-in-command's improper movement of the fuel selector valve resulting in fuel starvation, forced landing, and an in-flight collision with terrain.NTSB LAX93LA139Accident · No injuriesLimited investigationFinal reportAcro Sport Acro Sport · Lake Riverside, CAThat the pilot misjudged the landing/flare altitude. Contributing to this accident was the loss of power for undetermined reasons.NTSB BFO93LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Petersburg, OHLoss of engine power due to undetermined reasons. A factor related to the accident was the short, soft, hilly terrain condition in the emergency landing area.NTSB BFO93LA035Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Xenia, OHLoss of partial power for undetermined reasons.NTSB LAX93LA135Accident · Serious injuriesLimited investigationFinal reportDowner Aircraft Industries KR-1 · Prescott, AZThe total loss of engine power for undetermined reasons. A factor in the accident was the lack of a suitable landing area at the time of the power interruption.NTSB LAX93LA134Accident · Minor injuriesLimited investigationFinal reportBeech D35 · San Manuel, AZThe pilot's improper use of carburetor heat. Contributing to this accident were weather conditions which were conducive to the formation of carburetor ice.NTSB NYC93LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · New Cumberland, PAThe loss of engine power for undetermined reasons, resulting in a forced landing in the river.NTSB SEA93LA063Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Salem, ORA complete loss of power for undetermined reasons. Factors include unsuitable terrain, and trees surrounding the forced landing site.NTSB MIA93FA051Accident · Serious injuriesField investigationFinal reportCessna 140 · Niceville, FLA loss of engine power for undetermined reasons over terrain that was not suitable for the subsequent forced landing.NTSB BFO93LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Poestenkill, NYThe total loss of engine power due to undetermined reasons.NTSB ATL93FA046Accident · 2 fatalField investigationFinal reportBeech A23 · Ft. Bragg, NCThe loss of engine power for undetermined reasons and the loss of control during the forced landing.NTSB MIA93LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Titusville, FLLoss of engine power during the downwind leg for undetermined reasons, poor in-flight planning/decision by the dual student, and inadequate supervision by the pilot-in-command (CFI).NTSB SEA93LA047Accident · No injuriesLimited investigationFinal reportAero Commander AC-500B · Billings, MTLoss of engine power on both engines for undetermined reasons and left main landing gear not down and locked on touchdown.NTSB FTW93LA059Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Clint, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA058Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Coleman, TXA loss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB MIA93FA035Accident · Serious injuriesField investigationFinal reportCessna 310D · Miami, FLImproper installation of the right outboard torque tube in the right fuel selector valve assembly housing resulting in a total loss of engine power due to fuel starvation.NTSB LAX93LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-20 · Florence, AZThe pilot's poorly planned approach; his failure to attain the proper touch down point; and, delay in executing a go-around. Contributing to this accident was the partial loss of power for undetermined reasons.NTSB LAX93LA065Accident · No injuriesLimited investigationFinal reportCessna 185F · Lanai, HIThe failure of the engine for undetermined reasons. A factor in the accident was that obstructions were hidden in the grass of the landing area chosen by the pilot for the forced landing.NTSB FTW93LA050Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Norman, OKThe pilot's failure to refuel the airplane and power loss due to fuel exhaustion. Factors were the dark night and lack of suitable terrain.NTSB ATL93FA031Accident · 6 fatalField investigationFinal reportBeech 95-B55B · Calera, ALThe pilot's continued flight with the fuel tank selector handles improperly positioned, which resulted in fuel starvation and engine stoppage. Factors were the cloudy weather conditions, the night lighting conditions, and the steep, hilly terrain conditions…NTSB LAX93LA048Accident · 1 fatalLimited investigationFinal reportRans S-10 Sakota · San Jose, CA1) The loss of engine power due to undetermined reason(s), and, 2) the pilot not maintaining airspeed above the power off stall speed while maneuvering to the runway resulting in an inadvertent stall/spin. A factor in this accident was the pilot not having…NTSB FTW93LA037Accident · Serious injuriesLimited investigationFinal reportColgate, Henry A. FS21000 · Albuquerque, NMThe loss of engine power for undetermined reasons. Factors were the low altitude and unsuitable terrain.NTSB BFO93LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Red Hook, NYThe pilot's inadvertent deactivation of the electric fuel boost pump. A factor related to the accident was the failure of the engine driven fuel pump during takeoff.NTSB LAX93LA032Accident · 1 fatalLimited investigationFinal reportR.W. Sherman Turbulent · Adelanto, CAThe pilot's improper emergency decision to attempt to return to the departure area. Contributing to this accident was the undetermined loss of power, inadequate altitude, and failure to maintain the airspeed.NTSB MIA93FA015Accident · No injuriesField investigationFinal reportDouglas DC-7CF · Fort Lauderdale, FLFailure of the #4 engine for an undetermined reasons(s), and the inability of the airplane to remain airborne due to the overgross weight takeoff performed by the pilot. Factors which contributed to the accident were: the questionable airworthiness of the…NTSB FTW93LA031Accident · No injuriesLimited investigationFinal reportCessna U206D · Fort Stockton, TXThe pilot's failure to follow published fuel system sumping procedures before flight and total loss of power due to water contaminated fuel. Factors were the drizzle and icing conditions and the lack of suitable terrain.NTSB SEA93LA014Accident · No injuriesLimited investigationFinal reportCessna 182A · Ashton, IDA power loss for undetermined reasons. A factor contributing to the accident was the soft terrain.NTSB SEA93LA011Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Enterprise, ORPoor in-flight planning/preparation. A factor to the accident was: improper use of the mixture.NTSB SEA93LA009Accident · Minor injuriesLimited investigationFinal reportMorrisey Shinn 2150A · Dallas, ORFailure to maintain airspeed. Factors include an improper fuel selector setting, and fuel starvation.NTSB CHI93LA012Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Maryland Height, MOBlockage of the induction air system by a mouse nest.NTSB NYC93GA025Accident · Serious injuriesFinal reportSchweizer 269C · Baltimore, MDA power loss of undetermined origin. Factors related to the accident were the night conditions, the lack of a suitable landing area, and the inability of the pilot to maintain rotor RPM while maneuvering to avoid obstacles.NTSB FTW93LA015Accident · No injuriesLimited investigationFinal reportRobinson R22B · Robert Lee, TXThe loss of engine/rotor RPM for undetermined reasons.NTSB FTW93LA012Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Mexia, TXThe pilot fueled the aircraft with jet fuel instead of avaition gasoline. Factors were the unsuitable terrain encountered during the forced landing and the dark night light conditions.NTSB MIA93LA006Accident · 1 fatalLimited investigationFinal reportHarkness, Richard W. Adventure · New Smyrna Bch, FLThe failure of the pilot in command to maintain airspeed above stall speed following engine failure resulting in the aircraft stalling and descending uncontrolled to the ground. Contributing to the accident was the pilot in command's improper leaning of the…NTSB LAX93LA009Accident · No injuriesLimited investigationFinal reportCessna 210F · Buena Park, CAFailure of the pilot to adequately detect water contamination in the airplane's fuel system during preflight.NTSB MIA93LA005Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Port St. Lucie, FLTotal loss of engine power due to fuel exhaustion caused by poor preflight planning preparation by the pilot in command.NTSB FTW93LA009Accident · No injuriesLimited investigationFinal reportCessna 175 · Cleveland, TXThe loss of engine power for undetermined reasons. A factor was the unsuitable terrain.NTSB CHI93LA001Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Marion, IAThe loss of engine power for undetermined reasons.NTSB DEN93LA001Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Steamboat Sprgs, COThe pilot's selection of an unsuitable landing area when a suitable forced landing area was available. A factor was: fuel starvation for unknown reasons.NTSB FTW93LA004Accident · No injuriesLimited investigationFinal reportCessna 150F · Hughes, ARThe loss of control during the landing roll. A factor was the partial loss of engine power.NTSB MIA93LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Englewood, FLInadequate preflight of the airplane by the pilot in command which resulted in the total loss of engine power shortly after takeoff due to fuel contamination.NTSB CHI92LA295Accident · Serious injuriesLimited investigationFinal reportFunk, D.D. B85C · Buffalo, MNThe contamination of the carburetor, inadequate maintenance inspection by maintenance personnel, and the inadequate maintenance servicing by the pilot/owner.NTSB LAX92LA406Accident · No injuriesLimited investigationFinal reportCessna 150B · Show Low, AZFuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft and his failure to refuel the aircraft prior to departure.NTSB LAX92LA403Accident · No injuriesLimited investigationFinal reportGolightly, Robert B. RV4 · Rialto, CAFuel starvation due to the pilot's improper management of the fuel system, and his failure to perform the emergency procedure of repositioning the fuel selector to a tank containing fuel.