NTSB investigations
125 cases where the first occurrence was “Gear not extended”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 196) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 196) 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 CHI88LA022Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Decatur, ILThe aircraft experienced a landing with the gear retracted. The pilot stated that he perceived the yellow light indication for the landing gear to mean 'down', instead of looking for a green light.NTSB MIA88FA024Accident · 1 fatalField investigationFinal reportBeech C-55 · Brookhaven, MSThe pilot of the twin engine aircraft landed with vis 1/2 mile in fog and realized he had landed long. He executed a go-around and on the second landing forgot to lower the landing gear. The propellers stuck the runway and severely damaged one propeller. He…NTSB MIA88LA022Accident · No injuriesLimited investigationFinal reportMooney M20F · Vero Beach, FLPlt stated that while turning final approach he believes he placed the landing gear handle in the down position and observed red gear intransit lights. He was occupied by a strong wind for the landing and never checked for a gear down and safe indication. The…NTSB ATL88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Collegedale, TNThe airplane touched down while the ldg gear were extending. A witness reported that the acft began the ldg flare with the gear completely retracted, and that the gear began to extend when the airplane was 3-4 ft above the rwy. The main ldg gear contacted the…NTSB BFO88IA001Incident · No injuriesIncident investigationFinal reportFokker F-28-MK-1000 · Baltimore, MDThe acft had a main gear only landing after the nose gear failed to lock down. This was the first flight since a newly overhauled nose gear was installed. It was determined that when the nose gear was installed and before it was corrected, a wrong washer was…NTSB MKC87LA178Accident · No injuriesLimited investigationFinal reportAero Commander 500B · Kansas City, MOThe pilot was on approach to Kansas City international when he was requested to slow down and follow another aircraft. He used his checklist and decided to leave the gear up until he was closer to the airport. On short final he extended the flaps but failed…NTSB CHI87LA220Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pinckneyville, ILAccording to the instructor (CFI), he & the student confirmed the gear was extended & locked as they entered the traffic pattern. Flaps were extended & they contd in the pattern to practice a short field landing technique. Power was reduced after crossing…NTSB FTW87LA218Accident · No injuriesLimited investigationFinal reportBeech 58 · Guthrie, OKThe pilot failed to ensure that the landing gear was down and locked. The aircraft landed gear up and received substantial damage. The gear was lowered normally after the aircraft was lifted from the runway.NTSB CHI87LA210Accident · No injuriesLimited investigationFinal reportBeech 100 · Batesville, INThe aircraft was approaching hillenbrand airport when the pilot noticed a thunderstorm cell moving in on the airport. The pilot elected to expedite into hillenbrand. During the approach the landing gear was never placed in the extended position. The pilot…NTSB DEN87LA185Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Grandforks, NDThe commercial plt was flying cross country on a personal flight. After takeoff during gear retraction, a loud noise was heard in the cockpit. Upon reaching the first destination, the plt attempted gear down but gear did not extend. Manual extension was…NTSB LAX87LA262Accident · No injuriesLimited investigationFinal reportPiper PA-31T2 · Novato, CAAt the end of a cross country flt, the plt reported that he had extended the landing gear aprx 5 miles from the arpt and lowered partial flaps. Aprx 2 miles from the arpt the plt made shallow s turns for spacing and extended the rest of the flaps. The plt…NTSB ATL87IA163Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Birmingham, ALThe pilot reported that during a landing, he forgot to extend the landing gear. He was wearing a 'dave clark' headset with earplugs & did not hear the landing gear warning horn. During a subsequent check of the landing gear, it operated normally.NTSB LAX87LA164Accident · No injuriesLimited investigationFinal reportBeech S35 · Tucson, AZThe aircraft door came open during the initial climb after takeoff because it was not properly closed and locked. The pilot raised the landing gear. Thereafter, because of slow acceleration, he elected to land on the remaining runway. He moved the landing…NTSB BFO87FA024Accident · No injuriesField investigationFinal reportCessna R-182 · Martinsburg, WVThe plt stated that he forgot to make a final before lndg check because he was concentrating on traffic and the short lndg he had been requested to make. Twr personnel violated USAF procedures when they requested that the acft hold short of the east-west rwy…NTSB ANC87IA003Incident · No injuriesIncident investigationFinal reportBoeing 727-22C · Anchorage, AKAfter departure, the flight crew retracted the landing gear and noticed a nose gear disagreement light. Upon arriving at Anchorage, the flight crew could not lower the nose gear through normal or manual means. The airplane landed with main gear extended and…NTSB MIA86IA029Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Miami, FLThe plt stated that he was on a practice instrument apch & after arriving at minimums, declared a missed apch, retracted his landing gear & flaps but decided to land and continued his apch & inadvertently landed gear up.NTSB MIA86IA017Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe plt stated that he made a normal apch to rwy 12 buy on landing rollout as the nose of the acft touched down the nose gear ass'y folded & the acft slid to a stop, post crash examination of the acft revealed that the green light for the nose gear remained…NTSB MIA86LA003Accident · No injuriesLimited investigationFinal reportCessna 414 · Sarasota, FLThe plt stated that his right main gear would not extend, so he circled the arpt for about 1/2 hour to burn off excess fuel, retracted the remaining gear & intentionally landed gear up on rwy 32. Examination of the right main landing it to extend beyond it's…NTSB MIA85LA258Accident · No injuriesLimited investigationFinal reportCessna 177RG · Ormond Beach, FLThe plt stated that he forgot to extend the landing gear prior to touchdown while on a test flight after maintainence work was performed on the acft.NTSB LAX85LA381Accident · No injuriesLimited investigationFinal reportCessna 402A · San Jose, CAThe aircraft landed gear up. The pilot reported no malfunction and said he forget to lower the landing gear.NTSB MIA85IA182Incident · No injuriesIncident investigationFinal reportPiper Aztec PA-23-250 · Vero Beach, FLWhile in the traffic pattern, the cfi's attention was diverted as he attempted to assist ATC with some radio frequency info. While being so distracted, he permitted the student to land the acft with the gear up.NTSB MIA85IA156Incident · No injuriesIncident investigationFinal reportRockwell AC-500 · Palm Beach, FLOn final apch, the acft was advised twice by the tower to go around because his landing gear was not extended, the acft did not respond & landed gear up on rwy 13. Examination of the landing gear system after the occurrence revealed the warning horn was…NTSB ATL85LA092Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Charleston, SCPlt making practice coupled ILS apch in VMC. Intercepted localizer outside the outer marker. Held the gear,intending to lower them at om. Continued inbd to dh where he resumed manual control. Observed gear warning lt and heard aural gear warning but failed to…NTSB ATL83IA188Incident · No injuriesIncident investigationFinal reportMooney M20E · Hinesville, GAThe pilot failed to lower landing gear. The subsequent landing was executed non-intentional gear up. The pilot stated that she was preoccupied with a noise in the vicinity of the door.NTSB ANC83IA052Incident · No injuriesIncident investigationFinal reportCessna 177RG · Wasilla, AKThe pilot failed to extend the landing gear & the acft landed unintentional gear up.