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 WPR12LA359Accident · Serious injuriesLimited investigationFinal reportFechtner KR-2 · Tehachapi, CAThe pilot's failure to maintain control of the airplane during the approach to the airport.Aug 14, 2012 · N37686 · Substantial damageNTSB WPR12CA358Accident · Serious injuriesData collectionFinal reportBoughner R 80 Tiger Moth · Ramona, CAThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.Aug 14, 2012 · N615SX · Substantial damageNTSB CEN12LA545Accident · Serious injuriesLimited investigationFinal reportDykas Kitfox Series 7 · Monroe, MIThe inadequate descent angle flown by the pilot during a final approach for landing, which resulted in an in-flight collision with a power line.Aug 13, 2012 · N646FD · Substantial damageNTSB ERA12LA509Accident · Serious injuriesLimited investigationFinal reportDestiny XLT 2000 · Grayson, GAThe non-certificated pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to fuel exhaustion.Aug 12, 2012 · N103ME · Substantial damageNTSB WPR12CA350Accident · No injuriesData collectionFinal reportCessna 152 · Eastvale, CAThe failure of both pilots to ensure that no water was present in the fuel, which resulted in a complete loss of engine power and a forced off-field landing.Aug 10, 2012 · N94185 · Substantial damageNTSB CEN12LA529Accident · No injuriesLimited investigationFinal reportPiper PA32RT · Palo Pinto, TXThe pilot's failure to maintain directional control and a proper pitch attitude and airspeed while performing a go-around.Aug 7, 2012 · N36103 · Substantial damageNTSB CEN12IA518Incident · No injuriesIncident investigationFinal reportBell 407 · San Antonio, TXThe pilot’s failure to maintain clearance from a tower guy wire during the approach to a helipad at night.Aug 5, 2012 · N429PH · Minor damageNTSB CEN12CA526Accident · Minor injuriesData collectionFinal reportCessna 172R · Leesville, LAThe student pilot's failure to properly re-configure the airplane for a go-around, which resulted in a runway excursion when he decided to land on the remaining runway.Aug 3, 2012 · N989BT · Substantial damageNTSB WPR12CA340Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · McKinleyville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident were the pilot’s lack of experience in the accident airplane make and model and his lack of knowledge regarding the fuel system.Aug 2, 2012 · N3442Z · Substantial damageNTSB ERA12LA494Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLInadequate maintenance servicing and inspection of the nose landing gear, which resulted in the failure of the nose landing gear to lock and its subsequent collapse during landing.Aug 1, 2012 · N740FT · Substantial damageNTSB OPS12IA849Incident · No injuriesIncident investigationFinal reportArlington, VAA hearback/readback error on the part of the tower traffic management coordinator, who did not understand the request being made by the approach control area supervisor and then communicated that misunderstanding to the local controllers. Contributing to the…Jul 31, 2012 · No damageNTSB CEN12CA597Accident · No injuriesData collectionFinal reportBordelon Bruce Kitfox IV · Castlerock, MNPropeller system failure during a go-around maneuver resulting in a forced landing. Contributing to the severity of damage to the airplane was the postimpact fire.Jul 31, 2012 · N396BK · DestroyedNTSB CEN12LA490Accident · Serious injuriesLimited investigationFinal reportSmith Applebay Zuni II · Gregory, MIThe glider pilot’s failure to maintain sufficient altitude and airspeed while turning to the base leg of the traffic pattern, which resulted in a stall/spin and impact with trees and terrain.Jul 29, 2012 · N1ZV · Substantial damageNTSB ERA12WA488Accident · 8 fatalForeign investigationBeech 200 · Juiz de Fora, BrazilThis investigation is being conducted by the Brazilian Aeronautical Accident Prevention and Investigation Center This report is for information purposes only and contains only information released by the government Brazil. All inquiries should be directed to…Jul 28, 2012 · PR-DOC · DestroyedNTSB ERA12LA489Accident · No injuriesLimited investigationFinal reportBeech A36TC · Fayetteville, NCThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Jul 28, 2012 · N6672X · Substantial damageNTSB ERA12LA486Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blacksburg, VAThe pilot’s inadequate preflight planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 27, 2012 · N6248P · Substantial damageNTSB DCA12IA113Incident · No injuriesIncident investigationFinal reportBoeing 737-3H4 · El Paso, TXthe rupture of the nose landing gear hydraulic line that resulted from abrasions due to contact with the nose landing gear tire. Contributing to the incident was the incorrect installation of union and restrictor on the actuator.Jul 27, 2012 · N379SW · Minor damageNTSB ERA12FA483Accident · 1 fatalField investigationFinal reportCessna 172P · Plainville, CTThe pilot's failure to maintain the proper glidepath during final approach in visual meteorological conditions, resulting in collision with a berm.Jul 26, 2012 · N64182 · Substantial damageNTSB ERA12FA484Accident · 1 fatalField investigationFinal reportCessna 172M · San Juan, PRMaintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…Jul 25, 2012 · N73115 · Substantial damageNTSB WPR12TA323Accident · No injuriesFinal reportAero Commander 500 S · Elko, NVA loss of power due to fuel exhaustion. Contributing to the accident were the pilot's failure to comply with required fueling procedures and the pilot's poor decision-making in not monitoring his fuel gauge and turning back when it reached minimum fuel.Jul 24, 2012 · N535SA · Substantial damageNTSB WPR12FA316Accident · Serious injuriesField investigationFinal reportCessna 182P · Corona, CAA loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision to take off…Jul 21, 2012 · N640AM · Substantial damageNTSB ERA12LA470Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Farmingdale, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 21, 2012 · N2166G · Substantial damageNTSB CEN12LA467Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Miami, TXAn in-flight loss of control on final approach for undetermined reasons.Jul 21, 2012 · N9720Q · Substantial damageNTSB CEN12FA462Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Walsenburg, COThe pilot's failure to maintain airplane control while turning from base to final leg in the traffic pattern.Jul 21, 2012 · N96YK · Substantial damageNTSB CEN12LA420Accident · No injuriesLimited investigationFinal reportCessna T210M · Colorado Springs, COThe failure of the right hydraulic main gear down-lock actuator hose in flight.Jul 20, 2012 · N311TM · Substantial damageNTSB WPR12LA313Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Wells, NVA loss of engine power during the final landing approach for reasons that could not be determined because postaccident examination did not reveal any malfunctions or failures that would have precluded normal operation.Jul 19, 2012 · N6181N · Substantial damageNTSB CEN12LA457Accident · Serious injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Peoria, ILThe emergency ground egress during which a passenger broke her ankle. Contributing to the accident was the failure of the environmental system, which allowed smoke from a nearby house fire to enter the airplane.Jul 19, 2012 · N502AE · No damageNTSB CEN12LA446Accident · No injuriesLimited investigationFinal reportSC Iar Sa Brasov IAR 825 · Peru, ILThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 15, 2012 · N825BA · Substantial damageNTSB CEN12LA417Accident · Serious injuriesLimited investigationFinal reportBadeaux Challenger II · New Iberia, LAThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance with the power lines during the landing approach.Jun 29, 2012 · N16665 · Substantial damageNTSB CEN12LA410Accident · Minor injuriesLimited investigationFinal reportSteven Bornstein/Thomas Whitta Zenith · Centerburg, OHThe pilot’s inability to actuate the airplane’s rudder during an attempted go-around for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Jun 29, 2012 · N701ZN · Substantial damageNTSB ERA12LA422Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Mc Kinnon, TNThe separation of the piston connecting rod from the crankshaft due to inadequate installation from a mechanic, resulting in a total loss of engine power.Jun 28, 2012 · N174JB · Substantial damageNTSB ERA12CA418Accident · Minor injuriesData collectionFinal reportGrumman American Avn. AA-1C · West Chester, PAThe pilot’s failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.Jun 27, 2012 · N9675U · Substantial damageNTSB WPR12LA286Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Watsonville, CAA total loss of engine power during approach for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.Jun 24, 2012 · N55DN · Substantial damageNTSB WPR12CA288Accident · Minor injuriesData collectionFinal reportDg-Flugzeugbau DG-500MB · Richland, WAThe failure of the spoilers to retract because the right wing spoiler’s lower plate became jammed, which resulted in the glider not having enough lift to make it to the runway surface.Jun 24, 2012 · N505JL · Substantial damageNTSB ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.Jun 24, 2012 · N9542V · Substantial damageNTSB ANC12CA081Accident · No injuriesData collectionFinal reportPiper J3F-65 · Beluga, AKThe pilot's delayed decision to go around, which resulted in a hard landing.Jun 21, 2012 · N77EC · Substantial damageNTSB ERA12LA401Accident · Serious injuriesLimited investigationFinal reportBeech 400A · Atlanta, GAThe flight crew's failure to obtain the proper airspeed for landing, which resulted in the airplane touching down too fast with inadequate runway remaining to stop and a subsequent runway overrun. Contributing to the accident were the failure of either pilot…Jun 18, 2012 · N826JH · Substantial damageNTSB ERA12LA405Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilots’ operation of the airplane with an insufficient supply of engine oil, resulting in engine seizure and total loss of engine power.Jun 16, 2012 · N67324 · Substantial damageNTSB ERA12CA396Accident · No injuriesData collectionFinal reportCessna 150M · Gulf Shores, ALThe student pilot's improper flight control inputs and the flight instructor's delayed remedial action during the attempted go-around, which resulted in an aerodynamic stall.Jun 14, 2012 · N9119U · Substantial damageNTSB DCA12CA088Accident · Serious injuriesData collectionFinal reportAirbus Industrie A320-212 · Minneapolis, MNInadvertent encounter with convective turbulence while in descent.Jun 11, 2012 · N352NW · No damageNTSB ERA12CA389Accident · Serious injuriesData collectionFinal reportBuckeye Breeze · Lower Burrell, PAThe pilot’s failure to maintain directional control of the powered parachute, which resulted in a collision with trees during final approach. Contributing to the accident was the pilot's lack of flight training.Jun 10, 2012 · N786DS · Substantial damageNTSB ERA12FA387Accident · 1 fatalField investigationFinal reportPhillips William L Challenger · Plant City, FLThe non-certificated pilot’s loss of control during approach and landing. Contributing to the accident was the pilot’s lack of both total and recent flight experience.Jun 9, 2012 · N2571T · Substantial damageNTSB CEN12LA346Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Clark, SDThe pilot’s improper fuel management, which led to fuel exhaustion, and his failure to maintain adequate airspeed resulting in an aerodynamic stall.Jun 7, 2012 · N18012 · Substantial damageNTSB CEN12FA321Accident · 1 fatalField investigationFinal reportBell 206-L4 · (Gulf of Mexico)The pilot’s failure to maintain clearance from an obstacle while landing on an obstructed helipad, which resulted in a collision and loss of control. Contributing to the accident was the failure of the helipad owner to mark the helipad closed and the failure…May 28, 2012 · N7077F · Substantial damageNTSB CEN12FA320Accident · 1 fatalField investigationFinal reportTackabury Air-Cam · Fort Morgan, COThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an aerodynamic stall.May 28, 2012 · N788RJ · Substantial damageNTSB ERA12LA368Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Piney Flats, TNThe mechanic’s improper maintenance of the main transmission aft pinion nut and belt drive system, which resulted in the uncoupling of the tail rotor driveshaft and the subsequent loss of helicopter control.May 24, 2012 · N760DA · Substantial damageNTSB WPR12LA225Accident · Serious injuriesLimited investigationFinal reportWaggonner Excalibur · Buhl, IDThe pilot’s failure to maintain control of the airplane while on final approach, which resulted in an aerodynamic stall.May 22, 2012 · N165AW · Substantial damageNTSB CEN12FA311Accident · 1 fatalField investigationFinal reportCessna T210L · Boyd, TXThe pilot’s delayed initiation of a go-around and early retraction of the flaps during the maneuver, which resulted in a collision with trees.May 21, 2012 · N29112 · Substantial damageNTSB ERA12WA372Accident · 1 fatalForeign investigationCessna 182 · Veronica, ArgentinaOn May 19, 2012, about 2140 universal coordinated time, a Cessna 182C, Argentina registration LV-GTF, was substantially damaged when it impacted terrain during a missed approach at Veronica Airfield, Veronica, Buenos Aires, Argentina. The foreign certificated…May 19, 2012 · LV-GTF · Substantial damageNTSB ERA12CA357Accident · No injuriesData collectionFinal reportHughes TH-55 · Pittsfield, PAThe student pilot's failure to maintain helicopter control during an encounter with loss of tail rotor effectiveness.May 19, 2012 · N74914 · Substantial damage