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 SEA90FA047Accident · 2 fatalField investigationFinal reportBurton Cavalier Model 2 · Grants Pass, ORFuel exhaustion which resulted from the pilots intentionally operating the aircraft with a known deficiency. The pilot failed to maintain airspeed, resulting in a stall/spin and uncontrolled descent.NTSB MIA90LA073Accident · Minor injuriesLimited investigationFinal reportForney 415-CD · Tavernier, FLInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the presence of trees in the emergency landing area.NTSB ATL90LA067Accident · No injuriesLimited investigationFinal reportCessna 150M · Leitchfield, KYThe pilot's inadequate preflight, in that he did not assure that both fuel tank filler caps were secure prior to flight.NTSB LAX90LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Lucerne Valley, CAThe pilot's failure to use carburetor heat and improper emergency procedures. Contributing to the accident was the pilot's lack of total experience.NTSB FTW90LA073Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Carrollton, TXStarvation induced power loss caused by the pilot's improper selection/management of the appropriate fuel tank. Contributing to the accident was the pilot's poor inflight planning which resulted in running a fuel tank dry.NTSB ATL90LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Roxboro, NCThe pilot's failure to use the before landing checklist which requires the application of carburetor heat. Factors were soft terrain at accident site, and condition favorable for the formation of carburetor ice.NTSB BFO90LA029Accident · No injuriesLimited investigationFinal reportCessna 150M · Leesburg, VAThe pilot's failure to assure an adequate supply of fuel was onboard to complete the flight.NTSB LAX90LA096Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Inyokern, CAThe pilot's failure to refuel which led to fuel exhaustion.NTSB BFO90LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Tappahannock, VAFailure of fixed base operator (FBO) personnel to assure that the fuel tank was free of water, and failure of the pilot to insure that the aircraft was properly preflighted. Soft/marshy terrain in the emergency landing area was a related factor.NTSB FTW90FA069Accident · 2 fatalField investigationFinal reportBeech C-90 · Burlington, NCThe double engine power loss due to fuel starvation, the pilot's failure to follow procedures and directives by not engaging the right fuel transfer pump, and the inadvertent stall during the forced landing approach. A factor was the pilot's failure to refuel…NTSB CHI90LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Elkhart, INThe pilot's improper in-flight planning/decision and inadequate fuel consumption calculations, which resulted in a loss of engine power & subsequent off-airport forced landing. The stronger than anticipated wind aloft was a contributing factor.NTSB CHI90LA079Accident · No injuriesLimited investigationFinal reportCessna 177B · Raleigh, ILInadequate preflight by the pilot and fuel exhaustion due to an inadequate supply of fuel. The unreliable fuel quantity gauge was a related factor.NTSB ATL90LA062Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Atmore, ALFuel starvation due to an inadequate preflight and improper positioning of the fuel selector. A factor related to the accident was: rough terrain in the emergency landing area.NTSB MKC90LA053Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Palestine, ARImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB LAX90LA086Accident · No injuriesLimited investigationFinal reportCessna 150L · Bullhead City, AZThe pilot's miscalculation of the fuel remaining, which caused the engine to quit.NTSB ATL90LA063Accident · No injuriesLimited investigationFinal reportBeech A 36 · Ocean Island Be, NCLoss of engine power due to fuel starvation and the pilot in commands failure to turn on the electric boost pump during attempted engine restart resulting in a forced landing.NTSB SEA90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Boring, ORCarburetor icing, and the pilot's improper use of carburetor heat. Factors related to the accident were: carburetor icing conditions and the soft/uneven terrain in the emergency landing area.NTSB MIA90LA066Accident · No injuriesLimited investigationFinal reportCessna 172A · Pahokee, FLLoss of engine power for am undetermined reason.NTSB MIA90LA065Accident · Serious injuriesLimited investigationFinal reportMooney M-20K-231 · Winter Haven, FLThe pilot in command failed to properly pre-flight the airplane and assure that an adequate fuel supply was onboard to complete the intended flight. This resulted in an engine failure due to fuel exhaustion.NTSB BFO90MA023Accident · 1 fatalMajor investigationFinal reportHawker Siddeley HS.125-35 · Columbia, MOInadequate preflight by the pilot(s), water contamination of the fuel, low level of deice fluid (methanol) in the deice tank, and subsequent ice blockage of the fuel filters. Darkness was a related factor.NTSB FTW90FA059Accident · 1 fatalField investigationFinal reportAeronca 7DC · El Paso, TXPower loss due to failure of the carburetor assembly and the pilot's failure to correct known deficiencies. Factors were contaminated fuel, partially blocked fuel screen, fouled spark plugs, the rough terrain, and the lack of shoulder harnesses.NTSB ANC90FA032Accident · Minor injuriesField investigationFinal reportCessna 182 · Anchorage, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: the obstructions (utility pole, power line & fence) in the emergency landing area.NTSB ATL90LA057Accident · No injuriesLimited investigationFinal reportMooney M20A · Parris Island, SCThe failure of the pilot to insure that sufficient fuel was aboard for the flight, resulting in fuel exhaustion.NTSB FTW90LA054Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Bastrop, LALoss of engine power due to water contamination in the fuel. A factor related to the accident was: inadequate design of the fuel system drains, which prevented an adequate preflight of the fuel system.NTSB NYC90LA055Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Schuyler, NYThe pilot's improper use of carburetor heat, which resulted in a loss of engine power due to carburetor ice.NTSB LAX90LA071Accident · No injuriesLimited investigationFinal reportNorth American Navion · Apple Valley, CAThe pilot failed to properly preflight the airplane and departed on the accident flight with minimal fuel.NTSB NYC90LA052Accident · Serious injuriesLimited investigationFinal reportCessna C150 · E. Prospect, PAPilot's improper execution of emergency procedures after the engine failed. The pilot lost control of the airplane while maneuver the airplane back to the airstrip during the forced landing. The pilot stalled the airplane at too low an altitude to recover.NTSB MIA90LA056Accident · Minor injuriesLimited investigationFinal reportCessna 404 · Boca Raton, FLLoss of power in the right engine due to a disconnected duct between the turbocharger and the plenum chamber. The reason for the loss of power in the left engine was not determined.NTSB MKC90FA044Accident · Serious injuriesField investigationFinal reportCessna P210N · Newton, KSLoss of engine power for an undetermined reason. Darkness and the resultant delay in flaring to land were related factors.NTSB MIA90LA055Accident · Minor injuriesLimited investigationFinal reportConn ONE Design · Daytona Beach, FLFuel starvation due the fuel vent being blocked by a mud dauber nest and the pilot's failure to find the obstruction (inadequate preflight) before taking off. Trees beyond the departure end of the runway were a related factor.NTSB DEN90LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Provo, UTFuel starvation due to pilot misjudgement of fuel requirements for the trip and a failure to refuel the airplane en route.NTSB ATL90LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lithia Springs, GAImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel.NTSB CHI90LA061Accident · No injuriesLimited investigationFinal reportCessna 150L · Traverse City, MIImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB ATL90LA048Accident · No injuriesLimited investigationFinal reportCessna 172B · Killen, ALInadequate pre-flight planning by the pilot in command which resulted in fuel exhaustion during cruise flight.NTSB NYC90LA045Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Slippery Rock, PALoss of airspeed and an inadvertent stall by the pilot during an attempted return to the airport, following a power loss due to carburetor ice.NTSB BFO90LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Petersburg, VAFuel starvation and improper use of emergency procedures (fuel selector) by the pilot.NTSB NYC90LA044Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Millis, MAThe pilot's improper use of carburetor heat which caused a power loss and a forced landing in unsuitable terrain. Factors related to the accident were carburetor icing conditions and the pilots lack of total experience.NTSB MIA90FA044Accident · Serious injuriesField investigationFinal reportCessna 210M · Stuart, FLThe pilot's improper calculation of fuel consumption which resulted in an inadequate fuel supply to reach his destination.NTSB CHI90FA050Accident · 2 fatalField investigationFinal reportBeech 60 · Erie, PAThe pilot's failure to assure that the aircraft had an adequate supply of fuel on board for the intended flight. Contributing factors to the accident were an inoperative right fuel quantity gage which resulted in inaccurate fuel consumption calculations, and…NTSB NYC90LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · No. Andover, MAThe pilot inadvertently turned off the magneto switch during a go-around, resulting in a loss of power. Also causal to the accident was the failure of the pilot of a second airplane to respond to the tower controller's instructions. A factor related to the…NTSB ATL90LA046Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Selmer, TNThe failure of the instructor to place the engine mixture control in the rich position prior to beginning traffic pattern maneuvers. As a result, the engine quit because of the lean fuel mixture at the high power setting required for the go-around and…NTSB FTW90LA045Accident · No injuriesLimited investigationFinal reportCessna 150M · Minden, TXThe pilot's mismanagement of fuel by not maintaining an adequate supply of fuel.NTSB CHI90LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · New Phila, OHThe pilot's failure to drain all of the trapped water from the fuel system prior to flight. Factors related to the accident were: the unfavorable wind condition and trees in the emergency landing area.NTSB ATL90LA044Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Danielsville, GAInadequate preflight preparation/planning by the pilot, by not assuring an adequate supply of fuel, which resulted in fuel exhaustion. Related factors were: a false fuel quantity indication, trees in the emergency landing area, and failure of the landing gear…NTSB LAX90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bumble Bee, AZThe failure of the student pilot to apply carburetor heat in a timely manner. Contributing to the accident were the carburetor icing conditions and the desert terrain.NTSB CHI90LA046Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lacrosse, WIThe student pilot's improper pre-flight planning/preparation, which did not include a plan to refuel the aircraft as necessary. The student pilot's lack of total experience contributed to this accident, as did the cfi's inadequate supervision of the student.NTSB ATL90LA041Accident · No injuriesLimited investigationFinal reportBeech A36 · Nashville, NCA loss of engine power for undetermined reasons. A factor related to the accident was the ditch the airplane contacted.NTSB CHI90DEV01Accident · Minor injuriesFinal reportCessna 210D · Jerseyville, ILA total loss of engine power for an undetermined reason. A factor in the accident was the rough uneven terrain in the forced landing area.NTSB LAX90LA049Accident · No injuriesLimited investigationFinal reportCessna 150D · Inyokern, CAThe pilot's failure to use carburetor heat when climatic conditions were conducive to the formation of carburetor ice.NTSB ATL90LA037Accident · No injuriesLimited investigationFinal reportBeech A36 · Charlotte, NCThe failure of the airplane engine due to fuel exhaustion over terrain unsuitable for the forced landing.