NTSB investigations, LA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 FTW96LA386Accident · Minor injuriesLimited investigationFinal reportBell 206L-1/C-30P · Morgan City, LAThe loss of tail rotor control as result of a tail rotor blade strike by an undetermined object. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA378Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Loreauville, LAThe pilot's inadequate preflight planning/preparation for the flight, resulting in exceeding the maximum gross weight and performance of the helicopter. A factor was the high density altitude.NTSB FTW96FA368Accident · 2 fatalField investigationFinal reportCessna 150F · Jones, LAVFR flight into instrument meteorological conditions (VMC), and failure of the pilot (PIC) to maintain control of the airplane after becoming spatially disorientation. Factors relating to the accident were: darkness, the adverse weather condition (fog and…NTSB FTW96GA365Accident · 2 fatalFinal reportPiper PA-23-250 · Jennings, LAThe pilot's failure to maintain clearance. Factors were the pilot's lack of recent experience in the make and model of airplane, the dark night, and fog.NTSB FTW96LA356Accident · No injuriesLimited investigationFinal reportBell 47 Soloy · Intracoastal, LAthe loss of aircraft control by unknown person(s).NTSB FTW96LA355Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Clinton, LAthe instructor pilot's failure to follow recommended procedures to properly brace himself in preparation for landing.NTSB FTW96LA338Accident · No injuriesLimited investigationFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain airspeed and altitude/clearance during the takeoff. A factor was the density altitude.NTSB FTW96LA333Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Clayton, LAThe pilot's failure to maintain directional control during the takeoff roll. A factor was the wet grass runway.NTSB FTW96LA332Accident · No injuriesLimited investigationFinal reportAyres S2R-G5 · Start, LAa leak in the turbine scavenge pump oil supply line, due to chafing of its separated shield assembly, which resulted in an oil leak, oil starvation, and activation of the propeller feathering system.NTSB FTW96FA319Accident · 2 fatalField investigationFinal reportChester Glasair RG · Lafayette, LAfailure of the pilot to maintain proper altitude (and clearance above wooded terrain), while diverting to an alternate destination. Factors relating to the accident were: the loss of the comm/nav equipment as a result of an electrostatic discharge, darkness,…NTSB FTW96LA285Accident · No injuriesLimited investigationFinal reportHiller UH12 · Franklin, LAloss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM. A factor was the unsuitable terrain available for the precautionary landing.NTSB FTW96LA277Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Providence, LAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise motion of the airplane and subsequent damage.NTSB FTW96LA257Accident · Minor injuriesLimited investigationFinal reportOwens/Smyth Sidewinder · Minden, LAThe pilot's improper fuel consumption calculations resulting in fuel exhaustion. A factor was the unsuitable terrain for the forced landing.NTSB FTW96LA231Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe pilot's failure to maintain control of the airplane.NTSB FTW96FA228Accident · 1 fatalField investigationFinal reportAir Tractor AT-401 · Lake Providence, LAfailure of the pilot to maintain sufficient airspeed, while maneuvering (turning), which resulted in an inadvertent stall and collision with the terrain. The high gusty wind condition was a related factor.NTSB FTW96LA218Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-160 · Belcher, LAThe pilot's failure to maintain aircraft control in flight. A factor was the gusty wind.NTSB FTW96FA216Accident · 2 fatalField investigationFinal reportNanchang CJ-6A · Shreveport, LAa loss of engine power due to failure of the pressure carburetor diaphragm which led to restricted fuel flow through the carburetor and eventual fuel starvation. Factors contributing to the accident were the unsuitable terrain and tall trees which resulted in…NTSB FTW96LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Iowa, LAthe pilot's selection of an unsuitable area for takeoff. The high vegetation (tall grass) was a related factor.NTSB FTW96FA200Accident · 1 fatalField investigationFinal reportNorth American Harvard MK II · Lafayette, LAfailure of the pilot to maintain adequate airspeed and/or altitude, while performing aerobatic flight.NTSB FTW96LA175Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Franklin, LAThe pilot's poor judgment in attempting to refuel the helicopter with the engine (and rotors) operating. Factors relating to the accident were: the gusty wind condition, and close proximity of the vehicle that was allowed to be driven under the turning rotors.NTSB FTW96LA171Accident · 1 fatalLimited investigationFinal reportCessna U206G · Venice, LAthe pilot's inadvertent flight into instrument meteorological conditions. A factor was the fog.NTSB FTW96LA166Accident · No injuriesLimited investigationFinal reportCessna 182RG · Welsh, LAa loss of engine power for undetermined reasons. A factor was the unsuitable terrain for the emergency landing.NTSB FTW96LA159Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A · Hughes, LAthe pilot exceeding the maximum authorized crosswind component of the airplane. Factors were the crosswind and the side sloping runway.NTSB FTW96LA154Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Slidell, LAthe pilot's failure to maintain aircraft control during the approach, and his failure to execute a go-around. A factor was the gusting wind.NTSB FTW96FA151Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · New Orleans, LAThe in-flight loss of a bolt in the elevator control system due to improper installation by unknown person(s), which resulted in a disconnection of the elevator control system that rendered the airplane uncontrollable.NTSB FTW96LA147Accident · Minor injuriesLimited investigationFinal reportBell 206BIII · Houma, LAthe pilot's attempted maneuver which exceeded the dynamic capability of the helicopter.NTSB FTW96LA144Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Clinton, LAthe pilot's improper positioning of the fuel selector which resulted in fuel starvation. Factors were the dark night light condition and the worn spark plugs.NTSB FTW96LA140Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S49A · Vidalia, LAthe pilot-in-command's inadequate supervision of the ground crewmember.NTSB FTW96LA128Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Iowa, LAthe pilot's selection of the wrong runway for landing, his delay in initiating a go-around (aborted landing), and his failure to maintain clearance from the transmission lines. Factors relating to the accident were: the pilot's improper weather evaluation,…NTSB FTW96LA122Accident · No injuriesLimited investigationFinal reportCessna 182P · New Orleans, LAThe pilot not following procedures and directives in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing weather conditions and lack of suitable terrain for landing.NTSB FTW96LA103Accident · No injuriesLimited investigationFinal reportCessna A185F · Belle Chase, LAThe pilot's inadequate compensation for the wind conditions, which resulted in a loss of directional control and subsequent encounter with a ditch. The crosswind was a related factor.NTSB FTW96LA099Accident · No injuriesLimited investigationFinal reportCessna 182K · Covington, LAthe pilot's delayed touchdown which resulted in a landing with inadequate runway remaining under the wet runway condition. A factor was the wet grass runway.NTSB FTW96LA096Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mandeville, LAthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from obstructions (power lines) at night.NTSB FTW96FA060Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Thibodaux, LAfailure of the pilot to maintain clearance from the power line and utility pole. The gusty/crosswind (weather) condition was a related factor.NTSB FTW96LA001Accident · No injuriesLimited investigationFinal reportAerostar S60A · Baton Rouge, LAThe pilot's failure to compensate for wind conditions and maintain adequate clearance from the power lines during the approach. A factor was the sudden wind gust.NTSB FTW95IA397Incident · No injuriesIncident investigationFinal reportMBB BO-105C · Lafayette, LAa short in the 'jam proof system' solenoid valve which prevented activation of the backup hydraulic system and resulting in a cyclic hardover. Factors were the contaminated hydraulic fluid and the resulting jammed actuator (longitudinal control slider).NTSB FTW95LA344Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Monroe, LAThe student pilot's improper flare and the inadequate supervision by the flight instructor.NTSB FTW95LA332Accident · 1 fatalLimited investigationFinal reportCessna A188B · Fort Necessity, LAThe pilot's failure to maintain terrain clearance. A factor relating to the accident was: the gusty wind conditions.NTSB FTW95LA331Accident · No injuriesLimited investigationFinal reportGrumman G-164A · St.Francisville, LAThe pilot's failure to maintain clearance with the obstruction on short final. A factor was the low visibility.NTSB FTW95LA327Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Monroe, LAThe pilot's improper positioning of the fuel selector resulting in fuel starvation and the failure of the pilot to follow the published emergency procedures for propeller feathering. Factors were the fence and the trees.NTSB FTW95LA293Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Simmesport, LAThe loss of engine power as result of the failure of the number 7 cylinder. A factor was the lack suitable terrain for the forced landing.NTSB FTW95LA289Accident · No injuriesLimited investigationFinal reportCessna 182 · Port Sulphur, LAThe pilot's misjudgement of his short field landing resulting in an intentional ground loop to avoid an overrun. Factors were the reduced braking effectiveness on the wet grass runway.NTSB FTW95LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cheneyville, LAThe pilot's failure to maintain adequate airspeed at a low altitude.NTSB FTW95LA246Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18 Dromader · Jennings, LAThe partial power loss for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA240Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Iowa, LAThe failure of the right brake due to the hydraulic fluid leaking. Factors were proper alignment not possible and the close proximity of the ditch.NTSB FTW95LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ville Platte, LAThe pilot's failure to clear a levee during the approach. A factor was a truck parked on the runway.NTSB FTW95LA205Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · St Martinville, LAThe pilot's failure to maintain control of the aircraft. A factor was the high winds.NTSB FTW95LA197Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Abbeville, LAThe inadvertent stall.NTSB FTW95FA186Accident · 1 fatalField investigationFinal reportBell 206L-3 · Venice, LALoss of engine power due to ingestion of exhaust fumes from an oil platform flare boom.NTSB FTW95LA185Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Morse, LAPower loss due to a cracked intake valve pipe assembly. A factor was the lack of suitable terrain for the forced landing.