NTSB investigations
85 cases where the first occurrence was “Complete gear collapsed”.
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\" = 194) 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" = 194) 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 MKC84LA082Accident · No injuriesLimited investigationFinal reportMooney MK20B · Pocahontas, ARThe acft landing gear retracted during landing. The plt reported that the manually activated gear handle popped out of the gear down position during the landing roll. The plt indicated that he thought the gear handle was positively in the down lock position.NTSB NYC84LA079Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Philadelphia, PAThe plt broke out of the overcast at 1000 ft lowered flaps and landed the acft with the gear retracted. The plt said he had lowered the gear. The gear warning horn reportedly did not sound.NTSB CHI84LA075Accident · No injuriesLimited investigationFinal reportPiper J-4E · White Bear Lake, MNThe ski-equipped acft suffered landing gear failure during a landing on a snow covered turf rwy. The landing gear separated when an attach point failed. The plt gave fatigue failure as a reason for the failure.NTSB ATL84LA037Accident · No injuriesLimited investigationFinal reportBeech BE-58P · Beaufort, SCThe plt stated that he started having problems with various eletrically operated components during the latter part of the flt. During descent into Beaufort, he lost the ability to transmit and communicated to ATC by transponder. The plt said he put the gear…NTSB ATL84LA030Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Montgomery, ALAccording to the plt he had an unsafe gear indication while in the traffic pattern. He alerted the tower to the problem and made a low pass over the runway. He was informed by tower personnel that the gear looked down and normal. During the landing the plt…NTSB LAX83LVM11Accident · No injuriesFinal reportBeech 55 · Watsonville, CAThe acft was landed with the gear retracted. The plt stated that he lowered the gear but raised it when the tower requested that he circle while equipment was cleared from the rwy. When he was cleared to land he approached the rwy andas he did so saw a person…NTSB DEN83LA219Accident · No injuriesLimited investigationFinal reportCessna 320B · Mandan, NDThe acft landed gear up after the normal and emergency extension systems failed to extend the landing gear. During the appraoch to land the plt noticed the landing gear down light'would not come on'. A missed approach was executed. The pltdiscussed the…NTSB DEN83LA223Accident · No injuriesLimited investigationFinal reportMooney M-2O · Rock Spring, WYThe acft landed with the landing gear up after the flt experienced some delays in landing because an airshow was in progress. The accident plt was told to hold 30 minutes and then 6 minutes later was told he could land if he hurried and'got back to the arpt…NTSB FTW83LA385Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Catarina, TXThe acft was damaged when the landing gear was retracted during landing rollout at Catarina, TX. The plt identifed himself as larry day from chattanooga, TN. He claimed to have had engine trouble and was unable to extend the gear for landing. Post accident…NTSB LAX83IA342Incident · No injuriesIncident investigationFinal reportBeech B-35 · Fullerton, CAThe gear collapsed on the landing roll. Gear were found to be dry. Tge pilot had a gear flag but does not remember a green light.NTSB ATL83LA251Accident · No injuriesLimited investigationFinal reportCessna 310 · West Point, VAThe plt stated that he was practicing single engine procedures and landings. On his fourth landing to a full stop he landed gear up. He said he just forgot to put the gear down.NTSB LAX83LA321Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Franklin, CAThe acft landed wheels-up during a training flt. The CFI was simulating a single-engine landing. The CFI said he and thestudent were engrossed in conversation and forgot to lower the landing gear prior to landing. The warning horn did not sound until just…NTSB DEN83LA220Accident · No injuriesLimited investigationFinal reportBeech D35 · St. Thomas, NDThe plt stated that after a flt to inspect farm fields he 'made an approach to the arpt and landed with the gear up.' He said he heard the gear warning as he crossed the threshold but interpeted it as a stall warning.NTSB NYC83LA149Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Glens Falls, NYThe acft landed with the wheels up on a dual instructional flight. The flight had been doing air work before returning to glen Falls to continue training with takeoffs and landings. During the 1st landing the acft came over the threshold a little low but it…NTSB MKC83LA119Accident · No injuriesLimited investigationFinal reportBeech J35 · Fulton, MOThe pilot stated that before landing he was having electrical problems and shortly after touchdown all three landing gear collapsed. The persons who removed and inspected the acft have stated that the damage to the landing gear doors consisted of…NTSB MKC83LA095Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Springfield, MOThe student pilot retracted the landing gear during landing roll. This was to be a touch and go landing and the student had just raised the flaps in preparation for takeoff. The instructor stated that during the landing roll the student pilot moved the gear…NTSB CHI83LA182Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Champaign, ILThe acft was landed with the gear up. Investigation revealed during a retraction test, that no malfunction of the landing gear system prevented normal operation. Electrical system showed that the warning the horn did not operate. When the cockpit was checked…NTSB FTW83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Oklahoma City, OKWitnesses reported that the landing gear was lowered at the outer marker on an ILS approach. The pilot stated that he extended full flaps at about 400 feet AGL just as they broke out of the clouds. Almost immediately after landing the pilot retracted the…NTSB ATL83LA102Accident · No injuriesLimited investigationFinal reportMooney M20J · Marietta, GAThe acft landed with the wheels up during an attempted go-around. The plt who was receiving instruction decided as the acft floated during a landing that he would go-around. Full power was added as someone retracted the landing gear and the flaps. The acft…NTSB CHI83LA093Accident · No injuriesLimited investigationFinal reportBeech D18S · Plymouth, INPilot landed the aircraft with the landing gear up. He said he put the gear selector down but after landing the lever was up. He also mistook gear up warning horn for a stall warning. No malfunctions were reported.NTSB ATL83LA090Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Greenville, SCThe aircraft landing gear collapsed during landing rollout. The pilot stated that he raised the gear instead of the flaps during the landing roll.NTSB FTW83LA064Accident · No injuriesLimited investigationFinal reportBeech E33 · Little Rock, ARDuring the landing roll, all three of the landing gear retracted as the pilot was applying brakes to turn off at the first exit. FAA inspectors found the landing gear handle in the down position with the circuit breaker popped. The flaps were also found in…NTSB LAX83LA039Accident · No injuriesLimited investigationFinal reportCessna 210 · El Monte, CAThe pilot experienced a problem directly after takeoff when he discovered the landing gear would not retract. After continually trying to lock the gear in place, he executed an emergency landing. Investigation revealed a malfunction in the hydraulic power…NTSB MIA83LA041Accident · No injuriesLimited investigationFinal reportBeech 35 · Titusville, FLThe pilot reported that before landing, he extended the landing gear and observed a safe down and locked indication. He stated that as he applied brakes at about 45 KTS, the gear warning horn sounded and the gear collapsed. Also, he positively stated that the…NTSB FTW83LA022Accident · No injuriesLimited investigationFinal reportBeech H35 · Abilene, TXThe pilot stated that he extended the gear about 10 to 15 miles out to hold down the speed and descend. Before landing, he noted that none of his lights were working and he was unable to communicate with Abilene radio. Reportedly, he assumed the gear was down…NTSB ATL83LA010Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Camden, SCAccording to the pilot, he received landing information from the UNICOM operator for runway 7. He was advised to keep the pattern tight to accommodate heavy traffic at the airport. While expediting to get off the runway after landing, he reached to retract…NTSB CHI83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Indianapolis, INThe landing gear retracted at 64 mph during the takeoff roll. The takeoff was aborted and the aircraft slid on its fuselage. The landing gear systems all operated normally when checked after the accident.NTSB ATL83LA007Accident · No injuriesLimited investigationFinal reportBeech S35 · Macon, GAAfter landing and coming to a stop on the runway, the pilot made a 180 degree turn to proceed to a taxiway and began cleaning up the cockpit. During the turn, the gear collapsed. The pilot stated that he inadvertently raised the gear handle instead of the…NTSB FTW82DA369Accident · No injuriesFinal reportBeech A36 · Shawnee, OKLanding gear collapsed during landing roll.NTSB LAX82DA302Accident · No injuriesFinal reportBeech 58TC · Oakland, CAN17841, landed with the landing gear retracted at metropolitan Oakland airport. The pilot claims that the landing gear was lowered prior to landing. Efforts to reach the pilot for further comments concerning this flight were unsuccessful.NTSB LAX82DA296Accident · No injuriesFinal reportAero Commander 500S · Sacramento, CAPax/plt in right seat inadvertently raised gear instead of flaps.NTSB ATL82DA235Accident · No injuriesFinal reportBeech 58 · Birmingham, ALThe pilot stated that after a normal touchdown and a landing roll of 300-500 feet the gear retracted/collapsed. Subsequently, the entire landing gear system was ground checked and normal function of the system was found. The aircraft flaps were found in the…NTSB CHI82DA250Accident · No injuriesFinal reportPiper PA-30-160 · Salem, ILPilot stated he had 3 green gear lights. During touchdown and roll the landing gear collapsed. The landing gear control switch collar was defective and if the pilot did not hold the gear selector in the down position it may have returned to off before the…NTSB LAX82FVW03Accident · Minor injuriesFinal reportPiper PA-28R-200 · Las Vegas, NVThe pilot reported that during the night landing, he maintained a little more than normal speed and power since this was his first night landing at the mccarran airport. He stated that on final approach for landing, heavy left rudder was needed. He stated he…NTSB MIA82DA099Accident · No injuriesFinal reportBeech F33A · Ft. Lauderdale, FLDuring the landing roll, the landing gear retracted. The pilot recommended that the gear retract lever be located higher on the panel and not near the flap or cowl flap switch.