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 ANC06LA130Accident · Minor injuriesLimited investigationFinal reportMcNabb Bushmaster · Delta Junction, AKAn electrical short that disabled the electronic ignition system of the airplane's engine during the final approach phase for landing, which resulted in a forced landing and collision with high vegetation. A factor contributing to the accident was the failure…Sep 4, 2006 · N5090F · Substantial damageNTSB SEA06CA174Accident · No injuriesData collectionFinal reportCessna 180 · Arock, ORThe pilot's failure to maintain directional control during a go-around, resulting in an in-flight collision with trees and substantial damage to the airplane. Factors included the pilot's failure to attain the proper touchdown point, the delayed go-around,…Sep 3, 2006 · N9026C · Substantial damageNTSB MIA06CA134Accident · Minor injuriesData collectionFinal reportCessna 172N · Pensacola, FLThe student pilot's failure to raise the wing flaps for a go-around resulting in the airplane not climbing and an in-flight collision with trees.Sep 3, 2006 · N1210F · Substantial damageNTSB LAX06CA281Accident · No injuriesData collectionFinal reportCessna 172P · Spanish Springs, NVthe pilot's failure to initiate a timely go-around and to attain an adequate climb rate. Factors in the accident were the high density altitude and the likely quartering tail wind that may have affected the aircraft's climb gradient.Sep 1, 2006 · N97306 · Substantial damageNTSB SEA06CA173Accident · No injuriesData collectionFinal reportCessna 182RG · Fairfield, UTThe failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…Aug 30, 2006 · N5464N · Substantial damageNTSB ATL06CA124Accident · No injuriesData collectionFinal reportCessna 172R · Winder, GAThe student pilot's failure to maintain control of the airplane during an attempted go-around.Aug 29, 2006 · N856CP · Substantial damageNTSB NYC06FA209Accident · 7 fatalField investigationFinal reportCessna 401A · Whick, KYThe non-instrument-rated pilot's continued flight into instrument meteorological conditions, and his subsequent failure to maintain airspeed which resulted in an inadvertent stall. Contributing was the instrument meteorological conditions.Aug 28, 2006 · N408JC · DestroyedNTSB CHI06CA246Accident · No injuriesData collectionFinal reportAviat A-1B · Minocqua, WIThe inadvertent collision with power lines. A factor associated with the accident was the water which blended in with the power lines resulting in the pilot's inability to see them prior to contact.Aug 26, 2006 · N314MA · Substantial damageNTSB SEA06CA165Accident · No injuriesData collectionFinal reportBell 407 · Havre, MTThe pilot inadvertently allowing the helicopter to enter into a vortex ring state (settling with power) condition while he was lowering a long-line load to the ground, resulting in the helicopter settling to the ground and its tail rotor impacting part of the…Aug 19, 2006 · N407SH · Substantial damageNTSB ATL06FA122Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Hartsville, SCThe pilot's loss of control of the airplane due to spatial disorientation.Aug 18, 2006 · N31911 · Substantial damageNTSB CHI06LA244Accident · Minor injuriesLimited investigationFinal reportFairchild SA227-AC · Grain Valley, MOthe pilot not maintaining clearance from the fence. Contributing factors were the pilot's fatigue and the fence.Aug 17, 2006 · N620PA · Substantial damageNTSB CHI06CA234Accident · No injuriesData collectionFinal reportBeech 19A · Yankton, SDThe dual student's premature retraction of the flaps during the attempted go-around which resulted in the impact with the ground. The flight instructor's delay in calling for the go-around was an additional cause.Aug 16, 2006 · N6544T · Substantial damageNTSB CHI06FA232Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Sault Ste Marie, MIThe pilot's failure to maintain aircraft control during the circling approach and his failure to perform a missed approach when the airplane was no longer in a position to land using normal flight maneuvers. Contributing to the accident was the pilot's…Aug 14, 2006 · N133BH · DestroyedNTSB NYC06CA201Accident · No injuriesData collectionFinal reportBeech B100 · Pawtucket, RIThe pilot's misjudged distance and speed during final approach, which resulted in an undershoot and subsequent gear collapse.Aug 13, 2006 · N75AP · Substantial damageNTSB CHI06LA230Accident · 1 fatalLimited investigationFinal reportDix Acro Sport II · Coldwater, MIThe loss of engine power for undetermined reasons and the pilot's failure to maintain sufficient airspeed during the resulting forced landing which resulted in the inadvertent stall and subsequent impact with the ground. The rising terrain was a factor.Aug 12, 2006 · N208BY · Substantial damageNTSB SEA06CA160Accident · No injuriesData collectionFinal reportRobinson R-22B · Boise, IDThe instructor pilot's inadvertent excessive descent rate, and his delay of remedial action during the demonstration of a 180 degree autorotation.Aug 11, 2006 · N228SH · Substantial damageNTSB ANC06LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Deadhorse, AKThe pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an uncontrolled descent and collision with terrain. A factor contributing to the accident was an inadvertent stall.Aug 6, 2006 · N3546P · Substantial damageNTSB NYC06CA194Accident · Serious injuriesData collectionFinal reportChampion 7FC · Harmonsburg, PAThe pilot's failure to maintain the proper altitude/clearance on final approach, which resulted in an in-flight collision with trees.Aug 5, 2006 · N9866B · Substantial damageNTSB CHI06FA218Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Boyceville, WIThe pilot's failure to maintain adequate airspeed and the certified flight instructor's delayed remedial action and inadequate supervision of the flight training, which resulted in an inadvertent stall during a base to final turn to the landing runway. An…Aug 5, 2006 · N658CD · Substantial damageNTSB SEA06LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Ontario, ORThe pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. Factors were the en route high wind condition and the soft terrain.Aug 4, 2006 · N1221P · Substantial damageNTSB NYC06MA192Accident · 1 fatalMajor investigationFinal reportEmbraer 110P1 · Pownal, VTThe pilot's misinterpretation of the airplane's position relative to the final approach fix, which resulted in the displacement of the descent profile by 6 nautical miles and the subsequent controlled flight into rising terrain. Contributing to the accident…Aug 4, 2006 · N59BA · DestroyedNTSB LAX06CA253Accident · Serious injuriesData collectionFinal reportCessna 172M · Gasquet, CAthe pilot's selection of a runway favoring tailwind conditions, his delayed decision to go around, and his failure to attain and maintain an adequate airspeed during the aborted landing. Contributing factors were the tailwind and wind shear conditions…Aug 4, 2006 · N5262R · Substantial damageNTSB ANC06LA103Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Juneau, AKThe pilot's failure to maintain altitude/clearance during approach, which resulted in the airplane impacting the surface of the water. Factors associated with the accident were the flat-light and glassy water conditions, which affected the pilot's ability to…Jul 31, 2006 · N93356 · Substantial damageNTSB DFW06CA192Accident · No injuriesData collectionFinal reportBeech BE23 · Bowie, TXThe student pilot's failure to maintain clearance from trees. Contributing factors were the prevailing crosswind and improper supervision of the flight by the flight instructor.Jul 23, 2006 · N2326Z · Substantial damageNTSB CHI06FA196Accident · 2 fatalField investigationFinal reportShaw Europa XS · Oshkosh, WIThe pilot's failure to maintain adequate airspeed on final approach which resulted in a stall.Jul 23, 2006 · N229WC · Substantial damageNTSB LAX06CA248Accident · No injuriesData collectionFinal reportCessna T210N · Truckee, CAthe pilot's inadequate compensation for the existing wind conditions and failure to maintain an adequate airspeed.Jul 22, 2006 · N6686N · Substantial damageNTSB DFW06CA190Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Woodworth, LAThe pilot's failure to maintain clearance from a tree. Contributing factors were the sudden wind shift and the gusty wind conditions.Jul 22, 2006 · N9952W · Substantial damageNTSB CHI06CA198Accident · Minor injuriesData collectionFinal reportSargent Bushby Mustang II · Troy, MIThe pilot's delayed decision to go-around leading to the impact with the fence during the go-around. A factor was the fence.Jul 22, 2006 · N6186C · DestroyedNTSB ANC06LA092Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Deland, FLThe flight instructor's inadequate supervision of the dual student during final approach to land, and his delayed remedial action following a partial loss of engine power on one of the two engines. Factors associated with the accident are the dual student's…Jul 19, 2006 · N717PE · Substantial damageNTSB NYC06IA176Incident · No injuriesIncident investigationFinal reportEurocopter AS-350 BA · Philadelphia, PAA loss of hydraulic boost for undetermined reasons.Jul 17, 2006 · N606TV · No damageNTSB MIA06LA123Accident · Minor injuriesLimited investigationFinal reportBell 206B · Pompano Beach, FLThe pilot's improper landing flare during a precautionary landing. A factor in the accident was the unusual noise as a result of an improper repaired air conditioner compressor system.Jul 17, 2006 · N515AA · Substantial damageNTSB LAX06FA233Accident · 1 fatalField investigationFinal reportBellanca 14-19 · Arcata, CAThe pilot's failure to follow the prescribed instrument approach procedure and to maintain the proper glide slope and altitude/clearance from obstacles while on an instrument landing system approach, resulting in a collision with trees. Contributing to the…Jul 17, 2006 · N522A · DestroyedNTSB NYC06CA177Accident · No injuriesData collectionFinal reportBeech A36 · Somerville, NJThe pilot's continued flight into known adverse weather.Jul 16, 2006 · N5363P · Substantial damageNTSB NYC06CA119Accident · Serious injuriesData collectionFinal reportCessna 182A · Plattsburgh, NYThe pilot's failure to utilize carburetor heat, which resulted in the formation of carburetor ice and subsequent engine failure. Factors included the carburetor icing conditions and trees in the forced landing area.Jul 15, 2006 · N2186G · Substantial damageNTSB LAX06FA238Accident · No injuriesField investigationFinal reportLearjet 55 · Van Nuys, CAAn in-flight fire of undetermined origins.Jul 15, 2006 · N554CL · Substantial damageNTSB LAX06LA235Accident · Minor injuriesLimited investigationFinal reportAlfred Long-EZ · Hesperia, CAThe pilot's failure to maintain the proper glide path on final approach as a result of the visual illusions created by a narrow, upsloping runway.Jul 11, 2006 · N1014A · Substantial damageNTSB DFW06FA180Accident · 2 fatalField investigationFinal reportBeech C24R · Virginia Beach, VAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin while maneuvering at a low altitude. Contributing was the pilot's diverted attention to an open door.Jul 11, 2006 · N78MB · Substantial damageNTSB CHI06FA186Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Edgewater, MDThe pilot' failure to maintain sufficient airspeed which resulted in a stall. A factor was the pilots failure to properly set the flaps for the go-around.Jul 11, 2006 · N8163Q · DestroyedNTSB DFW06CA179Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Georgetown, TXThe flight instructor's inadequate supervision of the flight, which resulted in a loss of engine power due to fuel starvation after the private pilot inadvertently positioned the fuel selector to the OFF position. Contributor factors were the lack of suitable…Jul 10, 2006 · N8164J · Substantial damageNTSB ATL06LA103Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-D · Gold Hill, NCThe pilot's failure to maintain airspeed while doing a go around, which resulted in an inadvertent stall, loss of control and in-flight collision with the ground. A factor was the pilot's lack of recent experience in the airplane.Jul 8, 2006 · N96758 · Substantial damageNTSB ATL06FA102Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Suches, GAThe pilot's failure to retract the wing flaps and his decision to make a turn while performing a go-around.Jul 8, 2006 · N3380W · DestroyedNTSB DFW06CA176Accident · No injuriesData collectionFinal reportCessna 210A · Denver City, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jul 7, 2006 · N9419X · Substantial damageNTSB CHI06CA177Accident · Minor injuriesData collectionFinal reportCessna T210G · Pontiac, ILA loss of engine power due to the pilot's improper in-flight planning which led to fuel exhaustion and his failure to maintain an adequate airspeed during the landing approach which resulted in an inadvertent stall. The road embankment was a factor.Jul 6, 2006 · N6900R · Substantial damageNTSB CHI06CA176Accident · Minor injuriesData collectionFinal reportCessna 182A · Jackson, MIThe pilot's improper preflight planning which led to the exhaustion of the fuel supply during the flight. The overload failure of the nose landing gear was a factor.Jul 6, 2006 · N4780D · Substantial damageNTSB LAX06CA223Accident · No injuriesData collectionFinal reportPiper PA28-181 · Dorris, CAthe pilot's failure to maintain an adequate airspeed during a go-around, which resulted in a stall/mush. A contributing factor was the high density altitude.Jul 3, 2006 · N6413C · Substantial damageNTSB DEN06FA091Accident · 2 fatalField investigationFinal reportBeech A36TC · Montrose, COthe pilot's inadequate preflight planning/decision by not having the airplane refueled prior to takeoff, and allowing the engine to be starved of fuel because he failed to switch the fuel selector valve. A contributing factor was the flight instructor's…Jul 3, 2006 · N1800Z · DestroyedNTSB ATL06CA100Accident · Serious injuriesData collectionFinal reportNickel Acro II · Hertford, NCThe certified flight instructor and commercial pilot receiving instruction failure to maintain a visual look out, resulting in a wire strike on final approach, and collapse of the main landing gear on touchdown.Jul 2, 2006 · N6N · Substantial damageNTSB DFW06CA174Accident · Minor injuriesData collectionFinal reportCessna 172L · Burnett, TXThe flight instructor's delayed remedial action during a simulated emergency landing, which resulted in an inadvertent stall.Jul 1, 2006 · N7943G · Substantial damageNTSB NYC06LA160Accident · 1 fatalLimited investigationFinal reportAerial Productions Intl. Acrojet Special · Ocean City, MDThe pilot's failure to maintain adequate airspeed which resulted in a stall mush and subsequent impact with trees. A factor in the accident was windshear, and the high weight of the airplane.Jun 27, 2006 · N23AP · DestroyedNTSB LAX06CA217Accident · No injuriesData collectionFinal reportBeech 76 · El Cajon, CAthe failure of the "A" frame tube, which caused the left main landing gear to collapse.Jun 27, 2006 · N6720T · Substantial damage