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 ERA18FA005Accident · 1 fatalField investigationFinal reportBryant C Crosby BC Ultra PUP · Bardstown, KYThe pilot's improper decision to initiate a flight in an airplane he had never flown and with no currency in any airplane nor a medical certificate, which resulted in his loss of airplane control. Contributing to the accident was the pilot's psychiatric…Oct 5, 2017 · N484HC · Substantial damageNTSB ERA18LA002Accident · 1 fatalLimited investigationFinal reportCessna 182 · San Juan, PRThe pilot's failure to maintain adequate distance from helicopters during the approach for landing, resulting in an encounter with wake turbulence and subsequent loss of control.Oct 2, 2017 · N9021X · Substantial damageNTSB ERA17LA341Accident · No injuriesLimited investigationFinal reportCessna 162 · Huntsville, ALThe flight instructor’s failure to use carburetor heat, which resulted in the total loss of engine power due to carburetor icing.Sep 28, 2017 · N552ES · Substantial damageNTSB GAA17CA559Accident · No injuriesData collectionFinal reportCessna 182 · San Diego, CAThe airplane’s inadvertent entry into instrument meteorological, dark night conditions and the pilot’s failure to maintain an adequate approach for landing.Sep 27, 2017 · N9346G · Substantial damageNTSB CEN17LA376Accident · No injuriesLimited investigationFinal reportCessna 182M · Piqua, OHThe accumulation of carburetor ice while operating at a reduced engine power setting, which resulted in a total loss of engine power on approach and a subsequent forced landing on unsuitable terrain.Sep 27, 2017 · N70634 · Substantial damageNTSB GAA17CA557Accident · Minor injuriesData collectionFinal reportBellet James J Vans RV 8 · Orange, MAThe pilot's failure to remove the engine cowl plugs during preflight, which resulted in excessive engine cylinder head temperatures during climb and a total loss of engine power.Sep 26, 2017 · N184SJ · Substantial damageNTSB GAA17CA573Accident · No injuriesData collectionFinal reportCessna 172 · Chino, CAAn in-flight collision with a bird while on downwind.Sep 22, 2017 · N520KS · Substantial damageNTSB CEN17WA370Accident · 2 fatalForeign investigationCessna 150J · Goderich, CanadaOn September 20, 2017, about 2036 eastern daylight time, a Cessna 150J single-engine airplane, Canadian registration C-FHPU, serial number 15070602, crashed in Lake Huron about 1.1 nautical miles west of Goderich Municipal Airport (CYGD), Goderich, Ontario,…Sep 21, 2017 · C-FHPU · Substantial damageNTSB CEN17WA360Accident · 2 fatalForeign investigationVans RV4 · Stafsberg, NorwayOn September 19, 2017, at 1450 UTC, a Vans Aircraft RV-4, experimental, amateur-built airplane, Norwegian registration LN-ABF, impacted terrain near the Hamar Airport (ENHA), Stafsberg, Norway. The pilot and passenger on board were fatally injured and the…Sep 19, 2017 · LN-ABF · DestroyedNTSB WPR17LA208Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-161 · El Cajon, CAA partial loss of engine power due to the formation of carburetor ice during descent for landing. Contributing to the accident was the pilot’s failure to apply carburetor heat.Sep 17, 2017 · N2587X · Substantial damageNTSB CEN17LA365Accident · No injuriesLimited investigationFinal reportGaddis Michael Exec 162 F · Plymouth, INA failure of the drive belt for reasons that could not be determined based on the available information.Sep 16, 2017 · N123XZ · Substantial damageNTSB CEN17LA357Accident · Minor injuriesLimited investigationFinal reportBeech A36 · McAlester, OKA total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.Sep 15, 2017 · N18403 · Substantial damageNTSB ERA17LA325Accident · No injuriesLimited investigationFinal reportBeech C23 · Machias, METhe pilot's delay in applying carburetor heat, which resulted in a total loss of engine power due to carburetor icing.Sep 14, 2017 · N2120W · Substantial damageNTSB CEN17LA348Accident · No injuriesLimited investigationFinal reportBeech N35 · South Bend, INThe improperly seated fuel cap, which resulted in an in-flight fuel leak and subsequent total loss of engine power due to fuel starvation.Sep 12, 2017 · N9368Y · Substantial damageNTSB GAA17CA530Accident · Minor injuriesData collectionFinal reportCessna 172 · Plainville, CTThe pilot’s failure to properly execute the go-around, which resulted in the airplane failing to maintain a climb, which resulted in collision with a tree.Sep 11, 2017 · N54463 · Substantial damageNTSB ERA17WA321Accident · 1 fatalForeign investigationPiper Piper PA-34-200T · Cerrione, ItalySep 9, 2017 · G-STZA · DestroyedNTSB DCA17CA194Accident · Serious injuriesData collectionFinal reportMcdonnell Douglas MD 90-30 · El Paso, TXan inadvertent encounter with turbulence.Sep 4, 2017 · N938DN · No damageNTSB GAA17CA518Accident · No injuriesData collectionFinal reportCroft Robert C Kitfox Super Sport · Afton, WYThe pilot’s failure to maintain bank control during an attempted go-around.Sep 2, 2017 · N429NC · Substantial damageNTSB GAA17CA542Accident · No injuriesData collectionFinal reportCessna 150 · Wasilla, AKThe student pilot’s inadequate in-flight fuel planning, which resulted in fuel exhaustion, the subsequent total loss of engine power, and a forced off-airport landing.Aug 31, 2017 · N2996S · Substantial damageNTSB GAA17CA513Accident · Minor injuriesData collectionFinal reportCessna 172 · Belle Fourche, SDThe flight instructor's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around in gusting crosswind conditions, which resulted in an aerodynamic stall.Aug 30, 2017 · N2982U · Substantial damageNTSB ERA17FA299Accident · 2 fatalField investigationFinal reportGrumman AA1 · Portland, TNThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Aug 30, 2017 · N8866L · Substantial damageNTSB WPR17LA190Accident · Minor injuriesLimited investigationFinal reportBeech M35 · Lake Havasu City, AZThe pilot's incorrect positioning of the fuel tank selector valve during a tank switch, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the worn condition of the fuel selector valve handle position detents and…Aug 29, 2017 · N339Z · Substantial damageNTSB GAA17CA519Accident · No injuriesData collectionFinal reportPiper J5A · Springfield, VTThe pilot's unstabilized approach, which resulted in landing long and fast, and his subsequent failure to maintain clearance from trees during a go-around.Aug 27, 2017 · N30897 · Substantial damageNTSB ERA17WA351Incident · No injuriesForeign investigationCessna 207 · Recanati, ItalyThe government of Italy has notified the NTSB of an accident involving a CESSNA 207 airplane that occurred on August 27, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…Aug 27, 2017 · D-EPJR · Minor damageNTSB CEN17LA329Accident · No injuriesLimited investigationFinal reportJames M Raulerson CH 750 · Manila, ARA loss of engine power for reasons that could not be determined because the airplane was not available for examination.Aug 24, 2017 · N61LR · Substantial damageNTSB ERA17LA281Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Green Creek, NJThe pilot's exhaustion of the fuel supply in the selected tank.Aug 20, 2017 · N46286 · Substantial damageNTSB WPR17FA185Accident · 1 fatalField investigationFinal reportRich Wheeler Express CT · Madras, ORThe pilot's failure to maintain adequate airspeed while maneuvering in the airport traffic pattern for landing, which resulted in an exceedance of the airplane's critical angle of attack, a subsequent aerodynamic stall at an altitude too low to recover.Aug 19, 2017 · N246TM · DestroyedNTSB ERA17LA287Accident · No injuriesLimited investigationFinal reportCessna R182 · Clearwater, FLThe improper maintenance of the landing gear system and subsequent failure of the hydraulic landing gear down return line, which resulted in a loss of hydraulic fluid and the pilot’s inability to extend and lock the main landing gear.Aug 19, 2017 · N9155C · Substantial damageNTSB ANC17LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna T207 · Juneau, AKThe total loss of engine power due to fuel starvation.Aug 14, 2017 · N745KP · Substantial damageNTSB GAA17CA489Accident · No injuriesData collectionFinal reportCessna 170 · Axtell, KSThe pilot's exceedance of the airplane's critical angle of attack during a go-around. Contributing to the accident was the pilot's decision to attempt to close a passenger door during a critical phase of flight.Aug 11, 2017 · N4189V · Substantial damageNTSB CEN17LA359Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Raton, NMThe pilot's failure to maintain a proper descent rate, which resulted in a bounced landing, and his subsequent failure to attain a proper airspeed during an attempted go-around in shifting wind conditions, which resulted in an aerodynamic stall.Aug 10, 2017 · N702N · Substantial damageNTSB CEN17LA307Accident · 2 fatalLimited investigationFinal reportPegasus Quantum · Fort Atkinson, WIThe student pilot's failure to maintain aircraft control during a go-around, which resulted in impact with water. Contributing to the accident was the non-instructor sport pilot's decision to allow the student pilot to fly the aircraft.Aug 9, 2017 · N56092 · Substantial damageNTSB ERA17LA267Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJThe student pilot's improper decision to conduct a night flight and his failure to maintain adequate altitude during the approach, which resulted in controlled flight into trees and terrain. Contributing to the accident was the student pilot's lack of total…Aug 6, 2017 · N56884 · Substantial damageNTSB ERA17LA270Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Immokalee, FLThe pilot's failure to attain adequate airspeed during an attempted go-around, which resulted in an aerodynamic stall.Aug 3, 2017 · N811AW · Substantial damageNTSB GAA17CA472Accident · No injuriesData collectionFinal reportMooney M20 · Skiatook, OKThe pilot's improper decision to conduct the flight despite the fuel gauges indicating that there was insufficient fuel for the flight, which resulted in the low amount of fuel in the right tank becoming unported during the multiple turns, and his subsequent…Aug 2, 2017 · N95442 · Substantial damageNTSB DCA17WA168Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe Dirección General de Aeronáutica Civil (DGAC) has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on August 01, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation…Aug 1, 2017 · N368AR · No damageNTSB CEN17FA297Accident · 2 fatalField investigationFinal reportPiper PA30 · Topeka, KSThe failure of the pilot and flight instructor to maintain aircraft control while maneuvering in the traffic pattern.Aug 1, 2017 · N22HW · DestroyedNTSB GAA17CA477Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Homestead, FLThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in the pilot landing short of the intended runway.Jul 30, 2017 · N304MG · Substantial damageNTSB ERA17RA260Accident · 1 fatalForeign investigationBritten Norman BN2A · Eteringbang, GuyanaOn July 25, 2017, about 2153 coordinated universal time, a Britten Norman BN2A-26, Guyana Registration 8R-GRA, operated by Roraima Airways Ltd., was substantially damaged when it impacted wooded terrain while on approach to Eteringbang Airstrip (SYET),…Jul 25, 2017 · 8R-GRA · Substantial damageNTSB CEN17LA285Accident · Serious injuriesLimited investigationFinal reportHillard Charlie R Hawker FB60 · Breckenridge, TXA total loss of engine power for reasons that could not be determined because postaccident engine examination and testing did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.Jul 25, 2017 · N254SF · Substantial damageNTSB WPR17LA158Accident · Serious injuriesLimited investigationFinal reportEnstrom F 28C · Ontario, CAThe student pilot's mismanagement of the main rotor rpm, which resulted in low rotor rpm, a high descent rate, and a subsequent hard landing.Jul 19, 2017 · N5697B · Substantial damageNTSB WPR17FA155Accident · 2 fatalField investigationFinal reportEvolution 19 Lancair Evolution · Mesa, AZThe pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent stall/spin. Contributing to the accident was the pilot's distraction due to a failure…Jul 17, 2017 · N571JM · Substantial damageNTSB ERA17LA247Accident · No injuriesLimited investigationFinal reportAeroprakt A 20 Vista Cruiser · Shirley, NYThe pilot's inadvertent activation of the engine's choke control during a downdraft encounter, which resulted in a total loss of engine power.Jul 17, 2017 · N55US · Substantial damageNTSB GAA17CA417Accident · No injuriesData collectionFinal reportPerner/Pitts S1S · Brenham, TXThe pilot's failure to maintain lateral/bank and yaw control during a go-around.Jul 16, 2017 · N714H · Substantial damageNTSB WPR17LA157Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe failure of the No. 4 cylinder exhaust valve head, which resulted in a total loss of engine power due to oil starvation.Jul 15, 2017 · N754AP · Substantial damageNTSB GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.Jul 15, 2017 · N9303V · Substantial damageNTSB ERA17LA246Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe fatigue failure of an exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.Jul 15, 2017 · N561TU · Substantial damageNTSB ANC17LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180 · Anchorage, AKA total loss of engine power due to fuel starvation for undetermined reasons.Jul 9, 2017 · N2429C · Substantial damageNTSB GAA17CA474Accident · No injuriesData collectionFinal reportCessna 210 · Bettles, AKThe pilot's failure to maintain an appropriate glidepath during the approach to the runway over glassy water and in glaring sun conditions.Jul 8, 2017 · N9664X · DestroyedNTSB DCA17IA148Incident · No injuriesClass 1 · IncidentFinal reportAirbus A320-211 · San Francisco, CAThe flight crew's misidentification of taxiway C as the intended landing runway, which resulted from the crewmembers' lack of awareness of the parallel runway closure due to their ineffective review of notice to airmen (NOTAM) information before the flight…Jul 8, 2017 · C-FKCK · No damage