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 ATL91LA130Accident · 1 fatalLimited investigationFinal reportCessna 188 · Snow Hill, NCInadequate visual lookout by the pilot. Factors to the accident were tree.Jul 20, 1991 · N9072R · DestroyedNTSB NYC91DNC03Accident · 1 fatalFinal reportValentin GMB H Taifun 17E · West Arlington, VTPhysiological incapacitation due to cardiovascular disease which resulted in incapacitation and inflight collision with trees.Jul 19, 1991 · N333VT · DestroyedNTSB LAX91LA319Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Patterson, CAThe pilot-in-command's improper visual lookout in a descent at low altitude, resulting in an in flight collision with wires and subsequent in flight collision with terrain.Jul 19, 1991 · N23142 · Substantial damageNTSB FTW91DPG16Accident · No injuriesFinal reportAyres S2R-T34 · Mellwood, ARFailure of the pilot to maintain proper clearance with the power line.Jul 19, 1991 · N3092S · Substantial damageNTSB CHI91DTK03Accident · 1 fatalFinal reportWag-Aero Super Cuby · Roscoe, SDThe pilot's inadvertent stall and inadequate remedial action. Associated factors are the pilot's lack of recent total experience and inadequate preflight planning/preparation.Jul 19, 1991 · N336DT · DestroyedNTSB MIA91LA202Accident · No injuriesLimited investigationFinal reportCessna A188B · Hollandale, MSOverload failure of the no. 5 cylinder connecting rod bolt due to being loose for undetermined reasons. This resulted in the damage during the forced landing following total loss of engine power.Jul 18, 1991 · N9541J · Substantial damageNTSB LAX91LA316Accident · 2 fatalLimited investigationFinal reportJurca MJ5 Sirocco · Lake Mathews, CAThe pilot's intentional low altitude flight which resulted in a collision with a power line static cable. Contributing to the accident was inadequate light conditions which reduced the pilot's ability to detect the power line.Jul 18, 1991 · N239GA · DestroyedNTSB NYC91LA182Accident · No injuriesLimited investigationFinal reportCessna 152 · Springwater, NYThe on ground collision with trees during a forced landing after the pilot experienced an engine failure due to a broken exhaust valve.Jul 17, 1991 · N6489B · DestroyedNTSB MIA91LA188Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Cleveland, MSInadequate preflight resulting in water contamination causing loss of engine power.Jul 17, 1991 · N9327R · DestroyedNTSB ANC91IA102Incident · No injuriesIncident investigationFinal reportDe Havilland DHC2 MK1 · Iliamna, AKThe pilot-in-command's attempted flight into known adverse weather conditions. Contributing to the accident was the high and gusty winds in the accident area.Jul 16, 1991 · N6LU · Minor damageNTSB FTW91DPG14Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARPartial failure of the hopper, chemical fire, and the failure of the landing gear. A factor ws the loss of visual outside reference.Jul 15, 1991 · N6615 · DestroyedNTSB SEA91LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Musselshell, MTThe pilot's intentional stall at low altitude.Jul 13, 1991 · N9792P · DestroyedNTSB ATL91LA129Accident · Minor injuriesLimited investigationFinal reportCessna 210D · Hazel Green, ALThe inadvertent control interference caused when a parachute line became entangled in the right elevator trim tab, after the student jumper exited the airplane.Jul 13, 1991 · N3742Y · Substantial damageNTSB ATL91LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Hawkinsville, GAA complete loss of engine power for undetermined reasons. A factor in this accident was: the rough, uneven terrain at the forced landing site.Jul 12, 1991 · N31691 · Substantial damageNTSB MIA91LA183Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Greenwood, FLThe inadequate preflight which resulted in debris in the cockpit which reduced the pilot's visual lookout. Unsuitable terrain encountered during the landing was a factor.Jul 11, 1991 · N6891Q · DestroyedNTSB LAX91LA305Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-B · San Jose, CAThe student pilot's failure to unlock the cyclic trim and to maintain his hover altitude. His lack of experience with the aircraft, inadequate preflight, and the uncontrolled descent were factors in the accident.Jul 11, 1991 · N730SH · Substantial damageNTSB FTW91DRA06Accident · 1 fatalFinal reportMorrison-Keitel VOLKSPLANE-1 · Woodbranch, TXThe airplane's collision with trees for undetermined reasons.Jul 11, 1991 · N37898 · DestroyedNTSB LAX91LA304Accident · 1 fatalLimited investigationFinal reportPiper PA24-250 · Temple Bar, AZThe pilot's failure to maintain control of the aircraft during an attempted return to runway maneuver and the entry into an inadvertent stall/spin at low altitude. The exact nature of the emergency problem encountered by the pilot is undetermined.Jul 10, 1991 · N8142P · DestroyedNTSB LAX91LA303Accident · 1 fatalLimited investigationFinal reportE.C Trynka Pietenpol Aircamper · Skull Valley, AZThe pilot inadvertently inducing a stall spin condition with insufficient altitude to recover from the spin.Jul 10, 1991 · N64661 · DestroyedNTSB ATL91LA127Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Matthews, SCThe pilot's failure to maintain safe clearance from power lines, while maneuvering to avoid an automobile in the area of his spraying operation.Jul 10, 1991 · N4905Q · Substantial damageNTSB NYC91LA177Accident · No injuriesLimited investigationFinal reportCessna L-19 · Franconia, NHThe failure of the pilot to maintain airspeed, which resulted in a stall/spin and in flight collision with trees. Factors related to the accident were the improper in-flight planning by the pilot and the pilot's failure to compensate for winds and downdraft.Jul 9, 1991 · N5237G · DestroyedNTSB LAX91LA301Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Eloy, AZThe failure of the pilot to maintain the terrain clearance of the aircraft while maneuvering for a potential emergency landing on a moonless dark night.Jul 9, 1991 · N6633K · Substantial damageNTSB DEN91LA088Accident · No injuriesLimited investigationFinal reportPiper PA-25C-235 · Las Cruces, NMPower loss due to fuel contamination. A factor was: pilot's inadequate airplane preflight.Jul 9, 1991 · N8787L · Substantial damageNTSB SEA91LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Dayton, WYSevere down drafts. Factors to the accident were: terrain clearance was not maintained, and a poor weather evaluation, by the pilot.Jul 8, 1991 · N5826D · Substantial damageNTSB NYC91FA174Accident · 3 fatalField investigationFinal reportGulfstream American AA5B · Columbia, CTThe decision of the pilot to continue flight into instrument meteorological conditions, which resulted in an in flight collision with trees. Factors related to the accident were the pilot's lack of instrument flight expereince, his overconfidence in his…Jul 8, 1991 · N43ER · DestroyedNTSB SEA91FA156Accident · 2 fatalField investigationFinal reportChampion 7AC · Burns, ORImproper inflight planning/decision by the student pilot (pilot-in-command), and his failure to maintain adequate airspeed, which resulted in a stall. Factors related to the accident were: physical impairment of the student pilot/owner/operator from carbon…Jul 6, 1991 · N3006E · Substantial damageNTSB MIA91LA182Accident · Minor injuriesLimited investigationFinal reportAerotek PITTS-S2A · Eustis, FLThe loss of elevator control in flight due to a screwdriver jamming the elevator control for unknown causes.Jul 6, 1991 · N31427 · Substantial damageNTSB NYC91LA172Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Pomeroy, OHAn inflight collision with terrain after the pilot became incapacitated due to an allergic reaction to bee stings. A factor related to the accident was the failure of the pilot to recognize the situation in time to make the recovery.Jul 5, 1991 · N68560 · Substantial damageNTSB CHI91LA210Accident · 2 fatalLimited investigationFinal reportCessna 150F · Faulkton, SDAn inadvertent stall. A factor related to the accident was the pilot's failure to maintain airspeed.Jul 5, 1991 · N6263R · DestroyedNTSB BFO91LA064Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berlin, MDThe unsuitable placement of two banners (improper planning) by other personnel causing an unintentional pickup of both banners.Jul 5, 1991 · N5BJ · Substantial damageNTSB SEA91LA150Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Riverton, WYThe pilot did not maintain adequate terrain clearance. A factor to the accident was: poor inflight planning/preparation.Jul 4, 1991 · N2070J · Substantial damageNTSB FTW91DRA05Accident · 1 fatalFinal reportDaniel La Lee Miget Mustang M-1 · Santa Fe, TXThe pilot's performance of an aerobatic maneuver at an altitude inadequate to allow for safe recovery.Jul 4, 1991 · N20LL · DestroyedNTSB CHI91DEX04Accident · Minor injuriesFinal reportWilbur D. Batman Challenger II · Lebanon, INFailure to maintain stall airspeed while executing a forced landing. A factor related to the accident is failure of the engine starter clutch.Jul 4, 1991 · N503DB · Substantial damageNTSB ANC91GA087Accident · No injuriesFinal reportPiper PA-18 · King Salmon, AKThe pilot inadvertently switched the magnetos off during the flight. Contributing to the accident was the rough, uneven terrain with loose gravel.Jul 4, 1991 · N82732 · Substantial damageNTSB CHI91LA205Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Savoy, ILThe pilot's failure to maintain tail rotor clearance from the ground. A related factor is the pilot's lack of total experience in helicopters.Jul 2, 1991 · N94515 · Substantial damageNTSB NYC91DFJ01Accident · 1 fatalFinal reportSterns Sterns Longster · Mayville, NYThe failure of the pilot to maintain airspeed, which resulted in a stall and spin at a low altitude. Also causal to the accident was the lack of experience of the pilot in this make and model airplane.Jul 1, 1991 · N891DS · DestroyedNTSB BFO91DOA01Accident · Minor injuriesFinal reportBell UH-1B · Iaeger, WVThe loss of engine power for undetermined reasons, while operating over unsuitable terrain.Jul 1, 1991 · N91348 · Substantial damageNTSB NYC91LA159Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Manassas, VAThe pilot's improper inflight decision and his failure to maintain proper airspeed at a low altitude which resulted in the helicopter settling with power. A factor in the accident was the pilot's failure to follow prescribed procedures/directives.Jun 29, 1991 · N48323 · Substantial damageNTSB FTW91DPA02Accident · Serious injuriesFinal reportPaul M. F. Walker Pitts S-1-C · Royse City, TXThe pilot's performance of an aerobatic maneuver at an altitude too low to allow recovery.Jun 29, 1991 · N4PW · Substantial damageNTSB CHI91DER11Accident · No injuriesFinal reportPiper OA25-235 · Clinton, MNThe pilot's failure to maintain adequate control of the aircraft while maneuvering in aerial application operations. Related factors are wake turbulence and low altitude.Jun 29, 1991 · N9599P · DestroyedNTSB ATL91LA119Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Muscle Shoals, ALThe loss of engine power for undetermined reasons.Jun 29, 1991 · N48430 · Substantial damageNTSB ATL91FA117Accident · 2 fatalField investigationFinal reportFuji LM 1 · Keystone Hghts, FLFailure of the number four pilot (in N2100J) to maintain adequate visual lookout and/or clearance from the number three aircraft (N2109L).Jun 29, 1991 · N2109L · 2 aircraft · DestroyedNTSB CHI91DER08Accident · 1 fatalFinal reportBellanca 8GCBC · St. Hilaire, MNThe pilot's failure to maintain sufficient altitude while maneuvering.Jun 28, 1991 · N8714V · DestroyedNTSB ANC91LA081Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Whittier, AKThe pilot's failure to maintain proper flying speed.Jun 28, 1991 · N4362V · DestroyedNTSB MIA91LA169Accident · No injuriesLimited investigationFinal reportGrumman G164B · Immokalee, FLLoss of enine power due to undetermined reasons. Contributing to the accident was unsuitable terrain encounteered during the forced landing.Jun 26, 1991 · N3629X · Substantial damageNTSB MIA91FA171Accident · 2 fatalField investigationFinal reportBeech 77 · Magnolia, MSThe instructor pilot's (cfi's) improper supervision of flight and a failure to maintain sufficient altitude above the trees.Jun 26, 1991 · N60195 · DestroyedNTSB FTW91DRD06Accident · No injuriesFinal reportBell 47-G2 · White Castle, LAThe pilot's improper aircraft handling, which resulted in settling with power.Jun 26, 1991 · N8460E · DestroyedNTSB SEA91LA146Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Wenatchee, WAThe pilot's failure to maintain a proper altitude. Contributing to the accident was sun glare.Jun 25, 1991 · N40450 · Substantial damageNTSB DEN91LA089Accident · No injuriesLimited investigationFinal reportCessna A188B · Delta, COA total power loss due to a ruptured fuel line, and the installation of an incorrect fuel line.Jun 24, 1991 · N8278G · Substantial damageNTSB CHI91DEC02Accident · 2 fatalFinal reportHoward Tierra II · Cambridge Jct, MIEntanglement of the emergency ballistic parachute with the airplane's propeller shaft after it deployed for an undetermined reason. A factor related to the accident was: the aircraft's weight and balance limit was exceeded by the pilot.Jun 23, 1991 · N351R · Destroyed