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 BFO91LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Indian Head, MDThe student pilot's failure to maintain adequate aircraft control during the landing flare/touchdown. Contributing factors are his lack of total flight experience and his improper technique when raising flaps during an attempted go-around.Oct 8, 1990 · N6439G · Substantial damageNTSB NYC91LA008Accident · No injuriesLimited investigationFinal reportMaule M5-235C · Moscow, PAA hard landing due to the failure of the pilot to properly arrest his descent rate and the failure of the flight instructor to adequately monitor the actions of the pilot.Oct 7, 1990 · N9266E · Substantial damageNTSB NYC91LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Emlenton, PAThe pilot's failure to maintain adequate airspeed during the landing. The turbulence contributed to the accident.Oct 7, 1990 · N117T · Substantial damageNTSB LAX91LA007Accident · No injuriesLimited investigationFinal reportCessna 182M · Bakersfield, CAThe pilot failed to properly recover from the bounced landing. Contributing to the accident was the pilot's lack of familiarity with the airplane.Oct 7, 1990 · N70892 · Substantial damageNTSB ANC91LA003Accident · No injuriesLimited investigationFinal reportBeech B55B · Eielson Afb, AKThe dual student's inadvertent, premature selection of the landing gear handle to the up position; thereby causing the landing gear system to retract. Contributing to the accident was the instructor's failure to monitor the dual student's action and take…Oct 7, 1990 · N56AF · Substantial damageNTSB ANC91LA002Accident · No injuriesLimited investigationFinal reportCessna 185B · Koyuktolik, AKPilot-in-command's failure to properly execute a stabilized approach to the first 1/3 of the runway. Contributing to the accident was the excessive airpseed maintained during the approach and landing.Oct 7, 1990 · N2525Z · Substantial damageNTSB DEN91LA004Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Englewood, COThe pilot's inadequate preflight inspection.Oct 6, 1990 · N85VL · Substantial damageNTSB BFO91LA001Accident · No injuriesLimited investigationFinal reportBeech B23 · Westminster, MDThe pilot's failure to maintain positive directional control during the landing. Improper crosswind compensation and a variable, gusty crosswind were contributing factors.Oct 6, 1990 · N4005T · Substantial damageNTSB CHI91LA004Accident · No injuriesLimited investigationFinal reportBeech E-18 · Minneapolis, MNFailure of the pilot-in-command to maintain directional control of the aircraft during landing roll.Oct 5, 1990 · N703M · Substantial damageNTSB LAX91LA002Accident · No injuriesLimited investigationFinal reportCessna 152 · Kearny, AZThe pilot executing a left turn at an altitude insufficient to clear a corn field located in close proximity to the departure runway.Oct 4, 1990 · N4594B · Substantial damageNTSB CHI91LA007Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Emporia, KSGusty crosswinds, excessive flap setting, and lack of total experience in type of operation.Oct 4, 1990 · N3226L · Substantial damageNTSB MIA91LA003Accident · No injuriesLimited investigationFinal reportBeech C-90 · Tampa, FLThe lack of lubrication by maintenance personnel of the nose landing gear actuator.Oct 3, 1990 · N7128J · Substantial damageNTSB SEA91LA002Accident · No injuriesLimited investigationFinal reportBeech 58 · Seattle, WAThe pilot did not flare the airplane on landing. Factors related to the accident were: the pilot did not adequately recover from a bounced landing and the nose gear assembly failed in overload.Oct 2, 1990 · N7232K · Substantial damageNTSB DEN91LA001Accident · No injuriesLimited investigationFinal reportRaven S-60A · Harrison, ARThe student pilot's improper inflight planning and inaccurate evaluation of the surface weather. A factor was the unfavorable wind.Oct 1, 1990 · N4264D · Substantial damageNTSB SEA90LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Albany, ORThe pilot's decision to land with a strong tailwind resulted in the collapse of the landing gear.Sep 29, 1990 · N22450 · Substantial damageNTSB CHI90LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Amana, IAProper touchdown point not attained and go-around delayed by the pilot in command. Contributing factors were ATC communications inadequate and wet, grass runway with a tailwind environment plus a fence.Sep 27, 1990 · N21489 · Substantial damageNTSB ATL90LA180Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Fayetteville, TNThe pilot's premature flare which resulted in a loss of directional control at touchdown.Sep 27, 1990 · N16HT · Substantial damageNTSB ANC90FA187Accident · No injuriesField investigationFinal reportPiper PA-18A · Birchwood, AKThe pilot-in-command's failure to correctly analyze the wind and its effect on the airplane during the landing; thereby failing to maintain proper directional control.Sep 27, 1990 · N9279D · Substantial damageNTSB LAX90LA342Accident · No injuriesLimited investigationFinal reportPiper J-3C-115 · Wickenburg, AZThe pilot's failure to maintain directional control.Sep 26, 1990 · N49595 · Substantial damageNTSB CHI90LA274Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob 109A · Waukesha, WIThe pilot's failure to maintain adequate clearance and visual lookout for the moving tractor.Sep 26, 1990 · N912G · Substantial damageNTSB BFO90LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Maryville, KYThe failure of a hydraulic brake line which resulted in a loss of fluid, and an inoperative brake system during landing roll.Sep 26, 1990 · N96839 · Substantial damageNTSB ATL90LA181Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Minturn, SCA previously fractured main wheel which had resulted from a hard landing. A factor in the accident was inadequate inspection by the operator.Sep 26, 1990 · N36303 · Substantial damageNTSB MIA90LA189Accident · No injuriesLimited investigationFinal reportCessna 152 · Cedar Key, FLThe failure of the pilot to execute a go-around after landing long.Sep 25, 1990 · N93286 · Substantial damageNTSB NYC90DEI03Accident · No injuriesFinal reportPiper PA28-180 · Elkhorn Lake, OHThe pilot's improper decision to land on a short, wet grass strip. A contributing factor was the wet grass.Sep 24, 1990 · N7965W · Substantial damageNTSB FTW90LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Arlington, TXThe pilot's failure to properly flare the airplane for landing and his failure to initiate the proper recovery procedures following the bounced landing.Sep 24, 1990 · N66689 · Substantial damageNTSB SEA90LA194Accident · Minor injuriesLimited investigationFinal reportRoger A Hansen KR-2M · Shaniko, ORPilot's failure to maintain clearance from a road sign during landing ground roll. A factor in the accident was the failure of the engine exhaust system which resulted in high engine oil temperature.Sep 23, 1990 · N200RH · Substantial damageNTSB CHI90LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Lakeville, MNThe pilot in command attempting to force the airplane onto the runway.Sep 23, 1990 · N89038 · Substantial damageNTSB CHI90GA273Incident · No injuriesFinal reportPiper PA-3O · Cape Girardeau, MOExcessive play in the landing gear extension linkage. A factor in the incident was unreliability of the gear indicating system.Sep 23, 1990 · N752CF · Minor damageNTSB SEA90LA195Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Enumclaw, WAThe pilot did not maintain directional control of the airplane during the landing roll in gusting wind condition.Sep 22, 1990 · N3189Z · Substantial damageNTSB MIA90LA186Accident · No injuriesLimited investigationFinal reportCessna 421B · Pompano Beach, FLThe failure of the pilot to initiate a go-around due to being high on final approach and as a result, failure to attain the correct point of touchdown and his excessive application of brakes which resulted in failure of the right main tire and loss of…Sep 22, 1990 · N41JT · Substantial damageNTSB LAX90LA334Accident · No injuriesLimited investigationFinal reportCessna 172M · Orovada, NVThe pilot's failure to initiate a go-around. His lack of recent experience in type of operation, (landings), and the inadvertent ground loop were factors in the accident.Sep 22, 1990 · N13686 · Substantial damageNTSB FTW90LA184Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Fort Worth, TXThe pilot in command's failure to maintain directional control. The crosswind was a factor.Sep 22, 1990 · N67631 · Substantial damageNTSB SEA90LA193Accident · No injuriesLimited investigationFinal reportCessna 170 · Havre, MTThe selection of the wrong runway by the owner/student pilot and his failure to compensate for the wind during landing ground roll.Sep 21, 1990 · N4289V · Substantial damageNTSB LAX90LA341Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Cloverdale, CAThe improper procedure employed by the student pilot. Contributing to the accident was failure of the CFI to adequately guard the flight controls to apply timely corrective actions.Sep 21, 1990 · N700TV · Substantial damageNTSB LAX90LA328Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hayward, CAThe failure of the airplane's main landing gear bolt/nut plate attachment assembly. Contributing factors related to the improper installation (threading) of the gear bolt/nut assembly.Sep 21, 1990 · N46326 · Substantial damageNTSB ANC90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Egegik, AKThe improper use of elevator controls by the pilot.Sep 21, 1990 · N33181 · Substantial damageNTSB ANC90LA180Accident · No injuriesLimited investigationFinal reportCessna 185 · Upper Colleen, AKThe pilot-in-command's failure to select suitable terrain for landing. Contributing to the accident was the rough and uneven terrain.Sep 18, 1990 · N70087 · Substantial damageNTSB SEA90LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Enterprise, ORThe pilot's failure to maintain directional control of the aircraft during landing.Sep 17, 1990 · N3117D · Substantial damageNTSB LAX90LA323Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Montague, CAThe pilot's failure to maintain directional control during landing rollout. A contributing factor was the student pilot's lack of experience performing landings.Sep 17, 1990 · N2894P · Substantial damageNTSB SEA90LA185Accident · No injuriesLimited investigationFinal reportCessna 180A · Paisley, ORPilot's selection of unsuitable terrain for a landing site.Sep 16, 1990 · N9669B · Substantial damageNTSB SEA90FA183Accident · 1 fatalField investigationFinal reportCessna 172-P · Hood River, ORThe pilot in command's encountering spatial disorientation and his failure to maintain airspeed.Sep 16, 1990 · N5332K · DestroyedNTSB DEN90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Springdale, ARPilot's loss of control of the aircraft, during landing, due to mechanical malfunction of the tailwheel assembly.Sep 15, 1990 · N86483 · Substantial damageNTSB ATL90LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Americus, GAA low cycle fatigue failure of the left main landing gear spring.Sep 14, 1990 · N7905 · DestroyedNTSB SEA90LA188Accident · No injuriesLimited investigationFinal reportPiper PA34-200T · Jackson, WYThe pilot misjudged the landing flare and landed hard.Sep 13, 1990 · N3981F · Substantial damageNTSB LAX90LA337Accident · No injuriesLimited investigationFinal reportCessna 172 · Fresno, CAThe pilot misjudged the flare altitude and failed to properly recover from a bounced landing.Sep 13, 1990 · N738PF · Substantial damageNTSB FTW90FA179Accident · 1 fatalField investigationFinal reportBeech 58 · Conway, ARThe pilot's failure to attain the proper touchdown point and his delayed decision to abort the landing. Factors were the weather conditions.Sep 12, 1990 · N5641D · DestroyedNTSB SEA90LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Dillon, MTPilot misjudged the flare that resulted in a bounced landing.Sep 11, 1990 · N5345D · Substantial damageNTSB DEN90DTE08Accident · No injuriesFinal reportPiper PA-25-235 · Idalia, COThe encounter with an unfavorable wind, a dust devil. A factor was the inability of the pilot to maintain directional control.Sep 11, 1990 · N9571P · Substantial damageNTSB CHI90LA261Accident · No injuriesLimited investigationFinal reportPiper PA-601P · Monroe, MIA fatigue fracture of the torque link on the right landing gear strut scissor assembly.Sep 11, 1990 · N321GB · Substantial damageNTSB SEA90LA177Accident · No injuriesLimited investigationFinal reportCessna 172M · Lewiston, IDThe failure of a nose landing gear fork, which resulted in the pilot's loss of directional control, and a nose-over after an excursion from the runway.Sep 9, 1990 · N9895V · Substantial damage