OpenAirDocs.org

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 LAX87LA089Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Paradise, CAWhile practicing touch and goes, the pilot stated that on his last approach a considerable amount of crabbing to the right was required on final approach to runway 35. Upon touchdown the right wing lifted, the pilot turned the control wheel to the right and…Jan 18, 1987 · N40349 · Substantial damageNTSB NYC87LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Randolph, NHStudent pilot on a cross country instructional flight became disoriented, decided to return to departure airport. However seeing that he was running low on fuel looked for an airport to land to refuel and find out his location. He decided to make a…Jan 17, 1987 · N2430G · DestroyedNTSB BFO87LA015Accident · No injuriesLimited investigationFinal reportRockwell 500S · Lynchburg, VAAfter leaving clouds about 4500 feet MSL, the PIC made a visual approach to runway 03 at Lynchburg municipal. On short final the copilot stated that he noticed what seemed to be a gradual increase in pitch attitude while the aircraft was still too high off…Jan 17, 1987 · N717AM · Substantial damageNTSB SEA87LA047Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Deer Park, WAThe plt reported the acft veered to the left during roll out on the snow covered runway. The acft contacted a frozen snow bank and flipped inverted.Jan 15, 1987 · N10780 · Substantial damageNTSB ATL87LA060Accident · No injuriesLimited investigationFinal reportGrumman AA-5A · Stockbridge, GADuring an attempted landing, the pilot lost directional control and veered off the right side of runway 29 and collided with a tree. The pilot reported that a gust of wind from the left resulted in the left wing rising about 7 feet. The pilot applied power…Jan 14, 1987 · N26900 · Substantial damageNTSB LAX87LA081Accident · No injuriesLimited investigationFinal reportCessna T182 · Big Bear City, CAThe plt rprtd that when the nose wheel touched down during the landing, a severe vibration began & the acft veered to the left. She said she pulled the yoke aft, but this had no response. Also, she said she applied brakes, but could not stop the acft or make…Jan 11, 1987 · N6216N · Substantial damageNTSB LAX87LA086Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Yuma, AZThe left main landing gear retracted after a normal landing and the aircraft swerved off the left side of the runway into the dirt. Crewmembers stated that they observed three green landing gear position lights prior to touch down and that, after the aircraft…Jan 10, 1987 · N165SW · Substantial damageNTSB MKC87LA038Accident · No injuriesLimited investigationFinal reportCessna 152 · Forrest City, ARThe student pilot was landing after one leg of a solo cross-country flight. The airplane ran off the right side of the runway and into a small drainage ditch.Jan 8, 1987 · N68792 · Substantial damageNTSB MIA87FA067Accident · 1 fatalField investigationFinal reportBeech V-35 · Palm City, FLThe acft was attempting to land on the southbound lane of a closed portion of interstate 95 & struck a large tree with the right wing, hit the ground, flipped over, came to rest inverted & was consumed by post crash fire. The police officers at the accident…Jan 6, 1987 · N78BL · DestroyedNTSB SEA87LA043Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7FC · Athol, IDThe pilot lost control of the aircraft during landing with the aircraft veering to the left of the runway centerline. The plt then elected to go-around and on the go-around the aircrafts main gear caught on a snow berm causing a loss of control in flight. The…Jan 4, 1987 · N7547E · Substantial damageNTSB NYC87IA087Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Newark, NJDuring descent prior to the approach to Newark, NJ the B737 crew attempted to start the APU. The APU failed to start. During lndg roll another attempt to start the APU resulted in a fire warning light. The fire bottle was discharged but the fire warning…Jan 4, 1987 · N409PE · No damageNTSB MIA87FA066Accident · No injuriesField investigationFinal reportCessna 310-D · Lantana, FLThe pilot flying in marginal weather requested radar assistance in landing at his destination. He was given a radar vector to a position on downwind and saw an uncontrolled airport under him. He landed on a closed runway that was marked closed due to…Jan 4, 1987 · N656R · Substantial damageNTSB ATL87LA054Accident · No injuriesLimited investigationFinal reportCessna 172M · Hartsville, SCThe student plt made two go-arounds before starting his third landing attempt with a variable wind. After touchdown the acft veered to the right and departed the rwy. The plt applied power in an attempt to take-off but the nose wheel hit a hole and the acft…Jan 4, 1987 · N70493 · DestroyedNTSB NYC87LA053Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Goffstown, NHThe Cessna 180 made a touch and go on a 2100 ft long runway. The touchdown was described as past the first third of the runway. There were two rated pilots and a passenger in the aircraft. The co-pilot thought the aircraft would be unable to clear powerlines…Jan 1, 1987 · N9388C · Substantial damageNTSB MIA87LA065Accident · No injuriesLimited investigationFinal reportCessna 150H · Tchula, MSThe plt stated that while attempting to land at a crop dusting strip he inadvertently landed off to the side of the runway in a plowed field, flipped over and came to rest inverted.Jan 1, 1987 · N22684 · Substantial damageNTSB SEA87LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Gates, ORThe plt was attempting to land the aircraft at night on an unlit grass airstrip. Prior to reaching the airstrip the plt collided with an apple tree. Both wings were severed from the aircraft and it went inverted before striking the ground in a slightly nose…Dec 31, 1986 · N4116R · DestroyedNTSB CHI87LA059Accident · No injuriesLimited investigationFinal reportCessna 172H · Mosinee, WIThe CFI stated that while in the landing configuration, over the apch end of the rwy, the student excessively flared the acft and it stalled with the right wing contacting the rwy. According to the CFI, power was added but it was too late to 'save the…Dec 30, 1986 · N3220L · Substantial damageNTSB DEN87FA038Accident · Serious injuriesField investigationFinal reportCessna 172N · Central, UTThe plt and 3 passengers were on a local sightseeing flt over the pine valley mountain range. The plt stated that he made three 360 deg turns to gain alt from 7500 ft to 9500 ft. he also stated that upon leveling at 9500 ft the eng began to lose pwr. Attempts…Dec 29, 1986 · N5153K · Substantial damageNTSB FTW87DRD02Accident · No injuriesFinal reportCessna A-188-B · Ft.Polk, LAExamination revealed the tail wheel assembly was badly worn and its spacers were missing, causing the swivel mechanism to lock in the off center position. The aircraft landed on a narrow road. It veered slightly upon tail wheel contact and went off the…Dec 28, 1986 · N49220 · Substantial damageNTSB ATL87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · High Point, NCThe plt landed on the wet turf/gravel rwy with a slight quartering tail wind. Rprtdly, the acft touched down about 1/3 of the way down the rwy with an airspeed of 4 to 9 KTS above the recommended speed. The plt was unable to stop on the remaining rwy &…Dec 27, 1986 · N8389C · Substantial damageNTSB MIA87LA059Accident · No injuriesLimited investigationFinal reportPiper PA-44 · Key West, FLShortly after takeoff on an IFR flt, the flt lost all electrical power while in VFR conditions. The flt returned to the arpt and the plt completed the pre-landing checklist placing the gear handle in the down position. The gear, being electrically operated,…Dec 26, 1986 · N2197X · Substantial damageNTSB CHI87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Madison, WIWhile practicing touch & go landings, the student plt reports, the acft 'suddenly dropped' resulting in a hard landing. The acft then porpoised separating the nose gear and skidding to a stop off the rwy.Dec 26, 1986 · N4325E · Substantial damageNTSB FTW87LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Lindale, TXA private pilot substantially damaged his aircraft while attempting a landing on a grass strip in Lindale, TX. The pilot overshot the airstrip, and crashed in a field off the end of the runway.Dec 25, 1986 · N12525 · Substantial damageNTSB MIA87LA058Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe acft skidded off the end of the wet grassy runway after touching down about midway down the rwy. The plt stated that in the future, all available rwy should be used. The plt received his private certificate just prior to the accident.Dec 24, 1986 · N65484 · Substantial damageNTSB DEN87LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Nathrop, COThe canadian registered acft, with a pvt plt and instructor rated pax and two paxs aboard, took off from canon city, CO, enroute to gunnison, CO, to refuel. This was a cross-country flt to allow the plt to build necessary flt time towards a commercial…Dec 23, 1986 · CGYDG · Substantial damageNTSB MIA87LA055Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Ocala, FLThe acft dragged a wing during lndg according to the plts statement. The acft came to rest beside the rwy. The plt said he lost control of the acft due to a fuel imbalance. After the accident the left wing tip tank was found full of fuel. According to the…Dec 22, 1986 · N151CD · DestroyedNTSB MIA87LA053Accident · No injuriesLimited investigationFinal reportCessna 150F · Tunica, MSThe plt stated that during landing roll he lost control of the acft and it swerved off the right side of the rwy. The acft traveled into a plowed field and the nose gear collapsed.Dec 22, 1986 · N6907F · Substantial damageNTSB ANC87LA022Accident · No injuriesLimited investigationFinal reportCessna 206 · Ruby, AKThe pilot stated that during the landing roll on the frozen river, he lost control of the aircraft causing the aircraft to ground loop.Dec 22, 1986 · N734WE · Substantial damageNTSB NYC87DHA01Accident · No injuriesFinal reportPiper PA-28-180 · Lehighton, PAStudent pilot with a certified flight instructor while on the landing roll encountered a crosswind. Directional control was lost the aircraft departed the runway causing substantial damage due coming to final rest in a ditch.Dec 21, 1986 · N54482 · Substantial damageNTSB CHI87DET01Accident · No injuriesFinal reportPitts S1S · Warsaw, INAccording to the pilot after touchdown the right brake seemed to lock up with a 'skidding' noise as the aircraft left the runway. The pilot stated he was having difficulty keeping his toes off the brakes as he was attempting to maintain directional control.…Dec 21, 1986 · N39XP · Substantial damageNTSB SEA87LA038Accident · No injuriesLimited investigationFinal reportCessna 172 · Yamhill, ORThe plt was landing on a one way short narrow airstrip. He stated a gust of wind occurred just prior to touchdown. The aircraft then bounced and the plt added power. The aircraft then bounced several times and the nose gear collapsed. The aircraft then nosed…Dec 20, 1986 · N739LH · Substantial damageNTSB FTW87LA036Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Lubbock, TXThe plt stated that after a normal apch, he made a hard landing on the main gear and the acft bounced. He further stated that the second contact was hard on the main gear and that the nose gear collapsed when it touched down the 2nd time. Damage sustained by…Dec 20, 1986 · N8456X · Substantial damageNTSB FTW87LA034Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Arlington, TXA student pilot on solo flight in the local area of Arlington airport (F54) TX. Substantially damaged a Cessna 150 during a hard landing, breaking the nose gear and nosing over inverted. The pilot received minor injuries.Dec 20, 1986 · N714LL · Substantial damageNTSB DEN87IA031Incident · No injuriesIncident investigationFinal reportBeech C-99 · Albuquerque, NMMesa airline flt 114 was on a scheduled flt from Albuquerque to clovis, NM. Upon touchdown at clovis, the left landing gear began to collapse and a go-around was successful. The crew elected to return to Albuquerque where emerg equipment could stand by. After…Dec 18, 1986 · N7212P · Minor damageNTSB MIA87LA049Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Gulfport, MSThe acft touched down at a high rate of speed with a left quartering tailwind at the halfway point on the 2700 ft rwy. The acft ran off of the right side of the rwy and the plt regained control getting the acft back onto the rwy. The acft then overran the end…Dec 14, 1986 · N117CL · Substantial damageNTSB DEN87LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, CODuring landing, directional control was not maintained. The acft veered left, the landing gear entered a snowbank, and the acft nosed over.Dec 14, 1986 · N4597L · Substantial damageNTSB ATL87LA043Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Morganton, NCPlt reptd doing LCL flying for about one hr after dept from pvt grass strip. Made apch and ldg at Morganton-lenoir apt. On touchdown plt reptd bouncing, and being unable to recover before lt main gear collapsed and lt wing dragged. Plt stated that he felt…Dec 12, 1986 · N71966 · Substantial damageNTSB MKC87LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Olathe, KSDuring landing airplane ballooned due to wind gust. After touchdown. Airplane veered left and duirng pilot's correction, the left main landing gear leg broke off. Metallurgical evaluation revealed a previous fatigue failure in the fracture surface.Dec 11, 1986 · N26DL · Substantial damageNTSB LAX87LA060Accident · No injuriesLimited investigationFinal reportMooney M20C · Michigan Bar, CADuring the flare, just prior to touchdown, a deer ran across the runway from the right and subsequently collided with the left wing of the aircraft. The pilot reported there was no time to avoid an impact.Dec 9, 1986 · N5808Q · Substantial damageNTSB NYC87LA048Accident · No injuriesLimited investigationFinal reportCessna 150 · Poestenkill, NYThe pilot touched down hard, added power for a go around. Sluggish engine did not have enough power to clear trees at the end of the runway. Aircraft collided with trees. The plt after the acc said that after cutting off the carb head the eng seemed sluggish.…Dec 6, 1986 · N50714 · Substantial damageNTSB LAX87LA061Accident · No injuriesLimited investigationFinal reportCessna 182Q · San Rafael, CADuring an instructional flight, the student pilot was not aligned properly with the runway. The flight instructor (CFI) took control of the aircraft on final, but he stated that it did not respond when he applied rudder control. After touchdown, the aircraft…Dec 6, 1986 · N759DH · Substantial damageNTSB CHI87LA043Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Marquette, MIWhile on landing rollout the student pilot skidded off the left side of the runway and collided with a snowbank. The student stated he was holding excessive left rudder and brake pressure.Dec 6, 1986 · N41765 · Substantial damageNTSB NYC87DNC03Accident · No injuriesFinal reportAero Commander 680 · Barre, VTWitness observed the acft touchdown about 2000 feet down 5001 foot rwy. The rwy was reported wet and icy in spots at the north end only. The acft overran the rwys end and went down into a ravine about 25 ft below rwy level. There was no indication of…Dec 3, 1986 · N6375U · Substantial damageNTSB ANC87LA017Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot lost directional control of the aircraft on touchdown. Examination of the brake system revealed the left brake was frozen.Dec 3, 1986 · N6992N · Substantial damageNTSB DEN87LA027Accident · No injuriesLimited investigationFinal reportCessna 152A · Great Falls, MTThe student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.…Dec 2, 1986 · N4784A · Substantial damageNTSB CHI87IA039Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Madison, WIAircraft slid off the right side the runway during the rollout from a cross wind landing and struck 6 runway edge lights causing minor damage to the inboard trailing edge of the right flap. At the time of the incident there was 1/2 inch of snow on the runway…Dec 2, 1986 · N786NC · Minor damageNTSB NYC87DFA02Accident · No injuriesFinal reportSchweizer SGS 2-33A · Wurtsboro, NYThe pilot was landing a Schweizer SGS-233 when he started to get into a pilot induced oscillation. The oscillations increased and the aircraft impacted in a nose low attitude. The pilot said the accident could have been prevented with less control input,…Nov 30, 1986 · N1222S · Substantial damageNTSB LAX87LA056Accident · No injuriesLimited investigationFinal reportPitts Special S1-D · Phoenix, AZAt the end of a local pleasure flight, the aircraft ground looped while the pilot was turning off of runway 7R onto a high speed taxiway. The pilot reported that near the end of the landing roll, he tapped the brakes lightly in preparation to turn when the…Nov 29, 1986 · N365A · Substantial damageNTSB DEN87LA026Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Vernal, UTThe plt attempted to land on a dirt road near two oil rigs. He said he made several low passes to view the road surface. During the landing roll, the wheels of the acft dug into the soft surface. A loss of control occurred which resulted in the acft traveling…Nov 29, 1986 · N5996S · Substantial damageNTSB CHI87DER01Accident · No injuriesFinal reportCessna 185D · St. Paul, MNDuring landing after the skis had touched down the acft began to swerve. As the acft left the rwy the plt attemtped a go-around, however, one ski dug into the ground and the acft flipped over onto it's back. Post accident exam revealed the right ski had…Nov 29, 1986 · N1502F · Substantial damage