NTSB investigations, MN
371 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.\"eventStateOrRegion\" = 'MN' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'MN' AND c."eventCountry" = 'USA'
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 CEN11CA525Accident · No injuriesData collectionFinal reportBell 47G-2A · Nicolett, MNThe pilot's failure to maintain control of the helicopter while maneuvering during an aerial application flight.NTSB CEN11LA370Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Lakeville, MNThe loss of engine power due to a loose B-nut on the compressor discharge pressure bleed line.NTSB CEN11LA332Accident · Serious injuriesLimited investigationFinal reportUnregistered Quicksilver MXL II · Crookston, MNThe pilot’s improper airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin at a low altitude.NTSB CEN11CA017Accident · Serious injuriesData collectionFinal reportLuscombe 8D · Clarrisa, MNThe partial loss of engine power for undetermined reasons.NTSB CEN10LA491Accident · 2 fatalLimited investigationFinal reportSchneider Christen Eagle II · Clearwater, MNThe pilot's failure to maintain aircraft control and his improper decision to perform aerobatic maneuvers without proper experience or training in aerobatic flight. Also causal was his conduct of aerobatic flight in an airplane loaded outside its weight and…NTSB CEN10LA431Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Rochester, MNThe total loss of engine power due to a high-cycle fatigue fracture of a first-stage compressor blade. The reason for the fracture could not be determined during postaccident examination.NTSB CEN09CA560Accident · No injuriesData collectionFinal reportPiper PA-12 · Gonvick, MNA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.NTSB CEN09CA540Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot's failure to maintain clearance with the crops while maneuvering at low altitude.NTSB CEN09LA526Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Worthington, MNA fatigue failure of the elevator push-pull rod which resulted in the pilot's inability to control the aircraft's pitch attitude while landing.NTSB CEN09FA518Accident · 2 fatalField investigationFinal reportBeech E18S · Eden Prairie, MNThe pilot’s lack of experience flying the accident make and model of airplane, which led to a loss of control while maneuvering to return to the airport. Contributing to the accident was a partial loss of engine power for undetermined reasons.NTSB CHI08CA266Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Jasper, MNThe pilot's failure to assure the primer control was locked during the aircraft preflight. Factors associated with the accident were the low altitude at which the airplane was operating, the fence, the roadway, and the ditch.NTSB CHI08CA257Accident · No injuriesData collectionFinal reportAir Tractor AT-400A · Luverne, MNThe failure of the compressor turbine blades which resulted in the loss of power. Factors associated with the accident were the low altitude and the trees.NTSB CHI08CA252Accident · No injuriesData collectionFinal reportHiller UH-12E · Cokato, MNThe pilot did not visually identify and maintain clearance with the power lines, and the pilot's inability to maintain control of the helicopter once it contacted the power lines. Factors associated with the accident were the low altitude operations being…NTSB CHI08CA243Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Cosmos, MNThe pilot's failure to maintain clearance from the guide wire while maneuvering on an aerial application flight. Contributing to the accident was the presence of the guide wire.NTSB CHI08CA176Accident · No injuriesData collectionFinal reportAero Commander S2R · Clontarf, MNThe pilot's failure to maintain clearance from the power transmission lines. Contributing to the accident was the power transmission lines.NTSB CHI08LA080Accident · 1 fatalLimited investigationFinal reportCessna 140 · Grand Meadow, MNThe pilot's continued visual flight into an area of known instrument meteorological conditions in an airplane not equipped for instrument flight, and his failure to maintain control of the airplane while maneuvering at low altitude.NTSB CHI08LA067Accident · Serious injuriesLimited investigationFinal reportZiermann RV8 · Garrison, MNThe loss of engine power for undetermined reasons during cruise and the misjudged flare resulting in a hard landing. Contributing to the accident was the frozen lake to which the pilot performed a forced landing.NTSB CHI07LA277Accident · Minor injuriesLimited investigationFinal reportBell 47G-5A · Anoka, MNThe loss of helicopter pitch control for undetermined reasons during the aerial application maneuver and the pilot's inability to control the aircraft during the descent.. A contributing factor to the accident was the soft terrain.NTSB CHI07LA272Accident · 1 fatalLimited investigationFinal reportClifford Titan Tornado II · Henning, MNThe inadvertent stall and low airspeed while maneuvering. A contributing factor was the low altitude of the maneuver.NTSB CHI07LA193Accident · No injuriesLimited investigationFinal reportHughes 369D · Comfrey, MNThe loss of engine power due to the loose pressure line during aerial application maneuvers which resulted in a hard forced landing.NTSB CHI07FA032Accident · 2 fatalField investigationFinal reportCessna 172 · Crookston, MNThe pilot's inadvertent flight into instrument meteorological conditions which led to his spatial disorientation and subsequent loss of control. Factors were the snow, the low ceiling, and the pilot's lack of instrument flight experience.NTSB CHI06CA233Accident · No injuriesData collectionFinal reportHoyt Kolb Mark III Clsc · Lakeville, MNThe pilot's failure to maintain clearance from the crops which resulted in the subsequent impact with the ground.NTSB CHI06CA222Accident · Minor injuriesData collectionFinal reportRockwell S2R · Park Rapids, MNA loss of engine power for undetermined reasons and the inadequate airspeed during the forced landing which resulted in a stall/mush. A factor was the low altitude at which the airplane was being operated.NTSB CHI05LA234Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Georgetown, MNThe reported loss of engine power for undetermined reasons while maneuvering and the low altitude of the operation. Related factors were the unsuitable terrain encountered by the pilot, and trees.NTSB CHI05LA148Accident · 1 fatalLimited investigationFinal reportReay Titan Tornado II · Winsted, MNThe pilot performed an unauthorized aerobatic loop and failed to maintain control of the airplane.NTSB CHI05CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Minneapolis, MNThe pilot's inadequate compensation for the wind conditions and his failure to maintain control of the helicopter while maneuvering to center the helicopter on a cart. A factor associated with the accident was the wind gusts.NTSB CHI04CA110Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Shakopee, MNThe dual student's failure to maintain control of the helicopter during hovering flight and the flight instructor's delayed remedial action in order to prevent a loss of control. Contributing factors were the flight instructor's lack of dual instruction…NTSB CHI04LA017Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Evansville, MNThe pilot's misjudgment of clearance from the surface of the lake during the aerial application pass. The low altitude operation, glassy water, and his visual perception were contributing factors.NTSB CHI04LA007Accident · 1 fatalLimited investigationFinal reportAviat Pitts S-2B · Cromwell, MNThe altitude/clearance not maintained by the pilot while performing aerobatic maneuvers. Contributing factors were the planning/decision to perform an aerobatic maneuver at a low altitude.NTSB CHI03LA232Accident · No injuriesLimited investigationFinal reportAmerican Champion 8KCAB · Stephen, MNThe pilot's failure to maintain clearance from the transmission line and the pilot's continued operation with known deficiencies in equipment. Factors to the accident were the power lines and the low altitude the pilot was flying at.NTSB CHI03LA214Accident · No injuriesLimited investigationFinal reportAyres S2R-G10 · Staples, MNThe fatigue fracture of the oil jet flange resulting in a total engine failure during the aerial application.NTSB CHI03LA210Accident · Serious injuriesLimited investigationFinal reportBell 47G-5 · Cleveland, MNThe pilot's inadequate visual lookout and low altitude flight when he failed to maintain altitude/clearance from the transmission wire. A factor contributing to the accident was the transmission wire.NTSB CHI03LA172Accident · Minor injuriesLimited investigationFinal reportBell 206B · Baxter, MNThe pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. Factors contributing to this accident were the helicopter's low airspeed, low altitude, the crosswind, and the trees.NTSB CHI03LA117Accident · 1 fatalLimited investigationFinal reportSmith Rans S-7 · Baudette, MNThe pilot's failure to maintain adequate airspeed which resulted in a stall. A contributing factor was the low altitude maneuver by the student pilot.NTSB CHI03LA106Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Benson, MNThe loss of engine power for undetermined reasons.NTSB CHI03LA104Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Lino Lakes, MNThe pilot not maintaining aircraft control while manuevering.NTSB CHI03LA089Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Raymond, MNThe altitude/clearance not maintained by the pilot and his ostentatious display. The power lines and the pilot's maneuvering at low altitude were contributing factors.NTSB CHI03FA057Accident · 2 fatalField investigationFinal reportCirrus Design SR-22 · Hill City, MNSpatial disorientation experienced by the pilot, due to a lack of visual references, and a failure to maintain altitude. Contributing factors were the pilot's improper decision to attempt flight into marginal VFR conditions, his inadvertent flight into…NTSB CHI03LA036Accident · 2 fatalLimited investigationFinal reportNorth American T-28B · Glenwood, MNThe altitude/clearance not maintained by the pilot-in-command. The low altitude maneuvering by the pilot-in-command was a contributing factor.NTSB CHI02LA163Accident · Minor injuriesLimited investigationFinal reportBell 47G-2A-1 · Jordan, MNThe loss of engine power due to improper maintenance by unknown maintenance personnel which led to a misalignment of the gearbox casing.NTSB CHI02LA037Accident · 1 fatalLimited investigationFinal reportVermeys T-Bird II · Sherburn, MNThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin.NTSB CHI02LA024Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Erhard, MNThe pilot not maintaining adequate airspeed while maneuvering in the turn. Factors relating to this accident were the low airspeed, the inadvertent stall, and the low altitude.NTSB CHI01LA327Accident · Minor injuriesLimited investigationFinal reportBell 206B-III · Park Rapids, MNThe pilot not maintaining altitude/clearance when he maneuvered above the glassy lake. A factor to the accident was the glassy lake condition.NTSB CHI01LA198Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Stillwater, MNThe loss of engine power for undermined reasons and the unsuitable terrain encountered during the forced landing. Additional factors included the power line and the trees.NTSB CHI01LA143Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Detroit Lakes, MNAltitude/clearance not maintained from the transmission wires during a low altitude flight/maneuver performed by the pilot. A factor to the accident was the transmission wires.NTSB CHI00LA075Accident · Minor injuriesLimited investigationFinal reportKretsinger Bensen B8M · Wayzata, MNthe pilot's poor inflight planning in that he turned into a tailwind which resulted in diminished airspeed. Factors associated with the accident were the tailwind, low altitude maneuvering, the snow covered terrain, and the pilot's inability to successfully…NTSB CHI99LA317Accident · No injuriesLimited investigationFinal reportAyres S-2R · Brooten, MNthe compressor impeller failure and the unsuitable terrain for landing encountered by the pilot.NTSB CHI99FA223Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Fertile, MNthe inadvertent stall. Factors relating to this accident were the instructor pilot maneuvering the airplane at very low altitude and the trees.NTSB CHI99LA216Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Fisher, MNthe pilot's failure to maintain clearance from the crop during an aerial application spray run.NTSB CHI99FA213Accident · 1 fatalField investigationFinal reportLarson Smith Miniplane DSA-1 · Blackduck, MNAircraft control not being maintained by the pilot. Factors to the accident were the aerobatic maneuvers being flown by the pilot and the encountered spiral.