OpenAirDocs.org

NTSB investigations

14,038 cases where the phase of flight was Takeoff.

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 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 LAX03FA135Accident · 3 fatalField investigationFinal reportBeech A36 · Sedona, AZa partial loss of engine power due to the certified flight instructor's failure to comply with the pilot operating handbook requirements for the mixture setting during takeoff. Also causal was the instructor's inadequate supervision of the flight, failure to…Apr 13, 2003 · N323D · DestroyedNTSB MIA03LA088Accident · 1 fatalLimited investigationFinal reportAir Tractor 502B · Belle Glade, FLThe failure of both pilots to use on-board communication radios to advise takeoff and landing intentions, the reduction of visibility of the pilot-in-command of N6037H due to sun glare during takeoff, and the poor in-flight planning by the pilot-in-command of…Apr 8, 2003 · N6037H · 2 aircraft · DestroyedNTSB MIA03LA085Accident · Minor injuriesLimited investigationFinal reportGhiles Philippe/American Ga MCR-01 VLA · Lakeland, FLThe failure of the pilot-in-command to abort the takeoff after recognizing that the airplane did not become airborne at the calculated point down the runway. A contributing factor in the accident was the windshift during the takeoff roll resulting in a…Apr 7, 2003 · N6370X · Substantial damageNTSB MIA03LA082Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tavernier, FLThe control interference by the pilot-rated passenger in an attempt to avoid an obstacle, which resulted in a loss of control.Mar 30, 2003 · N4315S · DestroyedNTSB CHI03LA093Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Sturtevant, WIThe student pilot's abrupt liftoff resulting in his failure to maintain adequate airspeed followed by a stall. Also causal was the instructor's inadequate supervision.Mar 30, 2003 · N45799 · Substantial damageNTSB DEN03LA060Accident · No injuriesLimited investigationFinal reportCessna 170A · Hobbs, NMthe pilot's failure to maintain aircraft directional control during takeoff roll. A factor was the runway light's cement foundation.Mar 29, 2003 · N5577C · Substantial damageNTSB MIA03LA081Accident · No injuriesLimited investigationFinal reportBeech A36 · Naples, FLThe pilot's improper preflight planning and delay in aborting the takeoff which resulted in the airplane overrunning the runway and incurring damage.Mar 25, 2003 · N364JK · Substantial damageNTSB NYC03LA071Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Columbus, OHThe pilot under instruction's failure to maintain directional control, and the flight instructor's delayed remedial action.Mar 23, 2003 · N2968Z · Substantial damageNTSB NYC03LA069Accident · Minor injuriesLimited investigationFinal reportBell 47D · Princetown, NYThe student's failure to maintain control while executing a takeoff to a hover, and the flight instructor's delayed remedial action. A factor in the accident was the muddy ground.Mar 23, 2003 · N74120 · Substantial damageNTSB LAX03FA116Accident · 1 fatalField investigationFinal reportCessna 182G · Santa Maria, CAthe pilot's failure to maintain proper runway alignment during the takeoff ground roll, which resulted in the left wing contacting the brush lining the runway edge. The combined effects of the brush and tree contact retarded the airplanes acceleration and…Mar 22, 2003 · N3236S · DestroyedNTSB DEN03IA054Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Cedar City, UTthe captain's failure to maintain directional control during takeoff. Factors contributing to the accident were the crew's diverted attention, the snow and slush-covered runway, the fog, and the runway marker.Mar 17, 2003 · N214SW · Minor damageNTSB LAX03LA114Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · San Diego, CAthe pilot's use of an inadequate climb attitude during takeoff resulting in the proper climb rate not being established.Mar 16, 2003 · N31AP · Substantial damageNTSB ANC03LA031Accident · No injuriesLimited investigationFinal reportCessna 185 · Galena, AKThe failure of the airplane to climb after takeoff which resulted in an in-flight collision with terrain during an aborted landing attempt.Mar 9, 2003 · N1613M · Substantial damageNTSB FTW03LA105Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA341G · Alpine, TXThe pilot's failure to maintain translational lift, which resulted in an uncontrolled descent of the helicopter during takeoff. A contributing factor was the gusty tailwind condition.Mar 6, 2003 · N16KH · Substantial damageNTSB LAX03LA105Accident · Serious injuriesLimited investigationFinal reportAero Commander 690A · Tracy, CAthe failure of the pilot to maintain directional control during the departure roll on a narrow runway. A factor in the accident was the pilot's limited experience in the airplane.Mar 3, 2003 · N132JH · Substantial damageNTSB LAX03LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZthe CFI's inadequate supervision and delayed decision to abort the takeoff resulted in the runway overrun.Mar 1, 2003 · N62712 · Substantial damageNTSB NYC03LA062Accident · No injuriesLimited investigationFinal reportCessna 172N · Cincinnati, OHThe student pilot's failure to maintain directional control.Feb 26, 2003 · N733XP · Substantial damageNTSB NYC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Blue Bell, PAThe pilot's failure to maintain directional control after a loss of engine power for undetermined reasons.Feb 26, 2003 · N711AV · Substantial damageNTSB LAX03LA097Accident · 1 fatalLimited investigationFinal reportFirefly 11B · Yountville, CAA bystander was impaired by drugs and did not follow the pilot's directive to release the balloon as it began its ascent.Feb 25, 2003 · N1501H · No damageNTSB IAD03LA034Accident · No injuriesLimited investigationFinal reportCessna 150J · Williamson, NYThe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor was the snow-covered runway.Feb 25, 2003 · N51126 · Substantial damageNTSB LAX03LA091Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Scottsdale, AZthe student pilot's inadequate compensation for the existing crosswind conditions and failure to maintain directional control during the touch-and-go takeoff. A factor was his improper use of (failure to reduce) the throttle and normal brakes during the…Feb 21, 2003 · N3550X · Substantial damageNTSB NYC03LA053Accident · No injuriesLimited investigationFinal reportCessna 180 · East Windsor, CTThe pilot's failure to maintain directional control. A related factor was the snow-covered runway conditions.Feb 20, 2003 · N1752C · Substantial damageNTSB FTW03LA098Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Holly Grove, ARThe pilot's failure to abort the takeoff.Feb 18, 2003 · N61802 · Substantial damageNTSB MIA03IA062Incident · No injuriesIncident investigationFinal reportCessna 500 · Fort Lauderdale, FLInadequate quality control following overhaul of the high-pressure compressor (HPC) impeller by other maintenance personnel that resulted in a machining groove on the aft face of the HPC impeller being undetected, which resulted in a fatigue fracture and an…Feb 14, 2003 · N891CA · Minor damageNTSB CHI03LA073Accident · No injuriesLimited investigationFinal reportCessna 172 · Clare, MIThe student pilot failed to maintain directional control of the airplane during takeoff roll. A factor was the snow bank.Feb 14, 2003 · N693SA · Substantial damageNTSB SEA03LA039Accident · No injuriesLimited investigationFinal reportKesterson Nieuport 11 · Independence, ORAircraft control not maintained during takeoff. Factors include soft/muddy terrain.Feb 13, 2003 · N110DK · Substantial damageNTSB ANC03LA027Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Soldotna, AKThe pilot's selection of unsuitable terrain for takeoff, and his failure to maintain aircraft control which resulted in a nose over. A factor contributing to the accident was standing puddles of water on the frozen lake.Feb 11, 2003 · N4492A · Substantial damageNTSB IAD03LA031Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Russellville, KYThe total loss of engine power due to carburetor ice.Feb 6, 2003 · N7184M · Substantial damageNTSB CHI03LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Waskish, MNThe inadequate preflight planning/preparation by the pilot. Contributing factors were the snow covered takeoff area and the tailwind.Feb 3, 2003 · N8112U · Substantial damageNTSB ATL03LA040Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Titusville, FLThe loss of engine power for undetermined reasons. The pilot's failure to attain full power for takeoff in accordance with the operation handbook was a factor.Feb 2, 2003 · N9769L · Substantial damageNTSB LAX03LA081Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Long Beach, CAThe pilot's excessive pull up, which resulted in a failure to obtain/maintain flying speed and a subsequent stall/mush.Feb 1, 2003 · N300PS · Substantial damageNTSB CHI03LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeville, MNThe pilot's inadequate removal of ice and snow during the airplane preflight, and the subsequent loss of control due to the airplane being covered with ice.Jan 31, 2003 · N670CS · Substantial damageNTSB NYC03LA038Accident · No injuriesLimited investigationFinal reportCessna 150F · Crestline, OHThe pilot's improper decision to takeoff from unsuitable terrain. A factor related to the accident was the plowed, snow covered field.Jan 19, 2003 · N8555G · Substantial damageNTSB LAX03LA083Accident · No injuriesLimited investigationFinal reportBeech 76 · Truckee, CAfailure of the CFI to ensure that the pilot under instruction adequately understood the engine out procedure during the preflight planning phase of the flight; failure of the pilot under instruction to obtain/maintain directional control; and the inadequate…Jan 17, 2003 · N5400M · Substantial damageNTSB ATL03LA034Accident · No injuriesLimited investigationFinal reportCessna 172S · Mt. Pleasant, SCThe student pilot's failure to maintain directional control during the takeoff roll, which resulted in a loss of control and collision with terrain.Jan 11, 2003 · N5199H · Substantial damageNTSB ATL03LA033Accident · Minor injuriesLimited investigationFinal reportShaw Atlantica 235FG · Melbourne, FLThe pilot's inadvertent liftoff and his failure to maintain airspeed which resulted in a stall.Jan 10, 2003 · N235BW · Substantial damageNTSB DCA03MA022Accident · 21 fatalClass 1 · MajorFinal reportBeech 1900D · Charlotte, NCthe airplane's loss of pitch control during take-off. The loss of pitch control resulted from the incorrect rigging of the elevator system compounded by the airplane's aft center of gravity, which was substaintially aft of the certified aft limit.…Jan 8, 2003 · N233YV · DestroyedNTSB ATL03LA032Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Geneva, ALThe pilot's failure to achieve takeoff due to a mistrimmed elevator, and his failure to maintain directional control.Jan 8, 2003 · N3628X · Substantial damageNTSB CHI03LA045Accident · No injuriesLimited investigationFinal reportCessna 182S · Alton, ILFailure of the pilot-in-command to maintain directional control during the takeoff roll. Contributing factors were the wet, icy runway conditions and the presence of the snowbank.Jan 3, 2003 · N2724R · Substantial damageNTSB FTW03LA069Accident · Serious injuriesLimited investigationFinal reportWood Thorp T-18 · Stephenville, TXThe pilot's loss of directional control as result of his failure to compensate for the prevailing wind conditions. A contributing factor was the gusty crosswinds.Jan 1, 2003 · N335BW · Substantial damageNTSB 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 damage