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 ATL88LA166Accident · 1 fatalLimited investigationFinal reportPiper J5C · Gulf Shores, ALA witness reported that the airplane encountered a 'downdraft' while attempting to pick up a banner. The main ldg gear caught the banner pick-up line and carried the banner aloft. The witness radioed the plt to advise him of the situation, but received no…May 6, 1988 · N41333 · Substantial damageNTSB ANC88LA053Accident · 1 fatalLimited investigationFinal reportCessna 150L · Kotzebue, AKThe aircraft crashed five miles south of the city along the beach line. FAA inspectors, the Alaska state troopers accident report and several witnesses revealed that the pilot stated prior to the flight that he intended to commit suicide. The plt had a fight…May 4, 1988 · N6592G · DestroyedNTSB ANC88FA052Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Larson Bay, AKA float equipped Piper PA-18-150 and float equipped Cessna 185F, were involved in a midair collision at an altitude of approximately 800 feet MSL over Larson Bay, AK. At the time of the midair collision both aircraft were being used as fish spotters for…May 3, 1988 · N54768 · 2 aircraft · DestroyedNTSB LAX88DVG03Accident · No injuriesFinal reportSchweizer G-164B · Gridley, CADuring an agricultural operation, the engine quit at approximately 50 feet AGL. The airplane was landed on a dirt field and nosed over. Inspection of the engine revealed that the left magneto drive gear teeth were missing and the right magneto drive gear was…May 2, 1988 · N3627Q · Substantial damageNTSB SEA88LA087Accident · Minor injuriesLimited investigationFinal reportStearman A-75-N1 · Medford, ORPlt performed a negative 'g' maneuver, estimated at 2 to 2.5 negative 'g' force, following which the engine lost power. A forced landing was accomplished in scrub trees. The engine is equipped with a float carburetor. There were indications that the cause of…May 1, 1988 · N53125 · Substantial damageNTSB CHI88FA102Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Merrimac, WIThe pilot had just taken off from a private strip and immediately entered a high angle of bank turn to the left at low altitude. A witness, who was an experienced aerobatic pilot, estimated the angle of bank to approach 90 degrees. The nose was seen to pitch…May 1, 1988 · N31288 · DestroyedNTSB FTW88DRA11Accident · 1 fatalFinal reportCessna L-19E · Conroe, TXThe airplane was observed by witnesses making a chandelle-like maneuver from takeoff. At the top, the nose and right wing dropped for approximately 180 degrees of turn. The wings were almost level when the airplane hit the runway. The airplane burned after…Apr 30, 1988 · N3946L · DestroyedNTSB CHI88FA101Accident · 1 fatalField investigationFinal reportCessna 152 · Lonsdale, MNThe student pilot was on his first solo flight outside the airport traffic area and was practicing maneuvers prescribed by his flight instructor including slow flight and stall type maneuvers. The aircraft experienced a loss of control, followed by an…Apr 28, 1988 · N67338 · DestroyedNTSB ANC88FA051Accident · 2 fatalField investigationFinal reportBeech C55 · Tyonek, AKThe two pilots were operating the aircraft under the authority of a ferry permit which allowed flt only during day VFR conditions and with a single pilot. They requested and received just the weather at the destination airport, which was VMC. En route the flt…Apr 27, 1988 · N2730T · Substantial damageNTSB BFO88DIG02Accident · 1 fatalFinal reportLamb Shoestring S-102 · Gaithersburg, MDThe pilot inproperly performing aerobatics without sufficient altitude to complete a recovery.Apr 24, 1988 · N47CL · DestroyedNTSB LAX88DUA01Accident · 2 fatalFinal reportHernandez Thorp T-18 · Palos Verdes, CAThe pilot was demonstrating the acft for the passenger for a possible sale. They were part of a flight of two over the pacific ocean. The owner of the aircraft being demonstrated was in the second aircraft. The pilot of the demo acft radioed to the second…Apr 23, 1988 · N1394A · DestroyedNTSB ATL88LA149Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-4 · Chester, SCWhile thermaling during the sailplane competition, N45BD was slightly higher and to the left of N295SZ. N45BD made a right turn and struck the right inboard wing section of N294SZ with the outboard wing tip of N45BD. The outboard wing tip of N45BD separated…Apr 22, 1988 · N45BD · 2 aircraft · DestroyedNTSB SEA88LA081Accident · 1 fatalLimited investigationFinal reportRockwell A-9B · Grace, IDPlt/owner not certificated for aerial application. No record found of prior experience in aerial application. Replaced certificated plt for undet reason. Witnesses observed acft enter stall/spin during first aerial application turnaround maneuver in strong…Apr 19, 1988 · N7657V · DestroyedNTSB LAX88FA163Accident · 2 fatalField investigationFinal reportAerospatiale AS355F · Cajon, CAPilot's failure to maintain altitude.Apr 17, 1988 · N5777P · DestroyedNTSB MIA88LA152Accident · No injuriesLimited investigationFinal reportDenney Kitfox · Lakeland, FLThe plt stated that he was flying in the homebuilt acft area at the 'sun and fun fly in' when the engine quit. An attempt was made to land in a field, which he couldn't make, and came to rest in some scrub trees. The plt also stated that he had been having…Apr 16, 1988 · N84DD · Substantial damageNTSB MIA88LA146Accident · Minor injuriesLimited investigationFinal reportFischer STAR-LITE · Lakeland, FLThe owner/manufacturer of the homebuilt acft repaired the horizontal stabilizers, then asked the designer to test fly the aircraft. After takeoff, at an alt of aprx 7,000 feet MSL, in a nose low attitude, at 158 mph ( 28 mph greater than vne) both horizontal…Apr 13, 1988 · N20RF · DestroyedNTSB SEA88LA076Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lake Mead, NVThe pilot was flying very close to the water for the purpose of dropping beer to friends. The pilot allowed the aircraft to inadvertently descend and strike the water.Apr 12, 1988 · N91555 · DestroyedNTSB MIA88DL001Accident · Serious injuriesFinal reportFalcon Special S/R · Lakeland, FLThe pilot experienced an in flight fire in the exhaust system while performing acrobatic maneuvers at an airshow. The aircraft is equipped with a pump that injects oil into the exhaust system to produce a visible smoke trail when vaporized by the exhaust…Apr 10, 1988 · N82RC · Substantial damageNTSB FTW88DPJ04Accident · 1 fatalFinal reportAerotek Pitts S-2A · Elk City, OKThe aircraft was observed doing aerobatics. A stall/spin was initiated from a climbing vertical attitude. Corrective action was not accomplished by the pilot and the aircraft was observed to spin to ground impact. No aircraft malfunctions were found.Apr 10, 1988 · N8076 · DestroyedNTSB CHI88DEM04Accident · No injuriesFinal reportAnderson Pitts S-1S · Mt. Pleasant, MIThe pilot was performing some inverted maneuvers when the engine quit. The pilot stated he attempted to restart the engine but was unable to. He then executed an emergency landing in a farm field. During the landing roll the pilot was unable to maintain…Apr 10, 1988 · N528MS · Substantial damageNTSB ANC88DAG03Accident · No injuriesFinal reportPiper PA-14 · Glennallen, AKThe pilot stated that he was flying up a fairly wide valley containing a ridge that he had to fly over. The ground was completely white with snow. The pilot noticed a hill directly in front of the aircraft; he started a turn and the aircraft struck the snow…Apr 5, 1988 · N5188H · Substantial damageNTSB FTW88DRA05Accident · No injuriesFinal reportHiller UH-12E · La Salle, TXAcft was substantially damaged during an emergency autorotation following an engine failure while the acft was completing an aerial application maneuver. Acft touched down tail low and the main rotor blades flexed down and cut off the tail boom. Investigation…Apr 4, 1988 · N4029D · Substantial damageNTSB CHI88FA092Accident · 1 fatalField investigationFinal reportCessna 207 · Hardwick, MNWitnesses observed the aircraft for aprx 8 minutes in erratic diving, climbing, and steep-turning maneuvers which culminated in a 12 degree descent to the ground. The sound of the eng was heard throughout the sequence and other evidence indicated engine power…Apr 4, 1988 · N207CA · DestroyedNTSB CHI88DEM03Accident · No injuriesFinal reportGrumman G-164A · Allegan, MIThe pilot had just completed two swath runs and was turning to start the third when the aircraft began to buffet and approached a stall. The pilot then lowered the nose of the aircraft and added full throttle. After applying full throttle the pilot stated he…Apr 4, 1988 · N84PG · Substantial damageNTSB LAX88FA150Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Ukiah, CAThe pilot failed to maintain control of his aircraft. Contributing factors were the pilot's lack of recent IFR experience, spatial disorientation and his failure to perform remedial action.Apr 3, 1988 · N15847 · DestroyedNTSB LAX88DVA03Accident · No injuriesFinal reportCessna 188B · Gustine, CADuring an aerial application maneuver, at 70 ft. a.g.l., the engine lost all power. The pilot leveled the wings and dumped the remaining load. The engine regained full power, backfired, then lost power again. The aircraft collided with almond trees. An…Apr 2, 1988 · N21762 · Substantial damageNTSB DEN88FA089Accident · 2 fatalField investigationFinal reportBurkhart Grob G103A · Boulder, COApr 2, 1988 · N788G · DestroyedNTSB ATL88LA127Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Guntersville, ALThe seaplane collided with the water shortly after takeoff. The plt rptd that a large spider dropped in front of him and distracted him. The airplane was in a gradual right turn about 100 ft above the water at the time. He attempted to swat the spider with…Apr 1, 1988 · N50715 · Substantial damageNTSB MIA88LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Key West, FLAccording to the plt he was on a fish spotting flight. The acft lost power. The plt ditched in the ocean. He was picked up by a passing boat & taken to Key West, FL. He stated that due to the past history of this acft, his opinion was that the cause of the…Mar 27, 1988 · N739DQ · Substantial damageNTSB LAX88LA141Accident · No injuriesLimited investigationFinal reportCessna 172RG · Malibu, CAThe pilot stated that the purpose of the flight was to allow the passenger to photograph some yachts sailing off the Malibu coast. The pilot said that he initiated a turn at 300 feet AGL around one of the yachts and the aircraft 'suddenly stalled' and he was…Mar 27, 1988 · N9609B · DestroyedNTSB 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.Mar 22, 1988 · N9272S · Substantial damageNTSB DEN88GA088Accident · No injuriesFinal reportBell 47G-3B1 · Gobernador, NMThe commerical plt was hovering out of ground effect at 40 feet AGL. During a maneuver he reported hearing a loud bang and the rotor RPM began to decay. The plt made a hovering autorotation resulting in a hard landing. The main rotor struck the tail boom and…Mar 21, 1988 · N7863S · Substantial damageNTSB MKC88LA064Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Manter, KSWhile conducting a team aerial application operation, the trailing aircraft struck the terrain with the right wing tip, rotated in a flat attitude about 2 turns, and was destroyed by fire. The pilot said, while in a downwind procedure turnaround, into the…Mar 20, 1988 · N21653 · DestroyedNTSB ATL88LA120Accident · Serious injuriesLimited investigationFinal reportSlingsby Dart T-51 · Whitwell, TNThe glider was observed to make a normal release. While still in a turn it encountered a wind shear and rolled into a vertical bank. It sideslipped for a few seconds then the nose dropped into a vertical dive. The pilot stated that when he attempted to pull…Mar 20, 1988 · N209K · DestroyedNTSB FTW88LA081Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Weatherford, TXA forced landing was attempted following a complete eng failure. The plt overshot the intended touchdown pt and pulled the acft off the grnd in an attempt to clear a busy hwy. however, the acft struck wires located next to the road. Evidence indicated that…Mar 19, 1988 · N10842 · DestroyedNTSB SEA88LA058Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gold Bar, WAThe instructor pilot and his dual student flew into a canyon area. The aircraft was allowed to fly too close to rising terrain which the aircraft was unable to outclimb. During a turn to reverse direction the aircraft collided with terrain. The CFI stated…Mar 17, 1988 · N4932H · Substantial damageNTSB 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…Mar 17, 1988 · N82782 · DestroyedNTSB LAX88DVD03Accident · Serious injuriesFinal reportPaxton RV-3A · Antioch, CAWhile performing aerobatic maneuvers, the aircraft was seen to have entered a spin. At approximately 300 feet the aircraft recovered, however, the left wing was seen to be bent upward and the fiberglass tip was dangling from the wing. The aircraft impacted…Mar 15, 1988 · N87JP · DestroyedNTSB ATL88LA115Accident · No injuriesLimited investigationFinal reportCessna 172K · Butler, ALThe plt rptd that he observed the engine oil pressure indication drop to zero during a low-level pipeline patrol flight. He attempted to increase engine pwr and initiate a climb, but the engine began to run rough. He subsequently landed on the pipeline…Mar 15, 1988 · N78840 · Substantial damageNTSB ATL88LA111Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Maiden, NCThe aircraft had been flying a series of low level maneuvers over the city. The pilot was attempting to recover from an intentional spin close to the ground when the aircraft struck utility lines and impacted the ground.Mar 13, 1988 · N23899 · Substantial damageNTSB MIA88LA125Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Jacksonville, FLThe pilot stated that he did not visually check the fuel quantity prior to departure on an aerial photography flight. About .9 hours after takeoff the engine failed due to fuel exhaustion. The pilot executed a forced landing and the aircraft crashed. Both the…Mar 11, 1988 · N22CE · Substantial damageNTSB LAX88LA126Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A-1 · Oceanside, CAThe non-U.S. Certificated pilot lost control of the helicopter while hovering 3-FT AGL during a maintenance test flight. The acft descended, touched down hard and rolled over. The non-english speaking pilot immediately departed the scene & reportedly headed…Mar 11, 1988 · N73969 · DestroyedNTSB ANC88LA039Accident · No injuriesLimited investigationFinal reportCessna 207 · Ruby, AKThe aircraft was over the airport at 2,000 feet MSL when the engine quit. The aircraft crashed one mile north of the airport. Examination of the aircraft engine revealed a broken throttle control which would cause the engine to go to idle.Mar 11, 1988 · N70364 · Substantial damageNTSB ATL88IA108Incident · No injuriesIncident investigationFinal reportBoeing 737 · Greensboro, NCContinental flt 458 (Boeing 737, N13331) was flying NE at FL370 as Continental flt 703 (Boeing 737, N432PE) was flying fm the opposite drctn at FL350. Both flts were on the same freq, being ctld by atlanta ARTCC (sector 47) ctlr, who had just come on duty. In…Mar 10, 1988 · N13331 · 2 aircraft · No damageNTSB MIA88LA121Accident · No injuriesLimited investigationFinal reportSchleicher K-8B · Miami, FLThe plt stated that he had placed the glider into a mild dive & was indicating 90 to 95 mph, well below redline speed when the whole section of the trailing edge of the wing from the aft spar & wing root out to a dist of about 6 ft, separated from the acft.…Mar 7, 1988 · N4663S · Substantial damageNTSB MIA88LA203Accident · Serious injuriesLimited investigationFinal reportHunter Velocity · Merritt Island, FLWhile checking the stall characteristics of a homebuilt acft, the acft descended in a stalled condition until crashing into a river. The plt was unable to lower the nose. Investigation revealed that he improperly positioned baffles in the fuel tanks resulting…Mar 4, 1988 · N128JM · Substantial damageNTSB DEN88DTM01Accident · Serious injuriesFinal reportCessna 188 · Riverton, UTThis ag operator was fertilizing a field. He was making repetative trips which took about 10 min each. The plt was aware that the fuel gauges were inaccurate, reading less fuel than was actually onboard. While making a swath run the eng lost pwr and the acft…Mar 2, 1988 · N8073V · DestroyedNTSB MIA88LA118Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbus, MSThe plt stated that he was simulating a loss of power & then attempting to turn back to the arpt & land on the runway that they departed from. As he was turning back from an approximate altitude of 600 feet, the acft stalled & crashed.Feb 29, 1988 · N65532 · Substantial damageNTSB BFO88FID01Accident · 2 fatalFinal reportPerkins Christen Eagle II · Williamsburg, VAWitnesses saw the acft performing aerobatics which included loops and rolls. The acft was climbing in a loop when it suddenly pitched down and descended to the ground. Some witnesses said the acft was spinning as it descended.Feb 28, 1988 · N115MC · DestroyedNTSB NYC88LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · North Hanover, NJThe eng lost power while the acft was circling at aprx 1500 ft AGL & the occupants were engaged in aerial photography. Subsequently, the acft was damaged during an emergency landing in a swampy area. An exam of the acft revealed the left tank was empty. The…Feb 26, 1988 · N738MX · Substantial damage