OpenAirDocs.org

NTSB investigations

53,703 cases where the phase of flight was Landing.

Cases, newest first

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 550)
  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.

NTSB FTW04LA175Accident · No injuriesLimited investigationFinal reportAeronca/Bubeck Bubeck-Aeronca · Burleson, TXThe pilot's inadequate preflight planning/preparation for the flight. Contributing factors were the night visual conditions, and the lack of suitable terrain for landing.Jul 5, 2004 · N6030T · Substantial damageNTSB CHI04CA179Accident · No injuriesData collectionFinal reportWaco YMF-FSC · Lansing, ILThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. The crosswind and the ditch were contributing factors.Jul 5, 2004 · N620CR · Substantial damageNTSB CHI04CA176Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake City, MIThe pilot's failure to maintain directional control during landing.Jul 5, 2004 · N7072B · Substantial damageNTSB CHI04CA174Accident · No injuriesData collectionFinal reportCessna 182N · Lancaster, WIThe pilot's inadequate compensation for the gusty winds and his improper flare. The wind gusts were a contributing factor.Jul 5, 2004 · N92422 · Substantial damageNTSB CHI04CA170Accident · No injuriesData collectionFinal reportPiper PA28-140 · Rush City, MNThe pilot's inadequate compensation for wind conditions which led to his loss of aircraft control. Factors were the wind gusts, the ditch, and the fence.Jul 5, 2004 · N55930 · Substantial damageNTSB ANC04LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-160 · Chugiak, AKThe pilot's excessive use of the airplane's brakes during the landing roll, which resulted in the airplane nosing over. A factor contributing to the accident was the pilot's failure to maintain directional control.Jul 5, 2004 · N8918Y · Substantial damageNTSB SEA04CA123Accident · No injuriesData collectionFinal reportCessna T210M · Mallard Creek, IDImproper touchdown during landing. A factor contributing to the accident was soft ground conditions.Jul 4, 2004 · N761TD · Substantial damageNTSB NYC04LA165Accident · No injuriesLimited investigationFinal reportCessna 172C · Pottstown, PAThe pilot's inadequate flare, which resulted in a hard landing.Jul 4, 2004 · N38RA · Substantial damageNTSB IAD04LA034Accident · No injuriesLimited investigationFinal reportCessna 172N · Wellsboro, PAThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. A factor was the crosswind.Jul 4, 2004 · N10DJ · Substantial damageNTSB NYC04CA155Accident · No injuriesData collectionFinal reportBellanca 7ECA · North Creek, NYThe pilot's failure to maintain directional control during the landing roll. A factor in this accident was the pilot's lack of experience in tail-wheeled airplanes.Jul 3, 2004 · N57430 · Substantial damageNTSB IAD04LA029Accident · No injuriesLimited investigationFinal reportCessna 421B · Portland, MEFailure of the right main landing gear down-lock mechanism resulting in the collapse of the right main landing gear.Jul 2, 2004 · N421KS · Substantial damageNTSB CHI04CA172Accident · No injuriesData collectionFinal reportCessna 310P · Knox, INThe fatigue fracture of the main landing gear assembly.Jul 2, 2004 · N310WH · Substantial damageNTSB NYC04CA164Accident · No injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe pilot's improper flare during touch down, which resulted in a hard landing.Jun 30, 2004 · N421RW · Substantial damageNTSB ATL04IA132Incident · No injuriesIncident investigationFinal reportPilatus PC-12-45 · LaGrange, GAThe pilot's failure to maintain aircraft control during the landing flare.Jun 30, 2004 · N718JP · No damageNTSB SEA04LA120Accident · No injuriesLimited investigationFinal reportSheppard Kitfox IV · Rigby, IDFailure to maintain directional control during the landing roll. Factors include muddy terrain.Jun 29, 2004 · N316R · Substantial damageNTSB LAX04CA252Accident · No injuriesData collectionFinal reportBellanca 7KCAB · Casa Grande, AZthe pilot misjudged the flare resulting in a bounced landing. Also causal was the pilot's inadequate recovery from the bounced landing resulting in a loss of directional control.Jun 29, 2004 · N8717V · Substantial damageNTSB ANC04LA072Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Beluga, AKThe pilot's selection of an unsuitable area for landing, which resulted in an on ground encounter with rocks during the landing roll, and the collapse of the left main landing gear.Jun 29, 2004 · N9038D · Substantial damageNTSB MIA04LA102Accident · No injuriesLimited investigationFinal reportBeech V35B · Bay Saint Louis, MSThe failure of the pilot to verify the landing gear was extended prior to touchdown resulting in a gear-up landing.Jun 27, 2004 · N2167L · Substantial damageNTSB IAD04CA026Accident · Minor injuriesData collectionFinal reportLake LA-250 · Deep River, CTThe pilot's improper recovery from a bounced water landing.Jun 27, 2004 · N802RA · Substantial damageNTSB LAX04LA285Accident · No injuriesLimited investigationFinal reportEurocopter France AS350B3 · Cibecue, AZthe pilot's failure to maintain a proper decent rate during the landing approach and misjudged landing flare, which resulted in a hard landing. A factor in the accident was the brownout conditions created by the dust cloud that interfered with the pilot's…Jun 26, 2004 · N5226R · Substantial damageNTSB LAX04CA250Accident · No injuriesData collectionFinal reportCessna 172S · Glendale, AZthe pilot's failure to maintain directional control of the airplane, which resulted in a veer off the runway and collision with terrain.Jun 26, 2004 · N35389 · Substantial damageNTSB CHI04CA166Accident · No injuriesData collectionFinal reportBeech 23 · Saginaw, MIThe pilot's inadequate compensation for wind conditions, and his inadequate recovery from the bounced landing. The wind gusts and the runway sign were factors.Jun 26, 2004 · N23342 · Substantial damageNTSB CHI04CA165Accident · No injuriesData collectionFinal reportCessna 172S · Fishers, INThe pilot's inadequate remedial actions after an inadequate landing flare and subsequent hard landing. Additional causes were the pilot-induced porpoise and the collapse of the nose landing gear.Jun 26, 2004 · N229ME · Substantial damageNTSB SEA04LA118Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Miles City, MTThe pilot's failure to maintain directional control of the aircraft during the landing roll resulting in a main landing gear collapse.Jun 25, 2004 · N1936P · Substantial damageNTSB LAX04LA266Accident · No injuriesLimited investigationFinal reportLancair LC-40-550FG · Show Low, AZthe pilot's failure to maintain directional control of the airplane during landing after encountering a dust devil.Jun 25, 2004 · N6505L · Substantial damageNTSB ANC04LA071Accident · No injuriesLimited investigationFinal reportChristen Industries Husky A-1 · Bethel, AKThe pilot's failure to attain the proper touchdown point, which resulted in an in-flight collision with terrain during the ensuing aborted landing. A factor associated with the accident is the pilot's misjudgment of the airplane's speed and distance.Jun 25, 2004 · N9591C · Substantial damageNTSB SEA04LA117Accident · No injuriesLimited investigationFinal reportCessna 185F · Bozeman, MTThe failure of the right main gear brake disk attach flange during the landing roll, due to fatigue cracks emanating from numerous corrosion pits present on the surface of the disk, leading to the right brake becoming totally inoperative, and resulting in a…Jun 24, 2004 · N4585F · Substantial damageNTSB FTW04LA178Accident · No injuriesLimited investigationFinal reportCessna 172S · San Antonio, TXThe student pilot's failure to maintain control of the airplane during landing.Jun 24, 2004 · N810SA · Substantial damageNTSB FTW04CA177Accident · No injuriesData collectionFinal reportMooney M20R · Kerrville, TXThe pilot's failure to compensate for existing wind conditions. Contributing factors were the gusty high winds.Jun 24, 2004 · N9147H · Substantial damageNTSB SEA04LA115Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Deer Park, WAThe flight instructor's delayed remedial action. Factors include the owner/pilot's failure to maintain directional control during the landing roll, and a warped/realigned fuselage that contributed to the sensitivity of the aircraft's response to pilot rudder…Jun 23, 2004 · N699DS · Substantial damageNTSB LAX04TA248Accident · Minor injuriesFinal reportBell 206B · Lancaster, CAThe pilot's misjudged autorotative flare and the flight instructor's delayed remedial action and inadequate supervision of the flight.Jun 23, 2004 · N305FD · Substantial damageNTSB DEN04LA093Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Heber City, UTthe pilot's failure to maintain aircraft control during the aborted landing. Contributing factors were the pilot's failure to maintain runway alignment, the fence, and the ditch.Jun 23, 2004 · N2555C · Substantial damageNTSB SEA04CA116Accident · No injuriesData collectionFinal reportChampion 7GCB · Florence, ORPilot's improper touchdown point during landing. A sand mound was a factor in the accident.Jun 21, 2004 · N9827Y · Substantial damageNTSB NYC04CA145Accident · No injuriesData collectionFinal reportCessna 172R · Hartford, CTThe student pilot's improper flare and inadequate compensation for wind conditions. A factor was the gusty winds.Jun 21, 2004 · N356ES · Substantial damageNTSB ANC04LA066Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop/swerve, and the left wingtip and propeller striking the runway. A factor associated with the accident was the installation of oversized tires on the…Jun 21, 2004 · N4685A · Substantial damageNTSB SEA04LA112Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Bandera, WAThe pilot's failure to maintain clearance from an airport sign during the landing roll. Inadequate compensation for the wind gust and the sign were factors.Jun 20, 2004 · UNREG · DestroyedNTSB CHI04CA164Accident · No injuriesData collectionFinal reportCessna 401 · Mt. Vernon, ILThe pilot's misjudgment of the landing flare. Contributing factors were the pilot's failure to execute a stabilized approach for landing. An additional factor was the presence of the runway lights.Jun 20, 2004 · N3234Q · Substantial damageNTSB LAX04CA244Accident · No injuriesData collectionFinal reportFairchild 24R-40 · Lincoln, CAthe pilot's failure to maintain directional control and inadequate compensation for gusty wind conditions, which resulted in a ground loop and collision with the runway.Jun 19, 2004 · N232E · Substantial damageNTSB ATL04CA134Accident · Minor injuriesData collectionFinal reportCessna T210N · Ellijay, GAThe pilot misjudged his airspeed, distance and intended proper touchdown point which resulted in an overrun of the runway surface and the subsequent collision with an embankment.Jun 19, 2004 · N7393C · Substantial damageNTSB ATL04CA133Accident · No injuriesData collectionFinal reportCessna 172 · Kennesaw, GAThe student pilot's failure to maintain directional control during landing roll that resulted in the on ground collision with the ground, and the subsequent collapse of the nose gear.Jun 19, 2004 · N52846 · Substantial damageNTSB NYC04CA143Accident · No injuriesData collectionFinal reportStearman 4E · Loganton, PAThe pilot's failure to maintain aircraft control during the landing roll, which resulted in a nose over. A factor was uneven terrain.Jun 18, 2004 · N785H · Substantial damageNTSB SEA04CA109Accident · Serious injuriesData collectionFinal reportBalloon Works Fire Fly 9 · Aurora, ORPilot's failure to compensate for wind conditions. Wind was a contributing factor.Jun 17, 2004 · N3097R · Minor damageNTSB LAX04CA242Accident · No injuriesData collectionFinal reportVans RV-9A · The Sea Ranch, CAthe pilot's inadequate compensation for gusty crosswind conditions and failure to maintain proper runway alignment, resulting in a collision with trees.Jun 17, 2004 · N93AZ · Substantial damageNTSB SEA04CA105Accident · No injuriesData collectionFinal reportFetherolf Hatz CB-1 · Nampa, IDThe pilot's failure to maintain directional control of the tail wheel aircraft during an aborted landing. Factors include a slight tailwind, and a mound (berm) of earth in the area where the aircraft departed the side of the runway.Jun 16, 2004 · NX26WF · Substantial damageNTSB FTW04CA163Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's improper recovery from a bounced landing.Jun 16, 2004 · N2101M · Substantial damageNTSB ANC04LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · McGrath, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor contributing to the accident was the presence of soft tundra.Jun 16, 2004 · N18ZF · Substantial damageNTSB NYC04LA142Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Norfolk, VAThe student pilot's failure to maintain control of the helicopter, which resulted ground resonance. Contributing to the accident was the improperly serviced landing gear dampers.Jun 15, 2004 · N2065T · Substantial damageNTSB CHI04LA155Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Waukegan, ILThe pilot's misjudgment of the landing flare which resulted in a hard landing. Contributing factors were the subsequent overload and collapse of the nose landing gear.Jun 15, 2004 · N77DK · Substantial damageNTSB DEN04LA091Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTfracture and subsequent total failure of the nose gear strut. A contributing factor was the pilot not being able to control the airplane.Jun 14, 2004 · N6867P · Substantial damageNTSB DEN04LA090Accident · No injuriesLimited investigationFinal reportAircraft Mfg & Dev. Aleros CH 2000 · West Jordan, UTthe pilot's improper flare which resulted in a hard landing. Contributing factors were the low altitude and high airspeed, resulting in an unstabilized approach.Jun 14, 2004 · N8502F · Substantial damage