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 NYC86LA106Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · W. Milford, NJOn approach to Milford airport, the flight collided with power lines and crashed. The pilot made a missed approach then on second approach collided with wires, the pilot stated that it was dark and he did not see the wires until it was too late.Apr 14, 1986 · N43543 · Substantial damageNTSB MIA86LA121Accident · No injuriesLimited investigationFinal reportCessna 340 · Ocala, FLWhile on a combination company business and training flight, the instructor seated in the right seat of the aircraft commanded the other pilot to execute a VFR go-around on short final. The other pilot added power to both engines and noted that the right…Apr 14, 1986 · N1707G · Substantial damageNTSB DEN86LA117Accident · No injuriesLimited investigationFinal reportCessna 172H · Crossroads, NMAccording to the plt, he was attempting to underfly powerlines over a public road during landing, when the aircraft contacted an unseen wire and crashed.Apr 14, 1986 · N2896L · Substantial damageNTSB BFO86FA023Accident · Minor injuriesField investigationFinal reportPiper PA-28R-200 · Camp Springs, MDDuring a flt to prepare the student for a CFI check ride, both the student and the CFI could not obtain a green light confirming the nose gear was down and locked. After numerous attempts to assure it was down and locked the acft was landed at andrews afb.…Apr 14, 1986 · N32613 · Substantial damageNTSB CHI86FA120Accident · 2 fatalField investigationFinal reportLuscombe 8B · Pittsford, MIThe pilot overshot final approach due to a 10-15 kt tailwind on base leg. According to a pilot friend on the ground he put the acft into a 60 degree bank to in an attempt to realign himself with the final approach course. During this steep turn the aircraft…Apr 13, 1986 · N28914 · DestroyedNTSB SEA86LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Pioche, NVWhile on a quarter mile final to runway 06 with winds from 150 degrees at 15 knots gusting to 30 knots the pilot experienced turbulence. The pilot reported he retracted the flaps from 10 degrees and added full power. The aircraft climbed approximately 20 feet…Apr 12, 1986 · N734JP · Substantial damageNTSB MKC86LA087Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · St. Louis, MOThe plt reports that a wind squall passed over the arpt as he was landing. He said the acft encountered windshear at about 100 ft AGL on final apch and began to sink. The plt added pwr but could not stop the sink and the acft landed in a plowed field about 20…Apr 12, 1986 · N2578H · Substantial damageNTSB LAX86LA173Accident · No injuriesLimited investigationFinal reportCessna 182A · Death Valley, CAThe acft collided with terrain after a loss of pwr 50 yards short of the rwy. The plt stated he used various fuel selector positions while en route. Upon entry into the traffic pattern on a right downwind, the left tank was selected. On final apch the plt…Apr 12, 1986 · N5925B · Substantial damageNTSB FTW86LA064Accident · Serious injuriesLimited investigationFinal reportTaylorcraft L-2 · Graham, TXWitnesses stated the aircraft stalled during a sharp right bank at approximately 150 feet. The propeller exhibited no signs of rotation at impact. The engine was dissassembled in an attempt to determine the apparent failure. No evidence of pre-impact failure…Apr 12, 1986 · N50639 · Substantial damageNTSB ATL86LA111Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26A · Waynesville, OHThe pilot misread his altimeter and misjudged his altitude while in the traffic pattern for landing at the private gliderport. The glider collided with powerlines on the approach end of the runway and crashed short of the runway surface.Apr 12, 1986 · N2760R · Substantial damageNTSB CHI86FEP03Accident · Minor injuriesFinal reportSteinorth Extra Long EZ · Kenosha, WIDuring an apch to land, the eng of the home built acft lost power. The plt tried to restart the eng by using the ignition switch, but was unable. He turned to land in a pasture, but the acft hit an electrical wire & came to rest in a row of trees. The plt…Apr 11, 1986 · N123AE · Substantial damageNTSB ATL86LA109Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birmingham, ALAfter takeoff pilot noted loss of engine oil pressure. Engine siezed and pilot landed short of runway. A/c hit ILS antenna during landing roll, severed right wing. Engine oil cooler line burst due to aging. Line was fabricated in the 1st qtr 0F 1972. Oil…Apr 11, 1986 · N4087W · Substantial damageNTSB SEA86LA099Accident · Serious injuriesLimited investigationFinal reportMorley Avid Flyer · Spokane, WAWhile on a five-mile final, a total loss of power occurred. A loose right magneto contacting the flywheel magnet and shorting the electrical system was found. In an attempt to miss a river in the approach path to the runway, the pilot attempted a 180 degree…Apr 10, 1986 · N318M · DestroyedNTSB LAX86LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · San Jose, CAThe acft collided with terrain after a complete loss of pwr while on final apch. Post accident exam of the acft disclosed no fuel in either the main tanks nor in the carburetor fuel line. The plt indicated on his plt/operator accident report the right and…Apr 10, 1986 · N9237K · Substantial damageNTSB FTW86LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · El Paso, TXA student pilot, practicing touch and go landings, attempted a go-around. The pilot did not maintain sufficient airspeed before the aircraft stalled and collided with the runway.Apr 9, 1986 · N69054 · Substantial damageNTSB LAX86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Hesperia, CADuring a solo instructional flight the student plt attempted to land on a 3910-foot-long rwy which had its landing threshold displaced by 550 feet. The wind was light & variable, & the student plt was low on short final approach. The acft collided with the…Apr 8, 1986 · N5889V · Substantial damageNTSB SEA86IA095Incident · No injuriesIncident investigationFinal reportRaven RX-7 · Beaverton, ORThe pilot misjudged obstacle clearance during his descent for landing. The balloon's envelope was then impaled on a light pole. Flt time was not reported by the plt.Apr 7, 1986 · N27980 · Minor damageNTSB MKC86FA082Accident · Serious injuriesField investigationFinal reportHiller UH-12B · Fall River, KSThe helicopter flew through the tops of trees next to a plowed field and impacted almost straight down in the plowed field and nosed over to the inverted position. The pilot stated that he had intended to land in the field and allowed the airspeed and main…Apr 7, 1986 · N5307V · DestroyedNTSB DEN86LA110Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Falcon, COThe plt stated the acft contacted a powerline pole during a go-around. The powerline pole is located aprx one-half mile off the departure end of rwy 33. According to the plt, the pole is unmarked and unlighted. The accident occurred during night hrs with no…Apr 6, 1986 · N1580Q · Substantial damageNTSB CHI86FEM04Accident · No injuriesFinal reportPerkins Viking Dragonfly · Lansing, MIOn his first flight in this type of homebuilt the pilot encountered what he said was windshear on final approach for his first landing. He added power and the aircraft pitched up 30 degrees. He pushed down on the stick and the aircraft pitched down violently.…Apr 6, 1986 · N192AP · Substantial damageNTSB MKC86FA080Accident · Serious injuriesField investigationFinal reportCessna 150F · Hannibal, MOThe student plt was attempting to land with a right crosswind component in excess of 15 knots. He used a crab angle on final but as the acft apch the rwy he applied rudder. He said, with full rudder the acft was still not aligned with the rwy and he decided…Apr 5, 1986 · N8917S · Substantial damageNTSB FTW86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Springtown, TXThe pilot reported colliding with a fence at the end of the runway when he landed short while on final approach into kezer airport near Springtown, TX. His aircraft sustained substanial damage to the left wing, nose gear and propeller after travelling 200 ft.…Apr 5, 1986 · N9019W · Substantial damageNTSB MIA86FA110Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Ocklawaha, FLThe pvt plt refueled his acft the night before the flt and was observed to drain only the firewall strainer. The morning of the flt he did not drain any drains. About half way to his destination an eng pwr loss was experienced, he declared an emergency and…Apr 4, 1986 · N742JM · DestroyedNTSB SEA86LA090Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Fallon, NVWhile on final apch to the arpt, the acft's eng ceased operating due to fuel exhaustion. The acft was damaged during a hard forced landing on a baseball fld.Mar 31, 1986 · N6282P · DestroyedNTSB NYC86FA096Accident · 5 fatalField investigationFinal reportPiper PA-24-180 · Somers, CTThe acft, on a night flt, was seen flying about 1 mi west of ellington arpt. A witness saw the acft flying north and just above the 800 ft high terrain. The acft was in a gradual descent and it appeared that it would not clear terrain ahead. Afterwards the…Mar 31, 1986 · N6599P · DestroyedNTSB ATL86FKG08Accident · Minor injuriesFinal reportJoachim Hoehne Pazmany PL-4A · Canton, GAThe acft struck a powerline wire during an attempted go-around after a bounced landing. The plt aborted the landing and turned left at low alt until impact with a wire occurred at a distance of about 300 ft left of the rwy and 1200 ft from the approach end.…Mar 30, 1986 · N3942U · DestroyedNTSB FTW86LA053Accident · No injuriesLimited investigationFinal reportCessna 172 · Sallisaw, OKThe pilot stated that on approach into an unfamiliar airstrip he encountered turbulence and a tail wind. He attempted a go-around at a low altitude with full flaps. Before sufficient airspeed could be reached and flaps retracted, the aircraft collided with…Mar 29, 1986 · N7341A · Substantial damageNTSB DEN86LA107Accident · Serious injuriesLimited investigationFinal reportRolladen-Schneider L53 · Colorado Spring, COThe acft was making a landing due to an approaching thunderstorm. On final, the glider encountered moderate to severe turbulence and at 300 ft AGL, the glider was forced onto the ground by a microburst.Mar 29, 1986 · N96JH · Substantial damageNTSB FTW86FA049Accident · Serious injuriesField investigationFinal reportSpencer Pitts S-1 · Mckinney, TXAs a pitts special, N66D, was in the traffic pattern to lnd, a Cessna L-19E towplane, N4431B, was on the 1300' grass overrun near the apch end of the rwy with a glider being readied for tow. The glider (sailplane) was a grob 103, N226BG.the plt of the pitts…Mar 28, 1986 · N66D · 2 aircraft · Substantial damageNTSB SEA86LA082Accident · Serious injuriesLimited investigationFinal reportSocata MS894A · Wasco, ORThe plt stated that he encountered a wind shear on final. At the time of the accident the wind was recorded to be from the south/southeast at two knots with peak winds at four knots. When the plt noticed that his airspeed had deteriorated to 50 mph, he went…Mar 26, 1986 · N54BF · Substantial damageNTSB FTW86LA048Accident · No injuriesLimited investigationFinal reportBeech H35 · Talihina, OKAcft had a long descent from cruise alt of 7500' MSL at reduced power setting due to plt's desire to avoid the moderate turbulence at lower altitudes. On short final, over tall trees, the acft encountered a downdraft. The plt stated that when he applied power…Mar 25, 1986 · N5531D · Substantial damageNTSB DEN86FA103Accident · 2 fatalField investigationFinal reportI.C.A. Brasov IS-28B2 · Cedar City, UTThe plt and pax were returning from a LCL flt. Two fss specialists observed the glider on final approach to rwy 20. They stated that the acft completed two 360 degree turns with 90 degrees of bank. The glider was in the third 360 degree turn when the…Mar 24, 1986 · N32907 · Substantial damageNTSB CHI86FA108Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Boyne Falls, MIAfter the plt was cleared for an rnav-b apch, the acft crashed on hilly trrn aprx 3 mi se of the arpt at an elev of 750'MSL. Impact occurred after the acft had turned to the sse & was dscndg. Min dscnt alt (mda) for the apch was 1680'. No preimpact mechanical…Mar 23, 1986 · N43769 · DestroyedNTSB MKC86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Oil Trough, ARThe PIC found himself low on fuel with an indication of only 5 gallons in each tank. He passed over an arpt with fueling facilities available but diverted to batesville, Arkansas, which lay 48 miles beyond his present posn. The PIC stated that he attempted a…Mar 22, 1986 · N30561 · Substantial damageNTSB MKC86LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Neosho, MOThe pilot stated that he had descended from 5500 feet MSL to 2000 feet MSL with the throttle at idle and without using carburetor heat. When he advanced the throttle, the engine did not respond and he attempted a forced landing. The airplane impacted trees,…Mar 22, 1986 · N1017X · Substantial damageNTSB ANC86LA039Accident · No injuriesLimited investigationFinal reportCessna 172-G · Anchorage, AKThe plt stated that during the return from a x-country flt the acft ran out of fuel one-half mile from the rwy. Post acc exam revealed that both fuel tanks were empty.Mar 22, 1986 · N5892B · Substantial damageNTSB LAX86LA149Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Phoenix, AZThe pilot was practicing instrument approaches and reported to the control tower that he had experienced a loss of engine power. During the attempted forced landing, the aircraft struck power lines and crashed inverted in a river bed two miles west of the…Mar 21, 1986 · N5256A · Substantial damageNTSB FTW86LA072Accident · No injuriesLimited investigationFinal reportCessna R172K · Waco, TXThe pilot of a Cessna 172, N758KU, over-shot his approach to a privately owned grass strip. The runway is 05/23, 3180 foot long and 100 foot wide with an approximate 300 ft. displaced threshold at east end. The wind was variable from 300 degrees at 8 knots at…Mar 21, 1986 · N758KU · Substantial damageNTSB ANC86FA037Accident · 2 fatalField investigationFinal reportde Havilland DHC-4A · Lime Village, AKWitnesses observed the acft on final approach with its gear down then the nose pitched up. The acft rolled left and crashed into trees. The acft's cockpit, cabin, engine nacelles, cargo and portions of the wings were destroyed by post-impact fire. Post…Mar 20, 1986 · N539Y · DestroyedNTSB NYC86FHA02Accident · Serious injuriesFinal reportGulfstream American AA-1 · Pottstown, PAThe acft collided with an embankment short of the intended rwy. A CFI waiting on the taxiway for clearance to takeoff stated that the acft appeared to be ok about 200 ft from the threshold of the rwy. Then it appeared to slip to the left and turn 90 degrees…Mar 16, 1986 · N224Y · Substantial damageNTSB MIA86IA098Incident · No injuriesIncident investigationFinal reportBoeing 727 · Miami, FLDuring arrival at ft lauderdale, the aircrew attempted to extend the gear, but at first, they were unable to get a safe 'down' indication for the rgt main gear. After about one hour, they were able to insure that both main gear had extended& were locked. They…Mar 16, 1986 · N8861E · Minor damageNTSB NYC86FA084Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Williamstown, NJThe plt executed VOR rwy 09 apch to the arpt at night and during low visibility conditions that ranged from 100 to 400 feet due to fog. The acft first collided with a house, followed by two parked cars and then main impact with a second house. The accident…Mar 14, 1986 · N8259E · DestroyedNTSB DCA86AA021Accident · 3 fatalFinal reportEmbraer EMB-110P1 · Alpena, MIDrg arrival at 2125 EST, simmons airline flt 1746 was adzd by wurtsmith afb apch ctl that the 2052 EST wx at phelps collins arpt was: sky partially obscd, ceiling 100' overcast, vis 1/2 mi with lgt drizzle & fog, & to expect an ILS apch. However, at 2119, a…Mar 14, 1986 · N1356P · DestroyedNTSB ATL86FA092Accident · 1 fatalField investigationFinal reportPiper PA-23 · Toledo, OHN3124P crashed while attempting an ILS approach to rwy 07 at express airport in Toledo, OH. The pilot had attempted an approach at metcalf airport but missed the approach because of the weather. The aircraft crashed about 1 mile short of the airport in a…Mar 13, 1986 · N3124P · No damageNTSB SEA86FA075Accident · Serious injuriesField investigationFinal reportStinson 108-2 · La Conner, WAPlt was on approach for water landing in a canal used during previous summer for floatplane ops at dusk. Plt was looking for a specific boat moored in canal as landing mark, extended approach path beyond normal touchdown point. Acft struck telephone cable…Mar 11, 1986 · N388C · DestroyedNTSB MIA86LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · Captiva, FLThe plt stated that she was making a low final approach to the 2200 ft grass strip & lost lift as the acft passed below & behind the treeline. The plt's husband, also a plt, occupying the right front seat, stated that his wife may have been somewhat…Mar 9, 1986 · GPZS · Substantial damageNTSB DEN86LA095Accident · Minor injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P Aerostar · Dickinson, NDWhile enroute on an IFR flight plan, the plt changed destination to Dickinson, ND, which extended the length of the flt. He did not desiginate an alternate arpt or have an adequate fuel reserve as required. On arrival at the destination, he executed an…Mar 9, 1986 · N35DM · Substantial damageNTSB CHI86FA100Accident · 2 fatalField investigationFinal reportCessna 172M · Lafox, ILAn instructor plt (cfi/cfii) & his student (pvt single eng rated plt) were on an instructional flt in a Cessna 172, N72MA. The student had rrecently been taking instrument flt training & had a hood for use on this flt. Prior to the acdnt. The Cessna 172 was…Mar 8, 1986 · N72MA · 2 aircraft · DestroyedNTSB LAX86LA135Accident · No injuriesLimited investigationFinal reportRobinson R-22 · El Toro, CAA helicopter crashed into a mountain slope east of El Toro, CA while on a business flt. While the acft approached the mountain peak the plt experienced an increase in the rate of descent and aborted the landing. During the go-around, at adecreased main rotor…Mar 5, 1986 · N9072Z · Substantial damageNTSB ATL86FA085Accident · No injuriesField investigationFinal reportBeech BE-90 · Mount Pleasant, TNOn final approach the crew turned the aircraft cabin environmental control from the auto mode to the off position. Shortly thereafter, the cockpit and cabin began to fill with smoke. The occupant of the copilots seat felt heat around his feet. A normal…Mar 4, 1986 · N861K · Substantial damage