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 ERA19LA279Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Charlotte AmalieThe collapse of the left main landing gear for undetermined reasons.NTSB ANC19LA047Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Talkeetna, AKA failure of the aft left weld-on fuselage landing gear fitting due to a poor weld joint.NTSB DCA19WA195Incident · No injuriesForeign investigationBoeing 737 · El Alto, BoliviaThe government of Bolivia has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on August 03, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bolivia's investigation under the provisions…NTSB ANC19LA039Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Boise, IDA ductile overstress fracture failure of the right main landing gear bell crank assembly pivot bolt, which resulted in a collapse of the right main landing gear.NTSB GAA19WA478Accident · No injuriesForeign investigationBeech C90 · Bucaramanga, ColombiaNTSB WPR19LA180Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Chandler, AZThe pilot's failure to maintain directional control during landing in a gusting right quartering headwind, which resulted in a collapse of the left main landing gear.NTSB WPR19LA169Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Independence, ORFatigue failure of the right landing gear axle, which resulted in a loss of control during the landing roll.NTSB CEN19LA168Accident · No injuriesClass 3 · LimitedFinal reportRockwell 690 · Jacksonville, FLThe overstress fracture of the roll pin in the nose landing gear (NLG) spacer assembly which caused interference between the nose wheel actuator rod and the left forward gear door actuating rods preventing the NLG to fully extend into the full down and locked…NTSB GAA19WA597Accident · No injuriesClass 4 · ForeignPiper PA28 · Buenos Aires, ArgentinaNTSB GAA19WA541Accident · No injuriesForeign investigationCessna C 680 · Salta, ArgentinaThe government of Argentina has notified the NTSB of an accident involving a CESSNA C 680 airplane that occurred on July 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Argentina's investigation under the…NTSB ERA19LA169Accident · No injuriesClass 3 · LimitedFinal reportHawker Siddeley Hunter · Newport News, VAThe failure of the right main landing gear due to a fatigue cracking.NTSB GAA19WA265Accident · No injuriesForeign investigationLearjet 45 · Edinburgh, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a LEARJET 45 airplane that occurred on May 04, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB ERA19LA123Accident · No injuriesClass 3 · LimitedFinal reportBeech A100 · Latrobe, PAA landing gear collapse due to the separation of the actuator pinion bearing support from the actuator, which resulted in the failure of the actuator shaft.NTSB ERA19LA125Accident · No injuriesClass 3 · LimitedFinal reportPiper PA31 · Leesburg, FLMaintenance personnel’s improper rigging of the main landing gear actuators, which resulted in the collapse of the right main landing gear.NTSB DCA19WA099Accident · No injuriesForeign investigationBeech 1900 · Ourgla, AlgeriaThe Civil Aviation Directorate (CAD) of Algeria has notified the NTSB of an accident involving a Beech 1900D, which occurred on March 3, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the CAD investigation under the provisions of ICAO…NTSB GAA19CA132Accident · No injuriesData collectionFinal reportPiper PA 18A · McGrath, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the landing gear collapsing.NTSB DCA19WA067Incident · No injuriesForeign investigationBoeing 737 · Ndjili, Congo - KinshasaThe Aviation Accident Investigation Bureau (BPEA) of the Democratic Republic of Congo has notified the NTSB of an incident involving a Boeing 737, which occurred on January 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the BPEA…NTSB WPR19WA113Accident · No injuriesForeign investigationCirrus SR22 · Lanseria, South AfricaOn January 6, 2019, about 0730 coordinated universal time, a Cirrus SR22T, ZS-ARI, experienced a nose landing gear collapse during the landing roll at Lanseria, Gauteng Province, South Africa. The pilot and passenger were not injured. The airplane was…NTSB ERA19TA067Accident · No injuriesClass 3Final reportBeech A36 · Summerland Key, FLThe pilot’s inadvertent retraction of the landing gear during landing rollout, resulting in a landing gear collapse.NTSB DCA19WA026Incident · No injuriesForeign investigationBoeing 737 · La Paz, BoliviaThe AIG of Bolivia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 22, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AIG of Bolivia's investigation under the provisions of ICAO Annex…NTSB WPR19LA020Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Burns, ORThe failure of the left main landing gear due to fatigue cracking of a bolt that initiated at a corrosion pit, which formed in the absence of a required protective cadmium coating.NTSB DCA18WA305Incident · No injuriesForeign investigationBoeing 737 · Chattogram, BangladeshThe AAIG of Bangladesh has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 26, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIG of Bangladesh's investigation under the provisions of…NTSB WPR18LA272Accident · No injuriesClass 3 · LimitedFinal reportSmith AEROSTAR601 · Heber, UTA recent hard landing resulted in a fracture of a joint from a cylinder to a main landing gear.NTSB ERA18LA270Accident · No injuriesLimited investigationFinal reportMaule M7 · Floresville, TXThe separation of the left inboard main landing gear (MLG) attachment bolt due to insufficient torque, which resulted in the collapse of the left MLG.NTSB ERA18LA220Accident · No injuriesLimited investigationFinal reportCzech Sport Piper Sport · Stuart, FLInadequate maintenance inspection of the airplane's nose landing gear, which resulted in a nose landing gear collapse during landing due to cracking and corrosion.NTSB ERA18WA275Incident · No injuriesClass 4 · ForeignPiper PA42 · Contamana, PeruNTSB GAA18WA590Accident · No injuriesForeign investigationAero Commander 500 · Canefield Airoprt, DominicaThe government of Dominica has notified the NTSB of an accident involving a AERO COMMANDER 500 airplane that occurred on July 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominica's investigation under the…NTSB ERA18LA201Accident · No injuriesClass 3 · LimitedFinal reportAero Commander 560 · Crestview, FLA collapse of the right main landing gear for reasons that could not be determined based on the available information.NTSB CEN18TA296Accident · No injuriesFinal reportFisher Dakato Hawk · Oshkosh, WIThe failure of the left main landing gear for reasons that could not be determined, which resulted in a loss of directional control during the ground roll.NTSB DCA18WA248Accident · No injuriesForeign investigationBoeing 737 · Confins county, BrazilThe government of Brazil has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of…NTSB CEN18WA395Accident · No injuriesForeign investigationPiper PA34 · Kemble, United KingdomThe government of United Kingdom has notified the NTSB of an accident involving a Piper PA34 airplane that occurred on July 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Kingdom's investigation under the…NTSB ERA18LA226Accident · No injuriesLimited investigationFinal reportPiper PA28 · Thomaston, GAA landing gear axle nut being pulled from the threads of the axle rod at an unknown time, which resulted in the pilot's inability to maintain directional control during landing.NTSB ERA18LA182Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 25 · Flat Rock, ALThe failure of the right landing gear during takeoff due to a fatigue failure, which resulted in a runway excursion.NTSB DCA18WA234Incident · No injuriesForeign investigationBoeing 777 · Narita, JapanThe government of Japan has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on June 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of ICAO…NTSB ERA18LA171Accident · No injuriesLimited investigationFinal reportPiper PA 30 · Vero Beach, FLThe collapse of all three landing gear for reasons that could not be determined because postaccident examination of the landing gear system revealed no evidence of any mechanical malfunctions or failures that would have precluded normal operation.NTSB ANC18LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Ramona, CAThe failure of the engine-driven hydraulic pump due to the installation of improper cap screws, which resulted in a gap in the pump housing, a subsequent hydraulic leak, and the landing gear collapsing.NTSB WPR18WA208Incident · No injuriesForeign investigationPiper PA28 · Pretoria, South AfricaNTSB WPR18LA153Accident · No injuriesLimited investigationFinal reportPiper PA24 · San Jose, CAA landing gear retraction during the landing rollout for reasons that could not be determined based on the available evidence.NTSB ERA18LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Sandersville, GAA nose landing gear collapse for reasons that could not be determined based on the available information.NTSB WPR18LA129Accident · No injuriesClass 3 · LimitedFinal reportGulfstream AM Corp Comm Div 695A · Bishop, CAThe failure of the left main landing gear upper arm forging due to fatigue cracking and subsequent overstress, which resulted in the collapse of the landing gear during the landing roll.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 CEN18WA184Accident · No injuriesForeign investigationCessna 525 · Santiago, SpainOn April 5, 2018, about 1810 universal coordinated time (UTC), a Cessna 525C, Spanish registration EC-MOQ, was involved in an accident at the Santiago Airport (A Coruha, Spain). The left main landing gear collapsed while exiting the runway after landing. Two…NTSB WPR18WA117Incident · No injuriesForeign investigationBeech 58 · East London, South AfricaOn April 3, 2018, at 0612 coordinated universal time, a Beechcraft 58 Baron airplane, registration ZS-JYD, sustained minor damage after the nose gear collapsed during landing at East London (FAEL), Eastern Cape, South Africa. The pilot, sole occupant, was not…NTSB GAA18CA180Accident · Minor injuriesData collectionFinal reportAnderson Darrell L Starduster TOO · Tucson, AZThe failure of the left main landing gear axle weld during the landing roll.NTSB CEN18LA128Accident · No injuriesLimited investigationFinal reportCessna 310R · Kansas City, MOThe landing gear collapse due to the separation of the end fitting bolt for reasons that could not be determined based on the available evidence.NTSB GAA18CA138Accident · No injuriesData collectionFinal reportSikorsky S76 · New Iberia, LAThe helicopter’s striking of a pothole while taxiing, which resulted in the right main landing gear collapsing.NTSB ANC18LA019Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Juneau, AKA loss of hydraulic fluid due to a fatigue failure of the right main landing gear hydraulic actuator, which resulted in the pilot's inability to fully extend the landing gear and a main landing gear collapse during the landing roll.NTSB WPR18LA065Accident · No injuriesLimited investigationFinal reportJust JA30 Superstol · Kapolei, HIThe collapse and separation of the right landing gear suspension strut due to overload.NTSB WPR18LA057Accident · No injuriesLimited investigationFinal reportCessna T210L · Aurora, ORA collapse of the right main landing gear during the landing roll because the gear would not lock into place. Contributing to the accident was the pilot's failure to perform the alternate landing gear extension procedure before landing.NTSB CEN18CA058Accident · No injuriesData collectionFinal reportPiaggio P.180 · Georgetown, TXThe pilot's inadequate compensation for crosswind conditions, which resulted in a hard landing and the right main landing gear collapsing.