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 FTW83FA430Accident · 2 fatalField investigationFinal reportMBB BO-105S · Grand Chenier, LAThe acft departed an offshore platform at 1510 for a 13 min flt to Grand Chenier. On 9/20 the wreckage was recovered from the floor of the gulf. The bottom left side of the fuselage revealed evidence of high impact forces with the water. There was no evidence…NTSB FTW83LA414Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morse, LADuring a climbing turn after takeoff, the eng lost power & started smoking lightly. The plt dumped his chemical load & was able to clear a set of power lines. He then made a forced landing in a flooded rice field where the acft nosed over. An investigation…NTSB FTW83LA423Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Opelousas, LAAfter aborting 3 tkofs from a short grass strip the plt decided the grass was too long. Aft mowing the grass and an additional area to extend the length of the strip the plt took off alone to see if the length was suitable for takof. The plt then lndd and…NTSB FTW83LA410Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Lake Charles, LAThe acft collided with trees about 50 ft off the right side of the rwy after the left brake failed during hard brake intermittent applications. Failure to release the right brake in a timely fashion caused the acft to swerve to the rightand off the rwy. The…NTSB FTW83LA402Accident · No injuriesLimited investigationFinal reportGrumman G-164B · North Lacassine, LAThe plt reported that during the landing, the left wing struck tall grass at the side of the strip & the acft swerved to the left. He tried to correct the situation by applying right braking action, but his braking was ineffective on wet grass. Subsequently,…NTSB FTW83LA396Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Addis, LAThe acft made a forced landing in a plowed field after colliding with a low hanging transmission wire over a field beingsprayed. The plt applied full power after the collision but a damaged and locked up elevator caused excursions of climbing, stalling and…NTSB FTW83LA381Accident · No injuriesLimited investigationFinal reportCessna A188B · Plain Dealing, LAThe plt flew from his home base to Plain Dealing, LA to onload material for aerial application. During the landing roll-out, the right main gear leg failed. A metallurgical exam revealed the gear leg failed from fatigue which was initiated by corrosion pits…NTSB 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…NTSB FTW83FA373Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Ville Platte, LAPrior to takeoff the plt had received a wx briefing & was advised that VFR flt was not recommended. He was given convective SIGMET 13C which called for thunderstorms with tops above 45,000 ft throughout his route of flt. About 25 minafter takeoff four…NTSB FTW83LA366Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Jennings, LAThe acft nosed over during a forced landing after the engine quit shortly after takeoff. The main landing gear mired in soft plowed earth and the acft nosed over during landing. The takeoff gross weight was 5290 lbs. After the accident the engine tear down…NTSB FTW83LA365Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58 · Westwego, LAThe helicopter was being used to string power lines by carrying a 500 lb wt, to which, the respective wire was attached. While hovering at about 120 ft AGL & in close proximity to a power line tower, the eng loss power abruptly. An autorotative landing was…NTSB FTW83LA371Accident · No injuriesLimited investigationFinal reportBell 206B · Venice, LAThe acft landed hard during an autorotation landing. The plt said he could not control the engine RPM with RPM switch onthe collective or the manual throttle control. N2 tended to go over 100 percent. The plt notified his company and planned for an…NTSB FTW83LA345Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Houma, LAThe acft had previously been submerged in water. After it was salvaged & repaired, a ferry permit was obtained to fly it to amarillo, TX. According to a witness, the eng began running rough after the 1st 50 ft of the ground roll during takeoff. However. The…NTSB FTW83LA335Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Cameron, LAThe helicopter rocked and severed the tail boom during an off arpt forced autorotation landing. This acft had a history of engine surges and tot fluctuations. Changes had been made to try to correct the problem. During this flt the engine quit entirely. The…NTSB FTW83LA321Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Mandeville, LAOn a cross country flight in normal cruise at 2000 ft AGL the engine quit. The pilot made a forced landing to a road. During landing roll the left wing struck a vehicle. The acft then slid into a ditch. Post accident investigation revealed that an oil line…NTSB FTW83LA307Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Franklinton, LAThe acft slid into a tree during a landing on a wet rwy. The plt had encountered the rain shortly after takeoff and returned to the arpt. The private strip had become soft from the rain and the plt lost control of the acft. The acft veered off the strip and…NTSB FTW83LA297Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Lafayette, LAThe helicopter made a hard precautionary landing after the plt noted the rotor RPM and N2 would bleed off when collective pitch was increased to 80 percent torque. The plt returned to the arpt and elected to autorotate instead of landing with power available.…NTSB FTW83LA289Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Pineville, LAPrior to landing, the plt moved the gear switch to the extend position & noted that the gear indicated down. However, the left main gear did not extend. While landing with the left gear retracted, the acft settled on the left wing & prop. The acft spun 180…NTSB FTW83LA283Accident · No injuriesLimited investigationFinal reportCessna A-188B · Branch, LAAccording to the plt, the acft was using a longer than normal takeoff roll while taking off with the last load of the day. When he realized it was too late to abort, he dumped his load & continued the takeoff. The landing gear went thru a fence at the end of…NTSB FTW83LA277Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAThe acft collided with a dirt levee during takeoff after an engine malfunction. According to the plt he experienced a power failure at liftoff. He dumped his spray load and applied brakes. The engine regained partial power and failed again. At about 60 mph…NTSB FTW83LA267Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Kinder, LAThe acft collided with a tree and a levee during takeoff. The plt said the wind had shifted before or during takeoff andthe acft at rotation felt as if it stalled. The acft failed to clear a small tree and then was forced into a levee. The acft nosed over…NTSB FTW83LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Kaplan, LAWhile departing from a private strip, the plt took off to the north in calm winds. When he returned to land, the wind had begun blowing from the southwest at 20 KTS; thus, he elected to land toward the south. A truck was parked at the apch end of the strip,…NTSB FTW83FA259Accident · 2 fatalField investigationFinal reportCessna 180J · Harvey, LAA navigable waterway, Harvey canal, was being used as a seaplane base. In that area, a set of power lines were suspended over the canal by 2 tall towers. The lowest line over the canal was 160 ft above the canal surface, but the lines dropped to heights of…NTSB FTW83FA252Accident · 1 fatalField investigationFinal reportPiper PA-60 · New Orleans, LAWitnesses reported that when the acft was stabilized on final apch, it pitched up slightly & yawed, then rolled left to an inverted attitude & crashed in a canal. Several witnesses stated that the left prop was windmilling. One stated the left prop had…NTSB FTW83FA251Accident · 1 fatalField investigationFinal reportEnstrom 280C · Opelousas, LAThe helicopter was observed to lift off to a hover and began an erratic hover. The acft pitched up and spun throwing theplt out and fatally injuring him. Witnesses said they did not know the plt was going to fly the helicopter. The opinion was that it was to…NTSB FTW83LA248Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Breaux Bridge, LAThe acft nosed over during landing on a wet soft private grass strip. During landing the nose gear dug in and the acft nosed over. The plt stated that he needed more experience in judging grass strip conditions.NTSB FTW83LA244Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Taft, LAThe acft flew into guy wires of a weather tower after a spray run.NTSB FTW83FA238Accident · 1 fatalField investigationFinal reportAerospatiale AS-350D · Venice, LAThe acft crashed into a swamp with low rotor RPM after a failure of the accessory gearbox power output gear. The pilot radioed an emergency call saying he was experiencing severe vibrations and was landing. A few seconds later, he radioed that he was…NTSB FTW83LA239Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hayes, LAThe acft ran off the rt side of the rwy and collided with a dirt embankment drng lndg roll. Brake fluid was found on the l main gear following the accd. Investigation revealed the source of the leak to be a popped o-ring in the brake actuating cylinder.NTSB FTW83FA232Accident · Serious injuriesField investigationFinal reportBell 47G · Zachary, LAThe tail rotor gear box separated from the acft during practice autorotation. The acft began to spin rapidly and nose down. Increasing the power brought the nose up but increased the speed of rotation. The acft hit on one skid still in a rapid spin. The…NTSB FTW83LA220Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bastrop, LAAfter arriving, the plt made a pass over the turf strip to inspect it before landing. He elected to land; however, during the landing roll-out, he saw a ditch running laterally across the strip, but by then, he was unable to avoid it. Subequently, the acft…NTSB FTW83LA224Accident · No injuriesLimited investigationFinal reportCessna 180K · Houma, LAThe plt was step taxiing on the intracoastal canal when he attempted a right turn. This resulted in a left rear crosswind which resulted in the left wing to striking a tree on the canal bank.NTSB FTW83LA219Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Iowa, LAThe acft nosed over during an off arpt landing. The plt stated that he was landing to check his aerial application load and talk to a farmer. During touchdown the main landing gear dug into the soft ground and the acft nosed over.NTSB FTW83LA210Accident · No injuriesLimited investigationFinal reportCessna A188B · Winsboro, LAAprx 600 feet of the 2300 foot strip is concrete and the remainder is turf. According to the pilot, he raised the tail prior to running off the concrete. As the takeoff roll continued onto the turf, the acft veered sharply to the right. Full left rudder,…NTSB FTW83LA209Accident · No injuriesLimited investigationFinal reportAero Commander S-2R · Cheneyville, LAAccording to the operator, the brakes failed during landing causing the acft to ground loop off of the rwy. He also stated that postcrash investigation revealed a broken brake line on the right brake which he suspects was an act of sabotage by an unknown…NTSB FTW83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Breaux Bridge, LAAccording to the pilot he was attempting to takeoff at night from an unlit turf strip. Just before the attempted takeoff, two sets of vehicle headlights were directed down both sides of the rnwy to help the pilot in the takeoff. On both sides of the rnwy,…NTSB FTW83LA185Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Shreveport, LAAccording to the pilot, the crosswind landing and initial rollout were normal. Shortly after the tailwheel settled a sudden gust of wind of surprising strength caused the airplane to weathervane into the wind and toward a line of parked airplanes. To avoid a…NTSB FTW83LA167Accident · No injuriesLimited investigationFinal reportCessna 185F · Int.Coastal Cty, LAThe pilot stated that the landing gear was not retracted after takeoff from the airport. When the pilot attempted to land on water the aircraft flipped over and sank. The landing gear are built into the floats and during the retraction cycle the landing gear…NTSB FTW83LA166Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Newellton, LAAprx 1 minute after takeoff the acft engine failed. During the forced landing, the acft flipped inverted damaging one wing tip and the vertical stabalizer. Post crash inspection revealed a crack in the number 7 cylinder, from spark plug to spark plug, which…NTSB FTW83LA153Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Athens, LAJust prior to the flt, a mechanic performed some minor upkeep functions on the acft & knew of no mechanical problems. He was unaware that the owner was not a rated plt. The mechanic accompanied the owner on a local flt. Subsequently, the acft crashed on the…NTSB FTW83FA126Accident · 2 fatalField investigationFinal reportCessna 172N · Pineville, LAThe owner, an instructor plt (CFI), was in the right front seat & a private plt with no instrument rating was in the left front seat. During arrival, the aircrew had inquired about the wx at the esler regional arpt, however, the fss & the UNICOM had closed…NTSB FTW83LA123Accident · No injuriesLimited investigationFinal reportCessna 180H · Chandeleur Isl., LAThe plt elected to takeoff on a sandy beach aprx 1800 to 2000 ft long. There was a gradual curve in the beach for most of the takeoff distance. The plt reported that there was debris on the beach that was too heavy to move, which he had to dodge with less…NTSB FTW83FA121Accident · Minor injuriesField investigationFinal reportCessna P210 · Alexandria, LAThe acft made excessively steep turns at low altitude and the engine lost power. During the forced landing that followedthe acft struck a tree and rolled inverted. It struck the ground in a near vertical nose down attitude. From the amount of fuel aboard at…NTSB FTW83LA089Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Loreauville, LAReportedly, the acft was preflighted and all three water traps (sumps) were drained until only fuel flowed. During takeoff, the engine began losing power at aprx 400 ft AGL. An emergency landing was made in a cane field. During touchdown, the acft hit rows in…NTSB FTW83LA090Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Belle Chase, LAThe acft encountered fog during landing rollout, the pilot lost control and ran into a fence. The air taxi pilot had off loaded his passengers at new orleans and was ferrying the acft to the accident arpt at Belle Chase la. The pilot wasnot injured in the…NTSB FTW83FRD02Accident · 1 fatalFinal reportTeal TSC-1A · Port Sulphur, LAThe eng lost power during a pull-up from a low pass over the arpt. The plt made a forced landing in the icy Mississippi river with the gear down. The amphibian struck a submerged object in the river & flipped over. The plt & pax attempted to swim to shore but…NTSB 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…NTSB FTW83FRD01Accident · 3 fatalFinal reportPiper PA-28R-200 · Henderson, LAThe pilot and two passengers were on a flight from beaumont, TX to covington, LA. The non-instrument rated pilot departed on a special VFR clearance. At that time, the weather at beaumont was 300 ft overcast, visibility 12 mi. When the aircraft was about 10…NTSB FTW83LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ruston, LAOn takeoff the pilot heard a loud bang sound then lost engine power. The pilot made a 180 degree descending turn back toward the airport. At the edge of the airport the pilot made a hard touchdown on all three gear assemblies. Investigation revealed the…NTSB FTW83LA056Accident · No injuriesLimited investigationFinal reportLuscombe 8A · New Orleans, LAPilot used brakes to attempt to straighten aircraft veering in crosswind and aircraft nosed over.