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 CEN18WA169Accident · 2 fatalForeign investigationCessna 208B · Clonbullogue, IrelandMay 13, 2018 · G-KNYS · DestroyedNTSB WPR18WA281Accident · No injuriesForeign investigationZenith CH610 HD · Germiston, South AfricaOn May 12, 2018, about 0730 Universal Coordinated time, a Zenith Zodiac CH 610 HD airplane, ZU-FFA, touched down and overturned about 100 meters short of runway 11 at Rand Airport, Germiston, South Africa, following a loss of engine power. The pilot sustained…May 12, 2018 · ZU-FFA · Substantial damageNTSB CEN18LA165Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-200 · Valparaiso, INThe pilot receiving instruction’s failure to maintain a safe operating airspeed, which resulted in a loss of airplane control. Contributing to the accident was the flight instructor's failure to monitor the pilot's airspeed control.May 8, 2018 · N99GN · Substantial damageNTSB ERA18LA145Accident · No injuriesLimited investigationFinal reportPiper PA28 · Vero Beach, FLWater contamination of the fuel supply, which resulted in a total loss of engine power.May 7, 2018 · N80813 · Substantial damageNTSB GAA18CA263Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1 26 · Springfield, VTThe pilot’s inability to maintain sufficient altitude after the glider encountered downdrafts during the approach, which resulted in the glider striking trees.May 5, 2018 · N17909 · Substantial damageNTSB DCA18WA173Incident · No injuriesForeign investigationBoeing 767 323 · Guayaquil, EcuadorThe government of Ecuador has notified the NTSB of an incident involving a BOEING 767 323 airplane that occurred on May 03, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…May 3, 2018 · N396AN · No damageNTSB GAA18CA243Accident · No injuriesData collectionFinal reportCessna 310 · Gainesville, FLThe pilot’s failure to maintain an adequate approach path at night, which resulted in a tree strike.Apr 30, 2018 · N2212A · Substantial damageNTSB CEN18WA399Accident · Minor injuriesForeign investigationCessna 172 · Hamilton, BermudaOn April 30, 2018, about 2045 universal coordinated time (UTC), a Cessna 172 M airplane, N9085H, was substantially damaged during a landing at the L. F. Wade International Airport, near Hamilton, Bermuda. The pilot sustained minor injuries.The accident…Apr 30, 2018 · N9085H · Substantial damageNTSB GAA18CA244Accident · No injuriesData collectionFinal reportLuscombe 8 · Eunice, LAThe pilot’s failure to maintain clearance from a tree while on approach to land.Apr 28, 2018 · N71261 · Substantial damageNTSB GAA18CA234Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to relinquish flight controls and premature flap reduction during approach to land.Apr 25, 2018 · N922PA · Substantial damageNTSB GAA18CA220Accident · No injuriesData collectionFinal reportPiper PA 22 · Shelby, MTThe pilot’s improper use of the fuel selector, which resulted in fuel starvation to the engine and an off-runway landing.Apr 19, 2018 · N1283C · Substantial damageNTSB CEN18FA144Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Williamsburg, PAThe pilot's failure to obtain an updated weather briefing before the flight and his subsequent loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions during a diversion to an alternate airport after…Apr 19, 2018 · N451TD · DestroyedNTSB WPR18LA121Accident · Minor injuriesClass 3 · LimitedFinal reportAirborne Windsports PTY XT-912-L · Peoria, AZAn inflight loss of control due to failure of the weight-shift-control aircraft's wing assembly.Apr 15, 2018 · N107PW · Substantial damageNTSB CEN18WA141Accident · 2 fatalForeign investigationCirrus SR20 · Adolf Wurth Airport, GermanyOn April 15, 2018, at 1300 UTC, a Cirrus SR-20, D-EWTG, and a Dallach D4b Fascination, D-MJEK, encountered a midair collision under unknown circumstances near Adolf Würth Airport (EDTY), Schwäbisch Hall, Germany. Both aircraft were destroyed; and the pilots,…Apr 15, 2018 · D-EWTG · 2 aircraft · DestroyedNTSB GAA18CA215Accident · No injuriesData collectionFinal reportPage Russell L Long EZ · Wakefield, VAThe pilot’s failure to secure the canopy before flight, which resulted in the airplane striking a fence during the approach. Contributing to the accident was the pilot’s failure to follow the Before Takeoff checklist and In-flight Canopy Opening checklist…Apr 13, 2018 · N27RP · Substantial damageNTSB CEN18LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA 24 · New Braunfels, TXA partial loss of engine power for reasons that could not be determined based on the available information.Apr 12, 2018 · N7386P · Substantial damageNTSB GAA18CA214Accident · No injuriesData collectionFinal reportCessna 170 · Big Lake, AKThe pilot’s exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Apr 9, 2018 · N4133V · DestroyedNTSB DCA18WA123Accident · No injuriesForeign investigationBoeing 737 · Osaka, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the…Apr 9, 2018 · HL7725 · Substantial damageNTSB GAA18CA193Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe student pilot’s improper selection of the flap setting during a go-around, and the flight instructor’s delayed remedial action, which resulted in an aerodynamic stall.Apr 1, 2018 · N297PA · Substantial damageNTSB WPR18FA116Accident · 2 fatalField investigationFinal reportRagle RV6A · Santa Paula, CAThe pilot's exceedance of the airplane's critical angle of attack while maneuvering in the airport traffic pattern, which resulted in an aerodynamic stall and subsequent spin.Mar 31, 2018 · N820TL · DestroyedNTSB ENG18WA021Incident · No injuriesForeign investigationBoeing 747 · Chek Lap Kok, Hong Kong SAR ChinaThe Hong Kong Civil Aviation Department (HKCAD) has notified the NTSB of an incident involving a Boeing 747-8F airplane which occurred on March 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the HKCAD investigation under the…Mar 29, 2018 · JA18KZ · No damageNTSB CEN18LA123Accident · 1 fatalLimited investigationFinal reportMills Michael S1L · Dewitt, MIThe pilot's failure to see and avoid power lines due to sun glare.Mar 22, 2018 · N197X · Substantial damageNTSB WPR18WA110Accident · 2 fatalForeign investigationEurocopter EC120 · Hardy Reef, Queensland, AustraliaOn March 21, 2018, about 1500 local time, a Eurocopter (Airbus Helicopters) EC120B helicopter, VH-WII, sustained substantial damage when it impacted water during an aborted landing attempt on a floating helicopter landing site (HLS) located between Hardy Reef…Mar 21, 2018 · VH-WII · Substantial damageNTSB CEN18FA126Accident · 1 fatalField investigationFinal reportRans S-16 Shekari · Pierce, NEThe pilot's failure to maintain airspeed during the approach for landing, which resulted in an aerodynamic stall and the airplane's impact with terrain.Mar 21, 2018 · N741WT · Substantial damageNTSB ERA18LA097Accident · Minor injuriesLimited investigationFinal reportReilly Charles W Escapade · Palatka, FLThe interruption of fuel to the engine during final approach, which resulted in a total loss of engine power due to fuel starvation, and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall.Mar 6, 2018 · N45DC · Substantial damageNTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.Mar 6, 2018 · N6764W · Substantial damageNTSB ERA18LA095Accident · 1 fatalLimited investigationFinal reportRobert Snyder Autogyro Calidus · Beaufort, SCThe gyroplane pilot's failure to maintain rotor speed and aircraft control as he was attempting to return to the runway during a low-altitude simulated engine-out maneuver.Mar 5, 2018 · N221YT · Substantial damageNTSB CEN18LA115Accident · No injuriesLimited investigationFinal reportMesserschmitt-Bolkow-Blohm BK 117 B-2 · Sheboygan, WIThe restricted cyclic control movement for reasons that could not be determined because postaccident examination and testing of the cyclic control system did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal…Mar 5, 2018 · N1174U · Substantial damageNTSB ENG18RA018Incident · No injuriesForeign investigationCessna 441 · Broome, Australia, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Cessna 441 which occurred on March 2, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of ICAO…Mar 2, 2018 · VH-LBY · No damageNTSB CEN18LA112Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Mackinac Island, MIThe improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.Feb 26, 2018 · N1722J · Substantial damageNTSB ERA18LA089Accident · 1 fatalClass 2 · LimitedFinal reportAirborne Windsports PTY Edge XT 912 L · Eustis, FLThe pilot's exceedance of the weight-shift-control aircraft's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot's lack of experience in the…Feb 25, 2018 · N98YW · Substantial damageNTSB ERA18LA086Accident · Minor injuriesClass 3 · LimitedFinal reportStearman B75 · Zephryhills, FLThe pilot's inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power and impact with a pole during a forced landing.Feb 23, 2018 · N62438 · Substantial damageNTSB WPR18LA094Accident · Serious injuriesClass 3 · LimitedFinal reportSoko Galeb G 2 · Elko, NVAn improperly installed brake cylinder, which resulted in insufficient hydraulic pressure being provided to three of the brake cylinders and the left brake being inoperable during landing.Feb 21, 2018 · N90SR · Substantial damageNTSB WPR18FA093Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · San Diego, CAThe pilot's exceedance of the airplane's critical angle of attack during an attempted return to the runway following a total loss of engine power after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the excessive amount of…Feb 21, 2018 · N707DF · Substantial damageNTSB ERA18FA084Accident · 1 fatalField investigationFinal reportPiper PA28 · Bonifay, FLA partial loss of engine power due to a stuck exhaust valve. Contributing to the accident was the pilot's decision to operate an airplane with a known mechanical deficiency and his failure to fly an appropriate traffic pattern that would have allowed the…Feb 21, 2018 · N3568K · DestroyedNTSB CEN18FA101Accident · 2 fatalField investigationFinal reportSocata TBM 700 · Evanston, WYThe pilot's loss of control due to spatial disorientation.Feb 18, 2018 · N700VX · DestroyedNTSB CEN18LA117Accident · No injuriesLimited investigationFinal reportBlack Donald Cozy III · Los Lunas, NMThe seizure of the propeller gearbox for reasons that could not be determined based on the available information, which resulted in a forced landing.Feb 17, 2018 · N904DB · Substantial damageNTSB ANC18FA024Accident · 1 fatalField investigationFinal reportMooney M20 · Chuckanut, WAThe pilot's failure to maintain clearance from terrain during a visual approach in dark night visual meteorological conditions, which resulted in controlled flight into terrain.Feb 13, 2018 · N123JN · DestroyedNTSB WPR18MA087Accident · 5 fatalClass 3 · MajorFinal reportEurocopter EC130 · Peach Springs, AZA loss of tail rotor effectiveness, the pilot’s subsequent loss of helicopter control, and collision with terrain during an approach to land in gusting, tailwind conditions in an area of potential downdrafts and turbulence.Feb 11, 2018 · N155GC · DestroyedNTSB GAA18CA123Accident · No injuriesData collectionFinal reportOliver Lawrence R Kitfox IV 1200 · Carson City, NVThe flight instructor’s failure to maintain directional control during the landing roll and lateral control during the go-around in gusting crosswind conditions. Contributing to the accident was the lack of communication between the flight instructor and the…Feb 11, 2018 · N76478 · Substantial damageNTSB CEN18LA095Accident · Serious injuriesLimited investigationFinal reportHenderson Thorp T 18 · Troy, MOThe pilot's failure to maintain adequate clearance from trees while landing in crosswind conditions.Feb 8, 2018 · N600HH · Substantial damageNTSB WPR18LA082Accident · No injuriesClass 3 · LimitedFinal reportBeech 95 · North Las Vegas, NVLoss of aircraft control during an unplanned go-around for reasons that could not be determined based on available information. Contributing to the accident was the delayed remedial action by the flight instructor.Feb 2, 2018 · N128W · Substantial damageNTSB DCA18WA088Incident · No injuriesForeign investigationBoeing 757 23A · Tel Aviv, IsraelThe Israel's Ministry of Transport has notified the NTSB of an incident involving a Boeing 757, which occurred on January 30, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of…Jan 30, 2018 · N919FD · No damageNTSB ERA18LA071Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Meriden, CTThe pilot's inadequate preflight fuel planning and his improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.Jan 27, 2018 · N9673W · Substantial damageNTSB CEN18LA087Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Loveland, COThe airplane pilot’s failure to see and avoid the helicopter while in the traffic pattern, which resulted in a midair collision between the two aircraft. Contributing to the accident was the airplane pilot’s misunderstanding of the helicopter pilot’s…Jan 26, 2018 · N878BC · 2 aircraft · Substantial damageNTSB CEN18LA085Accident · No injuriesLimited investigationFinal reportQuartz Mountain Aerospace L-11E · Omaha, NEThe instructor pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.Jan 24, 2018 · N515BW · Substantial damageNTSB ERA18LA067Accident · No injuriesLimited investigationFinal reportCessna 172RG · Martinsburg, WVA hydraulic leak in the right main landing gear actuator, which resulted in the main landing gear not extending.Jan 21, 2018 · N9415B · Substantial damageNTSB WPR18CA072Accident · Minor injuriesData collectionFinal reportCessna 172P · Cloverdale, CAThe pilot's failure to maintain airplane control during the approach and his delayed decision to go around.Jan 20, 2018 · N64204 · Substantial damageNTSB CEN18LA073Accident · No injuriesLimited investigationFinal reportS.O.C.A.T.A. MS893E · Wadsworth, OHThe pilot’s failure to apply carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.Jan 11, 2018 · N353RA · Substantial damageNTSB CEN18WA067Accident · 1 fatalForeign investigationConstrucciones Aeronauticas C.A.S.A. 1.131 · Alicante, SpainOn December 30, 2017, at 1642 universal time coordinated, a Construcciones Aeronauticas SA C.A.S.A. 1.131 (Bucker BU-131), N1950M (NX-1950M), and a Bell 412SP, EC-MMC, experienced a mid-air collision during final approach for landing to runway 20 at Muchamiel…Dec 30, 2017 · N1950M · 2 aircraft · Substantial damage