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 MIA06CA003Accident · No injuriesData collectionFinal reportBeech 58 · Jacksonville, FLThe pilot's improper use of the normal brakes during the landing roll and his delay in performing a go-around resulting in an emergency descent/landing on grass past the departure end of the runway and subsequent collapse of the left main landing gear.Oct 6, 2005 · N4UT · Substantial damageNTSB DEN06CA006Accident · No injuriesData collectionFinal reportBell 206L-4 · Denver, COthe pilot's improper preflight planning and preparation resulting in him taking the helicopter into the air with insufficient fuel to accomplish the flight, and the subsequent fuel exhaustion leading to the hard landing.Oct 6, 2005 · N206DB · Substantial damageNTSB ANC06TA002Accident · No injuriesFinal reportAviat A-1B · Fairbanks, AKThe flight instructor's inadequate supervision of the dual student during the landing roll, which resulted in the dual student applying the brakes excessively, and the airplane nosing over. A factor associated with the accident was the excessive braking by…Oct 6, 2005 · N792 · Substantial damageNTSB CHI06CA007Accident · No injuriesData collectionFinal reportBeech C23 · Higginsville, MOThe airport operator's failure to properly mark the runway construction project, the exposed lip at the runway end, and the pilot's failure to obtain NOTAM information prior to the flight. A factor was the inadequate marking of the runway.Oct 5, 2005 · N9738L · Substantial damageNTSB LAX06CA003Accident · No injuriesData collectionFinal reportAerospatiale AS350B · Grand Canyon, AZthe pilot's failure to maintain control of the helicopter during landing in gusty wind conditions, which resulted in a hard landing and ground resonance.Oct 4, 2005 · N31MH · Substantial damageNTSB CHI06CA001Accident · No injuriesData collectionFinal reportPyramid Aventura II · Lake City, MIThe pilot's failure to obtain or maintain airspeed which resulted in the encountered stall/mush. An additional cause was the pilot's failure to maintain clearance from trees during his precautionary landing. The trees were a factor.Oct 4, 2005 · N9696K · Substantial damageNTSB SEA06CA002Accident · No injuriesData collectionFinal reportBeech D35 · Creswell, ORThe pilot's failure to attain a proper touchdown point and worn brakes. Inadequate maintenance was a factor.Oct 3, 2005 · N2106D · Substantial damageNTSB MIA06LA002Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Destin, FLThe inadequate design of the engine mount which led to cracking of the mount resulting in a loss of directional control and collapse of the nose landing gear. A contributing factor was the failure of maintenance personnel to comply with a service bulletin to…Oct 3, 2005 · N9199P · Substantial damageNTSB NYC06CA001Accident · No injuriesData collectionFinal reportWaco YMF · Kensington, NHAn overload fracture of the right main landing gear during the landing roll, which resulted in a nose over.Oct 2, 2005 · N89B · Substantial damageNTSB DFW06CA001Accident · No injuriesData collectionFinal reportCessna 195 · Addison, TXThe pilot's failure to maintain directional control while landing. A contributing factor was the wind gusts.Oct 2, 2005 · N9880A · Substantial damageNTSB SEA06LA003Accident · No injuriesLimited investigationFinal reportBeech B-60 · Arlington, WAMain landing gear collapse during the landing rollout for undetermined reasons.Oct 1, 2005 · N924GF · Substantial damageNTSB ANC05CA151Accident · No injuriesData collectionFinal reportCessna 182 · Bethel, AKThe pilot's misjudged distance and speed, which resulted in an overrun and a nose over during the landing roll. A factor associated with the accident was the dusk lighting conditions.Oct 1, 2005 · N3569Y · Substantial damageNTSB DEN05LA150Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Longmont, COthe failure of the left rudder cable resulting in a loss of directional control by the pilot. Contributing to the accident was the improper repair procedures on the seat frame.Sep 30, 2005 · N113AW · Substantial damageNTSB ATL05CA164Accident · No injuriesData collectionFinal reportMaule MT-7-235 · Guyton, GAThe pilot's improper recovery from a bounced landing, and improper flare, which resulted in a hard landing.Sep 28, 2005 · N1012H · Substantial damageNTSB CHI05CA275Accident · No injuriesData collectionFinal reportCessna T206H · Sturgeon Bay, WIThe unexpected wave that the airplane encountered during the landing flare.Sep 27, 2005 · N206WK · Substantial damageNTSB NYC05CA147Accident · No injuriesData collectionFinal reportCessna 182 · Southampton, NYThe pilot's failure to maintain directional control while landing.Sep 25, 2005 · N5203N · Substantial damageNTSB IAD05CA141Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 77A · Louisville, KYThe ground crewman's failure to release the basket of the balloon when it resumed flight during the landing phase. A factor in the accident was the wet grass at the landing site.Sep 24, 2005 · N4024P · No damageNTSB NYC05CA146Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot's failure to maintain directional control during landing.Sep 23, 2005 · N99137 · Substantial damageNTSB MIA05CA160Accident · No injuriesData collectionFinal reportBell 206B3 · Titusville, FLThe flight instructor's improper flare resulting in a hard landing and main rotor contact with tail boom.Sep 23, 2005 · N39MK · Substantial damageNTSB LAX05LA315Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fall River Mill, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain runway alignment during landing.Sep 23, 2005 · N5756Y · Substantial damageNTSB LAX05CA314Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kamuela, HIThe student's misjudged landing flare, and the instructor's inadequate supervision and delayed remedial action. A factor in the accident was the high density altitude.Sep 23, 2005 · N82001 · Substantial damageNTSB IAD05CA140Accident · No injuriesData collectionFinal reportBeech BE-36 · Farmingdale, NYThe pilot's improper recovery from a bounced landing.Sep 23, 2005 · N8014T · Substantial damageNTSB NYC05LA145Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland BK-117-B2 · Columbus, OHThe pilot's failure to maintain aircraft control during the landing flare, which resulted in a hard landing. A factor associated with this accident was a tailwind.Sep 22, 2005 · N117MK · Substantial damageNTSB LAX05TA306Accident · No injuriesFinal reportBell 407 · Inyokern, CAThe pilot failed to maintain tail rotor clearance from obstacles during landing.Sep 21, 2005 · N702WP · Substantial damageNTSB CHI05CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Mount Ayr, IAThe pilot's selection of a wrong runway, and the misjudged distance/speed which resulted in an overrun. Contributing factors were the tailwind, and the ditch.Sep 21, 2005 · N6266W · Substantial damageNTSB DEN05CA145Accident · No injuriesData collectionFinal reportCessna 172S · Cedar City, UTthe student pilot's failure to maintain aircraft control during the landing. Factors contributing to the accident were the improper flare and improper recovery from a bounced landing.Sep 20, 2005 · N172GW · Substantial damageNTSB NYC05CA143Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.Sep 19, 2005 · N64763 · Substantial damageNTSB CHI06CA018Accident · No injuriesData collectionFinal reportStinson 108-1 · Tea, SDThe pilot's failure to maintain directional control during the landing rollout which resulted in the encountered ground loop.Sep 19, 2005 · N8495K · Substantial damageNTSB SEA05LA196Accident · No injuriesLimited investigationFinal reportCessna 152 · Olympia, WAThe pilot's loss of aircraft control during landing roll, and airplane's subsequent inadvertent ground loop.Sep 18, 2005 · N49189 · Substantial damageNTSB LAX05CA302Accident · No injuriesData collectionFinal reportCessna 172S · Show Low, AZthe pilot's selection of a downwind runway for landing and his inadequate compensation for the strong and gusty quartering tail wind conditions, which resulted in a tail strike during landing.Sep 18, 2005 · N121CW · Substantial damageNTSB DEN05LA142Accident · Serious injuriesLimited investigationFinal reportShea Vans RV6A · Glendo, WYfailure of the nose gear during the landing roll.Sep 18, 2005 · N985JS · Substantial damageNTSB DCA05MA099Accident · No injuriesMajor investigationFinal reportAirbus A321-231 · Fort Lauderdale, FLFollowing a bounced landing, the pilot in command activated his sidestick controller while the first officer was in control of the airplane, which subsequently resulted in the overcontrol of pitch and a tailstrike. Contributing to the circumstances of this…Sep 18, 2005 · N583NK · Substantial damageNTSB CHI05CA270Accident · No injuriesData collectionFinal reportCessna 182S · Waukesha, WIThe misjudged flare by the pilot.Sep 18, 2005 · N5467C · Substantial damageNTSB ANC05CA148Accident · No injuriesData collectionFinal reportAeronca 7AC · Coldfoot, AKThe pilot's misjudgment of distance/altitude during the landing flare/touchdown, which resulted in an undershoot and subsequent nosing down of the airplane when the main landing gear tires contacted shallow water prior to the intended landing site.Sep 17, 2005 · N2873E · Substantial damageNTSB ANC05CA147Accident · No injuriesData collectionFinal reportCessna 172 · Anchorage, AKThe pilot's misjudgment of distance/speed during landing, which resulted in an overrun, a loss of directional control, and a nose over during the landing roll.Sep 17, 2005 · N124SM · Substantial damageNTSB LAX05CA307Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Reno, NVthe pilot's inadequate compensation for wind conditions and failure to maintain directional control. Contributing factors to the accident were the gusting quartering tail wind conditions.Sep 16, 2005 · N8063T · Substantial damageNTSB NYC05LA142Accident · No injuriesLimited investigationFinal reportRaytheon BE-390 · Rockland, METhe pilot's failure to maintain aircraft control during landing.Sep 15, 2005 · N701DF · Substantial damageNTSB LAX05CA304Accident · No injuriesData collectionFinal reportBeech 95-B55 · Porterville, CAthe pilot's failure to extend the landing gear prior to landing.Sep 15, 2005 · N127F · Substantial damageNTSB CHI05CA268Accident · Minor injuriesData collectionFinal reportCessna 180A · Lodi, WIThe pilot's failure to maintain directional control of the airplane during landing resulting in a nose-over.Sep 15, 2005 · N392PT · Substantial damageNTSB CHI05CA264Accident · Minor injuriesData collectionFinal reportMaule MT-7-260 · Decatur, INThe pilot's improper decision to land on a runway with a tailwind, the improper recovery from a bounced landing, and the loss of control during landing roll. Factors included the tailwind and the post.Sep 14, 2005 · N42619 · Substantial damageNTSB MIA05CA156Accident · No injuriesData collectionFinal reportCessna 172-S · Kendall-Tamiami, FLThe pilot's failure to recover from a bounced landing which resulted in damage to the airplane.Sep 13, 2005 · N513JG · Substantial damageNTSB ANC05CA140Accident · No injuriesData collectionFinal reportPiper PA-18 · Nenana, AKThe pilot's improper recovery from a bounced landing during the landing roll, which resulted in a loss of control and a nose over.Sep 13, 2005 · N7761D · Substantial damageNTSB IAD05CA143Accident · No injuriesData collectionFinal reportMaule MT7-235 · Capon Bridge, WVThe pilot's misjudged distance/speed which resulted in an overrun and a subsequent impact with trees.Sep 12, 2005 · N627RK · Substantial damageNTSB ANC05CA146Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a collision with a tree. A factor contributing to the accident was a tailwind.Sep 12, 2005 · N1755P · Substantial damageNTSB ANC05CA141Accident · No injuriesData collectionFinal reportCessna 185F · Bettles, AKThe pilot's inadequate compensation for a gusty crosswind, which resulted in a loss of control and an inadvertent ground-loop during the landing roll. Factors associated with the accident were the ground-loop and gusts.Sep 12, 2005 · N58316 · Substantial damageNTSB CHI05CA265Accident · No injuriesData collectionFinal reportAviat A-1B · Drummond Island, MIThe pilot's failure to adequately compensate for the wind conditions, his failure to perform a go-around, and he flared improperly. Factors included the downdraft and the shoreline.Sep 11, 2005 · N7QR · Substantial damageNTSB DFW05CA233Accident · No injuriesData collectionFinal reportIsrael Aircraft Industries 1124 · New Braunfels, TXThe airplane's collision with a coyote during the landing roll. A contributing factor was the prevailing night conditions.Sep 10, 2005 · N349MC · Substantial damageNTSB ATL05CA160Accident · No injuriesData collectionFinal reportCessna 182T · Wilmington, NCThe pilot's improper flare which resulted in a hard landing, and the collapse of the nose gear.Sep 10, 2005 · N1251C · Substantial damageNTSB ANC05LA142Accident · No injuriesLimited investigationFinal reportCessna 185E · Pilot Point, AKThe pilot's misjudged landing flare, which resulted in a hard landing and an overload failure of the main landing gear during the landing touchdown.Sep 10, 2005 · N1592F · Substantial damageNTSB CHI05CA262Accident · No injuriesData collectionFinal reportCessna 310Q · Boscobel, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the pilot's diverted attention due to the open cabin door.Sep 9, 2005 · N75SM · Substantial damage