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 MIA95LA011Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Mulberry, FLThe failure of the pilot-in-command to perform an adequate preflight inspection resulting in a leaking brake going undetected. This resulted in the failure of the brake due to loss of hydraulic fluid and collision with a sign and a ditch when the aircraft…Oct 22, 1994 · N7679 · Substantial damageNTSB CHI95LA020Accident · No injuriesLimited investigationFinal reportCessna 182P · Bremen, INthe pilot's failure to perform a go-around prior to touchdown. Factors to the accident were the tailwind, excessive airspeed, the rough terrain and the powerlines.Oct 22, 1994 · N9878E · Substantial damageNTSB MIA95LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Ormond Beach, FLThe pilot's failure to maintain directional control during landing, resulting in an on-ground loss of control, and collision with terrain.Oct 21, 1994 · N18539 · Substantial damageNTSB FTW95LA031Accident · No injuriesLimited investigationFinal reportHerron Little Wing Autogyro · Little Rock, ARThe fractured tail wheel mounting bracket and loose tailwheel. A factor was the pilot's continued flight testing after experiencing tail wheel shimmy on the prior test flight.Oct 21, 1994 · N45LW · Substantial damageNTSB CHI95LA017Accident · No injuriesLimited investigationFinal reportCessna 210L · Higginsville, MOA coyote (animal) that ran onto the runway as the airplane was landing.Oct 21, 1994 · N616WB · Substantial damageNTSB LAX95LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rialto, CAthe flight instructor's loss of airplane control during the landing flare as a result of his inadequate supervision of the flight and delayed corrective action over his presolo student's control inputs.Oct 20, 1994 · N8760F · Substantial damageNTSB LAX95LA012Accident · No injuriesLimited investigationFinal reportPitts S-2B · Chandler, AZthe pilot's failure to maintain proper alignment with the runway during landing rollout. A contributing factor was sun glare.Oct 19, 1994 · N15KR · Substantial damageNTSB ANC95LA007Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Palmer, AKThe pilot's selection of unsuitable terrain for landing. Snow covered terrain in the landing area was a factor in the accident.Oct 19, 1994 · N97821 · Substantial damageNTSB NYC95LA014Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Haymarket, VAThe pilot's failure to extend the landing gear which resulted in a gear up landing. A factor was the pilot's diverted attention.Oct 18, 1994 · N54VT · Substantial damageNTSB LAX95IA011Incident · No injuriesIncident investigationFinal reportCessna 402 · Grand Canyon, AZthe fracture and failure of the left main landing gear bellcrank which jammed the landing gear in the retracted position.Oct 18, 1994 · N402SW · Minor damageNTSB CHI95LA015Accident · No injuriesLimited investigationFinal reportQuestair Venture · Wheeling, ILThe inadvertent deployment of the nosewheel steering. A factor in this accident was the inadequate design of the rudder pedal pivot point height above the cockpit floor by the design personnel.Oct 18, 1994 · N62V · Substantial damageNTSB LAX95LA010Accident · No injuriesLimited investigationFinal reportBeech C-23 · Kahului, HIthe student pilot's improper recovery from a bounced landing, improper in-flight decision, and his failure to attain the proper climb airspeed during the initial takeoff resulting in an inadvertent stall. The student pilot's lack of total experience,…Oct 16, 1994 · N60054 · Substantial damageNTSB NYC95LA010Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Fitchburg, MAThe pilot's failure to adequately compensate for the crosswind condition during landing, which resulted in a ground loop and the subsequent wing tip collision with the runway.Oct 15, 1994 · N4923N · Substantial damageNTSB LAX95LA009Accident · No injuriesLimited investigationFinal reportCessna 177RG · Laytonville, CAwere the pilot's failure to maintain the proper airspeed and attain the proper touchdown point.Oct 15, 1994 · N7577V · Substantial damageNTSB FTW95LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmington, NMThe pilot's inadequate compensation for wind conditions. Factors were wind shear, crosswinds, and gusts.Oct 13, 1994 · N20384 · Substantial damageNTSB LAX95LA014Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Palo Alto, CAthe pilot's improper bounced landing recovery technique.Oct 12, 1994 · N8154C · Substantial damageNTSB MIA95LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Indiantown, FLThe improper landing flare by the pilot resulting in the hard landing.Oct 11, 1994 · N5415R · Substantial damageNTSB CHI95LA027Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Mt. Vernon, MOthe pilot's inadequate visual lookout. A factor associated with the accident is the fence post.Oct 11, 1994 · N5433Z · Substantial damageNTSB CHI95LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Bloomington, ILThe pilot's failure to maintain aircraft control while landing. Factors associated with the accident were the improper landing flare and the pilot's lack of total experience.Oct 10, 1994 · N69187 · Substantial damageNTSB NYC95LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Center Harbor, NHThe pilot's inadequate compensation for a crosswind condition.Oct 9, 1994 · N733MV · Substantial damageNTSB LAX95LA002Accident · No injuriesLimited investigationFinal reportCessna 172M · Coalinga, CAthe pilot's failure to maintain a proper glide path.Oct 8, 1994 · N5061R · Substantial damageNTSB SEA95LA003Accident · No injuriesLimited investigationFinal reportCessna 210 · Bend, ORThe failure of the landing gear downlock mechanism to engage due to undetermined reasons.Oct 7, 1994 · N75DA · Substantial damageNTSB NYC95LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Grt Barrington, MAthe pilot's improper flare during landing, which resulted in a hard landing and the subsequent collapsed landing gear. A factor in this accident was the pilot's lack of total recent flying experience and recent experience in make and model.Oct 7, 1994 · N44794 · Substantial damageNTSB MIA95LA003Accident · No injuriesLimited investigationFinal reportPitts S1C · Plant City, FLThe failure of the pilot in command to maintain directional control during landing resulting in the aircraft running off the side of the runway and nosing over in soft terrain.Oct 5, 1994 · N2997G · Substantial damageNTSB FTW95LA010Accident · Minor injuriesLimited investigationFinal reportWinn RV-6A · Marble Falls, TXThe pilot's improper compensation for the wind conditions. A factor was the unfavorable winds.Oct 5, 1994 · N600CW · Substantial damageNTSB SEA95LA002Accident · No injuriesLimited investigationFinal reportCessna 150 · Florence, ORThe pilot-in-command's failure to properly recover from a bounced landing, and his failure to compensate for wind conditions and maintain directional control during the landing rollout. Contributing to the accident were gusty crosswinds.Oct 4, 1994 · N3164X · Substantial damageNTSB MIA95LA002Accident · No injuriesLimited investigationFinal reportCessna 421B · Stuart, FLThe improper rigging of the landing gear safety squat switch by other maintenance personnel. Contributing to the accident was the contamination of the gear squat switch with corrosion and water.Oct 3, 1994 · N701AM · Substantial damageNTSB MIA95LA001Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenwood, MSThe student pilot's improper planning/decision concerning the selection/approach/execution of the emergency landing. Factors related to the accident were: the pilot's lack of experience, his becoming lost/disoriented, the light conditions at dusk, and the…Oct 3, 1994 · N65454 · Substantial damageNTSB FTW95LA005Accident · No injuriesLimited investigationFinal reportCessna 150L · Booker, TXThe pilot's failure to maintain a proper glidepath resulting in a collision with an object. Factors were the dark night and the pilot's disregard for the lack of lights.Oct 2, 1994 · N16191 · Substantial damageNTSB SEA95LA001Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Billings, MTInadequate compensation for wind conditions. Factors to the accident were: crosswind and inadequate remedial action.Oct 1, 1994 · N664G · Substantial damageNTSB ATL95LA002Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Covington, TNThe pilot's failure to maintain directional control during landing.Oct 1, 1994 · N731PS · Substantial damageNTSB ATL95LA001Accident · No injuriesLimited investigationFinal reportBeech V35B · Siler City, NCThe pilot's failure to maintain directional control during landing roll.Oct 1, 1994 · N2890W · Substantial damageNTSB FTW94LA320Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Andrews, TXThe pilot's failure to initiate a go-around after encountering a tailwind. A factor was the tailwind.Sep 30, 1994 · N8901Y · Substantial damageNTSB FTW94LA319Accident · No injuriesLimited investigationFinal reportLockheed PV-2 · Lafayette, LAThe pilot's inadvertent gear retraction.Sep 30, 1994 · N6857C · Substantial damageNTSB FTW94LA322Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Frederick, COA fatigue failure of the left main landing gear axle.Sep 28, 1994 · N53844 · Substantial damageNTSB FTW94LA314Accident · No injuriesLimited investigationFinal reportCessna 182N · Cortez, COThe pilot's improper recovery from a bounced landing.Sep 28, 1994 · N9ZG · Substantial damageNTSB MIA94IA217Incident · No injuriesIncident investigationFinal reportCessna 402C · Ft. Lauderdale, FLThe first officer's failure to maintain directional control on landing roll out due to improper use of brakes, resulting in the airplane veering off the runway, and subsequent on-ground collision with a runway light and sign. Contributing to the incident was…Sep 26, 1994 · N63PB · Minor damageNTSB FTW94LA312Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Galena, AKThe pilot's excessive use of brakes during landing. A factor was the unfavorable winds at the remote landing area.Sep 25, 1994 · N7513K · Substantial damageNTSB CHI94LA347Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Washburn, NDthe pilot's failure to maintain sufficient airspeed during the landing flare. Factors associated with the accident were the poorly planned approach and the soft terrain.Sep 25, 1994 · N6119Q · Substantial damageNTSB LAX94LA385Accident · No injuriesLimited investigationFinal reportCessna 152 · Fallbrook, CAThe student pilot's inadequate recovery from a bounced landing.Sep 24, 1994 · N89546 · Substantial damageNTSB FTW94LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Byers, COFailure by the pilot to maintain a proper descent rate during approach to landing. A factor was lack of experience in make, model, and type of aircraft.Sep 24, 1994 · N71245 · Substantial damageNTSB FTW94LA308Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Monte Vista, COThe pilot's failure to maintain directional. Factors were the cross wind conditions, and the pilot's poor evaluation of the weather.Sep 23, 1994 · N3540U · Substantial damageNTSB NYC94LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Buffalo, NYThe pilot's improper recovery from a bounced landing. A factor is the pilot's improper landing flare.Sep 22, 1994 · N3024M · Substantial damageNTSB ATL94LA176Accident · No injuriesLimited investigationFinal reportMooney M20J · Chamblee, GAThe pilot's improper flare that resulted a in hard landing, followed by his improper recovery from a bounced landing, and his failure to maintain directional control during the attempted go- around.Sep 22, 1994 · N97136 · Substantial damageNTSB LAX94LA384Accident · No injuriesLimited investigationFinal reportCessna 152 · Petaluma, CAthe failure of the pilot to initiate a go-around after failing to obtain the proper airspeed and rate of descent during the approach.Sep 21, 1994 · N6208B · Substantial damageNTSB LAX94LA370Accident · 1 fatalLimited investigationFinal reportJames B. Edwards Cozy · Skull Valley, AZThe pilot's poorly planned approach by failing to maintain the proper airspeed and alignment. The pilot's total expereince, and lack of experience in the airplane make and model were factors in this accident.Sep 21, 1994 · N151JE · DestroyedNTSB CHI94LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Plainwell, MIthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the pilot's lack of total experience.Sep 21, 1994 · N67324 · Substantial damageNTSB ATL94LA174Accident · No injuriesLimited investigationFinal reportCessna 152 · Linden, TNThe pilot's improper use of the rudder which resulted in a loss of directional control.Sep 21, 1994 · N5525P · Substantial damageNTSB NYC94LA181Accident · No injuriesLimited investigationFinal reportCessna 172P · Sterling, MAThe pilot misjudged landing distance, which resulted in an overrun of the runway. A factor is the pilot's failure to do a go-around.Sep 20, 1994 · N55164 · DestroyedNTSB CHI94LA337Accident · 1 fatalLimited investigationFinal reportPiper PA-20 · Greenville, MIIncapacitation of the pilot due to a seizure and/or loss of consciousness. A factor related to the accident was: the pilot's failure to properly report his medical information on his FAA medical application.Sep 20, 1994 · N7061K · Substantial damage