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 DEN85LA154Accident · Minor injuriesLimited investigationFinal reportCallair A-9 · Riverton, WYDuring an aerial application turn-around maneuver, the eng lost power. The plt stated that he immediately changed the fuel selector & turned on the boost pump, but the acft was too low for the eng to have time to restore power. The eng had been using fuel…Jun 7, 1985 · N8280H · Substantial damageNTSB SEA85LA128Accident · Serious injuriesLimited investigationFinal reportde Havilland DH 82A Tiger Moth · Orland, CAThe plt reported that during a loop, the eng lost power, then the acft entered an inverted spin. He said that he had gotten out of the inverted spin & was recovering from a regular spin when the acft struck the ground. According to a witness, the plt entered…Jun 5, 1985 · N99108 · DestroyedNTSB FTW85FA245Accident · 1 fatalField investigationFinal reportCessna 140 · Tioga, TXWitnesses observed the acft apchg from the northwest at an estimated alt of about 100 ft AGL. As it passed their position, the plt rolled into a steep (90 deg) right bank, then roll back out. The witnesses reported that after the acft rolled out of the bank,…Jun 4, 1985 · N3180N · DestroyedNTSB SEA85LA193Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Orovada, NVAfter completing his last spray run, the plt began a turn. During the turn, the eng lost power, then restarted & lost power again. Attempts to restart the eng were to no avail. Since the acft was still at a very low alt (aprx 50 ft), an emerg landing was…Jun 3, 1985 · N8804F · Substantial damageNTSB NYC85FHM01Accident · No injuriesFinal reportSchweizer SGS-1-35 · Middletown, NYThe acft landed off the arpt after the plt lost alt in a spin. The plt was afraid that the glider would land short in trees so he landed on a highway. The hard lndg damaged the acft.Jun 2, 1985 · N9JK · Substantial damageNTSB DEN85LA147Accident · Minor injuriesLimited investigationFinal reportIntermountain Mfg. Callair A-9 · Michigan, NDThe plt elected to fly the newly purchased acft around the airstrip to test the spray sys. Shortly after taking off, the eng stopped running while the acft was over a slough. The plt was unable to glide the acft to suitable terrain, & subsequently, the acft…Jun 2, 1985 · N3569G · Substantial damageNTSB MKC85FA120Accident · 2 fatalField investigationFinal reportCessna 152 · Albert, KSWhile maneuvering to reverse directions the acft stalled descending and impacting the ground in a steep dive. The plt was on the final leg of his cross-country flt.Jun 1, 1985 · N6426B · DestroyedNTSB MKC85LA115Accident · No injuriesLimited investigationFinal reportHughes 269C · West Liberty, IAOn a downwind swath run the helicopter experienced an eng failure and the plt entered an autorotation. The plt then made a hard landing which resulted in substantial damage. Inspection of the engine revealed that the nut which retains the gear to crankshaft…May 29, 1985 · N8976F · Substantial damageNTSB MKC85FA114Accident · Serious injuriesField investigationFinal reportBell OH-13E · Jonesboro, ARThe plt reported that the eng quit due to fuel exhaustion. He attempted to land straight ahead on soft terrain, but the helicopter rolled over. During the accident sequence, the main rotor blades struck the tail boom & scattered parts ahead of & to the rgt of…May 29, 1985 · N29WL · Substantial damageNTSB LAX85FA262Accident · 2 fatalField investigationFinal reportCessna TU-206E · San Manuel, AZThis plt was attempting to air drop illegal drugs to someone on the ground. While executing an intentional low pass, at dusk, theacft inadvertently collided with a cactus tree & crashed.May 29, 1985 · N1475M · DestroyedNTSB DEN85LA144Accident · Minor injuriesLimited investigationFinal reportContinental Copters Tomcat Mark 5A/OH13H · Freeman, SDThe plt said he had completed 4 to 5 swath runs (crop spraying mission). During a turning manuever with a left quatering tail wind, full left pedal,full pwr,the helicopter had a high sink rate until grd impact.May 29, 1985 · N9081T · Substantial damageNTSB LAX85FA259Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Moorpark, CAAcft crashed while being maneuvered in a canyon. Post crash inspection of the propeller revealed no evidence of rotation at impact. One-half gal of automotive fuel was found in the left wing tank and no fuel was found in the right wing tank. Some fuel lines…May 27, 1985 · N80970 · DestroyedNTSB CHI85FA211Accident · 1 fatalField investigationFinal reportSteens Skybolt · New Baden, ILWitnesses stated the acft made a low pass down the rwy (20 to 30 ft AGL) at an airspeed of aprx 200 mph. The acft then entered a steep climb and at about 100 at AGL, the acft rolled to the right. The acft lost alt during the roll and descended to ground…May 27, 1985 · N64AB · DestroyedNTSB ATL85FA173Accident · 1 fatalField investigationFinal reportCessna R182 · Seneca, SCDuring flt, the plt was observed to make a low pass over lake keowee near a friend's houseboat. The owner of the houseboat stated that the acft was flying low off his right side when the acft struck the water. Another witness also saw the acft flying at…May 27, 1985 · N7161S · DestroyedNTSB SEA85FA124Accident · 3 fatalField investigationFinal reportCessna 177 · Selma, ORThe acft was on a cap search mission with a plt & 2 observers on board. While searching, the plt was flying relatively low & slow over wooded, mountainous terrain. A witness observed the acft enter a bowl or box canyon type area at or below his eye level. The…May 26, 1985 · N2276Y · DestroyedNTSB MIA85LA177Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · St.Petersburg, FLThe pilot was assigned an aircraft with a recently overhauled engine to tow a banner. He preflighted, started and ran-up the engine 3 times. Each time the engine ran rough and lost RPM on magneto checks. After each occurrence, companymaintenance personnel…May 26, 1985 · N1211A · Substantial damageNTSB DEN85FTK01Accident · Serious injuriesFinal reportBoeing A75 · Tea, SDThe owner/plt-in-command (PIC) took off on a local flt with another occupant in the front seat. The front seat occupant was a commercial, single-eng, multi-eng plt with an instructor rating, but he had no previous experience in A75 acft. While in flt, the PIC…May 26, 1985 · N555 · Substantial damageNTSB CHI85FA209Accident · 1 fatalField investigationFinal reportHeekin B-8-M · Williamsburg, OHWitness reported hearing a loud bang and seeing the main rotor blades stopped. The gyrocopter was then observed rotating slowly in a clockwise direction to ground impact. The wooded prop (engine driven) was demolished with portions of it found up to 300 ft…May 25, 1985 · N3250M · DestroyedNTSB ATL85FLT06Accident · 1 fatalFinal reportCessna 150F · Jeffersonville, KYThe acft collided with the ground in a steep nose down attitude while banking to the left. The acft was in the process of making an approach to land in an off arpt pasture which was not normally used for acft operations. No mecanical reasons for the accident…May 25, 1985 · N7717F · Substantial damageNTSB NYC85FGM04Accident · Serious injuriesFinal reportBell 206B · New Baltimore, PAThe acft collided with a power line during aerial application operations. There was no malfunction of equipment prior to the accident. The helicopter descended into trees & was damaged. The plt said that he was looking for a cut off marker in the form of a…May 22, 1985 · N9901K · Substantial damageNTSB CHI85LA204Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Mantua, OHDuring an aerial application flt, the plt banked the helicoper to fly around a utility pole; however, the main rotor blades contacted the pole. The helicopter then descended, landed on its skids & sustained substantial damage. The plt stated that the gusty…May 22, 1985 · N73219 · Substantial damageNTSB NYC85FA131Accident · 3 fatalField investigationFinal reportCessna TR-182 · Grand Island, NYThe flt had been on a local sightseeing tour over the niagara falls. The plt then stated that he was going to give his pax a demonstration of how fast the acft appears to be traveling when it is close to the water. The plt then began a left descending turn…May 21, 1985 · N756ZM · DestroyedNTSB DEN85LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Claire City, SDThe acft collided with power lines during an aerial application flt. The power lines were located in the middle of the field being sprayed and during the last spray run, while flying into the sun, the acft contacted the lines.May 21, 1985 · N2382Y · Substantial damageNTSB SEA85FA120Accident · 3 fatalField investigationFinal reportCessna 205 · Chewelah, WAThe acft was observed flying up a canyon at low altitude while climbing at an angle equivalent to the surrounding terrain slope. Shortly thereafter the acft encountered steeply upsloping terrain and began impacting trees in a left wing high and nose up…May 20, 1985 · N125ZL · DestroyedNTSB MKC85LA107Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Harrisburg, ARPlt reports that the lt wing of N4017N hit a dike in a ricefield while he was making a trim swath. There were no indications of equipment malfunction.May 20, 1985 · N4017W · DestroyedNTSB LAX85LVA03Accident · Minor injuriesFinal reportBell 47-G5 · Lindsay, CAThe acft made a forced landing in a beet field following a noise in the eng or transmission. After he heard a noise the plt auto-rotated and during the hard landing the acft was damaged.May 20, 1985 · N1316X · Substantial damageNTSB SEA85FYM02Accident · Serious injuriesFinal reportRingsdorf-Mcconnell VARI-EZE · Eugene, ORThe acft has a fuselage fuel tank which holds only two gallons as well as two wing fuel tanks. The pilot departed the airport on the fuselage tank and the engine ceased operating before he realized he needed to change the fuel selector. An unsuccessful…May 19, 1985 · N37993 · DestroyedNTSB LAX85FVA02Accident · Serious injuriesFinal reportCessna 172 · Santa Nella, CAWitnesses stated the acft was circling over farm land at a low altand while in a left turn, it descended to ground impact.May 19, 1985 · N5982A · DestroyedNTSB ATL85LA166Accident · No injuriesLimited investigationFinal reportSchweizer SGS-233 · Chester, SCThe instructor pilot cut loose from the tow plane at 200 ft AGL during takeoff to simulate a rope break. The acft collided with trees while circling to land. CFI stated that student plt was too slow in returning to land on the rwy.May 19, 1985 · N5724S · Substantial damageNTSB MKC85LA104Accident · No injuriesLimited investigationFinal reportSchweizer G-164A · Searcy, ARThe plt reports that the eng lost power during a spray pass and each time he advanced the throttle in an effort to regain power the eng backfired. The plt made a forced landing in a nearby field and the acft hit a ditch, nosed over and burned. The eng was…May 18, 1985 · N8710H · DestroyedNTSB FTW85LRA02Accident · Serious injuriesFinal reportAir Tractor AT301 · Anahuac, TXThe acft collided with the ground after the engine reportedly lost power for an undetermined reason. Due to the low altitude while applying fertilizer the acft had to be landed in the path of flt.May 17, 1985 · N1361E · Substantial damageNTSB CHI85FA198Accident · 1 fatalField investigationFinal reportBell 47G-2 · Burlington, MIThe helicopter was departing from a trailer which was sloped 5 degs to the left. During takeoff, the left skid lifted off first and the helicopter drifted to the right. The right skid caught on the trailer guides and the helicopter rolled over to the right.May 16, 1985 · N3755J · Substantial damageNTSB MIA85FA170Accident · 1 fatalField investigationFinal reportSilvaire Luscombe 8A · Astatula, FLThe plt (PIC) & his plt rated friend were practicing what the PIC described as simulated crop dusting. After completing a low pass over a field, the PIC made a steep pull up to turn around. He reported that the acft then stalled & crashed. A witness stated…May 15, 1985 · N71909 · DestroyedNTSB CHI85LA197Accident · No injuriesLimited investigationFinal reportHughes 269 · Stonington, ILAfter completing a swath run, the plt maneuvered the helicopter up over a power line, then made a turn-around for another swath run. He stated that as he started the next run, he 'felt the wind push the tail upward forcing the nose downward...' He applied aft…May 15, 1985 · N7485F · DestroyedNTSB LAX85FA253Accident · 2 fatalField investigationFinal reportCessna 177B · Ojai, CAWitnesses observed the acft enter a box canyon in level flt at an alt below the tops of the surrounding ridges. The eng pwr sounds were reported as 'normal' by the witnesses. Shortly after the acft disappeared behind a ridge, the witnesses saw black smoke…May 13, 1985 · N17239 · DestroyedNTSB FTW85FA220Accident · 2 fatalField investigationFinal reportCessna 182RG · Odessa, TXWhile flying at approx 100' AGL, the acft struck a 5/8' static line on a newly constructed powerline. The cable was not yet anchored, except with pulley's on each tower and had about two miles of slack. The wire engaged the left front eng cowl and 1 prop…May 13, 1985 · N737ZL · DestroyedNTSB ANC85LA109Accident · No injuriesLimited investigationFinal reportCessna 207 · Emmonak, AKThe pilot-in-command stated he was passed by the airplane N9975M and did not see it again until he was at his right rear and slightly below. The propeller of N9975M struck the aileron and during the evasive maneuvering the left main gear of N9975M struck the…May 12, 1985 · N9975M · 2 aircraft · Minor damageNTSB NYC85FA120Accident · 2 fatalField investigationFinal reportCessna 210M · Morrisville, NYShortly after t/o the pilot experienced a rough running engine, continued maneuvering at a low altitude and the engine quit due to undetermined cause. The pilot attempted to stretch the glide to an open field and stalled the aircraft, which mushed into the…May 11, 1985 · N761MC · DestroyedNTSB MIA85LA168Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Stuart, FLThe plt stated that after releasing his banner, he made a steep right bank & the acft stalled & collided with the ground. He reported that the winds were variable. Aprx 30 south, the 1335 wind was from 040 deg at 12 KTS.May 11, 1985 · N41699 · Substantial damageNTSB ANC85LA080Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Iliamna, AKThe pilot in command stated he was flying in whiteout conditions when he observed an island pass by the right side of the airplane. He started a right turn and the right wing struck the lake ice surface. He stated he did not realize he was that low.May 11, 1985 · N4621Y · Substantial damageNTSB NYC85LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Hancock, MAThe acft was under contract to the Massachusetts state environmental department. It was being used for aerial observation of forest fires & for the disposition of ground fire fighting personel & equipment. The plt reported that while he was attempting to find…May 10, 1985 · N3550V · Substantial damageNTSB NYC85LA111Accident · No injuriesLimited investigationFinal reportCessna R172K · Glen Campbell, PADuring flt, the plt flew over svrl coal strip mines at low alt & at low airspeed. He had the acft trimmed for 60 KTS & had one notch of flaps extended. He reported that as he was flying in straight & level flt, the acft seemed to be drawn down into a valley.…May 10, 1985 · N736FG · Substantial damageNTSB FTW85FPJ02Accident · No injuriesFinal reportRobinson R-22A · Mcalester, OKThe plt was using the helicopter to round up cattle. One cow charged the helicopter and struck the tail rotor. The helicopter pitched nose down, the main rotor blade struck the ground. The helicopter came to rest in an upright position.May 8, 1985 · N8556C · Substantial damageNTSB FTW85FA211Accident · 1 fatalField investigationFinal reportCessna 310H · Avinger, TXThe pilot stated he was flying low over the lake surface. He felt a decelaration to the right and the next thing he was in the water. Witnesses saw the aircraft over the lake at a low altitude and saw the right wing impact the water and cartwheel to the right…May 8, 1985 · N1013Q · Substantial damageNTSB CHI85LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Virden, ILDuring aerial application, the pilot attempted to pass over a set of low wires and under high tension lines. The wires are 300 ft. apart horizontally. The prop contacted the high tension lines and the acft was destroyed on contact with the ground.May 8, 1985 · N731VR · DestroyedNTSB ATL85LA156Accident · No injuriesLimited investigationFinal reportPiper PA-25-260C · Ashburn, GAThe plt was on a flt to clean the spray boom by flying down the center of the airstrip & dispensing a cleaning substance thru the spray boom. He made one pass down the strip, then entered a pull-up to the right. He stated that he then turned back to the left…May 8, 1985 · N4796Y · DestroyedNTSB MKC85LA099Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Bridgeport, NEPilot was making a trial flight with thought of possible purchase of the ag operation. Pilot made forced landing after fuel supply was exhausted. Pilot decided against purchase and departed the area. Pilot has not been located or identified.May 7, 1985 · N7655Z · Substantial damageNTSB MKC85LA096Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Grady, ARAg airplane was being flown on a spray run when the left wing hit a tree. Impact with tree and ground demolished the airplane. Pilot was wearing helmet and seat belt and shoulder harness was fastened. The pilot was not injured.May 7, 1985 · N1754S · Substantial damageNTSB LAX85LA246Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Bullhead City, AZThe plt reported that while he was flying & looking for 'wild animals at the base of the mountain' the acft's eng lost power. The acft descended & when it was close to the ground eng power was reacquired. The plt further reported that there was 'severe'…May 7, 1985 · N8188L · Substantial damageNTSB SEA85LA107Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Fall Creek, ORThe helicopter sustained substantial damage during a forced landing following a loss of power. According to the plt, the helicopter was refueled aprx 1 hr flt time prior to the accident. Cause of the power loss was not determined.May 5, 1985 · N28872 · Substantial damage