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 CHI83LA297Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Brooten, MNThe helicopter had just lifted off of the flatbed of a truck when it started to spin. The plt lowered the collective, reduced the power & landed beside the truck. During touchdown, the main rotor blades struck the truck. An investigation revealed that the…Jul 5, 1983 · N4028K · Substantial damageNTSB CHI83LA296Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Kelleys Island, OHThe acft lost power on takeoff and collided with trees about 1/4 mile off the end of the rwy. The pilot said he prefltedand removed about 1/2 ounce of water from each tank, none from the gascolator. Inspection after the accident revealed water in the…Jul 5, 1983 · N5782W · Substantial damageNTSB CHI83IA299Incident · No injuriesIncident investigationFinal reportDouglas DC-8 · Chicago, ILShortly after takeoff during initial climb the no 1 engine failed and an engine fire erupted. The crew discharged 2 firebottles and extinguished the fire. The acft returned to the field and landed without further incident. The no 1 engine 1st stage compressor…Jul 5, 1983 · N8091U · No damageNTSB LAX83FUM08Accident · 1 fatalFinal reportClark Super Q2 · San Diego, CAThe hoem built acft was constructed using the basic design of the Q2, a 2 palce plane with a canard. However, it was built with signigicant design changes. These included a 2nd elevator which created at-tail. The 2nd elevator was operated by a handle which…Jul 4, 1983 · N401JC · DestroyedNTSB ATL83LA254Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BL-65 · Angier, NCThe acft collided with the ground in a nose low attitude just off the end of the rwy after a touch and go landing. Ground witnesses saw the acft make a touch and go landing, pull up, and saw a wing drop as the acft nosed down to the ground. The plt-owner was…Jul 4, 1983 · N23626 · Substantial damageNTSB FTW83LA317Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Jefferson, TXThe acft collided with small trees and two fences during takeoff and nosed down into the ground. A witness noticed the acft wobbling in the air at low alt before the collision with the trees. The density alt was 2800 ft. there were no mechanical malfunctions.Jul 3, 1983 · N9857L · Substantial damageNTSB CHI83FA291Accident · 2 fatalField investigationFinal reportPiper PA-22 · Rogers, OHThe acft collided with trees immediately after takeoff. The acft was 20 lbs under max gross weight. Density alt was 2,500 ft.Jul 3, 1983 · N8914C · DestroyedNTSB MKC83LA141Accident · No injuriesLimited investigationFinal reportPiper PA-36 · St. Paul, NEThe plt stated that when he was unable to get takeoff speed he dumped his load, then hit a fence & fence posts. The acftwas estimated to be within the CG & gross weight limits. Two inspections of the eng revealed no malfunctions.Jul 2, 1983 · N57748 · Substantial damageNTSB MKC83LA140Accident · Serious injuriesLimited investigationFinal reportBalloon Works Fire FLY 7 · Ellsworth, KSThe Balloon collided with a radio tower during takeoff. The wind was reported to be from 180 degrees at 12-18 KTS. There is no evidence that this plt received weather briefing. This Balloon was launched closer to the tower than any of the other balloons…Jul 2, 1983 · N1531N · Substantial damageNTSB MIA83LA193Accident · No injuriesLimited investigationFinal reportLake LA-4 · Gainesville, FLThe plt stated that during takeoff, the eng appeared to lose power at about 200 ft AGL, but the gauges showed no malfunction. The acft began to settle, so he elected to land on the rwy overrun area. Reportedly, the acft was landed successfully, however, while…Jul 2, 1983 · N1FQ · Substantial damageNTSB ATL83LA257Accident · No injuriesLimited investigationFinal reportCessna A188B · Prattville, ALThe acft collided with a cow during takeoff for an aerial application flt. The collision broke off the right main landing gear and killed the cow. The pilot stated that the cow got through the fence and wandered onto the strip. The airstrip has a small rise…Jul 2, 1983 · N9381G · Substantial damageNTSB FTW83LA314Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-2902 · Katy, TXThe glider collided with a ditch during a forced landing after the tow rope disconnected shortly after takeoff. The plt was not able to avoid the ditch during landing due to a strong sink rate. The tow hook assembly was examined after the accident and no…Jun 30, 1983 · N4999K · Substantial damageNTSB NYC83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Pittsfield, MAOn the 1st takeoff, the CFI demonstrated an aborted takeoff by placing the rt selector gasoline valve in the off position and had the student pull the eng back, making a landing on the rwy. The flt then taxied back for another takeoff, again the CFI shut off…Jun 29, 1983 · N6638Y · Substantial damageNTSB ANC83LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Nenana, AKThe acft nose gear failed during a forced landing after the engine lost power during climbout. The plt rptd the engine began to run intermittently then quit completely. The acft had just been serviced with 36 gallons of 80/87 octane fuel. The student pilot…Jun 29, 1983 · N8205K · Substantial damageNTSB FTW83LA304Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Langley, OKThe non-rated plt stated that the eng lost power after he took off & he was unable to restart the eng. During a forced landing, he was unable to clear over wires. He said the nosewheel hit the ground & the acft tumbled as he was attempting to glide under the…Jun 27, 1983 · UNREG · DestroyedNTSB ANC83FA107Accident · No injuriesField investigationFinal reportRotec Engineering 3A · Fairbanks, AKThe plt & a passenger were on a sales demonstration flt in the two-place, home built, ultralight acft. During takeoff, the acft mushed into power lines after attaining an altitude of aprx 30 ft. according to the plt, there was a loss of power during takeoff.…Jun 27, 1983 · N397RE · Substantial damageNTSB FTW83LA293Accident · Minor injuriesLimited investigationFinal reportGlobe GC-1B · Marion, TXThe acft collided with fences during a forced landing after an engine fuel fire. The left exhaust pipe failed and the misdirected heat burned through a fuel line. The fuel ignited filling the cockpit with smoke. The engine quit due to fuel starvation and the…Jun 26, 1983 · N7BL · Substantial damageNTSB DEN83FA152Accident · 2 fatalField investigationFinal reportCessna U206 · Cortez, COThe plt filed a company VFR flt plan & took off at aprx 0930 MDT on a return flt to farmington, NM. According to a surviving passenger, after departing blanding, the acft entered low clouds. Reportedly, the plt flew in the clouds for a period of time until he…Jun 25, 1983 · N5413X · DestroyedNTSB ANC83LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Kasilof, AKThe acft collided with trees and crashed during takeoff. The plt stated he made several attempts to get airborne in bothdirections from the strip and when he finally got airborne he struck a tree and crashed. The plt statements varied during several…Jun 25, 1983 · N4523M · Substantial damageNTSB MIA83LA166Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Yulee, FLThe plt stated that during takeoff, the acft entered a 'right turn' after it had climbed appx 25 ft above the rwy. Reportedly, full control inputs to the left failed to correct the right bank. When the plt saw the acft heading for trees to the right, he…Jun 24, 1983 · N2045H · Substantial damageNTSB DEN83LTE11Accident · Minor injuriesFinal reportEipper Formance MX-2 · Granby, COThe ultralight nosed down during an emergency landing after the engine lost power at about 100' AGL after takeoff. The pilot attempted a landing on the remaining rwy after the power loss, but the acft could not be flared and ended up on the rwy partially…Jun 24, 1983 · N3133L · Substantial damageNTSB CHI83LA278Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Germantown, OHThe acft struck a fence during takeoff. The plt said he rotated too soon and was unable to remain airborne. When the acft collided with the fence it cartwheeled, resulting in engine separation and near separation of the empennage. The wind was reported as…Jun 24, 1983 · N22521 · DestroyedNTSB NYC83LA150Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · Nantucket, MAThe helicopter made a hard landing during an aborted takeoff following a medical evacuation demonstration at Nantucket. After the presentation the acft was changed from a 2 litter configuration. The pilot noted that the cyclic retention cap was on the cyclic…Jun 23, 1983 · N2908U · Substantial damageNTSB DEN83FA150Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Gillette, WYThe plt had recently purchased the acft. While on a x-country trip, he landed at an arpt with an elevation of 4363 ft & refueled. When he was taking off, the density alt was aprx 7089 ft & the acft was near its max gross wt limit. Shortly after lift-off, the…Jun 23, 1983 · N6029V · DestroyedNTSB CHI83LA277Accident · No injuriesLimited investigationFinal reportCessna 188B · Campbell Hill, ILAfter taking off from a haul road, which was being used as an airstrip, the acft began climbing. At about 100 ft AGL, the plt noted a loss of power (thrust) as the eng began to overspeed. The plt lowered the nose to gain airspeed & dumped his load, but was…Jun 23, 1983 · N731KY · Substantial damageNTSB NYC83FA148Accident · 2 fatalField investigationFinal reportCessna 177 · Great Bend, PAThe owner of the acft reported the flight was unauthorized. He stated that during takeoff the eng quit and the plt made a right turn back to the field. Before the turn was completed, the acft stalled and plunged to the ground. Examination revealed that the…Jun 22, 1983 · N2293Y · DestroyedNTSB NYC83LA147Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · Shelburne, VTThe acft crashed into a ditch during an emergency landing after a power loss. The dual instructional flight was climbingat about 200 feet when the power dropped 700-800 RPM. The pilot applied carb heat switched fuel tanks and turned to avoid a housing area.…Jun 21, 1983 · N2389Z · Substantial damageNTSB DEN83FA149Accident · No injuriesField investigationFinal reportCessna T210M · Englewood, COThe acft made a forced landing after the engine lost power during takeoff climb. The pilot had leaned the mixture prior to takeoff. The checklist calls for full rich. When the pilot reduced power after takeoff the engine started detonating and lost power.…Jun 21, 1983 · N761AU · Substantial damageNTSB MKC83FA130Accident · 1 fatalField investigationFinal reportCessna 172N · South Fork, MOTakeoff was from a farm strip 1,600 ft long with grass 8 to 10 inches high. There are trees about 800 ft south of the south end of the strip. The acft took off to the south & made a left turn. After turning about 135 deg the bank abruptlysteepened, the nose…Jun 19, 1983 · N1298F · DestroyedNTSB ATL83FA232Accident · Minor injuriesField investigationFinal reportStinson 108-2 · Laytonsville, MDThe acft lost power at about 200 ft AGL during takeoff. The pilot had just aborted a takeoff because the power went to idle with throttle open. After a run-up of 30 seconds he decided to try again. The power loss occurred at about 200 ft AGL and the pilot…Jun 19, 1983 · N9673K · Substantial damageNTSB DEN83LA147Accident · No injuriesLimited investigationFinal reportCessna 150 · Red Owl, SDBefore the flt the student pilot had checked the fuel by the gages only and had not drained the fuel sumps. He thought he had enough fuel to fly from the ranch to the training school arpt to refuel. The engine quit at 100 ft AGL after takeoff. About 1-1/2…Jun 18, 1983 · N6418F · Substantial damageNTSB CHI83LA273Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Fraser, MIThe eng lost power on takeoff & the acft struck trees as the plt was attempting to return to the aprt. The center electrodes of the spark plugs were worn & covered with carbon. None of the plugs would fire above 55 PSI when put in a champion fire testor.…Jun 18, 1983 · N8430E · DestroyedNTSB DEN83FTM05Accident · Serious injuriesFinal reportBensen B-8M · Wendover, UTThe gyrocopter collided with a powerline at 29 ft AGL. The pilot took off from a road and in proceeding along the road collided with the wires. The pilot was seriously injured. His student pilot certificate had expired in dec. 1979. Due tohis injuries no…Jun 17, 1983 · N67037 · Substantial damageNTSB CHI83LA264Accident · No injuriesLimited investigationFinal reportBell 47-G3B · Litchfield, MNThe helicopter rolled over while attempting a takeoff after servicing from a truck platform for a spraying operation. The hose used to put the chemical spray into the hopper was not removed. When takeoff was attempted the acft was tethered to the ground rig…Jun 17, 1983 · N8471E · Substantial damageNTSB FTW83LA290Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Arlington, TXThe student was departing on a solo x-country flt. He reported that immediately after becoming airborne, directional control was lost & the acft swerved to the left. Full right rudder was applied, but directional control was not regained. As the plt reduced…Jun 16, 1983 · N25838 · Substantial damageNTSB FTW83LA281Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Forrest City, ARThe acft experienced power failure from about 20 feet AGL during takeoff from a private grass strip. A witness heard theengine spit and pop during the takeoff roll. He said it sounded just like his old pickup when it runs out of gas. After the accident the…Jun 16, 1983 · N35520 · DestroyedNTSB LAX83LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Yuma, AZThe plt reported that he landed on a farm road to inspect the alternator & associated wiring before starting aerial application. Following the inspection, during which nothing was found wrong, he commenced taking off. As the acft was accelerating for takeoff,…Jun 15, 1983 · N4337S · Substantial damageNTSB ATL83LA229Accident · No injuriesLimited investigationFinal reportAyres S-2R · Arlington, GADuring the takeoff roll, the acft had nearly reached its lift-off speed when the eng backfired. The plt shut down the eng, dumped the chemicals & stopped on the rwy. He then exited the acft. As he walked around the acft, he smelled a strong odor of fuel. He…Jun 15, 1983 · N30878 · DestroyedNTSB ANC83LA098Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe acft had an external load of plywood attached to its floats. The pilot stated that the acft lost power after takeoff. He made a right turn back toward the lake and the acft stalled. The pilot was recovering from the spin when the floats hit the water.…Jun 14, 1983 · N2565Z · Substantial damageNTSB CHI83LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Crookston, MNThe acft collided with the ground after takeoff. The pilot said the acft lost power and felt sloppy at about 350 ft AGL.he added power but maximum obtainable was 2000 RPM as opposed to 2300. The pilot said he tried to drop the load but the load remained with…Jun 13, 1983 · N8595H · DestroyedNTSB ANC83LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Quinhagak, AKAt about 50-70 ft AGL the eng quit. The acft landed about 1,500 ft off the end of the rwy. The plt stated the acft had been refueled from 50 gal drums immediately prior to the flt. The fuel in the right tip tank contained enough water to have caused eng…Jun 13, 1983 · N15400 · Substantial damageNTSB NYC83FA142Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Collegeville, PADuring takeoff, the acft was observed to enter a steep climb after making a short takeoff roll. One witness estimated that the takeoff roll was about 400 ft & then the acft entered a climb at aprx a 35 deg angle. After reaching an altitude of about 200 to 300…Jun 12, 1983 · N783L · DestroyedNTSB NYC83FGM03Accident · Serious injuriesFinal reportPiper J3C · Greenville, PAAccording to the plt, a cert A&P mechanic, he had flown the acft 1 hr since last inspection & everything operated normally. On the day of the accident, his wife, also a plt, departed their private arpt at mercer, PA on a local flt butlanded at Greenville 15…Jun 11, 1983 · N13DK · DestroyedNTSB NYC83FA141Accident · 4 fatalField investigationFinal reportBeech K35 · Ridgefield, CTShortly after takeoff, several witnesses heard unusual sounds from the acft. One stated that he heard a sputtering noise & the eng stopped, then it restarted, but was not smooth. The other 2 witnesses heard a backfiring or sputtering noise. Subsequently, the…Jun 11, 1983 · N9554R · DestroyedNTSB ATL83LA227Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9 · Florala, ALThe plt reported that during takeoff, the eng began to lose power at the edge of the arpt. He noted that fuel pressure was lost & reported that he was unable to regain the pressure with the electric fuel pump. He switched the fuel selector to the fullest…Jun 11, 1983 · N7284V · Substantial damageNTSB ANC83FA095Accident · No injuriesField investigationFinal reportCessna C-188 · Noatak, AKThe acft collided with the runway at the mid-point in a 30 degree nose low attitude during takeoff. According to the pilot the takeoff was started at the north end of the 5000 foot runway and after 500 feet the acft lifted off normally. The pilot then relaxed…Jun 11, 1983 · N731CN · Substantial damageNTSB FTW83LA278Accident · No injuriesLimited investigationFinal reportCessna 188 · Tucker, ARThis was the first loaded departure from the short, rutted strip which had power lines across each end. During takeoff the plt realized he was going to clear the power line & started to dump the load. However, the fertilizer would not dumpfast enough. The plt…Jun 10, 1983 · N731VF · Substantial damageNTSB ANC83FA096Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKThe plt of the float plane reported that he initiated his takeoff from lake hood toward the southeast with a 'canal option.' He stated that during the takeoff, he pulled the acft into the air before reaching the canal, then started a left turn toward the…Jun 10, 1983 · N2483F · Substantial damageNTSB SEA83FA121Accident · No injuriesField investigationFinal reportLearjet 35 · Seattle, WAThe acft dragged the right wing tip tank and ruptured it after the passenger door opened during takeoff. During the aborted takeoff the acft oscillated right, left and right before making ground contact on the right wing. The highest alt attained was about…Jun 9, 1983 · N1976L · Substantial damageNTSB NYC83LA138Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1 · Mechanicsburg, PAThe acft crashed during takeoff and was destroyed when it slid over logs in the roll-out area. The pilot had 3 hours in the make and model of acft. Takeoff was from a private grass airstrip which was rough and uphill in the direction of takeoff. When a crash…Jun 9, 1983 · N5962L · Substantial damage