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 CHI02LA173Accident · No injuriesLimited investigationFinal reportBeech BE90 · Roseau, MNAn inadvertent collision with a deer during the landing roll.Jun 27, 2002 · N911ND · Substantial damageNTSB ATL02LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Picayune, MSThe pilot's misjudged the touch down point on the runway and collided with the ground short of the runway.Jun 27, 2002 · N6708W · Substantial damageNTSB SEA02LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Donnelly, IDThe pilot's failure to arrest an excessive descent rate during an attempted landing, and his inadequate recovery from a bounced landing. Factors include a high density altitude , and trees near the runway.Jun 26, 2002 · N42505 · DestroyedNTSB NYC02TA123Accident · No injuriesFinal reportHughes 369D · Jeffersontown, KYThe flight instructor's loss of lateral control when his foot slipped off the rudder pedal during a power-off, running landing.Jun 26, 2002 · N40AP · Substantial damageNTSB ANC02LA063Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Kotzebue, AKThe pilot's excessive braking action while landing on a sandbar, which resulted in a nose over.Jun 26, 2002 · N62136 · Substantial damageNTSB SEA02TA110Accident · No injuriesFinal reportBell 206B · Rainier, WAThe pilot's failure to maintain aircraft control while trying to land. Rough/uneven terrain, inaccurate performance data calculations, inadequate in-flight planning and lack of familiarity with the geographic area were factors.Jun 25, 2002 · N1087L · Substantial damageNTSB DEN02LA059Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Deming, NMThe loss of aircraft directional control during the landing roll as a result of encountering a dust devil.Jun 24, 2002 · N9471H · Substantial damageNTSB DEN02LA058Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Giddings, TXthe failure of the pilot to maintain aircraft control during the landing rollout. A contributing factor was the subsequent inadvertent ground loop of the airplane.Jun 24, 2002 · N83DH · Substantial damageNTSB ANC02LA060Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Nikiski, AKThe pilot's excessive rate of descent resulting in a hard landing on water.Jun 24, 2002 · N211AW · Substantial damageNTSB SEA02LA105Accident · No injuriesLimited investigationFinal reportCessna 180K · Idaho Falls, IDThe pilot's inadequate compensation for wind conditions during the landing roll. A crosswind was a factor.Jun 23, 2002 · N2801K · Substantial damageNTSB SEA02FA109Accident · 2 fatalField investigationFinal reportBeech A35 · Atlanta, IDClearance from an object was not maintained during an aborted landing. Trees and mountainous terrain were factors.Jun 22, 2002 · N658B · Substantial damageNTSB NYC02LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Lynchburg, VAThe pilot's failure to maintain control of the airplane, a factor was the tailwind.Jun 22, 2002 · N5408E · Substantial damageNTSB ANC02LA056Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Chugiak, AKThe pilot's excessive braking, which resulted in a noseover during landing. Factors associated with the accident were the pilot's improper touchdown point, and landing with a tailwind.Jun 22, 2002 · N9378H · Substantial damageNTSB FTW02LA188Accident · No injuriesLimited investigationFinal reportCessna 182Q · Midland, TXThe pilot's hard landing as a result of her improper landing flare. Factors were the prevailing dark night conditions and the student pilot's lack of total experience in night operations.Jun 21, 2002 · N5327N · Substantial damageNTSB NYC02LA119Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Hagerstown, MDThe pilot's failure to perform a go-around and obtain the proper touchdown point, which resulted in an overrun. A factor in the accident was the crosswind condition.Jun 20, 2002 · N3282F · Substantial damageNTSB MIA02LA114Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Carrollton, GAthe pilot's inadequate compensation for wind and his failure to maintain aircraft control.Jun 20, 2002 · N4258Y · Substantial damageNTSB SEA02FA106Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics LA-4-200 · Puyallup, WAFailure to maintain aircraft control during a go-around. Trees were a factor in the accident.Jun 19, 2002 · CGHIT · Substantial damageNTSB DEN02LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Telluride, COthe pilot not maintaining proper aircraft control resulting in a hard landing. Factors contributing to this accident were the high airspeed, the porpoise encountered during the landing, and the pilot's delayed remedial action resulting in the damage to the…Jun 19, 2002 · N9089H · Substantial damageNTSB CHI02LA171Accident · No injuriesLimited investigationFinal reportHulle Horizon 1 · Niles, MIThe pilot's improper recovery from a bounced landing. A factor was the pilot's lack of experience in tailwheel airplanes.Jun 19, 2002 · N816DJ · Substantial damageNTSB ATL02LA126Accident · No injuriesLimited investigationFinal reportCessna 180 · Jacksonville, FLThe pilot's failure to maintain directional control on landing rollout resulting in an inadvertent ground loop. A factor related to the accident was the certified flight instructors inadequate supervision of the training flight.Jun 19, 2002 · N9150C · Substantial damageNTSB ANC02LA055Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane. A factor associated with the accident is a ditch adjacent to the runway.Jun 19, 2002 · N1858A · Substantial damageNTSB IAD02LA060Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Chesterfield, VApilot's improper flare, which resulted in a hard landing at night.Jun 18, 2002 · N2182C · Substantial damageNTSB NYC02IA118Incident · No injuriesIncident investigationFinal reportLearjet 35A · Oxford, CTThe flight instructor's inadequate supervision of the commercial pilot during a touch and go landing, including his failure to properly brief the commercial to not use reverse thrust during a touch and go landing.Jun 17, 2002 · N989AL · Minor damageNTSB FTW02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Pecos, TXThe pilot misjudged the landing flare resulting in a hard landing. A contributing factor was the dark night conditions.Jun 17, 2002 · N675MP · Substantial damageNTSB CHI02LA170Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-82 · Kansas City, MOThe inadequate flare by the flying pilot and the remedial action not performed by the company check airman.Jun 17, 2002 · N140NJ · Substantial damageNTSB CHI02LA169Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 90A · Mukwonago, WIThe inadequate weather evaluation by the pilot and high winds.Jun 17, 2002 · N40051 · No damageNTSB ANC02LA052Accident · No injuriesLimited investigationFinal reportGrumman G-21 · Northway, AKThe pilot's inadequate compensation for wind conditions during the landing roll, which resulted in an inadvertent ground loop/swerve. A factor associated with the accident was a crosswind.Jun 17, 2002 · N21A · Substantial damageNTSB FTW02LA184Accident · No injuriesLimited investigationFinal reportCessna P210N · Shreveport, LAthe collapse of the right main landing gear for undetermined reasons.Jun 16, 2002 · N4720P · Substantial damageNTSB LAX02LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Saint Johns, AZthe pilot's inadequate compensation for wind conditions resulting in a loss of directional control and collision with terrain. Related factors were the wind gusts, crosswind and soft terrain.Jun 15, 2002 · N64307 · Substantial damageNTSB FTW02LA178Accident · No injuriesLimited investigationFinal reportCessna 172M · Kirbyville, TXthe pilot's failure to attain the proper touchdown point. A contributing factor was the loose gravel.Jun 15, 2002 · N21799 · Substantial damageNTSB CHI02LA178Accident · No injuriesLimited investigationFinal reportCessna 182Q · Vermillion, SDThe pilot's improper flare.Jun 15, 2002 · N4833N · Substantial damageNTSB ANC02LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's inadequate compensation for wind conditions, and the excessive use of the airplane's brakes, which resulted in a nose over. A contributing factor to the accident was a wind gust.Jun 15, 2002 · N4131M · Substantial damageNTSB SEA02LA100Accident · No injuriesLimited investigationFinal reportCessna 152 · Hillsboro, ORAn improper flare during the landing. Not performing a proper recovery from a bounced landing was a factor.Jun 14, 2002 · N757FY · Substantial damageNTSB DEN02LA054Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glenwood Sprngs, COthe pilot's failure to maintain clearance from a tree while conducting an aborted landing. Contributing factors were the pilot’s low approach airspeed, and his failure to maintain directional control during landing roll.Jun 14, 2002 · N333AJ · Substantial damageNTSB CHI02LA164Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · St. Joseph, MOThe pilot's failure to attain proper alignment with the runway.Jun 14, 2002 · N2532N · Substantial damageNTSB MIA02LA112Accident · No injuriesLimited investigationFinal reportCessna 172S · Kill Devil Hill, NCthe pilot's failure to maintain control of the airplane after an attempted aborted landing, and while braking during the landing roll, which resulted in the airplane departing the end of the runway and impacting with a ditch.Jun 13, 2002 · N793SP · Substantial damageNTSB ANC02LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe student pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in the right wing striking the ground.Jun 13, 2002 · N1888A · Substantial damageNTSB ANC02LA047Accident · No injuriesLimited investigationFinal reportCessna 172 · Bethel, AKThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in the right wing striking the runway.Jun 11, 2002 · N7564G · Substantial damageNTSB ANC02LA046Accident · No injuriesLimited investigationFinal reportCessna 150 · Hope, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch. A contributing factor in the accident was the presence of a ditch in the landing area.Jun 10, 2002 · N8623J · Substantial damageNTSB LAX02LA193Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbia, CAThe pilot encountered a crosswind gust during the landing roll, resulting in a ground loop and nose over.Jun 9, 2002 · N2228C · Substantial damageNTSB IAD02LA058Accident · No injuriesLimited investigationFinal reportNorth American T6G · Salem, OHThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop.Jun 9, 2002 · N60690 · Substantial damageNTSB FTW02LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Sherman, TXThe hard landing as result of the pilot's failure to maintain aircraft control during landing. A contributing factor was the gusty crosswinds.Jun 9, 2002 · N2282Y · Substantial damageNTSB CHI02LA157Accident · No injuriesLimited investigationFinal reportMaule M-7-260C · Fishers, INThe pilot not performing a go-around prior to exceeding the proper touchdown point and the pilot not maintaining altitude/clearance from the trees. Factors to the accident were the pilot's inadequate preflight planning and the trees.Jun 8, 2002 · N63KP · Substantial damageNTSB ANC02TA045Accident · No injuriesFinal reportCessna 185 · Kaktovik, AKThe pilot's inadequate evaluation of the weather conditions during landing at a remote lake, resulting in a downwind landing. Factors contributing to the accident were the presence of a tailwind, and an icy lake surface.Jun 8, 2002 · N749 · Substantial damageNTSB ANC02LA072Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the left wing striking the ground. A factor contributing to the accident was the grass-covered runway surface.Jun 8, 2002 · N2162Z · Substantial damageNTSB LAX02LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Henderson, NVThe student pilot's inadequate recovery from a bounced landing and the instructor's inadequate supervision.Jun 7, 2002 · N49672 · Substantial damageNTSB LAX02LA185Accident · No injuriesLimited investigationFinal reportCessna A185F · Angwin, CAThe pilot's inadequate compensation for the wind conditions resulted in a loss of directional control and a ground loop/swerve.Jun 7, 2002 · N714WH · Substantial damageNTSB DEN02LA056Accident · No injuriesLimited investigationFinal reportBeech A35 · Newcastle, WYthe pilot-in-command's failure to lower the landing gear prior to landing.Jun 7, 2002 · N8735A · Substantial damageNTSB LAX02LA194Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's inadequate recovery from a bounced landing.Jun 6, 2002 · N94986 · Substantial damageNTSB LAX02LA183Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · North Las Vegas, NVThe dual student's improper autorotation and the flight instructor's inadequate supervision.Jun 6, 2002 · N7196W · Substantial damage