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 MKC86FA098Accident · 1 fatalField investigationFinal reportCessna 150 · Harrisburg, NEThe acft impacted in a 40 degree nose down attitude following a stall-spin. No mechanical descrepancies were noted with the acft and no pre-existing physical incapacitating history of the PIC was discovered. On two separate occasions prior to this flt, the…Apr 30, 1986 · N10768 · Substantial damageNTSB CHI86FEX07Accident · Minor injuriesFinal reportAir Tractor AT301 · Bruceville, INThe acft collided with trees during a pull-up at the end of a swath run. During the collision the rt wing tip separated from the acft and the acft rolled hitting the ground with the rt wing first which started a cartwheel. Investigation revealed that the acft…Apr 29, 1986 · N3660Y · DestroyedNTSB NYC86FA114Accident · 1 fatalField investigationFinal reportGlaser-Dirks DIRK-DG-400 · Julian, PAThe plt of N686U reported he was established in weak thermal at an alt of aprx 2500 AGL when two other gliders were seen. One at aprx the same alt and one below his alt. He continued to state that the glider which was at his alt passed very close to but…Apr 28, 1986 · N40MS · 2 aircraft · DestroyedNTSB ANC86LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Chugiak, AKWhile flying in the mountains at about 5000 feet MSL (200 feet AGL), the airplane encountered a downdraft, causing it to crash on a glacier. Pilot estimated the winds to be about 10 knots.Apr 28, 1986 · N3438A · Substantial damageNTSB LAX86LA195Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Kearny, AZThe plt stated that he was on a sightseeing flt and was flying westbound at about 100 ft AGL along the gila river, when the acft struck powerlines. The acft then descended into the river bed. He futher stated that he observed the powerlines at the last minute…Apr 27, 1986 · N12962 · DestroyedNTSB ATL86LA119Accident · No injuriesLimited investigationFinal reportPiper PA-25-150 · Braselton, GAThe pilot reported that the engine RPM decreased while conducting a banner tow flight and that the engine subsequently quit. The airplane was landed in a field of an auto race track where a telephone pole was struck during the landing roll. Temperature was 92…Apr 27, 1986 · N6242Z · Substantial damageNTSB DEN86LA119Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Santa Fe, NMAccording to the student plt, he was attempting to hover the helicopter when he encountered turbulence. The student plt stated that the hard landing which followed resulted in spreading the skids & severing the tailboom.Apr 25, 1986 · N4073G · Substantial damageNTSB CHI86FA129Accident · Minor injuriesField investigationFinal reportBell 222B · Chicago, ILThe aircraft had just discharged two passengers on the rooftop helipad and was preparing for departure. The aircraft was picked up to a hover and the tailrotor struck a heliport surface perimeter light. The tailrotor separated from the aircraft and the…Apr 25, 1986 · N660DD · Substantial damageNTSB ANC86LA047Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Yentna River, AKThe pilot stated that the aircraft began to settle; airspeed was 60 mph. The aircraft would not recover altitude with full power. The aircraft stalled and struck tree tops.Apr 24, 1986 · N170CH · Substantial damageNTSB LAX86LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269 · Kahului, HIA Hughes 269 went out of control after turning left into a 20 kt tailwind condition. The plt indicated that the engine failed. The eng was run on a eng test stand and no deficientcies were found. A fuel sample was found to be within specified parameters. Ac…Apr 23, 1986 · N9288F · Substantial damageNTSB NYC86FA112Accident · 1 fatalField investigationFinal reportCessna 310 · Lincoln, RIThe air taxi cargo aircraft was observed maneuvering over the airport in IMC conditions for a VFR approach to land. Witnesses described an abrupt turn to reverse direction of flight followed by a nose dive into the ground. The pilot, age 22, had accummulated…Apr 21, 1986 · N128K · DestroyedNTSB LAX86MA186Accident · No injuriesMajor investigationFinal reportLTV Aerospace Industries A7E · Warner Springs, CAA rolladen-schneider LS-4 glider and an Ltv A7E jet collided over hot Springs mtn, near Warner Springs, CA. The A7E was attempting a rapid pull up and the glider was attempting a nose down, 30 deg right turn when they collided. Both aircraft were operating…Apr 20, 1986 · USN · 2 aircraft · Substantial damageNTSB FTW86FRG18Accident · Serious injuriesFinal reportBaby Bird Q2-200 · Gerogetown, TXThe acft landed short of the rwy after losing partial pwr while maneuvering around the arpt. The plt had radioed that the eng was developing about 2000 RPM. The plt had reported throttle problems on previous flt. Due to impact damage it was not possible to…Apr 20, 1986 · N39943 · DestroyedNTSB NYC86FGM01Accident · No injuriesFinal reportVere Eze Long EZE · Dorrseyville, PAThe homebuilt acft collided with a ditch during a forced lndg short of the rwy after a power loss during a test flt. The plt had noted smoke in the cockpit and a loss of oil pressure. As he returned to the arpt the eng began to run rough and surge before…Apr 19, 1986 · N40FP · Substantial damageNTSB SEA86LA106Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Lapwai, IDThe helicopter rotor mast struck powerlines at an alt of 12 ft AGL during an aerial application flt. The plt reported she inadvertently missed seeing the powerlines when she made her survey of the terrain prior to this flt. The helicopterdescended and…Apr 18, 1986 · N1371X · Substantial damageNTSB ATL86LA115Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Lake City, TNWhile filming for king kong productions, a Cessna 150, flown by the production pilot collided with bowel mountain near Lake City, TN the pilot was flying low over the terrain when the aircraft failed to climb as fast as the pilot anticipated. The aircraft…Apr 18, 1986 · N63636 · DestroyedNTSB MKC86LA091Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Salem, IAThe pilot states that the engine quit without warning as he was spraying a wheatfield. Pilot further states that he had very little time to pick a suitable landing area. He landed in hilly terrain and slid sideways into a crest, tearing out the right main…Apr 17, 1986 · N4949X · Substantial damageNTSB ATL86LA113Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Appalachia, VAN7792E experienced a gradual power loss while en route to greenwood. S.c. via Appalachia, VA. The pilot reported that the engine quit and restarted for a few seconds after he had been flying about twenty minutes. This cycle continued for about two more…Apr 14, 1986 · N7792E · DestroyedNTSB LAX86LA176Accident · No injuriesLimited investigationFinal reportCessna 152 · Snellings, CAThe CFI stated that he pulled the acft up to avoid birds and then lowered the nose to gain airspeed from 70 KTS back to cruise speed. During the dive the acft collided with a power line that crossed a river at about 50 ft AGL. After the collision the acft was…Apr 13, 1986 · N5150B · Substantial damageNTSB DEN86LA116Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Wall, SDAccording to the plt he was making a precautionary landing due to wx, when the acft he was piloting encountered an unexpected crosswind just prior to touchdown. The plt said the left wing dipped & made contact with the ground. The impact resulted in…Apr 13, 1986 · N4479W · Substantial damageNTSB MKC86LA086Accident · No injuriesLimited investigationFinal reportGrumman G164B · Advance, MOThe airplane was being operated as an agricultural aircraft when the engine started backfiring and then quit. During the forced landing in a plowed field, the airplane flipped forward to the inverted position. Investigation revealed the teeth on the left…Apr 12, 1986 · N6609Q · Substantial damageNTSB LAX86LA175Accident · No injuriesLimited investigationFinal reportRobinson R22 · Grand Canyon, AZThe pilot stated that he was attempting to land on a dirt road and that the helicopter was at a two to five foot hover when a gust of wind pivoted the tail into the wind. The helicopter touched down and rolled over onto its right side. The pilot further…Apr 12, 1986 · N211DM · Substantial damageNTSB FTW86FA063Accident · 1 fatalField investigationFinal reportCessna 177RG · Dallas, TXThe pilot was advised by the FAA weather briefer, prior to flight, against making this flight due to present and forecast weather conditions. After arriving in the general area of his destination the plt observed the weather conditions and commented on thier…Apr 12, 1986 · N8047G · DestroyedNTSB MKC86FA083Accident · 1 fatalField investigationFinal reportGlasair 2 · Cheney, KSThe acft approached Cheney lake, west of wichita, Kansas at low altitude from the southeast. Several witnesses fishing from the bank saw the acft pass near the Cheney lake marina heading toward the lake. The acft then entered a spin and crashed into the lake…Apr 8, 1986 · N161JD · DestroyedNTSB MIA86LA117Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Miami, FLThe student plt was on a supervised solo flt & was hovering. The helicopter was seen to wobble, roll to the right & crash to the ground. The owner of the helicopter stated that he had flown the acft just prior to the accident & the acft performed normally.…Apr 8, 1986 · N428FH · Substantial damageNTSB MIA86FA115Accident · 1 fatalField investigationFinal reportPitts Special · Homestead, FLThe plt was on a flt to practice aerobatic mnvrs in a designated practice area. A witness, who was driving nearby, stated that he saw the acft 'falling straight down' & crash in a tomato field. An investigation revealed evidence that the acft had impacted in…Apr 7, 1986 · N501L · DestroyedNTSB NYC86LA099Accident · No injuriesLimited investigationFinal reportSikorsky S-76 · Safe Harbor, PAThe helicopter was maneuvering at low altitude, low airspeed, while on a search and rescue mission at night, looking for a capsized boat, when it impacted the water.Apr 5, 1986 · N221SC · Substantial damageNTSB FTW86FA059Accident · 1 fatalField investigationFinal reportBeech 65 · Montague, TXThe pilot was observed in the area for several minutes while he was performing steep climbs and descents, low passes, and buzzing. Witnesses reported power was removed from both engines simultaneously, as if the throttles were retarded, followed by a loud…Apr 5, 1986 · N810Q · DestroyedNTSB ATL86LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Moultrie, GAA deputy sheriff rented an acft to assist the sheriff's dept with a ground search for an escaped prisoner. Witnesses observed the acft flying low and slow over the area when it made a partial turn and pitch down into the trees. There were no indications of…Apr 5, 1986 · N48885 · DestroyedNTSB ANC86LA042Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Anchorage, AKThe student helicopter pilot stated that the helicopter nosed over and rolled to the right during the hover. The pilot encountered a roll to the right due to low rotor RPM.Apr 3, 1986 · N8455P · Substantial damageNTSB LAX86FJA01Accident · No injuriesFinal reportSchweizer 2-32 · Dillingham Fld, HIThe glider collided with a power line as the plt maneuvered down a valley to recover some airspeed that had been lost along a ridgeline. The vertical fin and rudder were damaged along the top 18 inches but the acft was landed without further incident.Apr 2, 1986 · N1189S · Substantial damageNTSB CHI86FEC01Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Leslie, MIThe acft was damaged during a forced lndg following a loss of power after a low pass over an off arpt intended landing area. The plt was overflying a field belonging to a friend in preparation for a possible landing when a loud clunk was heard from the eng…Apr 1, 1986 · N94903 · Substantial damageNTSB MKC86FA077Accident · 1 fatalField investigationFinal reportDonald R. Casper Skyote · St. Louis, MOThe pilot built the homebuilt airplane from data obtained from skyote aeromarine ltd. at the time of the accident, the airplane had 51 hours on it and the pilot/builder had flown all of the 51 hours. On this flight he was observed to depart on runway 16, fly…Mar 31, 1986 · N106DC · DestroyedNTSB FTW86FRD11Accident · No injuriesFinal reportGrumman G-164A · Crowley, LAThe acft crashed into wires and a house during an attempted forced landing. The plt was preparing to do rice seeding when the eng began to backfire & lose power. The plt was trying to return to the ag strip when the eng quit and he was forced to land. Eng…Mar 31, 1986 · N4561 · Substantial damageNTSB DEN86LA108Accident · Minor injuriesLimited investigationFinal reportLuscombe T-8F · Watkins, COWhile practicing ground reference maneuvers at 500 ft AGL a total loss of engine power was experienced. The pilot rated passenger in the rear seat performed the emergency landing while the PIC attempted to restart the engine. The landing was made on open…Mar 31, 1986 · N1593B · DestroyedNTSB CHI86FEP02Accident · Serious injuriesFinal reportPiper PA-38-112 · Dexterville, WIOn the fourth flight of the day carrying relatives in the vicinity of another relatives house the pilot admitted that he allowed the airspeed to decay during a 55 degree bank and did not recognize an impending stall. When the aircraft stalled there was…Mar 31, 1986 · N23854 · Substantial damageNTSB FTW86FA051Accident · 4 fatalField investigationFinal reportCessna 172N · Del Rio, TXThe pilot was doing aerobatic maneuvers in the Cessna 172 airplane with three passengers and a heavy load of fuel aboard. The maneuvers consisted of buzzing boats on the lake at very low altitude, at least one complete aileron roll, several very abrupt…Mar 30, 1986 · N8423E · DestroyedNTSB ATL86FA102Accident · 2 fatalField investigationFinal reportNorth American NA219 (T28B) · Luthersville, GAAfter takeoff the acft was observed to climb straight out toan alt of about 500-700 ft. it then turned to a northerly heading. After a short time on the northerly hdg, the acft was observed to initiated a left aileron or barrel roll, dishout and end up on an…Mar 30, 1986 · N544E · DestroyedNTSB LAX86LA158Accident · 1 fatalLimited investigationFinal reportCessna 150L · Kailua Kona, HIGround witnesses observed the acft spiral into the pacific ocean. Neither the plt nor the acft have been recovered.Mar 29, 1986 · N7384G · DestroyedNTSB CHI86FER03Accident · Minor injuriesFinal reportHughes 269A (TH-55A) · Lakeville, MNThe CFI reported the accident occurred during a demonstration of wind effect during turns around a point. The CFI reported that as the helicopter was turned downwind it began descending from an alt of aprx 200 ft AGL. It continued it's descent until the right…Mar 29, 1986 · N10415 · DestroyedNTSB CHI86FEX05Accident · 1 fatalFinal reportChristen Industries Eagle II · Aurora, INThe aircraft impacted the ground when an unsuccessful aerobatic loop maneuver was attempted on takeoff. The pilot of the aircraft was issued a statement of acrobatic compentency which allowed all maneuvers within the limitations of the aircraft and with a…Mar 26, 1986 · N39RH · DestroyedNTSB FTW86FA046Accident · 1 fatalField investigationFinal reportCessna 120 · Whitefield, OKThe pilot was flying at very low altitude while circling the area and most probably did not see the powerline, due to sunglare, until at very close range. He then pulled up steeply in the strong and gusty headwind and stalled the aircraft without sufficient…Mar 22, 1986 · N77483 · DestroyedNTSB ATL86FA097Accident · 2 fatalField investigationFinal reportRobinson R-22 · Memphis, TNA loss of control in flight for undetermined reasons.Mar 22, 1986 · N9069S · DestroyedNTSB LAX86FVG02Accident · No injuriesFinal reportSikorsky S-55 · Afton, CAThe acft was landed off the arpt in a forced landing after a pwr loss. The acft was damaged in the hard landing. Eng teardown showed the r/h magneto model S7LV-2 had stripped distributor drive gears. No other abnormalities noted. The TSO of the mag was…Mar 21, 1986 · N8327 · Substantial damageNTSB MIA86FA100Accident · 3 fatalField investigationFinal reportBeech D-35 · Crystal Springs, FLWitnesses stated they observed the acft performing aerobatics while at an estimated alt of 1000 to 1300 ft. after the completion of a loop, the acft was observed to nearly come to a stop while vertical, then fall off to the left & enter a spin which continued…Mar 18, 1986 · N5968C · DestroyedNTSB DEN86FA099Accident · Serious injuriesField investigationFinal reportCessna 401 · Silver City, NMThe 2 com rated plts were returning from a part 135 flt at night. The fuel tanks were inadvertently not switched from mains to aux. Fuel starvation occurred when acft was at low altitude. Insufficient altitude remained to restart the engines. Acft impacted…Mar 14, 1986 · N9867F · Substantial damageNTSB CHI86FER01Accident · Serious injuriesFinal reportCessna 172H · Williams, MNThe plt made a low pass over a frozen, snow covered lake, then intended to make a climbing left turn. He rprtd the wx & light conds as 'slight haze, poor horizon visibility, very white out.' As the plt contd with what he thought was a climbing turn, the acft…Mar 13, 1986 · N3706R · Substantial damageNTSB LAX86LA138Accident · No injuriesLimited investigationFinal reportCessna 172M · Guinda, CAThe plt & his roommate went flying in a rented acft. The plt maneuvered the acft through a valley, reversed course, descended over an assembly of persons & while buzzing them collided with trees. The plt was able to fly the substantially damaged acft back to…Mar 9, 1986 · N6740H · Substantial damageNTSB DEN86LA096Accident · No injuriesLimited investigationFinal reportCessna R172K · Ft. Bridger, WYAccording to the plt, he and his passenger were ferrying an acft back to the point of origin after a sar mission for the civil air patrol, when they encountered IMC weather. The plt stated he was making a precautionary landing on a dirt road when the acft…Mar 9, 1986 · N736GS · Substantial damageNTSB MKC86FCA02Accident · Serious injuriesFinal reportCessna A152 · Old Monroe, MOThe stu PIC and his instructor were practicing forced lndgs to a corn stubblefield. As they initiated a climb fm a simulated forced lndg, the acft crashed nose low, right wing low. No mech pblm was found with the flt controls or the pwrplant.Mar 8, 1986 · N8143L · Destroyed