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 FTW04LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oil City, LAA loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed resulting in a stall..NTSB FTW04LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Many, LAThe pilot's improper touchdown which resulted in a hard landing.NTSB FTW04CA106Accident · No injuriesData collectionFinal reportCessna 172K · Bogalusa, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04CA098Accident · No injuriesData collectionFinal reportStinson 108-1 · Slidell, LAthe pilot's failure to compensate for the gusty wind conditions and maintain control of the airplane while landing.NTSB FTW04LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Mamou, LAThe pilot's delay in aborting the landing. A contributing factor included the entrance of a crawfish boat onto the airstrip.NTSB FTW04LA091Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plain Dealing, LAA loss of engine power due to undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA086Accident · No injuriesLimited investigationFinal reportLake LA4-270T · Crowley, LAThe pilot's inadvertant water landing with the landing gear extended. Contributing factors were the sunglare and the pilot's failure to verify the position of the flaps and landing gear.NTSB FTW04LA082Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Ville Platte, LAThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04LA067Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Patterson, LAThe in-flight separation of the helicopter's left winglet due to pre-existing cracks resulting in the winglet striking the tail rotor in-flight, and subsequent loss of directional control.NTSB FTW04LA063Accident · No injuriesLimited investigationFinal reportCessna 172K · Lake Charles, LAThe disintegration of the piston, which resulted in the catastrophic failure of the engine. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW04IA077Incident · No injuriesIncident investigationFinal reportBell BH-212 · Galliano, LAThe loss of tail rotor control due to sheared, loose, and bent bolts which secured the tail rotor pitch control bellcrank support bracket.NTSB FTW04IA043Incident · No injuriesIncident investigationFinal reportBell 206B · Venice, LAThe failure of the forward boost pump while in cruise flight while operating with less than 10 gallons of fuel onboard, which resulted in a loss of engine power. A factor was the inoperative forward fuel boost pump caution light switch.NTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.NTSB FTW03LA216Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Kisatchie, LAA loss of engine power due to water contamination in the fuel system.NTSB FTW03LA204Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Winnsboro, LAThe pilot's inadequate inflight planning, which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB CHI03FA259Accident · 3 fatalField investigationFinal reportBell 206L-3 · E.I. 276, LAThe inadequate compensation for crosswind conditions and the directional control not obtained/maintained by the pilot during takeoff. Contributing factors were the crosswind and the planned approach to position the helicopter with a crosswind in order to…NTSB FTW03LA166Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Franklinton, LAThe pilot's encounter with dynamic rollover due to his failure to properly remove the tie-down strap on the right skid prior to takeoff. Factors were the pilot's inadequate preflight preparation and failure to abort takeoff.NTSB FTW03TA156Accident · No injuriesFinal reportBell 407 · Franklin, LAThe loss of tail rotor effectiveness due to the inadequate maintenance performed by other company personnel.NTSB FTW03LA135Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Bossier City, LAThe failure of the passenger to follow the pilots landing instructions.NTSB FTW03LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Batchelor, LAThe pilot's failure to abort the takeoff with adequate runway available. A contributing factor was the high density altitude.NTSB FTW03LA122Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Monroe, LAThe pilot's failure to maintain control of the helicopter. A contributing factor was the crosswind.NTSB FTW03FA117Accident · No injuriesField investigationFinal reportBell 407 · Houma, LAThe loss of tail rotor drive and anti-torque control resulting from the fracture and separation of the #5 tail rotor drive segment due to the overtemperature and subsequent failure of the #5 hangar bearing.NTSB FTW03LA106Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350B2 · Venice, LAThe pilot's inability to maintain directional control following a loss of tail rotor drive. A contributing factor was the fog.NTSB FTW03LA102Accident · No injuriesLimited investigationFinal reportEnstrom 280FX · Ruston, LAThe separation of the upper tail cone as a result of a fractured bolt due to fatigue.NTSB FTW03LA092Accident · Minor injuriesLimited investigationFinal reportMooney M20J · New Orleans, LAThe loss of engine power as a result of the separation of the magneto assembly due to inadequate maintenance by unknown personnel. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW03LA088Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Oak Grove, LAThe pilot's continued flight into adverse weather conditions, and his improper landing flare resulting in a hard landing. A contributing factors was the fog.NTSB FTW03TA087Accident · Serious injuriesFinal reportBeech T-34B · Hammond, LAThe pilot's inadequate inflight planning/decision resulting in fuel exhaustion and the loss of engine power. A contributing factor was the night light conditions.NTSB CHI03FA056Accident · 1 fatalField investigationFinal reportBell 206L-1 · B.S. 53, LAThe improper approach by the pilot and the settling with power encountered by the pilot.NTSB FTW03LA081Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-350-BA · Venice, LAThe loss of tail rotor drive as a result of baggage coming in contact with the tail rotor blades after the aft cargo door was not secured. A contributing factor was the passenger's failure to follow the procedures for properly securing the helicopter's doors…NTSB FTW03FA071Accident · 2 fatalField investigationFinal reportGrumman American AA-1A · Shreveport, LAThe pilot's failure to maintain adequate airspeed resulting in a stall.NTSB FTW03LA049Accident · 2 fatalLimited investigationFinal reportGirard RV-4 · Homer, LAThe pilot's VFR flight into IMC conditions and his failure to obtain/maintain altitude/clearance from trees during the initial climb after takeoff. Contributing factors were fog and trees.NTSB FTW03FA044Accident · 1 fatalField investigationFinal reportCessna 210L · Kentwood, LAThe failure of the #1 and #2 connecting rods during climb to cruise due to overheating, resulting from oil starvation. A contributing factor was the low cloud conditions limiting the pilot's visibility during the ensuing emergency landing.NTSB FTW03FA027Accident · 3 fatalField investigationFinal reportAero Commander 500-B · Rayville, LAThe pilot-in-command's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB FTW03LA018Accident · No injuriesLimited investigationFinal reportCarriere RW-152 Scorpion II · Opelousas, LAThe pilot's inadequate compensation for wind resulting in a loss of control. A contributing factor was the gusting wind conditions.NTSB FTW03LA007Accident · No injuriesLimited investigationFinal reportMooney M20K · Port Sulphur, LAthe pilot's failure to maintain directional control while landing, which resulted in an in-flight collision with trees during an attempted go-around. A factor was the wet runway condition.NTSB FTW02LA258Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-302 · Lacompte, LAThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing, and low altitude maneuvering.NTSB FTW02LA246Accident · No injuriesLimited investigationFinal reportCessna 182-Q · New Roads, LAThe pilot's failure to maintain airspeed which resulted in a stall.NTSB FTW02LA239Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Simmesport, LAthe contamination of the fuel system with water and a foreign material.NTSB FTW02LA231Accident · Minor injuriesLimited investigationFinal reportPage Rans S-7 · Welsh, LAthe pilot's failure to maintain the minimum required airspeed for flight, which resulted in an inadvertent stall.NTSB FTW02LA221Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · New Roads, LAThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin of the airplane.NTSB FTW02LA216Accident · No injuriesLimited investigationFinal reportBell TH-13T · New Iberia, LAThe loss of engine power for undetermined reasons. High vegetation was a factor.NTSB FTW02LA194Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Basile, LAthe loss of engine power as a result of fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA191Accident · Minor injuriesLimited investigationFinal reportBeech BE-V35B · Baton Rouge, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA186Accident · Minor injuriesLimited investigationFinal reportBell 47G4 · Grand Lake, LAthe pilot's inability to control the helicopter in a hover due to the restricted movement of the cyclic for undetermined reasons.NTSB FTW02LA184Accident · No injuriesLimited investigationFinal reportCessna P210N · Shreveport, LAthe collapse of the right main landing gear for undetermined reasons.NTSB FTW02LA180Accident · Serious injuriesLimited investigationFinal reportFrennance Twinstar · Bastrop, LAthe pilot's failure to maintain altitude for an undetermined reason, which resulted in an in-flight collision with trees.NTSB FTW02LA164Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Jonesville, LAthe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun and an on ground encounter with terrain.NTSB FTW02LA157Accident · No injuriesLimited investigationFinal reportGolden Circle Air T-Bird · Newellton, LAThe pilot's failure to maintain control of the airplane resulting in an inadvertant spin.NTSB FTW02LA152Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hathaway, LAthe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW02LA146Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7B-15 · Port Allen, LAThe pilot's decision to land in the sugar cane field, which resulted in the pilot's unintentional exit from the basket. A contributing factor was the high vegetation in the field.