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 LAX03LA293Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Georgetown, CAthe pilot's misjudged speed and distance, and his failure to perform a go-around which resulted in a runway overrun.Sep 20, 2003 · N9921B · Substantial damageNTSB SEA03LA191Accident · No injuriesLimited investigationFinal reportLevick RAF 2000 GTX-SE · Bonners Ferry, IDThe pilot's inadequate compensation for gusty wind conditions and his failure to maintain directional control, which resulted in the gyrocraft departing the runway and the main rotor impacting the ground. A contributing factor was wind gusts.Sep 19, 2003 · N24DN · Substantial damageNTSB FTW03FA229Accident · 1 fatalField investigationFinal reportLearjet 25B · Del Rio, TXThe pilot's misjudged distance and speed during the approach to landing, and his failure to obtain the proper touchdown point resulting in an overrun. A contributing factor was the pilot's failure to abort the landing.Sep 19, 2003 · N666TW · DestroyedNTSB SEA03LA193Accident · No injuriesLimited investigationFinal reportCessna A150K · Medford, ORThe student pilot's failure to maintain directional control of the aircraft during the landing roll.Sep 18, 2003 · N8351M · Substantial damageNTSB CHI03LA312Accident · Minor injuriesLimited investigationFinal reportCessna 182P · St. Louis, MOThe pilot's failure to maintain directional control during the landing rollout.Sep 17, 2003 · N9072M · Substantial damageNTSB ATL03LA141Accident · No injuriesLimited investigationFinal reportBellanca CH-300 · Peachtree City, GAThe pilots failure to maintain directional control during landing roll that resulted in a ground loop and subsequent collapse of the main landing gear.Sep 17, 2003 · N796W · Substantial damageNTSB ANC03LA116Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Skwentna, AKThe pilot's misjudgment of the distance/altitude to the touchdown point during landing, which resulted in an undershoot and collision with a river bank. A factor contributing to the accident was the presence of a river bank that formed the beginning of the…Sep 15, 2003 · N3386U · Substantial damageNTSB NYC03LA210Accident · No injuriesLimited investigationFinal reportSimoneau Kitfox Classic IV · Limington, METhe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the pilot's lack of experience in make and model.Sep 14, 2003 · N10224 · Substantial damageNTSB LAX03CA288Accident · No injuriesData collectionFinal reportCessna 172M · Tucson, AZthe pilot's improper flare. A contributing factor was the tailwind.Sep 14, 2003 · N73179 · Substantial damageNTSB LAX03CA286Accident · No injuriesData collectionFinal reportBeech 58 · Kneeland, CApoor braking action due to the undulating runway surface and crumbling asphalt resulting in an on ground encounter with terrain. Contributing to the accident was the necessity for the pilot to fly an increased approach angle due to the trees at the approach…Sep 13, 2003 · N258SJ · Substantial damageNTSB MIA03LA181Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C-1 · Homestead, FLthe inadequate 100-hour inspection of the helicopter by other maintenance personnel who failed to discover that the landing gear dampers had low pressure, which resulted in ground resonance and subsequent substantial damage during a run-on landing.Sep 11, 2003 · N6147Q · Substantial damageNTSB SEA03LA188Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Billings, MTThe pilot's inadequate compensation for wind conditions which led to a loss of control and subsequent ground loop. A contributing factor was the wind gust.Sep 10, 2003 · N9332D · Substantial damageNTSB FTW03LA222Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Porter, TXThe pilot's inadequate compensation for wind conditions and his failure to maintain control of the airplane while landing. A contributing factor was the gusty winds.Sep 10, 2003 · N233S · Substantial damageNTSB CHI03LA317Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Highland, ILThe pilot encountering unsuitable terrain during an off-airport landing. A factor to the accident was the high vegetation.Sep 10, 2003 · N424BG · Substantial damageNTSB CHI03LA308Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Wausau, WIThe excessive free play resulting in a loose tail wheel assembly and a failure of the flight crew to maintain directional control during the landing rollout.Sep 8, 2003 · N5595H · Substantial damageNTSB CHI03LA304Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Atwood, ILThe pilot's failure to correctly identify the location of the airport. Factors to the accident include the pilot flying while fatigued, which contributed to his misidentification of the runway, and the rough/uneven soybean field.Sep 8, 2003 · N615A · Substantial damageNTSB NYC03CA192Accident · No injuriesData collectionFinal reportCessna 152 · Franklin, VAThe student pilot's improper flare, which resulted in a hard landing.Sep 7, 2003 · N4725B · Substantial damageNTSB DEN03LA151Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Taos, NMthe pilot's failure to maintain directional control during landing roll which resulted in the subsequent ground loop/swerve and impact with the ditch.Sep 7, 2003 · N455RT · Substantial damageNTSB ANC03CA110Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Eagle, AKThe pilot's selection of an unsuitable landing area, and his excessive use of the airplane's brakes during the landing roll, resulting in a nose over. A factor associated with the accident was rough and uneven terrain.Sep 7, 2003 · N8597D · Substantial damageNTSB CHI03LA302Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Sikeston, MOThe pilot's inadvertent activation of the brake system during touchdown and his inadequate remedial action, which resulted in the airplane nosing over.Sep 6, 2003 · N19CK · Substantial damageNTSB ANC03LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Koliganek, AKThe pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an inadvertent stall and subsequent collision with terrain.Sep 3, 2003 · N4500W · Substantial damageNTSB LAX03LA275Accident · 2 fatalLimited investigationFinal reportBacon Questair #20 Venture · Carefree, AZThe pilot's misjudgment of speed/distance and his failure to do a go-around. Also causal was the pilot's failure to maintain directional control, and his delay aborting the landing.Sep 2, 2003 · N29G · DestroyedNTSB LAX03CA274Accident · Serious injuriesData collectionFinal reportBell 47D1 · Chino, CAthe student pilot's inappropriate remedial action through the application of excessive aft cyclic during a run-on landing. A factor in the accident was the student's disregard for company procedures.Sep 2, 2003 · N64580 · Substantial damageNTSB CHI03LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIThe student pilot's inadequate recovery from the bounced landing. Factors contributing to the accident were the variable crosswind, the misjudged flare that resulted in the bounced landing and the subsequent collapse of the nose landing gear.Sep 2, 2003 · N757GL · Substantial damageNTSB DEN03LA148Accident · No injuriesLimited investigationFinal reportCessna 150H · Moran, WYthe pilot's selection of an unsuitable takeoff area which resulted in an encounter with the gopher hole during the touch-and-go. Factors contributing to the accident were the gopher hole, the abrupt pull up, the low airspeed, the inadvertent stall mush, the…Sep 1, 2003 · N23108 · Substantial damageNTSB CHI03LA326Accident · No injuriesLimited investigationFinal reportCessna 210 · St. Paul, MNThe pilot in command performing an improper flare.Sep 1, 2003 · N7445E · Substantial damageNTSB IAD03CA072Accident · No injuriesData collectionFinal reportCessna C-170 · Kennebunkport, METhe pilot's failure to obtain the proper touchdown point, which resulted in the abrupt maneuver and subsequent failure of the landing gear.Aug 31, 2003 · N11576 · Substantial damageNTSB NYC03CA185Accident · Minor injuriesData collectionFinal reportCessna 172E · Lemont Furnace, PAThe pilot's improper bounced landing recovery. A factor was the pilot's inadequate flare during the initial touchdown.Aug 30, 2003 · N5628T · DestroyedNTSB CHI03LA295Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Maquoketa, IAThe pilot's excessive use of the brake system, which resulted in directional control not being maintained during the landing. A factor to the accident was the crosswind.Aug 30, 2003 · N1954B · Substantial damageNTSB ANC03LA105Accident · No injuriesLimited investigationFinal reportCessna 170 · Seward, AKThe pilot's selection of unsuitable terrain for landing which resulted in a nose over during the landing roll. A factor contribuiting to the accident was the presence of soft sand.Aug 30, 2003 · N1293D · Substantial damageNTSB SEA03LA181Accident · No injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDThe instructor's inadequate supervision, and the student's failure to maintain directional control.Aug 29, 2003 · N1027X · Substantial damageNTSB NYC03MA183Accident · 2 fatalMajor investigationFinal reportBeech 1900D · Yarmouth, MAThe improper replacement of the forward elevator trim cable, and subsequent inadequate functional check of the maintenance performed, which resulted in a reversal of the elevator trim system and a loss of control in-flight. Factors were the flightcrew's…Aug 26, 2003 · N240CJ · DestroyedNTSB LAX03LA262Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Brownsville, CAThe pilot's improper flare and his failure to maintain directional control. Contributing factors were excessive airspeed, pilot-induced oscillation, and inadequate recovery from a bounced landing.Aug 25, 2003 · N6250A · Substantial damageNTSB LAX03CA264Accident · No injuriesData collectionFinal reportHughes 269C · Columbia, CAthe student pilot's improper execution of the autorotation. Also causal, was the CFI's delayed remedial action and supervision of the flight.Aug 25, 2003 · N58363 · Substantial damageNTSB CHI03LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Deer Grove, ILThe pilot's failure to attain the proper touchdown point, and his failure to execute a go-around.Aug 25, 2003 · N5360B · Substantial damageNTSB CHI03LA285Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Omaha, NEThe pilot not maintaining aircraft control during the landing roll. Factors were the grass the airplane encountered when the airplane ground looped off the runway and the main gear collapsed.Aug 24, 2003 · N37642 · Substantial damageNTSB ANC03LA102Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Kenai, AKThe pilot's inadequate compensation for a crosswind during the landing roll, which resulted in a loss of control and subsequent ground loop. A factor in the accident was a crosswind.Aug 24, 2003 · N513F · Substantial damageNTSB NYC03LA181Accident · No injuriesLimited investigationFinal reportCessna A185F · Marion, OHFatigue and corrosion of the right main landing gear attachment, which resulted in a gear collapse while landing.Aug 23, 2003 · N44222 · Substantial damageNTSB FTW03LA206Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · McKinney, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall during landing. A contributing factor was flaring too high.Aug 23, 2003 · N8730V · Substantial damageNTSB ANC03LA101Accident · No injuriesLimited investigationFinal reportCloud-Wag Aero Sportsmen · Noatak, AKThe pilot's misjudgment of the airplane's distance and speed, which resulted in the airplane not attaining the proper landing touchdown point and overrunning the landing site.Aug 23, 2003 · N35CL · Substantial damageNTSB FTW03CA205Accident · No injuriesData collectionFinal reportCessna 195 · Sand Springs, OKThe pilot's failure to maintain directional control during the landing roll.Aug 22, 2003 · N9882A · Substantial damageNTSB CHI03LA287Accident · No injuriesLimited investigationFinal reportStaudacher S-1000 · Newberry, MIThe pilot's inadequate compensation for the wind conditions, resulting in aircraft control not being maintained during the landing approach. Contributing factors to the accident were the gusting crosswind and the VASI system.Aug 22, 2003 · N6195V · Substantial damageNTSB CHI03LA209Accident · No injuriesLimited investigationFinal reportYoung Cozy MkIV · Quincy, ILThe pilot's improper flare.Aug 22, 2003 · N96PJ · Substantial damageNTSB ATL03LA132Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Camilla, GAThe malfunction (locking) of the left brake piston during the landing roll, which resulted in a loss of control and subsequent nose over.Aug 22, 2003 · N936D · Substantial damageNTSB ANC03LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Glennallen, AKThe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground loop, and collapse of the main landing gear.Aug 22, 2003 · N2608S · Substantial damageNTSB CHI03LA292Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Macon, MOThe pilot's improper use of the rudder, which resulted in directional control not being maintained during the landing. A factor to the accident was the crosswind gust.Aug 21, 2003 · N25342 · Substantial damageNTSB CHI03LA275Accident · No injuriesLimited investigationFinal reportCessna 170 · Neche, NDThe unsuitable terrain encountered during the precautionary landing. Contributing factors to the accident include the pilot becoming lost/disoriented, his decision to perform a precautionary landing, and the soft terrain encountered during landing.Aug 21, 2003 · CFGRD · Substantial damageNTSB ANC03LA098Accident · No injuriesLimited investigationFinal reportAerospatiale SA319B · Whittier, AKThe pilot's encounter with ground resonance during landing, which resulted in an aborted landing and subsequent loss of control of the helicopter.Aug 21, 2003 · N319LF · Substantial damageNTSB SEA03LA175Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Cottonwood, IDThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane. Factors contributing to the accident were the updraft, the terrain drop-off, and the fence.Aug 20, 2003 · N80978 · Substantial damageNTSB SEA03LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-200R · Nampa, IDLanding gear collapse for undetermined reasons during the landing roll. On ground collision with a runway light was a factor.Aug 20, 2003 · N4816T · Substantial damage