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 FTW85LA183Accident · No injuriesLimited investigationFinal reportMitsubishi MU2J · Patterson, LAOn visual final apch to the arpt at night the acft entered ground fog. Reflection of the landing lights in the fog was distracting. The acft landed in the adjacent seaplane landing area instead of on the hard surface rwy. A subsequent inspection of the aprt…NTSB FTW85FA188Accident · Serious injuriesField investigationFinal reportBell UH-1B · Boutte, LAThe plt had stabilized acft in a 125' hover, prior to picking up a load, when the eng spooled down and acft entered talltrees with low rotor RPM and pitched nose down as it descended thru the trees. Ground witnesses heard 2 loud 'bangs' prior to the acft…NTSB FTW85FA181Accident · 4 fatalField investigationFinal reportCessna 320B · Athens, LAThe acft was on an instrument flt plan. The plt had received a pre takeoff weather briefing. He was briefed on the area of weather that was at the acft's twelve o'clock position four miles in front. The area was thirty miles southwest and twenty miles wide.…NTSB FTW85FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Franklin, LAAcft crashed into a crawfish pond during a forced landing at night following a power loss as a result of fuel exhaustion. After departure, the plt contacted ARTCC and stated that his alternator was out. With center help, alternator was restored and plt cont'd…NTSB FTW85LA164Accident · No injuriesLimited investigationFinal reportCessna 172M · Angola, LAThe acft touched down short of the rwy following an approach to land after the plt had accomplished a x-country flt with a pass'g on board. The plt stated that he became momentarily disoriented due to haze & bright sunlight during the approach. During this…NTSB 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…NTSB FTW85LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Houma, LAThe plt was attempting to takeoff from a short muddy strip near Houma, LA. He elected to abort the takeoff & applied brakes. The acft then rolled over a dry area on the strip, where braking action became effective & the aircraft nosed over. No mechanical…NTSB FTW85LA132Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dequincy, LAEn route back to a private air strip, according to the plt, the engine failed. The engine re-started and ran for 2 to 3 seconds before stopping. The aerial application acft flew a forced ldg into pine trees coming to a stop suspended above the ground.…NTSB FTW85LA121Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Holmwood, LAThe acft was 1 of 2 that were being repositioned form 1 ag strip to another. While en route, the flt encountered dense fog & the lead plt initiated a 180 deg turn. During the turn, the 2nd acft (N60885) was about 100 ft in trail of the 1st acft at aprx 150 ft…NTSB FTW85LA119Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A · Houma, LAThe aircrew had just completed a medivac flt & were repositioning the helicopter to the home base. While they were en route, the company dispatcher informed the crew that fog was moving into the area & that they had better hurry. During the night apch, the…NTSB FTW85LA124Accident · No injuriesLimited investigationFinal reportCessna T-188C · De Quincy, LAThe acft made an emergency landing in trees following an eng failure at 200 ft AGL. Shortly after departure from an ag strip, the eng oil temp started rising. The plt started a turn to return to the strip. During the turn the eng seized and the plt landed in…NTSB FTW85LA108Accident · No injuriesLimited investigationFinal reportCessna 182A · Covington, LADuring an apch to land, the eng lost power & the plt made an off arpt landing. While he was landing, the acft collided with a levee & was damaged. Ample fuel was still remaining in the acft & no preimpact failure or malfunction was found that would have…NTSB FTW85LA110Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Shreveport, LAThe plt landed on rwy 05 which was icy and covered with a blanket of fresh snow. He stated the wind was from 360 degs at 10 KTS. He had been informed of poor braking conditions on the rwy. The plt used main wheel brakes and reverse thrust. The acft drifted…NTSB FTW85LA107Accident · No injuriesLimited investigationFinal reportCessna A185F · Belle Chase, LAThe plt had diverted back to the departure aprt due to wx. After landing, he was 'step taxiing' on the water with no reported difficulties when a landing gear shock strut, p/n 51961, separated. This allowed a float to dig into the water & caused the acft to…NTSB FTW85LA103Accident · Minor injuriesLimited investigationFinal reportCessna 172B · Coushatta, LAThe acft was on its 1st flt following maintenance for a previous nose gear shimmy problem. When the student made his 1st attempt to land, he noticed that the nose gear seemed to be cocked, so he aborted the landing. On the 2nd attempt, the acft swerved to the…NTSB FTW85FA100Accident · No injuriesField investigationFinal reportBell 206L-1 · Lafayette, LAThe acft departed at 2040 CST as a flt of 2 on a ferry flt. Shortly after level-off at 700 ft and power stabilized at 72% torque the engine failed and the acft yawed left and right. An autoration was initiated into a soft plowed field with a slight…NTSB FTW85FA094Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Ferriday, LAAcft was observed in slow flt aprx 40 ft AGL just above stall speed with the eng operating smoothly. The acft then stalled and impacted in an aprx 90 deg nose down attitude. The plt was flying from the front seat. The acft was not equipped with shoulder…NTSB FTW85LA091Accident · No injuriesLimited investigationFinal reportCessna 210L · Monroe, LAThe acft suffered a collapsed nose gear after losing and regaining power during an ILS approach and finally completing an emergency landing two miles from the rwy of intended landing. There were no injuries and no fire. Examination of the acft in the field…NTSB FTW85LA089Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Houma, LAThe plt departed into known bad wx with low ceilings and poor visibility. Very shortly after takeoff the plt elected to return to the arpt. During a descending right turn the plt broke out of IMC at a very low altitude. He pulledcollective but still landed…NTSB FTW85FA084Accident · 4 fatalField investigationFinal reportBeech A36 · Lake Charles, LAThe acft crashed 3 miles short of the Lake Charles airport while on an ILS approach. Instrument meteorological conditions prevailed at the time of the accident, and an IFR flight plan was filed by the non-instrument rated pilot. A review of the radio…NTSB BFO85IA056Incident · No injuriesIncident investigationFinal reportBoeing 747-200 · New Orleans, LADuring arrival, a Boeing 747, registration number d-abyp, lufthansa flight 5432, was vectored for an ILS localizer backcourse apch to rwy 19 at the new orlean intl arpt. While on the apch at 2000 ft MSL, the aircrew were instructed by the arrival controller…NTSB 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…NTSB 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…NTSB 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…NTSB 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…NTSB FTW85LA042Accident · Minor injuriesLimited investigationFinal reportCessna 441 · Grand Chenier, LAThe pilot told the cameron parrish sheriff that he was attempting to land the aircraft at a small agricultural landing strip after one of the two engines quit due to fuel starvation. The pilot stated that there was nothing wrong with the aircraft except that…NTSB 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…NTSB FTW85LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · New Orleans, LAAccording to the CFI there was no intention to perform 'touchdown' autorotation landings. During the third simulated power loss the CFI reported that he initiated the flare at about 55 ft AGL. As airspeed dissipated and the sink rate continued the CFI…NTSB FTW85LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Bogalusa, LAThe solo student plt landed 8 to 10 ft short of the rwy and rolled into the asphalt lip of the prepared surface. Touchdown occurred in an area of construction lengthening the rwy.NTSB FTW85FA006Accident · 2 fatalField investigationFinal reportCessna 152 · Monroe, LAPrior to dep the plt contacted the Monroe fss twice requesting a wx briefing. Both times VFR flt was not recommended due to IFR conditions with low ceilings en route and forecast fog at the dest. During the second call the plt stated that it was clear at the…NTSB FTW85LA004Accident · No injuriesLimited investigationFinal reportCessna A185E · Morgan City, LAPlt arrived at intended lndg site on remote pipeline canal where quarter boat was operating, overflew site and visually checked conditons. After 100-150 yds of landing roll, the right float struck a submerged object. Float filled with water and acft rolled…NTSB FTW85LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Luling, LAThe plt stated that on final approach a gust of wind carried the acft to the right of the runway. Acft right wing struck a tree. Acft yawed right and contacted ground in uncontrolled flight.NTSB FTW85LA001Accident · No injuriesLimited investigationFinal reportCessna TU206G · Chandeleur Isl, LAPlt was flying low and slow in area awaiting arrival of boat for fishing party. Plt allowed his attention to be distracted by spotting fish & inadvertently contacted water with a float. Acft came to rest inverted in 6 inches of water.NTSB FTW84LA395Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mandeville, LAThe acft made an emerg landing on the south lanes of the lake pontchatrane causeway bridge after encountering a loss of eng power. Examination of the acft fuel tanks revealed both tanks empty. Activation of the fuel tank drain valves & the fuel strainer…NTSB FTW84LA390Accident · No injuriesLimited investigationFinal reportFairchild M-62A (PT-19) · Melville, LAThe student plt stated that the acft touched down long and bounced. He applied power to go-around and lost directional control colliding with a fence on the left side of the rwy. The wind was clam.NTSB FTW84LA378Accident · Minor injuriesLimited investigationFinal reportBell 206B · Houma, LAThe helicopter was on a cargo, non scheduled air taxi flight when the plt smelled smoke. A precautionary landing was made on a beach after which the acft was destroyed by fire.NTSB FTW84LA364Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Schriever, LAThe plt stated that he had full fuel & a full load of spray when the eng exploded. The nature & cause of the pwr failurewas not determined & external examination of the eng revealed no evidence of a mechanical failure.NTSB FTW84LA366Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Oak Grove, LAAircraft landed with a flat left main tire, veered left and nosed over inverted.NTSB FTW84LA362Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Pecan Island, LADue to the wet condition of the sod strip the plt used only the last 1,000 ft of the strip for the takeoff. During the roll he felt that insufficient rwy remained and initiated an aborted takeoff. Unable to stop however the plt resumed the attempted takeoff.…NTSB FTW84LA363Accident · 1 fatalLimited investigationFinal reportAir Tractor AT301 · Plain Dealing, LAWitnesses reported that the acft made a descending low level turn at the end of a spray run, nosed over and dove into the soybean fld being sprayed. The plt was not wearing a shoulder harness or helmet when the accident occurred. Toxicology results revealed a…NTSB FTW84FA354Accident · 2 fatalField investigationFinal reportCessna 180J · Lafitte, LAWitnesses observed the acft approach an oil production platform located in a marshy area near the destination airstrip. They reported that the acft made an abrupt, steep left turn at 200 to 300 ft AGL, followed by what they described as an accelerated stall.…NTSB FTW84LA350Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Minden, LADuring a night instructional flt on landing approach, the instructor pilot reported that the student over corrected for a high approach by closing the throttle. The acft hit the ground before he could establish control of the resulting high rate of sink.NTSB FTW84LA349Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Tallulah, LAAfter applying seven (7) loads of chemicals the pilot landed and loaded both fuel and chemicals. After takeoff he completed one swath run and was just starting the second run when he allowed the wheels to contact the crop. The load was not jettisoned and the…NTSB FTW84LA341Accident · No injuriesLimited investigationFinal reportMooney M20 · Thibodaux, LAAt 0729 CDT the plt filed a flight plan and obtained a wx brief forecasting moist unstable air with several scattered and broken cloud layers beginning at 1,500 ft. the briefer further advised the plt of thunderstorm activity at various locations along the…NTSB FTW84LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Woodworth, LAThe plt approached an unfamiliar area at less than 500 ft AGL and landed on an abandoned drag race strip about 3 miles from the dest airp. Directional control was lost very shortly after touchdown when the acft collided with dirt piles on the surface of the…NTSB FTW84FA329Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Lake Charles, LAAt aprx 250 ft ag., according to witnesses, eng sounds indicated that power was reduced to idle. The acft rolled into a steep left descending turn followed by the application of power just prior to impact. The CFI was known to have given other students…NTSB FTW84LA318Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Kinder, LAThe heavily loaded acft was turned shortly after takeoff and began to settle. The plt started to dump the load but the acft contacted trees during the attempt and crashed. The acft was loaded with fertilizer and nearly full of fuel. The temperature was 90…NTSB FTW84LA312Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lake Charles, LAThe plt landed on the edge of a 90 ft wide turf rwy which was soft due to recent rains. The acft drifted off into a ditch causing the collapse of the left main gear.NTSB FTW84FA302Accident · 1 fatalField investigationFinal reportMooney M-18LA · New Iberia, LAA plt witness observed the acft in a 20 to 30 deg dive at high speed just prior to the accident. He reported that at an alt of about 1200 to 1300 ft, the acft began a pull-up. As the pull-up was started, the outboard portion of the acft's left wing folded…NTSB FTW84LA301Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Killian, LAThe acft crashed while in a steep bank at low alt in VMC wx.a witness who knew the plt said he heard the acft approaching, went outside his house and saw the acft at about 200 ft AGL. The acft went into a turn and became almost inverted before colliding with…