NTSB investigations, MN
298 cases where the phase of flight was Takeoff.
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 = 300)
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 = 300)
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 CEN09LA579Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Park Rapids, MNThe pilot's failure to maintain a proper climb rate during a night takeoff.NTSB CEN09CA422Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Hibbing, MNThe pilot mistakenly using a closed taxiway for takeoff, which resulted in the airplane striking a construction barricade.NTSB CEN09CA210Accident · No injuriesData collectionFinal reportAeronca 7AC · Bagley, MNThe pilot's delayed aborted takeoff, which resulted in the ski-equipped airplane running aground and striking trees. Contributing to the accident was the slush layer that had formed since the previous landing.NTSB CEN09CA049Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Blaine, MNThe deer impacting the airplane during takeoff roll.NTSB CHI08CA254Accident · No injuriesData collectionFinal reportBell 47G-3B · Kenyon, MNThe pilot's inadequate preflight planning which resulted in the helicopter settling with power.NTSB CHI08CA249Accident · No injuriesData collectionFinal reportMorane-Saulnier MS-760/B · St Paul, MNRestriction of the elevator controls due to the presence of the seat belt buckled around the co-pilot control stick. An additional cause was the failure of the pilot to verify that the flight controls were unobstructed before flight. Contributing factors were…NTSB CHI08CA086Accident · No injuriesData collectionFinal reportRans S-4 Coyote I · Lakeville, MNThe pilot's failure to maintain directional control and his inadequate compensation for the crosswind conditions. Factors included the pilot's lack of experience in the make and model of the airplane and the crosswind gust.NTSB CHI07CA306Accident · No injuriesData collectionFinal reportPiper PA-12 · Detroit Lakes, MNThe reduced airplane climb performance capability resulting in the pilot not obtaining a proper climb rate during takeoff and the inadequate flare by the pilot during the aborted takeoff. Additional causes were the inadequate preflight planning/preparation by…NTSB CHI07CA239Accident · No injuriesData collectionFinal reportCessna 150H · Cook, MNThe pilot not maintaining airspeed leading to the stall/mush encountered during takeoff and the unsuitable terrain the pilot selected during the forced landing. Factors were the vehicle encountered during the forced landing and the ditch the pilot steered the…NTSB CHI06CA197Accident · No injuriesData collectionFinal reportCessna 206H · Lutsen, MNThe unsuitable terrain the pilot encountered during takeoff in rough water. A factor was the wave in the rough water.NTSB CHI06LA147Accident · Minor injuriesLimited investigationFinal reportAllied Ag Cat Productions G-164A · Gonvick, MNThe aborted takeoff not performed by the pilot. A contributing factor is the reported loss of takeoff performance.NTSB CHI06CA066Accident · No injuriesData collectionFinal reportCessna 120 · Hibbing, MNThe pilot used a rough frozen lake for takeoff which resulted in the overload failure of the landing ski. A factor was the rough frozen lake.NTSB CHI06LA027Accident · No injuriesLimited investigationFinal reportAgusta A109-E · Robbinsdale, MNThe loss of lift for undetermined reasons.NTSB CHI06CA019Accident · No injuriesData collectionFinal reportPiper PA-12 · Brainerd, MNThe pilot's inadvertent brake application during the takeoff roll, which resulted in a loss of directional control and subsequent ground loop.NTSB CHI05CA195Accident · No injuriesData collectionFinal reportCessna 180 · Bowstring, MNThe unsuitable water conditions for takeoff selected by the pilot and his inability to maintain aircraft control in the rough water. Contributing factors were the aborted takeoff initiated by the pilot, the rough water conditions and the high, gusty winds.NTSB CHI05FA162Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Grand Rapids, MNAn observed loss of engine power due to the bound/jammed turbocharger wastegate during takeoff, the pilot not maintaining airplane control, and the stall he inadvertently encountered. A factor was the maintenance personnel not replacing the turbocharger…NTSB CHI04CA291Accident · No injuriesData collectionFinal reportJohnson Titan Tornado I · Carlton, MNThe pilot's failure to abort the takeoff. Factors to the accident included the diminished takeoff performance due to the incorrect propeller pitch setting and the tree that the airplane impacted.NTSB CHI04CA237Accident · Serious injuriesData collectionFinal reportEnstrom F-28A · Leroy, MNThe partial loss of engine power due to the missing 1/8-27 NPT Allen plug as a result of other maintenance personnel undertorquing the plug. Additionally, the pilot improperly excecuted a run on landing. A factor was the loss of tail rotor effectiveness.NTSB CHI04LA060Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Minneapolis, MNA loss of engine power for undetermined reasons.NTSB CHI03LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Waskish, MNThe inadequate preflight planning/preparation by the pilot. Contributing factors were the snow covered takeoff area and the tailwind.NTSB CHI03LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeville, MNThe pilot's inadequate removal of ice and snow during the airplane preflight, and the subsequent loss of control due to the airplane being covered with ice.NTSB CHI03LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Paul, MNThe student pilot failed to maintain directional control. A factor was the runway sign.NTSB CHI02LA276Accident · No injuriesLimited investigationFinal reportCessna T188C · Olivia, MNThe fouled spark plugs and the terrain condition encountered during the aborted takeoff.NTSB CHI02IA270Incident · No injuriesIncident investigationFinal reportFokker 100 · Minneapolis, MNThe improper installation of the #2 main landing gear wheel, including the axle nut not being properly torqued and safetied, which resulted in the wheel separation during takeoff.NTSB CHI02LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Warroad, MNThe loss of engine power due to the failure of the muffler baffles which blocked the exhaust system. A factor to the accident was the treeline.NTSB CHI02LA235Accident · Minor injuriesLimited investigationFinal reportCessna 185B · Brainerd, MNThe pilot's evasive maneuver to avoid obstacle clearance, resulting in a premature lift off with inadequate airspeed followed by a stall. The presence of the boat was a factor.NTSB CHI02LA221Accident · Minor injuriesLimited investigationFinal reportAir Tractor 301 · Ulen, MNThe pilot not performing an aborted takeoff. A factor was the soybean crop.NTSB CHI02LA208Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Askov, MNDirectional control not obtained/maintained during the aborted takeoff.NTSB CHI02LA156Accident · No injuriesLimited investigationFinal reportHale Kitfox Model III · Fairmont, MNFailure by the pilot to obtain adequate clearance from the tree line, as well as a failure to abort the takeoff in a timely manner. A contributing factor was the tree line.NTSB CHI02LA141Accident · No injuriesLimited investigationFinal reportCessna A185E · Grand Marais, MNThe pilot displayed inadequate compensation for the wind conditions that existed at the time of the accident and directional control was not maintained. A factor associated with the accident was the crosswind weather condition.NTSB CHI02LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clear Lake, MNThe loss of engine power for undetermined reasons and the unsuitable terrain for the forced landing. Factors were the low altitude and the fences.NTSB CHI02LA062Accident · 1 fatalLimited investigationFinal reportWolter Avid Flyer · Rush City, MNThe unqualified pilot inadvertently stalled the airplane. A factor was the unqualified pilot's lack of total experience.NTSB CHI02LA030Accident · Minor injuriesLimited investigationFinal reportAero Commander 100 · Hillman, MNThe inadvertent stall by the pilot. Factors were the tailwind, and the improper decision of the pilot to takeoff with a tailwind.NTSB CHI01LA323Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Clear Lake, MNThe pilot not maintaining directional control of the airplane during the takeoff. A factor was the soybean crop.NTSB CHI01LA311Accident · No injuriesLimited investigationFinal reportCessna 150M · South St. Paul, MNThe student pilot failed to maintain directional control. A factor was his lack of total flight experience.NTSB CHI01LA229Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dodge Center, MNThe pilot not maintaining directional control on the ground during the takeoff roll. Factors relating to this accident were the total failure of the propeller governor and the corn crop.NTSB CHI01LA215Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Walker, MNthe loss of engine power for undetermined reasons during takeoff. Factors were the vehicles, the unsuitable terrain the pilot encountered, and the low altitude of the helicopter at the time of the loss of engine power.NTSB CHI01LA156Accident · No injuriesLimited investigationFinal reportCessna R182 · White Bear Lake, MNthe takeoff checklist not followed and the inadequete soft field takeoff proecedure by the pilot. The short/soft field was a factor.NTSB CHI00LA291Accident · Serious injuriesLimited investigationFinal reportBeech A36TC · Moorehead, MNThe pilots failure to abort the takeoff and the airplane not attaining a proper climb rate for undetermined reasons.NTSB CHI00LA230Accident · No injuriesLimited investigationFinal reportBell BH-222-U · St. Paul, MNthe pilot's inadequate preflight and improper vertical takeoff and not obtaining clearance from helicopter pad light. Factors included the tailwind takeoff and the helipad light.NTSB CHI00LA220Accident · Serious injuriesLimited investigationFinal reportFloroski Anderson Kingfisher · Deerwood, MNthe open carburetor heat air box resulting in a loss of engine power, the diminished climb rate and the altitude/clearance not possible by the pilot. Factors were the trees and the bent carburetor heat push-pull rod.NTSB CHI00FA214Accident · 1 fatalField investigationFinal reportPiper PA-23 · Dodge Center, MNThe pilot not maintaining airplane control in his turn back in the direction of the airport and the pilot not performing an emergency landing straight ahead. Factors were the water and debris contamination found in the fuel screens and carburetor bowl and the…NTSB CHI00LA198Accident · No injuriesLimited investigationFinal reportCessna T188C · Rock Dell, MNthe failure of the pilot to maintain clearance with the terrain.NTSB CHI00LA105Accident · Minor injuriesLimited investigationFinal reportWeinzierl Titan Tornado II · Maple Plain, MNthe obstructed fuel system filter, the inadequate silicone material the builder used, and the rough and uneven terrain. A factor was that suitable landing terrain was not available.NTSB CHI99LA243Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Marshall, MNthe inadvertent stall and the checklist not followed by the pilot. Contributing factors were the baggage door not secured and the precautionary landing attempt by the pilot.NTSB CHI99LA224Accident · No injuriesLimited investigationFinal reportCessna 172N · Faribault, MNthe pilot's failure to maintain directional control of the airplane during the takeoff ground run.NTSB CHI99LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · South St. Paul, MNthe student pilot's failure to maintain directional control of the airplane during takeoff. Factors associated with the accident were the student's lack of experience and the snowbank.NTSB CHI98FA187Accident · 1 fatalField investigationFinal reportCessna 421 · Little Falls, MNthe pilot's continued operation with a known deficiency in equipment.NTSB CHI97LA176Accident · No injuriesLimited investigationFinal reportMaule M5C · Lino Lakes, MNthe flight instructor's inadequate preflight planning/preparation, his the improper lowering of flaps for takeoff, his failure to use a longer available area for takeoff, and his failure to abort the takeoff before there was an insufficient amount of area…NTSB CHI96LA168Accident · No injuriesLimited investigationFinal reportCessna 188 · Roseau, MNthe pilot failed to maintain directional control during takeoff. The crosswind was a factor.