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 ANC91LA138Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Cube Cove, AKThe encounter with windshear.Aug 31, 1991 · N2738G · Substantial damageNTSB CHI91LA281Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Newark, ILThe pilot's poor inflight planning/decision making. A related factor was: the wet, slippery condition of the grass runway.Aug 30, 1991 · N3704T · Substantial damageNTSB ANC91LA139Accident · No injuriesLimited investigationFinal reportCessna 206 · Kelly River, AKThe pilot's inadequate judgment in deciding to land a tricycle gear airplane on a sandbar.Aug 30, 1991 · N2070K · Substantial damageNTSB ANC91LA137Accident · No injuriesLimited investigationFinal reportCessna 185-F · Cordova, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 29, 1991 · N1296F · Substantial damageNTSB SEA91LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Heber City, UTThe pilot's failure to maintain directional control during landing ground roll. A factor relating to the accident was the crosswind weather conditions.Aug 26, 1991 · N4653C · Substantial damageNTSB ANC91LA159Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Dry Bay, AKThe pilot failed to maintain adequate airspeed and stalled the airplane. Contributing to the accident was the unsuitable terrain on which the pilot chose to land.Aug 26, 1991 · N6644Z · Substantial damageNTSB DEN91LA118Accident · No injuriesLimited investigationFinal reportLet L-13 · Aspen, COThe pilot turning off the runway with excessive speed.Aug 25, 1991 · N2238 · Substantial damageNTSB CHI91LA271Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Saginaw, MIDirectional control was not maintained by the pilot which resulted in a ground loop. A factor related to the accident was a crosswind.Aug 25, 1991 · N7732K · Substantial damageNTSB ANC91LA133Accident · No injuriesLimited investigationFinal reportBeech B-18H · White Mountain, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.Aug 25, 1991 · N228A · Substantial damageNTSB LAX91LA373Accident · No injuriesLimited investigationFinal reportCessna 152 · Montague, CAThe pilot's improper flare and improper go-around procedure. Contributing to the accident was the lack of total pilot experience.Aug 24, 1991 · N757ZJ · Substantial damageNTSB LAX91LA372Accident · No injuriesLimited investigationFinal reportCessna 182 · Columbia, CAThe pilot of the aircraft experienced a bounced landing on his initial landing attempt. He executed a go-around and landed without incident on the second attempt. Substantial damage to the firewall was discovered afterwards. The pilot believes the bounced…Aug 24, 1991 · N7589S · Substantial damageNTSB FTW91LA156Accident · No injuriesLimited investigationFinal reportCessna 150J · Tomball, TXAn improper recovery from a bounced landing.Aug 24, 1991 · N60544 · Substantial damageNTSB FTW91LA154Accident · No injuriesLimited investigationFinal reportBell L4 Experimental · Arlington, TXThe pilot's failure to maintain adequate rotor RPM during the planned autorotation and his improper touchdown.Aug 24, 1991 · N2770X · Substantial damageNTSB FTW91LA152Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ward, ARThe pilot's failure to maintain directional control.Aug 23, 1991 · N2559N · Substantial damageNTSB MIA91LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Marianna, FLThe student pilot's failure to maintain proper airspeed during landing and failure to execute a go-around in a timely manner.Aug 21, 1991 · N757TM · Substantial damageNTSB CHI91LA268Accident · No injuriesLimited investigationFinal reportCessna 150 · St. Clair, MODirectional control was not maintained by the pilot.Aug 21, 1991 · N6326G · Substantial damageNTSB FTW91LA148Accident · No injuriesLimited investigationFinal reportBeech B19 · Poteau, OKThe improper flare technique utilitzed by the pilot under instruction. A factor was the failure of the check pilot to intervene.Aug 20, 1991 · N9741L · DestroyedNTSB ANC91LA129Accident · No injuriesLimited investigationFinal reportCessna 172 · Montague Island, AKThe pilot's failure to maintain control of the airplane during the landing roll. A factor was the unsuitable terrain selected for landing by the pilot, which was loose gravel, rough and uneven.Aug 19, 1991 · N7966B · Substantial damageNTSB FTW91LA150Accident · No injuriesLimited investigationFinal reportHughes 269A-1 · No. Little Rock, ARThe pilot's failure to maintain main rotor RPM, his delayed flare, and the improper touchdown.Aug 18, 1991 · N65372 · Substantial damageNTSB SEA91LA214Accident · No injuriesLimited investigationFinal reportBeech 58TC · Kalispell, MTThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to identtify a down and locked landing gear condition prior to touchdown.Aug 17, 1991 · N350TH · Substantial damageNTSB NYC91LA214Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Montauk, NYThe pilot made a hard landing, resulting in the main landing gear collapsing. Contributing to the accident was the pilot's interpretation of the wind conditions, misjudgment of the flare causing the airplane to balloon and stall.Aug 17, 1991 · N4368W · Substantial damageNTSB DEN91LA115Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Parker, COPhysical impairment of the pilot in command for unknown reasons.Aug 17, 1991 · N2253K · Substantial damageNTSB NYC91LA210Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Sandusky, OHThe pilot initiated an emergency landing when the engine RPM went to zero due to a broken tachometer cable. He did not attain the proper touchdown point and overran the end of the runway.Aug 16, 1991 · N64834 · Substantial damageNTSB ATL91LA163Accident · No injuriesLimited investigationFinal reportBell 47D1 · Winton, NCThe pilot's selection of unsuitable terrain for landing the helicopter.Aug 16, 1991 · N1MH · Substantial damageNTSB CHI91LA263Accident · No injuriesLimited investigationFinal reportBeech 36 · Davenport, IAThe inadequate visual lookout and poor inflight planning and decision making by the pilot of N97867. Factors in the accident are inoperative exterior lights and radio communication not possible.Aug 15, 1991 · N25496 · 2 aircraft · Substantial damageNTSB CHI91FA264Accident · 2 fatalField investigationFinal reportCessna 182Q · Jerseyville, ILFailure of the pilot to follow proper procedures during a go-around maneuver, and his failure to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the pilot's improper use of the flaps, his improper use…Aug 15, 1991 · N735XG · DestroyedNTSB CHI91DCA02Accident · Minor injuriesFinal reportManville Avid Flyer · Mexico, MOFailure of the pilot to maintain directional control during a landing roll. A factor associated with the accident is the pilot's lack of familiarity with the accident airplane.Aug 13, 1991 · N714J · Substantial damageNTSB LAX91LA354Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Monterey, CAThe failure of the pilot to maintain directional control of the aircraft during the landing roll.Aug 11, 1991 · N31279 · Substantial damageNTSB CHI91LA262Accident · No injuriesLimited investigationFinal reportCessna 310 · Plattsmouth, NEImproper maintenance by the owner/pilot. A factor related to the accident was the built-up of corrosion on he landing gear retraction system.Aug 10, 1991 · N4827B · Substantial damageNTSB ANC91LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe pilot's failure to maintain adequate airspeed, resulting in a stall, hard landing and collapse of the main landing gear.Aug 10, 1991 · N180AT · Substantial damageNTSB CHI91LA252Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Mount Pleasant, MIDirectional control was not maintained by the pilot. Factors related to the accident were a wet, grass runway and buildings adjacent the runway.Aug 7, 1991 · N4189Q · Substantial damageNTSB ANC91LA116Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Gulkana, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the unsuitable terrain selected by the pilot for landing which was rough, uneven and soft.Aug 7, 1991 · N6058D · Substantial damageNTSB NYC91LA204Accident · No injuriesLimited investigationFinal reportCessna 150J · Burgettstown, PAThe pilot-in-command's failure to maintain control of the airplane on the landing roll, resulting in an on ground collision with a tree. Factors related to the accident was the pilot's improper use of the brake system.Aug 6, 1991 · N60689 · Substantial damageNTSB CHI91LA255Accident · No injuriesLimited investigationFinal reportCessna 180 · Walker, MNDirectional control after landing was not maintained by the pilot. Factors related to the accident were a gusty crosswind and a downhill embankment (ditch).Aug 6, 1991 · N1637C · Substantial damageNTSB LAX91LA368Accident · No injuriesLimited investigationFinal reportCessna C-T210N · Modesto, CAThe pilot's failure to maintain the proper alignment over the runway. Factors which contributed to the accident were the pilot's inattentive handling of his aircraft, and the dark, nighttime condition.Aug 4, 1991 · N5092Y · Substantial damageNTSB NYC91LA202Accident · No injuriesLimited investigationFinal reportCessna 152 · Brookville, OHThe pilot's improper use of the flight controls resulting in loss of directional control and an inadvertent stall.Aug 3, 1991 · N8144L · Substantial damageNTSB NYC91LA198Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Atlantic City, NJThe failure of the pilot of N6877M to insure the runway was clear prior to pulling onto the runway.Aug 3, 1991 · N2237M · 2 aircraft · Substantial damageNTSB DEN91LA109Accident · No injuriesLimited investigationFinal reportBeech V35 · Byers, COThe pilot's selection of an unsuitable landing site. Factors were: weather conditions and the ditch.Aug 3, 1991 · N2751T · Substantial damageNTSB SEA91LA199Accident · No injuriesLimited investigationFinal reportCessna C-152 · W. Yellowstone, MTThe failure by the pilot to calculate aircraft fuel comsumption and the pilot's poor inflight planning. Factors relating to the accident were the inadequate preflight planning by the pilot, his lack of qualification and experience, and his disorientation…Aug 2, 1991 · N757PR · Substantial damageNTSB CHI91LA253Accident · No injuriesLimited investigationFinal reportCessna 180 · Eveleth, MNThe pilot's failure to maintain the proper descent rate and adequate airspeed during the approach. A factor related to the accident is the lack of recent total experience.Aug 2, 1991 · N9377T · Substantial damageNTSB CHI91LA249Accident · No injuriesLimited investigationFinal reportCessna 172 · Wheeling, ILInadequate compensation for wind conditions and directional control was not maintained by the pilot. Factors related to the accident were a gusty crosswind landing environment and a ditch.Aug 2, 1991 · N97650 · Substantial damageNTSB BFO91FA072Accident · 1 fatalField investigationFinal reportCessna 210N · Petersburg, VAThe pilot's inadequate pre-takeoff check and his failure to abort the takeoff. Inadequate maintenance of the engine was a factor.Aug 2, 1991 · N2112S · DestroyedNTSB ATL91LA151Accident · No injuriesLimited investigationFinal reportCessna 182L · Macon, NCThe pilot's failure to accurately judge the distance required to stop the airplane. A factor in the accident was the wet, grass runway surface at the time of the accident.Aug 2, 1991 · N3146R · Substantial damageNTSB LAX91LA338Accident · No injuriesLimited investigationFinal reportCessna 421C · Auburn, CAThe pilot's failure to attain the proper touchdown point while landing.Aug 1, 1991 · N98455 · Substantial damageNTSB CHI91LA238Accident · No injuriesLimited investigationFinal reportCessna 140 · Cadillac, MIImproper compensation for wind conditions resulting in aircraft control not being maintained. Factors related to the accident were a gusty crosswind condition and lack of total experience by the pilot.Aug 1, 1991 · N76535 · Substantial damageNTSB LAX91LA336Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilot's misjudged landing flare and his failure to maintain a proper go-around course over the runway.Jul 31, 1991 · N2946E · Substantial damageNTSB FTW91LA135Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Mesquite, TXThe flight instructor's inadequate supervision of the student. Factors were the dual student's misjudgement of altitude and premature flare of the airplane.Jul 31, 1991 · N1927L · Substantial damageNTSB CHI91LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Maple Lake, MNDirectional control was not maintained by the pilot. A factor related to the accident was the pilot's lack of total experience.Jul 31, 1991 · N55924 · Substantial damageNTSB ATL91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Spartanburg, SCThe pilot's failure to follow the checklist and extend the landing gear prior to touchdown.Jul 31, 1991 · N300HF · Substantial damageNTSB CHI91LA243Accident · No injuriesLimited investigationFinal reportCessna 172 · Oberlin, KSThe student pilot's failure to maintain directional control during landing. Factors in the accident were the pilot's discontinuing his crosswind compensation and his lack of experience in the type of operation.Jul 30, 1991 · N7113A · Substantial damage