NTSB investigations
649 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '094') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '094') 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 WPR16LA174Accident · No injuriesClass 3 · LimitedFinal reportSchneider K/Cook C SC Skybolt · Corvallis, ORThe collapse of the left main landing gear truss due to a weld joint failure, which resulted in substantial damage to the fuselage frame structure.NTSB WPR16LA163Accident · No injuriesLimited investigationFinal reportCessna TR182 · Torrance, CAThe failure of the right main landing gear to fully extend for reasons that could not be determined because postaccident examination and testing did not reveal any evidence of preimpact mechanical failures or malfunctions that would have precluded normal…NTSB CEN16LA356Accident · No injuriesLimited investigationFinal reportCessna P210N · Waco, TXThe failure of the right main landing gear (MLG) down-lock mechanism, which resulted in the collapse of the landing gear. The root cause of the right MLG down-lock mechanism could not be determined because the components were not available for examination.NTSB ERA16LA271Accident · No injuriesLimited investigationFinal reportCessna 310L · Linden, NJThe overtravel of the main landing gear (MLG) actuator, which resulted in the MLG partially collapsing upon landing. The reasons for the overtravel of the MLG actuator could not be determined due to the unavailability of the wreckage.NTSB ERA16LA260Accident · No injuriesLimited investigationFinal reportSorensen Danny Pitts S1 S · Somerville, TNThe failure of the left landing gear leg due to fatigue, which resulted in a ground loop during landing. Contributing to the accident was the airplane builder's installation of a custom-built landing gear rather than the landing gear included with the…NTSB WPR16LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Salinas, CAThe fatigue failure of a bulkhead-skin joint that supported the main landing gear leg, which resulted in the collapse of the left main landing gear. Contributing to the failure were the non-original structural configuration of the 60-year-old airplane and the…NTSB ERA16LA255Accident · No injuriesLimited investigationFinal reportFleet Fleet 16B · Rhinebeck, NYFailure of the gear strut mount nut due to wear.NTSB CEN16LA242Accident · Minor injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Wyoming, MNThe pilot’s inadequate flight planning and navigation for a flight at night, which resulted in his having to conduct a precautionary landing on an interstate highway due to low fuel and impacting the post of a wire road divider.NTSB ERA16LA234Accident · No injuriesLimited investigationFinal reportPiper PA28 · Poughkeepsie, NYAn overstress failure of the left main landing gear attachment bolts, which resulted in the left main landing gear collapse.NTSB GAA16CA314Accident · No injuriesData collectionFinal reportPiper PA 32 · Lincoln Park, NJThe airplane struck a deer during the landing flare resulting in substantial damage.NTSB GAA16CA286Accident · No injuriesData collectionFinal reportCessna 172 · Arlington, WAThe failure of the airplane’s right steering rod end, which resulted in the pilot’s inability to maintain directional control.NTSB ERA16WA335Incident · No injuriesForeign investigationPiper PA34 · Yurimaguas, PeruOn June 4, 2016, at 1712 universal coordinated time, a Piper PA-34-200T, Peruvian registration OB-1564, was substantially damaged when the nose landing gear collapsed during landing at Moises Benzaquen Rengifo Airport (SPMS), Yurimaguas, Peru. The pilot and…NTSB WPR16LA117Accident · No injuriesLimited investigationFinal reportHowell Bob Howell Special · Minden, NVThe failure of the right main landing gear assembly due to overstress fracture.NTSB ERA16LA190Accident · No injuriesLimited investigationFinal reportCessna R182 · Lake City, FLInternal failure of the main electrical contactor, which resulted in a complete loss of electrical power and an inability to extend the landing gear through normal means.NTSB ERA16LA177Accident · No injuriesLimited investigationFinal reportMaher Daniel J Velocity · Worcester, MAThe overstress failure of the nose landing gear fork assembly.NTSB ENG16WA022Accident · Minor injuriesForeign investigationBeech 1900 · Gander, CanadaThe Transportation Safety Board of Canada has notified the NTSB of an accident involving a Beechcraft 1900D, which occurred on April 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Transportation Safety Board of Canada…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 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 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 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 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 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 CEN16WA081Incident · No injuriesForeign investigationCessna 172RG · Cascais, PortugalNTSB 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 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 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 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 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 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 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 WPR15IA252Incident · No injuriesIncident investigationFinal reportCirrus SR22 · Scottsdale, AZThe failure of the nose landing gear due to unanticipated fatigue loads.NTSB CEN15WA457Accident · No injuriesForeign investigationCessna 340A · Vicovu de Sus, RomaniaThe accident is under the jurisdiction and control of the Romanian government. This report is for information purposes only and contains only information released by or obtained from the Romanian government. Further information pertaining to this accident may…NTSB ERA15LA381Accident · No injuriesLimited investigationFinal reportBrown James W Zenith Stol CH 750 · Charlotte, VTThe pilot’s inadequate compensation for a crosswind during landing, which resulted in a side load application to the nose landing gear and its subsequent collapse.NTSB ENG15WA035Incident · No injuriesForeign investigationEmbraer EMB120 · Moscow, RussiaThe government of Russia has notified the NTSB of an accident involving a Embraer EMB-120ER airplane that occurred on July 31, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the…NTSB CEN15LA351Accident · Minor injuriesLimited investigationFinal reportRoberts Bruce W Vans Aircraft RV 9A · Land O' Lakes, WIThe pilot’s failure to maintain a proper descent rate, which resulted in a hard landing.NTSB ANC15LA048Accident · No injuriesLimited investigationFinal reportCessna 210 · Juneau, AKA loss of hydraulic fluid due to a fractured left main landing gear hydraulic actuator as a result of a fatigue crack, which led to the landing gear collapsing upon touchdown.NTSB ERA15LA249Accident · No injuriesLimited investigationFinal reportBeech B 55 · Clearwater, FLThe pilot's delayed completion of the before landing checklist, including the extension of the landing gear, during an approaching thunderstorm, which resulted in a landing with the landing gear in transit and the subsequent collapse of the landing gear.NTSB WPR15LA184Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Sacramento, CAA manufacturing defect that resulted in fatigue failure of the left main landing gear trunnion.NTSB CEN15WA248Accident · No injuriesForeign investigationPiper PA-28RT-201T · Grenchen, SwitzerlandNTSB WPR15LA179Accident · No injuriesLimited investigationFinal reportBurr Express 2000 RG · Glendale, AZA collapse of the left main landing gear for reasons that could not be determined based on the available information.NTSB GAA15LA092Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Fresno, CAThe failure of the nose landing gear (NLG) leg due to fatigue fractures, which resulted in the NLG collapsing during landing.