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 SEA95FA012Accident · 2 fatalField investigationFinal reportUnited Consultant UC-1 · Pinedale, WYAircraft control was not maintained. Factors to the accident were: rough water and downdrafts.Oct 27, 1994 · N9501U · Substantial damageNTSB FTW95LA032Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ruston, LAThe pilot's improper handling of the helicopter after an apparent loss of power during a practice autorotation.Oct 27, 1994 · N206SF · Substantial damageNTSB MIA95LA008Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLFailure of the pilot to refuel resulting in loss of engine power due to fuel exhaustion.Oct 24, 1994 · N3629X · Substantial damageNTSB NYC95LA017Accident · Minor injuriesLimited investigationFinal reportPitts S-1C · Galeville, NYInadequate maintenance inspection which resulted in disengagement of the rudder clevis bolt and the inflight loss of control during aerobatic manuevers.Oct 22, 1994 · N7037W · DestroyedNTSB FTW95LA025Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Tres Piedras, NMThe pilot's inadequate inflight planning which led to maneuvering at slow airspeed to avoid terrain which resulted in further loss of airspeed and an aerodynamic stall.Oct 22, 1994 · N2721L · DestroyedNTSB FTW95FA020Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Artesia, NMThe pilot's impairment of judgment and performance due to drugs, and his failure to maintain clearance from a powerline.Oct 22, 1994 · N5905X · DestroyedNTSB FTW95LA028Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's failure to maintain clearance with the irrigation equipment. A factor was pilot fatigue.Oct 21, 1994 · N8523S · Substantial damageNTSB ATL95LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jakin, GAThe loss of engine power for undetermined reasons.Oct 20, 1994 · N8960H · Substantial damageNTSB BFO95LA005Accident · Minor injuriesLimited investigationFinal reportS M A N Hydroplum Petrel · Center Village, OHLoss of engine power due to a malfunction of the fuel pump.Oct 16, 1994 · N1601Z · Substantial damageNTSB NYC95LA009Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-355 · Jonesville, VAThe pilot's failure to maintain clearance from the power lines.Oct 15, 1994 · N5787A · DestroyedNTSB FTW95FA019Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · College Station, TXThe pilot's failure to maintain airspeed and the resulting inadvertent stall. Factors were the pilot's inadequate preflight inspection, and his diverted attention to an open cargo door.Oct 15, 1994 · N2964A · DestroyedNTSB NYC95LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beans Cove, PAThe pilot's failure to maintain adequate obstacle clearance which resulted in an inflight collision with a tree.Oct 13, 1994 · N4878Z · DestroyedNTSB LAX95LA005Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAan in-flight engine compartment fire for undetermined reasons.Oct 13, 1994 · N145HA · DestroyedNTSB SEA95LA006Accident · 2 fatalLimited investigationFinal reportGlines Acro Duster II SA750 · West Jordon, UTThe pilot-in-command's attempt to perform a low altitude flight maneuver, and his failure to maintain adequate airspeed during the maneuver. This led to an unrecoverable aerodynamic stall.Oct 8, 1994 · N31WD · DestroyedNTSB MIA95FA004Accident · 3 fatalField investigationFinal reportCessna 172N · Ochopee, FLThe pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and an uncontrolled descent until impact in a swamp.Oct 8, 1994 · N4851D · DestroyedNTSB ATL95LA004Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Ashburn, GAThe failure of a blade counterweight bearing shaft, allowing one propeller blade to go to high pitch.Oct 5, 1994 · N8971Q · Substantial damageNTSB FTW95LA009Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Oak Grove, LAThe pilot misjudged clearance from the vehicle.Oct 3, 1994 · N6676K · Substantial damageNTSB CHI95FA002Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Martinsville, INThe pilot's impairment of judgment and performance due to alcohol, improper planning/decision, and failure to maintain sufficient altitude/clearance above the ground.Oct 2, 1994 · N99305 · DestroyedNTSB CHI95FA001Accident · 1 fatalField investigationFinal reportCessna 150G · Lamberton, MNThe pilot's failure to maintain airspeed. A factor in the accident was the pilot's ostentatious display by buzzing.Oct 2, 1994 · N3654J · DestroyedNTSB FTW95FA002Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Pagosa Springs, COThe pilot's continued flight into known adverse weather. Factors were the pilot's lack of familiarity with the geographic area, the turbulence and high density altitude.Oct 1, 1994 · N1480X · DestroyedNTSB BFO94LA161Accident · 2 fatalLimited investigationFinal reportHenderson Christen Eagle II · Painesville, OHThe pilot's failure to maintain aircraft control while conducting aerobatic maneuvers. The pilot's overconfidence in his ability was a factor.Sep 30, 1994 · N39RH · DestroyedNTSB MIA94LA218Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Greenwood, MSThe improper decision of the pilot to execute a precautionary landing to an unprepared field due to a supercharger shaft failure.Sep 29, 1994 · N48572 · Substantial damageNTSB FTW94FA315Accident · 2 fatalField investigationFinal reportCessna 182K · Heeney, COThe pilot's failure to maintain terrain clearance. A factor was the rising terrain.Sep 28, 1994 · N2504Q · DestroyedNTSB LAX94LA379Accident · No injuriesLimited investigationFinal reportRockwell S2R · Visalia, CAthe pilot failed to maintain an adequate visual lookout and collided with power lines which resulted in an in-flight loss of control and subsequent collision with terrain.Sep 26, 1994 · N8874Q · DestroyedNTSB FTW94FA311Accident · 1 fatalField investigationFinal reportCessna T188C · Roscoe, TXThe pilot's failure to maintain flying speed resulting in an aerodynamic stall. A factor was the pilot's lack ofSep 26, 1994 · N3106J · DestroyedNTSB CHI94DET02Accident · Minor injuriesFinal reportSimcox Sport Trainer · Laporte, INThe pilot's continued operation with a known power deficiency. The loss of engine power was a factor in the accident.Sep 26, 1994 · N6881M · Substantial damageNTSB MIA94LA216Accident · No injuriesLimited investigationFinal reportBell 47G-2A · Moore Haven, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering on a swath run, resulting in an in-flight collision with wires, and subsequent in-flight collision with terrain.Sep 23, 1994 · N30JJ · DestroyedNTSB SEA94FA245Accident · 2 fatalField investigationFinal reportCessna A185E · Juneau, AKAttempted VFR flight into IMC. Factors to the accident were: clouds and mountainous terrain.Sep 22, 1994 · CFVZP · Substantial damageNTSB FTW94LA306Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Mcgehee, ARThe loss of engine power due to undetermined reasons. A factor was the unsuitable terrain.Sep 20, 1994 · N4549N · Substantial damageNTSB LAX94LA368Accident · 1 fatalLimited investigationFinal reportNorth American SNJ-5 · Reno, NVthat the pilot of the other airplane misjudged the distance between the airplanes. The other airplane pilot's diverted attention to the air race is a factor in this accident.Sep 18, 1994 · N8540Z · 2 aircraft · DestroyedNTSB FTW94FA300Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Tennesse Colony, TXThe pilot's failure to maintain airspeed and the resultant inadvertent stall/spin. A factor was the loss of engine power for undetermined reasons.Sep 18, 1994 · N9159P · Substantial damageNTSB LAX94LA386Accident · 2 fatalLimited investigationFinal reportBell 47G-5 · Pacific Ocean (Pacific Ocean)an in-flight collision with the water for undetermined reasons.Sep 17, 1994 · N2280W · Substantial damageNTSB LAX94FA367Accident · 1 fatalField investigationFinal reportAlon A2 · Orland, CAthe pilot's intentional performance of an aerobatic maneuver which overloaded the outboard portion of the left wing and caused it to fail. Factors which contributed to the accident were the pilot's overconfidence in his ability to perform the maneuver and his…Sep 17, 1994 · N37698 · DestroyedNTSB FTW94LA304Accident · No injuriesLimited investigationFinal reportMooney, Dan Rotorway Exec 90 · Owasso, OKThe flight instructor's inadequate supervision of the student. A factor was the student's failure to maintain adequate rotor RPM.Sep 16, 1994 · N92RE · Substantial damageNTSB CHI94FA329Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Beaver Island, MIThe pilot's failure to maintain control of the airplane. The pilot's buzzing and his impairment of judgment and performance due to alcohol were factors in the accident.Sep 15, 1994 · N13909 · DestroyedNTSB CHI94LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Decatur, INthe pilot-in-command's failure to maintain a proper altitude and his inadequate visual outlook. A factor was the tower.Sep 14, 1994 · N89897 · Substantial damageNTSB LAX94LA361Accident · 1 fatalLimited investigationFinal reportNorth American P-51D · Reno, NVthe pilot's failure to maintain aircraft control during an attempted forced landing. Factors in the accident were the failure of a propeller blade-feathering oil seal which leaked oil on the windshield, obscuring the pilot's vision.Sep 12, 1994 · N51U · DestroyedNTSB LAX94FA360Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Winslow, AZthe pilot's inadvertent stall and uncontrolled descent into the ground from a low altitude while scouting for game.Sep 12, 1994 · N2207A · DestroyedNTSB SEA94FA247Accident · 1 fatalField investigationFinal reportCessna 150J · Roseburg, ORthe pilot's failure to maintain clearance from the terrain.Sep 11, 1994 · N5565G · DestroyedNTSB ATL94LA170Accident · 1 fatalLimited investigationFinal reportPiper J-5A · Raeford, NCThe pilot's ostentatious display which resulted in a loss of control of the airplane.Sep 8, 1994 · N31172 · DestroyedNTSB NYC94LA170Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Houlton, MEInadequate maintenance inspection which failed to detect internal corrosion of the magneto, resulting in ignition arcing and the loss of engine power.Sep 7, 1994 · N8810Z · Substantial damageNTSB CHI94LA314Accident · No injuriesLimited investigationFinal reportCessna 188B · Oakdale, ILmisalignment of the number one connecting rod during major overhaul. Factors were the subsequent scoring and fatigue failure of the crankshaft.Sep 7, 1994 · N731SV · Substantial damageNTSB CHI94LA311Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Cassoday, KSthe attempted low level flight/maneuver with inadequate visual lookout by the pilot-in-command.Sep 5, 1994 · N82114 · DestroyedNTSB ANC94FA130Accident · 1 fatalField investigationFinal reportPiper PA-18 · Gulkana, AKThe pilot's failure to maintain clearance from terrain.Sep 5, 1994 · N7867D · Substantial damageNTSB NYC94FA165Accident · 1 fatalField investigationFinal reportBellanca 8-KCAB · Chatsworth, NJThe pilot's inadequate preflight that failed to detect water- contaminated fuel which resulted in the loss of engine power and the pilot's decision to conduct flight at an altitude too low to initiate emergency procedures.Sep 2, 1994 · N8670V · DestroyedNTSB SEA94LA228Accident · Minor injuriesLimited investigationFinal reportSikorsky S-64F · Libby, MTThe flight crew allowed the helicopter's weight and balance to be exceeded, and the external load (tank) jettison system failed to operate. A factor related to the accident was: the false indication on the retardant quantity indicator.Sep 1, 1994 · N165AC · DestroyedNTSB BFO94LA159Accident · No injuriesLimited investigationFinal reportBell UH-1B · Carrabasset, MEFracture failure of the tail rotor drive intermediate gearbox.Aug 31, 1994 · N204JB · Substantial damageNTSB MIA94LA203Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Egypt, MSPilot-in-command's inadvertent stall during an agricultural turn resulting in the loss of control and subsequent in flight collision with terrain.Aug 30, 1994 · N4811R · Substantial damageNTSB FTW94LA280Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Trinidad, COThe pilot's failure to maintain terrain clearance.Aug 28, 1994 · N5372T · Substantial damageNTSB ANC94LA124Accident · 2 fatalLimited investigationFinal reportPiper PA-18 · Glenallen, AKAirspeed not maintained. A factor was the gusty wind conditions.Aug 28, 1994 · N13900 · Destroyed