OpenAirDocs.org

NTSB investigations, 2006

225 cases where the phase of flight was Approach.

Cases per year

19622026

Where

Open the map

Latest cases

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 year(c.\"eventDate\") = 2006
    AND 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 NYC07FA052Accident · 4 fatalField investigationFinal reportCessna TR182 · Charlotte, NCThe pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was instrument meteorological conditions.Dec 31, 2006 · N7090S · DestroyedNTSB CHI07LA051Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · Romeo, MIThe pilot's failure to maintain aircraft control and proper rate of descent during the VOR approach. Factors associated with the accident were the low cloud conditions and moderate to heavy rain.Dec 31, 2006 · N888PR · Substantial damageNTSB CHI07LA050Accident · Minor injuriesLimited investigationFinal reportBeech B-99 · Rapid City, SDThe pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.Dec 29, 2006 · N99TH · Substantial damageNTSB LAX07CA066Accident · Minor injuriesData collectionFinal reportBurkhart Grob G-103A · Minden, NVThe flight's encounter with a low ceiling while on approach that necessatiated an off-airport precautionary landing on unsuitable terrain. Obstructions were a factor.Dec 27, 2006 · N794G · Substantial damageNTSB ATL07FA030Accident · 3 fatalField investigationFinal reportCessna 414A · Lawrenceville, GAThe pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.Dec 26, 2006 · N62950 · Substantial damageNTSB ANC07LA009Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Nashville, TNThe pilot's inadequate compensation for gusty crosswind conditions during landing, which resulted in a loss of control and collision with the runway. Factors contributing to the accident were the failure of the aileron augmentation (spoiler) flight control…Dec 26, 2006 · N136WE · Substantial damageNTSB CHI07FA045Accident · 4 fatalField investigationFinal reportBeech A36 · Chattanooga, TNThe pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.Dec 23, 2006 · N3704B · DestroyedNTSB ATL07FA029Accident · 4 fatalField investigationFinal reportCessna 340A · Charleston, SCThe pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.Dec 22, 2006 · N808RA · Substantial damageNTSB LAX07FA059Accident · 4 fatalField investigationFinal reportPiper PA-46-350P · Concord, CAFailure of the pilot to follow the prescribed instrument approach procedures and to maintain an adequate airspeed while maneuvering in the airport environment that led to a stall.Dec 21, 2006 · N1AM · DestroyedNTSB DFW07FA042Accident · 1 fatalField investigationFinal reportCessna T210N · Austin, TXThe pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.Dec 19, 2006 · N5434C · DestroyedNTSB DFW07FA041Accident · 1 fatalField investigationFinal reportBeech A36 · Fayetteville, ARThe pilot's failure to maintain clearance from obstacles. Contributing factors were the below approach/landing weather minimums, and the prevailing dark night conditions.Dec 19, 2006 · N1100J · DestroyedNTSB CHI07LA043Accident · No injuriesLimited investigationFinal reportCessna 560 · North Canton, OHThe rupture of the hydraulic pressure hose assembly, which was caused by internal wear between the hose's fire sleeve and stainless steel braid, and the failure of the emergency landing gear assembly to deploy the right main landing gear during approach.…Dec 18, 2006 · N49NS · Substantial damageNTSB DFW07CA038Accident · No injuriesData collectionFinal reportCessna 421 · Brackettville, TXThe pilot's failure to maintain proper runway alignment on final approach and his delayed decision to execute a go-around. Factors were the dark night conditions and the inoperative runway edge lights.Dec 16, 2006 · N642CB · DestroyedNTSB NYC07CA049Accident · Minor injuriesData collectionFinal reportCessna 172C · Middletown, NYThe pilot misjudging distance/altitude during the turn from base to final, which resulted in an undershoot and subsequent collision with trees. A factor was the haze.Dec 14, 2006 · N8260X · Substantial damageNTSB CHI07CA040Accident · No injuriesData collectionFinal reportSchleicher AS-K13 · Gregory, MIThe pilot's unexpected encounter with wind shear and his inability to remain clear of the trees while on final approach to land.Dec 14, 2006 · N545TT · Substantial damageNTSB SEA07FA031Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bandon, ORThe loss of aircraft control in the traffic pattern for undetermined reasons.Dec 12, 2006 · N5618U · Substantial damageNTSB DFW07FA036Accident · 3 fatalField investigationFinal reportCessna 310Q · Waco, TXThe pilot's failure to maintain sufficient airspeed to avoid a stall during the instrument landing approach, which resulted in an inadvertent stall and collision with terrain. Also causal was the pilot's impairment due to prohibited drugs. Factors associated…Dec 11, 2006 · N69677 · DestroyedNTSB NYC07FA043Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Charlottesville, VAA loss of engine power for undetermined reasons.Dec 10, 2006 · N8349C · DestroyedNTSB NYC07FA042Accident · 2 fatalField investigationFinal reportCessna 210K · Edgewater, MDThe pilot's failure to maintain the proper altitude/clearance will on approach, which resulted in an in-flight collision with trees. Contributing to the accident was the night-light conditions, an obstruction light that was not illuminated, and trees that had…Dec 9, 2006 · N9449M · Substantial damageNTSB DEN07CA035Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Falcon, COloss of power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing, unsuitable terrain available on which to make a forced landing and the tree.Dec 8, 2006 · N6487J · Substantial damageNTSB NYC07FA038Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601P · West Dover, VTA loss of control during approach for undetermined reasons, which resulted in a collision with trees.Dec 2, 2006 · N9797Q · DestroyedNTSB DFW07LA032Accident · 2 fatalLimited investigationFinal reportNoble Vans RV-7A · Norman, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's attempt at formation flying.Dec 2, 2006 · N216RV · Substantial damageNTSB NYC07FA037Accident · 1 fatalField investigationFinal reportCirrus SR22 · Huntersville, NCThe pilot's failure to maintain aircraft control. Contributing to the accident was the night instrument meteorological conditions.Dec 1, 2006 · N665CD · DestroyedNTSB LAX07FA049Accident · Serious injuriesField investigationFinal reportBeech B36TC · Buena Park, CAa fuel starvation induced loss of engine power due to pilot's inadequate fuel system management.Nov 27, 2006 · N3144D · Substantial damageNTSB LAX07LA048Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Las Vegas, NVA loss of power in the right engine due to fuel starvation. The fuel starvation was the result of the pilot's improper fuel selector position setting.Nov 26, 2006 · N414AY · Substantial damageNTSB NYC07LA036Accident · No injuriesLimited investigationFinal reportCessna T210N · Caldwell, NJThe private pilot's failure to maintain adequate altitude/clearance, and the flight instructor's failure to take remedial action. Contributing to the accident was the night light conditions.Nov 21, 2006 · N210MP · Substantial damageNTSB NYC07CA034Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Benton, KYThe pilot's improper decision to fly between the trees during his approach to the runway.Nov 21, 2006 · N148HW · Substantial damageNTSB MIA07CA020Accident · No injuriesData collectionFinal reportLiberty Aerospace XL-2 · Melbourne, FLThe pilot's (Dual Student) failure to relinquish control of the airplane when instructed by the certified flight instructor resulting in airspeed not being maintained and an inadvertent stall.Nov 21, 2006 · N508XL · Substantial damageNTSB ATL07CA023Accident · No injuriesData collectionFinal reportHudspeth Shawn D Challenger II · Bessemer, ALThe pilot's failure to maintain control of the airplane during an approach for landing. A factor in the accident was gusting winds.Nov 21, 2006 · N44594 · Substantial damageNTSB MIA07CA018Accident · Serious injuriesData collectionFinal reportSargent Jonathan Varieze · Punta Gorda, FLThe pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's inadequate preflight, which did not ensure the security of the canopy before flight.Nov 18, 2006 · N75EZ · Substantial damageNTSB LAX07LA037Accident · 1 fatalLimited investigationFinal reportBeechcraft J35 · Flagstaff, AZThe pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.Nov 18, 2006 · N8246D · Substantial damageNTSB SEA07IA019Incident · No injuriesIncident investigationFinal reportCessna 172 · Seattle, WAThe instructor pilot's improper in-flight decision not to take evasive action as a heavy aircraft passed by while on an upwind parallel approach path to an adjacent runway, leading to a wake vortices encounter. Factors include a nearly direct crosswind…Nov 16, 2006 · N9522S · No damageNTSB SEA07LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Caldwell, IDThe pilot's inadequate in-flight planning by failing to refuel while en route which resulted in fuel exhaustion and loss of engine power while on approach to the airport. Rough/uneven terrain was a factor.Nov 14, 2006 · N2390T · Substantial damageNTSB CHI07CA023Accident · Minor injuriesData collectionFinal reportMooney M20J · Akron, OHThe pilot's failure to maintain sufficient airspeed during final approach resulting in an inadvertent stall. Contributing factors were the airplane's low altitude at the time of the stall and the asymmetric flap configuration.Nov 14, 2006 · N202WB · Substantial damageNTSB MIA07CA015Accident · Minor injuriesData collectionFinal reportBellanca BL-17-30 · Lantana, FLThe pilot's improper preflight planning/decision which resulted in total loss of engine power due to fuel exhaustion.Nov 13, 2006 · N6663V · Substantial damageNTSB MIA07LA014Accident · No injuriesLimited investigationFinal reportCessna 150J · DeFuniak Springs, FLThe loss of engine power for undetermined reasons.Nov 11, 2006 · N50977 · Substantial damageNTSB DFW07FA023Accident · 2 fatalField investigationFinal reportMcCutchan Glasair · Mineral Wells, TXThe pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. A factor was the loss of engine power due to fuel exhaustion.Nov 11, 2006 · N606MC · DestroyedNTSB ATL07CA017Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA 20-C1 · Raleigh, NCThe pilot's failure to maintain airspeed during a go-around, which resulted in a inadvertent stall.Nov 10, 2006 · N190WA · Substantial damageNTSB SEA07FA016Accident · 1 fatalField investigationFinal reportBeech D35 · Shelton, WAThe pilot's failure to refuel the airplane, which resulted in fuel exhaustion, and his failure to maintain sufficient airspeed to avoid a stall during the subsequent forced landing. A factor associated with the accident is the inadvertent stall.Nov 9, 2006 · N2843V · Substantial damageNTSB DFW07LA022Accident · No injuriesLimited investigationFinal reportCessna 152 · Monroe, LAThe failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.Nov 7, 2006 · N94684 · 2 aircraft · Substantial damageNTSB MIA07FA011Accident · 2 fatalField investigationFinal reportBeech BE-76 · Port Orange, FLThe flight instructor's inadequate preflight planning which resulted in fuel exhaustion.Nov 1, 2006 · N6017U · DestroyedNTSB NYC07CA016Accident · No injuriesData collectionFinal reportJahns RV-7 · Farmingdale, NJA loss of engine power due to a disconnected throttle/power lever linkage. A contributingfactor was the owner/builder's improper installation of the throttle linkage.Oct 31, 2006 · N916R · Substantial damageNTSB NYC07CA014Accident · No injuriesData collectionFinal reportCessna 172N · Morgantown, WVThe student pilot's failure to maintain directional control and the flight instructor's improper planning and supervision of the student's solo cross country flight. A contributing factor was the wind gusts.Oct 29, 2006 · N952AC · Substantial damageNTSB CHI07FA009Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Lawrenceville, ILThe improper judgment by the pilot to conduct a flight to, and execute an approach to, an airport with weather conditions that were below the required minimums. Also causal was the pilot's continued descent below the approach minimum descent altitude.…Oct 27, 2006 · N1832N · Substantial damageNTSB SEA07CA010Accident · No injuriesData collectionFinal reportAlexander Lancair 320 · Scappoose, ORThe pilot's failure to maintain aircraft control during a go-around.Oct 22, 2006 · N1382Y · Substantial damageNTSB NYC07LA011Accident · 1 fatalLimited investigationFinal reportBishop Bakeng Duce · South Boston, VAThe pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall. Contributing was the deteriorating weather and diminishing light conditions, the pilot's decision to take off despite the weather advisory, and the pilot's…Oct 22, 2006 · N91BK · Substantial damageNTSB CHI07LA011Accident · No injuriesLimited investigationFinal reportCessna R182 · Ames, IAThe fatigue failure of the landing gear actuator pin and the exterior visual maintenance inspection for cracks not possible by company maintenance personnel.Oct 22, 2006 · N5274S · Substantial damageNTSB MIA07CA007Accident · Minor injuriesData collectionFinal reportCessna 150L · Umatilla, FLThe flight instructor's delayed remedial action during a go-around, which resulted in a failure to maintain sufficient airspeed to avoid a stall/mush, and an in-flight collision with terrain.Oct 20, 2006 · N10772 · Substantial damageNTSB NYC07FA009Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Odenton, MDThe pilot's failure to maintain adequate clearance from terrain during the approach. Contributing was the pilot's self-induced pressure to land the airplane after being informed by air traffic control that he was not operating in compliance with the ADIZ…Oct 19, 2006 · N9130N · DestroyedNTSB NYC07CA010Accident · No injuriesData collectionFinal reportCirrus SR-22 · Lumberton, NJThe pilot's failure to maintain aircraft control during a go-around, which resulted in an in-flight collision with a tree.Oct 19, 2006 · N246MT · Substantial damage