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 MIA86LA249Accident · No injuriesLimited investigationFinal reportCessna A188B · Newberry, FLThe plt stated that while spraying a field he experienced an eng problem and while attempting a precautionary landing in a cow pasture his left main gear hit a hole and collapsed. Post crash examination of the eng revealed that the linkage on the throttle…Sep 13, 1986 · N4892R · Substantial damageNTSB FTW86LA167Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Norias, TXThe commercial plt was engaged in a livestock round-up and attempted to hover over a wire fence. The acft skid caught on the fence causing a loss of acft control and subsequent impact with the terrain.Sep 13, 1986 · N40268 · Substantial damageNTSB SEA86LA243Accident · 1 fatalLimited investigationFinal reportGrumman G164A-450 · Orovado, NVPower lines were inadvertently struck in flight while maneuvering during aerial application. After striking the power lines the aircraft descended to the ground where a fire erupted and the aircraft was then destroyed by fire.Sep 12, 1986 · N8025K · DestroyedNTSB SEA86FA245Accident · 2 fatalField investigationFinal reportCessna 150M · Carbonado, WAThe instructor and passenger departed on either an introductory flight, initial instructional flight, (or combination thereof). During the flight the aircraft was flown down a canyon which the instructor had flown down previously. As the aircraft approached…Sep 12, 1986 · N9250U · DestroyedNTSB LAX86LA344Accident · No injuriesLimited investigationFinal reportHughes 269C · Carlsbad, CAThe helicopter departed palomar airport (crq), Carlsbad, CA, on a local instructional flight and was the second flight for the dual student. After completing the flight lesson the student asked the CFI to demonstrate hovering. The CFI initiated an…Sep 11, 1986 · N58323 · Substantial damageNTSB LAX86FVM08Accident · No injuriesFinal reportHiller UH 12E · Gonzales, CAA loss of power was expereinced as the acft descended into a field at the beginning of an aerial application spray run. The plt initiated a forced landing into the field. During the landing the right skid dug into the field, tipping the helicopter onto its…Sep 7, 1986 · N149HA · Substantial damageNTSB CHI86LA219Accident · Minor injuriesLimited investigationFinal reportHughes 500 (369HS) · West Lafayette, INThe helicopter was at a low altitude hover video taping an athletic event when the aft flex coupling on the tail rotor failed. The plt was unable to regain control and during descent the main rotor blades struck the roof of a residence. The helicopter then…Sep 6, 1986 · N2254X · DestroyedNTSB BFO86FA044Accident · 1 fatalField investigationFinal reportCessna 177B · Springfield, VAAccording to the plt, the eng bgn running rough drg flt, then clrd & ran smoothly again. He rprtd he elected to abort the flt & made a turn, then svrl min later, the eng lost pwr. Drg an emerg lndg in a parking lot, the l main gear hit anauto & fatally…Sep 6, 1986 · N34953 · Substantial damageNTSB DEN86LA248Accident · No injuriesLimited investigationFinal reportCessna 150J · Goodrich, NDPlt said he was flying low and chasing black birds from his sunflower fields. Terrain was rolling hills. Plt said he made one pass over field and was turning around for another pass. 'I got my airspeed too low and started to stall. I brought it out of the…Sep 5, 1986 · N50989 · Substantial damageNTSB FTW86FRD24Accident · No injuriesFinal reportTexas Helicopter OH-13E/M74 · Port Allen, LAThe helicopter experienced partial power loss and descended to ground. It spray booms became entangled in the soy beans. The helicopter started to nose over, then rolled onto its right side and came to rest. Reason for the partial power loss is undetermined.Sep 3, 1986 · N38092 · Substantial damageNTSB LAX86FUM04Accident · 2 fatalFinal reportSteen Skybolt UNK · Chula Vista, CADuring a local pleasure flight, the aircraft was observed to make a climbing right turn to the inverted position. When observed a few seconds later, the aircraft was right side up in a shallow spin. The aircraft remained in this position until colliding with…Sep 2, 1986 · N64596 · DestroyedNTSB ATL86FA239Accident · 1 fatalField investigationFinal reportCessna P206-B · Wht Sulphur Spr, WVAfter completing the revenue producing portion of this trip the company president called his company operations and told his secretary to send everyone home since it was a holiday. He was going to return the acft to its home base himself. The plt departed…Sep 2, 1986 · N4782F · DestroyedNTSB CHI86FEC06Accident · 1 fatalFinal reportLawrence Baby Great Lakes · Holly, MIThe plt/owner had recently acquired the acft & had only about 3 hrs of flt time in this make & model. After taking off, he flew to the area of a friend's house & made svrl passes over a field near the house. After the last pass, the plt turned to an easterly…Sep 1, 1986 · N1BL · Substantial damageNTSB ATL86FA240Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Hampton, NHThe acft was flying at low alt in the vicinity of interstate I-95 when the plt made a 360 deg, rgt turn. After the turn, the acft collided with pwr lines, which crossed I-95, then crashed & burned. A witness estimated the acft had dscndd to about 35 to 50 ft…Sep 1, 1986 · N8285C · DestroyedNTSB NYC86LA225Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Dennis Port, MAAccording to the plt, he was flying at an alt of 800 ft along the coastline during an aerial advertising flt and was switching from the right fuel tank to the left when the eng lost power. The acft was then ditched in 14 foot deep water. Post accident…Aug 31, 1986 · N3841P · Substantial damageNTSB NYC86FA219Accident · 1 fatalField investigationFinal reportCessna 152 · Bargaintown, NJThe student pilot on a supervised solo cross country, diverted from his planned route and was observed flying low over a residential area performing maneuvers at or below tree top level. The pilot apparently lost control of the aircraft. Aircraft impacted the…Aug 31, 1986 · N6563L · DestroyedNTSB LAX86LA339Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Lompoc, CAAccording to the plt's son the plt routinely overflew his home and rocked the wings. The plt indicated that he was flying at 1100 ft MSL (aprx 650 ft AGL) over his son's ranch and decided to demonstrate slow flt. He slowed the acft to 70 mph and made one…Aug 31, 1986 · N434CW · Substantial damageNTSB LAX86FVG07Accident · Minor injuriesFinal reportPhillips Steen Skybolt · Sonora, CAAn amateur built Phillips steen skybolt experienced an inflight failure of the upper wing panel fabric which led to a rapid descent and subsequent hard landing in a parking lot. Examination of the wing panel revealed no evidence of glue or bonding material…Aug 31, 1986 · N69Z · Substantial damageNTSB DEN86LA245Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2B · Salt Lake City, UTThe plt rprtd that while he was performing aerobatics at an airshow, the acft's eng momentarily lost power during inverted flt at the top of a loop. He was unable to complete the loop. Subsequently, the acft contacted the rwy in a level attitude while it was…Aug 31, 1986 · N260PS · DestroyedNTSB SEA86LA235Accident · 2 fatalLimited investigationFinal reportCessna 182D · Stibnite, IDAfter taking off in mountainous terrain, the pilot prematurely turned on course to a northerly heading, intending to cross over a ridge line. Shortly after the turn, and while flying up a drainage area towards rising terrain, he encountered a downdraft…Aug 30, 1986 · N8778X · DestroyedNTSB SEA86FA231Accident · 1 fatalField investigationFinal reportErcoupe 415C · Prosser, WAThe plt was practicing fly-bys for the next days airshow. The left wing sustained an inflight structural failure. Investigation revealed a progressive crack in the #7 rib emanating from previous damage to the leading edge of the left wing tip. This resulted…Aug 30, 1986 · N3002H · DestroyedNTSB MKC86LA122Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bayard, NEThe plt stated he encountered downdrafts near trees he was going to overfly while in a turnaround maneuver to spray crops. Instead of flying over the trees, the plt stated that the acft descended into the ground near the trees while in the turn. Wind…Aug 29, 1986 · N7364 · Substantial damageNTSB ANC86LA139Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Susitna River, AKThe pilot was demonstrating inverted flight to the student pilot and after one minute of flight in that attitude the engine began to run rough and then finally failed. The pilot performed a forced landing and during the landing roll the airplane nosed over.Aug 29, 1986 · N1177E · Substantial damageNTSB LAX86LA335Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-32 · Fremont, CAThe glider tow pilot stated that he noticed the glider's spoilers in the open position shortly after takeoff. He brought the glider to the traffic pattern. The glider pilot released from the tow and made a sharp turn during which the glider pitched up,…Aug 28, 1986 · N9845E · Substantial damageNTSB NYC86FHD03Accident · 1 fatalFinal reportPassonno Skybolt · Moorestown, NJThe Passonno skybolt was observed to recover from a loop and then the tail surfaces started to shake. The acft then descended to the ground and was destroyed by impact. Examination of various horizontal stabilizer and elevator components showed that the…Aug 27, 1986 · N8FP · DestroyedNTSB ATL86LA229Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Benson, NCThe acft was being operated at low level beneath power lines when it collided with the ground. The plt said he could not recall the events of the accident. Exam of the acft revealed no defect in the flt controls nor the engine. Exam of the accident site…Aug 26, 1986 · N25803 · DestroyedNTSB SEA86LA221Accident · Minor injuriesLimited investigationFinal reportCessna 172A · San Juan Island, WAThe pilot was flying the aircraft at a low altitude in order to spot fish. He ran the right fuel tank dry causing the engine to quit. He was unable to switch fuel tanks and attempt a restart due to his low altitude. A forced landing was made close to the…Aug 25, 1986 · N7405T · DestroyedNTSB SEA86LA223Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Caldwell, IDDuring an aerial application flight, the plt entered a right turn during a 'border pass.' While in the right turn, the right wing struck the ground and the aircraft cartwheeled & crashed.Aug 24, 1986 · N4077X · Substantial damageNTSB MIA86LA240Accident · Minor injuriesLimited investigationFinal reportBoeing PT-17 · Dublin, MSWhile buzzing at a low altitude the aircraft struck a wire causing the pilot to loose control at which time the aircraft crashed to the ground.Aug 24, 1986 · N55290 · Substantial damageNTSB MIA86FA241Accident · 1 fatalField investigationFinal reportRussell Post Moni Motorglider · Fellsmere, FLWitnesses reported seeing the aircraft performing aerobatic maneuvers at approximately 1500 feet. The aircraft was later found with the tail surfaces separated. The tail surfaces were found 300 and 400 feet from the main wreckage. A metallurgical examination…Aug 24, 1986 · N49P · DestroyedNTSB LAX86FUM02Accident · 1 fatalFinal reportStar-Lite UNK · Ramona, CADuring a local test flight of an experimental homebuilt acft, the plt was circling aprx 700 ft AGL when the right wing separated from the fuselage. The acft entered an uncontrollable steep angle dive and collided with the terrain. Inspection as to the…Aug 23, 1986 · N42TJ · DestroyedNTSB SEA86LA214Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Cusick, WAThe pilot was performing as a barnstormer close to a local fair. After completion of several low passes the pilot was attempting to make a steep 180 degree turn to a landing. The turn was completed at insufficient altitude to recover and the aircraft struck…Aug 22, 1986 · N95913 · Substantial damageNTSB NYC86LA227Accident · No injuriesLimited investigationFinal reportBell 47J-2A · Newburyport, MAThe plt experienced a total power loss of the acft eng while practicing autorotations. The helicopter landed hard, the main rotor flexed and severed the tail boom. Post accident inspection of the helicopter revealed the fuel selector was positioned on the…Aug 22, 1986 · N255PH · Substantial damageNTSB MKC86LA177Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Goodwin, ARThe ag acft was being used to spray nudrin on soybeans when the engine lost power. The plt made a forced landing in a rice field and the acft flipped forward to the inverted position. Investigation revealed the two-piece cam reduction gear came apart. An AD…Aug 22, 1986 · N634U · Substantial damageNTSB SEA86FA217Accident · 2 fatalField investigationFinal reportAeronca 7GCB · Stanley, IDWitnesses reported the aircraft came from the direction of Stanley (8 miles to the north). Circled over the guest lodge, made one or more low (100 to 300 foot) passes. On the last pass the acft was heading away from the lodge towards highway 75. The acft…Aug 21, 1986 · N9940Y · DestroyedNTSB SEA86FA215Accident · 6 fatalField investigationFinal reportCessna T207A · Frenchglen, ORAlthough low altitude flight within the gorge was not in accordance with the mission profile the pilot entered the canyon and proceeded upslope towards rising terrain. 87% of the pilot's extensive flight experience was in helicopter aircraft and he had…Aug 21, 1986 · N73569 · DestroyedNTSB SEA86FA213Accident · 2 fatalField investigationFinal reportLuscombe 8A · Pelican, AKAt about 1500 adt on 8/19/86, the plt departed on a flt to hoonak, AK. When he did not return, a search was initiated. The acft was located at 1400 adt on the following day where it had crashed on rising mountainous terrain at an elev of about 1740 ft. an…Aug 19, 1986 · N45830 · DestroyedNTSB LAX86LA334Accident · No injuriesLimited investigationFinal reportCessna 172 · Oroville, CAThe pilot of a Cessna 172 flew low over a reservoir with the engine stopped. The aircraft was observed to make a hard right turn stall and descend into the water. The uninjured pilot exited the sinking aircraft and was rescued by some nearby fishermen. They…Aug 18, 1986 · N8976B · Substantial damageNTSB FTW86LPJ11Accident · Minor injuriesFinal reportHomebuilt SA-100 · Oklahoma City, OKThe acft nosed over during a forced landing after a power loss. The plt stated after the accident that the engine lost power during a roll maneuver. The engine ran for a short time at aprx 1800 RPM and then stopped completely. The plt landed in a cultivated…Aug 17, 1986 · N57DH · Substantial damageNTSB NYC86FNC08Accident · 2 fatalFinal reportChampion 7HC · Epsom, NHA student pilot and passenger on a local flight collided with a tree, crashed and burned. No malfunction was found with the aircraft and engine. The plts flt time was not reported or available.Aug 16, 1986 · N8937R · DestroyedNTSB SEA86LA210Accident · Minor injuriesLimited investigationFinal reportWise OR-71-B · Richland, WAWhile on a qualifying lap for an air race the number one piston failed. A forced landing was then made onto a field.Aug 15, 1986 · N26RW · Substantial damageNTSB LAX86LA322Accident · 2 fatalLimited investigationFinal reportLuscombe 8F · Marble Canyon, AZWitnesses rprtd that prior to the acdnt, the plt made a low pass over a raft on the Colorado river to 'wave his wings' at the rafting group. Rprtdly, he was attempting to reverse his direction when the acft suddenly crashed in the river. A search was…Aug 15, 1986 · N2122B · DestroyedNTSB DEN86FA231Accident · 2 fatalField investigationFinal reportNorth American AT-6D · Redcliff, COA husband & wife rprtd that the acft flew near their house at a very low alt, then climbed in the direction of the sun to clear over a bridge. Moments later, the acft collided with power lines that were suspended between 2 towers. The towers were located atop…Aug 15, 1986 · N9813C · DestroyedNTSB ATL86FEI10Accident · 2 fatalFinal reportSenior Aero Sport D-260 · Valley City, OHAccording to witnesses, the acft was in lvl flt at low alt when it entered a steep climbing maneuver. Subsequently, it entered a steep dscnt & crashed in aprx a 75 deg nose down attitude. There was evidence the acft was in a right bank & was spinning or…Aug 15, 1986 · N35250 · DestroyedNTSB FTW86LQG18Accident · Minor injuriesFinal reportCessna A188B · Mcadoo, TXThe pilot stated he encountered unfavorable wind conditions during a procedure turn which caused the aircraft to bank excessively. Subsequently, the aircraft descended and impacted the ground. The plt thought the aircraft may have encountered a 'whirlwind.' A…Aug 14, 1986 · N4851R · DestroyedNTSB ATL86FEK05Accident · Serious injuriesFinal reportPiper PA-25-235 · Melrose, OHThe acft collided with a traffic sign during an aerial application flt. The plt had made a low pass prior to the collision.Aug 14, 1986 · N4454Y · Substantial damageNTSB CHI86FA198Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Perrinton, MIThe pvt PIC and his pax, also a pvt plt, departed the pic's pvt airstrip for a local pleasure flt. An acft, similar in size and color to the plt's was seen doing low level flt at tree top level with abrupt pull-ups near where the plt normally flew. The plt…Aug 13, 1986 · N36284 · Substantial damageNTSB SEA86FA203Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Grangeville, IDA passenger in the acft reported the plt made more than one pass over 'a salt lick', each time coming closer and closer to the trees. On the last pass the acft 'just fell out of the sky', hit the trees, and landed upside down. Fire broke out almost…Aug 10, 1986 · N6267M · DestroyedNTSB FTW86LA145Accident · No injuriesLimited investigationFinal reportCessna 172D · Cordell, OKThe pilot was practicing maneuvers at 1200 feet AGL, when the engine began to run rough. He applied the carburetor heat and had a large power reduction. He then turned off the carburetor heat and had a total loss of power at approximately 800 feet AGL. The…Aug 9, 1986 · N2730U · Substantial damageNTSB LAX86LA317Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Big Bear, CAThe plt planned a cross country flight from palm springs, CA. To the nearby mountain resort community of Big Bear, CA. Enroute, the plt navigated the acft over an area where the terrain was rising at a rate faster than his acft was climbing. The plt attempted…Aug 8, 1986 · N95370 · Substantial damage