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 WPR11CA343Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Colville, WAThe pilot’s inadequate braking after touchdown, which resulted in a runway excursion.NTSB WPR11CA336Accident · No injuriesData collectionFinal reportStearman C3-B · Spokane, WAThe pilot's failure to maintain directional control on landing. Contributing to the accident was the touch down in a slide-slip.NTSB WPR11CA330Accident · No injuriesData collectionFinal reportCessna 210-5(205) · McKenzie Bridge, ORThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB ERA11CA396Accident · No injuriesData collectionFinal reportPiper PA-30 · Plant City, FLThe failure of a screw in the nose landing gear aligner assembly for undetermined reasons, which prevented the landing gear from fully extending.NTSB ANC11LA061Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Anchorage, AKThe pilot’s decision to depart with minimal fuel and his improper fuel management and engine restart procedures, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the Pilot Operating Handbook did not provide the…NTSB WPR11CA323Accident · No injuriesData collectionFinal reportTL Ultralight Sro Stingsport · Soda Springs, IDThe pilot's improper landing flare and failure to maintain directional control during the landing.NTSB WPR11CA314Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · Spanish Fork, UTThe pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control.NTSB ERA11LA386Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Louisville, KYThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a landing gear collapse.NTSB ERA11CA408Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe student pilot's improper recovery from a bounced landing.NTSB WPR11CA301Accident · No injuriesData collectionFinal reportCessna A185F · Page, AZThe pilot's decision to take off with a gusty quartering tailwind.NTSB CEN11LA430Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Barron, WIThe loss of engine power, which resulted from fuel exhaustion due to the pilot's inadequate in-flight planning.NTSB WPR11LA313Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Flagstaff, AZFatigue failure of an engine mount attachment foot, which resulted in collapse of the nose landing gear during landing. Contributing to the accident was the failure of the owner/operator to adhere to the manufacturer's suggested engine mount inspection…NTSB CEN11LA419Accident · No injuriesLimited investigationFinal reportVanDenburg Pietenpol Air Camper · Gwinn, MIThe pilot’s loss of directional control during the landing roll, which resulted in a ground loop.NTSB CEN11CA438Accident · No injuriesData collectionFinal reportCessna A188 · Castroville, TXThe pilot's failure to maintain obstacle clearance during the agricultural spraying flight.NTSB ERA11LA357Accident · No injuriesLimited investigationFinal reportCessna 182F · Warrenton, VAThe fatigue failure of the left main landing gear due to inadequate maintenance inspection that did not detect and correct corrosion pitting.NTSB ERA11CA366Accident · No injuriesData collectionFinal reportChampion 7FC · Wellsville, PAThe pilot's failure to maintain adequate airspeed on final approach which resulted in an aerodynamic stall.NTSB CEN11LA402Accident · Serious injuriesLimited investigationFinal reportCessna P210R · Albia, IAThe pilot's inadequate preflight inspection, in which he did not detect that less fuel was on board the airplane than planned, which precipitated a loss of engine power due to fuel exhaustion during initial descent.NTSB ERA11CA351Accident · No injuriesData collectionFinal reportPerth Amboy Bird CK · New Castle, PAThe pilot's improper use of brakes during the landing rollout.NTSB ANC11CA049Accident · No injuriesData collectionFinal reportChampion 7HC · Kenai, AKThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear, and a nose over.NTSB WPR11CA262Accident · No injuriesData collectionFinal reportCessna 152 · Idaho Falls, IDThe pilot's inadequate landing flare and improper bounced landing recovery.NTSB ERA11CA346Accident · No injuriesData collectionFinal reportCessna 177 · Boone, NCThe pilot's delay in executing a go-around.NTSB WPR11LA363Accident · No injuriesLimited investigationFinal reportCessna 340A · Fullerton, CAThe pilot's inability to maintain directional control during landing due to the left brake's degraded performance due to oil contamination, which resulted from the fatigue failure of an oil line component.NTSB ERA11IA316Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Newburgh, NYThe flight crew did not ensure that the landing gear selector handle was in the full down (extend) position. Contributing to the incident was inadequate checklist information.NTSB DCA11WA064Accident · No injuriesForeign investigationBoeing 737 · Brussels, BelgiumThe Belgium Air Accident Investigation Unit (AAIU) has notified the NTSB of an accident involving a B737-45D that occurred on May 26, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions of ICAO…NTSB WPR11CA235Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Yakima, WAThe pilot’s failure to maintain directional control upon landing.NTSB CEN11LA361Accident · No injuriesLimited investigationFinal reportFlournoy Martin R Flournoy MR S1S · Colorado Springs, COThe pilot’s loss of directional control during the landing rollout due to failure of the tailwheel assembly for undetermined reasons.NTSB CEN11LA357Accident · No injuriesLimited investigationFinal reportCessna T210M · Pueblo, COFailure of the landing gear to fully extend due to a failed o-ring in the nose gear actuator piston and a broken seal in the emergency landing gear extension system.NTSB CEN11IA341Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COThe fatigue failure of the nose landing gear (NLG) end cap, which resulted in insufficient hydraulic pressure to secure the left main landing gear into the down and locked position. Contributing to the fatigue failure was the NLG end cap’s non-optimum grain…NTSB ERA11LA301Accident · No injuriesLimited investigationFinal reportLeigh S-6 Coyote II · New Kent, VAA total loss of engine power for undetermined reasons.NTSB CEN11LA390Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Grand Forks, NDThe flight instructor’s inadequate supervision of the landing, which resulted in an inadequate flare and subsequent hard landing.NTSB WPR11CA206Accident · No injuriesData collectionFinal reportTew William P Team Rocket F1 · Heber, UTThe pilot's failure to maintain directional control during landing.NTSB ERA11LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Meriden, CTMaintenance personnel's inadequate inspection of the main landing gear, which resulted in a failure of the right main landing gear’s inboard torque link lug due to a fatigue fracture. Contributing to the accident was owner's lack of compliance with a factory…NTSB ERA11CA248Accident · No injuriesData collectionFinal reportWalker J C Lancair 320 · Baltimore, MDThe pilot's improper recovery from a bounced landing.NTSB CEN11CA288Accident · No injuriesData collectionFinal reportPiper PA-30 · Austin, TXThe pilot’s loss of directional control during landing which resulted in a runway excursion.NTSB ERA11LA239Accident · No injuriesLimited investigationFinal reportBeech BE99 · Cedartown, GAThe failure of the left main landing gear bearings and supports due to inadequate lubrication by unknown maintenance personnel.NTSB CEN11TA279Accident · No injuriesFinal reportRockwell International 500-S · Eden Prairie, MNThe pilot's inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.NTSB CEN11LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oklahoma City, OKThe loss of aircraft control due to the failure of the stabilator control cable turnbuckle.NTSB CEN11FA274Accident · Minor injuriesField investigationFinal reportBeech A36 · Monaville, TXA total loss of engine power for undetermined reasons.NTSB ERA11LA231Accident · No injuriesLimited investigationFinal reportCessna 172RG · Okeechobee, FLThe failure of the main landing gear to lock in the extended position for undetermined reasons and both pilots’ failure to ensure that the landing gear was down and locked prior to landing.NTSB ERA11LA221Accident · No injuriesLimited investigationFinal reportCessna 310F · Sanford, FLThe failure of the nose landing gear due to inadequate servicing of the nose gear strut reservoir.NTSB CEN11LA254Accident · No injuriesLimited investigationFinal reportNorth American B25 · Encinal, TXThe co-pilot’s premature retraction of the landing gear during takeoff, which resulted in a gear collapse and impact with the runway surface.NTSB ERA11LA203Accident · No injuriesLimited investigationFinal reportCessna 150H · Maury City, TNThe pilot's failure to attain the proper glidepath during on off-airport landing.NTSB ANC11CA018Accident · No injuriesData collectionFinal reportCessna A185F · Aniak, AKThe inadvertent contact with a rut in the snow while taxiing, resulting in the collapse of the right main landing gear.NTSB ENG11WA054Incident · No injuriesForeign investigationBell 412 - EP · Zakum Field, United Arab EmiratesOn March 16, 2011, about 0718 coordinated universal time, a Bell 412EP helicopter, United Arab Emirates (UAE) registration A6-FLV, experienced a failure of the landing gear aft cross tube during loading of the helicopter at Zakum Field, UAE. The investigation…NTSB ERA11LA191Accident · No injuriesLimited investigationFinal reportCessna 414 · New York, NYThe improper rigging of the right main landing gear, which resulted in ovestress fractures of a bolt and aft lug on the trunnion assembly.NTSB WPR11CA162Accident · No injuriesData collectionFinal reportCessna 180 · Pine, AZThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with terrain.NTSB ERA11WA220Incident · No injuriesForeign investigationBeech B200 · Vichada, ColombiaOn March 6, 2011, about 2140 Universal Coordinated Time (UTC), a Beech BE-200, Columbian registration HK-4108, operated by Servicio Aereo de Capurgana (SEARCA S.A.), was substantially damaged during landing at Vichada, Columbia, following loss of engine…NTSB CEN11LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Delphi, INThe pilot's loss of directional control, resulting in a runway excursion, and the subsequent separation of the left main landing gear for undetermined reasons.NTSB ERA11CA202Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Allentown, PAThe pilot's failure to adequately compensate for crosswind conditions, resulting in a hard landing.NTSB WPR11LA143Accident · No injuriesLimited investigationFinal reportMooney M20F · Nephi, UTThe failure of the nose gear during landing for reasons that could not be determined due to postaccident damage.