NTSB investigations
20,992 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.\"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."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 CEN17FA258Accident · 2 fatalField investigationFinal reportPiper PA 28-181 · Waterford, OHThe pilot's loss of airplane control due to spatial disorientation in instrument meteorological conditions.NTSB CEN17LA261Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Wauseon, OHThe flight instructor’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA17LA229Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · Dillwyn, VAThe pilot's selection of a grass airstrip that was of insufficient length for landing, and his exceedance of the airplane's critical angle of attack during the go-around, which resulted in an aerodynamic stall.NTSB ERA17FA226Accident · 1 fatalField investigationFinal reportLuscombe 8 · Remsen, NYThe pilot's failure to maintain the proper airspeed and his exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall at an altitude too low for him to recover.NTSB GAA17CA421Accident · No injuriesData collectionFinal reportAviat A 1 · Dixie, IDThe pilot's failure to maintain an appropriate glidepath to landing with sun glare and downdraft conditions, which resulted in the airplane landing in a ravine short of the runway.NTSB GAA17CA379Accident · No injuriesData collectionFinal reportAmerican General Acft AG5 · Rio Vista, CAThe student pilot’s failure to maintain directional control during a go-around in gusting wind conditions.NTSB CEN17LA250Accident · 1 fatalLimited investigationFinal reportNorth American T-28A · Moorhead, MNControlled descent into terrain due to engine issues, the reason for which could not be determined because examination of the engine revealed no evidence of malfunctions or failures that would have precluded normal operation.NTSB CEN17LA247Accident · No injuriesLimited investigationFinal reportCessna P210N · Eagle, COThe loss of engine power due to fuel starvation for reasons that could not be determined because an examination of the airplane and engine did not reveal any malfunctions or failures that would have precluded normal operation.NTSB CEN17LA242Accident · No injuriesLimited investigationFinal reportBellanca 17 30 · Grove, OKAn unporting of fuel in the right wing while maneuvering in the airport traffic pattern, which resulted in a partial loss of engine power due to fuel starvation.NTSB ERA17LA212Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Panama City, FLThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to use the emergency checklist to restart the engine.NTSB CEN17FA231Accident · Serious injuriesField investigationFinal reportGefa-Flug AS-105-GD · Hartford, WIThe overpressurization failure of the airship envelope as a result of the airship's encounter with gusty wind conditions and thermal activity. Contributing to the accident was the jammed Plexiglass venting panel.NTSB ERA17LA205Accident · Minor injuriesLimited investigationFinal reportCessna P206 · West Creek, NJThe pilot's improper fuel management, which resulted in fuel starvation and the subsequent total loss of engine power.NTSB ANC17WA031Accident · Serious injuriesForeign investigationBell 214 · Dongducheon, South KoreaOn June 13, 2017, about 1810 local time, a Republic of Korea registered Bell 214B helicopter, HL9157, operated by UB Air, impacted remote mountainous terrain about 3 miles northeast of Dongducheon, Republic of Korea, during the approach to a drop zone while…NTSB GAA17CA337Accident · No injuriesData collectionFinal reportCessna 172 · Ravenna, OHThe flight instructor's failure to perform a go-around during final approach, which resulted in an aerodynamic stall and a hard landing. Contributing to the accident was the flight instructor's failure to brief the student pilot on the positive transfer of…NTSB ERA17LA201Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Gordonville, FLThe pilot's failure to properly configure the mixture control for landing due to disorientation because he had the airport diagram upside down, which resulted in a total loss of engine power.NTSB GAA17CA327Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe student pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB GAA17CA318Accident · Minor injuriesData collectionFinal reportCessna 172 · Payson, AZThe pilot’s inadequate preflight planning that did not account for high-density altitude conditions and his subsequent attempted go-around in conditions that prevented the airplane from attaining a positive climb rate and resulted in its subsequent descent…NTSB WPR17LA122Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Rexberg, IDA loss of engine power for reasons that could not be determined based on the available information which resulted in a landing short of the runway.NTSB GAA17CA317Accident · No injuriesData collectionFinal reportCessna 177 · Guttenberg, IAThe pilot’s failure to maintain an adequate approach path, which resulted in the left wing impacting a street sign.NTSB CEN17WA211Accident · 2 fatalForeign investigationLake LA-4-200 · Muskoka, Ontario, CanadaOn June 2, 2017, at 2113 coordinated universal time, a Lake LA-4-200 Buccaneer, C-GZSW, was destroyed on impact with terrain after takeoff from Muskoka Airport (CYQA), Muskoka, Ontario, Canada. After takeoff, the pilot attempted to return to the airport, and…NTSB CEN17WA240Incident · No injuriesForeign investigationReims F150 M · Charleroi, BelgiumOn May 30, 2017, about 1730 hours universal coordinated time, a Reims Aviation F150M, Belgium registration OO-PRG, sustained minor damage during a forced landing at Brussels South - Charleroi Airport (EBCI), Charleroi, Belgium. The flight instructor and…NTSB WPR17LA112Accident · Minor injuriesLimited investigationFinal reportCessna 175 · El Monte, CAThe flight instructor's delayed remedial action, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall and loss of control. Contributing to the accident was the student pilot's failure to maintain runway alignment…NTSB GAA17CA322Accident · No injuriesData collectionFinal reportPiper PA28 · Gilbert, SCThe pilot's improper glidepath in variable wind conditions, which resulted in the airplane impacting terrain short of the runway threshold.NTSB WPR17LA110Accident · Minor injuriesLimited investigationFinal reportJohnson Glastar · Concord, CAA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN17LA205Accident · No injuriesLimited investigationFinal reportAmstutz Curtis J BD-5B · Portland, INA failure of the wiring between the engine control unit and the fuel injector, which resulted in a total loss of engine power.NTSB ERA17FA190Accident · 1 fatalField investigationFinal reportEurocopter Deutschland EC 135 · New Castle, DEThe pilot's loss of helicopter control during a missed approach in instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.NTSB ERA17CA186Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Bristow, VAThe flight instructor’s and pilot’s mismanagement of the available fuel, which resulted in exhaustion of the fuel in the selected fuel tank and a subsequent total loss of engine power.NTSB CEN17LA192Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R66 · Canon City, COThe pilot’s loss of helicopter control on approach to land due to a vortex ring state (settling with power) condition, which resulted in a hard landing.NTSB CEN17MA183Accident · 2 fatalClass 1 · MajorFinal reportLearjet 35A · Teterboro, NJThe pilot-in-command's (PIC) attempt to salvage an unstabilized visual approach, which resulted in an aerodynamic stall at low altitude. Contributing to the accident was the PIC's decision to allow an unapproved second-in-command to act as pilot flying, the…NTSB CEN17WA189Accident · 1 fatalForeign investigationMonocoupe 90AF · Plattsville, CanadaOn May 13, 2017, a Monocoupe 90F-100 airplane, C-FJGA, impacted short of the threshold at Lubitz Flying Field (CLB2), Plattsville, Ontario. The pilot was fatally injured.This investigation is under the jurisdiction and control of the government of Canada. Any…NTSB CEN17LA185Accident · No injuriesLimited investigationFinal reportMooney M20TN · Grandby, COThe total loss of engine power for reasons that could not be determined based on the available information.NTSB OPS17IA021IncidentClass 3 · IncidentFinal reportCessna 172S · New Orleans, LAThe air traffic controller not following Federal Aviation Administration directives to establish sequencing and spacing between aircraft operating to the same runway.NTSB GAA17CA282Accident · No injuriesData collectionFinal reportPiper PA23 · Fremont, OHThe pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.NTSB ERA17FA174Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Clearwater, FLThe pilot's decision to attempt to land while a line of rain showers with microburst activity was crossing the airport, which resulted in a loss of control during a subsequent attempted go-around.NTSB WPR17LA126Accident · 1 fatalLimited investigationFinal reportHy-Tek Hurricane · Redcrest, CAThe noncertificated pilot's impairment from methamphetamine and alcohol use, which precluded the pilot from maintaining control of the airplane after a loss of engine power for reasons that could not be determined based on available information.NTSB GAA17CA255Accident · No injuriesData collectionFinal reportSchweizer SGS134 · Blairstown, NJThe pilot’s failure to attain a proper glidepath on approach for landing in gusting wind conditions, which resulted in an off-airport landing and impact with soccer goal posts.NTSB CEN17FA170Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Hollis, OKAn impact with terrain during final approach for reasons that could not be determined because no evidence of an in-flight failure or malfunction was observed.NTSB CEN17FA164Accident · 2 fatalField investigationFinal reportBellanca 17 31ATC · Boonville, MOThe pilot's impairment, due to his use of a combination of psychoactive drugs and a vision deficiency in his left eye, which resulted in a failure to maintain adequate altitude during final approach to landing and subsequent collision with power lines.NTSB WPR17FA089Accident · 1 fatalField investigationFinal reportAppleby Nieuport 28 · Paso Robles, CAThe failure of unknown personnel to properly safety an elevator control cable turnbuckle, which disconnected in flight resulting in loss of pitch control. Contributing to the accident was the inadequate design of the experimental airplane, which did not…NTSB ERA17LA166Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Ovid, NYThe mechanic's failure to inspect and clean the carburetor fuel inlet screen during the airplane’s annual inspection, which allowed undetected debris and dirt to obstruct the fuel supply and resulted in fuel starvation and the subsequent total loss of engine…NTSB ERA17LA165Accident · No injuriesLimited investigationFinal reportGanjoo Amit Sonex · Leesburg, VAThe pilot's failure to use carburetor heat appropriately, which resulted in a total loss of engine power due to the formation of carburetor ice.NTSB GAA17CA240Accident · Minor injuriesData collectionFinal reportParlette Robert L Glastar · Wenatchee, WAThe pilot’s improper landing flare and subsequent failure to adequately compensate for gusting wind conditions during a go-around.NTSB CEN17LA162Accident · No injuriesLimited investigationFinal reportCessna 210 · Salida, COThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN17LA157Accident · No injuriesLimited investigationFinal reportCessna 210 · Minden, LAThe pilot's inadequate fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR17WA123Accident · 1 fatalForeign investigationCessna 208 · Anem Mountain, Oksibil, IndonesiaOn April 12, 2017, about 0340 universal coordinated time, a Cessna 208C, PK-FSO, operated by PT. Spirit Avia Sentosa as an unscheduled cargo flight under the pertinent civil regulations of the government of Indonesia, collided with mountainous terrain 7…NTSB ERA17FA153Accident · 1 fatalField investigationFinal reportHoward DGA 15P · Monongahela, PAThe pilot's failure to maintain airplane control during an attempted go-around in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB CEN17LA153Accident · No injuriesLimited investigationFinal reportCessna 152 · La Porte, TXA total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection that did not detect water contamination.NTSB WPR17IA086Incident · No injuriesClass 3 · IncidentFinal reportBeech A36TC · Livermore, CAA mistrim condition while the autopilot was engaged for reasons that could not be determined based on available evidence, and the pilot’s subsequent failure to confirm the command bar status before disengaging the autopilot. Contributing to the accident were…NTSB GAA17CA241Accident · Minor injuriesData collectionFinal reportAmerican AA 1 · New Market, VAThe pilot’s failure to maintain a proper approach path, which resulted in an impact with trees.NTSB CEN17LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Greensburg, INThe pilot's failure to maintain control during landing, which resulted in an impact with terrain.