NTSB investigations, LA
20 cases where NTSB found Landing gear system.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 3 |
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2023 | 1 |
| 2024 | 4 |
| 2025 | 1 |
| 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\", '010232'))
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", '010232')) 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 CEN26LA236Accident · No injuriesClass 4 · LimitedFinal reportBeech C24R · Baton Rouge, LAThe pilot’s failure to extend the landing gear before landing.NTSB CEN25LA402Accident · No injuriesClass 4 · LimitedFinal reportTextron 525C · Baton Rouge, LAThe improper installation of the trunnion pin, which resulted in a failure of the right main landing gear. Contributing to the accident was the failure of maintenance personnel to follow the aircraft manufacturer’s maintenance procedures.NTSB CEN25LA017Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Shreveport, LAThe pilot’s inadvertent failure to lower the landing gear before touching down.NTSB CEN25LA015Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · New Orleans, LAThe failure of a landing gear torque arm which resulted in a landing gear collapse and runway excursion.NTSB CEN24LA211Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Chandeleur Island, LAA fatigue failure of the engine oil pressure line, which resulted in the loss of engine oil during the flight and subsequent damage to the nose landing gear support structure during the precautionary landing.NTSB CEN24LA075Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Mansfield, LAThe nose landing gear collapse and postimpact fire due to undetermined reasons.NTSB CEN24LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 340A · New Orleans, LAThe improper maintenance of the main landing gear, which resulted in a collapse and overstress failure of the left main landing gear during landing.NTSB CEN21LA298Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 500 S · Jennings, LAThe pilot’s failure to extend the landing gear before landing.NTSB CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.NTSB CEN20CA220Accident · Minor injuriesClass 4 · Data collectionFinal reportVans RV8 · Sulfer, LAA loss of directional control as a result of a fractured landing gear attach bracket.NTSB DCA18FA144Accident · No injuriesField investigationFinal reportMcdonnell Douglas DC 9 83(MD-83) · Alexandria, LAthe failure of the right main landing gear under normal loads due to fatigue cracking in an area subject to an FAA Airworthiness Directive that was not adequately inspected.NTSB GAA16CA321Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Delhi, LAThe pilot's inability to maintain directional control during the landing roll as a result of a piece of concrete from the runway impacting the right main landing gear brake during the landing roll, resulting in a right brake failure and a ground loop.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 CEN15LA207Accident · No injuriesLimited investigationFinal reportCessna 177B · Jennings, LAThe pilot's improper landing flare, which resulted in a hard landing, the nosewheel tire bursting, and a subsequent porpoise and nose-over.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 CEN12LA434Accident · No injuriesLimited investigationFinal reportBeech A36 · New Orleans, LAThe pilot's failure to lower the landing gear before touchdown.NTSB CEN12CA272Accident · No injuriesData collectionFinal reportTucker-Hurni Starduster SA-300 · Vidalia, LAThe failure of the airplane’s right main landing gear due to a pre-existing fatigue crack and corrosion.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 CEN10CA510Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Basile, LAThe loss of directional control during landing due to failure of the right brake for undetermined reasons.NTSB DFW08TA128Accident · No injuriesFinal reportBeech C90 · Baton Rouge, LAStructural failure of the right main landing gear torque knee. A contributing factor was the failure to inspect the torque knee at the designated interval.