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 MIA92LA165Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Prattville, ALThe pilot-in-command's improper visual lookout and failure to maintain clearance from the wires.Aug 19, 1992 · N731PV · Substantial damageNTSB SEA92LA181Accident · 1 fatalLimited investigationFinal reportR.P. Williams Acro Sport II · Herriman, UTInadequate remedial action and poor inflight planning/decision. A factor to the accident was: an uncontrolled stall/spin.Aug 17, 1992 · N122RW · DestroyedNTSB FTW92DRD05Accident · Minor injuriesFinal reportGrumman G-164 · Thibodaux, LAThe pilot's failure to maintain clearance from the wires.Aug 17, 1992 · N8916H · Substantial damageNTSB LAX92LA350Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Stockton, CAThe pilot's poor inflight planning and visual lookout.Aug 16, 1992 · N4623E · Substantial damageNTSB LAX92FA351Accident · 2 fatalField investigationFinal reportPiper PA-20-135 · Fort Bidwell, CAAn inadvertent stall while maneuvering. Contributing to the accident was pilot's diverted attention.Aug 16, 1992 · N1974A · DestroyedNTSB SEA92LA182Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Miltonfreewater, ORAn inadvertent stall while maneuvering in mountainous terrain. Factors include lack of experience in this type of operation.Aug 15, 1992 · N85425 · Substantial damageNTSB LAX92LA349Accident · Minor injuriesLimited investigationFinal reportHiller UH12-E, Saloy Conver · Arvin, CAThe failure of the tension torsion bar pin due to fatigue. Contributing to this accident was that it was not possible for the pilot to flare the helicopter on landing.Aug 15, 1992 · N9753C · Substantial damageNTSB FTW92LA209Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Special Shape · Tyler, TXThe pilot's failure to maintain adequate altitude and clearance from obstacles.Aug 15, 1992 · GPATY · DestroyedNTSB CHI92DTG04Accident · No injuriesFinal reportGrumman G-164B · Grandin, NDThe cracked cylinder which resulted in a forced landing. The lack of suitable terrain on which to make an emergency landing was a factor.Aug 14, 1992 · N48687 · Substantial damageNTSB LAX92LA348Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Laveen, AZThe pilot's failure to maintain altitude during the low-level aerial application procedure turn. Contributing to this accident was the night condition and the high tension wires.Aug 13, 1992 · N4410S · DestroyedNTSB NYC92LA159Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · West Mifflin, PAA yaw for unknown reason(s) which resulted in the tail rotor contacting the dirt bank and a loss of control. A factor related to the accident was the decision of the pilot to operate in close vicinity to the dirk bank.Aug 12, 1992 · N2070P · Substantial damageNTSB LAX92LA346Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Cirrus · Bishop, CAThe pilot's poor inflight decision to fly over mountainous terrain at an inadequate altitude.Aug 12, 1992 · N7988 · DestroyedNTSB LAX92LA338Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Parker, AZThe inadequate overhaul of the propeller blade by the overhaul facility. Contributing to this accident was the rough and uneven terrain.Aug 9, 1992 · N1547P · Substantial damageNTSB FTW92FA205Accident · 2 fatalField investigationFinal reportCameron V-77 · Mesquite, TXThe failure of the pilot to maintain clearance from known obstacles.Aug 9, 1992 · N9544G · DestroyedNTSB CHI92LA233Accident · Minor injuriesLimited investigationFinal reportMBB BO-105 · Madison, SDThe pilot's inadequate visual lookout and inadvertent descent.Aug 9, 1992 · N30SV · Substantial damageNTSB CHI92FA232Accident · 2 fatalField investigationFinal reportBell 206B · St. Charles, MOThe pilot-in-command's failure to see and avoid the wires, and his physical impairment due to alcohol consumption. A factor which contributed to the effect of the alcohol impairment was the medicine.Aug 9, 1992 · N200LT · DestroyedNTSB ATL92LA155Accident · No injuriesLimited investigationFinal reportCessna 150L · Manteo, NCThe delayed level off by the pilot, during the banner pick-up, which resulted in the entanglement of the banner with the horizontal stabilizer.Aug 9, 1992 · N11912 · Substantial damageNTSB ATL92LA154Accident · Minor injuriesLimited investigationFinal reportWeatherly 620A · Cobb, GAThe corroded, and separated, magnetic chip detector plug which allowed the loss of all engine oil and the engine's subsequent seizure. Factors were the inadequate 100 hour inspection, and the high vegetation in the forced landing field.Aug 9, 1992 · N4650W · Substantial damageNTSB LAX92LA337Accident · 2 fatalLimited investigationFinal reportCessna 310M · Honolulu, HILoss of aircraft control for an undetermined reason after the pilot took off at night and flew the aircraft into the area of a thunderstorm and lightning.Aug 8, 1992 · N26070 · DestroyedNTSB MIA92LA160Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Redwood, MSImproper maintenance of the airplane by an unknown person.Aug 7, 1992 · N3165A · Substantial damageNTSB CHI92FA231Accident · 2 fatalField investigationFinal reportCessna 120 · Maple, WIThe non-instrument rated private pilot's failure to maintain aircraft control.Aug 7, 1992 · N1947N · DestroyedNTSB FTW92DPG13Accident · 1 fatalFinal reportCessna A188 · Forrest City, ARThe pilot's failure to maintain clearance with the trees.Aug 6, 1992 · N9858V · DestroyedNTSB CHI92DEC03Accident · 1 fatalFinal reportJarrell RV-3 · Jackson, MIAn overload and total failure of the rear wing attach fitting.Aug 6, 1992 · N50WP · DestroyedNTSB NYC92LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot diverted his attention from flying the airplane and did not maintain a visual lookout, which resulted in a collision with trees.Aug 5, 1992 · N4280M · Substantial damageNTSB DEN92LA082Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Del Norte, COInadvertent stall while maneuvering during aerial application at an altitude insufficient for recovery.Aug 5, 1992 · N6646 · DestroyedNTSB FTW92FA201Accident · 1 fatalField investigationFinal reportCessna 172P · Breckenridge, TXAn inadvertent stall.Aug 4, 1992 · N63930 · Substantial damageNTSB LAX92FA331Accident · 1 fatalField investigationFinal reportCessna 152 · Maricopa, AZThe pilot exceeded the design stress limits of the airplane structure by attempting an abrupt maneuver at a speed in excess of the maneuvering speed.Aug 3, 1992 · N49016 · DestroyedNTSB SEA92LA170Accident · No injuriesLimited investigationFinal reportCessna 411 · Lehi, UTThe failure by the pilot to maintain airspeed above VMC, resulting in loss of control in flight, and his failure to lower the flaps and landing gear for the forced landing. A factor relating to the accident was the pilot's decision to perform fuel system…Jul 30, 1992 · N136CH · Substantial damageNTSB ANC92FA116Accident · 6 fatalField investigationFinal reportDe Havilland DHC-2 Mark 1 · Dillingham, AKThe pilot's delayed decision in reversing course and his failure to maintain airspeed during the maneuver. Factors related to the accident were: mountainous terrain and a low ceiling.Jul 30, 1992 · N67151 · DestroyedNTSB LAX92LA319Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Hayfork, CAThe failure of the main rotor drive shaft due to the improper installation by company maintenance personnel of an 'o' ring seal, which allowed the packing grease to escape and caused the over temperature failure of the drive shaft. A factor in the accident…Jul 28, 1992 · N89NW · Substantial damageNTSB SEA92LA167Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Shelby, MTThe poor decision by the pilot to make an aerial application turn around manuever under power lines and his failure to maintain clearance from the power lines.Jul 27, 1992 · N4859 · DestroyedNTSB FTW92DPA01Accident · Serious injuriesFinal reportAir Tractor AT-301 · Dekalb, TXLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jul 26, 1992 · N3167Y · DestroyedNTSB ATL92LA147Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Southport, NCThe failure of the pilot to maintain clearance from obstacles. A factor was the dusk lighting condition.Jul 25, 1992 · N7712H · Substantial damageNTSB FTW92LA187Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Midland, TXA loss of control for reasons undetermined.Jul 23, 1992 · N84102 · DestroyedNTSB SEA92FA160Accident · 1 fatalField investigationFinal reportCessna 172P · Kingston, WAThe pilot's attempt to conduct VFR flight in instrument meteorological conditions. Factors include fog and low ceilings.Jul 22, 1992 · N52201 · Substantial damageNTSB LAX92LA311Accident · No injuriesLimited investigationFinal reportCessna 172 · Elko, NVThe pilot's failure to maintain adequate altitude over the terrain, and his failure to maintain sufficient airspeed. The mountainous terrain was a factor.Jul 22, 1992 · N7138F · Substantial damageNTSB FTW92LA183Accident · No injuriesLimited investigationFinal reportCessna 180K · Curlew Island, LAThe pilot's selection of unsuitable terrain for landing. A factor was the pilot's physical impairment.Jul 22, 1992 · N66618 · Substantial damageNTSB SEA92LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Provo, UTFuel exhaustion due to inadequate fuel supply. Factors include a ditch encountered while landing.Jul 21, 1992 · N67819 · Substantial damageNTSB SEA92LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · Twin Falls, IDThe pilot's failure to refuel resulting in fuel exhaustion and the unsuitable terrain encountered during the forced landing.Jul 20, 1992 · N78734 · Substantial damageNTSB BFO92LA106Accident · No injuriesLimited investigationFinal reportHaas Rans S-6 · Nokesville, VAImproper planning or decision by the pilot, and his failure to maintain clearance from obstructions after inadvertently becoming airborne. The high density altitude, high obstructions, and the pilot's lack of familiarity with the airplane were related factors.Jul 20, 1992 · N116LP · Substantial damageNTSB CHI92DEX03Accident · 1 fatalFinal reportPiper PA-25-260 · Decker, INFailure of the right wing spar, improper maintenance/modification, and failure to comply with an airworthiness directive.Jul 18, 1992 · N4766Y · DestroyedNTSB FTW92FA180Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Tool, TXThe pilot exceeded the design stress limits of the airframe as a result of flight into known adverse weather conditions.Jul 17, 1992 · N6959C · DestroyedNTSB CHI92LA209Accident · No injuriesLimited investigationFinal reportBeech E35 · Escanaba, MIThe pilot's decision to fly into known adverse weather conditions.Jul 17, 1992 · N3488B · Substantial damageNTSB FTW92DPG09Accident · Serious injuriesFinal reportAir Tractor AT-301A · Fisher, ARA loss of engine power for undetermined reasons and the failure of the pilot to maintain airspeed above a stall.Jul 15, 1992 · N3652B · Substantial damageNTSB CHI92LA207Accident · No injuriesLimited investigationFinal reportCessna 172N · Bates City, MOTotal failure of the airplane windshield.Jul 15, 1992 · N1324E · Substantial damageNTSB ATL92FA138Accident · 2 fatalField investigationFinal reportKory G. Cornum SH-3R · Auburn, ALThe failure of the pilot-in-command to maintain adequate airspeed after initiating a maneuver from low altitude. A factor was the lack of sufficient altitude.Jul 15, 1992 · N383KR · DestroyedNTSB SEA92LA152Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH12D · Loman, IDFuel exhaustion. Factors include a short in the fuel quantity sensor/transmitter, an inadequate preflight, and a tree covered landing area.Jul 14, 1992 · N62404 · Substantial damageNTSB MIA92LA149Accident · No injuriesLimited investigationFinal reportMooney M20C · Pass-A-Grille, FLTotal loss of engine power due to fuel starvation.Jul 13, 1992 · N9379A · Substantial damageNTSB ANC92LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Palmer, AKThe pilot's inadvertent stalling of the airplane and an inadequate altitude in which he could recover. Factor relating to the accident was the water in the fuel.Jul 13, 1992 · N61272 · Substantial damageNTSB SEA92LA151Accident · No injuriesLimited investigationFinal reportBerkshire Mfg. Concept 70 · Ephrata, WAInadequate in-flight planning/decision. Factors to the accident were: no thermal lift and rough/uneven terrain.Jul 12, 1992 · N382W · Substantial damage