NTSB investigations, LA

78 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.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
    AND 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.

NTSB FTW87DRD03Accident · Serious injuriesFinal reportSikorsky S-55C · Kurthwood, LAThe engine surged and subsequently lost power during low altitude cruise flight above a dense forest. The pilot autorotated into the trees and then fell through onto the ground. Post accident examination revealed water contamination in the fuel system.Feb 3, 1987 · N418A · Substantial damageNTSB FTW87LA038Accident · No injuriesLimited investigationFinal reportCessna 150 · Loreauville, LAA private pilot substantially damaged his aircraft while attempting a landing in a field following a engine failure due to water contamination in the fuel system.Dec 27, 1986 · N5788E · Substantial damageNTSB FTW87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 337 · New Orleans, LADuring an instrument approach and the subsequent missed approach, both engines failed due to fuel starvation. It has been determined that as much as six gallons of fuel was contained in the auxillary tanks at the time of the accident but that none was…Nov 20, 1986 · N879SA · Substantial damageNTSB FTW86LA173Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Abbeville, LAThe pvt plt took off on a pleasure flt with 1 pax on board. Drg the initial climb, the eng lost power at about 300 ft AGL. The plt then turned downwind & subsequently made a forced landing in a sugar cane field adjacent to the arpt. Drg the landing, the acft…Sep 30, 1986 · N3050Z · Substantial damageNTSB FTW86LA144Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Slidell, LAThe eng lost power during flt, & subsequently, the plt made a forced landing in a wooded area about 4 mi from the destn arpt. During an investigation, insufficient fuel was found remaining in the tanks & lines to permit continued eng operation. The eng…Aug 8, 1986 · N92BT · Substantial damageNTSB FTW86LA124Accident · Minor injuriesLimited investigationFinal reportCessna P-210N · Zachery, LAThe plt experienced a total loss of power due to fuel exhaustion during cruise flight. Approach control vectored him to a closer airport but the aircraft was beyond gliding distance and it collided with a house which was under construction. Inspection of the…Jul 7, 1986 · N4UD · Substantial damageNTSB FTW86FRD10Accident · Minor injuriesFinal reportPiper PA-28-140 · Krotz Springs, LAThe acft crashed into a road sign during a forced landing on a hiway following fuel exhaustion. The plt had made a x-country flt and only added ten gals of fuel for the return trip. His estimate of fuel remaining was inaccurate partly because the carburetor…Mar 11, 1986 · N40820 · Substantial damageNTSB FTW86LRD09Accident · No injuriesFinal reportPiper PA-22-150 · Sulphur, LAOn March 9, 1986, at 0900 CST, Piper aircraft PA22-150, N3821P, registered to derrick d. smith, experienced a power failure due to fuel exhaustion. This was a pleasure flight in visual meteorological conditions. No flight plan was filed. The aircraft was…Mar 9, 1986 · N3821P · Substantial damageNTSB FTW86LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Charles, LAThe acft experienced eng failure as a result of fuel exhaustion and the plt made a forced landing in a lake near the departure arpt while towing a banner. FAA stated the plt did not obtain a waiver to tow the banner.Oct 3, 1985 · N67803 · Substantial damageNTSB FTW85LA326Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Farmerville, LAThe plt took off and started his climbout with the fuel selector on a fuel tank which was virtually empty. The eng stopped reaching an alt of 200 feet AGL. The plt made forced landing in trees. There was an ample supply of fuel (about 70 gallons) distributed…Aug 20, 1985 · N8050P · Substantial damageNTSB FTW85LA309Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tallulah, LADuring an aerial application operation, the eng lost power & the plt made an emergency landing in a soy bean field. While on the landing roll, the acft nosed over. The operator reported that he did not see or smell any fuel around the acft; he believed that…Aug 7, 1985 · N962X · Substantial damageNTSB FTW85LA214Accident · Minor injuriesLimited investigationFinal reportDempsey Quickie · Opelousas, LADuring preflight, the plt estimated that he had about 2.5 hrs of fuel according to the gage. After 1.5 hrs of flt, the eng quit in cruise flt due to fuel exhaustion. The acft nosed over during the subsequent forced landing in a fld.May 4, 1985 · N79QD · Substantial damageNTSB FTW85LA155Accident · No injuriesLimited investigationFinal reportCessna 177 · Monroe, LAAprx 15 mins after departure, on final apch to Monroe regional arpt the eng lost pwr due to fuel exhaustion. During the forced landing the acft struck cable tv lines and trees causing a right yaw and uncontrolled descent to the ground. The student plt stated…Mar 19, 1985 · N2207Y · Substantial damageNTSB FTW85LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Slidell, LAWhen the renter plt arrived at the fixed base operator, he was informed that his acft had been flown 1.6 hrs and had not been refueled. Further, he was told that the acft was booked by another plt in one hr. Plt elected to take the acft with partial fuel…Dec 8, 1984 · N24780 · Substantial damageNTSB FTW85LA062Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Bastrop, LAPlt stated that on preflight a small amount of water was drained from each wing tank. Also, the main fuel strainer was drained and fuel tanks were topped off (17 gals added). At about 500 ft AGL on initial climb, the engine quit and restart attempts were…Dec 1, 1984 · N7327M · Substantial damageNTSB FTW85FA060Accident · 1 fatalField investigationFinal reportCessna 172A · Hammond, LANon-stop endurance for this make/model is 4.2 hrs in normal cruise. Calculated ete for plt's reported route of flight is 4.0 hrs (non-stop, no wind, normal cruise). Time from intial departure to mishap was 6.0 hrs. Acft of this discription was observed to…Nov 26, 1984 · N7415T · DestroyedNTSB FTW85LA053Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Basile, LAThe acft experienced a nose gear collapse during a forced landing following a loss of power shortly after takeoff. Plt stated the power loss occurred at an alt of 400 ft AGL. The forced landing was made in a soft plowed field. Post accident exam of the acft…Nov 22, 1984 · N1857X · Substantial damageNTSB FTW85FA040Accident · Serious injuriesField investigationFinal reportCessna T337B · West Monroe, LAThe acft crashed into trees during a forced lndg after both engs lost pwr. The acft had been recently purchased and was being ferried to the new owner. The acft had been flown only 40 hrs since the last annual inspection which was done on 1/19/84. It was…Nov 9, 1984 · N6T · DestroyedNTSB FTW84LA143Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400A · Monroe, LAThe aircraft suffered a loss of power while returning from an ag flight and made an emergency landing in a ditch next toa rice field. The engine was test run with no discrepancies noted. It was determined that the loss of power was due to fuel exhaustion.Feb 21, 1984 · N3159C · Substantial damageNTSB FTW84LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Thibodaux, LAThe acft nosed over during a forced landing after the engine quit. A FBO visually inspected the wreckage acft and found little gas and a lack of fuel odor around the acft. Later the engine was refueled and ran normally. The 3 acft fuel tanks were found empty…Feb 9, 1984 · N2103E · Substantial damageNTSB FTW84LA109Accident · No injuriesLimited investigationFinal reportCessna 150M · New Orleans, LADuring arrival, the acft lost power after a descent from 3000 to 2000 ft. at that time, the plt noted that the fuel gages indicated each tank was 1/8 full, but he did not apply carb heat until he was in an emergency descent. He elected to land on a boulevard.…Jan 7, 1984 · N9468U · Substantial damageNTSB FTW83LA377Accident · No injuriesLimited investigationFinal reportCessna 150 · Jones, LADuring a properly endorsed solo flt the student plt became lost in hazy conditions. He was not aware that one of the acft's fuel gauges was inop and had no watch. Eventually he established his location but ran out of gas before reaching his home field. The…Aug 14, 1983 · N61193 · Substantial damageNTSB FTW83LA069Accident · No injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe eng quit while the amphibious acft was over the city. The acft had insufficient altitude to reach the Mississippi river & the plt made a forced landing on a residential street. The left main tank contained 14 gals of fuel & no usable fuel was in the right…Dec 27, 1982 · N121BJ · Substantial damageNTSB FTW83LA047Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Vinton, LAThe aircraft had been stolen by a noncertificated pilot sometime during the evening of 11/21/82. The purpose and destination of the flight was not determined. It was found laying upside down in a swamp on 11/29/82. The pilot was extracted by helicopter and…Nov 22, 1982 · N18632 · Substantial damageNTSB FTW82DA392Accident · No injuriesFinal reportCessna 152 · Parks, LAThe pilot stated that the aircraft ran out of fuel. The fuel gauges were still registering 1/4 full on both tanks when the engine quit. In addition the pilot stated, "if I had dipped the tanks on preflight I would have known exactly how much fuel was in the…Sep 22, 1982 · N212GS · Substantial damageNTSB FTW82DA314Accident · No injuriesFinal reportPiper PA-18-150 · Newellton, LADuring flight, the engine lost power and the pilot made a forced landing in a plowed field. While landing on the soft terrain, the aircraft flipped over. The pilot reported that the engine had failed due to fuel starvation when one fuel tank ran dry while the…Aug 4, 1982 · N2375J · Substantial damageNTSB FTW82DA059Accident · No injuriesFinal reportCessna 310D · Farmerville, LABefore this flight, the aircraft had not been flown for a period of time. The pilot was the owner of a maintenance facility and was preparing to perform an annual inspection of the aircraft. He elected to fly it around the airport to warm up the engines…Feb 15, 1982 · N6822T · DestroyedNTSB FTW82DA042Accident · No injuriesFinal reportCessna 150H · Shreveport, LAThe pilot departed stillwater, ok at 0950 CST on a flight to mcalister, OK. While airborne, he amended his destination to Shreveport, LA with an estimated arrival time of 1251 CST. On his flight plan, he estimated 3 hours of fuel on board. At 1253 CST, the…Jan 19, 1982 · N6510S · Substantial damage