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 NYC97LA018Accident · No injuriesLimited investigationFinal reportDubis Team Minimax · North Adams, MAfuel contamination, which resulted in a loss of engine power. Factors relating to the accident were: the lack of a drain in the fuel system to properly check the fuel before flight, and the pilot's failure (or inability) to detect the contaminated fuel.NTSB LAX97LA042Accident · Serious injuriesLimited investigationFinal reportBeech 35-33 · Apple Valley, CAfuel starvation, due to plugged fuel system vent lines, which resulted in loss of engine power.NTSB FTW97LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Tulsa, OKFuel exhaustion due the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB IAD97LA016Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Gaithersburg, MDthe pilot's inadequate preflight, and his failure to detect an insufficent fuel supply, which resulted in fuel exhaustion and a forced landing after takeoff. Uneven terrain (drop-off in the emergency landing area) was a related factor.NTSB FTW97LA037Accident · No injuriesLimited investigationFinal reportCessna T210N · Grand Prairie, TXfailure of the pilot to ensure that the fuel selector was positioned to a tank with sufficient fuel, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's inadequate preflight, false indication from the…NTSB LAX97LA033Accident · No injuriesLimited investigationFinal reportCessna 150M · Lake Havasu, AZcarburetor ice, and failure of the pilot to use carburetor heat, which resulted in loss of engine power. Factors relating to the accident were: carburetor icing conditions, darkness, and the lack of suitable terrain for a forced landing.NTSB MIA97IA016Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Mccomb, MSthe lineman's fueling of the aircraft with the wrong type fuel, the pilot's failure to verify the type of fuel added to the aircraft before flight, and failure of the refueling facility to be equipped with the proper fuel nozzle.NTSB MIA97FA010Accident · Minor injuriesField investigationFinal reportCessna 172F · Venice, FLinadequate maintenance servicing of the airplane during an oil change by the owner/pilot for his failure to secure the oil temperature probe securing nut. Also, inadequate maintenance of the airplane by the owner/pilot for his failure to operate the engine…NTSB NYC97LA007Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Pasadena, MDthe pilot's inadequate preflight planning/preparation and inadequate management of the airplane's fuel supply, which resulted in fuel exhaustion and a forced landing at night. Factors related to the accident were: an inaccurate fuel quantity indicating…NTSB SEA97LA017Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Pocatello, IDinadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Soft terrain at the emergency landing site was a related factor.NTSB LAX97LA020Accident · No injuriesLimited investigationFinal reportBeech S35 · Palo Alto, CAfuel starvation, due to the pilot's improper positioning of the fuel tank selector to an empty tank. Swampy terrain in the emergency landing area was a related factor.NTSB CHI97LA007Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Hillsdale, MIthe pilot's improper in-flight planning/decision and failure to refuel which led to fuel exhaustion.NTSB ATL97LA003Accident · Serious injuriesLimited investigationFinal reportHarper W-8 Tailwind · Macclenny, FLthe pilot's inadequate preflight inspection, which resulted in loss of engine power due to fuel contamination.NTSB LAX97LA015Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Agua Dulce, CAinadequate compliance with the applicable airworthiness directive by other maintenance personnel, and the pilot's inadequate preflight inspection which resulted in fuel exhaustion from a deteriorated fuel cap seal.NTSB ATL97LA002Accident · Serious injuriesLimited investigationFinal reportBell UH-IB · Bennettsville, SCthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of usable fuel. A factor relating to the accident was: an inoperative left boost pump, which increased the amount of unusable fuel…NTSB LAX97LA001Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Truckee, CAa total loss of engine power for undetermined nonmechanical reasons.NTSB IAD97LA005Accident · No injuriesLimited investigationFinal reportCessna T210M · Mentor, KYthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. Factors relating to the accident were: the inaccurate fuel quantity gage, and the light condition at dusk.NTSB LAX97LA012Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Truckee, CAthe pilot's inadequate preflight planning/preparation and fuel consumption calculations resulting in fuel exhaustion. The pilot's failure to switch the fuel tanks to the auxiliary position and feather both propellers were factors.NTSB FTW97LA013Accident · No injuriesLimited investigationFinal reportDickson RV-3A · Rosharon, TXThe pilot's failure to follow procedures and directives in that he did not use carburetor heat and he did not periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the transmission wire.NTSB MIA97LA003Accident · Minor injuriesLimited investigationFinal reportSocata TB-20 · Mobile, ALthe pilot's improper management of fuel, which resulted in fuel exhaustion and loss of engine power during a go-around, and subsequent collision with trees and terrain during a forced landing.NTSB LAX97LA007Accident · No injuriesLimited investigationFinal reportCessna 172C · Mesa, AZthe pilot's improper use (positioning) of the fuel selector, which resulted in fuel starvation and loss of engine power.NTSB FTW97LA010Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gulf Of Mexicofuel exhaustion due to the pilot's inadequate in-flight fuel consumption calculations.NTSB SEA97LA004Accident · No injuriesLimited investigationFinal reportCrouch Avid Mark IV · Stanwood, WAfailure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of engine power. A factor relating to the accident was: the pilot's failure to attain the proper touchdown point on suitable terrain during the…NTSB CHI97LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-16 · Silver Lake, INfuel starvation due to an inadequate preflight and the pilot performed a low altitude maneuver which prevented him from selecting suitable terrain for landing. Additional factors included the loose fuel cap, fuel siphoning, and unreliable fuel gauges.NTSB SEA97LA002Accident · No injuriesLimited investigationFinal reportRockwell S2R · Glide, ORfailure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of power. Factors relating to the accident were: false indications of cockpit fuel gauges and unsuitable terrain for a forced landing.NTSB IAD96LA155Accident · Serious injuriesLimited investigationFinal reportMerritt Acro Sport II · Cumberland, MDThe pilot's failure to select the electric fuel boost pump during take off which resulted in loss of engine power due to fuel starvation and the subsequent forced landing. A factor to this accident was the owner/builder alteration of the fuel system by…NTSB NYC96LA189Accident · No injuriesLimited investigationFinal reportCessna 172K · Deal, NJthe pilot's improper decision/planning, which resulted in fuel exhaustion and a subsequent forced landing.NTSB MIA96LA234Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Wassau Island, GAthe pilot's inadequate preflight and planning which resulted in fuel exhaustion.NTSB MIA96FA233Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Birmingham, ALThe pilot-in-command's improper in-flight planning/decision for electing to continue the flight after observing that the fuel gauges indicated empty. Contributing to the accident was an improperly adjusted economizer jet and an out of adjustment float. Also…NTSB IAD96LA154Accident · No injuriesLimited investigationFinal reportCessna 182 · Kansas, OHthe pilot's improper inflight planning/decision, which resulted in fuel exhaustion during cruise flight and subsequent loss of engine power. A related factor was the lack of suitable terrain for an emergency landing.NTSB CHI96LA350Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Germantown Hill, ILthe pilot's inadequate fuel supply and his misjudging distance and altitude. The trees were a factor.NTSB CHI96LA346Accident · No injuriesLimited investigationFinal reportBeech B23 · Viroqua, WIthe pilot's inadequate aircraft preflight which led to fuel exhaustion. A factor was the rough uneven terrain.NTSB CHI96LA344Accident · Minor injuriesLimited investigationFinal reportRozendaal Smith Innovation · Hampton, IAthe pilot's failure to refuel the airplane and his improper decision to perform a low altitude manuever with a low fuel supply.NTSB IAD96LA150Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Templeton, MAthe student pilot's improper in-flight decision to continued the cross-country flight into night conditions, and his inability to find the destination (or an alternate airport) in a timely manner, which resulted in fuel exhaustion, forced landing, and…NTSB FTW96LA397Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Lonestar, TXThe loss of engine power due to the pilot's improper fuel consumption calculations resulting in the fuel exhaustion. A factor was the unsuitable terrain for the forced landing.NTSB NYC96LA187Accident · No injuriesLimited investigationFinal reportCessna 180K · Derry, NHthe pilot's inadequate preflight inspection, which failed to detect water contaminated fuel, and resulted in a loss of engine power. A factor relating to the accident was: the pilot's operation of the aircraft with a known deficiency that consisted of a fuel…NTSB IAD96LA148Accident · Minor injuriesLimited investigationFinal reportBellanca BL-26 · Bowling Green, KYthe pilot's improper fuel consumption calculations and fuel exhaustion, which resulted in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.NTSB IAD96FA147Accident · No injuriesField investigationFinal reportShort Brothers SC7 · Findlay Twnshp, PAThe pilot's improper in-flight decision to continue to his destination when known en route delays were encountered which resulted in fuel exhaustion.NTSB MIA96LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Pensacola, FLloss of engine power during the initial climb due to contamination in the carburetor. Trees in the emergency landing area were a related factor.NTSB ANC96LA157Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKthe pilot's improper planning/decision, which resulted in loss of engine power due to fuel exhaustion. A factor associated with the accident was: the erroneous (false) indication of the fuel sight tubes.NTSB CHI96LA335Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Janesville, WIfuel exhaustion as a result of an inadequate preflight by the pilot in command.NTSB NYC96LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Closter, NJThe pilot's improper fuel management, which resulted in a power loss due to fuel exhaustion, followed by the airplane striking a tree during a forced landing.NTSB LAX96LA329Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Quincy, CAthe pilot's over leaning of the fuel mixture, which resulted in the initial loss of engine power; and continued fuel starvation, resulting from the pilot's inadvertent mispositioning of the fuel selector valve during an attempted restart of the engine.NTSB CHI96LA331Accident · No injuriesLimited investigationFinal reportCessna 182 · Eden Prairie, MNthe pilot's misjudging the fuel supply and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.NTSB ANC96TA148Accident · No injuriesFinal reportPiper PA-18 · Elmendorf, AKloss of engine power due to fuel starvation, which resulted from improper positioning of the fuel tank selector; inadequate supervision by the flight instructor (CFI); and the flight crew's improper emergency procedure.NTSB IAD96LA144Accident · No injuriesLimited investigationFinal reportCessna 150L · Hope, MEinadequate preflight, by not refueling the airplane during an en route stop, which led to fuel exhaustion, loss of engine power, and a subsequent forced landing.NTSB LAX96LA325Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Glendale, AZThe loss of engine power due to the pilot's mismanagement of the fuel system, which resulted in fuel starvation. The passenger's action, which restricted the pilot's ability to control the aircraft, was a factor in this accident.NTSB FTW96LA367Accident · Minor injuriesLimited investigationFinal reportJackson Sonerai I · Santa Fe, NMthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. The lack of suitable terrain for the forced landing was a related factor.NTSB LAX96LA323Accident · Serious injuriesLimited investigationFinal reportCessna T210L · Globe, AZfuel starvation due to the pilot's inadequate preflight inspection and improper fuel tank selection.NTSB LAX96LA322Accident · Minor injuriesLimited investigationFinal reportCessna 305A · San Diego, CAFuel exhaustion due to the pilot's improper preflight planning, and an inadequate fuel supply.