NTSB investigations
585 cases where the sequence of events included Landing gear not configured.
Cases, newest first
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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA19CA466Accident · No injuriesData collectionFinal reportDiamond DA 42 NG · Palatka, FLThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended due to distraction, which resulted in a gear-up landing.NTSB GAA19CA398Accident · No injuriesData collectionFinal reportCessna R182 · Petersburg, VAThe pilot's failure to verify that the main landing gear were extended, which resulted in landing with partially extended landing gear. Contributing to the accident was a tripped landing gear motor circuit breaker.NTSB GAA19CA427Accident · No injuriesData collectionFinal reportBeech 35 · Caldwell, NJThe pilot's distraction while looking for traffic, which led to his failure to extend the landing gear before landing, and his exceedance of the airplane's critical angle of attack during a subsequent go-around, which resulted in an aerodynamic stall.NTSB WPR19FA178Accident · 1 fatalClass 2 · FieldFinal reportMaule M7-235B · Sunriver, ORA partial loss of engine power due to the separation of baffling in both mufflers. Contributing to the accident was the pilot's failure to retract the landing gear on the float-equipped airplane before performing a forced landing to the river.NTSB GAA19CA294Accident · No injuriesData collectionFinal reportRatheon A36 · Hilton Head, SCThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to complete the before landing checklist.NTSB GAA19CA108Accident · No injuriesData collectionFinal reportDe Havilland DHC 2 · Hollister, CAThe pilot's failure to retract the amphibious float's landing gear wheels before landing on the water. Contributing to the accident was the pilot's failure to use the after takeoff and before landing checklists.NTSB GAA19CA358Accident · No injuriesData collectionFinal reportBeech 35 · Bowie, MDThe pilot's failure to extend the landing gear before landing.NTSB WPR19FA152Accident · 1 fatalClass 3 · FieldFinal reportCessna A185 · Whittier, AKThe pilot’s failure to configure the landing gear for a water landing, which resulted in a nose-over. Contributing to the accident was the pilot's distraction due to his talking passengers.NTSB CEN19LA142Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA44 · Centralia, ILThe failure of the nose landing gear to extend for reasons that could not be determined based on the available information.NTSB WPR19LA144Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · Gila Bend, AZThe pilot's failure to configure the landing gear in a timely manner before landing, which resulted in a propeller strike.NTSB WPR19LA139Accident · No injuriesClass 3 · LimitedFinal reportBeech 35 · Minden, NVA partial extension of the landing gear due to the poor condition of the electric landing gear motor, which resulted in a gear collapse upon landing.NTSB GAA19CA231Accident · No injuriesData collectionFinal reportBeech 76 · St Charles, MOThe pilot receiving instruction's failure to extend the landing gear. Contributing to the accident were the pilot receiving instruction's failure to complete the landing checklist and the flight instructor's inadequate monitoring of the pilot.NTSB GAA19CA206Accident · No injuriesData collectionFinal reportPiper PA28R · Hutchinson, KSThe pilot's failure to extend the landing gear before landing.NTSB GAA19CA234Accident · No injuriesData collectionFinal reportCessna T310 · Philadelphia, PAThe pilot’s and flight instructor's failure to verify that the landing gear were extended, which resulted in a gear-up landing. Contributing to the accident was the flight instructor’s inadvertent pulling of the landing gear motor circuit, which prevented the…NTSB ERA19TA129Accident · No injuriesClass 3Final reportBeech E55 · St. Petersburg, FLThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.NTSB GAA19CA171Accident · No injuriesData collectionFinal reportCessna T210 · Chandler, AZThe pilot's distraction while looking for other aircraft in the traffic pattern, which resulted in his failure to follow a prelanding checklist and to extend the landing gear before landing. Contributing to the accident was the improperly rigged landing gear…NTSB GAA19CA138Accident · No injuriesData collectionFinal reportCessna 172RG · Atlanta, GAThe pilot's failure to extend the landing gear before landing. Contributing to the accident were the pilot’s inability to see the landing gear position light because his iPad was blocking his view of it and his feeling of being rushed during the approach and…NTSB DCA19LA070Accident · No injuriesLimited investigationFinal reportBoeing 727 200 · Tuscaloosa, ALthe captain's decision to continue the landing with an unsafe gear indication.NTSB CEN19LA059Accident · No injuriesLimited investigationFinal reportCessna T210 · Flint, MIThe failure of the nose landing gear actuator hydraulic hose, which resulted in the loss of hydraulic fluid and hydraulic system pressure and a subsequent gear-up landing.NTSB GAA19CA070Accident · No injuriesData collectionFinal reportCessna T337 · Homosassa, FLThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and the subsequent total loss of power in both engines.NTSB GAA19CA053Accident · Minor injuriesData collectionFinal reportPiper PA24 · Texico, NMThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB GAA19CA046Accident · No injuriesData collectionFinal reportBeech 55 · Gainesville, FLThe pilot's inadvertent landing gear retraction during the landing roll, which resulted in a canted left main landing gear and the wing dragging during the subsequent landing following a go-around.NTSB GAA19CA032Accident · No injuriesData collectionFinal reportPiper PA24 · Madras, ORThe pilot’s failure to extend the landing gear, which resulted in an attempted go-around and subsequent pitchdown and impact with the runway.NTSB GAA19CA017Accident · No injuriesData collectionFinal reportCessna 177RG · Albermarle, NCThe pilot's improper decision to attempt a gear-up glide to the runway and his subsequent failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use a checklist before landing.NTSB DCA18WA298Incident · No injuriesForeign investigationAirbus A320 · Sydney, AustraliaNTSB WPR18LA264Accident · No injuriesLimited investigationFinal reportCessna T210 · San Luis Obispo, CAThe failure of the landing gear extension motor due to wear, which resulted in the right main landing gear not fully extending and locking into place during landing. Contributing to the accident was the pilot’s failure to ensure that all three landing gear…NTSB GAA18WA585Accident · No injuriesForeign investigationPiper PA28R · Cuatro Vientos, Spain, SpainThe government of Spain has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on September 04, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions…NTSB GAA18CA531Accident · No injuriesData collectionFinal reportPiper PA44 · Centralia, ILThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to verify that the landing gear was extended before landing. Contributing to the accident was the flight instructor’s delayed remedial action and…NTSB GAA18CA557Accident · No injuriesData collectionFinal reportSchweizer SGS 1 35 · Burnet, TXThe pilot's failure to extend the landing gear before landing and to use the Before Landing checklist.NTSB GAA18CA540Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · East Stroudsburg, PAThe pilot's failure to extend the landing gear during landing, which resulted in a runway excursion and subsequent impact with terrain.NTSB DCA18WA314Accident · No injuriesForeign investigationDe Havilland DHC8 · Callao, PeruThe Peru Comisión de Investigación de Accidentes Aviación ((CIAA) has notified the NTSB of an accident involving a De Havilland DHC8 that occurred on August 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the CIAA'S investigation…NTSB CEN18TA330Accident · No injuriesFinal reportPiper J3C · Friendswood, TXThe pilot's decision to conduct a flight in an airplane that had a tailwheel with degraded locking pins, which allowed the tailwheel to unlock and swivel out of alignment and precluded the pilot from regaining directional control on the ground during a…NTSB WPR18LA215Accident · No injuriesLimited investigationFinal reportCessna T337 · Lewiston, IDThe liberation of an internal snap ring from a landing gear door actuator, which resulted in a complete loss of hydraulic fluid and a gear-up landing. Contributing to the accident was the failure of maintenance personnel to replace the snap ring during the…NTSB GAA18CA462Accident · No injuriesData collectionFinal reportPiper PA24 · Evanston, WYThe pilot's failure to extend the landing gear during landing. Contributing to the accident were the pilot's distraction and his failure to complete the appropriate checklist before landing.NTSB GAA18CA438Accident · No injuriesData collectionFinal reportMooney M20E · Great Falls, MTThe flight instructor’s incorrect use of the landing gear system and his and the pilot’s failure to ensure that the landing gear was extended, which resulted in a gear-up landing. Contributing to the accident was the flight instructor’s unfamiliarity with the…NTSB GAA18CA418Accident · No injuriesData collectionFinal reportPiper PA28R · Houston, TXThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to ensure that the landing gear were extended during landing. Contributing to the accident was the pilot receiving instruction's and instructor's failure…NTSB GAA18CA412Accident · No injuriesData collectionFinal reportBeech A36 · Spencer, IAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were the pilot’s failure to use the Before Landing checklist due to being distracted while communicating with other aircraft and controlling the airplane in the…NTSB CEN18LA230Accident · No injuriesLimited investigationFinal reportCessna TR182 · Beloit, KSThe mechanic’s failure to properly torque one of the left brake caliper’s back plate attachment bolts while re-installing it during the annual inspection, which resulted in the left main landing gear not extending before landing.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 WPR18LA209Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Fort Lauderdale, FLThe failure of the left starter relay, which resulted in a loss of electrical power during the flight and the failure of the T-handle from the cable led to a forced landing with the landing gear retracted.NTSB WPR18CA172Accident · No injuriesData collectionFinal reportDornier Alpha JET · Sacramento, CAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s and the flight instructor’s failure to adequately monitor the workload.NTSB GAA18CA346Accident · No injuriesData collectionFinal reportPiper PA32R · Caddo Mills, TXThe student pilot’s failure to extend the landing gear before landing and to follow the Before Landing checklist, which resulted in an attempted go-around and subsequent hard landing.NTSB GAA18CA239Accident · No injuriesData collectionFinal reportBeech 76 · Vacaville, CAThe pilot under instruction’s failure to extend the landing gear and the flight instructor’s inadequate supervision and failure to ensure that the landing gear was extended.NTSB GAA18CA251Accident · No injuriesData collectionFinal reportBeech 95 B55 · Suffolk, VAThe pilot’s failure to properly secure the portable GPS and antenna cable, which resulted in the inadvertent landing gear retraction during landing.NTSB GAA18CA207Accident · No injuriesData collectionFinal reportPiper PA34 · San Diego, CAThe pilot receiving instruction and flight instructor’s failure to properly configure the landing gear before landing, which resulted in landing with the landing gear retracted.NTSB GAA18CA174Accident · No injuriesData collectionFinal reportCessna P210 · Jacksonville, FLThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were pilot fatigue and his failure to use the before landing checklist.NTSB GAA18CA148Accident · No injuriesData collectionFinal reportHarris Pierce Velocity XL RG · Locust Grove, GAThe pilot’s failure to extend the landing gear due to his distraction by talking on the radio, which resulted in a gear-up landing.NTSB GAA18CA137Accident · No injuriesData collectionFinal reportBeech C90 · Montague, CAThe failure of pilot to extend the landing gear during landing.NTSB CEN18WA105Incident · No injuriesForeign investigationSikorsky S-92A · Shetland, United KingdomOn January 14, 2018, about 1413 universal time (UTC), a United Kingdom registered Sikorsky S-92A, G-CHHF, experienced a nose landing gear (NLG) anomaly during landing at Scatsta Airport, Shetland, United Kingdom. The NLG did not extend during the approach to…NTSB GAA18CA115Accident · No injuriesData collectionFinal reportCessna 210 · Sussex, NJThe pilot’s inadvertent landing gear retraction during approach.