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 ANC05CA011Accident · No injuriesData collectionFinal reportChampion 7FC · Talkeetna, AKThe instructor pilot's inadequate supervision of the student, which resulted in a loss of control during the landing roll, and subsequent nose over.Oct 30, 2004 · N4851E · Substantial damageNTSB DEN05LA022Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pueblo, COThe pilot’s inadequate compensation for wind and his failure to maintain aircraft control which resulted in a gear collapse due to an on-ground collision with terrain. Contributing factors were the wind shear, gusty wind conditions, and rough terrain. This…Oct 29, 2004 · N203RF · Substantial damageNTSB ANC05CA013Accident · No injuriesData collectionFinal reportCessna 185 · Skwentna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over during the landing roll. A factor associated with the accident was deep wet snow.Oct 29, 2004 · N185CQ · Substantial damageNTSB LAX05CA017Accident · No injuriesData collectionFinal reportCessna 152 · Imperial, CAthe student pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane veering off of the runway surface and nosing over.Oct 26, 2004 · N4734B · Substantial damageNTSB DFW05CA011Accident · No injuriesData collectionFinal reportPiper PA-28 · Abilene, TXThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the wet runway surface and rain.Oct 26, 2004 · N9284J · Substantial damageNTSB NYC05CA011Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lehighton, PAThe pilot inadequate flare, and failure to recover from a bounced landing.Oct 23, 2004 · N586FL · Substantial damageNTSB ATL05CA015Accident · No injuriesData collectionFinal reportCessna 172SP · West Columbia, SCThe student pilot's improper landing flare, inadequate recovery from a bounced landing and failure to maintain directional control during rollout. A factor was the runway sign.Oct 20, 2004 · N37CJ · Substantial damageNTSB MIA05CA009Accident · Serious injuriesData collectionFinal reportRobinson R-22 · Vega Baja, PRThe pilot's failure to select a suitable landing area resulting in a tangled skid with vegetation during an aborted landing and subsequent dynamic roll over.Oct 19, 2004 · N2314T · Substantial damageNTSB CHI05CA010Accident · No injuriesData collectionFinal reportBeech B-55 · Chesterfield, MOThe diverted attention and the inadequate flare by the pilot during landing.Oct 19, 2004 · N558B · Substantial damageNTSB LAX05LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's misjudged distance/altitude and inadequate flare that resulted in a hard landing, and a porpoise down the runway. Also causal was the student pilot's improper bounced landing recovery technique.Oct 17, 2004 · N5272H · Substantial damageNTSB ATL05CA006Accident · No injuriesData collectionFinal reportCessna 177 · Auburn, ALThe pilot's improper landing flare resulting in a hard landing. A factor was the pilot's diverted attention.Oct 17, 2004 · N29459 · Substantial damageNTSB ATL05CA004Accident · Serious injuriesData collectionFinal reportLuscombe LL-8 · Jasper, GAThe pilot's excessive braking during landing roll resulted in a nose over.Oct 17, 2004 · N1491K · Substantial damageNTSB ANC05LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Chickaloon, AKThe pilot's failure to maintain directional control of the airplane, which resulted in a collision with terrrain during the landing roll. Factors contributing to the accident were a rough/rutted and snow-covered airstrip surface, and an inadvertent ground…Oct 17, 2004 · N5057Y · Substantial damageNTSB CHI05CA007Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Port Austin, MIThe pilot's excessive airspeed during landing resulting in the airplane exiting the end of the wet turf runway. Factors were the wind gusts, the wet grass, the reported airplane braking not being possible on the wet grass, and the impacted fence.Oct 16, 2004 · N555MN · Substantial damageNTSB DFW05CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Reserve, LAThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the strong crosswind.Oct 15, 2004 · N88390 · Substantial damageNTSB LAX05CA006Accident · Minor injuriesData collectionFinal reportCessna 182RG · Placerville, CAthe pilot's misjudged distance and speed, and failure to attain the proper touchdown point, which resulted in the airplane overrunning the runway surface and nosing over after encountering soft terrain.Oct 14, 2004 · N6071C · Substantial damageNTSB DFW05CA005Accident · Minor injuriesData collectionFinal reportMurray DA5B · Odessa, TXThe pilot's improper recovery from a bounced landing. A contributing factor was the unsuitable terrain for landing.Oct 13, 2004 · N1002W · Substantial damageNTSB DFW05CA003Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Coahoma, TXThe pilot's failure to maintain directional control during landing. A contributing factor was the lack of suitable terrain for landing.Oct 13, 2004 · N8886S · Substantial damageNTSB LAX05CA005Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Winslow, AZthe pilot's failure to maintain directional control during the landing rollout that resulted in a ground loop.Oct 12, 2004 · N50338 · Substantial damageNTSB ANC05LA010Accident · No injuriesLimited investigationFinal reportEurocopter France AS-350B2 · Ketchikan, AKThe pilot's failure to maintain clearance from an object while landing, which resulted in the main rotor blades striking a tree.Oct 12, 2004 · N166EH · Substantial damageNTSB DEN05CA010Accident · Serious injuriesData collectionFinal reportAerostar International S-60S · Albuquerque, NMthe passenger striking the pilot's leg during the landing, resulting in a fractured leg.Oct 10, 2004 · N6377C · No damageNTSB DFW05CA002Accident · No injuriesData collectionFinal reportBalloon Works Firefly 8B-15 · Piedmont, OKThe pilot's failure to maintain clearance with power lines while landing. Contributing factors were the reduced visibility, fog, and low cloud ceiling.Oct 9, 2004 · N2563W · DestroyedNTSB DEN05CA007Accident · No injuriesData collectionFinal reportMooney M20E · Broomfield, COthe pilot's improper flare and recovery from a bounced landing during a touch and go maneuver. Contributing factors were the excessive airspeed and descent rate during the approach.Oct 8, 2004 · N14DV · Substantial damageNTSB CHI05CA003Accident · No injuriesData collectionFinal reportSinclair Zenith 701 · Augusta, KSThe manufacturer's inadequate design/production of the landing gear axle leading to its separation and the airplanes subsequent nose over during the landing roll.. A factor was the axle's separation from its spring.Oct 8, 2004 · N701TD · Substantial damageNTSB ANC05LA001Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe inadequate and unapproved design of the main landing gear assembly by the manufacturer, which resulted in a failure of the main landing gear during landing, and structural damage to the airplane. A factor in the accident was the pilot's misjudged flare.Oct 8, 2004 · N5760D · Substantial damageNTSB DEN05LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Casper, WYthe student pilot's improper flare resulting in a hard landing. A factor contributing to the accident was the student pilot's improper recovery from the bounced landing.Oct 7, 2004 · N73764 · Substantial damageNTSB FTW05CA002Accident · No injuriesData collectionFinal reportThunder and Colt AA-1050 · Crescent, OKThe pilot's failure to maintain clearance from the high power transmission lines. Contributing factor was the dark night and high wind conditions.Oct 4, 2004 · G-BSRJ · DestroyedNTSB SEA05CA003Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Medford, ORThe pilot's inadequate compensation for crosswind conditions during landing, resulting in his failure to maintain directional control. Factors include the presence of crosswinds.Oct 2, 2004 · N2849Z · Substantial damageNTSB MIA05CA002Accident · Minor injuriesData collectionFinal reportRobinson R-22 · Pompano Beach, FLThe flight crew's excessive descent rate during landing, resulting in a hard landing, and the tail boom being severed.Oct 2, 2004 · N220CK · Substantial damageNTSB DEN05CA001Accident · No injuriesData collectionFinal reportCessna 185F · Santa Fe, NMthe pilot's failure to maintain aircraft control during the landing roll resulting in a ground loop. Contributing to the accident was the crosswind.Oct 1, 2004 · N714MX · Substantial damageNTSB DEN04LA150Accident · No injuriesLimited investigationFinal reportCessna 172S · Broomfield, COthe pilot's improper flare, and the flight instructor's inadequate supervision of the pilot.Sep 30, 2004 · N802SP · Substantial damageNTSB CHI04CA289Accident · No injuriesData collectionFinal reportArganbright Vans RV-4 · Custer, SDThe pilot's failure to maintain directional control during the landing. Factors were the sudden wind shift and the embankment.Sep 29, 2004 · N968MA · Substantial damageNTSB CHI04CA286Accident · No injuriesData collectionFinal reportCessna C-150J · Oxford, IAThe student pilot's failure to attain a proper glidepath which resulted in exceeding the proper touchdown point. An additional cause was his failure to abort the landing. The embankment was a factor.Sep 29, 2004 · N61111 · Substantial damageNTSB ATL04CA196Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Charlotte, NCThe pilot's misjudgment of speed and distance resulting in an overrun and collision with trees.Sep 29, 2004 · N41985 · Substantial damageNTSB ANC04CA116Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Talkeetna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was tundra.Sep 28, 2004 · N3685Z · Substantial damageNTSB SEA04CA194Accident · No injuriesData collectionFinal reportCessna 152 · Friday Harbor, WAThe pilot's delay in executing an aborted landing and his failure to obtain altitude/clearance from trees during the aborted landing. A factor was the pilot's failure to obtain the proper touchdown point as a result of his high airspeed on approach.Sep 27, 2004 · N757RD · Substantial damageNTSB DEN04LA148Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Broomfield, COthe pilot's improper in-flight planning/decision to accept a short traffic pattern and the improper flare resulting in a hard landing.Sep 26, 2004 · N200FF · Substantial damageNTSB CHI04CA287Accident · No injuriesData collectionFinal reportCessna 182P · Washington, MOThe misjudged flare by the student pilot and the inadequate supervision by the flight instructor. A factor was the overload failure of the nose landing gear.Sep 25, 2004 · N4637K · Substantial damageNTSB ANC04CA114Accident · No injuriesData collectionFinal reportde Havilland DHC-2 · Willow, AKThe pilot's selection of an unsuitable landing area, which resulted in an on-ground collision with trees during the landing roll. A factor associated with the accident were trees.Sep 25, 2004 · N1018D · Substantial damageNTSB NYC04CA216Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4-200 · New Milford, CTThe pilot's improper flair, which resulted in a nose over.Sep 24, 2004 · N44LD · Substantial damageNTSB SEA04CA193Accident · No injuriesData collectionFinal reportPiper PA-28 · Deer Harbor, WAThe pilot's failure to perform remedial action during the landing sequence. A factor contributing to the accident was the wet runway surface.Sep 23, 2004 · N56775 · Substantial damageNTSB FTW04CA240Accident · No injuriesData collectionFinal reportCarter-Jones Volmer Sportsman · Grand Prarie, TXThe pilot's failure to complete a pre-landing checklist, which resulted in a gear down landing on the water. A factor was the pilot's diverted attention as a result of abnormal engine indications.Sep 23, 2004 · N70HR · Substantial damageNTSB CHI04CA281Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jackson, MICollision with a deer when it crossed the airplane's path during landing rollout. Factors were low lighting (night) conditions and the pilot's inability to maintain directional control due to the collision.Sep 23, 2004 · N98222 · Substantial damageNTSB DCA04MA082Accident · No injuriesMajor investigationFinal reportBoeing MD-11 · Memphis, TNThe pilot's over-rotation during a go-around maneuver initiated because of a bounced landing. The go-around maneuver was initiated at a low speed and high pitch angle, and after reverse thrust was selected, contrary to Boeing and FedEx training guidance.Sep 19, 2004 · N601FE · Substantial damageNTSB LAX04CA321Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Kona, HIthe CFI's failure to maintain an adequate airspeed and main rotor rpm, and his improper flare, which resulted in a hard landing. A factor in the accident was the CFI's diverted attention.Sep 18, 2004 · N22XM · Substantial damageNTSB CHI04CA296Accident · No injuriesData collectionFinal reportPiper PA-16 · Port Huron, MIThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the overload failure of the right main landing gear.Sep 18, 2004 · N5891H · Substantial damageNTSB ANC04LA117Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Telida, AKA failure of the pilot-in-command to extend the landing gear, which resulted in a gear-up landing and structural damage to the airplane.Sep 17, 2004 · N41185 · Substantial damageNTSB DEN04CA143Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta 2 · Spanish Fork, UTthe pilot's failure to maintain adequate rotor rpm during a practice autorotation, and the flight instructor's improper flare. A contributing factor was the instructor's inadequate supervision of the pilot.Sep 16, 2004 · N7533E · Substantial damageNTSB NYC04LA213Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Somerville, NJThe pilot's failure to maintain aircraft control while landing. A factor was the pilot's impairment due to the influence of non-prescribed pain medication.Sep 15, 2004 · N29BF · Substantial damageNTSB NYC04LA209Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Oxford, CTThe pilot's improper recovery from a bounced landing.Sep 12, 2004 · N579AL · Substantial damage