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 SEA93LA003Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Powell, WYThe pilot in command's failure to assure clearance from the radio tower. Factors contributing to the accident were the marked tower and the pilot in command's inadequate visual lookout.Oct 3, 1992 · N32889 · DestroyedNTSB LAX92LA401Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Coachella, CAThe pilot's inadequate visual lookout and his failure to maintain an adequate clearance from the wires.Sep 26, 1992 · N57BA · Substantial damageNTSB FTW92DRG01Accident · 1 fatalFinal reportStits Playboy · Fredericksburg, TXThe inadvertent stall.Sep 26, 1992 · N5579V · DestroyedNTSB ANC92LA178Accident · Minor injuriesLimited investigationFinal reportHughes 369D · George Inlet, AKThe pilot's improper in flight planning and decision and his failure to maintain altitude during the turn to reverse direction. Contributing to the accident was the calm water.Sep 25, 1992 · N58315 · Substantial damageNTSB FTW92DPG17Accident · No injuriesFinal reportCessna A188B · Holly Grove, ARThe pilot failed to maintain object clearance.Sep 24, 1992 · N4804Q · Substantial damageNTSB LAX92LA396Accident · Minor injuriesLimited investigationFinal reportBell 47-G4A · Volcano, HIThe pilot's improper use of the collective control after inadvertently entering a power settling condition.Sep 21, 1992 · N73279 · Substantial damageNTSB LAX92LA399Accident · No injuriesLimited investigationFinal reportPiper 601P · Bakersfield, CAThe pilot's selection of an inadequate altitude for an intentional low pass. Contributing to the accident was the dusk light conditions, and the pilots improper inflight planning and decision.Sep 20, 1992 · N711YM · Substantial damageNTSB BFO92FA153Accident · 1 fatalField investigationFinal reportCessna 152 · Gloucester, VAThe pilot's failure to recover from an intentional stall, which resluted in inflight collision with the ground. Pilot inexperience is a contributing factor.Sep 20, 1992 · N46076 · DestroyedNTSB ATL92LA183Accident · 1 fatalLimited investigationFinal reportCorben Baby ACE · Jacksonville, NCThe pilot's failure to maintain flying speed which resulted in a loss of control and an inadvertent stall and collision with the ground.Sep 20, 1992 · N840Z · Substantial damageNTSB MIA92LA185Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Picayune, MSThe pilot in command's failure to maintain airspeed (vso) while conducting slow flight at a low altitude. This resulted in an in flight loss of control (stall) and subsequent in flight collision with trees.Sep 19, 1992 · N9578H · DestroyedNTSB LAX92FA389Accident · 2 fatalField investigationFinal reportBeech 76 · Mount Shasta, CAThe pilot's improper en route decision to alter his course and to proceed over a mountainous area with inadequate altitude to clear the rising terrain.Sep 17, 1992 · N5269M · DestroyedNTSB SEA92LA204Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Packwood, WAThe improper in-flt planning and decision by the student pilot and his failure to maintain terrain clearance. Factors relating to the accident were the box canyon and the rising mountainous terrain.Sep 16, 1992 · N6419S · DestroyedNTSB LAX92LA398Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Avalon, CAThe pilot's intentional flight at an altitude which provided insufficient clearance from the water.Sep 15, 1992 · N33SM · Substantial damageNTSB CHI92DTG06Accident · No injuriesFinal reportCessna 188B · Cogswell, NDLoss of engine power as a result of a complete piston failure.Sep 14, 1992 · N9747G · Substantial damageNTSB BFO92FA141Accident · 1 fatalField investigationFinal reportChampion 7KCAB · East Haddam, CTThe pilot's decision to attempt an aerobatic maneuver without adequate altitude for recovery.Sep 14, 1992 · N561EK · DestroyedNTSB ATL92LA184Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Powellsville, NCThe failure of the no.1 exhaust valve.Sep 14, 1992 · N6953Z · Substantial damageNTSB CHI92DEC04Accident · Serious injuriesFinal reportTennessee Engineering & Manf Z-MAX · Manchester, MIAn inadequate design of the rudder control system by the pilot/builder of the airplane, a pullup performed by the pilot, and a total failure of the rudder flight control system.Sep 13, 1992 · UNREG · DestroyedNTSB LAX92LA381Accident · 1 fatalLimited investigationFinal reportWarren-Thomas BD-5J · Chico, CAThe pilot misjudged the aerobatic maneuver recovery altitude.Sep 12, 1992 · N45DH · DestroyedNTSB ANC92FA162Accident · 2 fatalField investigationFinal reportChampion 7EC · Seward, AKThe pilot-in-command's failure to maintain an adequate altitude in mountainous terrain, in moderate-to-severe turbulent conditions, which resulted in a loss of control. In addition, the pilot was physically impaired due to alcohol. Factors contributing to the…Sep 11, 1992 · N4362C · DestroyedNTSB LAX92LA380Accident · No injuriesLimited investigationFinal reportCessna 172N · Stanfield, AZThe cfi's poor in-flight decision to demonstrate the simulated engine out emergency landing at too low an altitude and misjudging the altitude during the circling maneuver.Sep 10, 1992 · N734UT · Substantial damageNTSB ATL92LA179Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Waynesboro, GAThe pilot's failure to maintain adequate clearance from the street sign during an aerial application pass.Sep 10, 1992 · N92427 · DestroyedNTSB CHI92FA267Accident · 1 fatalField investigationFinal reportPiper PA-61-601P · Aurora, INExceeding the design stress limits of the airplane by the pilot in command.Sep 8, 1992 · N717BB · DestroyedNTSB BFO92FA131Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Conway, MAThe pilot's failure to maintain clearance above the trees. A possible factor related to the accident was the pilot's use of a prescription drug.Sep 8, 1992 · N2509D · DestroyedNTSB SEA92FA195Accident · 3 fatalField investigationFinal reportSnodgrass Starduster TOO · Lacey, WAThe failure of both pilots to see and avoid each other.Sep 7, 1992 · N4316 · 2 aircraft · DestroyedNTSB CHI92DCD10Accident · Minor injuriesFinal reportCurt Hoffstad Pitts S1-S · Council Bluffs, IAThe failure of the pilot to maintain aircraft control while maneuvering during aerobatic flight.Sep 7, 1992 · N90LB · Substantial damageNTSB SEA92LA196Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Cokeville, WYFatigue failure of the crankshaft. Factors include non suitable terrain for a forced landing and an improper propeller.Sep 6, 1992 · N78599 · Substantial damageNTSB MIA92FA174Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Inverness, MSThe failure of the pilot in command to maintain airspeed above stall airspeed resulting in the aircraft stalling and entering a spin from which it descended uncontrolled to the ground.Sep 6, 1992 · N70734 · DestroyedNTSB ANC92LA179Accident · No injuriesLimited investigationFinal reportPiper PA-18-180 · Sparrevohn, AKThe pilot's low pass between trees in crosswind conditions and inflight decision to conduct low altitude flight at a location that was too restricted for safe operation. Factors relating to the accident were: cross wind conditions and obstacles (trees).Sep 6, 1992 · N8699D · Substantial damageNTSB FTW92LA222Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Mcgehee, ARThe pilot's failure to maintain clearance.Sep 5, 1992 · N23207 · Substantial damageNTSB DEN92FA091Accident · 2 fatalField investigationFinal reportBeech E-55 · Steamboat Sprin, COThe pilot becoming spatially disoriented and losing control of the airplane. Factors were: the pilot's disregard of the preflight weather briefing, his intentional VFR flight into instrument meteorological conditions, his lack of recent instrument time, and…Sep 5, 1992 · N12GG · DestroyedNTSB BFO92FA127Accident · 1 fatalField investigationFinal reportCessna A150L · Troy, MEFailure of the pilot to maintain proper altitude during an aerobatic manuever.Sep 5, 1992 · N6054J · DestroyedNTSB ATL92LA172Accident · No injuriesLimited investigationFinal reportAyres S-2R · Douglas, GAThe pilot's failure to check weather prior to the flight. A factor was the dark night.Sep 4, 1992 · N4007H · Substantial damageNTSB DEN92LA090Accident · No injuriesLimited investigationFinal reportCessna A188 · Burlington, COFractured connecting rod. A factor was: the lack of suitable terrain for the forced landing.Sep 3, 1992 · N8041V · DestroyedNTSB ATL92LA173Accident · No injuriesLimited investigationFinal reportCessna A188B · Centre, ALThe pilot's inadequate compensation for existing wind conditions, which resulted in his inability to maintain a proper altitude. Factors were the turbulence and wind shear present at the time of the accident.Sep 2, 1992 · N4845Q · Substantial damageNTSB ANC92LA153Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Ninilchik, AKThe student pilot entered a low altitude stall/mush during an airdrop maneuver. Factors contributing to the accident were: the low pass maneuver, and the improper altitude.Sep 2, 1992 · N1737D · DestroyedNTSB MIA92LA170Accident · No injuriesLimited investigationFinal reportHughes 269B · Long Beach, MSImproper collective and cyclic control input by the pilot-in-command during the forced landing following total loss of engine power due to undetermined reasons.Sep 1, 1992 · N9460F · Substantial damageNTSB ATL92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sylvania, GAAn inadequate preflight inspection by the pilot which resulted in fuel contamination and a loss of engine power.Sep 1, 1992 · N9450G · Substantial damageNTSB CHI92DEP04Accident · Minor injuriesFinal reportGrumman 164A · Elkhorn, WIThe pilot-in-command's inadequate compensation for wind conditions.Aug 31, 1992 · N48635 · DestroyedNTSB NYC92LA180Accident · No injuriesLimited investigationFinal reportPiper PA-46-350 · Sanford, METhe pilot did not follow IFR procedures when he disregarded the decision height limitation and failed to initiate a missed approach which resulted in the airplane striking trees.Aug 28, 1992 · N350PM · Substantial damageNTSB FTW92LA219Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, ARThe pilot's inadequate visual lookout while maneuvering at low altitude.Aug 27, 1992 · N2659Z · Substantial damageNTSB DEN92LA087Accident · No injuriesLimited investigationFinal reportCessna 172F · Folsom, NMCarburetor heat not used and improper use of throttle and mixture control. A factor was: the lack of suitable terrain for a forced landing.Aug 25, 1992 · N5101F · Substantial damageNTSB ATL92LA166Accident · No injuriesLimited investigationFinal reportSikorsky UH-19D · St. Augustine, FLThe failure of the engine's exhaust valve rocker arm.Aug 25, 1992 · N37800 · Substantial damageNTSB ANC92LA144Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Nome, AKThe pilot's failure to maintain an adequate altitude.Aug 24, 1992 · N5006M · Substantial damageNTSB NYC92LA175Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-65 · Suffern, NYThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin. Factors related to the accident were the pilot's overconfidence in his abilities, and buzzing.Aug 23, 1992 · N27558 · DestroyedNTSB NYC92FA174Accident · 1 fatalField investigationFinal reportCessna 150M · Union Township, OHThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Factors related to this accident was night conditions, the pilot's lack of night experience, and the pilot becoming lost and disoriented.Aug 23, 1992 · N714DS · DestroyedNTSB ANC92LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150-F · Whittier, AKThe pilot's improper in flight planning/decision, and his inadvertent VFR flight into IMC weather conditions. Contributing factors were the pilot's lack of total experience with this type operation, and the mountainous terrain.Aug 22, 1992 · CGVJM · Substantial damageNTSB CHI92LA249Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Marshall, INThe pilot's failure to maintain control of the helicopter due to his alcoholic impairment of efficiency and judgement.Aug 21, 1992 · N203SD · DestroyedNTSB CHI92DCD09Accident · No injuriesFinal reportHiller Hiller UH-12E · Dows, IAContaminated fuel resulting in a loss of engine power.Aug 21, 1992 · N527HA · Substantial damageNTSB SEA92LA184Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Mattawa, WALoss of engine power due to fuel contamination as a result of inadequate maintenance by the operator. A factor contributing to the accident was soft terrain.Aug 20, 1992 · N28951 · DestroyedNTSB FTW92FA215Accident · Minor injuriesField investigationFinal reportBell XV-15 301 · Arlington, TXInadequate maintenance and inspection which resulted in a disconnected proprotor governor linkage.Aug 20, 1992 · N702NA · Destroyed