OpenAirDocs.org

NTSB investigations, 2003

515 cases where the phase of flight was Landing.

Cases per year

19622026

Where

Open the map

Latest cases

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 year(c.\"eventDate\") = 2003
    AND 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 SEA04CA037Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Bend, ORDirectional control not maintained during landing. Factors include an icy runway and a snow bank.Dec 30, 2003 · N727MR · Substantial damageNTSB CHI04LA049Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Wellington, KSThe pilot not maintaining directional control during the landing roll. Factors were the dry grass and the concrete box he encountered during his excursion off the runway.Dec 29, 2003 · N14763 · DestroyedNTSB DEN04LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Hudson, COthe pilot's failure to maintain directional control due to an excessive crosswind component, resulting in an uncontrolled groundloop/swerve. Contributing factors were the crosswind gust and the soft, sandy terrain.Dec 28, 2003 · N5609B · Substantial damageNTSB NYC04LA051Accident · Serious injuriesLimited investigationFinal reportSchweizer 269C-1 · Byron, NYThe pilot's improper use of the collective, and failure to maintain main rotor rpm, which resulted in low main rotor rpm and a hard landing.Dec 27, 2003 · N358SS · Substantial damageNTSB NYC04CA053Accident · No injuriesData collectionFinal reportCessna 172R · Bluffton, OHThe pilot's improper flare and inadequate recovery from a bounced landing.Dec 27, 2003 · N363SA · Substantial damageNTSB LAX04LA079Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Oxnard, CAthe failure of the pin that secured the right rudder pedal to the brake cylinder arm due to improper installation of the pin. Also causal was the manufacturer's confusing maintenance instructions regarding the installation of the right rudder pedal pin and…Dec 27, 2003 · N53879 · Substantial damageNTSB ATL04LA059Accident · No injuriesLimited investigationFinal reportSocata TB21 · Spruce Pine, NCThe pilot's inadequate flare, and his failure to maintain directional control. The pilot's improper recovery from a bounced landing, and trees are a contributing factor.Dec 27, 2003 · N1879S · Substantial damageNTSB CHI04LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Waterloo, IAThe impact with a deer during landing roll. A contributing factor was the night lighting conditions.Dec 26, 2003 · N7575V · Substantial damageNTSB ATL04LA062Accident · No injuriesLimited investigationFinal reportCessna 172R · Atlanta, GAThe pilot's improper flare resulting in a hard landing. A factor is lack of total experience.Dec 26, 2003 · N26486 · Substantial damageNTSB ATL04IA067Incident · No injuriesIncident investigationFinal reportSabreliner NA-265-60 · Birminghham, ALThe lack of lubrication of the right main wheel bearing which resulted in the overheating.Dec 26, 2003 · N124DC · No damageNTSB MIA04LA038Accident · No injuriesLimited investigationFinal reportCessna 172RG · Key West, FLPilot's improper emergency landing gear extension procedure which resulted in the right main landing gear not locking in the down position subsequent right main landing gear collapsing on landing.Dec 25, 2003 · N4721R · Substantial damageNTSB CHI04LA047Accident · Minor injuriesLimited investigationFinal reportSikorsky S-58JT · Ypsilanti, MIThe pilot became disoriented and attempted to land the helicopter at the wrong ramp resulting in his failure to maintain obstacle clearance during the approach. The light poles were a factor to the accident.Dec 22, 2003 · N598S · DestroyedNTSB MIA04LA036Accident · No injuriesLimited investigationFinal reportCessna 310P · Crystal River, FLInadequate maintenance by company maintenance personnel, which resulted in operation of the airplane with a deflated nose landing gear strut, which resulted in the nose gear failing to lock in position, gear collapse, and damage to the airplane during landing…Dec 21, 2003 · N5811M · Substantial damageNTSB IAD04CA006Accident · No injuriesData collectionFinal reportPiper PA-30 · Louisville, KYThe pilot's improper flare, which resulted a hard landing. A factor was the glare from the setting sun.Dec 21, 2003 · N7532Y · Substantial damageNTSB CHI04LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mountain Grove, MOImproper use of the brakes during landing by the pilot, resulting in failure of the left main landing gear tire and a loss of directional control. Contributing factors were the failure of the main landing gear, as well as the grass and the ditch adjacent to…Dec 21, 2003 · N56598 · Substantial damageNTSB FTW04LA049Accident · Serious injuriesLimited investigationFinal reportCessna 195B · Amarillo, TXThe leakage of the left brake master cylinder cap, which resulted in the loss of hydraulic fluid and the failure of the left brake.Dec 20, 2003 · N6850D · Substantial damageNTSB MIA04FA035Accident · 2 fatalField investigationFinal reportCessna U206G · Thonotosassa, FLThe pilot's failure to retract the landing gear prior to landing on the water, resulting in a loss of control, and the airplane nosing over.Dec 18, 2003 · N603DK · Substantial damageNTSB LAX04CA070Accident · No injuriesData collectionFinal reportLuscombe 8E · San Jose, CAthe pilot's failure to maintain directional control of the airplane during the landing roll.Dec 18, 2003 · N1338B · Substantial damageNTSB DCA04MA011Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-10-10F · Memphis, TN1) the first officer's failure to properly apply crosswind landing techniques to align the airplane with the runway centerline and to properly arrest the airplane's descent rate (flare) before the airplane touched down; and 2) the captain's failure to…Dec 18, 2003 · N364FE · DestroyedNTSB SEA04LA028Accident · No injuriesLimited investigationFinal reportAviat A-1B · Hailey, IDThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent group loop and the collapse of the right main landing gear.Dec 17, 2003 · N290AM · Substantial damageNTSB MIA04CA034Accident · No injuriesData collectionFinal reportWaco 4MF 5 · Marathon, FLThe pilot's loss of directional control during landing rollout in a crosswind resulting in the airplane ground looping and incurring damage to the left wing.Dec 17, 2003 · N64JE · Substantial damageNTSB LAX04LA071Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Gilbert, AZthe pilot's failure to maintain control of the airplane during the landing touchdown in soft terrain. A contributing factor was the pilot's selection of unsuitable terrain for landing.Dec 17, 2003 · N5516H · Substantial damageNTSB LAX04CA072Accident · No injuriesData collectionFinal reportPiper PA-18 · Prescott, AZthe failure of the pilot to maintain directional control of the tail wheel equipped airplane during landing, which resulted in a ground loop.Dec 16, 2003 · N4380T · Substantial damageNTSB CHI04LA042Accident · No injuriesLimited investigationFinal reportBeech 99 · Mosinee, WIThe pilot's failure to maintain the proper descent rate and his inadequate flare.Dec 16, 2003 · N399CZ · Substantial damageNTSB ATL04LA068Accident · No injuriesLimited investigationFinal reportCessna 182L · Knoxville, TNThe pilot's improper flare and his inadequate compensation for wind conditions. Wind gust was a factorDec 16, 2003 · N3191R · Substantial damageNTSB ATL04IA054Incident · No injuriesIncident investigationFinal reportNew Piper PA-46-350P · St. ThomasThe pilot's inadequate inflight planning and failure to extend the landing gear, which resulted in a wheels-up landing.Dec 15, 2003 · N5345S · Minor damageNTSB NYC04LA048Accident · No injuriesLimited investigationFinal reportBeech 35 · Laconia, NHThe pilot's failure to maintain directional control after experiencing a brake failure. A factor related to the accident was the failure of the brake master cylinder.Dec 13, 2003 · N3116V · Substantial damageNTSB DEN04LA029Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Elbert, COthe pilot's failure to maintain directional control of the airplane. A contributing factor was his inexperience in aircraft type.Dec 13, 2003 · N4621T · Substantial damageNTSB LAX04LA247Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZthe pilot's misjudged flare and improper recovery from a bounced landing, which resulted in a pilot induced porpoise/oscillation.Dec 10, 2003 · N63149 · Substantial damageNTSB IAD04CA004Accident · No injuriesData collectionFinal reportBeech BE-55 · E. Stroudsburg, PAThe pilot's improper flare, which resulted in a hard landing and collapse of the nose landing gear.Dec 9, 2003 · N7202R · Substantial damageNTSB FTW04CA039Accident · No injuriesData collectionFinal reportRobinson R22 · Spring, TXThe CFI's delay in taking remedial action which resulted in a hard landing. An excessive descent rate was a contributing factor.Dec 8, 2003 · N747LF · Substantial damageNTSB DEN04LA028Accident · No injuriesLimited investigationFinal reportCessna 150H · Bountiful, UTthe unqualified person's failure to maintain aircraft control, which resulted in a hard landing. Contributing factors include the instructor's inadequate supervision, the instructor's inadequate recovery from a bounced landing, and the two parked aircraft.Dec 8, 2003 · N6935S · Substantial damageNTSB CHI04LA040Accident · No injuriesLimited investigationFinal reportClement-Kazmierczak Sorrell SNS-7 · Highmore, SDThe unsuitable terrain for landing encountered by the pilot. Contributing factors were the grass runway surface and the snowbank.Dec 6, 2003 · N7543E · Substantial damageNTSB LAX04LA058Accident · No injuriesLimited investigationFinal reportCessna 525 · San Diego, CAThe pilot's failure to maintain directional control and to initiate a timely go-around when visual contact with the runway was lost.Dec 5, 2003 · N15C · Substantial damageNTSB LAX04LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Nogales, AZThe student pilot's improper recovery from a bounced landing and his failure to maintain directional control.Dec 4, 2003 · N5216J · Substantial damageNTSB LAX04CA063Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Morenci, AZthe pilot's excessive landing flare, which resulted in an improper touchdown and hard landing.Dec 3, 2003 · N1451T · Substantial damageNTSB CHI04LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bloomfield, IAThe pilot's inadequate compensation for the crosswind condition which resulted in his failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the grass which the airplane contacted.Nov 30, 2003 · N7467W · Substantial damageNTSB ATL04CA041Accident · No injuriesData collectionFinal reportGlobe Swift GC1B · Southern Pines, NCThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop and the collapse of the landing gear.Nov 26, 2003 · N3210K · Substantial damageNTSB NYC04LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kutztown, PAThe pilot's inadvertent retraction of the landing gear on the ground.Nov 25, 2003 · N5406P · Substantial damageNTSB ATL04IA048Incident · No injuriesIncident investigationFinal reportCessna 560XL · Savannah, GAThe malfunction of the nose wheel gear for undetermined reasons.Nov 25, 2003 · N632QS · Minor damageNTSB CHI04LA038Accident · No injuriesLimited investigationFinal reportCessna 340A · Poplar Bluff, MOFailure to maintain directional control during landing. Collapse of the nose landing gear, the muddy grass/turf and the berm were contributing factors.Nov 24, 2003 · N200GC · Substantial damageNTSB SEA04LA021Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Emmett, IDBrake failure as a result of inadequate hydraulic (brake) fluid in the aircraft's closed brake system. Contributing factors were the pilot's overall lack of experience in the aircraft make/model, the cold soaked brake system due to the low temperatures, and…Nov 23, 2003 · N8982C · Substantial damageNTSB NYC04LA038Accident · No injuriesLimited investigationFinal reportCessna 182Q · Tunkhannock, PAThe pilot's misjudgment of distance resulting in an overrun.Nov 23, 2003 · N735XY · Substantial damageNTSB CHI04LA036Accident · No injuriesLimited investigationFinal reportCessna 182R · Wausau, WIThe pilot 's improper flare which resulted in a hard landing, and the flight instructors inadequate supervision.Nov 22, 2003 · N323KW · Substantial damageNTSB ATL04LA040Accident · No injuriesLimited investigationFinal reportCessna 172 · Hickory, NCThe CFI inadequate supervision, and failure to maintain directional control during the attempted touch-and-go landing.Nov 22, 2003 · N61924 · Substantial damageNTSB MIA04CA028Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe student pilots improper landing flare and his improper recovery from a bounced landing resulting in a hard landing and damage to the airplane.Nov 21, 2003 · N378FA · Substantial damageNTSB CHI04LA034Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Superior, WIThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the ditch that the airplane contacted.Nov 21, 2003 · N28693 · Substantial damageNTSB DEN04LA023Accident · No injuriesLimited investigationFinal reportFairchild Swearingen SA226TC · Grand Junction, COthe operator's improper maintenance and servicing of the airplane's nose landing gear assembly, resulting in the collapse of the nose landing gear during the landing roll. Contributing factors include the nose section of the airplane's subsequent contact with…Nov 18, 2003 · N332BA · Substantial damageNTSB MIA04CA025Accident · No injuriesData collectionFinal reportCessna 152 · Ormond Beach, FLThe student pilot improper recovery from a bounced landing, which resulted in a hard landing and damage to the airplane.Nov 15, 2003 · N24887 · Substantial damageNTSB ATL04LA037Accident · No injuriesLimited investigationFinal reportHughes OH-6A · Greenville, SCThe pilot's improper landing flare, resulting in a hard landing and a main rotor/tailboom strike.Nov 15, 2003 · N536 · Substantial damage