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 GAA19CA383Accident · No injuriesData collectionFinal reportPiper PA28 · Milton, FLThe flight instructor's intentional overapplication of rudder to avoid a ditch during landing with a tailwind, which resulted in a runway excursion and landing gear collapse.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 GAA19CA313Accident · No injuriesData collectionFinal reportCessna 150 · Renton, WAThe pilot receiving instruction's failure to maintain directional control and his overapplication of right rudder and the flight instructor's delayed remedial action during the landing, which resulted in a ground-loop.NTSB GAA19CA301Accident · No injuriesData collectionFinal reportLuscombe 8 · Heber, UTThe pilot's exceedance of the airplane's critical angle of attack during an aborted landing, which resulted in an aerodynamic stall.NTSB GAA19CA287Accident · No injuriesData collectionFinal reportJihlavan Airplanes Sro KP5 · East Haddam, CTThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB WPR19LA153Accident · No injuriesClass 3 · LimitedFinal reportCessna 195 · Socorro, NMThe pilot's failure to maintain airplane control while landing with a quartering tailwind.NTSB GAA19CA276Accident · No injuriesData collectionFinal reportPiper J3C · Louisa, VAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the landing gear collapsing.NTSB GAA19CA373Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Blairesville, GAThe pilot's failure to maintain airplane control during landing in gusting crosswind conditions, which resulted in a hard landing and landing gear collapse.NTSB GAA19CA266Accident · No injuriesData collectionFinal reportRyan John Steffey Subsonex · Latrobe, PAThe pilot's failure to maintain pitch control while attempting to secure the canopy, which opened shortly after takeoff and resulted in the airplane impacting the ground and the main landing gear collapsing. Contributing to the accident was the pilot's…NTSB GAA19CA257Accident · Minor injuriesData collectionFinal reportCessna 182 · Glades Park, COThe pilot's failure to maintain adequate airspeed and climb rate during takeoff in high-density altitude conditions, which resulted in his failure to clear power lines.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 GAA19CA242Accident · No injuriesData collectionFinal reportFlight Design Ctls · Sandy Valley, NVThe pilot's steep bank turn at low altitude, which resulted in a rapid descent and hard landing.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 GAA19CA243Accident · No injuriesData collectionFinal reportHanson Parakeet A4 Replica · Faribault, MNThe pilot's improper landing flare with a left crosswind, which resulted in a hard landing, collapsed landing gear, runway excursion, and nose-over.NTSB CEN19LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Cloud, MNThe pilot's failure to maintain directional control during a crosswind landing. Contributing to the accident was the pilot’s decision to land in crosswind conditions given his lack of recent experience in those conditions.NTSB GAA19CA211Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA-18-225 · Denver, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA19CA217Accident · Minor injuriesData collectionFinal reportVans Vans RV-12 · Wall, SDThe pilot's improper decision to depart from a slush-covered runway, which resulted in a loss of directional control, a runway excursion, and a subsequent nose-over.NTSB ANC19LA016Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Bethel, AKA total loss of engine power due to a fatigue failure of the crankshaft. A contributing factor was the inadequate inspection during the engine’s last overhaul.NTSB GAA19CA199Accident · No injuriesData collectionFinal reportBeech 36 · Monument Valley, UTThe pilot's failure to maintain directional control and runway heading during landing, which resulted in a runway excursion and the nose landing gear collapsing.NTSB GAA19CA191Accident · No injuriesData collectionFinal reportPiper PA32 · Swainsboro, GAThe pilot's failure to maintain directional control during landing in gusting crosswind conditions, which resulted in a runway excursion and the landing gear collapsing.NTSB GAA19CA198Accident · No injuriesData collectionFinal reportCessna 195 · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and the nose landing gear collapsing.NTSB WPR19LA098Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 24 · Reno, NVFailure of the engine mount due to internal corrosion and wall thinning, which resulted in a loss of directional control and nose gear collapse during landing.NTSB GAA19CA167Accident · No injuriesData collectionFinal reportCub Crafters CC18 · Yakima, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop, and the flight instructor's delayed remedial action.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 GAA19CA162Accident · No injuriesData collectionFinal reportCessna 172 · Scottsdale, AZThe student pilot's failure to maintain the runway heading during a go-around with a crosswind, which resulted in the left main landing gear impacting a runway sign.NTSB GAA19CA151Accident · No injuriesData collectionFinal reportCessna 172 · Morristown, NJThe student pilot's improper rudder input and the flight instructor's delayed remedial action during takeoff, which resulted in a loss of directional control, a runway excursion, and the landing gear collapsing.NTSB GAA19CA140Accident · No injuriesData collectionFinal reportPiper PA24 · Slaton, TXThe student pilot's complacency, which led to his improper crosswind correction and subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground collision.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 CEN19TA073Accident · Serious injuriesFinal reportBeech A36 · Fort Worth, TXThe pilot's improper fuel management, which resulted in fuel starvation and a loss of engine power.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 ANC19CA010Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA31 · Chignik Lagoon, AKThe pilot’s selection of an unsuitable runway for landing, which resulted in a loss of control and runway excursion.NTSB WPR19CA067Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Chino, CAThe pilot's loss of directional control while landing, which resulted in a ground loop.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 CEN19LA059Accident · No injuriesLimited investigationFinal reportCessna T210 · Flint, MIThe failure of the nose landing gear actuator hydraulic hose, which resulted in the loss of hydraulic fluid and hydraulic system pressure and a subsequent gear-up landing.NTSB GAA19CA106Accident · No injuriesData collectionFinal reportCessna 172 · Caldwell, NJThe student pilot's failure to maintain directional control during the takeoff roll.NTSB GAA19CA087Accident · No injuriesData collectionFinal reportCessna 172 · Monroe, NCThe student pilot's improper landing flare, which resulted in a hard, bounced landing and nose landing gear collapse.NTSB GAA19CA073Accident · No injuriesData collectionFinal reportBeech C23 · Porterville, CAThe pilot's improper landing flare, which resulted in an abnormal landing and subsequent porpoise.NTSB GAA19CA072Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Benson, AZThe pilot's overcorrection during the landing, which resulted in a loss of directional control.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 ERA19LA086Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46 · Petersburg, WVA loss of control during the landing roll and subsequent runway excursion for reasons that could not be determined based on the available evidence.NTSB GAA19CA081Accident · No injuriesData collectionFinal reportCessna 172 · Inverness, FLThe pilot receiving instruction's failure to maintain directional control during landing.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 GAA19CA045Accident · No injuriesData collectionFinal reportPiper PA18 · Denver, COThe pilot's failure to maintain directional control of the airplane during landing in gusting wind conditions.NTSB ERA19LA033Accident · No injuriesLimited investigationFinal reportPiper PA28 · New Market, VAA loss of engine power on takeoff due to restricted air flow to the engine.