NTSB investigations

53,704 cases where the phase of flight was Landing.

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 = 550)
  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 MKC85LA010Accident · No injuriesLimited investigationFinal reportAspen Quickie 2 · Grand Island, NEThe plt stated that he was practicing landings & had less than three hours total time in the Q2. He said he flared high & bounced three times. During the third bounce the front wing, to which the main landing gear is attached, broke & the acft ran off the…Oct 29, 1984 · N39202 · Substantial damageNTSB MIA85LA019Accident · No injuriesLimited investigationFinal reportBeech 76 · Ft.Walton Beach, FLDuring takeoff on a multiengine instructioanl flt, the instructor (CFI) simulated an eng failure by retarding power on the left eng. The student elected to land on the remaining rwy. He retarded the right eng power & dove for the rwy, but the acft touched…Oct 29, 1984 · N38085 · Substantial damageNTSB CHI85LA033Accident · No injuriesLimited investigationFinal reportCessna 172 · Chicago, ILThe pvt plt stated that he was aware of a nose wheel shimmy on the acft before flt but was advised by the operator that it was safe to fly. He stated that upon landing, when the nose wheel touched down, it began to shimmy violently and the nose tire blew.…Oct 28, 1984 · N66964 · Substantial damageNTSB ANC85LA014Accident · No injuriesLimited investigationFinal reportde Havilland Otter DHC-3 · Dan Creek, AKAccording to the plt the acft hit a downdraft, landed hard and struck the wing on the rwy surface. The wind was reported from 360 deg 15 KTS gusting to 20 KTS.Oct 28, 1984 · N2899J · Substantial damageNTSB NYC85LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Farmington, PAAccording to the plt, during the landing flare the wind shifted causing the acft to drift off the left side of the rwy striking rwy lights and a pole. Winds were from 230 deg at 10 KTS gusting to 15.Oct 27, 1984 · N82587 · Substantial damageNTSB LAX85LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Fillmore, CAAccording to the pilot, unforecast wx was encountered in cruise at 6,500 ft. the student became lost and elected to make a precautionary landing in an unimproved field. The nose gear collapsed on touchdown and the acft nosed over coming to rest inverted. No…Oct 27, 1984 · N48809 · Substantial damageNTSB BFO85FA003Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Washington, DCAfter a high & fast apch, acft touched down beyond midfield on rwy 36 at dca. Plt delayed initiating a go around until he was sure the acft would not stop in the rwy remaining. On initial climb the acft struck two apch lights at the departure end of the rwy,…Oct 27, 1984 · N6235Y · Substantial damageNTSB ANC85LA013Accident · No injuriesLimited investigationFinal reportMaule M-6 · Homer, AKShortly after touchdown the acft veered left. Right rudder was applied causing the acft to over correct back to the right. In an effort to regain directional control left rudder was applied. The acft ground looped to the right collapsing the left main landing…Oct 27, 1984 · N5645D · Substantial damageNTSB FTW85LA024Accident · 1 fatalLimited investigationFinal reportBeech 58P · Beeville, TXWhen the plt called the fss at 1426 EDT & filed an IFR flt plan, the fss person began providing a wx briefing. The plt interrupted the wx briefing & said he would check back later. He called back at 2016 EDT, but talked to another briefer & only asked for…Oct 26, 1984 · N187DA · DestroyedNTSB ATL85LA022Accident · No injuriesLimited investigationFinal reportBeech 95 · Birmingham, ALPlt reported apch was high and fast but when the nose gear touched down during the normal landing, the nose gear tire blew. A witness stated the acft porpoised several times and then impacted on the nose gear resulting in the blown out tire.Oct 26, 1984 · N2773Y · Substantial damageNTSB ANC85FA012Accident · No injuriesField investigationFinal reportMaule M-6-235 · Kenai, AKThe acft bounced twice at a point about 1000-1500 ft down the rwy and then started to ground loop according to a witness. During the ground loop the acft pitched up and climbed steeply to about 40 ft AGL and stalled. The right wing dropped and the acft…Oct 26, 1984 · N56512 · Substantial damageNTSB LAX85LA031Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Chandler, AZThe student plt started to retract the flaps during a touch-&-go landing with a CFI on board the acft. The acft veered and the CFI took control. During this time the student applied the brakes. The right main landing gear went into the dirt and the acft nosed…Oct 24, 1984 · N72480 · Substantial damageNTSB ATL85LA019Accident · No injuriesLimited investigationFinal reportCessna 172M · Griffin, GAThe acft ran off the side of the rwy during landing. The plt planned to do touch and go landings. On the 1st landing theacft veered to the right and rolled off the rwy. The plt added power but the acft went into a ditch. The student plts logbook was not…Oct 24, 1984 · N92388 · Substantial damageNTSB NYC85LA012Accident · No injuriesLimited investigationFinal reportCessna 152II · Wappinger Falls, NYThe solo student plt stated that during the flare the acft drifted left toward the rwy lights. A go-around was initiated with power and the acft flew over the lights but collided with the unimproved grassy terrain, coming to rest aprx 30 ft left of the rwy.Oct 22, 1984 · N4904B · Substantial damageNTSB ANC85LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKAccording to the plt, when he arrived at the gravel bar the passengers to be picked up were not there & could not be located from the air. After making low passes over the gravel bar he determined that the snow did not look deep and touched down to check the…Oct 22, 1984 · N4361A · Substantial damageNTSB FTW85LA021Accident · No injuriesLimited investigationFinal reportCessna 152 · Bogalusa, LAThe solo student plt landed 8 to 10 ft short of the rwy and rolled into the asphalt lip of the prepared surface. Touchdown occurred in an area of construction lengthening the rwy.Oct 21, 1984 · N5097H · Substantial damageNTSB NYC85LA011Accident · No injuriesLimited investigationFinal reportCessna 206 · Menemsha, MADuring climb out when the plt normally retracted the landing gear he was copying an IFR clearance. The gear were not retracted and upon touchdown in the pond the float acft nosed over in the 8 ft deep water.Oct 20, 1984 · N8063E · Substantial damageNTSB LAX85LA026Accident · No injuriesLimited investigationFinal reportHarvard MK IV/AT-6 · Apple Valley, CAPlt had executed successful crosswind landing and was decelerating on roll-out when a gust of wind caused the acft to swerve into the wind. Directional control could not be regained with rudder so plt elected to attempt go-around. Acft became airborne in…Oct 20, 1984 · N44110 · Substantial damageNTSB CHI85LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Lake Village, INThe plt reported that he was on final apch to land on a wet, sod rwy when he noticed a flock of geese over the apch end. He added power to fly over the geese then proceeded to touchdown further down the rwy than what he had planned. Due to his speed & the wet…Oct 20, 1984 · N41483 · Substantial damageNTSB CHI85LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Dodgeville, WIThe plt attempted a landing on rwy 30 which is 85 ft higher in elev at the approach end of the rwy than the departure end. This was the plt's first flt to this arpt. The acft touched down further down the rwy than intended so the plt applied pwr to abort the…Oct 20, 1984 · N734YR · DestroyedNTSB ATL85LA015Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charlotte, NCDuring attempted go-around from a bounced landing, the plt allowed the acft to drift off center line and into trees paralling the runway. Directional control was compromised by low flying speed.Oct 20, 1984 · N2388V · Substantial damageNTSB ANC85LA009Accident · 1 fatalLimited investigationFinal reportCessna U-206C · Iliamna, AKThe acft dragged a wing tip & nosed over while landing on a small lake near Iliamna, Alaska. The passenger seated next to the PIC stated that the plt had cancelled his flt plan prior to landing, circled the lake & made a long final apch to a touchdown on the…Oct 20, 1984 · N9577G · Substantial damageNTSB ANC85LA007Accident · No injuriesLimited investigationFinal reportCessna A185E · Shulin Lake, AKThe acft nosed over during a water landing. This acft had wheels in the floats and one of the wheels was not retracted for the water landing. These gear are hand retracted by the plt. The plt said he checked visually to insure the left gear was up but did not…Oct 20, 1984 · N70018 · Substantial damageNTSB CHI85LA019Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Compton, ILThe plt stated that he landed aprx 1/4 way down the wet sod rwy which is 2590 ft long. The braking action was nil. The acft ran off the end of the rwy & collided with a 3 ft embankment.Oct 18, 1984 · N500JT · Substantial damageNTSB LAX85LA021Accident · No injuriesLimited investigationFinal reportCessna 172RG · El Monte, CAThe plt landed the acft fast & lost control. Subsequently, the acft went off the right side of the rwy & struck a perimeter fence.Oct 16, 1984 · N6456V · Substantial damageNTSB DEN85LA012Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Creede, COAccording to the plt, just prior to landing, at about 5 ft AGL, the gear warning horn sounded and the right main gear down and locked light flickered. The landing was continued and the right gear collapsed during the rollout. A mechanic who examined the acft…Oct 16, 1984 · N8011J · Substantial damageNTSB ANC85LA006Accident · No injuriesLimited investigationFinal reportBeech 3NM · Selawik, AKMaintaining visual separation with other acft, flying a straight-in apch instead of a conventional pattern, and concern over the landing on a short strip interfered with the plt's habit pattern. The gear was not extended and the gear-up landing resulted.Oct 16, 1984 · N9540 · Substantial damageNTSB MIA85LA010Accident · No injuriesLimited investigationFinal reportCessna 152 · Ormond Beach, FLStudent pilot was on first solo flight. Upon touchdown on main gear, the aircraft bounced and came down the second time on its nose gear. Main engine mount was bent.Oct 15, 1984 · N757TV · Substantial damageNTSB MIA85LA008Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Coolidge, GAThe acft collided with a bush during landing. The plt flew under a wire that he saw just in time to avoid hitting and over the 5 foot embankment on the opposite side of an intervening roadway. After the collision, the acft flipped over and slid through a…Oct 15, 1984 · N60960 · Substantial damageNTSB LAX85LA018Accident · No injuriesLimited investigationFinal reportCessna R172 · Corning, CAThe plt reported that during a landing on rwy 34, the acft encountered a x-wind gust & was pushed off the rwy. It subsequently collided with a ditch & was damaged. The plt reported that the wind was from 300 deg at 16 gusting 22 KTS.Oct 15, 1984 · N758FN · Substantial damageNTSB FTW85LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Uvalde, TXWitnesses stated that the student plt made an initial solo takeoff & landing. During the second landing attempt he made a go-around. On the final landing the acft touched on the wheels, bounced/floated, started to porpoise and collapsed the nose gear.Oct 15, 1984 · N67172 · Substantial damageNTSB FTW85LA013Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Booker, TXPlt arrived at destination at dusk. Lighted wind tetrahedron was out of service. Plt executed low pass in unsuccesful attempt to see windsock. Plt was aware of strong surface winds (about 35 KTS), presumed to be from sw, from recent frontal passage and…Oct 15, 1984 · N9737K · Substantial damageNTSB MIA85LA007Accident · No injuriesLimited investigationFinal reportCessna T210N · Live Oak, FLThe acft was landed long on the rwy according to the plts statement. He also said that he could not go-around because OF50 ft trees at the end of the rwy, so he elected to aim (place) the acft 'between a tree & house for safety reasons.' The accident happened…Oct 14, 1984 · N7393C · Substantial damageNTSB DCA85IA001Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-30 · Erie, PAThe orig destn was youngstown, OH, but its wx was blo mins, so the flt to transport a football team was planned to Erie which was slightly above mins. The coach & business manager were not happy about this, but plans were made to bus the team on to…Oct 14, 1984 · N965VJ · Minor damageNTSB ANC85LA004Accident · No injuriesLimited investigationFinal reportCessna U206 · Hinchinbrook, AKInvestigation revealed that the nose gear torque link bolt sheared during the landing roll on an abandoned sand airstrip causing the gear collapse and noseover. Metallurgical testing disclosed evidence of long term progression of severe corrosion between the…Oct 14, 1984 · N4863C · Substantial damageNTSB SEA85LA008Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Gabbs, NVOn landing touchdown, the acft bounced and ballooned back into the air. Plt applied full throttle for go-around, but engine responded with partial power, insufficient for successful go-around. Plt then cut throttle in attempt to remain within airport confines…Oct 13, 1984 · N6488N · Substantial damageNTSB LAX85LA016Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Sonoma, CAPlt made inadvertant gear up landing. Plt stated he forgot to lower the gear when his attention was diverted to the cabin door which came open in-flight.Oct 13, 1984 · N9493P · Substantial damageNTSB LAX85LA014Accident · No injuriesLimited investigationFinal reportBeech B35 · Marble Canyon, AZPlt stated wind was from 220 deg at 5 KTS but after touchdown a gust of wind caught the right wing forcing the acft off rwy. Plt added full pwr to abort landing and acft became airborne. Left landting gear contacted a sand dune. As acft veered left it…Oct 13, 1984 · N8885A · Substantial damageNTSB LAX85FA015Accident · 1 fatalField investigationFinal reportBellanca 73CA · Porterville, CAThe acft crashed after an inflt loss of control during both the landing flare & subsequent go around attempt. The plt stated that he was approaching touchdown in a three point attitude when 'a gust of wind suddenly pushed (the acft) to the right of the…Oct 13, 1984 · N53860 · DestroyedNTSB ATL85LA006Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Abbeville, SCRight main tire blew during a hard landing. Plt applied left brake and rudder but acft continued off right side of rwy. Acft skidded across a pile of debris which initiated a flash fire in the underbrush. The right main gear assembly was broken from the acft…Oct 11, 1984 · N66CM · Substantial damageNTSB LAX85LA010Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Concord, CAThe plt stated that he did a go-around while on final approach to runway 19L because of excessive speed. The plt re-entered the traffic pattern and was cleared by the tower to lnd on rwy 19R. The plt stated that he was advised by the tower to initiate the…Oct 10, 1984 · N52936 · Substantial damageNTSB LAX85LA009Accident · No injuriesLimited investigationFinal reportCessna 172H · Long Beach, CAThe plt said that after he returned to the arpt for a night landing, he applied back pressure during the flare, then heard the stall warning horn. Subsequently, the acft was damaged when it landed hard & bounced. However, the plt was able to taxi to the…Oct 9, 1984 · N8048L · Substantial damageNTSB FTW85LA020Accident · No injuriesLimited investigationFinal reportCessna 310C · Los Fresnos, TXThe plt stated that he landed on rwy 32 after noting vertical rising smoke about 1/2 mi north of the airstrip. He stated that during landing he encountered a 20 to 25 kt tailwind from a small local squall line & was unable to stop the acft. The acft continued…Oct 9, 1984 · N1794H · Substantial damageNTSB ATL85LA003Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Gold Hill, NCThe plt was uable to raise UNICOM for wind advisories and was unable to find the wind sock to aid in rwy selection. He did see some smoke on the ground which indicated calm winds. During his flare the acft floated about halfway down the rwy, touched down and…Oct 9, 1984 · N737MW · Substantial damageNTSB LAX85LA022Accident · No injuriesLimited investigationFinal reportCessna 180 · Santa Monica, CAPlt reproted, descent made to mda of 740 ft MSL and visual contact made with rwy 1/2 mile east of arpt. Slipped acft to within 200 ft of rwy and made a wheel landing midfield. Both wheels locked up and acft nosed over. Plt stated, 'I may have had my feet on…Oct 8, 1984 · N4932A · Substantial damageNTSB CHI85LA006Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Lincoln, ILAccording to the pilot touchdown occurred on the first third of the rwy and braking seemed ineffective. He further stated that as brake pressure was increased the seat back failed. A representative of the FAA examined the seat and found no evidence of…Oct 8, 1984 · N44730 · Substantial damageNTSB SEA85LA005Accident · No injuriesLimited investigationFinal reportCessna 172N · Ashford, WAThe acft ground looped during a landing in a gusty x-wind. After directional control was lost the acft veered off the rwy striking trees. No accident report form was filed by the plt.Oct 7, 1984 · N739UW · Substantial damageNTSB NYC85LA006Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Coram, NYPlt stated rough condition of runway surface made directional control difficult. The left wheel overran the runway edge which was bounded by a dirt ridge. Plt was unable to bring the left wheel back onto the prepared surface as ridge dimensions increase…Oct 7, 1984 · N76BP · Substantial damageNTSB FTW85LA008Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Waurika, OKAccording to witnesses, the acft nose was too low at water contact on lndg touchdown and the nose and right pontoon dug into the water. The acft swerved abruptly to the right, flipped inverted and sank. No logs or other floating debris were located during a…Oct 7, 1984 · N6685L · DestroyedNTSB FTW85LA007Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Amarillo, TXDuring the lndg roll, all 3 lndg gear collapsed. The plt stated that on short final he inadvertantly retracted the gear instead of the flaps. He immediately cycled it back down butthe gear collapsed shortly after touchdown.Oct 7, 1984 · N8692Y · Substantial damage