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 LAX83LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Oceana, CAThe student plt, a mexican national, was on a solo x-country flt. He reported that he could not locate the destination arpt at san luis obispo, CA. After circling the area, he saw the Oceana arpt & started to land. While on final apch, the eng lost power.…NTSB FTW83LA192Accident · Minor injuriesLimited investigationFinal reportCessna 210K · Austin, TXBefore taking off (at 1740) on his return flt, the plt got a wx briefing & checked the NOTAMS, but did not refuel the acft. There were no NOTAMS for the san marcos arpt. During arrival at san marcos, TX, no rwy lights were visible. The plt circled for 15 to…NTSB NYC83LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Norfolk, MAThe acft crash landed shortly after takeoff and was destroyed. The student pilot stated that after clearing the runway on his last takeoff of the day the engine hesitated and stopped. He lowered the nose to a glide speed of 70 mph picked aspot to land and…NTSB LAX83FA192Accident · 1 fatalField investigationFinal reportCessna 182P · Auburn, CAPrior to this flt, the acft had not been flown for two months or refueled in five months. During that period, it had been exposed to unusually heavy amounts of rainfall. An annual inspection had been completed on 1/12/82 & 77 hrs had been flown since that…NTSB NYC83LA092Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Waynesburg, PAThe pilot stated that following a normal takeoff, upon reaching an altitude of about 200 to 250 MSL, all eng power was lost. During an attempt to avoid trees at the end of the runway, for a clear area near a highway, the acft hit the top of a t-hangar. The…NTSB MIA83LA120Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Perry, FLThe acft made a forced landing in a swamp with the gear down and nosed over after both engines quit. The pilot said the acft was full of fuel at takeoff and yet it was empty less than an hour later. The pilot also did not know the quantity of fuel on board…NTSB LAX83LA198Accident · Minor injuriesLimited investigationFinal reportCessna 150J · San Jose, CAThe acft was rented for a x-country flt form San Jose, CA to san luis obispo & grover city, CA, then return to San Jose. The plt departed San Jose with full fuel tanks. At san luis obispo, 5.3 gal was purchased; however, no fuel was obtained at grover city.…NTSB NYC83LA089Accident · No injuriesLimited investigationFinal reportPiper J3C-85 · Spencer, MAThe pilot was warming the eng for a compression check and oil change in preparation for an annual inspection. He stated that he decided to fly the aircraft rather than run the engine on the ground. On tkof a high rate of climb was obtained and at 150 MSL the…NTSB MKC83FA087Accident · No injuriesField investigationFinal reportCessna 172 I · Paola, KSThe acrt crashed in a pasture after fuel exhaustion during an approach to johnson county industrial arpt. The acft had made a missed approach at his destination of Nevada MO. Enroute to a suggested alterate of butler arpt. The weather became worse and johnson…NTSB SEA83LA077Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · American Falls, IDThe acft was damaged in an off airport forced landing due to water in the fuel. The acft took off and at 3OO feet the left engine quit. The pilot was attempting a left turn back to the airport when the right engine started to sputter. Thepilot landed straight…NTSB LAX83LA181Accident · No injuriesLimited investigationFinal reportHiller UH12-E · Kettleman City, CAThe pilot reported that he began flying about 0725 with 23 gallons of fuel on board. He applied a herbicide for about an hour and came back to reload. After reloading he began a return to the area to be sprayed. About 10 minutes later all power was lost.…NTSB LAX83LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-300 · San Luis Obispo, CAThe acft departed rwy 29, & at about 200 ft AGL the eng was heard to sputter & surge. The acft was then observed in a steep left bank toward rwy 7. The wings leveled just prior to impact about 100 ft short of rwy 7. Arpt police personnel inspected the acft…NTSB DEN83FA091Accident · Serious injuriesField investigationFinal reportCessna 182H · Hayden, COThe acft collided with a powerline and crashed after the engine lost power on takeoff. According to witnesses the acft made a normal takeoff but during climbout the engine backfired and dark smoke came out. The acft turned left then steeply right before…NTSB MIA83LA118Accident · No injuriesLimited investigationFinal reportErcoupe G · Pempbroke Pines, FLThe acft collided with a tree during a forced landing after the engine lost power. Post accident investigation revealed that the fuel strainer was full of water and that the carburetor bowl contained one or two ounces of water. Draining of this water allowed…NTSB LAX83LA176Accident · No injuriesLimited investigationFinal reportCessna 182H · Ruth, CAAfter landing at Ruth, CA, the acft was refueled with aprx 38 gal of 80/87 octane aviation fuel. During takeoff, about 15 min after landing, the eng lost power as the acft was climbing thru aprx 200 to 300 ft AGL. The plt landed straight ahead in the best…NTSB FTW83LA179Accident · No injuriesLimited investigationFinal reportCessna 172M · Beaumont, TXAccording to the pilot he departed on a trip with an ete of 3.5 hours with an estimated 4.5 hours of fuel on board. After aprx 3.8 hours of flight the engine lost power and the pilot landed the acft on a service road. On rollout the left wing struck a highway…NTSB SEA83LA079Accident · No injuriesLimited investigationFinal reportErco 415C · Boring, ORThe aircraft collided with a fence and collapsed the nose gear during a forced landing after the engine lost power in cruise flight. The pilot had departed Oregon city earlier to fly to evergreen airport to fuel the aircraft and then to return to Oregon city.…NTSB LAX83LA183Accident · No injuriesLimited investigationFinal reportCessna T310R · Hilmar, CAThe acft lost power on the engines. Power was restored on only one engine and a precautionary landing was made off arpt in a field of alfalfa. The gear was not extended prior to ground contact. The pilot said he switched the fuel selector for power…NTSB MKC83LA085Accident · No injuriesLimited investigationFinal reportCessna 182F · Concordia, MOThe acft was forced to land in a wheatfield when the engine quit. The student pilot was on a solo cross-country flight cruising at 2000 feet when the engine lost power. The flt. Had started about 30 minutes before the accident. The dew point was 32 and the…NTSB ATL83LA148Accident · No injuriesLimited investigationFinal reportCessna 175 · Tuscaloosa, ALThe aircraft landed off the runway in soft terrain during a forced landing and nosed down. According to the pilot the engine began to run rough at 400 AGL on takeoff. He turned back toward the field and the engine quit. The pilot could not complete the turn…NTSB LAX83IA174Incident · No injuriesIncident investigationFinal reportDouglas DC-9-82 · 20n Bryce, UTWhile cruising at FL 350 the flt experienced a flame-out of both engines. The crew declared an emergency to salt lake artc center & the flt was vectored toward page,AZ for a possible emergency landing. At 12,200 ft the captain restarted both engines by…NTSB ANC83LA065Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Palmer, AKAccording to the plt's accident report, he had climbed to 3200 ft, pulled the throttle full back to descend, then the eng stopped. He stated that he tried to start the eng, but was unable, so he landed straight ahead in trees. The acft was destroyed during…NTSB MKC83LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Anthony, KSThe aircraft crashed during a forced landing after engine failure. It was determined during inspection after the accident that the fuel remaining in the aircraft was mostly water. The pilot during preflight had drained the fuel sumps and did not find any…NTSB MIA83FA101Accident · Serious injuriesField investigationFinal reportCessna C-337C · Silver Springs, FLThe acft collided with trees during an attempted go-around during a night operation. The plt had just recently acquired the acft and he was accompanied by his wife at the time of the accident. The plt lacked certification in the acft. Witesses heard the…NTSB LAX83LA163Accident · No injuriesLimited investigationFinal reportCessna 188 · Stanfield, AZThe rated commercial plt was on a solo instructional flt while in training for aerial application. He stated that before the accident, he had visually checked the fuel load & thought there was sufficient fuel for the flt. He took off, sprayed a load of water,…NTSB LAX83FUJ12Accident · Serious injuriesFinal reportCessna 182B · Benson, AZThe acft collided with a tree following a power loss during a low pass over a remote open area. The pilot and his wife were on a local pleasure flt when he decided to make a low pass over an area. During a 2nd pass over the same area when he applied the power…NTSB CHI83LA151Accident · No injuriesLimited investigationFinal reportBeech A-36 · Columbus, OHThe aircraft landed in a field about 1 mile from the approach end of the runway after engine stoppage during final approach. No malfunction of the engine was found during examination. The pilot stated he had flown about 3 hrs and 20 minutes. The hobbs meter…NTSB NYC83LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Syracuse, NYThe aircraft made an emergency landing on a golf course after the engine quit on final approach to Syracuse, NY. The acft had departed van wert, oh at 1350 and stopped for about 20 minutes at columbus, oh to pick up a passenger at 1445. The pilot contacted…NTSB ATL83LA153Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Shelbyville, TNThe acft collided with a power line during a forced landing after power loss due to fuel exhaustion. The acft was on thefinal approach. The pilot said he would be landing short of the rwy. When asked the nature of his emergency he said 'I think I am running…NTSB ATL83LA143Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Waycross, GADuring flt, the plt encountered strong headwinds & decided to divert to Waycross, GA. While using fuel from the right tank, the engine quit due to fuel starvation. The plt stated that this surprised him since the right fuel gauge needle was only slightly…NTSB SEA83LA067Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Bremerton, WAThe aircraft collided with a tree stump during a forced landing after the engine quit during entry into the traffic pattern. When the engine stopped the pilot felt he could not make the airport and chose a field to land in to avoid trees on the final approach…NTSB LAX83LA151Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Marana, AZThe acft nosed over during an emergency landing in an open field. The weather was VMC and no flt plan was filed. The pilot reported that during the ferry flt he flew past his destination arpt by misreading his sectional chart. Shortly after this he reversed…NTSB ATL83LA139Accident · Minor injuriesLimited investigationFinal reportBrown Sonera II L · Bowling Green, KYThe acft nosed over during a forced landing after the engine lost power on the base leg of the landing pattern. The weather was VMC and no flight plan was filed. The pilot stated that he had worked on the carburetor prior to this flightand had also moved the…NTSB DEN83LA080Accident · No injuriesLimited investigationFinal reportHelio H-295 · Baggs, WYThe plt reported that he was hauling hay for his stranded horse. The plt was delivering hay, 5 bales per flt & dropping 1 bale at a time. On the 19th drop, after 4 hrs & 15 min of flt time since refueling, the eng lost power. During a forced landing in deep…NTSB LAX83LA135Accident · No injuriesLimited investigationFinal reportVans RV-3A · Bakersfield, CAAccording to the plt, he took off, climbed to 1500 ft & set the engine controls at cruise power (2500 RPM at 160 mph). He stated that he then turned back toward the arpt & made a low pass without changing the power setting. As he started to climb from the low…NTSB DCA83AA019Accident · Serious injuriesFinal reportPiper PA-31-350-T1020 · Fort Belvoir, VAOn a flt from newark, NJ to richmond, VA, the departure time was delayed, and subsequently, the acft did not arrive at richmond until after the refueling facilities were closed. The plt decided there was sufficient fuel aboard to complete the next flt to the…NTSB LAX83LA132Accident · No injuriesLimited investigationFinal reportCessna 150G · Oakland, CAThe student plt was on a solo x-country flt from haymond, CA to sonoma & grass valley, CA, then return to hayward. She reported that the en route time on the 1st 2 legs of the flt were increased slightly due to the wx. The acft was not refueled at either of…NTSB LAX83LA131Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Palm Springs, CAThe pilot had departed riverside with an estimated 28 gallons of fuel, 23 gallons in the left tank and about 5 gals in the right. He flew to Palm Springs on the left tank and began to let down from 11,500 feet. At 7,000 ft the engine quit. The pilot called…NTSB FTW83LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-20 · Martinsville, TXReportedly, the plt took off with 36 gallons of fuel on board, of which, 10 gals was automobile low lead fuel. The automobile fuel had been purchased from an off airport gasoline station, was transported to the acft in 5 gal cans, then added to the fuel tanks…NTSB MIA83LA090Accident · No injuriesLimited investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe acft was ditched in the atlantic ocean following engine failure. The pilot estamated fuel on board during pre-flightfrom the electronic fuel gauges. The acft flew 2 hrs and 16 minutes before the engines quit in a mode of fuel exhaustionwith surging prior…NTSB LAX83LA129Accident · No injuriesLimited investigationFinal reportCessna 177B · Arvin, CAWhile descending to land, the eng sputtered & quit. According to the plt, the fuel gages indicated the left tank was 1/4 full & the right tank was 1/8 full when the eng lost power. During an emergency landing on a roadway, the acft collided with poles & wires…NTSB LAX83LA130Accident · No injuriesLimited investigationFinal reportCessna 195 · Concord, CAAt about 50 ft AGL during the takeoff portion of a touch-and-go, the eng loss power & the acft crashed into a fence. Thecarburetor bowl was drained & about 2/3 of the fluid was determined to be water. The fuel strainer also contained water.NTSB CHI83LA129Accident · No injuriesLimited investigationFinal reportRand KR1 KR-1 · Watervliet, MIThe pilot stated that he had flown the aircraft on the previous day and the operation had been satisfactory. Prior to that flight the aircraft had not been flown for two years. After takeoff he experienced power interruption, made a 180 degree turn back to…NTSB LAX83FA123Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Blythe, CAShortly after takeoff the acft experienced a power loss. During the subsequent forced landing the acft collided with trees. Wreckage examination disclosed no evidence of fuel and the engine operated normally during a functional test conducted 6 days after the…NTSB FTW83LA139Accident · Minor injuriesLimited investigationFinal reportBeckner FW-3 · Victoria, TXThe plt was on a test flt in his home built experimental acft. While he was returning to the airport about 45 min after takeoff, the engine lost power. A forced landing was made in a muddy field where the acft nosed over. After the accident, about 1/2 gal of…NTSB LAX83FA122Accident · No injuriesField investigationFinal reportCessna 210M · La Verne, CAThe pilot had found water in the wing tanks during his preflt but did not drain the fuel accumulator tanks as he was not aware of their existence. The engine sputtered and quit at 100 ft AGL, but the pilot was able to negotiate a landing on the arpt.…NTSB MIA83LA086Accident · No injuriesLimited investigationFinal reportCessna 150 · San Juan, PRThe acft was ditched in a lake near San Juan following engine failure due to fuel exhaustion. The pilot had rented the acft for a round trip to st. thomas. The accident occurred on the return flt to San Juan. It was reported that only residual fuel was found…NTSB FTW83LA138Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Shiro, TXWhile on a solo cross-country, the student plt became disoriented on the 3rd leg of the flt. He reoriented himself, but the eng lost power before he reached his intended destination. During an emergency landing, the acft encountered soft terrain & was damaged…NTSB FTW83LA136Accident · No injuriesLimited investigationFinal reportBellanca 7FC · Lake City, ARThe plt reported that during level flt, the eng lost power. He tried to land in an open field, but the acft struck a tree top aprx 35 to 40 ft AGL, then crashed on the ground, right wing first. The plt suspected possible carburetor ice. The temp & den point…NTSB CHI83LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Madeira, OHThe acft crashed into trees during a forced landing after the engine stopped operating while approaching an arpt. The acft was on a cross country flt from dayton to cincinnati in VMC weather. The acft was inspected at the scene and the engine was removed and…