NTSB investigations, LA
17 cases where NTSB found Runway/land/takeoff/taxi surface.
Cases per year
| 2008 | 3 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2020 | 2 |
| 2024 | 2 |
| 2025 | 2 |
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\", '030230'))
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", '030230')) 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 CEN25LA187Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Goudeau, LAThe pilot’s inadvertent encounter with soft terrain conditions during the landing which resulted in a loss of directional and a subsequent nose-over.NTSB CEN25LA152Accident · No injuriesClass 4 · LimitedFinal reportCorben Junior ACE · Jeanerette, LAThe pilot’s failure to maintain airplane control during the landing roll.NTSB CEN25LA045Accident · No injuriesClass 4 · LimitedFinal reportCessna R182 · Crowley, LAThe pilot’s un-stabilized landing approach and high airspeed during the approach, that resulted in touchdown with insufficient runway remaining to stop the airplane.NTSB CEN24LA213Accident · No injuriesClass 4 · LimitedFinal reportBoeing E75 · Shuteston, LAThe pilot failure to maintain directional control while landing on a wet grass strip.NTSB CEN20CA153Accident · No injuriesData collectionFinal reportAir Tractor AT 602 · Mamou, LAThe airplane's encounter with a sunken area during takeoff from a turf runway, which resulted in the airplane becoming prematurely airborne and impacting a tree and then terrain.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 GAA19CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · Crowley, LAThe pilot's selection of unsuitable terrain for takeoff, which resulted in a collision with vegetation and a subsequent loss of directional control.NTSB GAA18CA138Accident · No injuriesData collectionFinal reportSikorsky S76 · New Iberia, LAThe helicopter’s striking of a pothole while taxiing, which resulted in the right main landing gear collapsing.NTSB GAA18CA066Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · New Orleans, LAThe pilot’s failure to land the helicopter with both skids on the trailer platform, which resulted in a loss of control.NTSB CEN15LA371Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Venice, LAThe pilot's failure to attain a safe landing approach airspeed with a crosswind.NTSB CEN14CA528Accident · Minor injuriesData collectionFinal reportCessna 182G · Port Eads, LAThe pilot's improper decision to depart from a runway not suitable for takeoff, which resulted in a loss of aircraft control.NTSB CEN14LA076Accident · No injuriesLimited investigationFinal reportCessna T210L · Lake Providence, LAThe pilot's mismanagement of available fuel and incorrect use of the fuel boost pump which resulted in a total loss of engine power at a low altitude.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 CEN10CA196Accident · No injuriesData collectionFinal reportCessna 150 · Waterproof, LAThe pilot's failure to maintain directional control during landing and his failure to initiate a go-around when encountering the strong gusting winds.NTSB DFW08CA216Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Wisner, LAThe loss of engine power for undetermined reasons.NTSB DEN08CA099Accident · No injuriesData collectionFinal reportPiper Seneca · Plaquemine, LAThe certified flight instructor's poor decision to simulate a loss of engine on takeoff with a wet runway and the pilot's failure to maintain directional control. Contributing to the accident was the dew covered runway surface and the ditch.NTSB DFW08LA130Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Opelousas, LALoss of engine power due to starvation of the right fuel tank and the inability to select the left fuel tank. Contributing to airplane damage was the hidden obstruction in the field selected for the forced landing.