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 MIA93LA169Accident · No injuriesLimited investigationFinal reportAyres S2R-T15 · Louise, MSThe pilot in commands decision to takeoff from a road with a left quartering tailwind which resulted in his loosing directional control and the aircraft colliding with a utility pole.Aug 4, 1993 · N1950J · Substantial damageNTSB FTW93LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Harrison, ARAn inadvertent groundloop by the pilot.Jul 30, 1993 · N2464P · Substantial damageNTSB BFO93LA142Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Matawan, NJThe water collection in the ignition harness which rendered the lower cylinder spark plugs inoperative resulting in partial power loss.Jul 30, 1993 · N6617X · Substantial damageNTSB SEA93LA163Accident · No injuriesLimited investigationFinal reportCessna 195 · Pray, MTThe PIC failed to maintain directional control. A factor relating to the accident was the tailwind weather condition.Jul 27, 1993 · N9836A · Substantial damageNTSB CHI93LA277Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIThe pilot's inadequate preflight planning for determining the proper takeoff profile. A factor in the accident was the high density altitude.Jul 23, 1993 · N9307N · Substantial damageNTSB MIA93LA161Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Vero Beach, FLImproper planning/decision by the pilot, and his delay in aborting the takeoff. Factors related to the accident were: the tailwind, wet runway, and soft terrain beyond the end of the runway.Jul 22, 1993 · N888CD · Substantial damageNTSB CHI93LA271Accident · No injuriesLimited investigationFinal reportBeech A36 · Fowlerville, MIThe pilot-in-command's (CFI) delay in aborting the takeoff.Jul 22, 1993 · N211BB · Substantial damageNTSB CHI93LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe student pilot's failure to maintain directional control during the takeoff portion of a touch and go landing.Jul 22, 1993 · N64988 · Substantial damageNTSB BFO93LA127Accident · No injuriesLimited investigationFinal reportCessna 172P · Edgartown, MAThe pilot failed to maintain directional control during takeoff. Other related factors were: the tailwind, and the gross weight of the airplane being exceeded.Jul 18, 1993 · N52858 · Substantial damageNTSB MIA93FA156Accident · 1 fatalField investigationFinal reportMooney M20-J · Jackson, MSA power loss for undetermined reasons during takeoff, the failure of the pilot-in-command to abort the takeoff, and his improper decision to turn back to the airport when there was suitable terrain ahead for the forced landing.Jul 15, 1993 · N57287 · Substantial damageNTSB FTW93LA215Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to cylinder failure. A factor was the lack of suitable terrain for the forced landing.Jul 13, 1993 · N9780 · Substantial damageNTSB CHI93LA254Accident · No injuriesLimited investigationFinal reportGrumman G164B · Eldred, MNthe pilot's failure to maintain directional control during the takeoff roll.Jul 13, 1993 · N48518 · Substantial damageNTSB CHI93LA255Accident · No injuriesLimited investigationFinal reportCessna 182 · Prairie City, IAthe pilot's premature liftoff. Factors in the accident are the soft and wet sod runway.Jul 11, 1993 · N91162 · Substantial damageNTSB CHI93LA257Accident · No injuriesLimited investigationFinal reportCessna T188C · Wheaton, MNThe pilot's failure to maintain alignment during takeoff roll.Jul 10, 1993 · N3591J · Substantial damageNTSB LAX93LA284Accident · No injuriesLimited investigationFinal reportCessna 172N · Alturus, CAThe pilot's delay in aborting the takeoff. The pilot's premature rotation and his failure to follow the procedures in the airplane flight manual regarding use of the mixture control, the high density altitude condition and the pilot's lack of total flight…Jul 9, 1993 · N75901 · Substantial damageNTSB ANC93LA110Accident · No injuriesLimited investigationFinal reportCessna 180J · Delta Junction, AKThe pilot in command's delay in aborting the takeoff. The trees were a factor in the accident.Jul 3, 1993 · N74CG · Substantial damageNTSB SEA93LA146Accident · 1 fatalLimited investigationFinal reportDoellefeld RV6A · Independence, ORAn in flight loss of contol for unknown reasons.Jul 2, 1993 · N6LG · DestroyedNTSB NYC93LA131Accident · Minor injuriesLimited investigationFinal reportPiper PA-32 · Spencer, MAThe pilot's inadequate preflight planning for the high density altitude departure and the delay in aborting the takeoff roll, with insufficient runway remaining, resulting in a collision with treesJun 28, 1993 · N3490W · Substantial damageNTSB CHI93LA233Accident · Minor injuriesLimited investigationFinal reportBeech E35 · Virgil, ILThe pilot's failure to abort takeoff.Jun 25, 1993 · N314R · Substantial damageNTSB CHI93LA228Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Brownsburg, INfailure to replace a dirty air filter.Jun 25, 1993 · N89133 · Substantial damageNTSB LAX93LA265Accident · No injuriesLimited investigationFinal reportCulver LCA · San Luis Obispo, CAThe pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the pilot's lack of recent flight experience in tail wheel aircraft.Jun 21, 1993 · N29396 · Substantial damageNTSB MIA93LA144Accident · Minor injuriesLimited investigationFinal reportBell 47G · Panama City, FLImproper planning/decision by the pilot-in-command and his failure to maintain rotor RPM, which resulted in failure of the helicopter to attain effective translational lift. Factors related to the accident were: the fence & terrain conditions.Jun 19, 1993 · N3628G · Substantial damageNTSB FTW93LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hondo, TXThe pilot's improper evaluation of the weather which led to the downwind takeoff. Factors were the windshift and the tailwind.Jun 19, 1993 · N6695W · Substantial damageNTSB LAX93LA257Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Oakdale, CAthe failure of the flying pilot to maintain directional control of the aircraft during the takeoff ground roll. A factor in the accident was the flying pilot's lack of recent total flight time and recent experience in conventional landing gear equipped…Jun 14, 1993 · N9618D · Substantial damageNTSB CHI93LA211Accident · No injuriesLimited investigationFinal reportMonnett Sonerai IIL · De Kalb, ILThe pilot in command's inability to maintain directional control due to inadequate compensation for wind conditions.Jun 6, 1993 · N247RJ · Substantial damageNTSB ATL93LA099Accident · No injuriesLimited investigationFinal reportRockwell 114 · Woodstock, GAThe pilot's inadequate preflight planning which resulted in his failure to abort the takeoff when sufficient runway was available.Jun 1, 1993 · N116RC · Substantial damageNTSB LAX93LA233Accident · No injuriesLimited investigationFinal reportCessna 180 · Davenport, CAThe pilot's failure to maintain directional control to avoid the high vegetation. Factors relating to this accident were the failure of the pilot to obtain the climb airspeed and the inadvertent stall/mush.May 31, 1993 · N2790X · Substantial damageNTSB ANC93LA079Accident · No injuriesLimited investigationFinal reportCessna A185F · Kahiltna Glacie, AKThe pilot-in-command not maintaining directional control. A factor is the rough condition of the glacier airstrip.May 31, 1993 · N333DG · Substantial damageNTSB ATL93LA101Accident · No injuriesLimited investigationFinal reportCessna 150H · Lafayette, ALThe pilot's failure to maintain adequate clearance from the mile marker sign during the takeoff roll. A factor was the sign adjacent to the highwayMay 29, 1993 · N6924S · Substantial damageNTSB LAX93LA226Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Madera, CAThe pilot's failure to maintain directional control. A factor related to this accident was the left quartering tailwind.May 26, 1993 · N48632 · DestroyedNTSB ANC93LA068Accident · No injuriesLimited investigationFinal reportCessna 402B · Kivalina, AKThe pilot's failure to check the condition of the runway before takeoff. The soft runway condition was a factor in the accident.May 25, 1993 · N401NA · Substantial damageNTSB FTW93LA164Accident · No injuriesLimited investigationFinal reportPiper PA-25-151 · Calera, OKAircraft performance exceeded and takeoff not aborted. Factors were the soft wet turf runwayMay 24, 1993 · N6129Z · Substantial damageNTSB ANC93LA086Accident · No injuriesLimited investigationFinal reportCessna 185 · Barrow, AKThe fatigue fracture of the main landing gear spring.May 23, 1993 · N75LE · Substantial damageNTSB FTW93LA162Accident · No injuriesLimited investigationFinal reportCessna A185F · Timbalier Isle, LAPilot's inadequate preflight planning and preparation in the selection of his takeoff route. A factor was the sand barMay 22, 1993 · N3588 · Substantial damageNTSB MIA93LA122Accident · No injuriesLimited investigationFinal reportRockwell 112TC · Destin, FLThe pilot-in-command's failure to abort the takeoff roll, resulting in an on-ground loss of control, and on-ground collision with terrain. Contributing to the accident was the failure of the nose wheel steering cable.May 18, 1993 · N4579W · Substantial damageNTSB CHI93LA174Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Springport, MIA partial loss of engine power for undetermined reasons.May 16, 1993 · N35HM · Substantial damageNTSB FTW93LA152Accident · No injuriesLimited investigationFinal reportElliott B-80 · Amarillo, TXThe pilot's failure to compensate for wind conditions. Factors were the loss of engine power and the tailwindMay 12, 1993 · N42845 · DestroyedNTSB CHI93LA157Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT301A · Solomon, KSThe pilot's selection of unsuitable terrain on which to takeoff and his delay in aborting the takeoff.May 12, 1993 · N3162A · Substantial damageNTSB MIA93LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Ochopee, FLThe pilot's poor judgement in attempting the takeoff from the parking ramp when a 12,000-FT runway was available.May 11, 1993 · N9985V · Substantial damageNTSB ANC93LA059Accident · No injuriesLimited investigationFinal reportCessna 172 · Kasigluk, AKThe pilot's poor judgement in attempting a takeoff from a narrow, wet, soft gravel runway with a crosswind. The runway conditions and the crosswind were factors in the accident.May 1, 1993 · N6332D · Substantial damageNTSB FTW93LA145Accident · No injuriesLimited investigationFinal reportCessna 310H · Brookshire, TXThe pilot's failure to attain proper runway alignment. Factors were the dark night and weather conditions.Apr 30, 1993 · N48AA · Substantial damageNTSB FTW93LA144Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Anahuac, TXUndetermined.Apr 30, 1993 · N7485 · Substantial damageNTSB CHI93LA155Accident · No injuriesLimited investigationFinal reportMaule M5 · Green Bay, WIThe pilot's failure to maintain control of the airplane.Apr 30, 1993 · N5644D · Substantial damageNTSB NYC93LA096Accident · No injuriesLimited investigationFinal reportAir & Space 18-A · Paducah, KYThe inadequate supervision by the flight instructor resulting in a loss of directional control while conducting a simulated emergency, and the subsequent collision with the terrain during a roll over.Apr 27, 1993 · N6126S · Substantial damageNTSB ATL93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Lafayette, GAThe failure of the pilot to maintain control of the aircraft.Apr 22, 1993 · N5334F · Substantial damageNTSB CHI93LA144Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Mineral Point, WIThe pilot in command's failure to maintain directional control of the aircraft.Apr 21, 1993 · N2352R · Substantial damageNTSB LAX93FA177Accident · Serious injuriesField investigationFinal reportBritish Aerospace BA 3101 · Merced, CAThe first officer's failure to maintain an adequate rate of climb after a single-engine loss of power was simulated, and the company check pilot's inadequate supervision and failure to note the descent. Darkness was a related factor.Apr 20, 1993 · N131CA · DestroyedNTSB NYC93LA084Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Buchanan, VAThe pilot's improper planning/decision, inadequate crew coordination, and failure to maintain directional control. The unfavorable wind and proximity of obstructions were related factors.Apr 17, 1993 · N33929 · Substantial damageNTSB CHI93LA141Accident · No injuriesLimited investigationFinal reportBeech V-35B · Bennington, KSThe pilot-in-command's failure to maintain directional control of the aircraft.Apr 17, 1993 · N38076 · Substantial damageNTSB ATL93LA081Accident · No injuriesLimited investigationFinal reportCessna 421B · Fort Payne, ALThe pilot's failure to compensate for winds during the initial takeoff that resulted in the airplane colliding with the runway, exceeding the design limits of the aircraft and upon landing at the destination airport, the collapse of the main landing gear.Apr 15, 1993 · N14A · Substantial damage