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 CHI90DEC01Accident · 2 fatalFinal reportMoore Acroduster II SA750 · New Haven, MIThe pilot's the improper execution and/or recovery from an aerobatic maneuver (inverted flat spin), which resulted in a collision with the terrain.Apr 29, 1990 · N103GM · DestroyedNTSB CHI90FA118Accident · 1 fatalField investigationFinal reportSikorsky S-58F · Southfield, MIA loss of control due to physical incapacitation for unknown reason(s).Apr 28, 1990 · N871 · DestroyedNTSB NYC90DNA02Accident · No injuriesFinal reportBell 47G5 · Marion, MAImproper use of carburetor heat by the pilot resulting in a loss of engine power. The lack of suitable terrain for a forced landing was a factor.Apr 26, 1990 · N8591F · Substantial damageNTSB MKC90LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Allport, ARImproper use of carburetor heat by the pilot. Contributing factors were carburetor icing conditions, power lines and visual outlook inadequate by the pilot.Apr 24, 1990 · N50973 · Substantial damageNTSB DEN90FA099Accident · 2 fatalField investigationFinal reportPiper PA-22-160 · Scranton, NDPilot factor in that he failed to maintain aircraft control while performing an inflight maneuver.Apr 24, 1990 · N2911Z · DestroyedNTSB ATL90DLQ01Accident · No injuriesFinal reportBell 47D1 · Hickman, KYImproper in-flight planning/decision by the pilot. The resultant tailwind was a related factor.Apr 24, 1990 · N2134 · Substantial damageNTSB ATL90FA100Accident · 1 fatalField investigationFinal reportBell 205A-1 · Moncks Corner, SCThe in-flight separation of the main rotor because of the failure of a pillow block bolt, and the failure of the operator/repair station to follow the overhaul procedures.Apr 20, 1990 · N67HJ · DestroyedNTSB LAX90DUG05Accident · 1 fatalFinal reportGrumman G-164B · Blythe, CAFailure of the pilots of N6708K and N10222 to maintain adequate visual lookout and failure of the pilot of N6708K to follow a prearanged procedure for reversing the direction of flight.Apr 19, 1990 · N6708K · 2 aircraft · DestroyedNTSB CHI90LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Franklin, INThe pilot's improper planning/decision in choosing to continue flight to the destination airport without refueling. The dark night conditions, and a known intermittent radio problem were contributing factors.Apr 18, 1990 · N4698Z · Substantial damageNTSB CHI90DEV03Accident · Minor injuriesFinal reportBellanca 8KCAB · Lawrenceville, ILThe student pilot failure to maintain flying speed. Contributing to the accident was the flight instructor in that the instructor allowed the student to let the airspeeed dissipate below stall speed.Apr 16, 1990 · N50671 · Substantial damageNTSB ATL90LA098Accident · 1 fatalLimited investigationFinal reportCessna 150H · N. Myrtle Beach, SCThe pilot's improper course reversal procedure which resulted in a stall at a low altitude precluding a recovery before water impact.Apr 16, 1990 · N22953 · Substantial damageNTSB ATL90DLT01Accident · No injuriesFinal reportGrumman G-164B · Tiptonville, TNA loss of engine power for undetermined reasons. A factor in the accident was the rough terrain.Apr 16, 1990 · N6683K · Substantial damageNTSB ANC90FA061Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Egegik, AKFailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in a stall.Apr 16, 1990 · N95982 · Substantial damageNTSB FTW90DPJ05Accident · Minor injuriesFinal reportBell 47G-4A · Bixby, OKLoss of control due to undetermined mechanical failure.Apr 14, 1990 · N2238W · DestroyedNTSB SEA90FA065Accident · Serious injuriesField investigationFinal reportCessna 172M · Incline Village, NVImproper in-flight planning/decision by the instructor pilot (CFI), and his failure to maintain adequate altitude and clearance from obstructions. Factors related to the accident were: mountainous terrain, high density altitude, and the trees (obstructions).Apr 13, 1990 · N9021H · DestroyedNTSB FTW90DRD05Accident · No injuriesFinal reportSchweizer G-164B · Reeves, LALoss of engine power due to a frozen rocker arm.Apr 13, 1990 · N48455 · Substantial damageNTSB ANC90LA060Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKThe pilot-in-command's failure to maintain the proper altitude.Apr 13, 1990 · N9964M · Substantial damageNTSB ANC90LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Knik Clacier, AKA foreign object (tool) had jammed the aileron controls to the right as the pilot was maneuvering the aircraft for a low approach to a strip.Apr 13, 1990 · N4904M · Substantial damageNTSB ANC90LA054Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKImproper installation of the fuel valve.Apr 13, 1990 · N40872 · Substantial damageNTSB MKC90LA083Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Harrisburg, ARFailure of the generator, and failure of the pilot to maintain rotor RPM.Apr 12, 1990 · N4779U · Substantial damageNTSB MIA90FA102Accident · 1 fatalField investigationFinal reportFarrington AIR Command 532 · Okeechobee, FLPilot's decision to attempt to fly the gyrocopter without proper training resulting in the inflight loss of control and subsequent crash.Apr 7, 1990 · N532RC · DestroyedNTSB LAX90FA135Accident · 1 fatalField investigationFinal reportGardner Pitts S-1 · Eloy, AZThe pilot delayed the recovery from the inverted flat spin maneuver and misjudged his altitude.Apr 4, 1990 · N104KF · DestroyedNTSB LAX90DVG04Accident · 1 fatalFinal reportGrumman G-164B · Esparto, CAThe pilot misjudged the airplane's clearance with the transmission wires.Apr 4, 1990 · N8011K · DestroyedNTSB FTW90DRD04Accident · No injuriesFinal reportGrumman G-164B · Fenton, LAFailure of the elevator control rod end bearing.Apr 3, 1990 · N6714K · DestroyedNTSB SEA90LA060Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-2 · Hillsboro, ORThe pilot's failure to refuel resulting in fuel exhaustion.Apr 2, 1990 · N9449J · Substantial damageNTSB SEA90FA071Accident · 1 fatalField investigationFinal reportNorth American Navion H · Enumclaw, WAPilot's inadequate preflight planning, and inadvertent flight into IMC conditions. Factors in the accident were the low ceiling and visibility weather conditions, the mountainous/hill terrain, the pilot's lack of instrument qualification and his lack of…Apr 2, 1990 · N285RM · DestroyedNTSB MKC90LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Ankeny, IAFuel contamination and inadequate aircraft preflight by the pilot in command.Mar 26, 1990 · N2254J · Substantial damageNTSB CHI90LA102Accident · No injuriesLimited investigationFinal reportRobinson R22 · Phillipsburg, OHThe failure of the pilot to retain control of the aircraft.Mar 24, 1990 · N80450 · Substantial damageNTSB FTW90DPJ03Accident · Minor injuriesFinal reportPiper PA36-400 · Temple, OKFailure of an aileron attachment (bolt) due to fatigue.Mar 22, 1990 · N2331X · Substantial damageNTSB MKC90LA067Accident · No injuriesLimited investigationFinal reportGrumman AG-CAT G-164A · Parkin, ARTotal failure of the engine's master connecting rod.Mar 17, 1990 · N5336 · Substantial damageNTSB ANC90FA039Accident · 1 fatalField investigationFinal reportPiper PA-32-301 · Almautlak, AKThe pilot's loss of control of the airplane because of spatial disorientation. The weather conditions prevailing at the time were factors relating to the accident.Mar 16, 1990 · N8290T · DestroyedNTSB SEA90LA052Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Ashland, ORPilot displayed poor inflight planning and decisions by allowing the airplane's speed to deteriorate to the point that the airplane stalled. The pilot could not fully correct the situation due to a loss of altitude and insufficient clearance from the terrain.Mar 15, 1990 · N39205 · Substantial damageNTSB MIA90LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Mims, FLPilot's poor inflight monitoring of the a/c fuel state which resulted in fuel exhaustion and subsequent engine failure.Mar 14, 1990 · N66949 · Substantial damageNTSB NYC90FA075Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Smithfield, RIImproper in-flight planning/decision by the pilot, which resulted in insufficient altitude to recover from a stall. Factors related to the accident were: the pilot's lack of total experience and excessive gross weight of the airplane.Mar 8, 1990 · N2603G · DestroyedNTSB MKC90LA061Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Monette, ARFailure of the engine exhaust valve.Mar 6, 1990 · N8522V · Substantial damageNTSB MIA90LA082Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Alligator, MSEngine failure due to undetermined reasons resulting in the forced landing.Mar 5, 1990 · N5043X · Substantial damageNTSB DEN90LA070Accident · 1 fatalLimited investigationFinal reportChampion 7EC · Pine Ridge, SDThe failure of the pilot to maintain an adequate airspeed, after diverting his attention, which resulted in an inadvertent stall.Mar 4, 1990 · N4301C · DestroyedNTSB BFO90LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Grafton, WVThe pilot's improper use of carburetor heat, when operating at reduced power in conditions which were conducive to carburetor ice.Mar 1, 1990 · N65538 · Substantial damageNTSB SEA90FA047Accident · 2 fatalField investigationFinal reportBurton Cavalier Model 2 · Grants Pass, ORFuel exhaustion which resulted from the pilots intentionally operating the aircraft with a known deficiency. The pilot failed to maintain airspeed, resulting in a stall/spin and uncontrolled descent.Feb 27, 1990 · N7131 · DestroyedNTSB LAX90FA106Accident · 1 fatalField investigationFinal reportPiper PA28-201T · Yountville, CAThe pilot used poor judgement by attempting a v.f.r. flight to an area with forecasted instrument meteorological conditions and continuing the flight when I.f.r. conditions were encountered.Feb 27, 1990 · N8359H · DestroyedNTSB DEN90FA063Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Milliken, COThe pilot's poor judgement, intentional buzzing, and failure to see and avoid the obstruction (inadequate visual lookout). Factors related to the accident were: the power line and the absence of shoulder harnesses in the aircraft.Feb 25, 1990 · N4053H · DestroyedNTSB LAX90LA104Accident · 1 fatalLimited investigationFinal reportI.C.A. Brasov 2902.11.01.001 Lark · Orland, CAThe pilots loss of aircraft control due to the likelihood of experiencing an epileptic seizure. A factor which may have contributed to the accident was the pilot's ingestion of an anticonvulsant drug that causes drowsiness.Feb 24, 1990 · N123MR · DestroyedNTSB BFO90LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Dungannon, VAThe pilot's improper planning/decision, which resulted in fuel starvation and loss of engine power, and failure of the pilot to maintain directional control of the aircraft during the emergency landing. Factors related to the accident were: the adverse…Feb 24, 1990 · N3484W · DestroyedNTSB 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.Feb 22, 1990 · N24FD · DestroyedNTSB LAX90FA094Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Ojai, CAThe pilot's performing aerobatic maneuvers at a low altitude and failure to maintain altitude.Feb 19, 1990 · N5156T · DestroyedNTSB FTW90DRA03Accident · 1 fatalFinal reportAir Command 447 · Hearne, TXThe pilot's loss of control for undetermined reasons. A factor was the pilot's lack of total experience in the accident make and model.Feb 17, 1990 · UNREG · DestroyedNTSB LAX90LA095Accident · No injuriesLimited investigationFinal reportBell 47B3 · Redlands, CAFailure of the pilot to use carburetor heat when warrented by conditions.Feb 16, 1990 · N11HU · DestroyedNTSB FTW90LA070Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Arlington, TXPoor judgement of the pilot after consumption of alcoholic beverage, his decision to make low passes at night (buzzing), failure of the pilot to maintain proper altitude, and diversion of his attention. Darkness was a related factor.Feb 14, 1990 · N21969 · DestroyedNTSB LAX90FA088Accident · 1 fatalField investigationFinal reportBeech F-33A · Oro Valley, AZThe pilot's poor judgement in performing low level aerobatic maneuvers.Feb 12, 1990 · N3SN · DestroyedNTSB FTW90LA067Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Prue, OKFailure of the pilot to see-and-avoid the powerlines. The powerlines were a related factor.Feb 10, 1990 · N1407Y · Substantial damage