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 LAX83LA189Accident · Serious injuriesLimited investigationFinal reportRockwell A-9B · Marana, AZThe plt was on a flt from quanah, TX to chandler, AZ to deliver the acft for a sale. He had been on the ferry flt for 6 hrs when he landed at Marana, AZ. After refueling, raising the eng cowl, inspecting the eng & wiping off an accumulation of oil, he took…Apr 9, 1983 · N7909V · DestroyedNTSB LAX83FU001Accident · 1 fatalFinal reportMitchell A-10 · Tulare, CAThe ultralight was on a demonstration flt. Reportedly, the plt made a pass down the rwy, then had turned downwind at 400 to 500 ft, when witnesses heard a loud bang or crack & saw the wings of the vehicle fold. The ultralight then entered a spiral & crashed…Apr 7, 1983 · UNREG · DestroyedNTSB CHI83FA160Accident · No injuriesField investigationFinal reportGates Learjet 35A · Indianapolis, INThe aircraft struck trees one mile from the runway during an ILS approach to Indianapolis intl airport after a flight from chicago. The pilot successfully executed a missed approach and diverted to hulman regional airport, terre haute, IN, for an emergency…Apr 7, 1983 · N3794W · Substantial damageNTSB SEA83LA076Accident · No injuriesLimited investigationFinal reportCessna 150F · Anacortes, WAThe uncertificated plt had made several attempts to land when he struck a tree in the approach path with the right wing. The acft then left the area for a short period of time, returned & made what was described as a bumpy landing. The acft use was…Apr 6, 1983 · N6720F · Substantial damageNTSB SEA83LA074Accident · No injuriesLimited investigationFinal reportCessna 172G · Near Homedale, IDThe flt originated before sunset, but the student plt practiced in the local area until the onset of darkness. While attempting to land on his private strip, he made 2 go-arounds. On the second go-around, the acft collided with an electrical wire, then flew…Apr 5, 1983 · N3658L · Substantial damageNTSB ATL83FA150Accident · Serious injuriesField investigationFinal reportCessna 172 · Spartanburg, SCAccording to the plt's son, who was a passenger, the plt had made a final approach lineup on the wrong set of lights. Realizing the mistake, the plt initiated a go-around at aprx 200 ft AGL. However, the eng lost power. During an emergency landing at night,…Apr 5, 1983 · N8253U · Substantial damageNTSB NYC83FA085Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201 · Captree Island, NYThe plt contacted the islap west arrival controller with the intention of landing at islap, NY. However, islap was below mins, so the plt diverted toward farmingdale, NY & asked about the wx there. The islap controller coordinated the diversion with the…Apr 4, 1983 · N8219L · DestroyedNTSB LAX83FA179Accident · No injuriesField investigationFinal reportBell 206L-1 · Red Rock, AZReportedly, the plt elected to land in a mountainous area in calm wind conditions. At an estimated distance of 350 ft & an alt of aprx 75 ft above the touchdown zone, the nose of the helicopter began a gradual left turn as the plt applied collective pitch. At…Apr 4, 1983 · N302PS · Substantial damageNTSB FTW83FA178Accident · 1 fatalField investigationFinal reportCessna T310R · Dalhart, TXAs the plt was approaching Dalhart, TX, he was in radio & radar contact with albuquerque ARTCC (center). Aprx 15 mi from delhart, the plt asked center about the wx over Dalhart. He was advised that the fss there was shut down & no current wx for Dalhart was…Apr 4, 1983 · N6831T · DestroyedNTSB LAX83FA173Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Compton, CAThe acft collided with a chain link fence and a brick wall during an attempted go-around after overshooting the runway during landing. The pilot was high and had about 25 percent of the runway left when he decided to go around. The landingwas attempted on…Apr 2, 1983 · N1399H · DestroyedNTSB FTW83FA175Accident · 4 fatalField investigationFinal reportCessna 500 · Eagle Pass, TXThe acft was on a flt to a private ranch landing strip at night. The strip had an unlighted windsock at midfield & portable rwy edge lights were in use. During arrival, the aircrew estimated the visibility was 3 to 4 mi & reported they would be able to land.…Apr 2, 1983 · N700CW · DestroyedNTSB SEA83LA070Accident · Minor injuriesLimited investigationFinal reportPartenavia P68C/TC · Dixie, IDThe acft stalled, dragged the left wing and collided with a fence during landing. A 2nd pilot with limited multi-engine experience was making the landing. When power was reduced about 10 feet above the threshold, the acft stalled. The left main gear and the…Apr 1, 1983 · N2958W · Substantial damageNTSB LAX83LA169Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Hollister, CAWhile on final apch to land at night, the right main gear of the acft struck a semi-trailer truck as the acft crossed over a highway. The centerline of the highway was located aprx 102 ft from the apch end of the rwy. The plt continued the landing & the right…Apr 1, 1983 · N9324P · Substantial damageNTSB MIA83LA105Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Ocala, FLThe acft collided with the terrain while on a localizer 36 approach at Ocala, FL the weather was IMC and the flight was on an IFR clearance. The acft was damaged but the occupants were not injured. The pilot stated that while on the final segment of the…Mar 28, 1983 · N123WK · Substantial damageNTSB ATL83FA145Accident · 5 fatalField investigationFinal reportPiper PA-34-200T · Roanoke, VAThe acft was on a x-country from buffalo, NY to new port richey, FL. The plt made an en route stop at painsville, OH, then proceeded toward greensboro, NC. While en route, he elected to land at Roanoke, VA because his fuel would be low if he continued to…Mar 27, 1983 · N5885V · DestroyedNTSB MIA83FA101Accident · Serious injuriesField investigationFinal reportCessna C-337C · Silver Springs, FLThe acft collided with trees during an attempted go-around during a night operation. The plt had just recently acquired the acft and he was accompanied by his wife at the time of the accident. The plt lacked certification in the acft. Witesses heard the…Mar 26, 1983 · N2524S · DestroyedNTSB CHI83LA151Accident · No injuriesLimited investigationFinal reportBeech A-36 · Columbus, OHThe aircraft landed in a field about 1 mile from the approach end of the runway after engine stoppage during final approach. No malfunction of the engine was found during examination. The pilot stated he had flown about 3 hrs and 20 minutes. The hobbs meter…Mar 26, 1983 · N7464N · Substantial damageNTSB NYC83LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Syracuse, NYThe aircraft made an emergency landing on a golf course after the engine quit on final approach to Syracuse, NY. The acft had departed van wert, oh at 1350 and stopped for about 20 minutes at columbus, oh to pick up a passenger at 1445. The pilot contacted…Mar 25, 1983 · N2918E · Substantial damageNTSB ATL83LA153Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Shelbyville, TNThe acft collided with a power line during a forced landing after power loss due to fuel exhaustion. The acft was on thefinal approach. The pilot said he would be landing short of the rwy. When asked the nature of his emergency he said 'I think I am running…Mar 25, 1983 · N28190 · DestroyedNTSB ATL83LA143Accident · Minor injuriesLimited investigationFinal reportBeech C24R · Waycross, GADuring flt, the plt encountered strong headwinds & decided to divert to Waycross, GA. While using fuel from the right tank, the engine quit due to fuel starvation. The plt stated that this surprised him since the right fuel gauge needle was only slightly…Mar 25, 1983 · N6009A · DestroyedNTSB ATL83LA141Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Jacksonville, NCThe acft stalled, spun and collided with trees during an attempted go-around. The pilot had flown locally for about 1 hour doing stalls and touch and go landings. The accident occurred following a landing that was planned as a full stop landing. The landing…Mar 23, 1983 · N7538G · DestroyedNTSB SEA83LA067Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Bremerton, WAThe aircraft collided with a tree stump during a forced landing after the engine quit during entry into the traffic pattern. When the engine stopped the pilot felt he could not make the airport and chose a field to land in to avoid trees on the final approach…Mar 21, 1983 · N3355J · DestroyedNTSB MIA83LA095Accident · No injuriesLimited investigationFinal reportMolino PIK 20 · Highsprings, FLThe acft crashed short of the runway during a pleasure flight. The pilot was not injured. The pilot stated that he descended below the tree line and encountered a wind shear. He traded altitude for airspeed and the acft encountered thetop wire of a fence. The…Mar 19, 1983 · N1975S · Substantial damageNTSB CHI83LA143Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Irwin, OHThe plt circled the arpt to set up his landing pattern for rwy 14 with a left crosswind. On final at 60 KTS & full flapsthe stall warning horn came on with the acft drifting. The plt added power & removed carb heat. He also started to 'work' the flaps up 'a…Mar 17, 1983 · N9841J · Substantial damageNTSB ATL83FA176Accident · 2 fatalField investigationFinal reportBellanca 17-31A · Waverly, GAThe acft crashed into trees during an instrument approach at night in stormy weather. Both the CFI, seated in the front left seat, & the new owner of the acft, were fatally injured. An IFR flt plan was filed & the CFI had obtained 2 wx briefings prior to…Mar 17, 1983 · N8855V · DestroyedNTSB FTW83LA153Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Athens, LAJust prior to the flt, a mechanic performed some minor upkeep functions on the acft & knew of no mechanical problems. He was unaware that the owner was not a rated plt. The mechanic accompanied the owner on a local flt. Subsequently, the acft crashed on the…Mar 14, 1983 · N2389Q · Substantial damageNTSB ATL83LA139Accident · Minor injuriesLimited investigationFinal reportBrown Sonera II L · Bowling Green, KYThe acft nosed over during a forced landing after the engine lost power on the base leg of the landing pattern. The weather was VMC and no flight plan was filed. The pilot stated that he had worked on the carburetor prior to this flightand had also moved the…Mar 14, 1983 · N86BB · Substantial damageNTSB NYC83LA076Accident · No injuriesLimited investigationFinal reportBurkhart Grob G10Z Astir CS · Buena Vista, PAThinking that he might be lost in a wave above the clouds, the plt descended through an opening & decided to make an off-field landing. Severe wind gusts altered his glide path & he headed toward an apple orchard. The left wing contacted a branch about 10 ft…Mar 12, 1983 · N142SS · Substantial damageNTSB CHI83LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Garden City, MNThe pilot elected to land to the west on a blacktop road. After touchdown, he initiated a go-around. During the go-around, the aircraft collided with the top wire of a power line on the right side of the road and crashed. The pilot estimated that the wind was…Mar 12, 1983 · N1907E · Substantial damageNTSB DCA83AA019Accident · Serious injuriesFinal reportPiper PA-31-350-T1020 · Fort Belvoir, VAOn a flt from newark, NJ to richmond, VA, the departure time was delayed, and subsequently, the acft did not arrive at richmond until after the refueling facilities were closed. The plt decided there was sufficient fuel aboard to complete the next flt to the…Mar 11, 1983 · N120AE · Substantial damageNTSB ATL83LA134Accident · No injuriesLimited investigationFinal reportCessna A188B · Wadley, GAThe pilot had been using a paved road for a landing strip until someone complained. He then changed to a north- south dirt road with trees on the west side and utility wires and poles on the right side. While landing with a left crosswind at about 16 gusting…Mar 11, 1983 · N8233G · DestroyedNTSB CHI83LA131Accident · No injuriesLimited investigationFinal reportMooney M20C · Solon Springs, WIThe pilot reported that when he departed Solon Springs, WI at 2100 CST, the weather was windy, but the sky was clear. He landed at minneapolis, MN to pick up a passenger, then departed on a return flight to Solon. While returning, he encountered snow. The…Mar 10, 1983 · N5587Q · Substantial damageNTSB FTW83LA141Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Roswell, NMDuring arrival, the engine began to lose power as the acft was on base leg for landing. The plt was unable to restore full power and made a forced landing in an umimproved area aprx 2 mi from the airport. During the landing roll-out, the right wing tip hit a…Mar 7, 1983 · N5042J · Substantial damageNTSB ATL83FA129Accident · 2 fatalField investigationFinal reportBeech K35 · Birmingham, ALThe acft collided with trees and terrain during a practice localizer approach at night to rwy 23 at Birmingham municipalarpt. The weather was VMC and the pilot was not instrument rated. On approaching Birmingham from tri-cities, NC the pilot asked for a…Mar 7, 1983 · N9543R · DestroyedNTSB SEA83FA060Accident · 1 fatalField investigationFinal reportGlasair SH-2 · 5 Nm E. Of Kent, WAThe homebuilt acft collided with powerlines on final approach and crashed. The pilot was on a flight from one airport toanother to demonstrate his acrt to other builders of the acft. He was observed to enter the pattern and fly a low base leg and final…Mar 6, 1983 · N46JS · DestroyedNTSB FTW83LA140Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Canton, TXThe plt reported that during arrival, he started to land with a right crosswind at 15 gusting 22 KTS. He stated that the acft was very low over the runway when a gust of wind blew it over a plowed area adjacent to the runway. He applied full power, raised the…Mar 6, 1983 · N5536E · Substantial damageNTSB MIA83LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lehigh Acres, FLDuring a simulated, engine-out, emergency, the student elected to make an approach to a paved road. While turning to a final approach at about 300 ft AGL, the instructor pilot (CFI) observed power lines in their path. The CFI advised the student to go around.…Mar 2, 1983 · N8445G · Substantial damageNTSB FTW83IA131Incident · No injuriesIncident investigationFinal reportAerospatiale AS-350D · E. CameronDuring an approach to an oil drilling rig platform, the engine decelerated as the pilot started to all power. With the acft below the landing area, he maneuvered to miss the platform & initiated an autorotative landing. He made a mayday call & tried to…Mar 1, 1983 · N3593D · Minor damageNTSB NYC83LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Quakertown, PAThe acft touched down about 1 ft short of the rwy. The left gear & wing was damaged.Feb 28, 1983 · N38389 · Substantial damageNTSB DEN83LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Erie, COThe plt stated he encountered an unexpected downdraft or shear effect & landed approximately 102 ft short of the rwy. The acft then collided with a bar ditch located about 63 ft from the threshold folding back the main gear. The acft then slid down the…Feb 28, 1983 · N8295L · Substantial damageNTSB NYC83FNE02Accident · Serious injuriesFinal reportPiper PA-28-140 · Oxford, MADuring a go-around, the eng began losing power, & subsequently, the plt elected to make a forced landing in an open field. However, before landing, the acft collided with an electric wire, then crashed. An investigation revealed some maintenance…Feb 27, 1983 · N33458 · Substantial damageNTSB CHI83FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Beloit, WIReportedly, the plt had not flown for 2 or 3 months before his flts on 2/27/83. On that day, he took off & made 5 touch-and-go landings, then stopped for a cup of coffee. The plt then departed again on a 2nd flt. Aprx 1/2 hr later, smoke was observed from the…Feb 27, 1983 · N5769F · DestroyedNTSB NYC83FA072Accident · Minor injuriesField investigationFinal reportCessna 150J · Oxford, CTThe acft was last refueled on 11/28/82 & flown .2 hr to on arpt for an annual inspection. The annual was completed on 2/19/83. During the annual, an estimated .5 gal of fuel was drained from the acft & the eng was run about .2 hr. When the plt preflted the…Feb 26, 1983 · N60619 · Substantial damageNTSB NYC83FA071Accident · 2 fatalField investigationFinal reportCessna 172M · Mountville, PAThe acft collided with a power line and a tree before crashing to the ground during a go-around attemp. The acft had been crabbing in a cross-wind for a landing and drifting off to the right of the rwy. The pilot applied power for a go around but never…Feb 26, 1983 · N12067 · Substantial damageNTSB NYC83LA075Accident · No injuriesLimited investigationFinal reportBeech P35 · Beverly, MAThe approach was made at 90 mph with full flaps in winds gusting to 25K. As the plt flared for landing the right gear contacted a pot hole at the approach lip of the rwy blowing the tire causing the rear strut to push a hole into the wing skin.Feb 24, 1983 · N972Q · Substantial damageNTSB FTW83FA128Accident · 3 fatalField investigationFinal reportCessna P-206C · Brookland, ARThe acft crashed in IMC weather after the pilot failed to complete a VOR approach to jonesboro. According to the owner of the accident acft, the plt was instrument rated and had filed an IFR flt plan but was not very proficient in instrument flying. During…Feb 24, 1983 · N8637Z · DestroyedNTSB ATL83LA120Accident · No injuriesLimited investigationFinal reportCessna 421 · Dayton, TNThe Cessna 421 collided with trees during the landing approach while on a corporate flight. The weather was IMC at the accident site and the acft was on an IFR flight plan. The acft was substantially damaged but the pilot was not injured. The acft contacted…Feb 24, 1983 · N123SM · Substantial damageNTSB FTW83FA126Accident · 2 fatalField investigationFinal reportCessna 172N · Pineville, LAThe owner, an instructor plt (CFI), was in the right front seat & a private plt with no instrument rating was in the left front seat. During arrival, the aircrew had inquired about the wx at the esler regional arpt, however, the fss & the UNICOM had closed…Feb 23, 1983 · N4862G · DestroyedNTSB FTW83LA125Accident · No injuriesLimited investigationFinal reportPiper PA-31P · Nacogdoches, TXDuring arrival, a landing was made at night IMC conditions with low ceilings, heavy rain & gusty winds. The plt reported that during the landing, there was a x-wind component, light turbulence & a wind shift. Reportedly the acft was landed aprx half way down…Feb 21, 1983 · N7334L · Substantial damageNTSB CHI83LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Three Oaks, MIThe instructor (CFI) & his student had started flying at aprx 1900 EST. The purpose was to give the student aprx 3 hrs of night instruction. A refueling stop was made at south bend, IN. According to the student, the CFI stayed in the acft during the…Feb 21, 1983 · N704RX · Substantial damage