NTSB investigations, 2001, FL

35 cases where the phase of flight was Landing.

Cases per year

19622026
NTSB investigations, 2001, 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\") = 2001
    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 ATL02LA018Accident · No injuriesLimited investigationFinal reportPitts S-1S · Sanford, FLThe pilot's failure to maintain control of the airplane during landing roll in a tailwind, which resulted in a nose-over on the runway.Dec 19, 2001 · N522H · Substantial damageNTSB MIA02LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco Island, FLthe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the runway, impacting with a windsock, and nosing over in soft terrain.Oct 25, 2001 · N93455 · Substantial damageNTSB ATL02LA005Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Wales, FLThe pilot's improper decision to land on a wet sod runway which resulted in a loss of directional control during landing. Factors were the wet grass strip which allowed the airplane to hydroplane.Oct 24, 2001 · N4033W · Substantial damageNTSB MIA01LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Melbourne, FLthe pilot's failure to maintain directional control of the aircraft during the landing rollout while landing in gusty crosswind conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it…Sep 30, 2001 · N5447F · Substantial damageNTSB ATL01LA113Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Punta Gorda, FLThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the landing gear..Sep 9, 2001 · N4070E · Substantial damageNTSB MIA01LA230Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe student pilot's improper landing flare/touchdown while attempting to make a soft field landing during a supervised solo flight which resulted in substantial damage to the aircraftSep 5, 2001 · N704KK · Substantial damageNTSB ATL01LA102Accident · No injuriesLimited investigationFinal reportBeech 55 · Jacksonville, FLThe failure of the left landing gear extention rod for undetermined reasons that resulted in a landing with the gear retracted.Aug 25, 2001 · N521U · Substantial damageNTSB MIA01LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student pilot's improper recovery from a bounced landing resulting in a hard landing on the nose landing gear, collapse of the nose landing, the airplane sliding off the runway, and the airplane being destroyed by a postcrash fire.Jul 29, 2001 · N944AC · DestroyedNTSB ATL01LA089Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLThe student pilots improper flare, and improper recovery from a bounced landing. A factor was the student pilot's lack of total experience.Jul 21, 2001 · N448ER · Substantial damageNTSB ATL01LA104Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Pahokee, FLThe pilot's failure to follow the checklist while making an approach for landing resulting in a wheels up landing. Contributing to the accident was the certified flight instructor inadequate supervision of the rated pilot receiving instruction.Jul 9, 2001 · N747DN · Substantial damageNTSB ATL01LA078Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas DC-3 · Titusville, FLThe pilot's failure to maintain directional control during a bounced landing, resulting in a ground loop and subesequent collision with the runway.Jul 9, 2001 · N3239T · Substantial damageNTSB ATL01LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Cedar Key, FLThe pilot's improper in-flight decision to abort the landing resulted in the collision with water. A factor was the variable wind condition.Jul 7, 2001 · N52452 · Substantial damageNTSB ATL01LA084Accident · No injuriesLimited investigationFinal reportFleet BI-PLANE · Homestead, FLThe pilot's improper use of flight controls during a landing on a sod airstrip that resulted in a nose over.Jul 6, 2001 · NC8627 · Substantial damageNTSB MIA01LA174Accident · No injuriesLimited investigationFinal reportSocata TB-20 · Naples, FLThe collapse of the left main landing gear for undetermined reasons resulting in the loss of directional control and subsequent on-ground collision with a ravine.Jun 23, 2001 · N1887S · Substantial damageNTSB MIA01FA169Accident · Minor injuriesField investigationFinal reportBell 206-L4 · Daytona Beach, FLThe failure of the pilot to maintain directional control following a hard landing resulting from a failure to maintain rotor rpm.Jun 20, 2001 · N802DS · Substantial damageNTSB ATL01LA050Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lake Wales, FLThe pilot's improper use of flight controls during a bounced landing, and subsequent collision with the ground. A factor of the collision is the rough and uneven terrain.May 2, 2001 · N1491S · Substantial damageNTSB MIA01LA137Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Venice, FLThe failure of the pilot to attain the proper touchdown point resulting in a long landing and subsequent collapse of the right main landing gear. Also, failure of the pilot to perform a go-around following a long landing.Apr 27, 2001 · N876BB · Substantial damageNTSB MIA01LA124Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Destin, FLfailure of the flight instructor to maintain directional control of the aircraft during the landing rollout while landing with a crosswind in gusty conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial…Apr 17, 2001 · N1364N · Substantial damageNTSB MIA01LA122Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Dade City, FLthe pilot's inadequate recovery from a bounced landing, and loss of directional control which resulted in an in-flight collision with a fence during the go-around, resulting in a subsequent forced landing in a pasture.Apr 14, 2001 · N81189 · Substantial damageNTSB MIA01LA118Accident · No injuriesLimited investigationFinal reportCessna 172R · Ormond Beach, FLthe flight instructor's inadequate supervision and the dual student's improper use of brakes which resulted in the loss of directional control and collision with a wind sock. Contributing to the accident was the flight instructor's failure to follow…Apr 9, 2001 · N436ER · Substantial damageNTSB MIA01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lakeland, FLThe pilot's failure to flare on landing resulting in a hard landing.Apr 6, 2001 · N74SM · Substantial damageNTSB MIA01FA108Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Marco Island, FLThe failure of the pilot to maintain control of the aircraft during a rejected landing and the collision with the terrain and mangrove trees. A finding in the investigation was the presence of quinine in the blood and urine during postmortem toxicological…Mar 31, 2001 · N900CE · DestroyedNTSB MIA01LA101Accident · No injuriesLimited investigationFinal reportRobinson R22 · Okeechobee, FLan in-flight collision with the ground during a simulated engine failure, and autorotation, which resulted in the tailboom separating. A contributing factor in this accident was the pilot allowed the rotor rpm to decay which resulted in inadequate rotor rpm…Mar 16, 2001 · N666BH · Substantial damageNTSB MIA01LA094Accident · No injuriesLimited investigationFinal reportCessna 172L · Fort Lauderdale, FLThe total failure of the yoke weld assembly due to corrosion resulting in the inability of the flight crew to maintain elevator control of the airplane. Additionally, inadequate annual inspection of the airplane by other maintenance personnel for failure to…Mar 3, 2001 · N3802Q · Substantial damageNTSB MIA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melbourne, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll of the touch-and-go landing resulting in the on ground collision with a ditch and subsequent separation of the nose gear wheel and fork assembly and…Mar 3, 2001 · N4949N · Substantial damageNTSB MIA01IA091Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLIncomplete compliance with a non-mandatory Cessna Service Information Letter by an unknown person resulting in pulling through of the attach bolt of the upper and lower link assemblies and subsequent rotation of the right wheel assembly. Additionally,…Mar 3, 2001 · N108GP · Minor damageNTSB MIA01LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Naples, FLThe student's failure to maintain control of the aircraft during landing due to his improper landing flare height and improper recovery from a bounced landing, resulting in a nose landing gear collapse, and excursion off the runway.Feb 25, 2001 · N942AC · Substantial damageNTSB MIA01LA078Accident · No injuriesLimited investigationFinal reportLearjet 35A · Punta Gorda, FLthe pilot misjudged the flare resulting in a hard landing, and impact with the runway. A factor in the accident was reduced visibility because of ground fog.Feb 14, 2001 · N394JP · Substantial damageNTSB ATL01LA035Accident · Minor injuriesLimited investigationFinal reportMichael E. Nourse RV-6A · Immokalee, FLThe pilot's improper flare, and his evaluation of the gusty wind conditions resulted in the collision with the terrain.Feb 12, 2001 · N6279E · Substantial damageNTSB MIA01FA074Accident · Minor injuriesField investigationFinal reportAmerican 8KCAB · Leesburg, FLThe failure of the pilot of N123WA and the failure of both pilots of N301NL to adequately insure visual separation between their aircraft and other aircraft in the landing pattern, resulting in a runway collision. Factors contributing to the accident were the…Feb 9, 2001 · N123WA · 2 aircraft · Substantial damageNTSB ATL01LA030Accident · No injuriesLimited investigationFinal reportLearjet 25B · Ft. Pierce, FLThe mechanic's failure to properly install and secure the left main landing gear aft trunnion pin in accordance with procedures.Feb 4, 2001 · N48WA · Substantial damageNTSB ATL01LA032Accident · No injuriesLimited investigationFinal reportCessna 208 · Key West, FLThe airplanes' inadvertent collision with a swell during a water landing near a ferry boat that resulted the overload failure of the rear float/strut assembly.Jan 31, 2001 · N208KW · Substantial damageNTSB MIA01LA068Accident · No injuriesLimited investigationFinal reportCessna 152 · Edgewater, FLThe student pilot's failure to maintain directional control on landing rollout with a crosswind. This resulted in the airplane departing the runway, colliding with a berm/ridge, becoming airborne, and colliding with the terrain in a nose down attitude.Jan 29, 2001 · N152DF · Substantial damageNTSB ATL01LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLThe pilots failure to maintain directional control during the landing roll, which resulted in the collision with the airport sign.Jan 18, 2001 · N704ZF · Substantial damageNTSB MIA01LA056Accident · Serious injuriesLimited investigationFinal reportMaule MXT-7-180A · Perry, FLThe loss of control on landing due to the student's improper recovery from a bounced landing, and the resulting nose over on the grass runway.Jan 7, 2001 · N40030 · Substantial damage