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 NYC85LA033Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Prospectville, PAPlt stated he allowed the acft to go low on final approach. Collision with terrain separated the landing gear but plt recovered control as acft rebounded and executed a successful go-around. Plt diverted with escort to nearby military arpt where CFR…Nov 25, 1984 · N31699 · Substantial damageNTSB CHI85FA059Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Wixom, MIThe acft collided with power lines while on final approach for a landing. The passenger related that the sun was very low on the horizon, and while looking toward the sun & haze, the visibility was limited. As the acft turned on final approach, a large flock…Nov 25, 1984 · N2047H · DestroyedNTSB NYC85FHD01Accident · Minor injuriesFinal reportPiper Cherokee 140-C · Pennington, NJThe plt & passg stated that the flt & approach to land seemed normal in all respects. They both have no recollection of the actual accident and only recall waking up in the ambulance. There are no witnesses of record to the accident. The groung evidence shows…Nov 24, 1984 · N5894U · Substantial damageNTSB MKC85LA026Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Van Buren, MOPlt stated that while on approach into setting sun, he failed to see a tree and the windsock tower due to sunglare, colliding with both before impact with the ground. The windsock was located 200 ft north of the rwy. Winds were calm and reciprocal rwy was…Nov 24, 1984 · N4561U · DestroyedNTSB FTW85LA057Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Newcastle, OKOn simulated emerg landing, instructor evaluated approach as unsalvagable & at 1700 ft AGL told student to execute go-around. Student had allowed airspeed to decay in an effort to stretch glide. Student raised flaps & did not add pwr. As acft settled,…Nov 24, 1984 · N2478B · Substantial damageNTSB NYC85FHJ01Accident · Serious injuriesFinal reportPiper PA-28-140 · Hastings, NYPlt was occupying rt front seat, pax in left. Plt stated he noted eng oil press gage reading low and, recalling prior emerg lndg on golf course due oil starvation, elected precautionary lndg on golf course. Acft overshot intended approach. Plt initiated…Nov 23, 1984 · N32473 · DestroyedNTSB CHI85LA055Accident · Serious injuriesLimited investigationFinal reportBeech E35 · Lagrange, INPlt was landing in gusty, crosswind conditions. On late final, a gust of wind caused the left wing to drop and strike the top of an 80 ft tree. Acft touched down nose low, collapsing the landing gear.Nov 23, 1984 · N3301C · Substantial damageNTSB ATL85LA042Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Murphy, NCThe CFI and student plt initiated a go-around from a simulated forced landing when the eng failed to respond to the application of power. In order to avoid colliding with trees the CFI turned right towards a corn field. Ground impact occurred right wing low…Nov 23, 1984 · N11916 · Substantial damageNTSB FTW85LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Pampa, TXPreflight weather briefing showed closest reporting station to destination below dest apch minimum of I mile visibility but fcst to improve to 1/2 mi by arrival. Area freezing level fcst at 3-4000 ft. flt to dest at 6000 ft was on top of clouds and…Nov 19, 1984 · N54028 · DestroyedNTSB CHI85FEI01Accident · Serious injuriesFinal reportPiper PA-32R-301T · Sandusky, OHThe acft collided with trees at night during a short final approach to land and crashed to the ground in the back yard of a private residence. The plt, who was seriously injured in the accident, said he flew a normal pattern into a 15-20 kt wind when tree…Nov 19, 1984 · N8462U · DestroyedNTSB MKC85LA021Accident · No injuriesLimited investigationFinal reportMooney M20J · Kirksville, MOAccording to the plt, during a localizer apch impact with an object was heard and the acft yawed left. The plt did not see what the acft hit but stated that he believed the acft struck a bird. Using a flashlight he attempted to inspect theacft in order to…Nov 18, 1984 · N3955H · Substantial damageNTSB NYC85FA029Accident · 4 fatalField investigationFinal reportPiper PA-28-236 · Atlantic City, NJThe aircraft was observed in close proximity to another aircraft in the traffic pattern. The pilot extended the downleg leg leg. During the turn to align the aircraft with the runway the pilot suffered a disabling heart attack. Unable to recover the aircraft…Nov 17, 1984 · N2831Y · DestroyedNTSB MIA85LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Parkland, FLThe plt stated that as he approached the airstrip he flew his pattern low. As he turned base the wind caught the left wing shoving the acft down. He jammed the throttle forward but the acft crashed.Nov 17, 1984 · N5560H · DestroyedNTSB CHI85LA052Accident · No injuriesLimited investigationFinal reportBeech A23 · Plato Center, ILOn final approach with a 30-degree right crosswind of 14-16 KTS, the plt experienced a loss of headwind component as theacft passed below height of buildings in the windstream. Power was not added and the acft settled to the ground short of the runway…Nov 17, 1984 · N1407L · Substantial damageNTSB ATL85LA037Accident · Minor injuriesLimited investigationFinal reportAero Commander 500 · Florence, SCThe acft crashed short of the rwy after both engines lost power on the base leg. Th acft hit about 200 ft short of the rwy and slid through the fence onto the rwy destroying about 4 rwy lights. Investigation disclosed that the left fuel strainer drain was…Nov 17, 1984 · N6268B · Substantial damageNTSB ATL85LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Conway, SCThe certificated pilot, receiving instruction from a certified flight instructor, was manipulating the controls at the time of the accident. The student undershot the runway and touched down short of the paved rwy surface. The aircraft landing gear struck the…Nov 15, 1984 · N30001 · Substantial damageNTSB MIA85IA031Incident · No injuriesIncident investigationFinal reportSwearingen SA-226AT · Tallahassee, FLN31264 crashed intentionally gear up on rwy 18 at Tallahassee, FL, while on a night, all cargo 14 CFR 135 flt. The crew attempted emergency gear extension procedures & a fly-by. Investigation revealed a broken wire, TS-70, where it connects with terminal 6.…Nov 14, 1984 · N31264 · Minor damageNTSB ANC85FA016Accident · No injuriesField investigationFinal reportCessna 180 · Chugiak, AKAcft collided with trees aprx 2,600 ft short of rwy 19 threshold during the landing apch. The acft stopped 35-40 ft AGL in trees and after a few minutes fell to the ground. A descent was made from aprx 10,000 ft with a leaned mixture, closed throttle and no…Nov 12, 1984 · N9433C · Substantial damageNTSB NYC85LA041Accident · No injuriesLimited investigationFinal reportMooney M20J · Marlboro, NJPlt stated that on late final, with airspeed and descent path normal, acft encountered downdraft and collided with upslope at runway threshold before corrective action could be taken. A 60 degree left crosswind of 15 KTS existed at the time.Nov 10, 1984 · N3515H · Substantial damageNTSB NYC85FA025Accident · 1 fatalField investigationFinal reportCessna C337 · Taunton, MAAfter departure & at an altitude of 2000 ft the plt noticed that the rear eng fuel flow was low, however, the eng was operating satisfactory. The plt, as a precaution, decided to return to the departure arpt. While returning the plt noted that there was no…Nov 10, 1984 · N2327S · Minor damageNTSB MIA85FA029Accident · 2 fatalField investigationFinal reportGates Learjet 24F · St. ThomasWhile executing a night visual approach to runway 9 in visual meteorological conditions the aircraft was allowed to descend; crashing into water 2 miles short of the runway. The pilot was not familiar with the airport and failed to make use of a full…Nov 10, 1984 · N81MC · DestroyedNTSB MKC85LA019Accident · No injuriesLimited investigationFinal reportCessna R172E · Junction City, KSPilot was experiencing communications difficulties, diverted from destination to nearby uncontrolled arpt due to traffic considerations. Plt was unable to contact UNICOM and elected to circle for traffic and wind evaluation. Best runway for wind direction was…Nov 9, 1984 · N13030 · Substantial damageNTSB NYC85LA023Accident · No injuriesLimited investigationFinal reportBeech BE-55E · Groton, CTAs the acft broke out of the 300 overcast layer the plt saw birds flying off of the rwy threshold. Due to IFR conditions and low altitude the plt elected not to go around. The tower advised the plt of the birds on 2 mile final on the ILS apch.Nov 5, 1984 · N62561 · Substantial damageNTSB MIA85FA023Accident · 2 fatalField investigationFinal reportBeech C23 · Crestview, FLDuring arrival, the plt was cleared for an ILS apch. The reported wx at that time was: 600 ft overcast, visibility 7 mi, wind 010 deg at 6 KTS. The plt stated that during the apch, he felt a downdraft that caused the acft to bank to the left & pitch down. The…Nov 4, 1984 · N9242S · DestroyedNTSB FTW85FA037Accident · Serious injuriesField investigationFinal reportCessna 182A · Mckinney, TXThe plt stated, he had departed the aero county airport, Mckinney, TX, on a local flt to drop sky divers. He dropped the sky divers & was returning to the arpt when he encountered a loss of eng power & made a forced landing. He stated that he pulled on…Nov 4, 1984 · N5176D · Substantial damageNTSB NYC85FA019Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Beverly, MADuring an approach to land at night, the acft crashed & burned about 3000 ft from the approach end of the rwy. The non-instrument rated plt had been in contact with approach control. He indicated that IFR conditions existed over the arpt & that he was going…Nov 2, 1984 · N9930W · DestroyedNTSB FTW85LA033Accident · No injuriesLimited investigationFinal reportStinson 108 · Sandia, TXThe plt was attempting a night landing at an unlighted airport. Plt stated he elecuted a low angle approach, knowing of elevated and wooded terrain off the end of the runway. On sighting trees to his left, he initiated a go-around but struck other trees…Oct 31, 1984 · N97476 · Substantial damageNTSB CHI85FA035Accident · 2 fatalField investigationFinal reportGulfstream 690C · Wooster, OHWhile on final approach to rwy 09 the acft struck a 42 ft power pole with the right wing. The wing was torn from the acft. The acft landed inverted 400 ft east of the pole. The rwy threshold lights are displaced 165 ft from the rwy end for night operations.…Oct 31, 1984 · N2937A · DestroyedNTSB MIA85LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-315-B · West Bay, FLThe acft crashed following a loss of tail rotor control while on an external load agricultural flt. Witnesses stated that during a landing attempt at a loading area the acft started spinning, the ext load was jettisoned, and the acft hit the ground and rolled…Oct 29, 1984 · N49504 · Substantial damageNTSB NYC85FA015Accident · 2 fatalField investigationFinal reportEnstrom 280C · Butler, PAThe helicopter struck the static line of a high voltage transmission line while on a flt to photograph an apartment complex. The owner of the complex accompanied the plt on the flt, there after the acft was to be used for passenger sightseeing flts as part of…Oct 28, 1984 · N51686 · DestroyedNTSB LAX85LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Firebird Lake, AZThe CFI reported that while flying in the flt school's designated practice area at 3800 ft MSL she reduced the throttle to idle for the purpose of simulating an in-flt emerg for her student. The student responded properly. The CFI stated she cleared the eng,…Oct 28, 1984 · N6470L · Substantial damageNTSB DEN85LA022Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Longmont, COThe pilot stated that he encountered a strong gust of wind from the right and lost directional control. The acft struck the ground with the left wing tip and nose and flipped over.Oct 28, 1984 · N758CG · Substantial damageNTSB LAX85LUQ01Accident · No injuriesFinal reportJack L. Bigham Bede 5B · Camarillo, CAThe plt was performing a go around when the prop drive failed. A forced landing was made on a soft fld adjacent to a taxiway during which the landing gear collapsed. Examination of the acft disclosed the prop drive belt laying in the fuselage.Oct 27, 1984 · N721JB · Substantial damageNTSB LAX85LA029Accident · No injuriesLimited investigationFinal reportBeech C24R · Montague, CAThe acft made a forced landing in a pasture and collided with a cow after the engine quit. The plt said he has noticed the landing gear in transit light come on at about 10 minute intervals during the flt. He said he had noticed a red fluid dripping from the…Oct 27, 1984 · N66342 · Substantial damageNTSB MKC85LA009Accident · No injuriesLimited investigationFinal reportPiper PA32RT-300T · Columbia, MOThe plt was high on the ILS approach and flew a VFR very low circling approach after clearance to change from rwy 2 to rwy 20. The tower controller said the acft was so low that at one point he lost sight of the acft. He advised the plt that he appeared to be…Oct 26, 1984 · N75DR · Substantial damageNTSB DEN85LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Lima, MTAprx 35 min prior to the accident the seismic operations being conducted about 10 mi NE were secured due to poor visibility and high winds. The plt estimated wind to have been from 180 deg at 40 KTS gusting to 60. As the plt approached the landing zone…Oct 26, 1984 · N8624 · Substantial damageNTSB MKC85LA005Accident · No injuriesLimited investigationFinal reportBeech A36 · North Platte, NEThe plt stated that he had been using fuel from the rt wing fuel tank to compensate for a lateral imbalance during the flt. The fuel selector was on the rt tank when the eng failed. The plt said he switched tanks after the eng failed but was unable to restart…Oct 25, 1984 · N1890L · Substantial damageNTSB BFO85FA002Accident · 4 fatalField investigationFinal reportPiper PA-32R-301 · Salisbury, MDAfter contacting millville fss 4 times for wx info the acft departed lincoln park, NY, at 1858 EDT with destination listed on the IFR flt plan as easton, MD. En route the plt diverted to Salisbury, MD, due to wx. After being cleared forthe rwy 32 ILS the acft…Oct 25, 1984 · N81752 · DestroyedNTSB ATL85FA020Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Vicksburg, MSDuring preflt, plt detected water in fuel sample. After takeoff, the engine began to run roughly and on crosswind leg lost power completely. Plt stated that on approach to forced landing, he intentionally struck a tree with the left wing to slow the acft.…Oct 25, 1984 · N4873Z · DestroyedNTSB BFO85FA001Accident · 2 fatalField investigationFinal reportBeech 58 · Hot Springs, VAThe destn arpt was unattended at night & when the plt received his last wx briefing at 0519 CDT, no current wx info was available. During arrival, the acft was vectored for an ILS rwy 24 apch & the plt was advised that current wx info was still not available.…Oct 24, 1984 · N777AB · DestroyedNTSB DEN85FA017Accident · Serious injuriesField investigationFinal reportCessna 414 · Cheyenne, WYThe acft collided with the ground during a turn to final from a circling approach (IFR) at Cheyenne airport. According to ATC, the acft was a VFR 'pop up' & was subsequently issued an IFR clearance for an approach into the airport. Examination of the acft at…Oct 23, 1984 · N1569T · Substantial damageNTSB MIA85IA015Incident · No injuriesIncident investigationFinal reportMBB BO-105 · Orlando, FLThe purpose of the flt was to transport a 76 yr old patient, who was in critical condition. The flt was normal until it was on final apch to a 7th floor, rooftop, hospital heliport. During the apch, the plt attempted to increase the collective to slow the…Oct 22, 1984 · N29144 · Minor damageNTSB LAX85LA028Accident · No injuriesLimited investigationFinal reportCessna 172 · Palo Alto, CALoss of pwr occurred on final apch. Acft contacted a dike during forced landing collapsing the nose gear. Plt said direct route was flown at 10,500 ft MSL descending lower after crossing mountainous area. Plt did not lean mixture during flt or report which…Oct 22, 1984 · N61739 · Substantial damageNTSB ANC85LA008Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Theodore River, AKThe acft crashed during a go-around attempt at Theodore River located 35 miles southwest of anchorage, AK. According to the plt, after landing on a gravel oil pad he realized that the acft would not stop before going over the edge into a swamp. He applied…Oct 19, 1984 · N78449 · Substantial damageNTSB LAX85FA024Accident · No injuriesField investigationFinal reportCessna T207A · Sedona, AZOn final approach about 1.5 miles from the arpt the power loss occurred as the pilot attempted to add power. After flying over a ridge and several trees the acft touched down in the rough terrain and caught fire. The fire appeared to have started in the…Oct 18, 1984 · N6262H · DestroyedNTSB DCA85IA003Incident · No injuriesIncident investigationFinal reportBoeing VC-137B-BN · Seattle, WADuring arrival, a Boeing VC-137B-BN, USAF #58-6970, operating as air force 2 (AF-2), was cleared for a localizer back- course apch. At 1442:49, TRACON advised AF-2 of traffic at its 10 o'clock position at 2 mi, alt unkn. At 1443:11, TRACON advised AF-2 the…Oct 18, 1984 · USAF · 2 aircraft · No damageNTSB LAX85FA019Accident · No injuriesField investigationFinal reportCessna 210 · San Pedro, CAThe acft was on a 3.5 mile final approach to torrence arpt when the pilot experienced an engine failure. The plt landed the acft the los angeles, west basin harbor. Examination of the engine and associated fuel lines after the accident revealed no evidence of…Oct 16, 1984 · N7470E · Substantial damageNTSB CHI85LA016Accident · Serious injuriesLimited investigationFinal reportCessna 340 · Blue Earth, MNDuring arrival, the plt was cleared for a vor/dme apch to rwy 31. As he continued, he intercepted a 12 mi arc. He stated that when he applied power to level off at 2800 ft MSL & no power was available. He moved the mixtures to full rich, positioned the fuel…Oct 16, 1984 · N5422M · Substantial damageNTSB ANC85LA005Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Wasilla, AKDuring final approach the acft struck an unmarked staic wire 40 ft AGL and more than 75 ft from intended touch down. The pilot lost control of the acft. The acft landed on a parked acft during the descent.Oct 16, 1984 · N1609G · Substantial damageNTSB NYC85LA009Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Ono, PAAfter a lndg practice flight, solo student plt returned to home field at dusk. First lndg attempt resulted in overshoot and go-around. Since winds were calm, plt elected to land on reciprocal runway due to clear overrun area. This necessitated on obstacle…Oct 15, 1984 · N1069E · Substantial damage