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 FTW86LQG13Accident · No injuriesFinal reportBeech C23 · Vega, TXThe acft landed hard following a simulated short field landing over an obstacle. Power was reduced as the acft cleared the imaginary obstacle but there was a slight delay in lowering the nose to maintain airspeed. The acft was flared at a high sink rate…Mar 1, 1986 · N6110X · Substantial damageNTSB DEN86LA087Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Red Lodge, MTThe plt stated that during the ground roll phase of landing at Red Lodge, MT, he lost control of the acft which entered into a ground loop to the right. Just prior to the acft departing the right side of the rwy, he applied maximum braking, and the acft nosed…Mar 1, 1986 · N1503E · Substantial damageNTSB DEN86LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wisdom, MTThe student plt departed minden, NV on an unauthorized x-co flt that terminated in the accident at Wisdom, MT. During the landing roll at an abandoned arpt at Wisdom, the nose of the acft dug into the snow covered runway and the acft nosed over. The plt…Mar 1, 1986 · N69043 · Substantial damageNTSB CHI86LA095Accident · No injuriesLimited investigationFinal reportCessna 172C · Waupun, WIDrg arrival for a x-wind landing, the plt made a high apch & used full flaps to steepen his dscnt over trees near the apch end of the rwy. He stated that the touchdown was normal, but before he could raise the flaps, the x-wind pushed the plane to the left.…Mar 1, 1986 · N1636Y · Substantial damageNTSB NYC86LA080Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Rochester, NYOn landing roll left gear collapsed, airplane swerved left, came to a stop. Airplane substantially damaged. No fire. No injuries.Feb 27, 1986 · N36638 · Substantial damageNTSB FTW86LRG14Accident · No injuriesFinal reportPiper PA-18 · Uvalde, TXThe acft collided with mesquite brush during a landing on a ranch airstrip. The plt overcorrected and the acft touched down in a crab to the right. The plt applied the brakes & the acft nosed over.Feb 27, 1986 · N6798A · Substantial damageNTSB DEN86LA084Accident · No injuriesLimited investigationFinal reportCessna 150L · Watford City, NDThe acft made a hard landing on rwy 30 at Watford City muni arpt, ND, and was substantially damaged. The student plt said the accident occurred on the third touch-and-go. The plt said he used only 10 degrees of flaps. He noted some turbulence and an increase…Feb 27, 1986 · N16210 · Substantial damageNTSB DEN86LA085Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Estelline, SDAccording to the student plt, during the landing roll on a public road, the acft he was piloting encountered a crosswind which tipped the left wing up. The student plt indicated the acft nosed over onto its back. The plt had purchased the acft aprx 1 hr prior…Feb 25, 1986 · N5721D · Substantial damageNTSB DEN86IA083Incident · No injuriesIncident investigationFinal reportCessna T207A · Longmont, COAccording to the FAA examiner, the plt whom he was giving a checkride to applied full brakes during the short field landing, causing both tires to fail.Feb 25, 1986 · N6385H · Minor damageNTSB LAX86LA125Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodland, CAA Cessna 150 collided with the runway surface after the nose wheel collapsed. The student pilot indicated that during the landing flare his attention was diverted by an object that flashed into his view. He overflared to avoid the object and landed hard on…Feb 24, 1986 · N6188K · Substantial damageNTSB MKC86LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gardner, KSThe ip and student had been practicing landings at another airport and was landing at this airport for fuel. There was a crosswind at the airport and the ip made the approach and landing. A witness stated that the touchdown was three point in the Cessna 170A…Feb 23, 1986 · N1493D · Substantial damageNTSB LAX86LVM02Accident · No injuriesFinal reportBellanca 7ECA · San Jose, CAThe acft ground looped to the left after landing. The student plt said he attempted with rudder and aileron to regain directional control but failed. After rolling into the grass the acft nosed over. The plt said he should have held the stick back to assure…Feb 23, 1986 · N53893 · Substantial damageNTSB FTW86LPA20Accident · Serious injuriesFinal reportBalloon Works Fire FLY 7 · Keller, TXThe Balloon descended into a power line during landing at a mobile home park. The plt said that he did not see the wires until they were silhouetted against the horizon. He then tried to expedite the venting of hot air from the envelope to go under the wires.…Feb 23, 1986 · N2269H · Substantial damageNTSB MKC86LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · Alliance, NEThe plt had just completed a biennial flight review in Alliance, Nebraska and was returning to land on his ranch property south of Alliance. Wind rpts fm the Alliance airport, and the FAA flight service station in scottsbluff, indicated winds generally fm the…Feb 21, 1986 · N3400C · Substantial damageNTSB DCA86AA018Accident · Minor injuriesFinal reportMcDonnell Douglas DC-9-31 · Erie, PADrg arrival, the crew of us air flt 499 lndd on rwy 24, which was cvrd with snw. Rprtdly, while lndg, the acft touched dwn aprx 1800 to 2000' bynd the displaced threshold. Altho armed, the spoilers did not auto-deploy, so the capt operatedthem manually. He…Feb 21, 1986 · N961VJ · Substantial damageNTSB NYC86FA077Accident · 1 fatalField investigationFinal reportCessna 172N · Andover, NJThe student plt had difficulty landing the acft and instructor had devoted training session to landing technique. The difficulty was reported to be a tendency to over-flare prior to touchdown. Satisfied the student had corrected his problem area, the third…Feb 20, 1986 · N739SP · DestroyedNTSB FTW86LRG13Accident · No injuriesFinal reportRobinson R-22 · Austin, TXAcft was substantially damaged when it experienced a hard landing and severed the tailboom. Plt initially stated that the eng had 'missed' during pwr application at the bottom of a norm approach. Later he stated that he had been practicing touchdown…Feb 20, 1986 · N9062Z · Substantial damageNTSB FTW86LRD07Accident · No injuriesFinal reportMBB BO-105-CBS · Lake Charles, LAThe helicopter was simulating a single eng landing on an area marked to the size of an offshore helideck. The acft touched down hard enough to attract the attention of several witnesses. The crew continued with the training but later on post flt exam they…Feb 20, 1986 · N425EH · Substantial damageNTSB DEN86LA081Accident · No injuriesLimited investigationFinal reportCessna 152 · Alameda, NMThe student plt stated that during the landing, the aircraft bounced twice before it's nose gear collapsed. The student pilot said the aircraft nosed over onto its back following the nose gear collapse.Feb 19, 1986 · N6353M · Substantial damageNTSB ATL86LA078Accident · No injuriesLimited investigationFinal reportCessna 172N · Washington, NCThe student pilot stated that the aircraft encountered a gust of wind during landing flare causing the aircraft to drift to the left upon touchdown. In an attempt to correct for the drift the student pilot applied left brake pressure as well as left rudder…Feb 19, 1986 · N1975E · Substantial damageNTSB MKC86LA060Accident · No injuriesLimited investigationFinal reportBeech N35 · Hot Springs, ARThe pilot stated that he was on the landing roll and reached for the flap switch and moved the landing gear switch instead. The landing gear then retracted.Feb 18, 1986 · N9398Y · Substantial damageNTSB MKC86LA061Accident · Minor injuriesLimited investigationFinal reportSchweizer G164-B · Colt, ARThis was a new acft which the owner was ferrying from the dealer to his private ag strip. The landing was made to the north on a half mile long grass strip and the wind was calm. The plt reports that the brakes were locked when the acft touched down and the…Feb 17, 1986 · N3630K · DestroyedNTSB NYC86LA075Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Indiana, PACessna 182 landed in deep snow off the right side of the runway. The aircraft touched down hard broke the nose wheel and the Cessna flipped over and received substantial damage. There was no fire. There were no injuries to the pilot and one passenger.. The…Feb 16, 1986 · N71770 · Substantial damageNTSB CHI86LA088Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Frankfort, ILFollowing a descent through icing conditions the plt was told by the UNICOM operator that the active rwy was 'slippery'.the plt landed aprx 600-700 ft down the 3176 ft rwy and found that the braking action deteriorated from poor to nil during rollout. He…Feb 16, 1986 · N8663K · Substantial damageNTSB MIA86LA079Accident · No injuriesLimited investigationFinal reportBeech 55 · Ft. Myers, FLThe plt stated that he had experienced an electrical failure & because it was getting dark, he could not see the mechanical landing gear position indicator. He said that he performed a 'gump' check & verified that the gear handle was in the down position, but…Feb 15, 1986 · N163Q · Substantial damageNTSB MIA86LA078Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Clewiston, FLThe plt stated that a x-wind caused him to lose control of the acft while attempting to land on a x-country flt. The acft departed the rwy and struck a ditch. The plt indicated that no pre-flt wx briefing was obtained prior to departure.Feb 15, 1986 · N8886U · Substantial damageNTSB ANC86LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Mccarthy, AKThe pilot stated that he touched down too hard and the main wheels broke through the crust on the snow. The pilot lost control of the aircraft causing the plane to nose over on its back.Feb 15, 1986 · N70308 · Substantial damageNTSB CHI86LA086Accident · No injuriesLimited investigationFinal reportCessna 172N · St. Cloud, MNThe plt was diverting into galesburg due to bad weather at his original destination. Following an ILS approach at galesburg he spotted the rwy at '200 ft plus' off to his right. He then 'side-stepped' to the right but touched down in a crabbed angle. He…Feb 14, 1986 · N5466D · Substantial damageNTSB LAX86LA119Accident · Minor injuriesLimited investigationFinal reportBeech E18S · Kalaupapa, HIThe acft crashed off the end of rwy 23 during an attempted go-around after touchdown. The plt stated that after the acft touched down aprx 300 ft down the 2,760 foot rwy he raised the flaps along with the nose of the acft to slow down. Brakes were applied and…Feb 13, 1986 · N30Y · DestroyedNTSB MIA86LA074Accident · No injuriesLimited investigationFinal reportHughes 269C · Vero Beach, FLDuring auto-rotation practice, the CFI passed control of the helicopter to the student plt. At aprx 10 ft above the ground, the CFI attempted to apply corrective action when it became apparent that the acft was going to make a hard landing. The attempt was…Feb 12, 1986 · N58275 · Substantial damageNTSB ANC86LA026Accident · 1 fatalLimited investigationFinal reportPiper PA-28-235 · Mcgrath, AKThe pilot had been drinking for an unknown period before undertaking the night flight. After takeoff, the acft was observed flying in the local area in an erratic manner. Subsequently, the acft crashed about .6 mi short of rwy 16. Impact occurred at the base…Feb 9, 1986 · N7071C · Substantial damageNTSB LAX86LA118Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Carlsbad, CAThe acft ran off the end of rwy 24 at the mcclellen-palomar arpt. Light rain was reported at the time and the winds were reported to the plts as being from 340 degs at 10 KTS. The rwy is constructed of a porous friction course (pfc) material which provides…Feb 8, 1986 · N14DM · Substantial damageNTSB LAX86LA116Accident · No injuriesLimited investigationFinal reportCessna 182M · Healdsburg, CAOn February 8, 1986, at 1430 PST a Cessna 182, N91614, overran the landing surface and nosed over at a dirt strip. VMC prevailed at the time. The winds were generally calm with sporadic gusts from the north at approximately 10 knots. There was no indication…Feb 8, 1986 · N91614 · Substantial damageNTSB LAX86LA115Accident · No injuriesLimited investigationFinal reportCessna 140 · Rancho Murieta, CAOn February 8, 1986 at 1530 PST a Cessna 140 landed hard and nosed over on the runway. VMC prevailed at the time. The pilot indicated that on landing he flared too high and landed hard. His feet slipped on the pedals and inadvertently applied the brakes which…Feb 8, 1986 · N89447 · Substantial damageNTSB LAX86LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · San Jose, CAA Cessna 152 collided with the runway surface after the nose gear separated. The aircraft flared too high and bounced on landing. On the second bounce the nose gear separated. The flight instructor took over the controls and landed the aircraft on the nose…Feb 7, 1986 · N95139 · Substantial damageNTSB ANC86LA025Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6 · Mekoryuk, AKThe PIC stated that he was landing to the southwest because the fog was obscuring the apch path to rwy 05. After aligning with rwy 23, the acft drifted off course. The plt was attempting to realign the acft with the rwy when he touched down in a bank and…Feb 7, 1986 · N204EH · Substantial damageNTSB CHI86LA082Accident · No injuriesLimited investigationFinal reportCessna 340R · Galesburg, ILThe pilot was diverting into Galesburg due to bad weather at his original destination. Following an ILS approach at Galesburg he spotted the runway at '200 ft plus' off to his right. He then 'side-stepped' to the right but touched down in a crabbed angle. He…Feb 5, 1986 · N3849G · Substantial damageNTSB MIA86IA069Incident · No injuriesIncident investigationFinal reportPiper PA-60 · Folkston, GAThe plt stated that while on a flight from tampa, to jacksonville FL, he made an unauthorized deviation & landed at davis field Folkston ga, where the left main landing gear collapsed. Post crash examination of the acft revealed that the gear collapsed due to…Feb 2, 1986 · N9784Q · Minor damageNTSB DEN86LA074Accident · No injuriesLimited investigationFinal reportCessna T210M · Truth Or Conseq, NMAccording to the pilot, during the landing roll he is accustomed to keeping the nose gear off the runway until the ground speed has slowed. The pilot stated he did not check the landing gear condition lights. Upon lowering the nose, the acft propeller and…Feb 2, 1986 · N761JP · Substantial damageNTSB NYC86LA067Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Vincentown, NJThe pilot stated that a normal approach and a 3 point landing were made at the red lion airport. However after the aircraft rolled for 2-3 seconds, it started to drift to the right. Left rudder was applied, but there was no response. The pilot then applied…Feb 1, 1986 · N55047 · Substantial damageNTSB SEA86LA050Accident · No injuriesLimited investigationFinal reportCessna T210-H · Cascade Locks, ORDuring landing roll on the 1800 foot long 30 foot wide wet runway, the aircraft veered right off the runway and then nosed over. The pilot applied brakes twice with no effect and the third time they grabbed. No malfunctions were found during inspection or…Jan 30, 1986 · N1TF · Substantial damageNTSB MIA86LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe student pilot, on his third supervised solo flight, lost control of the aircraft during the landing roll and collided with an aircraft parked south of the runway.Jan 30, 1986 · N68223 · Substantial damageNTSB FTW86LRG12Accident · No injuriesFinal reportFairchild 24R-46A · Lakeway, TXThe dual instructional flight terminated in a crosswind landing with the rated pilot receiving dual instruction manipulating the controls. During the landing rollout directional control was lost and the aircraft veered to the left. According to the instructor…Jan 27, 1986 · N81348 · Substantial damageNTSB LAX86LA100Accident · Minor injuriesLimited investigationFinal reportErcoupe E · Apple Valley, CAThe plt stated that the acft's eng lost power and the acft flipped over during an attempted forced landing on a dirt road in front of his residence. A witness stated that the acft made three low passes over the dirt road prior to touchdown. A witness…Jan 26, 1986 · N94798 · Substantial damageNTSB CHI86LA078Accident · No injuriesLimited investigationFinal reportMooney M20-K · Madison, WIA gear up landing was performed by the pilot. He stated that he was distracted by an airliner ahead of him in the pattern and did not consult his before landing checklist. He also stated that he had not flown much in the last three months.Jan 26, 1986 · N1156C · Substantial damageNTSB SEA86LA048Accident · No injuriesLimited investigationFinal reportCessna 206 · Wenatchee, WAThe pilot diverted from his intended destination of pangborn field to a local private airstrip due to local fog. 8' of crusted snow was present on the runway and the aircraft nosed over on landing roll.Jan 25, 1986 · N8785Q · Substantial damageNTSB LAX86LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Lake Havasucity, AZOn January 25, 1986 a Cessna 182 collided with the runway surface after the nose wheel collapsed on runway 5 at lake havasu city airport, Arizona. VMC prevailed at the time with the UNICOM reported winds from 270 degrees at 17 knots and gusting. The…Jan 25, 1986 · N2302X · Substantial damageNTSB CHI86LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Baraboo, WIThe plt attempted a x-wind landing that was beyond his capabilities. He stated that if the x-wind was excessive he intended to divert to another arpt with a more favorable runway. At touchdown the aircraft drifted right into a two foot high snow bank off the…Jan 25, 1986 · N46675 · Substantial damageNTSB ANC86LA023Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot stated that during the landing roll he lost directional control of the aircraft. The aircraft struck a row of trees of the end of the landing area.Jan 25, 1986 · N3992M · Substantial damageNTSB MKC86LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Bancroft, IAThe plt became disoriented on a night, VFR flt and landed at an arpt to determine his location. The unattended arpt did not have a phone so the plt tookoff again enroute to his original dest. He became disoriented a second time and, because the acft was…Jan 24, 1986 · N7595U · Substantial damage