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 LAX90DVA10Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Westley, CAThe pilot's failure maintain obstacle clearance.NTSB NYC90DEG02Accident · 1 fatalFinal reportTrice Pitts Special S-1S · Hamilton, OHThe loss of engine power for undetermined reasons.NTSB LAX90DVA09Accident · No injuriesFinal reportRockwell S2R · Mendota, CALoss of engine power for an unknown reason. Darkness was a related factor.NTSB NYC90LA197Accident · No injuriesLimited investigationFinal reportRobinson R-22HP · Islip, NYImproper use of flt controls.NTSB MIA90FA171Accident · 2 fatalField investigationFinal reportNeal Christen Eagle II · Akron, ALFailure of the pilot to maintain control of the aircraft and to recover from (or avoid) a subsequent (flat) spin. Factors related to the accident were: the pilot's failure to follow established procedures, his lack of familiarity with the aircraft, and the…NTSB DEN90LA171Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Silver City, NMThe pilot's improper planning which resulted in a flight in conditions which exceeded the performance capability of the aircraft. The high density altitude was a factor.NTSB FTW90DPG09Accident · 1 fatalFinal reportGrumman G164A · Osceola, ARThe pilot's failure to maintain proper clearance from the power lines.NTSB ANC90FA146Accident · 2 fatalField investigationFinal reportCessna A150 · Kenai, AKPilot-in-command's failure to maintain control of the airplane.NTSB NYC90FA192Accident · 1 fatalField investigationFinal reportBellanca 7GCAA · Saltaire, NYThe pilot misjudged his altitude.NTSB LAX90LA283Accident · Minor injuriesLimited investigationFinal reportBell 206B II · San Francisco, CAThe pilot's failure to maintain directional control of the helicopter. Contributing to the accident was the pilot's decision to operate the helicopter in a flight regime conducive to unanticipated right yaw.NTSB CHI90DTG04Accident · No injuriesFinal reportPiper PA-25-235 · Parshall, NDImproper use of powerplant controls.NTSB SEA90FA163Accident · 1 fatalField investigationFinal reportCessna A185F · Wrangell, AKThe pilot did not maintain an adequate airspeed. The pilot's lack of recent experience in the Cessna 185 was a contributing factor.NTSB CHI90LA226Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-150 · Minden, NEA stall encountered because of aircraft control not maintained by the PIC. Factors were a partial powerplant failure due to carburetor icing conditions, carburetor heat not used by the PIC, and load jettison not performed by the PIC.NTSB ANC90LA190Accident · 2 fatalLimited investigationFinal reportPiper PA-12 · Cathedral Rapid, AKThe pilot's failure to maintain adequate altitude above the terrain which resulted in a loss of airspeed and a stall/spin while maneuvering to avoid terrain. The mountainous terrain, high winds, and high density altitude were factors which contributed to the…NTSB ATL90FA158Accident · 2 fatalField investigationFinal reportNorth American T-6G · Locust Grove, GAThe pilot-in-command's failure to maintain aircraft control during maneuvering flight, allowing the airplane to stall without sufficient altitude for recovery.NTSB LAX90DVA08Accident · Minor injuriesFinal reportHiller UH-12-E · Los Banos, CAThe pilot's failure to maintain a lookout for obstructions along his swath run.NTSB LAX90DVM03Accident · 1 fatalFinal reportIlli Thunder Gull · Calif Valley, CAPoor judgement of the pilot from use of a drug (cocaine), and the pilot allowing the design stress limits of the aircraft to be exceeded, while maneuvering, which resulted in overload failure of the wing spar & wing separation.NTSB SEA90FA158Accident · Serious injuriesField investigationFinal reportAerospatiale SA315B · Cougar, WALoss of power due to contamination in the engine speed governor.NTSB FTW90FA151Accident · Minor injuriesField investigationFinal reportCessna 172M · Elmendorf, TXInadequate visual lookout by both pilots in the T-38 and by the instructor pilot (CFI) in the Cessna 172.NTSB CHI90DEV09Accident · 1 fatalFinal reportPietenpol AIR Camper · Minonk, ILThe pilot's inattention to visual lookout.NTSB ANC90LA135Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA-315B · Tok, AKImproper installation of the fuel filter element in the aircraft by company/maintenance personnel, and subsequent contamination of the fuel system by unfiltered fuel. Factors related to the accident were: inadequate design of the fuel filter assembly, which…NTSB FTW90FA152Accident · 2 fatalField investigationFinal reportCessna 150L · Leesville, LAThe pilot's failure to maintain vs while maneuvering and the fact that altitude was insufficient for recovery from the inadvertent stall.NTSB CHI90DER05Accident · Serious injuriesFinal reportPiper PA-25-235 · Ulen, MNThe pilot-in-command's failure to maintain control of the aircraft to avoid the inadvertent entry into a stall/spin at low altitude which resulted in impact with the terrain.NTSB CHI90FA214Accident · 2 fatalField investigationFinal reportCessna 150L · Donnybrook, NDThe pilot's failure to maintain airspeed while maneuvering in hilly terrain. Contributing factors were the pilot's failure to maintain adequate altitude and the surrounding steeply rising terrain.NTSB CHI90DTG03Accident · Minor injuriesFinal reportEagle DW-1 · Jamestown, NDPilot's failure to maintain clearance from the powerline during an aerial application manuever.NTSB LAX90DXQ03Accident · Minor injuriesFinal reportAir Tractor AT-401 · Tule Lake, CAAn engine failure due to mechanical failure of the distributor.NTSB ATL90DKG05Accident · No injuriesFinal reportAyres Bull Thrush · Americus, GAFailure of the engine main oil line which allowed the engine oil to be ignited by the hot engine.NTSB NYC90FA181Accident · 2 fatalField investigationFinal reportCessna 150L · Palmer Township, PAThe failure of the student pilot to maintain airspeed which resulted in a stall/spin with insufficient altitude for recovery. Factors which contributed to the accident were: the student pilot's poor judgement in buzzing a residential area, and his lack of…NTSB FTW90DRD15Accident · No injuriesFinal reportCessna 188 · Archibald, LAThe power loss for undetermined reasons. A factor was the rough uneven terrain in which the forced landing was performed.NTSB ANC90LA130Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Merrill Pass, AKThe pilot-in-command's failure to maintain flying speed.NTSB CHI90FA212Accident · 1 fatalField investigationFinal reportBoeing A75N1 · Oshkosh, WIThe pilot-in-command's failure to maintain airspeed sufficient to avoid a stall/spin at an altitude insufficient to effect a full recovery.NTSB CHI90DCJ01Accident · 1 fatalFinal reportCessna A188B · Amherst, NEThe pilot's failure to see and avoid power lines in his area of operation.NTSB ATL90FA153Accident · 2 fatalField investigationFinal reportPiper PA-18 · Southport, NCThe entry into a flat spin which precluded recovery by the pilot. The reason for the spin becoming flat could not be determined.NTSB NYC90DNA04Accident · No injuriesFinal reportBell 47G-3B-1 · Hanson, MAThe pilot's loss of control of the helicopter due to the failure of the tail rotor drive shaft.NTSB MIA90FA163Accident · 2 fatalField investigationFinal reportCessna 150J · Baker Hill, ALAn inadvertent stall/spin. Factors were airspeed not maintained, altitude inadequate for safe recovery, and attention diverted.NTSB FTW90LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roades, LAUnknown mechanical malfunction resulting in engine oil starvation. A contributing factor was rough terrain in which the forced landing was made.NTSB BFO90DOA01Accident · Minor injuriesFinal reportBell TH-1L · Galax, VAThe lost of engine power because of a compressor stall.NTSB FTW90LA149Accident · No injuriesLimited investigationFinal reportCessna 150M · Alvord, TXThe failure of the engine to develop full rated power for unknown reasons.NTSB CHI90DEM07Accident · 1 fatalFinal reportPitts SA-1 · East Jordan, MIThe pilot-in-command's failure to maintain altitude during low altitude aerobatics.NTSB FTW90DPG04Accident · No injuriesFinal reportAir Tractor 301A · Foreman, ARThe pilot's inadvertent stall/mush.NTSB NYC90LA177Accident · No injuriesLimited investigationFinal reportRobinson R22HP · Shirley, NYImproper use of the flight controls by the student pilot.NTSB NYC90FA179Accident · 2 fatalField investigationFinal reportGrumman AA-1B · Springfield, NJThe pilot's failure to maintain airspeed and the inadvertent stall of the airplane at an altitude from which recovery was not possible.NTSB ATL90FA150Accident · 1 fatalField investigationFinal reportPiper PA-18A · Conway, SCTowline interference with the rudder, and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spinn. A factor that contributed to the accident was: failure of the company/operator management to adequately guard against such…NTSB CHI90DET04Accident · Serious injuriesFinal reportContinental Copters MK 5A Tomcat · Constantine, MIThe pilot's failure to see and avoid power lines in his area of operation.NTSB ATL90DKJ07Accident · Serious injuriesFinal reportBell-Continental Copters 47G · Clayhatchee, ALFailure of the engine magneto(s). The lack of suitable terrain (trees) in the emergency landing area was a related factor.NTSB LAX90DVA07Accident · 1 fatalFinal reportAir Tractor AT-401 · San Joaquin, CAThe failure of the no. 4 cylinder head.NTSB CHI90FA197Accident · 2 fatalField investigationFinal reportCustom Aerotech White Lightning · Oshkosh, WIThe pilot-in-command's failure to maintain airspeed to avoid loss of control of the aircraft.NTSB LAX90DVG17Accident · Minor injuriesFinal reportCloutier Scorpion 133 · Oroville, CAThe pilot's loss of directional control.NTSB CHI90FA193Accident · 2 fatalField investigationFinal reportPiper PA-38 · Hinckley, ILThe instructor pilot's inability to recover from a stall/spin. Factors were: acft wt & balance exceeded, and the instructor's and student pilot's lack of familiarity with acft.NTSB FTW90DRA06Accident · Minor injuriesFinal reportHuffaher Benson · Hearne, TXThe pilot's failure to adequately compensate for the tail wind condiitons during a low pass which exceeded the performance capability of the aircraft. A factor was the tail wind conditions.