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 CHI05CA068Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Larimore, NDThe CFI's delay in applying remedial action which resulted in a loss of directional control of the airplane. Factors associated with the accident were the student's excessive application of rudder and the snow bank which the airplane contacted.Feb 9, 2005 · N66ND · Substantial damageNTSB ANC05LA026Accident · No injuriesLimited investigationFinal reportCessna 411A · Hollywood, FLThe failure of the right main landing gear locking mechanism during the landing roll, which resulted in the collapse of the right main landing gear.Feb 8, 2005 · N258JM · Substantial damageNTSB IAD05CA037Accident · No injuriesData collectionFinal reportCessna 172P · Cross Keys, NJThe pilots failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the snow bank.Feb 7, 2005 · N54812 · Substantial damageNTSB NYC05LA049Accident · Minor injuriesLimited investigationFinal reportAeronca 65CA · Ravenswood, WVThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control while landing. A factor in this accident was the crosswind condition.Feb 6, 2005 · N33779 · Substantial damageNTSB NYC05CA050Accident · No injuriesData collectionFinal reportCessna 152 · Kelleys Island, OHThe pilot's failure to maintain obstacle clearance during landing.Feb 5, 2005 · N4649M · Substantial damageNTSB LAX05LA089Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601 · Murrieta, CAThe pilot's misjudgment of distance/altitude on final approach, which resulted in an undershoot of the runway.Feb 5, 2005 · N23LL · Substantial damageNTSB LAX05LA085Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAa loss of directional control due to a jammed rudder pedal, which prevented the pilot from exercising full rudder control authority.Feb 4, 2005 · N4530L · Substantial damageNTSB SEA05LA044Accident · No injuriesLimited investigationFinal reportSmuz RAF 2000 GTX SE · Puyallup, WAThe pilot's misjudged flare followed by an oscillation which damaged the aircraft.Feb 3, 2005 · N26AV · Substantial damageNTSB SEA05LA042Accident · No injuriesLimited investigationFinal reportMaule M-7-260 · Port Angeles, WAThe pilot's improper flare. Factors contributing to the accident included the pilot's improper approach and the glassy water condition.Feb 3, 2005 · N977BE · Substantial damageNTSB SEA05CA043Accident · No injuriesData collectionFinal reportCessna 172N · Idaho Falls, IDThe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight. A contributing factor was the deep snow beside the runway.Feb 3, 2005 · N5204K · Substantial damageNTSB LAX05LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · Desert Center, CAThe instructor's improper decision to land on the dry lakebed without knowing the condition of the landing surface. A factor in the accident was the soft sand surface of the lake bed.Feb 3, 2005 · N472RA · Substantial damageNTSB DEN05LA056Accident · No injuriesLimited investigationFinal reportHughes 369HS · Provo, UTthe pilot's improper in-flight planning and decision making, his failure to maintain terrain clearance, and the total failure of the tail rotor drive shaft as a result of the tail rotor strike.Feb 3, 2005 · N9118F · Substantial damageNTSB CHI05LA064Accident · No injuriesLimited investigationFinal reportCessna A185F · Minneapolis, MNA failure of the tail wheel locking mechanism which resulted in the pilot's inability to maintain directional control of the airplane during the landing roll.Feb 3, 2005 · N1767R · Substantial damageNTSB LAX05CA082Accident · No injuriesData collectionFinal reportCessna 172S · Coalinga, CAthe pilot's inadequate recovery from a bounced landing, and his failure to abort the landing.Feb 2, 2005 · N521JD · Substantial damageNTSB DEN05LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Loveland, COThe dual student's improper flare and the flight instructor's inadequate supervision.. A contributing factor was the inadequate communication between the flight instructor and the dual student,Feb 2, 2005 · N618MN · Substantial damageNTSB CHI05CA060Accident · No injuriesData collectionFinal reportCessna 172RG · Berrien Springs, MIThe pilot not maintaining airspeed leading to an excessive sink rate during a simulated emergency landing after takeoff. An additional cause was the certified flight instructor's inadequate supervision.Feb 1, 2005 · N9515B · Substantial damageNTSB SEA05LA056Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Prineville, OROther maintenance personnel's inadequate reassembly of the tail wheel assembly and the left main landing gear breaking assembly resulting in an inadvertent loss of control during the landing roll. Contributing factors were the pilot's inadvertent swerve…Jan 30, 2005 · N53719 · Substantial damageNTSB LAX05CA081Accident · No injuriesData collectionFinal reportCessna 182P · Reno, NVthe pilot's misjudged flare, which resulted in a stall and a hard landing.Jan 30, 2005 · N9003M · Substantial damageNTSB CHI05FA059Accident · No injuriesField investigationFinal reportLearjet 35A · Kansas City, MOThe contaminated runway conditions during landing. Contributing factors were the operation of the airplane without thrust reversers, flight to the planned alternate airport not performed by the flightcrew, and the insufficient runway information. Additional…Jan 29, 2005 · N911AE · Substantial damageNTSB LAX05CA078Accident · No injuriesData collectionFinal reportRobinson R22 · Chandler, AZthe certified flight instructor's inadequate use of the antitorque control pedals while adding throttle, which led to a loss of directional control.Jan 28, 2005 · N7535Z · Substantial damageNTSB DFW05CA062Accident · No injuriesData collectionFinal reportCessna 310-J · Crosbyton, TXThe pilot's failure to maintain aircraft control, and his inadequate flare which resulted in a hard landing. A contributing factor was the pilot's diverted attention to the open cabin door.Jan 28, 2005 · N3138L · Substantial damageNTSB ANC05LA025Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Toksook Bay, AKThe pilot's inadequate compensation for the gusty crosswind wind condition, which resulted in a loss of control during the landing roll, and the collapse of the nose landing gear. Factors associated with the accident were the crosswind and wind gusts.Jan 27, 2005 · N201EH · Substantial damageNTSB CHI05CA058Accident · No injuriesData collectionFinal reportCessna 172F · Willmar, MNThe student pilot's failure to properly compensate for the crosswind conditions and his failure to maintain directional control during the landing rollout. Contributing factors were the crosswind and the snow bank.Jan 26, 2005 · N8205U · Substantial damageNTSB MIA05CA054Accident · No injuriesData collectionFinal reportCessna 182S · Punta Gorda, FLThe pilot's improper flare resulting in a hard landing and subsequent damage to the firewall.Jan 25, 2005 · N182CR · Substantial damageNTSB SEA05LA039Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Lewiston, IDThe pilot's failure to maintain directional control during the landing roll. Wind gusts and the pilot's inadequate compensation for wind conditions were factors.Jan 21, 2005 · N1535A · Substantial damageNTSB MIA05CA053Accident · No injuriesData collectionFinal reportLee Harold Swarthout Velocity Xlrg · Daytona Beach, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll resulting in the on-ground collision with a fence and a ditch.Jan 21, 2005 · N121HS · Substantial damageNTSB DEN05CA050Accident · No injuriesData collectionFinal reportGrumman G-1159 · Logan, UTthe pilot's improper IFR operation by which he failed to comply to the missed approach procedure, and his improper evaluation of the weather resulting in an encounter with fog and his loss of visual contact with the runway during the landing.Jan 20, 2005 · N74RQ · Substantial damageNTSB DFW05LA066Accident · No injuriesLimited investigationFinal reportBell 206B · Pinehurst, TXThe flight instructor's delay in taking remedial action, which resulted in a hard landing.Jan 19, 2005 · N8040T · Substantial damageNTSB DFW05CA057Accident · No injuriesData collectionFinal reportCessna 182J · Malvern, ARThe pilot's failure to maintain directional control during the landing roll. A contributing factor was the sun glare.Jan 19, 2005 · N2855F · Substantial damageNTSB CHI05CA057Accident · No injuriesData collectionFinal reportCessna 421C · Muncie, INThe inadequate flare and the directional control not maintained/obtained by the pilot. Contributing factors were the instrument meteorological conditions, the icing conditions, the limited visibility afforded by the windshield antiice/deice system, and the…Jan 19, 2005 · N421HG · Substantial damageNTSB ANC05TA022Accident · No injuriesFinal reportCessna 185 · Eek, AKThe pilot's inadequate evaluation of weather conditions, which resulted in an on ground encounter with terrain during the landing roll. Factors associated with the accident were a tailwind, and snow-covered, icy terrain conditions.Jan 19, 2005 · N9452N · Substantial damageNTSB MIA05CA051Accident · No injuriesData collectionFinal reportRobinson R22 · Gulf Port, MSThe student pilot's inadequate flare and his failure to maintain rotor rpm which resulted in a hard landing. Also causal was the instructor's inadequate supervision of the flight.Jan 18, 2005 · N26498 · Substantial damageNTSB LAX05CA071Accident · No injuriesData collectionFinal reportRobinson R22B · Rialto, CAthe student pilot's improper use of the cyclic control during a practice autorotation, and the inadequate supervision by the certified flight instructor.Jan 16, 2005 · N1122R · Substantial damageNTSB LAX05LA069Accident · 1 fatalLimited investigationFinal reportSlipStream Revelation · Camarillo, CAthe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall/spin.Jan 15, 2005 · UNREG · Substantial damageNTSB SEA05LA036Accident · No injuriesLimited investigationFinal reportCessna U206F · Prevost, WAThe pilot not identifying unsafe landing conditions, and his subsequent intentional swerve during the landing roll resulting in impacting a ditch. Contributing factors were the ice/frost on the grass/dirt one-way runway (1,560 feet in length), the unexpected…Jan 14, 2005 · N8313Q · Substantial damageNTSB CHI05CA054Accident · No injuriesData collectionFinal reportCessna 152 · Stockton, MOthe pilot's failure to attain the proper touchdown point, which resulted in an overrun. Contributing factors were the tailwind and dusk light conditions.Jan 13, 2005 · N714UV · Substantial damageNTSB MIA05LA049Accident · No injuriesLimited investigationFinal reportBeech B300 · Jacksonville, FLThe pilot's failure to perform a missed approach after losing sight of the runway and the misjudgment of distance on the runway which resulted in an overrun. A contributing factor was the fog.Jan 12, 2005 · N350CS · Substantial damageNTSB CHI05FA053Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Eureka Springs, ARThe pilot misjudged his distance/speed which resulted in the overrun and subsequent impact with trees. The wet turf runway and the trees were factors in the accident.Jan 12, 2005 · N500KW · DestroyedNTSB SEA05CA033Accident · No injuriesData collectionFinal reportCessna 180 · Billings, MTThe pilot's improper flare and his failure to maintain aircraft control. The pilot's improper recovery from a bounced landing is a contributing factor.Jan 10, 2005 · N8609X · Substantial damageNTSB NYC05LA056Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Millville, NJThe flight instructor's failure to lower the landing gear during landing.Jan 10, 2005 · N7547Y · Substantial damageNTSB DFW05CA050Accident · No injuriesData collectionFinal reportReinhart GP-4 · Fort Worth, TXThe pilot's failure to compensate for the prevailing crosswind. A contributing factor was the crosswind.Jan 9, 2005 · N233CR · Substantial damageNTSB LAX05LA063Accident · No injuriesLimited investigationFinal reportCessna 340 · Carefree, AZthe pilot's improper use of the throttles during an aborted landing attempt that resulted in an engine over-boost condition requiring a reduction in power that then resulted in a runway overrun and collision with a ditch.Jan 8, 2005 · N340CS · Substantial damageNTSB LAX05CA067Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.Jan 8, 2005 · N8351W · Substantial damageNTSB LAX05CA066Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.Jan 8, 2005 · N151MM · Substantial damageNTSB DEN05IA049Incident · No injuriesIncident investigationFinal reportGulfstream American G-1159A · Englewood, COthe flight crew's misidentification of the parallel taxiway as an active runway, resulting in the flight crew executing a landing on the taxiway. Contributing factors include the airport's inadequate snow removal, the snow-covered runway, the visual illusions…Jan 6, 2005 · N111FA · No damageNTSB NYC05LA044Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Cleveland, OHThe pilot's failure to maintain directional control during landing, which resulted in an impact with a sign.Jan 4, 2005 · N17HF · Substantial damageNTSB MIA05CA048Accident · No injuriesData collectionFinal reportCessna 172SP · Clewiston, FLThe pilot's failure to maintain directional control during landing rollout which resulted in the airplane veering off the runway and colliding into an airport sign.Jan 4, 2005 · N365SP · Substantial damageNTSB SEA05CA035Accident · No injuriesData collectionFinal reportCessna 310J · Davenport, WAThe pilot's failure to maintain adequate airspeed during landing with airframe ice, which resulted in an inadvertent stall and hard landing. Factors were the icing conditions and the airframe ice.Jan 3, 2005 · N310RA · Substantial damageNTSB LAX05CA059Accident · No injuriesData collectionFinal reportCessna 441 · Thermal, CAthe pilot's misjudged speed and distance, which resulted in a failure to attain the proper touchdown point and a subsequent overrun of the runway. A factor in the accident was limited braking effectiveness resulting from the wet runway condition.Jan 3, 2005 · N441CX · Substantial damageNTSB LAX05FA058Accident · Minor injuriesField investigationFinal reportPiper PA-46-350P · Palo Alto, CAthe pilot's misjudged distance and speed on final approach, which led to a long landing and a runway overrun. Also causal was the pilot's inadequate in-flight decision to continue flight with indications of apparent serious system anomalies, failure to divert…Jan 2, 2005 · N4165P · Substantial damage