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 ATL90LA034Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Jackson, TNLoss of power in both engines (probable fuel starvation) due to improper planning/decision by the pilot(s), and lack of supervision by the instructor. Soft terrain in the emergency landing area was considered to be a factor.NTSB LAX90LA046Accident · No injuriesLimited investigationFinal reportPiper PA-32-437 · Hayward, CAEngine failure due to water in fuel that was not discovered by the pilot during his preflight inspection of the fuel system.NTSB CHI90DEE02Accident · Serious injuriesFinal reportEdward Avid Flyer C · Lansing Arpt, ILPilot's failure to attain proper runway alignment prior to touchdown. A factor in the accident was the builder's improper modification of the carburetors.NTSB CHI90LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Barron, WIImproper use of the carburetor heat by the pilot and subsequent carburetor ice. Contributing factors were: carburetor icing conditions, slick (wet/snow covered) runway, and trees/brush near the departure end of the runway.NTSB FTW90LA036Accident · No injuriesLimited investigationFinal reportCessna 150 · Fort Worth, TXFuel exhaustion due to the inadequate in-flight planning/decision by the plt. A factor in this was the improper initial training by the flight instructor.NTSB FTW90DRA01Accident · Minor injuriesFinal reportCessna A188B · Muldoon, TXA total power loss due to water contamination in the fuel. A factor was the pilot's inadequate preflight inspection.NTSB ATL90LA032Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · New Bern, NCThe failure of the instructor pilot to ensure that the engine fuel selector valves were properly positioned prior to takeoff, which led to fuel starvation and a loss of engine power during takeoff.NTSB NYC90LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Dunkirk, NYPilot in command failed to maintain airspeed during a forced landing resulting in a stall and hard landing after a engine power failure due to carburetor ice and improper use of the carburetor heat control by the pilot.NTSB ATL90FA031Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Helen, GAThe pilot's failure to properly preflight and plan en route refueling stops. The airplane collided with trees during the emergency descent.NTSB MKC90LA034Accident · No injuriesLimited investigationFinal reportCessna 150 · Wichita, KSFuel exhaustion due to poor planning and the pilot's failure to refuel the aircraft.NTSB DEN90DTE02Accident · 2 fatalFinal reportBruce Mckinney VARI-EZE · Aspen, COThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion. A related factor to the accident was: the mountainous terrain.NTSB DEN90DTE01Accident · 1 fatalFinal reportLanier Thorp T-18 · Colorado City, COLoss of engine power with carbon fouling of the spark plugs, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB CHI90DET01Accident · No injuriesFinal reportPiper PA-24-250 · Decatur, INThe pilot's misjudgement of the fuel supply, inaccurate fuel consumption calculations, and his improper in-flight planning/decision, which resulted in fuel exhaustion. The lack of suitable terrain for an emergency landing was a related factor.NTSB MKC90LA033Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Richmond, MNImproper use of the fuel tank selector by the pilot and his improper use of emergency procedures, which resulted in fuel starvation after a fuel tank had emptied. Contributing factors were: inoperative fuel quantity gauges, pilot's operation with known…NTSB SEA90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bremerton, WAFuel exhaustion and inadequate preflight planning.NTSB LAX90LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hayward, CAInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Collision with a vehicle in the emergency landing area contributed to the damage and injuries.NTSB CHI90LA030Accident · No injuriesLimited investigationFinal reportCessna 150M · Detroit, MIInadequate preflight planning/preparation which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB SEA90LA018Accident · No injuriesLimited investigationFinal reportCessna 140 · Amboy, WALoss of engine power due to carburetor icing.NTSB SEA90LA017Accident · No injuriesLimited investigationFinal reportErcoupe 415D · Vancouver, WAThe pilot's inadvertant leaning of the fuel mixture to near idle cutoff, causing the engine to quit.NTSB MIA90FA027Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Pembroke Pines, FLInadequate annual inspection by other maintenance personnel and inadequate preflight inspection by the pilot, which resulted in failure to detect water and contamination (residue) in the fuel. Contributing factors were: failure of the plt to feather the…NTSB FTW90LA027Accident · No injuriesLimited investigationFinal reportCessna 150M · Norman, OKThe pilot inadvertently became lost and disoriented and delayed in obtaining help from the flight service station, which resulted in fuel exhaustion.NTSB BFO90LA011Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Wilmington, DEA loss of engine power as a result of the student pilot inadvertently pulling the mixture control to the idle cut-off position, and the flight instructor's inadequate supervision. A contributing factor to the accident was the rough and uneven terrain.NTSB ATL90LA027Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Morrisville, NCLoss of engine power for an unknown reason. The dark night and instrument conditions contributed to the accident.NTSB LAX90LA030Accident · Minor injuriesLimited investigationFinal reportCessna 210 · North Hollywood, CAImproper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel. Factors related to the accident were: false fuel gage indications, lack of a suitable area for a forced landing, and obstructions (utility pole &…NTSB SEA90LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Hillsboro, ORFuel contamination and the pilots lack of peflight inspection. Contributing to the accident was the soft terrain.NTSB NYC90LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Coatesville, PAImproper planning/decision by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB MKC90LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pine Bluff, ARAn inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of power.NTSB MKC90LA029Accident · No injuriesLimited investigationFinal reportCessna 152 · Cape Girardeau, MOPoor planning by the pilot in not refueling enroute which resulted in fuel exhaustion.NTSB LAX90LA028Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Chandler, AZThe pilot failed to properly use the checklist and the fuel selector valve was improperly selected to the empty tank.NTSB ATL90DKG02Accident · 1 fatalFinal reportBell 47G/Tomcat MK5 · Elberton, GAA loss of engine power due to carburetor ice.NTSB FTW90LA023Accident · Serious injuriesLimited investigationFinal reportCessna P206 · Thelma, TXThe pilot's failure to drain all the water from the fuel system during preflight.NTSB MKC90LA021Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Saint Paul, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Darkness was a related factor.NTSB LAX90LA020Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palo Alto, CAThe flight instructor improperly supervised the flight and the dual student pilot failed to properly set the fuel selector valve in the proper position. Both pilots failed to use the emergency checklist.NTSB ATL90FA016Accident · Minor injuriesField investigationFinal reportCessna T210M · Peachtree City, GAThe improper calibration of the fuel quantity gauges by maintenance personnel, which resulted in erroneous fuel quantity indications and led to fuel starvation. Contributing to the accident were the unsuitable terrain conditions that existed at the…NTSB CHI90DEK02Accident · Minor injuriesFinal reportEickmeier Pitts Special/S1C · Van Buren, OHA total loss of engine power for an undetermined reason.NTSB NYC90LA017Accident · Minor injuriesLimited investigationFinal reportCessna T172N · Townsend, MAThe pilot's failure to use carburetor heat during weather conditions favorable to carburetor icing. A contributing factor was the lack of suitable terrain.NTSB LAX90LA011Accident · No injuriesLimited investigationFinal reportCessna 150L · Marana, AZFailure of the pilot to properly judge his fuel supply, which resulted in fuel exhaustion.NTSB ATL90LA014Accident · No injuriesLimited investigationFinal reportCessna 150K · Vine Grove, KYInadequate preflight planning/preparation by the student pilot, which led to fuel exhaustion due to an inadequate supply of fuel. The pilot's failure to attain the proper touchdown point during the landing and the parked airplane were contributing factors.NTSB ATL90LA013Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kinston, NCThe pilot's decision to depart for his destination airport with less than required fuel, and his improper use of the communications radio which resulted in his circling the airport and exhausting all fuel.NTSB MKC90LA015Accident · No injuriesLimited investigationFinal reportCessna 150 · Cherokee Vill, ARThe pilots failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.NTSB FTW90LA014Accident · No injuriesLimited investigationFinal reportCessna T-337G-P · Laredo, TXDouble engine failure due to fuel exhaustion. The fuel exhaustion was caused by incorrect inflight fuel consumption calculations and one inaccurate fuel quanity gauge. Contributing to the accident was the dark night restriction to visibility.NTSB MKC90LA011Accident · No injuriesLimited investigationFinal reportCessna 172Q · Hiwasse, ARThe pilot's failure to properly plan the flight and insure that there was sufficient fuel to complete the flight. The pilot also failed to monitor the fuel level during the flight.NTSB NYC90LA015Accident · No injuriesLimited investigationFinal reportRobinson R22 · Bethpage, NYThe pilot's improper handling of the helicopter during a power off autorotation resulting in a hard landing and a main rotor blade severing the tailboom. Contributing to the accident were a gusty wind and the pilot's improper operation of powerplant and…NTSB MIA90LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Immokalee, FLImproper planning/decision by the pilot, which resulted in fuel exhaustion. Factors related to the accident were: the pilot becoming lost or disoriented, and the tree(s) in the emergency landing area.NTSB MKC90LA008Accident · No injuriesLimited investigationFinal reportCessna P210 · Waterloo, IAFuel exhaustion, due to poor planning/decision, and fuel consumption calculations misjudged by the pilot in command. The fact that the runway lights were not operating & the accident occurred at night were contributing factors.NTSB BFO90LA001Accident · Minor injuriesLimited investigationFinal reportBeech A65 · Friendly, MDThe pilot's improper use of his fuel supply, which resulted in fuel starvation and loss of power in the left engine. A factor related to the accident was the pilot's lack of familiarity with the aircraft.NTSB ANC90LA006Accident · No injuriesLimited investigationFinal reportCessna 185 · Tuluksak, AKMounting shaft (airbox through-shaft) for the throttle and mixture controls had become loose and backed out, which resulted in loss of engine power. Factors related to the accident were: darkness and rough terrain.NTSB SEA90LA006Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · Homedale, IDInaccurate preflight planning and fuel consumption calculations by the pilot, and the pilot becoming lost or disoriented which resulted in fuel exhaustion.NTSB ANC90LA005Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Near Cold Bay, AKImproper use of carburetor heat by the pilot, which resulted in loss of engine power due to carburetor ice. Carburetor icing conditions and high vegetation in the forced landing area were contributing factors.NTSB CHI90DEE01Accident · Serious injuriesFinal reportBaker/Santiago Pitts S-1S · Dekalb, ILImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.