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 NYC06LA167Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Toms River, NJCarburetor icing, and the pilot's delayed application of carburetor heat, which resulted in a loss of engine power, and subsequent force landing. A factor in the accident was carburetor icing conditions.Jul 1, 2006 · N50619 · Substantial damageNTSB SEA06LA135Accident · No injuriesLimited investigationFinal reportHughes 369D · Moab, UTThe failure of the collective bungee support bracket due to non-compliance with a service information notice, which resulted in the pilot executing a precautionary autorotative landing. A contributing factor was the lack of suitable terrain for the landing.Jun 30, 2006 · N369PB · Substantial damageNTSB CHI06FA173Accident · 1 fatalField investigationFinal reportBell 206B · Walford, IAThe pilot's failure to maintain clearance from powerlines. The powerlines were a factor.Jun 30, 2006 · N2877F · DestroyedNTSB LAX06CA221Accident · No injuriesData collectionFinal reportRobinson R-44 · Fresno, CAthe pilot's failure to maintain directional control following a loss of tail rotor effectiveness while in a downwind hover.Jun 29, 2006 · N52EP · Substantial damageNTSB LAX06LA220Accident · Minor injuriesLimited investigationFinal reportBell 206B · Chino Hills, CAA loss of aircraft control for undetermined reasons.Jun 28, 2006 · N205LA · Substantial damageNTSB ANC06FA080Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cooper Landing, AKThe pilot's failure to maintain adequate airspeed while performing a low level pass, which resulted in an uncontrolled descent and collision with terrain. A factor contributing to the accident was an inadvertent stall.Jun 28, 2006 · N7658H · Substantial damageNTSB CHI06LA163Accident · 1 fatalLimited investigationFinal reportVarga 2150A · Columbus, WIThe pilot's failure to maintain adequate clearance from the trees during the attempted low altitude pass along the river. Contributing factors were the intentional low altitude flight maneuver, the pilot's improper decision to attempt that maneuver, and his…Jun 25, 2006 · N8267J · DestroyedNTSB SEA06FA126Accident · 2 fatalField investigationFinal reportPilatus PC-12/47 · Big Timber, MTThe flight instructor's failure to maintain an adequate airspeed while maneuvering, which led to an inadvertent stall.Jun 24, 2006 · N768H · DestroyedNTSB NYC06FA154Accident · 4 fatalField investigationFinal reportCessna 172N · Newry, METhe flight instructor's failure to maintain altitude/clearance while maneuvering, which resulted in an impact with trees.Jun 22, 2006 · N572BA · DestroyedNTSB CHI06CA162Accident · Minor injuriesData collectionFinal reportWeatherly 201B · Bowbells, NDThe pilot's failure to maintain clearance to the rising terrain while maneuvering during the agricultural application flight. Contirbuting factors were the low altitude operation and the rising terrain.Jun 22, 2006 · N1263W · Substantial damageNTSB ANC06LA073Accident · Minor injuriesLimited investigationFinal reportMBB BK 117A-3 · Ponce de Leon, FLThe pilot's failure to maintain clearance from objects while hovering in ground effect, which resulted in an in-flight collision with a tree. Factors associated with the accident were loose, sand-covered terrain, and the operator's failure to ensure that the…Jun 22, 2006 · N913EF · Substantial damageNTSB SEA06LA124Accident · No injuriesLimited investigationFinal reportHughes 369D · Salt Lake City, UTA loss of rotor rpm for undetermined reasons, resulting in a hard landing on top of the commercial building over which the helicopter was working.Jun 20, 2006 · N88SE · Substantial damageNTSB DFW06LA163Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Colt, ARThe pilot's failure to maintain clearance with the ground during an aerial application flight.Jun 20, 2006 · N2292J · DestroyedNTSB LAX06FA206Accident · 4 fatalField investigationFinal reportCessna 180 · Payson, AZThe pilot's failure to maintain clearance from the terrain during a low level flyby maneuver. A factor was glare from the sun and shadows created by the mountainous terrain.Jun 18, 2006 · N1535C · Substantial damageNTSB CHI06LA157Accident · 1 fatalLimited investigationFinal reportGood RV-6A · Peru, ILFailure of the pilot of the second airplane in the formation to maintain clearance with the lead airplane during the overhead recovery maneuver prior to landing.Jun 18, 2006 · N86CG · 2 aircraft · DestroyedNTSB SEA06FA119Accident · 4 fatalField investigationFinal reportCessna 180 · Agness, ORThe pilot's failure to maintain obstacle clearance while maneuvering at low altitude, which resulted in an in-flight collision with a tree and subsequent collision with rocky terrain. A contributing factor was the sun glare.Jun 17, 2006 · N38SP · DestroyedNTSB CHI06CA155Accident · No injuriesData collectionFinal reportMcFarland Rotorway Exec · Mooresville, INAn in-flight fire for undetermined reasons.Jun 17, 2006 · N9164X · DestroyedNTSB NYC06CA172Accident · No injuriesData collectionFinal reportRotorway 162-F · Brookhaven, NYThe student pilot inadvertently allowing the skids to contact the ground resulting in dynamic rollover.Jun 16, 2006 · N549AB · Substantial damageNTSB NYC06LA144Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Mayville, NYThe flight instructor's improper decision to attempt a simulated engine failure at a low altitude and her failure to maintain clearance from trees and wires, while maneuvering. Also causal was the flight instructor's impairment from prescription medication.Jun 13, 2006 · N96486 · Substantial damageNTSB ATL06CA091Accident · Serious injuriesData collectionFinal reportKearn Breezy · Dover, NCThe pilot's failure to ensure the airplane contained adequate fuel for the flight resulting in a loss of engine power due to fuel exhaustion.Jun 12, 2006 · N15WK · Substantial damageNTSB LAX06LA204Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Camarillo, CAa loss of engine power for undetermined reasons. A factor was the soft terrain encountered during the emergency landing.Jun 11, 2006 · N452WC · Substantial damageNTSB SEA06FA115Accident · 2 fatalField investigationFinal reportCessna TU206G · Mullan, IDThe pilot's VFR flight into IMC and his subsequent failure to maintain terrain clearance. The pilot's inadequate inflight planning/decision, mountain obscuration, trees and high terrain were factors.Jun 8, 2006 · N5136X · Substantial damageNTSB LAX06LA198Accident · Serious injuriesLimited investigationFinal reportCessna 182B · El Dorado, CAA loss of engine power for undetermined reasons and encounter with trees during the forced landing.Jun 8, 2006 · N2404G · Substantial damageNTSB LAX06FA200Accident · 2 fatalField investigationFinal reportCessna 152 · Peoria, AZthe failure of both the flight instructor and student pilot to regain control of the airplane in a timely manner during an intentional spin maneuver, resulting in a collision with terrain. A factor in the accident was the instructor's inadequate supervision…Jun 8, 2006 · N627PA · Substantial damageNTSB DFW06CA156Accident · Minor injuriesData collectionFinal reportCampbell W/Smiley J Execytive 162F · Porter, TXThe pilot's loss of control after encountering dynamic rollover while hovering.Jun 8, 2006 · N17VH · Substantial damageNTSB SEA06LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Laurel, MTThe failure of maintenance personnel to properly reinstall the left-hand control yoke to the left-hand control column, and the failure of other maintenance personnel to properly verify the installation, which resulted in the pilot's loss of control in flight…Jun 2, 2006 · N1123W · Substantial damageNTSB DFW06CA150Accident · Serious injuriesData collectionFinal reportGrumman G-164B · Alex, OKThe pilot's failure to maintain clearance from the power transmission line(s). A contributing factor was the low altitude selected by the pilot.Jun 2, 2006 · N8225K · DestroyedNTSB ANC06LA067Accident · No injuriesLimited investigationFinal reportCessna 182 · Chenega Bay, AKA loss of engine power for an undetermined reason while maneuvering at low level over a beach, which resulted in an in-flight collision with rough terrain and a nose over. A factor in the accident was the rough/uneven terrain.Jun 2, 2006 · N21545 · Substantial damageNTSB SEA06LA112Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3T · Port Townsend, WAThe pilot's misjudgment of the airplane's height above the water during a precautionary landing which resulted in a hard landing. Contributing factors were glassy water conditions, fog, and the pilot's inadvertent VFR flight into IMC.Jun 1, 2006 · N606KA · Substantial damageNTSB DFW06CA158Accident · No injuriesData collectionFinal reportAyres S2R-600 · Childress, TXThe pilot's inability to maintain directional control while landing due to the failure of the rudder horn due to corrosion.Jun 1, 2006 · N70AF · Substantial damageNTSB ANC06LA066Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Juneau, AKThe pilot's failure to maintain adequate altitude/clearance from terrain while maneuvering in adverse weather conditions. Factors associated with the accident are the pilot's decision to continue flight into adverse weather, fog, whiteout and flat light…Jun 1, 2006 · N45RP · Substantial damageNTSB NYC06LA142Accident · Minor injuriesLimited investigationFinal reportWeatherly 201B · Southampton, NJThe failure of the engine's supercharger, which resulted in a loss of engine power, and subsequent forced landing.May 31, 2006 · N1281W · Substantial damageNTSB DEN06CA079Accident · Serious injuriesData collectionFinal reportCessna T210N · Santa Fe, NMthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and failure to refuel the airplane.May 29, 2006 · N7353C · Substantial damageNTSB ATL06CA088Accident · No injuriesData collectionFinal reportBellanca 7ECA · Gadsden, ALThe pilot's failure to maintain a visual lookout,while maneuvering at a low altitude resulting in an in-flight collision with a powerline.May 29, 2006 · N99NR · Substantial damageNTSB SEA06CA107Accident · No injuriesData collectionFinal reportTaplin Avid Flyer · Grants Pass, ORThe partial loss of engine power for undertermined reasons, resulting in a forced landing and substantial damage to the airplane. A contributing factor was the transmission wire.May 28, 2006 · N537MF · Substantial damageNTSB NYC06LA122Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Mattituck, NYA loss of engine power due to undetermined reasons.May 28, 2006 · N9244F · Substantial damageNTSB NYC06CA125Accident · No injuriesData collectionFinal reportRobinson R-22 · Sanford, METhe flight instructor's inadvertent encounter with settling-with-power, which resulted in a hard landing, and subsequent roll-over. A factor in the accident was the tailwind.May 28, 2006 · N720RJ · Substantial damageNTSB DFW06LA141Accident · Serious injuriesLimited investigationFinal reportRobinson R44 · Payne Springs, TXThe loss of engine power for undetermined reasons.May 28, 2006 · N42KJ · Substantial damageNTSB DFW06FA140Accident · 2 fatalField investigationFinal reportAviat A-1B · Edna, TXThe pilot's ostentatious display while maneuvering at low altitude which resulted in an inadvertent stall/spin and subsequent impact with the water.May 27, 2006 · N166MA · Substantial damageNTSB ATL06LA085Accident · No injuriesLimited investigationFinal reportHughes 269A · Concord, NCThe loss of engine power for undetermined reasons while maneuvering, resulting in a forced landing to uneven terrain and a roll over.May 26, 2006 · N269RS · Substantial damageNTSB LAX06CA180Accident · No injuriesData collectionFinal reportBell 47-G5 · Soledad, CAfuel exhaustion due to the pilot's inaccurate fuel consumption calculations and failure to refuel the helicopter which resulted in a loss of engine power.May 23, 2006 · N4741R · Substantial damageNTSB SEA06CA101Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Vaughn, WAThe loss of engine power due to carburetor ice. A contributing factor was the lack of suitable terrain for the forced landing.May 20, 2006 · N2426H · Substantial damageNTSB ANC06CA055Accident · No injuriesData collectionFinal reportRockwell International S-2R · Perry, FLThe pilot's failure to refuel the airplane before fuel exhaustion, which resulted in a loss of engine power while maneuvering, and a subsequent forced landing and collision with trees.May 18, 2006 · N5596X · Substantial damageNTSB ATL06LA079Accident · 1 fatalLimited investigationFinal reportTaylor Skybolt · Sharpsburg, GAThe pilot's loss of control while conducting aerobatic flight. Factors in the accident were the pilot's ostentatious display, and lack of recent and total experience in type of operation.May 14, 2006 · N78BJ · DestroyedNTSB NYC06LA115Accident · Serious injuriesLimited investigationFinal reportEmbraer 145LR · Winchester, VAThe passenger's failure to heed the flight attendant warning and the seat belt sign. A factor was the turbulence.May 13, 2006 · N653AE · No damageNTSB MIA06LA106Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Caribbean SeaThe failure of the pilot to maintain control of the airplane. A contributing factor in the accident was the spatial disorientation of the pilot, resulting in the in-flight loss of control.May 10, 2006 · N5033Y · DestroyedNTSB DFW06CA123Accident · Minor injuriesData collectionFinal reportBell 47G-2 · Rosenberg, TXThe pilots encounter with loss of tail rotor effectiveness during an aerial application flight. A contributing factor was the gusty winds.May 10, 2006 · N993B · Substantial damageNTSB ATL06FA076Accident · 2 fatalField investigationFinal reportPiper PA60-602P · Camp Hill, ALThe pilot's continued flight into known thunderstorms resulting in an in-flight break up. A factor in the accident was air traffic controller's failure to issue extreme weather radar echo intensity information displayed on the controller's radar to the pilot.May 10, 2006 · N68999 · DestroyedNTSB DFW06LA121Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-802A · Jasper, TXThe loss of engine power due to fuel exhaustion. A contributing factor was the lack of suitable landing for the pilot to execute the forced landing.May 1, 2006 · N8504T · Substantial damageNTSB LAX06LA151Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Discus B · Minden, NVthe pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall. A factor was the loss of thermal lift.Apr 29, 2006 · N13SG · Substantial damage