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 SEA85FA067Accident · 1 fatalField investigationFinal reportCessna 175 · Bancroft, IDThe acft impacted level terrain aprx 500 yards east of the Bancroft arpt. N9386B was one of a flt of two acft returning to Bancroft from preston, ID. The wx had deteriorated during the flt with snow showers and blowing snow. While the other acft was landing…Mar 2, 1985 · N9386B · DestroyedNTSB LAX85LA162Accident · No injuriesLimited investigationFinal reportSevdy Pitts Special 104 · Yuma, AZWhile practicing aerobatics for an airshow, the plt entered a spin. During the spin maneuver, the eng sputtered, lost power & the prop stopped turning. The acft was not equipped with an electric starter, so the plt tried to windmill the prop by diving, but…Mar 2, 1985 · N913S · Substantial damageNTSB FTW85LA135Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Big Spring, TXCFI was demonstrating a simulated eng failure with tailwind of 10 KTS, 20 KTS grnd speed. The acft yawed left and touchdown was made with 10 kt grnd speed. The right skid broke off and the acft rolled over. The maneuver was initiated at 4 ft skid height.Mar 2, 1985 · N26EW · Substantial damageNTSB ANC85LA049Accident · No injuriesLimited investigationFinal reportCessna 207 · Dillingham, AKThe plt was attempting a 180 deg turn to reverse direction away from lowering clouds and snow showers when the right wing dug into the snow covered terrain. The plt stated a virtual 'white out' condition existed at the time.Mar 2, 1985 · N1715U · DestroyedNTSB DEN85FA088Accident · 2 fatalField investigationFinal reportBellanca 7GCAA · Cornville, AZThe acft was on a local flt with the owner/private plt & a student plt on board. While in aerobatic flt over a narrow canyon/gully area, the acft collided with & severed 3 power lines & a static line, located aprx 100 ft above the ground. The acft then…Feb 28, 1985 · N6328N · DestroyedNTSB FTW85LA129Accident · No injuriesLimited investigationFinal reportRotorway Exec · Bethany, OKThe owner/builder had a single engine, multi-engine, land rating, but did not have a helicopter rating. While practicing hover flt in his experimental helicopter, he unexpectedly allowed the helicopter to reach a higher than normal alt. He attempted to…Feb 27, 1985 · N3071 · Substantial damageNTSB LAX85FA156Accident · 3 fatalField investigationFinal reportCessna 152 · Newport Beach, CAThe student plt took off on a dark night in marginal wx conditions with 2 passengers occupying the only passenger seat. About 17 min later, the acft was observed in a low pass over a pier at Newport Beach, CA, flying toward the open ocean. After crossing over…Feb 26, 1985 · N714WJ · DestroyedNTSB CHI85LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Frankton, INDuring a setup for a practice stall the solo student pilot retarded the throttle, raised the nose slightly and applied carb heat. He believed he was losing airspeed too quickly so he then reapplied full power. At this point the engine rpms dropped to 5 or…Feb 26, 1985 · N5394M · Substantial damageNTSB LAX85LA155Accident · Serious injuriesLimited investigationFinal reportRobinson R-22A · Santa Barbara, CAStudent plt stated that while flying the last leg of a solo cross country flight he was flying along the coast at 50 to 75 feet, he diverted his attention to look at the a man on the beach and when he looked back at the instruments he noticed the helicopter…Feb 25, 1985 · N85550 · DestroyedNTSB CHI85FA121Accident · 4 fatalField investigationFinal reportMooney M20K · Coldwater, OHThe flight departed without a pre-flight inspection, engine run up, or radio call on UNICOM. The aircraft was observed doing low altitude aerobatic maneuvers. Witnesses observed the aircraft nose over and impact the ground in a near vertica attitude from…Feb 23, 1985 · N231GX · DestroyedNTSB DEN85FA084Accident · 2 fatalField investigationFinal reportTaylorcraft BC-65 · Chinook, MTThe airplane was observed to enter a shallow right climbing turn at about 200 feet AGL after making a low pass over friends. Witnesses said the airplane then stalled and dove to the ground. There was no evidence of airframe, eng, prop, flt control, or syst…Feb 22, 1985 · N26580 · DestroyedNTSB SEA85LA060Accident · Minor injuriesLimited investigationFinal reportBell 214B1 · Lowell, ORThe acft collided with hilly terrain during an emergency autorotation landing attempt following a reported eng overspeed. The crew reported there was an indication of eng overspeed which they could not control. Post acc examinationrevealed no evidence of…Feb 19, 1985 · N314RM · Substantial damageNTSB CHI85LA110Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Huntingburg, INThe acft experienced a partial power loss and made a hard autorotative lndg during a training flt. Investigation of the eng revealed mistiming of the left mag. The eng during tests also ran hot until the addition of a cooling shroud. The other significant…Feb 18, 1985 · N511R · Substantial damageNTSB LAX85LA144Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Healdsburg, CAWhile on a local flt, the acft collided with trees in a canyon. The plt reported the acft's alt was lower than anticipated & the terrain in the canyon rose rapidly. Full eng power was not sufficient to negotiate the rising terrain. The plt reported the acft's…Feb 17, 1985 · N739XZ · DestroyedNTSB LAX85FJA04Accident · Minor injuriesFinal reportCessna 152 · Laupahoehoe, HIThe acft collided with rising terrain while on a training alt. The student plt was scheduled to proceed to the practice area near puna for this first extended solo flt. At aprx 1200 HST, he returned to general lyman flt, hilo, ha, for touch-&-go landing…Feb 14, 1985 · N89246 · DestroyedNTSB NYC85FGT01Accident · Serious injuriesFinal reportCessna 335 · Barrville, PAThe Cessna 335 was making a contact approach when it flew into the ground. The aircraft received substantial damage and the pilot received serious injuries. Winds in the area were reported at 25 knots with gusts to 35 knots. Visual meteorological conditions…Feb 12, 1985 · N6821C · DestroyedNTSB DEN85LA076Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Thompson Falls, MTThe acft nosed over during a forced lndg on terrain covered by 20 inches of snow. The flt was on deer survey flt the plt told of improper use of the carb heat control during a period of'perfect' icing conditions. The plts reduction of power during maneuvering…Feb 11, 1985 · N3777P · Substantial damageNTSB CHI85FA104Accident · 2 fatalField investigationFinal reportMooney M20C · Portsmouth, OHThe acft was maneuvering at about 500 ft AGL when witnesses reported what they believed to be an eng malfunction. The acft then entered a spin and impacted in an open fld out of control. A conclusive cause of an eng malfunction could not be determined during…Feb 10, 1985 · N2961L · DestroyedNTSB ATL85FA090Accident · Serious injuriesField investigationFinal reportCessna 152 · Acworth, GAThe acft contacted power lines and descended uncontrolled to the terrain during the recovery phase of a simulated forced landing. The simulated forced landing was initiated by the CFI at an alt of aprx 800 ft AGL over the median strip of hwy 75. The student…Feb 9, 1985 · N5317Q · Substantial damageNTSB FTW85LA115Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Mccoy, TXThe plt stated that he had departed the gala ranch strip & was flying at aprx 100 ft AGL to show his passengers their ranch property. While in slow flight with the flaps deployed, the plt entered a downwind skidding left turn. The acft subsequently stalled &…Feb 8, 1985 · N79043 · Substantial damageNTSB SEA85LA053Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe acft had lifted off during an external load operation when the plt felt a 'vibration/shudder'. The right skid contacted the ground and the helicopter rolled over during an attempt to maneuver the helicopter away from ground personnel. Inspection revealed…Feb 4, 1985 · N8306F · DestroyedNTSB LAX85FA132Accident · Minor injuriesField investigationFinal reportHiller UH12E · Five Points, CAWhile performing an ag flight the helicopter's engin suddenly lost power. At the time the aircraft was near its max allowable gross weight and it was between 3-5FT AGL. As the aircraft yawed left and descended. The pilot in command attempted to land on a…Feb 3, 1985 · N5323V · Substantial damageNTSB NYC85LA058Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Silver Lake, METhe acft stalled and contacted the ground while maneuvering during the initial takeoff climb. The plt reported that the acft became airborne following a short takeoff ground run and upon reaching tree top level, the plt reported, 'we just mushed along.' The…Jan 30, 1985 · N1907B · Substantial damageNTSB LAX85FJA01Accident · No injuriesFinal reportEmair MA-1 · Paanilo, HIThe plt initiated his 1st spray pass uphill with about a 5 to 10 kt quartering tail wind. While on the swath run, he noted the airspeed was decaying, so he aborted the pass by turning into the wind. However, this resulted in flying over more rapidly rising…Jan 30, 1985 · N9924M · Substantial damageNTSB FTW85FA104Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Victoria, TXThe plt had rented the acft on January 28, 1985, with route of flt unknown. No reported contact was made with the acft. The acft impacted the surface during hours of darkness in instrument meteorological conditions and was demolished. The plt was fatally…Jan 30, 1985 · N8204A · DestroyedNTSB SEA85FA051Accident · 3 fatalField investigationFinal reportBeech BE-35 · Verdi, NVPilot impacted rising terrain while descending into & thru IFR weather conditions during VFR flight. Lost visual contact w/ground and broke out in mountains.Jan 26, 1985 · N1560S · DestroyedNTSB MKC85FA051Accident · 2 fatalField investigationFinal reportCessna 152 · Ashdown, ARAcft made two passes over residence to alert friend to go to nearby ag strip to pick up plt & pax. Acft was then seen flying in area at low alt & slow speed by the friend as she proceeded to the strip. She looked away from the acft momentarily & when she…Jan 26, 1985 · N89782 · DestroyedNTSB DEN85FA069Accident · 2 fatalField investigationFinal reportCessna 150F · Marvel, COA witness reported seeing the acft enter a dive and level off aprx 10-15 ft AGL. The acft continued flt close to the ground for aprx 1/2 mile, the witness stated, before a near vertical climb was entered until the acft stalled. Recovery from the stall was not…Jan 26, 1985 · N6787F · Substantial damageNTSB ANC85FA040Accident · 1 fatalField investigationFinal reportPiper PA-12 · Wasilla, AKWitnesses observed the plt 'buzzing' a building & rolling the acft about its longitudinal axis. After the 3rd pass, it entered a steep bank, stalled & pitched down into a wooded area. There was evidence that the acft was at least 73 lbs over its max weight…Jan 25, 1985 · N2399M · DestroyedNTSB ATL85FA081Accident · 2 fatalField investigationFinal reportCessna 182H · Letohatchee, ALAcft was observed at low alt descending on a northerly hdg. About 1.5 mi. 5 of the crash site. Engine sounds were characterized as smooth and normal. Acft struck a 44000 volt x-mission line parting a 5/16IN. Diameter hi-strength steel ground cable and a 1/0…Jan 24, 1985 · N2431X · DestroyedNTSB SEA85LA046Accident · No injuriesLimited investigationFinal reportHiller UH12DJ3 · Forks, WAThe acft made a hard landing and rolled to the left inverted after the engine quit due to fuel exhaustion. The plt stated that the fuel guage was not working and that he was using a dip stick to measure fuel at the time of the engine failure. He stated that…Jan 22, 1985 · N87977 · Substantial damageNTSB MIA85LA084Accident · No injuriesLimited investigationFinal reportCessna 340A · Orlando, FLThe acft collided with power lines while operating at low alt over an unpopulated area. The plt indicated that he descended to a 'low alt' & pulled up to aviod some trees. After the pull-up, he said that he noticed some damage & continued his flt to ft.…Jan 21, 1985 · N6829L · Substantial damageNTSB LAX85FA115Accident · 1 fatalField investigationFinal reportBell 205A-1 · Newhall, CAThis helicopter collided with hilly terrain while circling at a low altitude. It was following another helicopter in a clockwise circular pattern at the time, and being filmed for the t.v. series 'air wolf'. One witness observed the helicopter decending in…Jan 18, 1985 · N830V · DestroyedNTSB SEA85LA042Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Troutdale, ORShortly after takeoff plt felt a 'tick' in the engine. Plt reduced pwr and headed back to Troutdale. Engine quit over the threshold of rwy 07 as plt was making a 360 deg turn. Acft touched down short of rwy 07 contacting small bushes and trees. Inspection…Jan 16, 1985 · N6475B · Substantial damageNTSB NYC85LA054Accident · No injuriesLimited investigationFinal reportCessna 152II · Franklin, PAThe acft experienced a nose gear collapse during a landing in deep snow at Franklin center arpt after a partial loss or pwr. The CFI and student were practicing apch to landing stall recovery when the eng failed to produce full pwr. There was unsufficient pwr…Jan 16, 1985 · N5497P · Substantial damageNTSB ANC85FA095Accident · 1 fatalField investigationFinal reportCessna 207 · Port Alsworth, AKThe pilot continued the air taxi flight into adverse weather conditions and struck a mountain.Jan 16, 1985 · N1618U · Substantial damageNTSB DEN85LA064Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Wapiti, WYAccording to the pilot as she was flying her aircraft in a canyon she encountered downdrafts which pushed her aircraft down. She was unable to maintain her airspeed or altitude and elected to put the aircraft into the trees.Jan 14, 1985 · N759WB · DestroyedNTSB LAX85LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Beaumont, CAThe acft was on a personal VFR flt to santa barbara, CA, on a dark ovcst night. Marginal VFR conditions with lgt rain prevailed. Gnd witnesses rptd the acft was following the hwy at about 200 ft AGL prior to the accident. The plt rptd he inadvertently began…Jan 9, 1985 · N29493 · Substantial damageNTSB ANC85LA035Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Glennallen, AKShortly after liftoff plt experienced downdrafts and variable wind gusts. Plt decided to set the helicopter back down aprx 100 yds from point of takeoff. Plt stated hovering was very difficult and the helicopter settled to the upsloping terrain. The…Jan 9, 1985 · N5056F · DestroyedNTSB FTW85FA094Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Ferriday, LAAcft was observed in slow flt aprx 40 ft AGL just above stall speed with the eng operating smoothly. The acft then stalled and impacted in an aprx 90 deg nose down attitude. The plt was flying from the front seat. The acft was not equipped with shoulder…Jan 8, 1985 · N1474N · Substantial damageNTSB LAX85LA099Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Chandler, AZThe PIC reported the 2nd plt was flying the acft at the time of the accident while they were practicing off arpt landings. On the second takeoff, the 2nd plt executed a course reversal turn to land opposite the direction of takeoff. The initial turn was to…Jan 7, 1985 · N84096 · Substantial damageNTSB ANC85LA033Accident · Serious injuriesLimited investigationFinal reportMaule M6-235 · Trading Bay, AKThe plt-in-command, IA an attempt to avoid a mid-air collision, did not control his airplane sufficiently to avoid a stall. Once in the stall the plt-in-command did not properly recover & the airplane mushed into the ground.Jan 5, 1985 · N5652D · Substantial damageNTSB DEN85LA057Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Salt Lake City, UTThe helicopter collided uncontrolled with the terrain during external load operation. A 100 ft steel cable was attached to the cargo hook on the helicopter and a nylon sling was attached to the cable so a snowcat could be pulled out of a mud area. The plt…Jan 3, 1985 · N1356A · DestroyedNTSB MKC85FA042Accident · 1 fatalField investigationFinal reportCessna 150F · Pawnee City, NEPlt and passenger departed to fly over a group of friends who were on a coyote hunt. Witness stated the acft approached from the NE aprx 300 ft AGL. Acft then made a left crcling turn and was described as flying very slow. After completing aprx 360 degrees of…Jan 2, 1985 · N7138F · Substantial damageNTSB MIA85FA071Accident · Serious injuriesField investigationFinal reportFuji LM-1 "NIKKO" · Odessa, FLThe acft collided with the ground in an acft parking area on the arpt after a low alt loop which was not completed prior to ground contact. The plt had made one low pass down the rwy in formation with another Fuji acft, a 2nd pass ended in an aileron roll,…Jan 1, 1985 · N2104X · Substantial damageNTSB ATL85FA072Accident · 1 fatalField investigationFinal reportCessna 182A · Dublin, VAAfter dropping the parachutist, the acft was observed to fly eastward over the dz, make a left 180 turn, line up on the parked van on an easterly heading and descend to a low altiude. Witnesses estimated the altitude at from 10 T0 30 ft AGL. The van was…Dec 30, 1984 · N4963D · DestroyedNTSB LAX85FA088Accident · 4 fatalField investigationFinal reportCessna 182Q · Upland, CAThe instrument rated plt & 3 pax departed palo alto for an intended 3-hour long day VFR flt to santa ana, CA. The final destination was to be mx. The plt had not flown at night or on instruments in over 6 yrs. He elected to delay departing pao until 1611 PST…Dec 28, 1984 · N735MJ · DestroyedNTSB FTW85FA087Accident · 3 fatalField investigationFinal reportCessna T210N · Brackettville, TXThe plt had filed an instrument flt plan from how to dht and had received a wx briefing for the route. The flt proceededto dht where radar contact was lost and the acft was cleared for an apch. The plt canceled IFR. The plt then proceeded to Brackettville,…Dec 26, 1984 · N6578Y · DestroyedNTSB FTW85FA086Accident · 1 fatalField investigationFinal reportCessna 441 · Marble Falls, TXThe acft crashed aprx 1.5 miles south of the departure end of rwy 17 during an attempted rwy 17 NDB apch. The acft was cleared for the apch at 2012 CST and the plt canceled IFR reporting the arpt in sight at 2014. A witness located aprx 1 mile south of the…Dec 26, 1984 · N441CM · DestroyedNTSB SEA85FA036Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Imlay, NVPlt was reportedly engaged in aerial coyote hunting, witnesses observed acft of this description flying low and slow in vicinity but there were no eyewitnesses to the crash. Investigation revealed acft impacted ground upright with high vertical descent rate.…Dec 25, 1984 · N9659P · Destroyed