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 NYC94LA002Accident · No injuriesLimited investigationFinal reportGrumman G-164-A · Madisonville, KYthe pilot's inadequate preflight preparation and his inadequate visual lookout in flight which resulted in the collision with wires.Oct 4, 1993 · N9909 · DestroyedNTSB SEA94FA004Accident · 1 fatalField investigationFinal reportCessna 182P · Heber City, UTThe pilot's improper inflight decisions and failure to maintain proper altitude. Factors include the box canyon.Oct 3, 1993 · N50TH · DestroyedNTSB NYC94LA005Accident · No injuriesLimited investigationFinal reportSwift S-1 · Blairstown, NJThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall. A factor is wind gust and the pilot's inexperience in type aircraft.Oct 3, 1993 · N818AW · Substantial damageNTSB FTW94LA001Accident · Minor injuriesLimited investigationFinal reportCessna T188C · New Deal, TXFailure of the pilot to maintain ground clearance while avoiding a powerline. Failure of the pilot to see a second set of power lines prior to initiating the spraying run was also a cause.Oct 3, 1993 · N2031J · Substantial damageNTSB ANC94FA001Accident · 1 fatalField investigationFinal reportMaule M-6-235 · Merrill Pass, AKThe pilot-in-command's attempt to fly VFR into IMC conditions. A factor was the whiteout weather condition.Oct 2, 1993 · N5647N · Substantial damageNTSB SEA93FA214Accident · 3 fatalField investigationFinal reportCessna 172N · Ellensburg, WAThe pilot's failure to maintain an airspeed above stalling speed (vs), and his inadequate remedial action. Factors include the pilot's diverted attention, and an inadvertent stall/spin.Oct 1, 1993 · N172LS · DestroyedNTSB LAX94LA003Accident · 1 fatalLimited investigationFinal reportCessna 182H · Clear Lake Res, CAFailure of the pilot to maintain altitude, while performing a low-altitude maneuver (turn) over water. Factors related to the accident were: sun glare, haze, glassy condition of the water, and the lack of visual cues (visual perception) for the pilot to judge…Oct 1, 1993 · N8397S · Substantial damageNTSB FTW94LA033Accident · Serious injuriesLimited investigationFinal reportBell 204-B · Cedar Crest, NMFailure of ground personnel to follow published procedures. A factor was the the load jettison.Oct 1, 1993 · N41699 · No damageNTSB BFO93FA188Accident · 2 fatalField investigationFinal reportErcoupe 415-CD · Charles City, VAthe pilot exceeded the design stress limits of the airplane which resulted in an in-flight break-up.Sep 28, 1993 · N4576B · DestroyedNTSB MIA93FA200Accident · 1 fatalField investigationFinal reportBeech C35 · Ocklawaha, FLFailure of a propeller blade for an undetermined reason, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: low pass performed by the pilot, and his possible impairment from…Sep 24, 1993 · N5936C · DestroyedNTSB SEA93LA207Accident · No injuriesLimited investigationFinal reportBell UH-1B · Pierce, IDSeparation of the 90 degree gearbox after fatigue failure of the gearbox attach bolts. Factors include hilly/mountainous terrain.Sep 23, 1993 · N3979C · Substantial damageNTSB LAX93LA367Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Livermore, CAA partial engine power loss that resulted in a hard landing due to the engine primer system becoming unlocked.Sep 23, 1993 · N2407X · Substantial damageNTSB FTW93LA263Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A Dromader · Frogmore, LAThe pilot's failure to maintain clearance with the powerline. A factor was the dusk light condition.Sep 23, 1993 · N452TC · DestroyedNTSB SEA93FA205Accident · 2 fatalField investigationFinal reportCessna 185A · De Borgia, MTThe pilot's poor in-flight planning/decision and his failure to maintain airspeed above a stall.Sep 22, 1993 · N4176Y · DestroyedNTSB MIA93LA202Accident · No injuriesLimited investigationFinal reportCessna 172M · Hollywood, FLInadvertent exceeding of vfe with the flaps extended by the student pilot while practicing maneuvers.Sep 22, 1993 · N20457 · Substantial damageNTSB LAX93LA365Accident · Minor injuriesLimited investigationFinal reportSnow 600-S2C · Surprise, AZThe pilot's improper inflight planning resulting in his airplane's encounter with wake turbulence.Sep 22, 1993 · N1677S · Substantial damageNTSB LAX93LA361Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Buttonwillow, CAThe pilot's failure to avoid wires.Sep 20, 1993 · N8133K · Substantial damageNTSB SEA93LA200Accident · 1 fatalLimited investigationFinal reportCessna A188B · Waterville, WAThe pilot's inadequate visual lookout and failure to maintain clearance from the powerline.Sep 15, 1993 · N9523G · DestroyedNTSB LAX93LA353Accident · No injuriesLimited investigationFinal reportHughes 369D · Georgetown, CAFailure of the pilot to maintain aircraft control after improperly planning his approach to a hover by avoiding conditions conducive to settling with power. Factors in the accident were high density altitude and failure of the pilot to jettison the external…Sep 15, 1993 · N501RR · Substantial damageNTSB BFO93LA177Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Mattawamkeag, ME1) The pilot's initiation of an excessive maneuver (steep bank turn) at 400 feet above the ground, which resulted in an aerodynamic stall, and 2) the pilot's lack of recognition of the nature of the emergency, causing a delay in performing remedial action to…Sep 15, 1993 · N11689 · Substantial damageNTSB SEA93LA211Accident · No injuriesLimited investigationFinal reportCessna 150L · Silverton, ORClearance was not maintained. A factor to the accident was: poor in-flight planning/decision.Sep 14, 1993 · N11882 · Substantial damageNTSB LAX93LA351Accident · Serious injuriesLimited investigationFinal reportR&K Special 01 · Reno, NVThe pilot's loss of control due to an undetermined encounter with an unfavorable wind/air condition in the form of a dust devil, windshear, or wake turbulence from a previous lap. A related factor in the accident was: the low altitude at the time of the…Sep 14, 1993 · N115R · DestroyedNTSB LAX93FA352Accident · 1 fatalField investigationFinal reportScaled Composites 158-8 · Lemmon Valley, NVOil starvation and connecting rod failure in the right engine, and a resultant fuel fed fire.Sep 14, 1993 · N221BP · DestroyedNTSB SEA93LA198Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G164A · Dayton, WAThe pilot in command's failure to maintain proper clearance from the power lines. The unmarked power lines were a factor.Sep 13, 1993 · N9536 · DestroyedNTSB ANC93LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mosquito River, AKThe pilot's failure to maintain a proper altitude during the low pass. A factor was the rough/uneven terrain.Sep 12, 1993 · N82081 · Substantial damageNTSB ANC93IA176Incident · No injuriesIncident investigationFinal reportSikorsky C54A · Anita Bay, AKThe separation of the turbine blade from the power turbine disc.Sep 12, 1993 · N44094 · Minor damageNTSB ATL93LA156Accident · Serious injuriesLimited investigationFinal reportBrown VAN'S RV-3 · Statesville, NCWas the pilot's failure to see and avoid utility lines. A factor was the sunglare.Sep 11, 1993 · N115DB · Substantial damageNTSB SEA93LA196Accident · 1 fatalLimited investigationFinal reportAerospatiale SA-365-N2 · Ogden, UTThe pilot's failure to maintain proper altitude. A factor to the accident was glassy water.Sep 10, 1993 · N818R · DestroyedNTSB BFO93FA169Accident · 2 fatalField investigationFinal reportCessna A150 · Greenbelt, MD1) The pilot's poor judgement in buzzing a residential area, 2) his failure to maintain an airspeed above the aerodynamic stalling speed, which led to a stall/spin, and 3) the inability of the pilot to take remedial action and recover from the stall/spin due…Sep 10, 1993 · N6013J · DestroyedNTSB ATL93LA154Accident · No injuriesLimited investigationFinal reportCessna 177RG · Valdosta, GAThe pilot's inadequate evaluation of inflight weather conditions which resulted in the inflight encounter with severe turbulence and subsequent overstress of the airframe.Sep 10, 1993 · N2074Q · Substantial damageNTSB ATL93LA152Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Myrtle Beach, SCThe failure of the engine exhaust valve which resulted in the loss of engine power. The soft terrain in the landing area was a factor.Sep 9, 1993 · N2437E · Substantial damageNTSB SEA93LA193Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Price, UTThe failure of the pilot to maintain airspeed above stall.Sep 6, 1993 · N8067E · Substantial damageNTSB MIA93LA191Accident · 1 fatalLimited investigationFinal reportHudson Rans S-12 · Leesburg, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering resulting in a stall/spin.Sep 6, 1993 · UNREG · DestroyedNTSB SEA93FA194Accident · 1 fatalField investigationFinal reportCessna 182D · Lucile, IDThe pilot's failure to maintain airspeed resulting in an aerodynamic stall. The mountainous terrain was a factor.Sep 5, 1993 · N9995T · DestroyedNTSB FTW93LA252Accident · 1 fatalLimited investigationFinal reportMascola Christen Eagle II · Palo Pinto, TXThe pilot's intentional stall at an altitude insufficient to allow a safe recovery.Sep 5, 1993 · N53JS · DestroyedNTSB FTW93FA255Accident · 7 fatalField investigationFinal reportGates Learjet 25D · Pecos, NMWas physical impairment of the pilot in command from alcohol and drugs. A factor was the first officer's lack of experience in the lear jet.Sep 5, 1993 · N999BH · DestroyedNTSB BFO93LA156Accident · 1 fatalLimited investigationFinal reportCessna 172P · Pembroke, VAThe pilot's failure to maintain proper altitude while manuevering in mountainous terrain.Sep 4, 1993 · N50927 · DestroyedNTSB SEA93LA188Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Three Forks, MTThe pilot's failure to maintain flying speed resulting in a stall/mush. The high density altitude and the pilot's failure to completely jettison his load were factors.Sep 2, 1993 · N21861 · DestroyedNTSB ANC93LA165Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Kijik River, AKThe pilot's failure to maintain a proper altitude during the low pass.Sep 1, 1993 · N71585 · Substantial damageNTSB ANC93FA161Accident · 3 fatalField investigationFinal reportDe Havilland DHC-2 · Iliamna, AKThe pilot's failure to maintain airspeed resulting in an inadvertent stall. A factor in the accident was the inadequate recurrent training of the pilot by the operator/management.Aug 31, 1993 · N64273 · DestroyedNTSB CHI93IA382Incident · No injuriesIncident investigationFinal reportFairchild SA-227-AC · Grand Rapids, MNthe fractured aileron cable and other maintenance personnel's inadequate maintenance/adjustment.Aug 30, 1993 · N446MA · No damageNTSB ANC93LA159Accident · 1 fatalLimited investigationFinal reportMorgan Steen Skybolt MI-2 · Nome, AKThe pilot delayed in recovering from the aerobatic maneuver.Aug 29, 1993 · N23JM · Substantial damageNTSB DEN93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMImproper planning and decision making by the pilot in command in descending into a valley at an altitude providing no escape route in mountainous terrain.Aug 28, 1993 · N65655 · Substantial damageNTSB ANC93LA158Accident · No injuriesLimited investigationFinal reportHughes 369D · Mount Iliamna, AKThe pilot's improper in-flight planning/decision, and his delay in taking remedial action. Factors were the mountainous terrain and gusty winds.Aug 28, 1993 · N5074R · Substantial damageNTSB ANC93LA145Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Atigan Pass, AKThe pilot's improper inflight planning/decision and delay in taking remedial action.Aug 28, 1993 · N80303 · Substantial damageNTSB NYC93LA175Accident · No injuriesLimited investigationFinal reportEnstrom F28A · Meriden, CTThe loss of engine power for undetermined reasons.Aug 27, 1993 · N269Q · Substantial damageNTSB NYC93LA168Accident · No injuriesLimited investigationFinal reportPiper PA-25-225 · Chesapeake, VAThe loosening of the crankshaft geardrive as a resulted of a sheared bolt and guide pin which resulted in the loss of engine power. A factor was a forced landing on a crop field.Aug 26, 1993 · N9556P · Substantial damageNTSB ANC93LA157Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Beaver Creek, AKThe improper altitude flown by the pilot in command.Aug 26, 1993 · N7637S · Substantial damageNTSB FTW93FA245Accident · 1 fatalField investigationFinal reportAir Tractor AT-402 · La Barre, LALoss of control for undetermined reasons.Aug 25, 1993 · N1508X · DestroyedNTSB FTW93FA244Accident · 2 fatalField investigationFinal reportBusby Celebrity · Perry, OKThe pilot's failure to maintain airspeed due to alcohol impairment. A factor which contributed to the accident was the pilot performing aerobatics at a altitude inadequate to recover from a stall.Aug 23, 1993 · N2828 · Destroyed