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 SEA91LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Gig Harbor, WAThe pilot's failure to maintain directional control on the ground. Factors include wind gusts.Mar 8, 1991 · N5095P · Substantial damageNTSB ANC91LA033Accident · No injuriesLimited investigationFinal reportCessna A185-F · Shageluk, AKThe collapse of the left main landing gear during the landing roll due to preexisting cracks.Mar 8, 1991 · N1855Q · Substantial damageNTSB LAX91LA122Accident · No injuriesLimited investigationFinal reportCessna 140 · Flagstaff, AZThat the pilot improperly used the flight controls and brakes. Contributing to this accident was an existing cross/tailwind.Mar 6, 1991 · N76553 · Substantial damageNTSB CHI91LA105Accident · No injuriesLimited investigationFinal reportCessna 401 · St. Louis, MOThe landing gear locking mechanism (bell crank) had fractured.Mar 6, 1991 · N401RW · Substantial damageNTSB NYC91LA082Accident · Minor injuriesLimited investigationFinal reportLatham Pitts Special S-1C · Glens Falls, NYA loss of control on the ground due to the improper operation of flight controls by the pilot. A factor related to the accident was the variable wind.Mar 5, 1991 · N98RL · DestroyedNTSB FTW91LA047Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Leander, TXThe pilot's failure to maintain a proper descent rate during the final approach.Mar 5, 1991 · N9190A · Substantial damageNTSB CHI91LA107Accident · No injuriesLimited investigationFinal reportBeech 55 · Forest Lake, MNAn aborted landing not performed by the pilot. Factors related to the accident were a runway that was wet and ice covered.Mar 5, 1991 · N29SF · Substantial damageNTSB BFO91LA029Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Chesapeake, VAThe pilot's failure to maintain directional control. Contributing was the pilot's lack of experience.Mar 5, 1991 · N61533 · Substantial damageNTSB MIA91LA092Accident · No injuriesLimited investigationFinal reportCessna 172K · Everglades City, FLInformation given during a weather briefing was disregarded, in-flight encounter with wind gust, and failure of the pilot to execute a go-around. Contributing to the accident was inadequate placement of a windsock which was blocked by trees resulting in an…Mar 4, 1991 · N84461 · Substantial damageNTSB ANC91LA032Accident · Serious injuriesLimited investigationFinal reportDe Havilland DHC-2 · Finger Lake, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the rough and uneven terrain.Mar 3, 1991 · N5349G · No damageNTSB CHI91LA103Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-60 · Chicago, ILAn excessive landing flare by the copilot. Factors associated with the accident are the inoperative wing flaps and the captain's inadequate supervison.Mar 2, 1991 · N385MQ · Substantial damageNTSB NYC91LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Nashua, NHThe failure of the pilot to compensate for wind conditions during landing, resulting in a loss of control and collision with a tree.Mar 1, 1991 · N97313 · Substantial damageNTSB FTW91LA044Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Friendswood, TXThe duel student's failure to maintain directional control during the landing and his inadvertent activation of the brakes. A factor was the ditch.Mar 1, 1991 · N5524K · Substantial damageNTSB ANC91DAG01Accident · No injuriesFinal reportPiper PA-20 · Anchorage, AKThe student pilot's failure to maintain aircraft control.Mar 1, 1991 · N2636A · Substantial damageNTSB CHI91LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Springfield, MOThe pilot's poor evaluation of high wind conditions and the subsequent inability to compensate for the winds. Related to the accident was the gusty crosswind conditions.Feb 28, 1991 · N3658P · Substantial damageNTSB SEA91LA056Accident · No injuriesLimited investigationFinal reportCessna 152 · Port Townsend, WAThe pilot's failure to maintain aircraft directional control during landing roll. Factors relating to the accident were the crosswind weather conditions and the soft terrain beside the runway.Feb 27, 1991 · N67705 · Substantial damageNTSB ANC91LA031Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Flat Top Mtn., AKThe pilot's failure to maintain directional control of the airplane on landing roll out in unsuitable terrain. Contributing to the accident was the rough and uneven terrain.Feb 27, 1991 · N7578F · Substantial damageNTSB SEA91LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, WAThe pilot's selection of an unsuitable landing sute after making the decision to attempt a precautionary landing.Feb 23, 1991 · N6568B · Substantial damageNTSB FTW91DPG02Accident · No injuriesFinal reportGrumman G-164A · Light, ARThe pilot's selection of the downwind runway for landing. A factor was the tailwind.Feb 23, 1991 · N7493 · Substantial damageNTSB SEA91FA057Accident · 3 fatalField investigationFinal reportCessna 182J · Glendale, ORThe pilot's failure to use all available runway for this landing, aggravated by his failure to initiate a go-around after misjudging the proper touchdown point and landing with a tailwind.Feb 22, 1991 · N3154F · DestroyedNTSB MIA91LA083Accident · No injuriesLimited investigationFinal reportCessna T210N · Panama City, FLThe pilot's improper recovery from a bounced landing. A factor was the pilot's lack of recent night flight experience.Feb 20, 1991 · N6136Y · Substantial damageNTSB FTW91LA041Accident · No injuriesLimited investigationFinal reportHughes 269C · Knowles, OKThe pilot's failure to maintain a proper descent rate during the maneuver and his delay in initiating the go-around.Feb 18, 1991 · N8973F · Substantial damageNTSB ATL91LA057Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brunswick, GAA hidden hole in the runway surface, which was contacted by the nose wheel during the landing roll.Feb 18, 1991 · N759VB · Substantial damageNTSB LAX91LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · San Carlos, CAThe pilot's improper flare landing.Feb 17, 1991 · N5300F · Substantial damageNTSB ATL91LA058Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Union Springs, ALThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve.Feb 16, 1991 · N85880 · Substantial damageNTSB NYC91LA076Accident · No injuriesLimited investigationFinal reportGulfstream G-1159 · Cleveland, OHThe pilot's improper in flight decision to land on a snow covered runway. The lack of adequate braking action resulted in the pilot intentionally ground looping the airplane and overloading the main landing gear. Factors related to the accident were snow…Feb 15, 1991 · N85EQ · Substantial damageNTSB SEA91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot did not maintain directional control of the airplane during the landing roll.Feb 13, 1991 · N757PW · Substantial damageNTSB MIA91LA081Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plant City, FLFailure of the pilot to maintain proper alignment during the landing roll, excessive rudder input, and loss of directional control resulting in the collapse of the right main landing gear.Feb 13, 1991 · N95T · Substantial damageNTSB ANC91LA029Accident · No injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe pilot-in-command's failure to maintain directional control.Feb 13, 1991 · N6446K · Substantial damageNTSB NYC91LA074Accident · No injuriesLimited investigationFinal reportCessna 172M · Easton, PAThe pilot's improperly executed approach, resulting in a landing with excessive airspeed.Feb 10, 1991 · N9796V · Substantial damageNTSB CHI91LA095Accident · Serious injuriesLimited investigationFinal reportBeech G35 · Teedsburg, WIFailure of the pilot to obtain or maintain adequate airspeed for a go-around (aborted landing), which resulted in an inadvertent stall/mush. The failure to attain proper runway alignment for landing was a related factor.Feb 10, 1991 · N4596D · Substantial damageNTSB CHI91LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Lawrence, KSFailure of the student pilot to maintain directional control of the aircraft, which resulted in a ground swerve.Feb 9, 1991 · N4450C · Substantial damageNTSB ATL91LA056Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Gastonia, NCThe pilot's improper flare and subsequent failure to recover from a bounced landing.Feb 9, 1991 · N3353H · Substantial damageNTSB MIA91LA080Accident · No injuriesLimited investigationFinal reportBeech 58 · St. ThomasExcessive descent rate by the pilot, improper recovery from the bounced landing, and failure to recover from the porpoise condition.Feb 8, 1991 · N7278R · Substantial damageNTSB SEA91LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Helena, MTThe pilot-in-command's failure to maintain directional control on landing. Contributing to the accident was the pilot's improper flare on landing inadequate recovery from a bounced landing, and the pilot's lack of total and recent experience.Feb 7, 1991 · N13654 · Substantial damageNTSB LAX91LA091Accident · No injuriesLimited investigationFinal reportCessna 340 · Columbia, CAAn unavoidable collision with animals (deer) on landing roll. Contributing to the accident was the airport environment that cannot preclude deer from gaining access to the airport.Feb 5, 1991 · N5813M · Substantial damageNTSB ATL91FA046Accident · Minor injuriesField investigationFinal reportPiper PA-28-180 · Greensboro, NCAn encounter with wake turbulence which resulted in an uncontrolled descent. An additional cause was pilot's physiological conditions and his use of medication.Feb 4, 1991 · N55263 · Substantial damageNTSB LAX91LA087Accident · No injuriesLimited investigationFinal reportWaco UIC · Santa Paula, CAThe brittle fracture of the left brake master cylinder tread end causing loss of directional control.Feb 3, 1991 · N13408 · Substantial damageNTSB DEN91LA027Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Durango, COThe pilot's failure to maintain directional control of the airplane. Contributing factors were the pilot's lack of experience in airplane type and crosswind conditions.Feb 3, 1991 · N9713E · Substantial damageNTSB DEN91LA038Accident · No injuriesLimited investigationFinal reportCessna 170A · Holly, COThe pilot's failure to maintain directional control. Factors were: a gusty crosswind condition and the pilot's lack of familiarity with the aircraft.Feb 2, 1991 · N1437D · Substantial damageNTSB DCA91MA018Accident · 34 fatalClass 1 · MajorFinal reportBoeing 737-300 · Los Angeles, CAThe failure of the Los Angeles air traffic facility management to implement procedures that provided redundancy comparable to the requirements contained in the national operational position standards and the failure of the FAA air traffic service to provide…Feb 2, 1991 · N388US · 2 aircraft · DestroyedNTSB LAX91LA083Accident · No injuriesLimited investigationFinal reportCessna 172P · Sedona, AZThe failure of the pilot to maintain directional control of the aircraft.Jan 27, 1991 · N54863 · Substantial damageNTSB FTW91LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's failure to maintain directional control during landing. Contributing to the accident was the crosswind condition that existed at the time of the accident.Jan 27, 1991 · N67650 · Substantial damageNTSB CHI91LA084Accident · No injuriesLimited investigationFinal reportCessna 172N · Rochester, MNInadequate compensation or wind conditions, and failure to maintain directional control by the pilot. Factors related to the accident are lack of total experience, and the crosswind conditions.Jan 26, 1991 · N9419E · Substantial damageNTSB CHI91LA082Accident · No injuriesLimited investigationFinal reportCessna 170B · Rochester, INThe pilot-in-command's inadequate compensation for wind conditions. A factor contributing to the accident was the crosswind.Jan 26, 1991 · N4414B · Substantial damageNTSB SEA91TA003Accident · No injuriesFinal reportPiper PA-34 · Pinedale, WYThe pilot's failure to attain proper runway alignment during landing. A contributing factor was a snow covered runway.Jan 25, 1991 · N8372Z · Substantial damageNTSB LAX91LA080Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe student pilot's improper bounced landing recovery technique. A factor in the accident was the pilot's limited flight experience.Jan 24, 1991 · N93574 · Substantial damageNTSB CHI91LA076Accident · No injuriesLimited investigationFinal reportCessna 320 · Middleton, WIThe main landing gear collapsed during landing rollout due to extreme cold temperatures. A factor related to the accident was a snowbank adjacent to the runway.Jan 24, 1991 · N4112T · Substantial damageNTSB NYC91LA063Accident · No injuriesLimited investigationFinal reportCessna 152U · Stroudsburg, PAThe failure of the student pilot to maintain directional control of the airplane during landing, resulting in a collision with a snowbank. Factors related to the accident were: the pilot's lack of total flight experience and the unfavorable wind during…Jan 22, 1991 · N67315 · Substantial damageNTSB DEN91LA035Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Tulsa, OKThe inadequate supervision of the student by the flight instructor. A factor was: the student's failure to flare the aircraft.Jan 21, 1991 · N6374M · Substantial damage