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 SEA83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Grass Valley, ORThe aircraft stalled while the pilot was attempting to land downwind on an uphill Grass strip. The wind was estimated at 15 gusting to 20 KTS. The pilot stated that on his approach, he was to the left of the center of the landing strip. He attempted to…May 16, 1983 · N7173K · Substantial damageNTSB LAX83LA231Accident · No injuriesLimited investigationFinal reportCessna 150M · Bakersfield, CAThe acft collided with a powerline while on final approach and nosed over in a open field one half mile short of the runway. The pilot had flown into this arpt the morning of the accident as a pax. She decided to do some takeoffs and landings, local pilots…May 15, 1983 · N63404 · Substantial damageNTSB CHI83LA215Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Grandville, MIReportedly, the plt increased the bank angle during a turn to align the acft on final apch, then the plane lost speed & stalled. Subsequently, the acft impacted the ground aprx 480 ft southwest of the rwy threshold. Aprx 10 mi east at grand rapids, MI, the…May 15, 1983 · N3019N · Substantial damageNTSB FTW83LA233Accident · No injuriesLimited investigationFinal reportCessna 170A · Prague, OKWhile turning to base leg for landing the eng quit. With insufficient altitude to reach the arpt, the plt selected another field, but landed short in rough terrain. A large quantity of water was found in the acft's fuel tanks which wastraced to a contaminated…May 14, 1983 · N170KM · Substantial damageNTSB NYC83LA111Accident · No injuriesLimited investigationFinal reportCessna 150L · Monroeville, PAThe acft crashed into trees during an aborted landing. The student pilot was not injured. The weather was VMC and no fltplan was filed for this student solo flt. The pilot had set 30 degrees of flaps for landing, the pilot attempted to correct his position…May 13, 1983 · N10506 · Substantial damageNTSB LAX83LA228Accident · No injuriesLimited investigationFinal reportCessna 150F · Chico, CAThe student plt was practicing takeoffs & landing on a 2280 ft rwy in calm wind conditions. He reported that while on a final apch to land, the acft was high & was aprx 10 mph too fast. Before touching down & with over half of the rwy behind, the student…May 13, 1983 · N8674S · Substantial damageNTSB ATL83FIG04Accident · No injuriesFinal reportPiper PA-32-260 · Laurel, MDThe pilot started a go-around after the acft had progressed over half way down the runway in the air. When full power was applied the engine sputtered and quit. The pilot changed fuel tanks, lowered the nose and landed straight ahead in the tops of trees.…May 13, 1983 · N4823T · Substantial damageNTSB SEA83LA068Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Inchelium, WAThe intended landing area was a dirt road aprx 1500 ft long. After making a low pass to check the area, the plt made an approach over trees to land, but was too high, so he went around. On the 3rd pass, he applied full flaps. The plt stated that the acft was…May 12, 1983 · N1498F · Substantial damageNTSB MKC83FA108Accident · Serious injuriesField investigationFinal reportBeech D55 · Gardner, KSThe plt was cleared for an ILS rwy 35 approach & given the Kansas city downtown arpt (23 mi NE) wx as 900 ft broken & 6 mi visibility. The tower was closed & the control zone was not in effect raising minimums. The plt stated his ILS glide slope indication…May 12, 1983 · N725M · Substantial damageNTSB ATL83FA185Accident · 2 fatalField investigationFinal reportCessna 150L · Cheraw, SCThe student was on his 5th dual instructional flt & was practicing landings with his instructor. They had completed 3 or 4 landings & were in the traffic pattern for another when an intense thunderstorm cloud moved over the arpt. A plt/witness stated that a…May 12, 1983 · N21991 · DestroyedNTSB CHI83LA208Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Ceresco, MIThe plt reported that the acft was normal until he was on final apch to land. The acft began to loose too much altitude, so he advanced the throttle, then the eng lost power. Subsequently, the acft hit the top of a tree short of the rwy, then crashed. An exam…May 11, 1983 · N3355H · Substantial damageNTSB ATL83FA182Accident · Serious injuriesField investigationFinal reportCessna 172P · Gastonia, NCThe acft stalled into the ground just short of the rwy and collapsed the nose gear. The pilot was flying from the right seat so his female passenger could use the more adjustable left seat. The pilot stated that at 70 KTS on final approach for a landing the…May 9, 1983 · N5324K · Substantial damageNTSB MKC83LA105Accident · No injuriesLimited investigationFinal reportCessna 182Q · Springfield, MOThe acft went off the runway, collapsed the nose gear and nosed over during landing. The pilot was unable to extend the flaps and tried to land on a 3800 foot runway. There was a 7003 foot runway 8 NM west of the landing site. The pilot also had a tailwind of…May 8, 1983 · N4801N · Substantial damageNTSB LAX83LA259Accident · No injuriesLimited investigationFinal reportCessna 421B · Buckeye, AZThe plt had made 3 night landings at the strip during the past 6 mths. The procedure that had been used for lighting thestrip was to place a vehicle at the west end with the headlights facing east down the centerline of the strip. However, on the night of the…May 7, 1983 · N315CC · Substantial damageNTSB LAX83LA224Accident · No injuriesLimited investigationFinal reportGoldwing Dragan · Gilbert, AZThe plt/owner had assembled the acft from a kit aprx 1 yr prior to the accident. He reported that the acft was not equipped with brakes. When he returned to land at the ultralight flt park, he decided to make a low, short final apch to decrease the stoppage…May 7, 1983 · N3225D · Substantial damageNTSB MKC83LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-350 · Clinton, MOWhile cruising at 8,500 ft the pax in the right seat noticed that the oil filler access door on top of the right eng wasopen & oil was leaking. The plt checked the eng instruments & the only abnormal reading was a low manifold pressure reading on the left…May 6, 1983 · N278MW · Substantial damageNTSB LAX83LA218Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Gila Bend, AZThe student plt departed livermore, CA at an undetermined time. He reported that his destination was tucson, AZ. En route stops were made at bakersfield & banning, CA. After refueling at banning, he departed on a unspecified & undetermined route. He stated…May 6, 1983 · N7795U · Substantial damageNTSB CHI83LA200Accident · No injuriesLimited investigationFinal reportCessna U206 · Terre Haute, INThe acft made a forced landing off arpt after the engine lost power on the approach. The plt said he was using fuel fromthe right engine when the engine started to sputter. The plt switched to the left tank and tried to restart the engine to no avail. The…May 6, 1983 · N2198F · Substantial damageNTSB ATL83LA177Accident · No injuriesLimited investigationFinal reportBeech K35 · Fitzgerald, GAThe acft made a forced landing in an open field off the airport after the engine quit at about 300 ft AGL during a go- around. The pilot who was being checked out in this acft by an instructor was trained in a C-172 which has differences in the fuel system.…May 6, 1983 · N9526R · Substantial damageNTSB FTW83FA221Accident · No injuriesField investigationFinal reportBeech E33 · San Angelo, TXThe eng failed in flt & the acft crashed 1 mi short of rwy 18 during an emergency landing into mathis arpt. The acft's fuselage was streaked with fresh oil. The rigid oil pressure line, extending from the eng to the firewall, failed due tofatigue cracking…May 5, 1983 · N8314N · Substantial damageNTSB LAX83FUG15Accident · No injuriesFinal reportBoland Mong Sport · Murietta, CAThe acft collided with a fence during a forced landing in a grass field. The plt stated that during pre-flight, he found about 7 gallons of fuel aboard the acft. His flight was to be only 20 minutes of air work. Some time was added in locating ground…May 3, 1983 · N32RJ · Substantial damageNTSB SEA83FA094Accident · 1 fatalField investigationFinal reportCessna C-172N · Friday Harbor, WAThe acft crashed during an attempted go-around. The acft flap switch was in the down mode and the flaps were in the fulldown(40 degree) position. A passenger said the acft was 'real close to the right side of the runway' just before go- around N3413E impacted…May 1, 1983 · N3413E · DestroyedNTSB FTW83LA214Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Krum, TXThe acft collided with the ground during a simulated forced landing and go-around. The acft's left main landing gear wassheared and the left wing dragged during ground contact. The CFI had given the student a simulated forced landing during the approach and…May 1, 1983 · N2495K · Substantial damageNTSB FTW83LA212Accident · No injuriesLimited investigationFinal reportQuickie Q-2 · Fabens, TXThe pilot said that he was flying a low aprch to the airport. When he added power to go around the engine failed. A forced landing was made in a field. The acft is equipped with a header tank which feeds the engine and a main tank which feeds the header tank.…Apr 29, 1983 · N82JW · Substantial damageNTSB FTW83LA352Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Morrilton, ARThe acft collided with trees on the final approach to land at night. The plt had canceled his IFR clearance. During the approach the plt had the rwy in sight and asked memphis center how FAR he was from the arpt. When he was informed he WAS3 miles south he…Apr 28, 1983 · N54174 · Substantial damageNTSB DEN83AA105Accident · 3 fatalFinal reportCessna 340 · Rock Springs, WYThe aircrew of a Cessna 340, N5415M, were scheduled for an air taxi check ride with an inspector at jackson, WY, later in the afternoon. They had planned to takeoff from Rock Springs, WY, practice a few instrucment apchs at Rock Springs, then proceed to…Apr 26, 1983 · N5415M · 2 aircraft · DestroyedNTSB CHI83LA192Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Minneapolis, MNAfter takeoff, the plt elected to practice touch-and-go landings. After about 5 landings, the eng lost power while the plt was turning on a base leg for rwy 17 at about 400 ft AGL. He tried to restart the eng. However, the left wing hit the tops of trees &…Apr 26, 1983 · N82717 · Substantial damageNTSB CHI83LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Havana, ILThe aircraft collided with the ground during an attempted go around when the pilot stated that he did not see but two ofthe landing gear lights on. The approach was to runway 9 in a crosswind from 170 degrees at 18 KTS with gusts to 24 KTS the pilot described…Apr 26, 1983 · N7670J · DestroyedNTSB ANC83FA075Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Soldotna, AKWitnesses observed the acft maneuvering erratically near the arpt & anticipated the accident. The 1st approach to rwy 25WAS described as erratic with minimal apparent control which included an abrupt pull-up, stall, bounce, & go-around in aleft pattern at 300…Apr 25, 1983 · N4396Z · DestroyedNTSB DEN83LA101Accident · No injuriesLimited investigationFinal reportPiper J3C65 · Kalispell, MTWhile making an approach to a field on a ranch, the acft hit a power line on short final and crashed upright in the field. The pilot said he did not see the wire across the north approach to the field.Apr 24, 1983 · N88075 · Substantial damageNTSB CHI83LA181Accident · No injuriesLimited investigationFinal reportCessna 172P · Mt. Pleasant, MIWhile on a local sight-seeing flt, the plt elected to land at mt Pleasant, MI for lunch. A low pass was made over rwy 09. The plt reported that while he was on a second approach to land, the acft encountered wind gusts and a loss of altitude. The plane's…Apr 24, 1983 · N6155K · Substantial damageNTSB FTW83LA197Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Gage, OKThe acft made a forced landing off arpt after the engine quit. The weather was VMC and no flt plan was filed. This was across-country flt from los angeles, CA to bolivar, MO with a fuel stop at Gage, OK. The flt crashed 900 ft short of the rwy at Gage, OK.…Apr 20, 1983 · N599VK · Substantial damageNTSB NYC83LA108Accident · No injuriesLimited investigationFinal reportBellanca 7GBC · Middleboro, MAThe acft landed short of the runway after experiencing a power loss on the approach. The pilot had carburetor heat on and when he experienced a downdraft on final he said he opened the throttle and the engine quit. The acft was landed in the bushes short of…Apr 18, 1983 · N4163Y · Substantial damageNTSB FTW83LA198Accident · No injuriesLimited investigationFinal reportCessna A188B · El Campo, TXThe pilot said that as the acft was turning final flaps were extended to 20 degrees and the angle of bank was increased resulting in an increased rate of descent. He added power to correct his descent rate but the engine did not respond. Pumping the throttle…Apr 18, 1983 · N4876R · Substantial damageNTSB FTW83LA196Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-180 · Socorro, NMThe acft was returning from a cross-country flt and crash landed about 1 mile from the arpt when the engine quit. The pilot said he added power to reach the rwy but the engine would not respond. The acft impacted the ground and slid to a stop. An FAA…Apr 18, 1983 · N5064P · DestroyedNTSB NYC83LA099Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Erwinna, PAThe glider was on a dual instructional flight for landing practice. On the final approach to landing the glider lost lift after experiencing excessive sink and clipped the tops of trees. The glider landed short of the intended area and the wings and nose of…Apr 17, 1983 · N2706H · Substantial damageNTSB MIA83FA123Accident · Serious injuriesField investigationFinal reportBeech V35TC · Destin, FLThe acft collided with a powerline, crashed & burned after the engine lost power on the final approach. The acft was using fuel from a tank that was less than half full. The acft had made a go-around and during the pattern was observed to be oscillating from…Apr 17, 1983 · N265T · DestroyedNTSB LAX83FU002Accident · Serious injuriesFinal reportRotec Rally 2B · Le Grand, CAReportedly, the plt took off & landed in a dairy pasture with no apparent difficulties. He then took off again on an easterly heading. After takeoff, he turned to a modified crosswind/downwind pattern & was proceeding in a northwesterly direction. Reportedly,…Apr 17, 1983 · UNREG · Substantial damageNTSB NYC83FA098Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Blue Bell, PAThe plt had been briefed on forecast strong winds & a SIGMET for moderate to severe turbulence. Witnesses observed the acft make a series of approaches to rwy 24. On the 1st approach the acft was almost over the threshold as the base turn was completed. The…Apr 16, 1983 · N8167K · DestroyedNTSB ATL83FA163Accident · 4 fatalField investigationFinal reportBeech V35B · Frisco, NCThe destination arpt was unlighted & was closed from 30 min after sunset until 30 min before sunrise. Prior to the flt, the plt made arrangements for someone to take his car to the destination arpt & park it with the headlights turned on at the apch end of…Apr 16, 1983 · N9394Q · DestroyedNTSB LAX83LA194Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Oceana, CAThe student plt, a mexican national, was on a solo x-country flt. He reported that he could not locate the destination arpt at san luis obispo, CA. After circling the area, he saw the Oceana arpt & started to land. While on final apch, the eng lost power.…Apr 15, 1983 · N5985F · Substantial damageNTSB FTW83LA192Accident · Minor injuriesLimited investigationFinal reportCessna 210K · Austin, TXBefore taking off (at 1740) on his return flt, the plt got a wx briefing & checked the NOTAMS, but did not refuel the acft. There were no NOTAMS for the san marcos arpt. During arrival at san marcos, TX, no rwy lights were visible. The plt circled for 15 to…Apr 15, 1983 · N8234M · Substantial damageNTSB CHI83FA166Accident · 1 fatalField investigationFinal reportPiper PA24-260 · Middleton, WIDuring arrival at night, the plt was cleared for a vor-b apch to the morey arpt, an uncontrolled facility at an elevation of 928 ft MSL. Rwy 13/31 at the arpt had low intensity rwy lights which could be activated by keying the radio on 123.5 mhz. The circling…Apr 15, 1983 · N9215P · DestroyedNTSB ATL83FIJ02Accident · Serious injuriesFinal reportCessna 182P · Bluefield, WVThe plt reported that he began an ILS approach to the mercer county arpt. He stated that he planned to descend to 3200 ft MSL, then execute a missed approach & return to abington, VA. The arpt elevation was 2857 ft MSL. He stated that he remembered glancing…Apr 15, 1983 · N7353S · DestroyedNTSB FTW83LA186Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Weston, TXThe plt was on a flt to obtain aerial photographs. He elected to land in a pasture to discuss a survey problem with personnel on the ground. He had previously checked the area by driving across it with a vehicle and felt it was satisfactory. After making a…Apr 13, 1983 · N2437Q · Substantial damageNTSB ATL83LA160Accident · No injuriesLimited investigationFinal reportBell 47G-4A · Charleston, WVDuring an approach to land, the engine lost power at aprx 500 ft AGL. The plt reported that during an autorotative landing, he had to maneuver to avoid trees & a ridge in order to land in a suitable area. During this time, rotor RPM dropped & a crash landing…Apr 13, 1983 · N4749R · Substantial damageNTSB MIA83LA122Accident · No injuriesLimited investigationFinal reportCessna 402B · Ft. Pierce, FLThe acft was landed wheels up. The pilot stated that he never heard the landing gear warning horn operate. Post accidentinvestigation showed that the landing gear operated properly but that the warning horn was inoperative. The pilot of theaccident acft held…Apr 12, 1983 · N13GM · Substantial damageNTSB MIA83LA119Accident · Minor injuriesLimited investigationFinal reportSpencer Quickie Q2 · Tallahassee, FLThe acft was on its first test flt since being built. After about 40 min of flt, the acft returned to land. On final the plt added power to check the sink rate but there was no response. The acft landed short of the rwy tearing the gear off. The plt…Apr 12, 1983 · N212ES · Substantial damageNTSB MKC83LA089Accident · No injuriesLimited investigationFinal reportVarga 2150A · Moline, KSThe aircraft collided with power lines on final approach but a landing was accomplished on the runway. The pilot stated that he had made 2 prior landings on the same runway and did not see the wires. During this approach he saw the wires and tried to fly…Apr 10, 1983 · N8281J · Substantial damageNTSB MKC83FA087Accident · No injuriesField investigationFinal reportCessna 172 I · Paola, KSThe acrt crashed in a pasture after fuel exhaustion during an approach to johnson county industrial arpt. The acft had made a missed approach at his destination of Nevada MO. Enroute to a suggested alterate of butler arpt. The weather became worse and johnson…Apr 9, 1983 · N35722 · Substantial damage