OpenAirDocs.org

NTSB investigations, 2003

162 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\") = 2003
    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 LAX04CA082Accident · No injuriesData collectionFinal reportCessna 172N · Angels Camp, CAthe CFI's inadequate compensation for a crosswind condition, which resulted in the loss of directional control. The crosswind and wind gusts were factors.Dec 29, 2003 · N461BD · Substantial damageNTSB NYC04LA050Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's inadequate pre-flight inspection, which resulted in a decrease in airplane performance due to ice, and a subsequent hard landing.Dec 20, 2003 · N9469B · Substantial damageNTSB FTW04LA051Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Harrison, ARThe collapsing of the right main landing gear during the landing roll out as a result of impacting an animal on the runway during takeoff.Dec 20, 2003 · N69RS · Substantial damageNTSB NYC04IA054Incident · No injuriesIncident investigationFinal reportCanadair CL-600 · Teterboro, NJThe captain's inadequate preflight planning, which resulted in an overrun during an aborted takeoff.Dec 16, 2003 · N95EB · Minor damageNTSB FTW04LA041Accident · Serious injuriesLimited investigationFinal reportBull SE5-A · Rio Hondo, TXThe pilot's failure to maintain control of the tailwheel equipped airplane during takeoff. Contributing factors were the pilot's selection of the wrong runway for takeoff and the prevailing tailwind.Dec 13, 2003 · N42LB · DestroyedNTSB FTW04CA030Accident · Minor injuriesData collectionFinal reportBell 206L1 · Paris, ARThe pilot's failure to remove the main rotor tiedown prior to engine startup. Contributing factors were the pressure induced by conditions/events, improper preflight of the aircraft, and dark night conditions,Nov 29, 2003 · N103AE · Substantial damageNTSB CHI04LA037Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCBC · Menominee, MIThe Phillips screwdriver impacting the left tire on takeoff roll, and the deflated tire which did not allow directional control to be maintained during the subsequent landing.Nov 26, 2003 · N297JB · Substantial damageNTSB NYC04LA040Accident · No injuriesLimited investigationFinal reportBeech H-18 · Westminster, MDThe pilot's failure to maintain control of the airplane after a failure of one propeller system. Factors in the accident were the failure to perform maintenance inspection and the failure of a bolt in the left propeller blade system.Nov 23, 2003 · N22XL · Substantial damageNTSB LAX04LA049Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZthe flight instructor's inadequate supervision of the flight and delayed remedial action, which resulted in a loss of directional control. The reason for the partial power loss in the left engine was not determined.Nov 20, 2003 · N971PA · Substantial damageNTSB FTW04IA023Incident · No injuriesIncident investigationFinal reportBell 407 · Eugene Is. 27The loss of engine power due to the failure of the 3rd stage turbine wheel and subsequent catastrophic failure of the turbine assembly.Nov 16, 2003 · N405PH · Minor damageNTSB LAX04LA050Accident · No injuriesLimited investigationFinal reportBoeing 747-422 · San Francisco, CAa tail strike due to a combination of the wind shifting from a headwind to a tailwind during rotation, and the pilot's control inputs for the crosswind condition.Nov 14, 2003 · N178UA · Substantial damageNTSB FTW04LA020Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Mineral Wells, TXthe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Nov 12, 2003 · N95604 · Substantial damageNTSB SEA04LA015Accident · No injuriesLimited investigationFinal reportSchmitt Exec 162F · Prosser, WAThe student pilot's abrupt application of excessive collective and the flight instructor's inadequate supervision of the student. Contributing factors were the ditch and low rotor RPM.Nov 6, 2003 · N6463S · Substantial damageNTSB CHI04LA024Accident · No injuriesLimited investigationFinal reportCessna 172S · Lakota, NDThe student pilot not maintaining directional control during takeoff roll on a solo instructional flight. The factor to the accident was the wind gusts.Nov 2, 2003 · N730SP · Substantial damageNTSB ATL04IA028Incident · No injuriesIncident investigationFinal reportPiper PA-32RT-300T · Fayetteville, NCFlight control elevator attachment turnbuckle corrosion and fracture resulting in the loss of aircraft control in flight.Oct 25, 2003 · N39541 · Minor damageNTSB SEA04LA014Accident · Serious injuriesLimited investigationFinal reportTracy Kolb Mark III · Prineville, ORThe pilot in command's failure to maintain aircraft control during an aborted takeoff. Factors include the pilot's lack of experience in this type of aircraft (pusher).Oct 19, 2003 · NONE · Substantial damageNTSB MIA04CA005Accident · Minor injuriesData collectionFinal reportCessna 172N · Everglades City, FLThe pilot's improper preflight planning/preparation which resulted in the airplane's gust lock being left installed, which resulted in the airplane not being able lift off during the takeoff roll, and damage to the airplane when it overran the runway and…Oct 19, 2003 · N933JH · Substantial damageNTSB NYC04IA010Incident · No injuriesIncident investigationFinal reportBeech 1900D · Albany, NYThe maintenance technician's improper maintenance performed on the airplane, and his failure to perform a functional check, which resulted in a restricted movement of the elevator trim wheel. Factors were the captain's inadequate preflight inspection, and…Oct 16, 2003 · N850CA · No damageNTSB CHI04LA012Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Columbus, NEThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during an aborted takeoff. Factors associated with the accident were the crosswind condition, the delayed aborted takeoff, and the…Oct 15, 2003 · N5204F · Substantial damageNTSB CHI04LA010Accident · No injuriesLimited investigationFinal reportWright Redux Association 1903 Wright Flyer · Bolingbrook, ILThe inadequate planning/decision by the pilot to begin a flight in gusting wind conditions, the pilot's lack of experience in the airplane, and the stall encountered by the pilot during takeoff. The wind gusts were a contributing factor.Oct 14, 2003 · N203WF · Substantial damageNTSB NYC04LA008Accident · Minor injuriesLimited investigationFinal reportSibila VP 1 · Cincinnati, OHThe pilot's delayed decision to abort the takeoff, which resulted in a collision with trees.Oct 13, 2003 · N4087F · Substantial damageNTSB MIA04CA002Accident · No injuriesData collectionFinal reportPiper PA-24-260B · Archer, FLThe pilot's failure to maintain directional control during the takeoff roll/run, which resulted in the airplane veering off the centerline of the runway and impacting an object, incurring damage.Oct 12, 2003 · N9291P · Substantial damageNTSB DEN04IA012Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COthe manufacturer's improper installation of the inboard slat drive mechanism's lower left hand anti-torque strut, which resulted in the axial migration of the rod-end bearing, the binding of the anti-torque strut, and the subsequent activation of the slat…Oct 12, 2003 · N375FE · Minor damageNTSB LAX04LA009Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Murrieta, CAThe pilot's inadequate evaluation of the weather which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Fog and rising terrain were contributing factors.Oct 11, 2003 · N1918B · Substantial damageNTSB LAX04CA010Accident · No injuriesData collectionFinal reportAvions Max Holste MH 1521 Broussard · El Cajon, CAthe pilot's premature liftoff and his failure to attain an adequate takeoff airspeed, which resulted in a stall. The pilot's failure to correctly set the pitch trim before takeoff was a factor.Oct 11, 2003 · N239HL · Substantial damageNTSB ATL04LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 -C65 · Jackson, TNThe pilot's improper us of flight controls during an attempted takeoff, which resulted in an collision with the specially equipped automobile.Oct 4, 2003 · N38272 · Substantial damageNTSB FTW03CA233Accident · Minor injuriesData collectionFinal reportHughes 269C · Gail, TXThe loss of control for undetermined reasons.Sep 28, 2003 · N9620F · Substantial damageNTSB ATL03LA150Accident · Minor injuriesLimited investigationFinal reportSherman Holie Freebird · Newnan, GAThe failure of the aileron control rod, and subsequent loss of control in-flight.Sep 27, 2003 · UNREG · Substantial damageNTSB CHI03FA320Accident · 1 fatalField investigationFinal reportCessna 152 · Three Oaks, MIThe pilot not maintaining adequate airspeed resulting in a stall during takeoff. Contributing factors were the buzzing flight and trees.Sep 25, 2003 · N25787 · DestroyedNTSB CHI03LA325Accident · No injuriesLimited investigationFinal reportBrice Lancair Legacy · Kimberling City, MOThe pilot's delayed aborted takeoff. Contributing to the accident was the pilot's inadequate preflight planning/preparation in his failure to remove the pitot cover.Sep 19, 2003 · N27RM · Substantial damageNTSB MIA03LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLFailure of one blade in the engine compressor turbine disk due to fatigue which was caused by loss of gap between the blade platforms as a result of corrosion due to a foreign element (phosphate). This resulted in loss of engine power during takeoff and…Sep 18, 2003 · N1528T · DestroyedNTSB ANC03LA122Accident · No injuriesLimited investigationFinal reportCessna 180 · Cape Yakataga, AKThe pilot's selection of unsuitable terrain for departure, which resulted in a collision with a log during the takeoff roll. Factors contribuiting to the accident were the presence of hidden obstructions, and sunglare.Sep 18, 2003 · N2162Z · Substantial damageNTSB LAX03CA296Accident · No injuriesData collectionFinal reportCessna 182K · Young, AZthe collision with a bull during takeoff.Sep 17, 2003 · N2646R · Substantial damageNTSB NYC03LA200Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Ashland, VAThe pilot's decision to perform an aborted takeoff after he perceived a power loss. A factor was the unsuitable terrain the airplane encountered after it overran the end of the runway.Sep 15, 2003 · N32DQ · Substantial damageNTSB ANC03LA115Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot's failure to maintain control of the airplane during the takeoff run, which resulted in the airplane nosing over in the water. Factors contributing to the accident were wind gusts, and the pilot's inadequate evaluation of the wind conditions.Sep 15, 2003 · N3795Z · Substantial damageNTSB ANC03LA121Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an overrun and nose over during an aborted takeoff. Factors contributing to the accident were soft, sandy terrain, and a tailwind.Sep 14, 2003 · N9907V · Substantial damageNTSB CHI03LA310Accident · No injuriesLimited investigationFinal reportCessna 182D · Rushville, INThe pilot failed to maintain control of the airplane during the initial takeoff climb which resulted in an inadvertent stall.Sep 12, 2003 · N8702X · Substantial damageNTSB CHI03LA311Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Cash, ARThe delayed aborted takeoff by the pilot. The ditch was a factor to the accident.Sep 9, 2003 · N3299X · Substantial damageNTSB NYC03CA193Accident · No injuriesData collectionFinal reportCessna 150M · Jetersville, VAThe pilot's delayed decision to abort the takeoff, which resulted in an overrun. A factor was the dew on the grass.Sep 7, 2003 · N63600 · Substantial damageNTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.Sep 6, 2003 · N7632G · DestroyedNTSB CHI03LA318Accident · Minor injuriesLimited investigationFinal reportDixon Glasair II · Columbia, ILThe pilot's failure to maintain directional control during an aborted takeoff. Contributing factors were the open cabin door, the grass runway and the soft terrain adjacent to the runway.Sep 6, 2003 · N817CD · Substantial damageNTSB ANC03LA120Accident · No injuriesLimited investigationFinal reportCessna 150 · Tanana, AKThe pilot's failure to abort the takeoff after encountering muddy terrain during the takeoff roll, which resulted in a runway overrun and collision with trees. A factor in the accident was the muddy runway.Sep 6, 2003 · N6767F · Substantial damageNTSB FTW03FA211Accident · Minor injuriesField investigationFinal reportAgusta A109E · Dallas, TXThe reported loss of engine power for undetermined reasons. A contributing factor was the failure to maintain clearance with the safety fence during the aborted takeoff, which resulted in a dynamic rollover of the helicopter.Sep 4, 2003 · N143CF · Substantial damageNTSB NYC03CA188Accident · No injuriesData collectionFinal reportLancair IVP · Manassas, VAThe pilot's failure to follow the published takeoff procedures for the make and model airplane and his failure to maintain directional control during takeoff.Sep 2, 2003 · N789HS · Substantial damageNTSB ATL03CA135Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNAn on-ground collision with an animal (deer) during an attempted takeoff. .Sep 1, 2003 · N3542K · Substantial damageNTSB MIA03CA174Accident · No injuriesData collectionFinal reportCessna 152 · Ocala, FLthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with a ditch.Aug 30, 2003 · N93193 · Substantial damageNTSB LAX03CA269Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Joshua Tree, CAthe student pilot failed to maintain directional control of the airplane during the takeoff roll.Aug 30, 2003 · N2318L · Substantial damageNTSB SEA03CA178Accident · No injuriesData collectionFinal reportBeech C24R · Bend, ORThe first pilot's premature liftoff and his failure to abort the takeoff. Factors include a fence and a ditch bank located upwind of the runway.Aug 26, 2003 · N6536C · Substantial damageNTSB FTW03LA235Accident · No injuriesLimited investigationFinal reportVelocity RG · Skiatook, OKThe pilot's delay in aborting the takeoff. A contributing factor was the high density altitude.Aug 23, 2003 · N113JG · Substantial damageNTSB CHI03LA265Accident · No injuriesLimited investigationFinal reportCessna 188B · Monette, ARFailure of the right brake and the pilot's inability to maintain directional control. A factor associated with the accident was the ditch.Aug 23, 2003 · N5647G · Substantial damage