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 FTW95LA241Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Denver City, TXThe loss of engine power due to a fracture of the #3 cylinder resulting in the total failure of the cylinder. A factor was the lack of suitable terrain for the forced landing.Jun 13, 1995 · N15111 · DestroyedNTSB CHI95LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bay City, MIFailure of the pilot to maintain clearance from obstacles and his intentional buzzing.Jun 13, 1995 · N5256T · Substantial damageNTSB ATL95LA109Accident · No injuriesLimited investigationFinal reportCessna 188 · Red Springs, NCInadequate maintenance that overlooked corrosion of the exhaust manifold, which resulted in an exhaust manifold leak, an in flight fire, and a complete loss of engine power.Jun 13, 1995 · N4916Q · Substantial damageNTSB ATL95LA108Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Garfield, GAThe pilot's failure to maintain flying speed during a climbout from a swath run which resulted in a stall and the subsequent collision with trees.Jun 13, 1995 · N53340 · DestroyedNTSB NYC95LA132Accident · No injuriesLimited investigationFinal reportBeech 33 · Franklin Twp, PAThe pilot's improper planning/decision, his continued flight into adverse weather conditions, and his delay in reversing course (diverting to a new destination). The adverse weather with thunderstorms was a related factor.Jun 12, 1995 · N943T · Substantial damageNTSB FTW95FA238Accident · 1 fatalField investigationFinal reportSmith LONG-EZ · Cloudcroft, NMThe pilot's failure to maintain clearance from trees. Factors were the pilot exceeded the allowable maximum gross weight of the airplane, the rising terrain, and high density altitude.Jun 12, 1995 · N86PD · DestroyedNTSB FTW95IA243Incident · No injuriesIncident investigationFinal reportCessna 150L · Levelland, TXThe failure of the pilot of the other aircraft to maintain clearance during a formation flight. A factor was the lack of experience in the type of operation.Jun 11, 1995 · N10964 · 2 aircraft · Minor damageNTSB BFO95LA062Accident · 1 fatalLimited investigationFinal reportBerg Steen Skybolt · Bath, NYthe pilot's failure to maintain sufficient altitude/clearance to avoid trees while performing aerobatic maneuvers. Related factors are the low altitude at which the maneuver was initiated and the delayed recovery/pull-up.Jun 11, 1995 · N3753B · DestroyedNTSB MIA95LA168Accident · No injuriesLimited investigationFinal reportContinental Copters Tomcat MK 6C · Arcadia, FLInadequate preflight of the helicopter by the pilot-in-command by failure to assure adequate fuel for the flight. Contributing to the accident was the unsuitable terrain encountered during the forced landing.Jun 10, 1995 · N9034T · Substantial damageNTSB FTW95LA234Accident · 2 fatalLimited investigationFinal reportJoy Genesis · Kerrville, TXFailure of the pilot to maintain adequate airspeed, while manuevering at low altitude, which resulted in a stall and collision with the terrain. Factors relating to the accident were: the unfavorable wind, the pilot's overconfidence in his ability, and his…Jun 10, 1995 · N8099K · DestroyedNTSB FTW95FA232Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Joaquin, TXThe performance of aerobatics at low altitude and the inadvertent stall.Jun 7, 1995 · N8754 · DestroyedNTSB FTW95FA231Accident · 1 fatalField investigationFinal reportWeatherly 620B · Flagler, COFailure by the pilot to maintain clearance from the static line of a power transmission array during an aerial application flight.Jun 6, 1995 · N20119 · DestroyedNTSB LAX95LA202Accident · Minor injuriesLimited investigationFinal reportBellanca 8KCAB · Mission Viejo, CAthe loss of engine power due to the failure of company maintenance personnel to correctly connect the throttle arm and throttle linkage during engine installation.Jun 5, 1995 · N5540K · Substantial damageNTSB SEA95LA112Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Caldwell, IDThe pilot's failure to maintain clearance from power lines. Factors include sunglare encountered when he turned into the sun.Jun 4, 1995 · N9474F · DestroyedNTSB FTW95LA230Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Checotah, OKThe pilot allowing the helicopter to touchdown improperly. A factor was the erratic running engine.Jun 4, 1995 · N4254X · Substantial damageNTSB LAX95LA201Accident · Serious injuriesLimited investigationFinal reportCessna 180F · Cartago, CAthe pilot's inflight decision to attempt a low pass over a mountain airstrip at a high density alitude atmospheric condition, and, his failure to retract the flaps during the climb-out from the pass. The rising mountainous terrain surrounding the landing…Jun 3, 1995 · N2198Z · Substantial damageNTSB ANC95FA063Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Palmer, AKThe pilot's inadvertent stall. A factor in the accident was the pilot's emotional reaction to the vehicle travelling through his yard.Jun 3, 1995 · N32708 · Substantial damageNTSB SEA95LA110Accident · 1 fatalLimited investigationFinal reportGarlick TH-1L · Umpqua, ORThe pilot's failure to maintain clearance with a tree, resulting in a tail rotor blade strike on the tree which disabled the tail rotor. Contributing to the accident was the 150-foot-high rock bluff.Jun 1, 1995 · N27FL · Substantial damageNTSB CHI95LA163Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · E. Grand Forks, MNThe pilot's failure to maintain clearance with the wires.Jun 1, 1995 · N6682K · Substantial damageNTSB FTW95LA239Accident · No injuriesLimited investigationFinal reportBell 47G-5 · Falfurrias, TXInadvertent installation of an unapproved part (tail rotor gear/drive assembly), that became excessively worn since it did not conform to the manufacturer's specification, resulting in failure of the associated tail rotor bearing (also an unapproved part),…May 30, 1995 · N1502L · Substantial damageNTSB CHI95LA160Accident · 1 fatalLimited investigationFinal reportWeatherly 201C · Clarks, NEa partial failure of the engine supercharger.May 30, 1995 · N9038W · DestroyedNTSB SEA95LA108Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301A · Terreton, IDThe pilot's failure to maintain an adequate altitude to overcome the downdraft. The downdraft was a factor.May 29, 1995 · N31580 · Substantial damageNTSB LAX95LA195Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Robbins, CAa loss of engine power due to a separation of the number 6 cylinder, and the nose over during the subsequent forced landing.May 25, 1995 · N6774K · Substantial damageNTSB SEA95LA105Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hillsboro, ORThe student pilot's failure to maintain directional control while hovering, which resulted in the aircraft colliding with terrain. Contributing to the accident were gusting wind conditions.May 24, 1995 · N461H · Substantial damageNTSB LAX95LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Redding, CAthe pilot's improper use of the flight controls. The downward-sloping terrain and the intermittent gusty wind conditions were factors in this accident.May 21, 1995 · N8363Q · Substantial damageNTSB MIA95LA131Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350B · Tampa, FLThe failure of the pilot to follow manufacturers procedures after failure of the hydraulic system resulting in loss of control of the helicopter. Contributing to the accident was the failure of maintenance personnel to follow manufacturers procedures for…May 20, 1995 · N35AH · Substantial damageNTSB LAX95LA192Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Colusa, CAthe pilot's misjudged flare height and timing, which resulted in an inadvertent stall and hard landing. Factors in the accident were the loss of engine power for undetermined reasons and the lack of a suitable forced landing area.May 19, 1995 · N9830 · Substantial damageNTSB FTW95LA213Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Caldwell, ARThe loss of power due to a crack in the #4 cylinder. Factors were the lack of suitable terrain for the forced landing and proper touchdown point not possible.May 19, 1995 · N3655Z · Substantial damageNTSB FTW95LA205Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · St Martinville, LAThe pilot's failure to maintain control of the aircraft. A factor was the high winds.May 17, 1995 · N8365K · DestroyedNTSB NYC95LA110Accident · 1 fatalLimited investigationFinal reportHighcraft Buccaneer II · Millstone Twsp, NJThe loss of engine power due to the seizure of the number one cylinder pistion and the pilot's failure to maintain adequate airspeed which resulted in a stall.May 16, 1995 · UNREG · DestroyedNTSB FTW95LA199Accident · No injuriesLimited investigationFinal reportFairchild F-23A · Ozark, ARThe inadvertent stall while executing the turn to reverse direction during an aerial application flight.May 15, 1995 · N1133Z · Substantial damageNTSB FTW95LA202Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Joes, COA total loss of power due to fuel exhaustion. Factors were: a malfunction in the fuel measuring system, the pilot's failure to perform fuel consumption calculations, and soft and unsuitable terrain for a forced landing.May 14, 1995 · N9506 · Substantial damageNTSB NYC95LA107Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Newark, DEThe pilot's improper use of throttle and collective controls, resulting in the loss of rotor rpm and the inflight loss of control.May 13, 1995 · N122HA · Substantial damageNTSB FTW95LA197Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Abbeville, LAThe inadvertent stall.May 12, 1995 · N8509H · Substantial damageNTSB LAX95LA184Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Honolulu, HIthe pilot's attempted flight in close proximity to terrain under gusty wind conditions at an inadequate terrain clearance altitude.May 11, 1995 · N7768S · DestroyedNTSB NYC95DEI01Accident · 1 fatalFinal reportStaudacher S-600 · Wellington, OHloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in a stall and collision with the ground.May 8, 1995 · N600RT · DestroyedNTSB SEA95LA094Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Stayton, ORA power loss for undetermined reason(s). A factor was the soft terrain.May 7, 1995 · N6895Q · Substantial damageNTSB LAX95LA181Accident · Minor injuriesLimited investigationFinal reportCessna 172A · Colusa, CAthe pilot's selection of an inadequate en route cruise altitude for the aerial observation flight, and his failure to identify and stop an inadvertent descent while flying over flooded terrain at a very low altitude. Lack of pilot experience in low level…May 7, 1995 · N7358T · DestroyedNTSB LAX95LA180Accident · Serious injuriesLimited investigationFinal reportDavenport LONG-EZ · Los Angeles, CAfuel starvation due to a modification of the fuel system that rendered it incapable of maintaining adequate fuel pressure. The builder/pilot's lack of understanding of the fuel system was a factor in this accident.May 7, 1995 · N41BF · DestroyedNTSB SEA95LA092Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Bliss, IDThe pilot's continued VFR flight into instrument meteorological conditions. Factors include low ceiling, rain and fog.May 6, 1995 · N3728N · DestroyedNTSB SEA95FA093Accident · 2 fatalField investigationFinal reportCessna 152 · Snoqualmie Pass, WAThe pilot's attempt to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance with the terrain.May 6, 1995 · N855DA · DestroyedNTSB NYC95LA100Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Middleboro, MAthe pilot's failure to maintain airspeed during a low altitude aerial application turn, which resulted in inadvertent settling with power and the subsequent collision with the terrain.May 4, 1995 · N444GW · Substantial damageNTSB ANC95LA052Accident · No injuriesLimited investigationFinal reportCessna 205 · Anchorage, AKA failure of the engine driven fuel pump. Factors in the accident were the pilots' inadequate in-flight planning and unsuitable terrain in the area of the forced landing.May 4, 1995 · N8312Z · DestroyedNTSB SEA95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Anaconda, MTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain clearance from terrain.May 1, 1995 · N6288P · Substantial damageNTSB FTW95LA185Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Morse, LAPower loss due to a cracked intake valve pipe assembly. A factor was the lack of suitable terrain for the forced landing.Apr 29, 1995 · N6746K · DestroyedNTSB ATL95FA090Accident · 2 fatalField investigationFinal reportAxell, Charles Glasair RG-2 · Elberta, ALThe pilot's failure to maintain flying speed which resulted in a stall. A factor was the loss of engine power due to a blocked fuel injector nozzle.Apr 26, 1995 · N86XL · DestroyedNTSB ANC95LA049Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Old Harbor, AKThe pilot's continued flight into known adverse weather. The whiteout condition was a factor.Apr 26, 1995 · N1769U · DestroyedNTSB ATL95LA089Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Payne, ALThe inaequate visual lookout by both pilots. Factors were the radio reception difficulties of the 152 pilot, his failure to make position reports while maneuvering for a landing, and the failure of the 182 pilot to have a safety observer while conducting…Apr 25, 1995 · N5527M · 2 aircraft · Substantial damageNTSB FTW95FA349Accident · 4 fatalField investigationFinal reportCessna 172D · Tsaile, AZThe pilot's failure to maintain terrain clearance. Factors were the pilot's lack of mountain flying experience and the rising terrain.Apr 24, 1995 · N2587Y · DestroyedNTSB SEA95LA085Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Richfield, UTIce ingestion. Factors to the accident were: aircraft protective coverings were unavailable, inadequate preflight inspection, and uneven terrain.Apr 23, 1995 · N206AH · Substantial damage