NTSB investigations
1,789 cases where the sequence of events included Landing gear collapse.
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\" = '094' 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" = '094' 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 ERA16LA145Accident · No injuriesLimited investigationFinal reportCessna 175B · Hurley, MSThe mechanic's failure to identify and remove a plastic sheath covering a portion of the mixture control cable during an annual inspection, which prevented the proper securing of the mixture control cable and full travel of the control at the carburetor and…NTSB CEN16LA153Accident · No injuriesLimited investigationFinal reportGill Craig Lancair IV P Propjet · Addison, TXCollapse of the nose landing gear during landing for reasons that could not be determined, because postaccident examination did not detect any anomalies consistent with a preimpact failure or malfunction.NTSB CEN16LA138Accident · Serious injuriesLimited investigationFinal reportCessna 180D · Shiprock, NMThe pilot's failure to maintain directional control after encountering a sudden change in wind direction during the landing roll.NTSB GAA16CA170Accident · No injuriesData collectionFinal reportWaco CTO · Ridgeland, SCThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB GAA16CA164Accident · No injuriesData collectionFinal reportPphu Ekolot KR-030 Topaz · Lake Dallas, TXThe pilot's failure to maintain directional control during the landing in a crosswind, which resulted in a runway excursion and an impact with terrain.NTSB GAA16CA159Accident · No injuriesData collectionFinal reportCessna 152 · Valparaiso, INThe student pilot's failure to maintain pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.NTSB GAA16CA154Accident · No injuriesData collectionFinal reportNicholson David F RV 9 · Allison, IAThe pilot's improper soft-field landing technique, which resulted in a nose landing gear collapse and a nose over.NTSB ANC16WA026Incident · No injuriesForeign investigationCirrus SR22 · Kagoshima, JapanOn March 21, 2016 , about 1320 Local Time, a Cirrus SR22 airplane, Japan registration number JA01YK, operated by the pilot, sustained minor damage following a fracture of the nose landing gear strut during landing at the Kagoshima Airport, Japan. The pilot…NTSB GAA16CA155Accident · No injuriesData collectionFinal reportPiper PA 46 · Pflugerville, TXThe pilot's failure to maintain directional control during the landing touchdown in gusty crosswind conditions, which resulted in runway excursion, and nose gear collapse.NTSB ERA16LA135Accident · No injuriesLimited investigationFinal reportCessna 210L · Myrtle Beach, SCA complete loss of electrical power, which resulted from the separation of an alternator wire due to corrosion. Contributing to the accident was the failure of the emergency landing gear extension system due to a lack of hydraulic fluid, which resulted in…NTSB ERA16LA131Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon 400A · Rome, GAThe pilots’ failure to use available sources of wind information before landing and recognize cues indicating the presence of the tailwind and conduct a go-around, which resulted in their landing with a significant tailwind and a subsequent runway overrun.NTSB GAA16CA148Accident · No injuriesData collectionFinal reportRemos G 3/600 · Chesapeake, OHThe pilot's unstable approach, which resulted in excessive airspeed during the touchdown, subsequent bounced landing, collapsed nose landing gear, and a runway excursion.NTSB ENG16RA017Accident · No injuriesForeign investigationBoeing 737 · Mumbai, IndiaThe Air Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a Jet Airways Boeing 737, which occurred on March 3, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Air Accident Investigation…NTSB ERA16LA121Accident · No injuriesLimited investigationFinal reportPiper PA46 · Brunswick, GAA hard landing, which resulted in the collapse of the nose gear assembly due to an overstress fracture and separation of the right side mounting point.NTSB ENG16WA019Incident · No injuriesForeign investigationBoeing 767 · Domodedovo, RussiaInitial Notification sent to NTSB by the Ministry of Transport of the Russian Federation. The Ministry of Transport of the Russian Federation has appointed Federal Air Transport Agency (FATA) to investigate the incident of an Azurair Airlines B767-300…NTSB WPR16LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Pullman, WAThe student pilot's improper landing approach, which resulted in a hard landing and the subsequent overstress failure of the nose landing gear.NTSB ERA16LA113Accident · No injuriesLimited investigationFinal reportLiberty Aerospace Liberty XL · Orlando, FLA failure of the right brake for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's decision to continue the flight after experiencing a braking anomaly due to his perceived need for an…NTSB CEN16LA105Accident · No injuriesLimited investigationFinal reportEnstrom TH-180 · Menominee, MIThe failure of the torque meter mounting bolts, which resulted in a loss of engine power to the main drive belt and rotors.NTSB GAA16CA136Accident · No injuriesData collectionFinal reportFox AL KIT FOX Model · Slate Creek, IDThe left main landing gear forward gear tube collapsed during the landing roll.NTSB WPR16LA060Accident · No injuriesLimited investigationFinal reportPiper PA46 · Burns, ORThe total loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of an anomaly that would have precluded normal operation. Contributing to the accident was a preexisting landing gear anomaly that…NTSB CEN16LA100Accident · No injuriesLimited investigationFinal reportMaule M 7-235C · Macon, MOThe failure of the right main landing gear assembly for reasons that could not be determined based on the available information.NTSB WPR16LA058Accident · No injuriesLimited investigationFinal reportCessna 340A · Bakersfield, CAMaintenance personnel’s repeated failure to re-rig the main landing gear (MLG) in accordance with the airplane manufacturer's service manual requirements, which resulted in the collapse of the right MLG.NTSB GAA16CA103Accident · No injuriesData collectionFinal reportAviat A-1C · Breckenridge, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB CEN16WA148Accident · No injuriesForeign investigationCessna 402 · Leicestershire, United KingdomThe Air Accidents Investigation Branch (AAIB) United Kingdom has notified the NTSB of an accident involving a Cessna 402B, Registration G-MAPP, that occurred on January 14, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB…NTSB WPR16LA048Accident · No injuriesLimited investigationFinal reportBeech 35 C33 · Henderson, NVA partial loss of engine power during final approach for reasons that could not be determined based on available information.NTSB GAA16CA098Accident · No injuriesData collectionFinal reportJohnson Glenn L Zodiac 601 XL · Chesapeake, VAThe pilot's failure to maintain pitch control during the landing, causing the airplane to bounce and the nose gear to collapse, resulting in substantial damage to the firewall and frame.NTSB CEN16WA081Incident · No injuriesForeign investigationCessna 172RG · Cascais, PortugalNTSB GAA16CA089Accident · No injuriesData collectionFinal reportWaco YMF · Fullerton, CAThe pilot's failure to maintain directional control during the landing roll.NTSB DCA16LA032Accident · No injuriesLimited investigationFinal reportBoeing 737 3H4 · Nashville, TNthe flight crew's early turn towards the assigned gate because taxiway lighting had been inadvertently turned off by the controller-in-charge which resulted in the airplane leaving the paved surface. Contributing to the accident was the operation of the…NTSB GAA16CA082Accident · No injuriesData collectionFinal reportAeronca 7BCM · Reidsville, NCThe pilot's loss of pitch control while maneuvering at low altitude, which resulted in a collision with terrain, a left main landing gear collapse, and runway excursion.NTSB GAA16CA079Accident · No injuriesData collectionFinal reportMcmichael Elmer L Lancair 360 · Rimrock, AZThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion and a left main landing gear collapse.NTSB ERA16LA073Accident · No injuriesLimited investigationFinal reportCessna 310 · Kennesaw, GAInadequate inspection and rigging of the landing gear system, which resulted in the subsequent failure and collapse of the left main landing gear during landing.NTSB GAA16CA077Accident · No injuriesData collectionFinal reportPiper PA 28 · California, MDThe student pilot's descent below the prescribed final approach path at night, and flight instructor's failure to correct the student pilot's descent, which resulted in a collision with trees and impact with the ground.NTSB DCA16WA025Accident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe DGAC of Mexico has notified the NTSB of an accident involving a Boeing 737 that occurred on November 26, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as the State of…NTSB GAA16CA074Accident · No injuriesData collectionFinal reportCessna 177 · Palm Springs, CAThe failure of a shaft seal at the nose gear retraction/extension actuator, which resulted in a loss of hydraulic fluid and a main landing gear collapse during landing.NTSB WPR16IA025Incident · No injuriesIncident investigationFinal reportCirrus Design SR22T · Paso Robles, CAThe failure of the nose landing gear due to unanticipated fatigue loads.NTSB ERA16LA042Accident · No injuriesLimited investigationFinal reportCessna P210 · Atlanta, GAThe pilot's delayed extension of the landing gear and his failure to ensure that the main landing gear (MLG) were down and locked before touchdown, which resulted in the collapse of both MLG. Contributing to the landing gear collapse was the mis-set landing…NTSB DCA16WA012Accident · No injuriesForeign investigationBoeing 737 · Johannesburg, South AfricaThe government of South Africa has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on October 26, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…NTSB ENG16WA016Incident · No injuriesForeign investigationBoeing 737 · Cusco, PeruThe Comisión de Investigación de Accidentes de Aviación – CIAA of Peru has notified the NTSB of an incident involving a Peruvian Airlines Boeing 737, which occurred on October 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB GAA16CA023Accident · Serious injuriesData collectionFinal reportCessna 140 · Fort Benton, MTA hard landing which resulted in a loss of directional control, main landing gear collapse, and damage to the left wing spar.NTSB ERA16LA058Accident · No injuriesLimited investigationFinal reportCessna R182 · Sanford, FLA collapse of the nose landing gear due to a separation of the drag attachment fitting from the airframe. The separation was likely due to preexisting damage from an undetermined event.NTSB GAA16CA025Accident · No injuriesData collectionFinal reportDonham Timothy J RV 6A · Grenada, MSThe pilot's loss of directional control during landing, which resulted in a runway excursion.NTSB GAA16CA042Accident · No injuriesData collectionFinal reportCessna 421 · Amarillo, TXThe loss of directional control during taxi to the runway as a result of insufficient brake fluid level in the right brake master cylinder, resulting in a taxiway excursion and collision with a drainage culvert.NTSB GAA16CA017Accident · No injuriesData collectionFinal reportCessna 195A · Aztec, NMThe pilot's failure to maintain directional control during landing, which resulted in runway excursion and collision with terrain.NTSB WPR16LA015Accident · No injuriesLimited investigationFinal reportCessna 310J · Tucson, AZThe insufficient right main landing gear (MLG) down-lock tension due to maintenance personnel's failure to perform a rigging procedure during the airplane's most recent inspection, which resulted in the right MLG collapsing during landing.NTSB GAA15CA287Accident · No injuriesData collectionFinal reportPiper PA 24 · West Bend, WIThe pilot's failure to maintain his descent rate during the landing, which resulted in a hard landing and runway excursion.NTSB CEN15LA444Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · New Orleans, LAThe collapse of the landing gear for reasons that could not be determined based on the available information.NTSB CEN15LA415Accident · No injuriesLimited investigationFinal reportBeech 58 · Gary, INThe pilot’s failure to ensure that the landing gear was down while on short final, his subsequent failure to conduct a go-around, and his loss of situational awareness of the airplane’s altitude above the runway while landing.NTSB ERA15LA356Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Stratford, CTThe pilot's failure to maintain directional control while landing in a crosswind.NTSB CEN15LA417Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Pekin, INThe pilot's loss of directional control during the landing roll due to contact with a corn crop that extended into the runway area. Contributing to the accident were the lack of accurate available information to the pilot regarding the runway condition, the…