OpenAirDocs.org

NTSB investigations

18,849 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 CEN18LA311Accident · No injuriesLimited investigationFinal reportCessna 188 · Watkins, MNA partial loss of engine power for reasons that could not be determined because a postaccident examination revealed no evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.Aug 2, 2018 · N5523S · Substantial damageNTSB CEN18WA343Accident · 1 fatalForeign investigationPiper PA25 · Namiquipa, MexicoOn August 1, 2018, about 0956 hours mountain daylight time, a Piper PA-25-235 single-engine airplane, serial number 25-4177, Mexican registration XB-FMA, crashed in an agricultural field near Namiquipa, Mexico. The pilot was fatally injured. The local aerial…Aug 1, 2018 · XB-FMA · DestroyedNTSB CEN18LA303Accident · Minor injuriesLimited investigationFinal reportBuchanan Kitfox IV · Loma, COThe pilot's improper decision to conduct a low-altitude flight over a river and his inadequate monitoring of the environment, which resulted in a collision with a cableway.Jul 31, 2018 · N125TY · Substantial damageNTSB ERA18FA206Accident · 3 fatalField investigationFinal reportPiper PA60 · Greenville, METhe pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall.Jul 30, 2018 · C-GRRS · DestroyedNTSB ERA18LA204Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Haverhill, NHThe pilot's failure to maintain clearance from trees while maneuvering the airplane at a very low altitude in a confined area while attempting to land on a river.Jul 29, 2018 · N221EZ · Substantial damageNTSB CEN18FA297Accident · 1 fatalField investigationFinal reportAeronca 7AC · Alexandria, MNThe pilot's intentional low-altitude flight, which resulted in an impact with power lines.Jul 29, 2018 · N85506 · Substantial damageNTSB GAA18CA453Accident · Minor injuriesData collectionFinal reportRobinson R44 · Elma, IAThe pilot's failure maintain clearance from power lines during an agricultural application flight.Jul 27, 2018 · N466EL · Substantial damageNTSB ERA18LA202Accident · No injuriesLimited investigationFinal reportCessna 150 · Matthews, NCThe student pilot's improper decision to conduct a solo flight without an endorsement to do so and to perform an off-airport landing based on a perceived performance issue with the airplane. Contributing to the accident was the pilot's lack of training and…Jul 26, 2018 · N1193Y · Substantial damageNTSB CEN18WA308Accident · 1 fatalForeign investigationAir Tractor AT301 · Ascension, Chihuahua, MexicoOn July 25, 2018, about 1600 coordinated universal time, a Mexican registered Air Tractor AT 301 airplane, XB-OVB, impacted terrain near Ascension, Chihuahua, Mexico. The pilot was fatally injured and the airplane sustained substantial damage. The local…Jul 25, 2018 · XB-OVB · Substantial damageNTSB CEN18LA292Accident · No injuriesClass 3 · LimitedFinal reportGrumman AA5 · Brazoria, TXThe propeller blade separation due to a fatigue fracture.Jul 23, 2018 · N74420 · Substantial damageNTSB CEN18WA305Accident · 1 fatalForeign investigationLavia Argentina PA-25-260 · Namiquipa, Chihuahua, MexicoOn July 22, 2018, about 1500 coordinated universal time, a Lavia Argentina S.A. PA-25-260 airplane, XB-EGL and Lavia Argentina S.A. PA-25-235 airplane, XB-DVX, collided during aerial application maneuvers near Namiquipa, Chihuahua, Mexico. The pilot of XB-EGL…Jul 22, 2018 · XB-EGL · 2 aircraft · Substantial damageNTSB CEN18LA281Accident · No injuriesLimited investigationFinal reportPiper PA28 · Shreveport, LAThe partial loss of engine power for reasons that could not be determined based on the available evidence.Jul 19, 2018 · N7080F · Substantial damageNTSB ERA18LA195Accident · No injuriesLimited investigationFinal reportEagle DW1 · Ider, ALFatigue failure of the No. 2 cylinder studs/through bolts and the fracture of the crankcase, which resulted in a total loss of engine power.Jul 18, 2018 · N8805X · Substantial damageNTSB CEN18FA277Accident · 1 fatalClass 2 · FieldFinal reportCessna 152 · Fort Rice, NDThe pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…Jul 17, 2018 · N24515 · Substantial damageNTSB CEN18LA269Accident · Serious injuriesLimited investigationFinal reportBell 47J · Franklin, INA total loss of engine power for reasons that could not be determined based on the available evidence.Jul 15, 2018 · N8568F · DestroyedNTSB WPR18FA195Accident · 3 fatalClass 3 · FieldFinal reportCessna 172 · Deer Park, WAAn in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.Jul 13, 2018 · N24442 · Substantial damageNTSB CEN18LA270Accident · Serious injuriesClass 3 · LimitedFinal reportAir Tractor AT 602 · Bismarck, ILA loss of control for reasons that could not be determined based on the available information.Jul 13, 2018 · N629LA · Substantial damageNTSB CEN18IA273Incident · No injuriesIncident investigationFinal reportCessna A188B · Rockford, OHThe total loss of engine power, which resulted from the separation of the No. 2 connecting rod due to oil starvation as a result of insufficient clamping force of the engine's through-bolts.Jul 12, 2018 · N2483J · Minor damageNTSB CEN18FA263Accident · 1 fatalField investigationFinal reportAir Tractor AT-602 · Wheatley, ARThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available evidence.Jul 11, 2018 · N8508P · DestroyedNTSB CEN18FA262Accident · 1 fatalField investigationFinal reportSchempp-Hirth Flugzeugbau Ventus 3F · Moriarty, NMThe pilot's exceedance of the glider's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall and subsequent impact with terrain.Jul 10, 2018 · N753R · Substantial damageNTSB WPR18LA189Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164B · Colusa, CATotal loss of engine power for reasons that could not be determined based on the available information.Jul 9, 2018 · N6696K · Substantial damageNTSB CEN18LA260Accident · No injuriesLimited investigationFinal reportBell 206 · Bentley, ILThe pilot's failure to ensure that adequate fuel was on board for the maneuvering flight, which resulted in a total loss of engine power due to fuel starvation.Jul 6, 2018 · N224KM · Substantial damageNTSB CEN18FA258Accident · 1 fatalField investigationFinal reportBell 47G · Arlington, INThe inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.Jul 6, 2018 · N96195 · Substantial damageNTSB CEN18FA242Accident · 1 fatalField investigationFinal reportChampion 7GCAA · Arthur, NEThe pilot's failure to recover from a spin for reasons that could not be determined based on the available information.Jun 29, 2018 · N9026L · Substantial damageNTSB WPR18WA185Accident · 5 fatalForeign investigationBeech C90 · Mumbai, IndiaOn June 28, 2018, at 0740 Universal Coordinated Time, a King Air C90 airplane, VT-UPZ, was destroyed when it impacted the ground near Mumbai, India. The airplane was operated under the pertinent regulations of the Government of India. The two pilots, two…Jun 28, 2018 · VT-UPZ · DestroyedNTSB WPR18FA186Accident · 1 fatalClass 3 · FieldFinal reportCessna 320 · Eagle Mountain, UTThe pilot's exceedance of the airplane's critical angle of attack and the airplane experiencing an aerodynamic stall at too low an altitude to recover.Jun 28, 2018 · N320MF · DestroyedNTSB GAA18CA383Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Malin, ORThe pilot’s misjudgment of the approach and his subsequent exceedance of the airplane’s critical angle of attack during an agricultural application flight, which resulted in an aerodynamic stall and collision with power lines.Jun 27, 2018 · N151QC · Substantial damageNTSB ANC18WA060Accident · No injuriesForeign investigationBell 205 · Hudson Bay, CanadaOn June 27, 2018, at 1713 central standard time, a Canadian registered Bell 205A helicopter, C-FYHD, operated by Transwest Air Ltd Partnership, was substantially damaged during a precautionary landing due to severe airframe vibration at Buckmayer Lake,…Jun 27, 2018 · C-FYHD · Substantial damageNTSB WPR18LA181Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Phoenix, AZA total loss of engine power due to crankshaft failure as the result of a subsurface fatigue crack.Jun 26, 2018 · N154ME · Substantial damageNTSB CEN18CA240Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Encino, TXThe gunner's failure to ensure that the net would not ensnare the helicopter's skids once deployed, which resulted in the pilot being unable to maintain helicopter control as the bull pulled on the net and subsequent impact with terrain.Jun 26, 2018 · N122CH · Substantial damageNTSB WPR18WA202Accident · Serious injuriesForeign investigationZlin Z242L · Hong Kong, ChinaOn June 24, 2018, at 1638 local time, a Zlin Z 242 L airplane, B-LUK, was substantially damaged when it collided with the ground near Ma Shi Chau, Hong Kong, China. The private pilot was seriously injured. The airplane was operated in accordance with the…Jun 24, 2018 · B-LUK · Substantial damageNTSB CEN18FA235Accident · 2 fatalField investigationFinal reportErcoupe 415 D · Monmouth, ILA loss of engine power for reasons that could not be determined based on the available information.Jun 24, 2018 · N94070 · DestroyedNTSB WPR18FA178Accident · 1 fatalClass 2 · FieldFinal reportSchempp-Hirth Standard Cirrus · Aguila, AZThe pilot's exceedance of the glider's critical angle of attack while attempting a thermal climb at low altitude, which resulted in an aerodynamic stall/spin at an altitude that precluded recovery.Jun 23, 2018 · N7880 · Substantial damageNTSB WPR18LA177Accident · Minor injuriesClass 3 · LimitedFinal reportSchempp Hirth Flugzeugbau Arcus M · Richfield, UTAn inflight loss of control and subsequent inflight breakup for reasons that could not be determined based on the available information.Jun 21, 2018 · N16DN · DestroyedNTSB WPR18LA176Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 18-150 · Yellow Pine, IDThe pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…Jun 21, 2018 · N1979P · Substantial damageNTSB GAA18CA371Accident · No injuriesData collectionFinal reportAir Tractor AT 301 · Hutchinson, MNThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.Jun 20, 2018 · N3169D · Substantial damageNTSB CEN18FA232Accident · 1 fatalClass 2 · FieldFinal reportAir Tractor AT 502B · Enid, OKThe pilot's failure to see and avoid a known obstacle (communications tower) during agricultural spraying operations.Jun 19, 2018 · N2063B · DestroyedNTSB WPR18WA180Accident · 5 fatalForeign investigationPiper PA31 · Antananarivo, MadagascarOn June 18, 2018, about 0615 local time, a Piper PA-31 airplane, 5R-MKF, impacted terrain about 5 nautical miles from the Ivato International Airport, Antananarivo, Madagascar. The pilot in command, two pilot observers, pilot monitor, and one passenger were…Jun 18, 2018 · 5R-MKF · Substantial damageNTSB GAA18CA352Accident · No injuriesData collectionFinal reportBell 206 · Orondo, WAThe pilot's failure to maintain clearance from power lines while maneuvering at low altitude.Jun 17, 2018 · N2762P · Substantial damageNTSB GAA18CA378Accident · No injuriesData collectionFinal reportMcdonnell Douglas Heli 369 · Yabucoa, PRThe pilot's failure to maintain main rotor clearance from a fiber line while picking up a lineman.Jun 16, 2018 · N900FF · Substantial damageNTSB CEN18LA226Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Arrey, NMThe pilot's failure to maintain clearance from a hillside during an agricultural application flight while facing the sun.Jun 15, 2018 · N6672Q · Substantial damageNTSB CEN18FA227Accident · 2 fatalField investigationFinal reportCessna 172N · Rotan, TXThe pilot's reckless decision to conduct low-level flight over a canyon, resulting in the airplane's impact with power lines and terrain.Jun 15, 2018 · N734BS · DestroyedNTSB ERA18LA168Accident · No injuriesClass 3 · LimitedFinal reportStinson L 5 · Thomson, GAFailure of maintenance personnel to inspect the crankshaft after two previous propeller strikes, which resulted in failure of the crankshaft and a total loss of engine power. Contributing to the crankshaft failure was insufficient torque applied to the thrust…Jun 14, 2018 · N45TX · Substantial damageNTSB CEN18WA231Accident · 1 fatalForeign investigationAir Tractor AT802 · Mallorca, SpainOn June 12, 2018, about 1600 hours universal coordinated time, an Air Tractor AT-802 airplane, Spanish registration EC-GVN, was substantially damaged during an agricultural application flight near Mallorca, Spain. The pilot sustained fatal injuries. The local…Jun 12, 2018 · EC-GVN · Substantial damageNTSB CEN18FA217Accident · 2 fatalField investigationFinal reportLet L 23 Super Blanik · Moose, WYThe pilot's encounter with atmospheric conditions that resulted in a loss of lift and a subsequent loss of control near terrain that precluded recovery. Contributing to the accident was the pilot's failure to follow the operator's published tour flight…Jun 9, 2018 · N317BA · DestroyedNTSB CEN18FA215Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 · Oshkosh, WIThe pilot's decision to fly over the river at a low altitude and his failure to maintain clearance with wires during low-level flight.Jun 9, 2018 · N529DW · Substantial damageNTSB ANC18FA044Accident · 2 fatalClass 2 · FieldFinal reportPiper PA18 · Sitka, AKThe pilot's exceedance of the airplane's critical angle of attack for unknown reason, which resulted in an aerodynamic stall and a loss of control.Jun 9, 2018 · N1203A · Substantial damageNTSB CEN18WA234Accident · 1 fatalForeign investigationPiper PA-25 · Cajeme, Sonora, MexicoOn June 7, 2018, a Mexican registered Piper PA-25, XB-YEI, impacted electrical cables and terrain near Cajeme, Sonora, Mexico. The pilot received fatal injuries. The airplane sustained substantial damage. The flight departed Cajeme, Mexico, on a local aerial…Jun 7, 2018 · XB-YEI · Substantial damageNTSB GAA18CA357Accident · No injuriesData collectionFinal reportBellanca 7ECA · Fairbanks, AKThe airplane’s collision with a bird while maneuvering.Jun 6, 2018 · N8646V · Substantial damageNTSB WPR18LA164Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Sanders, KYA partial loss of engine power for undetermined reasons, and a loss of main rotor rpm during the subsequent autorotation, which resulted in a hard landing.Jun 5, 2018 · N518Z · Substantial damage