OpenAirDocs.org

NTSB investigations

53,703 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 NYC87LA110Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bridgeport, NJThe pilot was making a night landing to Bridgeport airport when he lost directional control of the aircraft and it veered to the left. The airplane continued to roll off the end of the runway and collided with trees.Apr 2, 1987 · N75336 · Substantial damageNTSB MKC87LA074Accident · No injuriesLimited investigationFinal reportCessna A185F · Topeka, KSThe tower stated the aircraft made a hard bounce and when it touched down again, the right gear collapsed. The airplane landed on runway 3 with winds from 350 degrees at 17 knots, gusts to 32 knots. Runway 3 was the best runway to use at the time.Apr 2, 1987 · N1467F · Substantial damageNTSB MIA87LA130Accident · No injuriesLimited investigationFinal reportCessna 310D · Miami, FLThe plt stalled the acft prior to touchdown resulting in a hard landing. According to FAA personnel at Oklahoma city, the plt holds a private plt certificate with a single eng land rating and was not rated in the Cessna 310D aircraft.Apr 2, 1987 · N6880T · Substantial damageNTSB MKC87LA073Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Halstead, KSThe PIC rptd lndg long on a 2600 ft sod rwy. During the lndg roll, the PIC rptd encountering a tailwind. The closest fss at wichita, 20 mi fm the accident arpt, rptd no significant wind chg during this period, the PIC, knowing that he had landed long and…Apr 1, 1987 · N733PX · Substantial damageNTSB MIA87LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Orlando, FLThe nose gear collapsed following a hard landing due to the student plts failure to adequately flare the acft.Apr 1, 1987 · N95904 · Substantial damageNTSB FTW87LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Laverne, OKDuring a downwind landing, the aircraft ran off the end of the runway contacting a barbed wire fence and subsequently a muddy field, substantially damaging the aircraft by shearing the landing gear off and tearing the wings on the top and bottom surfaces.Apr 1, 1987 · N31681 · Substantial damageNTSB DEN87LA078Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Englewood, COThe student plt said the acft ballooned during the flare and he applied forward stick. The acft touched down nose wheel first and the nose gear collapsed. The acft then settled hard on main gear resulting in additional damage.Apr 1, 1987 · N114PA · Substantial damageNTSB LAX87LA164Accident · No injuriesLimited investigationFinal reportBeech S35 · Tucson, AZThe aircraft door came open during the initial climb after takeoff because it was not properly closed and locked. The pilot raised the landing gear. Thereafter, because of slow acceleration, he elected to land on the remaining runway. He moved the landing…Mar 31, 1987 · N13W · Substantial damageNTSB LAX87LA162Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Paula, CAAt the end of a pleasure cross country flt the plt prior to entering the pattern noted the wind direction and speed as 060 degs at aprx 16 KTS. The plt then entered the pattern for rwy 4. On final apch the plt had to slip the acft to keep alligned with the…Mar 30, 1987 · N6339K · Substantial damageNTSB LAX87LA159Accident · No injuriesLimited investigationFinal reportJones Pitts Special S1A · Franklin, CADuring the landing roll, the pilot was unable to maintain directional control when a gust of wind from the right pushed the aircraft off the left side of the runway. The aircraft collided with the terrain and nosed over. There was no mechanical failure or…Mar 29, 1987 · N9GD · Substantial damageNTSB SEA87LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Newberg, ORSeated at the controls in the left front seat was a plt who had not flown in ten years. Seated in the right front seat was the owner/student plt. The purpose of the flt according to the plt, was to familiarize the plt with the acft so that the plt could…Mar 28, 1987 · N4298T · Substantial damageNTSB MKC87LA068Accident · No injuriesLimited investigationFinal reportCessna 150F · Fremont, MOThe student pilot got off course on the first leg of his solo cross-country flight. He landed at an airport for fuel and directions, but the airport was deserted. When he departed for a nearby airport, he could not find that airport. After the student pilot…Mar 28, 1987 · N6978F · Substantial damageNTSB MIA87LA121Accident · No injuriesLimited investigationFinal reportCessna 310L · Venice, FLThe left main landing gear collapsed during the landing roll after the plt inadvertently retracted the landing gear instead of the flaps. The pilot left the scene of the accident and his identity is unknown.Mar 28, 1987 · N3304X · Substantial damageNTSB LAX87LA166Accident · No injuriesLimited investigationFinal reportCessna 310 · Agua Dulce, CAThe non-multiengine rated pilot attempted to land his multiengine airplane on a 4600 foot runway. The aircraft touched down approximately half way down the runway and slid off the departure end. The aircraft impacted trees after departing the runway.Mar 28, 1987 · N223H · Substantial damageNTSB FTW87LA085Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Palestine, TXDuring flare/touchdown the pilot lost control of the aircraft due to a crosswind. The pilot attempted a go-around but contacted some trees off the right side of the runway causing substantial damage to the wings, tail and landing gear.Mar 28, 1987 · N22064 · Substantial damageNTSB FTW87LA084Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Many, LAAcft received substantial damage when it ran off the end of a 3,300' pvt airstrip into a lake during an attempted go around. The winds were calm. The plt reported that he landed long and fast over trees at the threshold and delayed initiating a go around…Mar 28, 1987 · N2946Y · Substantial damageNTSB DEN87LA076Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Cavalier, NDThe pilot was landing with a cross wind. The aircraft bounced and drifted into snow bank along the right edge of the runway. The nose gear was broken off in the collision with the snow bank and the engine was pushed into the firewall.Mar 28, 1987 · N2848V · Substantial damageNTSB MIA87LA120Accident · No injuriesLimited investigationFinal reportCessna 210C · Ponch, PRThe acft was found abandoned in a sugar beet field with the landing gear collapsed. Information pertaining to the occupant(s), history of flt, and facts pertaining to the accident could not be determined. Injury index presumed.Mar 27, 1987 · N3643Y · Substantial damageNTSB DEN87LA073Accident · No injuriesLimited investigationFinal reportMooney M20C · Wahpeton, NDA CFI and a dual student were making practice landings. On the sixth landing, the student failed to lower the landing gear. The CFI did not notice that the acft did not have landing gear extended. The acft landed with gear fully retracted.Mar 27, 1987 · N6550U · Substantial damageNTSB ATL87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Toccoa, GAThe pilot overshot runway 20 and skidded off the departure end which caused substantial damage to the aircraft. The pilot stated that he should have descended to the normal visual traffic pattern altitude before attempting a landing. There were no reported…Mar 27, 1987 · N3042U · Substantial damageNTSB DEN87LA072Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Greeley, CODuring landing roll, after a normal pattern, an unusual noise was heard by the pilot. He described it as a 'thud' or a loud 'pop' noise. The pilot lost directional control and departed the runway to the left. The landing gear was severely damaged. No prempact…Mar 26, 1987 · N8793V · Substantial damageNTSB ATL87LA096Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensboro, KYDuring a solo practice flight, the 16 hour student pilot touched down on rwy 23 at 70 KIAS and allowed the aircraft to bounce out of control and land hard on the nose landing gear. After the third bounce, the nose gear collapsed and the acft skidded to a…Mar 26, 1987 · N757LM · Substantial damageNTSB MKC87LA065Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Houston, MOThe airplane was on an IFR flight plan and five miles from the airport, the airplane broke out of the clouds and proceeded VFR to the airport. It was a dark night and light rain was falling. The pilot stated he flew over the airport twice looking for a wind…Mar 24, 1987 · N38077 · Substantial damageNTSB BFO87DID02Accident · Serious injuriesFinal reportEagle Balloons C-7 · Montvale, VAThe balloon plt selected a downsloping field with powerlines at the apch end and woods at the upwind end in which to land. On touchdown, the basket tipped over and the plt was pulled from the basket by his grip on the crown valve line. The balloon began to…Mar 22, 1987 · N60765 · Minor damageNTSB ATL87LA091Accident · No injuriesLimited investigationFinal reportChampion 7FC · Bellefontaine, OHThe acft was landed on rwy 04 with the wind from the east at eight KTS. The flight was the first solo in a tail wheel equipped acft for the plt. He had obtained no formal instruction in a tail wheel acft but had flown with a friend. On landing the acft…Mar 22, 1987 · N90398 · Substantial damageNTSB NYC87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Rutland, VTDrg arrival, the plt was cleared for an lda/ndb apch to rwy 19. When she 'went visual' on the apch, a check of the VASI showed she was hi, so she slipped the acft to lose alt. The winds were rprtd as light & variable, but plt rprtd that drgthe lndg, there was…Mar 21, 1987 · N2083K · DestroyedNTSB NYC87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Du Bois, PAThe student plt initiated a touch-&-go landing on rwy 7 with a left, quartering headwind. He rprtd that when the acft was at about 10 ft AGL with the left wing 'dipped' into the wind, the left wing & nose dropped & the plane impacted the rwy. The acft then…Mar 21, 1987 · N67911 · Substantial damageNTSB FTW87GA083Accident · No injuriesFinal reportBell 47G-3B-1 · Odessa, TXInvestigation reveals the helicopter touched down on the heel of its skids, left skid first, and at a slightly low rotor RPM. The tail boom then moved upward while the main rotor blades flexed downward. The main rotor blades contacted and severed the tail…Mar 21, 1987 · N62462 · Substantial damageNTSB ATL87LA092Accident · No injuriesLimited investigationFinal reportMooney M20 · Frankfort, KYDuring the final phase of the approach procedure, the pilot failed to extend the landing gear. The aircraft touched down, skidded along the runway surface until it finally came to rest. The pilot reported that the fuel strainer failed and a fire started and…Mar 20, 1987 · N5251B · DestroyedNTSB SEA87LA065Accident · No injuriesLimited investigationFinal reportCessna 150 · Las Vegas, NVDuring landing a gust of wind occurred from the right. The student pilot was not able to correct for the wind and lost control of the aircraft. The aircraft veered to the left of the runway onto rough terrain and then nosed over inverted.Mar 18, 1987 · N457AF · Substantial damageNTSB MIA87LA112Accident · No injuriesLimited investigationFinal reportCessna 182C · Branford, FLThe plt was unable to locate his postion, & with wx conditions deteriorating & darkness approaching, elected to land in a field. Upon touchdown, the nose gear broke off, the acft nosed over & came to rest inverted.Mar 18, 1987 · N8698T · Substantial damageNTSB SEA87FA064Accident · No injuriesField investigationFinal reportCessna 402A · Walla Walla, WADuring lndg roll the rt main lndg gear of the Cessna 402A collapsed. Visual inspection of the bell crank assembly revealed fracture surfaces similar to those of instantaneous overload.Mar 17, 1987 · N4549Q · Substantial damageNTSB CHI87LA098Accident · No injuriesLimited investigationFinal reportHughes 269B · South Bend, INAccording to the plt, after departure from aurora municipal airport, he landed at an airfield west of elgin, Illinois and picked up the two passengers. The plt stated that he then departed for elkhart, Indiana. According to an Indiana state police aircraft…Mar 17, 1987 · N9522F · Substantial damageNTSB ANC87LA052Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Fairbanks, AKThe student pilot lost control of the acft which ground looped during a stop and go landing roll. Inspection revealed the right brake master cylinder actuator rod failed.Mar 17, 1987 · N3008Z · Substantial damageNTSB MIA87LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLThe plt stated that upon landing on runway 22, as he added power to takeoff again the acft started to veer to the left and no matter how much right rudder he used, the acft still veered left and went off the side of the runway into the grass, spun around and…Mar 16, 1987 · N218JA · Substantial damageNTSB CHI87LA096Accident · No injuriesLimited investigationFinal reportCessna 172E · Muncie, INAccording to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According…Mar 16, 1987 · N7757U · Substantial damageNTSB MIA87LA110Accident · No injuriesLimited investigationFinal reportCessna 170A · Brandon, FLUpon touchdown the right landing gear separated from the acft due to a hard landing.Mar 15, 1987 · N1352D · Substantial damageNTSB MIA87LA109Accident · No injuriesLimited investigationFinal reportBeech A23 · Palatka, FLThe pilot stated that he 'had to make downwind landing due to traffic & direction from UNICOM operator. Landing was fast due to downwind, but not hard. Nose wheel collapsed during rollout with stall warning blowing. Plane gently nosed over & stopped at the…Mar 15, 1987 · N8883M · Substantial damageNTSB MIA87LA108Accident · No injuriesLimited investigationFinal reportLet L-13 · Brooksville, FLOn final apch, with full flaps extended, the glider began to float down the rwy. The plt then retracted them, after which, it descended, collided with a fence, & came to rest in a field.Mar 14, 1987 · N68PE · Substantial damageNTSB LAX87LA144Accident · Minor injuriesLimited investigationFinal reportCessna 414A · Chinle, AZThe plt rprtd the rwy lights on one side of the rwy were inop & that he made an apch to the wrong side of the lights. When he realized the acft was not aligned with the rwy, he initiated a go-around. However, as he started to go-around, the acft hit a fence…Mar 14, 1987 · N26864 · Substantial damageNTSB FTW87LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Roanoke, TXAircraft ballooned twice after touchdown followed by hard landing on nosegear resulting in substantial damage.Mar 13, 1987 · N64943 · Substantial damageNTSB BFO87LA030Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Norfolk, VAThe tower cleared the aircraft to land on runway 35 at Norfolk international airport with winds from 010 degrees at 20 to 25 knots. The pilot stated that all other traffic was using runway 05. During landing roll the aircraft started to drift to the right,…Mar 13, 1987 · N8218E · Substantial damageNTSB ATL87LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Bolivar, TNThe student plt reported that he flared excessively during touchdown while practicing a touch & go landing, causing the airplane to balloon. The airplane subsequently touched down again and headed toward the left side of the rwy. The student plt stated that…Mar 13, 1987 · N25503 · Substantial damageNTSB MIA87LA106Accident · Minor injuriesLimited investigationFinal reportHughes 364HS · Opa Locka, FLThe pilot of the helicopter was executing a normal approach to the ground when as he neared the ground the ventral fin struck the ground. The tail rotor driveshaft re-centered and the pilot thought the accompanying shudder was a tail rotor failure, and landed…Mar 12, 1987 · N4507C · Substantial damageNTSB CHI87LA095Accident · No injuriesLimited investigationFinal reportBeech C24R · Manitowoc, WIPilot flared too high on landing. Aircraft landed hard and nose wheel broke off.Mar 12, 1987 · N1824P · Substantial damageNTSB ANC87LA048Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKThe pilot stated that after touchdown and about 150 feet of the roll, the pilot lost directional control causing the aircraft to exit the gravel runway and striking two parked aircraft.Mar 12, 1987 · N61537 · Substantial damageNTSB ANC87LA047Accident · No injuriesLimited investigationFinal reportCessna 150D · Anchorage, AKThe pilot-in-command was a certificated flight instructor with prior experience in tail wheel airplanes, but had not flown a Cessna 150 tail wheel conversion and wished to familarize himself with the airplane by a series of touch and go landings. The pilot…Mar 12, 1987 · N5972T · Substantial damageNTSB MIA87LA105Accident · No injuriesLimited investigationFinal reportCessna A152 · Cocoa, FLThe plt stated that after touchdown the acft was blown off the left side of the rwy, after which, it collided with trees & came to rest. According to the plt's operating handbook the max demonstrated crosswind velocity is 12 KTS. At the time of the accident…Mar 11, 1987 · N4649A · Substantial damageNTSB NYC87LA104Accident · No injuriesLimited investigationFinal reportSwearingen SA-226AT · Jamaica, NYThe flight landed at kennedy international airport with the landing gears retracted due to a failure of the right main landing gear extension system.Mar 10, 1987 · CGJWW · Substantial damageNTSB MKC87LA059Accident · Minor injuriesLimited investigationFinal reportCessna 320E · Point Lookout, MOThe student plt landed the acft and allowed it to slow before applying brakes. The student stated, the acft then began veering to the right side of the rwy. Attempts by the student and CFI to correct the situation were ineffective and the acft departed the…Mar 10, 1987 · N712SF · Substantial damage