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 MIA89FA101Accident · 1 fatalField investigationFinal reportNorth American T-28C · Titusville, FLThe pilot's improper execution of an aerobatic maneuver resulting in inadequate airspeed and loss of control.Mar 10, 1989 · N775CH · DestroyedNTSB DEN89LA084Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Golden, COImproper in-flight planning/decision by the CFI which resulted in loss of tail rotor effectiveness and loss of directional control. Contributing factors were high density altitude, tailwind, and rough/uneven terrain.Mar 9, 1989 · N7411N · Substantial damageNTSB MIA89FA098Accident · 2 fatalField investigationFinal reportCessna 152 · Fort Lauderdale, FLInstructor pilots failure to maintain control of the aircraft resulting in a collision with terrain.Mar 6, 1989 · N47115 · DestroyedNTSB SEA89LA052Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Forrest Grove, ORThe pilot's misjudgment of his altitude and clearance while attempting to sling-load a trailer.Mar 3, 1989 · N7505Y · Substantial damageNTSB FTW89LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Bastrop, TXInadequate preflight planning and preparation by the pilot which resulted in fuel exhaustion. Contributing to the accident were the low ceilings and fog.Mar 3, 1989 · N7407T · Substantial damageNTSB LAX89DVA06Accident · Serious injuriesFinal reportGrumman G-164A · Riverdale, CAInadequate visual lookout by the pilot, when he diverted his attention. The power line was a related factor.Mar 1, 1989 · N8547H · DestroyedNTSB FTW89DQA01Accident · Minor injuriesFinal reportIntermountain Mfg. Callair A-9B · El Paso, TXEngine failure due to the pilot's failure to select the fullest tanks and, failure to maintain adequate flying speed.Feb 26, 1989 · N375MC · Substantial damageNTSB ANC89LA046Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Sulatna River, AKThe pilot's failure to maintain control of the airplane which resulted in a stall.Feb 22, 1989 · N1243A · Substantial damageNTSB MIA89LA087Accident · Minor injuriesLimited investigationFinal reportHarmon Velocity · Fort Lauderdale, FLThe inability of the pilot to recover from the intentional stall with an unknown c.g.Feb 17, 1989 · N330RH · Substantial damageNTSB ATL89FA088Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Jackson, GAThe pilot's improper handling of the airplane which resulted in an inadvertent stall/spin and subsequent collision with terrain. Factors contributing to the accident were the pilot's decision to perform aerobatic maneuvers at low altitude, and complacency…Feb 16, 1989 · N4126Y · DestroyedNTSB LAX89LA110Accident · No injuriesLimited investigationFinal reportCessna 152 · Green Valley, AZThe student pilot displayed poor judgement in not maintaining proper altitude. A factor contributing to the accident was the pilot's overall lack of experience.Feb 12, 1989 · N5496B · Substantial damageNTSB ATL89FA086Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Jasper, TNThe pilot's improper handling of the airplane flight controls at low altitude which resulted in an excessive rate of descent and collision with a tree.Feb 12, 1989 · N588FL · DestroyedNTSB NYC89FA080Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Lyon Mountain, NYThe pilot decided to fly in weather conditions that were beyond his and the aircraft's capabilities.Feb 11, 1989 · CGBHN · DestroyedNTSB ATL89DKG01Accident · No injuriesFinal reportGrumman G-164A · Dawson, GATotal loss of engine power due to leaking carburetor float. Contributing to the accident was the soft terrain used for a forced landing.Feb 10, 1989 · N9755 · Substantial damageNTSB SEA89LA048Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Cottonwood, IDThe pilot misjudging his altitude due to the white out conditions. Contributing to the accident was the pilots lack of experience in this aircraft and this type of operation.Feb 8, 1989 · N5620X · Substantial damageNTSB MIA89LA081Accident · No injuriesLimited investigationFinal reportBell TH-1L · Greenville, FLInstallation of the improper sprag clutch assembly by the owners maintenance personnel resulting in failure of the sprag clutch and the loss of transmission drive.Feb 8, 1989 · N204AP · Substantial damageNTSB ANC89LA040Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot's failure to compensate for the gusty wind conditions and to maintain control of the airplane. Contributing to the accident was the gusty winds.Feb 6, 1989 · N7049 · Substantial damageNTSB MIA89LA079Accident · No injuriesLimited investigationFinal reportStolp-Adams SA100 · Indian Rocks, FLThe pilot's attempt to perform aerobatic maneuvers in an aircraft that was not equipped with fuel and oil systems that would continue to operate in inverted positions. This action resulted in a loss of power and the pilot having to ditch the aircraft.Feb 4, 1989 · N511U · Substantial damageNTSB MIA89LA076Accident · Minor injuriesLimited investigationFinal reportWaco YMF · Key West, FLThe inability of the plt to maintain control after encountering his own wake turbulence at a low altitude during a steep turning maneuver.Feb 3, 1989 · N99Y · Substantial damageNTSB LAX89DVA03Accident · Serious injuriesFinal reportBell 47G-3B2 · Strathmore, CAImproper compensation for wind conditions by the pilot, and his failure to maintain clearance from the service truck. Factors relating to the accident were: the unfavorable (variable) and gusty wind conditions and close proximity of the service vehicle.Feb 1, 1989 · N2918W · DestroyedNTSB LAX89FA093Accident · 1 fatalField investigationFinal reportGrumman AA5A · Lake View, CAThe pilot's inadvertent flight into a box canyon.Jan 22, 1989 · N26313 · DestroyedNTSB LAX89FA092Accident · 2 fatalField investigationFinal reportRobinson R22A · Santa Barbara, CAFailure of the pilot to maintain adequate altitude, proper airspeed for the reduced visibility, and an adequate visual outlook to avoid a collision with power transmission cable. Contributing to the accident was reduced visibility due to fog.Jan 22, 1989 · N8529C · DestroyedNTSB MKC89FA055Accident · 1 fatalField investigationFinal reportChampion 7EC · Luxemburg, MNThe pilot failed to maintain adequate airspeed which resulted in a stall and loss of aircraft control. The pilot's failure to observe weight and balance limitations of the aircraft was a contributing factor.Jan 21, 1989 · N7596E · DestroyedNTSB LAX89LA087Accident · No injuriesLimited investigationFinal reportCessna T207A · Page, AZImproper in-flight planning/decision by the pilot and his inadequate visual lookout (failure to see-and-avoid the obstruction). Factors related to the accident were: the birds, the pilot's excessive maneuver, and the transmission line.Jan 17, 1989 · N6347H · Substantial damageNTSB ANC89LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Big Lake, AKThe student pilot's failure to follow procedures during the simulated forced landing. Contributing to the accident were the extreme temperatures.Jan 16, 1989 · N6414K · Substantial damageNTSB LAX89DUJ03Accident · 1 fatalFinal reportMurphey Vancraft 532 · Tucson, AZInadequate lookout by the pilot during unwarranted low flight.Jan 15, 1989 · N61LM · DestroyedNTSB BFO89LA015Accident · No injuriesLimited investigationFinal reportCessna 150 · Winchester, VAPartial loss of engine power for an unknown reason. Soft terrain was a contributing factor.Jan 14, 1989 · N714CR · Substantial damageNTSB ANC89LA033Accident · No injuriesLimited investigationFinal reportHughes 500-D · Bell Mountain, AKThe pilot's misjudgment of his clearance above the terrain due to distorted visual perception. Contributing to the accident was the whiteout condition.Jan 12, 1989 · N5074R · Substantial damageNTSB ATL89LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · Theodore, ALPilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall, and subsequent collision with the ground.Jan 4, 1989 · N69015 · Substantial damageNTSB FTW89LA036Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · S.Timbalier 151A collision between the aircraft and the platform during the emergency autorotation which caused the left skid and float to separate and destabilized the autorotation. The collision was probably unadoidable due to the maneuver that was being conducted at the…Jan 3, 1989 · N22704 · DestroyedNTSB SEA89LA029Accident · Minor injuriesLimited investigationFinal reportBell 47G3-B1 · Newberg, ORAs plt slowed helicopter to about 10 KTS forward speed, tail rotor effectiveness decreased. Acft yawed right into descent to ground contact.Dec 26, 1988 · N8587F · Substantial damageNTSB ATL89FA059Accident · 2 fatalField investigationFinal reportCessna 172 · Wadsworth, OHPIC & future son-in-law came to arpt to fly acft. Wx was low ceilings & viz due to fog. PIC did not have instrument rating. The son-in-law, an army captain, was sked to leave for overseas assignment shortly. Closest arpt which rpted wx, 15 miles southeast,…Dec 24, 1988 · N8193B · DestroyedNTSB MIA89LA056Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Crystal River, FLThe plt stated that he was giving a friend a ride in the acft when he inadvertantly struck powerlines and crashed in shallow water.Dec 23, 1988 · N1025J · Substantial damageNTSB NYC89FA053Accident · 2 fatalField investigationFinal reportCessna 414 · Franklin Twp, PABefore takeoff, the crew indcd the flt would be for 'check rides' & that they planned to 'shoot approaches' & proceed to the practice area to do some airwork. ATC advised the plts that the cloud bases were at 3500 feet MSL. Elevation of the terrain (where the…Dec 22, 1988 · N244RM · DestroyedNTSB FTW89DPJ02Accident · 2 fatalFinal reportErcoupe 415C · Oklahoma City, OKDuring flight, the airplane appeared to go into a steep banked spiral from which it did not recover. It struck a two-car detached garage and then the ground. Inspection revealed that the fabric of both wings had been installed improperly, and part of the…Dec 21, 1988 · N99636 · DestroyedNTSB DEN89FA045Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Elephant Butte, NMDuring a return flight from having maintenance performed on the acft the plt executed a low pass by his home which was located on a point of land overlooking Elephant Butte reservoir, NM. During the maneuver while in a steep turn the left wing struck the…Dec 21, 1988 · N751SP · DestroyedNTSB DEN89LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe plt was flying a cross-country flight. She said that 3 miles from her destination, the engine quit when the plane ran out of fuel. A landing on an ice covered asphalt road was performed. During roll out, the left main gear went off the road and the left…Dec 16, 1988 · N49209 · Substantial damageNTSB NYC89LA049Accident · No injuriesLimited investigationFinal reportCessna 150L · Greenwich, CTTrees during an off airport landing after the aircraft expererienced a power loss fue to fuel starvation.Dec 12, 1988 · N6538G · Substantial damageNTSB LAX89LA063Accident · No injuriesLimited investigationFinal reportHughes 369E · Hanalei, HIDuring a local sightseeing flight, the pilot reported that he heard a muffled bang and simultaneously the engine out warning lights and audio alarm activated. The pilot initiated a forced landing on the beach which resulted in the helicopter nosing over. An…Dec 12, 1988 · N7733H · Substantial damageNTSB FTW89DRA01Accident · Minor injuriesFinal reportHughes 369D · Kountze, TXFalse indications of the fuel quantity system, which led the pilot to believe ha had more fuel than he did.Dec 12, 1988 · N58261 · Substantial damageNTSB CHI89LA029Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 269C · Frankfort, ILThe helicopter experienced a tree strike with the main rotor blades and then rolled over when it struck the ground during a precautionary landing attempt. The helicopter had been conducting contract power line patrol when the PIC noted an apparent partial…Nov 28, 1988 · N1098P · Substantial damageNTSB ATL89FA045Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Concord, NCPIC & wife flew to local residential area to photograph a house. The acft was flown in the vicinity of the accident for about 30 minutes. Radar data displayed the acft in a level left turn at 2300 feet (1700 AGL) for about 50 seconds when contact was abruptly…Nov 26, 1988 · N98369 · DestroyedNTSB CHI89FA027Accident · 2 fatalField investigationFinal reportGulfstream AA1A · North Vernon, INThe aircraft was observed to make a high speed low level pass adjacent to the runway and a climbing left turn away from the airport, heading north. A witness in a field north of the airport reported seeing the aircraft descending from a low altitude, level…Nov 24, 1988 · N9396L · DestroyedNTSB LAX89LA053Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Santa Maria, CADuring a pleasure flight, the airplane was being flown along a ridgeline while the pilot and passenger were looking for an old airplane wreck. The pilot was distracted and did not notice the airplane was entering a canyon and rising terrain. When the pilots…Nov 19, 1988 · N6883F · Substantial damageNTSB 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.Nov 17, 1988 · N3RJ · DestroyedNTSB ATL89LA038Accident · Serious injuriesLimited investigationFinal reportCessna 152F · Harkers Island, NCThe plt rprtd he was orbiting over a school of fish at aprx 800' when he encountered wake turbulence from his own acft. He believed that a wider orbit would have prevented him from flying back into the wake & additional altitude would have provided more time…Nov 15, 1988 · N8225F · DestroyedNTSB FTW89DQG02Accident · 1 fatalFinal reportPiper PA-25 · Amarillo, TXFailure on the part of the pilot to maintain the proper airspeed for the maneuver being performed, followed by a stall at an altitude insufficient to recover.Nov 14, 1988 · N8547L · DestroyedNTSB CHI89DEV02Accident · 1 fatalFinal reportAir Command 503 · Sullivan, ILThe pilot failed to maintain control of the aircraft.Nov 13, 1988 · UNREG · DestroyedNTSB ATL89FA036Accident · 2 fatalField investigationFinal reportCessna 152 · Arcadia, FLAircraft departed on a cross country instructional flight. The aircraft landed for fuel at orlando int'l and departed VFR. There were no witnesses. The accident site was located by ELT signal in a treeline that bordered the west end of a large open pasture.…Nov 13, 1988 · N69175 · DestroyedNTSB LAX89LA046Accident · No injuriesLimited investigationFinal reportUnivair Taylorcraft BC12-D · Kawaihae, HIDuring a pleasure flight, the pilot intentionally shut down the engine and was flying the airplane similar to a sailplane. To restart the engine, he would dive the airplane to attain enough speed to windmill the prop. Just before the accident, he allowed the…Nov 12, 1988 · N5496V · Substantial damage