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 GAA19CA037Accident · No injuriesData collectionFinal reportZenith CH601 · Junction City, KSThe pilot's failure to secure the canopy latch before takeoff, which resulted in the canopy opening in flight and the subsequent loss of airplane control.NTSB GAA19CA020Accident · No injuriesData collectionFinal reportCessna 172 · Lawrenceville, GAThe student pilot's improper pitch application, which resulted in a hard landing and subsequent fire. Contributing to the accident was the student’s failure to give over the flight controls to the flight instructor when instructed to do so.NTSB ANC19CA003Accident · No injuriesData collectionFinal reportCessna 207 · Anchorage, AKThe pilot's inadequate in-flight fuel management, which resulted in fuel starvation and the subsequent loss of engine power, and her subsequent failure to maintain clearance from trees during the approach to land at a nearby airstrip.NTSB GAA19CA011Accident · Minor injuriesData collectionFinal reportBeech 55 · San Antonio, TXThe pilot's improper takeoff trim setting and failure to properly secure his seatbelt, which resulted in a loss of airplane control. Contributing to the accident was the pilot's failure to follow the Before Takeoff checklist.NTSB GAA19CA025Accident · No injuriesData collectionFinal reportCessna 152 · Lakeland, FLThe pilot's improper landing flare, which resulted in a hard, bounced landing and the nose gear collapsing.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 GAA18CA564Accident · No injuriesData collectionFinal reportCessna 150 · Roseburg, ORThe pilot's loss of directional control during landing.NTSB GAA18CA578Accident · No injuriesData collectionFinal reportCirrus SR22 · Frederick, MDThe pilot's improper landing flare, which resulted in the airplane porpoising.NTSB GAA18CA562Accident · No injuriesData collectionFinal reportRutan Rutan Long EZ · Independence, ORThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing.NTSB GAA18CA560Accident · Minor injuriesData collectionFinal reportPiper PA22 · Hillsdale, MIThe pilot’s exceedance of the airplane’s critical angle of attack during the landing flare, which resulted in an aerodynamic stall.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 GAA18CA555Accident · No injuriesData collectionFinal reportHimmeroeder Hansgeorg Bearhawk · Williams, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA551Accident · No injuriesData collectionFinal reportPiper PA28 · Cypress, TXThe student pilot’s improper approach path after the airplane encountered turbulence, which resulted in the airplane landing hard short of the runway.NTSB GAA18CA529Accident · No injuriesData collectionFinal reportPiper PA46 · Hartford, CTThe pilot’s unstabilized approach and hard landing, which resulted in a nose landing gear collapse.NTSB GAA18CA514Accident · No injuriesData collectionFinal reportCessna 150 · Eldorado, TXThe pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN18LA346Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Shreveport, LAThe student pilot's overshoot of the runway, which resulted from her misperception of an engine issue due to her failure to maintain proper pitch control during initial climb.NTSB GAA18CA495Accident · No injuriesData collectionFinal reportCessna 140 · Hayes Center, NEThe pilot's failure to maintain directional control during landing.NTSB GAA18CA493Accident · Minor injuriesData collectionFinal reportCessna 172 · Silver City, NMThe pilot’s failure to maintain directional control while landing with a quartering tailwind.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 GAA18CA494Accident · No injuriesData collectionFinal reportPiper PA18 · Gilliam Glacier, AKThe pilot's improper decision to take off in gusting crosswind conditions, which resulted in a loss of control and collision with terrain.NTSB GAA18CA481Accident · No injuriesData collectionFinal reportHelio H 295 · Great Falls, MTThe pilot’s failure to maintain lateral control of the airplane during takeoff in a quartering tailwind.NTSB ERA18LA215Accident · No injuriesLimited investigationFinal reportCessna R182 · Florence, SCThe pilot's failure to comply with emergency procedures in the pilot's operating handbook, resulting in the collapse of the main landing gear during landing. Contributing to the accident was the pilot's failure to address the low battery voltage before…NTSB GAA18CA470Accident · Minor injuriesData collectionFinal reportWalter C Smythe Tango XR · Mansfield, OHThe pilot’s exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall.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 GAA18CA519Accident · No injuriesData collectionFinal reportCessna 150 · Everett, WAA total loss of engine power due to carburetor icing during final approach, which resulted in a hard landing short of the runway and the nose landing gear collapsing.NTSB GAA18CA444Accident · No injuriesData collectionFinal reportCessna 195 · Hood River, ORThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA474Accident · No injuriesData collectionFinal reportDiamond DA20 · Van Nuys, CAThe student pilot's failure to maintain directional control during landing in a left quartering headwind, which resulted in a ground loop.NTSB GAA18CA427Accident · Minor injuriesData collectionFinal reportCessna 152 · Hollywood, FLThe student pilot’s inadvertent encounter with thunderstorm conditions and her failure to maintain a proper landing flare in a crosswind, which resulted in a bounced landing.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 WPR18CA213Accident · No injuriesData collectionFinal reportCessna E162 · Burlington, WAThe student pilot’s failure to maintain pitch control during an aborted takeoff.NTSB CEN18LA271Accident · No injuriesLimited investigationFinal reportSteen Skybolt · Lexington, TXThe fatigue failure of the main landing gear (MLG) truss, which resulted in the MLG spreading apart.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 GAA18CA434Accident · No injuriesData collectionFinal reportClassic Waco · North Myrtle Beach, SCThe pilot's failure to maintain directional control during landing in a left quartering headwind.NTSB GAA18CA404Accident · No injuriesData collectionFinal reportCessna 180 · Cut Bank, MTThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA400Accident · No injuriesData collectionFinal reportChampion 8GCBC · Waunakee, WIThe pilot’s failure to maintain clearance from tall corn along the edge of the airstrip during takeoff.NTSB GAA18CA414Accident · No injuriesData collectionFinal reportNorth American AT · Moneta, VAThe pilot's failure to maintain a proper descent rate, which resulted in a bounced landing and his subsequent failure to maintain directional.NTSB GAA18CA395Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · San Carlos, CAThe pilot’s failure to maintain a proper glidepath and crosswind correction during landing, which resulted in an aerodynamic stall.NTSB ERA18LA184Accident · 1 fatalLimited investigationFinal reportSwearingen SX300 · Daytona Beach, FLThe pilot's failure to maintain adequate airspeed during landing, which led to the airplane exceeding its critical angle-of-attack, experiencing an aerodynamic stall and hard landing, which resulted in a landing gear collapse, loss of directional control, and…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 GAA18CA391Accident · No injuriesData collectionFinal reportCessna 172 · Troy, MIThe student pilot’s failure to maintain a proper landing flare, which resulted in a hard, porpoised landing during an aborted go-around.NTSB GAA18CA390Accident · No injuriesData collectionFinal reportCessna 421 · Clifton, TXThe pilot's improper landing flare in crosswind conditions, which resulted in a hard landing.NTSB GAA18CA449Accident · No injuriesData collectionFinal reportCessna 182 · Swainsboro, GAThe pilot's unstabilized approach during the initial landing with a right quartering tailwind, which resulted in a hard landing and subsequent go-around and the collapse of the nose landing gear during the subsequent 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 GAA18CA381Accident · No injuriesData collectionFinal reportPiper PA 30 · Goodyear, AZThe pilot receiving instruction’s failure to maintain directional control during the landing roll.NTSB GAA18CA363Accident · No injuriesData collectionFinal reportPiper PA22 · Yakutat, AKThe pilot’s failure to maintain directional control during landing.