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 ATL91LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Hatteras, NCThe pilot's improper landing flare, subsequent inadvertent porpoise, and his failure to execute a bounced landing recovery.Apr 7, 1991 · N62340 · Substantial damageNTSB SEA91LA078Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Kent, WAThe pilot's inadequate remedial action to correct the imminent dynamic rollover. Factors to the accident were: the pilot's poorly planned approach and lack of totoal flight experience.Apr 6, 1991 · N24176 · Substantial damageNTSB NYC91LA116Accident · No injuriesLimited investigationFinal reportPiper 180 · Andes, NYThe failure of the pilot to maintain directional control during a landing with unfavorable winds.Apr 6, 1991 · N9006J · Substantial damageNTSB NYC91LA106Accident · No injuriesLimited investigationFinal reportCessna 172P · Burlington, CTThe failure of the pilot to maintain directional control during the landing. Factors related to the accident were: improper use of the flight controls by the pilot, his lack of recent experience and total time, and the crosswind.Apr 6, 1991 · N64182 · Substantial damageNTSB LAX91LA167Accident · No injuriesLimited investigationFinal reportCessna 414A · Avenal, CAThe failure of the pilot to maintain directional control after striking a dirt berm during the landing roll. Contributing to the accident was the failure of the pilot to ensure that the airport was adequate for his intended operations.Apr 6, 1991 · N242AR · Substantial damageNTSB SEA91LA080Accident · No injuriesLimited investigationFinal reportCessna 172A · Hood River, ORAn inadequately planned approach which resulted in a hard landing. Factors to the accident were rough water landing conditions, poor supervision by the CFI, and the overload condition to the float assembly.Apr 5, 1991 · N9852T · Substantial damageNTSB MIA91IA117Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110P1 · Ochopee, FLFailure of the student to use the checklist, inadequate supervision by the pic/cfi, and inadequate supervision by the FAA principle operations inspector.Apr 5, 1991 · N102TN · Minor damageNTSB CHI91LA130Accident · No injuriesLimited investigationFinal reportBeech 58 · Wichita, KSRemedial action was delayed by the instructor pilot. A factor related to the accident was an excessive rate of descent.Apr 5, 1991 · N58SE · Substantial damageNTSB ANC91LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's lack of currency with the type of landing gear involved.Apr 5, 1991 · N123TL · Substantial damageNTSB NYC91LA101Accident · No injuriesLimited investigationFinal reportBeech 56TC · New Haven, CTFailure of the pilot to maintain directional control after the nose wheel steering system failed.Apr 4, 1991 · N7QG · Substantial damageNTSB LAX91LA146Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Camarillo, CAThe failure of the pilot to maintain directional control of the helicopter and apply proper remedial action. Contributing to the accident was the improper selection of the touchdown point and the disregarding of company procedures.Apr 3, 1991 · N9068T · Substantial damageNTSB FTW91LA059Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Decatur, TXThe instructor's inadequate supervision and the student's failure to relinguish controls.Apr 3, 1991 · N2204J · Substantial damageNTSB ATL91LA076Accident · No injuriesLimited investigationFinal reportDavid Lowe ULTRA-PUP · Waycross, GAThe failure of the airplane battery, which prohibited the complete extension of the landing gear, resulting in a landing with the nose gear retracted. A factor in the accident was the soft terrain at the selected landing area.Apr 3, 1991 · N71427 · Substantial damageNTSB ANC91LA045Accident · No injuriesLimited investigationFinal reportStinson 108 · Fort Greely, AKUnsuitable terrain selected by the pilot for a precautionary landing.Apr 2, 1991 · N464C · Substantial damageNTSB SEA91LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Ogden, UTThe pilot's poorly planned approached for landing. Factors to the accident were: an excessive airspeed, and the inadequacy of the pilot's recovery from a bounced landing.Mar 31, 1991 · N6852H · Substantial damageNTSB SEA91LA077Accident · No injuriesLimited investigationFinal reportBell BH-47G2A · Waitsburg, WAThe improper installation of the main rotor mast nut and lock washer by maintenance personnel which resulted in the separation of the main rotor system.Mar 31, 1991 · N38926 · Substantial damageNTSB LAX91LA153Accident · No injuriesLimited investigationFinal reportPiper J3 · Arbuckle, CAThat the pilot used excessive brakes during the landing roll-out.Mar 31, 1991 · N42257 · Substantial damageNTSB LAX91LA152Accident · No injuriesLimited investigationFinal reportHughes 269C · Honolulu, HIThe instructor's improperly planned approach. A factor was the pilot's failure to observe performance data for the helicopter.Mar 30, 1991 · N8656F · DestroyedNTSB DEN91LA057Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Fort Collins, COThe loss of directional control by the pilot in command.Mar 30, 1991 · N8543D · Substantial damageNTSB CHI91LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Burwell, NEDirectional control not maintained by the pilot. Factors related to the accident were a gusty crosswind and lack of recent experience by the pilot.Mar 30, 1991 · N2071R · Substantial damageNTSB ANC91LA041Accident · No injuriesLimited investigationFinal reportBell 47 · Thompson Pass, AKThe pilot's failure to maintain aircraft control and improper flare during landing.Mar 30, 1991 · N73279 · Substantial damageNTSB MIA91LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · New Port Richey, FLIn-flight encounter with wind gusts while flaring to land and failure of the pilot to maintain directional control and failure to perform a goaround.Mar 29, 1991 · N7454J · Substantial damageNTSB ANC91LA040Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Kasigluk, AKThe pilot's failure to maintain directional control of the airplane on landing. Contributing to the accident was the snowbank.Mar 28, 1991 · N76RL · Substantial damageNTSB SEA91LA070Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Everett, WAThe pilot did not maintain control of the airplane during the landing roll. Factors tot he accient were the pilot inadequately planned the approach, and uncontrolled ground-loop, and the pilot's lack of total experience in this type of aircraft.Mar 27, 1991 · N371RF · Substantial damageNTSB CHI91LA117Accident · No injuriesLimited investigationFinal reportCessna 172 · Yankton, SDFailure of the pilot to maintain directional control of the aircraft during landing. The adverse wind condition and the pilot's lack of total experience were related factors.Mar 27, 1991 · N1743V · Substantial damageNTSB BFO91LA036Accident · No injuriesLimited investigationFinal reportHughes 369HS · Columbia, MDThe pilot's inadequate visual lookout, which resulted in his failure to see-and-avoid the obstruction (fence post).Mar 27, 1991 · N5FC · Substantial damageNTSB ANC91IA046Incident · No injuriesIncident investigationFinal reportNihon YS-11A-600 · Anchorage, AKA jammed nose gear due to incorrect installation of the shear pin. Contributing to the accident was the insufficiently defined maintenance procedure.Mar 27, 1991 · N173RV · Minor damageNTSB FTW91LA057Accident · No injuriesLimited investigationFinal reportCessna 195B · Mc Kinney, TXThe pilot's landing short of the threshold and loss of directional control.Mar 24, 1991 · N841DP · Substantial damageNTSB DEN91LA054Accident · No injuriesLimited investigationFinal reportBeech H35 · Greeley, COThe pilot's inadvertent activation of the landing gear switch causing the landing gear to collapse while the aircraft was still on the landing roll.Mar 24, 1991 · N5463D · Substantial damageNTSB CHI91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Grand Marais, MNFailure of the pilot to maintain directional control. The crosswind and snow covered runway were related factors.Mar 24, 1991 · N7010K · Substantial damageNTSB CHI91LA113Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Augusta, KSAn improper autorotation was performed by the dual student and remedial action was delayed by the CFI. Factors related to the accident were: inadequate airspeed and rotor RPM.Mar 24, 1991 · N2503A · Substantial damageNTSB MIA91LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Clewiston, FLMisjudged wind direction resulting in incorrect runway selection and failure by the PIC to initiate a go-around after landing with a tailwind. Contributing to the accident was the lack of the pilot's total experience.Mar 23, 1991 · N739BW · Substantial damageNTSB LAX91LA142Accident · No injuriesLimited investigationFinal reportCessna 421 · El Monte, CAThe pilot retracting the landing gear during the landing roll.Mar 23, 1991 · N4071L · Substantial damageNTSB CHI91LA119Accident · No injuriesLimited investigationFinal reportCessna 182P · Loup City, NEThe pilot's improper landing/touchdown. A related factor was the pilot's lack of total flight experience.Mar 21, 1991 · N91376 · Substantial damageNTSB CHI91LA114Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Burlington, IADelayed initiation of remedial action by the flight instructor. Factors related to the accident are gusty crosswinds, inadequate compensation for wind conditions and not maintaining airspeed by the student pilot, and complacency by the instructor.Mar 21, 1991 · N26009 · Substantial damageNTSB MIA91LA104Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · La Belle, FLFailure of the student pilot to maintain directional control during the landing roll. Contributing to the accident was the fact that the pilot diverted his attention when he pulled the parking brake handle to apply the brakes.Mar 20, 1991 · N25459 · Substantial damageNTSB FTW91LA052Accident · Minor injuriesLimited investigationFinal reportMonocoupe D145 · Lafayette, LAThe pilot's failure to maintain directional control of the airplane.Mar 19, 1991 · N17687 · Substantial damageNTSB NYC91LA091Accident · No injuriesLimited investigationFinal reportCessna 172M · Leroy, NYThe hard landing made by the pilot. Factors relating to the accident were the decision of the pilot to land on the runway despite the runway lighting system being partially inoperative, and the lack of experience of the pilot at night.Mar 18, 1991 · N20360 · Substantial damageNTSB DEN91LA052Accident · No injuriesLimited investigationFinal reportCessna 177RG · Colorado Spring, COThe pilot's failure to maintain directional control of the aircraft. The gusty/quartering crosswind was a related factor.Mar 18, 1991 · N1950Q · Substantial damageNTSB ANC91IA037Incident · No injuriesIncident investigationFinal reportBeech C-45H · Shageluk, AKThe accident was the pic's failure to properly determine the required width of runway needed by their airplane and inadequate snow removal. Contributing to the accident was the snow berm and the copilot's misjudgment of runway width.Mar 18, 1991 · N400WA · Minor damageNTSB CHI91LA110Accident · No injuriesLimited investigationFinal reportBoeing A75 · North Platte, NEDirectional control was not maintained by the pilot resulting in a swerve and ground loop. A factor related to the accident was lack of total experience in type of aircraft by the pilot.Mar 17, 1991 · N4968V · Substantial damageNTSB LAX91LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Eloy, AZThe student pilot's improper recovery from a bounced landing and the inadvertent entry into a porpoise condition.Mar 15, 1991 · N5496B · Substantial damageNTSB FTW91LA051Accident · No injuriesLimited investigationFinal reportBeech A36 · Lubbock, TXThe pilot's inadequate compensation for the crosswind. A factor was the crosswind.Mar 15, 1991 · N36DB · Substantial damageNTSB CHI91LA118Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Flushing, MIThe pilot's failure to attain proper runway alignment and not maintaining directional control which resulted in a ground loop. Factors relating to this accident were the gusty crosswind conditions which existed at the time.Mar 14, 1991 · N1406K · Substantial damageNTSB MIA91LA097Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hattiesburg, MSOn ground encounter with a wind gust and failure of the pilot to maintain directional control of the airplane during the landing roll, resulting in the collision with a ravineMar 13, 1991 · N735MK · Substantial damageNTSB NYC91LA088Accident · No injuriesLimited investigationFinal reportPiper PA28-400 · Fall River, MAAn improper flare and touchdown point which resulted in an overrun of the runway during the landing roll.Mar 12, 1991 · N8452P · Substantial damageNTSB NYC91LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Caldwell, NJImproper flare by the pilot. Darkness was a related factor.Mar 12, 1991 · N69095 · Substantial damageNTSB SEA91LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Seattle, WAA hard landing due to the pilot's midjudgement of his touchdown.Mar 9, 1991 · N64599 · Substantial damageNTSB SEA91LA063Accident · No injuriesLimited investigationFinal reportCessna 120 · Skykomish, WAThe pilot's failure to take appropriate remedial action after landing too FAR down the runway.Mar 9, 1991 · N3163N · Substantial damageNTSB NYC91LA085Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Miamisburg, OHThe instructor pilot's failure to maintain control of the airplane during landing in a strong crosswind.Mar 9, 1991 · N64937 · Substantial damage