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 ATL95LA147Accident · 1 fatalLimited investigationFinal reportQuadcity Challenger I · Anniston, ALThe pilot's failure to maintain airspeed, following an undetermined engine malfunction.Jul 18, 1995 · UNREG · Substantial damageNTSB ATL95LA138Accident · 1 fatalLimited investigationFinal reportCessna 188B · Allendale, SCThe pilot's failure to maintain clearance from the guy wire.Jul 18, 1995 · N731EM · Substantial damageNTSB FTW95LA304Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Stratton, COThe pilot's excessive rate of descent as he initiated the swath run and operation of the aircraft over the maximum allowable gross weight.Jul 15, 1995 · N9801P · DestroyedNTSB ATL95LA136Accident · No injuriesLimited investigationFinal reportCessna 150F · Russellville, ALThe student pilot's failure to properly plan enough fuel for the solo cross country flight. A factor was the terrain.Jul 15, 1995 · N8085F · Substantial damageNTSB ANC95FA104Accident · 2 fatalField investigationFinal reportCessna 172A · Naknek, AKInadequate visual lookout by the pilot of the Piper PA-18. The PA-18 pilot's diverted attention was a related factor.Jul 15, 1995 · N9827T · 2 aircraft · DestroyedNTSB CHI95LA222Accident · No injuriesLimited investigationFinal reportHughes 269C · Crete, NEthe pilot's failure to maintain clearance with the runway marker.Jul 14, 1995 · N88007 · Substantial damageNTSB CHI95LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot's failure to maintain altitude and/or clearance at the beginning of the spray run. A factor was turbulence due to the different Air temperatures of adjoining terrain.Jul 12, 1995 · N8673S · Substantial damageNTSB NYC95LA157Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Queenstown, MDfailure of the fuselage longeron tubes due to fatigue, which resulted in partial separation (distortion) of the fuselage, partial loss of aircraft control, and a partial loss of engine power.Jul 11, 1995 · N260BF · Substantial damageNTSB FTW95LA288Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec PZL-M-18 · Carlisle, ARThe pilot delayed pull-up from a swath run and failed to maintain clearance from the obstruction (grain elevator). A factor relating to the accident was: the pilot's use of medications that were not approved for use while flying.Jul 11, 1995 · N4609P · DestroyedNTSB MIA95GA178Accident · 2 fatalFinal reportPiper L-21A · Lorida, FLThe pilot's failure to maintain airspeed while his attention was diverted.Jul 10, 1995 · N5425V · Substantial damageNTSB FTW95FA278Accident · 2 fatalField investigationFinal reportNorth American T-28B · Ramah, COThe aircrew allowed the airplane's design stress limits to be exceeded.Jul 9, 1995 · N28TP · DestroyedNTSB SEA95LA138Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burley, IDA total loss of engine power due to fatigue failure of the crankshaft. A factor in the accident was the lack of suitable terrain for the forced landing.Jul 8, 1995 · N8946H · Substantial damageNTSB FTW95LA283Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Widener, ARLoss of engine power for an undetermined reason. The proximity of power lines (obstruction) was a related factor.Jul 7, 1995 · N8972Q · Substantial damageNTSB ANC95FA101Accident · 6 fatalField investigationFinal reportPiper PA-32R-300 · Haines, AKThe pilot's failure to maintain an adequate altitude above and clearance from the surrounding terrain. A factor related to the accident was the pilot's improper decision to conduct the maneuver in such close proximity to the rising terrain.Jul 7, 1995 · N6281J · DestroyedNTSB SEA95LA143Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Odessa, WALoss of engine power due to a cracked cylinder.Jul 6, 1995 · N3662X · Substantial damageNTSB FTW95LA282Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Newport, ARA disconnected throttle push pull rod, due to inadequate maintenance. A factor relating to the accident was: the lack of suitable terrain for the forced landing.Jul 6, 1995 · N5654X · Substantial damageNTSB ANC95FA095Accident · 1 fatalField investigationFinal reportPiper PA-18 · Nulato, AKThe pilot's failure to maintain adequate airspeed and clearance (altitude) above the water, while maneuvering at low altitude. A factor related to the accident was: the pilot's improper decision to allow a passenger to accompany the flight without a seat belt.Jul 6, 1995 · N8324 · Substantial damageNTSB SEA95FA136Accident · 1 fatalField investigationFinal reportAlon Aircoupe A-2 · Cody, WYThe pilot's failure to maintain clearance from terrain while maneuvering to reverse course. A factor was the downdrafts encountered in the mountainous terrain.Jul 4, 1995 · N718RS · DestroyedNTSB LAX95LA238Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Rio Vista, CAThe result of a chafing failure of the left anti-torque control cable while the aircraft was in flight. An inadequate preflight inspection by the pilot-in-command, and an inadequate 100-hour inspection by company maintenance personnel were factors in this…Jul 3, 1995 · N1348Z · Substantial damageNTSB NYC95LA138Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Malone, NYthe pilot's improper use of the flight controls, which resulted in an accelerated stall, an in-flight loss of control, and an uncontrolled descent to the ground. A factor relating to the accident was: the pilot's decision to fly the airplane in an airshow…Jul 2, 1995 · N51KF · DestroyedNTSB ATL95LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Conway, SCThe pilot's failure to maintain aircraft control which resulted in the uncontrolled descent and collision with terrain.Jul 2, 1995 · N8048D · Substantial damageNTSB SEA95LA134Accident · No injuriesLimited investigationFinal reportCessna 210B · Lewiston, MTLoss of engine power due to undetermined reasons, and the lack of a suitable area for the forced landing.Jul 1, 1995 · N4GY · Substantial damageNTSB NYC95LA137Accident · No injuriesLimited investigationFinal reportField VARI-EZE · Malone, NYfailure of the propeller speed reduction unit due to an inadequate design change by the manufacturer, which resulted in a complete loss of thrust. A factor was the rough terrain.Jul 1, 1995 · CGMEZ · Substantial damageNTSB ANC95LA092Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate evaluation of the weather conditions, and improper inflight planning/decision to assure clearance from mountainous terrain. A factor relating to the accident was: the unfavorable/gusty wind condition.Jul 1, 1995 · N555WK · Substantial damageNTSB FTW95LA281Accident · No injuriesLimited investigationFinal reportCessna 172RG · Weston, TXThe pilot receiving instruction's failure to maintain clearance with power lines while maneuvering at low altitude and the flight instructor's inadequate supervision. A factor was the instructor's decision to allow the simulation to continue to such a low…Jun 29, 1995 · N9502D · Substantial damageNTSB NYC95LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Bridgewater, CTthe loss of engine power for undetermined reasons resulting in a forced landing, and a subsequent collision with trees.Jun 28, 1995 · N9176H · Substantial damageNTSB ANC95LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tyonek, AKThe pilot's failure to maintain clearance from tall vegetation during a low pass.Jun 28, 1995 · N5238N · Substantial damageNTSB ANC95LA089Accident · No injuriesLimited investigationFinal reportCessna 208 · Talkeetna, AKThe pilot's inadequate visual lookout during the turn.Jun 28, 1995 · N9825F · Substantial damageNTSB FTW95LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cheneyville, LAThe pilot's failure to maintain adequate airspeed at a low altitude.Jun 27, 1995 · N8685H · Substantial damageNTSB CHI95LA202Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Blue Rapids, KSthe leaking drain in the main fuel sump. Factors to the accident were the incorrect fuel indication, the ravine, fuel exhaustion, and the low rotor RPM.Jun 27, 1995 · N1349A · Substantial damageNTSB BFO95FA075Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Cohocton, NYthe pilot's failure to maintain control of the airplane during a turn which led to an inadvertent stall/spin. Related factors were the low ceiling, and the non-instrument rated pilot's flight into known adverse weather.Jun 27, 1995 · N15124 · DestroyedNTSB ATL95LA121Accident · No injuriesLimited investigationFinal reportCessna 152 · Juliette, GAThe pilot's ostentatious display, resulting in a collision with the water.Jun 27, 1995 · N5523B · Substantial damageNTSB FTW95FA259Accident · 2 fatalField investigationFinal reportCessna 152 · Ben Wheeler, TXThe pilot's intentional low level flying and not maintaining a clearance from the trees. A factor was the pilot exceeded the maximum allowable gross weight of the airplane.Jun 26, 1995 · N4963H · DestroyedNTSB SEA95LA132Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Meachem, ORThe pilot-in-command's failure to maintain clearance from the surrounding terrain. A factor was the mountainous/hilly terrain condition.Jun 25, 1995 · N66727 · Substantial damageNTSB SEA95FA128Accident · 2 fatalField investigationFinal reportLuscombe 8A · Hubbard, ORThe failure of the maintenance personnel who rebuilt the aircraft to properly install the wing lower lift strut attachment bolts. Contributing to the accident was the failure of another maintenance person to adequately inspect the aircraft for properly…Jun 25, 1995 · N719JX · DestroyedNTSB FTW95LA262Accident · No injuriesLimited investigationFinal reportBeech 77 · Mcallen, TXThe dual student's failure to properly operate the throttle and the inadequate supervision by the flight instructor. A factor was the lack of suitable terrain for the forced landing.Jun 25, 1995 · N3737B · Substantial damageNTSB SEA95LA126Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Zillah, WAThe failure of company maintenance personnel to perform adequate inspections of the helicopter, and the failure of the cyclic control rod due to corrosion.Jun 24, 1995 · N1968H · Substantial damageNTSB LAX95LA221Accident · No injuriesLimited investigationFinal reportCessna 172 · Yerington, NVThe pilot's improper in-flight decision to enter mountainous terrain at an insufficient altitude to safely escape adverse weather conditions. Factors relating to the accident were: the terrain and weather conditions.Jun 23, 1995 · N5363T · Substantial damageNTSB CHI95FA191Accident · 1 fatalField investigationFinal reportChampion 8KCAB · Frankfort, ILthe pilot-in-command's overconfidence in his personal ability in attempting to teach aerobatics, his lack of experience as a flight instructor, and allowing the airplane to get into a position where its never exceed speed and design stress limits were…Jun 21, 1995 · N109AC · DestroyedNTSB FTW95LA253Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Bigelow, ARThe pilot's failure to maintain clearance with terrain.Jun 20, 1995 · N7937 · Substantial damageNTSB NYC95LA133Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Yellow Springs, OHinadequate visual lookout by the pilot which resulted in the airplane striking the tower.Jun 18, 1995 · N7239H · Substantial damageNTSB LAX95LA214Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Nipomo, CAthe pilot's improper handling of the helicopter by her failure to maintain an adequate airspeed for the attempted maneuver resulting in an uncontrolled descent and subsequent collision with the ground.Jun 18, 1995 · N115B · DestroyedNTSB LAX95LA213Accident · No injuriesLimited investigationFinal reportBell 47-G2A · Bakersfield, CAthe pilot's failure to maintain adequate lateral clearance from the irrigation standpipe while applying chemicals to a field.Jun 18, 1995 · N73260 · Substantial damageNTSB FTW95LA254Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Cash, ARThe loss of engine power for undetermined reasons. Factors were the low altitude at which the power loss occurred and the lack of suitable terrain for a forced landing.Jun 17, 1995 · N4562 · Substantial damageNTSB FTW95LA248Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M18 · Cherry Valley, ARFuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the lack of suitable terrain for a forced landing.Jun 16, 1995 · N2177Q · Substantial damageNTSB SEA95LA119Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Helena, MTThe loss of engine power for undetermined reasons.Jun 15, 1995 · N6669Q · DestroyedNTSB ATL95LA111Accident · No injuriesLimited investigationFinal reportCessna 188D · Athens, ALThe pilot's inadequate lookout, and his failure to maintain clearance from the utility line.Jun 15, 1995 · N8035V · DestroyedNTSB ATL95LA110Accident · Minor injuriesLimited investigationFinal reportCessna 188B · Huntsville, ALThe downdraft weather condition, and the pilot's failure to maintain adequate clearance from the terrain during his maneuver.Jun 15, 1995 · N5621G · DestroyedNTSB SEA95LA118Accident · No injuriesLimited investigationFinal reportEnstrom 280C · The Dalles, ORA partial loss of engine power due to one set of ignition points becoming loose during flight. Factors included the low altitude flight and maneuvering required to conduct the operation and the resulting lack of suitable terrain for a forced landing.Jun 14, 1995 · N51657 · Substantial damageNTSB FTW95LA244Accident · 1 fatalLimited investigationFinal reportWalter W. Bell Lazer Edge · El Reno, OKThe pilot's failure to maintain control resulting in an inadvertent stall/spin. Factors were the pilot's performance of aerobatic maneuvers at the low altitude.Jun 14, 1995 · N33PE · Destroyed