OpenAirDocs.org

NTSB investigations, 2002

153 cases where the phase of flight was Takeoff.

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\") = 2002
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 300)
  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 NYC03LA034Accident · No injuriesLimited investigationFinal reportSocata TB 9 · Mount Union, PAThe pilot's delay in aborting the takeoff. A factor was the soft runway.Dec 31, 2002 · N136ER · Substantial damageNTSB ANC03LA018Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Palmer, AKThe pilot's selection of an unsuitable takeoff area, and his failure to achieve takeoff speed which resulted in an on ground collision with a ditch. Contributing factors were soft and snow-covered terrain, and a ditch.Dec 18, 2002 · N325T · Substantial damageNTSB CHI03LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Jackson, MIThe pilot's failure to follow the checklist and extend the landing gear resulting in a gear up landing.Dec 15, 2002 · N948SB · Substantial damageNTSB NYC03IA030Incident · No injuriesIncident investigationFinal reportPiper PA-601P · Manassas, VAThe pilot' failure to maintain directional control during an aborted takeoff.Dec 13, 2002 · N141AJ · Minor damageNTSB CHI03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Greensburg, INFailure of the pilot to maintain directional control during the takeoff roll. Contributing factors included inadequate planning/decision by the pilot for attempting to depart from the slush covered runway, the slush covered runway itself, and the falling snow.Dec 13, 2002 · N793MA · Substantial damageNTSB SEA03LA010Accident · No injuriesLimited investigationFinal reportLearjet 36A · Astoria, ORCollision with an elk during the takeoff roll. Factors include dark night VFR conditions.Dec 3, 2002 · N546PA · DestroyedNTSB MIA03CA063Accident · No injuriesData collectionFinal reportConsolidated Aeronautics LA-4-200 · Blountstown, FLThe failure of the certified flight instructor (CFI) to maintain clearance between the wingtip and a water marker bouy resulting in contact with the wingtip.Dec 2, 2002 · N6193V · Substantial damageNTSB MIA03LA021Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Brevard, NCthe jamming of the elevator control system for undetermined reason, which resulted in the airplane departing the runway, and impacting with a ditch, during the aborted takeoff.Dec 1, 2002 · N3529F · Substantial damageNTSB CHI03IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-131 · Chicago, ILThe maintenance facililty improperly assembled and installed the nose landing gear shock absorber assembly. Factors were the improper assembly which allowed the nose gear to turn 90 degrees to the direction of travel.Nov 21, 2002 · N804UA · Minor damageNTSB IAD03LA013Accident · No injuriesLimited investigationFinal reportBeech C35 · Reedville, VAThe pilot's selection of an unsuitable takeoff area, and his failure to maintain directional control.Nov 10, 2002 · N707D · Substantial damageNTSB FTW03LA038Accident · No injuriesLimited investigationFinal reportAgusta A109E · Fort Worth, TXThe pilot's attempted running takeoff with the power controls in the improper position.Nov 8, 2002 · N142CF · Substantial damageNTSB FTW03LA035Accident · Serious injuriesLimited investigationFinal reportBeech J35 · Newcastle, OKThe loss of engine power due to fuel starvation. Contributing factors were the pilot's improper positioning of the fuel selector and the lack of suitable terrain for landing.Nov 7, 2002 · N8355D · DestroyedNTSB LAX03LA023Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesquite, NVThe pilot's failure to maintain directional control during takeoff. A contributing factor was the ditch.Nov 5, 2002 · N13265 · Substantial damageNTSB LAX03LA020Accident · No injuriesLimited investigationFinal reportCessna T182T · Long Beach, CAThe student's failure to maintain directional control and the instructor's inadequate supervision of the flight by his delayed remedial action.Nov 2, 2002 · N184TA · Substantial damageNTSB LAX03LA019Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Pollock Pines, CAThe pilot's failure to maintain adequate obstruction clearance during initial climb, which resulted in a collision with vegetation.Nov 2, 2002 · N2616B · Substantial damageNTSB LAX03LA017Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Kaaawa, Oahu, HIDynamic rollover during an attempted takeoff, due to the combined effects of the soft sloping terrain and the pilot's failure to redistribute the passengers to a more favorable lateral CG condition.Oct 29, 2002 · N220AL · DestroyedNTSB CHI03LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Paul, MNThe student pilot failed to maintain directional control. A factor was the runway sign.Oct 29, 2002 · N848SP · Substantial damageNTSB ANC03CA008Accident · No injuriesData collectionFinal reportPiper PA-22 · Palmer, AKThe premature liftoff by the pilot during takeoff, which resulted in on ground encounter with terrain when the airplane settled onto rocks. A contributing factor in the accident was an unfavorable wind.Oct 29, 2002 · N878A · DestroyedNTSB MIA03LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Sebring, FLThe student pilot's premature rotation and failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall, an uncontrolled descent, and an impact with the ground.Oct 25, 2002 · N267EP · Substantial damageNTSB NYC03LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Morristown, NJThe student pilot's failure to maintain directional control during takeoff.Oct 24, 2002 · N4599D · Substantial damageNTSB FTW03LA023Accident · No injuriesLimited investigationFinal reportBeech A23 · Farmington, ARThe loss of engine power due to the failure of the mechanical fuel pump.Oct 22, 2002 · N1451L · Substantial damageNTSB DCA03IA005Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Baltimore, MDThe captain's improper procedures regarding stall avoidance and recovery. Contributing to the incident were the partial blockage of the pitot static system, and the flight crew's improper decisions regarding their use of inaccurate airspeed indications.…Oct 20, 2002 · TF-FII · No damageNTSB ATL03LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · Opa Locka, FLThe pilot' inadequate evaluation of weather information, and the selection of the wrong runway that resulted in an attempted takeoff with a tailwind and the subsequent loss of control during takeoff.Oct 17, 2002 · N903WA · Substantial damageNTSB SEA03LA006Accident · Serious injuriesLimited investigationFinal reportRutledge Kitfox · Condon, ORA loose clamp around the gascolator bowl. A related factor was the maintenance inspection not being performed.Oct 15, 2002 · N885CR · Substantial damageNTSB ATL03LA004Accident · No injuriesLimited investigationFinal reportCessna 170B · Watkinsville, GAThe pilot's inadvertent collision with an ant hill during takeoff that resulted in a ground loop and the subsequent collision collision with the ground. A factor was unsuitable terrain.Oct 13, 2002 · N170LB · Substantial damageNTSB FTW03LA017Accident · No injuriesLimited investigationFinal reportCessna 172L · San Antonio, TXThe pilot's inadequate compensation for wind resulting in a loss of directional control. A contributing factor was the prevailing crosswind.Oct 11, 2002 · N7616G · Substantial damageNTSB LAX03LA004Accident · No injuriesLimited investigationFinal reportRans S-12 XL · Los Banos, CAThe loss of engine power for undetermined reasons and his failure to maintain adequate airspeed resulting in a stall. A contributing factor was the pilot's decision to conduct a downwind takeoff.Oct 9, 2002 · UNREG · Substantial damageNTSB MIA03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Immokalee, FLA loss of engine power on takeoff for undetermined reasons.Oct 8, 2002 · N7014Y · Substantial damageNTSB LAX03LA002Accident · No injuriesLimited investigationFinal reportKline KSE5A · Sedona, AZthe pilot's failure to compensate for the wind conditions resulting in a loss of directional control during the takeoff roll. A contributing factor was the pilot's incorrect installation of the left wheel, which resulted in a locked left wheel when the brakes…Oct 7, 2002 · N589D · Substantial damageNTSB ATL03LA001Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Louisburg, NCThe pilot's improper use of flight controls (collective and cyclic) during an attempted takeoff to a hover, that resulted in an in-flight collision with terrain, and dynamic rollover.Oct 4, 2002 · N222MQ · Substantial damageNTSB LAX02FA300Accident · Serious injuriesField investigationFinal reportFairchild SA227-AC · Hawthorne, CAThe pilot-in-command's failure to maintain directional control during the rejected takeoff. The loss of directional control was caused by the crew's failure to follow prescribed pretakeoff and takeoff checklist procedures to ensure the both propellers were…Sep 29, 2002 · N343AE · Substantial damageNTSB CHI02LA281Accident · No injuriesLimited investigationFinal reportErcoupe 415-CD · Effingham, ILThe partial loss of engine power due to the seized exhaust valve. A factor was the soft field.Sep 15, 2002 · N3989H · Substantial damageNTSB ANC02LA128Accident · No injuriesLimited investigationFinal reportCessna 207 · Circle, AKThe pilot's inadequate wind evaluation during takeoff resulting in a downwind takeoff and subsequent overrun during an aborted takeoff. Factors in the accident were a tailwind and the pilot's failure to verify the selected flap setting.Sep 15, 2002 · N207DG · Substantial damageNTSB DEN02FA106Accident · 1 fatalField investigationFinal reportBeech B19 · Delta, COthe pilot's failure to properly plan and compensate for the high density altitude conditions, resulting in partial engine power during takeoff, his failure to abort the takeoff, and his failure to maintain aircraft control on initial climb. Contributing…Sep 14, 2002 · N5119R · DestroyedNTSB ANC02LA125Accident · No injuriesLimited investigationFinal reportCessna 180 · Tenakee Springs, AKThe pilot's selection of an unsuitable takeoff area, which resulted in a nose over on takeoff roll. A factor associated with the accident was soft terrain.Sep 11, 2002 · N180TM · Substantial damageNTSB CHI02LA276Accident · No injuriesLimited investigationFinal reportCessna T188C · Olivia, MNThe fouled spark plugs and the terrain condition encountered during the aborted takeoff.Sep 10, 2002 · N9432J · Substantial damageNTSB CHI02IA270Incident · No injuriesIncident investigationFinal reportFokker 100 · Minneapolis, MNThe improper installation of the #2 main landing gear wheel, including the axle nut not being properly torqued and safetied, which resulted in the wheel separation during takeoff.Sep 5, 2002 · N1473K · Minor damageNTSB ANC02LA126Accident · No injuriesLimited investigationFinal reportCessna 185 · Seward, AKA loss of directional control of the airplane due to the failure of the pilot to correct for torque/P Factor during the takeoff roll. A factor in the accident was a wet grass surface.Sep 3, 2002 · N9808X · Substantial damageNTSB LAX02LA271Accident · No injuriesLimited investigationFinal reportMooney M20 · Sierraville, CAthe pilot's decision to attempt takeoff in crosswind conditions that likely exceeded the capability of the airplane, and, his subsequent failure to maintain the airplane's proper alignment over the runway. Also causal was the pilot's premature liftoff and…Sep 2, 2002 · N881B · Substantial damageNTSB MIA02LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe student pilot's failure to maintain control of the airplane during the takeoff roll/run which resulted in the airplane departing the runway and into a ditch where it nosed over incurring substantial damage.Sep 1, 2002 · N68414 · Substantial damageNTSB SEA02LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Big Creek, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include high density altitude, variable winds, and a ditch near the point where the aircraft departed the side of the runway.Aug 28, 2002 · N5781F · Substantial damageNTSB ANC02LA105Accident · No injuriesLimited investigationFinal reportCessna 172H · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the runway and colliding with objects. Factors contributing to the accident were the rough and uneven runway, and the premature lift-off of the…Aug 27, 2002 · N3752F · Substantial damageNTSB SEA02LA165Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Melstone, MTThe pilot's improper decision to continue a takeoff once it had become apparent that it was questionable whether the aircraft would clear an obstacle at the departure end of the takeoff area. Factors include the pilot's failure to perform pre-takeoff…Aug 25, 2002 · N36596 · Substantial damageNTSB MIA02LA158Accident · No injuriesLimited investigationFinal reportCessna 172N · Tarboro, NCThe failure of the solo student to maintain directional control of the airplane during the takeoff roll/run which resulted in the airplane veering off the runway and impacting trees, incurring substantial damage.Aug 25, 2002 · N2291E · Substantial damageNTSB CHI02LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Warroad, MNThe loss of engine power due to the failure of the muffler baffles which blocked the exhaust system. A factor to the accident was the treeline.Aug 25, 2002 · N9274V · Substantial damageNTSB DEN02LA099Accident · No injuriesLimited investigationFinal reportHildebrandt Rutan/Defiant · Erie, COfailure of the normal braking system, resulting in the airplane departing the end of the runway. A contributing factor was the airplane's slow acceleration during the takeoff roll.Aug 20, 2002 · N219DF · Substantial damageNTSB CHI02LA255Accident · No injuriesLimited investigationFinal reportCessna 172P · Buffalo City, WIThe malfunction of the seat positioning system for undetermined reasons, which resulted in the loss of directional control. A factor to the accident was the descending embankment.Aug 19, 2002 · N381J · Substantial damageNTSB SEA02LA170Accident · No injuriesLimited investigationFinal reportHiperLight SNS-8 · Auburn, WAThe pilot's failure to maintain directional control during takeoff roll resulting in a ground loop. A contributing factor was crosswind conditions.Aug 17, 2002 · UNREG · Substantial damageNTSB ANC02LA101Accident · No injuriesLimited investigationFinal reportHelio H-295 · Igiugig, AKThe pilot's inadequate evaluation of the wind/weather conditions resulting in a collision with an embankment during the takeoff run. A factor contributing to the accident was a sudden wind shift to a tailwind.Aug 15, 2002 · N920AS · Substantial damageNTSB DEN02TA092Accident · Minor injuriesFinal reportAir Tractor AT-802A · Broomfield, COthe airplane's left main landing gear tire separated from its wheel during takeoff roll for an undetermined reason. Contributing factors were the pilot's inability to maintain aircraft control during takeoff roll and the subsequent impact with the Visual…Aug 14, 2002 · N91092 · Substantial damage