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 DFW05CA093Accident · Minor injuriesData collectionFinal reportCessna 172M · Spring, TXThe pilot's inadequate use of carburetor heat, which resulted in carburetor ice and the loss of engine power. A contributing factor was conditions conducive to carburetor icing.Mar 18, 2005 · N91505 · Substantial damageNTSB SEA05CA059Accident · No injuriesData collectionFinal reportCessna 182A · Manzanita, ORThe pilot's inadequate compensation for the wind, which resulted in an inflight loss of control, a subsequent uncontrolled descent into the tree stump and guy wire, and the resultant nose over. A factor contributing to the accident was the downdraft.Mar 13, 2005 · N4076D · Substantial damageNTSB DFW05CA087Accident · No injuriesData collectionFinal reportCessna TU206G · Lancaster, TXThe pilot's mismanagement of the available fuel supply, which resulted in a total loss of engine power due to fuel starvation.Mar 12, 2005 · N6211Z · Substantial damageNTSB MIA05CA075Accident · No injuriesData collectionFinal reportSchleicher ASW 27 · Clermont, FLThe pilot's inadvertent deploying of the spoilers, while on final approach, resulting in the glider descending and impacting trees.Mar 10, 2005 · N661T · Substantial damageNTSB DFW05LA085Accident · No injuriesLimited investigationFinal reportCessna 182G · Fort Worth, TXThe loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive for carburetor icing, lack of suitable terrain for a forced landing, and the prevailing dark night conditions.Mar 10, 2005 · N2315R · Substantial damageNTSB ANC05IA048Incident · No injuriesIncident investigationFinal reportReims F406 · Nome, AKThe failure of the nose gear up lock actuator bracket during the landing approach due to fatigue cracking, which resulted in a nose wheel up landing. A factor associated with the incident is the mechanical binding of the nose wheel locking mechanism.Mar 9, 2005 · N6591R · Minor damageNTSB DFW05FA082Accident · 1 fatalField investigationFinal reportCessna 172F · Hot Springs, ARA loss of engine power due to the pilot's failure to refuel resulting in fuel starvation. Contributing factors were the lack of suitable terrain for the forced landing, and a shoulder harness restraint system was not installed.Mar 8, 2005 · N8382U · Substantial damageNTSB NYC05FA053Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Coatesville, PAThe pilot's inadequate remedial action during an engine failure, which resulted in a loss of airplane control. A factor was the pilot's improper fuel management, which resulted in fuel starvation to one engine, and its subsequent loss of engine power.Mar 6, 2005 · N2343Z · Substantial damageNTSB MIA05CA074Accident · No injuriesData collectionFinal reportDgflugzeugbau DG-800S · Clermont, FLThe pilots failure to maintain airspeed which resulted in the glider stalling and impact with trees during the uncontrolled descent.Mar 5, 2005 · N92DG · Substantial damageNTSB ANC05LA045Accident · No injuriesLimited investigationFinal reportHelio H-295 · Fairbanks, AKThe pilot's delay in performing a go-around, and his failure to maintain obstacle clearance.Feb 28, 2005 · N6465V · Substantial damageNTSB MIA05LA063Accident · No injuriesLimited investigationFinal reportCessna T207A · West Palm Beach, FLThe pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation and subsequent impact with an embankment during an emergency landing.Feb 23, 2005 · N207CC · Substantial damageNTSB DFW05CA075Accident · No injuriesData collectionFinal reportSchweizer SGS1-26B · Midlothian, TXThe pilot's misjudgment in distance/altitude and his failure to maintain clearance from a tree while on final to approach to landing. Contributing factors were the lack of thermal lift and the gusty wind conditions.Feb 20, 2005 · N7569 · Substantial damageNTSB ATL05LA051Accident · Serious injuriesLimited investigationFinal reportMooney 20P · Smith, ALMaintenance personnel failure to properly torque the cylinder head during installation that resulted in the separation from the engine assembly and the subsequent loss of power.Feb 18, 2005 · N321DT · Substantial damageNTSB DCA05MA037Accident · 8 fatalClass 1 · MajorFinal reportCessna 560 · Pueblo, COthe flight crew's failure to effectively monitor and maintain airspeed and comply with procedures for deice boot activation on the approach, which caused an aerodynamic stall from which they did not recover. Contributing to the accident was the Federal…Feb 16, 2005 · N500AT · DestroyedNTSB ANC05FA030Accident · 2 fatalField investigationFinal reportBeech K35 · Leesburg, FLAn abrupt maneuver performed by the pilot at a low altitude, and his failure to maintain adequate airspeed, which precipitated an inadvertent stall and impact with terrain.Feb 14, 2005 · N634Q · Substantial damageNTSB CHI05LA071Accident · No injuriesLimited investigationFinal reportTwin Commander Acft. 680V · Fort Wayne, INThe malfunction of the landing gear extension assembly during approach for undetermined reasons.Feb 11, 2005 · N688TM · Substantial damageNTSB CHI05LA069Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Bolivar, MOA loss of engine power due to the pilot's inaccurate preflight and inflight planning which resulted in an inadequate fuel supply for the flight, and the subsequent fuel exhaustion. A factor associated with the accident was the trees that the airplane…Feb 11, 2005 · N5961P · Substantial damageNTSB ANC05LA029Accident · No injuriesLimited investigationFinal reportBeech A36 · Bay St. Louis, MSThe pilot's failure to use the manual emergency landing gear extension mechanism during the approach to land, which resulted in the electrically actuated main landing gear collapsing during the landing roll. A factor associated with the accident is an…Feb 10, 2005 · N6742S · Substantial damageNTSB ATL05LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Concord, NCThe loss of engine power due to the failure of the fuel pump which resulted in fuel starvation.Feb 8, 2005 · N364BW · Substantial damageNTSB IAD05LA039Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper 912 · Woodbine, NJThe student's failure to maintain control of the airplane, and the flight instructor's inadequate remedial action, which resulted in an uncontrolled descent into terrain.Feb 7, 2005 · UNREG · DestroyedNTSB NYC05FA048Accident · 1 fatalField investigationFinal reportBeech V35B · Norwich, NYA loss of engine power for undetermined reasons.Feb 5, 2005 · N35JL · DestroyedNTSB DFW05FA065Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Alexandria, LAThe pilot's loss of control while maneuvering to land.Feb 3, 2005 · N99452 · DestroyedNTSB LAX05FA079Accident · 1 fatalField investigationFinal reportCessna 180 · Adelanto, CAThe pilot's failure to maintain sufficient airspeed to avoid a stall during an attempted go-around, resulting in a loss of control and collision with terrain.Jan 31, 2005 · N2882A · Substantial damageNTSB SEA05IA040Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · Seattle, WAThe flight crew's failure to maintain an adequate visual lookout while on final for a visual approach. Factors include the failure of both airport operations personnel and the local FAA Airports Inspector to insure that some form of identification marking was…Jan 30, 2005 · N350SW · No damageNTSB LAX05LA080Accident · No injuriesLimited investigationFinal reportCessna T210N · Glendale, AZThe airplane was struck by lightning during the approach to land.Jan 30, 2005 · N1164U · Substantial damageNTSB LAX05LA077Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Chico, CAA loss of engine power during approach to land for undetermined reasons.Jan 27, 2005 · N7337S · Substantial damageNTSB LAX05FA076Accident · Minor injuriesField investigationFinal reportBeech P35 · Willits, CAThe pilot's failure to maintain control of the airplane during an instrument landing approach, resulting in an in-flight collision with trees and terrain. Factors contributing to the accident were turbulence, and the pilot's diverted attention.Jan 26, 2005 · N222V · Substantial damageNTSB DFW05FA059Accident · 2 fatalField investigationFinal reportBeech BE-36 · Brownwood, TXThe pilots failure to maintain proper altitude and clearance while on final approach to land. Contributing factors were the pilot's lack of familiarity with the geographic area, the dark night light conditions, the non-availability of a visual approach glide…Jan 22, 2005 · N1750A · DestroyedNTSB DFW05CA077Accident · No injuriesData collectionFinal reportCessna 182 · Graham, TXThe airplane's collision with a deer during a go-around. A contributing factor was the prevailing night condition.Jan 21, 2005 · N832TC · Substantial damageNTSB ATL05CA045Accident · Minor injuriesData collectionFinal reportCessna 152 · Nashville, TNA loss of engine power due to fuel starvation as a result of fuel system blockage.Jan 17, 2005 · N24218 · Substantial damageNTSB MIA05LA052Accident · No injuriesLimited investigationFinal reportPaul Pajak RV-6A · Sanford, FLThe pilots failure to use carburetor heat in conditions conducive to carburetor icing which resulted in loss of engine power and collision with trees and ground during the resultant forced landing.Jan 16, 2005 · N654PJ · Substantial damageNTSB LAX05LA064Accident · 1 fatalLimited investigationFinal reportJimmy Hill Lancair 235 · El Cajon, CAthe pilot's failure to maintain the proper glidepath to avoid obstacles and terrain.Jan 12, 2005 · N124JH · Substantial damageNTSB DEN05FA051Accident · 3 fatalField investigationFinal reportBeech BE-90 · Rawlins, WYThe pilot's inadvertent flight into adverse weather [severe icing] conditions, resulting in an aerodynamic stall impact with rising, mountainous terrain during approach. A factor contributing to the accident was the pilot's inadequate planning for the…Jan 12, 2005 · N41WE · DestroyedNTSB SEA05FA034Accident · 2 fatalField investigationFinal reportCessna 182R · Monroe, LAThe failure of the pilot manipulating the controls to maintain aircraft control during a night missed approach in instrument meteorological conditions. Factors include a dark night and low ceilings.Jan 11, 2005 · N9474E · DestroyedNTSB MIA05FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Leesburg, FLThe pilot's decision to continue VMC flight into IMC conditions.Jan 11, 2005 · N1266T · DestroyedNTSB DFW05LA118Accident · 2 fatalLimited investigationFinal reportCessna TR182 · Little Rock, ARThe pilot's failure to maintain control of the airplane during an instrument approach for undetermined reasons. Contributing factors were the mist and low cloud ceiling.Jan 10, 2005 · N6150S · DestroyedNTSB ATL05LA042Accident · 1 fatalLimited investigationFinal reportBeech 35 · Knoxville, TNThe pilot's failure to maintain adequate obstacle clearance, which resulted in the in-flight collision with trees. A factor was dark night.Jan 9, 2005 · N501B · Substantial damageNTSB DFW05LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Decatur, TXThe student pilot's failure to maintain obstacle clearance and the instructor's inadequate supervision. Contributing factors were the prevailing dark night conditions, and the power line.Jan 8, 2005 · N9419C · Substantial damageNTSB CHI05LA050Accident · Minor injuriesLimited investigationFinal reportCessna 551 · Ainsworth, NEThe pilot's decision to continue below the minimum descent altitude (MDA) and his failure to fly the published missed-approach procedure. A factor to the accident was the pilot's improper use of windshield heat which resulted in the windshield becoming…Jan 1, 2005 · N35403 · Substantial damageNTSB NYC05CA037Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Johnstown, NYThe pilot's inadequate in-flight planning/decision which resulted in airframe ice with subsequent degradation of aircraft performance, and inadequate airspeed during the landing flare.Dec 29, 2004 · N300WE · Substantial damageNTSB DFW05LA049Accident · Minor injuriesLimited investigationFinal reportBeech BE35 · Los Fresnos, TXThe loss of engine power for undetermined reasons. A contributing factor was the prevailing dark night ilumination.Dec 29, 2004 · N860R · Substantial damageNTSB LAX05FA054Accident · 2 fatalField investigationFinal reportCessna 182P · La Mirada, CAthe pilot's inadequate visual lookout and failure to maintain altitude/clearance from a transmission tower while on an extended base leg of the traffic pattern. A factor in the accident was the sun glare condition.Dec 19, 2004 · N9187G · Substantial damageNTSB LAX05FA053Accident · 1 fatalField investigationFinal reportEurocopter AS-350-B3 · Apache Junction, AZA loss of control during the final approach to land for undetermined reasons.Dec 15, 2004 · N971AE · Substantial damageNTSB DFW05LA031Accident · Minor injuriesLimited investigationFinal reportBeech B200 · Tulsa, OKThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight and in-flight planning / preparation.Dec 9, 2004 · N6PE · Substantial damageNTSB CHI05FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Glenwood, MNThe pilot's failure to execute a missed approach and his failure to maintain sufficient altitude and clearance from terrain and obstructions. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his decision to delay descent…Dec 9, 2004 · N587C · Substantial damageNTSB ATL05FA034Accident · 3 fatalField investigationFinal reportDiamond DA40-180 · Pelzer, SCThe pilot's failure to follow IFR procedures and to maintain assigned altitude resulting in a collision with a transmission wire and trees.Dec 9, 2004 · N42SE · Substantial damageNTSB LAX05CA044Accident · Minor injuriesData collectionFinal reportCessna 150J · Amado, AZthe pilot's inaccurate fuel consumption calculations and failure to refuel the airplane at the intermediate stop, which resulted in fuel exhaustion.Dec 8, 2004 · N60469 · Substantial damageNTSB NYC05FA028Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Vandalia, OHThe pilot's failure to maintain adequate altitude\clearance while on approach, which resulted in an in-flight collision with trees. Factors in the accident were the fog and low ceiling conditions.Dec 7, 2004 · N54316 · DestroyedNTSB SEA05LA026Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Spanaway, WAThe pilot's misjudgment of distance/altitude during final approach to land which resulted in an undershoot and in flight collision with a fence. A factor was the pilot's alcohol impairment.Dec 6, 2004 · N3571V · Substantial damageNTSB SEA05FA025Accident · 2 fatalField investigationFinal reportCessna 208B · Bellevue, IDThe pilot's failure to maintain aircraft control while on approach for landing in icing conditions. Inadequate airspeed was a factor.Dec 6, 2004 · N25SA · Destroyed