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 LAX82DA154Accident · Minor injuriesFinal reportHughes 269B · North Las Vegas, NVThe pilot ran out of fuel and autorotated to a hard landing. He stated the low fuel warning light never came on. He was going to use this as a signal to refuel. This would give about 15 minutes of cruise flight. The low level warning switch wiring was found…NTSB DEN82FA075Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Wheatland, WYThe acft struck a tree approximately 1/2 mi from the approach end of rwy 08. No fuel was on board the acft. The gear were down & the flaps were in the 10 deg position.NTSB CHI82DA148Accident · No injuriesFinal reportBeech C35 · Dillsboro, INThe aircraft operated normally during taxi, run-up, takeoff, and climb to 3500 ft MSL. About 17 miles from the departureairport, the engine stopped running. During a forced landing in a dirt field, one of the main gear failed. The propellerseparated and the…NTSB ATL82DA118Accident · No injuriesFinal reportPiper PA-18A · Timmonsville, SCThe pilot reported that he reduced power at 1000 ft and applied carburetor heat for an extended glide to the sod strip. While on final approach over a wheat field, the airspeed bled off and he moved the throttle to add power. However, he reported that the…NTSB LAX82DA152Accident · Serious injuriesFinal reportCessna 175A · Lathrop Wells, NVThe aircraft's engine quit while on approach to Lathrop Wells. During the emergency landing the aircraft stalled and dropped from about 15 feet AGL and came to rest inverted. Fuel was present at the accident site and the fuel selector was found midway between…NTSB NYC82DA081Accident · No injuriesFinal reportMooney M20J · Madison, CTThe pilot reported that during takeoff, the engine lost power at about 30 ft AGL. He switched tanks and checked that the boost pump was on, but the engine did not restart. The plane was landed in a marsh where it flipped over during touchdown. An inspection…NTSB CHI82DA140Accident · No injuriesFinal reportBeech BE-19 · Ridgeville, WIThe student pilot departed oshkosh, WI on a round robin cross country flight. The flight was destined for rockford, IL, lacrosse, WI and oshkosh. The aircraft departed oshkosh with full fuel tanks and was not refueled en route. The total duration of the…NTSB DEN82DA072Accident · No injuriesFinal reportEnstrom 280-C · Granger, WYThe aircraft's engine backfired and quit during takeoff. The pilot cleared a fence and during the forced landing the gear collapsed. No engine malfunction or failure could be found.NTSB ATL82DA114Accident · No injuriesFinal reportCessna 172E · Society Hill, SCThe engine quit at 4000 feet and the pilot elected to land in trees rather than a road with traffic. The aircraft ended up on small gravel road with the gear collapsed. No fuel was found in the aircraft.NTSB CHI82DA137Accident · No injuriesFinal reportCessna 150 · Blaine, MNWhile on final approach the pilot stated that the engine lost power. The aircraft landed about 700 feet short of the runway in rough terrain. Investigation disclosed at least 1 1/2 pints of water in the left fuel tank, water in the carburetor bowl, and the…NTSB FTW82DA143Accident · No injuriesFinal reportBeech A60 · Garland, TXThe plane had been involved in a bankrupcy settlement and had not been flown for about 3 1/2 mths. The pilot had been sent to ferry the plane. During a run-up before takeoff, the propellers moved toward a feather position without pilot input. The pilot had a…NTSB CHI82DA130Accident · No injuriesFinal reportCessna 150 · Gary, INThe aircraft engine quit on final approach to landing at Gary municipal. A forced landing was made on a street and the aircraft collided with a street sign before nosing over into a ditch. The aircraft operator examined the aircraft at thescene and said the…NTSB FTW82FA137Accident · 3 fatalField investigationFinal reportPiper PA-31-350 · San Antonio, TXThe pilot was trying to land after both engines failed during takeoff after the aircraft was refueled with jet fuel instead of gasoline. The weather was IFR with fog, low ceiling and rain. The aircraft collided with trees during a forced landing and was…NTSB CHI82FA127Accident · 5 fatalField investigationFinal reportCessna 411 · Middlefield, OHThe purpose of the flt was to prepare for a FAA part 135 air taxi check ride which was scheduled later that week. The acft was observed during the approach with one eng shut down. During the turn to final the acft crashed 1/2 mi from rwy 28.NTSB LAX82DA137Accident · No injuriesFinal reportAvres S-2R · Kettleman City, CAThe pilot stated that the fuel gauge was faulty so he flew by time. On the day of the accident the battery on the pilot's electric watch ran down. The pilot reported that the aircraft ran out of fuel and crashed in an open field with his watch still showing…NTSB LAX82DA159Accident · No injuriesFinal reportGrumman AA-5B · Paulden, AZDuring a simulated forced landing after following the prescribed restart procedures the student, under the supervision of the instructor, executed her securing procedures. It was the instructor's policy to let the student actually move the proper control then…NTSB ATL82DA101Accident · No injuriesFinal reportPiper PA-25-235D · Baxley, GADuring takeoff, the engine lost power at about 75 ft AGL. The pilot jettisoned his load of pesticide and landed straight ahead on the remaining runway. The plane continued off the end of the runway, ran into a drainage ditch, and was substantially damaged.…NTSB FTW82DA129Accident · No injuriesFinal reportQuickie · Cleveland, TXAfter taking off with full power, the pilot turned left to a crosswind position. Shortly thereafter, he noticed a partial power loss and turned further left to a downwind. From this position, there was a powerline between him and the runway. He elected to…NTSB MKC82FA055Accident · Serious injuriesField investigationFinal reportMartin-Pitts S1S · Grain Valley, MOThe plt estimated the fuel gauge indicated about 10 gals during preflight. The fuel gauge is a clear tube extending from the bottom of the tank up the right side of the cockpit. A dipstick was not available. The plt flew to liberty, MO made two landings &…NTSB LAX82DA132Accident · No injuriesFinal reportCessna 150 · Tuscon, AZThe pilot stated that he filled the fuel tanks with 22 gallons of fuel. Three hours and 15 minutes after takeoff, he ran out of fuel. He made a forced landing about 1.5 miles from the intended destination and encountered desert shrubbery.NTSB SEA82DA049Accident · No injuriesFinal reportPiper PA-28-181 · Spokane, WAStudent pilot/copilot reset the aircraft clock in anticipation of the time zone change that would occur in flight. This caused the pilot to think he had another hour of flight time. In addition the fuel gage was found to show fuel in the right tank when all…NTSB SEA82DA048Accident · No injuriesFinal reportPiper PA-25-235 · Basin City, WADuring a return trip to the landing area from a dusting run the engine stopped. The main landing gear caught wires during an attempted landing to a field and the aircraft turned over before colliding with the ground. The fuel tanks were found empty and the…NTSB ATL82DA097Accident · No injuriesFinal reportCessna 172 · Brook Haven, MSThe pilot visually checked the fuel level before takeoff and estimated that he had 15 to 16 gallons remaining. Since the flight was planned for 30 to 45 minutes, no fuel was added. However, after flying for 30 to 35 minutes, the engine lost power. The pilot…NTSB SEA82FA046Accident · Serious injuriesField investigationFinal reportCessna 177RG · 10 East Of Till, ORDuring flight at 13,000 ft MSL, the engine began losing power. The aircraft was vectored toward the prospect airport near tiller, Oregon. However, about two minutes later, all engine power was lost. During a forced landing, the aircraft struck a dead…NTSB MIA82FA092Accident · Minor injuriesField investigationFinal reportCessna 421B · Ft. Lauderdale, FLReportedly, the left engine quit during an approach to land while the aircraft was at about 500 ft AGL with the gear and flaps down. The pilot stated that he immediately checked the fuel selector handles to be sure they were both in the indent, which they…NTSB ATL82DA095Accident · No injuriesFinal reportPiper PA-24-250 · Tazewell, VAThe pilot stated that the engine failed at 8000 ft in clear air and level flight. He immediately attempted to switch the fuel selector to one of the two remaining full fuel tanks but the selector would not move. After repeated attempts to switch tanks using a…NTSB CHI82DA114Accident · Minor injuriesFinal reportCessna T210L · Detroit, MIThe pilot elected to land at an alternate airport when he encountered poor visibility and icing conditions. While receiving vectors to Detroit metro the pilot reported he was low on fuel and needed to land. During the approach the engine quit. The aircraft…NTSB NYC82DA068Accident · No injuriesFinal reportCessna 150M · Washington, CTWhile practicing power on stalls and gliding turns the pilot stated that the engine would not respond with half throttle. A forced landing was made after passing up two rough fields for a more distant one at a higher altitude. The pilot stated he should have…NTSB LAX82DA126Accident · No injuriesFinal reportCessna 206-F · Winters, CAAfter takeoff as the aircraft climbed through 550 feet AGL the engine lost power. The pilot attempted to turn the aircraft around and land on a taxiway but landed in a soft area near it. The nose gear collapsed and the aircraft slid across the taxiway and…NTSB DEN82DA052Accident · Minor injuriesFinal reportCessna 180K · Montrose, CODuring flight over mountainous terrain, the pilot encountered "horizontal snow squalls." He reported that he flew through the snow squall for about 25 miles while maintaining ground contact. He approached a cloud layer, but was able to fly over it at 16,500…NTSB FTW82DA105Accident · No injuriesFinal reportPiper PA-28-180 · Norman, OKThe aircraft's engine quit 15 minutes short of the destination on a cross country flight. The aircraft had 36 gallons of fuel on departure at 1600 CST and the accident occurred at 1915. A forced landing was made on a street in Norman, Oklahoma.NTSB LAX82DUJ30Accident · No injuriesFinal reportPiper 25 · Sacaton, AZDuring an aerial application procedure turn the aircraft's engine quit. The aircraft was crash landed in a field and was substantially damaged. Examination of the wreckage revealed there was no fuel in the fuel tanks and approximately one tablespoon of fuel…NTSB CHI82DA101Accident · Minor injuriesFinal reportCessna 150 · West Chicago, ILThe student and an instructor had previously flown this aircraft to recertify the student for solo flight. After the dual flight, the student had some problem with obtaining fuel and took off without refueling. While flying at night, the student became lost.…NTSB MIA82DA084Accident · No injuriesFinal reportRockwell Commander AC-100 · Chipley, FLThe student pilot/mechanic was attempting to fly the aircraft from where the owner kept the aircraft to the maintainance facility approximately 4 miles away. The pilot stated that just after level off the engine quit. A road was selected to land on but at the…NTSB CHI82DA097Accident · No injuriesFinal reportCessna 150 · Wheeling, ILThe student pilot departed Wheeling, IL on a cross-country flight to dubuque, IA; oshkosh, WI and return. The pilot refueled with 17.7 gallons of 100 octane low-lead gasoline at dubuque, but did not refuel at oshkosh. Near milwaukee, he noted that the right…NTSB LAX82DA114Accident · No injuriesFinal reportCessna 150 · Delano, CAThe student made a scheduled stop at lompoc, California, but was unable to obtain 80 octane fuel. He then flew to santa maria, California, which was not a part of his planned flight. He was also unable to get 80 octane fuel at santa maria. From there, he…NTSB MKC82DA046Accident · No injuriesFinal reportEnstrom F-28A · Parsons, KSThe pilot was rated in fixed wing aircraft, but he was a student pilot in helicopters. He had only 40 hours in rotorcraft. During a cross-country in his own helicopter, he ran out of fuel and struck trees during an auto-rotative landing. The pilot stated that…NTSB ATL82DA078Accident · Minor injuriesFinal reportMooney M20E · Alexandria, KYThe pilot reported that he had monitored the refueling operation, but did not actually uncap and check the fuel himself. He calculated that he had five hours of fuel on board. However, he ran out of fuel after using the right fuel tank for two hours and 30…NTSB ATL82DA073Accident · No injuriesFinal reportHiller UH12E · Lydia, SCThe pilot was applying liquid fertilizer on his last swath run prior to reloading when the engine stopped. A run-on landing was attempted during which the skids sank into the soft ground causing the helicopter to roll over. The field was level and covered…NTSB ATL82DA071Accident · Minor injuriesFinal reportBeech B24R · Pell City, ALWhile the pilot was making touch and go landings, the engine lost power as the aircraft was climbing through about 300 ft AGL. The pilot landed in a field with the landing gear up to reduce the stopping distance. No pre- impact malfunctions or failures were…NTSB ATL82DA070Accident · Minor injuriesFinal reportCessna 152 · Lusby, MDThe student was on a cross-country flight from leonardtown, MD to cumberland, MD to lancaster, pa and then return to leonardtown. Before takeoff, the student was instructed to refuel at cumberland or lancaster before continuing. The student stated that he had…NTSB ATL82DA069Accident · Minor injuriesFinal reportCessna 182P · Huntington, WVAccording to the pilot the engine failed after liftoff at about the 3500 foot point down the runway at approximately 300 feet AGL. The runway has 1000 feet of overrun and the aircraft came to rest near the runup area for runway 12. The aircraft had not been…NTSB CHI82DA084Accident · Serious injuriesFinal reportPiper PA-28 · Cambridge, MNThe pilot had expected that strong headwinds would decrease during flight; however, they continued. The pilot made an enroute stop for fuel, but after landing, he found that the airport was deserted. He stated that he recalculated the elapsed time, etc, and…NTSB ATL82DA068Accident · No injuriesFinal reportCessna 172N · Chamblee, GAThe engine lost power as the aircraft approached the destination airport. The pilot was unable to start the engine or glide to the airport. While attempting to land on a road, the pilot was able to avoid electrical wires; however, the right wing struck a pole…NTSB NYC82FFJ12Accident · Minor injuriesFinal reportPiper PA-32 · Syracuse, NYThe pilot took off on a VFR flight plan with a litter patient and 3 other passengers onboard. The right main fuel tank was used for about the first 30 minutes of flight, then the pilot switched to the left main tank. While en route, an IFR flight plan was…NTSB FTW82FA090Accident · Serious injuriesField investigationFinal reportCessna 150J · Bryan, TXAfter a touch & go on rwy 13 the eng failed. The CFI attempted a left turn back to rwy 32. During the turn the acft contacted a tree, then collided with the ground flipping the acft inverted. One quart of fuel was drained from the left tank & less than one…NTSB CHI82DA080Accident · No injuriesFinal reportCessna 150 · Charlestown, INThe pilot reported that he ran out of fuel on a cross-country flight. He made an emergency landing in an open field at night. During the landing, the plane flipped over on its back.NTSB ATL82FKG09Accident · 1 fatalFinal reportCessna 210D · Near Commerce, GAThe owner had flown a PA-23 from charlotte to jackson county,FL with another plt following him in N3909Y. The owner stated the other plt was very meticulous & always drained fuel prior to flt. After the 1 hr flt to jackson county, they both looked over the…NTSB MIA82IA066Incident · No injuriesIncident investigationFinal reportPiper PA-28-140 · Near Melbourne, FLThe aircraft had been in the practice area southwest of Melbourne, FL doing commercial flight check maneuvers for about 1 hour. According to the pilot, after completing his maneuvers he circled a lake once at 1000' AGL and then headed toward Melbourne. As he…NTSB ATL82DA067Accident · No injuriesFinal reportPiper PA-28-181 · Murfreesboro, TNThe pilot estimated his fuel consumption to be 10 gal/hr. The actual consumption was about 12 gal/hr. Approximately 20 miles from his destination, he decided to make an enroute stop for fuel. While turning to final approach for landing, the engine quit. From…