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 ERA10FA048Accident · 2 fatalField investigationFinal reportCessna 172S · Tallahassee, FLThe pilots' spatial disorientation during flight in dark conditions, which resulted in an uncontrolled descent into terrain.Nov 5, 2009 · N5194X · DestroyedNTSB WPR10CA049Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Lewiston, IDThe pilot's delayed decision to execute a go-around in gusting winds and with up-sloping terrain.Nov 1, 2009 · N82213 · Substantial damageNTSB CEN10LA047Accident · No injuriesLimited investigationFinal reportCessna T182T · Loveland, COThe pilot's failure to attain the proper touchdown point during dusk light conditions, and his failure to execute a go-around.Nov 1, 2009 · N652CP · Substantial damageNTSB ERA10WA035Accident · 5 fatalForeign investigationHawker BAe-125-800B · Minsk, BelarusOn October 26, 2009, at 1934 universal coordinated time (2134 local standard time), a Hawker-Beech BAe-125-800, Russian registration RA-02807, operated by S-Air, was destroyed when it impacted forested terrain during a go-around attempt at Minsk-2…Oct 26, 2009 · RA-02807 · DestroyedNTSB ERA10FA029Accident · 1 fatalField investigationFinal reportCessna 172P · Bennington, VTThe pilot’s failure to maintain clearance from terrain during a night approach. Contributing to the accident was the pilot’s non-standard traffic pattern over higher terrain.Oct 25, 2009 · N55479 · Substantial damageNTSB WPR10CA084Accident · No injuriesData collectionFinal reportGolden Circle Tierra I · Jensen, UTA loss of engine power, as reported by the pilot, for undetermined reasons.Oct 24, 2009 · N440KC · Substantial damageNTSB CEN10FA027Accident · 2 fatalField investigationFinal reportCommander 114-B · Adrian, MIThe pilot did not maintain control of the airplane due to spatial disorientation while on an instrument approach in instrument meteorological conditions.Oct 23, 2009 · N6025U · Substantial damageNTSB WPR10LA034Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Cedar City, UTThe failure of the landing gear accumulator/regulator and the installation of the improper priority valve, which precluded the landing gear from extending and locking into place.Oct 21, 2009 · N690TR · Substantial damageNTSB CEN10FA021Accident · Minor injuriesField investigationFinal reportCessna P210N · Rifle, COThe pilot’s failure to properly identify the power lever and, instead, manipulating the propeller condition lever.Oct 18, 2009 · N7217S · Substantial damageNTSB CEN10CA018Accident · Minor injuriesData collectionFinal reportCessna T206H · Johnson City, KSThe pilot's delayed action in applying full power during a go-around after flying into a fog bank.Oct 16, 2009 · N454TG · Substantial damageNTSB WPR10CA015Accident · Serious injuriesData collectionFinal reportLet Blanik L-13 · Llano, CAThe student pilot's improper use of the airbrakes while on approach for landing.Oct 11, 2009 · N948LC · Substantial damageNTSB ERA10GA015Accident · No injuriesFinal reportBell OH-58A · Ocala, FLThe excessive wear and failure of engine governor components for undetermined reasons, which resulted in a loss of engine power.Oct 11, 2009 · N911AF · Substantial damageNTSB WPR10CA026Accident · No injuriesData collectionFinal reportCessna 180A · Condon, ORThe pilot's failure to maintain clearance from the fence post on approach.Oct 10, 2009 · N9586B · Substantial damageNTSB ANC10CA002Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Nondalton, AKThe pilot's decision to attempt a landing in weather conducive to strong downdrafts, resulting in a loss of control.Oct 10, 2009 · N27231 · Substantial damageNTSB ERA10CA008Accident · No injuriesData collectionFinal reportCessna 172S · Easton, PAThe pilot’s failure to maintain adequate clearance from terrain while on short final.Oct 6, 2009 · N66087 · Substantial damageNTSB WPR10LA006Accident · Serious injuriesLimited investigationFinal reportTurpen RV-8 · Yankton, ORThe pilot's inadequate planning during an instrument approach and failure to maintain the published minimum altitudes, which resulted in controlled flight into terrain.Oct 5, 2009 · N61FS · Substantial damageNTSB ERA10LA005Accident · No injuriesLimited investigationFinal reportCessna 210 · Louisville, KYA malfunction of the landing gear extension system due to a fractured hydraulic line. Contributing to the accident was the inadequate inspection and maintenance of the hydraulic line.Oct 4, 2009 · N9443T · Substantial damageNTSB WPR09CA469Accident · No injuriesData collectionFinal reportCessna 182 · Parowan, UTThe pilot's improper flare and recovery from a bounced landing.Sep 26, 2009 · N1040D · Substantial damageNTSB ERA09WA546Accident · 2 fatalForeign investigationPiper PA18 · Barbones, Ecuador, EcuadorOn September 25, 2009, about 1330 central standard time, a Piper PA-18-150, Ecuadorian registration HC-AHD, registered to and operated by FumiPalma S.A., crashed following a loss of engine power, while on an approach for landing at the Pista Bardones, El Oro,…Sep 25, 2009 · HC-AHD · DestroyedNTSB ERA09LA536Accident · 1 fatalLimited investigationFinal reportDuke Paul Challenger II · Lumberton, MSThe non-certificated pilot’s failure to maintain clearance from trees during a go-around procedure for unknown reasons.Sep 24, 2009 · N4340D · Substantial damageNTSB CEN09FA601Accident · 1 fatalField investigationFinal reportCessna T210 · Hilltop Lakes, TXThe loss of control of the airplane in dark night light conditions due to the pilot’s spatial disorientation.Sep 24, 2009 · N9734Y · DestroyedNTSB ERA09LA531Accident · Minor injuriesLimited investigationFinal reportDaniel L Patrick Kolb Mark · Mystic, CTThe pilot's failure to maintain airspeed during final approach, resulting in an inadvertent stall. Contributing to the accident was the pilot's lack of total flight experience.Sep 20, 2009 · N208NS · Substantial damageNTSB WPR09LA458Accident · Serious injuriesLimited investigationFinal reportCassutt III M · Reno, NVThe loss of engine power due to failure of the No. 2 connecting rod as a result of operation of the engine at excessive temperatures.Sep 19, 2009 · C-FDXO · Substantial damageNTSB CEN09CA593Accident · Minor injuriesData collectionFinal reportLinke KR-2 · Mt. Vernon, ILThe inadequate preflight planning/preparation and fuel management by the pilot which led to fuel exhaustion and a total loss of engine power during approach. Contributing to the accident was the inoperative fuel indicator.Sep 18, 2009 · N4207Z · Substantial damageNTSB WPR09LA453Accident · 2 fatalLimited investigationFinal reportQuad City Challenger II · Redlands, CAStructural failure of the right wing during the landing approach due to the separation of the wing's fabric covering.Sep 16, 2009 · N732LS · Substantial damageNTSB ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.Sep 13, 2009 · N734TV · Substantial damageNTSB CEN09CA584Accident · Minor injuriesData collectionFinal reportYates W/Lazar M Safari Helicopter · Cedar Park, TXAn in-flight separation of the tail rotor blades and the tail rotor gearbox for undetermined reasons.Sep 13, 2009 · N555BB · Substantial damageNTSB ERA09FA514Accident · 1 fatalField investigationFinal reportBeech A36 · Flat Rock, NCThe pilot’s attempt to maintain visual flight during instrument meteorological conditions, resulting in controlled flight into mountainous terrain. Contributing to the accident was the pilot’s failure to advise the controller of the weather conditions…Sep 10, 2009 · N888WD · Substantial damageNTSB ERA09LA501Accident · 2 fatalLimited investigationFinal reportKeithley Thomas E Starduster Too · St. Matthews, SCA loss of airplane control during approach for undetermined reasons.Sep 7, 2009 · N26TK · Substantial damageNTSB ANC09LA098Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Central, AKThe pilot’s failure to maintain control of the helicopter after an in-flight encounter with a downdraft while landing. Contributing to the accident was the pilot’s inadequate evaluation of wind conditions.Sep 7, 2009 · N4186Y · Substantial damageNTSB ERA09LA500Accident · 1 fatalLimited investigationFinal reportBlum Matthew Aventura II · Boca Raton, FLThe improper assembly of both carburetors, resulting in an excessively rich fuel to air ratio and subsequent partial loss of engine power.Sep 6, 2009 · N6301M · Substantial damageNTSB CEN09LA576Accident · No injuriesLimited investigationFinal reportCessna 170A · Grain Valley, MOA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat.Sep 6, 2009 · N9129A · Substantial damageNTSB CEN09CA566Accident · No injuriesData collectionFinal reportPiper J3C-65 · Mondovi, WIThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an aerodynamic stall.Sep 6, 2009 · N3549W · Substantial damageNTSB ERA09FA497Accident · 1 fatalField investigationFinal reportRobinson R44 · Jackson, MSThe pilot's failure to maintain adequate main rotor rpm, for undetermined reasons.Sep 1, 2009 · N33PX · Substantial damageNTSB ERA09CA493Accident · No injuriesData collectionFinal reportBeech B19 · Thomasville, PAA partial loss of engine power due to a partial blockage of the carburetor fuel inlet filter.Aug 30, 2009 · N6982R · Substantial damageNTSB WPR09LA426Accident · Minor injuriesLimited investigationFinal reportSix-Chuter American Spirit · Brownsville, ORThe pilot's failure to maintain clearance from power lines.Aug 29, 2009 · N9184F · Substantial damageNTSB ERA09LA483Accident · 2 fatalLimited investigationFinal reportBeech C24R · Sylva, NCThe pilot's failure to maintain an adequate airspeed during an aborted landing, which resulted in an aerodynamic stall.Aug 26, 2009 · N770DL · DestroyedNTSB CEN09LA549Accident · 1 fatalLimited investigationFinal reportPiper PA-15 · Lakeview, MIThe pilot's failure to maintain control of the airplane.Aug 26, 2009 · N4585H · DestroyedNTSB CEN09LA555Accident · 1 fatalLimited investigationFinal reportDestiny Powered Parachutes Destiny 2000 · Arcanum, OHThe failure of pilot to maintain an adequate visual lookout in order to avoid the collision with an aircraft on final approach to land.Aug 25, 2009 · N5604B · 2 aircraft · Substantial damageNTSB WPR09LA412Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Santa Barbara, CAA loss of power during approach due to fuel exhaustion for undetermined reasonsAug 23, 2009 · N8775P · Substantial damageNTSB ERA09LA464Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC-145 · North Captiva Island, FLThe pilot's failure to arrest the helicopter's descent, which resulted in controlled flight into terrain.Aug 17, 2009 · N911LZ · Substantial damageNTSB WPR09FA398Accident · 2 fatalField investigationFinal reportCessna 152 · Hesperia, CAThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern, which resulted in an aerodynamic stall/spin. Also causal was the failure of the left magneto due to improper assembly of the drive gear during installation on the…Aug 16, 2009 · N67361 · Substantial damageNTSB CEN09CA532Accident · Serious injuriesData collectionFinal reportPiper PA-28-161 · Washington, IAA loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat in conditions that were conducive to carburetor icing.Aug 16, 2009 · N47539 · Substantial damageNTSB CEN09CA513Accident · No injuriesData collectionFinal reportBeech A36TC · Brighton, MIThe pilot's failure to maintain airspeed and compensate for wind conditions during final approach.Aug 9, 2009 · N336TC · Substantial damageNTSB ERA09LA456Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate preflight inspection and failure to ensure an adequate quantity of fuel was available for the flight.Aug 7, 2009 · N20977 · Substantial damageNTSB ERA09CA442Accident · Minor injuriesData collectionFinal reportRans S12 · Quitman, GAThe pilot's failure to maintain obstacle clearance on final approach.Aug 4, 2009 · N43377 · Substantial damageNTSB ANC09CA076Accident · No injuriesData collectionFinal reportPiper PA-18 · Skwentna, AKThe pilot’s misjudged landing on a downsloping, short landing strip, resulting in a nose over.Aug 2, 2009 · N7509K · Substantial damageNTSB WPR09LA378Accident · 1 fatalLimited investigationFinal reportGray RV-6 · Caldwell, IDThe pilot's failure to maintain adequate airspeed that led to a stall/spin while maneuvering in the traffic pattern.Aug 1, 2009 · N69KG · DestroyedNTSB CEN09LA491Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Iowa Falls, IABoth pilots' failure to execute adequate visual lookout, resulting in the two airplanes colliding over the runway.Jul 31, 2009 · N989TP · 2 aircraft · Substantial damageNTSB CEN09CA480Accident · No injuriesData collectionFinal reportBoring Robert Burton RV6A · Demming, NMThe loss of engine power due to fuel starvation as a result of the pilot's failure to manage and monitor fuel usage.Jul 31, 2009 · N613LE · Substantial damage