OpenAirDocs.org

NTSB investigations

20,559 cases where the phase of flight was Initial climb.

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 = 350)
  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 LAX83LA178Accident · Minor injuriesLimited investigationFinal reportPiper PA 32-300 · San Luis Obispo, CAThe acft departed rwy 29, & at about 200 ft AGL the eng was heard to sputter & surge. The acft was then observed in a steep left bank toward rwy 7. The wings leveled just prior to impact about 100 ft short of rwy 7. Arpt police personnel inspected the acft…Apr 6, 1983 · N15278 · Substantial damageNTSB DEN83FA091Accident · Serious injuriesField investigationFinal reportCessna 182H · Hayden, COThe acft collided with a powerline and crashed after the engine lost power on takeoff. According to witnesses the acft made a normal takeoff but during climbout the engine backfired and dark smoke came out. The acft turned left then steeply right before…Apr 6, 1983 · N2971Y · Substantial damageNTSB LAX83LA176Accident · No injuriesLimited investigationFinal reportCessna 182H · Ruth, CAAfter landing at Ruth, CA, the acft was refueled with aprx 38 gal of 80/87 octane aviation fuel. During takeoff, about 15 min after landing, the eng lost power as the acft was climbing thru aprx 200 to 300 ft AGL. The plt landed straight ahead in the best…Apr 5, 1983 · N2353X · Substantial damageNTSB ATL83LA148Accident · No injuriesLimited investigationFinal reportCessna 175 · Tuscaloosa, ALThe aircraft landed off the runway in soft terrain during a forced landing and nosed down. According to the pilot the engine began to run rough at 400 AGL on takeoff. He turned back toward the field and the engine quit. The pilot could not complete the turn…Apr 3, 1983 · N7588M · Substantial damageNTSB NYC83FU002Accident · Serious injuriesFinal reportCGS Hawk · East Hanover, NJDuring takeoff, the plt heard a bang as the propeller (prop), attaching pulley & reduction drive belts separated, while the ultralight vehicle was climbing thru about 130 ft AGL. At that time. The eng began overspeeding, the nose pitched up & the ultralight…Apr 2, 1983 · UNREG · DestroyedNTSB FTW83FA176Accident · 3 fatalField investigationFinal reportCessna 172N · Cuero, TXThe non-rated plt had been previously employed by the operator & knew where the keys of the acft had been kept. He had no known flight training, but had previously been a passenger in the acft on at least one ocasion. He took the acft without permission,…Apr 2, 1983 · N734ZR · DestroyedNTSB FTW83FA172Accident · 1 fatalField investigationFinal reportCessna 182A · Bethany, OKThe student pilot departed Oklahoma city, OK en route to chickasha, OK. The acft was observed to depart runway 17R and proceed wsw of the airport. The acft wreckage was located about 1 1/2 miles west of wiley post airport. The acft was intact and exam…Mar 31, 1983 · N2030G · DestroyedNTSB DEN83LA095Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA 315B · Craig, COThe helicopter was being used in a long line demonstration when the cable contacted a man on the ground and injured him. According to the pilot, after the acft was landed at the staging area, the field was briefed on helicopter operations for aprx 45 min.…Mar 30, 1983 · N5770F · No damageNTSB FTW83LA169Accident · Minor injuriesLimited investigationFinal reportBeech 35 · El Paso, TXOn a flt after an annual inspn, the plt could not retract the gear, using the normal electrical sys. It remained extended with the green safe light on & the gear pointer indicating down. He tried to assist the normal sys with the manual handcrank, although…Mar 29, 1983 · N3732N · Substantial damageNTSB FTW83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Mountain Park, OKThe pilot stated that he was taking off to the north on a highway for a crop spraying operation. The aircraft was loaded with 720 pounds of chemical and 36 gal of fuel. He perceived a breeze from the south but took off north because of a hill to the south.…Mar 28, 1983 · N6983D · Substantial damageNTSB CHI83LA153Accident · No injuriesLimited investigationFinal reportMooney M20J · Warren, MNThe pilot was practicing a short field takeoff. The acft came off the ground nose high at low airspeed. At about 40 feetagl the pilot retracted the landing gear and while doing this he inadvertantly raised the flaps. The acft mushed back tothe surface. The…Mar 28, 1983 · N1170G · Substantial damageNTSB LAX83LA152Accident · No injuriesLimited investigationFinal reportCessna 182A · Torrance, CAThe plt stated that when he reached aprx 60 ft AGL during takeoff, he noticed the airspeed indicator drop below 40 mph. He said the eng sounded normal. He lowered the nose of the acft, but the airspeed indicator reading remained below 40 mph, so he elected to…Mar 26, 1983 · N2112G · DestroyedNTSB FTW83LA166Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Newellton, LAAprx 1 minute after takeoff the acft engine failed. During the forced landing, the acft flipped inverted damaging one wing tip and the vertical stabalizer. Post crash inspection revealed a crack in the number 7 cylinder, from spark plug to spark plug, which…Mar 24, 1983 · N3652A · Substantial damageNTSB ATL83LA142Accident · No injuriesLimited investigationFinal reportCessna 188B · Houston, MSThe plt reported that during takeoff, he had reached an alt of aprx 100 ft AGL, had reduced power & was retracting the flaps from the takeoff setting when he felt the acft 'give.' He reextended the flaps, applied full throttle & dumped his load, but the acft…Mar 24, 1983 · N731PP · Substantial damageNTSB MIA83LA099Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLA student pilot on a supervised solo flight in a Cessna 152 collided with a remote controlled model airplane during climb out through 400 feet. The acft was damaged but the pilot was not injured. The model airplane was being operated from an adjacent park, by…Mar 23, 1983 · N5547P · Substantial damageNTSB ANC83FAA05Accident · Serious injuriesFinal reportCessna U206G · Rampart, AKThe runway was a 3000 foot gravel strip covered with hard packed snow and snow berms on both sides. The pilot stated he broke ground about half way down the runway at about 50 KTS airspeed. At about 40 feet AGL, he noticed he was drifting toward 60 foot trees…Mar 23, 1983 · N9068G · Substantial damageNTSB DEN83IA083Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Denver, CODuring takeoff the inboard left main landing gear tire & wheel departed the acft. The flight returned and landed withoutfurther incident. Examination of the wheel rim revealed multiple fatigue cracks in the rim.Mar 21, 1983 · N7358F · Minor damageNTSB MIA83FA093Accident · Serious injuriesField investigationFinal reportMooney M20J · Tampa, FLThe accident occurred during an instrument takeoff in IMC. The sky was obscured & visibility zero. After lift-off the acft began to settle. The plt stated he aggravated the situation by advancing down trim which was his routine to establish a 5 deg climb…Mar 20, 1983 · N1166U · DestroyedNTSB ANC83LU001Accident · Serious injuriesFinal reportWaspair HM-81 Tomcat Tour · Chugiak, AKA test plt & dealer for the manufacturer inspected the ultralight vehicle & made adjustments prior to making a test flight after it was assembled. He stated that before takeoff, he was having problems setting the carburetor mixture & that the throttle cable…Mar 20, 1983 · UNREG · Substantial damageNTSB MIA83LA102Accident · Serious injuriesLimited investigationFinal reportGemini Int'l. Humingbird · Lakeland, FLThe acft landed hard and collapsed the nose gear after one engine failed during takeoff. The acft had made one takeoff and landing and was beginning a second. As the acft rotated the left engine failed due to the throttle linkage becoming disconnected. The…Mar 19, 1983 · N3147G · Substantial damageNTSB FTW83LA159Accident · No injuriesLimited investigationFinal reportCessna 150J · El Dorado, ARThe acft collided with trees after running off the end of the rwy during an aborted takeoff. The student plt made 2 touch and go landings and taxied in to have his seat fixed. After the repair he taxied out and held for about 5 minutes for traffic. After…Mar 19, 1983 · N5512G · Substantial damageNTSB LAX83LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Tipton, CADuring takeoff, at aprx 80 ft AGL, the eng backfired then lost power. The plt chose an open field for an emergency landing while trying to dump the load. While landing, the acft bounced, rolled about 600 ft, then hit a dirt berm & subsequently came to rest in…Mar 16, 1983 · N400HP · Substantial damageNTSB LAX83LA142Accident · No injuriesLimited investigationFinal reportCessna T188C · Clarksburg, CAAccording to the plt, he was taking off from a narrow gravel strip with a x-wind when he encounter a strong gust. Reportedly, he lost control when the acft was about 1 ft AGL & the right main wheel hit a ditch. Subsequently, the acft was spun around & was…Mar 16, 1983 · N9957J · Substantial damageNTSB SEA83FU001Accident · Serious injuriesFinal reportWeedhopper 1 · Woodinville, WAThe plt took off in an ultralight vehicle from a sod field. Witnesses observed that the right wing tip was dropped during the takeoff. At aprx 200 ft AGL, the vehicle entered a right spiral & impacted the ground. The lower, right wing, left/drag strut pin was…Mar 15, 1983 · UNREG · Substantial damageNTSB NYC83FNC01Accident · Serious injuriesFinal reportQuickie Q-2 · Norridgewock, METhe new home-built acft had no previous flt time. After making preparations, the plt taxied to rwy 33 for high speed taxi runs with runway lift-offs. On the first high speed run, he lifted off to about 20 ft AGL, then landed back on the rwy. He reported that…Mar 14, 1983 · N298P · Substantial damageNTSB MIA83LA100Accident · No injuriesLimited investigationFinal reportQuicksilver Quicksilver MX II · Lakeland, FLThe acft collided with a sand hill at the departure end of the runway when the acft failed to accelerate sufficiently following a partial power loss during takeoff. According to the operator spark plug fouling in the engine was the cause of the partial power…Mar 14, 1983 · N3132S · Substantial damageNTSB FTW83FA149Accident · 3 fatalField investigationFinal reportPiper PA-34-200 · Kingston, OKThe acft rolled right after a premature liftoff due to a dip in the rwy. The acft continued to roll right until it impacted a 6 degree slope in a 100 degree nose down attitude. Investigation revealed that the right engine had suffered a power loss due to a…Mar 12, 1983 · N43480 · DestroyedNTSB LAX83LA134Accident · Minor injuriesLimited investigationFinal reportEnstrom F280C · Concord, CAThe helicopter collided with a tree during a landing after a decay in rotor RPM during takeoff. According to the pilot the acft was facing southeast prior to departure and the pilot estimated that the wind was from the northwest at 8 KTS. Following a pedal…Mar 11, 1983 · N5691H · Substantial damageNTSB LAX83LA133Accident · No injuriesLimited investigationFinal reportCessna 188B · Delhi, CAThe plt reported that he had been spraying fertilizer in the area all day. While taking off from a strip surrounded by trees, the acft climbed above the treetops, then began to settle. Subsequently, it crashed into almond trees & burned. The plt stated that…Mar 11, 1983 · N731JK · DestroyedNTSB FTW83LA148Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Breckenridge, TXThe student plt stated that she initiated rotation for takeoff at 58 to 60 mph. Very shortly after lift-off, the left wing dropped. The student stated that she seemed to have no control over the acft after the left wing dropped & that she never heard the…Mar 11, 1983 · N24147 · Substantial damageNTSB LAX83LA130Accident · No injuriesLimited investigationFinal reportCessna 195 · Concord, CAAt about 50 ft AGL during the takeoff portion of a touch-and-go, the eng loss power & the acft crashed into a fence. Thecarburetor bowl was drained & about 2/3 of the fluid was determined to be water. The fuel strainer also contained water.Mar 8, 1983 · N1560D · Substantial damageNTSB LAX83LA127Accident · Minor injuriesLimited investigationFinal reportCessna 310C · San Jose, CAThe plt reported that when he was taking off, he heard a noise, during gear retraction, that sounded to him like an explosion & the gear-up light did not illuminate. He then tried to extend the gear, but was unable to get a safe-down indication. He was able…Mar 6, 1983 · N1884H · Substantial damageNTSB CHI83LA129Accident · No injuriesLimited investigationFinal reportRand KR1 KR-1 · Watervliet, MIThe pilot stated that he had flown the aircraft on the previous day and the operation had been satisfactory. Prior to that flight the aircraft had not been flown for two years. After takeoff he experienced power interruption, made a 180 degree turn back to…Mar 6, 1983 · N4306 · DestroyedNTSB LAX83FA123Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Blythe, CAShortly after takeoff the acft experienced a power loss. During the subsequent forced landing the acft collided with trees. Wreckage examination disclosed no evidence of fuel and the engine operated normally during a functional test conducted 6 days after the…Mar 5, 1983 · N9716T · DestroyedNTSB LAX83FA122Accident · No injuriesField investigationFinal reportCessna 210M · La Verne, CAThe pilot had found water in the wing tanks during his preflt but did not drain the fuel accumulator tanks as he was not aware of their existence. The engine sputtered and quit at 100 ft AGL, but the pilot was able to negotiate a landing on the arpt.…Mar 4, 1983 · N761RG · Substantial damageNTSB ATL83LA125Accident · No injuriesLimited investigationFinal reportRockwell 112A · Chestertown, MDThe aircraft settled back to the right of the runway during takeoff and struck an old stanchion used for runway lights. The pilot was unsure of the extent of damage and elected to re-land the aircraft. The landing gear had already been raised, so the landing…Mar 3, 1983 · N1461J · Substantial damageNTSB FTW83FA134Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · La Grange, TXThe plt elected to takeoff to the north on a downsloping paved road. He reported that the wind was variable from the southwest at 2 to 4 KTS, gusting 4 to 6 KTS. At austin, TX, the wind was from 190 deg at 13 gusting 20 KTS & at college station, TX, it was…Mar 2, 1983 · N8384A · DestroyedNTSB FTW83FA133Accident · 3 fatalField investigationFinal reportCessna 177 · Borger, TXAccording to 2 plt witnesses, the acft stalled during takeoff after it had climbed to aprx 75 to 100 ft AGL. They reported that at that time, it did a wing-over, entered a dive & crashed. Reportedly, the acft was loaded to near its max gross wt limit. The…Mar 2, 1983 · N29302 · DestroyedNTSB CHI83LA127Accident · Minor injuriesLimited investigationFinal reportAeronca Champion 7AC · Newberry, MIThe aircraft collided with a telephone pole while attempting a takeoff on skis. The snow was wet, sparse and sticky and the takeoff was being performed on a taxiway because it had more snow. This was a dual instructional flight with the student at the…Mar 1, 1983 · N84583 · DestroyedNTSB CHI83FA122Accident · No injuriesField investigationFinal reportCessna 150 · Wheeling, ILThe student pilot was making a touch-and-go landing and at about 100 ft AGL the engine stopped. A restart was to no avail. The plt stated that he kept the airspeed near stall speed until ground impact. There was fuel spillage at the accident site and no…Feb 26, 1983 · N63044 · DestroyedNTSB SEA83LA059Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Near Oakridge, ORAccording to the pilot, a 250 lb load on a 30 ft external line had been set down at a site at an elevation of about 3500 ft MSL. After the load was released, the pilot attempted to transition from a hover to a climb, but the helicopter began to settle.…Feb 25, 1983 · N62398 · Substantial damageNTSB LAX83LA117Accident · No injuriesLimited investigationFinal reportBell BH 206-L111 · Peach Springs, AZAfter the rotorcraft took off to a hover the pilot did a pedal turn for a down canyon departure. After the hover turn the pilot slid to the right to clear some obstacles and when the rotorcraft moved laterally about 25 feet the pilot heard a bang. The left…Feb 24, 1983 · N3898Y · Substantial damageNTSB MIA83FA081Accident · 2 fatalField investigationFinal reportCessna 182H · Chuluota, FLThe acft crashed from 200 ft AGL on takeoff. Witnesses said the engine quit and the acft made a steep left turn and then dove straight to the ground. The acft had almost made a 180 degree turn to line up with state road 419 when it crashed. This road…Feb 23, 1983 · N2081X · DestroyedNTSB MIA83FLD03Accident · Serious injuriesFinal reportCessna 182 · Zephyrhills, FLOn initial climb at about 250 ft AGL the engine failed. Water was found in the gascolator and in the fuel tanks. A wrinkled ridge was found in the fuel tank bottom which trapped water.Feb 21, 1983 · CGNHL · DestroyedNTSB LAX83LA112Accident · No injuriesLimited investigationFinal reportBell 47G3B-2 · Merced, CAThe eng lost power at about 20 ft AGL for undetermined reasons.Feb 21, 1983 · N88CP · DestroyedNTSB ANC83FU002Accident · 1 fatalFinal reportEagle B · Chugiak, AKReportedly, the plt took off from a yard, and when the ultralight vehicle had climbed to about 200 ft AGL, the eng lost RPM momentarily, then regained power. A witness reported that when the RPM decreased, the ultralight nosed over & went upside down. During…Feb 21, 1983 · UNREG · Substantial damageNTSB NYC83LA070Accident · No injuriesLimited investigationFinal reportCessna 152 · Bally, PAThe pilot reported that he initiated his takeoff from the 1300 ft/blacktop portion of a 2500 ft runway. The remainder of the runway was sod. He stated that he rotated for takeoff about 50 ft from the end of the blacktop portion at 56 to 58 KTS. Also, he…Feb 19, 1983 · N25565 · Substantial damageNTSB LAX83LA108Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Rubidoux, CAThe acft crashed alongside the runway during takeoff in windy conditions. Witnesses observed the acft stagger into the air at slow airspeed from a grass runway into a 20-30 KTS santa ana wind out of the north. The pilot stated that he attempted a soft field…Feb 19, 1983 · N8347X · DestroyedNTSB FTW83LA123Accident · No injuriesLimited investigationFinal reportCessna 180H · Chandeleur Isl., LAThe plt elected to takeoff on a sandy beach aprx 1800 to 2000 ft long. There was a gradual curve in the beach for most of the takeoff distance. The plt reported that there was debris on the beach that was too heavy to move, which he had to dodge with less…Feb 19, 1983 · N9080M · DestroyedNTSB ATL83LA109Accident · No injuriesLimited investigationFinal reportPiper J-3C · Stockbridge, GAThe acft collided with a tree during a forced landing. The plt stated that the acft engine quit shortly after takeoff. Examination of the engine and fuel system failed to reveal any discrepancies or malfunctions. An external fuel tank was connected to the…Feb 18, 1983 · N88037 · Substantial damage