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 CHI04CA121Accident · No injuriesData collectionFinal reportCessna 172C · Fort Leavenwort, KSThe inadequate flare by the pilot.May 15, 2004 · N1806Y · Substantial damageNTSB NYC04CA125Accident · No injuriesData collectionFinal reportCessna 150 · Sacramento, KYThe pilot's improper decision to land with a tailwind, and his inadequate compensation for the wind conditions. A factor was the tailwind.May 14, 2004 · N7795E · Substantial damageNTSB LAX04CA209Accident · No injuriesData collectionFinal reportCessna 180 · Kingman, AZthe pilot under instruction's excessive and improper use of the rudder control during the landing roll and the flight instructor's inadequate supervision, which resulted in an inadvertent ground loop and nose over.May 14, 2004 · N6430X · Substantial damageNTSB SEA04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Shelton, WAThe pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.May 13, 2004 · N1829P · Substantial damageNTSB LAX04LA206Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Carson City, NVthe pilot's failure to maintain directional control during an aborted touch-and-go landing.May 13, 2004 · N7584W · Substantial damageNTSB ATL04CA115Accident · Minor injuriesData collectionFinal reportLoehle Ent. 2/3 Earlybird Jenny · Grantham, NCThe loss of engine power for undetermined reasons.May 13, 2004 · N112PE · Substantial damageNTSB NYC04CA132Accident · Minor injuriesData collectionFinal reportAviat A-1B · Halifax, MAThe pilot's inadequate flare during landing, which resulted in an in-flight collision with water. A factor was the glassy water conditions.May 12, 2004 · N17MR · Substantial damageNTSB SEA04LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Battle Ground, WAThe student pilot's misjudgment of distance and his failure to do a go-around. Also causal was the instructor's inadequate supervision of the flight. Factors include gusty crosswinds, the dual student's failure to adequately compensate for those winds, a wet…May 10, 2004 · N54477 · Substantial damageNTSB DCA04MA045Accident · Serious injuriesClass 1 · MajorFinal reportATR 72 · San Juan, PRthe captain's failure to execute proper techniques to recover from the bounced landings and his subsequent failure to execute a go-around.May 9, 2004 · N438AT · DestroyedNTSB SEA04LA196Accident · No injuriesLimited investigationFinal reportDornier DO27A4 · Marion, MTThe pilot's improper landing flare resulting in a hard landing.May 8, 2004 · N276MK · Substantial damageNTSB MIA04LA081Accident · No injuriesLimited investigationFinal reportBeech A23A · Crystal River, FLThe pilots failure to maintain directional control during the landing rollout, which resulted in the airplane departing the runway and incurring damage.May 8, 2004 · N3659Q · Substantial damageNTSB CHI04CA116Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Genesee Depot, WIThe pilot's failure to maintain proper rotor RPM during the hover landing and his inadequate remedial action, which resulted in the hard landing.May 8, 2004 · N215WW · Substantial damageNTSB FTW04LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Many, LAThe pilot's improper touchdown which resulted in a hard landing.May 7, 2004 · N21131 · Substantial damageNTSB NYC04CA121Accident · No injuriesData collectionFinal reportCessna 152 · Pottstown, PAThe student pilot's failure to maintain directional control during landing, and the flight instructor's delayed remedial action.May 6, 2004 · N94577 · Substantial damageNTSB ATL04LA109Accident · 1 fatalLimited investigationFinal reportBergmann Rans S-12 XL Airaile · Cummings, GAThe unqualified person's poor judgement and his failed to maintain clearance from power lines and trees while maneuvering for a landing which resulted in the in-flight collision with trees and power lines. Factors were the dark night and the unqualified…May 6, 2004 · N8KD · Substantial damageNTSB ANC04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kasilof, AKThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were a downdraft, and an embankment.May 6, 2004 · N2521S · Substantial damageNTSB ATL04CA113Accident · No injuriesData collectionFinal reportCessna 172N · Odessa, FLThe pilot's improper landing flare that resulted in a hard landing.May 4, 2004 · N737HW · Substantial damageNTSB LAX04LA199Accident · No injuriesLimited investigationFinal reportCessna 195 · Riverside, CAthe pilot's failure to maintain directional control, resulting in a veer off the runway and collision with terrain.May 1, 2004 · N195AF · Substantial damageNTSB LAX04CA200Accident · No injuriesData collectionFinal reportCessna 182K · Phoenix, AZthe pilot's inadequate flare, which resulted in a hard landing. Also causal was the pilot's inadequate recovery from a bounced landing, which resulted in an inadvertent porpoise and collision with a sign.May 1, 2004 · N2493Q · Substantial damageNTSB CHI04CA113Accident · Minor injuriesData collectionFinal reportCessna 172K · Harrisonville, MOThe dual student's failure to maintain directional control of the aircraft during the landing flare. Contributing factors were the dual student's failure to relinquish the controls to the flight instructor, the resulting inability of the flight instructor to…May 1, 2004 · N7448G · Substantial damageNTSB NYC04CA114Accident · Minor injuriesData collectionFinal reportCessna 305 A · Taunton, MAThe pilots inadequate pre-flight planning which resulted in a landing on soft terrain and subsequent nose over. A factor was the soft terrain.Apr 30, 2004 · N2070E · Substantial damageNTSB NYC04CA113Accident · No injuriesData collectionFinal reportCessna C-152 · Columbus, OHThe student pilot's improper flare, and inadequate recovery from a bounced landing, which resulted in a hard landing.Apr 30, 2004 · N70SU · Substantial damageNTSB SEA04LA075Accident · No injuriesLimited investigationFinal reportPiper PA-20 · North Bend, WAThe pilot's failure to maintain aircraft control during the landing roll. A rough landing surface and tailwind gusts were factors.Apr 29, 2004 · N7631K · Substantial damageNTSB NYC04CA115Accident · No injuriesData collectionFinal reportMooney M20C · Front Royal, VAThe pilot's failure to maintain directional control during an aborted landing. A factor in this accident was the crosswind conditions.Apr 29, 2004 · N99NH · Substantial damageNTSB ATL04CA101Accident · No injuriesData collectionFinal reportBeech D95A · Athens, GAThe pilot's misjudgment of airspeed and distance which resulted in an overshoot of the runway and collision with ground. The tailwind was a factor.Apr 29, 2004 · N7908M · Substantial damageNTSB ATL04CA102Accident · No injuriesData collectionFinal reportPiper PA-18 · Cedartown, GAThe pilot's improper use of brakes during landing roll which resulted in the airplane nosing over.Apr 28, 2004 · N271T · Substantial damageNTSB LAX04CA198Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Squaw Valley, CAthe pilot's failure to maintain a proper descent rate during the landing approach, which resulted in a hard landing and roll over. Also causal was the pilot's inadequate compensation for tailwind conditions. A factor in the accident was the high density…Apr 27, 2004 · N7521P · Substantial damageNTSB FTW04LA117Accident · No injuriesLimited investigationFinal reportBell 407 · Hurst, TXThe student pilot's excessive flare prior to touchdown during the practice autorotation which resulted in the tailboom stinger striking the ground. A contributing factor was the flight instructor's delay to take remedial action.Apr 27, 2004 · N407BP · Substantial damageNTSB CHI04CA111Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Rochester, MNThe pilot's failure to maintain control of the helicopter during landing. Contributing factors were the aircraft's low altitude and the pilot's limited flight experience.Apr 27, 2004 · N40725 · Substantial damageNTSB ANC04LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · Skwentna, AKThe pilot's selection of an unsuitable landing site, which resulted in a nose over during the landing roll.Apr 26, 2004 · N4861D · Substantial damageNTSB LAX04LA195Accident · No injuriesLimited investigationFinal reportSpirangam Velocity · Boulder City, NVthe pilot's failure to maintain directional control of the airplane during the landing rollout.Apr 25, 2004 · N216MR · Substantial damageNTSB LAX04CA215Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Galt, CAthe pilot under instruction's failure to maintain an adequate airspeed on final and misjudged flare, which resulted in stall/mush and hard landing. The certified flight instructor's inadequate supervision and failure to initiate timely remedial action were…Apr 25, 2004 · N169JP · Substantial damageNTSB SEA04LA072Accident · No injuriesLimited investigationFinal reportCessna 170B · Nampa, IDThe right seat pilot's failure to maintain directional control during the initial part of the landing roll, and his improper handling of the aircraft (excessive braking) as the aircraft departed the side of the runway. Factors include the pilot's lack of…Apr 23, 2004 · N8252A · Substantial damageNTSB FTW04LA118Accident · No injuriesLimited investigationFinal reportCessna 182U · Boerne, TXThe pilot's inattentive planned approach to land on a runway with obstructions.Apr 22, 2004 · N7435Q · Substantial damageNTSB NYC04CA110Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Willoughby, OHThe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the gusty wind conditions associated with thunderstorm activity.Apr 21, 2004 · N497MA · Substantial damageNTSB DEN04CA066Accident · No injuriesData collectionFinal reportCessna 182K · Durango, COthe pilot's inadequate in-flight planning and decision making. Contributing factors include the crosswind and the crosswind component exceeded.Apr 21, 2004 · N2861R · Substantial damageNTSB LAX04LA297Accident · No injuriesLimited investigationFinal reportAviat A-1A · Visalia, CAthe pilot's failure to maintain an adequate airspeed on final approach, which resulted in an inadvertent stall and a hard landing.Apr 20, 2004 · N40AW · Substantial damageNTSB LAX04LA201Accident · No injuriesLimited investigationFinal reportCessna U206A · Lake Havasu, AZThe pilot's misjudged flare during landing, which resulted in a hard landing and structural damage to the firewall.Apr 19, 2004 · N4941F · Substantial damageNTSB LAX04LA192Accident · No injuriesLimited investigationFinal reportAeronca Champ 7AC · Hayward, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.Apr 19, 2004 · N83587 · Substantial damageNTSB LAX04CA189Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Minden, NVthe pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control of the airplane, resulting in a collision with terrain.Apr 18, 2004 · N6062D · Substantial damageNTSB SEA04LA070Accident · No injuriesLimited investigationFinal reportCessna 195 · Everett, WAThe pilot's failure to maintain directional control of the aircraft as a result of a locked main gear brake during the landing roll. An inadvertent ground loop was a factor.Apr 17, 2004 · N127DD · Substantial damageNTSB MIA04CA077Accident · No injuriesData collectionFinal reportCessna 172S · Key West, FLThe pilot's failure to maintain directional control while landing in gusty wind conditions which resulted in the airplane departing the runway and impacting a sign, incurring damage.Apr 17, 2004 · N5280D · Substantial damageNTSB LAX04LA194Accident · No injuriesLimited investigationFinal reportCessna 205 · Page, AZthe fatigue fracture and separation of the pilot's control wheel, which resulted in a momentary loss of control and a hard landing.Apr 17, 2004 · N1815Z · Substantial damageNTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.Apr 17, 2004 · N6715X · Substantial damageNTSB MIA04LA087Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air 4000 · Port St. Lucie, FLThe pilot's failure to maintain directional control during landing, which resulted in an inadvertent swerve, the right main landing gear wheel separating, and the airplane impacting trees and incurring structural damage.Apr 16, 2004 · N6425 · Substantial damageNTSB MIA04LA072Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5B · Lakeland, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in the airplane departing the right side of the runway, collapsing the left main landing gear, the left wing striking the ground, and the airplane…Apr 15, 2004 · N31443 · Substantial damageNTSB DEN04CA061Accident · No injuriesData collectionFinal reportRobinson R22 · Nephi, UTthe flight instructor's failure to maintain control of the helicopter resulting in a hard landing.Apr 14, 2004 · N555UH · Substantial damageNTSB LAX04CA186Accident · No injuriesData collectionFinal reportCessna 172S · Long Beach, CAthe student pilot's inadequate flare, which resulted in a hard landing and porpoise.Apr 13, 2004 · N669SP · Substantial damageNTSB LAX04CA185Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Grass Valley, CAthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Factors in the accident were wind gusts and tailwind/crosswind conditions.Apr 12, 2004 · N39515 · Substantial damageNTSB LAX04CA183Accident · No injuriesData collectionFinal reportCessna 182C · Garberville, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control of the airplane. Factors in the accident were the terrain induced turbulent conditions, wind shear, a sudden wind shift, and a tailwind.Apr 12, 2004 · N8872T · Substantial damage