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 ANC84LA048Accident · No injuriesLimited investigationFinal reportCessna 170B · Skwentna, AKThe plt elected to land on a snow covered strip that had a frozen snow crust & was rutted. He stated that during the touchdown, the acft bounced, then he elected to go around. However, the acft touched down again & broke thru the frozen crust, then nosed over.Mar 22, 1984 · N4672C · Substantial damageNTSB CHI84LA136Accident · No injuriesLimited investigationFinal reportCessna 402C · Kenosha, WIThe acft ran off the rwys end after the plt landed downwind to avoid flying through a 'wall of precipation'. During the rollout in slush the brakes froze. The nose gear settled in mud and collapsed.Mar 21, 1984 · N2663G · Substantial damageNTSB CHI84LA135Accident · No injuriesLimited investigationFinal reportCessna 421C · Joliet, ILThe acft picked up moderate to severe icing which the pilot thought he had shaken off as he cycled the deice boots. He saw the ice come off of the wings but could not see the horizontal stabilizer. On short final at 100 KTS the control yoke began vibrating.…Mar 21, 1984 · N260RA · Substantial damageNTSB DEN84LA113Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, COAccording to the plt he landed too FAR on the right side of the rwy & the right wheel hit a chunk of ice. The acft veered right into a snowbank collapsing the nose gear.Mar 20, 1984 · N11315 · Substantial damageNTSB MKC84LA107Accident · No injuriesLimited investigationFinal reportCessna 340 · Olathe, KSThe acft skidded off the rwy into slush covered terrain alongside the rwy, dragging the left gear in the mud. As the acft continued its fwd roll the main gear struck the edge of a taxiway & collapsed backwards. The rwy was covered with slush at the time of…Mar 19, 1984 · N6320X · Substantial damageNTSB MKC84LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Lincoln, NEDuring landing roll on the runway with crosswind conditions and restricted visibility due to ice on the windshield the acft slid left on the ice and collided with a snow bank, damaging the propeller and the right wing tip.Mar 19, 1984 · N9996H · Substantial damageNTSB MIA84LA125Accident · No injuriesLimited investigationFinal reportCessna 310R · Palm Beach, FLThe acft landed hard, blew the left main tire and ran off the runway. A witness stated 'the pilot came in high on final, chopped power off and landed hard.'Mar 19, 1984 · N1UB · Substantial damageNTSB MIA84LA120Accident · No injuriesLimited investigationFinal reportSchweizer SGU-22 · Williston, FLThe acft collided with the wind tetrahedron during landing. The plt stated he landed on the grass parrllel to rwy 22 and a combination of landing long and ground effect caused him to hit the telrahedron.Mar 18, 1984 · N50RE · Substantial damageNTSB ANC84LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe plt landed on hard packed snow on a glacier. Some of the crusted snow gave in and the acft swerved to the left whilenosing over.Mar 18, 1984 · N3927V · Substantial damageNTSB SEA84LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Kennewick, WAThe plt was performing touch and go landings when he lost control of the acft and groundlooped. The wind was gusting to 15 KTS.Mar 17, 1984 · N9328N · Substantial damageNTSB LAX84LA224Accident · No injuriesLimited investigationFinal reportBeech 55 · Phoenix, AZThe acft veered off the rwy into soft dirt collapsing the right main landing gear. The left brake was foundMar 17, 1984 · N131TW · Substantial damageNTSB ANC84LA046Accident · Minor injuriesLimited investigationFinal reportCessna 180H · Soldotna, AKThe plt stated that the left wing of the acft struck small spruce trees during landing. He stated that the acft touched down 'off balance and pointed at two parked planes.' He applied power flew over the parked acft but could not avoid a large tree.Mar 17, 1984 · N9762G · Substantial damageNTSB MIA84LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Clearwater, FLThe aircrew were practicing touch & go landings when a loss of power occurred. Subsequently, the acft was damaged during an emergency landing in a field. An investigation revealed that the throttle linkage had become disconnected at the carburetor support…Mar 16, 1984 · N1242U · Substantial damageNTSB ATL84LA122Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Newberry, SCThe plt had executed a go-around from an approach to rwy 4 due to a crosswind & gusty wind conditions. While on downwindhe observed that the wind was favoring rwy 10. He overshot the approach end of rwy 10 & executed another go-around. Upon observing that he…Mar 16, 1984 · N3674L · DestroyedNTSB NYC84LA109Accident · Minor injuriesLimited investigationFinal reportBeech 77 · West Mifflin, PAThe acft landed short of the rwy and nosed over. According to the plt he felt that the acft was low on final approach and he added power. At this time the nose pitched down and the acft contacted the ground and came to rest upside down on the paved rwy.Mar 15, 1984 · N38675 · Substantial damageNTSB CHI84LA130Accident · No injuriesLimited investigationFinal reportCessna 401 · Chicago, ILThe acfts left main gear collapsed during the landing roll. Investigation revealed that the bolt on the top portion of the LH bellcrank assembly was sheared off. One of the tangs at the bottom of the bellcrank was also broken. When examined under a 10 power…Mar 15, 1984 · N777CS · Substantial damageNTSB MKC84LA099Accident · No injuriesLimited investigationFinal reportCessna 182J · Minden, NEThe plt had returned from dropping skydivers & was landing on rwy 29 at sunset. He reported that during the flare to land, he was temporarily blinded by the sun. The acft landed hard & bounced back into the air. It then settled, veered off the rwy, hit piles…Mar 14, 1984 · N2832F · Substantial damageNTSB FTW84LA169Accident · No injuriesLimited investigationFinal reportCessna 172D · Belle Chasse, LAThe acfts nose gear dug into mud during landing rollout. The acft then nosed over.Mar 14, 1984 · N2882U · Substantial damageNTSB ATL84LA120Accident · No injuriesLimited investigationFinal reportBeech 99 · Myrtle Beach, SCThe acft was landed with the landing gear up. The plt said that the sun was shining on the instrument panel and he thought he saw 3 green lights. After the acft stopped on the rwy the red light in the gear handle was on and the warninghorn was sounding. He…Mar 14, 1984 · N7994R · Substantial damageNTSB MIA84LA108Accident · No injuriesLimited investigationFinal reportCessna 310N · Tampa, FLThe plt reported that after arrival, he was cleared to land & made a landing check, but 'apparently made gear-up landing.' During an investigation, the gear operated normally. A witness stated that he saw the acft with the gear retracted.Mar 13, 1984 · N4197Q · Substantial damageNTSB FTW84LA165Accident · No injuriesLimited investigationFinal reportCessna 172N · Stamford, TXThe acft touched down nose wheel 1st on the 3200 ft x 60 ft asphalt rwy. As the plt attempted to hold the acft on the surface, directional control was lost & the acft went off the right side of the rwy, rolling into a muddy field. The nose wheel dug into the…Mar 12, 1984 · N6794E · Substantial damageNTSB ANC84FA044Accident · No injuriesField investigationFinal reportChampion 7EC · Anchorage, AKThe acft swerved and collided with a snowbank during landing. The wind was calm and the rwy dry. After the collision the right landing gear collapsed.Mar 12, 1984 · N4374C · Substantial damageNTSB NYC84LA106Accident · No injuriesLimited investigationFinal reportCessna C172 · Fairfield, NJThe acft hit a snowdrift during landing roll and veered left into a snowbank. The acft nosed down, striking the right wing tip and propellers.Mar 10, 1984 · N64493 · Substantial damageNTSB MIA84LA103Accident · No injuriesLimited investigationFinal reportMaule M4-220 · Boca Raton, FLThe plt stated that while practicing touch & go's he lost directional control & the left landing gear collapsed.Mar 10, 1984 · N40330 · DestroyedNTSB LAX84LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Pacoima, CADuring the overflight of the uncontrolled field, both plts noticed that the wind tee indicated rwy 12 as the landing direction. During landing, the acft floated & touched down about 2/3 down the rwy. The acft struck a fence & trees at the end of the rwy.…Mar 10, 1984 · N52702 · Substantial damageNTSB LAX84LA211Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5B · Carlsbad, CAThe plt reported that when the acft was about 10 ft AGL & he was beginning to flare for a landing on rwy 24, a slight gust of wind caused the plane to drift to the edge of the rwy. The plt began correcting for the drift, but the passenger grabbed the yoke &…Mar 10, 1984 · N74862 · Substantial damageNTSB FTW84LA164Accident · Minor injuriesLimited investigationFinal reportEagle Balloons Eagle C-7 · Houston, TXThe plt stated that the wx at the accident site was scattered clouds between 150-650 ft AGL with a definite ceiling at 650 ft (broken). Visibility was 1 mi with rapidly forming fog layer. The plt descended with the intention of landing as soon as possible. He…Mar 10, 1984 · N6081L · Substantial damageNTSB CHI84LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Stow, OHThe acft ran off the rwy & collided with a snowbank during landing. The acft had been subjected to previous damage whichhad not been fully repaired when a mechanic released it for further flt. A bolt (slightly worn, according to the mechanic) was reused in…Mar 10, 1984 · N9111K · Substantial damageNTSB CHI84LA128Accident · No injuriesLimited investigationFinal reportCessna 421B · Madison, WIThe acft went off the rwy to the left during landing. There was a crosswind of 15-28 KTS at the time. The plt said the acft veered left and could not be controlled. After the accident the was 464P-26 bolt and 5133-4032 spacer were sheared off both the left…Mar 10, 1984 · N41022 · Substantial damageNTSB ATL84LA131Accident · No injuriesLimited investigationFinal reportPitts Special S2A · Apex, NCThe acft made a hard landing and damaged a brake. During the second landing the brakes were found to be malfunctioning and as the rudder became ineffectual the acft left the rwy and collided with a hanger. The owner of the acft was improperly acting as an…Mar 10, 1984 · N83798 · Substantial damageNTSB ANC84FA045Accident · No injuriesField investigationFinal reportCessna 152 · Anchorage, AKThe acft had previously been involved in an accident in which the airframe was substantially damaged. It was then rebuilt & put back into service. Since then, it had been flown about 24 hrs using a snow covered rwy for takes & landing. During the 1st…Mar 9, 1984 · N68291 · Substantial damageNTSB FTW84LA186Accident · No injuriesLimited investigationFinal reportLockheed VEGA-1 · Yukon, OKThe plt was practicing touch-&-go landings & lost control of the acft. It swerved to the left onto soft terrain & went over on its nose. At 1st, the plt made comments about improper strut inflation. However, later, he reported that wx was not a problem & that…Mar 8, 1984 · N12288 · Substantial damageNTSB FTW84IA163Incident · No injuriesIncident investigationFinal reportBeech BE-200 · Fort Worth, TXAcft veered rt on touchdown. Heavy braking and differential pwr used to maintain directional control. Both rt side tires and the left outboard tire blew during rollout. Plt stated left main gear unsafe light illuminated during rollout. After engines were…Mar 8, 1984 · N888B · Minor damageNTSB CHI84IA127Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Erlanger, KYWhile the acft was about 15 mi sw of the arpt being vectored for a rwy 36 cat ii approach, the local controller gave theground controller permission to clear snow removal equipment to proceed north on rwy 36 & to exit rwy 36 at the intersection of rwy 27L.…Mar 8, 1984 · N794N · No damageNTSB ATL84FA115Accident · Serious injuriesField investigationFinal reportSikorsky S-76A · Spartanburg, SCThe acft collided with trees during a landing at a company helipad. The weather was IMC with low ceilings and fog. The acft had been cleared for a VOR approach monitored by radar. The co-plt spotted the pad and called it out to the plt who started a steep…Mar 6, 1984 · N15479 · Substantial damageNTSB LAX84LA206Accident · No injuriesLimited investigationFinal reportCessna 170B · Fullerton, CAThe acft ran off the rwy during landing. The plt said the'right brake was not functioning properly.' The acft collided with a rwy light and collapsed the right main gear.Mar 5, 1984 · N4630C · Substantial damageNTSB ATL84FKG05Accident · 1 fatalFinal reportPiper PA-34-220T · Madison, GAThe acft collided with a car while landing on an airstrip at night. The car had been parked on the strip & an occupant in the car was fatally injured. An illicit substance was found aboard the acft & it was confiscated by law enforcement officials. Rain & fog…Mar 5, 1984 · N2912X · Substantial damageNTSB NYC84LA101Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Norwood, MAThe student plt was practicing touch and go landings. The plt reported that the acft encountered a strong gust of wind about 5 ft AGL during the 2nd landing. The touchdown was made on the right main gear as the acft skidded and bounced. The next landing was…Mar 4, 1984 · N9175A · Substantial damageNTSB NYC84LA098Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Bedford, MAThe acft was decelerating at about 35 mph during roll when a gust of wind picked up the right wing and the acft veered to the right. Full power was applied to regain control and during acceleration the right main gear collapsed and the acft pivoted right and…Mar 4, 1984 · N2843K · Substantial damageNTSB CHI84LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · Strongsville, OHThe CFI stated that on the second landing, during the flare, the acft veered off the left side of the rwy due to the rt crosswind. He stated that he attempted to take control of the acft but it was already off the rwy in a two to three ft deep snowbank. The…Mar 4, 1984 · N48898 · Substantial damageNTSB ATL84LID01Accident · No injuriesFinal reportChampion S-150 · Ft. Eustis, VAThe plt reported that he made a smooth landing using full flaps. He stated that suddenly with no warning, the left wing came up and the right wing hit the runway. The acft went off the left side of the runway and the rt main gear collapsed. Investigation…Mar 4, 1984 · N5046N · Substantial damageNTSB NYC84LA303Accident · No injuriesLimited investigationFinal reportCessna R182 · Boston, MAAccording to the plt, due to landing traffic he was requested by ATC to keep his airspeed as fast as possible. A hard landing resulted at 110 KTS.Mar 3, 1984 · N9159C · Substantial damageNTSB DEN84LA104Accident · No injuriesLimited investigationFinal reportGates Learjet 25D · Denver, COAbout 1 mi from the arpt while established on the glide slope, the plt was advised by the controller to go around due totraffic on the ground. Just after the plt advanced the throttles & retracted the landing gear, the controller again cleared the plt for…Mar 3, 1984 · XALAP · Substantial damageNTSB CHI84LA129Accident · No injuriesLimited investigationFinal reportCessna 150M · Hagerstown, INDuring the rollout after a normal landing the acft collided with a snowdrift on the sod rwy. The collision collapsed theacft nose gear and damaged the propeller and firewall of the acft.Mar 3, 1984 · N714MC · Substantial damageNTSB CHI84LA124Accident · No injuriesLimited investigationFinal reportCessna 152 · Taylorville, ILThe acft collided with a snowbank and nosed over during landing. The student plt said a nose wheel shimmy developed during landing roll and he was unable to keep the acft on the 6O ft wide rwy.Mar 3, 1984 · N67919 · Substantial damageNTSB ATL84IA117Incident · No injuriesIncident investigationFinal reportBeech 19A Sport III · Atlanta, GAThe student plt landed hard & the nose gear collapsed while on a supervised solo flt. The acft slid off the rwy but remained upright.Mar 3, 1984 · N6968Q · Minor damageNTSB CHI84LA122Accident · No injuriesLimited investigationFinal reportCessna R172K · Marion, OHThe plt lost directional control of the acft during landing on an icy rwy in a gusty crosswind. The acft skidded to the left and contacted a snowbank, after which it nosed over.Mar 1, 1984 · N736JT · Substantial damageNTSB ATL85LA048Accident · No injuriesLimited investigationFinal reportAero Commander 1121 · Salisbury, NCIn March, 1984, N454SR reportedly sustained substantial damage during a hard landing. The accident was reported by a former FAA inspector on 11/29/84.Mar 1, 1984 · N454SR · Substantial damageNTSB MKC84LA088Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Point Lookout, MOThe plt angled in on the final approach at low alt. And the right landing gear hit a snowbank. The collision pulled the acft into the snow and it nosed over.Feb 29, 1984 · N74WB · Substantial damageNTSB NYC84LA094Accident · No injuriesLimited investigationFinal reportCessna 500 · Fitchburg, MAThe plt landed on a slushy rwy. He was unable to stop on the rwy and angled off the end into marshy ground. The stoppingdistance on a dry rwy was figured at 2355 ft. on a slushy rwy the stopping distance was about 4004 ft. the landing rwy was 4500 ft long.…Feb 28, 1984 · N712US · Substantial damage