NTSB investigations, MN
370 cases where the phase of flight was Approach.
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 = 500)
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 = 500)
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 CEN09FA363Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Crystal, MNThe pilot's failure to maintain airspeed which resulted in a loss of aircraft control during a go-around. Factors associated with the accident were the dark night lighting conditions, moderate to heavy rain, and fatigue.NTSB CEN09LA238Accident · Serious injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Lakeville, MNThe instructor pilot’s failure to maintain directional control of the airplane, and the student pilot’s unintentional interference with the instructor’s rudder pedal during the go-around. Contributing to the accident was the cockpit design which allowed…NTSB CEN09CA053Accident · No injuriesData collectionFinal reportCessna 172F · Hutchinson, MNThe bird that the airplane struck while on final approach.NTSB CHI08CA285Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Lakeville, MNThe pilot's lack of clearance from the approach lights and the distraction of those bright approach lights during his night approach.NTSB CHI08FA039Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Faribault, MNThe pilot not maintaining adequate airspeed for the gusty crosswind conditions and the stall/spin encountered during the go-around. Contributing to the accident were the crosswinds and wind gusts.NTSB CHI07CA105Accident · No injuriesData collectionFinal reportPavliga Hatz CB-1 · Buffalo, MNThe loss of engine power due to the carburetor fuel flow valve becoming stuck in the closed position, which resulted in fuel starvation.NTSB CHI07LA002Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Marshall, MNThe failure of the nose gear to properly extend for undetermined reasons, which resulted in damage to the forward fuselage during landing.NTSB CHI06CA082Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Backus, MNThe airplane stalled as a result of the low airspeed and the instructor pilot's failure to take remedial action.NTSB CHI06LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Marshall, MNA loss of engine power in both engines while on approach due to fuel exhaustion and the pilot's inaccurate fuel consumption calculations leading to him refueling the outboard tanks only.NTSB CHI06LA012Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCBC · Williams, MNThe pilot's failure to maintain airspeed which resulted in the airplane stalling. Factors associated with the accident were the low level at which the airplane was maneuvering and the pilot's failure to perform weight and balance calculations prior to the…NTSB CHI05FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Glenwood, MNThe pilot's failure to execute a missed approach and his failure to maintain sufficient altitude and clearance from terrain and obstructions. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his decision to delay descent…NTSB CHI05CA005Accident · No injuriesData collectionFinal reportBuss Rotorway Exec · Eden Prairie, MNThe pilot's inadvertent deactivation of the battery switch leading to the helicopter's loss of engine power on base leg. A factor was the crops he encountered during the emergency landing.NTSB CHI04CA190Accident · No injuriesData collectionFinal reportSelby Dean KR-2-SS · Lake Elmo, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control. A related factor was the crosswind.NTSB CHI04FA177Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Rochester, MNThe loss of control due to the student pilot's failure to maintain rotor RPM and the flight instructor's inadequate supervision.NTSB CHI04FA133Accident · 4 fatalField investigationFinal reportCessna U206F · Owatonna, MNThe altitude/clearance not maintained by the pilot-in-command during a precision instrument approach. A contributing factor was the instrument meteorological conditions.NTSB CHI04LA046Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · St. Paul, MNThe failure of the worm drive bearing that resulted in the failure of the landing gear extension/retraction gearbox, which ultimately resulted in the extension of the landing gear not being possible. A factor to the accident was the airport sign that the…NTSB CHI04LA033Accident · No injuriesLimited investigationFinal reportSaab-Scania Saab 340B · Minneapolis, MNThe in-flight collision with geese during approach. The contributing factor was the bright night conditionsNTSB CHI03FA296Accident · 2 fatalField investigationFinal reportBeech 58P · Grand Marais, MNThe continued descent below minimum descent altitude and the altitude/clearance not maintained by the pilot during approach to the airport. The low ceiling was a contributing factor.NTSB CHI03LA087Accident · No injuriesLimited investigationFinal reportAero Commander 500-B · Mankato, MNFuel exhaustion due to the pilot's inadequate preflight and not verifying the airplane had been refueled.NTSB CHI03LA046Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Ada, MNThe pilot's failure to maintain the minimum descent altitude and his failure to maintain obstacle clearance. A low ceiling was a factor.NTSB DCA03MA008Accident · 8 fatalClass 1 · MajorFinal reportBeech King Air 100 · Eveleth, MNThe flight crew's failure to maintain adequate airspeed, which led to an aerodynamic stall from which they did not recover.NTSB CHI03LA008Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Lake Elmo, MNThe pilot's failure to maintain aircraft control. Factors to the accident included the gusting wind conditions and the encountered windshear, which resulted in the inadvertent stall at a low altitude and subsequent in-flight collision with the transmission…NTSB CHI03LA007Accident · No injuriesLimited investigationFinal reportMadewell EAA-Biplane-P · Forest Lake, MNThe loss of engine power for undetermined reasons. A related factor was the swampy terrain.NTSB CHI03LA005Accident · No injuriesLimited investigationFinal reportCessna 172L · Fish Lake, MNThe altitude/clearance not maintained while maneuvering on short final for landing on the lake. The glassy water was a contributing factor.NTSB CHI03LA034Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Owatonna, MNThe remedial action not performed by the certified flight instructor (CFI) during the bounced landing and directional control not maintained during the go-around by CFI. Contributing factors were the CFIs preflight planning/preparation in placing the dual…NTSB CHI02LA299Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Moorhead, MNThe inadequate fuel management by the certified flight instructor.NTSB CHI02LA271Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooklyn Park, MNThe pilot's inadequate preflight preparation/planning, which resulted in fuel exhaustion and the loss of engine power. A factor to the accident was the power transmission line and the trees.NTSB CHI02LA209Accident · No injuriesLimited investigationFinal reportBeech S35 · Minneapolis, MNThe proper glide path not obtained/maintained by the pilot. The approach lights were a contributing factor.NTSB CHI02LA135Accident · No injuriesLimited investigationFinal reportMooney M20F · Minneapolis, MNThe pilot did not attain a proper climb rate during the go-around and the intentional wheels up landing. Factors associated with the accident were the inability of the pilot to maintain directional control of the airplane during the landing and the parked…NTSB CHI02LA044Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · St Paul, MNThe autopilot's computer connections arcing and reported disconnection during the localizer approach and the pilot not performing a go around prior to the hard landing. A factor was the pilots lack of total experience in the accident airplane's make and model.NTSB CHI02LA027Accident · Serious injuriesLimited investigationFinal reportBeech V35 · Mounds View, MNFuel starvation caused by the pilot's improper positioning of the fuel tank fuel selector while in the traffic pattern, and the unsuitable terrain encountered during the forced landing. Factors relating to the accident were the pilot not complying with the…NTSB CHI01LA179Accident · Serious injuriesLimited investigationFinal reportCessna T310P · St. Cloud, MNthe fuel starvation. Fuel management by the pilot was an additional cause. The muddy terrain was a contributing factor.NTSB CHI01LA127Accident · No injuriesLimited investigationFinal reportCessna 172M · Eveleth, MNThe pilot's inadequate compensation for the crosswind conditions which resulted in the loss of aircraft control. Factors associated with the accident were the gusty crosswind condition, the pilot's lack of experience, and the trees which were contacted.NTSB CHI01LA109Accident · Serious injuriesLimited investigationFinal reportCessna 414 · Minneapolis, MNThe pilot not maintaining the proper airspeed during the circling approach, the inadvertent stall and the subsequent loss of control. Factors were the pilot's decision to continue the approach in weather conditions below the approach/landing minimums, the…NTSB CHI01LA027Accident · Minor injuriesLimited investigationFinal reportForney F1A · Austin, MNthe proper glide path not being maintained by the pilot which resulted in the proper touchdown point not being obtained during the approach. A factor to the accident was the rising embankment.NTSB CHI00FA170Accident · 1 fatalField investigationFinal reportAeronca 7AC · Lakeville, MNthe pilot not maintaining aircraft control and the stall/spin she encountered during the approach on base to final. A factor was the pilot passenger not detecting the remedial action needed to correct the aircraft's nose up attitude during the approach.NTSB CHI00LA142Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sandstone, MNthe pilot not attaining an airspeed necessary for the go-around and not maintaining clearance from terrain. Factors were the crosswind, gust, and the collapsed nose gear.NTSB CHI00FA080Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Moorhead, MNthe pilot's failure to maintain aircraft control during the missed approach. Factors to the accident were, the pilot's improper decision to attempt the approach in weather conditions below the approach/landing minimums, the weather, the pilot's lack of…NTSB CHI00LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Mankato, MNthe pilots failure to maintain a proper glidepath. Factors were the dark night and the pilots lack of recent night flying experience.NTSB CHI99LA331Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Forest Lake, MNthe pilot's misjudging the proper glidepath, and his not maintaining airspeed. Factors were the pilot's lack of recent experience, the airplane's inadvertent stall, and the fence.NTSB CHI99LA037Accident · Serious injuriesLimited investigationFinal reportBeech BE-55 · Crystal, MNthe pilot failed to maintain the proper glidepath. A factor was the sunglare.NTSB CHI99LA008Accident · Minor injuriesLimited investigationFinal reportBeech 65-B80 · Brainerd, MNthe pilot's failure to maintain the proper glidepath and his diversion of attention during a critical phase of flight.NTSB CHI98LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Emily, MNThe pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).NTSB CHI98LA092Accident · Minor injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe pilot's improper raising of flaps and not maintaining directional control of the aircraft during the go-around sequence.NTSB CHI98LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lakeville, MNgeese that were encounter on an ILS final approach. Darkness was a related factor.NTSB CHI97LA307Accident · No injuriesLimited investigationFinal reportCessna 182 · Dassel, MNthe pilot's failure to attain the proper touchdown point on the airstrip. Factors associated with the accident were the high vegetation which skewed the pilot's visual perception of threshold, and the embankment which the airplane contacted.NTSB CHI97LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glenwood, MNfailure of the student pilot to maintain the correct airspeed for a go-around maneuver, which resulted in a stall/mush and collision with terrain.NTSB CHI97LA115Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Duluth, MNthe loss of engine power for undetermined reasons and the pilot's failure to maintain aircraft control.NTSB CHI97FA058Accident · 2 fatalField investigationFinal reportMooney M20J · Cottage Grove, MNfailure of the pilot to maintain control of the airplane during an ILS approach. Factors relating to the accident were: the IFR weather conditions, the pilot's lack of recent instrument experience, and the pilot's lack of familiarity in flying the accident…NTSB CHI96LA256Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Backus, MNthe pilot's failure to maintain adequate altitude and his abrupt maneuver to avoid the tree tops. The dark night was a factor.