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 NYC89LA098Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Bethel, NYImproper planning/decision by the pilot concerning his fuel management, which resulted in fuel exhaustion due to an inadequate supply of fuel. The false indication from the fuel quantity gage(s), dark night, and trees were considered to be factors.NTSB ANC89LA052Accident · No injuriesLimited investigationFinal reportCessna 185E · Alexander Lake, AKThe pilot's improper in-flight planning, decisions which resulted in exceeding the amount of fuel available which resulted in fuel exhaustion.NTSB ATL89LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blountville, TNCarburetor ice. The pilot failed to apply carburetor heat in a timely and adequate manner. This failure resulted in the accumulation of ice to a point of failure of the engine which eliminated the heat necessary to remove the ice.NTSB FTW89LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Bastrop, TXInadequate preflight planning and preparation by the pilot which resulted in fuel exhaustion. Contributing to the accident were the low ceilings and fog.NTSB ATL89LA094Accident · No injuriesLimited investigationFinal reportCessna 150G · Springboro, OHLoss of power (takeoff) from carburetor ice due to improper use of carburetor heat during extended ground operation using auto fuel in weather which was conducive to icing.NTSB FTW89LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Temple, TXImproper planning/decision, by the pilot which resulted in fuel exhaustion, due to an inadequate supply o fuel.NTSB FTW89DQA01Accident · Minor injuriesFinal reportIntermountain Mfg. Callair A-9B · El Paso, TXEngine failure due to the pilot's failure to select the fullest tanks and, failure to maintain adequate flying speed.NTSB MKC89LA065Accident · No injuriesLimited investigationFinal reportComposite Aircraft Mfg Cozy · Hudson, IAImproper preflight by the pilot which resulted in an inadequate fuel supply and fuel exhaustion.NTSB CHI89DEV05Accident · No injuriesFinal reportCessna 182A · Sparta, ILPoor and improper maintenance which resulted in the carburetor venturi being blocked by the duct tape. Contributing to the accident was the soft terrain on which the forced landing was made.NTSB FTW89LA052Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Austin, TXThe pilot's inaccurate fuel consumption calculations and improper positioning of the fuel tank selector valve.NTSB MKC89LA057Accident · No injuriesLimited investigationFinal reportCessna 150 · Wayland, MOThe pilot becoming lost during the flight which resulted in fuel exhaustion.NTSB ATL89LA085Accident · No injuriesLimited investigationFinal reportCessna 177B · Oneonta, ALInadequate preflight by the pilot and fuel exhaustion. Trees contributed to the aircraft damage.NTSB ATL89DKG01Accident · No injuriesFinal reportGrumman G-164A · Dawson, GATotal loss of engine power due to leaking carburetor float. Contributing to the accident was the soft terrain used for a forced landing.NTSB MIA89GA082Accident · Minor injuriesFinal reportCessna T210L · Melbourne, FLFailure of the pilot to accurately determine fuel quantity prior to departure followed by his failure to operate the engine on the fullest fuel tank resulting in a fuel tank being run dry resulting in engine failure while on short final approach at his…NTSB MIA89FA078Accident · Serious injuriesField investigationFinal reportBeech A23-24 · Clearwater, FLFuel starvation due to the CFI depleting the fuel supply from one of two tanks and failing to select the fullest tank for landing. Contributing to the accident was the cfi's improper decision to turn back to the airport when insufficient altitude was…NTSB NYC89LA078Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Kennebunk, METhe pilot's failure to assure the fuel selector was properly positioned which resulted in fuel starvation and the subsequent forced landing.NTSB LAX89LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Martin, CAEngine failure due to a loose spark plug with the reminaing plugs fouled with carbon deposits.NTSB LAX89LA097Accident · No injuriesLimited investigationFinal reportBeech E33 · Parlier, CAThe pilot's improper in-flight planning/decision to continue to the destination airport after encountering a restrictionof fuel flow from the right tank and subsequent fuel starvation when the left tank emptied. Contributing factors were the blocked fuel vent…NTSB FTW89LA043Accident · No injuriesLimited investigationFinal reportHiller OH-23B · Wichita Falls, TXThe pilot's improper use of the carburetor heat during flight and his improper flare during an autorotative landing. Contributing factors were: carburetor icing conditions, improper in-flight planning/decision by the pilot, a tailwind during the landing, and…NTSB CHI89GA048Accident · 2 fatalFinal reportPiper PA-28-180 · Chicago, ILInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: high obstructions and retaining wall in the emergency landing area.NTSB DEN89FA064Accident · Minor injuriesField investigationFinal reportConvair 580 · Buena Vista, COInadvertent deactivation of fuel to the left engine as the pilot was making a precautionary shutdown of the right engine, and his failure to follow the emergency checklist procedure. Related factors were: low gearbox oil pressure (at flight altitude), and…NTSB BFO89LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Elkview, WVInadequate preflight by the pilot and inadequate crew/group coordination by the flight leader (CFI), 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…NTSB NYC89LA069Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Bridgeport, CTThe improper fuel selector position and loss of power to the engine due to fuel exhaustion.NTSB MKC89LA054Accident · No injuriesLimited investigationFinal reportBeech C-23 · Greenfield, IAThe pilot's failure to assure an an adequate supply of fuel was on board in order to complete the flight.NTSB MIA89FA065Accident · No injuriesField investigationFinal reportBritten-Norman BN-2A · Carolina, PRFuel exhaustion and the failure of the pilot to insure that the proper fuel load was placed on the aircraft for the flight. Contributing factors included the improper refueling of the aircraft, improper initial training of the refueler and the crop, which…NTSB FTW89DRD02Accident · Minor injuriesFinal reportPiper PA-25-235 · Bogalusa, LAThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB LAX89LA084Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Westlake, CAImproper planning and decision by the pilot which resulted in fuel exhaustion. Contributing factors were: faulty fuel indication, utility pole & uneven terrain.NTSB CHI89LA044Accident · No injuriesLimited investigationFinal reportCessna 150J · Osceola, WIInadequate preflight by the student pilot, inadequate supervision (to assure a proper preflight) by the instructor pilot (CFI), and water contamination of the fuel. The terrain was considered to be a contributing factor.NTSB NYC89LA065Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Albany, NYFuel exhaustion resulting from the pilot's inadequate in-flight planning and misjudged fuel consumption.NTSB DEN89FA061Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Albuquerque, NMEngine stoppage from fuel starvation which resulted from the pilot's failure to select the fullest tank for takeoff. In addition the pilot attempted to return to the airport during the forced landing and inadvertently stalled the aircraft during the…NTSB FTW89LA040Accident · No injuriesLimited investigationFinal reportBeech V35B · Pawhuska, OKFuel tank selector valve being inadvertently switched off and the pilot's emergency procedures inadequate in discoveringand correcting the problem. This resulted in the fuel starvation related power loss. Contributing to the accident was the rough terrain on…NTSB ATL89FA066Accident · 1 fatalField investigationFinal reportPiper PA-31 · Springfield, OHFuel exhaustion precipatated by the inadequate fuel consumption calculations performed by the pilot, pressure from the company president to not carry excess fuel and improper in-flight planning/decisions by the pilot by not refueling enroute before fuel was…NTSB FTW89LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Austin, TXThe pilot did not have an adequate fuel supply to complete the flight. The plts flt planning was inadequate and the ignored opportunities to obtain fuel enroute led to fuel exhaustion, prior to reaching destination.NTSB DEN89LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Erie, COThe pilot said that he made a normal preflight and engine runup prior to takeoff on runway 33 at the tri-county airport, Erie, Colorado. A normal takeoff was made but he said that as the aircraft reached 200 feet, the engine lost about 400 RPM. When he…NTSB NYC89LA061Accident · No injuriesLimited investigationFinal reportNavion NA-1 · Allentown, PAThe pilot stated that he experienced a loss of power shortly after takeoff and landed back on the runway. The landing was hard and the right wing was damaged. The FAA investigator checked the engine and fuel system for possible contaminants and water. No…NTSB DEN89LA050Accident · No injuriesLimited investigationFinal reportCessna 152 II · Gilcrest, COThe plt, with his wife as a pax, departed greeley, CO, on a cross-country flt to clayton, NM. After landing, the pilot had his aircraft refueled. It took 23.5 gallons of fuel to fill the fuel tanks. The plt then took off, flew 46 miles southeast, then turned…NTSB MIA89LA059Accident · No injuriesLimited investigationFinal reportCessna 177A · West Palm Beach, FLThe private pilot contacted lakeland tower in flt about 2115 and was told that no fuel was available. He elected to continue flt. The pilot experienced an engine failure due to fuel exhaustion after 4 hours and 12 minutes of flight. He then executed a forced…NTSB FTW89LA033Accident · Serious injuriesLimited investigationFinal reportCessna TU206D · Alamo, TXAirplane's collision with trees and terrain during an attempted forced landing at night following an engine faiure. The engine failure was caused by fuel starvation as a result of a faulty fuel system which the operator had failed to correct.NTSB CHI89LA037Accident · No injuriesLimited investigationFinal reportCessna P210R · Grovertown, INNTSB ATL89DKJ01Accident · Serious injuriesFinal reportSloan RV-4 · Russellville, ALWhile cruising at 2500 feet with ram air gate open, engine began to run rough. The plt closed the ram air gate and applied carb heat but the engine continued to run rough and then stopped. The pilot attempted to land in an open field, clearing several large…NTSB NYC89LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-44-180T · Princeton, NJThe acft experienced a loss of power of both engines and crashed into trees near Princeton airport, Princeton, NJ. The pilot flew 4.5 hrs and after a missed approach one engine quit. While attempting to make Princeton airport the other engine quit. According…NTSB LAX89LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Victorville, CADuring cruise flight, the engine lost power. The pilot initiated a forced landing on an interstate. During the descent, the airplane collided with transmission wires and subsequently came to rest on interstate 15. During an inspection of the wreckage, it was…NTSB ATL89LA060Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Gilbertsville, KYDuring preflt inspection fuel was noted to be up to the slots in the tab for the reduced fuel indicators, or 20 gal each tank. A 3 hour, dark night, cross country was flown to destination. PIC said acft arrived with about 5 gal fuel remaining in each tank. On…NTSB FTW89LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Houma, LAThe airplane was on an IFR flight plan but was in VFR conditions when the communications radios failed. Pilot used hand held transceiver, but communications were not satisfactory. Pilot elected to continue to destination but did not declare an emergency nor…NTSB CHI89DET02Accident · No injuriesFinal reportCessna 150H · Benton Harbor, MIA misjudged approach during the execution of an emergency landing resulting in an encounter with unsuitable terrain. Contributing factors are inaccurate fuel consumption calculations and fuel starvation due to contamination.NTSB CHI89LA033Accident · No injuriesLimited investigationFinal reportCessna 414 · Pontiac, MINTSB NYC89LA051Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stacyville, METhe student pilot became lost during a cross country flt. The flight was continued until the acft ran out of fuel. The aircraft collided with trees during an emergency landing and nosed over. The plt told the state police at the acc site that the acft had run…NTSB MKC89LA039Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Rolla, MOWhile returning from a personal cross country flight, the newly certificated private pilot said that the winds picked up and he was blown 30 miles east of his intended course. In addition, he was running one hour over the time allotted for the trip. He landed…NTSB LAX89FA064Accident · 2 fatalField investigationFinal reportCessna T210L · Buena Park, CAThe pilot used poor judgement in beginning the flight with inadequate fuel; his failure to follow normal v.f.r. procedures; and his poor preflight inspection.NTSB CHI89DEE01Accident · No injuriesFinal reportCessna 210L · Bannock Burn, ILFuel starvation caused by ice blocked fuel lines.