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 LAX03LA129Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Herald, CAthe inadequate visual lookout for other aircraft by both pilots that resulted in a midair collision.Apr 5, 2003 · N3859E · 2 aircraft · Minor damageNTSB DEN03LA064Accident · No injuriesLimited investigationFinal reportCessna 182G · Truth or Conseq, NMthe pilot's failure to maintain directional control during landing roll which resulted in impact with terrain. Contributing factors include, the pilot's improper in-flight planning/decision making, the crosswind and gusty wind conditions, the ditch, and the…Apr 5, 2003 · N3749U · Substantial damageNTSB ATL03LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Summerville, SCThe pilot's improper flare and recovery from a bounced landing.Apr 5, 2003 · N6599B · Substantial damageNTSB NYC03LA077Accident · No injuriesLimited investigationFinal reportWaco YOC · Allentown, PAThe pilot's failure to maintain directional control while landing which resulted in a ground loop. A factor in the accident was the crosswind.Apr 4, 2003 · N15244 · Substantial damageNTSB MIA03CA093Accident · No injuriesData collectionFinal reportBoeing A75N1 · Lakeland, FLThe pilot's failure to maintain control during the landing rollout which resulted in the airplane exiting the runway, impacting a runway light, and nosing over.Apr 4, 2003 · N2535R · Substantial damageNTSB NYC03LA078Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Taunton, MAThe pilot's inadequate compensation for the winds, and his failure to maintain airspeed which resulted in the inadvertent stall. A factor in the accident was the tailwind.Apr 2, 2003 · N88387 · Substantial damageNTSB MIA03CA086Accident · Minor injuriesData collectionFinal reportMathews Pegazai · Lakeland, FLThe failure of the pilot to maintain directional control and his inadequate compensation for wind.Apr 1, 2003 · N405BM · Substantial damageNTSB MIA03CA083Accident · No injuriesData collectionFinal reportCessna 190 · Lakeland, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control. A related factor was the crosswind.Mar 31, 2003 · N4413C · Substantial damageNTSB SEA03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Troutdale, ORAircraft control was not maintained during the landing roll. An improper flare which resulted in a bounced landing was a factor.Mar 30, 2003 · N4961T · Substantial damageNTSB ATL03LA071Accident · Minor injuriesLimited investigationFinal reportCessna 310F · Reidsville, NCThe failure of maintenance personnel to properly install the nose gear landing door link during an annual inspection that resulted in the failure of the nose gear to fully extend.Mar 30, 2003 · N5810X · Substantial damageNTSB MIA03LA087Accident · No injuriesLimited investigationFinal reportPool Pool Jungster I · Fernandina Beac, FLThe pilot's failure to maintain control during the landing flare/touchdown while attempting a crosswind landing resulting in the left wing impacting the ground, and a collision with runway lights during the attempted recovery.Mar 29, 2003 · N7135 · Substantial damageNTSB IAD03LA051Accident · No injuriesLimited investigationFinal reportBell 47G · Lehighton, PAThe student pilot's improper flare, which resulted in a hard landing, and his continued flight operations with a known discrepancy.Mar 28, 2003 · N17114 · Substantial damageNTSB ANC03LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an encounter with soft snow, and subsequent nose over during the landing roll. A factor contributing to the accident was the soft, snow-covered terrain.Mar 28, 2003 · N4448Z · Substantial damageNTSB MIA03CA091Accident · No injuriesData collectionFinal reportMaule M-5-235C · Jay, FLThe failure of the pilot to perform a go-around after bouncing following touchdown, resulting in the airplane nosing over during the landing roll.Mar 27, 2003 · N366X · Substantial damageNTSB IAD03CA044Accident · No injuriesData collectionFinal reportCessna 172S · Cleveland, OHThe student pilot's improper flare, which resulted in a hard landing.Mar 27, 2003 · N613SP · Substantial damageNTSB ATL03LA069Accident · No injuriesLimited investigationFinal reportCessna 310 · Dyersburg, TNThe pilot's failure to maintain directional control during landing roll. A factor was muddy terrain conditions.Mar 27, 2003 · N244S · Substantial damageNTSB FTW03LA116Accident · No injuriesLimited investigationFinal reportCessna 172B · Tulsa, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.Mar 26, 2003 · N6947X · Substantial damageNTSB LAX03LA118Accident · Minor injuriesLimited investigationFinal reportRyan Navion · Mammoth Lakes, CAthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll. A factor was the gusty crosswind.Mar 23, 2003 · N5291K · Substantial damageNTSB LAX03LA117Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Van Nuys, CAthe pilot's failure to maintain directional control during an aborted landing. A contributing factor is the pilot's improper recovery from a bounced landing.Mar 23, 2003 · N63788 · Substantial damageNTSB DEN03LA052Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Erie, COthe pilot's failure to maintain aircraft control during aborted landing. Contributing factors include the crosswind component, and the snow covered muddy terrain.Mar 23, 2003 · N3544Q · Substantial damageNTSB CHI03LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Owatonna, MNThe pilots loss of directional control on landing and subsequent collision with terrain. Contributing factors were the crosswind, the airport lights, and the ditch.Mar 23, 2003 · N92505 · Substantial damageNTSB ATL03LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot misjudged the landing distance, landed with excessive airspeed, did not attempt a go-around resulting in the airplane going off the overrun, and colliding with trees.Mar 23, 2003 · N13591 · Substantial damageNTSB LAX03LA115Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Chandler, AZThe student pilot's improper flare and his failure to maintain directional control. A contributing factor is the student pilot's improper recovery from a bounced landing.Mar 21, 2003 · N2474Z · Substantial damageNTSB CHI03LA085Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILThe pilot's improper flare resulting in a hard landing.Mar 19, 2003 · N930DE · Substantial damageNTSB ATL03LA081Accident · No injuriesLimited investigationFinal reportBeech A100 · Carrollton, GAThe pilot misjudged the approach and touchdown airspeeds that resulted in the overrun of the runway during a landing. Factors were the wet runway and hydroplaning conditions.Mar 17, 2003 · N227BC · Substantial damageNTSB LAX03LA133Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · San Diego, CAthe pilot's misjudgment of the landing flare and descent rate. A contributing factor was the pilot's misjudged speed and distance.Mar 16, 2003 · N1169S · Substantial damageNTSB ATL03LA063Accident · No injuriesLimited investigationFinal reportCessna A152 · Peachtree City, GAThe pilot's failure to maintain directional control during landing roll that resulted in a nose over after the airplane departed the runway surface. A factor is muddy terrain.Mar 16, 2003 · N762JS · Substantial damageNTSB SEA03IA046Incident · No injuriesIncident investigationFinal reportBoeing DC-9-82 · Seattle, WAThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Factors include sunglare from the wet paved surfaces, and a visual illusion created by the airport surface…Mar 15, 2003 · N298AA · No damageNTSB IAD03LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Honesdale, PAThe pilot's failure to maintain directional control while landing. A factor was the crosswind.Mar 15, 2003 · N4896F · Substantial damageNTSB DEN03LA058Accident · No injuriesLimited investigationFinal reportAviat A-1B · Englewood, COthe pilot's failure to maintain directional control of the airplane, resulting in an inadvertent ground loop. A contributing factor was the gusty winds.Mar 15, 2003 · N60HY · Substantial damageNTSB MIA03LA075Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Humacao, PRthe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the left side of the runway, and impacting with a ditch. Factors in this accident were; the pilot did not follow the procedures, and…Mar 13, 2003 · N35SR · Substantial damageNTSB FTW03LA110Accident · No injuriesLimited investigationFinal reportCessna 177A · England, ARThe pilot's failure to refuel the airplane while searching for a private grass airstrip, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.Mar 12, 2003 · N30461 · Substantial damageNTSB LAX03LA112Accident · No injuriesLimited investigationFinal reportCessna 172R · Thermal, CAthe student pilot's failure to use aileron controls to compensate for the known crosswind and failure to maintain directional control during the landing rollout.Mar 11, 2003 · N4201Y · Substantial damageNTSB NYC03LA065Accident · No injuriesLimited investigationFinal reportCessna 172P · Linden, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Factors in the accident were the crosswind and the snowbank.Mar 10, 2003 · N30EF · Substantial damageNTSB FTW03LA108Accident · No injuriesLimited investigationFinal reportWaco UKS-7 · El Paso, TXThe pilot's failure to compensate for existing wind conditions. A contributing factor was the crosswind.Mar 9, 2003 · N17721 · Substantial damageNTSB ATL03LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NCThe pilot's improper flare during touchdown and failure to properly recover from a bounced landing, which resulted in a loss of control and inflight collision with the runway. A factor was the pilot did not understand the porpoise condition during landing.Mar 9, 2003 · N52546 · Substantial damageNTSB ATL03LA058Accident · No injuriesLimited investigationFinal reportCessna 172 M · Collegedale, TNThe student pilot's failure to maintain directional control, which resulted in a loss of control, impact with terrain and subsequent nose over.Mar 9, 2003 · N1754V · Substantial damageNTSB NYC03LA064Accident · No injuriesLimited investigationFinal reportPiper PA-22/20-150 · South Woodstock, CTThe pilot's failure to maintain directional controlMar 8, 2003 · N7342D · Substantial damageNTSB IAD03LA037Accident · No injuriesLimited investigationFinal reportBeech 23 · Cincinnati, OHThe second pilot's inadequate flare and the pilot/owner's lack of remedial action, which resulted in a hard landing. A factor was the wind gusts.Mar 8, 2003 · N6995Q · Substantial damageNTSB FTW03LA119Accident · No injuriesLimited investigationFinal reportCessna 150 · Pearland, TXThe pilot's failure to maintain runway alignment. Contributing factors were the pilot's diverted attention to the banner staging area, and the ditch.Mar 8, 2003 · N8994U · Substantial damageNTSB CHI03LA091Accident · No injuriesLimited investigationFinal reportAviat A-1 · Cahokia, ILThe pilot’s inadequate compensation for wind and his failure to maintain directional control of the airplane which resulted in a ground loop. A factor associated with the accident was the gusty crosswind condition.Mar 8, 2003 · N96033 · Substantial damageNTSB CHI03LA081Accident · No injuriesLimited investigationFinal reportCessna 180K · St Charles, MOThe pilot's inadequate compensation for wind and his failure to maintain directional control resulting in a ground loop. A factor was the crosswind.Mar 8, 2003 · N2732K · Substantial damageNTSB ATL03LA056Accident · No injuriesLimited investigationFinal reportFokker F.27MK 500 · Kinston, NCThe fatigue failure of the main drag stay tube. A factor is no inspection procedure required.Mar 8, 2003 · N712FE · Substantial damageNTSB DEN03LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Richfield, UTthe pilot's failure to maintain aircraft control during landing roll resulting in a ground loop/swerve and subsequent nose over. A contributing factor was the gusty wind conditions.Mar 7, 2003 · N8205W · Substantial damageNTSB LAX03LA106Accident · No injuriesLimited investigationFinal reportCessna 421C · Crescent City, CAThe separation of the upper and lower right main landing gear scissor links due to improper maintenance, which resulted in a ground loop, and the collapse of the right main landing gear during the landing roll.Mar 5, 2003 · N26533 · Substantial damageNTSB CHI03LA079Accident · No injuriesLimited investigationFinal reportCessna 172R · St. Paul, MNThe loss of directional control by the solo student pilot. A factor to the accident was the excessive speed during landing.Mar 5, 2003 · N35307 · Substantial damageNTSB ATL03LA053Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rogersville, TNThe pilot's improper landing flare which resulted in a hard landing.Mar 4, 2003 · N4135Q · Substantial damageNTSB DEN03LA044Accident · No injuriesLimited investigationFinal reportCessna 150M · Gateway, COthe pilot's failure to maintain aircraft control. Contributing factors were the snow-covered runway.Mar 3, 2003 · N714NF · Substantial damageNTSB SEA03LA044Accident · No injuriesLimited investigationFinal reportCessna 180 A · Malin, ORAircraft control not maintained during landing. Soft terrain was a factor.Mar 2, 2003 · UNREG · Substantial damageNTSB ANC03IA037Incident · No injuriesIncident investigationFinal reportCessna 206 · Homer, AKThe separation of the main landing gear spring strut during landing touchdown due to corrosion and fatigue. Factors contributing to the accident were the manufacturer's and the FAA's insufficient standards/requirements for inspection procedures.Mar 1, 2003 · N8337Q · Minor damage