NTSB investigations, LA
63 cases where NTSB found Conditions/weather/phenomena.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 3 |
| 2010 | 3 |
| 2011 | 7 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 5 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 7 |
| 2020 | 6 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 5 |
| 2024 | 3 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0303'))
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' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0303')) 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 CEN26LA315Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne Searey · DeQuincy, LAThe pilot’s failure to maintain directional control during takeoff after encountering a wind gust. Contributing to the accident was nearby convective activity.NTSB CEN25LA231Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Lockport, LAThe pilot’s inadequate planning for the high density altitude conditions which resulted in reduced airplane performance, climb capability, and subsequent forced landing.NTSB CEN25LA073Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Buras, LAThe pilot’s failure to maintain control during a hover taxi with a quartering tailwind.NTSB CEN24LA232Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Ruston, LAThe student pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB CEN24LA126Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Alexandria, LAThe pilot’s failure to maintain directional control during the landing roll with a gusting crosswind.NTSB CEN24LA100Accident · No injuriesClass 3 · LimitedFinal reportBeechcraft BE58 · DeRidder, LAThe pilot’s encounter with heavy rain, hail, and severe turbulence associated with a thunderstorm, which resulted in substantial damage to the airplane.NTSB CEN24FA021Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-502B · Vidalia, LAThe pilot’s failure to maintain clearance from power lines during an aerial application flight. Contributing to the accident was the pilot’s cell phone use and the position of the sun, which reduced the pilot’s ability to perceive the location of the power…NTSB CEN23FA283Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Rayville, LAThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control during the approach to the destination airport and subsequent impact with terrain.NTSB CEN23FA142Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 II · Port Allen, LAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions, which resulted in spatial disorientation and the loss of aircraft control.NTSB DCA23LA175Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A319-132 · New Orleans, LAThe flight’s encounter with convective turbulence.NTSB CEN23LA087Accident · No injuriesClass 3 · LimitedFinal reportWorld WA-3 · Shreveport, LAThe loss of engine power due to carburetor icing.NTSB CEN23LA068Accident · No injuriesClass 3 · LimitedFinal reportGrumman American AA-5B · Reserve, LAThe partial loss of engine power due to carburetor icing and the flight instructor’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing.NTSB CEN23LA028Accident · Serious injuriesClass 3 · LimitedFinal reportBeech E-90 · Slidell, LAThe pilot’s failure to maintain airplane control during an attempted go-around in low visibility conditions.NTSB CEN22FA073Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron Canada 407 · LaPlace, LAThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the pilot’s decision to fly in instrument conditions.NTSB DCA21LA164Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321-231 · New Orleans, LAAn inadvertent encounter with severe turbulence during cruise flight that caused a flight attendant to fall and fracture his ankle.NTSB CEN21LA154Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Duson, LAThe uncertified pilot’s failure to maintain control of the helicopter when encountering a wind gust while hovering to land.NTSB CEN21LA089Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Bossier City, LAThe student pilot’s decision to conduct a flight during night instrument meteorological conditions and his loss of airplane control due to spatial disorientation. Contributing to the accident was the student pilot’s use of an amphetamine and his attention…NTSB CEN21LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper PA12 · Gilliam, LAThe non-instrument rated pilot’s encounter with poor weather conditions resulting in his performing a precautionary landing to a cornfield and subsequently nosing over.NTSB CEN20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Welsh, LAA partial loss of engine power while in flight due to corrosion of engine components, which resulted in a loss of control and a subsequent impact with terrain.NTSB CEN20CA115Accident · No injuriesData collectionFinal reportMooney M20K · New Orleans, LAThe pilot's improper decision to turn the airplane from the runway onto the taxiway at an excessive speed, which resulted in a loss of directional control, runway excursion, and collision with a taxiway sign.NTSB CEN20FA075Accident · 3 fatalClass 3 · FieldFinal reportCessna 182 · Chatham, LAThe pilot’s encounter with icing in-flight, which resulted in a loss of control and impact with terrain.NTSB DCA20CA058Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A320 · New Orleans, LAan encounter with convectively induced turbulence while overflying an area of known convective activity.NTSB CEN20MA044Accident · 5 fatalClass 2 · MajorFinal reportPiper PA 31T · Lafayette, LAThe pilot’s loss of airplane control due to spatial disorientation during the initial climb in instrument meteorological conditions.NTSB CEN20CA040Accident · Minor injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot's failure to attain an adequate climb rate during an aborted landing with a left quartering, gusting headwind, which resulted in impact with a tree.NTSB DCA20CA038Accident · Serious injuriesClass 4 · Data collectionFinal reportEmbraer EMB 135KL · Alexandria, LAan encounter with convectively induced turbulence while overflying an area of known convective activity.NTSB CEN19TA310Accident · No injuriesClass 3Final reportChampion 7KCAB · Winnsboro, LAThe pilot's failure to maintain directional control during a crosswind landing, which resulted in an impact with a tree.NTSB CEN19FA271Accident · 1 fatalClass 3 · FieldFinal reportCessna U206 · Hopedale, LAThe controlled flight into terrain (CFIT), resulting from the pilot’s failure to maintain proper altitude and continued flight into instrument meteorological conditions.NTSB CEN19FA095Accident · 2 fatalClass 2 · FieldFinal reportBell 407 · Galliano, LAThe pilot's loss of control during cruise flight as a result of spatial disorientation while operating the helicopter in close proximity to terrain in marginal meteorological conditions.NTSB CEN19FA088Accident · 2 fatalField investigationFinal reportPiper PA46 · Shreveport, LAThe pilot's conduct of a departure into instrument meteorological conditions (IMC), which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot's poor instrument flying skills and his decision…NTSB GAA19CA009Accident · No injuriesData collectionFinal reportStearman A75N1(PT17) · New Orleans, LAThe pilot’s failure to maintain directional control during a crosswind landing.NTSB CEN17FA103Accident · 2 fatalField investigationFinal reportBell Helicopter Textron Canada 429 · Shreveport, LAThe pilot's inadvertent encounter with instrument meteorological conditions resulting in spatial disorientation, loss of control, and subsequent impact with terrain.NTSB GAA17CA103Accident · Minor injuriesData collectionFinal reportPiper PA28 · Shreveport, LAThe pilot’s inadequate compensation for crosswind conditions during the go-around, which resulted in a loss of airplane control.NTSB CEN16LA338Accident · 2 fatalLimited investigationFinal reportCessna 172 · New Orleans, LAThe pilot's improper decision to continue a descent during a night visual approach a for landing which resulted in controlled flight into terrain. Contributing to the accident was the reduced visibility and pilot's disregard of the PAPI indications that the…NTSB CEN16FA304Accident · 1 fatalField investigationFinal reportSchweizer 269C 1 · Jeanerette, LAThe pilot's loss of helicopter control for reasons that could not be determined based on available evidence.NTSB CEN16FA158Accident · 2 fatalField investigationFinal reportBeech 65 A90 1 · Slidell, LAThe unstable approach in black-hole conditions, resulting in the airplane overshooting the runway extended centerline and descending well below a safe glidepath for the runway. Contributing to the accident was the lack of monitoring by the copilot allowing…NTSB GAA16CA131Accident · No injuriesData collectionFinal reportFoxworthy Roy Christen Eagle · Bell City, LAThe pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a runway excursion and a nose over.NTSB CEN16LA064Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Sulphur, LAThe loss of engine power due to water and contaminants in the carburetor, which resulted in a forced landing to a wet field.NTSB CEN15FA426Accident · 1 fatalField investigationFinal reportJones Ralph D Zodiac CH 601 HD · Ama, LAThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack following a loss of engine power for reasons that could not be determined based on available evidence, which resulted in an aerodynamic stall and…NTSB CEN15LA371Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Venice, LAThe pilot's failure to attain a safe landing approach airspeed with a crosswind.NTSB GAA15CA108Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5B · Springhill, LAUnintentional collision with a deer during landing in dusk visual conditions.NTSB CEN14LA251Accident · Serious injuriesLimited investigationFinal reportSmythe Donald F Kitfox Classic IV · Slaughter, LAThe pilot’s inadequate preflight planning, which resulted in his attempt to takeoff in conditions under which the airplane was unable to attain a positive rate of climb and resulted in its failure to clear trees.NTSB CEN14CA082Accident · No injuriesData collectionFinal reportSikorsky S 76B · Port Fourchon, LAThe pilot's loss of control of the helicopter when it entered a settling with power condition during sudden gusty wind conditions on takeoff resulting in the helicopter subsequently impacting terrain.NTSB CEN13FA143Accident · 4 fatalField investigationFinal reportRaytheon A36 · Richwood, LAThe pilot's failure to maintain control of the airplane during a missed approach in instrument meteorological conditions.NTSB CEN13FA012Accident · 1 fatalField investigationFinal reportCessna 172R · Simpson, LAThe pilot’s loss of airplane control while maneuvering between areas of precipitation during a night cross-country flight.NTSB CEN13FA003Accident · 1 fatalField investigationFinal reportBell 407 · Intracoastal City, LAThe pilot’s decision to attempt a local flight in marginal visual meteorological conditions and his subsequent loss of control following an inadvertent encounter with instrument metrological conditions shortly after takeoff.NTSB CEN12FA250Accident · No injuriesField investigationFinal reportSikorsky S-76B · Gulf of Mexico, LAThe intermittent loss of engine power due to a "stuck" stepper motor in the No. 2 engine's fuel control as a result of an inadequate overhaul. Contributing to the accident was the pilot's decision to continue flying the helicopter with a known defect, his…NTSB CEN12CA185Accident · No injuriesData collectionFinal reportCessna 180H · Belle Chase, LAThe bent tailwheel spring that allowed the tailwheel to caster when the airplane encountered a wind gust on landing roll.NTSB CEN12LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Vidalia, LAA total loss of engine power likely due to carburetor ice.NTSB CEN11CA580Accident · No injuriesData collectionFinal reportCessna 172N · Winnsboro, LAThe pilot's failure to maintain aircraft control during takeoff with a gusting crosswind.NTSB CEN11LA396Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Oak Ridge, LAThe flight instructor's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and subsequent impact with trees.