NTSB investigations, AL

149 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.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    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 ATL94LA112Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Summerdale, ALThe pilot's failure to maintain airspeed during takeoff.Jun 2, 1994 · N53819 · Substantial damageNTSB ATL94LA070Accident · No injuriesLimited investigationFinal reportMooney M20J · Muscle Shoals, ALWas the loose throttle cable, and the pilot's failure to abort the takeoff when the engine did not produce full power. A factor was the inadequate maintenance inspection of the engine.Mar 25, 1994 · N4780H · Substantial damageNTSB ATL94LA019Accident · Serious injuriesLimited investigationFinal reportBell-Carson 47G-SUPER C-4 · Eufaula, ALThe pilot's failure to maintain aircraft control. A factor was the pilot's limited helicopter flight experience.Nov 16, 1993 · N614X · Substantial damageNTSB ATL94LA009Accident · No injuriesLimited investigationFinal reportBell 47G2 · Billingsley, ALThe pilot's improper vertical liftoff which resulted in dynamic roll-over and the main rotor's impact with the ground.Oct 25, 1993 · N866Z · 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 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 damageNTSB ATL93LA048Accident · No injuriesLimited investigationFinal reportCessna 120 · Bessemer, ALThe failure of the pilot to maintain directional control during take off.Jan 1, 1993 · N4292N · Substantial damageNTSB ATL93LA042Accident · No injuriesLimited investigationFinal reportPitts S2B · Tuscaloosa, ALThe failure of the pilot to maintain directional control of the aircraft, during the take off roll. A factor was the wind gust.Dec 26, 1992 · N92AP · Substantial damageNTSB ATL93LA023Accident · 1 fatalLimited investigationFinal reportBede BD-5B · Guntersville, ALThe pilot's inadvertent stall of the airplane, during the base to final turn, at too low an altitude to effect recovery. Factors were the improper lift off, which resulted in the airplane re contacting the runway after lift off, and served to distract the…Nov 8, 1992 · N84EJ · DestroyedNTSB MIA92LA159Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Toney, ALThe left main landing gear attachment bolt failed for undetermined reasons resulting in the collapse of both main landing gear during the take off roll.Aug 4, 1992 · N5272 · Substantial damageNTSB ATL92LA059Accident · No injuriesLimited investigationFinal reportCessna 310R · Tuscaloosa, ALThe instructor's inadequate supervision and the student pilot's failure to follow instructions.Mar 11, 1992 · N87355 · Substantial damageNTSB ATL92LA006Accident · No injuriesLimited investigationFinal reportGrumman G164 · Bay Minette, ALThe rough/uneven runway condition caused by the sink hole.Oct 14, 1991 · N590Y · Substantial damageNTSB ATL91LA174Accident · No injuriesLimited investigationFinal reportCessna 150J · Wilsonville, ALThe pilot's inadequate preflight planning, and his improper use of flaps during the takeoff roll. Factors in the accident were: the high density altitude, the rising runway conditions, and the departure end obstructions at the airstrip.Sep 14, 1991 · N6866G · Substantial damageNTSB ATL91LA100Accident · No injuriesLimited investigationFinal reportCessna 177B · Huntsville, ALThe pilot's failure to remove the control lock prior to attempting flight and his failure to follow the 'before takeoff' checklist. A factor in the accident was the pilot's diverted attention.May 27, 1991 · N19823 · Substantial damageNTSB ATL90LA184Accident · No injuriesLimited investigationFinal reportCessna 152 · Dothan, ALThe student pilot's selection of the wrong runway and the subsequent loss of directional control during takeoff. The pilot's improper usage of flight controls, presence of crosswind conditions, and his overall lack of experience were factors in the accident.Sep 30, 1990 · N49553 · Substantial damageNTSB ATL88DKG16Accident · No injuriesFinal reportCessna 188 · Hazel Green, ALThe plt rprtd he had flown off the strip all day & the temp had risen to 101 deg. As he was on his last takeoff, he realized the chemical load was too great for the conditions. He said he dumped part of the load, but the acft settled back to the ground.…Aug 13, 1988 · N42404 · Substantial damageNTSB ATL88DKG04Accident · Serious injuriesFinal reportWeber Evans VF-1 · Fort Payne, ALFeb 26, 1988 · N18JW · Substantial damageNTSB ATL87LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gulf Shores, ALThe plt aborted the takeoff about half way down the 3600 ft rwy after observing that the airspeed indicator was inop. Before he could stop the acft, it ran off the end of the rwy & went into a ditch. An exam by an A&P mechanic revealed that the pitot head was…Jul 8, 1987 · N8389Y · Substantial damageNTSB ATL86IA167Incident · No injuriesIncident investigationFinal reportBeech H35 · Birmingham, ALDuring takeoff ground run the aircraft would not develop full power according to the pilot. The pilot elected to abort the takeoff and during the aborted takeoff the aircraft ran off the end of the runway.Jun 11, 1986 · N7989D · Minor damageNTSB ATL86LA019Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Sylacauga, ALDuring takeoff ground run the plt lost directional control of the acft which ran off the side of the rwy and into a grove of trees. The plt stated that the right eng lost pwr, however, the eng was test run after the accident and no discrepancies were noted.Nov 6, 1985 · N601PC · Substantial damageNTSB ATL86LA005Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Chapman, ALDuring an attempted takeoff from a field adjacent to a grove of trees the aircraft was unable to climb over the trees and crashed into them. The engine was test run and although it ran rough during initial start up it later operated normally and the reason…Oct 10, 1985 · N7451F · DestroyedNTSB ATL85FA169Accident · No injuriesField investigationFinal reportLuscombe 8-A · Columbiana, ALThe airstrip is used primarily as a gliderport and at the time of the accident, traffic was being controlled by a person on the ground using handsignals. N28428 proceeded on to the rwy to takeoff as the ultralight was on final apch. Both plts observed the…May 18, 1985 · N28428 · 2 aircraft · Substantial damageNTSB ATL85LKG02Accident · No injuriesFinal reportCessna 172N · Tuscaloosa, ALThe acft veered to the left during the takeoff ground run. The acft departed the rwy into a soft, plowed field where it momentarily nosed down before coming to rest on the main landing gear.Dec 23, 1984 · N1947F · Substantial damageNTSB ATL84LA020Accident · No injuriesLimited investigationFinal reportCessna 172 · Cullman, ALThe student plt was on his 1st solo flt. During a touch-and-go pattern, he started to takeoff, after landing, with the elevator trim in a nearly full nose-up position. He stated that after he added power to takeoff, he had to hold the nose down by applying…Oct 15, 1983 · N5082G · Substantial damageNTSB ATL83LA370Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Berry, ALThe acft dragged a wing during takeoff and collapsed the right main gear in the process. After liftoff the plt said the left wing dipped and contacted soybeans at the end of the rwy. He said he overcontrolled and rolled the right wing into the beans. He…Sep 14, 1983 · N48475 · Substantial damageNTSB ATL83LA343Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 600-A · Florala, ALThe pilot stated that during takeoff roll he experienced a power surge but the engine did not quit. He aborted the takeoff by reducing power on both engines and applying brakes. This resulted in the aircraft swerving off the right side of the runway, rolling…Aug 29, 1983 · N139TS · DestroyedNTSB ATL83LA276Accident · No injuriesLimited investigationFinal reportPiper L-21B · Vernon, ALThe acft departed the rwy & nosed over inverted during an unauthorized flight. After the accident the non-certificated plt told the owner that he had flown the acft several times based on the permission of a friend who was authorized to fly the acft.Jul 4, 1983 · N8056W · Substantial damageNTSB ATL83LA101Accident · No injuriesLimited investigationFinal reportBeech H18 · Talladega, ALThe plt stated that shortly after full power application & prior to tailwheel lift-off, the 'right wing raised aprx 3 to 4 ft into the air.' The acft then began drifting left. During ensuing maneuvers, the plt alternately advanced & retarded the throttle as…Feb 11, 1983 · N1461G · Substantial damageNTSB ATL83FA008Accident · No injuriesField investigationFinal reportCessna 177RG · Montgomery, ALAfter advancing the throttle about 1/2 of its travel to commence the takeoff roll, the plt heard a loud explosion & felt a violent shaking of the acft. The eng quit & the acft swerved to the right side of the rwy. Post crash examinationrevealed that one…Oct 9, 1982 · N45696 · Substantial damageNTSB ATL82IA281Incident · No injuriesIncident investigationFinal reportPiper PA-34-22OT · Montgomery, ALThe pilot stated that a normal runup was completed before takeoff. During the takeoff roll, the aircraft accele- rated through 75 knots when a loud bang was heard from the left side. The takeoff was aborted and a rollout accomplished. Examination of the left…Sep 15, 1982 · N220HB · Minor damageNTSB ATL82DA216Accident · Minor injuriesFinal reportCessna 150G · Huntsville, ALThe pilot landed long and fast and pushed the flap lever to an up position for takeoff. The flap lever is spring loaded to the neutral position. When the flaps did not come up the pilot pushed the switch again and the flaps started up. As the runway end was…Jul 27, 1982 · N3124J · Substantial damageNTSB ATL82FA011Accident · No injuriesClosedBeech 58 · Selma, ALOct 27, 1981 · N755CF · Substantial damageNTSB ATL81FKJ35Accident · No injuriesClosedBellanca 14-19 · Weaver, ALSep 12, 1981 · N36KC · Substantial damageNTSB ATL81DKJ22Accident · No injuriesClosedHiller Acft UH-12E · Centreville, ALJul 10, 1981 · N702WA · DestroyedNTSB ATL81FA067Accident · No injuriesClosedAdams A50S · Montevallo, ALApr 18, 1981 · N1062X · Substantial damageNTSB ATL81DKJ13Accident · No injuriesClosedPiper PA-38 · Bessemer, ALMar 6, 1981 · N2534C · Substantial damageNTSB MIA79DKJ51Accident · No injuriesClosedAeronca 7AC · Pell City, ALJul 4, 1979 · N85663 · Substantial damageNTSB MIA79DKJ16Accident · Minor injuriesClosedCessna 172 · Huntsville, ALDec 21, 1978 · N7215Q · Substantial damageNTSB MIA79DKJ04Accident · No injuriesClosedPiper PA-38T · Birmingham, ALOct 15, 1978 · N2414E · Substantial damageNTSB MIA78DKJ50Accident · Minor injuriesClosedCessna 172 · Huntsville, ALJun 12, 1978 · N6136E · Substantial damageNTSB MIA78FKJ40Accident · No injuriesClosedCessna 172 · Chipley, ALMay 27, 1978 · N8374U · Substantial damageNTSB MIA78DKJ35Accident · No injuriesClosedPiper PA-22 · Lacey Springs, ALApr 16, 1978 · N3553P · Substantial damageNTSB MIA78FKJI4Accident · No injuriesClosedCessna 421C · Bay Minette, ALDec 16, 1977 · N8305G · Substantial damageNTSB MIA78DKJ07Accident · No injuriesClosedCessna 182 · Wetumpka, ALNov 15, 1977 · N1264S · Substantial damageNTSB MIA78FKJ81Accident · No injuriesClosedCessna 172 · Grove Hill, ALSep 3, 1977 · N64260 · Minor damageNTSB MIA77DKJ78Accident · No injuriesClosedAero Comdr A9 · Berry, ALAug 21, 1977 · N7291V · Substantial damageNTSB MIA77DKJ77Accident · No injuriesClosedHughes 269A · Clanton, ALAug 21, 1977 · N8877F · Substantial damageNTSB MIA77DKJ57Accident · No injuriesClosedPiper PA18 · Alabaster, ALJul 9, 1977 · N221T · Substantial damageNTSB MIA77DKJ51Accident · No injuriesClosedCessna 150H · Birmingham, ALJun 25, 1977 · N6470S · Substantial damageNTSB MIA77FKJ21Accident · 1 fatalClosedBellanca 8KCAB · Headland, ALMar 15, 1977 · N57479 · Destroyed