NTSB investigations, AL

315 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.\"eventStateOrRegion\" = 'AL' AND c.\"eventCountry\" = 'USA'
    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 ERA10FA259Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Tuscaloosa, ALThe pilot's failure to maintain adequate airspeed while maneuvering to land, which resulted in an aerodynamic stall/spin and collision with the ground.May 11, 2010 · N424LF · Substantial damageNTSB MIA08CA126Accident · Minor injuriesData collectionFinal reportTaylorcraft F19 · Montgomery, ALThe pilot's improper loading of personal belongings which resulted in rudder pedal interference.Jun 20, 2008 · N3681T · Substantial damageNTSB NYC08FA157Accident · 2 fatalField investigationFinal reportCartwright H Jr/Cottrell M RV-10 · Seale, ALThe pilot-in-command's in-flight loss of control due to spatial disorientation. Contributing to the accident were the weather conditions and the pilot-in-command's lack of flight experience in the accident airplane.Apr 7, 2008 · N210HM · DestroyedNTSB LAX08LA105Accident · No injuriesLimited investigationFinal reportRaytheon B300 · Tuscaloosa, ALThe pilot's encounter with severe turbulence during descent into the airport environment, which resulted in an exceedence of the aircraft's design stress limit and structural damage.Apr 4, 2008 · N900WP · Substantial damageNTSB NYC08CA085Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Arley, ALA malfunction of the rudder control system.Jan 19, 2008 · N2669A · Substantial damageNTSB NYC07LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Enterprise, ALThe designated examiner's improper decision to simulate an engine failure on short final approach, in conjunction with a short-field landing maneuver, and his inadequate remedial action. Contributing to the accident was the private pilot's inadvertent…Jul 12, 2007 · N4043P · 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 ATL06LA093Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Selma, ALThe loss of engine power during the approach to land due to an uncontained turbine failure, which resulted in an in-flight fire.Jun 14, 2006 · N6133T · Substantial damageNTSB ATL06CA043Accident · No injuriesData collectionFinal reportCessna 172P · Birmingham, ALAn in-flight collision with a deer during a go around, which resulted in damage to the left main landing gear and subsequent collapse of the left main landing gear.Feb 2, 2006 · N902NS · Substantial damageNTSB ATL06LA008Accident · 1 fatalLimited investigationFinal reportElan/Glaser Dirks DG-300 · Brownsboro, ALThe pilot's misjudgment of distance/altitude on final approach which resulted in an undershoot of the runway, and an in-flight collision with a embankment. A factor was the dirt bank/rising terrain.Oct 16, 2005 · N300HX · Substantial damageNTSB ATL05LA137Accident · 1 fatalLimited investigationFinal reportCessna T210 · Muscle Shoals, ALThe pilot's inadequate visual lookout, and failure to maintain clearance, which resulted in an in flight collision with a transmission wire.Jul 29, 2005 · N9501Y · Substantial damageNTSB ATL05CA067Accident · No injuriesData collectionFinal reportAviat A1A · Alexander City, ALThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.Mar 29, 2005 · N119WP · Substantial damageNTSB ATL05LA051Accident · Serious injuriesLimited investigationFinal reportMooney 20P · Smith, ALMaintenance personnel failure to properly torque the cylinder head during installation that resulted in the separation from the engine assembly and the subsequent loss of power.Feb 18, 2005 · N321DT · Substantial 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 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 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 ATL04LA087Accident · Serious injuriesLimited investigationFinal reportAircraft Mfg & Development Alarus CH2T · Bay Minette, ALThe pilot's inadequate inflight decision which resulted in continued VFR flight into IMC conditions, and his failure to maintain clearance which resulted in a collision with trees. A factor was the fog.Mar 28, 2004 · N605AM · Substantial damageNTSB ATL04LA044Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Birmingham, ALA loss of engine power due to the throttle/power lever cable becoming disconnected in-flight, as a result of maintenance personnel failure to comply with Airworthiness Directive (AD) 86-24-07 and Cessna information letter SE79-6.Dec 3, 2003 · N3056Q · Substantial damageNTSB ATL03LA121Accident · Minor injuriesLimited investigationFinal reportLancair 235 · Fort Payne, ALThe pilot's failure to properly reconnect the mixture control cable resulting in a total loss of engine power, and subsequent in-flight collision with the trees.Jul 30, 2003 · N7156W · Substantial damageNTSB ATL03FA082Accident · 1 fatalField investigationFinal reportSocata TBM 700B · Mobile, ALThe improper installation of the power control linkage on the engine fuel control unit by maintenance personnel which resulted in a loss of power lever control, and the pilot's failure to follow emergency procedures and his intentional engine shutdown which…Apr 25, 2003 · N705QD · Substantial damageNTSB ATL02LA093Accident · No injuriesLimited investigationFinal reportCessna 150B · Enterprise, ALThe pilot's failure to maintain airspeed during an attempted go-around that resulted in an inadvertent stall and the subsequent collision with the ground.Apr 26, 2002 · N1299Y · Substantial damageNTSB MIA02LA071Accident · No injuriesLimited investigationFinal reportBeech C-24R · Bayou La Batre, ALThe pilot's failure to maintain aircraft directional control while executing a go-around, resulting in an inflight collision with trees.Mar 24, 2002 · N18891 · Substantial damageNTSB MIA02FA037Accident · 2 fatalField investigationFinal reportCessna 208B · Bessemer, ALThe poor in-flight planning by the pilot-in-command for his initiation of the ILS approach to runway 05 with weather conditions below minimums for the approach contrary to the federal aviation regulations, and the failure of the pilot to maintain control of…Dec 1, 2001 · N499BA · DestroyedNTSB MIA02FA026Accident · 2 fatalField investigationFinal reportEnstrom 280FX · Tallassee, ALThe failure of the pilot to maintain a safe altitude above terrain and maintain a visual lookout resulting in the helicopter colliding with power transmission lines and crashing into a river. A factor in the accident was the power transmission lines not being…Nov 22, 2001 · N280XF · DestroyedNTSB MIA01LA134Accident · No injuriesLimited investigationFinal reportDavid G. Holmes Bensen Gyrocopter · Troy, ALThe failure of the pilot to maintain airspeed during the approach resulting in a hard landing. A contributing factor in the accident was the loss of engine power during final approach due to undetermined reasons.Apr 22, 2001 · N218DH · Substantial damageNTSB ATL01FA036Accident · 5 fatalField investigationFinal reportCessna 421 · Munford, ALThe pilot continued visual flight into instrument weather conditions that resulted in the inflight collision with a river bank. Factors were reduced visibility and dark night.Feb 14, 2001 · N5AY · DestroyedNTSB ATL01LA003Accident · 1 fatalLimited investigationFinal reportUniversity of Alabama MINI-500 · Tuscaloosa, ALThe loss of engine power for undetermined reasons, and the pilot's unapproved airframe modification that resulted in the loss of flight control during the emergency descent.Oct 3, 2000 · N6165T · DestroyedNTSB MIA00LA259Accident · No injuriesLimited investigationFinal reportEugene L. Capozzi VAN RV-6A · Bayou La Batre, ALThe pilots failure to maintain airspeed during final approach result in the aircraft stalling and descending uncontrolled until ground impact.Sep 3, 2000 · N199EC · Substantial damageNTSB MIA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fayette, ALThe pilot's failure to maintain directional and altitude control of the airplane during a ago-around maneuver, resulting in collision with a fence and utility pole.Feb 4, 2000 · N8924T · Substantial damageNTSB ATL99LA133Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Enterprise, ALThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was the in-flight collision with a tree during the forced landing.Sep 19, 1999 · N6736Q · DestroyedNTSB ATL99LA095Accident · No injuriesLimited investigationFinal reportAircraft Parts & Dev. A-9B · Hartsell, ALThe pilot's failure to maintain flying speed that resulted in the inflight collision with the ground. A factor was the pilot's lack of total experience in the aircraft.May 21, 1999 · N9082A · Substantial damageNTSB ATL99FA044Accident · 2 fatalField investigationFinal reportBeech 300 · Cullman, ALThe pilot's failure to adhere to the missed approach procedure resulting in a collision with terrain. Contributing factors were fog and the rotorcraft rated pilot's lack of fixed wing certification/experience.Jan 14, 1999 · N780BF · DestroyedNTSB MIA99LA025Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Hartselle, ALImproper modification of the carburetor float by maintenance personnel resulting in the float sticking in the full needle valve open position and failure of the engine due to excessive fuel flow.Oct 31, 1998 · N99924 · Substantial damageNTSB ATL98LA128Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Goodway, ALThe pilot's continued approach into known adverse weather which resulted in the pilot's loss of control, and subsequent inflight collision with terrain. A factor was the weather conditions.Sep 22, 1998 · N9774 · Substantial damageNTSB MIA98FA162Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Mccalla, ALThe pilot's failure to maintain airspeed, which resulted in a stall.May 14, 1998 · N96750 · Substantial damageNTSB ATL98LA033Accident · 1 fatalLimited investigationFinal reportCessna 150L · Guntersville, ALThe pilot's intentional shut down of the engine in flight that resulted in the total loss of engine power. A factor was the failure of both magnetos.Jan 18, 1998 · N7443G · Substantial damageNTSB MIA98LA036Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Hazel Green, ALthe pilot's miscalculating the aircraft's fuel consumption for the flight, resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Nov 28, 1997 · N3908L · Substantial damageNTSB MIA97LA137Accident · No injuriesLimited investigationFinal reportCessna 185D · Wetumpka, ALloss of engine power during a go-around for undetermined reason(s).Apr 11, 1997 · N285BG · Substantial damageNTSB MIA97LA003Accident · Minor injuriesLimited investigationFinal reportSocata TB-20 · Mobile, ALthe pilot's improper management of fuel, which resulted in fuel exhaustion and loss of engine power during a go-around, and subsequent collision with trees and terrain during a forced landing.Oct 7, 1996 · N59TB · Substantial damageNTSB MIA96FA233Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Birmingham, ALThe pilot-in-command's improper in-flight planning/decision for electing to continue the flight after observing that the fuel gauges indicated empty. Contributing to the accident was an improperly adjusted economizer jet and an out of adjustment float. Also…Sep 27, 1996 · N8803J · Substantial damageNTSB MIA96LA125Accident · No injuriesLimited investigationFinal reportRans S6ES · Bayou La Batre, ALthe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.Apr 22, 1996 · N5144X · Substantial damageNTSB ATL96LA063Accident · No injuriesLimited investigationFinal reportCessna 172RG · Gulf Shores, ALThe failure of both pilots to maintain an adequate visual lookout. A factor was the lack of position reports via radio by the pilot of the helicopter.Mar 10, 1996 · N6612V · 2 aircraft · Substantial damageNTSB MIA96TA014Accident · No injuriesFinal reportCessna 182R · Redstone Arsena, ALthe pilot's poor inflight planning decision for not flying the scheduled time and electing to perform 3 additional takeoffs not planned during fuel consumption calculations. Contributing to the accident was the use of an inaccurate dipstick.Oct 21, 1995 · N3163E · Substantial damageNTSB ATL95FA162Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Double Springs, ALfailure of the pilot to follow emergency procedures for loss of engine power, and his failure to maintain control of the airplane. Factors relating to the accident were: the pilot's inadequate preflight planning/preparation and improper fuel consumption…Aug 23, 1995 · N15866 · DestroyedNTSB ATL95LA160Accident · No injuriesLimited investigationFinal reportBell UH-1H · Montgomery, ALthe pilot's failure to maintain clearance from the trees.Aug 7, 1995 · N794CF · Substantial damageNTSB ATL95LA100Accident · Minor injuriesLimited investigationFinal reportBeech 95-A55 · Tuskeegee, ALThe pilot's inadequate preflight planning that resulted in fuel exhaustion.May 28, 1995 · N401W · Substantial damageNTSB ATL95LA091Accident · Minor injuriesLimited investigationFinal reportBeech S-35 · Huntsville, ALA loose wire which shorted between an exposed terminal on the avionics bus relay and the oil line to the oil pressure gage, and the failure of maintenance personnel to tie up loose wires.Apr 26, 1995 · N67HC · Substantial damageNTSB MIA95FA072Accident · Serious injuriesField investigationFinal reportCessna 152 · Mobile, ALThe pilot's improper planning/decision, which resulted in fuel exhaustion before reaching the airport, and his failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in an inadvertent stall and collision with the terrain.Feb 7, 1995 · N757XX · Substantial damageNTSB ATL95LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Orange Beach, ALA loss of engine power for undetermined reasons.Jan 16, 1995 · N32411 · Substantial damageNTSB ATL95LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Foley, ALAn engine fire for undetermined reasons.Jan 3, 1995 · N6829F · Destroyed