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 MIA01FA108Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Marco Island, FLThe failure of the pilot to maintain control of the aircraft during a rejected landing and the collision with the terrain and mangrove trees. A finding in the investigation was the presence of quinine in the blood and urine during postmortem toxicological…Mar 31, 2001 · N900CE · DestroyedNTSB LAX01LA132Accident · No injuriesLimited investigationFinal reportCessna 170B · Lincoln, CAThe certified flight instructor's inadequate supervision of his dual student who used excessive braking on landing resulting in the airplane's nose over.Mar 31, 2001 · N4315B · Substantial damageNTSB DEN01LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Rangely, COthe pilot's improper use of aileron and his failure to maintain directional control during landing. A contributing factor was the direct gusty crosswind.Mar 31, 2001 · N54663 · Substantial damageNTSB SEA01LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Scapoose, ORthe pilot's failure to maintain a speed above minimum in-flight stall speed (Vs). Factors include gusty winds at the time of the attempted landing.Mar 30, 2001 · N33657 · Substantial damageNTSB FTW01LA092Accident · No injuriesLimited investigationFinal reportBradley Midget Mustang · Orange, TXthe pilot's inadequate compensation for the crosswind conditions during the landing roll which resulted in a loss of control. A contributing factor was the crosswind condition.Mar 30, 2001 · N11DB · Substantial damageNTSB LAX01LA130Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Holbrook, AZFailure of the rudder lower hinge attach point resulting in a loss of rudder control and steerable tailwheel control. A factor was the crosswind condition.Mar 29, 2001 · N9299D · Substantial damageNTSB DEN01LA079Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Las Vegas, NMthe pilot's failure to maintain directional control during landing roll. Factors were weather evaluation by the pilot and rough terrain off the side of the runway.Mar 29, 2001 · N88352 · Substantial damageNTSB IAD01LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJpilot's failure to maintain directional control during the landing roll-out. A factor was the crosswind.Mar 28, 2001 · N1046H · Substantial damageNTSB ANC01LA052Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was uneven terrain.Mar 28, 2001 · N91303 · Substantial damageNTSB MIA01LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dyer, TNThe improper installation of the main landing gear tire (pinched tube) by company maintenance personnel resulting in a total loss of air pressure in-flight, loss of directional control on landing roll, and subsequent nose down.Mar 27, 2001 · N6552K · Substantial damageNTSB DEN01LA076Accident · No injuriesLimited investigationFinal reportBeech 95-B55B (T42A) · Watkins, COAn inadvertent landing gear retracted landing by the CFI during an instructional flight conducting a touch-and-go landing.Mar 27, 2001 · N38KS · DestroyedNTSB FTW01LA086Accident · No injuriesLimited investigationFinal reportCartercopters Cartercopter · Olney, TXthe pilot's failure to maintain rotor rpm, which resuted in the main rotor contacting the tail during landing.Mar 25, 2001 · N121CC · Substantial damageNTSB LAX01LA128Accident · No injuriesLimited investigationFinal reportCessna 305A · Winslow, AZThe student's inadvertent restriction of the rudder pedal's movement during landing rollout precipitated the loss of directional control and ground loop. A finding was that remedial action by the CFI was not possible due to the student’s control interference.Mar 23, 2001 · N5188G · Substantial damageNTSB FTW01LA089Accident · No injuriesLimited investigationFinal reportAviat A-1B Husky · Odessa, TXthe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Mar 23, 2001 · N304C · Substantial damageNTSB LAX01FA127Accident · No injuriesField investigationFinal reportAgusta A109A · Hanapepe, Kauai, HIthe pilot's misjudged flare during an autorotation, which resulted in a hard landing. A contributing factor was the check airman's failure to demonstrate a stuck pedal maneuver prior to assigning the procedure to the pilot.Mar 22, 2001 · N293G · Substantial damageNTSB LAX01LA143Accident · No injuriesLimited investigationFinal reportBeech C35 · Fullerton, CAThe premature retraction of the landing gear and the failure of the CFI to properly supervise the flight.Mar 21, 2001 · N7MK · Substantial damageNTSB LAX01LA125Accident · No injuriesLimited investigationFinal reportRobinson R22B · Long Beach, CAFailure of the CFI to adequately monitor the flight, which resulted in a low airspeed autorotation and hard landing.Mar 21, 2001 · N8492A · Substantial damageNTSB MIA01LA101Accident · No injuriesLimited investigationFinal reportRobinson R22 · Okeechobee, FLan in-flight collision with the ground during a simulated engine failure, and autorotation, which resulted in the tailboom separating. A contributing factor in this accident was the pilot allowed the rotor rpm to decay which resulted in inadequate rotor rpm…Mar 16, 2001 · N666BH · Substantial damageNTSB CHI01LA105Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sidney, NEthe pilot's failure to maintain directional control during the landing. A factor relating to this accident was the berm.Mar 16, 2001 · N3947Z · Substantial damageNTSB FTW01LA080Accident · No injuriesLimited investigationFinal reportCessna 210D · Lawton, OKthe pilot's failure to maintain aircraft control during the landing flare/touchdown. A contributing factor was the crosswind.Mar 15, 2001 · N210HS · Substantial damageNTSB LAX01LA115Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe pilot's failure to maintain directional control resulting in an encounter with terrain and a nose over.Mar 14, 2001 · N738PP · Substantial damageNTSB SEA01LA061Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350 B2 Ecureuil · Mazama, WAThe pilot's failure to maintain aircraft control. Snow covered terrain, high and variable wind conditions, and failure of attaining the proper touchdown point were factors.Mar 11, 2001 · N189EH · Substantial damageNTSB NYC01LA087Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Islip, NYThe certified flight instructor’s inadequate supervision and delayed remedial action, which resulted in a roll-over. Factors in this accident were the crosswind condition and soft landing area.Mar 10, 2001 · N9077F · Substantial damageNTSB LAX01LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802 A · Maricopa, AZInadequate selection of landing facilities and improper placement of vehicles near the runway. An additional factor was the use of a runway which resulted in a downwind landing.Mar 10, 2001 · N6059L · Substantial damageNTSB NYC01FA084Accident · No injuriesField investigationFinal reportHawker Siddeley HS-125-3A · Bridgeport, CTThe pilot-in-commands inadequate preflight planning resulting in an approach to a runway with insufficient length. A factor related to the accident was the slush covered runway which resulted in a hydroplaning condition.Mar 9, 2001 · N48DD · Substantial damageNTSB SEA01LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Enterprise, ORInadvertent collision with a deer while landing. A contributing factor was night conditions.Mar 8, 2001 · N71354 · Substantial damageNTSB LAX01LA111Accident · No injuriesLimited investigationFinal reportCessna 140 · San Jose, CAThe failure of the pilot to maintain directional control during landing.Mar 8, 2001 · N77J · Substantial damageNTSB NYC01LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Keene, NHThe pilot's failure to maintain directional control during the landing roll. A factor included the patchy snow on the runway.Mar 7, 2001 · N574SP · Substantial damageNTSB DEN01LA069Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Heber, UTUncommanded locking of the right brake, resulting in loss of control and nose over during landing.Mar 7, 2001 · N75848 · Substantial damageNTSB DEN01LA068Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Morgan, UTthe pilot's failure to maintain directional control during landing roll which resulted in a collision with a snow bank on the edge of the runway.Mar 7, 2001 · N42523 · Substantial damageNTSB LAX01IA109Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Phoenix, AZthe pilot's misjudgment of distance, which resulted in a runway overrun. A factor in the incident was the failure of the flightcrew to conduct a briefing for the approach to runway eight.Mar 5, 2001 · N335SW · Minor damageNTSB MIA01LA092Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30A · Sylacauga, ALThe pilot's failure to maintain directional control during landing rollout, and the subsequent runway excursion and collision with trees.Mar 4, 2001 · N8844V · Substantial damageNTSB MIA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172L · Fort Lauderdale, FLThe total failure of the yoke weld assembly due to corrosion resulting in the inability of the flight crew to maintain elevator control of the airplane. Additionally, inadequate annual inspection of the airplane by other maintenance personnel for failure to…Mar 3, 2001 · N3802Q · Substantial damageNTSB MIA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melbourne, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll of the touch-and-go landing resulting in the on ground collision with a ditch and subsequent separation of the nose gear wheel and fork assembly and…Mar 3, 2001 · N4949N · Substantial damageNTSB MIA01IA091Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLIncomplete compliance with a non-mandatory Cessna Service Information Letter by an unknown person resulting in pulling through of the attach bolt of the upper and lower link assemblies and subsequent rotation of the right wheel assembly. Additionally,…Mar 3, 2001 · N108GP · Minor damageNTSB DEN01LA063Accident · No injuriesLimited investigationFinal reportCessna 152 · Grand Junction, COthe student pilot's failure to recover from a bounced landing, which resulted in porpoising and subsequently a nose over.Mar 3, 2001 · N24950 · Substantial damageNTSB DEN01LA062Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Durango, COthe pilot's failure to maintain directional control. A contributing factor was the blown tire.Mar 3, 2001 · N8356X · Substantial damageNTSB DEN01LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control of the airplane during landing.Mar 3, 2001 · N152RC · Substantial damageNTSB DEN01LA060Accident · No injuriesLimited investigationFinal reportBell 407 · Jackson, WYThe pilot's failure to maintain adequate lateral and vertical clearance during landing. Factors were the clouds and snow-covered high terrain.Mar 2, 2001 · N9HE · Substantial damageNTSB MIA01LA088Accident · No injuriesLimited investigationFinal reportTemco GC-1B · Sanford, NCThe failure of the pilot to maintain directional control of the airplane after the second touchdown following a bounced landing resulting in collapse of all landing gears.Mar 1, 2001 · N3310K · Substantial damageNTSB CHI01LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Mankato, MNThe student pilot's failure to maintain directional control during the landing. Factors relating to the accident were the student pilot's lack of total experience, the icy runway, the strong crosswind, the wind gusts, and the snowbank.Feb 28, 2001 · N5236H · Substantial damageNTSB SEA01LA054Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Seattle, WABoth pilots' exceedance of the proper descent rate during the autorotative descent. Factors included the helicopter's low altitude at maneuver initiation, the failure of both pilots to maintain the proper airspeed during the descent, and both pilots' delay in…Feb 27, 2001 · N8362Q · Substantial damageNTSB CHI01LA096Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Appleton, WIThe misjudged glidepath and the intentional engine shutdown by the pilot. Factors were the false indication of the landing gear down light and the approach light.Feb 27, 2001 · N8196Y · Substantial damageNTSB CHI01LA094Accident · No injuriesLimited investigationFinal reportCessna 500 · Sault Ste Marie, MIThe pilot exceeding the available runway distance during landing and the pilot's delay in executing a go-around. Factors relating to the accident were, the pilots improper in-flight planning/decision, the pilot disregarding the NOTAMS for the airport, the…Feb 26, 2001 · N234UM · Substantial damageNTSB MIA01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student's failure to maintain control of the aircraft during landing due to his improper landing flare height and improper recovery from a bounced landing, resulting in a nose landing gear collapse, and excursion off the runway.Feb 25, 2001 · N942AC · Substantial damageNTSB FTW01LA070Accident · No injuriesLimited investigationFinal reportBartels Rans S-7 · Lafayette, LAthe pilot's improper flare which resulted in a hard landing.Feb 25, 2001 · N777SB · Substantial damageNTSB ANC01LA038Accident · No injuriesLimited investigationFinal reportForney F-1A · Whittier, AKThe pilot's inadequate preflight planning/preparation, and his selection of unsuitable terrain for landing. A factor in the accident was snow-covered terrain.Feb 24, 2001 · N3032G · Substantial damageNTSB LAX01TA092Accident · No injuriesFinal reportMcDonnell Douglas 600N · San Diego, CAThe student pilot's improper use of the rotorcraft flight controls, and the instructor pilot's inadequate supervision of the maneuver.Feb 21, 2001 · N606BP · Substantial damageNTSB DEN01LA054Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Angel Fire, NMthe pilot's failure to maintain control of the airplane during landing. Contributing factors were the crosswind, the pilot exceeding the published maximum demonstrated crosswind component, and the snow bank.Feb 18, 2001 · N3051U · Substantial damageNTSB ANC01LA037Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Fairbanks, AKThe flight instructor's inadequate supervision of the flight during the landing flare. A factor in the accident was the student's abrupt airplane control.Feb 16, 2001 · N36266 · Substantial damage