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 MKC88FA067Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Excelsior Spgs, MODuring arrival at night, after using fuel from the inboard tanks, the plt switched to the outboard fuel tanks. Shortly, thereafter, both engs lost power. The plt declared an emergency & obtained vectors to the nearest airport, but was unable to reach it.…NTSB MIA88LA128Accident · No injuriesLimited investigationFinal reportCessna 150H · Pensacola, FLThe 3.8 hr cross country flt was uneventful, but after the flt entered the downwind leg of the traffic pattern for landing, the eng quit due to fuel exhaustion. During the forced landing the acft collided with trees & came to rest.NTSB LAX88FA130Accident · Serious injuriesField investigationFinal reportDornier DO-24 · Oildale, CAPilot's improper fuel consumption calculations and his failure to properly use the mixture control.NTSB MIA88FA127Accident · 1 fatalField investigationFinal reportMooney M-20J · Fernandina Bch, FLThe private pilot flew a flight that consumed about 31 gallons of fuel from a 31 gallon tank. The other fuel tank still had 31 gallons of fuel. The engine failed on base leg and the aircraft crashed in a wooded area. The pilot did not switch the fuel selector…NTSB LAX88LA128Accident · No injuriesLimited investigationFinal reportCessna 150M · Lodi, CAOn the day of the accident, the pilot departed lancaster, California, flew to fresno to pick up a passenger and then continued on to Lodi, the ultimate destination. While being vectored toward the airport at Lodi, the engine quit and the aircraft collided…NTSB MIA88LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Jacksonville, FLThe pilot stated that he did not visually check the fuel quantity prior to departure on an aerial photography flight. About .9 hours after takeoff the engine failed due to fuel exhaustion. The pilot executed a forced landing and the aircraft crashed. Both the…NTSB ATL88LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Orangeburg, SCThe engine lost pwr as the airplane was returning from a fire-patrol flt. The plt made a forced ldg in a field where the airplane ran into soft dirt and nosed over. Post-crash exam of the acft revealed no evidence of any fuel ramaining in the fuel system. The…NTSB MKC88LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mound City, MOThe PIC, after an earlier lndg at tarkio, Missouri and an unsuccessful attempt to reach his fishing partner, flew his acft to and landed at st. joseph rosecrans arpt. After contacting his friend, and catching a few hours of sleep, the PIC made an early…NTSB ATL88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Cleveland, OHThe plt rptd that both engines began to surge shortly after t/o during climb. The engines subsequently lost pwr completely, and the plt made a forced ldg in trees. Post-crash exam revealed that the fuel selectors were in the inbd tank positions. The lt inbd…NTSB LAX88LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Hesperia, CANTSB ATL88IA102Incident · No injuriesIncident investigationFinal reportGovernment Aircraft Fact Nomad N22B · Birmingham, ALNTSB DEN88DTM01Accident · Serious injuriesFinal reportCessna 188 · Riverton, UTThis ag operator was fertilizing a field. He was making repetative trips which took about 10 min each. The plt was aware that the fuel gauges were inaccurate, reading less fuel than was actually onboard. While making a swath run the eng lost pwr and the acft…NTSB ATL88DMG03Accident · Minor injuriesFinal reportThorp T-18 · Advance, NCNTSB MKC88LA055Accident · No injuriesLimited investigationFinal reportCarter Quickee 2 · Springfield, MOWhile flying a homebuilt aircraft, under experimental category, the pilot experienced an engine failure. An emergency ldg was made on a highway, and during the ldg roll the acft struck some marker barrels, suffering substantial damage. The pilot said the…NTSB LAX88LA116Accident · No injuriesLimited investigationFinal reportBeech F35 · Pacoima, CAThe plt rprtd that he had initially psnd the fuel selector (sel) to the left main tank. He said that after abt 1 hr of flt (near palmdale, CA), he psnd the sel to the rgt main tank for a short time, then (near Pacoima), he moved it back to the left main tank.…NTSB BFO88FA024Accident · 2 fatalField investigationFinal reportCessna 177RG · Ellamore, WVAprx 3 hrs and 26 minutes after takeoff from republic airport, the plt reported having engine problems. Unable to make it to an airport, the plt radioed that he was going to attempt to land on a road. The airplane struck trees and crashed in a wooded area…NTSB MIA88IA112Incident · No injuriesIncident investigationFinal reportCessna 182 · Stuart, FLWhile on final apch to land from a banner towing flt, the eng lost power due to fuel exhaustion. The plt made an emergency landing off the airport, but the nose gear collapsed, which resulted in minor damage.NTSB DEN88LA080Accident · Minor injuriesLimited investigationFinal reportCessna TU-206 · Durango, COWhile on a cross country flight the plt ran short of fuel and altered course to another airport. The pilot said the acft engine failed short of the new destination due to fuel exhaustion. The plt performed an emergency landing in an open field and the acft…NTSB ATL88LA095Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, ALThe pilot had just purchased the aircraft and it had less than one hour on the overhauled engine. The pilot was at 1500 feet when the engine quit. On final approach to the emergency landing area, the aircraft collided with trees. The engine examination…NTSB FTW88DRG05Accident · No injuriesFinal reportAir Tractor 301 · Circleville, TXThe airplane was being ferried to a new location, and an en route refueling stop was planned. A low ceiling and low visibility set in and the pilot tried to extend the flight to a different town. The fuel was exhausted 6 miles short of a town. The airplane…NTSB FTW88LA062Accident · No injuriesLimited investigationFinal reportCessna 170B · Crowley, TXThe engine stopped as a result of fuel starvation, due to a large amount of contamination throughout the fuel system. The source of the contamination and the length of time it had been in the system was not determined. The pilot was not in gliding distance of…NTSB FTW88LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe pilots experienced a sudden total and complete loss of engine power during climbout after takeoff. Suitable terrain for a safe landing was not available and the aircraft was damaged during landing on a golf course. Examinations of the aircraft and engine…NTSB FTW88LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · San Antonio, TXThe pilot experienced a complete loss of engine power while on the final approach. The damage to the aircraft occurred when he had to land on unsuitable terrain during the forced landing. Examination of the aircraft fuel system showed that a fuel line to the…NTSB LAX88DVM01Accident · No injuriesFinal reportBeech M35 · San Jose, CADuring a pleasure flight, while on final approach to the airport, the engine quit. The pilot made a forced landing in a shopping center parking lot, where the aircraft collided with three parked vehicles. Inspection of the engine did not identify any…NTSB ATL88LA087Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Liberty, NCThe plt rptd that he overestimated the amount of fuel on board the acft prior to departure. The engine subsequently lost pwr at cruise due to fuel exhaustion. A forced ldg was made in a field. During the rollout, the airplane vaulted the crest of a small hill…NTSB FTW88LA059Accident · No injuriesLimited investigationFinal reportCessna 182P · Weatherford, TXA used eng had just been installed in the acft and the owner and mech were performing a functional test flt. Shortly after takeoff at about 300 ft AGL, the eng lost power. The plt pumped the throttle and the eng restarted but immediately quit again and would…NTSB MIA88FA097Accident · Serious injuriesField investigationFinal reportTimm N2T-1 · Pompano Beach, FLPilot experienced complete loss of engine power while on short final. While making forced landing on a city street the acft collided with a car. Post crash examination of the acft and crash site revealed the acft to contain approx. 3 ounces of fuel with no…NTSB LAX88IA102Incident · No injuriesIncident investigationFinal reportFairchild SA227AC · S. Lake Tahoe, CACaptain's failure to follow flight manual procedures in the operation of the anti-ice/de-ice systems.NTSB ATL88FA085Accident · Serious injuriesField investigationFinal reportBell 204B · Stockton, ALNTSB LAX88LA100Accident · No injuriesLimited investigationFinal reportCessna 150F · Lake Havasu Cty, AZDuring a pleasure flt, while on final approach, the engine experienced a pwr loss. An emergency landing was made short of the rwy where the acft collided with a telephone pole, slowing the acft during the landing roll. Inspection of the engine revealed that…NTSB LAX88LA097Accident · No injuriesLimited investigationFinal reportCessna 150 · Redbluff, CADuring a cross country flt, the engine experienced a complete pwr loss. The plt made a forced landing where the acft collided with the terrain 1 mile short of the rwy. Inspection of the acft revealed that the fuel tanks were near empty. There were no reported…NTSB SEA88LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kennewick, WAAt about 75 feet AGL a total loss of power occurred. The plt landed on the remaining runway but overran the rwy, coming to rest 200 ft beyond the end. During the overrun, the nose gear struck a rock and the acft nosed over. The aircraft's fuel tanks contained…NTSB BFO88FA014Accident · No injuriesField investigationFinal reportCessna T210N · Sterling, VAAbt 2.7 hrs after takeoff, the student plt & instructor (CFI) were practicing instrument apchs when the eng lost pwr. The CFI took control of the acft & made a forced lndg, but the acft was damaged on rough terrain. An exam of the acft revealed the right &…NTSB BFO88LA015Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Danville, VAEngine power loss occurred when the acft was in the traffic pattern. The plt made a forced landing in an open field about 2 miles from the airport. The investigation disclosed less than 1 gal of fuel in the selected rt tank.NTSB MIA88LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · San Juan, PRThe pilot, while on an on-demand air taxi flight, switched to an empty fuel tank in preparation for landing and the engine failed. The pilot then executed a forced landing to the grass short of the runway and the landing gear failed.NTSB NYC88LA066Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Stowe, VTThe Cessna 210 took off and shortly thereafter experienced a loss of power. The pilot was unable to get the engine restarted and made an off-airport landing in a grove of trees. On-scene examination by the FAA showed that the fuel selector was on the left…NTSB ANC88LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Anchorage, AKThe pilot had selected the left auxiliary fuel tank for takeoff. During the climbout the engine quit; the aircraft crashed short of a private airstrip. The pilot stated that he ran the left auxiliary fuel tank dry and did not select another fuel tank with the…NTSB ATL88LA079Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Fayetteville, NCThe student plt rptdly became lost on a solo x-c flight, and was unable to locate her destination arpt. She subsequently obtained radar vectors to another arpt. The airplane subsequntly lost power while on final appch to the arpt, and the airplane crashed…NTSB ATL88LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Carolina Beach, NCThe aircraft sustained substantial airframe damage when the acft collided with the ground following an aborted t/o. the instructor reported that the student pulled the throttle back after the aircraft broke ground. The instructor attempted to recover, but the…NTSB NYC88LA054Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Honesdale, PAShortly after takeoff from runway 35 at cherry ridge airport, Honesdale, Pennsylvania, the aircraft experienced an engine power loss and crashed about 200 feet off the end of the runway. Examination of the aircraft after the accident revealed no fuel in the…NTSB LAX88DUG01Accident · Minor injuriesFinal reportSmith DSA-1 · Upland, CAThe pilot reported that he had performed a moderate to severe 'noseover' at 4000 ft AGL. The engine started to run rough and then quit. The pilot stated that he had performed maintenance on the carburetor just prior to this flight. An emergency landing was…NTSB MIA88LA082Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Tampa, FLAfter preflighting the acft, 30.8 gal of fuel were added. No further insp was performed. The flt took off after an eng runup was accomplished. No problems were noted. During the initial climb of the first touch-and-go landing, at an alt of aprx 75 ft, the eng…NTSB ATL88FA073Accident · Serious injuriesField investigationFinal reportCessna P210N · Huntsville, ALNTSB MIA88LA080Accident · Minor injuriesLimited investigationFinal reportBellanca 14-13 · Merritt Island, FLThe private pilot experienced a power loss after takeoff. He then collided with water after hitting a mast of a boat and a dock. The plt stated that he experienced carburetor ice prior to the eng quitting. The plt stated that on an earlier flt he had problems…NTSB LAX88LA078Accident · No injuriesLimited investigationFinal reportCessna 150K · San Andreas, CANTSB MIA88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLEn route to the destination during a cross country flt, the acft was diverted to an alternate arpt due to weather conditions below minimums. Unable to land at the alternate due to poor visibility the non-instrument rated plt requested vectors to the…NTSB ATL88FA069Accident · Serious injuriesField investigationFinal reportCessna 172M · Warner-Robins, GAThe non-ifr rated plt dptd in VFR wx. He subsequently encountered IFR wx several hrs after departure and attempted to continue on to his destination arpt in IFR conditions. He made several VOR approaches to the destination arpt. But was unable to visually…NTSB CHI88LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Mt. Pleasant, WIThe stu plt climbed to 1600 ft MSL aft tkof. Shortly aft level off, the engine stopped. He attempted an air start without success. During the forced lndg the nose wheel dug in and the acft nosed over in the soft soil. During a post crash interview, the stu…NTSB LAX88LA077Accident · No injuriesLimited investigationFinal reportCessna 150E · Hilo, HIDuring a local pleasure flt, while climbing to 5500 feet, the engine sputtered and quit. During the landing roll, the acft nosed over. The engine was examined with no mechanical failures or malfunctions noted. The acft was operating in the range of serious…NTSB LAX88LA076Accident · No injuriesLimited investigationFinal reportCessna 210K · Chowchilla, CADuring a cross country flt, the plt had diverted to another arpt for fuel. The plt was unable to activate the rwy lights and a forced landing was made that was perpendicular to the rwy. Upon inspection of the acft, an incorrect frequency was noted on the…