NTSB investigations, AR
12 cases where NTSB found Landing gear system.
Cases per year
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2025 | 1 |
| 2026 | 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\" = 'AR' 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" = 'AR' 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 CEN26LA278Accident · No injuriesClass 4 · LimitedFinal reportCessna 310 · North Little Rock, ARThe flight instructor and pilot receiving instruction’s failure to verify that the landing gear was extended before landing, which resulted in a gear-up landing.NTSB CEN26LA232Accident · Minor injuriesClass 4 · LimitedFinal reportRocky Mountain Kitplanes S-6S · Marvel, ARA partial blockage of the pitot static system that precluded the airspeed indicator from displaying the correct airspeed which led to the faster landing speed and bounced landing.NTSB CEN25LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · Melbourne, ARThe flight crew’s failure to use the airplane pre-landing checklist and failure to extend the airplane’s landing gear before landing.NTSB CEN18LA241Accident · No injuriesLimited investigationFinal reportCessna T210 · Pocahontas, ARThe pilot's excessive use of wheel brakes while landing, which resulted in both brakes locking up, a loss of directional control, a runway excursion, and a nose over.NTSB GAA18CA361Accident · No injuriesData collectionFinal reportRaytheon A36 · Lakeview, ARThe pilot’s failure to extend the landing gear before landing, which resulted in a propeller strike, followed by an aborted landing and a subsequent hard, precautionary landing.NTSB CEN17LA312Accident · No injuriesLimited investigationFinal reportRalph Marine Devil DOG · Danville, ARA separation of the left tire from its wheel because of the use of an improper substance and wheel size, which resulted in a loss of directional control during landing.NTSB CEN17LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164C · Beech Grove, ARA tire failure for reasons that could not be determined, which resulted in a loss of directional control during takeoff.NTSB GAA15CA288Accident · No injuriesData collectionFinal reportCessna 305F · Bentonville, ARThe pilot's failure to maintain yaw control during a go-around, which resulted in a right main landing gear collapse and the right wing impacting terrain during a runway excursion.NTSB CEN13LA384Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Heth, ARThe partial collapse of the right main landing gear during landing due to an improper previous weld repair to the right main landing gear and subsequent corrosion, which resulted in a loss of directional control and impact with terrain.NTSB CEN12LA476Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Conway, ARThe pilot's improper landing flare, which resulted in a hard landing and overstress failure of the right main landing gear.NTSB CEN11CA143Accident · No injuriesData collectionFinal reportRardin William I Kitfox III · Carlisle, ARFailure of the left main landing gear strut due to a pre-existing crack in the weld joint.NTSB CEN11CA113Accident · No injuriesData collectionFinal reportBeech 95-C55 · Ozark, ARThe pilot's failure to extend the landing gear prior to landing.