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 LAX83FA274Accident · Serious injuriesField investigationFinal reportMooney M20J · Death Valley, CAThe plt initiated his takeoff from the Death Valley arpt at about 1530 hrs on a hot day. Subsequently, the acft collidedwith trees on the left side of the rwy & crashed. An investigation revealed that the acft had angled to the left prior to reaching the 1000…Jun 9, 1983 · N3894H · DestroyedNTSB FTW83LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Addison, TXThe plt reported that during takeoff, the acft 'immediately slid sideways' as the nosewheel lifted off. According to a witness, the acft weathervaned/veered into the wind. Subsequently, the plt reduced power & the acft dropped from about 15 ft AGL to the…Jun 9, 1983 · N65419 · Substantial damageNTSB MKC83FU003Accident · 1 fatalFinal reportAirmass Sunburst · Pittsburg, KSThe plt had completed a private plt ground school course & had flown aprx 4.6 hrs in a Cessna 172 before flying his home built ultralight vehicle. During a test flt, he was making a go-around from a touch-and-go landing when the vehicle crashed. A witness…Jun 8, 1983 · UNREG · Substantial damageNTSB LAX83LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Meadview, AZThe pilot stated that shortly after takeoff at aprx 100 feet, the engine lost power. He then switched the boost pumps from low to high and the engine momentarily surged before losing power. During the forced landing the landing gear collapsed and the wings…Jun 7, 1983 · N8348Z · Substantial damageNTSB SEA83LA119Accident · No injuriesLimited investigationFinal reportBell 205A-1 · Near Randle, WAThe acft was engaged in log slinging operations and had just released a load and initiated a climb away from the site when according to the pilot the engine started to spool down, although the pilot was able return to the log-landingarea there was…Jun 6, 1983 · N98HJ · Substantial damageNTSB LAX83LA270Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Concord, CAThe acft made a forced landing on the arpt after the engine lost power at 150-200 ft AGL on takeoff. The pilot said all preflt checks were normal. Post accident examination revealed no reason for a loss of power.Jun 6, 1983 · N6714J · Substantial damageNTSB LAX83LA265Accident · 1 fatalLimited investigationFinal reportCessna 150 · Show Low, AZThe acft stalled during a night takeoff and collided with the ground. The weather was VMC and no flight plan was filed. No one witnessed the takeoff as the airport was closed. It was a dark night and the student pilot had no night flying experience. The pilot…Jun 6, 1983 · N51255 · Substantial damageNTSB FTW83LA268Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Mcallen, TXThe eng quit during climbout. Inspection revealed that the fuel system contained about 50% clear liquid other than gasoline. The acft had sat with its tanks empty for the past 7-10 days.Jun 6, 1983 · N4016Y · Substantial damageNTSB ATL83LA219Accident · No injuriesLimited investigationFinal reportCessna 172M · Kingston, TNThe plt checked the wx conditions before operating on the 1020 ft grass strip. He landed on the strip at 0935 EDT, took off again about 10 min later, then returned & landed again. Aprx 1 hr & 5 min after his 1st takeoff, he started another departure with 20…Jun 6, 1983 · N13881 · Substantial damageNTSB DEN83LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hamilton, MTGround roll during takeoff was normal but at liftoff the acft began a roll to the left. The pilot said he began the takeoff with less than full power but added full power as the turn began. He tried to correct with aileron to no avail. The acft was now…Jun 5, 1983 · N8787W · Substantial damageNTSB CHI83LU002Accident · Serious injuriesFinal reportBarnstormer 1 · Newton, ILDuring takeoff, the right wing collapsed when the ultralight vehicle was climbing thru aprx 100 ft AGL. An investigation disclosed that the right wing spar failed allowing the section, outboard of the strut attach point, to fold upward.Jun 5, 1983 · UNREG · DestroyedNTSB FTW83LA267Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Kinder, LAThe acft collided with a tree and a levee during takeoff. The plt said the wind had shifted before or during takeoff andthe acft at rotation felt as if it stalled. The acft failed to clear a small tree and then was forced into a levee. The acft nosed over…Jun 4, 1983 · N6642K · Substantial damageNTSB NYC83FNC05Accident · Minor injuriesFinal reportEnstrom 280C · New Market, NHAfter completing a normal run-up & mag check, the plt hovered in ground effect. A normal takeoff was then made in groundeffect. At about 200 ft AGL the plt noticed the RPM dropping from 2900 to about 2700. He tried to restore by dropping collective &…Jun 2, 1983 · N587H · Substantial damageNTSB CHI83LA236Accident · Serious injuriesLimited investigationFinal reportCessna 177B · Jackson, MIThe plt stated the eng quit at about 100-200 ft AGL after takeoff. He executed a descending right turn to remain within the arpt boundary & the acft struck the ground. The upper portion of the magneto mount flange was broken & the magneto was hanging by the…Jun 2, 1983 · N20082 · Substantial damageNTSB FTW83FA259Accident · 2 fatalField investigationFinal reportCessna 180J · Harvey, LAA navigable waterway, Harvey canal, was being used as a seaplane base. In that area, a set of power lines were suspended over the canal by 2 tall towers. The lowest line over the canal was 160 ft above the canal surface, but the lines dropped to heights of…Jun 1, 1983 · N52072 · DestroyedNTSB ATL83LA205Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Blakely, GAShortly after takeoff, the eng sputtered, lost power & belched black & gray smoke. The plt was unable to get the acft to maintain altidude. Also, he was unable to reach an open field, so he landed on the tops of trees. An investigation revealed that the front…Jun 1, 1983 · N8476K · DestroyedNTSB MIA83FA149Accident · 5 fatalField investigationFinal reportPiper PA-23C-250 · Ft. Lauderdale, FLThe acft crashed shortly after takeoff. According to witnesses, the acft veered to the left losing altitude and suddenlyflipped to the left crashing about 1/2 mile from the arpt in a steep left bank. The landing gear was reported in a down position. An…May 31, 1983 · N6103Y · DestroyedNTSB DEN83LA124Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-315B · Kemmerer, WYThe helicopter crashed during takeoff. The weather was VMC and a company VFR flight plan was on file. According to the pilot, he tookoff and brought the acft to a hover, made a right pedal turn and accelerated for a normal takeoff. The acft suddenly jerked,…May 31, 1983 · N16297 · Substantial damageNTSB LAX83LA250Accident · No injuriesLimited investigationFinal reportCessna 337B · Sedona, AZThe acft made a forced landing and collided with a pine tree after a takeoff with a tow bar attached to the nose gear. The pilot reported that he attached a tow bar to get the acft level to measure the oil quantity in the engine. After thepreflt inspection he…May 30, 1983 · N2368S · Substantial damageNTSB FTW83LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Bon Wier, TXThe acft collided with a fence during takeoff from an unimproved field. The plt and his wife had departed houston TX theday before for a 'local' flt. Due to mechanical difficulties a landing was made at Bon Wier. According to the plt, although relatives live…May 30, 1983 · N714UX · Substantial damageNTSB FTW83LA260Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Farmington, NMAccording to the plt, a unauthorized ground crew relieved the plt's crew & would not follow his instructions. After the ground crew moved the Balloon into a position that was upwind from a light pole, they released it & it ascending. The plt stated that he…May 30, 1983 · N2375H · Substantial damageNTSB ATL83FIA01Accident · Minor injuriesFinal reportChampion 402 · Friendly, MDThe left engine quit at 400 feet after takeoff. After the accident fuel was found draining from the right tank filler opening. The acft was leveled and the engine started with boost pump and pumping throttle. The engine was started twice but would not…May 30, 1983 · N9966Y · Substantial damageNTSB MKC83LA117Accident · No injuriesLimited investigationFinal reportMooney M20C · Wheatland, MOThe pilot said the engine lost power after takeoff and settled into trees off the end of the rwy. The engine, damaged by fire, was examined and there was no evidence of pre-impact failures or deficiencies.May 29, 1983 · N6288U · DestroyedNTSB SEA83FYK03Accident · Serious injuriesFinal reportRyan-Navion NAV 4 · Cottage Grove, ORThe acft made a forced landing in a hay field and collaped the landing gear after the engine quit at 500 ft AGL during takeoff climb. During an on scene investigation there was no fuel visible in the rt wing tank. The left wing tank has nofiller access but is…May 28, 1983 · N4468K · Substantial damageNTSB ATL83LA209Accident · Serious injuriesLimited investigationFinal reportBarnes AX-6B · Decatur, ALThe balloon was launched from a field with power lines along the east side after another balloon was launched. The first balloon was aprx 50 ft from the power line when it was launched. When it tookoff, it traveled to the north northwest & remained well clear…May 28, 1983 · N2023H · DestroyedNTSB ATL83LA203Accident · Serious injuriesLimited investigationFinal reportAeronca C3 · Ocean City, MDAt about 150 ft AGL after takeoff the acft stalled. The plt previously had an accident with the acft on 6/13/82. Since that date he had recorded 17 hrs of flt time with less than 1 hr in a J-3 cub. The J-3 is similar to the Aeronca C3 in size but with twice…May 28, 1983 · N16270 · Substantial damageNTSB ATL83FKJ04Accident · Serious injuriesFinal reportCessna 310 · Decatur, ALThe pilot stated that just after retracting the landing gear, the left engine appeared to quit. Unable to maintain flying speed, he elected to land in an open field but was unable to clear a row of trees. The acft impacted the ground after striking the trees.…May 28, 1983 · N8KD · DestroyedNTSB SEA83FU004Accident · Serious injuriesFinal reportWaspair Tomcat · Ketchikan, AKThe plt stated that virtually calm wind conditions existed prior to takeoff to the south, the direction of the prevailing winds. At about 25 ft AGL, the ultralight encountered a strong northerly (tailwind) gust. The ultralight tumbled & struck the ground.…May 27, 1983 · UNREG · Substantial damageNTSB DEN83FA122Accident · No injuriesField investigationFinal reportBell 206B · Billings, MTThe helicopter made a hard autorotative landing after takeoff from an off arpt landing stie. The plt was on a personal flt with family and friends when a engine fire/explosion forced him to land. The fire was extinguished by the plt after landing. Post…May 27, 1983 · N16937 · Substantial damageNTSB CHI83LA232Accident · 1 fatalLimited investigationFinal reportBoeing A75N1 · Lebanon, INThe plt had flown the acft to boone county arpt to get the acft's carburetor adjusted. After the adjustment, he took off to the south on a grass rwy beside the concrete rwy. While climbing thru about 300 to 400 ft AGL, the eng began running rough. The plt…May 27, 1983 · N52470 · Substantial damageNTSB NYC83FNC03Accident · Serious injuriesFinal reportLake LA-4-200 · Vinalhaven, METhe acft crashed following a water takeoff from a small Lake. The pilot and witnesses stated that for approximately two hours before departure an attempt was made to remove water from the tail section of the acft. The water had accumulated due to a missing…May 25, 1983 · N5015L · DestroyedNTSB LAX83LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Aguanga, CAThe acft collided with an abandoned auto during an aborted takeoff. The pilot said he applied full power during takeoff and accelerated to about 85 mph and rotated. At about 15 ft AGL the engine seemed to lose power. The pilot said the engine did not sputter…May 25, 1983 · N4964L · Substantial damageNTSB FTW83LA247Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Beaumont, TXThe helicopter was damaged in an emergency landing in a street. The acft had just taken off from an adjoining parking lot in a shopping center. According the plt the acft lost rotor RPM at 150-175 ft during climb after takeoff and went into a 'settling with…May 25, 1983 · N543FH · Substantial damageNTSB FTW83LA246Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Timpson, TXAcft stalled on takeoff.May 24, 1983 · N62969 · Substantial damageNTSB DEN83LA117Accident · Minor injuriesLimited investigationFinal reportAircoupe 415-C · Big Piney, WYThe pilot was practicing a short field takeoff. However, he held the elevator full back during the takeoff roll until the acft was 50 ft AGL, and then only released it slightly. According to the pilot, airspeed was 47 mph at 50 ft and about 57 mph at 70 ft.…May 22, 1983 · N3726H · Substantial damageNTSB ATL83LA195Accident · No injuriesLimited investigationFinal reportCessna 182P · Nashville, TNThe acft nosed over during a forced landing after the engine quit during takeoff at about 150 ft AGL. After the engine stoppage the pilot said he applied carburetor heat with no effect. A landing was made in a grain field straight ahead. During the landing…May 22, 1983 · N52848 · Substantial damageNTSB CHI83LA223Accident · Serious injuriesLimited investigationFinal reportSchreder HP12A · Stanton, MNThe pilot performed his preflight checks including a flight control check. After lift off the pilot could not control the pitch of the glider. As the pitch increased to about 30 degrees he elected to release the tow cable from the tow aircraft. The glider…May 21, 1983 · N544J · Substantial damageNTSB ANC83LA077Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Aniak, AKAccording to the plt, he was taking off downslope & downwind on bumpy muskeg/tundra with full flaps. At aprx 40 to 45 mph, the acft lifted off before reaching the edge of a deep ravine. He began a shallow left turn, then the left wing struck a tree which spun…May 21, 1983 · N2725M · Substantial damageNTSB SEA83LA102Accident · Serious injuriesLimited investigationFinal reportCessna TRI82 · Idaho Falls, IDDuring takeoff, the engine lost power after the plt started to make a turn at aprx 500 ft AGL. An emergency landing was made in a plowed field with the gear & flaps retracted. After touchdown, the acft slid aprx 100 yards, then stopped in a canal. An…May 20, 1983 · N757SP · DestroyedNTSB NYC83LA120Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Bedford, MAThe engine quit at 250 feet during the takeoff climb. No cause for the engine failure was found.May 19, 1983 · N3201K · Substantial damageNTSB LAX83LU005Accident · Serious injuriesFinal reportWizard W-1 · Shafter, CAThe vehicle involved in this mishap was a Wizard W-1 ultralight which was assembled from a kit supplied by the manufacturer, us, inc. it was designed to be controller by 'weight shifts' of the plt, and featured a ground adjustable fixed horizontal stabilizer…May 19, 1983 · UNREG · Minor damageNTSB LAX83LA243Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Willows, CAThe acft collided with the terrain shortly after takeoff. The pilot stated he noticed signs of a 'power loss'. Trying toland on a highway he abandoned his approach because of traffic and headed for a plowed field. Without time to jettison his load he did not…May 19, 1983 · N48381 · Substantial damageNTSB NYC83LA116Accident · No injuriesLimited investigationFinal reportCessna 150G · So. Bethlehem, NYThe pilot lost directional control during takeoff. The instructor pilot and student were not injured. The student tried to abort a takeoff when the acft started to swerve left. The instructor tried to correct but had difficulty because of the students input…May 18, 1983 · N3138X · Substantial damageNTSB NYC83LA114Accident · No injuriesLimited investigationFinal reportCessna 150L · Waterford, CTThe acft experienced a power loss shortly after takeoff and collided with a tree during the forced landing. Before the flight the only fuel check described was looking at the fuel gauges which indicated one quarter to one third full. During takeoff at about…May 17, 1983 · N11234 · Substantial damageNTSB CHI83LA219Accident · No injuriesLimited investigationFinal reportPiper PA25 · Tomah, WIThe acft lost power and made a forced landing immediately after takeoff on an aerial application mission. The landing gear collapsed during the landing. The pilot stated that the accident occurred on the 5th flt of the day after taking off on runway 27 and…May 17, 1983 · N4521Y · Substantial damageNTSB MKC83LA110Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Gardner, KSThe acft was throughly preflighted to check for water in fuel. The acft had been outdoors in rain for several weeks. Run-up and taxi were normal. During right turn out of traffic the engine quit. The pilot made a landing in a field and nosed over. The acft…May 16, 1983 · N780H · DestroyedNTSB NYC83LNC02Accident · Serious injuriesFinal reportAeronca 7AC · Johnson Pond, METhe acft lifted off from the surface of Johnson Pond and was climbing over trees when the plt made a sharp turn and the acft struck a tree. The acft then impacted the ground and was destroyed by impact and fire.May 15, 1983 · N1241E · DestroyedNTSB CHI83LA214Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Spring Arbor, MIThe acft made a forced landing off the arpt when the engine quit during takeoff climb. The acft had about 1/2 a tank of fuel in both right and left tank before takeoff. The plt was using the right tank for takeoff. The plt had done a 180 degree left turn on…May 15, 1983 · N3242Z · Substantial damageNTSB NYC83LA112Accident · No injuriesLimited investigationFinal reportForney F-1 · Fitchburg, MAThe acft settled into trees during a forced landing on takeoff after a power loss at 800 feet AGL. The flight had started at stow, MA. And proceeded at Fitchburg after practicing stalls and turns for a pilot review. After landing at Fitchburg airport the…May 14, 1983 · N7528C · Substantial damageNTSB ATL83LA186Accident · Serious injuriesLimited investigationFinal reportCummings Quickie Q2 · Asheboro, NCThis particular home built acft was equipped with an 'aileron reflexer.' This modification allowed the plt to change the faired setting of the ailerons, above or below the normal neutral position. Reportedly, this adjustment would affect the lift of the main…May 13, 1983 · N3154Z · Destroyed