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 WPR14CA157Accident · No injuriesData collectionFinal reportRobert A Miller Murphy Rebel Elite · Roundup, MTThe pilot's loss of directional control while landing.Apr 2, 2014 · N3552J · Substantial damageNTSB WPR14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Anacortes, WAThe pilot's improper application of brakes during the landing roll resulted in a runway excursion and nose over.Apr 1, 2014 · N19982 · Substantial damageNTSB WPR14CA152Accident · No injuriesData collectionFinal reportPiper PA 18A · Wheatland, WYThe front seat pilot's excessive approach speed and subsequent brake application during the landing which resulted in a nose-over. Contributing to the accident was the instructor's failure to maintain situational awareness.Mar 30, 2014 · N1952P · Substantial damageNTSB WPR14CA150Accident · No injuriesData collectionFinal reportJust Highlander · Yakima, WAThe student pilot's inadequate compensation for the gusting crosswind conditions and the certified flight instructor's inadequate supervision, resulting in a loss of directional control during the landing roll.Mar 28, 2014 · N553GW · Substantial damageNTSB ERA14CA177Accident · No injuriesData collectionFinal reportAviat A 1B · Dadeville, ALThe pilot's failure to obtain the proper touchdown point while landing on a lake with a tailwind.Mar 27, 2014 · N59AW · Substantial damageNTSB CEN14IA172Incident · No injuriesIncident investigationFinal reportCessna 560XL · Traverse City, MIThe inoperative galley drain tube heater, which allowed water within the tube to freeze and led to its failure; the tube’s failure allowed water to drain onto the rudder cables and freeze and resulted in the rudder binding during landing.Mar 26, 2014 · N580QS · No damageNTSB WPR14CA145Accident · No injuriesData collectionFinal reportAeronca 7DC · Fallon, NVThe pilot's failure to maintain directional control during the landing roll with a tailwind.Mar 24, 2014 · N817DC · Substantial damageNTSB WPR14CA156Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Mesa, AZThe student pilot's excessive speed during taxi which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate monitoring of the remaining runway length available during the landing roll.Mar 23, 2014 · N4112L · Substantial damageNTSB ERA14CA166Accident · No injuriesData collectionFinal reportWaco UIC · Saint Petersburg, FLThe pilot's inadequate compensation for the wind conditions during landing.Mar 23, 2014 · N13562 · Substantial damageNTSB WPR14LA146Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC42 550FG · Truckee, CAThe pilot’s failure to maintain directional control during both the landing and the subsequent attempted go-around.Mar 21, 2014 · N112FP · Substantial damageNTSB WPR14LA142Accident · No injuriesLimited investigationFinal reportBellanca 17 31 · Salt Lake City, UTThe failure of the right main landing gear extension spring to maintain adequate pressure, which allowed the landing gear to collapse during the landing roll.Mar 21, 2014 · N28119 · Substantial damageNTSB ERA14LA173Accident · No injuriesLimited investigationFinal reportCessna 206H · Philadelphia, PAThe pilot's failure to maintain control of the airplane while landing in gusty wind conditions.Mar 21, 2014 · N309JK · Substantial damageNTSB CEN14CA186Accident · No injuriesData collectionFinal reportCessna 172N · Marine City, MIThe pilot's improper recovery from a bounced landing.Mar 21, 2014 · N739RX · Substantial damageNTSB WPR14CA140Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Coolidge, AZThe pilot's failure to maintain directional control during landing.Mar 20, 2014 · N4106G · Substantial damageNTSB ERA14LA170Accident · No injuriesLimited investigationFinal reportCessna 421 · Charleston, SCInadequate maintenance, which resulted in the collapse of the right main landing gear during landing.Mar 20, 2014 · N5929M · Substantial damageNTSB WPR14CA139Accident · No injuriesData collectionFinal reportBayer Oscar Starduster SA300 · San Luis Obispo, CAThe pilot's inadequate flare, which resulted in a bounced landing and subsequent loss of aircraft control during landing.Mar 19, 2014 · N490B · Substantial damageNTSB CEN14CA166Accident · No injuriesData collectionFinal reportSkykits Savannah VGW · Hudson, COThe pilot's inadequate monitoring of his glide path resulting in a collision with a berm prior to landing.Mar 19, 2014 · N508TG · Substantial damageNTSB ERA14CA157Accident · No injuriesData collectionFinal reportCessna 210N · Marathon, FLThe pilot's failure to ensure that the airplane's landing gear was down and locked prior to touchdown. Contributing to the accident was the possibility of intermittent landing gear operation due to a faulty hydraulic power pack contactor.Mar 17, 2014 · N210JZ · Substantial damageNTSB ERA14LA159Accident · No injuriesLimited investigationFinal reportCessna 500 · Zephyrhills, FLThe pilots' inadequate in-flight planning and improper selection of runway 36 for landing, which resulted in a significant quartering tailwind during the landing, exceedance of the airplane's braking capability, and a subsequent runway overrun.Mar 16, 2014 · N125DS · Substantial damageNTSB ERA14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Brooksville, FLThe pilot's failure to compensate for the reported crosswind conditions resulting in the wings contacting the ground.Mar 14, 2014 · N80457 · Substantial damageNTSB CEN14CA183Accident · No injuriesData collectionFinal reportStinson 108 · Broomfield, COThe pilot's failure to maintain directional control during the landing, which resulted in the airplane departing the runway and nosing over.Mar 14, 2014 · N9538K · Substantial damageNTSB CEN14CA162Accident · No injuriesData collectionFinal reportBeech 35 C33A · West Union, OHA loss of aircraft control during landing, due to the pilot's excessive braking. Contributing to the accident was the pilot's lack of recent flight experience.Mar 13, 2014 · N242JB · Substantial damageNTSB CEN14CA158Accident · Minor injuriesData collectionFinal reportAmerican Champion 8GCBC · Chisago City, MNThe unsuitable landing area encountered by the pilot due to wet soft snow conditions that resulted in a nose over.Mar 10, 2014 · N63HE · Substantial damageNTSB ERA14LA152Accident · Serious injuriesLimited investigationFinal reportKurtz Jay B RV-9A · Live Oak, FLThe pilot’s improper recovery from a bounced landing, which resulted in an aerodynamic stall, a subsequent nose-down landing, and excessive bending loads to the nose landing gear.Mar 9, 2014 · N125TK · Substantial damageNTSB WPR14LA133Accident · No injuriesLimited investigationFinal reportPeter W Stevens Bearhawk Patrol · Salt Lake City, UTThe pilot’s failure to maintain directional control during the landing roll.Mar 8, 2014 · N123WW · Substantial damageNTSB ERA14CA160Accident · No injuriesData collectionFinal reportCessna 172N · Charlottesville, VAThe pilot's inadequate landing flare, which resulted in a bounced landing and substantial damage to the firewall.Mar 8, 2014 · N5423J · Substantial damageNTSB ERA14CA150Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Salisbury, NCThe flight instructor's decision to continue the landing in close proximity to a landing helicopter, resulting in an encounter with rotor vortices, loss of airplane control, and collision with terrain.Mar 8, 2014 · N4335T · Substantial damageNTSB WPR14LA134Accident · No injuriesLimited investigationFinal reportCessna 170B · San Luis Obispo, CACorrosion of the bulkhead assembly in the left main landing gearbox area, which resulted in the structural failure of the bulkhead and the subsequent landing gear collapse.Mar 7, 2014 · N2252D · Substantial damageNTSB ERA14CA151Accident · No injuriesData collectionFinal reportCessna 172M · Pittstown, NJThe pilot's failure to maintain directional control while landing.Mar 7, 2014 · N1319U · Substantial damageNTSB CEN14CA153Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 · Cleveland, OHThe pilot's improper flare and recovery from a bounced landing, which resulted in a loss of control and impact with terrain.Mar 6, 2014 · N108WA · Substantial damageNTSB ERA14CA140Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Mayaguez, PRThe pilot's loss of directional control of the airplane during landing, which resulted in a runway excursion.Mar 1, 2014 · N929SC · Substantial damageNTSB ERA14CA139Accident · No injuriesData collectionFinal reportPiper PA 11S · Marlboro, MAThe pilot's loss of directional control during the landing rollout in crosswinds, resulting in a runway excursion and subsequent impact with a snow bank.Mar 1, 2014 · N5556H · Substantial damageNTSB CEN14CA157Accident · No injuriesData collectionFinal reportAeronca 7AC · Adrian, TXThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the airplane ground looping.Mar 1, 2014 · N85372 · Substantial damageNTSB WPR14LA130Accident · No injuriesLimited investigationFinal reportGrumman G164 - A · Caruthers, CAAn undetected fatigue crack in the landing gear leg, which initiated at an electrical arc-induced damage site of undetermined origin and resulted in landing gear failure. Contributing to the severity of damage to the airplane was the close proximity of an…Feb 28, 2014 · N72ES · Substantial damageNTSB WPR14CA122Accident · No injuriesData collectionFinal reportCessna 172M · Ramona, CAThe student pilot's inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.Feb 25, 2014 · N91712 · Substantial damageNTSB ERA14CA134Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · Gulf Shores, ALThe student pilot's incorrect rudder input, which resulted in a ground loop and collision with a runway sign.Feb 25, 2014 · N156WB · Substantial damageNTSB ERA14CA136Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lake Wales, FLThe pilot's improper flare during a water landing, which resulted in the wings contacting the water.Feb 24, 2014 · N9563P · Substantial damageNTSB WPR14CA120Accident · No injuriesData collectionFinal reportPiper PA 16 · Scappoose, ORThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot's diverted attention and inadequate preflight inspection.Feb 22, 2014 · N5626H · Substantial damageNTSB CEN14WA248Accident · No injuriesForeign investigationCessna 340 · Toussus-Le-Noble, FranceFeb 18, 2014 · N876DT · Substantial damageNTSB ERA14CA127Accident · Minor injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe pilot's failure to maintain directional control while landing.Feb 17, 2014 · N426SP · Substantial damageNTSB DCA14WA175Accident · No injuriesForeign investigationBoeing 737 - 8K2 · Madeira, PortugalFeb 17, 2014 · G-GDFC · Substantial damageNTSB ERA14LA133Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Allentown, PAThe flight instructor’s failure to maintain directional control during the landing.Feb 16, 2014 · N931JS · Substantial damageNTSB WPR14CA116Accident · No injuriesData collectionFinal reportCessna 172 - N · Glendale, AZThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a runway excursion and subsequent impact with a taxiway sign.Feb 15, 2014 · N738BH · Substantial damageNTSB CEN14LA146Accident · No injuriesLimited investigationFinal reportFogg Quicksilver MX II · Holland, MIThe pilot's inability to maintain airplane control after inadvertently landing in an area of deep snow on a frozen lake.Feb 15, 2014 · N94567 · Substantial damageNTSB ERA14LA122Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Pinson, TNThe noninstrument-rated pilot’s decision to continue flight into deteriorating weather conditions at night and his failure to divert in a timely manner, which resulted in an off-airport precautionary landing and subsequent substantial damage to the airplane.Feb 14, 2014 · N194EX · Substantial damageNTSB CEN14CA152Accident · No injuriesData collectionFinal reportCessna 172R · Ellsworth, KSthe student pilot's failure to maintain directional control during landing.Feb 13, 2014 · N816KS · Substantial damageNTSB ERA14CA119Accident · No injuriesData collectionFinal reportPiper PA 38-112 · West Milford, NJThe failure of the pilot-in-command to maintain directional control during landing.Feb 11, 2014 · N381PT · Substantial damageNTSB CEN14LA138Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Marion, IAThe pilot’s failure to attain a touchdown on the runway’s hard surface, which resulted in a loss of directional control.Feb 11, 2014 · N350AR · Substantial damageNTSB ANC14CA015Accident · Minor injuriesData collectionFinal reportCraig C Walls Snowyriver Special · Wasilla, AKThe pilot's failure to maintain directional control after landing, resulting in a nose over.Feb 6, 2014 · N207CW · Substantial damageNTSB DCA14FA058Accident · No injuriesClass 3 · FieldFinal reportEmbraer EMB145 - EP · Memphis, TNthe failure of the flight crew to adequately monitor the system for proper operation and manually activate the system during the flight in icing conditions. Contributing to the accident was the crew's limited training on the manual operation of the anti-ice…Feb 5, 2014 · N802HK · Substantial damage