NTSB investigations, 1992

309 cases where the phase of flight was Maneuvering.

Cases per year

19622026
NTSB investigations, 1992 per year, 1962–2026: 18,849 cases
1964415
1965419
1966366
1967410
1968394
1969360
1970330
1971384
1972359
1973407
1974410
1975407
1976480
1977443
1978433
1979384
1980377
1981374
1982416
1983476
1984462
1985402
1986357
1987357
1988349
1989313
1990307
1991350
1992309
1993315
1994322
1995320
1996279
1997262
1998259
1999267
2000281
2001257
2002241
2003263
2004224
2005212
2006203
2007222
2008234
2009208
2010222
2011250
2012236
2013216
2014199
2015217
2016177
2017201
2018187
2019197
2020165
2021186
2022186
2023191
2024165
2025145
202690

Latest cases

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 year(c.\"eventDate\") = 1992
    AND 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 FTW93LA059Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Clint, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Dec 27, 1992 · N18532 · DestroyedNTSB FTW93LA058Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Coleman, TXA loss of engine power for undetermined reasons. A factor was the unsuitable terrain.Dec 26, 1992 · N5159Q · Substantial damageNTSB FTW93LA057Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Weatherford, TXAn engine failure for undetermined reasons. The lack of suitable terrain for the forced landing was a factor.Dec 26, 1992 · N9891B · Substantial damageNTSB DEN93LA016Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Boulder, COThe pilot's failure to evaluate changing weather conditions.Dec 19, 1992 · N4384A · Substantial damageNTSB ATL93LA037Accident · 1 fatalLimited investigationFinal reportDonald Rhodes Moni 110 · Greenville, TNThe pilot's operation of the aircraft beyond its design stress limits.Dec 19, 1992 · UNREG · DestroyedNTSB LAX93LA069Accident · 1 fatalLimited investigationFinal reportLydick LONG-EZ · Tucson, AZThe pilot's failure to maintain an airspeed or power setting sufficient to maintain engine rotation during the low speed demonstration. A factor in the accident was the insufficient altitude to affect an engine restart once the propeller stopped turning.Dec 18, 1992 · N777CJ · DestroyedNTSB ATL93LA033Accident · Minor injuriesLimited investigationFinal reportKaman HH43F · Columbia, SCThe deterioration of the engine fuel shutoff solenoid valve which failed in the closed position.Dec 11, 1992 · N100PL · Substantial damageNTSB SEA93FA033Accident · 1 fatalField investigationFinal reportBeech 35-33 · Riverton, UTTerrain clearance was not maintained. Factors to the accident were: snow and flight into known adverse weather.Dec 9, 1992 · N755AA · DestroyedNTSB MIA93LA027Accident · Minor injuriesLimited investigationFinal reportBell 47-G5A · Belle Glade, FLThe improper in flight decision of the pilot in command to attempt an agricultural turn with insufficient altitude to accomplish the maneuver. Contributing to the accident was the pilot's overconfidence in his abilities.Dec 7, 1992 · N7925J · Substantial damageNTSB LAX93LA063Accident · No injuriesLimited investigationFinal reportHughes 269B · Kahului, HIFailure of the pilot to maintain adequate rotor RPM during downwind flight and adequate altitude to recover the loss of main rotor RPM before settling into the water. Contributing to the accident was the pilot's lack of rotorcraft flight experience.Dec 7, 1992 · N9566F · DestroyedNTSB SEA93FA032Accident · 1 fatalField investigationFinal reportCessna 152 · Marysville, WAThe design stress limits of the airframe were exceeded by the student pilot.Dec 6, 1992 · N69260 · DestroyedNTSB SEA93FA029Accident · 2 fatalField investigationFinal reportAeronca 7AC · Medford, ORThe failure of the pilot to maintain clearance from wires while buzzing.Dec 5, 1992 · N2216E · DestroyedNTSB ANC93LA019Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Scammon Bay, AKThe pilots VFR flight into IMC conditions, and his failure to maintain sufficient altitude while maneuvering. Contributing to the accident were the whiteout snow and fog conditions.Dec 4, 1992 · N8374T · Substantial damageNTSB LAX93LA059Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lost Hills, CAThe pilot's poor preflight planning/preparation, poor fuel consumption calculations, and delay in effecting any remedial action. Contributing to this accident was the pilot inadvertently becoming Lost/disoriented and the dark night.Dec 3, 1992 · N5405S · Substantial damageNTSB LAX93LA057Accident · 2 fatalLimited investigationFinal reportHughes 369B · Fallbrook, CAThat the pilot misjudged the distance of the high tension wires from the helicopter.Dec 2, 1992 · N5035F · DestroyedNTSB CHI93FA042Accident · 2 fatalField investigationFinal reportCessna 150L · Waldron, MOThe pilot's failure to maintain aircraft control.Nov 28, 1992 · N18528 · DestroyedNTSB SEA93FA025Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Cedar City, UTClearance from mountainous terrain was not maintained. Factors to the accident were: dark night condition, snow showers, and intentional flight into known adverse weather.Nov 23, 1992 · N5108S · DestroyedNTSB LAX93LA050Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Hilo, HIThe pilot's intentional flight in and near a volcanic gas cloud which induced a partial loss of engine power due to a lack of combustible oxygen in the atmosphere.Nov 21, 1992 · N789N · Substantial damageNTSB LAX93LA047Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Wellington, NVThe pilot's improper handling of his airplane during the performance of an aerobatic maneuver with inadequate altitude.Nov 21, 1992 · N117E · DestroyedNTSB SEA93FA023Accident · 3 fatalField investigationFinal reportCessna T207A · Elk City, IDThe pilot's continuation of a VFR flight into instrument meteorological conditions. Factors include becoming lost, disoriented, falling snow, and mountainous, hilly terrain.Nov 19, 1992 · N6257H · Substantial damageNTSB LAX93LA043Accident · Serious injuriesLimited investigationFinal reportHughes 269C · Camp Verde, AZThe pilots intentional maneuvering flight at a altitude inadequate to ensure terrain clearance.Nov 16, 1992 · CGGLF · Substantial damageNTSB LAX93LA037Accident · 1 fatalLimited investigationFinal reportCessna TU206G · Ruby, AZFuel exhaustion due to inaccurate preflight planning.Nov 13, 1992 · XBBRI · DestroyedNTSB ANC93GA020Accident · 2 fatalFinal reportPiper PA-18-150 · Beaver, AKThe pilot-in-command's failure to maintain airspeed which resulted in an inadvertent stall at an altitude inadequate to affect a recovery. Factors which contributed to the accident were: the overweight airplane, and the snow covered mountainous terrain.Nov 12, 1992 · N9124D · DestroyedNTSB ANC93LA014Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Ekwok, AKThe pilot failed to maintain airspeed and inadvertently stalled the airplane. Contributing to the accident were the pilots improper in flight planning/decision, her intentional flight into known adverse weather, and the fog and icing conditions.Nov 11, 1992 · N9237M · Substantial damageNTSB FTW93FA033Accident · 2 fatalField investigationFinal reportBellanca 17-31ATC · Dublin, TXImproper IFR operation by the pilot by descending under instrument meteorological conditions below the minimum altitude and the pilot's failure to maintain control of the airplane while maneuvering for a landing. Factors which contributed to the accident…Nov 9, 1992 · N39883 · DestroyedNTSB SEA93FA018Accident · 2 fatalField investigationFinal reportMaule M5 · Challis, IDThe pilot continued the VFR flight into IMC weather conditions. Factors relating to the accident were the snow and obscuration weather conditions, inadequate preflt planning/preparation by the pilot in command, and the mountainous terrain.Nov 7, 1992 · N9008E · DestroyedNTSB LAX93LA030Accident · 1 fatalLimited investigationFinal reportBellanca 8KCAB · Pahrump, NVThe pilot misjudged the pull up altitude.Nov 5, 1992 · N57644 · DestroyedNTSB FTW93FA032Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Uvalde, TXClearance not maintained by pilot in command.Nov 5, 1992 · N6798A · DestroyedNTSB LAX93LA026Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Fontana, CAThe noncertificated pilot's unwarranted low flying.Nov 2, 1992 · N49180 · Substantial damageNTSB LAX93FA024Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Kelso, CAThe pilot's poor preflight planning; his inadequate weather evaluation; and his intentional VFR flight into instrument meteorological conditions. Contributing to the accident was the turbulence, rain and low clouds.Oct 31, 1992 · N7902P · DestroyedNTSB LAX93FA020Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Cottonwood, AZAn inadvertent stall and descent into terrain when the pilot failed to maintain sufficient airspeed and altitude above the ground.Oct 30, 1992 · N2221L · DestroyedNTSB FTW93LA027Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Liverpool, TXThe loss of engine power due to the failure of the engine blower. A factor was the lack of suitable terrain at the pilot's disposal.Oct 29, 1992 · N637U · Substantial damageNTSB FTW93LA024Accident · No injuriesLimited investigationFinal reportCessna 150M · Norman, OKThe pilot's failure to properly judge his level off altitude while maneuvering.Oct 26, 1992 · N8960U · Substantial damageNTSB SEA93FA010Accident · 2 fatalField investigationFinal reportPiper PA-12 · Lowman, IDThe pilot's failure to maintain adequate terrain clearance. Factors include mountainous/hilly terrain, trees, and the pilot's diverted attention.Oct 25, 1992 · N3743M · DestroyedNTSB CHI93LA017Accident · 1 fatalLimited investigationFinal reportPiper PA-25-260 · Trenton, NDThe pilot's improper aircraft handling while maneuvering at low altitude.Oct 24, 1992 · N8675L · DestroyedNTSB LAX93LA017Accident · 1 fatalLimited investigationFinal reportPasporello, J.F. RV-3 · Lompoc, CAThe failure of an unidentified airframe or component system for unknown reasons and the resulting inflight fire.Oct 23, 1992 · N65JP · DestroyedNTSB CHI93LA018Accident · 1 fatalLimited investigationFinal reportAmerican Eagle 101 · New Hudson, MIThe pilot's failure to maintain aircraft control.Oct 23, 1992 · N7157A · DestroyedNTSB SEA93LA006Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Sisters, ORThe pilot's poor inflight decision. Factors include mountainous/hilly terrain, trees, high density altitude, and downdrafts.Oct 20, 1992 · N19092 · Substantial damageNTSB FTW93FA017Accident · 1 fatalField investigationFinal reportCessna 150L · Liverpool, TXThe pilot's failure to maintain clearance with the obstruction. Factors were: the pilot's lack of total experience in night operations, and inadequate supervision from the certified flight instructor.Oct 19, 1992 · N10736 · DestroyedNTSB ATL93FA012Accident · 2 fatalField investigationFinal reportPiper PA-12 · Cedar Springs, GAThe private pilot's failure to maintain airspeed above stalling speed, and his failure to maintain a proper altitude, which resulted in an inadvertent, low altitude stall. A factor was the gusty wind condition at the time of the accident.Oct 17, 1992 · N2479M · DestroyedNTSB FTW93LA015Accident · No injuriesLimited investigationFinal reportRobinson R22B · Robert Lee, TXThe loss of engine/rotor RPM for undetermined reasons.Oct 15, 1992 · N8066B · Substantial damageNTSB LAX93FA011Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Rosemead, CAThe pilot's poor preflight planning/preparation and intentional flight into instrument meteorological conditions. Factors relating to this accident were the prevailing low ceiling and fog.Oct 13, 1992 · N3940F · DestroyedNTSB DEN93LA003Accident · Serious injuriesLimited investigationFinal reportO'Connor SNO-BIRD XL · Bryan, TXDelamination of the rudder leading edge and subsequent jamming of the rudder.Oct 10, 1992 · N532SB · Substantial damageNTSB ATL93LA009Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Centre, ALThe pilot's failure to maintain main rotor RPM, which resulted in an in flight loss of control and collision with terrain.Oct 9, 1992 · N31FG · Substantial damageNTSB NYC93LA011Accident · Serious injuriesLimited investigationFinal reportAnderson Pitts S-1 · Minersville, PAA loss of control due to a foreign object jamming the elevator flight controls.Oct 8, 1992 · N31SP · DestroyedNTSB LAX93LA005Accident · 1 fatalLimited investigationFinal reportSwich II · El Mirage, CAThe pilot/owner's improper installation of the vertical stabilizer. Contributing to this accident was the pilot's intentional stall, inadvertent spin, and inability to recover from the spin due to the inadequate equipment (vertical stabilizer) design.Oct 6, 1992 · N4663A · DestroyedNTSB FTW93LA006Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Montrose, ARThe pilot's failure to maintain aircraft control and the inadvertent stall. A factor was the pilot's diverted attention in the cockpit.Oct 6, 1992 · N9633J · Substantial damageNTSB MIA93LA004Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Naples, FLIncorrect airspeed, insufficient airspeed, and failure of the pilot in command to perform the correct emergency procedure following the in flight loss of control. Contributing to the accident was self induced pressure by the pilot in command.Oct 5, 1992 · N2321X · Substantial damageNTSB LAX93LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Three Points, AZThe pilot's poor judgment, intentional buzzing, and poor visual lookout. Contributing to this accident was the pilot's diverted attention.Oct 4, 1992 · N3099G · Substantial damageNTSB SEA93LA003Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Powell, WYThe pilot in command's failure to assure clearance from the radio tower. Factors contributing to the accident were the marked tower and the pilot in command's inadequate visual lookout.Oct 3, 1992 · N32889 · Destroyed