OpenAirDocs.org

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.

NTSB WPR11LA317Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Bigfork, MTThe pilot’s failure to maintain adequate airspeed and his excessive control inputs during a simulated rope break while taking off, which resulted in an accelerated aerodynamic stall.Jul 8, 2011 · N591CC · Substantial damageNTSB WPR11LA315Accident · No injuriesLimited investigationFinal reportBeech V35B · Oljato, UTThe pilot’s failure to follow the airplane manufacturer’s mixture setting guidance while landing in high density altitude conditions.Jul 7, 2011 · N1735W · Substantial damageNTSB CEN11FA434Accident · 1 fatalField investigationFinal reportSchaffer Gary W Lancair · Yukon, OKThe pilot's use of an excessive bank angle while in the airport traffic pattern, which resulted in an accelerated stall. Contributing to the accident were the pilot’s lack of experience in the airplane and the pilot’s distracted attention to the rough running…Jun 30, 2011 · N358MA · Substantial damageNTSB CEN11FA431Accident · 2 fatalField investigationFinal reportBosonetto Thorp T-18 · Howell, MIThe pilot's failure to maintain airplane control and airspeed during final approach, which resulted in an aerodynamic stall/spin at a low altitude.Jun 29, 2011 · N8AL · Substantial damageNTSB ERA11FA369Accident · 2 fatalField investigationFinal reportCessna 172M · Poughkeepsie, NYThe pilot’s loss of airplane control due to impairment or incapacitation as a result of coronary artery disease in combination with atrial fibrillation. Contributing to the accident was the pilot's failure to report his paroxysmal atrial fibrillation to the…Jun 28, 2011 · N61579 · Substantial damageNTSB OPS11IA686Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-83(MD-83) · Apache Junction, AZThe failure of the pilots of both airplanes to see and avoid each other and to maneuver as advised by the air traffic controller in time to prevent the conflict that resulted in the reported near midair collision.Jun 27, 2011 · N416NV · No damageNTSB ERA11FA360Accident · 1 fatalField investigationFinal reportClabaugh Robert R Barracuda · Andalusia, ALThe pilot did not maintain airspeed while maneuvering on approach for landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Jun 26, 2011 · N289DH · Substantial damageNTSB ERA11CA365Accident · Serious injuriesData collectionFinal reportPiper PA-32-300 · Bridgeport, CTThe pilot's failure to maintain clearance from a blast fence on final approach to land.Jun 26, 2011 · N600DK · Substantial damageNTSB ERA11CA363Accident · Minor injuriesData collectionFinal reportCessna 150L · Winter Haven, FLThe certified flight instructor's failure to maintain control during the attempted go-around, which resulted in an aerodynamic stall.Jun 26, 2011 · N18735 · Substantial damageNTSB CEN11LA457Accident · Minor injuriesLimited investigationFinal reportBeech B36TC · Akron, COThe mixture control cable disconnected from the cable housing attach clamp, which resutlted in the pilot's inability to add power when needed.Jun 23, 2011 · N93PP · Substantial damageNTSB WPR11CA271Accident · No injuriesData collectionFinal reportLuscombe 8F · McCall, IDThe pilot's failure to maintain adequate airspeed that resulted in a stall/mush. Contributing to the accident was the pilot's failure to maintain an adequate spacing from the aircraft ahead of him.Jun 21, 2011 · N1459B · Substantial damageNTSB ERA11CA355Accident · No injuriesData collectionFinal reportDotson William P Sngl Seat Hawk Arrow · Carthage, NCA partial loss of engine power due to the pilot’s improper installation of the engine’s No. 1 cylinder spark plugs.Jun 20, 2011 · N4209F · Substantial damageNTSB ERA11CA366Accident · No injuriesData collectionFinal reportChampion 7FC · Wellsville, PAThe pilot's failure to maintain adequate airspeed on final approach which resulted in an aerodynamic stall.Jun 18, 2011 · N7583E · Substantial damageNTSB ERA11CA353Accident · No injuriesData collectionFinal reportHead Balloons AX8-88 · Summerdale, ALThe balloon pilot's failure to maintain proper altitude/clearance from a tree line during the landing approach.Jun 18, 2011 · N8190V · Substantial damageNTSB CEN11CA411Accident · No injuriesData collectionFinal reportWorley Dennis Sonex · Gardner, KSThe pilot's failure to maintain a proper glide path during the visual approach.Jun 18, 2011 · N563 · Substantial damageNTSB ERA11CA347Accident · No injuriesData collectionFinal reportCessna 172N · Belle Glades, FLThe pilot’s failure to maintain airplane control during the landing approach.Jun 15, 2011 · N4954G · Substantial damageNTSB OPS11IA653Incident · No injuriesIncident investigationFinal reportBeech 1900C · Fairbanks, AKInadequate air traffic control actions that failed to establish and maintain required separation between the two airplanes. Contributing to the incident was inexperience on the part of the local controller, inadequate oversight by the tower…Jun 14, 2011 · N121WV · 2 aircraft · No damageNTSB CEN11CA410Accident · No injuriesData collectionFinal reportTaft, Malcolm J SR Glastar · Canon City, COA loss of engine power due to an overheated engine as a result of a malfunction of the modified engine cooling system, necessitating a forced landing on unsuitable terrain.Jun 6, 2011 · N238W · Substantial damageNTSB WPR11FA248Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Astoria, ORThe student pilot’s failure to maintain adequate airspeed while maneuvering for landing, which resulted in a stall/spin. Contributing to the accident were the pilot's distraction and anxiety from a reported failure of the airplane's electrical system.Jun 5, 2011 · N511FS · Substantial damageNTSB WPR11LA246Accident · No injuriesLimited investigationFinal reportScottish Series 100 MDL 101 · Chandler, AZA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Jun 3, 2011 · N101MY · Substantial damageNTSB WPR11LA245Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Lake Havasu, AZThe failure of the low pressure switch in the normal landing gear system, which prevented normal operation of that system, and the misrigging of the emergency extension gear release valve, which prevented the system from being depressurized to allow for the…Jun 2, 2011 · N712MK · Substantial damageNTSB WPR11FA242Accident · 4 fatalField investigationFinal reportCessna 172R · Wendover, UTThe pilot did not maintain adequate airspeed during the downwind turn resulting in an aerodynamic stall, in-flight loss of control, and spin. Contributing to the accident was the pilot’s inadequate preflight planning and exceedance of the approved weight and…Jun 1, 2011 · N475ER · Substantial damageNTSB ERA11CA323Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Wurstboro, NYThe flying pilot's failure to maintain aircraft control and the flight instructor's inadequate supervision while landing with a gusting wind. Contributing to the accident was the lack of communication between the flight instructor and pilot under evaluation…Jun 1, 2011 · N2656H · Substantial damageNTSB ERA11CA319Accident · Serious injuriesData collectionFinal reportAero AT SP Zoo AT-4 LSA · Concord, NHThe student pilot's loss of aircraft control during a go-around maneuver following a bounced landing.May 31, 2011 · N709PR · Substantial damageNTSB CEN11FA359Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B2 · Fort Worth, TXThe pilot’s loss of control due to his not maintaining adequate airspeed and altitude during a simulated hydraulic flight control failure. Contributing to the accident was the flight instructor’s inadequate supervision and delayed remedial response.May 29, 2011 · N747CH · Substantial damageNTSB CEN11FA358Accident · 2 fatalField investigationFinal reportRockwell 112 · Bryan, TXThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper control inputs following the loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to…May 29, 2011 · N1041J · Substantial damageNTSB ERA11CA309Accident · Minor injuriesData collectionFinal reportBeech A23 · Greene, NYThe pilot's decision to continue a visual approach with low visibility and in heavy rain and his subsequent failure to maintain clearance from trees.May 21, 2011 · N3548R · Substantial damageNTSB CEN11LA345Accident · Serious injuriesLimited investigationFinal reportSocata TBM-850 · Salem, OHThe pilot's failure to maintain a stabilized glide path which resulted in the airplane touching down short of the runway.May 19, 2011 · N1UL · Substantial damageNTSB ANC11TA031Accident · Minor injuriesFinal reportBeech B200 · Atqasuk, AKThe pilot did not maintain sufficient airspeed during an instrument approach in icing conditions, which resulted in an aerodynamic stall and loss of control. Contributing to the accident were the pilot’s fatigue, the operator’s decision to initiate the flight…May 16, 2011 · N786SR · Substantial damageNTSB ERA11LA301Accident · No injuriesLimited investigationFinal reportLeigh S-6 Coyote II · New Kent, VAA total loss of engine power for undetermined reasons.May 15, 2011 · N929RL · Substantial damageNTSB ERA11LA300Accident · Serious injuriesLimited investigationFinal reportCarothers Zenith CH701 · Tidioute, PAThe pilot's impairment due to alcohol and failure to maintain altitude on approach to landing, resulting in an in-flight collision with a tree.May 13, 2011 · N433UB · Substantial damageNTSB CEN11CA362Accident · No injuriesData collectionFinal reportBeech B24R · Dowagiac, MIThe flight instructor's failure to maintain an appropriate glide path and airspeed during the landing approach, which resulted in an aerodynamic stall.May 11, 2011 · N9321S · Substantial damageNTSB ANC11CA029Accident · Serious injuriesData collectionFinal reportPiper PA-18-125 · Cordova, AKThe pilot's loss of aircraft control during final approach in gusty wind conditions, resulting in a hard landing.May 6, 2011 · N1129A · Substantial damageNTSB WPR11IA213Incident · No injuriesIncident investigationFinal reportCessna 421B · Truckee, CAFatigue failure of the right flap extend cable during the landing approach.May 2, 2011 · N270CS · No damageNTSB WPR11LA210Accident · No injuriesLimited investigationFinal reportCessna 150H · College Place, WAThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during final approach.Apr 24, 2011 · N23295 · Substantial damageNTSB ERA11CA267Accident · Minor injuriesData collectionFinal reportCessna 182A · Galax, VAThe pilot's inadequate compensation for the wind while on approach for landing.Apr 24, 2011 · N4920D · Substantial damageNTSB ERA11FA258Accident · 1 fatalField investigationFinal reportCessna 210D · Altavista, VAThe pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s lack of experience in actual night instrument conditions.Apr 23, 2011 · N3963Y · Substantial damageNTSB CEN11FA302Accident · 4 fatalField investigationFinal reportBeech 58 · Topeka, KSThe pilot failed to maintain control of the airplane while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot’s minimal experience flying in actual instrument conditions.Apr 22, 2011 · N580EA · DestroyedNTSB OPS11IA499Incident · No injuriesIncident investigationFinal reportBoeing 737 · Camp Springs, MDThe misapplication of wake turbulence and instrument flight rules (IFR) separation criteria by air traffic controllers.Apr 18, 2011 · 2 aircraft · No damageNTSB CEN11CA293Accident · No injuriesData collectionFinal reportCessna 172 · Greenville, TXThe pilot's delayed action in performing a go-around maneuver, which resulted in an impact with trees.Apr 16, 2011 · N6933A · Substantial damageNTSB ERA11CA243Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Latrobe, PAMaintenance personnel’s failure to properly secure the throttle cable to the fuel servo.Apr 14, 2011 · N5325L · Substantial damageNTSB CEN11CA290Accident · No injuriesData collectionFinal reportCessna 182H · Park Falls, WIThe student pilot's failure to maintain aircraft control during an aborted landing.Apr 14, 2011 · N8364S · Substantial damageNTSB OPS11IA476Incident · No injuriesIncident investigationFinal reportBeech 400 · Midland, TXInadequate planning and control instructions issued to the pilots involved by the trainee controller operating the local control position and inadequate supervision by the instructor responsible for the position.Apr 13, 2011 · Military · 2 aircraft · No damageNTSB CEN11IA280Incident · No injuriesIncident investigationFinal reportBeech 90B · Chickasha, OKThe mechanic's improper installation of the aileron.Apr 11, 2011 · N37OU · Minor damageNTSB ERA11LA239Accident · No injuriesLimited investigationFinal reportBeech BE99 · Cedartown, GAThe failure of the left main landing gear bearings and supports due to inadequate lubrication by unknown maintenance personnel.Apr 10, 2011 · N899AE · Substantial damageNTSB ERA11FA233Accident · 1 fatalField investigationFinal reportCessna 402B · Biddeford, METhe pilot did not maintain minimum controllable airspeed while on final approach with a partial loss of power in the right engine, which resulted in a loss of control. Contributing to the accident was the partial loss of engine power in the right engine due…Apr 10, 2011 · N402RC · Substantial damageNTSB ERA11FA232Accident · 3 fatalField investigationFinal reportCessna 310R · McComb, MSThe pilot's impairment due to alcohol ingestion and his failure to maintain airplane control during an approach at night in instrument meteorological conditions.Apr 10, 2011 · N100TK · Substantial damageNTSB ERA11CA236Accident · No injuriesData collectionFinal reportCessna 172N · Millville, NJThe pilot’s improper recovery from a bounced landing which resulted in a loss of aircraft control during the go-around.Apr 10, 2011 · N6338F · Substantial damageNTSB WPR11FA192Accident · Serious injuriesField investigationFinal reportBeech 35-B33 · Camarillo, CAThe loss of engine power during the landing approach for undetermined reasons.Apr 9, 2011 · N460SR · Substantial damageNTSB WPR11CA189Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Salt Lake City, UTThe student pilot's inadvertent action of pulling out the engine's mixture control lever to idle cutoff that resulted in a complete loss of engine power.Apr 6, 2011 · N268SH · Substantial damage