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 CHI90DEV07Accident · 2 fatalFinal reportPitts S2B · Springfield, ILThe pilot's failure to maintain flying speed and allowed the aircraft to stall during the break turn to downwind.NTSB LAX90LA257Accident · No injuriesLimited investigationFinal reportCessna A185F · Discovery Bay, CAThe pilot's improper visual lookout to assure the area was clear of boats before departing.NTSB FTW90GA137Accident · Minor injuriesFinal reportCessna 404 · San Angelo, TXImproper use of powerplant controls by the pilot-in-command (PIC). Factors related to the accident were: the pic's inadequate crew coordination, and the excessive airspeed and rate of descent that resulted, when the PIC maneuvered the aircraft back on course…NTSB MKC90DCJ01Accident · 1 fatalFinal reportK. W. Jeffers Varieze · Brainard, NEPilot used poor judgement in attempting aerobatics with inadequate altitude which resulted in loss of aircraft control. Contributing factors were a low pass performed, over confidence in personal ability and ostentatious display by the PIC.NTSB BFO90LA042Accident · No injuriesLimited investigationFinal reportBell 47D · Baltimore, MDThe pilot applied excessive cyclic control, causing the main rotor to flex and severe the tail cone.NTSB DEN90FA099Accident · 2 fatalField investigationFinal reportPiper PA-22-160 · Scranton, NDPilot factor in that he failed to maintain aircraft control while performing an inflight maneuver.NTSB CHI90LA115Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Milwaukee, WIThe utilization of improper procedures on the part of the pilot in command by attempting to execute a coupled approach outside the parameters of the autopilot.NTSB LAX90LA151Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Creston, CAThe inadvertent intrusion of wildlife on the runway environment and the pilot's application of brakes resulting in a nose down attitude and propeller strike.NTSB DEN90FA059Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260C · Agoura, CALoss of control of the aircraft during acrobatic flight and the pilot's failure to recover from a spin.NTSB FTW90LA020Accident · No injuriesLimited investigationFinal reportCessna 150H · Mountain Home, TXLack of airspeed for a climb to clear obstacles off the departure end of the runway, resulting in a precautionary landing into unsuitable terrain. The inadequate airspeed was a result of an encounter with deer during the take off and the pilots vertical…NTSB FTW90LA016Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Friona, TXThe pilot's decision to perform an aerobatic maneuver during initial climb out with inadequate altitude for recovery.NTSB FTW89LA174Accident · No injuriesLimited investigationFinal reportBell 206BII · Grand Prairie, TXThe pilot's decision to execute an abrupt maneuver while hovering downwind, which led to a reduction in rotor RPM and subsequent hard landing.NTSB BFO89FA079Accident · Serious injuriesField investigationFinal reportBell 206B-III · White Plains, MDThe pilot's failure to follow procedures in that he delayed his climb during a night takeoff from a confined area. Contributing factor(s) was: the dark night and surrounding obstructions.NTSB CHI89LA103Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Milan, MIThe pilot's excessive rotation, which resulted in an inadvertent mushed stall and collision with trees.NTSB ANC89FA084Accident · 1 fatalField investigationFinal reportStinson 108-2 · Wasilla, AKPilot failed to operate the aircraft within its recommended parameters, resulting in loss of control and a stall-spin into the water.NTSB ATL89LA154Accident · 1 fatalLimited investigationFinal reportBoeing E75 (PT-13D) · Jacksonville, NCThe pilot encountered an accelerated stall during an abrupt maneuver, lost control of the airplane and did not have sufficient altitude to recover from the ensuing spin prior to colliding with the ground.NTSB LAX89DVG05Accident · No injuriesFinal reportMorse F85P-1 · Redding, CAAn animal on the runway. Factors were: the pilot's intentional ground loop and the resultant loss of control.NTSB DEN89FA093Accident · 2 fatalField investigationFinal reportCessna 177RG · Albuquerque, NMThe pilot's improper use of flaps during takeoff which resulted in inadequate airspeed, a stall, and loss of control.NTSB DEN89IA067Incident · No injuriesIncident investigationFinal reportBoeing 707-323B · Salt Lake City, UTThe pilot-in-command's attempt to align the airplane with the runway at an altitude insufficient for safe maneuvering, resulting in the no. 1 engine striking the runway. Contributing factors include obscured visibility due to fog, the captain's loss of depth…NTSB CHI89DEX01Accident · 1 fatalFinal reportPitts S-15 · Delphi, INFailure to recover from an aerobatic maneuver due to lack of total experience, and lack of recent experience in the type of flight regime.NTSB FTW89DPJ01Accident · 1 fatalFinal reportAutra Scorpion/133 · Mcalester, OKThe homebuilt helicopter was departing on a local flight, when, on initial climbout, the low time, inexperienced student pilot made an abrupt maneuver which sent the helicopter into an uncontrolled descent. It impacted trees and a post crash fire occurred.NTSB MKC89FA004Accident · Serious injuriesField investigationFinal reportHughes 500C · Branson, MOThe flight was conducted for sightseeing with 5 passengers onboard. The pilot turned on final approach with 35 knots of airspeed and encountered a high rate of descent. The pilot reported that he noted a split tach and initiated an autorotation, but was…NTSB SEA89LA003Accident · No injuriesLimited investigationFinal reportLet L-13 · Enumclaw, WAThe pilot allowed the aircraft to become too close to terrain while soaring. A steep turn to reverse direction resulted in entry into an accelerated stall at low altitude. The pilot lowered the nose of the aircraft to recover, however, while lowering the nose…NTSB FTW88DPA07Accident · No injuriesFinal reportBölkow BO-105C · Dallas, TXThe helicopter made its approach to an open area on the westside of the airport to go to a refueling area on the south side of the airport. The pilot changed his mind and decided to go to the northeast side of the airport. He received tower approval but was…NTSB ATL88FA220Accident · No injuriesField investigationFinal reportPiper PA-28-151 · La Grange, GAThe PIC stated he had a hardover in the single axis autopilot which resulted in the acft constantly turning right. Therefore due to the continous bank he elected to make a precautionary landing in a lake versus on land. The acft impacted in a lake left of the…NTSB DEN88LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Fort Peck, MTThe pilot made a takeoff from a muddy, dirt, road. He said that after he become airborne he put his aircraft into a sharp turn in order to avoid some power lines. Although he was successful in avoiding the power lines, he inadvertently stalled the aircraft…NTSB LAX88LA229Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dorris, CADuring a local pleasure flt, just as the airplane touched down, an antelope ran across the rwy. The plt swerved the airplane to avoid the animal, exited the runway and collided with the terrain. There were no mechanical failures or malfunctions with the…NTSB MKC88LA102Accident · No injuriesLimited investigationFinal reportPitts S-2 · Siloam Springs, ARThe pilot said that after takeoff and reaching a safe altitude, he made an immediate hard left turn resulting in a loss of control. Pilot did not recover from the resultant stall.NTSB SEA88FA095Accident · 1 fatalField investigationFinal reportCessna 172L · Ocean Shores, WAThe student pilot departed on his fifth solo flight from the airport where he had been accustomed to originating his instructional flights. After several touch and go landings he proceeded to a nearby airport and conducted at least one more touch and go.…NTSB FTW88DRA10Accident · Minor injuriesFinal reportNew Rutan LONG-EZE · Friendswood, TXThe pilot overrotated the aircraft on takeoff to a nose high attitude, then overcontrolled in the opposite direction to get the nose down. The aircraft touched down nose gear first and all three landing gears collapsed, a wing sheared off, and the aircraft…NTSB FTW88DRA09Accident · 1 fatalFinal reportCurtis Baby Great Lakes · Angleton, TXShortly after liftoff, the acft was observed to enter a rt bank and then a left bank to a course parallel to the t/o rwy. It was subsequently observed to enter a left turn which steepened and the acft nosed over until ground impact. Original turn was executed…NTSB SEA88LA072Accident · 1 fatalLimited investigationFinal reportSteen Skybolt GT-2 · Saint John, WAAfter tkof witnesses said the acft did a maneuver at 50-60 ft AGL that involved a steep (90 degree) banked turn to a snap roll. The biwing acft was capable of aerobatic flt and the plt had discussed aerobatic roll maneuvers on tkof with the acft co-owner. The…NTSB MKC88FA072Accident · 1 fatalField investigationFinal reportBeech H18 · Kansas City, MOThe cargo flt dptd cincinnati enrt to wichita, KS with an intermediate stop at Kansas City dtwn arpt. The flt progressed nrmly to a VOR rwy 03 instrument apch, circling to rwy 01. The PIC had been clrd to commence the apch. Twr pers subsequently advised the…NTSB ATL88FA123Accident · 4 fatalField investigationFinal reportBeech C23 · Sevierville, TNThe aircraft was not certified for acrobatic flight. According to several witnesses the pilot was practicing acrobatics with three passengers on board. The pilot lost control of the aircraft and did not recover.NTSB ATL88FA118Accident · 2 fatalField investigationFinal reportChampion 7BCM · Bishopville, SCThe student pilot, carrying a passenger, attempted a low level maneuver, and stalled the aircraft. He was unable to recover in the altitude available and the aircraft struck the ground. Toxicological tests on the blood/urine were done on the PIC. The blood…NTSB MIA88FA122Accident · No injuriesField investigationFinal reportBoeing 747-200 · Miami, FLAfter landing the Boeing 747-200 airliner, the captain increased the pitch attitude to 11 degrees nose up by pulling the control column aft. The tail struck the ground causing substantial damage. The Boeing airplane flight manual prescribes that the…NTSB MKC88FA040Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Creve Coeur, MOWitnesses stated that the aircraft suddenly started a vertical climb from a straight and level flight attitude. The airplane lost momentum while in the climb, then it nosed down and dove towards the ground. It exploded upon impact and was destroyed in the…NTSB ATL88FA070Accident · 2 fatalField investigationFinal reportCessna 152 · Ravenna, OHNTSB BFO88FA007Accident · 2 fatalField investigationFinal reportCessna 152 · Warrenton, VAThe acft was observed to be flying straight and level when the sounds of the eng were heard to increase. The only witness saw the acft nose over and dive into the ground. Radar tracking of the acft flt path confirms this. Investigation revealed that the this…NTSB CHI87FA219Accident · 1 fatalField investigationFinal reportBeech H-18 · Rockford, ILThe commercial pilot was on a repositioning flight from kenosha, Wisconsin to atlanta, Georgia, after having been without sleep for about 20 hours. Witnesses observed the aircraft circling a subdivision near Rockford, Illinois at a low altitude, just above…NTSB LAX87LA333Accident · Minor injuriesLimited investigationFinal reportAeronca Champ 7AC · Victorville, CAWhile climbing out over a ridge, the instructor, who was sitting in back, heard his student yell something. The instructor looked out the front windscreen just in time to see powerlines. Simultaneously, the student pushed the stick forward to go under the…NTSB LAX87LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Long Beach, CAThe plt indicated that 10 min from his destination he became concerned that the fuel gauges read 'near zero.' The plt elected to divert to another aprt, which was closed. The plt maintained his alt in case of power loss. The plt stated, 'I also became glued…NTSB LAX87LA313Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Buckeye, AZA Piper PA-38-112 landed hard on the runway while on a VFR training flight. The certificated flight instructor (CFI) indicated that the student pilot made an abrupt aft yoke (up elevator) application during the landing flare. The aircraft ballooned…NTSB LAX87IA303Incident · No injuriesIncident investigationFinal reportBoeing 747-300 · Los Angeles, CADrg arr, japan airline flt 62 (Boeing 747, JA-8163) was initially vectored (by lax ARTCC) for an ILS rwy 24R apch in reduced visibility (haze). Bfr turning final, flt 62 was adzd of an acft that was 4 mi ahead. Flt 62 rprtd that they had the acft in sight.…NTSB LAX87FA286Accident · 2 fatalField investigationFinal reportLuscombe 8A · Oakdale, CAThe plt & his plt-rated wife (flying in their Luscombe) & another couple (in a rented Mooney) had dinner & drank wine. By about 0015 the couples had taken off in their respective acft for a return flt home and they had each other in sight. The couple in the…NTSB MIA87FA191Accident · 2 fatalField investigationFinal reportRockwell 690A · Hilliard, FLRadar data indicated the acft climbed normally to 9,200 feet at which time some manuever was performed with the acft. The acft then entered a near vertical dive and the last radar hit was at 6,900 feet. Examination of the acft revealed it experienced an…NTSB CHI87LA154Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILWhile on final approach just past the threshold of runway 32 at about 10 feet AGL, a helicopter crossed in front of the Cessna 152. The student pilot added power and pulled back on the yoke. The instructor pilot then took the controls and attempted to get the…NTSB NYC87LA178Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sterling, MAWhile practicing hovering in the designated hover area at the arpt, the stu plt accidently pulled aft cyclic while the helicopter was drifting backwards. This caused the tail structure and rotor blades to contact the ground. The main rotor blades then…NTSB ATL87LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Sylva, NCThe CFI instructed his low-time beginning student to make a normal appch to the rwy, and fly down the rwy at about 10 ft above the rwy surface while maintaining rwy hdg. The CFI stated that the purpose of the maneuver was '...to help the student improve his…NTSB FTW87MA135Accident · 2 fatalMajor investigationFinal reportMBB BO-105CBS · Bay City, MIAcft was involved in EMS static demonstration at beaver township fire dept, near Bay City. Following demonstration, shortly after takeoff, the pilot attempted a steep downwind turn at low altitude. Reported winds at the time of the accident were 250 degrees…