OpenAirDocs.org

NTSB investigations

18,851 cases where the phase of flight was Maneuvering.

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 = 450)
  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 LAX83LA115Accident · No injuriesLimited investigationFinal reportGrumman G164A · Mendota, CAThe acft collided with wires and crashed during and aerial application flight. The acft stalled after hitting the wires with the left wing and was out of control when it hit the ground and nosed over. The pilot said he had 3 miles visibility. He was also…Feb 22, 1983 · N8679H · DestroyedNTSB ATL83LA112Accident · No injuriesLimited investigationFinal reportCessna T188C · Puckett, MSThe acft was damaged during a forced landing after the engine quit due to fuel exhaustion. The plt stated that he forgotto check the fuel prior to takeoff. He said he was upset and distracted because his employees did not want to work on Saturday. Examination…Feb 19, 1983 · N3239J · Substantial damageNTSB FTW83FA121Accident · Minor injuriesField investigationFinal reportCessna P210 · Alexandria, LAThe acft made excessively steep turns at low altitude and the engine lost power. During the forced landing that followedthe acft struck a tree and rolled inverted. It struck the ground in a near vertical nose down attitude. From the amount of fuel aboard at…Feb 15, 1983 · N4880P · DestroyedNTSB DEN83LA061Accident · No injuriesLimited investigationFinal reportCessna 172K · Dove Creek, COThe acft crashed during a low pass over the snow covered runway. The pilot stated that he made two low passes over the rwy during the 2nd pass 'the acft was in ground, effect with mild up and down drafts using minimal power setting.' The left wing was down…Feb 15, 1983 · N84631 · Substantial damageNTSB MIA83FA073Accident · 2 fatalField investigationFinal reportAeronca 7EC · Astatula, FLThe acft made a low pass over witnesses & pulled up steeply. The acft stalled & slid backwards before it became inverted and spun to the ground. There were about 2 rotations in the spin before impact. The plt who is listed as PIC for this flt was employed as…Feb 12, 1983 · N4320C · DestroyedNTSB DEN83FA058Accident · 1 fatalField investigationFinal reportNorth American T-28A · N. Winter Park, COAccording to the surviving passenger (the plt's 15 yr old son), they saw some skiers after crossing over a mountain pass. He stated that as they turned, his father said, 'let's buzz them.' He reported that they turned sharply, 'sort of dove down to buzz…Feb 12, 1983 · N28TW · DestroyedNTSB CHI83LA109Accident · No injuriesLimited investigationFinal reportCessna 150 · Calumetville, WITais Cessna 150 collided with snow covered terrain while practicing the results of 'ground effect'. The weather was VMC and no flight plan was filed. The pilot was not injured in the accident. The flight originated at fond du lac WI at 1200 CST on feb. 12,…Feb 12, 1983 · N11454 · Substantial damageNTSB CHI83LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Mauston, WIThe acft collided with a frozen lake during a low pass while sight seeing. The pilot stated that he dropped down to 250 feet AGL to see if anyone was fishing and hit a downdraft. The acft descended and made contact with the snow and ice covered lake. The…Feb 11, 1983 · N6126T · Substantial damageNTSB MIA83LA071Accident · Minor injuriesLimited investigationFinal reportCessna T-210 · Ft. Myers, FLThe acft nosed over in a swampy area during a forced landing following an engine failure. The weather was VMC and no fltplan was filed. The two occupants of the acft received minor injuries. The pilot indicated that he believed he had enough fuel for the…Feb 8, 1983 · N9561Y · Substantial damageNTSB LAX83FA092Accident · 1 fatalField investigationFinal reportCessna 182P · Wenden, AZThe acft crashed into a hillsideduring a low altitude turn while surveying sheet. The plt in the right front seat who was flying the acft made a steep right turn to follow a herd of big horn sheep and the acft settled into the rising terrain. No evidence of…Feb 6, 1983 · N5943J · DestroyedNTSB LAX83FA087Accident · Minor injuriesField investigationFinal reportBell 47G4 · Five Points, CAThe pilot was on his final pass of the operation. He flew under 2 sets of wires but failed to see a third set. The spray boom caught on the the wire pitching the helicopter nose down. The main rotor hit the tail boom and the helicoptercrashed into a canal.Feb 3, 1983 · N4262Y · DestroyedNTSB SEA83LA049Accident · No injuriesLimited investigationFinal reportCessna A188B · Medford, ORThe aircraft collided with a tree during aerial application operations. The pilot stated that there was a powerline at one end of the orchard he was spraying and a row of leafless trees at the other. One of the taller boundary trees was overlooked by the…Feb 2, 1983 · N4784Q · DestroyedNTSB MIA83LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G2 · Riverview, FLAccording to the pilot he lost control of the acft after a bird hit him on the right temple while flying at about 15 feet above the water. The acft was traveling at about 50 mph when the bird flew in through left door opening. The pilot lost control of the…Jan 29, 1983 · N74822 · Substantial damageNTSB MIA83FA065Accident · 1 fatalField investigationFinal reportMBB Scorpion TOO · Tallahassee, FLThe helicopter collided with trees while on a local personal flight. According to witnesses the acft was flying low overthe trees. Several loud backfires were heard and the helicopter crashed in a wooded area. The acft descended almost vertically with the…Jan 29, 1983 · N5459G · Substantial damageNTSB ATL83FA091Accident · 4 fatalField investigationFinal reportMooney M-20A · Prattville, ALThe left wing separated as the plt began a pull-up after a low pass. The separation point was in the wing root where themain spar had been secured to the fuselage with a metal bracket. A butt splice had been made to the bottom of the wing spar. The fracture…Jan 29, 1983 · N8146E · DestroyedNTSB SEA83FA045Accident · 1 fatalField investigationFinal reportCromwell/Pitts S-1S · Athol, IDThe plt tookoff with an estimated 7 gal of fuel on board. While performing aerobatic maneuver, he entered a vertical, climbing, power-on maneuver. Witnesses reported that the acft climbed to zero airspeed at about 2500 ft AGL. Reportedly, the acft then slid…Jan 24, 1983 · N56T · DestroyedNTSB LAX83LA079Accident · No injuriesLimited investigationFinal reportCessna 140 · Mt. Baldy, CAThe pilot reported that while he was flying toward the crest of mt Baldy, he was blinded by the sun reflecting off of the freshly covered snow peak. As he reached for his sun glasses, the aircraft struck the mountain about 10 ft below the crest.Jan 23, 1983 · N2180N · Substantial damageNTSB NYC83FHA03Accident · Serious injuriesFinal reportPiper PA-22-135 · New Hope, PAThe acft collided with a power line while the pilot and a friend in another plane were flying along the deleware river. The plt reported that as he approached a bridge, he climbed to clear over the bridge and some power lines, then started to descend. He…Jan 16, 1983 · N8604C · Substantial damageNTSB FTW83LA093Accident · Minor injuriesLimited investigationFinal reportDouglas DC-3 · Bay City, TXThe guatemalan registered acft collided with the ground while airdropping bales of marijuana on a beach. According to a witness, while the acft was making low passes over the beach the propeller struck the beach tearing it off the acft. The acft then…Jan 16, 1983 · TGSAB · Substantial damageNTSB DEN83FTI03Accident · Serious injuriesFinal reportPiper PA-18-150 · Galen, MTAccording to witnesses, the plt circled around some ranch building, then began a steep climbing turn. The plt stated that he was momentarily distracted by an outside observation, the climb became too steep, and the plane stalled. The pilot initiated a…Jan 15, 1983 · N4610Y · Substantial damageNTSB SEA83FA042Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Sunriver, ORThe aircraft departed the runway, entered a steep climb and reversed course back over the runway in the opposite direction. At about 200 feet AGL, the aircraft rolled to the left and nosed down into the ground. The pilot had called on UNICOM and said he was…Jan 14, 1983 · N29757 · DestroyedNTSB MIA83LA059Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28A · New Smyrna Bch, FLThe newly purchased helicopter was being ferried to Maryland. During arrival to new Smyrna beach, FL, the 1st planned stop, the plt executed a landing approach to rwy 2. After coming to a hover, the helicopter lost rotor RPM during a pedal turn to a downwind…Jan 10, 1983 · N278Q · Substantial damageNTSB FTW83FA079Accident · 2 fatalField investigationFinal reportMooney M20E · Cushing, OKThe acft collided with a powerline during a low flt down a river. The acft impacted 3 high tension cables spanning the river. Witnesses said the acft was flying low and fast. The collision produced a sound 'like a gunshot' and the acft fell to the ground and…Jan 9, 1983 · N7778M · DestroyedNTSB FTW83LA107Accident · No injuriesLimited investigationFinal reportGrumman G164A-450 · Clyde, TXThe acft collided with a powerline and crashed during a forced landing after a engine failure. The pilot reported that he was pulling out from a swath run when the engine cut out,backfired and started running again. The pilot decided to return to elmdale, on…Jan 8, 1983 · N7843 · Substantial damageNTSB FTW83FA078Accident · 2 fatalField investigationFinal reportCessna 150K · Romayor, TXThe acft spun into the ground from a relatively low alt. The student pilot was giving rides to relatives and had successfully completed one flt during which the acft was stalled followed by a wing over and a dive. These maneuvers were repeated. Estimates of…Jan 8, 1983 · N6049G · DestroyedNTSB MIA83FA057Accident · 2 fatalField investigationFinal reportCessna 152 · La Belle, FLAt about 1720 a commercial plt landed at La Belle arpt & reported that the ceiling was ragged in nature, some 200-300 ftoff the ground, with visibility 2 mi in drizzle. As he was leaving the arpt he noticed 2 men sitting in a blue & while C-152. After…Jan 6, 1983 · N89225 · DestroyedNTSB FTW83FRD02Accident · 1 fatalFinal reportTeal TSC-1A · Port Sulphur, LAThe eng lost power during a pull-up from a low pass over the arpt. The plt made a forced landing in the icy Mississippi river with the gear down. The amphibian struck a submerged object in the river & flipped over. The plt & pax attempted to swim to shore but…Jan 6, 1983 · N2004T · DestroyedNTSB DEN83LA046Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 (Soloy) · Great Falls, MTWhile maneuvering at low altitude in search of animals, the pilot experienced a severe vibration through the flight controls. The helicopter began an uncontrolled descent and attempts to stop the descent by using the collective were unsuccessful. The…Jan 6, 1983 · N7039J · DestroyedNTSB DEN83FTE05Accident · No injuriesFinal reportSchweizer 1-36 · Colo Springs, COThe glider was substantially damaged during a pullup from a dive at altitude. The wing was rippled and beckled and damaged at the attach points. The dihedrial had changed from 6 degrees to 8.5 degrees. There was also unmeasured change in the sweepback. It is…Jan 6, 1983 · N36166 · Substantial damageNTSB LAX83FA067Accident · 2 fatalField investigationFinal reportJavelin Wichawk · Camarillo, CAThe acft impacted the ground 15 degrees nose down 70 degree left bank while performing low level aerobatics. Witnesses had observed the acft performing low altitude aerobatic maneuvers in the area of the accident. The acft was last seen descending at a near…Jan 4, 1983 · N6940 · DestroyedNTSB MIA83LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32-301R · Near Vero Beach, FLThe acft collided with tree tops during a night flight but the pilot was able to maintain control and land at a nearby airport. According to the pilot he was on approach to fort pierce airport when the accident occurred. However according to some witnesses…Jan 3, 1983 · N35590 · Substantial damageNTSB CHI83FA069Accident · 2 fatalField investigationFinal reportNorth American T-6G · Genoa City, WIPrior to the accident the acft flew over the arpt at tree-top level with the gear retracted. The acft then landed. After spending about 15 min on the ground the plts took off to the west. The gear was retracted immediately after takeoff & the acft remained…Jan 2, 1983 · N3168G · DestroyedNTSB ATL83FIG03Accident · 1 fatalFinal reportCessna 172F · Hancock, MDThe aircraft collided with the top two wires of a powerline during a low altitude sight-seeing flight along the potomac river. The pilot stated he was maintaining visual contact with the ground should an emergency landing become necessary. He was staying high…Jan 2, 1983 · N8515U · Substantial damageNTSB LAX83FVM06Accident · No injuriesFinal reportCessna 152 · King City, CAThe acft collided with & broke 3 power lines suspended across a creek. The plt made a precautionary landing at King cityarpt without further incident.Dec 30, 1982 · N5275H · Substantial damageNTSB ATL83FLG03Accident · Minor injuriesFinal reportPiper PA-28R-200 · Cleveland, SCThe plt stated he was VFR on top of a broken cloud layer & decided to descend through an opening. After descending clear of the clouds he was in a pass with hills on each side & not enough room to turn around. He continued north along the highway hoping the…Dec 24, 1982 · N9327N · DestroyedNTSB ATL83FIG02Accident · 2 fatalFinal reportGrumman AA1B · Delmar, MDPilot making steep turns near his home at low altitude stalled and crashed. No malfunctions found. Witnesses said engine sounded normal in flight.Dec 24, 1982 · N6207L · DestroyedNTSB MKC83FA044Accident · 1 fatalField investigationFinal reportCessna R182 · 1 1/2 Mi.N. May, KSThe pilot received wx briefings at 1114 & 1220. He was advised against VFR flt due to low ceilings & visibilities in western Missouri, eastern & northeastern Kansas. At 1300 the plt received a special VFR clearance to depart. At 1330 witnesses observed the…Dec 23, 1982 · N756DB · DestroyedNTSB SEA83FYP01Accident · 1 fatalFinal reportBurke-Parker Quickie · Richland, WAWitnesses first observed the acft proceeding southbound over the departure end of rwy 19 at an altitude of APPROXIMATELY50 ft. the acft then continued southbound at tree-top level for approximately 1 mile in level flt. It then turned eastbound & shortly after…Dec 18, 1982 · N82PB · DestroyedNTSB LAX83FUJ09Accident · 1 fatalFinal reportGrumman American AA-1B · Cornville, AZThe pilot was on a flight from wickenburg to cottonwood, AZ to meet a friend and fly him to phoenix, AZ. During arrival, he made two passes over the top of some homes where his friend was staying, nearby at Cornville, AZ. On the second pass, he made a barrel…Dec 18, 1982 · N9692L · Substantial damageNTSB CHI83LA062Accident · 1 fatalLimited investigationFinal reportScorpion Too · Sandwich, ILThe rotorcraft impacted the runway very hard with no flare after the engine quit 100-200 feet AGL. The pilot had no training in this aircraft. No fuel was found in the fuel tank and no fuel odors were present. An examination of the fuelsystem, engine and…Dec 18, 1982 · N9354A · DestroyedNTSB CHI83LA051Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Muskegon, MIThe pilot descended below his altitude and struck trees approximately 4.7 miles south of his destination. The aircraft continued to fly and the pilot elected to make an emergency landing. After touchdown the aircraft skidded down the runway for approximately…Dec 15, 1982 · N45EV · Substantial damageNTSB LAX83FUJ07Accident · 1 fatalFinal reportBeech K35 · Tucson, AZThe acft crashed into rising terrain left wing tip first. The pilot had made a radio call saying he was landing due to smoke in the cockpit at 1517 MST. At 1523 MST the acft crashed off arpt on an upslope with a 30 degree incline. Examination of the wreckage…Dec 14, 1982 · N6085E · DestroyedNTSB LAX83FUG08Accident · 2 fatalFinal reportRand KR-2 · Norco, CAExperimental aircraft on demonstration flight spun to the ground from low altitude and was destroyed on impact. Witness saw and heard the aircraft maneuver and crash with the engine at high RPM. Weather was VMC.Dec 12, 1982 · N5RU · DestroyedNTSB SEA83LA030Accident · Serious injuriesLimited investigationFinal reportTaylorcraft L-2 · Near Gooding, IDThe pilot made a steep turn close to the ground while taking photographs of coyotes. The aircraft stalled and contacted the ground.Dec 11, 1982 · N68903 · DestroyedNTSB ATL83LA061Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nashville, TNDuring an autorotation at about 125 ft AGL the student attempted to apply power for a recovery but noted that the oil pressure light was illuminated & the eng had quit. The CFI took the controls & executed an emergency landing. He maneuvered to avoid power…Dec 11, 1982 · N90773 · Substantial damageNTSB SEA83AA028Accident · 8 fatalFinal reportde Havilland DHC-2 · Near Klawock, AKAt 1236 the flt departed ketchikan seaplane base with a special VFR clearance & at 1240 reported clear of the control zone. The next & last transmission by the plt was made to the company via fm radio at about 1340. This report was issuedin the vicinity of…Dec 9, 1982 · N68081 · DestroyedNTSB LAX83LA057Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Westley, CAThe acft collided with a dirt berm during a swath run tearing off both main landing gear. The acft continued to fly & an emergency landing was made at crow's landing nas. The plt attributed his inability to maintain sufficient ground clearance to the haze &…Dec 9, 1982 · N6713Q · Substantial damageNTSB LAX83LA053Accident · Serious injuriesLimited investigationFinal reportBell TH-13T · Phoenix, AZAfter a practice spray turn, the helicopter collided with the ground during recovery from a descent back into the field. No discrepancies were reported with the airframe, engine or weather conditions. The pilot was quoted as saying he refrained from pulling…Dec 8, 1982 · N3001F · Substantial damageNTSB ANC83FA022Accident · Minor injuriesField investigationFinal reportEnstrom F-28A · Chugiak, AKThe aircraft collided with ground and rolled while the pilot was hover taxiing downwind. The winds were described as 15 KTS to gusts as high as 45 KTS. The Enstrom chief engineer reported that a downwind hover tends to decay the main rotor RPM due to…Dec 6, 1982 · N9607 · Substantial damageNTSB LAX83FA048Accident · 1 fatalField investigationFinal reportVarieze Ruatan · Riverside, CAWitnesses stated he heard and saw the aircraft flying (rather slow and low) over the canyon. He heard the engine "sputtering" and then observed the aircraft appear to stall followed by a steep descent into the hilly terrain. Investigation revealed the…Dec 5, 1982 · N1182Z · Destroyed