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 SEA94LA177Accident · Serious injuriesLimited investigationFinal reportDay Teeny II · Colville, WAThe pilot's failure to maintain altitude sufficient to clear terrain. The downdraft was a factor.Jul 11, 1994 · N526AD · Substantial damageNTSB NYC94FA119Accident · 1 fatalField investigationFinal reportCessna 172RG · Kiptopeka, VAInadequate visual lookout by the flightcrew of the helicopter. A factor related to the accident was: failure of the departure controller to issue a traffic advisory.Jul 11, 1994 · N6624R · 2 aircraft · DestroyedNTSB FTW94FA224Accident · 2 fatalField investigationFinal reportAerospatiale AS 350B-2 · Granite, COFailure of the pilot to assure main rotor clearance from sloping terrain while in a hover. The terrain condition was a related factor.Jul 10, 1994 · N95LG · DestroyedNTSB SEA94LA175Accident · Minor injuriesLimited investigationFinal reportPezetel M-18 Dromader · Plymouth, WAThe rudder being jammed in almost the full left position.Jul 9, 1994 · N4685R · Substantial damageNTSB MIA94LA176Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Sanford, FLThe failure of the tailrotor driveshaft for undetermined reasons resulting in loss of tailrotor drive. This resulted in the helicopter spinning uncontrolled and descending from a hover until it crashed in the water.Jul 9, 1994 · N22431 · Substantial damageNTSB LAX94LA285Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Gilbert Islands (Pacific Ocean)An in flight failure and separation of the tail rotor for undetermined reasons.Jul 8, 1994 · N9242F · Substantial damageNTSB CHI94LA224Accident · No injuriesLimited investigationFinal reportCessna 150 · Andover, MNthe flight instructor's improper procedures and directives by electing to pull the mixture control to the 'off' position during simulated emergency procedures. A factor associated with the accident is the existence of weather conditions conducive to…Jul 8, 1994 · N9284U · Substantial damageNTSB SEA94LA171Accident · No injuriesLimited investigationFinal reportRobinson R-22M · Portland, ORTail rotor gearbox failure due to inadequate assembly and inspection procedures by the manufacturer.Jul 7, 1994 · N42WC · Substantial damageNTSB SEA94LA169Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Weiser, IDClearance from powerlines was not maintained. Factors include dusk light conditions.Jul 7, 1994 · N4900T · Substantial damageNTSB SEA94FA164Accident · 1 fatalField investigationFinal reportCessna 185C · Palouse, WAThe inadvertent disorientation of the pilot after entering instrument meteorological conditions. Fog was a related factor.Jul 5, 1994 · N5833T · Substantial damageNTSB FTW94FA220Accident · 2 fatalField investigationFinal reportSIAI-Marchetti F.260 · Dover, OKFailure of the pilot to maintain adequate altitude while performing an aerobatic demonstration. Factors related to the accident were: the pilot's inadequate training, his lack of experience in the type of operation, and insufficient FAA oversight of this type…Jul 5, 1994 · N260MS · DestroyedNTSB CHI94DCG02Accident · 1 fatalFinal reportAero Commander Calair A-9B · Excelsior Sprgs, MOThe pilot's failure to maintain altitude clearance above the powerlines during his maintenance test application run.Jul 5, 1994 · N7965V · DestroyedNTSB SEA94FA163Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Seeley Lake, MTThe pilot in command's failure to maintain flying airspeed.Jul 4, 1994 · N88114 · DestroyedNTSB MIA94LA171Accident · No injuriesLimited investigationFinal reportPitts S2B · Fort Lauderdale, FLThe poor welding quality of the manufacturer, resulting in the fatigue failure of the aileron attachment bracket.Jul 4, 1994 · N61PS · Substantial damageNTSB MIA94LA172Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Rolling Fork, MSThe loss of engine power for undetermined causes. Contributing to the accident was the unsuitable terrain encountered during the forced landing.Jul 3, 1994 · N8820Q · Substantial damageNTSB SEA94FA162Accident · 2 fatalField investigationFinal reportPiper PA-18A-150 · Lowell, IDThe pilot in command's failure to maintain adequate airspeed.Jul 2, 1994 · N8565D · DestroyedNTSB NYC94LA110Accident · Minor injuriesLimited investigationFinal reportBell 47-G5 · Wareham, MAThe pilot's inadequate inflight planning which resulted in fuel exhaustion and the loss of engine power.Jul 2, 1994 · N59400 · Substantial damageNTSB NYC94LA108Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Bristol, NHthe failure of maintenance personnel to remove an object from the carburetor heat duct during annual inspection which blocked induction air and resulted in the loss of engine power, and the subsequent collision with the terrain during a forced landing.Jul 2, 1994 · N734TU · Substantial damageNTSB ATL94LA128Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Smithville, GAThe failure of # 2 cylinder head.Jul 2, 1994 · N3649B · DestroyedNTSB MIA94LA170Accident · 1 fatalLimited investigationFinal reportFullana Quicksilver GT-500 · Palmas Del Mar, PRThe pilot's abrupt lowering of the flaps which resulted in a loss of control at an altitude insufficient for recovery, and the pilot's unwarranted low flying.Jul 1, 1994 · N4287L · DestroyedNTSB FTW94LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Marked Tree, ARThe power loss for undetermined reasons. Factors were the pilot's inadvertent entry into a stall and the lack of suitable terrain onto which to execute the landing.Jul 1, 1994 · N6568 · Substantial damageNTSB CHI94LA218Accident · No injuriesLimited investigationFinal reportCallair A9B · Minot, NDthe pilot's failure to maintain clearance from the wheat field. A factor was the turbulence.Jul 1, 1994 · N2851F · Substantial damageNTSB ANC94FA074Accident · 3 fatalField investigationFinal reportPiper PA-22 · Delta Junction, AKThe loss of engine power for undetermined reasons. A factor was the pilot did not maintain airspeed resulting in a stall/spin.Jul 1, 1994 · N8510C · DestroyedNTSB LAX94LA268Accident · 1 fatalLimited investigationFinal reportRockwell S2-R · Firebaugh, CAThe pilot's loss of aircraft control as a result of incapacitation from an in-flight sulfur fire.Jun 29, 1994 · N4230X · DestroyedNTSB FTW94LA218Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Collbran, COAn inadvertent stall. Factors were a partially blocked pitot tube and a downdraft.Jun 29, 1994 · N2580Q · DestroyedNTSB CHI94DTG02Accident · No injuriesFinal reportAir Tractor AT301 · Lawton, NDThe pilot's improper use of carburetor heat. The carburetor icing weather condition was a factor.Jun 29, 1994 · N4349S · Substantial damageNTSB SEA94LA156Accident · 1 fatalLimited investigationFinal reportBurkhart Grob G-109B · Bend, ORThe pilot's impairment of judgment and performance due to drugs, which led to his failure to maintain control of the aircraft.Jun 27, 1994 · N109KM · Substantial damageNTSB CHI94LA191Accident · 1 fatalLimited investigationFinal reportHiller HU-12E · Watertown, SDthe pilot's failure to maintain a visual lookout. A factor associated with the accident was the powerlines.Jun 23, 1994 · N330CW · DestroyedNTSB ANC94FA070Accident · 7 fatalField investigationFinal reportde Havilland DHC-3 · Juneau, AKVFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude (clearance) above the surface of the river. Factors related to the accident were: the adverse weather conditions, and the surface condition of the…Jun 23, 1994 · N13GA · Substantial damageNTSB FTW94LA209Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Parkin, ARTotal power loss for undetermined reasons. A factor was unsuitable terrain for a forced landing.Jun 22, 1994 · N6535 · Substantial damageNTSB FTW94FA206Accident · 1 fatalField investigationFinal reportLuscombe 8A · Decatur, TXThe pilot's loss of control while maneuvering. Factors were the pilot's maneuvering at an low altitude and his lack of recent experience in make and model.Jun 21, 1994 · N71347 · Substantial damageNTSB FTW94FA203Accident · Serious injuriesField investigationFinal reportCessna 175B · Sonora, TXThe pilot's failure to maintain obstacle clearance.Jun 21, 1994 · N8103T · Substantial damageNTSB FTW94GA204Accident · Minor injuriesFinal reportHughes 269C · London, TXThe partial power loss due to a sticking valve. Factors were the remaining worn lobes on the camshaft and the lack of suitable terrain onto which a successful forced landing could be executed.Jun 20, 1994 · N7404F · DestroyedNTSB MIA94LA162Accident · 1 fatalLimited investigationFinal reportStolte Deuce · Prentiss, MSFailure of the pilot to maintain proper altitude while performing an aerobatic maneuver and recovering from a spin. Factors related to the accident were: the pilot's failure to follow procedures/directives, lack of formal training in aerobatic flight, and…Jun 19, 1994 · N10RS · DestroyedNTSB MIA94LA161Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The pilot-in-command's failure to maintain a visual outlook and a safe altitude while making a low pass over a boat, resulting in an in-flight collision with the boat mast.Jun 19, 1994 · N5333Y · Substantial damageNTSB ATL94LA122Accident · 1 fatalLimited investigationFinal reportStephen Akro · Advance, NCThe pilot's failure to maintain airspeed.Jun 19, 1994 · N69TA · DestroyedNTSB SEA94LA150Accident · Serious injuriesLimited investigationFinal reportSchell RV-6A · Crowheart, WYThe pilot in command's failure to maintain adequate altitude. A factor was downdraft conditions.Jun 17, 1994 · N48TS · DestroyedNTSB LAX94LA254Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Live Oak, CAFailure of the pilot to remain clear of power lines. A factor related to the accident was: the pilot's impairment due to use of drugs that were not approved for use while flying.Jun 15, 1994 · N8392K · DestroyedNTSB FTW94LA195Accident · 1 fatalLimited investigationFinal reportGrumman G-164D · Gilbert, LAThe inadvertent stall while performing aerobatic maneuvers at an inadequate altitude.Jun 14, 1994 · N164MC · DestroyedNTSB BFO94LA099Accident · 2 fatalLimited investigationFinal reportUpton Mustang II · Churchtown, OHThe pilot's performance of a maneuver that exceeded the design stress limits of the airplane.Jun 14, 1994 · N49YP · DestroyedNTSB LAX94LA247Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Bakersfield, CAThe in-flight fire due to the spontaneous combustion of sulfur dust and subsequent forced landing. A factor was the high temperature.Jun 11, 1994 · N8507H · Substantial damageNTSB CHI94LA195Accident · 1 fatalLimited investigationFinal reportCanadair T-33 · Mount Clemens, MIThe pilot's failure to maintain clearance from terrain during an aerobatic maneuver. His improper execution of the maneuver was a factor.Jun 11, 1994 · N12418 · DestroyedNTSB ATL94LA119Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235C · Bainbridge, GAThe inadvertent stall by the pilot during practice agricultural spraying runs.Jun 11, 1994 · N4643Y · Substantial damageNTSB SEA94LA147Accident · No injuriesLimited investigationFinal reportHughes 369D · Snoqualmie, WAPoor in-flight planning/decision. Factors to the accident were: clearance not maintained and tailwind.Jun 10, 1994 · N1088G · Substantial damageNTSB FTW94LA192Accident · Minor injuriesLimited investigationFinal reportCallair A-5T · Fabens, TXLoss of engine power for undetermined reason(s).Jun 10, 1994 · N96084 · Substantial damageNTSB FTW94FA191Accident · 1 fatalField investigationFinal reportPiper PA-25-235 · Breckenridge, TXThe pilot's continued VFR flight into IMC. Factors were the weather and the lack of flight instruments.Jun 10, 1994 · N4492Y · DestroyedNTSB ATL94LA117Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Bainbridge, GAThe loss of engine power for undetermined reasons.Jun 10, 1994 · N89972 · Substantial damageNTSB SEA94LA145Accident · No injuriesLimited investigationFinal reportMooney M20C · Wamsutter, WYClearance not maintained. A factor to the accident was: transmission wire.Jun 9, 1994 · N711LP · Substantial damageNTSB SEA94LA142Accident · 1 fatalLimited investigationFinal report1ST FTR GP FOCKE-WULF 190 · Salt Lake City, UTImproper balancing of the ailerons resulting in aileron flutter.Jun 8, 1994 · N25074 · DestroyedNTSB LAX94LA242Accident · Serious injuriesLimited investigationFinal reportHayes/Pietenpol AIR Camper · Blythe, CAThe pilot's unexpected encounter with a downdraft while flying at an improper altitude in mountainous terrain.Jun 7, 1994 · N76TC · Destroyed