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 CHI92LA214Accident · No injuriesLimited investigationFinal reportCessna A185E · Cadillac, MIThe pilot's premature liftoff and subsequent stall mush.Jul 29, 1992 · N4573F · Substantial damageNTSB CHI92LA213Accident · No injuriesLimited investigationFinal reportBeech H35 · Baraboo, WIInadequate maintenance service and aircraft preflight by the pilot. A factor contributing to this accident was a partial failure of the brake system.Jul 28, 1992 · N7957D · Substantial damageNTSB SEA92LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Sisters, ORThe improper use of flight controls by the PIC during an aborted takeoff. Factors relating to the accident were the unfavorable wind (windshift) encountered during takeoff ground roll, the tailwind and high da weather conditions.Jul 27, 1992 · N5639W · Substantial damageNTSB BFO92LA114Accident · No injuriesLimited investigationFinal reportCessna A188B · Richmond, VAThe pilot's failure to maintain clearance during takeoff.Jul 27, 1992 · N731MR · Substantial damageNTSB BFO92LA113Accident · No injuriesLimited investigationFinal reportStinson JR.SR. · Hanson, MAThe pilot inadequate compensation for wind which resulted in the loss of directional control.Jul 26, 1992 · N13462 · Substantial damageNTSB ATL92LA145Accident · No injuriesLimited investigationFinal reportCessna 180B · Monroe, GAFailure of the pilot's seat assembly for an undetermined reason(s) which resulted in a loss of control during the takeoff roll.Jul 26, 1992 · N9581B · Substantial damageNTSB ANC92LA110Accident · No injuriesLimited investigationFinal reportCessna 172 · Twin Hills, AKThe pilot in command not following the procedures outlined in the pilot's operating handbook.Jul 23, 1992 · N5339H · Substantial damageNTSB BFO92LA108Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Marston Mills, MAThe pilot's inadequate preflight preparation. Contributing was the pilot's failure to use all available runway and overconfidence in his own abilities.Jul 20, 1992 · N8358P · Substantial damageNTSB FTW92LA182Accident · No injuriesLimited investigationFinal reportSchleicher KA6E · Haskell, OKThe pilot's failure to maintain directional control and the wing runners failure to keep the right wing up.Jul 18, 1992 · N1342 · Substantial damageNTSB SEA92LA155Accident · No injuriesLimited investigationFinal reportHelio H-295 · Laramie, WYThe pilot's failure to maintain runway alignment, and an inadvertent ground-loop. Factors include crosswinds.Jul 14, 1992 · N68857 · Substantial damageNTSB BFO92LA098Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Bally, PAThe pilot failed to maintain directional control during takeoff.Jul 12, 1992 · N57472 · DestroyedNTSB SEA92IA150Incident · No injuriesIncident investigationFinal reportBeech 1900C · Cheyenne, WYFailure of the fuel control unit on the left engine.Jul 11, 1992 · N109YV · No damageNTSB ANC92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kugururak River, AKThe failure to maintain directional control during takeoff. Factors include rough/uneven terrain.Jul 11, 1992 · N9961D · Substantial damageNTSB SEA92FA147Accident · 4 fatalField investigationFinal reportPiper PA-24-260 · Woods Cross, UTPilot factor in that he failed to attain and maintain sufficient flying speed. Factors to the accident were: cylinder over temperature, improper use of the mixture and procedures/directives were not followed.Jul 9, 1992 · N9323P · DestroyedNTSB BFO92LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Frederick, MDThe pilot's improper use of carburetor heat resulting in the formation of carburetor ice. Carburetor icing weather conditions was a factor.Jul 6, 1992 · N92668 · Substantial damageNTSB LAX92LA279Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Shelter Cove, CAThe pilot's inadequate preflight inspection of the aircraft and his failure to ensure that the control surface locks were removed prior to flight.Jul 5, 1992 · N929DB · DestroyedNTSB CHI92LA208Accident · No injuriesLimited investigationFinal reportSchweizer SGS2-33A · Kendallville, INImproper remedial action, the pilot's failure to maintain airspeed, and the failed tow rope.Jul 5, 1992 · N36133 · Substantial damageNTSB ANC92LA102Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's failure to maintain directional control. Factors include gusty crosswind conditions.Jul 5, 1992 · N2824A · Substantial damageNTSB LAX92LA275Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Olancha, CA1) The tow pilot's intentional premature release of the glider, which had become airborne, when the tow plane failed to achieve sufficient airspeed during its takeoff ground roll, and, 2) the glider having insufficient altitude at the time of release to…Jul 3, 1992 · N173SS · Substantial damageNTSB FTW92LA176Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Marietta, OKEngine power loss for undetermined reasons.Jul 3, 1992 · N4957P · Substantial damageNTSB NYC92LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-60-602P · Lancaster, PAThe failure of the left engine turbochargers bearings, which resulted in a loss of power and subsequent degradation of climb performance.Jun 25, 1992 · N700MM · DestroyedNTSB LAX92LA256Accident · No injuriesLimited investigationFinal reportLake 200 · Clearlake, CAThe pilot's inadequate weather evaluation of the wind on the Lake and his delay in lift-off. Contributing to the accident was the rough water that existed on the unsheltered section of the Lake.Jun 22, 1992 · N67C · Substantial damageNTSB LAX92LA262Accident · Serious injuriesLimited investigationFinal reportBell 47-G5A · Pago Pago (Pacific Ocean)The pilot's inadequate preflight inspection in failing to ensure that all skid tiedowns were removed prior to the attempted takeoff.Jun 21, 1992 · N211CB · Substantial damageNTSB CHI92LA187Accident · No injuriesLimited investigationFinal reportBeech M35 · Dekalb, ILThe pilot's failure to use proper nose wheel steering which resulted in a loss of directional control.Jun 21, 1992 · N9873R · Substantial damageNTSB FTW92DRA03Accident · No injuriesFinal reportSchweizer G-164B · Bay City, TXThe pilot's inability to initiate a climb due to exceeding the takeoff capability of the airplane. A factor was the high grass on the airstrip.Jun 20, 1992 · N8157K · Substantial damageNTSB DEN92LA063Accident · No injuriesLimited investigationFinal reportFairchild 24W-46 · Brighton, COThe pilot's inadequate visual lookout.Jun 20, 1992 · N81229 · 2 aircraft · Substantial damageNTSB DEN92FA060Accident · 1 fatalField investigationFinal reportBeech V35B · Tulsa, OKAircraft climb performance exceeded. Factors were: aircraft gross weight exceeded, grass runway selected, takeoff flaps not used, and premature rotation.Jun 17, 1992 · N4567S · DestroyedNTSB CHI92LA182Accident · No injuriesLimited investigationFinal reportCessna 150M · Wichita, KSA loss of directional control and remedial action not performed by the pilot. Factors related to this accident were a swerve encountered by the pilot and the pilot's lack of overall experience.Jun 17, 1992 · N7867U · Substantial damageNTSB CHI92DCA02Accident · No injuriesFinal reportCessna 188B · Risco, MOThe pilot in commands failure to maintain directional control of the airplane during the aborted takeoff. The pilot's inadequate evaluation of the wind was a factor.Jun 16, 1992 · N731GX · Substantial damageNTSB FTW92DRD03Accident · No injuriesFinal reportAir Tractor AT-502 · Kaplan, LAThe pilot's failure to lower flaps to the takeoff position.Jun 15, 1992 · N45383 · Substantial damageNTSB FTW92DPG02Accident · Minor injuriesFinal reportGrumman G-164-B · Mcdougal, ARThe pilots failure to properly plan his take off. A factor was his lack of familiarity with the chemical dispensing equipment.Jun 15, 1992 · N8285K · DestroyedNTSB CHI92LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rockford, ILThe flight instructor's premature liftoff. Related factors are the instructor's lack of total experience in the accident make and model airplane, and the unsuitable terrain encountered during the roll-out.Jun 14, 1992 · N56311 · Substantial damageNTSB ATL92LA124Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ft. Gaines, GAThe pilot's inadequate preflight planning/preparation.Jun 14, 1992 · N7357 · Substantial damageNTSB NYC92LA111Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Lewisburg, WVThe failure of the instructor pilot to take proper remedial action during a takeoff resulting in a loss of airplane control and subsequent inadvertant stall. Factors related to the accident were the instructor's lack of total, recent and instructional flight…Jun 13, 1992 · N5506K · Substantial damageNTSB CHI92FA170Accident · 2 fatalField investigationFinal reportGates Learjet 25B · Sheboygan Falls, WIThe copilot's premature liftoff and the captain's inadequate remedial action resulting in loss of aircraft control at low altitude.Jun 12, 1992 · N38DJ · DestroyedNTSB NYC92LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Woodbine, MDThe student pilot's failure to maintain directional control of the glider during takeoff, which resulted in a ground loop. Factors related to the accident were the student's lack of total flight experience, the instructor's lack of flight experience in this…Jun 10, 1992 · N693RF · Substantial damageNTSB DEN92LA056Accident · No injuriesLimited investigationFinal reportNorth American Harvard MK-II · Watkins, COThe pilot inadvertently stalling the airplane. Factors included: the pilot's failure to maintain directional control on takeoff, and inadequate airspeed.Jun 8, 1992 · N90541 · DestroyedNTSB SEA92LA119Accident · No injuriesLimited investigationFinal reportMooney M20K · Stanley, IDThe failure of the pilot to maintain runway alignment and his loss of directional control during takeoff ground roll, resulting in a swerve off the 150 ft wide runway and impact with a fence. Factors relating to the accident were the lack of runway lights,…Jun 6, 1992 · N5772C · Substantial damageNTSB FTW92LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Truth Or Cons, NMThe pilot's inability to stop due to worn brakes and low brake fluid.Jun 5, 1992 · N4547A · Substantial damageNTSB FTW92LA148Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Oil Trough, ARThe pilot's selection of unsuitable terrain for takeoff.Jun 5, 1992 · N8732H · DestroyedNTSB ATL92LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bainbridge, GAThe pilot's misjudged distance of runway remaining, resulting in a delayed decision to abort the takeoff, and subsequent collision with trees. Factors were the high obstructions (trees) at the departure end of the runway.Jun 5, 1992 · N83453 · Substantial damageNTSB NYC92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-32 · New Milford, CTInadequate visual lookout by the pilot which resulted in the glider striking a vehicle parked next to the runway.Jun 3, 1992 · N2724H · Substantial damageNTSB LAX92LA233Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Fallbrook, CAThe loss of engine power due to a disconnection of the turbocharger inlet duct.Jun 3, 1992 · N29169 · Substantial damageNTSB ATL92LA122Accident · No injuriesLimited investigationFinal reportAirship Industries Airship 600 · Weeksville, NCThe improper installation of the elevator control cables by repair facility maintenance personnel, the inspector's inadequate inspection of the maintenance accomplished, and his failure to follow delineated procedures. An additional cause was the inadequate…Jun 1, 1992 · N600LP · Substantial damageNTSB LAX92LA248Accident · No injuriesLimited investigationFinal reportCessna 172L · Safford, AZThe airplane colliding with animals which ran on to the runway during the pilot's takeoff roll. A factor in this accident was the pilot not being able to take remedial action and avoid the animals.May 31, 1992 · N4163L · Substantial damageNTSB LAX92LA240Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Lone Pine, CAThe pilot did not abort the takeoff in time to avoid the on ground collision with the fence and creek bank.May 30, 1992 · N3349L · Substantial damageNTSB CHI92DCG02Accident · No injuriesFinal reportA. H. Gettings Glassair SH2 · Marshall, MOThe pilot's inadequate pre-takeoff flight control check.May 30, 1992 · N18KG · DestroyedNTSB BFO92LA079Accident · Minor injuriesLimited investigationFinal reportRichard N. Burns KR-2 · Middletown, DEThe pilot's lack of familiarity with the aircraft and his inadequate handling of the aircraft.May 27, 1992 · N183RB · DestroyedNTSB ANC92LA078Accident · No injuriesLimited investigationFinal reportCessna 185 · Kahiltna Glacie, AKThe fracture of the landing gear wheel ski pivot shaft due to improper manufacture.May 24, 1992 · N124KT · Substantial damageNTSB CHI92LA158Accident · No injuriesLimited investigationFinal reportAeronca O-58B · Oshkosh, WIThe inadequate inspection by other maintenance personnel, and an inadequate preflight inspection by the pilot in command. A factor contributing to the accident was the reversal of the aileron cables.May 23, 1992 · N47373 · Substantial damage