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 MIA05CA041Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Holly Springs, MSThe failure of the pilot to maintain directional control of the airplane while performing a go-around after a bounced landing, resulting in the on ground collision with trees.Dec 4, 2004 · N3570J · Substantial damageNTSB IAD05LA022Accident · No injuriesLimited investigationFinal reportCessna 414 · Petersburg, VAThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain adequate airspeed (Vmc).Dec 2, 2004 · N2EQ · Substantial damageNTSB NYC05FA026Accident · No injuriesField investigationFinal reportGulfstream Aerospace G-IV · Teterboro, NJThe flightcrew's inadvertent engagement of the autothrottle system, and their failure to recognize the engagement during landing, which resulted in a runway excursion. Factors were the lack of autothrottle switch guards, lack of an autothrottle engagement…Dec 1, 2004 · G-GMAC · Substantial damageNTSB CHI05CA039Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lee's Summit, MOThe inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power. Contributing factors were the muddy terrain and the vegetation.Dec 1, 2004 · N3575X · Substantial damageNTSB ATL05LA031Accident · No injuriesLimited investigationFinal reportCessna 172K · Smyrna, TNThe pilot's inadequate preflight planning of fuel required for the flight, and his inadequate in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.Nov 29, 2004 · N78402 · Substantial damageNTSB NYC05CA023Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Appomattox, VAthe pilot's misjudgment of distance and altitude.Nov 26, 2004 · N33061 · Substantial damageNTSB NYC05FA021Accident · 2 fatalField investigationFinal reportCessna 310R · Paeonian Spring, VAThe pilot's failure to follow the published instrument approach procedure, which resulted in an in-flight collision with terrain. A factor related to the accident was the low cloud ceiling.Nov 24, 2004 · N310DM · Substantial damageNTSB CHI05LA033Accident · No injuriesLimited investigationFinal reportCessna 150H · Columbia, ILA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. Factors were the unsuitable field encountered during the forced landing, the muddy field, and the dark night.Nov 24, 2004 · N6932S · Substantial damageNTSB DCA05MA011Accident · 3 fatalClass 1 · MajorFinal reportGulfstream Aerospace G-III · Houston, TXthe flight crew's failure to adequately monitor and cross check the flight instruments during the approach. Contributing to the accident was the flight crew's failure to select the instrument landing system frequency in a timely manner and to adhere to…Nov 22, 2004 · N85VT · DestroyedNTSB ATL05CA028Accident · No injuriesData collectionFinal reportEnstrom F-28A · Smyrna, TNThe loss of engine power for undetermined reasons, and the pilot's improper flare during forced landing, which resulted in an inflight collision into an open field.Nov 22, 2004 · N9235 · Substantial damageNTSB DEN05IA027Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe first officer's failure to maintain proper glide slope during the landing approach, and the captain's failure to adequately monitor the approach and landing, and his failure to challenge and/or intervene when the first officer continued to descend below…Nov 21, 2004 · N234AA · Minor damageNTSB ATL05CA027Accident · Serious injuriesData collectionFinal reportBeech A36TC · Huntsville, ALThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation and a forced landing to an open field.Nov 20, 2004 · N38047 · Substantial damageNTSB IAD05CA015Accident · No injuriesData collectionFinal reportSocata TB 21-TC · Binghamton, NYThe pilot's improper IFR procedure by his flight below the decision altitude, and his failure to maintain obstacle clearance.Nov 18, 2004 · N55510 · Substantial damageNTSB NYC05LA017Accident · 1 fatalLimited investigationFinal reportLabhart Kolb Twinstar Mk III · London, KYThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination. A factor was the lack of an installed fuel strainer.Nov 14, 2004 · N83NK · Substantial damageNTSB DFW05FA020Accident · 5 fatalField investigationFinal reportPiper PA-31-350 · San Antonio, TXThe pilot's failure to maintain control during an ILS approach. Contributing factors were the prevailing instrument meteorological conditions( clouds, low ceiling and drizzle/mist), and the pilot's spatial disorientation.Nov 14, 2004 · N40731 · DestroyedNTSB CHI05LA030Accident · 1 fatalLimited investigationFinal reportHedge Bede-4 · Omaha, NEThe pilot's failure to maintain control of the airplane resulting in a stall and spin, while on approach to land. Contributing factors were the airplane's low altitude and low airspeed at the time of loss of control.Nov 13, 2004 · N435BD · Substantial damageNTSB LAX05LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Apple Valley, CAloss of engine power due to fuel starvation/exhaustion, which was a result of the pilot's inadequate preflight inspection and failure to ensure there was enough fuel onboard for the flight.Nov 12, 2004 · N5LT · Substantial damageNTSB LAX05CA031Accident · Minor injuriesData collectionFinal reportCessna P210N · North Las Vegas, NVthe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's inadequate preflight planning/preparation which failed to assure an adequate fuel supply.Nov 11, 2004 · N6663P · Substantial damageNTSB SEA05LA014Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Boise, IDThe pilot's failure to maintain the required glidepath, and his failure to maintain obstacle clearance after visual contact with the runway during the instrument approach.Nov 9, 2004 · N162WA · Substantial damageNTSB CHI05LA023Accident · 1 fatalLimited investigationFinal reportTaylorcraft BC12-D · Wasta, SDThe pilot inadvertently pulled the fuel shut off valve resulting in fuel starvation and a subsequent loss of engine power. The pilot also failed to maintain adequate airspeed which resulted in the airplane stalling.Nov 6, 2004 · N39971 · Substantial damageNTSB LAX05FA026Accident · 1 fatalField investigationFinal reportCessna T210M · Lomita, CAA loss of engine power due to fuel starvation as a result of the pilot's mismanagement and inadequate preflight inspection.Nov 5, 2004 · N732RW · DestroyedNTSB ATL05CA019Accident · Serious injuriesData collectionFinal reportCessna 172N · Columbia, SCThe pilot's inadequate preflight planning of fuel required for the flight, which resulted in fuel exhaustion and subsequent loss of engine power.Nov 3, 2004 · N4874G · Substantial damageNTSB DEN05LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Ogden, UTthe loss of engine power due to carburetor icing. Contributing factors include the weather conditions conducive for carburetor icing, and a lack of suitable terrain for a forced landing.Nov 2, 2004 · N7852P · Substantial damageNTSB LAX05LA027Accident · No injuriesLimited investigationFinal reportCessna 172RG · Kingman, AZLanding gear extension system component failure resulting in a gear up landing.Nov 1, 2004 · N6140R · Substantial damageNTSB LAX05LA022Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Martin, CAA loss of power for undetermined reasons.Oct 31, 2004 · N903B · Substantial damageNTSB LAX05LA021Accident · No injuriesLimited investigationFinal reportCessna 210A · North Las Vegas, NVloss of engine power for undetermined reasons.Oct 30, 2004 · N6675X · Substantial damageNTSB NYC05LA012Accident · 1 fatalLimited investigationFinal reportDouglas Adventure Air Ampib · Pawtucket, RIThe pilot's failure to maintain aircraft control, which resulted in an inadvertent stall.Oct 29, 2004 · N469PD · DestroyedNTSB NYC05LA009Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Dulles, VAThe pilot's improper in-flight decision to continue the instrument approach and landing, which resulted in a collision with a sign. A factor was the below instrument approach landing minimum weather conditions.Oct 26, 2004 · N888TR · Substantial damageNTSB ATL05LA012Accident · No injuriesLimited investigationFinal reportRogers Lancair IVP · Sylvester, GAThe loss of engine power for undetermined reasons.Oct 26, 2004 · N724HP · Substantial damageNTSB MIA05LA013Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Juan, PRThe pilot-in-command's failure to maintain airspeed while on base to final leg, which resulted in an inadvertent stall/mush and subsequent impact with the runway.Oct 25, 2004 · N62711 · Substantial damageNTSB LAX05CA016Accident · Minor injuriesData collectionFinal reportBellanca BL17-30 · Las Vegas, NVthe pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power.Oct 25, 2004 · N4894V · Substantial damageNTSB ATL05FA011Accident · 1 fatalField investigationFinal reportBeech BE-P35 · Aiken, SCThe pilot’s failure to follow IFR procedures, and continued flight below the minimum descent altitude and collided with trees.Oct 25, 2004 · N32AB · DestroyedNTSB IAD05MA006Accident · 10 fatalClass 1 · MajorFinal reportBeech 200 · Stuart, VAThe flight crew's failure to properly execute the published instrument approach procedure, including the published missed approach procedure, which resulted in controlled flight into terrain. Contributing to the cause of the accident was the flight crew's…Oct 24, 2004 · N501RH · DestroyedNTSB SEA05LA011Accident · No injuriesLimited investigationFinal reportCessna T210H · Missoula, MTThe pilot's failure to follow published procedures/directives (inducing excessive fuel flow to the engine), and the subsequent loss of engine power for nonmechanical reasons while on final approach. Contributing factors were the utility pole and the ditch.Oct 23, 2004 · N2240R · Substantial damageNTSB DEN05LA013Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Glenwood Spring, COthe pilot's failure to use carburetor heat which resulted in the formation of carburetor ice and the loss of engine power. Related factors were conditions conducive for carburetor icing and the lack of suitable terrain for a forced landing.Oct 23, 2004 · N9176A · Substantial damageNTSB DCA05MA004Accident · 13 fatalClass 1 · MajorFinal reportBritish Aerospace Jetstream 32 · Kirksville, MOthe pilots' failure to follow established procedures and properly conduct a nonprecision instrument approach at night in IMC, including their descent below the minimum descent altitude (MDA) before required visual cues were available (which continued…Oct 20, 2004 · N875JX · DestroyedNTSB SEA05LA010Accident · No injuriesLimited investigationFinal reportBeech 99A · Billings, MTthe pilot's failure to follow the instrument approach procedure, which resulted in a premature descent below the decision height and subsequent collision with a building.Oct 18, 2004 · N955AA · Substantial damageNTSB ATL05LA005Accident · Serious injuriesLimited investigationFinal reportMoody Easy Riser · Augusta, GAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall/spin, and subsequent collision with the ground.Oct 17, 2004 · N87EZ · Substantial damageNTSB IAD05LA005Accident · No injuriesLimited investigationFinal reportBeech C24R · Hyannis, MAThe mechanic's failure to secure the fuel pressure line to the fuel pressure gauge fitting, which resulted in an engine compartment fire and a subsequent loss of engine power.Oct 15, 2004 · N6598C · Substantial damageNTSB ANC05CA007Accident · No injuriesData collectionFinal reportPiper PA-18 · Wasilla, AKThe pilot's failure to maintain adequate airspeed during the landing approach, which resulted in a stall and an uncontrolled descent to the runway. A factor contributing to the accident was an inadvertent stall.Oct 15, 2004 · N9146D · Substantial damageNTSB ANC05CA005Accident · No injuriesData collectionFinal reportCessna 207 · Chefornak, AKThe in-flight collision with a bird while on final approach to land.Oct 11, 2004 · N5277J · Substantial damageNTSB NYC05LA002Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Harrison, OHThe Cessna 152 pilot's improper traffic pattern procedure and improper radio communication, which resulted in a mid-air collision with a Cessna 172. A factor in the accident was both pilots' failure to maintain an adequate visual lookout.Oct 10, 2004 · N68298 · 2 aircraft · Substantial damageNTSB CHI05CA005Accident · No injuriesData collectionFinal reportBuss Rotorway Exec · Eden Prairie, MNThe pilot's inadvertent deactivation of the battery switch leading to the helicopter's loss of engine power on base leg. A factor was the crops he encountered during the emergency landing.Oct 9, 2004 · N82DR · Substantial damageNTSB LAX05CA003Accident · No injuriesData collectionFinal reportCessna 152 · San Jose, CAan in-flight collision with a bird.Oct 4, 2004 · N24373 · Substantial damageNTSB CHI05CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marion, IAThe pilot's inadequate compensation for the gusting wind conditions and his failure to maintain aircraft control. Factors to the accident were the encountered turbulence, the gusting wind conditions and the airport hangar.Oct 3, 2004 · N7841N · Substantial damageNTSB MIA04LA132Accident · No injuriesLimited investigationFinal reportBell 206L · Gulf of MexicoA loss of engine power for undetermined reasons while on short final to land on an oil platform in the Gulf of Mexico, which resulted in the pilot ditching the helicopter into the water.Sep 29, 2004 · N34CA · DestroyedNTSB CHI04CA288Accident · No injuriesData collectionFinal reportAeronca 7BCM · St. James, MOThe pilot's failure to maintain clearance from trees during the go-around. Factors were the sun glare and the trees.Sep 26, 2004 · N4179E · Substantial damageNTSB CHI04LA278Accident · Serious injuriesLimited investigationFinal reportCessna 208B · Gwinner, NDThe pilot's failure to maintain altitude during the circling maneuver. Contributing factors were the pilot's improper decision to execute the approach when weather conditions were below minimums and the low light (dark night) conditions.Sep 24, 2004 · N7392B · Substantial damageNTSB CHI04LA262Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Knox, INA loss of engine power for undetermined reasons. Contributing to the accident were the unsuitable terrain encountered, the dark night conditions, and the ditch.Sep 20, 2004 · N2453T · Substantial damageNTSB FTW04CA241Accident · No injuriesData collectionFinal reportPiper J3C-65 · Louise, TXThe pilot's inadvertent positioning of the fuel shutoff valve resulting in the fuel starvation of the engine and the subsequent loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.Sep 19, 2004 · N98659 · Substantial damage