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 CHI92DER02Accident · No injuriesFinal reportPiper PA-25-235 · Badger, MNThe pilot's failure to maintain aircraft control while maneuvering at low altitude in gusty winds.Jul 10, 1992 · N4704Y · DestroyedNTSB CHI92DCJ04Accident · No injuriesFinal reportCallair A-9 · Beaver City, NEThe inadequate maintenance overhaul of the left magneto, and subsequent failure of the left magneto/ignition system which caused a complete loss of engine power.Jul 10, 1992 · N9627Z · Substantial damageNTSB BFO92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chestertown, MDCarburetor ice, due to the pilot's improper use of carburetor heat. Factors related to the accident were: carburetor icing (weather) conditions, and obstructions (houses and utility pole) in the emergency landing area.Jul 9, 1992 · N89577 · Substantial damageNTSB SEA92FA154Accident · 2 fatalField investigationFinal reportBeech 58 · Pierce, IDInflight loss of control when aircraft control was not maintained. Factors to the accident were: flight into known adverse weather and thunderstorm activity.Jul 8, 1992 · N23LB · DestroyedNTSB LAX92LA288Accident · No injuriesLimited investigationFinal reportHiller FH-1100 · Van Nuys, CAThe second pilot's improper use of the rotorcraft flight controls and the first pilot's poor supervision of the flight. A factor relating to this accident was both pilot's inexperience in the helicopter make and model.Jul 8, 1992 · N5061F · Substantial damageNTSB FTW92DPG06Accident · No injuriesFinal reportGrumman G-164A · Swifton, ARLoss of engine power. A factor was the lack of suitable terrain for forced landing.Jul 6, 1992 · N8922H · Substantial damageNTSB LAX92LA280Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Barstow, CA1) The pilot's maneuvering at low altitude into a tailwind condition which exceeded the performance capabilities of the helicopter, 2) his failure to maintain proper main rotor RPM, and 3) the pilot's selection of an altitude for the maneuvers which was too…Jul 5, 1992 · N2321R · Substantial damageNTSB CHI92LA196Accident · 2 fatalLimited investigationFinal reportLuscombe 8E · Napoleon, NDThe pilot's failure to maintain airspeed above a stall.Jul 4, 1992 · N2264K · DestroyedNTSB FTW92DRG02Accident · No injuriesFinal reportAero Commander Callair A-9B · Harlingen, TXAn inflight fire due to a loose fuel fitting and fuel line due to improper maintenance.Jul 3, 1992 · N7616V · DestroyedNTSB CHI92FA195Accident · 1 fatalField investigationFinal reportMooney M20K · Oconto Falls, WIThe pilot's failure to maintain adequate clearance from obstructions during a low pass.Jul 3, 1992 · N231FW · DestroyedNTSB FTW92DPG04Accident · Serious injuriesFinal reportAyres S2R-T11 · Jonesboro, ARThe failure of the company maintenance personnal and the pilot to perform adequate inspections and the separation of flight control surfaces. A factor was the corroded rudder assembly.Jul 2, 1992 · N8487V · Substantial damageNTSB BFO92LA085Accident · No injuriesLimited investigationFinal reportSchweizer 269D · Watkins Glen, NYFuel starvation as a result of improper rigging of the fuel control unit.Jul 2, 1992 · N330TT · Substantial damageNTSB LAX92FA271Accident · 2 fatalField investigationFinal reportHolmes-Salley/Starduster Too SA300 · Chatsworth, CAThe pilots inflight loss of control for undetermined reasons and an inadvertent entry into a stall spin. Contributing to the accident was the pilot's lack of total experience in type of aircraft and a low cloud cover.Jun 30, 1992 · N27BP · DestroyedNTSB SEA92LA141Accident · No injuriesLimited investigationFinal reportBell-World 47D1 · Wenatchee, WACarburetor ice and the pilot in command's not being able to maintain clearance. Factors contributing to the accident were: carburetor icing conditions and tree(s).Jun 29, 1992 · N17301 · DestroyedNTSB NYC92FA133Accident · 1 fatalField investigationFinal reportCessna 152 · Pleasant Mount, PAThe pilot's decision to perform low altitude maneuvers, resulting in a loss of airplane control and collision with trees. Factors related to the accident were the ostentatious display by the pilot, and his lack of total flight experience.Jun 29, 1992 · N757QN · DestroyedNTSB ATL92LA132Accident · 1 fatalLimited investigationFinal reportBell 206B · Bessemer, ALThe pilots failure to maintain clearance from wires.Jun 29, 1992 · N2636X · DestroyedNTSB CHI92DCA03Accident · 1 fatalFinal reportPiper PA-28-180 · Mokane, MOAn inadequate visual lookout by the pilot and his failure to maintain clearance from the wires.Jun 28, 1992 · N5175L · DestroyedNTSB BFO92LA089Accident · Minor injuriesLimited investigationFinal reportMadsen Rans S-12 · Saluda, VAWater contamination of the fuel, and an inadequate preflight by the pilot.Jun 28, 1992 · N43364 · Substantial damageNTSB CHI92LA190Accident · No injuriesLimited investigationFinal reportPitts S2B · Aurora, NEThe pilot-in-command's restricted visual lookout from smoke entering the cockpit. Factors were smoke in the cockpit which resulted in the pilot becoming disoriented.Jun 27, 1992 · N92BT · DestroyedNTSB SEA92LA134Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Ronan, MTThe pilot's operation with known deficiencies in equipment and erratic operation of the fuel control system. A factor contributing to the accident was: soft terrain.Jun 25, 1992 · N4690C · Substantial damageNTSB CHI92DCG04Accident · No injuriesFinal reportDennis L. Fetters Mini 500 · Missouri City, MOAn improper connecting rod assembly resulting in mechanical binding between the rod and the engine crankshaft.Jun 25, 1992 · N500ZZ · Substantial damageNTSB ATL92LA131Accident · No injuriesLimited investigationFinal reportBell 47D1 · Centre, ALThe pilot's inadequate visual lookout, resulting in a collision with a wire.Jun 25, 1992 · N68632 · Substantial damageNTSB ATL92LA130Accident · Minor injuriesLimited investigationFinal reportGrumman 164A · Abbeville, ALThe pilot's failure to see and avoid the top utility wire.Jun 25, 1992 · N5093 · DestroyedNTSB FTW92DPJ03Accident · 1 fatalFinal reportCessna 188A · Idabel, OKPower loss for undetermined reasons. A factor was lack of unsuitable terrain for the forced landing.Jun 24, 1992 · N9973G · DestroyedNTSB CHI92DTK03Accident · Serious injuriesFinal reportPiper PA-25-235/250 · Ramona, SDFailure of the pilot to maintain a visual lookout while maneuvering during aerial application of agricultural chemicals.Jun 24, 1992 · N4601Y · DestroyedNTSB CHI92DTG03Accident · No injuriesFinal reportGrumman G-164A · Orr, NDA stall encountered during the spray run reversal turn. Factors related to the accident are the attempted downwind turn, and insufficient altitude for recovery.Jun 24, 1992 · N9935 · Substantial damageNTSB CHI92DCQ04Accident · Minor injuriesFinal reportWSK PZL Mielec M18 · Norton, KSFailure of the pilot in command to level off while performing aerial application.Jun 23, 1992 · N90135 · Substantial damageNTSB FTW92LA166Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ponca City, OKThe pilot's failure to maintain main rotor RPM. A factor was the contaminated fuel.Jun 21, 1992 · N66LR · Substantial damageNTSB ATL92LA129Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Donalsonville, GAThe pilot's inadequate preflight inspection of the aircraft, and his failure to detect water in the aircraft fuel system.Jun 21, 1992 · N10273 · Substantial damageNTSB SEA92FA130Accident · 1 fatalField investigationFinal reportChampion 7GCBC · Prosser, WAInadequate inflight planning/preparation and airspeed was not maintained. A factor to the accident was: an uncontrolled stall/spin.Jun 20, 1992 · N1812G · Substantial damageNTSB FTW92LA167Accident · No injuriesLimited investigationFinal reportGlasflugel 201B · Briggs, TXThe inadvertent ground loop by the pilot. Factors were the downdraft and the rough/uneven terrain.Jun 20, 1992 · N6152 · Substantial damageNTSB NYC92LA121Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Bedford, NHPhysical impairment of the pilot as the result of alcohol consumption, resulting in his failure or inability to maintain control of the airplane. Factors which contributed to the accident were: the pilot's poor judgement in buzzing residences and his failure…Jun 19, 1992 · N8736V · Substantial damageNTSB NYC92LA120Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Huron, OHThe student pilot's alcoholic impairment of efficiency and judgement which led to his geographical disorientation and eventual fuel exhaustion and total loss of engine power, and his failure to maintain airspeed during the forced landing resulting in a…Jun 19, 1992 · N8215S · DestroyedNTSB FTW92LA168Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA-326 · Clifton, TXThe inadvertent stall by the pilot. Factors were the inadequate altitude and the pilot's lack of experience in type aircraft.Jun 18, 1992 · N71528 · Substantial damageNTSB FTW92GA157Accident · 1 fatalFinal reportHughes OH-6A · Sunland Park, NMThe pilot's failure to see and avoid the wires.Jun 13, 1992 · N10436 · DestroyedNTSB CHI92LA175Accident · 1 fatalLimited investigationFinal reportChampion 7GCAA · Brainerd, MNAn excessive pull up and failure to maintain an airspeed above stalling speed by the pilot in command.Jun 13, 1992 · N2519F · DestroyedNTSB CHI92DTG02Accident · Minor injuriesFinal reportCallair A9B · Bisbee, NDThe loss of engine power due to fuel starvation resulting from the pilot's inadequate preflight inspection.Jun 13, 1992 · N7761V · Substantial damageNTSB SEA92LA125Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Coulee City, WAA loss of engine power for undetermined reasons. Factors include soft terrain.Jun 11, 1992 · N8938H · Substantial damageNTSB SEA92LA124Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Klamath Falls, ORThe pilot's poor inflight planning/decision. Factors to the accident were: clearance was not maintained and inadequate remedial action.Jun 10, 1992 · N3627S · DestroyedNTSB NYC92LA099Accident · 1 fatalLimited investigationFinal reportMurdock/Gates/Field Kolb MK-III · Boonville, NYThe failure of the pilot to maintain proper airspeed, resulting in a stall and loss of airplane control. A factor related to the accident was the student pilot's lack of total flight experience.Jun 7, 1992 · N3146G · Substantial damageNTSB ANC92LA087Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Klutina Lake, AKThe pilo'ts poor inflight planning. Factors include downdrafts, and mountainous/ hilly terrain.Jun 7, 1992 · N4088M · Substantial damageNTSB ATL92LA116Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Socastee, SCThe failure of the pilot to maintain proper clearance from terrain during the maneuver. Factors in the accident were the failure of the pilot to release the banner, and the excessive size of the banner.Jun 6, 1992 · N6179Z · DestroyedNTSB LAX92FA236Accident · 1 fatalField investigationFinal reportCessna 152 · Sylmar, CAThe pilot's failure to adequately judge and evaluate the weather conditions and his improper in-flight decision to fly close to clouds. These acts led to his entering IMC and becoming lost and disoriented.Jun 5, 1992 · N701KA · DestroyedNTSB FTW92LA150Accident · 1 fatalLimited investigationFinal reportLewis-Starduster SA300 · Wills Point, TXThe pilot's inadequate visual lookout.Jun 5, 1992 · N5649 · DestroyedNTSB SEA92FA116Accident · 3 fatalField investigationFinal reportCessna TR182 · Moxee City, WAThe pilot in command's inadvertently allowing the aircraft to stall. A factor contributing to the accident was: rising terrain.Jun 3, 1992 · N736JG · DestroyedNTSB LAX92LA227Accident · No injuriesLimited investigationFinal reportAir Tractor AT 400 · Lemoore, CAThe pilot's failure to observe the presence of an obstacle in the field. Factors which contributed to the accident were the dark nighttime light condition, and the small size and color of the obstacle which decreased the conspicuity of the object.Jun 2, 1992 · N7307V · DestroyedNTSB NYC92FA093Accident · 3 fatalField investigationFinal reportCessna 172N · Brookeville, MDImproper inflight planning/decision by the flight instructor (pic/cfi) in the Cessna 172, his misjudgement of distance between the two airplanes, and inadequate visual lookout by both pilots in the Cessna 172.Jun 1, 1992 · N738YV · 2 aircraft · DestroyedNTSB FTW92FA145Accident · 4 fatalField investigationFinal reportBellanca 17-30A · El Campo, TXThe pilot's failure to maintain adequate airspeed.Jun 1, 1992 · N8230R · DestroyedNTSB MIA92LA128Accident · 2 fatalLimited investigationFinal reportCessna A150L · Cocoa Beach, FLDescent into the ocean for undetermined reasons.May 31, 1992 · N106DM · DestroyedNTSB CHI92DTG01Accident · Serious injuriesFinal reportPiper PA-25-235 · Gardner, NDAn inadvertent stall with insufficient altitude for recovery.May 29, 1992 · N6541Z · Substantial damage