NTSB investigations, 1994
322 cases where the phase of flight was Maneuvering.
Cases per year
| 1964 | 415 |
|---|---|
| 1965 | 419 |
| 1966 | 366 |
| 1967 | 410 |
| 1968 | 394 |
| 1969 | 360 |
| 1970 | 330 |
| 1971 | 384 |
| 1972 | 359 |
| 1973 | 407 |
| 1974 | 410 |
| 1975 | 407 |
| 1976 | 480 |
| 1977 | 443 |
| 1978 | 433 |
| 1979 | 384 |
| 1980 | 377 |
| 1981 | 374 |
| 1982 | 416 |
| 1983 | 476 |
| 1984 | 462 |
| 1985 | 402 |
| 1986 | 357 |
| 1987 | 357 |
| 1988 | 349 |
| 1989 | 313 |
| 1990 | 307 |
| 1991 | 350 |
| 1992 | 309 |
| 1993 | 315 |
| 1994 | 322 |
| 1995 | 320 |
| 1996 | 279 |
| 1997 | 262 |
| 1998 | 259 |
| 1999 | 267 |
| 2000 | 281 |
| 2001 | 257 |
| 2002 | 241 |
| 2003 | 263 |
| 2004 | 224 |
| 2005 | 212 |
| 2006 | 203 |
| 2007 | 222 |
| 2008 | 234 |
| 2009 | 208 |
| 2010 | 222 |
| 2011 | 250 |
| 2012 | 236 |
| 2013 | 216 |
| 2014 | 199 |
| 2015 | 217 |
| 2016 | 177 |
| 2017 | 201 |
| 2018 | 187 |
| 2019 | 197 |
| 2020 | 165 |
| 2021 | 186 |
| 2022 | 186 |
| 2023 | 191 |
| 2024 | 165 |
| 2025 | 145 |
| 2026 | 90 |
Where
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\") = 1994
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.
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") = 1994
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA95LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Lehi, UTThe pilot's failure to maintain altitude/clearance above the terrain. Factors include the pilot inadvertently becoming lost/disoriented, his improper inflight decision to attempt to maneuver through unfamiliar mountainous terrain to his original destination,…NTSB LAX95LA064Accident · No injuriesLimited investigationFinal reportRockwell S2R Thrush Cmdr · Yuma, AZa forced landing due to an engine failure of the no.1 cylinder.NTSB MIA95LA044Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLInadequate supervision by the pilot-in-command (CFI) for failure to note reduction in clearance between the tail rotor and an embankment.NTSB CHI95LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadequate design of the reserve parachute cable housing, which resulted in an inadvertent deployment of the parachute, and subsequent collision with, and jamming of, the aircraft's horizontal stabilizer, necessitating a forced landing.NTSB FTW95LA066Accident · Serious injuriesLimited investigationFinal reportCessna 182R · Eagle Nest, NMThe pilot's flight into rising terrain without sufficient altitude and climb performance available to clear the trees and terrain. A factor was the pilot becoming lost and disoriented.NTSB LAX95LA052Accident · No injuriesLimited investigationFinal reportBell 206B · Julian, CAthe failure of the pilot to maintain a proper alignment during hover in a mountainous area.NTSB LAX95LA051Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Oasis, CAthe pilot's improper inflight decision by selecting an inadequate terrain clearance altitude over mountainous terrain.NTSB ANC95LA020Accident · No injuriesLimited investigationFinal reportCessna 207 · Saint Mary'S, AKThe pilot's decision to continue visual flight into instrument meteorological conditions. Factors associated with the accident are the pilot's failure to maintain adequate altitude/clearance from terrain, and the whiteout weather conditions.NTSB LAX95LA050Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Tehachapi, CAthe pilot's poor in-flight planning/decision and inadequate airspeed. The downdraft and trees were factors in this accident.NTSB LAX95FA043Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260C · North Las Vegas, NVthe pilot's failure to maintain control of the airplane by inadvertently allowing the flying passenger to enter a stall/spin. Factors in the accident were the passenger's interference with the pilot's attempted recovery from the spin, and the pilot's lack of…NTSB CHI95DCA01Accident · 1 fatalFinal reportYakovlev YAK-52 · Caruthersville, MOThe insufficient altitude (300 feet above the airport) at which an aerobatic maneuver was attempted by the pilot.NTSB ATL95LA019Accident · 2 fatalLimited investigationFinal reportWeeks Glasair SH2F · Timmonsville, SCThe pilot's continued operation into known adverse weather conditions with a known aircraft deficiency, and his ensuing spatial disorientation, which resulted in ground impact during an uncontrolled descent.NTSB FTW95LA054Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks DG-600 · Alamogordo, NMThe inadvertent stall.NTSB MIA95LA028Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Tunica, MSThe pilot's delay in obtaining ATC assistance after becoming lost/disoriented resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was failure of the pilot to navigate using the VOR system.NTSB MIA95FA027Accident · 2 fatalField investigationFinal reportChampion 7ECA · Arcadia, FLThe failure of the dual-student to maintain airspeed while maneuvering resulting in an inadvertent stall and uncontrolled descent. Contributing to the accident was improper supervision of the dual-student by the flight instructor.NTSB MIA95LA024Accident · Serious injuriesLimited investigationFinal reportAyres S2R-R1820 · Arcadia, FLFailure of the engine due to a undetermined failure in the engine power section.NTSB MIA95FA023Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Daytona Beach, FLThe pilot's failure to maintain aircraft control while maneuvering in instrument flight conditions during an instrument approach, resulting in the pilot becoming spatially disoriented, and a subsequent in-flight collision with terrain. Contributing to the…NTSB SEA95LA023Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Yamhill, ORFailure of the pilot to maintain adequate altitude/clearance, while maneuvering to a hover, which allowed the external load cable/hook to become snagged and to rebound into the path of the main rotor blades.NTSB BFO95LA013Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Magnolia, DEthe pilot's failure to maintain adequate rotor rpm while hovering.NTSB ATL95LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Johns Island, SCA loss of engine power due to a partially blocked fuel line to the gascolator.NTSB MIA95FA021Accident · 2 fatalField investigationFinal reportPiper PA-18 · Bainbridge, GAInadvertent stall/spin and altitude inadequate for recovery by the pilot-in-command (CFI).NTSB FTW95FA050Accident · 2 fatalField investigationFinal reportCessna 172P · Deming, NMThe pilot's failure to maintain sufficient altitude and clearance in moutainous terrain. Factors were rising terrain and gusty, high wind conditions.NTSB FTW95FA047Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G-164B · Wisner, LAThe pilot's failure to maintain minimum required airspeed for flight. A factor was the pilot's lack of total experience in the type of aircraft.NTSB LAX95FA037Accident · 3 fatalField investigationFinal reportCessna 172K · Springerville, AZthe pilot's failure to maintain the proper airspeed, which resulted in an inadvertent stall/spin. The pilot's diverted attention and overconfidence in the aircraft's ability to fly slow were factors in this accident.NTSB ATL95FA014Accident · 2 fatalField investigationFinal reportCessna 172H · Louisville, GAThe pilot's failure to maintain clearance from trees during a low pass maneuver. A factor was the trees at the vicinity of the low pass.NTSB LAX95FA033Accident · 1 fatalField investigationFinal reportSchweizer 269C · Valencia, CAthe pilot's failure to maintain adequate clearance from a dirt embankment while performing an undetermined maneuver.NTSB FTW95LA041Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Johnson City, TXThe pilot's failure to maintain clearance with the trailer while landing.NTSB SEA95FA017Accident · 4 fatalField investigationFinal reportBeech 58P · Great Falls, MTThe pilot's failure to maintain airspeed. A factor to the accident was: inadequate aircraft preflight.NTSB FTW95LA039Accident · No injuriesLimited investigationFinal reportHughes 269A · Monticello, ARThe loss of engine power due to a fatigued rod end bolt. A factor was the lack of suitable terrain for landing.NTSB NYC95LA021Accident · 2 fatalLimited investigationFinal reportBoeing A-75N1 · Sayville, NYA loss of control in flight by the pilot(s) while maneuvering, with insufficient altitude for recovery.NTSB MIA95FA018Accident · 2 fatalField investigationFinal reportBölkow BO-105S · Perry, FLFailure of the pilot to maintain sufficient clearance from the power line, while buzzing (at low altitude).NTSB SEA95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Gillette, WYThe pilot in command's failure to maintain clearance with terrain. Factors contributing were the snow covered terrain and low ceiling resulting in poor contrast.NTSB ATL95LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Rock Hill, SCThe student pilot's poor judgement and his failure to maintain clearance from obstacles.NTSB LAX95LA023Accident · No injuriesLimited investigationFinal reportGlen A. Senecal 5151 · Apple Valley, CAthe manufacturer's (owner/operator) improper balancing of the aileron flight controls which resulted in a cable separation due to overload from the aileron flutter. The rough/uneven terrain was also a factor.NTSB SEA95LA013Accident · No injuriesLimited investigationFinal reportHiller UH-12E4 · Morton, WAA leak in the fuel filler cap and water in the fuel system. A factor to the accident was: inadequate preflight.NTSB LAX95FA020Accident · 2 fatalField investigationFinal reportCessna T337H · Douglas City, CAThe improper in-flight decision of the pilot to fly in dark night time conditions in mountainous terrain during adverse weather conditions.NTSB SEA95FA012Accident · 2 fatalField investigationFinal reportUnited Consultant UC-1 · Pinedale, WYAircraft control was not maintained. Factors to the accident were: rough water and downdrafts.NTSB FTW95LA032Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Ruston, LAThe pilot's improper handling of the helicopter after an apparent loss of power during a practice autorotation.NTSB MIA95LA008Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLFailure of the pilot to refuel resulting in loss of engine power due to fuel exhaustion.NTSB NYC95LA017Accident · Minor injuriesLimited investigationFinal reportPitts S-1C · Galeville, NYInadequate maintenance inspection which resulted in disengagement of the rudder clevis bolt and the inflight loss of control during aerobatic manuevers.NTSB FTW95LA025Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Tres Piedras, NMThe pilot's inadequate inflight planning which led to maneuvering at slow airspeed to avoid terrain which resulted in further loss of airspeed and an aerodynamic stall.NTSB FTW95FA020Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Artesia, NMThe pilot's impairment of judgment and performance due to drugs, and his failure to maintain clearance from a powerline.NTSB FTW95LA028Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lubbock, TXThe pilot's failure to maintain clearance with the irrigation equipment. A factor was pilot fatigue.NTSB ATL95LA006Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jakin, GAThe loss of engine power for undetermined reasons.NTSB BFO95LA005Accident · Minor injuriesLimited investigationFinal reportS M A N Hydroplum Petrel · Center Village, OHLoss of engine power due to a malfunction of the fuel pump.NTSB NYC95LA009Accident · 1 fatalLimited investigationFinal reportAerospatiale AS-355 · Jonesville, VAThe pilot's failure to maintain clearance from the power lines.NTSB FTW95FA019Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · College Station, TXThe pilot's failure to maintain airspeed and the resulting inadvertent stall. Factors were the pilot's inadequate preflight inspection, and his diverted attention to an open cargo door.NTSB NYC95LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-108 · Beans Cove, PAThe pilot's failure to maintain adequate obstacle clearance which resulted in an inflight collision with a tree.NTSB LAX95LA005Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAan in-flight engine compartment fire for undetermined reasons.NTSB SEA95LA006Accident · 2 fatalLimited investigationFinal reportGlines Acro Duster II SA750 · West Jordon, UTThe pilot-in-command's attempt to perform a low altitude flight maneuver, and his failure to maintain adequate airspeed during the maneuver. This led to an unrecoverable aerodynamic stall.