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 SEA93LA203Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Recluse, WYThe brake system locked for undetermined reasons.Sep 20, 1993 · N61043 · Substantial damageNTSB LAX93LA359Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Hawthorne, CAdual student's failure to maintain directional control and improper use of the rudder and the CFI's inadequate supervision of the flight.Sep 20, 1993 · N88EW · Substantial damageNTSB SEA93LA204Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot's failure to maintain the proper airspeed and glidepath.Sep 19, 1993 · N3117Y · Substantial damageNTSB CHI93LA370Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Lenox, ILSelection of the wrong runway by the pilot after misreading the wind sock. The resultant tailwind was a related factor.Sep 19, 1993 · N8753E · Substantial damageNTSB BFO93LA182Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Painesville, OHThe pilot's attempt to land with excessive airspeed, his improper use of the brakes, and his delay in performing remedial action.Sep 19, 1993 · N6294J · Substantial damageNTSB BFO93LA181Accident · No injuriesLimited investigationFinal reportCessna 180H · New Philadelphi, OHThe pilot's failure to maintain directional control of the airplane during landing rollout, subsequently causing the airplane to veer off the runway and groundloop.Sep 19, 1993 · N9704G · Substantial damageNTSB ANC93LA180Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Yantarni Bay, AKThe pilot failed to maintain directional control of the airplane during the landing roll. A factor was the crosswind.Sep 19, 1993 · N4259H · Substantial damageNTSB CHI93LA369Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Festus, MOa fatigue failure of the tailwheel spring.Sep 18, 1993 · N840B · Substantial damageNTSB ANC93LA179Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lake George, AKThe pilot's improper in-flight planning/decision, and his failure to attain the proper touchdown point. A factor was the rough/uneven terrain.Sep 18, 1993 · N5029M · Substantial damageNTSB MIA93LA197Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Fernandina Bch, FLThe pilot-in-command's excessive airspeed, his failure to touch down at the proper point on the runway, and his failure to abort the landing.Sep 17, 1993 · N456CB · Substantial damageNTSB CHI93LA363Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Griffith, INthe improper recovery from a bounced landing by the pilot-in- command.Sep 16, 1993 · N2353K · Substantial damageNTSB CHI93LA362Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Hobart, INThe certificated flight instructor's inadequate supervision of the flight during a simulated single engine approach and landing.Sep 16, 1993 · N4470P · Substantial damageNTSB SEA93LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's failure to maintain a proper glidepath, improper flare, and improper recovery from a forced landing.Sep 13, 1993 · N757WT · Substantial damageNTSB BFO93LA174Accident · No injuriesLimited investigationFinal reportCessna 182L · Oxford, MAThe failure of the CFI to maintain a proper descent rate, and his delay in performing remedial action. Factors related to the accident are the downdraft, the gusting winds, and the soft runway.Sep 13, 1993 · N42233 · Substantial damageNTSB ANC93LA185Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Puget Bay, AKThe pilot's improper in-flight planning/decision, and his misjudging his altitude above the water. A factor was the glassy water.Sep 13, 1993 · N95608 · Substantial damageNTSB MIA93FA194Accident · 1 fatalField investigationFinal reportCessna 172H · Liberty, MSThe pilot's delayed go-around and failure to retract the flaps in a timely manner. Factors which contributed to the accident were: the pilot's misjudgment of distance and speed which resulted in overshooting the approach, and the existence of power lines…Sep 12, 1993 · N3767R · DestroyedNTSB BFO93LA172Accident · No injuriesLimited investigationFinal reportCessna 172L · Gr Barrington, MAThe pilot's inadequate compensation for the crosswind which resulted in his loss of directional control during the landing roll and subsequent collision with the parked airplanes. A related factor was the pilot's lack of experience.Sep 12, 1993 · N7064Q · Substantial damageNTSB LAX93LA355Accident · No injuriesLimited investigationFinal reportAlfred F. Dibernardino RV-6A · Mesa, AZthe pilot's failure to maintain the landing airspeed. The inadvertent stall was a factor related to this accident.Sep 11, 1993 · N45FD · Substantial damageNTSB BFO93LA168Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Gilbertsville, KYThe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control. The crosswind was a related factor.Sep 10, 1993 · N4473B · Substantial damageNTSB MIA93LA189Accident · No injuriesLimited investigationFinal reportFerrie Ferri Exec · Delray Beach, FLThe pilot-in-command's improper use of the flight controls (cyclic and collective) during a simulated autorotation, resulting in an in flight collision with terrain and subsequent roll over.Sep 6, 1993 · N71714 · Substantial damageNTSB LAX93LA344Accident · No injuriesLimited investigationFinal reportCessna 182A · Potrero, CAThe overload failure of the upper nose gear torque link and the subsequent separation of the nose wheel and fork assembly from the nose gear strut. A factor in the accident was the surface irregularity in the dirt landing strip.Sep 6, 1993 · N4847D · Substantial damageNTSB FTW93LA254Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Oak Grove, LADirectional control not maintained by the pilot for undetermined reasons. Factors were a fence and trees.Sep 6, 1993 · N747BW · Substantial damageNTSB SEA93LA201Accident · No injuriesLimited investigationFinal reportCessna 182H · Salt Lake City, UTThe pilot's improper flare. Inadequate recovery from a bounced landing was factor.Sep 5, 1993 · N2076X · Substantial damageNTSB LAX93LA347Accident · No injuriesLimited investigationFinal reportCameron V-77 · Truckee, CAthe pilot's inadequate compensation for the wind conditions during the landing approach.Sep 5, 1993 · N2021A · Substantial damageNTSB CHI93LA358Accident · No injuriesLimited investigationFinal reportCessna 140 · Trenton, ILFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.Sep 5, 1993 · N89467 · Substantial damageNTSB BFO93LA158Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Block Island, RIImproper in-flight planning/decision by the pilot, and his failure to attain proper runway alignment.Sep 5, 1993 · N46DK · DestroyedNTSB BFO93LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Columbia Stn, OHThe pilot's delay in initiating a go-around (aborted landing), and his improper raising of the flaps at a low airspeed after lift-off, which resulted in a stall/mush. A factor related to the accident was: the pilot's failure to attain the proper touchdown…Sep 4, 1993 · N2189H · Substantial damageNTSB BFO93LA155Accident · Serious injuriesLimited investigationFinal reportDouglas MD-88 · Lexington, KYThe cabin attendant did not follow published procedures.Sep 4, 1993 · N913DL · No damageNTSB SEA93LA190Accident · No injuriesLimited investigationFinal reportCessna 182L · Idaho Falls, IDThe encounter with unfavorable wind during landing roll and the pilot's failure to maintain directional control.Sep 3, 1993 · N42708 · Substantial damageNTSB MIA93LA192Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Greenwood, MSOperation of the airplane by the pilot-in-command/cfi with known deficiencies in equipment and the worn condition of the tailwheel assembly.Sep 3, 1993 · N2966M · Substantial damageNTSB CHI93LA349Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Delevan, WIthe excessive use of brakes and rudder by the pilot-in-command. A factor related to the accident was the pilot-in-command's lack of total experience in this type of aircraft.Sep 3, 1993 · N55501 · Substantial damageNTSB BFO93LA154Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Centre Hall, PAThe pilot misjudged his airspeed and altitude which resulted in the pilot's failure to attain the proper touchdown point resultng in the airplane exiting the runway and colliding with the berm. A related factor was the location of the berm.Sep 2, 1993 · N2406U · Substantial damageNTSB BFO93LA149Accident · Serious injuriesLimited investigationFinal reportLach Bensen B-8M · Fall River, MAFATIGUE FAILURE OF THE GYROCOPTER'S MAIN ROTOR CONTROL ARM. fACTORS RELATED TO THE ACCIDENT WERE: A LOOSE CLAMP ON THE ROTOR CONTROL ARM, DUE TO INADEQUATE MAINTENANCE OR INSPECTION, WHICH RESULTED IN CHAFING OF THE CONTROL ARM.Sep 2, 1993 · N8447 · Substantial damageNTSB ANC93LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Squirrel River, AKThe pilot improperly compensated for the wind conditions.Sep 1, 1993 · N4402Z · Substantial damageNTSB ANC93LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Victory, AKThe partial failure of the airplane's brake system. Factor was the intentional ground looping by the pilot-in-command.Aug 31, 1993 · N9016Y · Substantial damageNTSB NYC93LA179Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · West Mifflin, PAThe pilot's misjudgement of speed and distance, which resulted in a landing overrun of the runway. Factors were an embankment and the pilot not being able to abort the landing.Aug 29, 1993 · N2572U · Substantial damageNTSB LAX93LA339Accident · Serious injuriesLimited investigationFinal reportMooney M-20M · Eureka, CAthe pilot's failure to attain the proper touch down point and the excessive airspeed.Aug 29, 1993 · N353CK · Substantial damageNTSB CHI93LA341Accident · No injuriesLimited investigationFinal reportCessna R182 · St Louis, MOthe pilot's delay in lowering the landing gear prior to touchdown.Aug 29, 1993 · N2623C · Substantial damageNTSB NYC93LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Cortland, NYThe student pilot's improper recovery from a bounced landing, resulting in a hard landing and collapse of the nose gear. A factor was the student pilot's inexperience.Aug 28, 1993 · N63626 · Substantial damageNTSB LAX93LA340Accident · No injuriesLimited investigationFinal reportCessna 177RG · Cameron Park, CAThe pilot's failure to assure that the landing gear was down and locked. Factors relating to this accident were the alternator failure due to a broken wire and the low battery output.Aug 28, 1993 · N33195 · Substantial damageNTSB NYC93LA174Accident · Serious injuriesLimited investigationFinal reportCameron HAB-N90 · Niagara Falls, NYThe inadequate bracing of the passenger for landing which resulted in a fall.Aug 27, 1993 · N1192W · No damageNTSB SEA93FA186Accident · No injuriesField investigationFinal reportDassault DA-10 · Hailey, IDThe pilot-in-command's improper procedures. Factors include failure of an electrical relay, inoperative thrust reverser, poor crew coordination, and the second-in-command's improper procedures.Aug 26, 1993 · FBYCV · Substantial damageNTSB CHI93LA338Accident · No injuriesLimited investigationFinal reportBeech 19 · Elkhart, INinadequate remedial action by the flight instructor. Factors related to the accident were the excessive descent rate and the overload failure of the landing gear.Aug 26, 1993 · N1914L · Substantial damageNTSB SEA93LA184Accident · No injuriesLimited investigationFinal reportCessna 206B · Challis, IDInadequate compensation for wind conditions. The downdraft was a factor.Aug 25, 1993 · N3431L · Substantial damageNTSB CHI93LA337Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Saint James, MIImproper planning/decision by the pilot. Factors related to the accident were: the unfavorable wind, and high obstructions near the end of the runway.Aug 24, 1993 · N479CB · Substantial damageNTSB LAX93LA334Accident · No injuriesLimited investigationFinal reportCessna A150M · Sacramento, CAThe dual student pilot's failure to maintain directional control, improper use of the flight controls, and failure to relinquish the flight controls to the CFI. The soft dirt was a factor in this accident.Aug 23, 1993 · N9861J · Substantial damageNTSB SEA93LA185Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Garfield, WAThe pilot's improper flare and recovery from a bounced landing. Factors include approach airspeed not maintained, a lack of total experience, and a ditch near the runway.Aug 22, 1993 · N22369 · Substantial damageNTSB NYC93LA167Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Slattington, PAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain. A factor was the proper touchdown point was not obtained.Aug 22, 1993 · N23PM · Substantial damageNTSB CHI93LA332Accident · No injuriesLimited investigationFinal reportCessna 172M · Lincoln, NEthe pilot's failure to attain the proper touchdown point.Aug 22, 1993 · N80476 · Substantial damageNTSB CHI93LA331Accident · No injuriesLimited investigationFinal reportBeech 23 · Milwaukee, WIthe student pilot's improper recovery from a bounced landing.Aug 22, 1993 · N9772L · Substantial damage