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.
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" 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 LAX96LA219Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Paso Robles, CAthe student pilot's loss of control and subsequent dynamic rollover due to his abrupt and excessive use of the collective and anti-torque controls.NTSB CHI96FA185Accident · 1 fatalField investigationFinal reportCorey Cirrus VK-30 · Lapeer, MIincomplete cure of the bonding material in the cruise flap, improper material in the cruise flap hinge, and improper welding of the cruise flap push rod end caps. Factors were delamination of the cruise flap, partial failure of the cruise flap hinge, and…NTSB IAD96LA088Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B2B · Oakwood, OHa loss of engine power due to inadequate maintenance and inspection by the owner/operator which failed to detect the clogged fuel vent line, and the pilot's improper autorotation. A related factor was the pilot's inadequate training/familiarization with…NTSB MIA96LA144Accident · No injuriesLimited investigationFinal reportBell UH1B · West Palm Beach, FLthe failure of the tail rotor drive shaft which resulted in a loss of tail rotor control.NTSB FTW96LA232Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARfailure of the pilot to maintain clearance from the power line.NTSB FTW96LA231Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Bunkie, LAThe pilot's failure to maintain control of the airplane.NTSB CHI96LA188Accident · 1 fatalLimited investigationFinal reportGray Miniplane DSA-1-G · Astoria, ILthe pilot's failure to maintain clearance with the terrain while performing an aerobatic maneuver.NTSB SEA96LA102Accident · No injuriesLimited investigationFinal reportCessna T188C · Hooper, UTloss of engine power for undetermined reason(s). A factor relating to the accident was: the proximity of obstructions, which limited the pilot's ability to reach a suitable emergency landing area.NTSB LAX96LA214Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Corning, CAthe pilot misjudged the airplane's clearance from wires he was flying beneath. A contributing factor was the presence of light turbulence.NTSB LAX96LA213Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lost Hills, CAthe loss of engine power due to a cylinder failure. A contributing factor was the lack of a suitable field for the forced landing.NTSB SEA96LA103Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Moscow, IDinflight loss of an unsecured access plug from the engine crankcase, which resulted in a loss of engine oil and a forced landing. Factors relating to the accident were: hilly terrain, and foreign material (engine oil) on the windscreen which limited forward…NTSB LAX96LA207Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas MD-600 · Thermal, CAinadequate design of the stress limits for cyclic control of the helicopter.NTSB FTW96FA228Accident · 1 fatalField investigationFinal reportAir Tractor AT-401 · Lake Providence, LAfailure of the pilot to maintain sufficient airspeed, while maneuvering (turning), which resulted in an inadvertent stall and collision with the terrain. The high gusty wind condition was a related factor.NTSB LAX96LA204Accident · 1 fatalLimited investigationFinal reportGrumman G-164 · Colusa, CAfailure of the pilot to remain clear of the power lines. Factors relating to the accident were: Lack of visual cues at dawn, and the power lines.NTSB CHI96LA186Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Crookston, MNcatastrophic engine failure.NTSB CHI96FA169Accident · 1 fatalField investigationFinal reportBeech F33A · Saint Clair, MOfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in a stall and collision with the terrain.NTSB FTW96LA221Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Paradise, TXThe loss of engine power and hydraulic pressure for reasons undetermined. A factor was the lack of suitable terrain for the forced landing.NTSB FTW96LA219Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Griffithville, ARloss of engine oil (leak) for an undetermined reason, which resulted in oil starvation and a loss of engine power; and failure of the pilot to maintain airspeed during the emergency descent/landing phase, which resulted in an inadvertent stall and subsequent…NTSB CHI96LA165Accident · Serious injuriesLimited investigationFinal reportAS+ AC 4 · Hartford, WIlack of airspeed control by the pilot, while maneuvering.NTSB FTW96FA216Accident · 2 fatalField investigationFinal reportNanchang CJ-6A · Shreveport, LAa loss of engine power due to failure of the pressure carburetor diaphragm which led to restricted fuel flow through the carburetor and eventual fuel starvation. Factors contributing to the accident were the unsuitable terrain and tall trees which resulted in…NTSB IAD96LA077Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Hellam, PAthe pilot's loss of directional control during aerial application for undetermined reasons.NTSB SEA96LA093Accident · Serious injuriesLimited investigationFinal reportCrescenzi Kitfox · Terrebonne, ORThe pilot's inadequate compensation for wind conditions and failure to maintain altitude/clearance above terrain, while maneuvering to land. The unfavorable wind was a related factor.NTSB FTW96LA209Accident · No injuriesLimited investigationFinal reportCessna 150M · Springdale, ARthe flight instructor's improper (unapproved) procedure of using the mixture control to simulate an engine failure. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB IAD96LA076Accident · 2 fatalLimited investigationFinal reportCessna 150 · Welch, WVthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear obstacles. A factor was his intentional buzzing.NTSB IAD96LA073Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BCS-65 · Wolfeboro, NHthe pilot's failure to maintain control and altitude of the seaplane while circling to draw attention before landing on the lake. A related factor was that the aircraft was not equipped with a radio.NTSB FTW96LA204Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Okmulgee, OKThe pilot's continued operation with known deficiencies in the airplane and the pilot's and maintenance personnel's failure to comply with an airworthiness directive resulting in the malfunctioning of a worn ignition switch. A factor was trees.NTSB ATL96FA084Accident · 3 fatalField investigationFinal reportLake 4-200 · Melbourne, FLThe pilot's failure to maintain clearance from trees while maneuvering. A factor was the tailwind condition.NTSB FTW96FA200Accident · 1 fatalField investigationFinal reportNorth American Harvard MK II · Lafayette, LAfailure of the pilot to maintain adequate airspeed and/or altitude, while performing aerobatic flight.NTSB LAX96TA187Accident · Minor injuriesFinal reportHughes 369 · Yuma, AZfailure of the pilot to maintain control of the helicopter, while maneuvering close to the ground. The unfavorable wind condition was a related factor.NTSB CHI96LA147Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Blaine, MNfailure of the pilot to maintain adequate airspeed while circling at low altitude, which resulted in an inadvertent stall/spin.NTSB LAX96TA186Accident · No injuriesFinal reportHughes 369 · Yuma, AZfailure of the pilot to maintain altitude and/or clearance from obstacles, while maneuvering a low altitude at night. Factors relating to the accident were: darkness and the lack of visual cues.NTSB MIA96LA132Accident · Minor injuriesLimited investigationFinal reportAerotek Pitts S-2A · Reidsville, NCthe pilot failed to maintain control of the airplane while performing an acrobatic maneuver.NTSB FTW96LA190Accident · Serious injuriesLimited investigationFinal reportDeaton JUNGSTER-1 · Mcalester, OKthe pilot's failure to maintain obstacle clearance.NTSB FTW96LA184Accident · Minor injuriesLimited investigationFinal reportCessna T210M · El Paso, TXfailure of the #2 cylinder connecting rod bolt due to oil starvation as a result of the shifting of the main bearing. A factor was the unsuitable terrain for the forced landing.NTSB CHI96FA141Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Buffalo, MOfailure of company/operator personnel to install the wing and landing gear (strut) fairings after modifying the airplane for a supplemental type certificate (STC), and improper planning/decision by the pilot. Factors relating to the accident were: the…NTSB LAX96FA177Accident · 1 fatalField investigationFinal reportHughes 269C · San Diego, CAthe decision of the pilot to fly at low altitude and low airspeed within a hazardous performance area published in the pilot operating handbook. Factors in the accident were tailwinds, lack of operator preventative maintenance impairing engine power,…NTSB MIA96TA127Accident · No injuriesFinal reportRobinson R-22 · Kissimmee, FLthe pilot's improper use of the helicopter's flight controls which led to an inadvertent loss of tail rotor effectiveness during a hover.NTSB MIA96LA122Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Edison, GAFailure of the mounting studs for the No. 4 cylinder, which resulted in separation of the cylinder and loss of engine power. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW96LA174Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Silver, TXthe pilot's failure to maintain adequate rotor RPM.NTSB FTW96LA172Accident · No injuriesLimited investigationFinal reportCessna 305A · Erie, COentanglement of the tow banner during banner pickup, and subsequent failure or inability to jettison the banner. A factor relating to the accident was: high gusty wind condition.NTSB ANC96LA051Accident · Serious injuriesLimited investigationFinal reportCessna 206G · Whittier, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings and whiteout conditions.NTSB IAD96FA061Accident · 1 fatalField investigationFinal reportCessna P206C · Hartwood, VAthe inadvertent/premature deployment of the first skydiver's parachute, which resulted in contact with the airplane's horizontal stabilizer by the first skydiver and his parachute, loss of integrity of the empennage to the aft fuselage, loss of aircraft…NTSB ANC96LA047Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Wasilla, AKA loss of engine power for an undetermined reason.NTSB CHI96LA130Accident · 3 fatalLimited investigationFinal reportCessna 177B · Perry, MOthe pilot's impairment of judgment and performance due to alcohol, and his failure to maintain altitude/clearance from the power transmission wires. Darkness, restricting the pilot's ability to see-and-avoid the transmission line, was a related factor.NTSB MIA96LA113Accident · 2 fatalLimited investigationFinal reportSnowbird 636D4 · Okeechobee, FLthe failure of the main rotor control connecting rod, which rendered the control stick unusable and led to a loss of control.NTSB FTW96LA167Accident · No injuriesLimited investigationFinal reportWeatherly 620 · Akron, COa total loss of engine power due to failure of the number 2 cylinder. A factor was the limited cockpit visibility due to windscreen damage and engine oil coating.NTSB LAX96LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Inyokern, CAthe pilot misjudged altitude while maneuvering in mountainous terrain. Contributing factors were: the pilot's inadequate in-flight planning and the lack of available thermal lift over the rapidly rising rough terrain.NTSB FTW96LA163Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Midlothain, TXthe pilot's failure to maintain obstacle clearance.NTSB LAX96LA156Accident · 1 fatalLimited investigationFinal reportTwibell Tangent 65 · Lucerne Valley, CAthe pilot's failure to maintain altitude. Factors in the accident were: the pilot's decision to buzz the area and his ostentatious display.NTSB SEA96FA076Accident · No injuriesField investigationFinal reportBell UH-1H · Rainier, WAfailure of the forward power shaft (number 21) bearing. A factor relating to the accident was: the lack of suitable, unobstructed terrain for an emergency landing.