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 ERA12CA348Accident · Minor injuriesData collectionFinal reportMooney M20C · Pembroke Pines, FLThe pilot's improper fuel management, which resulted in a total loss of engine power during approach due to fuel exhaustion.May 19, 2012 · N2610W · Substantial damageNTSB DCA12FA076Accident · 1 fatalField investigationFinal reportHawker Hawker Hunter MK.58A · Point Mugu, CAthe pilot's decision to continue the flight with a known fuel imbalance condition that resulted in a loss of lateral control when the imbalance exceeded the known capabilities of the airplane. The fuel imbalance was due to incomplete refueling and an…May 18, 2012 · N329AX · DestroyedNTSB WPR12LA214Accident · Serious injuriesLimited investigationFinal reportMarley Kolb Firestar II · Cedar Fort, UTThe pilot's failure to maintain airplane control while on approach for landing in gusting wind conditions.May 17, 2012 · N9173T · Substantial damageNTSB ERA12CA333Accident · Minor injuriesData collectionFinal reportLuttenbacher Kurt Bushby Mustang 2 · Kingstree, SCThe pilot’s failure to maintain airplane control during the approach to landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's lack of experience in the airplane.May 12, 2012 · N58RS · Substantial damageNTSB CEN12CA286Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2006T · Cleburne, TXThe pilot's inadvertent selection of flap 0 degrees during the go-around and the flight instructor’s inadequate supervision, which resulted in an aerodynamic stall at low altitude.May 10, 2012 · N727TA · Substantial damageNTSB ERA12CA321Accident · Serious injuriesData collectionFinal reportEiriavion PIK 20D · Eagleville, TNThe glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in an aerodynamic stall.May 6, 2012 · N39RB · Substantial damageNTSB CEN12CA279Accident · No injuriesData collectionFinal reportBalloon Works Firefly 7-15 · Hallsville, MOThe pilot’s failure to maintain clearance from power lines during landing.May 6, 2012 · N9079S · Substantial damageNTSB CEN12FA271Accident · 2 fatalField investigationFinal reportBeech S35 · Lake in the Hills, ILThe pilot's excessive bank angle while on approach to land, which resulted in an inadvertent aerodynamic stall and spin.May 3, 2012 · N176Q · Substantial damageNTSB ERA12WA300Accident · 1 fatalForeign investigationBeech C90 · Jundiai, BrazilOn April 20, 2012, at 1735 UTC, a Beech C90A, Brazilian registration PP-WCA, was destroyed when it impacted the ground shortly after takeoff from Comandante Rolim Adolfo Amaro State Airport (SBJD), Jundiaí, Brazil. The pilot was fatally injured. Visual…Apr 20, 2012 · PP-WCA · Substantial damageNTSB ERA12LA299Accident · No injuriesLimited investigationFinal reportCessna 210 · Gatlinburg, TNFailure of the nose landing gear down pressure hose, which resulted in the main landing gear being unable to lock and collapse of the main landing gear during the landing roll.Apr 19, 2012 · N96050 · Substantial damageNTSB ERA12LA282Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Farmington, CTThe pilot's inadequate compensation for wind during a high-power, low-speed downwind turn, which resulted in a loss of control due to loss of tail rotor effectiveness and settling with power. Contributing to the accident was the pilot’s decision to land…Apr 14, 2012 · N1152W · Substantial damageNTSB ERA12LA279Accident · Minor injuriesLimited investigationFinal reportStanley B E Murphy Rebel · Falmouth, MAThe pilot's delayed application of carburetor heat, which resulted in a loss of engine power.Apr 13, 2012 · N24V · Substantial damageNTSB WPR12CA163Accident · No injuriesData collectionFinal reportAvian Balloon Magnum IX · Sedona, AZThe pilot did not maintain adequate clearance during approach for landing between his basket and the envelope of another balloon that was also on approach, which resulted in a midair collision.Apr 10, 2012 · N2037U · 2 aircraft · Substantial damageNTSB WPR12LA160Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Kent, WAThe pilot’s failure to maintain airplane control while maneuvering in the traffic pattern, which resulted in a collision with trees.Apr 7, 2012 · N6616S · Substantial damageNTSB WPR12CA157Accident · No injuriesData collectionFinal reportFisher HP-14 Sailplane · Nampa, IDThe pilot’s incorrect positioning of the wing flaps during the landing approach, which resulted in a loss of lift and hard landing.Apr 6, 2012 · N990 · Substantial damageNTSB CEN12LA228Accident · Minor injuriesLimited investigationFinal reportEnstrom 280FX · Corpus Christi, TXThe failure of the bolt that retained the clutch drive rod end, which resulted in a loss of main rotor drive and a subsequent hard landing.Apr 3, 2012 · N3042D · Substantial damageNTSB DCA12WA066Accident · No injuriesForeign investigationBoeing 777 - 206 · Tokyo, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a Boeing 777-246ER that occurred on March 31, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of ICAO…Mar 31, 2012 · JA701J · Substantial damageNTSB ANC12FA028Accident · 2 fatalField investigationFinal reportPiper PA-18 · Sleetmute, AKOperation of the airplane by a non-certificated pilot and his failure to maintain adequate airspeed and airplane control, which resulted in an aerodynamic stall.Mar 31, 2012 · N7276D · Substantial damageNTSB CEN12LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Arcola, TXA total loss of engine power during landing approach for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Mar 30, 2012 · N800KA · Substantial damageNTSB CEN12FA210Accident · 1 fatalField investigationFinal reportBeech E-55 · Broken Bow, NEThe pilot’s failure to maintain airspeed and subsequent loss of airplane control during a single-engine landing approach. Contributing to the accident was the pilot's improper fuel management during cruise flight, which resulted in an initial loss of power in…Mar 28, 2012 · N1567W · Substantial damageNTSB ERA12FA256Accident · 1 fatalField investigationFinal reportAnderson John H Avid Flyer MK 4 · Waxhaw, NCThe pilot's failure to maintain adequate airspeed during an attempted go-around, which resulted in a low-altitude aerodynamic stall.Mar 26, 2012 · N61410 · Substantial damageNTSB ERA12CA254Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2007 · Groveland, FLThe pilot's failure to maintain directional control during a go-around maneuver in gusty crosswind conditions.Mar 25, 2012 · N2570C · Substantial damageNTSB ERA12LA273Accident · No injuriesLimited investigationFinal reportCessna T337B · Dothan, ALThe failure of the landing gear to extend and lock, despite troubleshooting attempts using normal and emergency procedures. The reason for the failure could not be determined because the systems were unavailable for testing.Mar 24, 2012 · N2334S · Substantial damageNTSB ERA12LA252Accident · No injuriesLimited investigationFinal reportNew Kolb Mark III Classic · Deland, FLThe pilot's lack of preflight planning for potential carburetor icing conditions, and the subsequent flight in those conditions in an airplane not equipped with carburetor heat.Mar 24, 2012 · N528DJ · Substantial damageNTSB CEN12CA202Accident · No injuriesData collectionFinal reportSmith Aerostar 601P · Casterville, TXThe pilot did not maintain control of the airplane while circling to land.Mar 24, 2012 · N602BV · Substantial damageNTSB ERA12LA246Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Beaver Falls, PAThe operator’s maintenance personnel’s improper adjustment of the engine's fuel system, which resulted in a total loss of engine power.Mar 23, 2012 · N166SE · Substantial damageNTSB ERA12WA243Accident · 1 fatalForeign investigationBell 407 · Podnovye, RussiaOn March 22, 2012, about 0615 coordinated universal time, a Bell 407, Russian registration RA-01931, was substantially damaged when it impacted electrical utility wires and the Volga River while on approach to a private landing area near Podnovye, Russia. The…Mar 22, 2012 · RA-01931 · Substantial damageNTSB ERA12CA248Accident · No injuriesData collectionFinal reportJDT MiniMax · Gap, PAThe student pilot's failure to maintain airspeed during a go-around, resulting in an aerodynamic stall.Mar 21, 2012 · UNREG · Substantial damageNTSB CEN12LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Pinconning, MIThe pilot's failure to properly align his airplane with the runway during final approach. Contributing to the accident was the sunglare that obscured the pilot's view of the runway.Mar 21, 2012 · N2389P · Substantial damageNTSB ERA12LA233Accident · Serious injuriesLimited investigationFinal reportBoehlke Kevin P 2/3 Scale Jenny · Hannacroix, NYThe non-certificated pilot's improper high-speed taxi test, which resulted in a loss of control and the pilot's subsequent decision to take off to avoid trees. Also causal, was an in-flight magneto failure, which resulted in a partial loss of engine power.…Mar 18, 2012 · N987KB · Substantial damageNTSB ERA12CA244Accident · No injuriesData collectionFinal reportMooney M20M · Clearwater, FLThe pilot’s failure to extend the landing gear before landing due to his distraction regarding another airplane in the traffic pattern.Mar 18, 2012 · N9140M · Substantial damageNTSB WPR12LA138Accident · Minor injuriesLimited investigationFinal reportRaven Industries S-66A · Avra Valley, AZThe pilot's improper decision to partially open the balloon's vent before clearing a power line while landing, which resulted in the balloon descending too soon and contacting the power line.Mar 16, 2012 · N57194 · Substantial damageNTSB WPR12LA140Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Palo Alto, CAThe pilot's improper use of the throttle grip, which resulted in the deactivation of the rpm governor and a loss of rotor rpm.Mar 15, 2012 · N290SH · Substantial damageNTSB DCA12FA051Accident · 2 fatalClass 1 · FieldFinal reportConvair 440 - NO Series · San Juan, PRthe flight crew's failure to maintain adequate airspeed after shutting down the right engine due to an in-flight fire in one of the right augmentors. The failure to maintain airspeed resulted in either an aerodynamic stall or a loss of directional control.Mar 15, 2012 · N153JR · DestroyedNTSB WPR12CA129Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Santa Clarita, CAThe pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain. Contributing to the accident was the pilot's decision to land with a tailwind.Mar 12, 2012 · N4143C · Substantial damageNTSB CEN12CA183Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Fort Collins, COThe pilot did not maintain adequate airspeed and airplane control during the go-around, which resulted in the airplane impacting trees.Mar 8, 2012 · N2986P · Substantial damageNTSB DCA12PA049Accident · 1 fatalFinal reportIsrael Aircraft Industries F21-C2 · Fallon, NVfuel exhaustion following missed approaches due to deficient ATC handling under weather conditions which were significantly lower than forecast. The second missed approach may have been initiated due to limited pilot instrument proficiency. Contributing to…Mar 6, 2012 · N404AX · DestroyedNTSB CEN12LA179Accident · 1 fatalLimited investigationFinal reportSkeeter 1M · Oklahoma City, OKThe pilot's failure to maintain airplane control while on final approach as he was executing a turn to provide spacing between his airplane and an airplane on the runway.Mar 3, 2012 · N1111V · Substantial damageNTSB ERA12CA204Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCAA · Bedminster, NJThe pilot receiving instruction’s inadvertent movement of the pitch trim control to the nose-down position while attempting a go-around.Mar 2, 2012 · N518F · Substantial damageNTSB ERA12CA198Accident · No injuriesData collectionFinal reportLester Robert E KR-2 · Boca Raton, FLThe failure of the airplane’s engine air inlet system resulting in a total loss of engine power.Mar 1, 2012 · N1701L · Substantial damageNTSB ERA12FA196Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Melbourne, FLThe pilot's abrupt maneuver in response to a perceived traffic conflict, which resulted in an accelerated stall and a loss of airplane control at low altitude. Contributing to the accident was the air traffic controller's incomplete instructions, which…Feb 29, 2012 · N544SR · Substantial damageNTSB DCA12FA046Accident · Serious injuriesField investigationFinal reportAirbus A321 · Millville, NJan encounter with convective turbulence that resulted in injury to a passenger who was not seated when the seatbelt sign was illuminated.Feb 24, 2012 · N162UW · No damageNTSB CEN12LA169Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Cypress, TXThe pilot's improper preflight planning/preparation and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion during the approach to the destination airport.Feb 24, 2012 · N99EZ · Substantial damageNTSB CEN12LA166Accident · Serious injuriesLimited investigationFinal reportBoeing 737-832 · Detroit, MIAn in-flight encounter with forecasted turbulence, which resulted in a serious injury to a flight attendant. Contributing to the accident was the flight attendant not being seated with her seatbelt fastened when the encounter occurred.Feb 19, 2012 · N374DA · No damageNTSB CEN12FA161Accident · 2 fatalField investigationFinal reportCessna 414A · Hayden, COThe pilot’s inadvertent stall during a missed approach. Contributing to the accident was the pilot’s operation of the airplane in forecasted icing conditions without using all of its anti-ice systems.Feb 19, 2012 · N4772A · Substantial damageNTSB ERA12CA190Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Swainsboro, GAThe pilot’s failure to maintain the proper glidepath during final approach in night visual meteorological conditions, which resulted in a collision with trees.Feb 18, 2012 · N47863 · Substantial damageNTSB WPR12CA173Accident · No injuriesData collectionFinal reportLindstrand LBL180A · Temecula, CAThe pilot failed to see and avoid a set of power lines while maneuvering to a landing site.Feb 17, 2012 · N49CD · Substantial damageNTSB ERA12LA186Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Jasper, GAThe pilots' inadequate preflight inspection that failed to detect water-contaminated fuel, which resulted in a total loss of engine power.Feb 17, 2012 · N60276 · Substantial damageNTSB CEN12CA165Accident · No injuriesData collectionFinal reportBeech 95-B55 · Lancaster, WIThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Feb 17, 2012 · N4624A · Substantial damageNTSB ERA12FA175Accident · 1 fatalField investigationFinal reportCessna T182T · Lebanon, NHThe pilot’s failure to maintain airspeed during a return to the airport after takeoff, which resulted in an aerodynamic stall and loss of airplane control.Feb 9, 2012 · N6062E · Substantial damage