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 FTW90DRD02Accident · No injuriesFinal reportC&J Sontheimer Rotorway · Lake Charles, LAFailure of the tail rotor drive belt.NTSB FTW90LA054Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Bastrop, LALoss of engine power due to water contamination in the fuel. A factor related to the accident was: inadequate design of the fuel system drains, which prevented an adequate preflight of the fuel system.NTSB FTW90LA049Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Hammond, LAPilot in command's initiation and continuation of the flight into an area of known IMC weather conditions and his subsequent inability to land prior to running out of fuel. Contributing factors to the accident were the pilot's failure to exercise good…NTSB FTW90DRD01Accident · No injuriesFinal reportLong E-Z-E Long E-Z-E- · Hammond, LAInadequate aircraft handling and recovery from a bounced landing. Factors were gusty wind conditions, the pilot's failure to maintain directional control, and the pilot's lack of familiarity with the airplane.NTSB FTW90IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Baton Rouge, LAThe captain's excessive speed during a turn off of the runway, and his failure to maintain directional control. The wet taxiway was a related factor.NTSB FTW90LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Port Allen, LAFuel system contamination due to inadequate maintenance/service of the airplane.NTSB FTW90FA033Accident · 2 fatalField investigationFinal reportCessna 182P · Slidell, LAThe pilot's initiation of the flight into known adverse weather conditions which resulted in spatial disorientation and his failure to maintain sufficient altitude over the water. Factors were: darkness and the adverse weather conditions that prevailed.NTSB FTW90LA019Accident · No injuriesLimited investigationFinal reportCessna 182J · Leesville, LAThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was: the lack of a suitable landing area.NTSB FTW90LA017Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Thibodaux, LAStudent pilot's failure to obtain or maintain airspeed during an aborted landing, which resulted in an inadvertent stall/mush. His failure to maintain runway alignment and the ditch were related factors.NTSB FTW90LA003Accident · No injuriesLimited investigationFinal reportAerospatiale 350D · New Iberia, LAThe second pilot's (under instruction) misjudgement of aircraft attitude during the level off phase of the autorotationNTSB FTW90LA001Accident · Serious injuriesLimited investigationFinal reportGlobe GC-1B · Sulphur, LAThe failure of the landing gear to completely retract which resulted in the inability to gain sufficient airspeed to perform the climbing maneuver.NTSB FTW89FA172Accident · 1 fatalField investigationFinal reportCessna 210D · Covington, LAThe pilot in command's disregard of the weather information provided during two briefings and his decision to continue VFR flight into IMC condtions. Factors contributing to the accident were the pilot's lack of night and instrument experience.NTSB FTW89DRD16Accident · Serious injuriesFinal reportSours/Midget Mustang SM-1 · Franklinton, LAA total loss of engine power for undetermined reasons. Trees in the emergency landing area were a related factor.NTSB FTW89DRD15Accident · Serious injuriesFinal reportCessna 188 · Winnsboro, LAThe pilot's inadequate visual lookout and subsequent collision with a tree.NTSB FTW89DRD14Accident · No injuriesFinal reportGrumman G-164A · Franklin, LAFatigue failure of the propeller blade, which resulted in separation of the blade's tip and severe engine vibration. The soft terrain was a related factor.NTSB FTW89FA159Accident · 3 fatalField investigationFinal reportCessna 152 · Houma, LAThe failure of both pilots to see-and-avoid each other's aircraft (inadequate visual lookout). A probable factor was: failure of either pilot to issue a traffic advisory.NTSB FTW89GA156Accident · Minor injuriesFinal reportPiper PA-18-150 · Grand Chenier, LAOn August 30, 1989, at 1225 CDT, a Piper PA-18-150, N4423Z,being operated by and conducting an aerial survey forlouisiana wildlife and fisheries commission as a publicaircraft, flipped forward to the inverted position during aforced landing 15 miles…NTSB FTW89LA153Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Jonesboro, LAThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control, which resulted in a porpoise off the side of the runway. The tree was a related factor.NTSB FTW89IA152Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Kenner, LAInaccurate operators procedures/directives and the improper takeoff performance data computed by the captain. Poor flight crew coordination was considered a factor as well a wrong runway selection for the computed takeoff data.NTSB FTW89DRD13Accident · No injuriesFinal reportBell 47G-3B-1 · Rayville, LAFailure of the pilot to maintain sufficient rotor RPM. A factor related to the accident was: the cotton crop.NTSB FTW89LA150Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAPilot's improper emergency procedures and flare that led to a hard landing and roll over. Factors in the accident were the pilot's decision to initiate an autorotation following an undetermined event and failure to maintain directional control during the…NTSB FTW89FA143Accident · 1 fatalField investigationFinal reportBalloon Works Firefly 6B · Baton Rouge, LAThe pilot exceeded the temperature limitations of the Balloon during the climb, which resulted in failure of the frabric. Factors related to the accident were: the previous heat damage to the frabric, and the lack of maintenance by the pilot/owner.NTSB FTW89DRD12Accident · No injuriesFinal reportSchweizer G-164B · Donaldsonville, LALoss of engine power for undetermined reasons. A contributing factor was the soft terrain.NTSB FTW89DRD11Accident · No injuriesFinal reportSchweizer G-164A · Lake Arthur, LALoss of engine power for undetermined reasons. The high weeds (vegetation) & levee (dirt bank) were considered to be related factors.NTSB FTW89LA140Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Gueydan, LAThe pilot's inadvertent spin entry at pattern altitude which resulted in ground collision.NTSB FTW89FA128Accident · 1 fatalField investigationFinal reportCessna P210N · Houma, LAIncapacitation of the 70 year old pilot, which led to the loss of control of the airplane.NTSB FTW89DRD10Accident · 1 fatalFinal reportGrumman G-164-B · Mer Rouge, LAThe failure of the individual struck by the taxiing airplane's propeller to visually perceive and avoid the airplane.NTSB FTW89LA119Accident · No injuriesLimited investigationFinal reportCessna A185F · Marksville, LAFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and a subsequent nose over.NTSB FTW89DRD09Accident · No injuriesFinal reportSchweizer G-164A · Bunkie, LAThe loss of the number five cylinder in flight, resulting in a loss of engine RPM. The pilot misjudged the landing flare height due to obscured vision from fire and smoke and the airplane stalled and impacted the ground nose first.NTSB FTW89LA114Accident · No injuriesLimited investigationFinal reportCessna 150J · Minden, LAThe loss of engine power due to improper maintenance performed during an annual inspection 1.6 flying hours prior to the accident which resulted in the mixture control becoming disconnected.NTSB FTW89DRD08Accident · Minor injuriesFinal reportSchweizer G-164B · Kaplan, LALoss of engine power due to a cracked cylinder.NTSB FTW89DRD07Accident · No injuriesFinal reportGrumman-Schweizer G-164A · Morse, LALoss of engine power for an undetermined reason. The soft terrain was a contributing factor.NTSB FTW89DRD06Accident · No injuriesFinal reportGrumman-Schweizer G-164B · Ville Platte, LAWear and/or failure of the carburetor/float. Factors related to the accident were: the terrain conditions.NTSB FTW89LA106Accident · No injuriesLimited investigationFinal reportBell 206L · Abbeville, LAPartial loss of engine power for an undetermined reason. Factors related to the accident were: person(s) in the intended emergency landing area and soft terrain where the helicopter touched down.NTSB FTW89DRD05Accident · Minor injuriesFinal reportGrumman G-164A · Gueydan, LAVisual lookout was not maintained by the pilot in command, which resulted in the collision with a power transmission line during a swath run.NTSB FTW89DRD04Accident · No injuriesFinal reportSchweizer G-164A · Oak Grove, LAThe pilot failed to perform adequate prelight planning/preparation before attempting a takeoff by failing to assure the runway condition.NTSB FTW89DRD03Accident · 1 fatalFinal reportSchweizer G-164A · Maxie, LAFailure of the pilot to maintain clearance from the trees. A factor related to the accident was: the presence of trees near the field where fertilizer was to be dispensed.NTSB FTW89FA089Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601 · New Iberia, LAThe pilot failed to maintain a proper climb immediately after takeoff. Contributing to the accident was excessive manifold pressure indications for the left engine. The pilot's diverted attention in dealing with that condition most probably resulted in the…NTSB FTW89LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Lake Arthur, LAThe failure of the pilot to see and avoid tree limbs that extended over the edge of the canal. Factors related to the accident were: the tree limbs and dirt bank near the edge of the selected landing area.NTSB FTW89FA065Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · New Orleans, LAThe pilot diverting his attention from flying the aircraft while complying with the departure control instructions, and allowing the aircraft to descend into the water.NTSB FTW89LA048Accident · Serious injuriesLimited investigationFinal reportPitts S2B · Walker, LALoss of total engine power due to fuel exhaustion. Fuel exhaustion occurred due to the pilot's failure to perform fuel consumption calculations. Contributing was the inadequate fuel quanity sight gauge in the rear cockpit, which was occupied by the PIC.NTSB FTW89FA042Accident · 1 fatalField investigationFinal reportCessna 150L · Zachary, LAThe pilot's loss of aircraft control due to spatial disorientation after encountering instrument meteorological weather conditions (IMC) shortly after takeoff, his intentional takeoff into adverse weather conditions, and the operator's inadequate supervision…NTSB FTW89DRD02Accident · Minor injuriesFinal reportPiper PA-25-235 · Bogalusa, LAThe pilot's failure to refuel the airplane prior to the last takeoff resulting in an inadequate fuel supply for the flight.NTSB FTW89IA038Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas DC9-30 · Baton Rouge, LAThe proper touchdown point was not attained by the flight crew. (Copilot was flying and the PIC was supervising).NTSB FTW89LA032Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Houma, LAThe airplane was on an IFR flight plan but was in VFR conditions when the communications radios failed. Pilot used hand held transceiver, but communications were not satisfactory. Pilot elected to continue to destination but did not declare an emergency nor…NTSB FTW89LA026Accident · No injuriesLimited investigationFinal reportBell 206B · Chalmette, LAThe rated pilot's inadequate takeoff technique the the instructor pilot's momentary lack of judgement in having the pilot attempt a hydraulics off takeoff.NTSB FTW89DRD01Accident · Minor injuriesFinal reportSandridge KR-2 · Monroe, LAAs the plt was taxiing to takeoff, the tower adzd him that wind shear advisories were in effect. At aprx 1359, he was clrd for takeoff on rwy 31. At that time, the wind was from 280 deg at 18 KTS. Drg takeoff, the acft was climbing thru about 300 to 500 ft,…NTSB FTW88DRD21Accident · No injuriesFinal reportAir Tractor AT301 · Ferriday, LAThe agricultural airplane was on a swath run when the engine malfunctioned. The pilot released the load of chemicals and made a forced landing in a bean field. There was very little damage to the beans but there was substantial damage to the airplane.…NTSB FTW88LA159Accident · No injuriesLimited investigationFinal reportCessna 180H · Welsh, LAThe pilot was landing the tailwheel type airplane on runway 6 while the winds were from 270 degrees at 15 knots, gusting to 25 knots. After touchdown, it ballooned several feet, touched on the left wheel, then the left wing tip and flipped forward to the…NTSB FTW88DRD20Accident · 1 fatalFinal reportAlon A2A · New Orleans, LAThe highly modified airplane was observed in a near vertical dive before it impacted into a marsh. No mechanical or medical reasons were found for the crash. Although toxicological analysis indicated a blood alcohol level of .11%, there was evidence of…