NTSB investigations, 2003, FL

28 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 2003, FL per year, 1962–2026: 3,027 cases
19624
19633
196477
1965113
196694
1967121
196883
196972
197066
197172
197293
197390
197481
197559
197662
197772
197879
197968
198067
198148
198255
198344
198453
198545
198662
198759
198848
198952
199028
199126
199227
199330
199441
199528
199627
199729
199845
199931
200033
200135
200232
200328
200436
200550
200650
200748
200840
200925
201025
201133
201222
201322
201443
201533
201626
201734
201842
201934
202029
202129
202221
202321
202428
202529
202625

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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    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 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 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 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 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 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 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 MIA04CA009Accident · No injuriesData collectionFinal reportCessna 172N · Melbourne, FLInadvertent full retraction of the flaps, while recovering from a bounced landing, resulting in an inadvertent stall, uncontrolled descent, and subsequent impact with terrain.Oct 21, 2003 · N734JT · Substantial damageNTSB MIA04CA006Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Everglades City, FLThe pilot's failure to maintain the proper glide path during the approach to land, which resulted in him undershooting the runway.Oct 19, 2003 · N198GM · Substantial damageNTSB MIA04CA003Accident · No injuriesData collectionFinal reportWilliam F. Lair RV-6A · Fort Myers, FLThe pilot in command's improper recovery from a bounced landing, which resulted in a hard landing and damage to the airplane.Oct 15, 2003 · N710WL · 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 MIA03LA166Accident · Minor injuriesLimited investigationFinal reportRobinson Robinson R22 Beta · Odessa, FLThe failure of the pilot to maintain the proper airspeed during the practice 180-degree autorotational landing and his failure to maintain main rotor rpm resulting in a hard landing. A contributing factor in the accident was the delay by the designated pilot…Aug 20, 2003 · N129YE · Substantial damageNTSB MIA03LA169Accident · No injuriesLimited investigationFinal reportBeech 35J · Avon Park, FLThe failure of the pilot to maintain directional control during landing resulting in the airplane drifting to the right, encountering standing water on the runway edge, and running off the runway where it incurred substantial damage.Aug 10, 2003 · N4975B · Substantial damageNTSB MIA03CA151Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2T · Crystal River, FLThe student pilot 's failure to maintain control while landing in crosswind which resulted in airplane departing the runway and incurring damage.Jul 25, 2003 · N643AM · Substantial damageNTSB MIA03LA145Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Fort Pierce, FLThe pilot's failure to maintain directional control of the airplane during landing roll resulting in collision with trees after the airplane departed the runway.Jul 20, 2003 · N5224Y · Substantial damageNTSB MIA03CA125Accident · No injuriesData collectionFinal reportCessna 172S · Melbourne, FLThe pilot's improper flare and inadequate recovery from a bounced landing. Contributing factors were the pilot's failure to maintain directional control and his failure to execute a go-around.Jun 18, 2003 · N53352 · Substantial damageNTSB MIA03CA113Accident · Minor injuriesData collectionFinal reportCessna 120 · Plant City, FLThe failure of the pilot to maintain control of the airplane resulting in it nosing over during the landing roll.May 27, 2003 · N76494 · Substantial damageNTSB MIA03IA110Incident · No injuriesIncident investigationFinal reportCessna 402C · Miami, FLThe inadequate annual inspection of the airplane by other maintenance personnel for failure to note an incorrect washer was installed securing the upper and lower torque links, resulting in separation of the upper and lower links and subsequent rotation of…May 22, 2003 · N402DD · No damageNTSB MIA03LA101Accident · No injuriesLimited investigationFinal reportCessna 177-RG · Clearwater, FLThe pilot's failure to maintain directional control during landing roll resulting in the failure and separation of the right main landing gear, partial collapse of the nose landing gear, and substantial damage to the airplane.Apr 28, 2003 · N8015G · Substantial damageNTSB MIA03LA100Accident · No injuriesLimited investigationFinal reportCessna 172P · Lantana, FLthe pilot's use of excessive airspeed and the improper touchdown point during the landing roll, which resulted in the airplane departing the runway, and impacting with trees.Apr 27, 2003 · N51898 · 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 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 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 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 MIA03FA065Accident · 1 fatalField investigationFinal reportAerofab Lake 250 · Weirsdale, FLThe inadequate flare by the pilot-in-command on the calm water resulting in the in-flight collision with the water and subsequent nose over.Feb 20, 2003 · N811JG · DestroyedNTSB ATL03LA039Accident · No injuriesLimited investigationFinal reportRobinson R22 · Fort Lauderdale, FLThe private pilots improper use of flight controls during a run on landing resulting in a roll over.Feb 1, 2003 · N528EE · Substantial damageNTSB MIA03CA053Accident · No injuriesData collectionFinal reportCessna 182R · Everglades City, FLstudent pilot's improper use of the brakes at the landing touchdown which caused the left main landing gear tire to burst, resulting in the student and certified flight instructor pilots not being able to maintain control of the airplane, and the subsequent…Jan 26, 2003 · N9973H · Substantial damageNTSB MIA03CA041Accident · Serious injuriesData collectionFinal reportCessna 150K · Everglades City, FLThe instructor's failure to maintain airspeed during climb after lift off from an aborted landing, resulting in the airplane stalling, entering a spin, and crashing into water at the departure end of the runway. Contributing to the accident was the…Jan 11, 2003 · N5629G · Substantial damage