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 GAA16CA244Accident · Minor injuriesData collectionFinal reportSchleicher ASW 19 · Frankton, INThe pilot's exceedance of the critical angle of attack on final approach in turbulent conditions, which resulted in an aerodynamic stall and collision with terrain.May 15, 2016 · N19VT · Substantial damageNTSB DCA16CA153Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320 214 · Philadelphia, PAan inadvertent encounter with clear air turbulence that resulted in a serious injury to a flight attendant.May 14, 2016 · N103US · No damageNTSB WPR16LA110Accident · Minor injuriesLimited investigationFinal reportSeguin Quickie · Mojave, CAA loss of engine power for reasons that could not be determined based on the available information.May 13, 2016 · N68TQ · DestroyedNTSB ERA16LA179Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12 D · Critz, VAThe pilot’s failure to maintain airspeed while on final approach, which resulted in an exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.May 7, 2016 · N43363 · Substantial damageNTSB ANC16LA022Accident · Serious injuriesLimited investigationFinal reportAirbus AS350 · Juneau, AKThe pilot's failure to maintain terrain clearance while on approach to land in flat light conditions. Contributing to the severity of the pilot's injuries was the inadequately restrained internal cargo, which shifted forward during the impact and struck the…May 5, 2016 · N194EH · Substantial damageNTSB GAA16CA212Accident · No injuriesData collectionFinal reportCessna 140 · Poplar Grove, ILThe pilot's visual disorientation and failure to monitor the altimeter during a night approach, which resulted in controlled flight into terrain.Apr 30, 2016 · N4242H · Substantial damageNTSB CEN16LA170Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine 582 · Fortville, INThe collapse of the powered parachute's canopy for a reason that could not be determined, because postaccident examination revealed no anomalies with the parachute.Apr 29, 2016 · N9447T · Substantial damageNTSB DCA16WA143Accident · No injuriesForeign investigationRobinson R44 · Pretoria, South AfricaThe South African CAA has notified the NTSB of an accident involving a Robinson R44 helicopter and Aeroprakt A-22 Foxbat ultralight that occurred on April 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation…Apr 27, 2016 · ZS-RXD · 2 aircraft · Substantial damageNTSB WPR16LA096Accident · No injuriesLimited investigationFinal reportDG Flugzeugbau DG 800B · Clements, CAThe motorglider pilot's decision to perform an in-flight engine start with insufficient altitude, which resulted in an off-airport landing and collision with trees after the engine did not start. Contributing to the accident was the pilot's distraction by the…Apr 25, 2016 · N800YG · Substantial damageNTSB ERA16FA168Accident · 1 fatalField investigationFinal reportRyskamp Bruce A Acroduster · Belton, SCA loss of engine power for reasons that could not be determined due to extensive postcrash fire damage. Also causal was the pilot's loss of airplane control, resulting in an aerodynamic stall and subsequent impact with terrain.Apr 24, 2016 · N380JA · DestroyedNTSB GAA16CA201Accident · Minor injuriesData collectionFinal reportHelicycle/Morrisey RR RM-1 · Denver, COThe pilot's failure to maintain control of the helicopter yaw while operating in conditions conducive to loss of tail rotor effectiveness, resulting in an uncommanded rapid right yaw and ground impact.Apr 22, 2016 · N867TV · Substantial damageNTSB CEN16LA163Accident · Minor injuriesLimited investigationFinal reportCessna 162 · Zionsville, INThe flight instructor’s improper decision to depart on a local instructional flight in rapidly deteriorating weather conditions, including thunderstorms and hail, which resulted in subsequent impact with terrain during a go-around.Apr 21, 2016 · N5217S · Substantial damageNTSB CEN16FA158Accident · 2 fatalField investigationFinal reportBeech 65 A90 1 · Slidell, LAThe unstable approach in black-hole conditions, resulting in the airplane overshooting the runway extended centerline and descending well below a safe glidepath for the runway. Contributing to the accident was the lack of monitoring by the copilot allowing…Apr 20, 2016 · N7MC · DestroyedNTSB ERA16FA165Accident · 2 fatalField investigationFinal reportVans RV12 · Stevensville, MDThe pilot's failure to maintain airplane control during approach for landing in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.Apr 19, 2016 · N276VA · Substantial damageNTSB WPR16LA093Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Avalon, CAThe pilot's failure to maintain a proper approach path on landing because he failed to familiarize himself with the airport's unique approach hazards and recommended procedures before the flight. Also causal was the pilot's failure to recognize the airplane's…Apr 17, 2016 · N7133G · DestroyedNTSB DCA16WA131Accident · 12 fatalForeign investigationBritten Norman BN2 · Kiunga, Papua New GuineaThe government of Papua New Guinea has notified the NTSB of an accident involving a BRITTEN NORMAN BN2 airplane that occurred on April 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Papua New Guinea's…Apr 13, 2016 · P2-SBC · DestroyedNTSB ERA16LA148Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Hilton Head Island, SCThe pilot's failure to apply carburetor heat following a loss of engine power due to carburetor icing.Apr 6, 2016 · N466CT · Substantial damageNTSB CEN16RA136Accident · 7 fatalForeign investigationMitsubishi MU 2B · Iles-de-la-Madeleine, CanadaimportMar 29, 2016 · N246W · Substantial damageNTSB CEN16LA137Accident · Serious injuriesLimited investigationFinal reportMatthews H Thomas Jodel F11 A · Marathon, TXThe pilot's failure to conduct a go-around in a timely manner, which resulted in impact with trees and a powerline.Mar 26, 2016 · N3068M · Substantial damageNTSB CEN16LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA24 · Kentland, INThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that would have precluded normal operation. Contributing to the accident was the flight…Mar 26, 2016 · N8154P · Substantial damageNTSB ANC16WA016Accident · 4 fatalForeign investigationMooney M20C · Yao, JapanOn March 26, 2016 , about 1618 Local Time, a Mooney M20C airplane, Japan registration number JA3788, operated by the pilot, was destroyed by post crash fire following a loss of control while attempting a go-around at the Yao Airport, Osaka Prefecture. The…Mar 26, 2016 · JA3788 · DestroyedNTSB DCA16WA235Accident · No injuriesForeign investigationCessna T210H · Hoedspruit, Limpopo Province, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Cessna T210H airplane that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the SACAA's investigation under the…Mar 25, 2016 · ZS-DOM · Substantial damageNTSB DCA16WA110Incident · No injuriesForeign investigationEmbraer ERJ 190 100 IGW · Nassau, BahamasThe Bahamas Department of Civil Aviation's Air Accident Investigation & Prevention Unit (AAIPU) has notified the NTSB of an incident involving an Embraer EMB 190 that occurred on March 25, 2016. The NTSB has appointed a U.S. Accredited Representative to…Mar 25, 2016 · N273JB · Minor damageNTSB CEN16LA143Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Alexandria, LAThe partial loss of engine power for reasons that could not be determined based on the available information.Mar 23, 2016 · N927DS · Substantial damageNTSB GAA16CA157Accident · No injuriesData collectionFinal reportCessna 172 · Nashville, TNThe pilot's excessive pitch up and incorrect action of selecting flaps to zero degrees, which resulted in a tail strike during a go-around in crosswind conditions.Mar 20, 2016 · N118ET · Substantial damageNTSB ERA16WA206Accident · No injuriesForeign investigationCessna 150 · Daule, EcuadorOn March 20, 2016, at 1730 Universal Coordinated Time (UTC), a Cessna 150L, Ecuadorian registration HC-CJS, operated by Sky Ecuador, received substantial damage following a loss of engine power and forced landing in a rice field near Daule, Ecuador. The…Mar 20, 2016 · HC-CJS · Substantial damageNTSB DCA16RA108Accident · 62 fatalForeign investigationBoeing 737 · Rostov-on-Don, RussiaThe Russian Interstate Aviation Committee (MAK) has notified the NTSB of an accident involving a BOEING 737 that occurred on March 19, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the MAK investigation under the provisions of ICAO…Mar 19, 2016 · A6-FDN · DestroyedNTSB CEN16LA129Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Wichita, KSThe total loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel management.Mar 18, 2016 · N9262M · Substantial damageNTSB ENG16RA011Incident · No injuriesForeign investigationAirbus A320 · Mexico City, MexicoThe Dirección General de Aviación Civil of Mexico has notified the NTSB of an accident involving a AIRBUS A320-233 that occurred on March 13, 2016. The NTSB has designated a U.S. Accredited Representative to assist the DGAC investigation under the provisions…Mar 13, 2016 · XA-VLD · No damageNTSB CEN16FA122Accident · 2 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Española, NMThe pilot's failure to maintain adequate airspeed while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low altitude.Mar 11, 2016 · N28GX · DestroyedNTSB ERA16LA137Accident · No injuriesLimited investigationFinal reportBeech 99 · Rockland, METhe airplane’s encounter with isolated severe turbulence, which resulted in substantial airframe damage.Mar 2, 2016 · N198WA · Substantial damageNTSB CEN16FA111Accident · 4 fatalField investigationFinal reportCirrus Design SR20 · Navasota, TXThe flight instructor's delayed remedial action to prevent a stall at an altitude that was too low to recover. Contributing to the accident was the owner/non-certificated pilot's failure to maintain control of the airplane, which resulted in an accelerated…Feb 28, 2016 · N477TC · Substantial damageNTSB ERA16LA111Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pembroke Pines, FLThe loss of engine power while on approach for reasons that could not be determined based on the available evidence.Feb 24, 2016 · N6449P · Substantial damageNTSB GAA16LA135Accident · No injuriesLimited investigationFinal reportPinkston Randy T RV-7 · Tavernier, FLThe pilot's misidentification of a parallel roadway for the runway and the airplane's subsequent collision with numerous objects during landing.Feb 18, 2016 · N705RP · Substantial damageNTSB ANC16WA070Accident · No injuriesForeign investigationPiper PA-28-140 · St Andrews, CanadaOn February 13, 2016, about 2039 Coordinated Universal Time (UTC), a Piper PA-28-140 airplane, (Canadian Registration C-GQPN) was on approach to St. Andrews, MB (CYAV) with an instructor and a student on board. Prior to touch down at approximately 50 feet…Feb 13, 2016 · C-GQPN · No damageNTSB GAA16LA128Accident · Serious injuriesLimited investigationFinal reportPiper PA24 · Sturgis, SDThe pilot's failure to execute the published missed approach procedure in a timely manner, which resulted in collision with a light pole and subsequent impact with terrain.Feb 12, 2016 · N6691P · Substantial damageNTSB CEN16LA105Accident · No injuriesLimited investigationFinal reportEnstrom TH-180 · Menominee, MIThe failure of the torque meter mounting bolts, which resulted in a loss of engine power to the main drive belt and rotors.Feb 12, 2016 · N180TH · Substantial damageNTSB GAA16CA126Accident · No injuriesData collectionFinal reportPiper PA31 · Newport, RIAn inadvertent collision with birds during final approach at night.Feb 5, 2016 · N102WM · Substantial damageNTSB ERA16FA100Accident · 2 fatalField investigationFinal reportCessna 182 · Mobile, ALThe pilot's loss of airplane control during a missed approach in instrument meteorological conditions due to spatial disorientation. Contributing to the accident was the pilot's inadequate preflight and inflight weather planning which resulted the pilot's…Feb 2, 2016 · N784CP · DestroyedNTSB WPR16FA059Accident · 2 fatalField investigationFinal reportPiper PA 24-260 · Santa Rosa, CAThe pilot’s failure to maintain airplane control during an instrument approach in night instrument meteorological conditions, which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of recent experience in night…Jan 29, 2016 · N9362P · Substantial damageNTSB DCA16WA080Accident · 3 fatalForeign investigationCessna 425 · Windhoek, NamibiaThe Namibia Directorate of Aircraft Accident and Incident Investigation (DAAII) has notified the NTSB of an accident involving a Cessna 425 airplane that occurred on January 29, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the…Jan 29, 2016 · V5-MJW · DestroyedNTSB CEN16FA095Accident · 1 fatalField investigationFinal reportCirrus Design SR22T · Xenia, OHThe pilot's failure to maintain adequate airspeed while turning from the base leg to final, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall.Jan 26, 2016 · N1703 · Substantial damageNTSB GAA16CA106Accident · No injuriesData collectionFinal reportPiper PA 28RT-201 · Terrell, TXThe private pilot's exceedance of the airplane's critical angle-of-attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall and a collision with terrain short of the runway.Jan 19, 2016 · N2119N · Substantial damageNTSB CEN16LA093Accident · No injuriesLimited investigationFinal reportSocata TBM700 · Wichita, KSThe pilot’s failure to maintain the minimum-recommended approach airspeed in icing conditions, which resulted in a loss of airplane control.Jan 19, 2016 · N602MA · Substantial damageNTSB ERA16LA090Accident · No injuriesLimited investigationFinal reportBeech A23 · Kingston, TNThe pilot's inadequate preflight inspection and fuel planning and his improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Jan 16, 2016 · N3680Q · Substantial damageNTSB CEN16FA083Accident · 1 fatalField investigationFinal reportCessna 172N · Gilmer, TXThe pilot's inadequate preflight planning and inspection, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's failure to maintain an appropriate traffic pattern altitude and distance from the…Jan 13, 2016 · N737EZ · Substantial damageNTSB ERA16LA085Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Concord, NCThe pilot’s inadequate management of the airplane’s automated systems, which resulted in a loss of control during an instrument approach and necessitated his subsequent deployment of the airplane’s parachute system.Jan 8, 2016 · C-GXXJ · Substantial damageNTSB WPR16LA048Accident · No injuriesLimited investigationFinal reportBeech 35 C33 · Henderson, NVA partial loss of engine power during final approach for reasons that could not be determined based on available information.Jan 5, 2016 · N20XY · Substantial damageNTSB ERA16WA083Accident · 2 fatalForeign investigationBeech C90 · Parati, BrazilOn January 3, 2016, about 1730 Coordinated Universal Time (UTC), a Beech C90GTi, PP-LMM, registered to Bradesco Leasing S.A., operated by Supermercado Shibata Ltda, experienced controlled flight into mountainous terrain near Parati Airport (SDTK), Parati,…Jan 3, 2016 · PP-LMM · DestroyedNTSB WPR16LA049Accident · No injuriesLimited investigationFinal reportKai Engstad RV-8A · Salem, ORA total loss of engine power for undetermined reasons, because postaccident examination of the engine and fuel system did not reveal any anomalies that would have precluded normal operation.Jan 2, 2016 · N958RV · Substantial damage