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 ANC99LA036Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Girdwood, AKThe pilot's misjudged flare while landing. Factors associated with the accident were whiteout conditions, and snow-covered terrain.Mar 17, 1999 · N197EH · Substantial damageNTSB MIA99LA106Accident · No injuriesLimited investigationFinal reportBeech 58 · St CroixThe pilot's failure to extend the landing gear.Mar 16, 1999 · N6CH · Substantial damageNTSB ANC99LA035Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Healy, AKThe pilot's inadequate recovery from a bounced landing. A factor associated with the accident was a snowbank.Mar 16, 1999 · N9023L · Substantial damageNTSB FTW99LA111Accident · No injuriesLimited investigationFinal reportCessna 182Q · Galveston, TXThe pilot's delayed landing flare of the aircraft. Factors were the excessive airspeed and the pilot's lack of experience in the make and model of aircraft.Mar 15, 1999 · N7608S · Substantial damageNTSB DEN99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Leadville, COThe pilot's inadequate compensation for the gusty crosswind conditions. A factor was the gusting crosswindMar 14, 1999 · N90995 · Substantial damageNTSB ATL99LA052Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Laurens, SCThe pilot's disregard for current wind conditions and his failure to maintain directional control during landing. Factors were the tailwind and wet runway surface.Mar 14, 1999 · N345RP · Substantial damageNTSB NYC99LA075Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Winchester, VAThe pilot's failure to extend the landing gear before landing on the runway.Mar 13, 1999 · N700SP · Substantial damageNTSB LAX99LA118Accident · No injuriesLimited investigationFinal reportCessna 305A · Coalinga, CAThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the airplane.Mar 13, 1999 · N5188G · Substantial damageNTSB SEA99LA042Accident · No injuriesLimited investigationFinal reportCessna 182R · Hailey, IDThe pilot's failure to maintain aircraft control after touchdown. Factors contributing to the accident were a snow bank along the runway edge and a crosswind.Mar 11, 1999 · N1622E · Substantial damageNTSB CHI99LA103Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIThe pilot's improper flare and failure to maintain directional control. Related factors were the snowbank and lack of total experience.Mar 10, 1999 · N983AV · Substantial damageNTSB CHI99LA091Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIthe loss of directional control by the pilot. Factors to the accident were the lack of total experience of the pilot, the snow covered runway condition, the snowbank, and the flight instructor not verifying the runway snow removal with the Duty Instructor…Mar 10, 1999 · N989AV · Substantial damageNTSB CHI99LA106Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Grand Ledge, MIthe flight instructor's failure to successfully take remedial action to maintain directional control of the airplane during the landing roll out. Factors were the crosswinds and snowbank.Mar 8, 1999 · N432W · Substantial damageNTSB LAX99LA114Accident · No injuriesLimited investigationFinal reportCessna 180F · Inyokern, CAthe pilot's inadequate compensation for the variable and gusting winds during a wheel landing, which led to a loss of directional control.Mar 7, 1999 · N345RC · Substantial damageNTSB CHI99LA104Accident · No injuriesLimited investigationFinal reportCessna 172P · Plainfield, ILthe pilot's inadequate directional control during landing roll. A factor was the snow bank.Mar 7, 1999 · N65192 · Substantial damageNTSB ANC99LA031Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Big Lake, AKThe pilot's selection of unsuitable terrain for landing the wheel equipped airplane. A factor associated with the accident was the soft snow covering the frozen lake.Mar 7, 1999 · N4040M · Substantial damageNTSB MIA99LA101Accident · No injuriesLimited investigationFinal reportCessna 177 · Lantana, FLthe pilot misjudged the flare, resulting in a hard landing, and subsequent impact with the runway.Mar 6, 1999 · N2890X · Substantial damageNTSB FTW99LA090Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange, TXThe student pilot's failure to maintain directional control during landing touchdown. A factor was the muddy drainage ditch.Mar 6, 1999 · N5803E · Substantial damageNTSB SEA99LA039Accident · No injuriesLimited investigationFinal reportCessna TU206G · Cascade, IDUnsuitable terrain for landing was selected. Snow covered airstrip was a factor.Mar 3, 1999 · N756AV · Substantial damageNTSB MIA99LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-60-601P · Statesville, NCthe pilot's failure to attain the proper touchdown point on the runway. Factors in this accident were excessive approach speed, rain, and a wet runway.Mar 3, 1999 · N727MB · Substantial damageNTSB MIA99LA096Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Stuart, FLThe inadequate touchdown resulting in a hard landing on the nose landing gear and subsequent structural damage.Feb 28, 1999 · N2313Z · Substantial damageNTSB FTW99LA087Accident · No injuriesLimited investigationFinal reportMonocoupe 90A · Fort Worth, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop/swerve. A factor was the crosswind.Feb 28, 1999 · N11760 · Substantial damageNTSB DEN99LA044Accident · No injuriesLimited investigationFinal reportParsons Kitfox II · Colorado Spgs, COThe airplane's encounter with a dust devil during landing.Feb 28, 1999 · N740GP · Substantial damageNTSB NYC99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Myerstown, PAThe student pilot's improper flare which resulted in a hard landing.Feb 27, 1999 · N8923J · Substantial damageNTSB NYC99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sublett, KYThe pilot's improper decision to continue the flight with a perceived excessive fuel consumption, and delaying his decision to execute a precautionary until night, which resulted in the airplane impacting wires. Factors in the accident were the pilot's lack…Feb 27, 1999 · N25856 · DestroyedNTSB NYC99LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Berlin, NJThe pilot in command's failure to obtain the proper touch down point on the runway, and failure to perform a go-around. A factor relating to the accident was a sudden wind shift.Feb 26, 1999 · N737MJ · Substantial damageNTSB LAX99LA110Accident · No injuriesLimited investigationFinal reportHelio Jergins H 800 · Prescott, AZThe malfunction of the propeller for undetermined reasons at an altitude too low for the pilot to take effective remedial action.Feb 26, 1999 · N666X · Substantial damageNTSB LAX99LA109Accident · No injuriesLimited investigationFinal reportCessna 172P · Death Valley, CAThe pilot's use of an excessive approach reference speed and his misjudged distance/speed relationship to the runway, which resulted in a landing overrun. The pilot's failure to execute a timely go-around was also causal.Feb 26, 1999 · N99269 · Substantial damageNTSB MIA99LA092Accident · No injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe student pilot's failure to maintain directional control during the landing roll. A related factor was the pilot's diverted attention.Feb 25, 1999 · N49407 · Substantial damageNTSB ANC99TA029Accident · Minor injuriesFinal reportBell 206L-1 · Barrow, AKThe pilot's misjudged flare while landing. Factors associated with the accident were whiteout conditions, and the snow-covered terrain.Feb 24, 1999 · N785SR · Substantial damageNTSB MIA99LA090Accident · No injuriesLimited investigationFinal reportCessna 172P · Pelion, SCThe pilot's loss of directional control during landing roll as a result of improper recovery from a bounced landing and the subsequent excursion from the runway, collision with the adjacent terrain, and collapse of the nose landing gear.Feb 21, 1999 · N65770 · Substantial damageNTSB SEA99LA035Accident · No injuriesLimited investigationFinal reportCessna 150L · Hillsboro, ORThe pilot's failure to maintain directional control of the aircraft. A related factor was the crosswind condition.Feb 20, 1999 · N16058 · Substantial damageNTSB FTW99LA084Accident · Minor injuriesLimited investigationFinal reportBeech BE-76 · Mesquite, TXThe flight instructor's inadequate supervision of the multi-engine rated instrument student during a simulated single engine landing, resulting in loss of control of the airplane. Factors were the dark night light condition, the flight instructor's inadequate…Feb 20, 1999 · N3819D · Substantial damageNTSB CHI99LA093Accident · No injuriesLimited investigationFinal reportMitsubishi 300 · Columbus, NEthe pilot-in-command failed to attain the proper touchdown point during the landing. Factors associated with the accident were the rough, snow covered terrain encountered off the end of the runway, and the low ceiling at the time of the landing.Feb 18, 1999 · N110DS · Substantial damageNTSB LAX99FA101Accident · No injuriesField investigationFinal reportGrumman G-1159 · Van Nuys, CAThe pilot performed inadequate in flight planning and decided to continue the approach and landing with excessive airspeed. The pilot failed to follow company directives, which required a go around under the encountered flight conditions. This led to a long…Feb 16, 1999 · N711TE · Substantial damageNTSB DEN99LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Colorado Sprngs, COThe pilot's failure to maintain directional control of the aircraft during landing touchdown. A factor was the sign.Feb 16, 1999 · N8804J · Substantial damageNTSB DEN99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · West Jordan, UTThe pilot's failure to maintain directional control of the aircraft. Factors were his lack of recent flight experience, and his lack of experience in the make and model of aircraft.Feb 16, 1999 · N734BE · Substantial damageNTSB SEA99LA033Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Seattle, WAThe dual student's improper touchdown while drifting during a practice autorotation. Contributing to the accident was the flight instructor (CFI) inadequate remedial action.Feb 15, 1999 · N8362Q · Substantial damageNTSB LAX99LA133Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Prescott, AZThe pilot's inadequate compensation for the crosswind condition, which led to a loss of directional control and an inadvertent ground loop.Feb 15, 1999 · N2077U · Substantial damageNTSB LAX99LA097Accident · No injuriesLimited investigationFinal reportCessna 414 · Phoenix, AZThe overload failure of the left main gear locking mechanism due to improper system rigging by maintenance personnel.Feb 15, 1999 · N1557T · Substantial damageNTSB MIA99LA084Accident · No injuriesLimited investigationFinal reportCessna 172K · Marathon, FLThe pilot's improper use of elevator control while landing in gusty winds resulting in the aircraft nosing down and the propeller and wing contacting the runway.Feb 14, 1999 · N75RR · Substantial damageNTSB IAD99LA073Accident · No injuriesLimited investigationFinal reportMonocoupe 110 · Limington, MEPilot's failure to maintain directional control during the landing rollout.Feb 14, 1999 · N10730 · Substantial damageNTSB FTW99LA082Accident · No injuriesLimited investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain an adequate approach airspeed which resulted in a excessive descent rate and hard landing and the pilot's failure to recover from a bounced landing. A factor was the pilot's lack of total experience.Feb 14, 1999 · N6405K · Substantial damageNTSB SEA99LA034Accident · No injuriesLimited investigationFinal reportCessna 182A · Conner, MTThe pilots delayed remedial action during an aborted landing. Factors include a slush-covered runway.Feb 13, 1999 · N3753D · Substantial damageNTSB LAX99LA098Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Boulder City, NVThe failure of the pilot-in-command to properly position the floatplane landing gear for a water landing and failure to verify the landing gear position resulting in an inadvertent wheels down landing on water.Feb 13, 1999 · N747CL · Substantial damageNTSB FTW99LA081Accident · No injuriesLimited investigationFinal reportCessna 188 · Alexandria, LAThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in an inadvertent ground loop.Feb 13, 1999 · N8295G · Substantial damageNTSB MIA99LA080Accident · No injuriesLimited investigationFinal reportCessna 172P · Cleveland, MSThe pilot's improper recovery from a bounced landing, resulting in a blown nose tire, loss of directional control, and subsequent collision with terrain.Feb 10, 1999 · N6089K · Substantial damageNTSB MIA99LA078Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Sanford, FLthe pilot misjudged the flare resulting in a hard landing and damage to the airplane.Feb 10, 1999 · N39531 · Substantial damageNTSB FTW99LA073Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Denton, TXThe hard landing as a result of the pilot's failure to maintain the proper descent rate during the landing flare.Feb 7, 1999 · N112WS · Substantial damageNTSB NYC99LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Burnt Chimney, VAThe pilot's decision to land on a short runway with a strong tailwind, and his failure to obtain a proper touchdown point.Feb 6, 1999 · N19186 · DestroyedNTSB CHI99LA088Accident · No injuriesLimited investigationFinal reportCessna 150G · Hillman, MIthe pilot's misjudging crosswinds during landing roll. Factors were crosswinds and a snow and ice covered runway, and the snowbank.Feb 6, 1999 · N3332J · Substantial damage