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 ANC85FA163Accident · 6 fatalField investigationFinal reportCessna 180H · Mt. Palmer, AKAircraft collided with Cessna 180 and crashed on mountain side about one-quarter mile apart. Piper was sightseeing and Cessna was spotting sheep. Scattered clouds were reported about 300 feet above the points of ground impact.Aug 25, 1985 · N417GP · 2 aircraft · DestroyedNTSB FTW85LA332Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · San Angelo, TXThe plt had recently purchased the acft and received 25 hrs dual instruction to comply with his insurance requirements. Shortly thereafter he went out solo to practice steep turns. He climbed to 12,500 ft and leveled off. He then rolled into a 60 deg left…Aug 24, 1985 · N8045J · DestroyedNTSB DEN85LTK02Accident · Minor injuriesFinal reportPiper PA-25-235 · Yankton, SDThe acft descended uncontrolled into the terrain after it contacted a power line during an aerial application flt. Witnesses reported the acft appeared to pull up at the west end of the 40 acre fld, however, it did not clear the lines and it nosed over into…Aug 24, 1985 · N9748P · DestroyedNTSB BFO85FID04Accident · Minor injuriesFinal reportCessna A188B · Farmville, VAThe pilot stated that while making his third swath run over a field, the engine started to run rough. He stopped spraying and attempted to gain altitude, but the roughness increased. Shortly thereafter, the manifold pressure dropped and he was unable to keep…Aug 24, 1985 · N4830Q · DestroyedNTSB ATL85LA258Accident · No injuriesLimited investigationFinal reportBeech C23 · Clarksburg, WVThe pilot ran into less than VFR weather and turned around and attempted to make an airport. He became boxed in by weather all around and attempted to land on the highway. He did not make a pss over his intended landing area. When he was on short final, a car…Aug 24, 1985 · N6975R · DestroyedNTSB LAX85LA365Accident · No injuriesLimited investigationFinal reportCessna 150 · Newport Beach, CAThe acft was circling to photograph a sailboat race. The plt rptd that when he attempted to rollout of the turn the acft flt controls did not respond. In order to prevent a stall the plt applied full power and pushed the nose downwards. The acft collided with…Aug 23, 1985 · N5422Q · DestroyedNTSB FTW85LA330Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-400 · Oak Ridge, LAThe plt stated the acft 'sagged' (settled) during an aerial application maneuver and he leveled the wings to let it recover. However, he did not add power, flaps, or dump the load of almost 300 gallons of spray material he was carrying since he thought it…Aug 23, 1985 · N3656N · Substantial damageNTSB CHI85LA358Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Fergus Falls, MNWhen the plt entered a steep right turn at the end of a swath run the acft began to loose alt so the plt added full pwr and leveled the wings. When the acft was close to the ground and slow the plt noticed a row of trees along the flt path. During a pull up…Aug 23, 1985 · N40920 · Substantial damageNTSB MKC85LA193Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Meade, KSThe plt reported that when he attempted to climb at the end of a swath run the acft began to mush. The acft was over tall corn and despite the use of full power it would not climb. The acft flew about one mile in the semi-stalled condition and then began to…Aug 22, 1985 · N731SM · Substantial damageNTSB LAX85LA361Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Buckeye, AZThe plt had just completed a spray run and was executing a procedure turn when the engine's no. 8 cylinder connecting rod failed. Engine oil covered the windshield. The plt attempted to land on the departure airstrip but he could not align the acft with the…Aug 22, 1985 · N5297 · Substantial damageNTSB ANC85LA159Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe acft crashed shortly after the plt had departed an airstrip to proceed on a hunting trip. Impact occurred in a wooded area about 1 mi from the strip. According to witnesses, the plt had made 2 low approaches over the trees before the acdnt. The acft was…Aug 22, 1985 · N625SW · DestroyedNTSB MIA85FA235Accident · 4 fatalField investigationFinal reportCessna 172M · St. ThomasWitnesses stated the acft was flying slow at aprx 200 ft alt photographing a group of sail boats. As the plt entered a left turn to reverse course, it stalled and nosed down striking the water in a near vertical attitude. At the time of the accident the acft…Aug 19, 1985 · N22198 · DestroyedNTSB DEN85FA225Accident · Serious injuriesField investigationFinal reportCessna 182J · Torrington, WYThe plt had a limitation on her certificate that prohibited flight at night. The flt was conducted at night and while enroute the plt diverted to the Torrington arpt. The rwy is equipped with plt activated lgts. A witness stated that the acft circled several…Aug 19, 1985 · N3336F · Substantial damageNTSB CHI85FA356Accident · 1 fatalField investigationFinal reportCessna 172 · Rose Township, MIJust prior to the accident, several witnesses observed the acft flying at a very low alt in the vicinity of the crash site. The crash site was located across the road from the home of the plt's brother. According to witnesses, the acfts eng was operating…Aug 19, 1985 · N5146A · DestroyedNTSB MKC85FA191Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · New Madrid, MOA witness said N267CD made a low pass down the farm airstrip and as the acft neared the end of the strip, it began a climb, banked to the left and descended to the ground. The acft impacted in a nose low, left wing low attitude.Aug 18, 1985 · N267CD · DestroyedNTSB ANC85FA154Accident · 4 fatalField investigationFinal reportde Havilland DHC-2 MK.1 · Tutna Lake, AKThe acft crashed on the side of a mountain at an elev of 2200 ft aprx 3 miles from its intended destination, a remote lake. Purpose of the flt was to discharge caribou hunters into an area where caribou were spotted early that day. The acft was destroyed by…Aug 18, 1985 · N68085 · DestroyedNTSB NYC85FA213Accident · 1 fatalField investigationFinal reportCessna C-305A · Brooklyn, NYDuring an aerial banner tow operation at low level along the beach, witnesses observed the airplane bank sharply to the right and dive into the water. Witnesses recall the engine noise to have been loud yet sputtering before the impact. Inspection of the…Aug 17, 1985 · N5250G · DestroyedNTSB MKC85LA188Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lee'S Summit, MOThe plt reported that the eng start & run-up were normal before he took off on a night currency & proficiency flt. After 2 normal takeoffs & full stops, he made a 3rd takeoff. He climbed to 1000 ft AGL on a x-wind leg, reduced power to 20' manifold pressure &…Aug 17, 1985 · N4772R · Substantial damageNTSB MIA85LKG04Accident · No injuriesFinal reportCessna A188B · Bainbridge, GAThe acft stalled during aerial application operations and collided with the ground. The plt said the wind was gusting to 30 KTS and during a steep downwind turn the loaded acft stalled at 100 ft AGL. The plt recommended less steep turns and not operating in…Aug 17, 1985 · N731RD · Substantial damageNTSB CHI85FEK02Accident · Serious injuriesFinal reportUnknown Quickie · Wren, OHOn August 17,1985 at about 1442 EDT, a Q2 quickie (homebuilt) N4253F, registered to gary a. moser and flown by keith w. moser crashed while performing maneuvers 1/2 mile southeast of Wren, Ohio, while on a personal flight. VFR meteorological conditions…Aug 17, 1985 · N4253F · DestroyedNTSB ATL85LA250Accident · No injuriesLimited investigationFinal reportCessna A-188B · Winterville, MSDuring pull-up from a swath, the acft stalled & descenced into trees. The plt related that he pulled up into a tight turn causing the acft to stall.Aug 17, 1985 · N4762Q · Substantial damageNTSB MIA85LKG05Accident · No injuriesFinal reportCessna L-188 · Camilla, GAThe plt stated that during a swath run at an alt of aprx 5 ft AGL, a sudden loss of pwr occurred. The acft was damaged when it settled and contacted the terrain. Post accident inspection and a test run of the eng failed to reveal any mechanical…Aug 16, 1985 · N53172 · Substantial damageNTSB LAX85LA349Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Santa Paula, CAOn a local flt to view camping and hiking facilities in mountainous terrain, the acft entered a box canyon with a moderately rising floor and steep sides reported by the sheriff's department at about one-quarter of a mile wide. Duringan attempted course…Aug 15, 1985 · N79504 · Substantial damageNTSB LAX85LA348Accident · No injuriesLimited investigationFinal reportCessna A188B · Willcox, AZOn August 15, 1985, a Cessna 180 lost eng pwr due to fuel exhaustion and collided with the ground during an aerial applicaion maneuver. The acft sustained substantial damage but the pilot was not injured. The plt stated that he should have checked the fuel…Aug 15, 1985 · N4974Q · Substantial damageNTSB FTW85LA323Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Floydada, TXThe plt stated he failed to see a metal stand pipe in the cotton field. The acft collided with the stand pipe and flipped inverted. Residue of the spraying chemical was observed on the windscreen after the accident. This residue restricted forward visibility…Aug 15, 1985 · N9964J · DestroyedNTSB ATL85LA248Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Irwinville, GAThe acft reportedly suffered a loss of power during aerial application. A forced landing was attempted in a field and collided with a tree. The cause of the loss of power was undeterminedAug 15, 1985 · N48515 · Substantial damageNTSB MKC85LA183Accident · No injuriesLimited investigationFinal reportCessna A188B · Menlo, KSPlt reports that the eng gradually lost power during a swath turn around. A landing on a nearby road appeared possible but the eng quit and the acft crashed in a corn field. Post accident examination by an FAA inspector failed to reveal any evidence to…Aug 13, 1985 · N4936Q · Substantial damageNTSB LAX85LA345Accident · No injuriesLimited investigationFinal reportAerospatiale SF3130 · Buckeye, AZDuring a hover in a confined area the plt misinterpeted his passg signal to move to a diferent location as a signal that the tail rotor was in danger. The plt used abrupt control movements that resulted in the toe of a skid hooking into a wire fence. The…Aug 12, 1985 · N537 · Substantial damageNTSB FTW85MA317Accident · 3 fatalMajor investigationFinal reportBeech 200 · Quinlan, TXN100HC and N33177 collided due to the failure of both plts to maintain adequate visual separation. The PIC of N100HC made a poor decision by performing the simulated emergency descent on a low alt airway. The southerly descending maneuver was performed…Aug 12, 1985 · N100HC · 2 aircraft · DestroyedNTSB ATL85LA246Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Goodway, ALDuring aerial application the acft lost total pwr and the plt made an emergency landing in a fld. The plt stated that shortly after the eng lost pwr, he noticed smoke coming from the eng nacelle. After landing in the fld, the acft began to burn and was…Aug 12, 1985 · N9647P · DestroyedNTSB ATL85LA245Accident · No injuriesLimited investigationFinal reportCessna T188C · Athens, ALThe acft experienced a gradual loss of pwr followed by an in-flt fire which lead to an off arpt forced landing. During the forced landing ihe acft collided with trees and was destroyed by fire.Aug 12, 1985 · N2825J · DestroyedNTSB ANC85LA151Accident · No injuriesLimited investigationFinal reportCessna C-207 · Mountain Villag, AKThe pilot-in-command was aware of the weather he was operating in and intended to fly through a locally well known pass. He misidentified the pass and found himself in a narrow valley. There was insufficient width to effect a 180 degree turn and the rising…Aug 12, 1985 · N9480M · Substantial damageNTSB FTW85LA312Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Morton, TXAfter completing several passes, the acft was crossing a road under power lines when the propeller struck a road sign. The acft subsequently became uncontrollable and impacted in an adjacent field, flipped over and slid to a stop. The pilot stated that he was…Aug 11, 1985 · N6529Z · DestroyedNTSB MKC85FA181Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Moscow, ARWitnesses saw three acft in a loose trail formation at low alt near the plt's pvt farm strip. The last acft in the trail position (N9060P) broke off to the left and made a steep pull up. After a short climb, the nose of the acft dropped and the acft dove to…Aug 10, 1985 · N9060P · DestroyedNTSB MKC85FA179Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Palisade, NEWhile on a swath run over a cornfield, the plt attempted to maneuver under power lines that were spanning a large ditch. The right wing struck one of the three lower cables which cut into the wing structure. The cable finally separated releasing the acft. The…Aug 10, 1985 · N8941L · DestroyedNTSB MIA85LA228Accident · No injuriesLimited investigationFinal reportHughes 269C · St.Petersburg, FLThe pilot of the helicopter was executing a quick stop in a downwind condition. As he increased collective pitch control, the rotor RPM bled down. The pilot stated that he increased collective pitch to increase RPM and the aircraft crashed.Aug 10, 1985 · N300JS · Substantial damageNTSB MIA85FA227Accident · 2 fatalField investigationFinal reportCessna 172RG · Cedar Key, FLThe manager of the destination arpt said the plt had called earlier in the evening & had asked to be picked up at the arpt. The plt said that he would fly over the manager's house after he arrived. The manager heard the acft fly over from east to west.…Aug 10, 1985 · N6419R · DestroyedNTSB FTW85FA310Accident · 1 fatalField investigationFinal reportBell UH-1B · Saint James, LAAcft was at a 150' hover preparing to pick up a log when it experienced a power loss. Witnesses stated that they heard a loud 'bang' and the pilot radioed 'get out of the way'. Acft autorotated thru 60' to 80' trees with very low rotor RPM and impacted with…Aug 8, 1985 · N1385W · DestroyedNTSB DEN85LTE06Accident · No injuriesFinal reportCessna 180 · Mule Creek Jct, WYThe plt was spotting cattle during a cattle herding operation. He saw 2 cows with calves in a cove of a canyon that personnel on the ground were leaving behind. The plt stated that he made a sharp turn & flew over the cows to show their location to riders on…Aug 8, 1985 · N5163E · DestroyedNTSB FTW85LA309Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Tallulah, LADuring an aerial application operation, the eng lost power & the plt made an emergency landing in a soy bean field. While on the landing roll, the acft nosed over. The operator reported that he did not see or smell any fuel around the acft; he believed that…Aug 7, 1985 · N962X · Substantial damageNTSB CHI85LA338Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Pickett, WIThe fld where this accident occurred had been sprayed one week prior to the accident by a fixed-wing acft at an alt of 20 ft. no wires were noted to be a hazard at that time. On the day of the accident the plt of the helicopter was talking to a spotter on the…Aug 7, 1985 · N1476W · Substantial damageNTSB ANC85LA150Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Wasilla, AKThe instructor initiated a simulated engine failure at 250 foot above the ground with no forced landing area in sight except of the lake behind them from which they had just departed. The student attempted a 180 degree turn back to the lake and the instructor…Aug 7, 1985 · N29705 · Substantial damageNTSB NYC85FGT02Accident · 2 fatalFinal reportJones Marquart MA-5 · New Oxford, PABefore flying a short distance to thomasville to refuel, the plt added 3 to 4 gal of auto fuel to the acft. At thomasville, the acft was serviced with 20.1 gal of aviation fuel. While taxiing to takeoff, the eng stopped & was restarted twice. After departing…Aug 6, 1985 · N168FJ · DestroyedNTSB MKC85FA177Accident · Serious injuriesField investigationFinal reportCessna A188B · Dodge City, KSThe plt was was making east & west runs over a milo field as he was dispensing parathion. He reported that he had been working under high voltage power lines each time he flew past the west edge of the field. He stated that on the last pass, the acft…Aug 5, 1985 · N9257G · DestroyedNTSB ATL85LA236Accident · No injuriesLimited investigationFinal reportCessna A188B · Trenton, ALThe pilot stated that the eng lost power while he was maneuvering for another spray run over the field. The aircraft settled into the trees and a post-crash fire developed.Aug 5, 1985 · N21708 · DestroyedNTSB ATL85FA237Accident · 1 fatalField investigationFinal reportCessna 172A · Glencoe, KYThe acft crashed in a field next to where a friend of the plt was baling hay. The plt had called the friend earlier in the day & ask the friend to go fly with him. Just prior to the acdnt, the plt flew over & circled a couple of times at low alt. Two…Aug 5, 1985 · N7279T · Substantial damageNTSB SEA85LYA01Accident · No injuriesFinal reportRockwell S2R · Caldwell, IDAn aero commander S2R had been modified by the installation of an air research TPE-331-43A power plant. During an aerial application flight the pilot heard a loud bang and experienced a loss of power. Investigation revealed the first stage turbine whee, part…Aug 4, 1985 · N5511X · Substantial damageNTSB LAX85LA338Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Santa Paula, CAOn aug 4, 1985 an Aeronca 7AC collided with the ground while buzzing over a sand bar near Santa Paula, CA. VMC existed at the time. The ac sustained substantial damage and the pvt plt received minor injuries. He reported no mechanical problems with the ac…Aug 4, 1985 · N85168 · Substantial damageNTSB ATL85LA233Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Leesburg, GAThe aircraft suffered a loss of power due to water in fuel and made an emergency landing in a field. During landing roll the aircraft collided with trees at the end of the field.Aug 4, 1985 · N48562 · Substantial damageNTSB ANC85LA158Accident · No injuriesLimited investigationFinal reportCessna C-172M · Wasilla, AKThe pilot-in-command was on a personal flight with the purpose of observing a hunting camp from the air. While maneuvering in the canyon, the pilot stated he encountered a downdraft. He applied full power and lowered the flaps 20 degrees. The airplane…Aug 4, 1985 · N20338 · Substantial damage