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 ATL89LA111Accident · 1 fatalLimited investigationFinal reportMorrisey 2150A · Lenoir, NCPilot disregarded the apparent severity of the approaching thunderstorms and attempted a circuit of the airport under visual flight rules when it was not possible. The pilot's lack of recent flight experience was a contributing factor.NTSB FTW89LA068Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Galveston, TXFailure of the pilot to maintain sufficient airspeed, which resulted in a stall and loss of control. Contributing factors were: the weather conditions, which were below minimums, and failure of the pilot to perform a missed approach.NTSB BFO89DID01Accident · No injuriesFinal reportHalstead Sandpiper · Chesapeake, VAThe pilot/builders improper installation of the ruddervador and the pilot's improper recovery from a bounced landing. A contributing factor was the failure of the FAA to detect the flaw during the certification of the aircraft.NTSB CHI89MA057Accident · 2 fatalMajor investigationFinal reportNihon YS-11A-600 · West Lafayette, INA loss of control due to the improper inflight decisions by the crew and the undetected accumulation of ice on the leading edge of the horizontal stabilizer, during flight in a forward center of gravity condition and exacerbated by the extension of full…NTSB ATL89IA104Incident · No injuriesIncident investigationFinal reportCessna 177RG · Savannah, GAFatigue-induced fracture of the main landing gear actuator rod end.NTSB DEN89LA085Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Roy, UTThe pilot allowed himself to become distracted by a landing gear problem, which resulted in fuel exhaustion, when he had insufficient fuel to delay his landing. Factors related to the accident were: the landing gear problem and trees in the emergency landing…NTSB LAX89LA123Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Watsonville, CAThe pilot's improperly planned approach, and his failure to maintain clearance from the wind sock pole. The proximity of the wind sock (arpt facility) was considered to be a related factor.NTSB MKC89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Monroe City, MOFuel contamination and the pilot's failure to comply with a maintenance AD. Contributing to the accident was the pilot's operation of the airplane with a known deficiency.NTSB ATL89LA103Accident · No injuriesLimited investigationFinal reportCessna 172M · Sanford, NCCarburetor ice due to the failure of the pilot to properly use the carburetor heat control during descent and flight in the traffic patterns at reduced power. Underlying this is inadequate training in the proper understanding of carburetor icing and the…NTSB MIA89FA100Accident · 2 fatalField investigationFinal reportBeech S35 · Daytona Beach, FLThe pilot's improper IFR procedure and his failure to maintain proper altitude. Contributing factors were: his improper use of the navigation receiver, his delay in making a missed apch, his lack of experience in the type of aircraft, his lack of recent…NTSB LAX89LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZThe failure of the instructor pilot to properly evaluate the weather conditions resulting in an encounter with an unanticipated downdraft condition and failure of the student pilot to maintain a proper descent rate.NTSB MIA89LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Jacksonville, FLAn unstabilized instrument approach wherein the pilot descended below the mda. Contributing factors included an inadequately equipped acft and the pilot's lack of recent instrument experience.NTSB FTW89LA061Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Robstown, TXThe pilot delayed flight to an alternate destination, continued flight into instrument meteorological conditions (IMC), experienced spatial disorientation, and lost control of the aircraft. Contributing factors were: the pilot's inadequate preflight…NTSB NYC89FA097Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Lake Placid, NYThe pilot's departure into known adverse weather conditions and his continued VFR flight into instrument meteorological conditions. Contributing factor(s) was: the adverse weather conditions.NTSB MIA89FA096Accident · Minor injuriesField investigationFinal reportDouglas DC-3 · Isla Verde, PRThe failure of the flight crew to feather the left propeller and trim the aircraft after the left engine stopped producing power for undetermined reasons.NTSB FTW89IA064Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Houston, TXFailure of the TRACON final approach controller to assure radar separation between the aircraft. Factors related to the accident were: inadequate supervision by the ATC supervisor, excessive workload for the controller, unclear instructions by the controller,…NTSB DEN89LA081Accident · No injuriesLimited investigationFinal reportCessna 150 · Evanston, WYThe failure of the pilot to maintain the proper descent rate on final approach which resulted in a landing short of the runway.NTSB LAX89LA116Accident · No injuriesLimited investigationFinal reportCessna 177 · Yuba City, CAInadequate supervision by the instructor (CFI) which resulted in a delayed go-around, inadequate airspeed, and a stall/mush into the ground. A poor approach by the student pilot was a contributing factor.NTSB FTW89DQA02Accident · Serious injuriesFinal reportI.C.A. Brasov IS-28B2 · El Paso, TXThe failure of the pilot to maintain adequate airspeed, while maneuvering to land in turbulent weather, which resulted in a stall/spin and subsequent collision with a tree and the ground. Turbulence was a factor.NTSB NYC89LA090Accident · Minor injuriesLimited investigationFinal reportTaylorcraft L-2M · Olcott, NYThe inattentiveness of the pilot to maintain airspeed while turning base leg for landing which resulted in a stall and subsequent collision with a hangar.NTSB FTW89LA054Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Brownsville, TXThe pilot failed to compensate for the existing wind conditions and maintain proper alignment with the runway. The wind conditions and the sunglare are considered to be contributing factors to the accident.NTSB LAX89FA113Accident · 1 fatalField investigationFinal reportCessna 172F · Safford, AZFailure of the pilot to maintain proper airspeed while on final approach resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed use of wing flaps.NTSB FTW89LA052Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Austin, TXThe pilot's inaccurate fuel consumption calculations and improper positioning of the fuel tank selector valve.NTSB MIA89FA088Accident · 2 fatalField investigationFinal reportCessna 320E · Melrose, FLThe failure of the pilot to comply promptly with ATC instructions and his loss of control due to spatial disorientation.NTSB ATL89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Huntersville, NCFire resulting from an oil leak of undetermined origin in the area of the left engine.NTSB NYC89LA083Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Yarmouth, MAA loss of engine power and subsequent forced landing which resulted from binding of the carbuerator throttle shaft. The binding resulted from an improper overhaul of the carbuertor approximately 10 flight hours prior to the accident.NTSB LAX89FA103Accident · Minor injuriesField investigationFinal reportCessna 150K · Honolulu, HIInadequate control tower service provided by the local controller (lc), and failure of the two pilots to see and avoid each other's aircraft. Related factors were: identification of the wrong aircraft by the local controller, his excessive workload (heavy…NTSB MIA89GA082Accident · Minor injuriesFinal reportCessna T210L · Melbourne, FLFailure of the pilot to accurately determine fuel quantity prior to departure followed by his failure to operate the engine on the fullest fuel tank resulting in a fuel tank being run dry resulting in engine failure while on short final approach at his…NTSB MIA89FA078Accident · Serious injuriesField investigationFinal reportBeech A23-24 · Clearwater, FLFuel starvation due to the CFI depleting the fuel supply from one of two tanks and failing to select the fullest tank for landing. Contributing to the accident was the cfi's improper decision to turn back to the airport when insufficient altitude was…NTSB LAX89DVD02Accident · 1 fatalFinal reportWar Replicas P-51 · Tracy, CAThe improper installation of the aileron controls of this homebuilt acft by the pilot/manufacturer which led to the inflight loss of control of the airplane. Contributing to the accident was the pilot's inexperience in the airplane.NTSB FTW89LA045Accident · Minor injuriesLimited investigationFinal reportPiper J-3C-65 · Richards, TXThe pilot's inadequate preflight planning/preparation in disregarding wind information. Contributing to the accident were the gusting crosswind conditions and the pilot's overconfidence in personal ability.NTSB MKC89LA056Accident · No injuriesLimited investigationFinal reportCessna 172 · Ainsworth, NEThe loss of power from undetermined reasons during an attempted go-around. Contributing to the accident was the pilot's failure to maintain directional control of the airplane and the crosswind conditions.NTSB LAX89LA097Accident · No injuriesLimited investigationFinal reportBeech E33 · Parlier, CAThe pilot's improper in-flight planning/decision to continue to the destination airport after encountering a restrictionof fuel flow from the right tank and subsequent fuel starvation when the left tank emptied. Contributing factors were the blocked fuel vent…NTSB LAX89LA100Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gualala, CAPilot misjudged the altitude and distance to the runway and subsequently did not attain the proper touchdown point.NTSB DEN89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Las Cruces, NMThe loss of right engine power for undetermined reason(s), and the failure of the instructor pilot to feather the right engine. Factors related to the accident were: failure of the left main gear locking mechanism to engage and the unprepared (rough/uneven)…NTSB ATL89DMG02Accident · Minor injuriesFinal reportCessna 172P · Mooresville, NCFailure of the pilot to maintain airspeed on final approach to land, which resulted in an inadvertent stall. Factors related to the accident were: carburetor icing conditions, night conditions, and the pilot's decision to land at an unlighted runway.NTSB FTW89DRA02Accident · Serious injuriesFinal reportPitts S1A · Santa Fe, TXPilot in command failed to maintain adequate altitude and clearance on final approach.NTSB DEN89IA067Incident · No injuriesIncident investigationFinal reportBoeing 707-323B · Salt Lake City, UTThe pilot-in-command's attempt to align the airplane with the runway at an altitude insufficient for safe maneuvering, resulting in the no. 1 engine striking the runway. Contributing factors include obscured visibility due to fog, the captain's loss of depth…NTSB ATL89LA082Accident · No injuriesLimited investigationFinal reportCessna 150 · Cambridge, OHThe pilot's failure to maintain directional control in crosswind conditions while on short final and the improperly adjusted carburetor idle flow.NTSB CHI89GA048Accident · 2 fatalFinal reportPiper PA-28-180 · Chicago, ILInadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: high obstructions and retaining wall in the emergency landing area.NTSB DEN89LA062Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Broomfield, COFuel starvation due to improper fuel tank selectior operation by the pilot. A factor related to the accident was: unprepared (rough/uneven) terrain short of the runway.NTSB MKC89LA054Accident · No injuriesLimited investigationFinal reportBeech C-23 · Greenfield, IAThe pilot's failure to assure an an adequate supply of fuel was on board in order to complete the flight.NTSB SEA89LA035Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Sekiu, WAPilot attempted a landing in adverse weather conditions, rather than postpone the business trip and return to origin or other safe area. Contributing to the accident were turbulence and gusty winds along with the self induced pressure to make the business flt.NTSB LAX89LA084Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Westlake, CAImproper planning and decision by the pilot which resulted in fuel exhaustion. Contributing factors were: faulty fuel indication, utility pole & uneven terrain.NTSB SEA89LA034Accident · No injuriesLimited investigationFinal reportCessna 210 · Carson City, NVSeparation of the throttle cable due to wear as power was applied for a landing go-around. Contributing to the accident was rough terrain at the touchdown point of the forced landing.NTSB NYC89LA066Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Newport, RILoss of control during an attempted go-around due to raising the flaps at low airspeed, in a nose high attitude.NTSB CHI89LA045Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Valparaiso, INInadequate preflight preparation by the pilot, which resulted in inadvertent flight in icing conditions and rapid accumulation of airframe ice, and the pilot's failure to maintain sufficient airspeed to flare during the landing. Factors related to the…NTSB MIA89LA067Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Rose Hill, MSLoss of electrical power for an undetermined reason and fuel starvation from improper use of the fuel selector. Factors related to the accident were: night and adverse weather conditions.NTSB ATL89FA071Accident · Serious injuriesField investigationFinal reportCessna 208B · Madison, NCImproper IFR procedure by the pilot and his failure to maintain the minimum descent altitude (mda). Contributing factors were: low ceiling, fog, delayed missed approach by the pilot, and trees.NTSB LAX89FA083Accident · Serious injuriesField investigationFinal reportPitts S2B · Ramona, CAThe Pitts pilot's inadequate visual lookout. Contributing factor(s) was: inadequate radio communications by the Pitts pilot.