NTSB investigations, LA
33 cases where the sequence of events included Runway excursion.
Cases per year
| 2010 | 2 |
|---|---|
| 2011 | 5 |
| 2012 | 3 |
| 2013 | 1 |
| 2015 | 4 |
| 2016 | 3 |
| 2018 | 2 |
| 2019 | 3 |
| 2020 | 3 |
| 2021 | 2 |
| 2024 | 4 |
| 2025 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN26LA063Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20E · Gonzales, LAThe pilot’s improper pitch control that resulted in a hard landing, and his improper recovery from multiple bounced landings. Contributing to the accident was the safety pilot’s delayed response to the initial bounced landing which led to the runway excursion.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 CEN24LA213Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Shuteston, LAThe pilot failure to maintain directional control while landing on a wet grass strip.NTSB CEN24LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 172H · Belle Chasse, LAThe inadequate landing flare by the flight instructor that resulted in a loss of directional control and impact with terrain.NTSB CEN24LA156Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Monroe, LAThe student pilot’s failure to maintain directional control during the landing roll.NTSB CEN21LA298Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 500 S · Jennings, LAThe pilot’s failure to extend the landing gear before landing.NTSB CEN21LA284Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Reserve, LAA total loss of engine power for undetermined reasons.NTSB CEN20LA361Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Crowley, LAThe failure of the No. 4 cylinder exhaust valve that resulted in a partial loss of engine power. Based on available evidence, the reason for the failed valve was not determined.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 CEN20CA103Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Bunkie, LAThe pilot's failure to lock the tailwheel before landing, which resulted in his loss of directional control during the landing roll, a runway excursion onto soft ground, and a subsequent ground loop.NTSB GAA19CA576Accident · No injuriesData collectionFinal reportPiper PA 22 · Pollock, LAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent ground loop.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 GAA19CA115Accident · No injuriesData collectionFinal reportNavion Navion · Patterson, LAThe pilot's failure to maintain clearance from power lines while making an evasive maneuver to avoid birds.NTSB GAA18CA447Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Iowa, LAThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA335Accident · No injuriesData collectionFinal reportBeech A36 · Gilliam, LAThe pilot’s exceedance of the airplane’s critical angle of attack during a soft-field takeoff, which resulted in an aerodynamic stall.NTSB CEN16LA250Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Oak Ridge, LAThe pilot's failure to maintain airplane control during the aborted takeoff, which resulted in it becoming airborne momentarily and then over running the runway.NTSB GAA16CA175Accident · No injuriesData collectionFinal reportChampion 7ECA · Kinder, LAThe pilot's selection of an unsuitable landing area, resulting in a loss of directional control during landing, an airstrip excursion, impact with a fence and the subsequent airplane fire.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 CEN15LA444Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · New Orleans, LAThe collapse of the landing gear for reasons that could not be determined based on the available information.NTSB GAA15CA250Accident · No injuriesData collectionFinal reportGrumman American Avn. G 164A · Welsh, LAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and a ground loop.NTSB GAA15CA236Accident · No injuriesData collectionFinal reportCessna 182Q · Pineville, LAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane, resulting in a runway over-run and collision with terrain.NTSB GAA15CA108Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5B · Springhill, LAUnintentional collision with a deer during landing in dusk visual conditions.NTSB CEN13CA226Accident · No injuriesData collectionFinal reportEdward W Gray Lancair 360 · Alexandria, LAThe pilot's failure to attain the proper touchdown point, and his decision to continue the landing, which resulted in a runway excursion.NTSB CEN12CA526Accident · Minor injuriesData collectionFinal reportCessna 172R · Leesville, LAThe student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.NTSB CEN12LA500Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Newellton, LAThe pilot's inadequate takeoff planning and his use of an improper flap setting, which resulted in a runway excursion and collision with terrain during takeoff.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 CEN12FA088Accident · 1 fatalField investigationFinal reportPiper PA-31 · New Orleans, LAThe pilot's fatal cardiac event, which resulted in the inflight loss of control of the airplane. Contributing to the accident was the pilot's use of impairing medications and operation of the airplane with disqualifying medical conditions.NTSB CEN12CA027Accident · No injuriesData collectionFinal reportMichael Cans RV-8 · Breaux Bridge, LAThe pilot's failure to maintain control of the airplane after striking an unseen sinkhole during landing.NTSB CEN11CA336Accident · Serious injuriesData collectionFinal reportReed Roderick KB3 Gyroplane · Scott, LAThe pilot's poor decision to takeoff with a tailwind which resulted in a runway excursion.NTSB DCA11IA040Incident · No injuriesIncident investigationFinal reportAirbus A320 · New Orleans, LAthe captain's failure to properly recognize and manage the abnormal condition, resulting in it escalating to an in-flight emergency.NTSB CEN11CA171Accident · No injuriesData collectionFinal reportCessna 172R · Shreveport, LAThe student pilot's loss of directional control during the landing.NTSB CEN10CA547Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Houma, LAThe pilot’s inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.NTSB CEN10IA397Incident · No injuriesIncident investigationFinal reportBell 206 · Gulf of Mexico, LAImproper reassembly of the collective flight controls by maintenance personnel. Contributing to the incident were inadequate postmaintenance examinations by maintenance personnel and inadequate preflight inspections by two pilots.