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 LAX03LA175Accident · 2 fatalLimited investigationFinal reportGray Jerry Kitfox · Jerome, AZThe pilot's failure to maintain adequate clearance/altitude from rising terrain, and his failure to maintain control of the airplane while maneuvering, which resulted in an uncontrolled descent and in-flight collision with terrain.May 31, 2003 · N111BM · DestroyedNTSB LAX03LA173Accident · 1 fatalLimited investigationFinal reportAero Vodochody L-39 · Tracy, CAthe pilot's failure to maintain adequate terrain clearance while performing low level aerobatics.May 31, 2003 · N139RH · DestroyedNTSB FTW03LA164Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2A · Grand Prairie, TXthe pilot's improper inspection of the aircraft after impacting trees on a previous flight which resulted in an in-flight separation of the lower left wing and aileron while performing aerobatic maneuvers.May 31, 2003 · N97DW · Substantial damageNTSB DEN03LA092Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cheyenne, WYthe pilot's failure to maintain aircraft control. A contributing to the accident was the sudden tailwind encountered.May 30, 2003 · N508SQ · Substantial damageNTSB ATL03LA098Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hampton, GAThe certified flight instructor's failure to maintain clearance from the runway during a low pass. A factor was gusty wind conditions.May 29, 2003 · N140PF · Substantial damageNTSB LAX03FA166Accident · 4 fatalField investigationFinal reportRockwell 114 · Bishop, CAThe pilot's failure to maintain an adequate airspeed while maneuvering close to the ground over mountainous terrain in a high density altitude environment near the upper performance capability of the airplane, which resulted in an inadvertent stall/mush into…May 26, 2003 · N4730W · DestroyedNTSB IAD03LA055Accident · No injuriesLimited investigationFinal reportCessna 414 · Port Jefferson, NYLoss of power to both engines for undetermined reasons.May 26, 2003 · N1234 · DestroyedNTSB SEA03FA092Accident · 1 fatalField investigationFinal reportCessna 180H · Yellow Pine, IDThe pilot's failure to maintain clearance while maneuvering. Trees, a box canyon and rising terrain were factors.May 25, 2003 · N767 · Substantial damageNTSB NYC03LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA32-260 · Huntington, WVThe pilot's failure to position the fuel selector to a tank with adequate fuel for the flight, which resulted in a power loss due to fuel starvation and the subsequent forced landing.May 25, 2003 · N820CA · Substantial damageNTSB FTW03LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Palestine, ARThe shearing of the torsion shaft which resulted in a loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.May 25, 2003 · N6136Z · Substantial damageNTSB DEN03FA087Accident · 2 fatalField investigationFinal reportErcoupe 415D · Los Lunas, NMthe pilot's failure to maintain clearance from the transmission wire. Contributing factors were the high wind, the pilot's decision to make a low-altitude turn onto the crosswind leg, and the power line.May 25, 2003 · N93971 · DestroyedNTSB CHI03LA134Accident · Minor injuriesLimited investigationFinal reportWeatherly 620A · Melville, NDThe pilot's failure to maintain clearance from the wires. The low altitude operation and the wires were contributing factors.May 24, 2003 · N4650W · Substantial damageNTSB FTW03LA171Accident · Minor injuriesLimited investigationFinal reportBoyle Black Eagle BE360 · Celina, TXThe loss of propeller pitch effectiveness for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.May 23, 2003 · N72BJ · Substantial damageNTSB LAX03LA158Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Willows, CAA loss of engine power for an undetermined reason during an aerial application.May 21, 2003 · N5653X · Substantial damageNTSB NYC03LA111Accident · Serious injuriesLimited investigationFinal reportVirginia Wright Model B · Midland, VAThe pilot's failure to maintain aircraft control.May 20, 2003 · N1911K · Substantial damageNTSB FTW03LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Edna, TXThe pilot's failure to maintain clearance with the transmission wires while maneuvering during an aerial application flight. A contributing factor was the haze restricting the visibility.May 19, 2003 · N9086M · DestroyedNTSB SEA03LA086Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Basin City, WAThe failure of the torque sensor idler gear duplex bearing during agricultural aerial application, resulting in a total power loss and a forced landing. Factors include tall wheat and soft terrain.May 16, 2003 · N3629E · Substantial damageNTSB ATL03LA094Accident · 4 fatalLimited investigationFinal reportKerner Lancair IV · Allendale, SCThe pilot's inadvertent flight into adverse weather ,thunderstorms, that resulted in the design limits of the airplane being exceeded.May 16, 2003 · N29ME · DestroyedNTSB ANC03LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot's failure to maintain clearance from terrain while maneuvering, which resulted in the airplane colliding with terrain. A factor contributing to the accident was the pilot's diverted attention.May 16, 2003 · N9877D · Substantial damageNTSB CHI03LA124Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Benkelman, NEThe pilot's failure to maintain altitude clearance while maneuvering. Contributing factors were the wheat crop and the ground.May 14, 2003 · N5192T · Substantial damageNTSB FTW03CA146Accident · Minor injuriesData collectionFinal reportBell 47G-4 · Robinson, TXThe pilot's failure to maintain clearance with the ground while performing a quick stop maneuver which resulted in a dynamic rollover.May 12, 2003 · N4205D · Substantial damageNTSB LAX03LA148Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pala, CAthe dual student's delay in executing the proper recovery procedures and improper retraction of the flaps, the CFI's inadequate supervision during the recovery to normal flight, the CFI's delayed remedial action, and the failure of both pilots to maintain an…May 6, 2003 · N48796 · Substantial damageNTSB CHI03LA118Accident · 2 fatalLimited investigationFinal reportAir Tractor AT-503A · Pontiac, ILThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. A factor associated with the accident was the low altitude maneuver.May 5, 2003 · N503D · Substantial damageNTSB NYC03GA094Accident · 1 fatalFinal reportPiper PA-18-150 · Ashland, METhe pilot's impairment due to over-the-counter medications, which resulted in a loss of aircraft control while maneuvering.May 4, 2003 · N46773 · Substantial damageNTSB ANC03LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Skwentna, AKThe pilot's failure to use carburetor heat, which resulted in the accumulation of carburetor ice, a partial loss of engine power, and a subsequent forced landing. Factors contributing to the accident are a downdraft, the pilot operating the airplane at a low…May 3, 2003 · N8240P · Substantial damageNTSB SEA03LA074Accident · Serious injuriesLimited investigationFinal reportCessna 182 · McCall, IDThe pilot's inadvertent entry into instrument meteorological conditions while maneuvering in the area of rapidly growing cumulus clouds. Factors include the pilot's improper decision to try to out-climb the rising clouds, mountainous terrain, falling snow,…Apr 27, 2003 · N5595B · Substantial damageNTSB MIA03LA099Accident · No injuriesLimited investigationFinal reportCessna 172D · South Ponotoc, MSthe pilot's failure to maintain altitude and aircraft control during a low pass over a grass runway, which resulted in the airplane impacting the ground.Apr 27, 2003 · N2371U · Substantial damageNTSB DEN03FA074Accident · 2 fatalField investigationFinal reportChristen Industries Pitts S-2B · Longmont, COthe pilot's improper in-flight planning and decision that resulted in fuel exhaustion and his entering an aerobatic maneuver with insufficient altitude. Factors contributing to the accident were the low airspeed and low altitude, and the fuel exhaustion.Apr 26, 2003 · N399DB · DestroyedNTSB CHI03LA117Accident · 1 fatalLimited investigationFinal reportSmith Rans S-7 · Baudette, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the low altitude maneuver by the student pilot.Apr 26, 2003 · N272T · DestroyedNTSB ATL03LA083Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Trenton, TNThe pilot's loss of control in flight and failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with the ground.Apr 25, 2003 · N6621G · Substantial damageNTSB NYC03FA088Accident · 2 fatalField investigationFinal reportAviat Pitts S-2B · Newport, PAThe pilot's improper decision to perform aerobatics at a low altitude, which inhibited his ability to recover from an encountered flat spin. A factor related to the accident was the aft center of gravity, which was beyond the operational limit for the…Apr 24, 2003 · N6085U · Substantial damageNTSB LAX03LA139Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Corona De Tucso, AZThe pilot's failure to maintain an adequate clearance from obstructions while performing low level passes. The pilot's physical impairment due to a high blood alcohol level was also causal.Apr 21, 2003 · N243M · DestroyedNTSB IAD03LA054Accident · Minor injuriesLimited investigationFinal reportRoger Mann Ragwing RW8-PT2S · Hanover, VAA loss of engine power for undetermined reasons. A factor was the wheat in the forced landing field.Apr 21, 2003 · UNREG · Substantial damageNTSB FTW03LA134Accident · No injuriesLimited investigationFinal reportHughes 369HS · Conroe, TXThe pilot's inability to control the helicopter after encountering loss of tail rotor effectiveness. A contributing factor was the unfavorable winds.Apr 19, 2003 · N16Q · Substantial damageNTSB ATL03LA080Accident · 1 fatalLimited investigationFinal reportRans S-12 · West Point, TNThe pilot's failure to maintain adequate obstacle clearance which resulted in the inflight collision with a utility line. A factor was utility lines.Apr 19, 2003 · UNREG · Substantial damageNTSB LAX03LA138Accident · No injuriesLimited investigationFinal reportEurocopter France AS355N · Redding, CAFailure of the pilot to maintain adequate obstruction clearance during landing, which resulted in the tail rotor contacting a brush pile. The accident sequence was precipitated by the initiation of a precautionary landing by the pilot due to a discrepancy…Apr 18, 2003 · N355J · Substantial damageNTSB SEA03FA165Accident · 2 fatalField investigationFinal reportCessna 320D · Mazama, WAThe pilot's failure to maintain clearance from terrain while maneuvering. Mountainous terrain, trees and mountain obscuration were factors.Apr 17, 2003 · N4178T · Substantial damageNTSB CHI03LA106Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Benson, MNThe loss of engine power for undetermined reasons.Apr 13, 2003 · N5519X · Substantial damageNTSB CHI03LA104Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Lino Lakes, MNThe pilot not maintaining aircraft control while manuevering.Apr 13, 2003 · N26HW · Substantial damageNTSB NYC03FA082Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Conesus, NYThe flight instructor's failure to maintain adequate airspeed which resulted in an inadvertent spin.Apr 12, 2003 · N8985J · DestroyedNTSB SEA03TA060Accident · No injuriesFinal reportMcDonnell Douglas 369E · Plentywood, MTAircraft control was not maintained during a hovering turn. High wind conditions and excessive remedial action were factors.Apr 11, 2003 · N91620 · Substantial damageNTSB MIA03LA094Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT- 401 · Fellsmere, FLThe poor in-flight planning by the pilot-in-command for his overhsooting the pull-up following a spray pass resulting in the in-flight collision with trees then terrain. Contributing to the accident was sunglare that the pilot encountered during the spray…Apr 8, 2003 · N4549N · DestroyedNTSB SEA03LA058Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Taholah, WAThe entanglement of the fuel quantity sender float in the start pump wiring within the fuel tank as a result of the wiring not being properly secured. This rendered the fuel gauge inaccurate and the low fuel warning light inoperative which led to fuel…Apr 7, 2003 · N5225C · Substantial damageNTSB FTW03LA124Accident · No injuriesLimited investigationFinal reportRobinson R22 · Freer, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel en route. A contributing factor was the lack of suitable terrain available for the forced landing.Apr 5, 2003 · N9071K · Substantial damageNTSB FTW03LA122Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Monroe, LAThe pilot's failure to maintain control of the helicopter. A contributing factor was the crosswind.Apr 5, 2003 · N86238 · Substantial damageNTSB LAX03LA125Accident · No injuriesLimited investigationFinal reportVortec 99 · El Cajon, CAA loss of engine power for undetermined reasons.Apr 4, 2003 · N6052T · Substantial damageNTSB LAX03FA124Accident · 2 fatalField investigationFinal reportCessna 172P · North Las Vegas, NVthe applicant pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in an inadvertent stall/spin.Apr 4, 2003 · N553CH · DestroyedNTSB MIA03LA092Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Pahokee, FLThe instructor's inadequate in-flight decision and his delay in taking remedial actions. Also causal was the student pilot's failure to maintain airspeed which resulted in a stall. Low altitude flight is a contributing factor.Apr 3, 2003 · N6488H · Substantial damageNTSB DEN03LA062Accident · No injuriesLimited investigationFinal reportHughes 369D · Estes Park, COthe failure of the pilot-in-command to maintain clearance from terrain. Factors include the high density altitude and the pilot-in-command's improper in-flight planning.Apr 2, 2003 · N56SM · Substantial damageNTSB LAX03LA122Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Avondale, AZThe pilot failed to maintain adequate visual lookout and did not maintain clearance from power lines. The backhoe's location, which caused the pilot to alter his planned flight path, was a factor.Apr 1, 2003 · N30913 · Substantial damage