NTSB investigations, LA
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA' 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 FTW86FRD11Accident · No injuriesFinal reportGrumman G-164A · Crowley, LAThe acft crashed into wires and a house during an attempted forced landing. The plt was preparing to do rice seeding when the eng began to backfire & lose power. The plt was trying to return to the ag strip when the eng quit and he was forced to land. Eng…NTSB 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…NTSB 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…NTSB FTW86LRD08Accident · No injuriesFinal reportCessna 172P · Many, LAThe acft drifted off the rt side of the rwy into the soft shoulder during landing in a 10-12 kt x-wind. When the nose gear contacted the soft dirt it collapsed, which resulted in a nose over.NTSB FTW86LRD07Accident · No injuriesFinal reportMBB BO-105-CBS · Lake Charles, LAThe helicopter was simulating a single eng landing on an area marked to the size of an offshore helideck. The acft touched down hard enough to attract the attention of several witnesses. The crew continued with the training but later on post flt exam they…NTSB FTW86LRD06Accident · No injuriesFinal reportAir Tractor AT301 · Gilbert, LAOn January 29, 1986, an airtractor AT310, N5218S, owned by halcom flying service, was substantially damaged due to a fire which occurred during an attempted engine start. N5218S was to be flown to another location for maintenance purposes.NTSB FTW86FA034Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Deville, LAThe student plt had previously flown this acft in flt training. However, the insurance for the acft had lapsed & the owner had secured the acft to a tie-down with a chain & pad lock to prevent it from being flown. After the chain was cut with a hack saw, the…NTSB FTW86LRD05Accident · Serious injuriesFinal reportBell BH206L-1 · Gulf Of Mexico, LAThe acft descended into the Gulf Of Mexico from a 100 ft AGL hover after the plt lost yaw control downwind of an offshore oil platform in 35 kt winds. As the acft came to a hover it began a turn to the right even though it was headed into the wind. Full left…NTSB FTW86FA031Accident · 2 fatalField investigationFinal reportPiper PA-31P-350 · Norco, LAThe plt initiated an ILS apch in below minimum weather conditions shortly after night fall. He was given a low alt alert, but continued the apch. He announced a missed apch, and indicated problems climbing to alt. He then declared an unspecified emergency,…NTSB FTW86FRD04Accident · No injuriesFinal reportCessna 150J · Belle Chasse, LAThe acft nosed over during a forced landing following a loss of power. The flt was begun an hour before the acc with the intention of staying in local area. The wx was minimal VMC at the time of takeoff and suddenly became IMC when fog rolled in. The plt was…NTSB FTW86LRD03Accident · No injuriesFinal reportCessna 185 · Leeville, LAThe acft collided with a power line during an off arpt landing on a canal. It was an intentional landing to transport company employees of la-tex gulf drilling, inc. the wx was VMC and no flt plan was filed.NTSB FTW86FRD02Accident · No injuriesFinal reportCessna 172P · Monroe, LAOn November 7, 1985, at approximately 1740 CDT, Cessna 172P, registration no. N52995, sustained substantial damage. Pilot stated that he was in cruise configuration at 5,500 feet, when Lycoming engine model O-260-D2J, serial no. L-10724-39A, lost power. Pilot…NTSB FTW86FA023Accident · 2 fatalField investigationFinal reportCessna 152 · Arcadia, LAThe instrument flight instructor and student experienced a directional gyro failure. They covered the instrument and requested a return to their departure point. The aircraft was not equipped to fly the published approach. They requested a descent to an…NTSB FTW86LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Amite, LAThe plt reported a loss of brake effectiveness while landing on a dew-covered sod strip. Unable to stop, the acft slid through a fence, damaging the wings.NTSB FTW86FRD01Accident · No injuriesFinal reportNorth American AT6G · Jennings, LAThe acft contacted a ditch and nosed down during an overrun landing. The acft was in a flt of 3 AT6'S landing at the arpt for a fly-in. N104DC touched down on the 2000 ft freshly mowed grass strip aprx 500 to 600 ft from the end. The plt stated the…NTSB FTW86FA016Accident · No injuriesField investigationFinal reportBell 222A · Charenton, LAThe helicopter had just completed a phase two check, twenty minutes into the flight the occupants heard a loud noise and a severe one-to-one vibration ensued. A successful emergency landing was performed. Examination revealed that one swash plate drive link…NTSB FTW86LA009Accident · No injuriesLimited investigationFinal reportCessna A185E · Intracoastalcty, LAThe plt was spraying for mosquito control during the hours of darkness. He turned to reverse course and then turned on the acft's landing light to check his altitude. He observed power lines but it was too late for evasive action. After the prop impacted the…NTSB 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.NTSB FTW85LA357Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Ruston, LAThis 110 hour private pilot lost directional control of the aircraft while landing in a 90 degree cross wind and veered into a pickup truck spraying herbicide on the runway edge lights. Two city employees saw the aircraft coming towards them and escaped…NTSB FTW85LA348Accident · 1 fatalLimited investigationFinal reportCessna A185F · Catahoula, LAThe plt took off from a bayou with inadequate distance to climb above the trees growing along each side before the bayou made an aprx 120-DEG right turn. In order to avoid collision with the trees the plt entered a steep banked right turn to follow the bayou.…NTSB FTW85LA344Accident · 1 fatalLimited investigationFinal reportMooney M20J · Kraemer, LAAcft was descending from cruise alt when it entered a radar lvl 3 thunderstorm and control was lost during a night VFR flt. The acft impacted a swamp in a vertical attitude with the rt wing leading slightly. The lft wing was found about 10' south of the main…NTSB FTW85LA342Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Port Sulphur, LAThe plt stated he initiated his water takeoff run on a canal which had a left bend. When he rounded the bend he observed a 15-20 foot high piling (post) in the middle of the canal and a peninsula of land about 300 yards beyond the piling. He steered to the…NTSB FTW85LRD04Accident · No injuriesFinal reportCessna A188B · Rayville, LAThe acft contacted the terrain in a cotton fld during an uncontrolled descent which occurred on takeoff. The plt was test flying the acft in anticipation of possibly purchasing it. The plt reported that when aprx 1/2 the way down the rwy the acft did not…NTSB FTW85LA330Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · Oak Ridge, LAThe plt stated the acft 'sagged' (settled) during an aerial application maneuver and he leveled the wings to let it recover. However, he did not add power, flaps, or dump the load of almost 300 gallons of spray material he was carrying since he thought it…NTSB FTW85LA329Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Coushatta, LAAcft experienced a complete engine failure shortly after takeoff while at an altitude of approx 500' AGL. It was substantially damaged when it ran thru 2 fences during the ensuing forced landing. Investigation revealed that the eng fuel pump ejector nozzle…NTSB FTW85FRD03Accident · Minor injuriesFinal reportAdvanced Technology Predator 480 · Welsh, LAThe acft impacted the terrain in an uncontrolled descent during the initial takeoff climb. The plt reported that after takeoff at an alt of aprx 20 ft AGL, the acft rolled 20 to 25 degs to the right. After correcting for the roll, the plt stated, the acft…NTSB 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…NTSB FTW85FA310Accident · 1 fatalField investigationFinal reportBell UH-1B · Saint James, LAAcft was at a 150' hover preparing to pick up a log when it experienced a power loss. Witnesses stated that they heard a loud 'bang' and the pilot radioed 'get out of the way'. Acft autorotated thru 60' to 80' trees with very low rotor RPM and impacted with…NTSB 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…NTSB FTW85LA304Accident · No injuriesLimited investigationFinal reportCessna 172 M · Arcadia, LAThe plt stated he heard a 'boom' and experienced a partial power loss when he was about 10 ft above the rwy during the initial takeoff climb. He was about half way down the 3000 foot rwy at this time. He aborted the takeoff and landed. However, he was not…NTSB FTW85FA300Accident · 1 fatalField investigationFinal reportS.N.I.A.S. AS350D Astar · Houma, LAThe plt landed at a microwave antenna tower and did not shut down the eng or deplane. An employee at the tower retrievedcargo from the helicopter (a small box of parts) and went back inside the tower building. Shortly thereafter, the plt apparently initiated…NTSB FTW85LA298Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Bonita, LAThe plt stated he was the second of two acft in a formation takeoff and he encountered severe wake turbulence from the other acft (same type). He stated that he dumped his load of chemicals but could not get above the pwr curve and the acft settled into a…NTSB FTW85LA291Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Patterson, LAThe acft was substantially damaged when it was rammed by a speed boat after it had landed on a canal and was water taxiing to its tie down area. The boat came out of a crossing canal at high speed and struck the amphib in the area of the left float. The boat…NTSB FTW85FA282Accident · 1 fatalField investigationFinal reportAerospatiale AS-350D · Matagorda Islng, LAThe acft touched down hard during an attempted autorotation to an abandoned air base. Initial touchdown occurred on the stinger and the acft yawed to the left of rwy heading 30 to 40 degrees. The next touchdown was on the skids and the acft yawed further to…NTSB FTW85LA271Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Tallulah, LADuring initial climb after takeoff, the ag plt realized that he could not clear wires at the end of the rwy. The plt dumped his load of fertilizer and attempted to maneuver around the wires, however during the maneuver, the acft stalled. Investigation…NTSB FTW85LA267Accident · Serious injuriesLimited investigationFinal reportCessna 172E · New Orleans, LAThe pilot stated the engine quit while he was being vectored for an approach to msy airport, New Orleans. He stated orally that he did not run out of fuel. A successful test run was made with adequate power for flight available. The cause of the engine power…NTSB FTW85LA264Accident · Serious injuriesLimited investigationFinal reportBellanca 7ECA · Ville Platte, LAThe plt had rented the acft for a local flt and was observed by ground witnesses to have flown very low (50 ft AGL) over miller lake when the left wing struck a tree. The acft continued for aprx 50 ft in a left wing low attitude before striking another tree,…NTSB FTW85FRD02Accident · 1 fatalFinal reportTeratorn Tierra II · Lake Charles, LAThe acft impacted the terrain in an uncontrolled descent. Witnesses stated the acft was participating in a bean bag drop contest when the accident occurred. After dropping the last bag the acft made a turn to the west, entered a spin and descended to ground…NTSB FTW85FA247Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Pineville, LAThe aircraft landed long and fast on the relatively short, sloping runway. After bouncing four times, the pilot rapidly added throttle on the turbocharger-equipped aircraft and attempted to climb. Witnesses observed smoke from the exhaust, and described high…NTSB FTW85FA244Accident · 1 fatalField investigationFinal reportCessna 152 · Bogalusa, LAA few minutes after departure the student plt flew into the ground in an effort to return to the arpt about 1400 ft n of rwy 18 in aprx a 15 deg nose down and 35 deg left angle of bank. The afct slid about 80 ft when it rotated about it's right wing flipping…NTSB FTW85LA252Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAThe left brake failed during the landing roll. The acft veered to the right of the rwy and ground looped. During the groundloop, the left tire blew and the tail wheel spring bolt assembly failed. Cause of the brake failure was not determined.NTSB FTW85LA234Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-400 · Cheneyville, LAThe plt stated he had attempted to take off in a left quartering tailwind with a 1200 lb load of seed rice. Witnesses stated that the acft began a shallow turn and the nose dropped. The plt regained control of the acft, but it contacted the ground in a level…NTSB FTW85LA215Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Natchitoches, LAThe pilot experienced partial power loss due to ingestion of the alternate air door shaft needle bearing rollers into the engine, and cross firing of the right magneto. He reportedly closed the throttle and made a gear up forced landing. The aircraft slid…NTSB FTW85LA235Accident · No injuriesLimited investigationFinal reportGrumman G-164A-450 · Basile, LAThe plt detected a fuel leak after takeoff and returned to land. He shut the acft eng down and exited the acft, but the acft busrt into flames before the prop stopped turing. Subsequent investigation discovered a material failure in a fuel line on the eng…NTSB FTW85FRD01Accident · Serious injuriesFinal reportAlon A-2 · Bunkie, LAThe acft contacted the terrain and was destroyed by fire following a loss of elevator and aileron control. The plt reported he maintained control of the acft by use of the rudder, pwr and elevator trim. Post accident inspection revealed the left aileron…NTSB 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.NTSB FTW85LA205Accident · No injuriesLimited investigationFinal reportCessna A185F · Gibson, LAThe amphibian acft was substantially damaged when it collided with a tree while landing on an oil field service canal. The plt stated that he landed long and fast and as a result he was unable to negotiate the second half of an 's' turn in the canal. The left…NTSB FTW85LA201Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Ama, LAThe aircraft reportedly assumed an abrupt nose high attitude during its initial climb following takeoff. The pilot stated he made the initial left departure turn from the airport and then realized he could not release the elevator back pressure he had used…NTSB FTW85LA200Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Sulphur, LAThe pilot stated he had taken off to the south into the wind. He made a turn to the west to clear trees. At about 150 feet the aircrafts climb ability deteriorated so he turned back into the wind but the nose dropped stalled and the aircraft entered a spin.…NTSB FTW85LA189Accident · No injuriesLimited investigationFinal reportCessna A185F · Slidell, LAThe plt reported that during a water landing, the left float dragged, but he was able to 'pull it out' & started to add power to go around. However, he saw power lines ahead & realized that a go-around was not possible. He said he 'planted it back on the…