NTSB investigations, AL
11 cases where NTSB found Gear extension and retract sys.
Cases per year
| 2012 | 1 |
|---|---|
| 2013 | 1 |
| 2014 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 3 |
| 2026 | 1 |
Where
Latest 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\" = 'AL' 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\", '01023230'))
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" = 'AL' 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", '01023230')) 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 ERA26LA265Accident · No injuriesClass 4 · LimitedFinal reportBeech E35 · Lincoln, ALThe pilot’s failure to ensure that the landing gear were extended prior to landing.NTSB ERA26LA083Accident · No injuriesClass 4 · LimitedFinal reportIcon A5 · Gulf Shores, ALA nose landing gear collapse during landing.NTSB ERA26LA071Accident · No injuriesClass 4 · LimitedFinal reportBeech D95A · Jasper, ALThe pilots’ failure to ensure that the airplane’s landing gear was extended before landing. Contributing was the flight instructor’s inadequate supervision during the landing approach.NTSB ERA25LA182Accident · Minor injuriesClass 4 · LimitedFinal reportRobb Aventura II · Elmore, ALThe pilot’s failure to configure the airplane for a water landing.NTSB ERA24LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Montgomery, ALThe failure of the nose landing gear actuator to maintain a fully down and locked position.NTSB ERA24LA034Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Florala, ALThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the flight instructor’s inadequate supervision of the flight.NTSB ERA20LA259Accident · No injuriesClass 3 · LimitedFinal reportBeech 400 · Montgomery, ALLanding with the left main landing gear retracted due to the failure of the landing gear control unit, which resulted in substantial damage.NTSB DCA19LA070Accident · No injuriesLimited investigationFinal reportBoeing 727 200 · Tuscaloosa, ALthe captain's decision to continue the landing with an unsafe gear indication.NTSB ERA14CA431Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Gunthersville, ALThe pilot's failure to retract the landing gear wheels prior to a water landing, resulting in a nose over upon touchdown.NTSB ERA13LA407Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Guntersville, ALThe improper installation of the engine magneto by unknown maintenance personnel, which resulted in the magneto separating from the engine and a subsequent total loss of engine power. Contributing to the accident was the pilot's delay in proceeding directly…NTSB ERA12LA273Accident · No injuriesLimited investigationFinal reportCessna T337B · Dothan, ALThe failure of the landing gear to extend and lock, despite troubleshooting attempts using normal and emergency procedures. The reason for the failure could not be determined because the systems were unavailable for testing.