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 FTW83LA255Accident · No injuriesLimited investigationFinal reportGlasflugel H-301 · Los Lunas, NMThe glider ground looped off the rwy after the wingtip contacted tall grass. The acft had gone to the right early in thetow but the plt thought the tow would straighten him out even after the wing dropped to the ground. When the right wing contacted tall…May 28, 1983 · N1017 · Substantial damageNTSB DEN83LA128Accident · No injuriesLimited investigationFinal reportCessna 180B · Decker, MTThe tailwheel acft groundlooped on takeoff as the tail came up and the acft swerved sharply to the left. During the turn at about 40 mph the acft nosed over. The pilot noticed a pulling to the left as the takeoff roll commenced but thought he could contain it…May 28, 1983 · N5259E · Substantial damageNTSB LAX83LA252Accident · No injuriesLimited investigationFinal reportCessna 170B · Yreka, CAThe plt landed at the montague arpt for fuel, but fuel was not available, so he proceeded to rohrer field where 18 gal was onloaded. During takeoff with a density alt of aprx 4200 ft, he lifted off after using aprx 2/3 of the 3360 ft rwy. He reported that at…May 27, 1983 · N8018A · Substantial damageNTSB FTW83LA282Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Mount Ida, ARDuring the takeoff portion of a touch and go lndg the plt applied pwr and the acft drifted off the left side of the 50 ft wide rwy onto soft terrain. The nose gear collapsed and the propeller and leading edge of the rt wingtip were damaged.May 27, 1983 · N56255 · Substantial damageNTSB CHI83LA229Accident · No injuriesLimited investigationFinal reportCessna 152 · Holland, MIWhile the student plt was taking off with a left crosswind, he reportedly became distracted when he became aware that he was applying incorrect aileron deflection for wind correction. He stated that he corrected the ailerons, but in the meantime, the acft…May 27, 1983 · N4805B · Substantial damageNTSB ATL83IA201Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Charlotte, NCThe #3 eng sustained an uncontained failure of the #4 1/2 bearing of the turbine section, due to fatigue cracking of the roller bearing cage.May 27, 1983 · N856N · Minor damageNTSB LAX83LA235Accident · No injuriesLimited investigationFinal reportPiper PA 28-236 · Emigrant Gap, CAThe acft collided with trees during takeoff. The CFI and student had made a landing on a rwy that was 2/3 covered with snow. They thought they could make a short field landing and a short field running takeoff. They nosed down in the snow during the attempted…May 18, 1983 · N2960X · Substantial damageNTSB FTW83LA240Accident · No injuriesLimited investigationFinal reportCessna 152 · Woodward, OKAs the a/s increased drng tkof roll the acft started to skid to the rt. The student plt stated that with full l aileron and no rt rudder the acft continued to skid to the rt. He then atmptd to apply l rudder and abort the tkof by reducing pwr. The acft veered…May 16, 1983 · N65412 · Substantial damageNTSB ANC83LA081Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Twin Hills, AKThe acft nosed over during takeoff when the landing gear dug into the soft sand. The weather was VMC but the wind was gusting up to 40 mph. The pilot did not claim any problems with the wind or the acft but he did have a strong crosswind. The accident site…May 16, 1983 · N5042Q · Substantial damageNTSB FTW83LA231Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wheeler, TXThe plt stated that before reaching rotation speed, with about 250 ft of rwy remaining, the left main landing gear dropped off into a chug hole in the rwy. The acft became prematurely airborne, heading off the rwy to the left. It came down in rough terrain…May 15, 1983 · N5525E · Substantial damageNTSB DEN83LA113Accident · No injuriesLimited investigationFinal reportCessna 182Q · Townsend, MTThe acft nosed over in a plowed field off the end of the rwy during an attempted aborted takeoff. The acft had departed one arpt and landed again at a private strip to onload a passenger clothes bag. The landing was uphill into the wind. There was no windsock…May 15, 1983 · N759LW · Substantial damageNTSB DEN83LA112Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Buffalo, WYThe plt reported that he attempted to takeoff on rwy 30 with a left x-wind from 210 deg at 25, gusting 30 KTS. At aprx 45 mph, after he had raised the tail of the acft into the takeoff attitude, a gust of wind was encountered & the acft weathervaned to the…May 15, 1983 · N585C · Substantial damageNTSB LAX83FU003Accident · 1 fatalFinal reportHomebuilt None · Tracy, CAThe plt had built the ultralight vehicle at home by using the plans of a weedhopper. Reportedly, he had used materials that would have been similar to or stronger than those that would have been supplied by a weedhopper kit. A friend, who had flown the…May 14, 1983 · UNREG · DestroyedNTSB CHI83LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Mora, MNThe acft ran off the departure end of the rwy into a cornfield during an aborted takeoff. The pilot stated that after liftoff the stall warning came on and the acft would not accelerate or climb. He pulled the power off and aborted the takeoff. The acft…May 11, 1983 · N36804 · Substantial damageNTSB CHI83LA207Accident · No injuriesLimited investigationFinal reportCessna 152 · Smithfield, OHThe plt had been practicing touch-and-go landings. On about the 6th or 7th touch-and-go, he applied power to takeoff when a group of deer crossed the rwy. He steered to the left to avoid the animals, went off the rwy, hit a large mound of dirt, then the acft…May 10, 1983 · N69057 · Substantial damageNTSB CHI83FA205Accident · Serious injuriesField investigationFinal reportBeech A36 · Minonk, ILThe plt reported that during takeoff from a private farm strip, he had only 70 KTS as he apchd the end of the rwy. By then, there was not enough room to abort & he believed the acft had insufficient airspeed to clear wires along a roadway about 330 ft from…May 9, 1983 · N6039Z · Substantial damageNTSB ANC83LA078Accident · No injuriesLimited investigationFinal reportCessna U206 · Twin Hills, AKThe plt was dispatched to a beach area to pick up passengers. After landing, the passengers & baggage were loaded & the plt attempted to takeoff. The top & bottom of the beach area had some humps of gravel that blended into the beach sand. During the takeoff…May 8, 1983 · N49HH · Substantial damageNTSB LAX83LA222Accident · No injuriesLimited investigationFinal reportGrumman 164B · Lodi, CAThe aircraft was rolling for takeoff at dawn when it collided with another crop duster taxiing in the opposite directionthe aircraft taking off had rolled about 100 feet when the pilot saw a red light on the runway and aborted the takeoff and attempted to…May 7, 1983 · N6530K · DestroyedNTSB ATL83FA178Accident · 1 fatalField investigationFinal reportCessna 150 · Kennesaw, GAThe acft crashed in a wooded area after a touch and go landing. The wing flaps lever had been placed to the up position but the flaps did not retract. When the CFI finally noticed that the flaps were not up he took over at about 200 ft AGL and started a…May 7, 1983 · N5835G · Substantial damageNTSB LAX83LA215Accident · No injuriesLimited investigationFinal reportNorth American Rockwell S2R800 · Fallon, NVThe acft overran the departure end of the rwy during takeoff. The acft had a full load of fuel and about 250 lbs. Of insecticide. The acft had attained a speed of 65 mph as the end of the rwy was approached. The pilot stated that he thought he could make the…May 4, 1983 · N4985X · DestroyedNTSB CHI83LA204Accident · No injuriesLimited investigationFinal reportCessna 180J · Ely, MNThe plt was practicing water takeoffs & landings. He stated that during takeoff a gust of wind caught the acft lifting the right wing. The left wing struck the water & the acft flipped inverted.May 3, 1983 · N9906N · Substantial damageNTSB ATL83FA175Accident · Minor injuriesField investigationFinal reportCessna 182A · Monticello, GAThe acft was damaged in a forced landing off arpt after a power loss at 500-600 AGL during climb. The engine would not restart. Post accident examination showed 3.5 ounces of water in the carburetor bowl with 1 ounce of fuel. The fuel tankcaps had good seals…May 3, 1983 · N3721D · Substantial damageNTSB MIA83LA134Accident · No injuriesLimited investigationFinal reportGulfstream American AA1B · Moore Haven, FLAccording to the plt he collided with a large ant hill during the takeoff roll, lost directional control, & veered off the rwy into trees.May 1, 1983 · N6286L · Substantial damageNTSB ANC83FAG08Accident · No injuriesFinal reportCessna 180 · Kenai, AKThe acft nosed over during takeoff roll. The pilot of the tailwheel acft pushed the yoke foward during the roll and thenreleased the pressure he said the tail of the acft came up too high and the pilot said he ould not overcome this action with back pressure…May 1, 1983 · N2661Y · Substantial damageNTSB FTW83LA216Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Roswell, NMThe CFI stated, the acft was lined up on the center line at the end of runway 17. The student pilot applied power and the acft veered to the left, he over-corrected to the right. He further stated, 'I reduced the power to idle as the right landing gear…Apr 30, 1983 · N82946 · Substantial damageNTSB FTW83LA210Accident · No injuriesLimited investigationFinal reportCessna A188B · Winsboro, LAAprx 600 feet of the 2300 foot strip is concrete and the remainder is turf. According to the pilot, he raised the tail prior to running off the concrete. As the takeoff roll continued onto the turf, the acft veered sharply to the right. Full left rudder,…Apr 28, 1983 · N70203 · Substantial damageNTSB SEA83LA090Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Malad City, IDDuring an interview, the plt reported that he had removed ice from the acft & attempted to depart from a snow covered alfalfa field, aprx 1000 ft long. The acft did not become airborne & the plt elected to abort the takeoff. During the abort, the acft…Apr 26, 1983 · N40314 · Substantial damageNTSB NYC83LA101Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Millbrook, NYThe pilot was using runway 17 for takeoff when he lost directional control. The acft went off the left side of the runway and over an embankment.Apr 23, 1983 · N719 · DestroyedNTSB CHI83LA176Accident · No injuriesLimited investigationFinal reportCessna 182 · Madison, WIThe aircraft groundlooped and rolled inverted during the takeoff roll. The student pilot stated that during the takeoff roll the sun broke through the clouds and blinded him. He reported, that this condition plus the crosswind interferred with his ability to…Apr 23, 1983 · N1683M · Substantial damageNTSB MIA83LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Zellwood, FLThe acft ran off the departure end of the runway and collided with a ditch during an aborted takeoff following a touch- and-go landing. The instructor stated that the student made the landing and prepared the acft for takeoff. Power was applied and at 45 KTS…Apr 21, 1983 · N6333M · Substantial damageNTSB SEA83LA082Accident · No injuriesLimited investigationFinal reportStinson L-5 · Haines, ORThe aircraft collided with a fence during a takeoff and nosed over. The runway was an alfalfa field approximately 1000 feet in length with high growth. The density altitude was 4000 feet. The aircraft did become airborne but settled back to the field, and…Apr 18, 1983 · N6430C · Substantial damageNTSB MKC83LA091Accident · No injuriesLimited investigationFinal reportCessna 150M · Axtell, NEThe plt reported that he began taking off on a 1310 ft rwy that was dry but spongy. The elevation was reported as 2210 ft, the wind was calm, and the temperature was 55 deg. The flaps were set at 10 deg. Reportedly, the acft lifted off, but settled back to…Apr 18, 1983 · N714BP · Substantial damageNTSB FTW83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Breaux Bridge, LAAccording to the pilot he was attempting to takeoff at night from an unlit turf strip. Just before the attempted takeoff, two sets of vehicle headlights were directed down both sides of the rnwy to help the pilot in the takeoff. On both sides of the rnwy,…Apr 17, 1983 · N3572Z · Substantial damageNTSB LAX83FUJ13Accident · Serious injuriesFinal reportPiper PA-28R-180 · Flagstaff, AZThe plt reported he had a problem with the spark plugs loading up before he departed sacramento, CA on a x-country & ther magneto (mag) had been overhauled before he departed. He stated the eng ran well 'except for brief plug load (one cyl)cleared by leaning…Apr 16, 1983 · N4579J · Substantial damageNTSB ANC83IA069Incident · No injuriesIncident investigationFinal reportCessna U-206 · Old Harbor, AKThe acft rt wing rose during the water takeoff & the left wing struck the water. After impact the aircraft sank. The pilot did not receive a weather briefing & a sigment for lowlevel turbulence was in effect.Apr 11, 1983 · N732FN · Minor damageNTSB ATL83FU002Accident · 1 fatalFinal reportWizard J3 · Dovesville, SCReportedly, the owner/plt had purchased the ultralight acft on 4/21/83. His instructor stated that he (the plt) had received aprx 1 1/2 hrs of supervised taxi time, but had not flown the vehicle prior to the accident flt. On the day of the accident, the plt…Apr 7, 1983 · UNREG · DestroyedNTSB MIA83LA112Accident · No injuriesLimited investigationFinal reportCessna 150 · Vero Beach, FLThe student pilot stated that during the takeoff portion of a touch and go landing power was applied, the acft went out of control and ran off the left side of the runway striking trees.Apr 6, 1983 · N61113 · Substantial damageNTSB ATL83LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Williamsburg, VAThe aircraft ran off the runway after an aborted takeoff. The pilot stated that he elected to abort the takeoff about half way down the runway after failing to obtain an airspeed indication sufficient for takeoff. After cutting the power and lowering the nose…Apr 4, 1983 · N98362 · Substantial damageNTSB LAX83LA172Accident · Minor injuriesLimited investigationFinal reportGrumman American G164-B · Near Madera, CAThe acft hit a chuck hole in high grass during takeoff roll from a field for an aerial application mission. The left landing gear separated from the acft. The weather was VMC and no flight plan was filed. The pilot sustained minor injuries. The flight was…Apr 1, 1983 · N31184 · Substantial damageNTSB ATL83LA149Accident · No injuriesLimited investigationFinal reportCessna 172N · Jekyll Island, GAThe instructor, a canadian CFI, reported that the canadian student was operating the rudder peddles while he, the CFI, was handling the remaining acft controls. A second student plt was also on board, observing from a rear seat. After traveling aprx 800 ft on…Apr 1, 1983 · CGYCY · Substantial damageNTSB MIA83LA107Accident · No injuriesLimited investigationFinal reportStinson 10A · Miami, FLThe owner of the acft said that the plt was negotiating to buy the acft but conducted this flt without proper authority in the acft that was not airworthy. The plt had landed the acft earlier in an emergency situation declaring a loss of oil pressure and RPM.…Mar 30, 1983 · N39431 · DestroyedNTSB CHI83LA155Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, OHThe aircraft swerved off the runway during takeoff and nosed down in the dried grass. The student pilot was taking off on the return leg of a cross-country when he lost directional control at a speed of about 40 KTS. The wind was 90 degrees at 9 KTS. The acft…Mar 30, 1983 · N5545L · Substantial damageNTSB ATL83LA147Accident · No injuriesLimited investigationFinal reportGrumman G164 A · New Church, VAThe acft swerved from a soft spot on the runway and left the runway. When the acft went into a plowed field the landing gear mired and the acft nosed over. The pilot could not see over the nose of the tailwheel acft to detect the soft spot in the runway. The…Mar 30, 1983 · N8719H · Substantial damageNTSB LAX83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Glendale, AZThe pilot reported performing a normal preflight and run-up. No water was observed in the fuel during preflight. Full power was applied and the acft accelerated to 55 KTS. As the acft rotated and climb attitude established the engine sputtered. The pilot…Mar 29, 1983 · N81191 · Substantial damageNTSB SEA83LA066Accident · No injuriesLimited investigationFinal reportCessna 172N · Telma, WAThe aircraft collided with deep unplowed snow on the runway during takeoff and nosed over. The pilot stated that he had landed on frozen snow but when he returned to takeoff the snow was soft. He had a 1200 ft long portion of the runway cleared but it was…Mar 20, 1983 · N738QA · Substantial damageNTSB ATL83LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Stone Mountain, GAThe aircraft overran the departure end of the runway and collided with an embankment during an aborted takeoff. The student pilot did not file a flight plan or check the weather for this flight. The weather was VMC but the pilot startedthe takeoff down wind.…Mar 19, 1983 · N8593N · DestroyedNTSB ANC83IA058Incident · No injuriesIncident investigationFinal reportPiper PA34-200T · Palmer, AKDuring touch go landing the student pilot placed the landinggear handle in the up polition while still on the ground, and immediately placed it in the down position. The gear collapsed. The instructor stated that the student appeared to be fatigued.Mar 19, 1983 · N47895 · Minor damageNTSB DEN83LA081Accident · No injuriesLimited investigationFinal reportCessna 421C · Gunnison, COThe plt began taking off on rwy 06 with a wind from 190 deg at 8 KTS. He stated that max power & RPM were obtained. He noted that he obtained 39 inches of manifold pressure & 2235 RPM at 100 KTS IAS. Reportedly, the acft rotated properly, but began to vibrate…Mar 18, 1983 · N67943 · Substantial damageNTSB LAX83LA146Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Corcoran, CAAccording to the plt, he was taking off in a x-wind condition & allowed the acft to drift off the duster strip. He stated that he decided to continue the takeoff because of soft ground. The acft lifted off, then settled & the gear struck a levee. The plane…Mar 17, 1983 · N4187X · Substantial damageNTSB FTW83LA157Accident · No injuriesLimited investigationFinal reportGulfstream Commander 695 · Houston, TXShortly after beginning the takeoff roll, the acft's right main gear ran off the right edge of the runway into soft wet grass. The soft ground appeared to cause the airplane to continue right and off the runway with takeoff power still applied. The acft…Mar 16, 1983 · N999ST · Substantial damage