NTSB investigations
5,891 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.
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\" = 353) 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" = 353) 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 LAX97FA189Accident · No injuriesField investigationFinal reportEmbraer EMB-120 · San Diego, CAThe failure of maintenance personnel to allow adequate time for the engine oil to drain back into the engine oil reservoir prior to adding additional oil, thereby overfilling the reservoir, which resulted in an engine fire and subsequent damage to hydraulic…NTSB LAX97LA186Accident · No injuriesLimited investigationFinal reportCessna 150 · Groveland, CAwas fuel exhaustion. Contributing to the accident was the lack of preflight review by the student's flight instructor and training.NTSB LAX97LA184Accident · No injuriesLimited investigationFinal reportCessna 182G · Corona, CAfuel exhaustion due to the pilot's failure to perform either preflight or en route fuel consumption calculations. The pilot's decision to fly the aircraft without the required pilot's operating handbook (POH) on board was a factor in this accident.NTSB LAX97LA183Accident · No injuriesLimited investigationFinal reportNorth American Navion NA-1 · Morristown, AZfailure to replace an old and abraded oil feedline hose which led to its rupture and the in-flight loss of engine oil pressure. A related factor was the pilot's misjudgment of distance-to-go versus altitude remaining during the subsequent forced landing.NTSB CHI97FA133Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Savoy, ILthe pilot's improper preflight planning/preparation and her not maintaining airspeed. Factors were fuel exhaustion and entering an inadvertent stall.NTSB MIA97LA168Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Orlando, FLThe pilot misjudging the distance of the intended touchdown point resulting in his intentional decrease in the main rotor rpm to clear obstacles below. Contributing to the accident was the total loss of engine power due to undetermined reasons.NTSB FTW97LA190Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Laredo, TXloss of engine power due to fuel contamination, and the pilot's failure to properly check the fuel system for evidence of water during the preflight inspection. A factor was the lack of suitable terrain for the forced landing.NTSB IAD97LA074Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Lewisburg, WVThe pilot's inadequate preflight, which led to the loss of a fuel cap and subsequent fuel exhaustion.NTSB ATL97FA072Accident · 1 fatalField investigationFinal reportBellanca 14-13 · Stockbridge, GAthe pilot's improper use of carburetor heat, which led to loss of engine power due to carburetor ice. Factors related to the accident were: carburetor icing (weather) conditions, and trees in the emergency landing area.NTSB FTW97IA362Incident · No injuriesIncident investigationFinal reportAyres S2R-G10 · Munday, TXblockage of both fuel lines from the left wing tank to the header tank by silicone rubber contaminants (foreign material), which resulted in fuel starvation. A related factor was the lack of suitable terrain for the forced landing.NTSB FTW97FA173Accident · Minor injuriesField investigationFinal reportGowan LONG-EZ · Roanoke, TXThe pilot's failure to maintain the proper descent rate. A factor was the gascolator's filter screen becoming contaminated with fiber glass residue due to the pilot/mechanic's inadequate maintenance.NTSB IAD97LA071Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Washington, DCtotal loss of power on both engines due to fuel exhaustion as a result of the pilot's improper fuel consumption calculations.NTSB ATL97LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-180 · Russellville, ALThe loss of engine power for undetermined reasons. A factor was conditions were favorable for the formation of carburetor ice.NTSB ANC97LA065Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Hope, AKa loss of engine power resulting from fuel starvation due to the pilot's improper positioning of the fuel selector, and the pilot's failure to identify and correct the deficiency during the ensuing emergency descent.NTSB ATL97LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Hazelhurst, GAThe loss of engine power for undetermined reasons. Factors were, conditions were favorable for the formation of carburetor ice, and the pilot lack of qualification for the flight.NTSB SEA97FA094Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar Aerostar 601P · Klammath Falls, ORThe pilot's failure to set the throttle of his second failed engine to 'Cracked-1/2-Open' as called for in the Engine Failure/Restart checklist, followed by a high-power engine surge. Factors include the pilot's delay in landing for refueling, the pilot…NTSB LAX97LA168Accident · Serious injuriesLimited investigationFinal reportCessna T182 · Hemet, CAthe pilot's decision not to dip check the aircraft fuel tanks after he had noted a disagreement between the cockpit fuel gages and what he had observed visually in the fuel tanks, and his failure to accomplish in-flight endurance calculations based on…NTSB ATL97LA063Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lincolnton, GAThe pilot's inadequate preflight planning of the fuel requirement for this flight that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB ATL97LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Clearwater, FLThe pilot's failure to select the fuller tank for takeoff that resulted in fuel starvation to the engine, and the subsequent total loss of engine power.NTSB CHI97LA110Accident · Serious injuriesLimited investigationFinal reportGulfstream 500B · Mission, KSthe pilot's inadequate preflight planning which resulted in fuel exhaustion.NTSB MIA97LA140Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe flight crew's improper planning/decision, which resulted in loss of engine power due to fuel exhaustion.NTSB FTW97LA158Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · El Paso, TXthe pilot's improper plannning/decision, which resulted in loss of engine power (both engines) due to fuel exhaustion. Darkness was a related factor.NTSB MIA97LA127Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Tullahoma, TNFuel exhaustion for undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the failure of the pilot to divert to an alternate airport while en route after recognizing that the fuel consumed was…NTSB NYC97FA069Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Farmingville, NYthe pilot's improper inflight planning/decision, which subsequently resulted in fuel exhaustion and loss of engine power. Related factors were: excessive fuel consumption rate, and obstructions (trees and house) in the emergency landing area.NTSB MIA97LA122Accident · Minor injuriesLimited investigationFinal reportKunc KR-1 · Deland, FLthe pilot's improper planning/decision, by failing to ensure there was sufficient fuel to safety complete the flight, which resulted in fuel exhaustion, loss of engine power, a forced landing, and subsequent collision with tree(s).NTSB MIA97LA121Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Miami, FLThe student pilot's inadequate preflight planning and improper fuel consumption calculations which resulted in fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB MIA97LA115Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Columbia, SCThe pilot's inadequate planning/decision and failure to assure an adequate supply of fuel was on board the airplane.NTSB NYC97LA070Accident · No injuriesLimited investigationFinal reportCessna 150E · Wolfeboro, NHThe pilot's improper preflight, and failure to refuel the airplane, which resulted in fuel exhaustion during the initial climb after takeoff, and the subsequent forced landing and collision with a mound of dirt.NTSB LAX97LA147Accident · No injuriesLimited investigationFinal reportCessna 182D · Tucson, AZFuel exhaustion due to the inadequate preflight inspections performed by both pilots. A factor in the accident was the crosswind experienced during landing rollout.NTSB MIA97LA113Accident · No injuriesLimited investigationFinal reportChance Vought F4U · New Smyrna Bch, FLThe pilot's failure to assure that an adequate supply of fuel was on board for the intended flight.NTSB FTW97LA149Accident · Minor injuriesLimited investigationFinal reportBeech D35 · Bartlesville, OKthe pilot's selection of an empty fuel tank, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's lack of familiarity with the aircraft.NTSB IAD97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Pittsburgh, PAthe student pilot inadvertently became lost/disoriented during a cross-country flight, and failed to use his radio for assistance, which led to fuel exhaustion, loss of engine power, and a forced landing.NTSB ANC97LA044Accident · No injuriesLimited investigationFinal reportCessna 175 · Naknek, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. Factors associated with the accident were the pilot's inadequate preflight preparation and planning by failing to obtain information about the out of service runway lighting, and the rough…NTSB ANC97LA038Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Kake, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion. Factors associated with the accident were the pilot's lack of familiarity with the geographic area, the pilot's becoming lost/disoriented, and rocks and boulders in the emergency landing…NTSB LAX97LA129Accident · No injuriesLimited investigationFinal reportCessna 150L · Nogales, AZLoss of engine power due to fuel contamination resulting from the pilot's inadequate fuel storage and filtering procedures.NTSB FTW97LA142Accident · No injuriesLimited investigationFinal reportCessna T210L · Durango, COthe pilot's improper planning/decision, and failure to ensure there was sufficient fuel aboard for the flight, which resulted in fuel exhaustion and loss of engine power. A factor relating to the accident was: the lack of suitable terrain for a successful…NTSB FTW97FA130Accident · 1 fatalField investigationFinal reportCessna 421 · League City, TXThe pilot's failure to refuel the airplane which resulted in the loss of power to the right engine due to fuel exhaustion, and the pilot's failure to maintain airspeed during the single engine landing approach which resulted in a stall/spin.NTSB CHI97LA088Accident · No injuriesLimited investigationFinal reportCessna 150J · La Valle, WIthe pilot's inadequate pre-flight planning/preparation which led to fuel exhaustion. A factor was the snow covered terrain.NTSB FTW97LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Broomfield, COthe student pilot's improper use of the fuel tank selector which led to fuel starvation and loss of engine power. Factors were the pilot's inadequate fuel management and the lack of suitable terrain for the forced landing.NTSB MIA97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Nashville, TNimproper planning/decision by the pilot, by failing to ensure there was sufficient fuel to reach a suitable landing area, which resulted in fuel exhaustion, loss of engine power, a forced landing, and collision with a tree. The faulty fuel indication was a…NTSB IAD97LA053Accident · No injuriesLimited investigationFinal reportCessna 175 · Weirs Cave, VAthe pilot's inadequate preflight planning/preparation, and inaccurate fuel calculations, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Darkness and high vegetation in the forced landing area were related factors.NTSB LAX97LA115Accident · No injuriesLimited investigationFinal reportRyan Navion · Marina, CAFuel exhaustion due to the pilot's improper preflight inspection and his inaccurate fuel consumption calculations.NTSB FTW97LA118Accident · No injuriesLimited investigationFinal reportRyan Navion A · Hudson, COA total power loss due to fuel starvation as a result of the pilot's inadequate preflight inspection of the airplane and its fuel system. Factors include: the pilot's failure to refuel the airplane, the improper fuel tank selector position that would not…NTSB MIA97LA096Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Huntsville, ALTotal loss of engine power due to fuel exhaustion for undetermined reasons.NTSB LAX97LA117Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Alpine, CAA loss of engine power due to fuel starvation caused by an obstruction in the fuel vapor return system. An additional causal finding is the failure of maintenance personnel to properly troubleshoot a discrepancy with the fuel system.NTSB NYC97LA059Accident · No injuriesLimited investigationFinal reportBeech J35 · Pittstown, NJthe pilot's placing the fuel selector in the improper position causing fuel starvation and a loss of engine power. The loss of engine power resulted in a forced landing on the runway during an aborted landing.NTSB CHI97LA076Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · West Chicago, ILfuel starvation due to the pilot's improper fuel tank selection.NTSB FTW97FA109Accident · 1 fatalField investigationFinal reportKeating Quickie II · Houston, TXThe loss of engine power due to fuel starvation as result of the pilot's improper fuel management. Factors were the pilot's lack of familiarity with the airplane, the dark night, the lack of cockpit lights, and the lack of suitable terrain for the pilot to…NTSB IAD97LA051Accident · No injuriesLimited investigationFinal reportHughes 369HS · Marion, OHUncovering of the fuel tanks outlet, which resulted in fuel starvation and subsequent loss of engine power. A related factor was the unsuitable terrain.NTSB FTW97LA108Accident · No injuriesLimited investigationFinal reportCessna R172K · Brownsville, TXthe pilot's failure to refuel the airplane which resulted in a loss of engine power due to fuel exhaustion.