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 CHI82DA063Accident · Serious injuriesFinal reportBellanca 8KCAB · Franklin, WIAfter a 1.8 hour flight, the fixed base operator serviced the aircraft with 15 gallons of fuel. The pilot stated that he drained the sumps as part of his preflight. The pretakeoff checks and takeoff roll were normal. At about 75 to 100 feet AGL, the engine…Feb 21, 1982 · N1218E · Substantial damageNTSB LAX82DA081Accident · No injuriesFinal reportCessna 172N · Grand Canyon, AZThe aircraft was observed to taxi and takeoff with full flaps and a density altitude of about 7700 feet. According to a witness aboard the aircraft the stall warning was going on and off from shortly after takeoff until landing. At about 150 feet AGL the…Feb 20, 1982 · N529CA · Substantial damageNTSB CHI82DA060Accident · No injuriesFinal reportCessna 172A · Roselle, ILShortly after takeoff, the pilot noted a partial loss of power. He turned back toward the airport and turned the carburetor heat on; however, the carburetor heat did not seem to help. The fuel selector was switched from both tanks to the right tank, and this…Feb 20, 1982 · N210GL · Substantial damageNTSB FTW82DA059Accident · No injuriesFinal reportCessna 310D · Farmerville, LABefore this flight, the aircraft had not been flown for a period of time. The pilot was the owner of a maintenance facility and was preparing to perform an annual inspection of the aircraft. He elected to fly it around the airport to warm up the engines…Feb 15, 1982 · N6822T · DestroyedNTSB ATL82FLJ04Accident · 2 fatalFinal reportPorterfield CP-65 · Jacksonville, NCWitnesses heard the eng sputter after takeoff as the acft was in a steep climb. The acft was then observed to turn sharply left, enter a nose down attitude & crash. About 1/2 teaspoon of rusty water was found in the main fuel strainer & the fuel screen…Feb 14, 1982 · N37768 · Substantial damageNTSB LAX82DVA12Accident · No injuriesFinal reportGrumman G-164B · Valley Home, CAThe pilot reported that during takeoff, there was a partial loss of engine power and the aircraft settled back to the ground. The aircraft touched down on soft terrain about 1/4 mile from the runway and flipped over. The aircraft caught on fire and burned…Feb 12, 1982 · N6659Q · DestroyedNTSB MKC82DA030Accident · No injuriesFinal reportCessna 152 · Chesterfield, MODuring takeoff from a touch and go landing, the engine lost power at about 300 ft AGL. The student pilot was unable to restart the engine. The aircraft was damaged during a forced landing off of the runway. No pre-impact engine malfunctions or failures were…Feb 11, 1982 · N757YE · Substantial damageNTSB FTW82FRA16Accident · 1 fatalFinal reportPiper PA-60-602P · Brenham, TXAircraft during entire roll and initial climb after takeoff had an unusually nose high attitude. Aircraft climbed to about 200 feet AGL then appeared to stall and fall off on left wing. Investigation did not reveal any reason for the unusual attitude.Feb 11, 1982 · N6894L · Substantial damageNTSB ATL82IA051Incident · No injuriesIncident investigationFinal reportBeech 200 · Birmingham, ALWhile climbing thru 500 ft AGL on takeoff, the manual pitch trim struck at 1 or 2 units nose up. Use of the three trim disconnect switches did not remedy the problem. About 30 secs later, the pitch trim ran away nose up and would not stop until the pitch trim…Feb 9, 1982 · N205SG · No damageNTSB SEA82FYM09Accident · Serious injuriesFinal reportRockwell Comdr 112TCA · Aurora, ORDuring takeoff, the plane was observed to rotate to a steep nose high attitude, then roll into a steep bank, go into a descent, and crash. During the descent, it rolled to a wings level attitude before impacting with the nose slightly down. An examination of…Feb 8, 1982 · N4660W · Substantial damageNTSB FTW82FQD09Accident · 1 fatalFinal reportPiper PA-18A-150 · Sanderson, TXThe pilot was the owner and operator of the aircraft. A search of the FAA airman and medical records revealed no indication of a previous rating. During takeoff, the plane was observed to climb to about 200 to 300 ft AGL, then nose down and crash. There was…Feb 8, 1982 · N2887Z · Substantial damageNTSB LAX82DA064Accident · No injuriesFinal reportCessna 152 · Corona, CAFollowing a preflight inspection of the aircraft by the student pilot, the aircraft departed the Corona municipal airport on a dual training flight. Upon reaching an altitude of approximately 300 feet, the engine quit. The instructor landed the aircraft…Feb 6, 1982 · N49013 · Substantial damageNTSB NYC82FNE03Accident · Serious injuriesFinal reportPiper PA-28-140 · Ellington, CTThe aircraft was allowed to warm up for 5 to 10 minutes at end of the runway before takeoff. The instructor pilot (ip) reported that the before takeoff run-up was made by using the checklist and all engine instruments were in-the-green. He reported that…Feb 5, 1982 · N721FL · Substantial damageNTSB FTW82DA055Accident · No injuriesFinal reportBell 206L-1 · Gulf Of MexicoThe helicopter was landed on an oil rig platform for refueling. The pilot stated that after refueling, he turned into the wind and took off. As the helicopter cleared the platform, it yawed left and pitched nose down. The pilot applied collective to cushion…Feb 4, 1982 · N2623 · Substantial damageNTSB MIA82FLD13Accident · Serious injuriesFinal reportCessna 172 · Crystal River, FLThe private pilot was a foreign national that was dispatched on a solo cross-country training flight. However, he departed on a different route with a passenger. During the return flight, he encountered deteriorating weather and decided to land at the Crystal…Feb 1, 1982 · N5111D · DestroyedNTSB NYC82FFA03Accident · Minor injuriesFinal reportPiper PA-22 · Lake Placid, NYDuring takeoff, the engine lost power at about 250 ft AGL. At that time, the aircraft was about half way down the 4200 ft runway. The pilot applied carburetor heat and full flaps with the intention of landing on the runway. As the aircraft touched down on the…Jan 31, 1982 · N6758B · Substantial damageNTSB FTW82DA050Accident · No injuriesFinal reportCessna 140 · Bald Knob, ARAn estimate two hours of fuel was observed in the aircraft during the preflight inspection. About 24 minutes after takeoff, the engine lost power during takeoff from a touch and go landing. The power loss occurred at about 100 to 150 ft AGL. The instructor…Jan 30, 1982 · N3041N · Substantial damageNTSB FTW82DA047Accident · No injuriesFinal reportGrumman G-164A · Hobbs, NMThe aircraft engine failed seconds after takeoff on the first flight of the day. The pilot had insufficient altitude and speed to dump his load of dry fertilizer. The plane stalled and touched down hard in a three-point attitude and bounced. The plane then…Jan 23, 1982 · N8584 · DestroyedNTSB ATL82FLT02Accident · 1 fatalFinal reportGrumman AA-1 · New Albany, MSThe airport manager stated that he heard the aircraft takeoff, turn right, then turn back left. A few seconds later he heard the engine rev up and shortly after it hit the trees. He further stated that there was fog in the area and the ceiling was no more…Jan 21, 1982 · N6142L · DestroyedNTSB LAX82IA044Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · San Jose, CAThe aircraft was departing on an IFR flight from San Jose, CA to chester, CA. Shortly after liftoff at an altitude of about 50 feet AGL, the pilot heard a loud bang and the right front seat passenger informed him that the right propeller was missing. The…Jan 20, 1982 · N74HP · Minor damageNTSB NYC82DA026Accident · No injuriesFinal reportPiper Aerostar 601P · Somerset, PAThe aircrew intended to depart at 1600 EST, but due to the general aviation reservation restrictions, the flight was delayed until 1700. The pilot reported the takeoff was normal until just before rotation at 85 to 90 KTS, when freezing rain began to obscure…Jan 19, 1982 · N8043J · Substantial damageNTSB MKC82FCQ08Accident · 1 fatalFinal reportMooney M20F · Cedar Vale, KSWhile landing on the previous flight, the propeller was damaged when it struck an electric fence. After the propeller was repaired, the pilot elected to takeoff at night. A mechanic stated that the pilot had removed all frost before takeoff. Witnesses stated…Jan 19, 1982 · N7761M · DestroyedNTSB LAX82FVG14Accident · 1 fatalFinal reportCessna 150M · Davis, CAThe non-instrument rated pilot had recently received a night checkout on 1/8/82 and was scheduled to have been on a practive night flight. The three nearest weather stations reported ceilings between 200 ft and 400 ft and visibilities from 3/4 to 1 1/2 miles…Jan 18, 1982 · N63182 · DestroyedNTSB LAX82DA042Accident · Minor injuriesFinal reportConvair 440 · Honolulu, HIAfter lift-off, the pilot called for the landing gear to be raised. As the plane was climbing through about 100 ft AGL, the pilot noted a loss of power in the right engine and saw a fire light. Ground witnesses heard a muffled explosion and saw smoke and fire…Jan 18, 1982 · N21DR · DestroyedNTSB ATL82FA035Accident · 2 fatalField investigationFinal reportBeech F50 · Picayune, MSThe aircraft took off during darkness with a single-engine pilot in the pilot-in-command (PIC) position and a multi-engine instructor pilot in the copilot (cp) position. The PIC had a full set of controls (when the yoke was on his side); however, there were…Jan 17, 1982 · N654T · DestroyedNTSB ANC82DA014Accident · Minor injuriesFinal reportCessna 150 · Anchorage, AKDuring takeoff, the aircraft entered a fog bank near the end of the runway while the student was at the controls. The student released the yoke and thought the instructor had assumed control. The instructor reported that he was not paying close attention and…Jan 17, 1982 · N63516 · DestroyedNTSB SEA82DA018Accident · No injuriesFinal reportCessna 140 · Spokane, WAAfter an annual inspection, the pilot made a thorough ground check and taxied out for a test flight. During takeoff, the engine lost power at about 50 ft AGL. The pilot landed on the runway overrun in about 9 inches of crusted snow and the plane nosed over.…Jan 15, 1982 · N72901 · Substantial damageNTSB NYC82FA021Accident · Serious injuriesField investigationFinal reportSwearingen SA 226-TC · Jamaica, NYBefore N341PL started takeoff on runway 31L, a Boeing 747 was cleared to taxi southeast down the outer/parallel taxiway. The taxiway was 375 ft right of the runway centerline. The 747 stopped momentarily, then turned 90 deg left onto taxi- way kk. Meanwhile,…Jan 15, 1982 · N341PL · Substantial damageNTSB DCA82AA011Accident · 78 fatalFinal reportBoeing 737-222 · Washington, DCThe Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-82/08. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Sched…Jan 13, 1982 · N62AF · DestroyedNTSB DEN82FA017Accident · 4 fatalField investigationFinal reportCessna 210N · Riverton, WYThe acft impacted a hill immediately after taking off. The wreckage was located 8,000 ft beyond the departure end of rwy 28 & 1,800 ft left of the rwy centerline extended. The accident site was approximately 55 ft above the airport elevation. Witnesses…Jan 12, 1982 · N6558A · DestroyedNTSB CHI82FA025Accident · No injuriesField investigationFinal reportPiper 23-250 · Wheeling, ILShortly after takeoff the pilot noticed a loss of oil pressure on both engines and initiated a left turn back to the airport. During landing the aircraft departed the right side of runway 12, collided with, and substantially damaged two Cessna 150'S and…Jan 10, 1982 · N6995Y · DestroyedNTSB ATL82FLG08Accident · No injuriesFinal reportMooney M-20J · Hilton Head, SCDuring takeoff at about 200 to 300 feet the engine malfunctioned and the pilot elected to make a gear up landing. Investigation revealed that the left wing fuel tank contained over a quart of water. Water and a red substance similar in appearance to tank…Jan 6, 1982 · N201NH · Substantial damageNTSB ANC82FA012Accident · Serious injuriesField investigationFinal reportCessna A185F · Bethel, AKWhen a passenger arrived for a charter flight, the intended aircraft would not start. Therefore, Cessna A185F, N3343S, a wheel/ski equipped aircraft was selected for the flight. The pilot indicated that the temperature had been extremely cold on the…Jan 5, 1982 · N3343S · Substantial damageNTSB FTW82FRA14Accident · 1 fatalFinal reportCessna R172K · Hearne, TXBefore the aircraft took off, fog was noted at the airport. Witnesses reported that the ceiling was about 100 to 200 ft and the visibility was about 1/2 mile. Reportedly, the pilot tried to contact the fss by telephone; however, only a pay telephone was…Jan 2, 1982 · N758SK · DestroyedNTSB FTW82FPG07Accident · No injuriesClosedCessna 177RG · Little Rock, ARDec 31, 1981 · N1925Q · Substantial damageNTSB CHI82DEV05Accident · No injuriesClosedCessna 172 · Carthage, ILDec 31, 1981 · N5357D · Substantial damageNTSB ANC82DAD04Accident · No injuriesClosedDehavnd Can DHC-2 · Big Pt Walter, AKDec 31, 1981 · N64396NTSB MIA82DKJ02Accident · No injuriesClosedCessna 411 · Panama City, FLDec 30, 1981 · N222WW · Substantial damageNTSB CHI82FEE10Accident · No injuriesClosedCessna 177RG · Monee, ILDec 29, 1981 · N53122 · Substantial damageNTSB DEN82FTA08Accident · Serious injuriesClosedPiper PA-24 · Rock Springs, MTDec 27, 1981 · N9376P · Substantial damageNTSB NYC82FNC03Accident · Minor injuriesClosedCessna 182K · Eliot, MEDec 26, 1981 · N2677Q · DestroyedNTSB CHI82FEX05Accident · Serious injuriesClosedCessna 172 · Paoli, INDec 26, 1981 · N5072A · DestroyedNTSB CHI82FEE09Accident · No injuriesClosedCessna 177 · Paw Paw, ILDec 25, 1981 · N3485T · Substantial damageNTSB LAX82FVM08Accident · Serious injuriesClosedPiper PA-22 · Half Moon Bay, CADec 24, 1981 · N8899C · Substantial damageNTSB CHI82FEX06Accident · No injuriesClosedCessna 182G · Jeffsonville, INDec 24, 1981 · N3414S · Substantial damageNTSB FTW82DRD07Accident · Serious injuriesClosedBell 206L-1 · Gulf Of Mexico (Gulf of Mexico)Dec 21, 1981 · N2203X · DestroyedNTSB DEN82FTE12Accident · No injuriesClosedGulf-Amer AA-5A · Longmont, CODec 19, 1981 · N26872 · Substantial damageNTSB ANC82DAA02Accident · No injuriesClosedTaylorcraft BC12-D · Nome, AKDec 19, 1981 · N95245 · Substantial damageNTSB MKC82FA013Accident · 3 fatalClosedCessna T210N · Jackson, MIDec 17, 1981 · N6347Y · DestroyedNTSB LAX82DUJ21Accident · Minor injuriesClosedPiper PA-28 · Show Low, AZDec 17, 1981 · N9404J · Substantial damage