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 SEA85LA003Accident · No injuriesLimited investigationFinal reportCessna 175 · Astoria, ORThe plt reported that during landing the acft started to skid to the left of the rwy. He applied rudder and aileron and then added power. The elevator was pulled back, the nose went up and the left wing went down. The acft hit the ground hard on the wing tip…Oct 6, 1984 · N9243B · DestroyedNTSB CHI85LA012Accident · No injuriesLimited investigationFinal reportBeech BE-77 · Cincinnati, OHThe plt reported that during a landing, he flared too high, the acft entered a high rate of descent & touched down hard. He reported that the nose gear became bent, the acft went off the left side of the rwy & struck a culvert.Oct 6, 1984 · N3730S · Substantial damageNTSB CHI85LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Xenia, OHThe plt reported that after landing on the 3000 ft grass rwy, the acft traveled off the right & hit a ditch. No mechanical problems were evident.Oct 6, 1984 · N80941 · Substantial damageNTSB CHI85LA008Accident · No injuriesLimited investigationFinal reportCessna 172N · Youngstown, OHAfter returning to the arpt, the plt entered the pattern for a x-wind landing. He made 3 go-arounds while attempting to land. On the 4th apch, the acft touched down, then became airborne again. The plt decided 'to much time had passed to make another…Oct 6, 1984 · N738CY · Substantial damageNTSB CHI85LA007Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2B · Hampshire, ILDuring the landing flare the acft stalled at about 15 ft. both main ldg gear collapsed when the acft collided with the runway.Oct 6, 1984 · N53130 · Substantial damageNTSB LAX85LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Van Nuys, CAThe student plt was on his 3rd supervised solo flt & stayed in the traffic pattern to practice landings. On the 2nd approach to land, the acft ballooned during the flare & yawed to the left. The acft touched down & immediately veered left, went off the rwy &…Oct 5, 1984 · N2099U · Substantial damageNTSB FTW85LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Crowell, TXThe plt stated that he lowered the landing gear on short final and that he received 3 green lights. During the landing roll a total gear collapse was experienced. A pilot witness on the ground stated that the nose gear did not appear to beextended when the…Oct 5, 1984 · N6263C · Substantial damageNTSB DEN85LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Silver City, NMThe plt stated after the accident that he was attempting to land on rwy 33. He continued to state that immediately prior to the landing flare, a 'terrific downdraft' forced the acft down on the rwy. The acft landed hard and the plt attempted a go-around. He…Oct 5, 1984 · N707FL · DestroyedNTSB CHI85LA011Accident · No injuriesLimited investigationFinal reportMooney M20A · Tecumseh, MIUpon touchdown the landing gear collapsed. Inspection revealed the landing gear actuator handle was cracked aprx 1/2 inch above the actuator torque tube. The crack was through 3/4 of the circumference and there was a 10 deg bend in the tube near the crack.…Oct 5, 1984 · N1093C · Substantial damageNTSB CHI85LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150F · West Branch, MIThe plt reported that when he arrived at night, he was unable to activate the rwy lights, but decided to land anyway. He touched down long on the 3700 ft rwy & was unable to stop on the remaining area. The acft continued off the end & hit a ditch where the…Oct 5, 1984 · N8108F · Substantial damageNTSB MKC85LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Nashville, ARDuring the flare the acft ballooned, decelerated and stalled. The resultant hard ldg collapsed the ldg gear.Oct 4, 1984 · N4498V · Substantial damageNTSB LAX85LA001Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Redding, CARunway 15 was in use. Plt broadcast on UNICOM freq intention to land rwy 15. Plt landed on rwy 33 with a 10 kt tailwind. On landing roll, plt realized he would not be able to stop on remaining rwy & go-around was initiated. Acft did not attain flying speed…Oct 4, 1984 · N2073S · Substantial damageNTSB FTW85LA004Accident · No injuriesLimited investigationFinal reportCessna A185E · Morgan City, LAPlt arrived at intended lndg site on remote pipeline canal where quarter boat was operating, overflew site and visually checked conditons. After 100-150 yds of landing roll, the right float struck a submerged object. Float filled with water and acft rolled…Oct 3, 1984 · N2768J · Substantial damageNTSB CHI85LA002Accident · Minor injuriesLimited investigationFinal reportBrewer Corsair · Ft. Wayne, INAfter touchdown and an initial rollout of aprx 480 ft, the acft began veering to the right. The acft departed the right side of the rwy and contacted a plowed trench, 29 ft from the rwy, where it nosed over.Oct 3, 1984 · N3152P · Substantial damageNTSB LAX85LA020Accident · No injuriesLimited investigationFinal reportCessna 180 · El Monte, CAA low time pvt plt flared the acft which touched down hard and bounced. On the second touchdown, the acft entered a ground loop to the right. Application of right brake and rudder did not correct the situation. The left wing and nose went down & the acft went…Oct 2, 1984 · N4902A · Substantial damageNTSB ANC85LA001Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Ohio Creek, AKThe pilot reported that during the landing roll, the right main landing gear wheel adaptor broke. The failure caused the pilot to lose directional control and the airplane subsequently overturned. Examination of the wheel adaptor disclosed evidence of…Oct 2, 1984 · N3952Z · Substantial damageNTSB NYC85LA024Accident · No injuriesLimited investigationFinal reportRaven S-66A · Little Compton, RIPlt brushed basket against tree tops and bushes to slow the balloons forward speed. Plt pulled deflation port aprx 10 ft AGL over a mown hay field with an 8-10 mph horizontal, 100 fpm vertical speed. Basket bounced and gust of wind caught deflating envelope…Sep 30, 1984 · N4272Y · Substantial damageNTSB MKC84LA287Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Prairie City, IAWhile the hot air balloon was airborne, the surface winds increased to 13 KTS. The plt instructed both passengers to prepare for a high wind landing. Contrary to the plt's instructions, the passenger, who became injured, crouched in the bottom of the basket…Sep 30, 1984 · N8517L · No damageNTSB LAX84LA502Accident · No injuriesLimited investigationFinal reportCanadair T-33 · Palm Springs, CAThe plt stated that 'as I crossed over the field boundry, landing was assured so I closed the throttle. The acft then pitched nose up (slightly), left wing dropped & acft sank out of control to touchdown on the overrun just short of the threshold.' The acft…Sep 30, 1984 · N12422 · Substantial damageNTSB DEN84LA305Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTPlt flared abruptly and acft floated before it touched down hard on the rwy collapsing the nose gear. Acft traveled 20 ft off the right side of the rwy before coming to rest.Sep 30, 1984 · N93239 · Substantial damageNTSB SEA84LA235Accident · No injuriesLimited investigationFinal reportGarre Leo J Glasair · Aurora, ORPlt was attempting a no flap landing. The acft developed a high rate of sink, struck the rwy and bounced. The acft ground looped and nosed over.Sep 29, 1984 · N108DR · Substantial damageNTSB NYC84LA322Accident · Minor injuriesLimited investigationFinal reportGulfstream 112 · West Hampton, NYThe acft collided with the ground following a loss of control during the landing flare. As the student plt began the flare, the acft veered to the left and contacted the ground despite the application of right rudder.Sep 29, 1984 · N1093J · Substantial damageNTSB FTW84IA412Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-300 · Houston, TXDuring a landing on rwy 14R, the acft veered off the left side of the rwy, hit a rwy sign & was damaged. At the same time the DHC-6 was approaching to land, a Boeing 727 was also in the traffic pattern to land on rwy 14L. According to tower personnel, the…Sep 29, 1984 · N914MA · Minor damageNTSB CHI84LA409Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIAccording to the CFI the glider was at about 500 ft AGL on base leg when a downdraft caused the acft to descend and touch down 50 ft short of the rwy.Sep 29, 1984 · N14420 · Substantial damageNTSB CHI84LA388Accident · No injuriesLimited investigationFinal reportAvian Balloon AX8 · Canton, OHPlt and passenger (student balloon pilot) elected a precautionary landing in an open field rather than overfly densely populated area and power lines, on touchdown, wind lifted balloon slightly and caused drift. As student plt was operating envelope vent, she…Sep 29, 1984 · N7003Q · Substantial damageNTSB SEA84LA236Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Darrington, WAThe acft went off the rwys end into a tree stump and brush during landing. The plt said he landed with excess speed and was unable to stop. The plt recommended that a go-around should have been performed.Sep 28, 1984 · N9701J · Substantial damageNTSB ANC84FA192Accident · No injuriesField investigationFinal reportCessna 305A · Anchorage, AKDuring the rollout the tail wheel began to shimmy and the acft swerved to the right and ground looped. The left wing and left horizontal stabilizer contacted the ground. Investigation revealed that the tail wheel spring ass'y was oversized and not properly…Sep 28, 1984 · N5312G · Substantial damageNTSB NYC84LA324Accident · No injuriesLimited investigationFinal reportCessna 140 · Harrisburg, PAAcft was landed downwind in light wind conditions by student plt. On roll-out, after normal braking was applied for deceleration, acft began to drift right. Student applied left brake as CFI also applied corrective left brake. Left brake connecting rod failed…Sep 27, 1984 · N2053N · Substantial damageNTSB MIA84LA266Accident · No injuriesLimited investigationFinal reportCessna 210N · Orlando, FLAfter encountering mod turbulence and strong winds on final approach, with reported surface winds of 25 KTS gusting to 34 KTS, the plt elected to continue landing. During flare, gusting winds exceeded acft performance capability. Plt attempted go-around but…Sep 27, 1984 · N5410C · DestroyedNTSB CHI84LA407Accident · No injuriesLimited investigationFinal reportCessna 150M · Clio, MIThe airport consists of three sod strips none of which contains rwy lights. The CFI and student departed the arpt for a local night flight. The CFI stated that upon returning to the arpt he called the arpt office on the UNICOM freq and requested the night…Sep 27, 1984 · N6106K · Substantial damageNTSB MIA84LA260Accident · No injuriesLimited investigationFinal reportCessna C-152 · Little S.Simons, GAThe acft struck a washed-out area during a beach landing at night and was destroyed when it flipped over into the ocean. Investigation revealed that the plt was bringing a mechanic/plt to this part of the beach in an effort to repair another acft that had…Sep 26, 1984 · N714YJ · DestroyedNTSB LAX84LA496Accident · No injuriesLimited investigationFinal reportCessna 180K · Salinas, CAThe plt stated that he landed on rwy 26 and after the acft slowed down to aprx 15 to 20 KTS, a gust of wind lifted the rt wing and the acft veered to the rt. The plt was unable to maintain directional control and the acft ground looped collapsing the left…Sep 24, 1984 · N66039 · Substantial damageNTSB LAX84LA493Accident · No injuriesLimited investigationFinal reportCessna 180 · Camarillo, CAThe pilot reported that he was unfamiliar with the acft. He discovered that the right main tire was deflated during his landing roll and he over controlled the acft while compensating. The acft ground looped to the left and nosed over.Sep 24, 1984 · N169N · Substantial damageNTSB DEN84LA306Accident · No injuriesLimited investigationFinal reportCessna 182 · Salt Lake City, UTAccording to the plt the southerly wind was gusting to an unknown intensity and wind shear was encountered during landing. Ground contact occurred in a nose down attitude on the nose landing gear.Sep 22, 1984 · N97852 · Substantial damageNTSB CHI84LA406Accident · No injuriesLimited investigationFinal reportBeech B33 · Willshire, OHDuring the landing flare the acft floated and drifted left. The left wing contacted corn stalks planted up to the edge of the runway.Sep 22, 1984 · N941Q · Substantial damageNTSB CHI84LA399Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lake Elmo, MNPilot stated that he landed near the approach end of runway 13 and 'right side of aircraft collapsed.' The investigation revealed that the aircraft landed 50 feet to the right side of runway 13. The pilot recorded only a total of 4 hours of night time, 2…Sep 22, 1984 · N25687 · Substantial damageNTSB FTW84LA403Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Plainview, TXThe CFI stated that at the time of the accident the private plt, in preparation for his commercial certificate, was flying a power off 'spot landing' with a desired touchdown point at the second centerline stripe. In an effort to reach the landing point with…Sep 21, 1984 · N522MM · Substantial damageNTSB CHI84LA400Accident · Minor injuriesLimited investigationFinal reportSteen Skybolt · Valparaiso, INThe acft dragged a wing and flipped over after the plt made a hard landing and lost control. The plt attempted a go-around in an uncontrolled situation. The acft was destroyed.Sep 21, 1984 · N57SP · Substantial damageNTSB CHI84LA395Accident · No injuriesLimited investigationFinal reportCessna 182P · Chicago, ILThe plt reported to gnd control after the accident that he had a flat tire. Several witnesses stated the pilot made a hard landing after which he lost directional control. The plt did not complete an NTSB pilot/operator aircraft accident report.Sep 21, 1984 · N1377S · Substantial damageNTSB ANC84LA191Accident · No injuriesLimited investigationFinal reportCessna 185 · Mt Plummer, AKThe plt stated that while landing in a crosswind, he ground looped the airplane. The acft departed the airstrip surface and rolled off the mountainside backward.Sep 21, 1984 · N1688Z · Substantial damageNTSB NYC84LA318Accident · No injuriesLimited investigationFinal reportCessna 182P · West Mifflin, PAOn arrival at airport, plt received wind information from twr as varying from 230 to 250 degrees at 15 KTS gusting to 20 and was offerred a choice of rwy 28 or rwy 23. Rwy 23 is 100 ft wide and 2380 ft long. Plt chose rwy 28. At landing flare, acft…Sep 20, 1984 · N52830 · Substantial damageNTSB DEN84LA296Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Carrington, NDAccording to the plt, the landing gear were extended on base leg but he did not recall seeing the green light indicating a down and locked configuration. As the acft touched down some resistance was felt by the plt as all 3 gear collapsed and the acft settled…Sep 20, 1984 · N8579P · Substantial damageNTSB SEA84LA231Accident · No injuriesLimited investigationFinal reportDrake Quickie II · Twin Falls, IDThe plt said that the acft porpoised 2 or 3 times after initial touchdown. After bouncing, the acft veered to the rt, ground looped and nosed over after contacting the soft ground off the side of the rwy.Sep 19, 1984 · N42Q · Substantial damageNTSB SEA84LA230Accident · No injuriesLimited investigationFinal reportCessna R-182 · Mountain Home, IDThe pilot was landing on a road to visit friends when the acft collided with a gate during the roll. The pilot had originally intended to land at a nearby municipal arpt after flying over the friends house. Due to the close proximity of Mountain Home air…Sep 19, 1984 · N2386C · Substantial damageNTSB NYC84LA325Accident · No injuriesLimited investigationFinal reportPiper J-3 · Durham, CTThe plt attempted to land on a grass strip. The wind was reported to be from 270 degrees at 10 KTS. The plt stated that he experienced a change in wind direction and a gust. The acft then veered and collided with a stone wall.Sep 19, 1984 · N7456H · Substantial damageNTSB NYC84LA316Accident · No injuriesLimited investigationFinal reportCessna 182H · Stonington, MEPlt was delayed in return flt to home arpt and arrived at the unlighted strip in darkness. The plt misjudged his runway alignment on approach, colliding with trees 15 ft from the runway during the landing flare.Sep 18, 1984 · N2052X · DestroyedNTSB LAX84FA484Accident · 2 fatalField investigationFinal reportMooney M20C · Mariposa, CAThe acft collided with a tree & telephone pole during a go-around maneuver on rwy 26. Investigation revealed that the acft exited the left side of rwy 26 about 1625 ft beyond the threshold. Although there were no eyewitnesses to the accident a ground witness…Sep 18, 1984 · N6406U · DestroyedNTSB FTW84LA401Accident · No injuriesLimited investigationFinal reportPitts S-T1 · Rockwall, TXThe pilot reported that the rwy was clear when he turned on final. Once on final forward visibility is limited and the pilot did not see the cow until the acft collided with it. The airport manager was aware of the problem of cattle wondering onto the rwy but…Sep 18, 1984 · N105BA · Substantial damageNTSB DEN84FTE04Accident · No injuriesFinal reportHomebuilt KR 2 · Boulder, COPlt installed a different propeller on acft to increase RPM and thrust. After takeoff plt was unable to gain sufficient alt to clr trees on base leg. Precautionary landing was made on a highway. Plt applied right brake during landing roll and acft traveled to…Sep 18, 1984 · N45757 · DestroyedNTSB CHI84LA393Accident · No injuriesLimited investigationFinal reportPickel Smith Miniplane · Covington, INThe pilot stated after the accident that during the landing roll the left wheel separated from the aircraft. The aircraft slid aprx 40 feet and nosed over. The plt stated that he had removed the main landing gear aprx 10 hrs prior to the accident to repack…Sep 18, 1984 · N5023D · Substantial damage