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 CHI83LA052Accident · No injuriesLimited investigationFinal reportCessna A150 · Fostoria, OHThe student pilot was practicing ground reference maneuvers when he experienced a power failure. A forced landing was made in an open plowed field. The aircraft nosed over. The aircraft had been flying about 1 hour and was out of fuel. It as estimated that…Dec 5, 1982 · N7399A · Substantial damageNTSB CHI83FA068Accident · 1 fatalField investigationFinal reportCGS Hawk · Dewitt, MIThe owner had been conducting hi-speed taxi practice with short takeoff/landing hops in the same direction but was unable to obtain lift-off. He then asked the plt to see what the problem was the plt said he would not attempt to fly the ultralight. On the 2nd…Dec 4, 1982 · N918JS · DestroyedNTSB NYC83FA034Accident · 2 fatalField investigationFinal reportBeech C23 · Hazleton, PAOn 11/28/82, the pilot encountered icing conditions and landed at Hazleton, PA. The aircraft was not deiced at Hazleton and icing conditions continued until the morning of 11/29/82. While departing on 11/29/82, the aircraft was observed to use more than two…Nov 29, 1982 · N2014D · DestroyedNTSB ATL83FKM01Accident · 1 fatalFinal reportCessna 172P · Near Maider, NCThe pilot crashed into trees 6 miles east of maiden, NC in deteriorating weather. Witnesses described the weather as rainy and foggy in the area of crash. Some heard the aircraft flying low before colliding with trees. The pilot was off course for statesville…Nov 27, 1982 · N53460 · DestroyedNTSB MKC83FA025Accident · 3 fatalField investigationFinal reportCessna 172K · Oxford, NEThe pilot made 3 low passes near his son's home. Reportedly, the 3rd pass was made at an altitude of about 40 to 50 ft AGL. A witness then observed the pilot pull up abruptly to about a 45 deg climb. After climbing an additional 40 to 50 ft, the aircraft…Nov 25, 1982 · N79173 · DestroyedNTSB DEN83FTK02Accident · 5 fatalFinal reportCessna 182Q · Bryant, SDThe aircraft crashed in an open, flat, stubble field just south of Bryant SD. The angle of impact was 45 degrees nose down, with wings level. Fire after impact consumed most of the wreckage and the 5 occupants received fatal injuries. Theweather was IFR with…Nov 25, 1982 · N94657 · DestroyedNTSB ATL83LA047Accident · No injuriesLimited investigationFinal reportCessna 150J · Bedford, VAWhile practicing stalls and turns, the student stated the aircraft began to vibrate. The student attempted to eliminate the vibration by reducing and advancing the throttle and found the higher the RPM, the greater the vibration. Upon attempting to land in an…Nov 25, 1982 · N60631 · Substantial damageNTSB DEN83FTM03Accident · 3 fatalFinal reportCessna T210M · Tremonton, UTThe acft was observed flying over the interstate highway approximately 100 ft AGL prior to colliding with two high voltage power transmission lines.Nov 24, 1982 · N6011N · DestroyedNTSB DEN83FTE04Accident · 2 fatalFinal reportScorpion 133 · Englewood, COThe helicopter crashed while maneuvering at low altitude. The pilot had modified the cowling and had only completed the first phase of his training in this aircraft. The school warned the student not to try advanced flying without more instruction. A witness…Nov 22, 1982 · N4KF · DestroyedNTSB DEN83LA022Accident · No injuriesLimited investigationFinal reportBell 206B · Near Kalispell, MTAcft departed hospital at missoula in good wx to assist highway accident victim 5 mi east of clinton. Victim was placed aboard helicopter on stretcher for emergency flight to hospital. About 5-6 mi east of missoula plt noticed light snow falling & observed a…Nov 21, 1982 · N5011G · Substantial damageNTSB MKC83FA024Accident · 1 fatalField investigationFinal reportCessna 172 · Wamego, KSA witness observed the acft flying low along the Kansas river for about 2 mi just before the accident. He stated that the acft was flying below the tops of trees bordering the river. The two lower strands of a power line, which crosses the river, were found…Nov 20, 1982 · N3599E · DestroyedNTSB FTW83LA042Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Waco, TXDuring the second swath run the pilot struck a power wire located in a tree line. The aircraft crashed in a OAT field and was destroyed by ground fire.Nov 20, 1982 · N6839L · DestroyedNTSB FTW83LA041Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Sherman, TXThe passenger stated that after takeoff from dallas the plt drank 6 cans of beer before landing at texhoma. While taxiing from landing the plt allowed the left wing to collide with a tree putting a dent in the leading edge. They then went to a restaurant…Nov 20, 1982 · N20576 · Substantial damageNTSB CHI83FA044Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Evart, MIThe aircraft flew into trees during low flight in IMC weather. The pilot had received a weather briefing and was instrument rated but was not on an IFR flight plan. IMC weather was forecast for the route planned. Hunters heard the aircraft fly over at a low…Nov 19, 1982 · N6012H · DestroyedNTSB ANC83LA015Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Elim, AKAccording to a witness, the acft lifted off the rwy about midfield, climbed to about 30-50 ft AGL & then began a dive. The witness heard no change in eng sound. The acft's wing first struck a box set on top of other equipment on the ground(about 4 ft 6 in…Nov 17, 1982 · N2780D · Substantial damageNTSB NYC83FHA01Accident · Serious injuriesFinal reportPiper PA-28-180 · Bethel, PAWitnesses stated the aircraft made several low level passes over a farm house including flying under powerlines before colliding with a tree. The pilot, who was seriously injured could not remember the circumstances leading to the accident. Examination of the…Nov 16, 1982 · N2581R · Substantial damageNTSB SEA83FA018Accident · 2 fatalField investigationFinal reportStinson 108-3 · Lynnwood, WAThe eng failed approaching the arpt at low altitude. The acft struck trees during a descending turn toward a power company right-of-way. Investigation revealed that the impulse drive springs on both magnetos had failed in fatigue. The springs are not assigned…Nov 13, 1982 · N6943M · DestroyedNTSB NYC83LA028Accident · No injuriesLimited investigationFinal reportAerospatiale SA316B · West Mifflin, PAPilot turned aircraft into the wind to perform power check. Approximately 3-5 ft above the ground the pilot reportedly began receiving feedback through the cyclic. Moderate then severe vibration of the airframe was reported. Aircraft yawed 90 degrees left and…Nov 13, 1982 · N72590 · Substantial damageNTSB NYC83FFA01Accident · Serious injuriesFinal reportCessna 150L · Hunter, NYThe acft stalled while making a low level steep turn over a residential area.Nov 11, 1982 · N11263 · DestroyedNTSB SEA83FYA01Accident · 1 fatalFinal reportCessna 180B · Near Irwin, IDThe pilot and two passengers were on a local flight to spot moose. While flying low with the flaps extended, the aircraft collided with trees on rising terrain, then impacted on the ground and burned. Initial impact occurred with a 75 ft tall tree, about 60…Nov 7, 1982 · N5271E · DestroyedNTSB FTW83FRA02Accident · 1 fatalFinal reportJohnson, Douglas L. Jayhawk · 3 North Brooksh, TXThe previous owner had just sold the aircraft and had moved it on a trailer, with the wings removed, to the new owner. After the wings were re-installed, the previous owner flew the aircraft to demonstrate the handling characteristics. The next flight was…Nov 1, 1982 · N28352 · DestroyedNTSB ATL83FLA01Accident · 2 fatalFinal reportCessna 172M · 9nm Nw Quitman, GAWitnesses observed the acft a little above the tree tops prior to colliding with a high voltage tension wire. The two passengers (ages 10 & 11) were seated in the right front seat, both using the same seat belt. The surviving passenger stated they had…Oct 31, 1982 · N8977V · DestroyedNTSB NYC83FA004Accident · 1 fatalField investigationFinal reportTed Smith 601P · Augusta, MEPilot lost control of his aircraft during low altitude maneuvers to align the aircraft for landing. The low ceiling and rising terrain around the airport influenced the pilots decisions to make tight turns at low altitude. The aircraft was stalled and rolled…Oct 29, 1982 · N90439 · DestroyedNTSB LAX83LA022Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Delano, CAThe pilot was making a helicopter spray run and decended into trees on th irst pass after reloading. He got a low RPM light in a reduced power situation. No malfunctions were found. The pilot had made 34 similiar operations during this schedule.Oct 28, 1982 · N15FC · DestroyedNTSB NYC83LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Buckingham, PAAircraft collided with a tree during one of several low passes. Pilot said he had temporary power loss. Witnesses said his passes were at high speed, high power with no sign of engine trouble. He made a seccessful landing back at departure point with damaged…Oct 27, 1982 · N4956L · Substantial damageNTSB LAX83LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Coolidge, AZThe pilot stated that he flew into a dust devil while in a downwind, procedure turn and the aircraft stalled. Reportedly, he dumped his load and applied full power, but he was able to recover before the plane hit the ground, left wing first. The pilot…Oct 26, 1982 · N6628Q · Substantial damageNTSB FTW83FQA01Accident · 1 fatalFinal reportCassutt 111M · Moriarty, NMThe pilot tookoff to deleiver the aircraft to a new owner. Shortly after takeoff, the aircraft turned as if to return to the airport and suddenly nosed down and dove at a 30 to 45 degree angle. Before leveling off, it mushed into the ground hard enough to…Oct 25, 1982 · N19L · Substantial damageNTSB FTW83LA020Accident · No injuriesLimited investigationFinal reportPiper J-3 · Sweetwater, TXWhen the confederate air force failed to show up for an airshow the pilot was asked to make some low passes over the airport and explosive charges were to be set off to simulate bomb bursts. During one low pass the charges were exploded too soon. The…Oct 24, 1982 · N38449 · Substantial damageNTSB DEN83LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-125 · Camp Crook, SDPilot making low altutude turns found controls jammed and collided left wing low in descent with bales of hay. Fuselage was found to contain spent and live shotgun shells under the floor. Aileron had a firing pin from a shotgun lodged in a pulley. The pilot…Oct 24, 1982 · N1190A · DestroyedNTSB ATL83FKQ01Accident · 2 fatalFinal reportCessna 150F · Sidon, MSThe student pilot and passenger departed jackson on a flight to madison, MS. The highway patrol received a report of a low flying aircraft and a loud noise in the vicinity of Sidon, MS, the aircraft wreckage was found the next morning in a soy bean field. The…Oct 24, 1982 · N3066X · DestroyedNTSB DEN83FTI02Accident · 2 fatalFinal reportCessna 172P · Dillon, MIThe pilot and three passengers departed Dillon, mt at about 0740 MDT to scout for elk in preparation for hunting the next day. According to a passenger, they flew directly to a mountain area about 30 miles away where they spotted some elk. He said that while…Oct 23, 1982 · N4AM · DestroyedNTSB CHI83FA023Accident · 1 fatalField investigationFinal reportRobinson R-22 · Indian Hill, OHThe helicopter was observed circling an athletic field. During the third pass over the field it was observed to come to a near hover immediately followed by a tailrotor separation. The manufacturer issued a safety notice 12/4/81 & again on 10/4/82 stressing…Oct 21, 1982 · N9015R · DestroyedNTSB NYC83FGM01Accident · Serious injuriesFinal reportHughes 369D · Coaltown, PAThe pilot and two passengers were patrolling along the west'side of a power line from south to north. While patrolling the pilot was maintaining an altitude of 75 to 100 ft AGL at 20 to 30 KTS with an 8 to 10 kt tail wind. He reported that he was descending…Oct 20, 1982 · N31PL · DestroyedNTSB ATL83FA013Accident · 1 fatalField investigationFinal reportBeech B-23 · Lexington, SCThe aircraft crashed in a corn field shortly after takeoff. The aircraft was owned by the pilot who was fatally injured in the accident. The weather was VMC and no system malfunction could be found. The aircraft was seen flying at low altitude prior to the…Oct 20, 1982 · N9143T · Substantial damageNTSB ATL83FA021Accident · 3 fatalField investigationFinal reportLockheed 18 · Kosciusko, MSThe acft was observed without lights making repeated low altitude passes over a pipeline right-of-way at night. The acftwas equipped with an internal aux fuel tank, non-standard internal plumbing, a large lever-operated petroleum products pump, an inflatable…Oct 18, 1982 · N1040G · DestroyedNTSB DEN83FTM01Accident · 1 fatalFinal reportBowers Flybaby 1A · Ephriam, UTApproximately 4 ft of the inboard section of the left wing separated in flight during an aerobatic maneuver. Witnesses stated that the acft had been performing little loops & then it went straight up & rolled off to the left upside down. It then spiralled…Oct 16, 1982 · N63498 · DestroyedNTSB ATL83FA012Accident · 1 fatalField investigationFinal reportCessna 182P · Conyers, GAAircraft was observed making low passes. During on of these low passes aircraft collided with wires, trees and a tennis court. Pilots blood ethanol level was 214 mg percent. The pilot had not been given permission by the owner to fly the aircraft.Oct 16, 1982 · N52333 · DestroyedNTSB LAX83LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Bakersfield, CADuring flight, the piot decided to practice a simulated forced landing. During an approach to an alfalfa field, the aircraft struck a power line and crashed.Oct 15, 1982 · N65616 · DestroyedNTSB FTW83LA018Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Sicily Island, LAThe pilot stated that on his last swath run the left outboard section of the wing collided with a light pole and separated jamming the aileron. The aircraft became uncontrollable and crashed in an open field. The aircraft cartwheeledand broke up before coming…Oct 15, 1982 · N8520L · DestroyedNTSB CHI83FA016Accident · 1 fatalField investigationFinal reportLuscombe 8A · Delavan, WIThe airport manager stated that the aircraft had been flying for about 45 min when it returned to the airport. He reported that the pilot made a low pass over the runway, as if he was checking the wind for landing. He saw the pilot start to climb and enter a…Oct 15, 1982 · N1094K · DestroyedNTSB SEA83FA009Accident · 2 fatalField investigationFinal reportBoeing Vertol 107 · Cascade, IDDuring a log slinging operation a loud bang was heard & the acft was observed to rapidly descend vertically to the ground with numerous small fragments falling in the same vicinity. The #5 synchronization shaft was found to be fractured at the forward end…Oct 14, 1982 · N6676D · DestroyedNTSB LAX83FVA01Accident · Serious injuriesFinal reportEagle DW-1 · Near Bakersfiel, CADuring a turn-around while spraying a cotton field, the aircraft started rolling to the left and the pilot could not stop it. He stated the left spoiler remained deployed and would not close. He fought the roll until it impacted with the ground. The left…Oct 14, 1982 · N88126 · DestroyedNTSB CHI83LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · Sacred Heset, MNWhile on a flight to photograph farms, the engine lost power and the pilot was unable to get it restarted. An emergency landing was made in a bean field that was soft from recent rains. Shortly after touchdown, the aircraft nosed over. After the accident,…Oct 14, 1982 · N758QX · Substantial damageNTSB MKC83LA006Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Le Mars, IAThe pilot was on a power line patrol mission with an observer on board. According to him, the wind was from the west at about 20 KTS and he was flying east along a line that made a 90 degree turn to the north. At that point, he began a 270 degree turn to the…Oct 12, 1982 · N9035A · DestroyedNTSB DEN83LA007Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Blanding, UTThe private single-engine pilot had a student helicopter certificate. He took off to hover and check that the helicopter was in good condition. He stated that before takeoff, the helicopter was fueled with a 5 gallon can that had been painted red. Before…Oct 12, 1982 · N5316V · DestroyedNTSB NYC83LA008Accident · No injuriesLimited investigationFinal reportCessna 172P · Grahamsville, NYThe pilot and two passengers departed on a local sightseeing flight with full fuel tanks. About one hour after takeoff, the pilot flew over the passengers' house to take pictures. While a passenger was photographing the house, the pilot's attention was…Oct 10, 1982 · N54177 · Substantial damageNTSB CHI83LA011Accident · Minor injuriesLimited investigationFinal reportRand KR2 · Fairview, ILThe pilot overflew his destination and attempted to locate the airport. The pilot realized his fuel supply was low and decided to land in an open field. The aircraft's left wing struck the ground during the landing and the aircraftcartwheeled.Oct 6, 1982 · N2263N · DestroyedNTSB NYC83LA003Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Ipswich, MAThe pilot descended over water at night and elected to fly over a beach area at 100 to 200 ft AGL. He reported that he lowered the nose briefly to see better. At about that time, the aircraft collided with a sand bank.Oct 5, 1982 · N9923L · Substantial damageNTSB LAX83FJA01Accident · 3 fatalFinal reportBeech C-45G · Waimanalo, HIThe purpose of the flt was to be a reindoctrination/training flt for the second-in-command. Witnesses observed the acft off shore flying parallel to the cliffs approximately 500 ft over the water. The acft banked left then right to a 90 deg right wing low…Oct 4, 1982 · N215H · DestroyedNTSB LAX83FA003Accident · 5 fatalField investigationFinal reportBeech 95-55 · Flagstaff, AZTwo witnesses reported that between 0130 & 0200 they observed an acft performing dives, loops, inverted flight & buzzinga lake. They stopped their vehicle & continued to observe the acft. The acft then departed but returned shortly thereafter. The lake is…Oct 3, 1982 · N72RT · Destroyed