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 DEN83LA038Accident · No injuriesLimited investigationFinal reportCessna 182 · Afton, WYThe pilot reported that the aircraft had a power loss during takeoff and nosed over in snow during a forced landing. Theoat was 21 degrees. There was no evidence of a mechanical malfunction during a post accident examination.Dec 24, 1982 · N21008 · Substantial damageNTSB ANC83LA026Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Near Palmer, AKImmediately after taking off from a frozen lake, the pilot turned left to parallel a fog bank over the knik river. He stated that while climbing, the engine did not quit, but the propeller lost thrust, and he lost control of the aircraft. He stated that he…Dec 21, 1982 · N4269N · Substantial damageNTSB ATL83FA067Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Johns Isle, SCThe plt stated both engs lost power after takeoff & the acft ditched in the stono river. No preimpact failure and/or malfunction of either eng could be found. The plt did not hold any airman certificate.Dec 19, 1982 · N713BT · DestroyedNTSB MKC83LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · West Plains, MOEarlier in the day, the pilot had landed on a highway after the aircraft ran low on fuel. He purchased 15 gal of automobile fuel and put it in the aircraft fuel tanks. He then took off from the highway, flew to an airport and added an additional 20 gal of…Dec 18, 1982 · N56689 · DestroyedNTSB MIA83FA050Accident · Serious injuriesField investigationFinal reportPiper PA-32R-301 · Homestead, FLThe aircraft lost power during takeoff and the pilot made a hard landing in a plowed field. The magneto cam, p/n 10-349359-9, had separated the shaft. Bendix service bulletin #608 recommending a cam retaining screw had not been accomplished.Dec 17, 1982 · N81012 · DestroyedNTSB ATL83LA066Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Anderson, SCAfter takeoff, while several hundred feet in the air, the engine backfired & quit. The plt was able to turn around & head back toward the arpt, but could not quite reach the rwy. The acft landed 1,000 ft short of the rwy, hit a ditch & flipped over. The plt…Dec 16, 1982 · N61857 · Substantial damageNTSB ANC83LA023Accident · No injuriesLimited investigationFinal reportCessna 185A · Sawmill Bay, AKThe aircraft encountered gusty wind and experienced power loss during takeoff. The pilot made a hard landing on the water and the aircraft nosed over but did not sink. It washed ashore on a rocky beach and was destroyed by wave action. No one was injured in…Dec 14, 1982 · N4939Q · DestroyedNTSB LAX83FVD04Accident · Serious injuriesFinal reportHollman Condor · Fremont, CAUnable to start the eng the plt removed the magneto assisted by bystanders. After freezing the mag impluse coupling he reinstalled the mag. A bystander offered to tighten the mag mounting bolts. The only tool availale was a pair of pliers. The mounting bolts…Dec 13, 1982 · N100WH · Substantial damageNTSB LAX83LUJ06Accident · No injuriesFinal reportFrank Turben Aero Sport Scamp · Carefree, AZThe pilot flew from glendale to Carefree, AZ. After landing, he refueled and paid for 6.7 gals of gasoline. During takeoff, he encountered a partial loss of power. A turn was made toward lower terrain and to land on a golf course. The aircraft barely cleared…Dec 12, 1982 · N37690 · Substantial damageNTSB LAX83LA059Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Big Bear Lake, CAThe acft descended into trees after a non-mechanical engine failure on a night takeoff. The wx was foggy with visibilityless than 100 yards. The elevation was 6,750 ft MSL. It is not known whether the plt appled carburetor heat. The control was broken off at…Dec 12, 1982 · N1221Q · DestroyedNTSB FTW83LA062Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Ruston, LAOn takeoff the pilot heard a loud bang sound then lost engine power. The pilot made a 180 degree descending turn back toward the airport. At the edge of the airport the pilot made a hard touchdown on all three gear assemblies. Investigation revealed the…Dec 12, 1982 · N89100 · Substantial damageNTSB FTW83LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Grandfield, OKShortly after takeoff, a child, who had been allowed to occupy the baggage compartment during the takeoff, fell from the acft when the door opened in flight. The child's grandfather, who occupied the rear seat, allowed the youngster to climb into the baggage…Dec 12, 1982 · N9317J · No damageNTSB SEA83FA029Accident · Serious injuriesField investigationFinal reportCessna 172A · Renton, WAThe eng lost power during takeoff at about 200 ft AGL. The acft then executed a left descending 180 deg turn & crashed on the flightline of an acft company. Investigation revealed that the fuel filter bowl contained about 1/2 fuel & 1/2 water, and the…Dec 11, 1982 · N9846T · DestroyedNTSB CHI83LA058Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Lacon, ILAfter a normal liftoff to pattern altitude the engine began to miss and backfire. The pilot returned to the airport. The pilot performed a thorough magneto check finding no unusual indications. The pilot tookoff and at approximately 200 ft the engine back to…Dec 11, 1982 · N77340 · Substantial damageNTSB CHI83LA055Accident · No injuriesLimited investigationFinal reportCessna 175 · Neenah, WIPilot took off in short ground run. Crosswind blew aircraft to east side of runway. No climb established. Aircraft flew into trees alongside runway. Alignment with runway not maintained.Dec 10, 1982 · N6588E · Substantial damageNTSB MIA83FA046Accident · 3 fatalField investigationFinal reportPiper PA-601P · Valparaiso, FLTwo minutes after takeoff the plt reported a loss of the left eng. He was immediately cleared for a landing at eglin afb. While maneuvering for a landing the left eng & wing separated from the acft. The eng was separated from the wing & showed evidence of in…Dec 9, 1982 · N90692 · DestroyedNTSB ATL83IA054Incident · No injuriesIncident investigationFinal reportGulfstream American G-159 · Chamblee, GAOrion airlines flt 110 experienced an engine fire immediately after tkof from dekalb-peachtree airport. At 400 ft AGL, the rt engine fire warning lt illuminated. Flames were observed over the wing and coming from the inbd side of the right eng cowl. The rt…Dec 8, 1982 · N153TG · Minor damageNTSB FTW83LA055Accident · No injuriesLimited investigationFinal reportBeech 58 · Lovington, NMThe pilot reported that while taking off with a light crosswind, the right passenger door opened. While trying to catch papers and hold the door, the right propeller struck the runway and the right main gear began collapsing. By this time, the pilot decided…Dec 7, 1982 · N18HM · Substantial damageNTSB MKC83LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Olathe, KSOn the second short field takeoff the student pilot allowed the aircraft to liftoff at too slow an airspeed. The right wing dropped and the aircraft impacted the ground beside the runway.Dec 6, 1982 · N757WD · DestroyedNTSB LAX83LA054Accident · No injuriesLimited investigationFinal reportCessna 172P · Dateland, AZDuring takeoff, the pilot was using the right side of a private strip to avoid an area of mud. At lift-off speed, the right wing tip struck a power pole near the right side of the runway and veered toward an irrigation ditch. The pilot was able to clear over…Dec 6, 1982 · N55299 · Substantial damageNTSB ATL83FLG02Accident · Serious injuriesFinal reportPiper 32RT-300T · Hilton Head, SCThe aircraft collided with trees after takeoff. The pilot stated he held 80 or 90 KTS indicated and started what he thought was a normal climb. During gear retraction, the aircraft hit the trees.Dec 5, 1982 · N36447 · DestroyedNTSB LAX83LA049Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Palo Alto, CAThe pilot stated that during takeoff, when the aircraft was about 6 to 10 ft AGL, something hit the left propeller and the left side of the aircraft's nose. He did not see anything, but assumed the plane had struck a large bird. Darkness and the baggage door…Dec 3, 1982 · N8292Y · Substantial damageNTSB ATL83FKG04Accident · No injuriesFinal reportMooney M22 · Hampton, GAAfter takeoff the acft climbed to about 60-70 ft & the eng quit. The acft crash landed off the end of rwy 24. The overboard flexible atmospheric drain vent, connected to the fuel pressurization valve, was found to be plugged by a very small piece of foreign…Dec 3, 1982 · N7728M · Substantial damageNTSB NYC83FNA01Accident · 1 fatalFinal reportCessna 150L · Marstons Mills, MAThe acft was observed to climb at a steep angle to 150-200 ft & then enter a spin. The owner/plt had just finished installing stall fences as part of a stol kit that he was in the process of completing. Examination of the acft showed a partial installation of…Dec 2, 1982 · N1433Q · Substantial damageNTSB LAX83FUJ04Accident · 1 fatalFinal reportPiper PA-32-300 · Douglas, AZThe plt was observed to crash shortly after takeoff. Witnesses stated it had been snowing off & on. The plt's blood alcohol level was 228 mg%.Dec 2, 1982 · N55118 · DestroyedNTSB ATL83FID02Accident · 2 fatalFinal reportPiper PA-28R · Chesapeake, VAThe aircraft had previously been flown from orlando, FL to norfolk/Chesapeake, VA. While the original non-instrument rated pilot was in Virginia, the weather deteriorated, so the owner flew up from orlando (via the airlines) to fly the original occupants back…Nov 29, 1982 · N9025C · DestroyedNTSB LAX83FVG03Accident · 2 fatalFinal reportPiper PA-28-161 · Lincoln, CAThe non-instrument rated pilot took off at about 2003 PST. The weather at the marysville fss (20 NM north) was; thin obscured, 500 ft overcast, 2 miles visibility with fog. The plane crashed about 1800 ft northeast of runway 33.Nov 27, 1982 · N1949H · DestroyedNTSB LAX83FVG04Accident · 2 fatalFinal reportCessna 150L · Lincoln, CAThe acft crashed on the arpt immediately after takeoff. A plt who had landed at the arpt at 2030 reported that fog had just reached the arpt with a top approximately 1,100 ft AGL & the base a 200 ft AGL. He advised the plt against going, but the plt stated he…Nov 26, 1982 · N1411Q · DestroyedNTSB CHI83LA048Accident · No injuriesLimited investigationFinal reportCessna 152 · Rockford, ILThe student pilot with his instructor on board were performing touch and go landings. After the third takeoff the engine quit at approximately 150 ft AGL. The pilot made an emergency landing between the two runways at Rockford. Examination of the engine…Nov 24, 1982 · N6348B · Substantial damageNTSB ATL83FA046Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Cullman, ALAfter takeoff from rwy 1, the acft was observed to climb in a steep attitude into the clouds. The acft crashed in a nearvertical attitude about 3/4 mi from the rwy on a bearing of 050 deg. The control lock pin flag was found in the vicinityof the control…Nov 24, 1982 · N18411 · DestroyedNTSB ATL83FA044Accident · No injuriesField investigationFinal reportRobinson R-22 · Alabaster, ALThe pilot reported that shortly after takeoff, he noticed the rpm's began falling. He stated that he increased the throttle and lowered the collective, but the rpm's continued to decrease until the low RPM warning horn came on. An autorotative landing was…Nov 23, 1982 · N90218 · Substantial damageNTSB ATL83LA043Accident · No injuriesLimited investigationFinal reportAerosport Champ · Spartanburg, SCThe aircraft collided with trees during a forced landing following an engine failure during climbout after takeoff. The engine developed full power during runup and takeoff. During a left turn to crosswind the engine began to lose power andcontinued to lose…Nov 22, 1982 · N27SS · Substantial damageNTSB SEA83LA024Accident · No injuriesLimited investigationFinal reportCessna 170 · Spanaway, WAThe pilot reported that while climbing through about 75 to 100 ft AGL, the engine lost power. He maneuvered the aircraft straight ahead to land beyond a highway. There were transmission lines on both sides of the roadway. The pilot believed he had…Nov 21, 1982 · N2698V · DestroyedNTSB MIA83FA031Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Miramar, FLThe aircraft lost power after a touch and go landing and the pilot elected to land in a meadow. The aircraft collided with a ditch after 300 feet of ground roll and the pilot lost control. The aircraft cartwheeled and was destroyed. The pilot was fatally…Nov 21, 1982 · N3677A · DestroyedNTSB FTW83FA039Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Hennessey, OKThe plt was giving taxi rides to his grandchildren at a private farm strip. Accompanied by two teenage granddaughters, the plt was observed in the right front seat holding the entry door open while taxiing the acft up & down the strip. A witness heard the…Nov 21, 1982 · N9816W · DestroyedNTSB LAX83FA037Accident · Serious injuriesField investigationFinal reportTifft-V Varieze · Santa Paula, CADuring takeoff the acft did not become airborne until reaching the end of the rwy. After flying under the first set of wires the left main gear struck the roof of a small house off the east end of the field, taking down a tv antenna. The acft engaged heavy…Nov 20, 1982 · N115EZ · DestroyedNTSB NYC83FA030Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Plymouth, MAThe aircraft had been repossessed. The purpose of the flight was for the pilot to demonstrate it to one or both of the other occupants. Prior to this flight, the aircraft had not been flown since 5/20/82. During takeoff, the engine lost power at about 200 ft…Nov 19, 1982 · N9103J · DestroyedNTSB CHI83FA042Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · Mccutchanville, INAt about 0401 EST, the pilot took off on an IFR flight and was cleared to climb and maintain 6000 ft MSL. Radar contact was established at about 0402. After about another 30 seconds, radar contact was lost. The aircraft impacted about 3 to 4 mi from the…Nov 19, 1982 · N2161N · DestroyedNTSB CHI83LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Black River Fal, WIAfter flying in the local area about 1 hr, the pilot landed at the airport. While taxiing back to the hangar, he elected to make another short flight. The aircraft was taxied back to the runway and a takeoff was made. No engine runup or carburetor heat check…Nov 17, 1982 · N813A · Substantial damageNTSB CHI83LA036Accident · No injuriesLimited investigationFinal reportQuickie · Red Wing, MNThis was the pilot's first flight in the new home built aircraft. He had no previous flight time in this make and model and had no previous flight experience in aircraft with canard airfoils. He stated that after lift-off, the aircraft began to porpoise, and…Nov 16, 1982 · N69HD · Substantial damageNTSB MIA83LA028Accident · No injuriesLimited investigationFinal reportCessna 177RG · Pensacola, FLAccording to the pilot, shortly after liftoff the engine lost power and he aborted the takeoff. The aircraft overran the end of the runway and collided with uneven terrain.Nov 14, 1982 · N2699V · Substantial damageNTSB ATL83AA031Accident · 8 fatalFinal reportPiper PA-31-310 · Spencer, VAThe pilot filed an IFR clearance and took off on runway 30 after dark. At that time, the airport manager was in his living quarters, getting ready to eat his evening meal. He reported that from his position, the takeoff height looked normal. As the aircraft…Nov 14, 1982 · N3538R · DestroyedNTSB LAX83FA030Accident · 1 fatalField investigationFinal reportCessna T337D · Scottsdale, AZFour minutes after takeoff the plt radioed that his eng had failed & he was going down. The acft crashed into a residential area, striking power lines, a fence & two houses. The acft had been flown during the day with no refueling the right aux tank contained…Nov 10, 1982 · N86041 · DestroyedNTSB DEN83LA016Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Beulah, NDPilot said he experienced power loss during takeoff, used carburetor heat but it seemed to get worse. He landed in a soft field to right of runway. Wing hit a fence and aircraft flipped inverted. Engine kept running until crash. No malfunctions found.Nov 10, 1982 · N739FZ · Substantial damageNTSB ATL83FKG01Accident · 1 fatalFinal reportBeech A23 · Junnel Hill, GADuring takeoff, the engine lost power at about 700 ft AGL. A forced landing was made in a pasture that was hilly with a gully running through it. During the landing, the aircraft first contacted the top of a small Hill in the pasture, then became airborne a…Nov 8, 1982 · N3513R · Substantial damageNTSB NYC83LA023Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Prospectville, PAPrior to departure the pilot performed a run-up and engine check. All indications were normal. The pilot stated that the takeoff was normal until 100 feet when an engine power loss was experienced. He attempted to land on the remaining runway, however was…Nov 7, 1982 · N2230H · Substantial damageNTSB LAX83LA029Accident · No injuriesLimited investigationFinal reportCessna 172 · Alamo, NVAfter takeoff from a desert road the acft settled & struck a yucca tree.Nov 7, 1982 · N41783 · Substantial damageNTSB CHI83LA032Accident · Serious injuriesLimited investigationFinal reportTemco GC-1B · Boston Heights, OHThe pilot reported that the engine lost power abruptly as he was climbing through about 200 ft AGL after takeoff. During a forced landing, he maneuvered to avoid houses and attempted to land between two trees. Reportedly, the aircraft collided with a tree and…Nov 7, 1982 · N78309 · Substantial damageNTSB NYC83LA022Accident · No injuriesLimited investigationFinal reportCessna 172H · Clarion, PAAfter engine quit pilot tried to return to airport but crashed off airport in a turn collapsing the nose gear and damaging the right wing. The fuel aboard was one gallon in left tank and about two gallons in right tank. The gauges indicated empty for left and…Nov 6, 1982 · N2649L · Substantial damageNTSB LAX83LVG02Accident · No injuriesFinal reportSchleicher ASW-20 · Calistoga, CAThe pilot stated that he forgot to connect the elevator control when he assembled the glider for the flight. He also stated that he did not become aware of this situation until he tried to use the control during takeoff. The aircraft crashed in a nose down…Nov 6, 1982 · N3682 · Substantial damage