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 DEN86LA013Accident · No injuriesLimited investigationFinal reportCessna 170B · Coloradosprings, COThe pilot took off on runway 17. The wind was reported to be from 130 degrees at 10 knots. After liftoff the left wing rose abruptly and the aircraft veered to the right. The pilot stated that because of his low altitude he could not regain control of the…Oct 23, 1985 · N170CE · Substantial damageNTSB ATL86LMG02Accident · Serious injuriesFinal reportAeronca 11AC · Wallace, NCThe acft collided with the terrain following a loss of control during initial takeoff climb. The plt reported that after clearing trees at an alt of aprx 200 ft the acft drifted to the right. The tail of the acft then rose pushing the nose down until the acft…Oct 21, 1985 · N86097 · DestroyedNTSB MIA86FA015Accident · Serious injuriesField investigationFinal reportBeech BE 35 · Zellwood, FLThe private pilot landed at a turf strip utilizing full flaps and 6 units of nose up trim. The pilot stated that when preparing for departure he was in a hurry to avoid inclement weather at his destination and did not utilize a check list he never re-trimmed…Oct 20, 1985 · N2805V · Substantial damageNTSB NYC86FA015Accident · 2 fatalField investigationFinal reportPiper PA-28-236 · Tobyhanna, PAAt about the time N4298K was departing pocono mountains mun icipal airport, recorded radar information from new york ARTCC displayed an aircraft in that area. The aircraft flew eastward and then northward. The aircraft disappeared from the radar screen about…Oct 19, 1985 · N4298K · DestroyedNTSB MIA86MA013Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-9-51 · Tampa, FLShortly after lift-off, the flt crew heard a loud noise (similar, but louder than a tire blow-out) as the #1 eng failed. They secured the #1 eng, remained in the traffic pattern & landed on the same rwy. After landing, an exam revealed the combustion chamber…Oct 19, 1985 · N412EA · Minor damageNTSB FTW86FRA01Accident · Minor injuriesFinal reportCessna 172 M · Houston, TXThe acft made a forced landing on a golf course and nosed over after the engine quit during takeoff. Post accident investigation revealed that the gascolator was full of water and the carburetor contained 25 percent water. No other discrepancies in equipment…Oct 19, 1985 · N9892Q · Substantial damageNTSB ATL86LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-201T · Chattanooga, TNThe aircraft lost total power during takeoff initial climb and attempted an forced landing in a shopping center parking lot. During the landing attempt the aircraft collided with a utility pole and slid inverted approximately 250 ft before coming to rest.…Oct 19, 1985 · N2854S · Substantial damageNTSB SEA86LA014Accident · No injuriesLimited investigationFinal reportCessna 150 · Pullman, WAThe pilot of the landing aircraft failed to see and avoid the departing aircraft. The aircraft struck the departing aircrafts vertical stabilizer and rudder with the propeller. Approximately 40% of the vertical stabilizer and rudder separated from the…Oct 17, 1985 · N3231V · 2 aircraft · Substantial damageNTSB LAX86FA016Accident · 2 fatalField investigationFinal reportOfria Glanair · Van Nuys, CAWintesses stated that the acft had just departed and, during the initial steep climb, it appeared to attempt to return to the arpt, stalled, and spun to gound contact 1/4 mile north of the arpt. Post accident examination failed to discloseany preimpact…Oct 15, 1985 · N179SH · DestroyedNTSB NYC86LA008Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · Norwood, MAAccording to the pilot, during the takeoff climb the aircraft did not develop sufficient power to maintain altitude. The pilot turned the aircraft to the right in an attempt to return to the airport. During the approach to the airport, the aircraft collided…Oct 14, 1985 · N39714 · Substantial damageNTSB CHI86LA010Accident · Serious injuriesLimited investigationFinal reportBeech K35 · New Lisbon, WIAccording to the plt, acft preflight, engine runup and warm up were normal. Takeoff and initial climb up to approx 300 ft AGL were normal also. At this point the engine quit and the plt performed a forced landing in a clover field below him. The acft was…Oct 14, 1985 · N6060E · DestroyedNTSB LAX86FA014Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Schellville, CAThe acft crashed while attempting a slow roll immediately after departing from rwy 34 at the sonoma valley arpt. The plt stated to witnesses that he liked to roll his acft after takeoff. Witnesses indicated the acft became airborne after a 300 to 400 ft…Oct 13, 1985 · N46871 · DestroyedNTSB CHI86LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Troy, MIThe pilot reported a partial loss of power on takeoff. Altitude could not be maintained. During an attempt to return to the airport, the aircraft descended and landed on railroad tracks. The engine was test run at all power settings without discrepancies.Oct 13, 1985 · N9422N · DestroyedNTSB DEN86FA008Accident · 2 fatalField investigationFinal reportCessna 175A · Jal, NMA witness watched the acft takeoff and disappear in the darkness. The plt had intended to make 3 takeoffs and landings to regain currency for night flying. The acft never returned. The wreckage was found 2 miles north of the arpt the following morning. Wx was…Oct 11, 1985 · N6959E · DestroyedNTSB CHI86LA012Accident · No injuriesLimited investigationFinal reportCessna 421C · Wooster, OHThe plt stated that the right eng manifold pressure decreased to 22 inches just after liftoff. He aborted the takeoff and put the acft back on the rwy. The acft ran off the end of the rwy, crossed a road and hit a ditch shearing the landing gear. Post…Oct 11, 1985 · N59EP · Substantial damageNTSB FTW86FA008Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Pecos, TXThe non-instrument rated pvt plt departed on a night flt with wx reported as 300 and 2 in fog and drizzle. Acft impacted terrain shortly thereafter in a 60 degree nose down attitude. The plt had told a friend that after depature he would acquire and then…Oct 10, 1985 · N711OW · DestroyedNTSB ATL86LA004Accident · No injuriesLimited investigationFinal reportCessna 305A(0-1A) · Marietta, GAAircraft was on touch and go landing. Pilot allowed aircraft to become airborne prematurely. Flaps were not raised during go around and pilot stated he lost it. Aircraft veered to left after initial lift off for go around touched down repeatedly,with second…Oct 10, 1985 · N9623Q · Substantial damageNTSB MIA86LA006Accident · No injuriesLimited investigationFinal reportNorth American Navion · Tallahassee, FLThe plt stated that while doing touch-and-go landings at quincy, FL, the left main strut fell off the acft. He then returned to Tallahassee and made an intentional gear-up landing. Examination of the main landing gear scissor ass'y revealed that it failed due…Oct 5, 1985 · N4007K · Substantial damageNTSB MIA86LA002Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Pahokee, FLThe plt stated that upon takeoff from hickory farms airstirp, the aircraft began losing power. He then dumped his load of chemicals and on descent, struck sugar cane and cartwheeled into a canal. No determination could be made as to the nature of the loss of…Oct 4, 1985 · N2443X · Substantial damageNTSB NYC86FA001Accident · 1 fatalField investigationFinal reportMooney M20J · Robbinsville, NJDuring IFR departure from an uncontrolled arpt, the acft was instructed to squawk the discrete freq that had been issued in pre-flt clearance. The plt acknowledged the freq. The acft disappeared from radar. Ground witnesses saw the acft descend out of the low…Oct 3, 1985 · N5750L · DestroyedNTSB MKC86LA001Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas City, MOThe Piper PA-28-140 was departing the Kansas City, MO area for a VFR, no flight-plan flight to warrensburg, MO. Witnesses stated that the airplane appeared to lift off prematurely and remained effectively stalled until impact two min later in a…Oct 3, 1985 · N8047N · Substantial damageNTSB CHI86FEX01Accident · No injuriesFinal reportPiper PA-38-112 · Terre Haute, INThe acft rt main & nose gear collapsed during a forced landing after a power loss during takeoff. The student plt was at the controls when the eng quit at about 300 ft AGL. The CFI took the controls and turned left toward a taxiway for the landing. The acft…Oct 2, 1985 · N3768U · Substantial damageNTSB MKC85LA224Accident · Minor injuriesLimited investigationFinal reportBellanca Citabria 7ECA · Council Bluffs, IAOn climbout fm the Council Bluffs airport the plt reported a loss of engine power and the engine quitting. The plt attempted an air restart but was too low to the grnd to continue. The plt weaved in and out of trees during his descent finally impacting the…Sep 30, 1985 · N1008E · Substantial damageNTSB SEA85LA232Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Lopez Island, WAShortly after takeoff the acft's eng ceased operating for unknown reasons. During the landing rollout, the acft struck a fence and nosed over.Sep 29, 1985 · N95515 · Substantial damageNTSB ATL85MA286Accident · 17 fatalMajor investigationFinal reportCessna 208 · Jenkinsburg, GAAs the plt & 16 jumpers deptd on a skydiving flt, the eng lost pwr at aprx 300' AGL. The acft then banked steeply left, spiraled in a steep nose dwn attitude & crashed. An exam revealed fuel in the tanks was contaminated with wtr & foreign material with the…Sep 29, 1985 · N551CC · DestroyedNTSB FTW85LA361Accident · No injuriesLimited investigationFinal reportCessna 182G · Maypearl, TXPlt stated that shortly after takeoff, the engine failed completely without warning. He set up for and executed a forced landing in a field. During the flare, one wing tip struck the top of a tree and during the landing roll the acft crossed several terraces,…Sep 28, 1985 · N3414S · Substantial damageNTSB ATL85FLT14Accident · Minor injuriesFinal reportCessna 150H · Lebanon, TNThe acft crashed during a forced lndg after a power loss during takeoff. According to reports the plt took off on a check ride with an instructor. At 150 ft AGL pwr dropped to 2000 RPM. The CFI took over and shortly thereafter the pwr dropped to 1800 RPM. In…Sep 28, 1985 · N7086S · Substantial damageNTSB ANC85LA186Accident · No injuriesLimited investigationFinal reportCessna A185F · Port Alsworth, AKThe pilot took off in turbulent wind conditions and lost control of the airplane; striking ground and upending.Sep 28, 1985 · N9676H · Substantial damageNTSB SEA85LA229Accident · No injuriesLimited investigationFinal reportCessna 185 · San Juan Island, WAThe pilot was attempting to depart his private airstrip to the north with trees bordering the north end of the airstrip. The wind was from 360 at 20 knots gusting to 30 knots. The pilot was unable to arrest his rate of sink and made a right turn to avoid…Sep 27, 1985 · N9644H · DestroyedNTSB ATL85FLT13Accident · No injuriesFinal reportPiper PA-38-112 · Springfield, TNThe acft was substantially damaged after contacting thres during a landing following a loss of pwr on takeoff. Post accident inspection revealed the carburetor valve ass'y had separated from the lever ass'y allowing the valve to seat flat against the…Sep 26, 1985 · N2438C · Substantial damageNTSB SEA85LA230Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Burlington, WADuring initial climb, the plt smelled smoke & heard a backfire, then the eng lost power. A forced landing was made in a field on rough/uneven terrain. During the landing roll, the acft struck a ditch & was damaged. A visual inspection revealed that the left…Sep 24, 1985 · N6627V · Substantial damageNTSB NYC85FA245Accident · 1 fatalField investigationFinal reportBell 206B · Chalkhill, PAThe helicopter was being used on an external load operation with a 100 ft cable attached. When a 618 lb load was ready to be moved, the plt started the eng, lifted off & moved the helicopter to a hover over the load. The loaders hooked the load to the cable &…Sep 22, 1985 · N32TV · DestroyedNTSB CHI85FER03Accident · Minor injuriesFinal reportUnivair 108-1 · Mcgregor, MNThe acft contacted trees off the departure end of rwy 18 during a forced landing following a loss of pwr on takeoff. Post accident inspection revealed the fuel selector was positioned for the left tank and the left tank contained no fuel. The carburetor did…Sep 22, 1985 · N8403K · Substantial damageNTSB ATL85FIJ01Accident · Minor injuriesFinal reportStarduster SA-100 · Point Pleasant, WVThe plt stated that she made a normal preflt. She reported that the float type fuel gage indicated that the main fuel tank, which had a capacity of 12 gal, was half full. While climbing thru about 500 ft AGL after takeoff, the eng sputtered & lost power. The…Sep 22, 1985 · N21GT · Substantial damageNTSB LAX85LA398Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Huntington Bch, CAThe plt stated that he aborted his first takeoff because of reduced acceleration. He taxied back, via a parallel taxiwayand made run-on type takeoff. He said that as the acft climbed to an alt of aprx 50 to 60 ft above the rwy he heard a thud and the airspeed…Sep 21, 1985 · N4840G · Substantial damageNTSB CHI85LA386Accident · No injuriesLimited investigationFinal reportCessna 172 M · Freemont, OHThe pilot stated that just after liftoff a gust of wind pushed him back down almost on the runway. He could not accelerate but did keep the aircraft straight and level as he drifted off the runway through a fence and into some trees at a low airspeed. When…Sep 21, 1985 · N9391H · Substantial damageNTSB MKC85LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Kalona, IAThe plt reported that on the initial indication of rain, he elected to takeoff from the harvested soybean field before it became muddy. The field was soft & was about 2100 ft long. Before the acdnt, the wind was from the south, so the plt began his takeoff in…Sep 20, 1985 · N78227 · Substantial damageNTSB FTW85LA351Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Mt. Pleasant, TXThe pilot stated he lost engine power shortly after takeoff. He made an emergency forced landing in a grassy field. An examination showed a collapsed flex air duct from the air filter to the fuel injector. A forty five degree metal duct was not installed…Sep 19, 1985 · N95RA · Substantial damageNTSB BFO85FA077Accident · Serious injuriesField investigationFinal reportCessna 150E · Clinton, MDPlt stated that on initial climb from a normal takeoff, a partial engine pwr loss was experienced. Control of the airplane was lost while maneuvering for a suitable forced landing area. A flight instructor that witnessed the takeoff stated that it appeared to…Sep 18, 1985 · N3518J · DestroyedNTSB NYC85LA237Accident · Serious injuriesLimited investigationFinal reportPiper J-3 · Chenango Bridge, NYAccording to the pax after takeoff the aircraft climbed to about 300 feet. The pilot then made a right turn. During the turn the pilot yelled out 'we're losing it, we're losing it.' Afterwards the aircraft descended and impacted the ground. The pax does not…Sep 15, 1985 · N41440 · Substantial damageNTSB MIA85LA256Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Indiantown, FLThe acft attempted a take-off from an intermediate point of a damp, soft, turf rwy. A 70 deg. Left x-wind of approx 25 KTS existed at the time. The acft became airborne but was unable to clear trees at the end of the rwy. Thee acft was destroyed in the crash…Sep 15, 1985 · N1767Q · DestroyedNTSB SEA85LA213Accident · Minor injuriesLimited investigationFinal reportTodd KR-II · Boise, IDThe acft settled back onto the rwy shortly after takeoff pushing both main gear up through the wings. The plt did not have any previous experience in this type acft.Sep 14, 1985 · N5CJ · Substantial damageNTSB CHI85FET03Accident · 1 fatalFinal reportVanbenthuysen John Bede BD-5B · Elkhart, INThe acft rolled inverted & collided with the ground after an overtemperature reading, an RPM loss and loss of airspeed were recognized by the plt during the recording of the takeoff. The plt had a portable recorder on board and was using it during the…Sep 14, 1985 · N23105 · Substantial damageNTSB NYC85LA234Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · East Swanzey, NHThe acft was preflighted & determined to have 10 qts of oil in the eng. While climbing thru about 1000 ft MSL after takeoff, the propeller RPM began rising to the redline. The plt reduced power & proceeded to make an emerg landing. During a turn toward the…Sep 12, 1985 · N42722 · DestroyedNTSB MIA85FA251Accident · 1 fatalField investigationFinal reportJodel D-9 · Okeechobee, FLThe plt had flown only 4 has in the last 6 months in a Cessna 150 type acft & had never flown a Jodel 09 before. The plt boarded the acft, declined a cockpit check by the owner & made an immediate take off. The plt took off from the grass strip without…Sep 11, 1985 · N12HD · DestroyedNTSB CHI85LA373Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Irwin, OHAt an alt of aprx 20 ft AGL after takeoff, the #1 cylinder failed. A straight ahead landing was made in a corn field during which the acft was destroyed. The eng had under gone a major overhaul 197 hrs prior to this accident.Sep 11, 1985 · N48514 · DestroyedNTSB SEA85LA210Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Winnemucca, NVThe student had recently purchased the acft. On 9/5/85, an instructor plt, who had delivered the acft to the Winnemucca arpt, gave the student a total of 0.4 hr dual instruction, which included 2 landings. The instructor then indorsed the student's log book…Sep 10, 1985 · N2377J · DestroyedNTSB FTW85LA345Accident · Serious injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Caddo Mills, TXThe CFI PIC stated the eng lost power with the acft about 400 to 500 ft AGL. He couldn't return to the arpt due to lack of altitude. He elected to land in the plowed field. The acft touched down and flipped inverted. The air induction duct was found…Sep 9, 1985 · N6262L · DestroyedNTSB ANC85LA175Accident · No injuriesLimited investigationFinal reportCessna 180 · Farewell, AKAcft failed to gain alt & crashed on takeoff from gravel bar weight & balance. CG, & winds were questionable.Sep 9, 1985 · N3657C · Substantial damageNTSB MKC85LA212Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Charles, MOStudent plt on first solo takeoff experienced left yaw after liftoff. While plt attempted to correct for the yaw the acft touched down beside the rwy, traveled a short distance, collided with a dirt bank and nosed over. The plt said there was a left crosswind…Sep 8, 1985 · N67463 · Substantial damage