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 ERA14CA458Accident · No injuriesData collectionFinal reportBeech C90 · Oneida, TNThe pilot's failure to properly configure the rudder trim for takeoff and his failure to maintain directional control during a precautionary landing, which resulted in a runway excursion and collision with terrain.Sep 25, 2014 · N211PC · Substantial damageNTSB WPR14CA391Accident · No injuriesData collectionFinal reportPiper PA 31T - II · Oakland, CAThe pilot's failure to extend the landing gear which resulted in a gear-up landing. Contributing to the accident was the pilot's failure to use the checklist and reported stress.Sep 24, 2014 · N774MF · Substantial damageNTSB ANC14CA086Accident · No injuriesData collectionFinal reportMiller Gregory S Bushwacker · Iliamna, AKThe pilot's failure to maintain control on landing, resulting in the collision with terrain.Sep 22, 2014 · N9013U · Substantial damageNTSB WPR14CA386Accident · Minor injuriesData collectionFinal reportCessna E162 · Bellingham, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.Sep 21, 2014 · N6035S · Substantial damageNTSB WPR14CA384Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Meadow Creek, MTThe pilot's inadequate landing flare and failure to maintain aircraft control during landing.Sep 20, 2014 · N714TM · Substantial damageNTSB ERA14CA449Accident · No injuriesData collectionFinal reportCessna 182A · Bethany Center, NYThe pilot's failure to maintain a directional control of the airplane during gusting wind conditions.Sep 20, 2014 · N3785D · Substantial damageNTSB WPR14CA380Accident · No injuriesData collectionFinal reportCessna 170B · Portland, ORThe pilot's failure to maintain directional control of the airplane during the landing.Sep 19, 2014 · N3210A · Substantial damageNTSB ERA14LA448Accident · No injuriesLimited investigationFinal reportCessna 172M · Leesburg, FLThe flight instructor’s delayed remedial action and his subsequent loss of directional control during landing on a wet runway for reasons that could not be determined because postaccident examination of the airplane revealed no anomalies.Sep 19, 2014 · N13394 · Substantial damageNTSB ERA14CA447Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Culpepper, VAThe failure of both pilots to maintain directional control during landing.Sep 19, 2014 · N749KY · Substantial damageNTSB CEN14FA505Accident · No injuriesField investigationFinal reportEmbraer EMB 505 · Conroe, TXThe second-in-command's (SIC) engagement of the emergency parking brake (EPB), which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the SIC's decision to engage the EPB was the…Sep 19, 2014 · N322QS · Substantial damageNTSB CEN14WA509Accident · No injuriesForeign investigationMaule M 7-235B · Le Touquet, FranceSep 17, 2014 · N1027G · Substantial damageNTSB DCA14CA161Accident · No injuriesData collectionFinal reportBoeing 757 223 · Miami, FLThe failure of the first officer to control the airplane pitch after touchdown. Contributing to the accident was the first officers inexperience in the aircraft type.Sep 16, 2014 · N654A · Substantial damageNTSB CEN14CA501Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Longville, MNThe pilot's loss of control during an attempted go-around following a multiple bounce landingSep 16, 2014 · N6081K · DestroyedNTSB ERA14CA452Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's improper landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's self-induced pressure to land due to the deteriorating weather conditions.Sep 14, 2014 · N21670 · Substantial damageNTSB CEN14CA514Accident · No injuriesData collectionFinal reportStanley Arthur Freeman Zodiac 601XL · Fremont, NEThe pilot's improper landing flare which resulted in a hard landing.Sep 14, 2014 · N710DM · Substantial damageNTSB WPR14CA396Accident · Minor injuriesData collectionFinal reportUltramagic N250 - NO Series · Phoenix, AZThe pilot's failure to maintain aircraft control while landing in downdraft and gusting wind conditions which resulted in striking trees and a subsequent hard landing.Sep 13, 2014 · N59EX · Substantial damageNTSB ERA14TA435Accident · No injuriesFinal reportCessna T210N · Gaithersburg, MDThe pilot’s failure to execute a missed approach after recognizing that the airplane was not aligned with the wet runway, which resulted in a long landing with a tailwind and a subsequent runway overrun.Sep 13, 2014 · N5132C · Substantial damageNTSB ANC14CA080Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Aniak, AKThe pilot's inability to maintain directional control of the airplane resulting in a separation of the wheel axle, resulting in a collision with terrain.Sep 13, 2014 · N9877D · Substantial damageNTSB ANC14CA078Accident · No injuriesData collectionFinal reportCessna 180H · Nenana, AKThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control of the airplane, while landing during dark night conditions.Sep 13, 2014 · N2419F · Substantial damageNTSB CEN14LA497Accident · Serious injuriesLimited investigationFinal reportDarney Glasair III · Austin, TXThe pilot’s use of an improper attitude and airspeed during landing followed by excessive braking, which resulted in the airplane wheelbarrowing on the runway and a subsequent loss of directional control.Sep 12, 2014 · N39RD · Substantial damageNTSB WPR14CA373Accident · Minor injuriesData collectionFinal reportBell 407 · Moab, UTThe pilot's failure to ensure adequate clearance from terrain while landing on sloped terrain.Sep 11, 2014 · N142MA · Substantial damageNTSB WPR14CA372Accident · Minor injuriesData collectionFinal reportFound Acft Canada FBA 2C1 · Cascade, IDThe pilot's failure to maintain directional control during landing.Sep 11, 2014 · N500FA · Substantial damageNTSB CEN14CA496Accident · No injuriesData collectionFinal reportCessna 172M · Oxford, WIThe pilot did not compensate for the decrease in the crosswind when he descended below the tree line during the landing.Sep 11, 2014 · N3510Q · Substantial damageNTSB CEN14CA488Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Belen, NMThe student pilot's improper recovery from a bounced landing.Sep 8, 2014 · N6693W · Substantial damageNTSB CEN14CA512Accident · No injuriesData collectionFinal reportChampion 7GCAA · Alpine, TXThe loss of airplane control during a precautionary landing resulting in a hard landing.Sep 7, 2014 · N2535F · Substantial damageNTSB WPR14LA368Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Mesa, AZThe failure of the right main landing gear (MLG) transmission mounting bracket coupled with the differential rigging of the two landing gear cables, which prevented the right MLG from moving to the down-and-locked position before landing.Sep 6, 2014 · N5966P · Substantial damageNTSB WPR14CA366Accident · Minor injuriesData collectionFinal reportBellanca 8KCAB · Black Rock City, NVThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's disorientation as a result of dust which reduced visibility.Sep 6, 2014 · N31273 · Substantial damageNTSB ERA14CA431Accident · No injuriesData collectionFinal reportPiper PA-18A-150 · Gunthersville, ALThe pilot's failure to retract the landing gear wheels prior to a water landing, resulting in a nose over upon touchdown.Sep 6, 2014 · N7089B · Substantial damageNTSB ANC14CA076Accident · No injuriesData collectionFinal reportCessna U206B · Gustavus, AKThe motor vehicles operators' lack of attention, and improper decision to cross the runway with the runway alert system active, resulting in a collision with the airplane.Sep 6, 2014 · N3862G · Substantial damageNTSB WPR14TA370Accident · No injuriesFinal reportEurocopter AS 350 B3 · Lincoln, CAThe failure of the engine to provide sufficient power when commanded by the pilot during the power recovery phase of a practice autorotation for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or…Sep 5, 2014 · N217HP · Substantial damageNTSB WPR14CA365Accident · Minor injuriesData collectionFinal reportEaland Charles Lionheart · Santa Maria, CAThe pilot's inadequate landing flare and subsequent loss of directional control during the landing roll.Sep 5, 2014 · N15TE · Substantial damageNTSB CEN14LA489Accident · No injuriesLimited investigationFinal reportGallager John C Glasair · Highland Heights, OHThe pilot’s loss of aircraft control during landing, and his failure to maintain directional control.Sep 5, 2014 · N4PX · Substantial damageNTSB ANC14CA074Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Fairbanks, AKThe pilot's inability to maintain directional control of the airplane resulting in a runway excursion and collision with terrain.Sep 5, 2014 · N2158A · Substantial damageNTSB ERA14LA423Accident · 1 fatalLimited investigationFinal reportMcmurray David C Searey · Webb, NYThe pilot’s failure to maintain control of the amphibious airplane while practicing touch-and-go takeoffs and landings on a reservoir.Sep 4, 2014 · N8768B · Substantial damageNTSB CEN14LA492Accident · No injuriesLimited investigationFinal reportCampbell Super Bearhawk · Sault Ste Marie, MIThe pilot’s inadequate flare during landing on water with a glassy condition, which resulted in the airplane nosing over.Sep 4, 2014 · CFBCA · Substantial damageNTSB ANC14CA075Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Homer, AKThe pilot's failure to maintain aircraft control during the landing roll.Sep 4, 2014 · N8775C · Substantial damageNTSB ANC14CA073Accident · No injuriesData collectionFinal reportCessna 170B · Palmer, AKThe pilot's excessive use of brakes during the landing roll resulting in a nose over.Sep 4, 2014 · N1661D · Substantial damageNTSB WPR14CA364Accident · No injuriesData collectionFinal reportFlight Design Ctls LSA · Grass Valley, CAThe pilot's inadequate flare which resulted in a loss of aircraft control during landing.Sep 3, 2014 · N245LS · Substantial damageNTSB CEN14LA493Accident · No injuriesLimited investigationFinal reportDavis Benny Christen Eagle II · Vinton, IAThe pilot's loss of directional control during landing after the airplane encountered uneven pavement at the intersection with a crossing runway.Sep 3, 2014 · N229HP · Substantial damageNTSB CEN14LA476Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Cortez, COThe flight instructor’s delayed decision to abort the simulated engine out maneuver, his failure to unfeather the propeller before restoring engine power, and his inadequate airspeed management, which led to an aerodynamic stall at low altitude.Sep 3, 2014 · N747TH · Substantial damageNTSB CEN14CA483Accident · No injuriesData collectionFinal reportRoss Alfred K/Oneill Terrence Lancair 235 · Longmont, COThe pilot's inadvertent application of the brake which resulted in the loss of directional control during the landing roll.Sep 3, 2014 · N211AL · Substantial damageNTSB WPR14CA379Accident · No injuriesData collectionFinal reportCessna 152 · Santa Rosa, CAThe student pilot's inadequate flare resulted in a hard landing.Sep 1, 2014 · N67367 · Substantial damageNTSB CEN14CA532Accident · Minor injuriesData collectionFinal reportAirborne Edge X · Willow Springs, MOThe pilot's loss of control after the weight-shift-control aircraft encountered low-level wind shear shortly before touchdown. Also causal to the accident was the pilot's inadequate preflight weather assessment that failed to correctly determine the actual…Sep 1, 2014 · N2017A · Substantial damageNTSB ANC14CA072Accident · No injuriesData collectionFinal reportPiper PA 12 · Talkeetna, AKThe pilot's inadequate recovery from a bounced landing, resulting in a runway excursion and collision with trees.Sep 1, 2014 · N2507M · Substantial damageNTSB WPR14TA357Accident · Minor injuriesFinal reportAirbus Helicopters AS 350 B3 · Hemet, CAThe flight instructor's failure to adequately brief and demonstrate the simulated emergency procedure to the pilot under instruction and his delayed remedial action and inadequate supervision during the maneuver, which resulted in an excessive sink rate and a…Aug 28, 2014 · N991SD · Substantial damageNTSB WPR14CA360Accident · No injuriesData collectionFinal reportNavion Navion F · Colville, WAThe pilot's loss of directional control during the landing roll.Aug 28, 2014 · N91611 · Substantial damageNTSB ERA14CA410Accident · Minor injuriesData collectionFinal reportBertagna John Just Highlander · Birdsboro, PAThe pilot's improper landing flare and recovery from a bounced landing resulting in loss of aircraft control.Aug 27, 2014 · N61148 · DestroyedNTSB WPR14CA378Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Walla Walla, WAThe pilot's misjudged approach which resulted in overshooting the landing point and insufficient remaining landing surface.Aug 25, 2014 · N7860D · Substantial damageNTSB CEN14LA451Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Gordonville, TXA loss of directional control during a crosswind landing.Aug 23, 2014 · N3202T · Substantial damageNTSB CEN14LA463Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MIThe pilot’s failure to extend the landing gear before landing.Aug 20, 2014 · N3084Z · Substantial damage