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 NYC84LA026Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Hackettstown, NJAccording to the plt, he made an extended pattern to keep spacing on a slower acft that was landing. He stated that he went thru the landing checklist & everything seemed normal. On final apch, the acft got a little low, but when the throttle was advanced,…Nov 13, 1983 · N4720L · Substantial damageNTSB ANC84FA017Accident · Serious injuriesField investigationFinal reportBell 212 · Nuiqsut, AKThe search & rescue flt had been dispatched from barrow to an acft accident site adjacent to the Nuiqsut arpt. Accordingto the plt, upon arriving at Nuiqsut at 300 ft AGL the visibility was 2-3 mi. They lined up with snow machines for a visual apch to the…Nov 13, 1983 · N3910Y · Substantial damageNTSB ANC84FA016Accident · 1 fatalField investigationFinal reportMaule M-4-210C · Nuiqsut, AKThe acft crashed during the approach to land at a fogged in arpt at night. Sometime between 2045 and 2100 yst an acft was heard overflying the arpt at Nuiqsut. The villager who heard the acft stated the noise decreased as though the acft was landing. He then…Nov 13, 1983 · N51418 · Substantial damageNTSB LAX84FA058Accident · 4 fatalField investigationFinal reportBeech 56TC · San Diego, CADuring arrival, the plt was cleared for an ILS apch to rwy 28R. About 3 min later, he commenced a missed apch & requested another ILS to rwy 28. At that time, the ATC controller advised the plt that the 5 preceding acft had made ILS apchs & all had executed…Nov 12, 1983 · N911SC · DestroyedNTSB LAX84LA052Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Fremont, CAAfter receiving an aero tow to 3,000 ft MSL & being released 5 mi from the departure arpt, the plt thermaled for about 5 min. He then descended to 2,300 ft MSL & turned back toward the arpt. He encountered 'heavy sink' had insufficient altitude to reach the…Nov 11, 1983 · N1239S · Substantial damageNTSB ATL84LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Leesburg, VAAt about 1,000 ft AGL after takeoff from rwy 17 the eng cowling opened on the left side & began flapping. The CFI took control & returned to the arpt on a downwind for rwy 17. When she saw that the acft was too low to make the field, she turned off the fuel,…Nov 10, 1983 · N6470Q · DestroyedNTSB NYC84LA025Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Syracuse, NYThe acft collided with approach lights during a landing approach. The plt executed a go-around and landed without further incident. The acft was damaged in the collision. An accident report was not filed by the plt.Nov 9, 1983 · N1323T · Substantial damageNTSB LAX84FA034Accident · Minor injuriesField investigationFinal reportCessna 172N · Woodland, CAThe aircrew reported that as the acft was entering a left downwind to land on rwy 34, sparks, fire & smoke were observed emanating from the eng compartment. Reportedly, the instructor plt (CFI) assumed command of the acft, shut down the eng & attempted to…Nov 9, 1983 · N76073 · Substantial damageNTSB SEA84FA017Accident · 1 fatalField investigationFinal reportCessna A185F · 4nm W Of Boring, ORThe acft collided with 3 major objects, a tree, a house and a motor home during an attempted go-around. The pilot had attempted a landing on a soft short dirt road near his home. The length of the road was 462 ft. he landed 74 ft short ofmarkers at the…Nov 8, 1983 · N53079 · DestroyedNTSB FTW84FA045Accident · 2 fatalField investigationFinal reportCessna 310L · Bartlesville, OKThe acft was observed at 300-500 ft on a downwind leg over the brightly lighted city. After passing the city the acft entered a very dark & hilly area immediately north of the city. He then made a left turn onto base leg & remained over unlighted & hilly…Nov 8, 1983 · N3256X · DestroyedNTSB MKC84LA015Accident · Minor injuriesLimited investigationFinal reportCessna T337E · Kimball, NEThe acft collided with the ground in a pancake stall mush during a forced landing half a mile from the arpt. The rear engine had stopped in flt and the plt decided on a precautionary landing after restarting the engine. During the final approach to land the…Nov 7, 1983 · N1272M · Substantial damageNTSB DEN84FA021Accident · Serious injuriesField investigationFinal reportConvair 580 · Sioux Falls, SDThe acft collided with a bird during the landing approach at night. The captain who was flying the acft was struck in the face by the bird and flying glass. The co-plt completed the landing due to incapacitation of the capt. investigationrevealed the…Nov 7, 1983 · N7517U · Minor damageNTSB LAX84LA050Accident · Minor injuriesLimited investigationFinal reportCessna 150H · San Jose, CAThe acft was flown from San Jose, CA to an arpt near sutter creek, CA where the plt landed. Before taking off on the return flt, he visually checked the fuel, and according to him, the fuel was within 1/2 inch from the top of the tanks. No fuel was added…Nov 6, 1983 · N23268 · Substantial damageNTSB ATL84LA039Accident · 1 fatalLimited investigationFinal reportRand KR-2 · Greer, SCAccording to a witness, the plt began an apch to rwy 9, but made a go-around, then maneuvered to land on rwy 27. The witness stated that during the turn to final apch for rwy 27, the acft descended rapidly in a nose down attitude until it disappeared behind…Nov 6, 1983 · N25134 · DestroyedNTSB MKC84LA013Accident · No injuriesLimited investigationFinal reportCessna 172 · Osage Beach, MOThe plt reported that while he was making an instrument apch in heavy rain, there was a parial loss of eng power. He applied carburetor heat, but reported that the eng still did not provide full power. He continued the vor/dme apch. When he saw the rwy, he…Nov 3, 1983 · N55461 · Substantial damageNTSB NYC84LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Prospectville, PAThe pilot said that as he turned final he was too high and to the right of the rwy so he slipped the acft to the left to line up. The left fuel tank, which he was using was very low on fuel. The aprch was too high so he decided to go around. As the acft was…Nov 1, 1983 · N39955 · Substantial damageNTSB SEA84LA014Accident · No injuriesLimited investigationFinal reportCessna 180 · Juneau, AKThe plt reported that during the preflt, he thought the fuel gauges read full. He did not visually check the fuel tanks. After takeoff, the acft was aprx 2500 ft & 4 mi from the arpt, when the plt realize the plane had very little fuel on board. He turned…Oct 31, 1983 · N4448P · Substantial damageNTSB MKC84LA012Accident · No injuriesLimited investigationFinal reportCessna 150F · Garnett, KSThe acft collided with trees during final approach to land on a local night flight. The weather was VMC with a 12 mile visibility reported. The pilot reported that during final approach for a full stop landing the acft struck the tops of some trees which…Oct 29, 1983 · N8127F · Substantial damageNTSB ATL84FA031Accident · Minor injuriesField investigationFinal reportEmbraer EMB110-P1 · Blountville, TNThe acft was landed with the landing gear up. Post accident tests of the landing gear extension system showed that all operations were normal except for the main gear down-lock indications. When the crew lowered the gear for landing the nose gear and right…Oct 29, 1983 · N764 · Substantial damageNTSB CHI84FEE01Accident · No injuriesFinal reportPopelka BD-5 · Sugar Grove, ILThe acft had received an inspection on 9/8/83, before it was disassembled & transported from California to Illinois. On 10/27/83, the plt took off on a flt from sandwich to aurora, IL. While on a final apch to land at aurora, after a throttle reduction, the…Oct 27, 1983 · N99555 · Substantial damageNTSB LAX84LA035Accident · No injuriesLimited investigationFinal reportEnstrom F28F · Chino, CAThe acft experienced an in-flt fire on the downwind leg of the traffic pattern during a flt test following routine maintenance. The plt stated that while flying at 500 ft AGL in the traffic pattern smoke began entering the cockpit. Allgauges and systems…Oct 26, 1983 · N8621X · Substantial damageNTSB MKC84LA006Accident · No injuriesLimited investigationFinal reportPiper PA31-350 · Chillicothe, MODuring arrival, the plt attempted to lower the gear, but only 2 of the 3 would indicate down & safe. The plt was unable to extend the left gear, so he continued flying for aprx 1 hr to burn down fuel, then intentionally landed with the gear up. The landing…Oct 24, 1983 · N62898 · Substantial damageNTSB DEN84LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COThe plt reported that during arrival, he was receiving vectors for an ILS when he entered a descent from 9000 to 8500 ft MSL. He entered clouds during the descent & applied carburetor (carb) heat immediately before entering the clouds. He said that the acft…Oct 24, 1983 · N9317J · Substantial damageNTSB ATL84FA028Accident · 2 fatalField investigationFinal reportCessna TU206G · Brentwood, TNThe acft crashed while the plts were attempting an ILS approach to nashville. One plt was not instrument rated. The other was rated but was limited in experience. The instructions for radar vectoring to the approach were not followed and disorientation with…Oct 23, 1983 · N7338G · DestroyedNTSB NYC84LA012Accident · No injuriesLimited investigationFinal reportPiper PA-25 · West Mifflin, PAThe pilot said that prior to departure he visually checked the tanks, found fuel in the tanks and the fuel indicator working properly. On final aprch at destination, the engine stopped and the acft landed in trees aprx 2 miles short of the rwy. During post…Oct 22, 1983 · N6247Z · Substantial damageNTSB FTW84FA028Accident · 3 fatalField investigationFinal reportMitsubishi MU-2B · Patterson, LAWhile descending into the Patterson area on an IFR flt plan, the plt was cleared to hold & was advised that he would be the #2 acft for an approach to the Patterson arpt. A few winutes later the plt asked how long the delay would be. He subsequently stated he…Oct 20, 1983 · N444PA · DestroyedNTSB ATL84LA025Accident · No injuriesLimited investigationFinal reportBell 206B · Nr. Mcadams, MSThe helicopter was being used on an aerial right-of-way-burning flt. The plt reported that due to the terrain & obstacles, his attention was to the outside of the helicopter during the burning operation. After completing the burning operation for that flt, he…Oct 20, 1983 · N2183P · Substantial damageNTSB LAX84LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yuma, AZThe plt stated that prior to departing lake havasu city he visually inspected the fuel tanks & observed that both tanks were slightly less than 1/2 full. Based on this observation he thought the acft had 20-30 gals of fuel which would be sufficient for the…Oct 17, 1983 · N9560J · Substantial damageNTSB FTW84FA020Accident · 1 fatalField investigationFinal reportGrumman FM-2 · Houston, TXThe plt had purchased the wwii fighter about a week before the accident & it had been flown several hours during the last few days before the accident. The plt intended to shoot touch-&-go's on this flt. After takeoff the acft was observed to remain in the…Oct 14, 1983 · N12371 · DestroyedNTSB FTW84LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Dallas, TXWhile still several miles from addison, TX, the acft encountered the leading edge of a thunderstorm. Both occupants stated the acft encountered wind shear. Reportedly, the wind shear was so severe that it forced the acft down & it contacted the ground. A few…Oct 11, 1983 · N67176 · DestroyedNTSB MKC84LA004Accident · No injuriesLimited investigationFinal reportCessna 152 · Clear Lake, IAThe student plt was on a x-country flt that had originated at ames, IA. While enroute, he had landed at carroll, IA, but did not refuel. He stated that he was on a long, right base leg to land on rwy 12 at the mason city muni arpt when the eng began loosing…Oct 9, 1983 · N69035 · Substantial damageNTSB ANC84LA003Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe acft collided with a row of small trees during the approach to a private airstrip 26 miles south of Anchorage, AK. The pilot stated he should have made a much higher approach to the airstrip.Oct 9, 1983 · N4702B · Substantial damageNTSB MIA84LA010Accident · No injuriesLimited investigationFinal reportCessna 210L · St. Augustine, FLThe acft landed gear up after the landing gear could be extended in flight. The plt stated during the app to St. Augustine attempts to lower the gear were unsuccessful. The gear doors would open and the hydraulic pump was working butthe gear would not extend.…Oct 8, 1983 · N1778X · Substantial damageNTSB CHI84LA017Accident · No injuriesLimited investigationFinal reportCessna 177 · Wonder Lake, ILThe acft veered off the rwy and into a fence during a crosswind landing. The landing was on rwy 9 and the wind was from 021 degrees at 5 KTS gusting to 22 KTS. The pilot had applied power for a go-around but not in time to prevent the touchdown. Then the acft…Oct 8, 1983 · N30168 · Substantial damageNTSB ATL84FU001Accident · Serious injuriesFinal reportCGS Hawk · New Kent, VAThe plt & his partner had completed building the ultralight vehicle several days prior to the accident. Since then, the plt had flown it aprx 8 hrs. A witness observed the vehicle circle the arpt in what he indicated was a normal left traffic pattern for rwy…Oct 6, 1983 · UNREG · DestroyedNTSB MKC84FA002Accident · 4 fatalField investigationFinal reportCessna 182R · Springfield, MOAt 2346 CDT, Kansas city center provided the 2251 CDT Springfield wx & advsed the plt to expect vectors for an apch to rwy 1. Vectors were provided until 0006;50 CDT, when center advised that radar contact was lost, 3 mi south of the outer marker compass…Oct 5, 1983 · N5191E · DestroyedNTSB CHI84LA008Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Lancaster, OHThe acft landed in a plowed field during an off arpt forced landing after power loss in the traffic pattern for landing. The arpt manager reported that when he reached the acft the carburetor heat was off. The pilot said she thought she usedit but was not…Oct 4, 1983 · N63425 · Substantial damageNTSB FTW84LA006Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Rayne, LAThe acft stalled during final approach and landed hard on the dirt airstrip. The CFI said he yelled 'add power' when he felt the acft buffet. The student plt reacted by pulling off the power and the acrt stalled to ground contact.Oct 3, 1983 · N82147 · Substantial damageNTSB NYC83FA260Accident · 3 fatalField investigationFinal reportCessna 170B · Livermore Falls, METhe acft collided with trees during a go-around at night in a ground fog. The plt had called his wife and discussed the weather. He decided on an alternate arpt if the weather created problems. He had flown into bowman field many times at night and knew the…Oct 1, 1983 · N2429D · DestroyedNTSB LAX84LA001Accident · No injuriesLimited investigationFinal reportCessna 172 · Salinas, CAThe acft nosed over during a forced landing after the engine quit on an inital approach to land. The pilot had taken offfrom monterey CA at 1100 hours PDT to fly to Salinas CA with an estimated 4-5 gallons of fuel on board the acft. At 1150PDT the acft landed…Oct 1, 1983 · N8426X · Substantial damageNTSB CHI84LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Neenah, WIThe plt was not lined up with the rwy during final & executed a go-around. He applied full power, retracted flaps, & theacft dropped onto the rwy nose gear first. The student plt had 5 hrs of dual & was no endorsed for solo flt.Oct 1, 1983 · N22774 · Substantial damageNTSB ATL83LA006Accident · No injuriesLimited investigationFinal reportCessna 150G · Glenville, WVGround fog started developing as the flt approached its destination. During the vor-b approach to rwy 16 the plt spotted the rwy lights about a mile out & set up on left base to the rwy. The plt turned final but drifted left of base. The plt stated that due…Oct 1, 1983 · N2857S · Substantial damageNTSB MKC83LA227Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Warrensburg, MOThe glider landed short of the rwy hitting a rough hump which was an old fence line. The glider bounced & landed hard on the rwy. The pax was hospitalized for 4 days for observation & treatment.Sep 29, 1983 · N7776S · No damageNTSB ATL83LA387Accident · No injuriesLimited investigationFinal reportHughes 269A · Moultrie, GAThe acft landed hard during an autorotational forced landing after engine stoppage. This was an aerial application flt in VMC weather. Reportedly the engine quit at 100 ft AGL over trees while the plt was trying to land to reload. After the power loss a hard…Sep 27, 1983 · N8751F · Substantial damageNTSB LAX83FVD07Accident · No injuriesFinal reportPilatus PC-6/C-H2 · Lodi, CAAccording to the pilot as he made an approach to land he advanced the power lever to gain more thrust but he felt that the propeller went into beta range due to play in the propeller control linkage. At aprx 50 feet AGL and 200 feet from the end of the…Sep 26, 1983 · N361F · Substantial damageNTSB SEA83LA207Accident · No injuriesLimited investigationFinal reportHughes 500C · Pelican, AKThe acft collided with glassy water during an approach to land in marginal weather on a dark night. The acft was damagedand sank but the occupants escaped with no injuries. The acft sank in water that is over 60 ft deep. The pilot stated that he should not…Sep 25, 1983 · N9243F · DestroyedNTSB NYC83FU011Accident · 1 fatalFinal reportCGS Hawk · Huntington Mill, PAWitnesses observed the home built, ultralight vehicle as the plt was making a turn from downwind to final apch. They reported that the bank angle became steep as the plt was making a left turn. Subsequently, the vehicle entered a nose down attitude & crashed…Sep 25, 1983 · UNREG · DestroyedNTSB NYC83LA257Accident · No injuriesLimited investigationFinal reportCessna 152 · Batavia, NYThe plt stated that he was landing at the end of rwy 28 & a gust of wind yawed the acft. He applied full throttle for a go around, but the acft climbed only about 20 ft, then stalled & crashed. He reported the wind was from 280 deg at 13, gusting 20 KTS.Sep 24, 1983 · N49008 · Substantial damageNTSB NYC83FNE05Accident · Serious injuriesFinal reportI.C.A. Brasov IS28B2 "LARK" · North Canaan, CTTwo witnesses observed the glider on a downwind that was, in their estimation, lower than normal. One witness reported observing the spoilers extended. The plt stated he extended the flaps on downwind, but had not used the spoilers. Duringthe turn to base…Sep 24, 1983 · N87RW · Substantial damageNTSB FTW83LA439Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Brownsville, TXThe plt took off on a local banner towing flt at 1232 CDT. At about 1510 CDT, he returned & dropped the banner. As he was circling to land, the eng lost power. Subsequently, the acft was damage during a forced landing just short of the rwy.Sep 24, 1983 · N40310 · Substantial damage