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 CHI90LA179Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOInadequate visual outlook by the PIC.Jul 20, 1990 · N16088 · Substantial damageNTSB ANC90LA121Accident · No injuriesLimited investigationFinal reportCessna 150M · Goose Bay, AKA loss of engine power for undetermined reasons. The wet tundra was a contributing factor.Jul 19, 1990 · N66277 · Substantial damageNTSB NYC90LA165Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1 · Highland, NYOff airport landing in unsuitable terrain due to a power loss for unknown reasons.Jul 17, 1990 · N1404R · Substantial damageNTSB SEA90LA137Accident · No injuriesLimited investigationFinal reportSikorsky S-58BT · Ovando, MTThe pilot did not maintain rotor RPM after a compressor assembly blade failure. A related factor was an inadequate autorotation resulting in a hard landing.Jul 16, 1990 · N439DS · Substantial damageNTSB FTW90FA141Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Garfield, COThe pilot's decision to fly into the mountain pass and the subsequent inability to maintain adequate ground clearance.Jul 15, 1990 · N8102C · DestroyedNTSB ATL90FA144Accident · 1 fatalField investigationFinal reportCessna 305A · Fruitdale, ALThe pilot exercised poor judgment by attempting to operate the airplane while impaired by alcohol.Jul 15, 1990 · N5301G · DestroyedNTSB LAX90DUG08Accident · 2 fatalFinal reportSelstad VARI-EZE · Corona, CAThe failure of the pilot to maintain control of the aircraft. Factors related to the accident were: the pilot's lack of experience in the type of aircraft, his impairment from consumption of alcohol, and inadequate altitude to recover from the loss of control.Jul 14, 1990 · N1336K · DestroyedNTSB LAX90LA256Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Santa Catalina, CAThe engine failure due to carburetor ice and the pilots improper use of carburetor heat.Jul 13, 1990 · N1398Q · DestroyedNTSB NYC90FA156Accident · No injuriesField investigationFinal reportBell 206 B3 · Teterboro, NJFailed power turbine shaft. Factors in the accident were corrosion on the power turbine shaft and inadequate manufacturer's service bulletins.Jul 10, 1990 · N73LM · Substantial damageNTSB NYC90LA150Accident · Serious injuriesLimited investigationFinal reportBeech BE-58 · St. Albans, VTFlight into trees while recovering from an inadvertent spin after a pilot used incorrect procedures during a simulated engine failure below VMC and the instructor pilot delayed the corrective actions.Jul 9, 1990 · N335T · Substantial damageNTSB LAX90LA246Accident · No injuriesLimited investigationFinal reportSchweizer 300C · San Jose, CAThe pilot's loss of directional control. A factor in the accident was his inadequate compensation for wind conditions.Jul 7, 1990 · N917JS · Substantial damageNTSB FTW90FA138Accident · 1 fatalField investigationFinal reportMingess-Bennett M30 · New Braunfels, TXFailure of the pilot in the overtaking aircraft (N97RJ) to see-and-avoid the aircraft that had been leading (N911HG). Factors related to the accident were: the lack of ability for the pilot in the lead aircraft (911HG) to be able see other aircraft in the…Jul 7, 1990 · N97RJ · 2 aircraft · DestroyedNTSB FTW90LA133Accident · 1 fatalLimited investigationFinal reportBell 206B · San Antonio, TXThe lineman/flight crewman not following procedures.Jul 6, 1990 · N3894L · No damageNTSB SEA90LA121Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Walla Walla, WAA loss of engine power for undetermined reasons.Jul 4, 1990 · N62431 · Substantial damageNTSB LAX90FA244Accident · 1 fatalField investigationFinal reportCessna 172N · Avalon, CAThe pilot's improper in-flight planning, decision, and his intentional low flying near mountainous terrain. Contributing factors related to the pilot's not maintaining/following proper VFR procedures, the related distraction of the open cabin door, and the…Jul 4, 1990 · N2810E · DestroyedNTSB NYC90LA144Accident · Minor injuriesLimited investigationFinal reportRolladen-Schneider LS-3 · South Mountain, PAThe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall.Jul 3, 1990 · N41MP · Substantial damageNTSB FTW90LA130Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · San Antonio, TXPilot's failure to maintain adequate speed. Contributing to the accident was the momentary power loss.Jul 2, 1990 · N66302 · Substantial damageNTSB FTW90DRG04Accident · No injuriesFinal reportAir Tractor AT-301 · Mission, TXThe pilot's failure to maintain proper clearance above the crops he was spraying. A factor was the tree induced mechanical turbulence encountered during the descending turn.Jul 2, 1990 · N3653W · Substantial damageNTSB SEA90LA117Accident · No injuriesLimited investigationFinal reportDickey E-RACER · Jackpot, NVAn undetermined failure or anomaly of the exhaust system, which resulted in an in-flight fire of the fiberglass structure of the aircraft and failure of the aircraft braking system.Jul 1, 1990 · N131RD · Substantial damageNTSB NYC90LA142Accident · 1 fatalLimited investigationFinal reportNorth American AT-6 · Buffalo, NYLoss of control in flight due to physical impairment. Factors related to the accident were: the pilots use of an over the counter antihistamine.Jul 1, 1990 · N44ZZ · DestroyedNTSB MKC90LA143Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Marshalltown, IAInadequate visual lookout and clearance not obtained.Jul 1, 1990 · N70147 · DestroyedNTSB NYC90LA143Accident · 1 fatalLimited investigationFinal reportBoeing A75L3 · Groton, CTAn impact with the ground following an improperly executed roll with insufficient altitude for recovery. Factors related to the accident were improper use of the flight controls by the pilot.Jun 30, 1990 · N1205V · Substantial damageNTSB DEN90FA149Accident · 2 fatalField investigationFinal reportTaylorcraft BC 12-D · Homedale, IDThe failure of the pilot to maintain adequate airspeed during maneuvers (buzzing) which resulted in an inadvertent stall of the aircraft. A factor was the intentional buzzing of family members.Jun 30, 1990 · N5071M · Substantial damageNTSB LAX90LA234Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Carlsbad, CAFailure of the pilot to maintain directional control at a hover.Jun 29, 1990 · N1102H · Substantial damageNTSB DEN90LA147Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Center, COThe pilot's failure to maintain flying speed, which resulted in a stall and collsion with the ground.Jun 29, 1990 · N1255W · Substantial damageNTSB MIA90LA146Accident · No injuriesLimited investigationFinal reportAyres S-2R · Fort Pierce, FLEngine failure due to failure of the engine driven fuel pump shaft due to undetermined reasons.Jun 27, 1990 · N4909X · DestroyedNTSB MKC90LA138Accident · No injuriesLimited investigationFinal reportHiller 12-E · Watson, MNPilot misjudged his flare and collided with the terrain.Jun 26, 1990 · N62397 · Substantial damageNTSB CHI90DEE07Accident · Minor injuriesFinal reportSchweizer G-164B · Deer Grove, ILThe pilot's inadequate visual lookout, resulting in collision with a power line.Jun 26, 1990 · N8483K · Substantial damageNTSB DEN90LA144Accident · Serious injuriesLimited investigationFinal reportCessna C-152 · Golden, COThe pilot's disregard for airplane performance data. Contributing to the accident were high density altitude and the fact that airplane climb performance capability was exceeded.Jun 24, 1990 · N757KL · Substantial damageNTSB LAX90FA230Accident · No injuriesField investigationFinal reportHughes 369D · Hanapepe, HIFailure of pilot of the photographing helicopter to maintain clearance and avoid collision.Jun 23, 1990 · N8605F · 2 aircraft · Substantial damageNTSB FTW90DQG03Accident · 1 fatalFinal reportNorth American P-51D · Abilene, TXFailure of the pilot to maintain adequate airspeed, while maneuvering after a low pass, which resulted in an inadvertent stall. The high density altitude was a related factor.Jun 23, 1990 · N12700 · DestroyedNTSB NYC90DGM02Accident · 1 fatalFinal reportBell 47D1 · Meadville, PAThe pilot's failure to see and avoid the power lines.Jun 22, 1990 · N310A · DestroyedNTSB MKC90LA135Accident · No injuriesLimited investigationFinal reportCallair A-9 · Barrett, MNInadequate visual outlook and a delayed pull-up by the pilot in command.Jun 22, 1990 · N9621Z · Substantial damageNTSB DEN90LA140Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Hazelton, NDThe failure of the pilot in command to maintain adequate visual lookout during aerial application maneuvering.Jun 22, 1990 · N4988Y · DestroyedNTSB DEN90FA139Accident · 2 fatalField investigationFinal reportPiper PA-18 · Laurel, MTThe pilot's failure to maintain proper clearance from other objects wwhile maneuvering.Jun 22, 1990 · N9926D · DestroyedNTSB ATL90LA134Accident · No injuriesLimited investigationFinal reportHughes 269C · Saluda, SCPilot's failure to properly plan for high density altitude operations, which resulted in settling with power to the ground.Jun 22, 1990 · N7448F · Substantial damageNTSB SEA90LA105Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDThe pilot did not maintain a proper altitude while maneuvering to reverse direction.Jun 21, 1990 · N4530N · Substantial damageNTSB NYC90FA135Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Greenville, MEFailure of the pilot to maintain the proper altitude, while searching for the destination airport at night. Factors related to the accident were: darkness, fog obscuring the destination airport lights, mountainous terrain, and the lack of visual perception at…Jun 19, 1990 · N44897 · DestroyedNTSB FTW90FA120Accident · 1 fatalField investigationFinal reportSukhoi SU-26MX · Oklahoma City, OKFailure of the pilot to recover from the aerobatic maneuver and subsequent stall/spin, due to inadequate altitude. Fatigue may have been a related factor.Jun 17, 1990 · N26TJ · DestroyedNTSB BFO90LA058Accident · No injuriesLimited investigationFinal reportCessna 150 · Alderson, WVThe pilot's failure to maintain adequate airspeed, causing the aircraft to stall. Low altitude and inattention were related factors.Jun 17, 1990 · N5964E · Substantial damageNTSB MKC90LA134Accident · No injuriesLimited investigationFinal reportWeatherly 201-B · Stuttgart, ARFuel exhaustion induced power loss caused by the pilot's failure to refuel the airplane.Jun 16, 1990 · N1260W · Substantial damageNTSB MKC90FA130Accident · 3 fatalField investigationFinal reportBell 47G-3B1 · Cedar Rapids, IAThe failure of the pilot to maintain control of the helicopter during maneuvering flight. Darkness and the pilot's manner of flying the aircraft (ostentatious display) were considered to be related factors.Jun 16, 1990 · N67223 · Substantial damageNTSB 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.Jun 16, 1990 · N3KJ · DestroyedNTSB MKC90LA129Accident · No injuriesLimited investigationFinal reportRockwell S2R · Tilton, ARFailure of the engine blower(supercharger). Related to the accident was the soft/wet terrain, where the forced landing was performed.Jun 15, 1990 · N8421V · Substantial damageNTSB MKC90LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Ulysses, KSFailure of the powerplant cylinder and stall/mush encountered by the pilot in command.Jun 15, 1990 · N3650Z · Substantial damageNTSB LAX90DVA06Accident · No injuriesFinal reportRay Edmistonn Z-200 · Selma, CAA loss of engine power for undetermined reasons.Jun 15, 1990 · N10LM · Substantial damageNTSB DEN90FA135Accident · 2 fatalField investigationFinal reportCessna TU206G · Challis, IDThe pilot's entry into an excessive maneuver after takeoff with insufficient altitude and airspeed to complete the maneuver, which resulted in a stall/mush into trees. Factors related to the accident were: high density altitude and trees.Jun 15, 1990 · N7582N · DestroyedNTSB CHI90DEM04Accident · 1 fatalFinal reportVanek 300 · Vriesland, MIThe pilot's misjudgment of the altitude. A factor related to the accident was the low ceiling.Jun 14, 1990 · N359VE · DestroyedNTSB MKC90LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Fisher, ARPartial loss of engine power for an undetermined reason.Jun 12, 1990 · N5257 · DestroyedNTSB SEA90FA100Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Pocatello, IDThe instructor pilots poor judgement in performing low altitude steep turn maneuvers resulting in an inadvertant stall at an altitude too low for recovery. Factors in the accident were the over gross weight and out-of-cg aircraft loading, and strong gusty…Jun 11, 1990 · N1877G · Destroyed