NTSB investigations
288 cases where the first occurrence was “Abrupt maneuver”.
Cases, newest first
Query with SQL
duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 100) 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.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 100) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA87FA106Accident · 1 fatalField investigationFinal reportHiller UH-12E · Shelton, WAThe pilot was properly certificated for the flight; however, due to operator insurance restrictions, all prior commercial flights had required the owner/operator to accompany this pilot, therefore this was the pilot's first commercial flight as sole pilot.…NTSB CHI87DER07Accident · 1 fatalFinal reportAir Command Unknown · Dodge Center, MNBefore flt the pilot had stated that his uncertified and unregisterd gyroplane had a 'lot of bugs to work out'. After t.o. and five min of airwork the acft entered a steep 90 degree banked turn and then began to tumble. Shortly after the main rotor separated.…NTSB MKC87FA103Accident · 2 fatalField investigationFinal reportChampion 7EC · Delia, KSWitnesses stated that the aircraft was performing high speed, low level passes over the homes of some friends and relatives when, suddenly, it started a steep climb over a tree line. The aircraft appeared to slow down at the top of the climb; then it leveled…NTSB FTW87FA105Accident · 2 fatalField investigationFinal reportGrumman AA-5B · Eagle Lake, TXOn April 25,1987 a Grumman American AA5B, N28846, impacted the terrain near Eagle Lake, Texas. The private pilot and her husband received fatal injuries. The aircraft was destroyed. Visual meteorological conditions prevailed at the time of the accident. The…NTSB DEN87FA090Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Berthold, NDThe plt took off to the east from a farm driveway to return home. Witnesses saw the airplane make an immediate right turn, followed by a left turn at aprx 35-50 ft AGL. The acft approached the farm at aprx 50-100 ft AGL. The acft suddenly pulled up, banked…NTSB MIA87FA129Accident · Serious injuriesField investigationFinal reportBellanca 7GCBG · New Smyrna Bch, FLThe plt had just returned from a banner tow flight and had refueled. Witnesses stated that on departure the acft banked steeply during the initial climb to pick up another banner. The wings then rocked back and forth and the acft mushed until impact with a…NTSB DEN87LA075Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Columbus, MTA pre-solo student and CFI were practicing landings. The CFI reduced pwr on climbout at 300 to 400 feet. During the discussion of what to do in case of lost pwr on takeoff, the student executed a steep, 180 degree turn, toward the arpt. The acft stalled, and…NTSB CHI87FA104Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Frankfort, ILAircraft control was lost as the pilot attempted to descend to his assigned altitude of 5000 feet from excessive climb. He was in IFR conditions at the time. The airframe broke apart, empennage first, during the uncontrolled descent to the ground due to high…NTSB ATL87FA088Accident · 3 fatalField investigationFinal reportBeech C23 · Semora, NCWhile conducting a local aircraft checkout, the aircraft was observed flying low prior to pulling up to avoid colliding with a utility line crossing the intended flt path. The aircraft crashed into an open field in a nose low vertical attitude. The post…NTSB ANC87FA043Accident · No injuriesField investigationFinal reportBell 47G-2 · Anchorage, AKA flight instructor and his commercial rotorcraft student were practicing quick stops to a hover at low altitude over a snow covered non-maintained airstrip. The student, a commercially rated fixed wing pilot, had successfully completed three quick stops, but…NTSB BFO87LA021Accident · No injuriesLimited investigationFinal reportCessna 310Q · Moundsville, WVOn touchdown the pilot realized that he was long but decided it was too late to go-around. He intentionally ground looped the aircraft to the right. Both ends of the runway drop off into a valley.NTSB SEA87FA051Accident · 2 fatalField investigationFinal reportCessna 150J · Vancouver, WAAircraft was returning from stage 3 instructional flight during which instructor normally allowed student to fly. Evidence indicates aircraft passed in vicinity of heavy bird activity and student executed nose down bird avoidance maneuver. Instructor, for…NTSB DEN87FA042Accident · Serious injuriesField investigationFinal reportAero Commander 690A · Miles City, MTThe plt of the nonscheduled domestic pax air taxi flt was flying the vor/dme rwy 22 apch to wiley field, Miles City, MT. The plt said he turned on the autopilot and after turning inbound from the procedure turn towards the faf he engaged the apch mode. After…NTSB FTW87DQA01Accident · 1 fatalFinal reportBeggs Pitts S-1 · El Paso, TXCommercial pilot practicing aerobatics in pitts S1 experimental homebuilt aircraft entered spin. Pilot failed to recover control of aircraft during descent. Aircraft impacted terrain approximately 1/2 mile south of west Texas airport near El Paso, TX.NTSB ATL87FA045Accident · 2 fatalField investigationFinal reportCessna 170B · Asheville, NCDuring initial climb from a private grass airstrip, witnesses described the aircraft perform a 'wing-over' aerobatic maneuver at low altitude and impact the ground at a near vertical attitude. A ground fire consumed the wreckage. The pilot held a student…NTSB LAX87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Davis, CAA Cessna 152 nosed over in a rough plowed field after a partial loss of power while on a night VFR pleasure flight. The pilot indicated that he was on a date with his girl friend and offered to demonstrate negative gravity to her. He slowed the aircraft and…NTSB CHI87LA041Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Vergenns, ILAccording to the student pilot, while practicing emergency landings, he descended to about 250 feet AGL and then surrendered the controls to the instructor. The student pilot stated that the instructor immediately added full power and banked the acft to the…NTSB NYC87LA035Accident · No injuriesLimited investigationFinal reportCessna 185F · Ithaca, NYThe pilot of the landing Cessna 185 swerved to avoid hitting a deer that was crossing the runway at night. The left wing tip and elevator contacted the runway as the aircraft ground looped. The aircraft received substantial damage, however, it was able to…NTSB DEN87LA013Accident · No injuriesLimited investigationFinal reportPitts S-1D · Shelby, MTThe plt took off with little or no warmup, pushed the acft to max performance at 10 ft, performed a max performance climb to 300 to 400 ft and reduced throttle to idle. As the acft reached stall speed, the plt dived at a 45 degree angle and impacted the…NTSB CHI87DEM01Accident · 1 fatalFinal reportBrown Acro Sport II · Grand Haven, MIAccording to the pilot after takeoff he leveled off to gain airspeed and then entered a 60 degree pitch up attitude. The pilot stated at about 400 feet AGL he noticed the airspeed was lower than 'normal'. Shortly thereafter the aircraft stalled and entered a…NTSB MKC86LA199Accident · No injuriesLimited investigationFinal reportBell 206A · Texarkana, ARThe pilot stated that the left front passenger raised the collective pitch control by mistake while trying to open the cabin door. According to the pilot, the rotor system was between 65-70 n 1 , and the throttle at flight idle. When the helicopter achieved…NTSB DEN86FA252Accident · 1 fatalField investigationFinal reportCessna 172M · Bennett, COThe plt, a bail bondsman, flew to goodland, KS, reportedly in search of an accused felon. On the afternoon of the accident, the plt obtained a wx briefing from the fss and filed a VFR flt plan back to the brighton-van aire airport in Colorado. Wx was cavu.…NTSB 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…NTSB 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…NTSB FTW86FA142Accident · Serious injuriesField investigationFinal reportBell 206B · Watson, OKPilot of Bell 206B conducting forestry operations experienced problem with fire dispensing apparatus being slung beneath aircraft while returning to helipad for fuel. Pilot landed, released external load, and got out of aircraft to release electrical…NTSB NYC86FNC07Accident · Serious injuriesFinal reportCessna 150M · Nashua, NHThe CFI had allowed the student to make the takeoff, witness observed the C150 flying above the rwy at approx 75 to 100 ft with 20 degree flaps. Other witnesses stated that the nose was observed to pitch up then the left wing dropped and the acft went from…NTSB NYC86FHD02Accident · Minor injuriesFinal reportCessna 172K · Jobstown, NJWhile on the third landing attempt, the student pilot was high and fast, the instructor allowed the landing to be accomplished, on the last third of the runway, the CFI attempted a go-around, the flaps were not retracted. The aircraft cleared power lines, but…NTSB DEN86LA178Accident · No injuriesLimited investigationFinal reportCessna 182F · Joliet, MTAccording to the plt, horses ran in front of him during landing and he was forced to make evasive maneuvers. During the evasive maneuvers, the acft ground looped and was substantially damaged.NTSB DEN86LA192Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Provo, UTThe student & instructor (CFI) were practicing touch-&-go lndgs. The CFI rprtd that drg a lndg, when the acft was aprx 6 inches above the rwy, the student suddenly applied full left rudder. The acft yawed sharply to the left & the CFI attempted corrective…NTSB ATL86FMG08Accident · 1 fatalFinal reportH. Preiss HP-19C · Boone, NCThe glider made a steep nose high turn, stalled and crashed after a premature tow release at aprx 150 ft AGL. Witnesses said that the glider appeared to be badly controlled from the beginning of the takeoff roll. After the stall during the turn the acft…NTSB DEN86FA146Accident · 1 fatalField investigationFinal reportBauer'S Mitchell Wing U-2 · Cheyenne, WYThis was an experimental amateur-built acft. Witnesses reported seeing the acft in a steep right bank when the eng lost power. The acft was then seen to stall and enter a right spin. Witnesses said the plt recovered but entered a second stall and dove…NTSB BFO86FID08Accident · 1 fatalFinal reportMilliken Gyrocopter B-80 · Suffolk, VAAccording to a plt witness the accident plt was attempting to compensate for an increase in wind velocity when the accident occurred. The witness stated the plt entered a steep dive to compensate for the increase lift followed by the gyrocopter ballooning due…NTSB NYC86FA112Accident · 1 fatalField investigationFinal reportCessna 310 · Lincoln, RIThe air taxi cargo aircraft was observed maneuvering over the airport in IMC conditions for a VFR approach to land. Witnesses described an abrupt turn to reverse direction of flight followed by a nose dive into the ground. The pilot, age 22, had accummulated…NTSB FTW86FA051Accident · 4 fatalField investigationFinal reportCessna 172N · Del Rio, TXThe pilot was doing aerobatic maneuvers in the Cessna 172 airplane with three passengers and a heavy load of fuel aboard. The maneuvers consisted of buzzing boats on the lake at very low altitude, at least one complete aileron roll, several very abrupt…NTSB ATL86FA102Accident · 2 fatalField investigationFinal reportNorth American NA219 (T28B) · Luthersville, GAAfter takeoff the acft was observed to climb straight out toan alt of about 500-700 ft. it then turned to a northerly heading. After a short time on the northerly hdg, the acft was observed to initiated a left aileron or barrel roll, dishout and end up on an…NTSB FTW86FA050Accident · 3 fatalField investigationFinal reportLockheed L-402-2 (LASA-60) · Seagoville, TXAcft crashed immediately after takeoff on a flt to discharge jumpers over a drop zone located on the arpt. Witnesses stated that shortly after liftoff the acft entered a steep left bank estimated between 45 and 70 degs. After about 120 degs of turn the acft…NTSB MIA86FA100Accident · 3 fatalField investigationFinal reportBeech D-35 · Crystal Springs, FLWitnesses stated they observed the acft performing aerobatics while at an estimated alt of 1000 to 1300 ft. after the completion of a loop, the acft was observed to nearly come to a stop while vertical, then fall off to the left & enter a spin which continued…NTSB ATL86LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Lafayette, TNThe pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.…NTSB ATL86MA087Accident · 1 fatalMajor investigationFinal reportPiper PA-32-300 · Andalusia, ALThe accident flt was to be the last in a series of flt tests. This flt was for the purpose of determining the landing characteristics of the acft with a combination speed/stol kit installed. When the FAA flt test plt failed to return from the mission a search…NTSB NYC86FA077Accident · 1 fatalField investigationFinal reportCessna 172N · Andover, NJThe student plt had difficulty landing the acft and instructor had devoted training session to landing technique. The difficulty was reported to be a tendency to over-flare prior to touchdown. Satisfied the student had corrected his problem area, the third…NTSB MIA86FA027Accident · 2 fatalField investigationFinal reportParsons B/P Gyrocopter · Dunnellon, FLThe instructor plt who was not rated in helicopters or gyroplanes and had an expired instructors certificate was imparting instruction to a student plt in a 2 place homebuilt gyrocopter. When on downwind turn to base leg the student tipped the rotor disc…NTSB LAX86LA027Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Fullerton, CADuring an instructional flt the student plt, who had a total of 5 hrs of flt time, attempted to land with the flaps extended to the 20 deg position. The acft ballooned, & the CFI took control & elected to complete the landing. Insufficient rwy remained & the…NTSB NYC86FA017Accident · 1 fatalField investigationFinal reportSchweizer SGS-1-35C · North Conway, NHDuring an off airport landing attempt in a cleared corn field, the glider was approaching a treeline at an altitude of 10 to 20 ft AGL. Witnesses observed the glider pull up and bank to the left before falling nose first into the ground. The pilot's log book…NTSB CHI85LA378Accident · Minor injuriesLimited investigationFinal reportSchweizer 134 · Hampshire, ILThe pilot reportedly failed to use spoilers on final. The approach was high so he attempted a 180 degree turn at the departure end of the runway. The glider stalled and collided with the ground.NTSB LAX85FA385Accident · 1 fatalField investigationFinal reportJonas Humming Bird · Tucson, AZThe experimental homebuilt acft was designed by the plt and incorporated a lifting body symetrical airfoil shaped fuselage. Pitch control was to be accomplished with a narrow chord canard. Witnesses saw the acft lift off briefly to about 10 ft AGL during the…NTSB FTW85FA335Accident · 2 fatalField investigationFinal reportNorth American British Harvard Mkii · Ada, OKTwo fully qualified single engine plts were in the acft at the time of the accidnet. The acft was observed making low passes near the airport after takeoff. One plt's mother lived near the accident site. The acft was in a steep banked right turn when the…NTSB FTW85FA306Accident · 1 fatalField investigationFinal reportCessna A150M · Levelland, TXThe plt had been observed to make takeoffs using maximum up elevator for liftoff. The elevator was found in a nineteen degree up position and both the left horizontal stabilizer and elevator were bent upward at the tip. The down elevator clevis was observed…NTSB LAX85LA319Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Thermal, CAThe acft crashed during a night visual approach while practicing landings. The pax stated that the acft was high on the approach and the pilot was adjusting his rate of descent when the acft went down.NTSB DEN85FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Columbus, MTAfter making a low pass over his pax home, the plt pulled the acft up abruptly and stalled at a very low altitude. The alt was too low for the plt to effect a successful recovery before ground impact.NTSB FTW85LA260Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Houston, TXThe pilot stated he first saw another aircraft ahead of and below him on final to the runway. He maneuvered to establish interval, then decided to go around. He added fullthrottles but left the flaps and gear down. Unalbe to climb,he decided to land behind…