OpenAirDocs.org

NTSB investigations, 2012

181 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\") = 2012
    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 ERA13WA103Accident · 2 fatalForeign investigationPiper PA28 · Minas City, BrazilOn December 26, 2012, at 2050 universal coordinated time, a Piper PA-28-181, Brazilian registration PR-NAX, was destroyed when it impacted the ground after the crew lost control during a go around. The instructor pilot and student were fatally injured. The…Dec 26, 2012 · PR-NAX · DestroyedNTSB DCA13WA041Accident · Serious injuriesForeign investigationFokker 100 · Heho, Myanmar (Burma)On December 25, 2102, at 08:50 local time, a Fokker 100, registration XY-AGC operated by Air Bagan as flight W9-11 crashed short of the runway at Heho Myanmar (Burma). The flight was a scheduled passenger flight from Mandalay. There was one fatality and…Dec 25, 2012 · XY-AGC · Substantial damageNTSB WPR13FA074Accident · 1 fatalField investigationFinal reportCharland Vortex · Wellton, AZThe pilot’s failure to maintain aircraft control while maneuvering in the traffic pattern.Dec 23, 2012 · N618TC · Substantial damageNTSB CEN13TA113Accident · Minor injuriesFinal reportCessna 550 · Oklahoma City, OKThe flight crew's decision to fly close behind a heavy airplane, which did not ensure there was adequate distance and time in order to avoid a wake turbulence encounter with the preceding heavy airplane’s wake vortex, which resulted in a loss of airplane…Dec 21, 2012 · N753CC · Substantial damageNTSB CEN13LA109Accident · No injuriesLimited investigationFinal reportBeech A23 · Grand Isle, NEThe student pilot's inadequate fuel management due to distraction by airport traffic, which resulted in a loss of engine power due to fuel starvation.Dec 18, 2012 · N3573R · Substantial damageNTSB ERA13FA088Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Parkton, NCThe failure of the instrument-rated pilot to maintain control of the airplane while in instrument meteorological conditions after reporting a gyro malfunction. Contributing to the accident was the loss of primary gyro flight instruments due to the failure of…Dec 16, 2012 · N5714W · Substantial damageNTSB CEN13CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Bellview, TXThe pilot's inadequate compensation for a sudden wind shift during the approach and landing, which resulted in a runway overrun.Dec 15, 2012 · N735BV · Substantial damageNTSB WPR13CA065Accident · No injuriesData collectionFinal reportBellanca 7ECA · Tehachapi, CAThe non-instrument-rated pilot's continued descent into instrument meteorological conditions during the landing approach and his loss of situational awareness, which resulted in a collision with terrain.Dec 8, 2012 · N8595V · Substantial damageNTSB CEN13LA097Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Moody, TXThe total loss of engine power for reasons that could not be determined because the examination of the engine did not reveal any anomalies that would have precluded normal operation.Dec 8, 2012 · N280JM · Substantial damageNTSB CEN13LA099Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Abilene, TXThe flight instructor's failure to conduct an autorotation following the loss of engine power due to fuel exhaustion. Contributing to the accident was the failure of the flight instructor and the student pilot to visually check fuel levels to ensure adequate…Dec 7, 2012 · N574H · Substantial damageNTSB CEN13LA094Accident · No injuriesLimited investigationFinal reportLsa America Allegro · Adrian, MIThe student pilot’s improper flight control input during a go-around and his interference with the flight instructor’s attempted remedial actions.Dec 6, 2012 · N448SS · Substantial damageNTSB DCA13CA066Accident · No injuriesData collectionFinal reportBombardier CL-600-2B19 · New York, NYan inadvertant birdstrike on approach.Dec 5, 2012 · N411ZW · Substantial damageNTSB CEN13LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Rochester, MNThe pilot’s spatial disorientation during the instrument approach in night, instrument meteorological conditions, which resulted in the airplane descending below decision height and impacting terrain outside the lateral limits of the localizer. Contributing…Dec 3, 2012 · N9853Q · Substantial damageNTSB ERA13LA076Accident · 1 fatalLimited investigationFinal reportCassutt Sport Racer · Collegedale, TNImpact with trees and terrain during the landing approach likely due to the physiological incapacitation of the pilot.Dec 2, 2012 · N9CA · Substantial damageNTSB ERA13CA077Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Middletown, NYThe pilot's improper altitude management in the landing pattern that caused the glider to impact trees on final approach.Dec 2, 2012 · N5787S · Substantial damageNTSB CEN13CA083Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.Dec 2, 2012 · N562BG · Substantial damageNTSB ERA13CA073Accident · No injuriesData collectionFinal reportBeech B19 · Fort Lauderdale, FLThe pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.Dec 1, 2012 · N2196W · Substantial damageNTSB CEN13FA081Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Blair, NEThe pilot's loss of control due to physical incapacitation.Nov 29, 2012 · N720RC · Substantial damageNTSB ERA13LA069Accident · Serious injuriesLimited investigationFinal reportLawson J/Bowie R/Smith M CA-8 · Merritt Island, FLThe pilot's improper decision to continue a cross-country flight as a primary control (aileron) system anomaly progressively worsened. Contributing to the accident was an aileron control system anomaly, the reason for which could not be determined because the…Nov 28, 2012 · N155JD · Substantial damageNTSB CEN13FA078Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Clutier, IAThe pilot’s failure to monitor, recognize, and identify obstacles on approach to landing, which resulted in an inadvertent collision with power lines. Contributing to the accident was the pilot’s expectation and assumption that there were no above-ground…Nov 28, 2012 · N94973 · Substantial damageNTSB CEN13FA067Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hillsdale, MIThe pilot's failure to maintain clearance from terrain during a straight-in night visual flight rules approach to land in hazy weather conditions. Contributing to the accident were the pilot's lack of recent night flying experience, the nonfunctional…Nov 21, 2012 · N40781 · Substantial damageNTSB CEN13FA066Accident · 1 fatalField investigationFinal reportBrian P North RAF SE5A Replica · Watkins, COThe pilot’s loss of airplane control and inadvertent stall while attempting to return for landing.Nov 21, 2012 · N17SE · Substantial damageNTSB ERA13LA065Accident · No injuriesLimited investigationFinal reportBeech C90A · Roanoke, VAThe failure of the right main landing gear bearing actuator support brackets. Contributing to the accident was the owner's and operator's failure to comply with the airplane manufacturer's mandatory service bulletin and the Federal Aviation Administration's…Nov 20, 2012 · N702DK · Substantial damageNTSB ERA13FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Canton, CTThe pilot’s failure to maintain clearance from terrain while performing a night visual approach to an airport. Contributing to the accident were the dark night and the pilot's lack of recent experience flying at night.Nov 19, 2012 · N8826J · Substantial damageNTSB CEN13LA063Accident · 1 fatalLimited investigationFinal reportRedd Tom Quicksilver GT 400 · Oak Grove, LAThe total loss of engine power, the specific cause of which could not be identified during the postaccident examination, and the airplane’s subsequent impact with trees.Nov 19, 2012 · N4031Q · Substantial damageNTSB ERA13FA062Accident · 1 fatalField investigationFinal reportCessna 172K · Savannah, GAThe pilot's failure to maintain airplane control while operating in night, instrument meteorological conditions, due to spatial disorientation.Nov 18, 2012 · N78304 · Substantial damageNTSB ERA13LA060Accident · Minor injuriesLimited investigationFinal reportBeech 35B33 · White Plains, NYThe pilot's improper fuel management and his excessive slip maneuver, which led to fuel starvation and a total loss of engine power, and his failure to activate the electric boost pump during the attempted engine restart.Nov 17, 2012 · N8519M · Substantial damageNTSB ERA13LA058Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lexington, KYThe rupture of the landing gear’s hydraulic pressure hose, which resulted in the depletion of all of the hydraulic fluid, and the inability of the landing gear to raise or lower. Contributing to the accident was the installation of an unapproved hydraulic…Nov 15, 2012 · N9985B · Substantial damageNTSB ERA13LA053Accident · No injuriesLimited investigationFinal reportCessna 210 · Jasper, GAA loss of engine power due to fuel starvation as a result of the pilot’s prolonged sideslip maneuvers during the descent to landing. Contributing to the accident was the airplane’s lack of a required placard advising pilots to avoid lengthy sideslip maneuvers…Nov 11, 2012 · N9633T · Substantial damageNTSB ERA13LA054Accident · No injuriesLimited investigationFinal reportVans RV-12 · Williamson, GAThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision.Nov 10, 2012 · N678AD · 2 aircraft · Substantial damageNTSB ERA13WA074Accident · 4 fatalForeign investigationPiper PA-31T · Curitiba, BrazilOn November 6, 2012, at 2030 Coordinated Universal Time (UTC), a Piper PA-31T, Brazilian registration PT-MFW, was destroyed when it impacted terrain while approaching Bacacheri Airport (SBBI), Curitiba, Brazil. The flight was operated by Taxi Aereo Hercules,…Nov 6, 2012 · PT-MFW · DestroyedNTSB CEN13FA045Accident · 1 fatalField investigationFinal reportCessna 150F · Gothenburg, NEThe student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.Nov 4, 2012 · N8375G · Substantial damageNTSB CEN13LA041Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Roanoke, TXThe student pilot's failure to maintain clearance from obstacles on the runway approach path. Contributing to the accident was the airport management's decision to relocate the runway displaced threshold, which did not provide an adequate safety margin for…Nov 3, 2012 · N985GE · Substantial damageNTSB CEN13FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Maryland Heights, MOThe pilot’s failure to activate the carburetor heat while operating in conditions conducive to carburetor icing, which resulted in a loss of engine power due to carburetor ice.Oct 25, 2012 · N55620 · Substantial damageNTSB CEN13LA029Accident · 1 fatalLimited investigationFinal reportQuad City Challenger · Castroville, TXThe pilot’s steep 180-degree turn to final approach for landing, which resulted in an inadvertent stall and spin at an altitude from which he could not recover.Oct 23, 2012 · UNREG · Substantial damageNTSB CEN13LA016Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Wausau, WIThe pilot's decision to attempt an instrument approach in meteorological conditions below approach minimums and his failure to properly execute a missed approach.Oct 17, 2012 · N121VP · Substantial damageNTSB WPR13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Corona, CATotal loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.Oct 13, 2012 · N4309E · Substantial damageNTSB ERA13LA018Accident · No injuriesLimited investigationFinal reportSikorsky S-55B · Yorktown, NYThe pilot's improper decision to perform a downwind precautionary landing and the helicopter’s resultant settling with power and impact with terrain.Oct 12, 2012 · N443FD · Substantial damageNTSB ERA13WA108Incident · No injuriesForeign investigationSikorsky S61 · Carauari, BrazilOn October 10, 2012, at 1630 Coordinated Universal Time (UTC), a Sikorsky S-61, Brazilian registration PR-HRU, experienced a loss of power in the number one engine and performed a single-engine landing to Carauari Airport, Carauari Municipality, Brazil. The…Oct 10, 2012 · PR-HRU · No damageNTSB ANC13CA002Accident · No injuriesData collectionFinal reportCessna U206F · Buckland, AKThe pilot's loss of airplane control during final approach in gusty wind conditions.Oct 9, 2012 · N9575G · Substantial damageNTSB WPR13LA005Accident · Minor injuriesLimited investigationFinal reportCessna 180H · St Maries, IDThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.Oct 7, 2012 · N2780X · Substantial damageNTSB ERA13LA012Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Birmingham, ALThe pilot's failure to maintain airplane control during a missed approach in instrument meteorological conditions. Contributing to the accident was the pilot's overreliance on the autopilot system and his inability to hand-fly the airplane once the autopilot…Oct 6, 2012 · N80KW · Substantial damageNTSB WPR13LA002Accident · 1 fatalLimited investigationFinal reportWood Mustang II FB · San Manuel, AZThe pilot's failure to maintain adequate airspeed while maneuvering to final approach due to his distraction by the low engine oil pressure, which resulted in an aerodynamic stall.Oct 4, 2012 · N112MW · Substantial damageNTSB WPR13FA001Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Beatty, NVThe pilot’s inadequate flight planning, subsequent loss of situational awareness, and failure to maintain clearance from the power lines during a dark night approach to a closed, unlit runway.Oct 3, 2012 · N7895W · Substantial damageNTSB CEN13FA002Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Gary, INThe pilot's loss of control during an instrument approach due to spatial disorientation. Contributing to the accident were deficient approach control services and the pilot's loss of positional awareness.Oct 3, 2012 · N308PJ · Substantial damageNTSB WPR12LA441Accident · Minor injuriesLimited investigationFinal reportTeam MINI-MAX · Chula Vista, CAA complete loss of engine power as a result of fuel starvation due to an unsecured fuel filter, which moved in flight and kinked the flexible fuel line, severely restricting the fuel flow to the carburetor. Contributing to the accident was the inadequate…Oct 1, 2012 · N1532W · Substantial damageNTSB CEN12LA675Accident · No injuriesLimited investigationFinal reportBeech E33 · Greeley, COThe loss of engine power for reasons that could not be determined during postaccident examinations and testing.Sep 26, 2012 · N7133N · Substantial damageNTSB CEN12CA658Accident · No injuriesData collectionFinal reportCessna 175A · Spearfish, SDThe pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain.Sep 25, 2012 · N6979E · Substantial damageNTSB ERA12LA575Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Fort Thomas, KYThe pilot’s failure to periodically add engine power during an extended descent in carburetor icing conditions, which resulted in insufficient carburetor heat, the gradual build-up of carburetor ice, and the subsequent loss of engine power.Sep 23, 2012 · N735FJ · Substantial damageNTSB WPR12FA432Accident · 1 fatalField investigationFinal reportKundel Vans RV 7A · Laramie, WYThe pilot’s decision to attempt a landing with a gusting tailwind, which resulted in his loss of airplane control during final approach and a subsequent aerodynamic stall/spin.Sep 21, 2012 · N423RA · Destroyed