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 MIA86LA107Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Ft. Lauderdale, FLThe non-certificated student plt was making an unauthorized night solo x-country flt. He attempted a landing at his destination with a left 60 deg, 12 kt x-wind. During the landing roll the acft veered to the right and the plt correctedby applying 'extreme'…Mar 29, 1986 · N28007 · Substantial damageNTSB CHI86LA110Accident · No injuriesLimited investigationFinal reportCessna 172MM · Middleton, WIThe 94 hour private pilot was attempting a landing with a crosswind component of 90 degrees and a wind velocity of 15 to 18 KTS gusting to 22 KTS when he touched down with the right main gear & 2 feet off the right side of the runway. The right main gear came…Mar 28, 1986 · N20866 · Substantial damageNTSB CHI86LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Lacon, ILThe pilot stated he was maintaining a steep approach angle to clear trees at the approach end of the 2200 ft. runway. He flared late, landing hard and damaging the firewall.Mar 27, 1986 · N3187T · Substantial damageNTSB MKC86LA075Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Salem, ARThe acft was landing on a 2,050 by 100 ft asphalt rwy. The plt said the touchdown was not hard but not smooth. The acft traveled about 300 ft after touchdown before the r MLG collapsed. The broken parts which were removed from the landing gear assembly were…Mar 26, 1986 · N2889M · Substantial damageNTSB MKC86LA074Accident · No injuriesLimited investigationFinal reportBeech G18S · Cedar Rapids, IAThe pilot was aware that he would have a strong crosswind on landing. He was landing on runway 13 with winds from 180 degrees at 20 knots, gusting to 30 knots. The pilot stated that while the airplane was rolling down the runway, the right wing was lifted by…Mar 25, 1986 · N528 · Substantial damageNTSB MIA86LA105Accident · No injuriesLimited investigationFinal reportCessna 150L · St. ThomasThe student plt was on a supervised solo flt practicing to & ldgs. On the last ldg, the wind caught the acft & the plt attempted to recover without adding power. Control of the acft was lost & the plt attempted to force the acft back onto the rwy. The acft…Mar 25, 1986 · N11505 · Substantial damageNTSB LAX86LA153Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeport, CAWitnesses reported that they observed the plt make 2 approaches and landings prior to the accident. On the landing just before the accident, they observed an 'extremely hard landing on the nose gear.' They reported that the plt then taxied back to takeoff…Mar 25, 1986 · N4863F · Substantial damageNTSB DEN86LA104Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Falcon, COAccording to the plt, when the acft slowed after landing, it turned 'sharply to the right.' The plt stated he experienced 'extreme tailwheel shudder' prior to this during the landing roll. During the investigation, it was ascertained that the tailwheel spring…Mar 25, 1986 · N9614S · Substantial damageNTSB ATL86LLT08Incident · No injuriesFinal reportPiper PA-34 · Smithville, TNThe acft ran off the departure end of the rwy during landing. The acft reportedly landed 1/2 way down the 3400 ft rwy. The plt stated in a post acc interview that he was 'too high too fast and too long.'Mar 25, 1986 · N3951X · Minor damageNTSB ATL86LA101Accident · No injuriesLimited investigationFinal reportCessna 172N · Advance, NCWhile on final apch to rwy 27,plts vision restricted by sun glare. Plt indicated that he was high & fast and landed too long to allow go around. Overran runway, nose gear mired and acft nosed over.Mar 25, 1986 · N737DR · Substantial damageNTSB LAX86LA152Accident · No injuriesLimited investigationFinal reportCessna C-152T · Fresno, CAA Cessna 152 collided with terrain after running off rwy 29L. The plt indicated he made a go-around on first approach due to difficulty maintaining rwy heading. On second approach he was aligned a little left of centerline and elected to land. The acft…Mar 24, 1986 · N49420 · Substantial damageNTSB ANC86LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe flight instructor stated that he was demonstrating a stall landing to the student pilot. After touchdown and rollout the aircraft struck a snow drift on the runway causing the aircraft to nose over on its back.Mar 24, 1986 · N7145K · Substantial damageNTSB NYC86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Danbury, CTPilot touched down long on 3135 foot runway, exceeding the braking action of the aircraft, ran off end of runway into a ditch causing substantial damage to the aircraft. The pilot, the sole occupant received no injuries.Mar 23, 1986 · N80021 · Substantial damageNTSB MIA86LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hollywood, FLThe plt stated that while flaring to land, a gust of wind picked up his right wing & before he could recover he lost control & the acft ground looped.Mar 23, 1986 · N9169T · Substantial damageNTSB FTW86LPA16Accident · No injuriesFinal reportCessna 188 · Atlanta, TXThe pilot lost directional control of the aircraft during the landing roll. It then departed the runway and ran into a drainage ditch which collapsed the main landing gear.Mar 22, 1986 · N6009G · Substantial damageNTSB ANC86LA040Accident · No injuriesLimited investigationFinal reportCessna 170-B · Whittier, AKThe pilot stated that after touchdown he realized that the snow was soft. The aircraft nosed over on its back.Mar 22, 1986 · N1999C · Substantial damageNTSB MKC86LA072Accident · No injuriesLimited investigationFinal reportJim Elliott VP-2 · Scott City, KSThe plt was making his first flt in the acft which is powered by a volkswagon, 1,834 cc eng. The acft became airborne from a hard surface rwy and climbed to about 100 ft AGL. The plt said the controls felt mushy and when he attempted to climb the airspeed…Mar 21, 1986 · N32JE · Substantial damageNTSB DEN86FA101Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Albuquerque, NMThe acft crashed on the second aborted takeoff attempt. The plt said that the acft was not accelerating properly on the first attempt and that the eng lost power on the second attempt. Ground witnesses said that the air conditioner condenser door was open and…Mar 21, 1986 · N555EB · DestroyedNTSB NYC86IA109Incident · No injuriesIncident investigationFinal reportSikorsky S-76 · Atlantic City, NJDuring a preflight examination of a Sikorsky S76 the instructor and student discovered a hole in the leading edge of the pylon above the intermediate gear box and scuff mark on the main rotor blade caps. The instructor and student had just completed a 2.1 hr…Mar 20, 1986 · N38 · Minor damageNTSB LAX86LA148Accident · No injuriesLimited investigationFinal reportCessna 140 · Rio Linda, CAOn March 20, 1986, a Cessna 140 nosed over in mud after running off runway 17. VMC prevailed at the time. The aircraft was substantially damaged and the pilot and his passenger were not injured. The pilot stated he was too fast on his approach and ran off the…Mar 20, 1986 · N89698 · Substantial damageNTSB ANC86LA036Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe student pilot lost control of the aircraft on landing at a winter ice landing strip.Mar 20, 1986 · N3935Z · Substantial damageNTSB MKC86LA070Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Mulvane, KSThe PIC of the acft landed his Cessna 182 to the north on a farm pasture he owns which doubles as a landing strip. The PIC stated he approached too high and too fast, landing about midway of the field. A fence which borders the field was fast approaching with…Mar 19, 1986 · N3379F · Substantial damageNTSB LAX86LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Hayward, CAA Cessna 172P collided with a rwy light after veering off rwy 28. The winds at the time off the accident were reported from 350 deg at 6 KTS. The right main landing gear collapsed when it struck a rwy light damaging the right wing and tail section.Mar 19, 1986 · N52628 · Substantial damageNTSB MKC86LA069Accident · No injuriesLimited investigationFinal reportCessna 172N · Warren, ARThe plt reports that a deer ran in front of the acft during the flare for a night landing. The prop hit and killed the deer and the nose gear and bottom of the eng compartment were damaged. After the collision the plt said he smelled fuel fumes and when the…Mar 18, 1986 · N1530E · DestroyedNTSB FTW86LA045Accident · 1 fatalLimited investigationFinal reportCessna TU206F · Goliad, TXThe pilot apparently failed to properly recover from a bounced landing and broke a landing gear wheel. The aircraft hit and fatally injured a person on the ground. Local authorities believe the persons body was then transported about four miles and thrown…Mar 17, 1986 · N6633T · DestroyedNTSB ATL86LA095Accident · No injuriesLimited investigationFinal reportCessna 150 · Lafayette, TNThe pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.…Mar 17, 1986 · N2618J · Substantial damageNTSB CHI86LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Brooklyn Park, MNUpon initial touchdown the acft bounced. In the process of 're-flaring' the acft it drifted to the egde of the rwy. The solo student plt applied full power to go-around, however, during this maneuver the left wheel hit a snowbank along the edge of the rwy.…Mar 16, 1986 · N4633B · Substantial damageNTSB NYC86LA085Accident · Minor injuriesLimited investigationFinal reportRockwell 680FL · Houlton, METhe pilot-in-command landed on runway 5 which had approximately 1 inch of fresh snow. He reported that he encountered whiteout conditions during the landing & lost reference to the runway centerline. The aircraft touched down on the left side of the runway,…Mar 15, 1986 · N287B · Substantial damageNTSB MKC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Lake City, ARThe flight instructor and his student touched down on the newly constructed private dirt strip in the airplane and rolled for 610 feet before the main gear bogged down. The nosewheel then cocked sideways and the airplane rolled forward to the inverted…Mar 15, 1986 · N9848Y · Substantial damageNTSB SEA86LA101Accident · No injuriesLimited investigationFinal reportBeech 76 · Troutdale, ORThe acft was substantially damaged during a hard landing performed by the multi-enging student during a dual instructional flt.Mar 14, 1986 · N5095M · Substantial damageNTSB MIA86LA096Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Lake Wales, FLThe plt stated that he landed long and was unable to stop. The acft ran off the end of the runway into a lake.Mar 14, 1986 · N9790L · Substantial damageNTSB MIA86FA095Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Florida City, FLThe acft touched down on the top of a flood control dike approx 12 ft wide. The acft continued for about 1336 ft before the left wheel slid off the dike where the dike makes a slight curve to the right. The left gear was torn from the acft as it left the…Mar 14, 1986 · N49984 · DestroyedNTSB DEN86LA100Accident · No injuriesLimited investigationFinal reportCessna A185F · Bozeman, MTAccording to the plt, shortly after touchdown, the right wing came up and the acft seemed to be pushed to the left. The plt said before he regained control, the left wing and horizontal stabilizer contacted the ground. The plt later learned that a Boeing 767…Mar 14, 1986 · N4984Q · Substantial damageNTSB ATL86IA093Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-31 · Charleston, SCThe acft landed on rwy 15 at 2357 EST. The rwy was wet from heavy rain & thunderstorms. Braking was ineffective and the acft failed to stop. The capt steered rt into the mud to the rt side of the overrun. Post accident review of the flt data recorder showed…Mar 14, 1986 · N8924E · Minor damageNTSB BFO86LA019Accident · No injuriesLimited investigationFinal reportCessna 150M · Orange, VAAt about 1245 EST, the plt took off on his second flt of the day and flew in the local area about 30 minutes. Upon returning to Orange county arpt, the plt observed the tetrahedron during the left downwind leg for rwy 25, and noted that the wind had changed…Mar 11, 1986 · N6143K · Substantial damageNTSB ATL86FMG05Accident · No injuriesFinal reportCessna 150 · Yadkinville, NCThe acft was landed improperly and after bouncing two of three times the nose gear separated. The acft then nosed over and suffered further damage to the prop, wings and tail.Mar 11, 1986 · N4752X · Substantial damageNTSB SEA86LA077Accident · No injuriesLimited investigationFinal reportAeronca 7AC · East Sound, WAUpon rollout, a loss of directional control occurred during a wind gust. The pilot elected to go-around. Shortly after lift off, the main gear of the aircraft struck VASI lights. The aircraft then struck the ground.Mar 10, 1986 · N84842 · Substantial damageNTSB DEN86LA097Accident · No injuriesLimited investigationFinal reportMooney M20F · Longmont, COAccording to the plt, during the flare to touchdown, the acft stalled and the left wing contacted the ground along with four runway lights. The plt said the accident could have been prevented by maintaining a higher airspeed on apch.Mar 10, 1986 · N3280F · Substantial damageNTSB BFO86FID04Accident · No injuriesFinal reportCessna 210N · Blacksburg, VAWhile landing at Blacksburg airport in Blacksburg, Virginia, the landing gear failed to extend. The aircraft collided with a runway light and served off the runway onto a grass area causing substantial damage to the left stabilizer and elevator. The pilot…Mar 10, 1986 · N6502C · Substantial damageNTSB ATL86LA088Accident · No injuriesLimited investigationFinal reportCessna 152 · Mocksville, NCDuring landing the student pilot failed to correct for the crosswind. The aircraft drifted off the runway and collided with sock support post.Mar 9, 1986 · N5276M · Substantial damageNTSB ATL86LA091Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Hampton, GADuring landing roll the pilot was unable to keep the tailwheel on the ground and the aircraft nosed over. Post crash examination of the wreckage disclosed that the brake pads were worn down to the rivets.Mar 8, 1986 · N71633 · Substantial damageNTSB LAX86FVA03Accident · Minor injuriesFinal reportSchweizer G164A · Wasco, CAThe acft went off the left side of rwy during a downwind landing. The ag plts made a practice of landing downwind to speed up turn-around time. They relied on their brakes to maintain control. The acc acfts brake pads were worn and the rt brake was fluid…Mar 7, 1986 · N946X · Substantial damageNTSB ATL86LA086Accident · No injuriesLimited investigationFinal reportGrumman American AA5A · Fayetteville, NCDuring landing roll the pilot lost directional control of the aircraft. The aircraft ground looped and swerved off the runway. The pilot stated that he should have been more diligent in correcting for the crosswind condition.Mar 6, 1986 · N26171 · Substantial damageNTSB FTW86FRG16Accident · Minor injuriesFinal reportCessna U206F · Mcallen, TXOn 03-05-86 at 0854 CST a Cessna U206F, N8502Q, was substantially damaged on landing rollout at miller international airport in Mcallen, Texas. There was no fire and the pilot received minor injuries when the electronics cargo fell upon him as the aircraft…Mar 5, 1986 · N8502Q · DestroyedNTSB LAX86LA133Accident · No injuriesLimited investigationFinal reportCessna 152 · San Luis Obispo, CAOn March 4, 1986 a Cessna 152 collided with the runway surface after the nose wheel collapsed. The student pilot was on his third consecutive solo flight since his solo endorsement. On his third approach the aircraft bounced on landing and became airborne…Mar 4, 1986 · N49429 · Substantial damageNTSB SEA86LA072Accident · No injuriesLimited investigationFinal reportPatrick Henry Fokker DR. 1 · Gold Hill, ORPlt attempted spur of the moment landing in open field. Acft wheels sank into soft terrain after touchdown and acft nosed over.Mar 3, 1986 · N35PH · Substantial damageNTSB DEN86LA090Accident · No injuriesLimited investigationFinal reportCessna 180J · Casper, WYAccording to the flt instructor, during the touch and go landing, directional control was lost when brakes were applied and the acft ground looped. During the investigation, it was ascertained that an 'o' ring on the right wheel had dislodged, resulting in…Mar 3, 1986 · N9923N · Substantial damageNTSB MKC86LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Grain Valley, MOThe PIC was making a roundtrip flt to numerous airports across Kansas and Missouri. The owner of the aircraft was aboard for the trip which was for pleasure. The PIC had obtained weather info and was apprised of the wind conditions for his route of flt. Upon…Mar 2, 1986 · N3979L · Substantial damageNTSB FTW86LRD08Accident · No injuriesFinal reportCessna 172P · Many, LAThe acft drifted off the rt side of the rwy into the soft shoulder during landing in a 10-12 kt x-wind. When the nose gear contacted the soft dirt it collapsed, which resulted in a nose over.Mar 2, 1986 · N5234K · Substantial damageNTSB NYC86FHA01Accident · No injuriesFinal reportPiper PA-28-140 · Doylestown, PAThe Piper PA-28-140 was landing on rwy 23. The winds were reported to be from 320' - 330' with a velocity of 20 KTS and gusts to 30 KTS. The student pilot lost control on landing and veared off the right side of runway. The aircraft received substantial…Mar 1, 1986 · N2270Q · Substantial damage