NTSB investigations, 2002

516 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 year(c.\"eventDate\") = 2002
    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 ANC03LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fairbanks, AKThe pilot's excessive use of brakes during the landing roll, which resulted in the nose over of the airplane.Nov 3, 2002 · N1933B · Substantial damageNTSB MIA03LA010Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Pell City, ALThe pilot's failure to maintain directional control following landing touchdown, resulting in a runway excursion and collision with a ditch off the left side of the runway.Nov 2, 2002 · N9558E · Substantial damageNTSB LAX03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Corona, CAThe pilot's misjudged landing flare. Also causal were the pilot's improper bounced landing recovery procedures and inadvertent swerve, resulting in the landing gear collapsing from overload.Nov 2, 2002 · N5129P · Substantial damageNTSB MIA03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Vero Beach, FLThe collapse of the nose landing gear for undetermined reasons resulting in the loss of directional control and the subsequent collapse of the main landing gears.Oct 25, 2002 · N92897 · Substantial damageNTSB NYC03LA013Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Cottageville, WVThe pilot's improper decision not to over fly the landing area, which resulted in an in-flight collision with power lines.Oct 23, 2002 · N71AV · No damageNTSB IAD03LA009Accident · No injuriesLimited investigationFinal reportCessna 185 · Waterville, METhe pilot's excessive braking during the landing roll, which resulted in a nose over. A factor was the quartering tailwind.Oct 22, 2002 · N7321H · Substantial damageNTSB DEN03LA011Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Fort Collins, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airspeed resulting in a stall.Oct 22, 2002 · N41807 · DestroyedNTSB ANC03CA004Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, resulting in the left wing striking the runway.Oct 21, 2002 · N1302D · Substantial damageNTSB CHI03LA011Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, MIThe pilot not maintaining directional control during landing and the inoperative right main landing gear brake. Contributing factors were the failed brake master cylinder seal, resulting in a hydraulic leak, the inadequate preflight by the pilot, the fuel…Oct 20, 2002 · N56655 · Substantial damageNTSB LAX03LA010Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Hayward, CAThe flight instructor's inadequate supervision and delayed remedial action, which resulted in a hard landing.Oct 18, 2002 · N61416 · Substantial damageNTSB CHI03LA013Accident · 1 fatalLimited investigationFinal reportWondrasek Rans S-10 Sakota · Missouri Valley, IAThe pilot's failure to maintain control and adequate airspeed, resulting in the inadvertent stall/spin. A factor was the low altitude.Oct 18, 2002 · N228DW · DestroyedNTSB SEA03LA005Accident · 2 fatalLimited investigationFinal reportIV Lancair IV · Coeur d'Alene, IDThe pilot's inadequate flare and his failure to maintain runway alignment. The pilot's lack of familiarity,downsloping terrain, and trees are contributing factors.Oct 15, 2002 · N599L · Substantial damageNTSB NYC03LA007Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR-20 · Point Pleasant, WVAn inadvertent collision with wildlife. A factor in the accident was wildlife having access to the runway environment.Oct 15, 2002 · N137CD · Substantial damageNTSB FTW03LA010Accident · No injuriesLimited investigationFinal reportBeech K35 · Flippin, ARThe pilot's selection of an unsuitable landing area. A contributing factor was the pilot's disorientation.Oct 14, 2002 · N9508R · Substantial damageNTSB DEN03LA007Accident · No injuriesLimited investigationFinal reportMooney M20J · Englewood, COthe complete collapse of the landing gear, during landing roll, for undetermined reasons.Oct 14, 2002 · N8084D · Substantial damageNTSB SEA03LA004Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Helena, MTThe student pilot's failure to maintain clearance from a tower during an aborted landing. Factors include landing with a tailwind and a tower.Oct 13, 2002 · N8752 · Substantial damageNTSB LAX03LA006Accident · No injuriesLimited investigationFinal reportCessna 310L · North Las Vegas, NVThe pilot's failure to use the landing checklist due to his diverted attention, which resulted in a wheels-up landing.Oct 13, 2002 · N2209F · Substantial damageNTSB SEA03LA003Accident · No injuriesLimited investigationFinal reportMooney M20K · Rexburg, IDThe pilot's failure to perform a go-around once it became evident that his remedial action was not adequate to overcome the porpoise/pilot-induced oscillation that occurred during the landing flare. Factors include the pilot's inadvertent repeated…Oct 12, 2002 · N231EH · Substantial damageNTSB NYC03LA006Accident · No injuriesLimited investigationFinal reportBeech 58 · Allentown, PAThe pilot's inadvertent retraction of the landing gear on the ground.Oct 12, 2002 · N8199R · Substantial damageNTSB ANC03LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Wasilla, AKThe instructor's inadequate supervision of the pilot-rated dual student, and the dual student's excessive use of brakes during the landing roll, which resulted in the nose over of the airplane.Oct 11, 2002 · N7027D · Substantial damageNTSB MIA03LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Cullman, ALthe pilot-in-command's (CFI) delayed remedial action, and improper recovery from a bounced landing, resulting in a hard landing, and impact with a parked airplane.Oct 9, 2002 · N22DB · Substantial damageNTSB DEN03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Watkins, COthe pilot's inability [not possible] to control the airplane during landing roll due to the failure of the left brake, and the subsequent inadvertent ground loop.Oct 9, 2002 · N7672K · Substantial damageNTSB NYC03FA002Accident · Serious injuriesField investigationFinal reportCessna 525A · Dexter, MEwas the pilot's improper decision to land with excessive speed, and his delayed decision to perform an aborted landing, both of which resulted in a runway overrun. A factor was the tail wind.Oct 7, 2002 · N57EJ · Substantial damageNTSB FTW03LA007Accident · No injuriesLimited investigationFinal reportMooney M20K · Port Sulphur, LAthe pilot's failure to maintain directional control while landing, which resulted in an in-flight collision with trees during an attempted go-around. A factor was the wet runway condition.Oct 6, 2002 · N231QL · Substantial damageNTSB SEA03LA001Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air 4000 · Tillamook, ORThe fracture of the weld joining the left main wheel strut to the left/right main wheel axel resulting in separation of the strut from the axle during an unknown phase of operation which ultimately lead to the left gear collapse and subsequent nose-over on…Oct 5, 2002 · N4949 · Substantial damageNTSB CHI03CA004Accident · No injuriesData collectionFinal reportCessna 182E · Oslo, MNFailure of the pilot-in-command to maintain directional control during the landing roll. Contributing factors were the wind gust and the soft terrain adjacent to the runway.Oct 5, 2002 · N3345Y · Substantial damageNTSB DEN03LA001Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Morgan, UTthe pilot's inadequate inflight planning and decision which resulted in an unsuitable off-field landing site. A contributing factor was downdraft weather conditions.Oct 3, 2002 · N99805 · DestroyedNTSB FTW03LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Norman, OKThe pilot's failure to maintain directional control. A factor was the inadequate flare.Oct 2, 2002 · N9623C · Substantial damageNTSB FTW03LA001Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235C · San Antonio, TXThe pilot's failure to compensate for the existing winds conditions. A contributing factor was the prevailing tailwind.Oct 1, 2002 · N4269B · DestroyedNTSB CHI03LA001Accident · No injuriesLimited investigationFinal reportMooney M20J · Chicago, ILThe pilot's inadequate compensation for wind, and his failure to maintain directional control.Oct 1, 2002 · N22RJ · Substantial damageNTSB MIA02LA172Accident · No injuriesLimited investigationFinal reportRonald Levee Kitfox IV · De Land, FLThe failure of the pilot to maintain directional control of the airplane during the flare/touchdown resulting in substantial damage. A factor in the accident was the poor in-flight planning decision by the pilot for his continuing the approach in close…Sep 29, 2002 · N1441Z · Substantial damageNTSB FTW02LA268Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Del Rio, TXThe pilot's failure to maintain control of the helicopter. A contributing factor was the reported gusting wind conditions.Sep 29, 2002 · N952LC · Substantial damageNTSB SEA02LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Spokane, WAThe flight instructor's delay of the remedial action necessary to correct for the student pilot's error during the landing flare. Factors include the student pilot's misjudgment of the aircraft's height above the runway when he initiated the flare.Sep 28, 2002 · N132ND · Substantial damageNTSB SEA02LA183Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18 · Gannett, IDThe pilot's excessive braking during the landing rollout.Sep 28, 2002 · N380CC · Substantial damageNTSB LAX02LA301Accident · No injuriesLimited investigationFinal reportCessna 182G · Paradise, CAthe pilot's improper flare resulting in a hard landing.Sep 28, 2002 · N2443R · Substantial damageNTSB FTW02LA269Accident · No injuriesLimited investigationFinal reportCessna 421B · Mineral Wells, TXThe pilot's failure to maintain a proper descent rate which resulted hard landing and a subsequent failure of the main landing gear.Sep 28, 2002 · N7926R · Substantial damageNTSB ATL02LA177Accident · No injuriesLimited investigationFinal reportSchempp-Hirth KA8B · Tullahoma, TNThe student pilot misjudged the airspeed and altitude during a visual approach to land that resulted in the in-flight collision with the trees.Sep 28, 2002 · N8747 · Substantial damageNTSB SEA02LA182Accident · No injuriesLimited investigationFinal reportCessna 172RG · Billings, MTThe failure of the landing gear actuator during landing as a result of fatigue.Sep 26, 2002 · N6525R · Substantial damageNTSB SEA02LA181Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Shaw Island, WAThe pilot's failure to adequately compensate for ambient wind conditions. Factors include the pilot's misjudgment of distance/altitude, gusting crosswinds, and trees growing near the edge of the airstrip.Sep 26, 2002 · N736PJ · Substantial damageNTSB NYC02LA194Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Erwinna, PAThe pilot's failure to maintain directional control during an aborted landing. A factor was a crosswind.Sep 24, 2002 · N4210Y · Substantial damageNTSB CHI02LA293Accident · No injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAThe premature fracture of the cyclic/mixture bracket resulting in the inability to conduct a landing flare.Sep 24, 2002 · N1040S · Substantial damageNTSB SEA02LA178Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Anacortes, WANormal braking application was excessive during the landing roll resulting in the aircraft nosing over.Sep 23, 2002 · N9641 · Substantial damageNTSB SEA02LA179Accident · No injuriesLimited investigationFinal reportCessna R172K · Salmon, IDFailure to maintain airspeed while on approach which resulted in an aerodynamic stall and hard landing.Sep 21, 2002 · N1071V · Substantial damageNTSB SEA02LA177Accident · No injuriesLimited investigationFinal reportCessna 182L · McCall, IDThe pilot's failure to maintain adequate airspeed and an acceptable rate of descent while on short final for landing, and his failure to maintain directional control after the resultant hard landing. Factors include a ditch near the temporary runway (taxiway)…Sep 21, 2002 · N42862 · DestroyedNTSB MIA02CA177Accident · No injuriesData collectionFinal reportAviat A-1 · Cherry Point, NCthe pilot misjudged the landing flare, resulting in a hard landing, an inadvertent ground loop, and the subsequent impact with the runway.Sep 21, 2002 · N6QR · Substantial damageNTSB IAD02LA096Accident · No injuriesLimited investigationFinal reportCessna 172N · Bumpass, VAThe pilot's failure to maintain directional control during the landing. A factor was the narrow runway width.Sep 21, 2002 · N737TG · Substantial damageNTSB CHI02LA291Accident · No injuriesLimited investigationFinal reportCessna 172S · Boyne Falls, MIThe pilot's improper flare during landing.Sep 21, 2002 · N784SA · Substantial damageNTSB CHI02CA287Accident · No injuriesData collectionFinal reportCessna 150G · Dodge Center, MNThe pilot's misjudgment of distance resulting in an undershoot of the runway.Sep 18, 2002 · N2870S · Substantial damageNTSB LAX02LA289Accident · No injuriesLimited investigationFinal reportCessna 152 · El Cajon, CAThe pilot's misjudged landing flare, which resulted in a hard landing.Sep 17, 2002 · N5100B · Substantial damageNTSB ANC02LA122Accident · No injuriesLimited investigationFinal reportCessna 206 · Circle, AKA partial separation of the nose wheel flange from the hub that resulted in a nose over during the landing roll.Sep 17, 2002 · N8515Q · Substantial damage