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 CHI87LA008Accident · No injuriesLimited investigationFinal reportCessna 177 · Waukesha, WIAccording to the plt, it was a normal flight and approach to rwy 18. On touchdown, the acft nose dropped and the acft bounced three of four times. The plt stated that he immediately added pwr and became airborne, but a vibration caused him to cut pwr and land…Oct 22, 1986 · N3436T · Substantial damageNTSB CHI87LA006Accident · No injuriesLimited investigationFinal reportCessna 120 · Decatur, ILThe pilot stated that he was practicing crosswind landings on runway 24 when the airplane bounced twice. According to the pilot, he immediately added power and then lost directional control of the airplane and ground looped to the left. Following the ground…Oct 22, 1986 · N2896N · Substantial damageNTSB NYC87LA044Accident · No injuriesLimited investigationFinal reportCentrair 101A · Julian, PAThe pilot had decided to land following a 41 minute flt. The plt reported his airspeed was too fast during the landing apch and he over compensated which resulted in too slow of an airspeed. The glider touched down hard, became airborne and landed hard a…Oct 21, 1986 · N40KG · Substantial damageNTSB ANC87LA007Accident · 1 fatalLimited investigationFinal reportInterstate S-1B1 · Eureka Creek, AKThe pilot lost control of the aircraft on landing & it collided with a large metal sluice box that was located beside the runway. At the time of the accident, the wind was from the northeast & was gusty. The dirt ruway was frozen, rough &rutted.Oct 21, 1986 · N46243 · Substantial damageNTSB ANC87LA006Accident · No injuriesLimited investigationFinal reportShort Brothers SC7 · Nightmute, AKAccording to the plt-in-command (PIC), when the acft was on final apch to the 1600 ft rwy, it encountered a downdraft. Subsequently, the acft hit hard on the lip of the rwy, then bounced & touched down on the rwy. After the 2nd touchdown, the acft veered to…Oct 21, 1986 · N406TH · Substantial damageNTSB LAX87LA022Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Big Bear City, CAThe acft veered off rwy 7 during landing roll. The plt indicated the acft veered to the right. There was a single rubber skid mark aprx 150 ft long found on the rwy. The wind was reported by another plt to be 'down the runway at 10-15 knots.' Examination of…Oct 20, 1986 · N9206D · Substantial damageNTSB CHI87DEM02Accident · No injuriesFinal reportLeblanc Dragonfly · Lansing, MIThe home built acft was on a test flt & was being flown by a plt with only about 2.5 hrs of flt time in this make & model. During the landing, the acft touched down hard & began to porpoise. The canard & wooden prop were damaged during the occurrence.Oct 20, 1986 · N4463L · Substantial damageNTSB MKC87LA009Accident · No injuriesLimited investigationFinal reportCessna 501 · Little Rock, ARThe PIC stated that he had to fly a faster than normal apprch to the outer marker for the ILS apprch as instructed by apprch control. Apprch cntl indicated that a Boeing 727 was no. 2 for the apprch and that the PIC should maintain 230 KTS till further…Oct 19, 1986 · N2BT · Substantial damageNTSB FTW87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Jacksboro, TXThe pilot reports that after a hard landing, the aircraft ballooned, bounced hard and veered off the runway due to gusty crosswinds. The winds for the area were reported to be from 140 degrees at 11 knots with no gusts.Oct 19, 1986 · N29589 · Substantial damageNTSB ANC87LA005Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chickaloon Flat, AKThe pilot-in-command refused to cooperate and would not submit an NTSB form 6120.1 nor would he discuss the accident except that he crashed upon landing. The plts med. Cert had expired.Oct 19, 1986 · N39146 · Substantial damageNTSB MKC87LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Macon, MOThe pilot stated that he encountered more severe crosswinds than planned upon landing and that he tried remedial action, including a rejected landing, but it came too late. The wind was blowing from the right on the landing roll as he shut down the engine and…Oct 18, 1986 · N1690K · Substantial damageNTSB MIA87IA011Incident · No injuriesIncident investigationFinal reportCessna 310R · West Palm Beach, FLWhile on an on-demand air-taxi flight the pilot noted that at touchdown the rt main gear was collapsing. He executed a go-around and attempted to lower the gear manually, but could not. The pilot then shut down the right engine and feathered the right…Oct 18, 1986 · N2638N · Minor damageNTSB LAX87LA019Accident · Serious injuriesLimited investigationFinal reportLake LA4-180 · Folsom, CADuring a local cross country pleasure flight, the pilot attempted a landing on Lake Folsom. Upon touchdown the aircraft began settling in the water then nosed over and sank. The pilot stated he felt there was an object in the water that was struck. Witnesses…Oct 18, 1986 · N1118L · Substantial damageNTSB MKC87LA006Accident · No injuriesLimited investigationFinal reportCessna 421C · Hot Springs, ARThe pilot stated that gear went down normally, he had three green lights and the gear warning horn was not on and he could see that the nose gear was down by looking in the nacelle mirror. After touchdown, the nose was lowered and as it touched the runway,…Oct 17, 1986 · N49D · Substantial damageNTSB ATL87LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Middlefield, OHStudent plt stated that he was preparing to land after a business x-country flt. On downwind he noted the wind sock ind a x-wind. Made a long final and did not notice x-wind. Stated that at flare he seemed to have a little tailwind since his spd was 85 KTS…Oct 17, 1986 · N5162M · Substantial damageNTSB MIA87FA009Accident · Serious injuriesField investigationFinal reportCessna 152 · Hattiesburg, MSThe student plt was on a supervised solo flt. He stated that he had always been 'scared' of landings & when he returned to the airport to land, the wind sock was standing 'straight out.' He later stated that he intended to continue flying and thought that he…Oct 16, 1986 · N24485 · Substantial damageNTSB NYC87LA019Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Leroy, NYFlight instructor simulating an emergency landing, landed on main landing gears and tail. Aircraft veered to the right off the runway and collided with bushes.Oct 15, 1986 · N60CS · Substantial damageNTSB NYC87IA014Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Portland, METhe cp was flying the aircraft from the left seat while being observed by the PIC. The PIC was monitoring the approach, which was being made in IMC conditions and noted the aircraft drifting to the left, the cp started to make correction to the right at which…Oct 15, 1986 · N517PE · Minor damageNTSB MIA87LA008Accident · No injuriesLimited investigationFinal reportCessna 210 · Kissimmee, FLThe plt stated that he forgot to lower the gear and that the accident could have been prevented if a tower had told him to lower the gear. There is no tower at the arpt. After the accident, the plt produced a caa commercial plt certificate which was issued in…Oct 15, 1986 · N7395E · Substantial damageNTSB MIA87LA007Accident · No injuriesLimited investigationFinal reportWaco YMF · Key West, FLThe acft nosed over during landing roll. The professional plt stated that he was certain the brakes were off prior to takeoff and that he was sure he was not 'riding' the braked on landing. The plt stated that he thought the parking brake may have come on…Oct 15, 1986 · N99Y · Substantial damageNTSB DEN87LA005Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Fort Morgan, COThe student plt had just been endorsed for his first supervised solo flt. He had successfully completed one landing and was attempting his second landing when the accident occurred. The plt said he lost directional control, touched down, and over corrected.…Oct 15, 1986 · N9748D · Substantial damageNTSB ANC87IA003Incident · No injuriesIncident investigationFinal reportBoeing 727-22C · Anchorage, AKAfter departure, the flight crew retracted the landing gear and noticed a nose gear disagreement light. Upon arriving at Anchorage, the flight crew could not lower the nose gear through normal or manual means. The airplane landed with main gear extended and…Oct 15, 1986 · N753AS · Minor damageNTSB NYC87LA018Accident · Minor injuriesLimited investigationFinal reportBeech E-90 · Beverly, MAThe Beech king air E-90 was observed to break out of the clouds in a steep descent, land long and run off the departure end of the 4637 ft runway. The aircraft received substantial damage and the crew of 2 and 6 passengers received minor injuries. The…Oct 14, 1986 · N195B · Substantial damageNTSB NYC87LA042Accident · Minor injuriesLimited investigationFinal reportRaven S60A · Montville, CTWhile landing in a field. The balloon encountered strong winds and was pushed into trees and brush causing substantial damage.Oct 11, 1986 · N2799Z · Substantial damageNTSB SEA87LA010Accident · No injuriesLimited investigationFinal reportBritten-Norman BN-2A-20 · Lower Loon, IDThe plt diverted from his original destination due to weather. Upon landing at the alternate airport wiht a 7 knot tail wind, while using heavy braking on wet sod, the brakes locked. The acft veered to the right of the center placing the right main gear on…Oct 10, 1986 · N25SA · Substantial damageNTSB SEA87LA007Accident · No injuriesLimited investigationFinal reportHughes 500-D · Seattle, WADuring a practice autorotation a loss of power occurred. The pilot attempted engine recovery but was unable to resulting in a hard landing in which the main rotor blade flexed, severing the tail boom. The throttle linkage on the pilots side was found to have…Oct 10, 1986 · N58239 · Substantial damageNTSB NYC87LA016Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Poughkeepsie, NYThe Piper PA-32, landing with a 5 knot quartering tailwind from the right, ran off the left side of the runway and struck the windsock receiving substantial damage. The pilot and 2 passengers were not injured. The pilot reported that upon touchdown he felt…Oct 10, 1986 · N42943 · Substantial damageNTSB DEN87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Price, UTThe student plt was on a solo cross-country flt. She stated that on landing, the acft ballooned. She initiated a go-around and during the climbout, the acft began to settle. It drifted off to the side of the rwy and the wing tip struck the ground. The acft…Oct 9, 1986 · N93703 · Substantial damageNTSB CHI87DEE02Accident · No injuriesFinal reportPiper PA-23-250 · Crestwood, ILThe aircraft was flown without authorization from the owner by unknown person(s). Upon landing, directional control was lost. The aircraft skidded off the runway into an aircraft tie-down area and collided with a parked aircraft.Oct 9, 1986 · N6955Y · Substantial damageNTSB ATL87LA002Accident · Minor injuriesLimited investigationFinal reportCessna 172P · East Liverpool, OHRwy repair was in progress. The rwy was closed & battery powered lights were left to mark a 5 inch deep ditch that crossed the runway. Arpt & rwy lights were left off. The FBO continued to rent acft for operations from the arpt. The plt departed on a 28 mi…Oct 9, 1986 · N54067 · Substantial damageNTSB SEA87LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Petersburg, AKThe plt reported that while landing on a river the acft skidded on river silt. He stated he could not stop the acft which traveled to the FAR end of the river into 8 inch deep water where it nosed over.Oct 8, 1986 · N6191D · Substantial damageNTSB BFO87FA003Accident · Minor injuriesField investigationFinal reportBellanca 8GCBC · Keysville, VAThe pilot made a tailwheel high touchdown on the 1850 foot grass strip. Shortly after touchdown, the nose dropped and, although the pilot said he moved the control stick fully aft, the propeller struck the ground, and the aircraft flipped inverted.Oct 8, 1986 · N7100C · Substantial damageNTSB ANC87LA002Accident · No injuriesLimited investigationFinal reportTeal TSC-1A2 · Lewis River, AKThe plt stated that he landed the amphibious acft on the Lewis River with the gear in the extended position. Shortly after touchdown, the acft nosed over on its top. FAA records showed the plt had a total flying time of aprx 710 hrs.Oct 8, 1986 · N87857 · Substantial damageNTSB NYC87LA013Accident · No injuriesLimited investigationFinal reportCessna 150 · So. Dayton, NYThe student pilot came in long and high, bounced the aircraft a few times. The nose wheel collpased and the aircraft was substantially damaged.Oct 7, 1986 · N50832 · Substantial damageNTSB MIA87FA004Accident · No injuriesField investigationFinal reportSmith, Ted Aerostar Aerostar 600 · Jacksonville, FLReportedly, during an ILS approach to land, the pilot did not use the company approved checklist and landed with the gear retracted.Oct 7, 1986 · N338NA · Substantial damageNTSB LAX87LA011Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Yuma, AZA Bellanca 7KCAB lost control and veered off rwy 16. The CFI indicated that the aircraft veered right during landing roll. The student pilot applied left pedal and the aircraft swung left and ground looped. The aircraft dropped off the rwy shoulder, breaking…Oct 6, 1986 · N8727V · Substantial damageNTSB MKC87LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Seward, NEThe plt reports that he was landing on his private grass strip which is 1600 x 60 ft. he said the grass on the edges was thicker then that in the middle. During landing roll the acft drifted to the lt and the lt wing collided with milo growing along the lt…Oct 5, 1986 · N5980P · Substantial damageNTSB ANC87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22 · North Pole, AKAfter touchdown on the grass next to the runway, the pilot lost directional control of the aircraft and struck a snowbank.Oct 5, 1986 · N7427D · Substantial damageNTSB SEA87LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Madras, OROn landing touchdown, aircraft nose tire blew out. The student pilot over-corrected with controls and power, causing the aircraft to balloon into the air and touch down a second time in a flat attitude, resulting in a hard landing.Oct 2, 1986 · N4693J · Substantial damageNTSB NYC87LA003Accident · No injuriesLimited investigationFinal reportCessna 150 · Buxton, METhe pilot was making a short field landing at a private airstrip which was grass covered and wet. The pilot came in too high and long and once on the ground, skidded to a stop between two trees.Oct 2, 1986 · N94457 · Substantial damageNTSB LAX87LA001Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAThe acft went out of control and ran off the rwy. The student plt indicated that on his first apch his altitude was too high and he was aligned to the left of the rwy. He initiated a go-around and made a second attempt. During the flare on his second apch the…Oct 2, 1986 · N4178Y · Substantial damageNTSB FTW87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Sulpher, LAThe pilot landed long at a private grass airstrip and deliberately ground looped the aircraft to avoid overrunning the airstrip into a three foot ditch. The nose gear collapsed during the ground loop and the wings and main gears were damaged when the aircraft…Oct 2, 1986 · N7533Y · Substantial damageNTSB BFO87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Hillsville, VAAfter touchdown on the rwy, the plt held the nose wheel off for about 200 feet of travel by holding the control wheel back. According to him, the acft then veered to the left and he was unable to steer it with the rudder pedals. The acft went off the side of…Oct 2, 1986 · N6003D · Substantial damageNTSB NYC87LA001Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Caldwell, NJThe pilot in command allowed the aircraft to become too low during a night simulated emergency (engine out) during an instructional flight. The aircraft contacted the tops of trees, became uncontrollable and crashed to the ground.Oct 1, 1986 · N8320A · Substantial damageNTSB LAX86LA359Accident · No injuriesLimited investigationFinal reportCameron 0-77 · Tiburon, CAAfter completing an aerial advertising flight across the san francisco bay, the plt attempted a landing on up-sloping terrain. The terrain was steeper than anticipated & the plt became distracted. The plt forgot to turn off the pilot light to the left burner.…Sep 30, 1986 · N2948G · DestroyedNTSB DEN86LA262Accident · No injuriesLimited investigationFinal reportBeech 60 · Boulder, COAt touchdown, the plt applied brakes normally. He noticed softening of the left brake pedal and the acft turned right leaving the rwy and intersecting a taxiway at aprx a 30 degree angle. The taxiway had a six inch rise at the edge which caused the left main…Sep 30, 1986 · N3694D · Substantial damageNTSB MKC86FA197Accident · No injuriesField investigationFinal reportRockwell NA-265-80 · Liberal, KSThe right main landing gear downlock pin retracted just before or during touchdown. The airplane touched down 21 feet short of the runway. It traveled that 21 feet, traveled the full length of the 6999-foot runway, then traveled another one-fourth of a mile…Sep 29, 1986 · N64 · Substantial damageNTSB NYC86LA243Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Seneca Falls, NYThe acft was landed gear up and was subsequently destroyed by fire. The plt admitted he forgot to lower the gear. It wasconfirmed during the post accident inspection that the gear selector was in the up position and the gear doors were closed.Sep 28, 1986 · N525TP · Substantial damageNTSB MKC86LA196Accident · No injuriesLimited investigationFinal reportFloyd R.Harris Eagle 2 · Joplin, MOPilot was landing rwy 22 with winds from 190 at 12. Just before touchdown, a wind gust lifted acft to right, off side of the runway. Pilot started a go-around but discovered path of flight was toward tower and terminal bldg. Pilot aborted go-around and put…Sep 28, 1986 · N25FH · Substantial damageNTSB LAX86DVM07Accident · No injuriesFinal reportWalter D. Burleson KR-2 · Hollister, CADuring a first proving flt for the experimental homebuilt, the pilot said the aircraft 'hit hard' during the landing, bounced and came down on the left wing and nose. According to the pilot, he had accrued less than an hour of flight time in the accident…Sep 28, 1986 · N50WB · Substantial damage