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 LAX85LA357Accident · No injuriesLimited investigationFinal reportCessna 172P · Glendale, AZThe acft ran off the rwy and into a ditch after a landing at Glendale, AZ. The rwy is 2400 ft long and 50 ft wide. The plt stated he landed about 40% down the rwy, bounced three times, steered off the rwy and hit a shallow ditch. The plt reported no…Aug 15, 1985 · N65748 · Substantial damageNTSB DEN85LA220Accident · No injuriesLimited investigationFinal reportBeech 76 · Sula, MTPlt stated that he overflew airstrip to 'make sure it was clear.' During the landing roll, he saw shrubbery on the rwy and attempted evasive action. The acft veered left and the left main gear rolled into a drainage ditch and the left wing contacted a fence…Aug 15, 1985 · N3865U · Substantial damageNTSB SEA85LA196Accident · No injuriesLimited investigationFinal reportCessna 150L · Bellingham, WAThe plt, who was unfamiliar with the area, was given directions & traffic pattern info to the meadows mist arpt, a a pvt/charted strip near Bellingham, WA. She came upon a similar grass strip in that area with a parked acft on it. Thinking this uncharted…Aug 13, 1985 · N10647 · Substantial damageNTSB NYC85LA208Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28F · Groton, CTEnstrom F28F, N8623X was performing auto rotation at Groton-new london, Connecticut when a loss of power was experienced, the student pilot was at the controls and entered auto rotation with the understanding that it would terminate in a power recovery. After…Aug 12, 1985 · N8623X · Substantial damageNTSB MIA85LA229Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Jacksonville, FLPilot stated that while enroute he experienced an electrical system failure. During approach to the airport he could not get the landing gear to extend and he made a gear up landing. As the aircraft was raised after the accident the landing gear extended and…Aug 12, 1985 · N6522C · Substantial damageNTSB LAX85LA344Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Big Bear City, CAOn August 12, 1985, a Bell 47G2 helicopter collided with a yucca tree and rolled over during a landing near Big Bear City, CA. The acft sustained substantial damage and the plt and his two passengers were not injured. The purpose of the flight was a aerial…Aug 12, 1985 · N2899B · Substantial damageNTSB MKC85LA185Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Shawnee, KSThe commercial Balloon plt was giving a ride to three paying passengers. Plt stated that during the landing apch higher than normal winds were present so he briefed the passengers to lean against the side of the basket. He stated that he pulled the deflation…Aug 11, 1985 · N40468 · No damageNTSB MKC85LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Hays, KSThe student plt, who was taking his pvt plt chk ride with an faa-designated examiner, reduced power prematurly on final approach for landing at Hays. The acft dropped, striking the ground in a level attitude, which jammed the nose gear upwards, distorting and…Aug 10, 1985 · N98251 · Substantial damageNTSB SEA85LA192Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAA ground loop occurred and the steering spring failed. The aircraft's steering spring had failed prior to the accident away from a repair station. The pilot made a temporary repair that failed during this ground loop. The pilot stated that a combination of a…Aug 9, 1985 · N7765K · Substantial damageNTSB LAX85LXQ02Accident · Serious injuriesFinal reportRonald C. Render Long EZ · Lee Vining, CADuring arrival, the acft was aligned slightly right of the rwy centerline while landing with a left x-wind component. The plt stated that the acft landed on the dirt apron, rolled to the right & he could not lift the downwind wing. Subsequently, the right…Aug 9, 1985 · N325OK · Substantial damageNTSB FTW85LA319Accident · No injuriesLimited investigationFinal reportCessna R182 · Lubbock, TXThe plt made a hard landing at the town and country arpt at Lubbock, TX, and a collapse of the nose gear resulted.Aug 9, 1985 · N7304T · Substantial damageNTSB DEN85LA213Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverton, WYThe student plt attempted to land on rwy 17. The wind was reported to be from 010 degs at 13 KTS. The acft touched down halfway down the rwy. The plt attempted to go around but aborted because of the tailwind. The acft ran off the end of the rwy and collided…Aug 9, 1985 · N4941P · Substantial damageNTSB CHI85LA347Accident · No injuriesLimited investigationFinal reportCessna 172 · N. Philadelphia, OHThe plt landed at the wrong arpt at dusk, colliding with a ditch during rollout on the turf rwy. The destination arpt was 10 miles away on the same course with the sod rwy alignment.Aug 9, 1985 · N4753D · Substantial damageNTSB ATL85FA242Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Abbeville, SCThe acft crashed into trees & the ground after going into a left turn during a go-around initiated after a bouncy landing. After power was added for the go-around the acft seemed to be uncontrolled so that the CFI on the ground, who had just exited the acft…Aug 9, 1985 · N7475W · DestroyedNTSB ATL85LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Peachtree City, GAPilot was renewing proficiency in light acft. On first touch and go landing, according to his statement during phone interview, he flared, acft ballooned, landed hard and porpoised. During ensuing roll out nose of acft settled and prop contacted runway. Acft…Aug 8, 1985 · N61769 · Substantial damageNTSB SEA85LA188Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Cold Meadows, IDThe plt was attempting to land on an airstrip with a density alt of 9000 ft. during a go-around the acft was unable to out climb rising terrain due to the density alt. A departure stall into trees resulted. A post-impact fire destroyed the acft. The plt…Aug 6, 1985 · N4346T · DestroyedNTSB NYC85LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Doylestown, PAAccording to the plt, on touchdown the acft braking was ineffective due to morning dew on the grass rwy. The acft slid off the end of the rwy and collided with bushes.Aug 6, 1985 · N2960B · Substantial damageNTSB NYC85LA203Accident · No injuriesLimited investigationFinal reportCessna 152 · Allentown, PAThe acft touched down hard and bounced while landing at Allentown, PA. The plt stated that upon making the landing, the controls felt like the acft's nose wheel had gone flat. As he attempted to pull the nose up, the acft ballooned and came down to the side…Aug 6, 1985 · N757PX · Substantial damageNTSB LAX85LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Hesperia, CAUpon completing a x-c flt, the plt placed the landing gear selector in the down position, & thereafter observed 'three in the green.' The plt reported that the acft touched down normally, & as weight placed onto the gear the right main gear retracted. The…Aug 6, 1985 · N6166H · Substantial damageNTSB FTW85LA307Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Olton, TXThe pilot stated that when he touched down on the dirt landing strip the aircraft immediately turned right and no amount of corrective action helped. He further stated the mechanic had to remove the brake pads to get the tire to roll. The aircraft's owner…Aug 6, 1985 · N5025X · Substantial damageNTSB FTW85LA328Accident · No injuriesLimited investigationFinal reportPiper J4A · Duncan, OKThe plt was practicing short fld landings when the accident occurred. He stated the acft ballooned and he advanced the throttle but the eng failed to respond immediately. The acft stalled at 2 ft above the ground according to the plt. Hardcontact with the…Aug 5, 1985 · N30986 · Substantial damageNTSB ATL85LA239Accident · No injuriesLimited investigationFinal reportCessna 172N · Wilmington, NCDuring landing roll the plt lost directional control of the acft & ran off the side of the rwy. The acft nosed down in soft soil resulting in substantial damage. The plt reported a gust of wind was encountered which resulted in the control loss.Aug 5, 1985 · N733NU · Substantial damageNTSB ANC85LA145Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Eureka, AKPlt approach strip high and fast, struck a dirt berm and turned over.Aug 5, 1985 · N704JN · Substantial damageNTSB MIA85LA226Accident · No injuriesLimited investigationFinal reportCessna 210N · Melbourne, FLAct swerved left after landing and crashed at drainage ditc h appx 50 ft north of rwy. The pilot stated he was unable to effect a timely recovery from the left swerve and that 'a more consistent training effort could sharpen my reactions to this sort of…Aug 4, 1985 · N4744C · Substantial damageNTSB LAX85LA340Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Tucson, AZThe tailwheel equipped acft nosed over after the plt lost iirecitional control during lndg. There were no reports of mechanical difficulties or weather facotrs to be considered in the area of cause. The plts flt experience is unknown since repeated attempts…Aug 4, 1985 · N45CT · Substantial damageNTSB MKC85LA176Accident · No injuriesLimited investigationFinal reportCessna 172 · Cape Girardeau, MOWhile on a solo x-country flt, the student plt became lost/disoriended. When the acft's fuel level became low at dusk, the student elected to land on a gravel road. As the acft was on the landing roll-out, the left wing struck a brace wire for a power line…Aug 3, 1985 · N54666 · Substantial damageNTSB LAX85LA342Accident · No injuriesLimited investigationFinal reportPitts S-2A · Van Nuys, CAAfter practicing acrobatics the plt returned to the arpt for the purpose of practicing landings. He made the first one successfully, but flared out high on the second landing. The acft bounced 'hard' on the rwy twice, & the plt elected to go around. After…Aug 3, 1985 · N88M · Substantial damageNTSB CHI85LA332Accident · Minor injuriesLimited investigationFinal reportMcfarland Quickie 2 · Port Clinton, OHThe pilot failed to release the parking brakes before landing after setting the brakes while enroute. The acft swerved off the runway and nosed over.Aug 3, 1985 · N335RM · Substantial damageNTSB CHI85LA331Accident · No injuriesLimited investigationFinal reportCessna 150K · Romeo, MIThe acft nosed over after contacting a ditch during a landing roll. The student plt, on his second solo flt, was practicing touch & go landings when the accident occurred. He stated he rushed on final apch because other acft were lined up waiting to takeoff.…Aug 3, 1985 · N5783G · Substantial damageNTSB CHI85LA330Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Lansing, ILOne of the pilot's eyes became irritated. He attempted to scratch it on short final. A hard landing resulted. The aircraft became airborne & the pilot added power. His glasses became dislodged. At this time the pilot was attempting to regain control as the…Aug 3, 1985 · N57275 · Substantial damageNTSB ATL85LA235Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Burnsdie, KYThe acft bounced during touchdown on a grass airstrip and veered off the left side of the rwy. Before proper alignment was gained the left wing struck a parked acft and both acft incurred substantial damage.Aug 3, 1985 · N4884L · Substantial damageNTSB LAX85LA337Accident · No injuriesLimited investigationFinal reportCessna 172 M · Island Mountain, CAUpon arriving over the uncharted, 2000-foot-long dirt airstrip, the plt placed the acft into landing configuration & attempted to land. The acft touched down hard, bounced 3 times, 'floated,' overran the runway's end, went into a ditch & nosed over. The plt…Aug 2, 1985 · N64033 · Substantial damageNTSB DEN85LTG05Accident · No injuriesFinal reportGrumman G164A · Colfax, NDThe plt noticed the spray pump was stuck in the off position shortly after takeoff for the aerial application flt. The decision was made to land on a private strip and during landing on the soft fld, the acft contacted high vegetation and nosed down.Aug 2, 1985 · N5364 · Substantial damageNTSB ANC85LA144Accident · No injuriesLimited investigationFinal reportCessna C-182K · Port Alsworth, AKThe pilot-in-command stated that he misjudged his height above the runway's surface after making his approach from over the water. He flared 10 to 15 foot above the ground. Upon touchdown he lost control of the airplane and it left the runway's surface and…Aug 2, 1985 · N3121Q · Substantial damageNTSB ANC85LA142Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Nome, AKThe plt stated on short final apch he noticed a x-wind stronger then expected. After touchdown directional control of the acft was lost. The acft then exited the rwy into a open ditch. At the time of the accident the wind was 280 degs at 12 KTS.Aug 2, 1985 · N70008 · Substantial damageNTSB DEN85LA205Accident · No injuriesLimited investigationFinal reportCessna 172RG · Evanston, WYThe plt lost direstional control of the acft while attempting to land in gusty x-wind conditions. The acft was destroyedwhen it impacted terrain in a 50 ft deep ravine.Jul 30, 1985 · N9455D · DestroyedNTSB CHI85LA323Accident · No injuriesLimited investigationFinal reportMaule M-6 · Iron Mountain, MIDuring landing rollout the aircraft ground looped and the left wing struck the runway. This was the pilot's first flight in this model conventional gear aircraft.Jul 30, 1985 · N5646Z · Substantial damageNTSB CHI85LA322Accident · No injuriesLimited investigationFinal reportCessna 152II · Indianapolis, INThe student plt lost directional control on rollout following a bounced landing. The CFI attempted to regain control but was not able to before the acft departed the rwy and nosed over.Jul 30, 1985 · N48241 · Substantial damageNTSB SEA85FA182Accident · 2 fatalField investigationFinal reportConsolidated-Vultee PBY-6A · Northport, WAWater bomber acft landed on lake with dump doors partially open during landing phase of water pickup run. Mechanically operated dump door locks were applied before dump doors were closed. Plt controlled dump doors from pilots control wheel, co-pilot operated…Jul 29, 1985 · N2886D · DestroyedNTSB MKC85LA192Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Grand Island, NEDuring flt, the plt encountered radio receiver problems & diverted to Grand Island, NE. During arrival, he requested a special VFR clearance, but could not ascertain if the tower had answered. Radio communication was established in the traffic pattern & the…Jul 29, 1985 · N9937Y · Substantial damageNTSB MKC85LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Ames, IAThe desired rwy (19) was closed at the destination, so the plt landed on rwy 13 with a 15 kt x-wind. The x-wind was within the capability of the acft & the plt. After touchdown, the plt used full rudder & brake to maintain directional control. However, he…Jul 29, 1985 · N3161C · Substantial damageNTSB CHI85LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Franklin, WIThe pilot used a shortfield takeoff and the acft would not fly. The plt aborted the takeoff and landed on the end of therwy, overrunning the rwy and striking a ditch. The plt reported engine RPM normal and the acft was under max gross takeoff weight.Jul 29, 1985 · N4542F · Substantial damageNTSB SEA85LA184Accident · No injuriesLimited investigationFinal reportGrumman 164 · Klamath Falls, ORA landing was being made on an agricultural airstrip when a dust devil was encountered. During application of brakes the right brake failed due to a leaking o ring. The aircraft then veered right striking a fence.Jul 28, 1985 · N742Y · Substantial damageNTSB NYC85LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-140B · Duanesburg, NYAccording to the pilot, the aircraft landed and was taxiing to the fuel pump. The aircraft was moving fast and when the hand brake was applied it did not function. The pilot veered the aircraft off the runway in an attempt to slow it down. The aircraft rolled…Jul 28, 1985 · N95141 · Substantial damageNTSB MIA85LA221Accident · No injuriesLimited investigationFinal reportCessna 182P · Davisville, FLThe pilot stated that on landing roll out at the agricultural airstrip, the aircraft struck a ditch causing the nose gear to collapse.Jul 28, 1985 · N1243M · Substantial damageNTSB LAX85LA331Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Taohoma, CAOn July 27, 1985 a float equipped Cessna TU206G landed on choppy water, nosed over and sank at the seaplane base in lake tahoe, CA. The pilot and 1 passenger were not injured. Witnesses reported that time water conditions were moderate chop with waves 2 to 5…Jul 28, 1985 · N6277Z · Substantial damageNTSB CHI85LA326Accident · No injuriesLimited investigationFinal reportCessna 177B · Kankakee, ILThe plt landed on the 5100 ft x 100 ft rwy, porpoised several times, lost directional control and veered off the rwy. The nose gear broke off and the acft nosed down.Jul 28, 1985 · N20277 · Substantial damageNTSB NYC85LA196Accident · No injuriesLimited investigationFinal reportCessna 425 · Manahawkin, NJAfter overflying the airfld and deciding to land on rwy 22, the plt concentrated on the airspeed and alt of the acft. A twr east of the flt was noticed and was not considered a problem. During the final apch, the plt was distracted by a passenger who said to…Jul 27, 1985 · N6887B · Substantial damageNTSB CHI85LA327Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Fond Du Lac, WIThe plt had accurued aprx 12 hrs of flying time on the day of the accident. During the final landing the acft touched down at the rwy mid-point and bounced. The acft then struck a rwy light and veered off the rwy paved surface into soft sod. The plt attempted…Jul 27, 1985 · N5604V · Substantial damageNTSB BFO85LA063Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Woodbine, MDThe acft nosed over during a hard landing at Woodbine airport, Woodbine, Maryland, while on a check ride.Jul 27, 1985 · N7657S · Substantial damage