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 NYC98LA151Accident · No injuriesLimited investigationFinal reportCessna A185F · Moneta, VAThe pilot's failure to maintain airspeed which resulted in a stall and subsequent collision with water.Jul 18, 1998 · N1481F · Substantial damageNTSB MIA98LA201Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Belzoni, MSThe malfunction in the engine blower section, resulting in oil starvation, the seizure of the engine.Jul 18, 1998 · N8488V · Substantial damageNTSB CHI98MA260Accident · 2 fatalMajor investigationFinal reportNorth American NA-265-80 · Florence, KSthe pilot's overconfidence in his personal ability, his improper in-flight decision to attempt aerobatics, and his loss of control of the airplane.Jul 18, 1998 · N547JL · DestroyedNTSB CHI98LA262Accident · Serious injuriesLimited investigationFinal reportAeronca 11BC · Blue Springs, NEthe pilot's inadequate visual outlook to avoid impact with a wire. Factors were sunglare and the wire (static).Jul 18, 1998 · N9156E · Substantial damageNTSB CHI98LA259Accident · 1 fatalLimited investigationFinal reportAnderson T Craft Special · Pick City, NDThe pilot's failure to maintain sufficient altitude/clearance with terrain. A factor was the pilot's attempted low altitude acrobatic maneuver.Jul 18, 1998 · N91XX · DestroyedNTSB SEA98LA140Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Caldwell, IDThe pilot-in-command's misjudgment of clearance with a power line, resulting in a collision with the line. Factors included a power line and dark night light conditions in the spray area.Jul 17, 1998 · N7951 · Substantial damageNTSB LAX98LA233Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Tranquillity, CAThe pilot's failure to detect and avoid a set of wires during a night aerial application flight. Factors in the accident were the pilot's failure to perform an adequate preflight inspection of the field to determine obstruction locations and the dark night…Jul 17, 1998 · N2373V · Substantial damageNTSB LAX98FA235Accident · 2 fatalField investigationFinal reportPZL-Bielsko SZD 50-3 · California City, CAThe failure of the first and/or second pilot to obtain and maintain control of the aircraft after stalling and entering a spin.Jul 17, 1998 · N7215L · DestroyedNTSB FTW98LA315Accident · No injuriesLimited investigationFinal reportBell 47-GB31 · Olathe, COThe pilot's inadequate in-flight planning which resulted in an encounter with his own wake turbulence. Related factors were high density altitude and wake turbulence.Jul 17, 1998 · N92HA · Substantial damageNTSB FTW98FA310Accident · 1 fatalField investigationFinal reportAir Command International C-147A · Caddo Mills, TXThe pilot's failure to maintain rotor rpm while maneuvering, which resulted in the main rotor blades contacting the tail section of the gyroplane.Jul 15, 1998 · N147GY · DestroyedNTSB LAX98LA234Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Discus A · Bridgeport, CAThe failure of the pilot to maintain clearance with the trees while maneuvering to locate a thermal lift.Jul 13, 1998 · N95KM · DestroyedNTSB CHI98FA244Accident · 1 fatalField investigationFinal reportStubbe-Kitfox Classic · Traer, IAthe failure of the pilot of the Kitfox to maintain flying speed (Vs).Jul 12, 1998 · N494S · 2 aircraft · DestroyedNTSB LAX98LA228Accident · Serious injuriesLimited investigationFinal reportPitts S1-S · Tracy, CAThe failure of the pilot to maintain adequate clearance with the terrain during aerobatic maneuvering.Jul 11, 1998 · N71HR · Substantial damageNTSB LAX98LA227Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Sedona, AZThe failure of the pilot to maintain a visual clearance with the trees.Jul 11, 1998 · N5050C · Substantial damageNTSB FTW98LA309Accident · Serious injuriesLimited investigationFinal reportOverton Mustang M-II · Hillsdale, WYThe pilot's inadequate visual lookout and his failure to maintain adequate clearance from obstacles. Factors were an intentional low altitude flight maneuver, wires, and low light conditions.Jul 11, 1998 · N121GD · Substantial damageNTSB CHI98LA245Accident · No injuriesLimited investigationFinal reportCessna 188B · Atlanta, NEA loss of engine power due to a loose 'B' nut on the fuel line fitting. Contributing to the accident was the inadequate maintain and the soft terrain.Jul 11, 1998 · N9247R · Substantial damageNTSB FTW98LA304Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Plainview, TXThe pilot's failure to maintain obstacle clearance during the aerial application flight. A factor was the transmission wire.Jul 8, 1998 · N2325G · Substantial damageNTSB LAX98LA225Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Salinas, CAThe failure of the pilot to maintain clearance with the telephone lines.Jul 7, 1998 · N7914S · DestroyedNTSB CHI98LA240Accident · No injuriesLimited investigationFinal reportCessna T188C · Austin, MNthe improper maintenance by other maintenance personnel. Factors were the throttle control not safetied, the crops, and unsuitable terrain encountered by the pilotJul 6, 1998 · N9957J · Substantial damageNTSB LAX98LA224Accident · No injuriesLimited investigationFinal reportTaylorcraft BL-65 · Livermore, CAThe pilot's failure to maintain adequate clearance from the trees. A related factor was the mountainous terrain.Jul 5, 1998 · N23670 · Substantial damageNTSB LAX98LA223Accident · 1 fatalLimited investigationFinal reportMorane-Saulnier MS 880B · Trinity Center, CAThe pilot's failure to maintain an adequate airspeed margin while maneuvering in a mountainous area at low altitude, which resulted in an inadvertent stall/spin.Jul 5, 1998 · N55BF · DestroyedNTSB CHI98LA238Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Strandquist, MNthe pilot's failure to maneuver to avoid obstructions. A factor was the trees.Jul 4, 1998 · N5829G · Substantial damageNTSB SEA98LA155Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 · Douglas, WAThe pilot's failure to maintain clearance from objects on the ground. Factors include misjudgment of weather conditions (unfavorable winds).Jul 3, 1998 · N707NL · Substantial damageNTSB FTW98LA296Accident · No injuriesLimited investigationFinal reportGrumman G164A · Stratton, COA power loss for reasons undetermined. A factor was the muddy corn field.Jul 3, 1998 · N36RA · Substantial damageNTSB FTW98FA290Accident · 1 fatalField investigationFinal reportCessna A188B · Panhandle, TXThe pilot's failure to maintain clearance from the power transmission wires while maneuvering during an aerial application flight.Jun 30, 1998 · N3845J · DestroyedNTSB FTW98FA289Accident · 2 fatalField investigationFinal reportCessna 150H · Weslaco, TXFailure to maintain adequate airspeed by one of the pilot's on board. A factor was the low altitude.Jun 30, 1998 · N22651 · DestroyedNTSB SEA98LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Big Creek, IDThe pilot's failure to maintain airspeed while maneuvering to an emergency landing, resulting in an inadvertent stall/mush into the terrain. A contributing factor was the high density altitude.Jun 28, 1998 · N44536 · Substantial damageNTSB FTW98GA286Accident · 2 fatalFinal reportLockheed SP-2H · Reserve, NMFailure of the copilot to maintain both lateral and vertical clearance from the trees, and failure of the captain to provide adequate supervision of the flight.Jun 28, 1998 · N14835 · DestroyedNTSB MIA98LA189Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Perry, FLThe improper repair of the no. 2 engine cylinder, which resulted in the loss of engine power.Jun 27, 1998 · N2622J · Substantial damageNTSB CHI98LA220Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fargo, NDthe pilot's failure to maintain clearance with the powerline during a swath run. A factor associated with the accident was the powerline.Jun 25, 1998 · N7174B · Substantial damageNTSB CHI98LA219Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Mobridge, SDThe pilot's failure to maintain clearance from the power lines. Factors associated with the accident were the power lines, and the separation of the vertical stabilizer and rudder which resulted in the pilot's inability to maintain directional control of the…Jun 25, 1998 · N3760E · Substantial damageNTSB ATL98GA086Accident · No injuriesFinal reportEctor 305A (L-19) · Morganton, NCThe inflight encounter with a downdraft which led to a stall/mush and an inflight collision with the ground. Factors were the inadequate training in mountain flying and inadequate guidelines provided by the North Carolina Forest Service.Jun 25, 1998 · N16574 · Substantial damageNTSB CHI98LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-375 · Stephen, MNthe visual lookout not being maintained by the pilot. A factor to the accident was the transmission wire.Jun 23, 1998 · N82585 · Substantial damageNTSB CHI98LA214Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIthe pilot misjudging his distance and not maintaining the proper altitude. A factor was trees.Jun 22, 1998 · N9209R · Substantial damageNTSB SEA98FA109Accident · No injuriesField investigationFinal reportNolley BD-5T · Corvallis, ORThe introduction of a fuel containing an ethanol additive into fuel tanks sloshed/sealed with a compound incompatible with alcohols, resulting in debonding of the compound from the fuel tank walls, leading to partial blockage of an in-line fuel filter, and a…Jun 21, 1998 · N50TX · Substantial damageNTSB FTW98LA278Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Freer, TXThe pilot's failure to maintain tail rotor-ground clearance due to his improper flare while hovering.Jun 21, 1998 · N982SH · Substantial damageNTSB LAX98LA207Accident · Serious injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Skull Valley, AZThe pilot's failure to maintain control of the aircraft while maneuvering at a low altitude.Jun 20, 1998 · N45053 · DestroyedNTSB FTW98LA275Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Hazen, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the pilot to execute the forced landing.Jun 19, 1998 · N3632S · Substantial damageNTSB CHI98LA208Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Winchester, MOThe pilot's low altitude flight and failure to maintain clearance, resulting in collision with trees. A factor was trees.Jun 19, 1998 · N4539R · DestroyedNTSB SEA98FA104Accident · No injuriesField investigationFinal reportGarlick UH-1H · Couer D'Alene, IDFatigue failure of a reduction drive planetary gear. Factors include an unapproved part and plating process, and uneven terrain at the emergency landing site.Jun 18, 1998 · N869W · Substantial damageNTSB FTW98LA274Accident · No injuriesLimited investigationFinal reportBell 206L4 · Hurst, TXThe flight instructor's failure to maintain control of the helicopter while attempting to increase the engine RPM while hovering. Factors were the prevailing high winds and the instructor's diverted attention.Jun 18, 1998 · N8094L · Substantial damageNTSB FTW98FA272Accident · 1 fatalField investigationFinal reportAyres S2R-R1340 · Humphrey, ARThe pilot's visual lookout was inadequate for undetermined reasons.Jun 18, 1998 · N4020G · DestroyedNTSB LAX98TA202Accident · No injuriesFinal reportMcDonnell Douglas 600N · Laguna Beach, CAThe inadvertent entanglement of an external load, which interfered with the pilot's ability to control the aircraft.Jun 17, 1998 · N185SD · Substantial damageNTSB FTW98LA263Accident · 1 fatalLimited investigationFinal reportMoore B-8MJ · Pauls Valley, OKThe non-certificated pilot's failure to maintain clearance from the hangar. A factor was the pilot's maneuvering at a low altitude.Jun 15, 1998 · N4874X · Substantial damageNTSB LAX98LA195Accident · 1 fatalLimited investigationFinal reportBlackmore RV-4 · Sedona, AZThe pilot's attempt to perform aerobatics with insufficient terrain clearance altitude available to complete the maneuver. A factor was high density altitude.Jun 14, 1998 · N813R · DestroyedNTSB SEA98LA095Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Starbuck, WAThe pilot-in-command's failure to maintain adequate visual lookout. A contributing factor was the unmarked transmission lines.Jun 12, 1998 · N8252K · DestroyedNTSB ATL98LA081Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Nicklesville, GAThe loss of engine power for undetermined reason. A factor was that weather conditions were favorable for the formation of carburetor ice.Jun 12, 1998 · N87027 · Substantial damageNTSB FTW98LA262Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider LS-6A · Green River, UTThe pilot's failure to maintain airspeed. Factor's were the unforecasted weather (tail wind) and the inadvertent stall/spin.Jun 11, 1998 · N511M · Substantial damageNTSB CHI98LA198Accident · Serious injuriesLimited investigationFinal reportBell 47G · Le Center, MNthe pilot's failure to maintain clearance with the wire. A factor associated with the accident was the wire which the helicopter contacted.Jun 10, 1998 · N73284 · DestroyedNTSB SEA98FA089Accident · 1 fatalField investigationFinal reportMooney M20A · Canyon Creek, MTThe design stress limits of the aircraft was exceeded. The pilot's inadequate preflight planning/preparation, lack of an instrument rating, poor weather evaluation and low ceilings and mountain obscuration were factors.Jun 7, 1998 · N1048B · Destroyed