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 ANC02LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Copper Center, AKThe pilot's selection of unsuitable terrain for landing, resulting in a nose-over during the landing roll. A factor contributing to the accident was rough/uneven terrain.Aug 11, 2002 · N83272 · Substantial damageNTSB CHI02LA251Accident · No injuriesLimited investigationFinal reportCessna 210L · Lacon, ILThe pilot's improper in-flight decision to perform an intentional gear-up precautionary landing instead of continuing to the next available airport. A factor to the accident was the corn crop.Aug 10, 2002 · N3UF · Substantial damageNTSB DEN02LA093Accident · No injuriesLimited investigationFinal reportCessna 310N · Grand Junction, COThe dual student's inadequate aircraft control resulting in a hard landing. Contributing factors include, the dual student's inadequate airspeed and high flare, the inadequate supervision by the instructor, the in-flight separation of the right main landing…Aug 9, 2002 · N111KC · Substantial damageNTSB ATL02LA154Accident · No injuriesLimited investigationFinal reportCessna 172M · Enterprise, ALThe pilot's delayed flare on landing that resulted in a hard landing.Aug 9, 2002 · N73461 · Substantial damageNTSB NYC02LA158Accident · No injuriesLimited investigationFinal reportCessna R182 · Reading, PASeparation of a hydraulic line from its landing gear motor fitting.Aug 8, 2002 · N21PL · Substantial damageNTSB NYC02LA156Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cincinnati, OHThe pilot's misjudgment of distance which resulted in the airplane landing short of the runway.Aug 8, 2002 · N95915 · Substantial damageNTSB MIA02LA156Accident · No injuriesLimited investigationFinal reportAviat A1 · Merritt Island, FLThe pilot's failure to maintain directional control during the landing rollout while landing in a crosswind which resulted in the airplane inadvertently veering off the runway and incurring damage when the pilot forced it into a ground loop to avoid entry…Aug 8, 2002 · N13HU · Substantial damageNTSB ANC02LA124Accident · No injuriesLimited investigationFinal reportWilliamson GlaStar · Anchorage, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors in the accident were the pilot's inadequate compensation for the crosswind condition, and the misjudged landing flare.Aug 8, 2002 · N62849 · Substantial damageNTSB IAD02LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Mount Pocono, PAThe pilot's improper flare, which resulted in a hard landing.Aug 7, 2002 · N1727V · Substantial damageNTSB CHI02LA249Accident · Minor injuriesLimited investigationFinal reportGoode Acro Sport I · Carbondale, ILThe unsuitable landing area selected by the pilot and his lack of total experience in the accident airplane. The gusting winds were a contributing factor.Aug 7, 2002 · N65701 · Substantial damageNTSB ATL02LA153Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Memphis, TNThe pilot's decision to make a precautionary landing to an unsuitable sod airstrip that resulted in a ground loop. A factor was tall vegetation.Aug 6, 2002 · N3164E · Substantial damageNTSB ATL02LA151Accident · No injuriesLimited investigationFinal reportCessna 172M · Dahlonega, GAThe pilot's improper recovery from a bounced landing and failure to maintain directional control resulting in the airplane going off the left side of the runway and colliding with a ditch.Aug 5, 2002 · N8954V · Substantial damageNTSB ANC02LA091Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Chickaloon, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane impacting rough terrain. A factor contributing to the accident was the rough/uneven terrain condition.Aug 5, 2002 · N9255D · Substantial damageNTSB DEN02LA088Accident · No injuriesLimited investigationFinal reportCessna 172S · Englewood, COthe instructor's inadequate supervision of the flight and his premature raising of the flaps, resulting in a hard landing.Aug 4, 2002 · N238SP · Substantial damageNTSB DEN02LA087Accident · No injuriesLimited investigationFinal reportCessna R172K · Monticello, UTthe student pilot's failure to maintain aircraft control during landing flare, which resulted in a hard landing. Contributing factors include the porpoise and subsequent bounced landing and the student pilot's lack of total experience.Aug 4, 2002 · N758AR · Substantial damageNTSB SEA02LA143Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Quincy, WAThe pilot's failure to maintain the proper descent rate during the descent for landing. A proper glide path was not attained, inadequate remedial action, and a fence were factors.Aug 3, 2002 · N3766X · Substantial damageNTSB SEA02LA142Accident · Minor injuriesLimited investigationFinal reportKaminski RAF 2000 · Newberg, ORThe pilot's inadequate compensation (excessive altitude) for crosswind conditions resulting in the gyroplane's rotors contacting the ground. Contributing factors were the gusty crosswind conditions.Aug 3, 2002 · N73GK · Substantial damageNTSB NYC02LA157Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Atlantic City, NJThe pilot's improper flare during approach.Aug 3, 2002 · N44EK · Substantial damageNTSB CHI02LA230Accident · No injuriesLimited investigationFinal reportErcoupe G · Palmyra, WIFailure by the pilot-in-command to properly compensate for the wind conditions, as well as an improper landing flare. Contibuting factors were the inadequate supervision by the flight instructor and the wind gusts.Aug 3, 2002 · N94431 · Substantial damageNTSB LAX02LA244Accident · No injuriesLimited investigationFinal reportCessna 182P · Mokelumne Hill, CAThe pilot's failure to maintain the proper glidepath and failure to follow the manufacturer's recommended flap setting of 40 degrees, which resulted in an undershoot short of the runway. Factors include the runway's upslope and short length, which likely…Aug 2, 2002 · N8290G · Substantial damageNTSB LAX02FA247Accident · 2 fatalField investigationFinal reportBeech 58TC · Avalon, CAthe pilot's misjudged distance and speed during the landing approach, which resulted in an overrun of the runway. Also causal was the pilot's failure to conduct a go-around during the approach, or abort the landing when an overrun became obvious.Aug 2, 2002 · N2102L · DestroyedNTSB ANC02LA089Accident · No injuriesLimited investigationFinal reportHelio H-295 · Fort Yukon, AKThe failure of the axle shaft, which resulted in the separation of the right main tire/wheel from the airplane on landing.Aug 2, 2002 · N50718 · Substantial damageNTSB ANC02LA088Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which precipitated an aborted landing, and subsequent collision with trees.Aug 2, 2002 · N53828 · Substantial damageNTSB SEA02LA147Accident · No injuriesLimited investigationFinal reportCessna 177B · Elma, WAThe pilot's failure to maintain directional control during a bounced landing and recovery resulting in the aircraft's departing the runway. Contributing factors were the high brush/vegetation the aircraft rolled into and the pilot's reduced visual acquisition…Aug 1, 2002 · N34633 · Substantial damageNTSB LAX02LA245Accident · No injuriesLimited investigationFinal reportCessna 170B · St. Johns, AZthe pilot's selection of the wrong runway for the existing crosswind condition and his subsequent inadequate compensation for the winds, which led to a failure to maintain directional control and a ground loop.Aug 1, 2002 · N2233D · Substantial damageNTSB CHI02LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Belleville, ILDirectional control not obtained/maintained by the pilot during landing.Aug 1, 2002 · N8137S · Substantial damageNTSB CHI02LA226Accident · No injuriesLimited investigationFinal reportGiroux Air Cam · Ozawkie, KSThe pilot's delay in aborting the landing. A contributing factor was the excessive airspeed.Aug 1, 2002 · N1029G · Substantial damageNTSB ATL02LA149Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Ft. Lauderdale, FLPilot in command failed to maintain directional control of the airplane during the landing roll that resulted in a ground loop and the overload failure of the right main landing gear.Aug 1, 2002 · N957T · Substantial damageNTSB ATL02LA148Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Burnsville, NCThe pilot misjudged distance and speed, and did not attain the proper touchdown point during landing, resulting in an overrun of the runway.Aug 1, 2002 · N2008X · Substantial damageNTSB ANC02LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chugiak, AKThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control during an aborted landing, which resulted in an in-flight collision with a culvert. A factor associated with the accident was a wind gust.Aug 1, 2002 · N4948 · Substantial damageNTSB SEA02LA140Accident · Minor injuriesLimited investigationFinal reportBlanik L-13 · Belgrade, MTThe glider pilot's improper in-flight planning decision and his failure to attain the proper touchdown point. Contributing to the accident were the inadvertent activation of the speed brakes, the pilot's failure to maintain altitude, the high vegetation and…Jul 31, 2002 · N70741 · Substantial damageNTSB NYC02LA150Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Ravenna, OHThe pilot's loss of directional control for undetermined reasons.Jul 31, 2002 · N759BC · Substantial damageNTSB SEA02LA139Accident · No injuriesLimited investigationFinal reportCessna R182 · Puyallup, WARestricted movement of the left main landing gear resulting in the gear not extending for the landing. A misaligned brake line was a factor.Jul 30, 2002 · N7592Y · Substantial damageNTSB NYC02LA149Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Madison Heights, VAThe pilot's failure to attain the proper touchdown point on the helipad, which resulted in a rollover. A factor in this accident was pilot fatigue.Jul 30, 2002 · N8347Y · Substantial damageNTSB ANC02LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKThe pilot's inadequate compensation for wind conditions during the landing roll, resulting in a nose over. A factor associated with the accident was a wind gust.Jul 29, 2002 · N8995D · Substantial damageNTSB LAX02LA239Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Prescott, AZthe student pilot's failure to maintain adequate main rotor rpm, the CFI's delayed remedial action and inadequate supervision of the flight, resulting in a hard landing. Wind gusts and the high density altitude were factors in the accident.Jul 27, 2002 · N232DR · Substantial damageNTSB LAX02LA238Accident · No injuriesLimited investigationFinal reportCessna T210F · Willits, CAthe student pilot's misjudged, distance, and speed, and failure to attain the proper touchdown point.Jul 27, 2002 · N6776R · Substantial damageNTSB CHI02LA216Accident · Serious injuriesLimited investigationFinal reportAerostar International S-77A · Custer, SDThe pilot of the balloon did not maintain aircraft control. Factors contributing to the accident include the variable winds and the inadequate compensation for the wind conditions by the pilot in command.Jul 27, 2002 · N2867W · No damageNTSB DEN02LA081Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Two Buttes, COthe failure of the right main landing wheel master brake cylinder and the subsequent inadvertent ground loop during the landing roll by the pilot.Jul 24, 2002 · N5416 · Substantial damageNTSB SEA02LA136Accident · No injuriesLimited investigationFinal reportStearman C3-R · Arlington, WAThe pilot's inadequate remedial action when responding to the swerve/veer of the tailwheel equipped aircraft, leading to a failure to maintain directional control during the landing roll. Factors include the pilot’s lack of experience in the make and model…Jul 23, 2002 · N656K · Substantial damageNTSB MIA02LA138Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · Trenton, GAThe failure of the pilot to clear the engine during a prolonged approach at idle power resulting in the engine hesitating during application of power to arrest the descent for landing touchdown resulting in a hard landing and separation of the left main…Jul 23, 2002 · N10550 · Substantial damageNTSB LAX02LA236Accident · No injuriesLimited investigationFinal reportCessna TR182 · Yuma, AZthe pilot's failure to properly verify that the landing gear was in the down and locked position.Jul 23, 2002 · N756EV · Substantial damageNTSB DEN02LA095Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Lehi, UTthe pilot's inadequate in-flight planning resulting in the glider impacting terrain short of the runway, and the pilot's subsequent abrupt handling of the glider when it became airborne again, which resulted in a hard second landing. A contributing factor was…Jul 23, 2002 · N48038 · DestroyedNTSB CHI02LA225Accident · No injuriesLimited investigationFinal reportCessna 140 · Cook, MNThe pilot's failure to maintain directional control of the airplane during the landing roll.Jul 23, 2002 · N2070N · Substantial damageNTSB ANC02LA081Accident · No injuriesLimited investigationFinal reportMBB BO-105S · Deadhorse, AKThe pilot's failure to correct a settling-with-power condition during a helicopter landing flare/touchdown, resulting in a hard landing and roll over.Jul 23, 2002 · N491HL · Substantial damageNTSB NYC02LA144Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Zelienople, PAThe pilot failure to follow the published aborted landing procedures, with the retraction of the flaps to 10 degrees prior to reaching a safe altitude and airspeed, which resulted in an uncontrolled descent.Jul 22, 2002 · N732AK · Substantial damageNTSB FTW02LA219Accident · No injuriesLimited investigationFinal reportSchempp-Hirth K.G. Nimbus-2C · Briggs, TXthe pilot's failure to maintain clearance with the high grass during the landing roll, which resulted in a ground loop.Jul 21, 2002 · N141SF · Substantial damageNTSB DEN02TA078Accident · No injuriesFinal reportCessna 182R · Englewood, COthe pilot-in-command's improper flare resulting in a hard landing. Contributing factors were the pilot's improper remedial action, and the second pilot's inadequate monitoring of the flight.Jul 21, 2002 · N6271N · Substantial damageNTSB CHI02FA200Accident · No injuriesField investigationFinal reportPiper PA-20 · Oshkosh, WIInadequate visual lookout by both the accident pilot and the pilot of the other airplane. An additional cause is the arrival procedure used which resulted in a congested traffic pattern and the subsequent inadequate visual separation of the airplanes. Factors…Jul 21, 2002 · N1592A · Substantial damageNTSB CHI02CA214Accident · No injuriesData collectionFinal reportCessna 182A · Laretto, MNThe pilot's improper flare.Jul 21, 2002 · N6321B · Substantial damage