NTSB investigations, 2000, FL

33 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 2000, 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\") = 2000
    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 MIA01LA038Accident · No injuriesLimited investigationFinal reportGrob G102 · Clermont, FLThe pilot's premature extension of the speed brakes on landing resulting in the glider colliding with trees short of the runway.Dec 9, 2000 · N36WW · Substantial damageNTSB MIA01LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe student pilot's failure to maintain a visual look out while transitioning from the active runway to a taxiway resulting in an on-ground collision with a taxiway sign.Nov 30, 2000 · N617FT · Substantial damageNTSB MIA01LA024Accident · No injuriesLimited investigationFinal reportCessna 172P · Inverness, FLa loss of directional control on landing due to the pilot's failure to execute a proper flare and recovery from the resultant bounced landing, causing the airplane to depart the runway, enter the uneven grass infield, and sustain a nose over.Nov 4, 2000 · N54729 · Substantial damageNTSB MIA01LA020Accident · No injuriesLimited investigationFinal reportJohn S. Eberle Pitts Special S1S · Sebring, FLImproper inspection of the tailwheel assembly by the pilot which resulted in shimmy of the tailwheel assembly during landing due to a worn bearing caused by dirt infiltration which resulted in the pilot being unable to control the airplane and the airplane…Oct 30, 2000 · N39124 · Substantial damageNTSB MIA01LA019Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLThe failure of the pilot to maintain directional control during landing with a quartering tail wind, resulting in the aircraft nosing over and coming to rest inverted.Oct 27, 2000 · N32049 · Substantial damageNTSB MIA01LA018Accident · No injuriesLimited investigationFinal reportMooney M-20J · Deland, FLthe dual student's improper use of the brakes and the flight instructor's inadequate supervision which resulted in a loss of directional control and a subsequent ground swerve during which the aircraft exited the runway and collided with a runway sign.Oct 26, 2000 · N201SE · Substantial damageNTSB MIA01LA010Accident · No injuriesLimited investigationFinal reportJim Price Pitts Special S · Indiantown, FLThe failure of the pilot of N56JP, during landing rollout, to see and avoid N49713, who was turning off the runway after landing from the opposite direction, resulting in the 2 aircraft colliding on the runway.Oct 21, 2000 · N56JP · 2 aircraft · Substantial damageNTSB ATL01LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Indiantown, FLThe pilot had excessive airspeed, misjudged the landing distance, and did not perform a go-around, which resulted in a nose over. The ditch was a contributing factor.Oct 11, 2000 · N7396G · Substantial damageNTSB ATL01LA005Accident · Serious injuriesLimited investigationFinal reportAlvin R. Kemmet Tango 2 · New Port Richey, FLThe uncertified pilot's improper recovery from a bounced landing which resulted in the collapse of the nose gear asasembly and subsequent nose over. Factors were the pilot's lack of certification and the runway light.Oct 2, 2000 · N29AK · Substantial damageNTSB MIA00IA266Incident · No injuriesIncident investigationFinal reportBeech 1900C · Miami, FLThe excessive clearance between the shuttle valve and the shuttle bore in the end cap of the left main landing gear actuator for undetermined reasons either during overhaul or manufacturing resulting in failure to build hydraulic pressure using the emergency…Sep 16, 2000 · N194GA · Minor damageNTSB ATL00LA090Accident · No injuriesLimited investigationFinal reportJack McDaniel Rans S12XL · Homestead, FLThe pilot's improper flare during landing which collapsed the landing gear.Sep 9, 2000 · N823S · Substantial damageNTSB MIA00LA254Accident · No injuriesLimited investigationFinal reportBeech D-45 · Jacksonville, FLthe pilot's improper landing flare which resulted the right wing dropping and impacting the runway.Aug 26, 2000 · N20685 · Substantial damageNTSB MIA00LA248Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Niceville, FLThe pilots failure to drop the advertising banner prior to a precautionary landing resulting in the aircraft stalling and landing hard. Contributing to the accident was the pilots failure to maintain airspeed during climb after banner pickup resulting in the…Aug 25, 2000 · N57648 · Substantial damageNTSB MIA00LA243Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · St. Petersburg, FLThe pilot's improper judgment not to sit in the pilot's seat (rear seat) and improper use of brakes on landing roll resulting in a loss of directional control and subsequent nose over.Aug 20, 2000 · N70673 · Substantial damageNTSB MIA00LA239Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Zephyrhills, FLThe student pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall/spin and subsequent in-flight collision with terrain.Aug 16, 2000 · N7679 · Substantial damageNTSB MIA00LA230Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · New Smyrna Bch., FLthe pilot's failure to maintain control of the airplane during the landing roll. Factors in this accident were; a crosswind, and the pilot lack of experience in this kind of aircraft.Aug 3, 2000 · N2143M · Substantial damageNTSB MIA00LA192Accident · No injuriesLimited investigationFinal reportEuropa Europa XS TRI-GEAR · Lakeland, FLthe flight instructor's inadequate supervision that resulted in the dual student performing an improper landing flare/touchdown which resulted in a hard landing and overload to the nose landing gear assembly.Jun 28, 2000 · N912EA · Substantial damageNTSB MIA00LA165Accident · No injuriesLimited investigationFinal reportLet L-13 · Pensacola, FLThe student's failure to maintain the proper landing pattern altitude resulting in an undershoot during landing and collision with a fence. A factor in the accident was the pilot's failure to realize the spoilers were still deployed during the undershoot.May 22, 2000 · N90867 · Substantial damageNTSB MIA00LA148Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Jacksonville, FLthe student pilot's misjudgment of the aircraft's altitude and subsequent maneuver to avoid an obstacle, that resulted in a loss of airspeed, an inadvertent stall, and an inflight loss of control, which resulted in damage to the aircraft during landing.May 6, 2000 · N5738S · Substantial damageNTSB ATL00LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Marco Island, FLThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a nose over.May 2, 2000 · N1449T · Substantial damageNTSB ATL00LA050Accident · No injuriesLimited investigationFinal reportCessna 501 · Orlando, FLThe pilot's failure to follow the landing checklist that resulted in the delay of lowering the landing gear before touchdown.May 2, 2000 · N56LW · Substantial damageNTSB MIA00LA136Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Immokalee, FLthe pilot misjudged the flare resulting in a hard landing short of the intended landing site, subsequently impacting the ground, and nosing over.Apr 16, 2000 · N238DM · Substantial damageNTSB MIA00LA143Accident · No injuriesLimited investigationFinal reportNew Standard D-25 · Lakeland, FLthe pilot's improper inflight planning/decision to land long, with a tailwind, on a wet grass runway that resulted in the loss of control and the airplane exiting the runway, incurring substantial damage.Apr 15, 2000 · N930V · Substantial damageNTSB MIA00LA137Accident · Minor injuriesLimited investigationFinal reportWalden A. Cooper Pitts S1S · Daytona Beach, FLCollapse of the tail wheel to the right during landing rollout when the forward attach bolt sheared for undetermined reasons. This resulted in the aircraft's rudder deflecting to the right, the pilot losing directional control, and the aircraft running off…Apr 11, 2000 · N27235 · Substantial damageNTSB MIA00LA116Accident · No injuriesLimited investigationFinal reportStearman A75N1 · Fort Lauderdale, FLThe pilot's failure to maintain directional control after touchdown and the subsequent wing tip strike, ground loop, and runway excursion.Mar 22, 2000 · N541JK · Substantial damageNTSB MIA00LA110Accident · Minor injuriesLimited investigationFinal reportAeronca-Bubeck Irving BUBECK-AERONCA · Merritt Island, FLThe flight instructors inadequate supervision of the dual student resulting in the student pushing forward on the control stick during a bounced landing until the aircraft impacted the runway, bounced, landed hard, and broke the main landing gear.Mar 17, 2000 · N6030T · Substantial damageNTSB MIA00LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLthe flight instructor's inadequate supervision of the student pilot by allowing the student to fly in gusty wind conditions with excessive crosswinds that resulting in the student pilot not maintaining control and nosing the aircraft over.Mar 15, 2000 · N569JH · Substantial damageNTSB ATL00IA035Incident · No injuriesIncident investigationFinal reportCessna CE-560 · Key Largo, FLThe malfunction of the nose gear locking mechanism for undetermined reason.Mar 5, 2000 · N314QS · Minor damageNTSB MIA00LA097Accident · No injuriesLimited investigationFinal reportHughes TH-55 · Odessa, FLThe pilot's improper use of flight controls (cyclic and col lective) during a autorotation resulting in a hard landing and subsequent roll over.Feb 28, 2000 · N9518K · Substantial damageNTSB ATL00LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe pilot's failure to maintain visual lookout during flight operations under Visual Flight Rules. A factor is that the pilot was not on the airport radio frequency.Feb 12, 2000 · N757XF · 2 aircraft · Substantial damageNTSB MIA00LA071Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Deland, FLThe pilot's evasive maneuver during landing roll due to panic after hearing another pilot report landing on the opposite runway resulting in the pilot losing directional control and nosing over in soft terrain. A factor in the accident was the pilot of the…Jan 22, 2000 · N663C · Substantial damageNTSB MIA00LA072Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Palmetto, FLFailure for undetermined reasons of the right main landing gear strut during landing resulting in collapse of the right main landing gear.Jan 19, 2000 · N82029 · Substantial damageNTSB MIA00LA061Accident · No injuriesLimited investigationFinal reportEaa Chapter 229 Zenair 601 · Kissimmee, FLThe pilot's failure to maintain directional control on landing resulting in the airplane going off the side of the runway and colliding with a barricade.Jan 4, 2000 · N229FF · Substantial damage