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 CEN22LA141Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150M · Brodhead, WIA loss of engine power due to the fatigue fracture of the No. 1 cylinder’s rocker shaft bosses, which resulted in a forced landing into uneven terrain.NTSB CEN22LA144Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Minot, NDThe failure of the Nos.2, 4, and 6 cylinders due to detonation.NTSB GAA22WA122Accident · No injuriesClass 5 · ForeignCessna 182 · Tumeremo, VenezuelaNTSB ERA22FA149Accident · 2 fatalClass 3 · FieldFinal reportCessna 182Q · Panama City, FLThe pilot’s deviation from the final approach course during a night instrument approach with low instrument meterological conditions, which resulted in an impact with heavily wooded terrain. Contributing to the accident was the pilot’s decision to continue…NTSB DCA22WA092IncidentClass 5 · ForeignBoeing 737 · Malaga, SpainNTSB ERA22LA138Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Farmingdale, NYThe flight crew’s failure to verify the landing gear position prior to landing. Contributing to the accident was an overload in the landing gear motor electrical circuit which resulted in the circuit breaker opening, preventing the landing gear from extending.NTSB WPR22LA114Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 208B · Oceanside, CAThe pilot’s intentional inflight operation of the propeller in beta, which led to an aerodynamic lock, his inability to restore forward thrust, and subsequent collision with terrain.NTSB CEN22FA131Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Fostoria, OHThe pilot’s loss of airplane control in night instrument meteorological conditions during the procedure turn of an instrument approach due to spatial disorientation, which resulted in a collision with terrain.NTSB CEN22LA129Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Franklin, INThe pilot’s loss of control in the landing pattern resulting in an aerodynamic stall and impact with terrain.NTSB WPR22LA105Accident · No injuriesClass 4 · LimitedFinal reportShelton Joseph G S-7 · Buckeye, AZThe pilot’s exceedance of the airplane’s critical angle of attack while on final approach to land which resulted in an aerodynamic stall and hard landing.NTSB ERA22LA130Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Washington, NCThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination.NTSB CEN22LA120Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Murphysboro, ILThe pilot’s failure to maintain clearance from power lines during approach for landing.NTSB CEN22LA118Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · Katy, TXThe pilot’s failure to maintain a proper glidepath while on the final approach segment of the traffic pattern in dark night conditions.NTSB DCA22WA119IncidentClass 5 · ForeignAirbus A320 · Pointe-a-Pitre, GuadeloupeNTSB WPR22LA097Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20J · Paradise, CAThe pilot’s failure to maintain a proper glidepath which resulted in a collision with terrain.NTSB ERA22LA125Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Pinehurst, NCThe in-flight encounter while on final approach with high-speed trailing vortices from a military helicopter, resulting in abnormal runway contact. Contributing to the accident was the Cirrus pilot’s incorrect selection of the common traffic advisory…NTSB CEN22LA125Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Burleson, TXThe student pilot accidentally pulling the mixture control in the landing pattern which resulted in a loss of engine power and forced landing.NTSB CEN22LA116Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C35 · Shell Knob, MOThe pilot’s failure to maintain airplane control that resulted in an aerodynamic stall during approach and impact with terrain.NTSB ERA22LA124Accident · No injuriesClass 4 · LimitedFinal reportCessna 172RG · Rocky Mount, NCAn inflight collision with a bird, which resulted in substantial damage to the left wing.NTSB ERA22LA112Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 195 · Palm Coast, FLThe pilot’s inadequate fuel planning and preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN22LA110Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe windshear encounter on short final approach, which resulted in an excessive decent rate and ground impact.NTSB CEN22LA107Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Angola, INThe pilot’s failure to ensure adequate terrain clearance during an approach. Contributing to the accident was the flight instructor’s delayed remedial action when the airplane descended too low after transitioning to a visual descent to the runway.NTSB GAA22WA087Accident · No injuriesClass 5 · ForeignBeech 58 · Curitiba, BrazilNTSB ERA22LA110Accident · Serious injuriesClass 4 · LimitedFinal reportMiller Roger Thatcher CX4 · Angier, NCThe pilot’s encounter with a flock of birds on final approach, which resulted in a loss of control, an aerodynamic stall and spin, and impact with trees and terrain.NTSB GAA22WA085Accident · No injuriesClass 5 · ForeignMD Helicopter 369 · International Waters, PanamaNTSB ERA22LA107Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Winter Haven, FLThe pilot receiving instruction’s failure to maintain airspeed during a turn, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall. Contributing to the accident was the flight instructor’s failure to…NTSB CEN22LA098Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Youngstown, OHA loss of engine power for reasons that could not be determined based on available information, which resulted in a forced landing.NTSB GAA22WA068Accident · Minor injuriesClass 4 · ForeignCessna 402B · Berry Islands, BahamasNTSB DCA22WA067Incident · No injuriesClass 5 · ForeignBoeing 787 · Warsaw, PolandNTSB CEN22LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182C · Port Aransas, TXThe loss of engine power due to carburetor icing and the pilot’s failure to utilize carburetor heat.NTSB ERA22LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Berlin, NJAn inadvertent in-flight collision with a goose while on approach.NTSB WPR22FA068Accident · 4 fatalClass 3 · FieldFinal reportGates Learjet 35A · El Cajon, CAThe flight crew’s decision to descend below the published MDA, cancel their IFR clearance to conduct an unauthorized circle-to-land approach to another runway while the airport was in nighttime IFR conditions, and the exceedance of the airplane’s critical…NTSB WPR22LA069Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172N · Auburn, CAThe pilot’s failure to maintain altitude during an instrument approach, which resulted in an impact with power lines.NTSB WPR22FA067Accident · 2 fatalClass 3 · FieldFinal reportVans RV6 · Show Low, AZThe pilot’s exceedance of the airplane’s critical angle of attack following an aborted landing approach, which resulted in an aerodynamic stall and loss of control at an altitude too low for recovery.NTSB WPR22LA078Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Strawberry, AZThe pilot’s failure to maintain clearance from a static wire during approach.NTSB GAA22WA054Accident · 1 fatalClass 5 · ForeignCirrus Design SR22 · Auxerre, FranceNTSB ERA22LA092Accident · Serious injuriesClass 4 · LimitedFinal reportBeech D55 · Hamilton, ALThe pilot’s failure to properly configure the airplane’s fuel system, which resulted in a loss of engine power on the left engine due to fuel starvation.NTSB CEN22LA084Accident · No injuriesClass 4 · LimitedFinal reportTextron 525 · Dubuque, IAAn inflight collision with a flock of geese that resulted in substantial damage to the vertical stabilizer.NTSB GAA22WA180Accident · Minor injuriesClass 5 · ForeignBell 206 · Santa Ana Mountain, ColombiaNTSB CEN22FA080Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Bloomington, INThe pilot’s failure to follow the instrument landing system (ILS) course guidance, which resulted in the pilot’s loss of airplane control during the instrument approach. Contributing to the accident was the presence of turbulence and low-level wind shear.NTSB CEN22LA074Accident · No injuriesClass 4 · LimitedFinal reportMini-MAX 1600R Sport · South Bend, INThe pilot’s low-level flight and poor visual lookout which resulted in collision with a light pole on final approach and the pilot’s improper decision to operate an airplane under the influence of alcohol.NTSB ERA22FA086Accident · 1 fatalClass 3 · FieldFinal reportSwearingen SA226 · Bedford, NHThe pilot’s failure to secure and feather the left engine and increase power on the right engine after a perceived loss of engine power in the left engine, which resulted in a loss of control and impact with terrain just short of the runway. Contributing to…NTSB CEN22FA069Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Steamboat Springs, COThe pilot’s failure to adhere to the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB CEN22LA071Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV8 · Wichita Falls, TXThe pilot’s improper fuel management that resulted in a total loss of engine power due to fuel starvation.NTSB ERA22LA084Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Midland, VACollision with a bird in flight, which resulted in damage to the right-wing leading-edge spar.NTSB CEN22LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Tahlequah, OKA loss of yaw control while on final approach, which resulted in the pilot performing an off-runway landing, and a subsequent nose over. The reason for the loss of yaw control could not be determined based on the available evidence.NTSB ANC22LA009Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 208 · Port Alsworth, AKThe pilot's failure to maintain a proper approach path which resulted in landing short of the runway and impact with terrain.NTSB GAA22WA048Incident · No injuriesClass 5 · ForeignBAE ATP · Belfast, United KingdomNTSB WPR22LA050Accident · Serious injuriesClass 4 · LimitedFinal reportAlon A2 · Frazier Park, CAThe pilot’s failure to maintain adequate airspeed while on approach for landing which, resulted in an aerodynamic stall and collision with terrain.NTSB WPR22LA041Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Farmington, NMThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.