NTSB investigations, LA
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 FTW87DRD07Accident · No injuriesFinal reportGrumman G-164B · Chenneyville, LAThe engine experienced a total loss of power due to a failed #1 connecting rod. During the forced landing the left wing contacted cotton plants which caused the aircraft to veer left and flip inverted.NTSB FTW87DRD05Accident · No injuriesFinal reportGrumman G-164 · Kaplan, LAThe plt was dispensing fertilizer on a rice field when the acft collided with six strands of a power line at about 20' AGL. The airplane then crashed to the ground & was substantially damaged. The power line poles were located outside the field boundry.…NTSB DCA87MA033Accident · Serious injuriesMajor investigationFinal reportBritish Aerospace 3101 · Kenner, LAThe acft overran the dept end of the rwy and came to rest on a hiway barrier after an aborted takeoff following engine torque oscillations. The capt tried reducing the power levers as he had been taught to 'get off' the ttl since he thought the ttl was…NTSB FTW87LA121Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Olla, LAShortly after takeoff, witnesses observed the acft in a steep climb. Rprtdly, it then entered a left turn & appeared to stall. The plt stated that after about 180 deg of turn, he rolled out, nose low, leveled the wings, then a vibration started. Rprtdly, the…NTSB FTW87LA114Accident · No injuriesLimited investigationFinal reportAyres S2R-1820 · Ville Platte, LAAfter landing on a wet grass strip the pilot realized that the aircraft was not going to stop. Obstructions off the end of the runway prevented a go-around. The aircraft collided with two trees causing substantial damage.NTSB FTW87LA110Accident · No injuriesLimited investigationFinal reportLaw OSPREY-2 · Minden, LAPilot stated that he flared about ten feet too high and landed hard collapsing the main gear followed by the aircraft sliding off the runway and colliding with a ditch where substantial damage occurred.NTSB FTW87LA101Accident · Serious injuriesLimited investigationFinal reportSikorsky S-55B · De Quincy, LAThe pilot experienced an engine surge followed by a complete loss of power during a swath run of a tree spraying ag operation. The helicopter was over a densely wooded area and autorotated into trees. The owner was aware of a carburetor problem and had…NTSB FTW87FA100Accident · No injuriesField investigationFinal reportBeech D55 · Cameron, LAThe left engine lost power at rotation but, due to the short runway (2500-SOD), the pilot elected to continue the takeoff. He switched the left fuel selector, placed the boost pump switch in the 'high' position and retracted the landing gear and flaps but did…NTSB FTW87DRD04Accident · No injuriesFinal reportGrumman G-164 · Rayne, LAThe aircraft's engine lost power and stopped while maneuvering. The aircraft impacted a dirt bank and nosed over in soft dirt/mud during the forced landing. Water was found in the fuel system and water was also found in the fuel tank of another aircraft…NTSB FTW87LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Jackson, LAEngine failed due to fuel exhaustion. Aircraft collided with trees short of rwy 33.NTSB FTW87LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Lake Providence, LAThe pilot, who reportedly was familiar with the 2200 x 90 foot sod strip, allowed the aircraft to drift left during the landing roll where the left main landing gear struck the end of a concrete culvert which did not extend quite to the extreme edge of the…NTSB FTW87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Many, LAAcft received substantial damage when it ran off the end of a 3,300' pvt airstrip into a lake during an attempted go around. The winds were calm. The plt reported that he landed long and fast over trees at the threshold and delayed initiating a go around…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.NTSB FTW87DRD02Accident · No injuriesFinal reportCessna A-188-B · Ft.Polk, LAExamination revealed the tail wheel assembly was badly worn and its spacers were missing, causing the swivel mechanism to lock in the off center position. The aircraft landed on a narrow road. It veered slightly upon tail wheel contact and went off the…NTSB 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.NTSB 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…NTSB FTW87LA020Accident · No injuriesLimited investigationFinal reportBarnes Firefly 7 · Holden, LAA commercially rated pilot on an instructional flight was attempting a touch and go landing in the median of hiway I-12 1 mile east of Holden, LA. The pilot failed to see and avoid some power lines substantially damaging the balloon. The pilot and student…NTSB FTW87LA013Accident · No injuriesLimited investigationFinal reportCessna 182J · England Afb, LAThe plt was on an apch into England Afb, LA, behind a flt of 4 jet fighters. He stated that at aprx 200 ft past the threshold, while at about 3 ft AGL & 80 mph, the acft suddenly fell & touched down on the main gear. It then porpoised btn the main & nose gear…NTSB FTW87DRD01Accident · No injuriesFinal reportCessna A188B · Gilbert, LAThe acft was conducting aerial application operations when a decrease in fuel pressure and engine surging occurred. Examination failed to reveal a reason for the loss of fuel pressure and the subsequent surging of the engine. The emergency landing had to be…NTSB FTW87LA002Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Minden, LAThe non-instrument rated plt entered IMC conditions while in cruise flt on a dark night at an altitude of 500 ft. he then entered a descent to reach VMC. During the descent, the helicopter collided with a tree at aprx 75 to 100 feet AGL,then crashed to the…NTSB FTW87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sulpher, LAThe pilot landed long at a private grass airstrip and deliberately ground looped the aircraft to avoid overrunning the airstrip into a three foot ditch. The nose gear collapsed during the ground loop and the wings and main gears were damaged when the aircraft…NTSB 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…NTSB FTW86FRD25Accident · 1 fatalFinal reportWSK PZL Mielec PZL-M18 · Mer Rouge, LAThe pilot pulled up steeply at the end of a spray run and started a turn-around. During this time he allowed the airspeed to bleed off to the point at which the aircraft stalled and entered a spin without sufficient altitude to recover before ground impact…NTSB FTW86LA163Accident · No injuriesLimited investigationFinal reportCessna 172N · Vick, LAThe pilot was given incorrect information as to the location of his destination airstrip. However, he found an airstrip at that approximate location. It was a 2500 foot grass strip as opposed to the 3600 foot grass strip which he was expecting. While on the…NTSB FTW86FRD24Accident · No injuriesFinal reportTexas Helicopter OH-13E/M74 · Port Allen, LAThe helicopter experienced partial power loss and descended to ground. It spray booms became entangled in the soy beans. The helicopter started to nose over, then rolled onto its right side and came to rest. Reason for the partial power loss is undetermined.NTSB FTW86LRD23Accident · No injuriesFinal reportGrumman G-164B · Lecompte, LAThe plt was engaged in an aerial application flt when a thunderstorm developed to the southwest of the airstrip. The plt was attempting to land to the east before the storm hit. Control of the acft was lost after touchdown and the acft nosed over. A 25 to 40…NTSB 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…NTSB FTW86LRD18Accident · No injuriesFinal reportGrumman G-164A · Bastrop, LAThe acft came to rest inverted with the engine under water after a power loss and forced landing. The plt stated that he started losing power in the turn to line up for his first aerial application run. The acft settled to ground impact in a landing attitude…NTSB FTW86LRD22Accident · No injuriesFinal reportGrumman G-164A · Franklin, LADuring aerial application, the pilot was maneuvering for alignment with a field, when the aircraft struck the ground. Nopreimpact mechanical malfunction or failure was evident.NTSB LAX86MA309Accident · No injuriesMajor investigationFinal reportAerospatiale AS-355F-1 · Morgan City, LAThe plt flew to a nearby arpt to practice takeoffs & lndgs. He rprtd that after 3 lndgs 'out of a hover,' he returned to the departure heliport & lndd again from a hover. Drg touchdown, the helicopter bgn to rock fm side to side & enteredground resonance. The…NTSB FTW86LRD21Accident · No injuriesFinal reportGrumman G-164A · Abbeville, LAThe pilot stated he experienced a loss of engine power and made a forced landing in a wet pasture where the aircraft flipped inverted before coming to a stop. Subsequent engine examination failed to reveal a reason for the power loss. The owner reported that…NTSB FTW86LRD19Accident · Minor injuriesFinal reportAir Tractor AT-301 · Campti, LAThe acft crash landed from about 60 ft AGL after the eng quit during the end of a cotton spraying operation. The plt said he just dived & 'pancaked' which sheared the landing gear. The reason for the power filure is unknown. The plt said he has had 20 power…NTSB 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…NTSB FTW86FRD17Accident · Minor injuriesFinal reportGrumman G-164 · Rayville, LAThe acft crashed during takeoff after losing pwr during a turn at 150 ft AGL. The plt said that the acft stalled and hit in a cotton field about 1/4 mile from the arpt. The plt also said oil hit the windshield about 3 seconds before pwr failure. The acft was…NTSB FTW86LRD15Accident · No injuriesFinal reportGrumman G-164B · Church Point, LAThe acfts left wingtip caught in weeds during takeoff and the acft was pulled left. The plt had turned to avoid a wet spot on the airstrip and contacted the high weeds then swerved into a rice levee.NTSB FTW86LRD20Accident · Serious injuriesFinal reportPiper PA-25-235 · Marksville, LAThe pilot delayed in his pullup from a spray swath run until there was insufficient time and distance to clear the line of trees at the end of the field. Airspeed decreased rapidly during the pullup. Tree impact occurred and the pilot was unable to recover…NTSB FTW86LA118Accident · Minor injuriesLimited investigationFinal reportCessna A185F · New Orleans, LAThe pilot decided to land due to rainy conditions shortly after departure. He had forgotten to retract the landing gear after takeoff and made a water landing with the gear down, causing the aircraft to invert and sink.NTSB FTW86LRD16Accident · No injuriesFinal reportGrumman G-164B · Abbeville, LAThe pilot stated he made a successful forced landing, due to loss of power, and then had to flip the aircraft to prevent colliding with a lateral (above ground irrigation system) with a water depth of about four feet. Subsequent engine examination revealed…NTSB FTW86LA119Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS35OD · Theriot, LAThe pilot experienced a sudden yaw in the helicopter at cruise flight. The ng started winding down confirming an engine failure. The pilot had to extend an autorotation over a tree line, which caused the RPM to decrease, and made a hard landing in an adjacent…NTSB FTW86FA115Accident · 1 fatalField investigationFinal reportCessna P206C · Grand Chenier, LAThe aircraft impacted the marshy terrain while in a very shallow descent and wings level attitude and at a relatively high speed (I.e.,cruise). It then cartwheeled and slid to a stop. There was evidence of substantial engine power being developed at impact.…NTSB FTW86FA116Accident · 1 fatalField investigationFinal reportMBB 105 · Houma, LAA fatigue failure in a main rotor blade pitch change link resulted in the loss of control of one blade, leading to an in flight separation of the tail boom. The helicopter was uncontrollable and pitched forward, impacting the ground inverted.NTSB FTW86LA105Accident · No injuriesLimited investigationFinal reportMaule M7-235 · New Orleans, LAThe plt lost directional control of the acft during the landing roll when he failed to compensate adequately for the x-wind resulting in a ground loop.NTSB FTW86LA101Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Timbalier, LADuring the ground run portion of a water take-off from a canal, the pilot encountered a strong gust of wind to the right of the aircraft nose. The pilot lost control of the aircraft and collided with an oil rig. The pilot failed to compensate for the…NTSB FTW86LA095Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Orange Grove, LADuring a part 135 check ride, the check plt had the plt execute a pwr off landing from an alt of 150 ft AGL. The plt reacted to the pwr loss by attempting a left turn to land. The acft then stalled and impacted the ground after the failure maintain airspeed.NTSB FTW86LRD13Accident · No injuriesFinal reportGrumman G164B · Morse, LAThe acft settled into power lines and stalled into the ground during a spray operation. The plt had turned downwind to line up for his spray run. The acft started descending and even though power was applied as load was jettisoned the acfts tail wheel snagged…NTSB FTW86LRD12Accident · No injuriesFinal reportGrumman G-164A · Branch, LAShortly after takeoff, a partial power loss occurred & the plt made a forced landing in a soft plowed field, where the acft nosed over onto its back. The plt rprtd the loss of power was due to failure of the eng blower.NTSB FTW86LRD14Accident · No injuriesFinal reportGrumman G-164A · Guedan, LAThe pilot lost engine power at an altitude of about 150 feet AGL following takeoff. He impacted a raised roadbed during the forced landing, flipped inverted, slid to a stop, and burned. The fire damage prevented determination of the cause of engine failure.NTSB FTW86FA079Accident · 6 fatalField investigationFinal reportCessna 411A · Bossier City, LAThe pilot reportedly did an unusual amount of engine run-up before pulling onto the runway. He then performed another run-up before departing. This is evidence that he was aware of a problem with his aircraft. The engine(s) were popping and puffing black…NTSB FTW86FA073Accident · 1 fatalField investigationFinal reportPartenavia P68C · Goudeau, LAThe pilot received a weather briefing indicating IMC conditions existed at the point of departure and at reporting stations near the point of the first intended landing. (There was no reporting stations at the airport of intended landing). Weather conditions…NTSB FTW86LA057Accident · No injuriesLimited investigationFinal reportCessna 185F · Point Aufer, LAThe pilot reported losing control of his aircraft, during takeoff from a canal at Point Aufer island, LA, when gusty wind conditions lifted a wing, causing the aircraft to collide with a bank. After the collision, the aircraft continued up onto the canal…