NTSB finding · Aircraft › Aircraft systems › Landing gear system
- Cases
- 113
- In the probable cause
- 91 (81%)
- Fatal cases
- 4
- NTSB code
- 01023200
NTSB has coded findings and defining events since 2008. Earlier cases used its older occurrence and cause codes, so they aren’t counted here.
When and where
In green, cases where NTSB made it part of the probable cause; in gray, a factor or other finding. Findings are coded with the final report, often a year or more after the event, so the latest years are incomplete.
Cases per year
| 2008 | 18 |
|---|---|
| 2009 | 5 |
| 2010 | 5 |
| 2011 | 13 |
| 2012 | 15 |
| 2013 | 9 |
| 2014 | 4 |
| 2015 | 4 |
| 2016 | 1 |
| 2017 | 7 |
| 2018 | 3 |
| 2019 | 5 |
| 2020 | 4 |
| 2021 | 1 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 6 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapQuery with SQL
duckdb -csv -c "SELECT year(c.\"eventDate\") AS year, count(DISTINCT f.case_mkey) AS cases,
count(DISTINCT f.case_mkey) FILTER (WHERE f.\"inProbableCause\") AS in_probable_cause
FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = f.case_mkey
WHERE starts_with(f.\"findingCode\", '01023200') AND c.\"eventDate\" >= DATE '2000-01-01'
GROUP BY 1
ORDER BY 1"Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT year(c."eventDate") AS year, count(DISTINCT f.case_mkey) AS cases, count(DISTINCT f.case_mkey) FILTER (WHERE f."inProbableCause") AS in_probable_cause FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = f.case_mkey WHERE starts_with(f."findingCode", '01023200') AND c."eventDate" >= DATE '2000-01-01' GROUP BY 1 ORDER BY 1
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.
In the same cases
Query with SQL
duckdb -csv -c "WITH matched AS (SELECT DISTINCT case_mkey, aircrafts_position FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' WHERE starts_with(\"findingCode\", '01023200'))
SELECT * FROM (
SELECT 'Defining event' AS kind, e.\"tier2Number\" AS code, max(e.\"eventTier2Name\") AS name, count(DISTINCT f.case_mkey) AS cases
FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_events.parquet' e ON e.case_mkey = f.case_mkey AND e.aircrafts_position = f.aircrafts_position AND e.\"isDefiningEvent\"
WHERE e.\"tier2Number\" <> ''
GROUP BY ALL
UNION ALL
SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT f.case_mkey)
FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = f.case_mkey AND a.position = f.aircrafts_position
LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
WHERE a.aircraft_model_code IS NOT NULL
GROUP BY ALL
UNION ALL
SELECT 'Other finding', left(g.\"findingCode\", 8), max(g.\"tier4Name\"), count(DISTINCT g.case_mkey)
FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' g
WHERE g.case_mkey IN (SELECT case_mkey FROM matched) AND NOT starts_with(g.\"findingCode\", '01023200') AND g.\"findingCode\" GLOB '[0-9][0-9]*'
GROUP BY ALL
)
QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
ORDER BY kind, cases DESC"Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
WITH matched AS (SELECT DISTINCT case_mkey, aircrafts_position FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' WHERE starts_with("findingCode", '01023200'))
SELECT * FROM (
SELECT 'Defining event' AS kind, e."tier2Number" AS code, max(e."eventTier2Name") AS name, count(DISTINCT f.case_mkey) AS cases
FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_events.parquet' e ON e.case_mkey = f.case_mkey AND e.aircrafts_position = f.aircrafts_position AND e."isDefiningEvent"
WHERE e."tier2Number" <> ''
GROUP BY ALL
UNION ALL
SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT f.case_mkey)
FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = f.case_mkey AND a.position = f.aircrafts_position
LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
WHERE a.aircraft_model_code IS NOT NULL
GROUP BY ALL
UNION ALL
SELECT 'Other finding', left(g."findingCode", 8), max(g."tier4Name"), count(DISTINCT g.case_mkey)
FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' g
WHERE g.case_mkey IN (SELECT case_mkey FROM matched) AND NOT starts_with(g."findingCode", '01023200') AND g."findingCode" GLOB '[0-9][0-9]*'
GROUP BY ALL
)
QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
ORDER BY kind, cases DESCRun 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.
Newest cases · 113
NTSB CEN26LA166Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Colorado Springs, COMaintenance personnel's installation of an oversized tire, which prevented the left main landing gear from extending resulting in a precautionary gear up landing.NTSB CEN26LA002Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7GC · Haskell, OKThe pilot’s excessive braking during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot’s lack of experience with the recently installed brakes and tundra tires.NTSB CEN25LA083Accident · No injuriesClass 4 · LimitedFinal reportRaytheon Hawker 800XP · Minneapolis, MNThe failure of the nose landing gear to extend for undetermined reasons.NTSB ANC25LA009Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Egegik, AKA failure of the right main landing gear leg for reasons that could not be determined.NTSB CEN25LA001Accident · No injuriesClass 4 · LimitedFinal reportCessna TR182 · Englewood, COThe collapse of the right main landing gear during landing rollout.NTSB WPR24LA278Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SF50 · Watsonville, CAThe pilot’s inadvertent use of the landing gear control handle instead of the flaps selector switch during the landing rollout, which resulted in the collapse of the nose landing gear.NTSB CEN24LA261Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT602 · Decatur, ILThe pilot’s inability to maintain directional control during the landing roll due to the malfunction of the tail wheel locking mechanism.NTSB WPR24LA157Accident · No injuriesClass 3 · LimitedFinal reportCessna P210 · Daggett, CAThe pilot’s failure to detect the tripped alternator circuit breaker in flight, which resulted in a drained battery that prevented the landing gear from fully extending to the down-and-locked position. Contributing to the accident was the improperly installed…NTSB CEN24LA086Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Fort Worth, TXThe pilot’s failure to extend the landing gear and the flight instructor’s lack of recognition and inadequate remedial action, which resulted in a gear up landing.NTSB ERA24LA037Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Frederick, MDA failure of a hydraulic filter, which preluded normal extension of the landing gear. Also causal was the pilot’s failure to confirm that he landing gear was extended before landing, which resulted in a gear up landing.
See all 113 casesQuery 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01023200')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01023200')) 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.