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 ERA14CA175Accident · Minor injuriesData collectionFinal reportBeech S35 · Marathon, FLThe pilot's distraction in the cockpit while on a visual approach over water during a dark night resulting in the airplane descending until impact with the water.Mar 30, 2014 · N8985M · Substantial damageNTSB ERA14LA174Accident · 1 fatalLimited investigationFinal reportN/A N/A · Patillas, PRThe pilot’s failure to maintain airplane control during approach for landing, which resulted in a stall/spin.Mar 26, 2014 · UNREG · Substantial damageNTSB ERA14CA171Accident · Serious injuriesData collectionFinal reportCessna 172 · Carlisle, PAThe pilot's decision to depart with a known mechanical malfunction and his improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain during an off-airport landing.Mar 24, 2014 · N4214F · Substantial damageNTSB ERA14CA165Accident · Serious injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Kill Devil Hills, NCThe pilot's failure to maintain control of the airplane during the landing approach in gusty wind conditions.Mar 23, 2014 · N90650 · Substantial damageNTSB ERA14FA162Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Safety Harbor, FLThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's impairment due to cocaine use.Mar 22, 2014 · N8309L · Substantial damageNTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.Mar 22, 2014 · N702H · Substantial damageNTSB ERA14LA161Accident · 1 fatalLimited investigationFinal reportCessna LC41-550FG · Palatka, FLThe pilot’s improper management of the fuel mixture and his failure to use the appropriate checklist and guidance during the flight, which resulted in an overrich mixture condition, carbon-fouling of the spark plugs, and a subsequent total loss of engine…Mar 21, 2014 · N717RR · Substantial damageNTSB CEN14CA170Accident · No injuriesData collectionFinal reportDonald G Stokes Challenger II · Crockett, TXThe pilot's failure to maintain control of the airplane, resulting in a hard landing.Mar 21, 2014 · N284DS · Substantial damageNTSB CEN14LA165Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Wichita Falls, TXThe loss of engine power due to the misrigging of the fuel mixture control.Mar 18, 2014 · N9532Y · Substantial damageNTSB ERA14LA156Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Stuart, FLThe pilot’s improper preflight planning and fuel management, which resulted in a total loss of power in both engines due to fuel exhaustion.Mar 14, 2014 · N419AR · Substantial damageNTSB ERA14FA153Accident · 1 fatalField investigationFinal reportWaters Peter T Avid Bandit · Washington, PAThe pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.Mar 11, 2014 · N62PT · DestroyedNTSB ERA14LA147Accident · Serious injuriesLimited investigationFinal reportCessna 172D · Fairhope, ALThe pilot’s failure to maintain adequate separation from a helicopter during the approach to landing, which resulted in an encounter with the helicopter’s trailing vortices, a loss of airplane control, and impact with terrain.Mar 8, 2014 · N2755U · DestroyedNTSB ERA14LA146Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Mulberry, FLThe failure of the pilot and the parachutist to see and avoid each other, which resulted in the airplane’s wing colliding with the parachute’s suspension lines.Mar 8, 2014 · N211R · Substantial damageNTSB WPR14LA153Accident · No injuriesLimited investigationFinal reportZenair CH2T · Woodland, CAA total loss of engine power during approach due to carburetor icing, which resulted in an off-airport landing into trees.Mar 6, 2014 · N285AM · Substantial damageNTSB WPR14FA127Accident · 1 fatalField investigationFinal reportPiper PA 46 350P · Truckee, CAThe pilot’s failure to properly execute the missed approach in instrument conditions. Contributing to the accident were the pilot’s lack of instrument proficiency, as demonstrated by his failure to execute the required procedure turn to align with the final…Mar 3, 2014 · N9281F · Substantial damageNTSB WPR14CA129Accident · No injuriesData collectionFinal reportPartenavia P 68 Observer · Molokai, HIThe pilot's inadequate decision to continue an unstable approach in dark night conditions, which resulted in a collision with trees and hard landing.Feb 28, 2014 · N947MZ · Substantial damageNTSB WPR14LA123Accident · No injuriesLimited investigationFinal reportLake LA 4 200 · Corona, CAThe loss of engine power during initial climb for reasons that could not be determined because a postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Feb 25, 2014 · N1040L · Substantial damageNTSB WPR14LA119Accident · 1 fatalLimited investigationFinal reportSabrena Dragonfly · Maricopa, AZThe pilot’s failure to maintain control of the airplane while maneuvering, which resulted in the airplane exceeding its critical angle of attack and subsequently experiencing an aerodynamic stall and spin at a low altitude.Feb 24, 2014 · N7745C · Substantial damageNTSB ERA14FA128Accident · 3 fatalField investigationFinal reportBeech 95-B55 · LaGrange, GAThe pilot's overreaction to a perceived conflict with a tow plane and glider on an intersecting runway, which resulted in a loss of control during an attempted aborted landing. Contributing to the accident was the failure of the glider tow operator to follow…Feb 22, 2014 · N36638 · DestroyedNTSB CEN14FA145Accident · 1 fatalField investigationFinal reportBeech B100 · Pearland, TXThe noninstrument-rated pilot's loss of airplane control during a missed instrument approach. Contributing to the accident was the pilot's decision to file an instrument flight rules flight plan and to fly into known instrument meteorological conditions.Feb 19, 2014 · N811BL · DestroyedNTSB ERA14FA120Accident · 2 fatalField investigationFinal reportCessna 210L · Clay, ALThe pilot's failure to maintain control of the airplane while being vectored to intercept the localizer during night instrument meteorological conditions (IMC). Contributing to the accident was the operator's inadequate dispatch procedures, which did not…Feb 15, 2014 · N732EJ · DestroyedNTSB ERA14CA124Accident · No injuriesData collectionFinal reportCessna 172S · Mansfield, MAThe student pilot's failure to maintain an adequate approach glide path, which resulted in a collision with a snow bank.Feb 15, 2014 · N2143X · Substantial damageNTSB ERA14WA125Accident · 3 fatalForeign investigationCessna 210N · Palmas, BrazilOn February 9, 2014, about 1330 universal coordinated time, a Cessna 210N, Brazilian registration PT-OMX, operated by a private individual, was substantially damaged after it experienced a loss of engine power and impacted terrain while on approach to the…Feb 9, 2014 · PT-OMX · Substantial damageNTSB CEN14LA133Accident · No injuriesLimited investigationFinal reportCessna 182A · Lexington, TXThe pilot’s improper use of the carburetor heat, which resulted in a total loss of engine power due to carburetor icing.Feb 9, 2014 · N6061B · Substantial damageNTSB CEN14LA129Accident · No injuriesLimited investigationFinal reportCessna 525 · Elk City, OKThe pilot’s descent below the published minimum descent altitude for the instrument approach procedure, which resulted in impact with a utility pole.Feb 4, 2014 · N61YP · Substantial damageNTSB ERA14FA112Accident · 4 fatalField investigationFinal reportGulfstream AM Corp Comm Div 690 · Bellevue, TNThe pilot's failure to maintain airspeed with one engine inoperative, which resulted in a loss of control while on approach. Contributing to the accident were airframe ice accumulation due to conditions conducive to icing and the loss of engine power on one…Feb 3, 2014 · N840V · DestroyedNTSB DCA14WA179Accident · 3 fatalForeign investigationBeech C90 · Lanseria, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Beech C90-GTI airplane that occurred on February 03, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA investigation under the…Feb 3, 2014 · ZS-CLT · DestroyedNTSB WPR14CA110Accident · Minor injuriesData collectionFinal reportBeech V35A · Globe, AZThe pilot's inadequate glide path and failure to maintain adequate airspeed during final approach, which resulted in an aerodynamic stall.Feb 1, 2014 · N31TC · Substantial damageNTSB ERA14WA114Accident · 2 fatalForeign investigationCessna 140 · Cachoeira do Sul, BrazilOn January 29, 2014, about 1340 universal coordinated time, a Cessna 140, Brazilian registration PP-DFW, was substantially damaged during impact with terrain, following a loss of control on approach to Cachoeira do Sul Airport (SSKS), Cachoeira do Sul, Rio…Jan 29, 2014 · PP-DFW · Substantial damageNTSB CEN14LA134Accident · No injuriesLimited investigationFinal reportCessna 172K · Milan, ILThe 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 a short final approach.Jan 26, 2014 · N4VN · Substantial damageNTSB CEN14CA123Accident · Minor injuriesData collectionFinal reportCessna 172N · Boulder, COThe pilot's failure to maintain airplane control during final approach with known turbulence present.Jan 25, 2014 · N738LQ · Substantial damageNTSB ERA14LA099Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Pell City, ALThe pilot’s use of an improper clutch engagement procedure, which resulted in clutch glazing, slippage, and, ultimately, the in-flight disengagement of the clutch and a loss of rotor rpm. Contributing to the accident were the installation of a light-weight…Jan 21, 2014 · N93067 · Substantial damageNTSB DCA14WA042Incident · No injuriesForeign investigationBoeing 767 332 · Buenos Aires, ArgentinaThe Direccion Nacional de Aviacion Civil e Infraestructura Aeronautica (DINACIA) has notified the NTSB of an incident involving Boeing 767-300, which occurred on January 21, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DINACIA…Jan 21, 2014 · N191DN · Minor damageNTSB WPR14WA108Accident · 4 fatalForeign investigationPiper PA31 - 350 · Maluku, Indonesia, IndonesiaOn January 19, 2014, at 1220 local time, a Piper PA-31-350, PK-IWT, collided with terrain under unknown circumstances while on approach to Dumatubun Airport, Maluku, Indonesia. The pilot and three passengers were fatally injured and the airplane was…Jan 19, 2014 · PK-IWT · DestroyedNTSB CEN14FA110Accident · 1 fatalField investigationFinal reportCessna 310R · Waterford, MIThe pilot's controlled flight into terrain during an instrument landing system approach at night in instrument flight rules conditions. Contributing to the accident were the operator's inadequate training of the pilot, the operator's failure to provide a…Jan 11, 2014 · N3829G · DestroyedNTSB ERA14LA086Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Buckhannon, WVThe pilot’s improper in-flight fuel mixture management and failure to use the appropriate checklist or manuals during approach to landing, which resulted in a loss of engine power.Jan 4, 2014 · N450TX · Substantial damageNTSB CEN14LA094Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Gladewater, TXThe loss of engine power due to carburetor icing.Dec 28, 2013 · N6905G · Substantial damageNTSB ERA14LA076Accident · Serious injuriesLimited investigationFinal reportCessna 210N · Tampa, FLA total loss of engine power due to the fatigue failure of the No. 4 connecting rod. Contributing to the accident was a likely loss of lubrication for reasons that could not be determined during a postaccident engine examination.Dec 20, 2013 · N5307A · Substantial damageNTSB ERA14FA075Accident · 1 fatalField investigationFinal reportBeech A36TC · Chatlottesville, VAThe pilot’s failure to position the fuel selector handle in a fuel tank detent, which resulted in a total loss of engine power due to fuel starvation. Contributing to the pilot’s fatal injuries was the separation of his shoulder harness due to overload in an…Dec 18, 2013 · N3705Z · Substantial damageNTSB ERA14FA073Accident · 2 fatalField investigationFinal reportRaytheon 390 · Atlanta, GAThe pilot's failure to maintain airplane control while maneuvering the airplane in the traffic pattern at night. Contributing to the accident was the pilot's impairment from the use of illicit drugs.Dec 18, 2013 · N50PM · DestroyedNTSB ERA14FA068Accident · 3 fatalField investigationFinal reportCessna 310R · Jacksonville, FLThe pilot’s failure to maintain airplane control during a missed approach in night instrument meteorological conditions due to spatial disorientation and a lack of instrument proficiency.Dec 8, 2013 · N98BT · DestroyedNTSB CEN14WA180Accident · No injuriesForeign investigationChristen Industries Pitts S-2B · Meaux-Esbly, FranceOn December 8, 2013, at 1607 coordinated universal time, a Pitts S-2B airplane, F-GEAL, experienced a loss of engine power and conducted a force landing near Meaux-Esbly, France. The pilot and passenger were not injured. The airplane was substantially…Dec 8, 2013 · F-GEAL · Substantial damageNTSB ERA14LA059Accident · Minor injuriesLimited investigationFinal reportMoffitt Oscar/ Kit Prostar A/C PT2 · Trenton, SCThe airplane owner/pilot ‘s failure to follow the gascolator manufacturer’s recommendations for installing and safety wiring the gascolator strainer bowl, which resulted in the bowl separating and a total loss of engine power due to fuel starvation.Dec 2, 2013 · N355PT · Substantial damageNTSB ANC14MA008Accident · 5 fatalMajor investigationFinal reportCessna 208B · Saint Marys, AKThe pilot's decision to initiate a visual flight rules approach into an area of instrument meteorological conditions at night and the flight coordinators' release of the flight without discussing the risks with the pilot, which resulted in the pilot…Nov 30, 2013 · N12373 · Substantial damageNTSB WPR14LA059Accident · No injuriesLimited investigationFinal reportCessna 210 · Florence, ORThe failure of the hydraulic power pack, which prevented the extension of the landing gear and resulted in a partial gear-up landing.Nov 29, 2013 · N6575X · Substantial damageNTSB ERA14LA052Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Trussville, ALThe failure of the No. 2 connecting rod due to oil starvation, which resulted in a total loss of engine power.Nov 28, 2013 · N5655D · Substantial damageNTSB ANC14LA007Accident · No injuriesLimited investigationFinal reportBeech 1900C · Deadhorse, AKThe captain’s decision to initiate a visual flight rules approach and attempted landing into an area of instrument meteorological conditions, which resulted in the airplane touching down short of the runway. Contributing to the accident was the operator’s…Nov 22, 2013 · N575X · Substantial damageNTSB ERA14WA047Accident · 1 fatalForeign investigationRobinson R66 · Rio de Janeiro, BrazilNov 20, 2013 · PR-MXM · Substantial damageNTSB ERA14FA044Accident · 1 fatalField investigationFinal reportFocke-Wulf FWP 149D · Kenansville, NCThe pilot’s loss of control in instrument meteorological conditions for reasons that could not be determined because examination of the airframe and engine revealed no anomalies that would have precluded normal operation. Contributing to the accident was the…Nov 17, 2013 · N132FW · DestroyedNTSB DCA14RA012Accident · 50 fatalForeign investigationBoeing 737 - 500 · Kazan, RussiaThe Russian Interstate Aviation Committee, Accident Investigation Commission (IAC) has notified the NTSB of an accident involving a Boeing 737-500 that occurred on November 17, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the IAC…Nov 17, 2013 · VQ-BBN · Destroyed