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 DFW05LA179Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance with terrain during aerial application.Jul 12, 2005 · N9086V · Substantial damageNTSB CHI05CA183Accident · Serious injuriesData collectionFinal reportRockwell S-2R · Guelph, NDThe pilot's failure to maintain clearance to the guy wire during the agricultural application pass. Contributing factors were the guy wire, and low altitude flight.Jul 12, 2005 · N4232X · Substantial damageNTSB NYC05FA117Accident · 2 fatalField investigationFinal reportCarlstrom Long EZ · Lewes, DEThe Long EZ pilot's failure to maintain clearance from the RV-8 airplane, which resulted in a mid-air collision during a formation flight.Jul 10, 2005 · N78LC · 2 aircraft · DestroyedNTSB ATL05LA126Accident · 1 fatalLimited investigationFinal reportEllsworth Sky Bolt · Cumming, GAThe pilot's improper fuel management while maneuvering resulting in a total loss of engine power due to fuel starvation.Jul 9, 2005 · N250SE · Substantial damageNTSB MIA05CA133Accident · Minor injuriesData collectionFinal reportRobinson R44 · St. Cloud, FLThe failure of the pilot to maintain clearance with a palm tree resulting in the in-flight collision with it, and subsequent uncontrolled descent and in-flight collision with the ground.Jul 7, 2005 · N90SG · Substantial damageNTSB SEA05LA138Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Oroville, WAThe failure of the throttle cable housing, which permitted the engine's RPM to decay to the idle position. Contributing factors were the trees and the lack of suitable terrain for a forced landing.Jul 5, 2005 · N38926 · Substantial damageNTSB IAD05LA094Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Conesus, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and collision with terrain.Jul 5, 2005 · N6028V · Substantial damageNTSB CHI05LA164Accident · 1 fatalLimited investigationFinal reportRockwell S-2R · Bristol, SDThe pilot's failure to maintain clearance with the static lines between the transmission towers. A factor associated with the accident were the static lines.Jul 5, 2005 · N3211R · Substantial damageNTSB NYC05LA113Accident · Serious injuriesLimited investigationFinal reportMeyer Atlantis · Pittstown, NJThe pilot's failure to maintain clearance from power lines, while returning to the airport after takeoff.Jul 4, 2005 · N98Y · Substantial damageNTSB LAX05LA224Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude and his decision to turn toward higher terrain.Jul 3, 2005 · N31AP · DestroyedNTSB ANC05LA094Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Whittier, AKThe pilot's becoming lost/disoriented while maneuvering due to inadequate in-flight planning/decision making, which resulted in fuel exhaustion and a forced landing in tree-covered terrain. A factor contributing to the accident was fuel exhaustion.Jul 3, 2005 · N8626V · Substantial damageNTSB MIA05LA129Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Glen Saint Mary, FLThe separation of a plastic sleeve off the idle stop of the servo fuel injector for undetermined reasons resulting in decreased fuel flow and subsequent total loss of engine power.Jul 2, 2005 · N53269 · Substantial damageNTSB DFW05CA177Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · Gillett, ARThe loss of engine power resulting from a disconnected discharge pressure line at the fuel control unit. A contributing factor was the lack of suitable terrain for the forced landing.Jul 1, 2005 · N6626K · Substantial damageNTSB DEN05LA102Accident · No injuriesLimited investigationFinal reportEnstrom 480B · Scofield, UTthe pilot's failure to maintain control of the helicopter. Contributing factor's include the pilot's failure to maintain clearance from terrain.Jun 29, 2005 · N480EH · Substantial damageNTSB SEA05LA128Accident · 1 fatalLimited investigationFinal reportEllsberg One Design · Madras, ORThe pilot's failure to maintain altitude/clearance from terrain while performing aerobatics which resulted in a collision with the ground.Jun 25, 2005 · N555TE · DestroyedNTSB SEA05CA132Accident · No injuriesData collectionFinal reportWeatherly 620B · Teton, IDThe pilot's failure to maintain clearance from power transmission lines while maneuvering.Jun 25, 2005 · N2021V · Substantial damageNTSB IAD05LA084Accident · No injuriesLimited investigationFinal reportBell 206B · Cleveland, OHA failure of the main drive shaft for undetermined reasons, which resulted in a total loss of engine power. A factor was pilot's improper flare, which resulted in a hard landing.Jun 25, 2005 · N1212N · Substantial damageNTSB CHI05CA159Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Osage Beach, MOThe pilot not maintaining clearance from the water while maneuvering for photographs.Jun 25, 2005 · N7195L · DestroyedNTSB IAD05LA083Accident · 1 fatalLimited investigationFinal reportTitan Tornado · Bath, PAThe pilot/owner's failure to maintain adequate airspeed following a loss of engine power, which resulted in an inadvertent stall/spin. Factors in the accident were the stripped spark plug threads, and an inadequate preflight inspection by the pilot/owner.Jun 23, 2005 · UNREG · DestroyedNTSB DFW05LA171Accident · 1 fatalLimited investigationFinal reportCessna A188B · Piggott, ARThe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall.Jun 23, 2005 · N9071R · DestroyedNTSB ATL05LA111Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Yadkinville, NCThe pilots failure to maintain adequate clearance from object and inadequate visual look-out while maneuvering resulted in an in-flight collision with power lines.Jun 23, 2005 · N6912H · Substantial damageNTSB ATL05LA110Accident · 1 fatalLimited investigationFinal reportCasten Rans S-10 · Perry, SCA loss of engine power due to fuel starvation as a result of the pilot mismanagement. Contributing to the accident was the pilot's failure to maintain adequate airspeed resulting in a stall during the forced landing.Jun 23, 2005 · N327AN · Substantial damageNTSB DFW05CA172Accident · Serious injuriesData collectionFinal reportGarlick Helicopters OH-58A+ · Graham, TXThe pilot's failure to maintain clearance with the wire while maneuvering during an aerial application flight. Low altitude flight is a contributing factor.Jun 22, 2005 · N372NS · Substantial damageNTSB SEA05CA122Accident · Minor injuriesData collectionFinal reportBell 47G-3B-1 · Brewster, WAThe pilot's inadvertent anti-torque pedal input, which resulted in a loss of control and collision with trees while hovering.Jun 19, 2005 · N8554F · Substantial damageNTSB NYC05FA100Accident · 1 fatalField investigationFinal reportCessna 182Q · Stockholm, NJThe pilot's failure to maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the ground. Factors in this accident were clouds, and the pilot's spatial disorientation.Jun 19, 2005 · N21005 · DestroyedNTSB CHI05LA149Accident · 1 fatalLimited investigationFinal reportCessna 188 · Senath, MOThe pilot's failure to maintain clearance from the tower guy wires. A factor was the extra antenna guy wire.Jun 19, 2005 · N9778G · DestroyedNTSB IAD05MA078Accident · Serious injuriesMajor investigationFinal reportSikorsky S-76C · New York, NYAn inadvertent encounter with a left quartering tailwind. Factors in the accident were settling with power, the high gross weight of the helicopter, and the crew's failure to accurately assess the winds in the area.Jun 17, 2005 · N317MY · Substantial damageNTSB DFW05LA162Accident · 1 fatalLimited investigationFinal reportWsk-Pzl Mielec M18B · Eudora, ARThe pilot's failure to maintain clearance from the tree.Jun 17, 2005 · N16836 · DestroyedNTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.Jun 17, 2005 · N122AR · DestroyedNTSB IAD05LA077Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Southampton, NJA lack of lubrication for undetermined reasons which resulted in the failure of the Nos. 4 and 5 connecting rods, and a subsequent total loss of engine power. A factor in the accident was the furrowed cornfield.Jun 15, 2005 · N4754Y · Substantial damageNTSB LAX05LA204Accident · 1 fatalLimited investigationFinal reportBellanca 7GCBC · Woodfords, CAthe pilot's failure to maintain an adequate airspeed while turning in strong wind conditions, which resulted in a stall/spin. A factor in the accident was the high density altitude.Jun 14, 2005 · N8634 · Substantial damageNTSB NYC05LA096Accident · 1 fatalLimited investigationFinal reportHall Maxair Drifter · Gloucester, VAThe in-flight separation of the empennage, which resulted in a loss of control and subsequent impact with the ground.Jun 12, 2005 · N9238V · Substantial damageNTSB LAX05CA200Accident · Minor injuriesData collectionFinal reportAviat Pitts S-1T · Fillmore, CAthe pilot's failure to affect timely recovery from an intentional inverted flat spin.Jun 12, 2005 · N647J · DestroyedNTSB SEA05LA114Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-4B · Wenatchee, WAThe pilot's failure to maintain terrain clearance for undetermined reasons.Jun 11, 2005 · N1198Z · DestroyedNTSB DFW05CA166Accident · No injuriesData collectionFinal reportRockwell International S-2R · Watson, ARThe loss of engine power for undetermined reasons and the pilot's failure to maintain adequate airspeed which resulted in a stall.Jun 11, 2005 · N8856Q · Substantial damageNTSB DFW05CA155Accident · No injuriesData collectionFinal reportCessna A188B · Goodlett, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain (soft) for the forced landing.Jun 11, 2005 · N4919R · Substantial damageNTSB DFW05CA176Accident · No injuriesData collectionFinal reportCessna A188B · Truman, ARThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A contributing factor was the sunglare.Jun 10, 2005 · N4842R · Substantial damageNTSB DEN05CA085Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Wallsburg, UTthe flight instructor's inadequate in-flight planning and decision making and failure to maintain aircraft control. Contributing factor's include the flight instructor's inadequate supervision of the flight, the student pilot's failure to maintain rotor rpm,…Jun 7, 2005 · N993RW · Substantial damageNTSB LAX05GA192Accident · Serious injuriesFinal reportEurocopter AS 350 B2 · Bisbee, AZthe pilot's failure to maintain an adequate forward airspeed, which resulted in an in-flight loss of control due to a loss of tail rotor effectiveness, while operating near the out of ground effect hover capability of the helicopter. Contributing factors to…Jun 2, 2005 · N5205F · Substantial damageNTSB DFW05CA144Accident · Minor injuriesData collectionFinal reportHughes 269A · Sherman, TXThe applicant's failure to maintain directional control of the helicopter during a simulated power failure from a hover and the FAA inspector's delayed remedial action resulted in a dynamic rollover.Jun 1, 2005 · N62269 · Substantial damageNTSB DFW05LA140Accident · Serious injuriesLimited investigationFinal reportDebus/Mountain/Bowes Debus-Casst-Snoshoo · Oklahoma City, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the loss of engine power as result of the fracture of the number two piston to crankshaft connecting rod.May 29, 2005 · N102MB · Substantial damageNTSB LAX05FA189Accident · Serious injuriesField investigationFinal reportRobinson R44 · Lucerne Valley, CAthe pilot's failure to maintain adequate main rotor rpm and directional control while maneuvering at low altitude. Contributing factors in the accident were the helicopter's gross weight in excess of the maximum hover out of ground effect limit, a high…May 28, 2005 · N7015Q · DestroyedNTSB DFW05LA138Accident · 1 fatalLimited investigationFinal reportStearman D75 · Taylor, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was low altitude selected by the pilot.May 28, 2005 · N56259 · Substantial damageNTSB LAX05LA187Accident · Serious injuriesLimited investigationFinal reportBell 47G-4A · Bakersfield, CAthe pilot's inadequate visual lookout and failure to maintain clearance from the power lines.May 25, 2005 · N110DT · DestroyedNTSB DFW05CA132Accident · Minor injuriesData collectionFinal reportWeatherly 201B · Tornillo, TXThe loss of engine power as result of the failure of a cylinder.May 24, 2005 · N1284W · Substantial damageNTSB DEN05LA082Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Provo, UTthe dual student’s failure to maintain adequate rotor rpm and the inadequate supervision by the instructor.May 23, 2005 · N553SH · Substantial damageNTSB ATL05FA086Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Conway, SCThe pilot's failure to maintain airspeed while maneuvering after releasing a banner aerial sign, resulting in an inadvertent stall and collision with the ground. A factor in the accident was the flight instructor's improper supervision of the pilot receiving…May 23, 2005 · N9951Q · DestroyedNTSB NYC05FA086Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edinburg, OHThe pilot's failure to maintain aircraft control.May 22, 2005 · N217AW · Substantial damageNTSB IAD05FA067Accident · 4 fatalField investigationFinal reportCessna 172S · Brooklyn, NYThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent impact with terrain.May 21, 2005 · N778LP · Substantial damageNTSB DFW05LA126Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Ralls, TXThe pilot's failure to maintain clearance from the antenna tower. Contributing factors were the recency of the tower's construction and the lack of obstruction lights on the tower.May 19, 2005 · N9017Z · Destroyed