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 FTW84LA282Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Houma, LAThe helicopter autorotated into trees and marsh land after a partial loss of power. The acft was on a pipeline patrol atlow alt at the time of the power loss. Examination of the engine after the accident revealed that the fuel control governor spring, p/n…NTSB FTW84LA275Accident · No injuriesLimited investigationFinal reportCessna A185F · New Iberia, LAWhile decelerating after landing one of the floats contacted a submerged object. Directional control was lost, acft veered to left and collided with a tree on the bank.NTSB FTW84LA266Accident · Minor injuriesLimited investigationFinal reportBell 212 · Milton, LAThe pilot had consumed alcohol in 2 different bars prior to the flt. He took the helicopter without authorization & departed with 2 passengers that he had met in a bar. He stated that he was returning to the arpt when he experienced an unusual oscillation in…NTSB FTW84FA264Accident · 2 fatalField investigationFinal reportCessna A185F · Houma, LAPlt was returning to home base of operations, executing standard visual approach along intercoastal waterway on westerly base heading prior to turn on final. Acft collided with overhead ground wires of power transmission array spanning the waterway at an…NTSB FTW84LA263Accident · 1 fatalLimited investigationFinal reportRockwell A-9B · Maringouin, LAThe plt was completing the first swath pass attempting to fly under a power line and between a tree and parked farm equipment. In a slight left turn under the power line, the right wing contacted tree tops aprx 30 ft AGL. The acft continued aprx 150 yards…NTSB FTW84LA262Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bell City, LAA propeller counterweight bearing shaft failed after takeoff at max gross weight. A vibration occurred & the plt began dumping his load, but he was unable to maintain altitude. The aircraft landed in soft mud and nosed over when it collided with a rice levee…NTSB FTW84LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Ferriday, LAUpon landing the acft traveled off the side of the airstrip and nosed over in a small ditch. The student plt was not endorsed by a CFI for landing at this airstrip while on the x-country flight.NTSB FTW84LA265Accident · No injuriesLimited investigationFinal reportAerospatiale AS 355 F Ecureuil · Venice, LAThe plt landed to secure a seat belt flapping on the outside of the fuselage. The area chosen for landing was soft and the acft began to settle into the mud. The plt initiated takeoff and when the acft freed itself from the mud it started spinning. The plt…NTSB FTW84FA243Accident · 1 fatalField investigationFinal reportCessna 177B · Kinner, LAThe plt stated he lost eng pwr after departing the new orleans int'l arpt. The flt was unable to return to the arpt. The acft crashed in the waters of lake pontchartraih about 1 mile from the arpt. The wreckage was located and marked with a buoy. Due to high…NTSB FTW84LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe plt reported after the accident that he was dispensing fertilizer and had just flown through a heavy rain shower when the engine began to lose power. A forced landing was made in a flooded rice field and the acft nosed over. The pilot stated that he was…NTSB FTW84LA245Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Tallulah, LAThe acft caught fire shortly after takeoff and the plt landed in a wheat field. The nosewheel dug into the soft field and the acft nosed over. This acft has been the subject of recommendations on worn and deteriorated fuel lines. The pltsdescription of his…NTSB FTW84LA248Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · New Roads, LAThe flt instructor stated that the 17 hr student plt was on a supervised solo flt when the accident occurred. The student was landing on rwy 18 with a wind from 220 degrees at 6 KTS. The student was unable to maintain directional control and the acft traveled…NTSB FTW84LA240Accident · No injuriesLimited investigationFinal reportRockwell S2R · Alexandria, LAThe acft collided with a static wire between two electrical poles while maneuvering during aerial application. Control was maintained and the acft returned to the airport and landed without futher incident.NTSB FTW84LA230Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Many, LAThe acft was damaged when it failed to climb during takeoff and went past the departure end of the rwy for 1400 ft before stopping. There was a witness who observed six persons on board the 4 place acft. The plt stated that his son in the rt front seat…NTSB FTW84LAMS4Accident · 1 fatalFinal reportPiper PA-32-260 · Lafayette, LAThe acft has been missing since 5/10/84. The owner called for his acft preflighted and departed on a southerly heading. An off shore oil rig spotted a twin engine acft heading south. Search efforts by cap were unsuccessful. The plt gave no indication of his…NTSB FTW84LA225Accident · No injuriesLimited investigationFinal reportGrumman G164A · Fenton, LAThe acft, while maneuvering at low alt, hit the ground and flipped inverted. The plt reported encountering a strong downdraft over a wooded area and in maneuvering to avoid the trees, the acft settled to the ground. The plt reported winds from 225 degrees at…NTSB FTW84LA203Accident · Serious injuriesLimited investigationFinal reportCessna 185F · Belle Chasse, LAWhen the plt attempted to start the eng, it 'hung up in the middle of the compression stroke.' He stated that after confirming that the magnetos were off, he attempted to 'free the propeller by hand.' The eng started as soon as the propeller was moved. The…NTSB FTW84LA201Accident · No injuriesLimited investigationFinal reportCessna A185F · Grand Isle, LAThe plt estimated that the wind was from the northeast at 15 KTS gusting to 25 KTS. During an easterly takeoff from a private strip, the acft encountered a gust which lifted the left wing causing the plane to drift right & lift off. The acft climbed to an alt…NTSB FTW84LA198Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Monterey, LAThe plt landed at an improved private strip. Later, he took off in winds that he reported were down the rwy at 12 KTS gusting to 14 KTS. After lift-off the acft 'climbed normally' & cleared a power line as well as low trees at the end of the strip. However,…NTSB FTW84LA200Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · New Orleans, LAShortly after touchdown on a x-wind landing, the tailwheel equipped acft began to weathervaned to the left into the wind. The plt lost directional control & the acft ground looped to the left. The right gear collapsed & the right wing dragged on the ground.…NTSB FTW84FA190Accident · 1 fatalField investigationFinal reportBeech 65 · Jennings, LAA popping or backfiring sound was heard by several people who later observed the acft flying at low altitude on what appeared to be a final approach to rwy 13 at Jennings arpt (located about 75 mi sw of the departure point.) No radios were onboard the acft so…NTSB FTW84LA185Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Eunice, LAThe plt reported that the engine lost power on takeoff and return to the rwy was not possible, so he landed on the edge of a pond. A post accident investigaiton revealed a crack in the #7 cyl head between the spark plug holes. The engine had just gotten a…NTSB FTW84LA179Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Lake Charles, LAThe acft hit a tree and a ditch during a forced landing on a road after the engine lost power. Examination of the engineafter the accident revealed that the throttle rod had disconnected from the throttle control arm at the bolt hole. The hole had worn…NTSB FTW84LA183Accident · No injuriesLimited investigationFinal reportCessna 180 · Rayville, LADuring the takeoff the acft yawed left. The plt overcorrected causing the acft to yaw right & depart the right side of the rwy collapsing the left main landing gear.NTSB FTW84LA176Accident · No injuriesLimited investigationFinal reportCessna 188 · Clayton, LADuring the last landing of the day in a gusty crosswind, the acft went off the side of the rwy and nosed down in a plowed field. This was the plts 26th landing for this day, all on the same rwy. The wind was gusting to 20 KTS.NTSB FTW84LA169Accident · No injuriesLimited investigationFinal reportCessna 172D · Belle Chasse, LAThe acfts nose gear dug into mud during landing rollout. The acft then nosed over.NTSB FTW84LA162Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Braithwaite, LAThe plt said that when he applied power for takeoff he overcorrected and the acft veered right. He attempted to abort but saw a ditch and reapplied power. The acft hit the ditch and collapsed the landing gear. The plt thought maybe the brakes locked but an…NTSB FTW84LA154Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Intracstl City, LAThe helicopter collided with marsh terrain while spotting dead alligators. The plt does not remember events of the accident. The helicopter operator stated the helicopter appeared to have impacted at a low airspeed at a normal RPM. The emergemcy floats were…NTSB FTW84LA145Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Abbeville, LAThe plt was employed as a professional corporate & charter plt; however, he had not flown agricultural acft in several years. He had receently purchased half interest in the air sevice & was on his 1st refresher flt since then. While the plt was practicing a…NTSB 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.NTSB FTW84FU003Accident · 1 fatalFinal reportUltraclassics Bearcat 150 · Abita Springs, LAThe airman tookoff for a personal flt, and after circling, made a desending high speed pass over the arpt. He then pulled the vehicle into a climb and began a roll. About 2/3 through the roll, the vehicle's nose dropped and it dove into the ground. The nose…NTSB FTW84LA136Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58E · Morgan City, LAThe helicopter was hovering above trees at about 100 ft AGL when the tail rotor chip detector lgt flickered svrl times, then illuminated steadily. This was followed by a loud grinding noise from the tail area & the acft yawed to the right. The acft entered an…NTSB 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…NTSB FTW84LA118Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Venice, LAAbout 10 min after departing an offshore platform, the plt encountered an area of fog. He descended to aprx 200 ft, slowed to 40 KTS & started turning back. As he was turning, he was looking to the right to locate a petroleum production facility to use as a…NTSB FTW84FA121Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · New Orleans, LAThe eng quit as the acft was descending for an approach into moisant arpt & the acft was ditched in lake pontchartrain. Examination revealed that the magneto distributor block was severely cracked & both sets of breaker points were displaced away from the…NTSB FTW84LA116Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Vencie, LAAccording to the plt, he took off from a came site to pick up duck hunters at several locations. During the flt, he encountered fog & turned toward venice, LA to land. He then saw an oil field structure & some land & elected to make a precautionary landing.…NTSB FTW84LA416Accident · 1 fatalLimited investigationFinal reportCessna 210N · Plaquemine, LAThe acft was found by a hunter crashed in a heavily wooded swamp area aprx 10 months after the acdnt. The sole body fnd was beyond a condition of testing for toxicology or autopsy. The body was identified as a plt who was supposed to meet the owner of the…NTSB 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.…NTSB FTW84FA107Accident · 2 fatalField investigationFinal reportAerospatiale AS-355F · Morgan City, LAThe plts in a helicopter encountered foggy weather during a positioning flt and crashed into a lake about 4 mi from the departure point, a fisherman who witnessed the accident said the acft descended into the water in a nose low attitude. The acft skipped and…NTSB FTW84FA077Accident · 4 fatalField investigationFinal reportCessna 172L · Simpson, LAThe acft collided with the ground in a steep nose down altitude at a high rate of speed after the plt encounterd low ceiling and rain during a x-country flt. In attempting to fly IFR and follow radar vectors the non-instrument rated plt lost countrol of his…NTSB FTW84LA055Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Kurthwood, LAThe student plt & a passenger, who was also a student plt, flew to a private sod strip near Kurthwood, LA. After flying a hi, fast, visual apch to the strip, the acft landed long & overran the landing area. It continued into a wooded area & was damaged. The…NTSB FTW84IA094Incident · No injuriesIncident investigationFinal reportSikorsky S76A · Cameron, LAThe helicopter was on initial climb when the #1 engine failed explosivly. A post explosion fire ensued and both fire bottles were utilized to no avail. During landing the gear collapsed and the acft settled on its belly. The cause of the engine failure is…NTSB FTW84LA042Accident · 1 fatalLimited investigationFinal reportCessna A185F · Freemason Is., LAThe acft was on the return leg of a fishing trip at night. According to the plt, the float plane lifted off after a fairly long run on smooth water. He stated that at 200 ft AGL & 90 KTS, he initiated a 10 to 15 deg right turn & rolled out on a heading of 350…NTSB FTW84LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Slidell, LAThe acft collided with submerged objects during takeoff. The takeoff was aborted and the acft ran up on the bayou bank where it collided with trees.NTSB FTW84LA041Accident · No injuriesLimited investigationFinal reportCessna 180K · Patterson, LAAfter landing, the plt was step taxiing the float plane around a slight curve in the canal. As the acft went around the curve, the sun was in the plt's eyes & he did not see a piling until it was directly ahead. He took evasive action, but the left wing…NTSB FTW84LA029Accident · Minor injuriesLimited investigationFinal reportMooney M20D · Ama, LAAfter takeoff the plt made two low passes over the rwy, & was turning to make a third when the acft struck trees.NTSB FTW84FA028Accident · 3 fatalField investigationFinal reportMitsubishi MU-2B · Patterson, LAWhile descending into the Patterson area on an IFR flt plan, the plt was cleared to hold & was advised that he would be the #2 acft for an approach to the Patterson arpt. A few winutes later the plt asked how long the delay would be. He subsequently stated he…NTSB FTW84LA006Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Rayne, LAThe acft stalled during final approach and landed hard on the dirt airstrip. The CFI said he yelled 'add power' when he felt the acft buffet. The student plt reacted by pulling off the power and the acrt stalled to ground contact.NTSB FTW83LA446Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Napoleonville, LAThe acft dragged a wing in the sugarcane crop during a start of a swath run. According to the operator the plt was looking at a map as he approached the run. After the wing dragged the acft yawed 90 degrees and settled into the crop. The engine and right main…NTSB FTW83FA441Accident · 3 fatalField investigationFinal reportCessna 172E · Leesville, LAEarlier in the day the four occupants of the acft had been reported to the sheriff's dept as being drunk at a lounge near zwolle,LA. After landing at the Leesville arpt the acft ran off the asphalt bending both ends of the prop blades. The occupants attempted…