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 DEN04CA097Accident · No injuriesData collectionFinal reportCessna 172E · La Junta, COthe student pilot's failure to maintain aircraft control and adequate airspeed during the go-around resulting in an inadvertent stall. Contributing to the accident was the low airspeed and altitude.Jul 4, 2004 · N3581S · DestroyedNTSB DEN04CA096Accident · Minor injuriesData collectionFinal reportCessna T210J · Cheyenne, WYthe detachment of the nut and bolt that attaches the throttle control cable to the fuel induction due to improper maintenance. Contributing factors were the fiber optics wire, fence, and ditch, and the unavailability of suitable terrain on which to make a…Jul 3, 2004 · N2KD · Substantial damageNTSB CHI04CA168Accident · No injuriesData collectionFinal reportPeck Vans RV-4 · Palmyra, WIThe pilot's failure to maintain proper airspeed resulting in the inadvertent stall during the go-around. The overload failure of the left main landing gear was a contributing factor.Jun 30, 2004 · N43MP · Substantial damageNTSB ATL04CA144Accident · Minor injuriesData collectionFinal reportMooney M-20E · Thomasville, GAThe pilot's misjudgment of the airspeed and distance during approach to land that resulted in an undershoot and the subsequent collision with the ground.Jun 30, 2004 · N77ET · Substantial damageNTSB LAX04CA246Accident · No injuriesData collectionFinal reportSchweizer 1-35 · Sparks, NVthe pilot's misjudgment of altitude and distance resulting in an undershoot of the runway.Jun 23, 2004 · N2874H · Substantial damageNTSB SEA04FA111Accident · 1 fatalField investigationFinal reportTeST TST-10 M · Enumclaw, WAAircraft control not maintained while maneuvering for landing. A proper glidepath was not maintained was a factor.Jun 21, 2004 · N410JP · Substantial damageNTSB ATL04CA135Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Gulf Shores, ALThe pilot's failure to maintain airspeed that resulted in a stall and the subsequent collision with the ground.Jun 20, 2004 · N82451 · Substantial damageNTSB NYC04LA141Accident · Minor injuriesLimited investigationFinal reportSchleicher ASK-21 · Warren, VTThe pilot's improper pre-flight and in-flight planning, which resulted in a forced landing after experiencing a loss of thermal lift. A factor was the loss of thermal lift.Jun 16, 2004 · N21VT · Substantial damageNTSB LAX04FA241Accident · 1 fatalField investigationFinal reportCessna 337 · Carson City, NVthe pilot's failure to maintain an adequate airspeed while maneuvering during a go-around that led to an inadvertent stall spin.Jun 16, 2004 · N63BB · DestroyedNTSB ATL04LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-301 · Baxley, GAThe mechanical malfunction of the autopilot pitch servo, and the pilot's inability to maintain adequate control pressure to manually retrim the pitch attitude.Jun 14, 2004 · N8451E · Substantial damageNTSB ANC04FA063Accident · 1 fatalField investigationFinal reportBeech C-45H · Kodiak, AKThe pilot's failure to follow proper IFR procedures by not adhering to the published missed approach procedures, which resulted in an in-flight collision with tree-covered terrain. Factors contributing to the accident were a low ceiling, fog, rain, and the…Jun 14, 2004 · N401CK · DestroyedNTSB LAX04CA238Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Anza, CAThe pilot's misjudged altitude and speed, which resulted in an undershoot and a collision with a berm. Also causal was the control interference from the passenger.Jun 13, 2004 · N9009J · Substantial damageNTSB DEN04TA088Accident · Serious injuriesFinal reportCessna C172P · Las Cruces, NMthe pilot's failure to maintain clearance from terrain and the improper go-around procedure. Contributing factors include the pilot's diverted attention, improper in-flight planning and decision making, pilot fatigue, the night conditions and the mesquite…Jun 10, 2004 · N9474L · Substantial damageNTSB CHI04CA141Accident · Minor injuriesData collectionFinal reportDoerr Raymond R RV-9A · Fort Scott, KSThe vapor lock of the airplane fuel system and the ditch encountered during the emergency landing..Jun 6, 2004 · N369RV · Substantial damageNTSB SEA04LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Columbus, MTThe pilot's failure to maintain directional control of the aircraft during the landing and subsequent go-around. Inadequate compensation for the gusting winds and an airport hangar were factors.Jun 5, 2004 · N82172 · Substantial damageNTSB FTW04LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Benton, ARThe student pilot's failure to maintain airspeed resulting in an inadvertent stall during a go-around.Jun 5, 2004 · N5677E · Substantial damageNTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.Jun 4, 2004 · N50923 · Substantial damageNTSB CHI04CA135Accident · Minor injuriesData collectionFinal reportCessna T210L · Wichita, KSThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.Jun 4, 2004 · N59027 · Substantial damageNTSB ATL04CA125Accident · Serious injuriesData collectionFinal reportTaylorcraft DC-65 · Savannah, TNThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power.Jun 4, 2004 · N39190 · Substantial damageNTSB NYC04FA136Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Leominster, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with trees. A factor related to the accident was the low cloud ceiling, and dark night.Jun 2, 2004 · N21072 · DestroyedNTSB CHI04FA133Accident · 4 fatalField investigationFinal reportCessna U206F · Owatonna, MNThe altitude/clearance not maintained by the pilot-in-command during a precision instrument approach. A contributing factor was the instrument meteorological conditions.Jun 2, 2004 · N81685 · DestroyedNTSB CHI04CA132Accident · No injuriesData collectionFinal reportCessna 150 · Midland, MIThe student pilot failed to maintain control of the airplane during the go-around. A factor associated with the accident was the student's lack of experience.Jun 1, 2004 · N959B · Substantial damageNTSB LAX04LA230Accident · No injuriesLimited investigationFinal reportCessna T210M · Santa Rosa, CAMaintenance personnel's improper installation and servicing of a retaining ring, which resulted in the failure of the landing gear door actuator and failure of the landing gear extension system during landing.May 30, 2004 · N121JR · Substantial damageNTSB ATL04LA123Accident · 1 fatalLimited investigationFinal reportCessna 310 · N. Myrtle Beach, SCThe pilot's inadequate preflight/planning and his in-flight decision which resulted in the loss of power in one engine due to fuel starvation.May 30, 2004 · N361Z · Substantial damageNTSB NYC04FA127Accident · 1 fatalField investigationFinal reportMooney M20J · Oxford, CTThe pilot's failure to maintain altitude/clearance during an instrument approach, which resulted in a collision with trees prior to the runway. Factors were nighttime conditions and cloud cover.May 24, 2004 · N5763W · Substantial damageNTSB DEN04FA074Accident · 2 fatalField investigationFinal reportPiper PA-30 · Evanston, WYthe pilot's failure to maintain terrain clearance. Contributing factors include snow, low ceiling, icing conditions, and the dark night.May 24, 2004 · N7460Y · DestroyedNTSB NYC04CA128Accident · Serious injuriesData collectionFinal reportCameron Balloons N90 · Whately, MAThe pilot's failure to maintain clearance from the trees. A factor was windshear.May 23, 2004 · N6123U · Minor damageNTSB ANC04FA056Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Cold Bay, AKA loss of engine power during the final approach to land for an undetermined reason, and the pilot's failure to maintain airspeed during the ensuing emergency descent, which resulted in an inadvertent stall. A factor associated with the accident was the stall.May 22, 2004 · N4319Z · Substantial damageNTSB ATL04FA118Accident · 1 fatalField investigationFinal reportBeech A36 · Morrisville, NCThe failure of the engine for undetermined reasons resulting in the aircraft colliding with powerlines and the ground during the subsequent forced landing.May 17, 2004 · N4550S · Substantial damageNTSB SEA04LA085Accident · No injuriesLimited investigationFinal reportStinson SR-10E · Eliza Island, WAThe pilot's misjudgment of altitude/distance resulting in an undershoot of the runway.May 16, 2004 · N27782 · Substantial damageNTSB FTW04IA128Incident · No injuriesIncident investigationFinal reportLockheed 1329-23E · Houston, TXThe fatigue failure of the inboard left wing actuator fitting.May 15, 2004 · N57NR · Minor damageNTSB IAD04FA021Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Ferndale, MDThe pilot's failure to maintain airspeed during a sharp turn, which resulted in an inadvertent stall and subsequent impact with terrain. Factors included the pilot's failure to fly to the intended point of landing, and his abrupt course reversal back towards…May 14, 2004 · N755AF · DestroyedNTSB NYC04CA124Accident · Minor injuriesData collectionFinal reportFraker Mustang II · Wauseon, OHThe failure of the drive coupling between the engine and the propeller speed reducer. A factor related to the accident was the pilot's inadequate preflight inspection of the drive coupling.May 13, 2004 · N78K · Substantial damageNTSB MIA04LA082Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Lake Worth, FLThe loss of engine power for undetermined reasons which resulted in a forced landing, collision with a berm during landing rollout, and the airplane nosing over.May 12, 2004 · N551PK · Substantial damageNTSB ATL04LA112Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Cortland, ALThe pilot's misjudgment of distance/altitude and his failure to maintain obstacle clearance which resulted in an undershoot and collision with trees.May 11, 2004 · N7123R · Substantial damageNTSB FTW04LA123Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Industries DA-40 · Georgetown, TXThe failure of both pilot's to maintain an adequate visual lookout, which resulted in a midair collision between the two airplanes.May 9, 2004 · N89SE · 2 aircraft · Substantial damageNTSB DEN04LA071Accident · Serious injuriesLimited investigationFinal reportCessna A185E · Englewood, COthe pilot's inadequate preflight planning which failed to verify an adequate fuel supply and his inadequate in-flight planning/decision which resulted in fuel exhaustion. The inadequate indication of his fuel quantity system is a contributing factor.May 8, 2004 · N185K · Substantial damageNTSB CHI04CA117Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · DeKalb, ILThe failure of the pilot and his flight instructor to identify the location of the relocated threshold and proper touchdown point, which resulted in the airplane striking the construction barricade while on approach. A factor to the accident was the…May 8, 2004 · N81898 · Substantial damageNTSB CHI04CA115Accident · No injuriesData collectionFinal reportVilleneuve RV-3 · Mayetta, KSThe pilot failed to maintain airspeed and aircraft control during final approach, which resulted in a stall/mush flight condition. A factor to the accident was the crosswind and the trees.May 8, 2004 · N12JV · Substantial damageNTSB MIA04CA080Accident · Minor injuriesData collectionFinal reportBeech H35 · Fort Pierce, FLThe pilots failure to maintain the proper glide path during the approach which resulted in the airplane undershooting the runway and not attaining the proper touchdown point.May 6, 2004 · N87AD · Substantial damageNTSB ATL04LA111Accident · 1 fatalLimited investigationFinal reportRiggs Skyraider 1 · Blounts Creek, NCThe pilot's failure to maintain adequate airspeed which resulted in a stall. A factor was loss of engine power and water in the fuel.May 6, 2004 · N321TR · Substantial damageNTSB ATL04FA107Accident · 2 fatalField investigationFinal reportMooney M20M · Cary, NCThe pilot experienced spatial disorientation, which resulted in a loss of control and the subsequent collision with trees. Factors were low ceilings and fog.May 3, 2004 · N91514 · Substantial damageNTSB SEA04CA076Accident · No injuriesData collectionFinal reportMooney M-20J · Redmond, ORThe pilot's failure to adequately compensate for wind conditions. Unfavorable wind was a factor.Apr 30, 2004 · N5764K · Substantial damageNTSB NYC04CA112Accident · No injuriesData collectionFinal reportBolger Scott RV-6A · Fredericksburg, VAThe pilots failure to maintain airspeed during a precautionary landing which resulted in an undershoot and subsequent impact with terrain. A factor was the inadequate pre-flight inspection.Apr 28, 2004 · N999SB · Substantial damageNTSB SEA04LA073Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Haines, ORA momentary partial loss of power for undetermined reason(s) and the pilot's failure to maintain adequate RPM during his autorotation landing.Apr 26, 2004 · N9785C · Substantial damageNTSB ANC04LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Minto, AKThe loss of engine power for an undetermined reason, which resulted in a forced landing and an in-flight collision with trees.Apr 25, 2004 · N2833R · Substantial damageNTSB CHI04CA109Accident · Serious injuriesData collectionFinal reportAeronca 7AC · Flushing, MIThe pilot's failure to maintain airspeed while on final approach, resulting in an inadvertent stall at a low altitude.Apr 24, 2004 · N83291 · Substantial damageNTSB MIA04FA076Accident · 2 fatalField investigationFinal reportCessna 177RG · Tampa, FLImproper maintenance by other maintenance personnel, and the reinstallation of an unserviced magneto during an engine overhaul, which resulted in the magneto malfunctioning, a loss of engine power, and the airplane being ditched into the water.Apr 20, 2004 · N1910Q · Substantial damageNTSB NYC04LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Berkley, MAThe pilot's misjudgment of altitude/distance and his failure to maintain adequate clearance from trees while landing. Factors related to the accident were the lack runway displaced threshold markings, the trees located at the end of the runway, and the…Apr 19, 2004 · N9862D · Substantial damageNTSB IAD04FA017Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · North Lima, OHThe pilot's failure to maintain a safe altitude clearance from trees. Factors included the night lighting conditions and the pilot's diminished night vision capability.Apr 19, 2004 · N5369P · Destroyed