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 DEN88LA049Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Clovis, NMJan 12, 1988 · N5063J · Substantial damageNTSB ATL88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student plt rptd that he attempted to land long to avoid snow and ice on the rwy. The airplane touched down earlier than he intended however, and contacted the snow and ice. The airplane subsequently veered off of the runway, impacted a snowbank, and…Jan 12, 1988 · N757AS · Substantial damageNTSB SEA88LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Juneau, AKThe aircraft was ballooning during the approach to the ice-covered lake. The pilot momentarily added power to go-around, but elected to reduce the power in order to land. During the landing roll directional control was lost with the aircraft sliding into an…Jan 10, 1988 · N7221F · Substantial damageNTSB NYC88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Old Bridge, NJThe flight made a normal approach and touched down on runway 24. As the pilot applied pwr for takeoff due to the hazardous runway conditions, the pilot lost directional control and the left main landing gear impacted plowed snow at the edge of the runway.Jan 10, 1988 · N9317N · Substantial damageNTSB MKC88LA038Accident · No injuriesLimited investigationFinal reportCessna 177 · St. Charles, MOWhile practicing touch and go ldgs, PIC noted a significant increase in sink rate. Additional power failed to arrest the descent, and the acft struck the terrain short of the rwy causing substantial damage to the acft, and no injuries to plt and pax.Jan 10, 1988 · N35284 · Substantial damageNTSB DEN88LA052Accident · No injuriesLimited investigationFinal reportCessna 305A · Littleton, COJan 10, 1988 · N5245G · Substantial damageNTSB DEN88LA047Accident · No injuriesLimited investigationFinal reportCessna 182G · Aurora, CON3406S was landing on rwy 32, an asphalt rwy 5,000 ft long and 40 ft wide. The rwy was clear and dry, but the terrain surrounding the rwy was covered by 12 to 15 inches of snow. The wind at an arpt 5 mi sw was from 160 deg at 5 KTS. In his rpt of the acdt the…Jan 10, 1988 · N3406S · Substantial damageNTSB ATL88LA076Accident · No injuriesLimited investigationFinal reportCessna 182G · Lancaster, OHThe plt rptd that the airplane began to veer left almost immediately after touchdown. The airplane subsequently swerved off of the rwy. Traveled across a snow-covered grassy area, and impacted a taxiway embankment. The nose gear was found to be collapsed…Jan 10, 1988 · N2006R · Substantial damageNTSB MKC88FA037Accident · No injuriesField investigationFinal reportBeech 58 · Dewitt, ARThe pilot of N4613S was making a VFR approach into the de witt, Arkansas municipal airport. Snow had been removed from the runway and piled up on the approach end of runway 35. The nose gear of the aircraft contacted the piled up snow/ice at touchdown,…Jan 9, 1988 · N4613S · Substantial damageNTSB DEN88LA051Accident · No injuriesLimited investigationFinal reportRaven RX-7 · Rio Rancho, NMDuring the landing the plt reported a wind shift which drifted the balloon into pwr lines before the landing could be accomplished. The plt reported she could not see the pwr lines due to the balloon restricting visibility and the pax pointed the lines out to…Jan 9, 1988 · N2797L · Substantial damageNTSB ANC88DAG02Accident · No injuriesFinal reportCessna 172 · Willow, AKThe pilot stated that immediately upon touchdown, the airplane started sinking in (two feet) deep snow, and came to a stop in about 50 feet. The left wing and propeller struck the ground. The plt had overflown the arpt and saw the snow removal equipment about…Jan 9, 1988 · N8439X · Substantial damageNTSB NYC88LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic City, NJThe Piper PA-23-250 made an instrument approach to the airport. The pilot said he lowered the landing gear prior to touchdown, however, both propellers struck the runway. The pilot tried to make a go-around and the aircraft started to veer to the left. The…Jan 8, 1988 · N62554 · Substantial damageNTSB ANC88LA023Accident · No injuriesLimited investigationFinal reportCessna 207 · Akiachak, AKThe pilot stated that during the landing roll on the ice covered runway, he lost control causing the plane to exit the departure end of the runway into a snow bank.Jan 4, 1988 · N73036 · Substantial damageNTSB MKC88LA036Accident · No injuriesLimited investigationFinal reportCessna 414 · Fayetteville, ARDuring an instructional flt, the CFI and student plt heard a loud pop while attempting to lower the gear in preparation for landing. Several flybys past the control tower were made to confirm an unsafe nose gear configuration. They flew the aircraft an…Jan 1, 1988 · N30ML · Substantial damageNTSB LAX88LA079Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Phoenix, AZJan 1, 1988 · N74169 · Substantial damageNTSB NYC88LA061Accident · No injuriesLimited investigationFinal reportCessna 172 · Concord, NHThe aircraft was landing at Concord municipal airport, and during landing roll, the aircraft veered to the left leaving the runway surface and nosed over in the field between the taxiway and runway 35.Dec 31, 1987 · N5383R · Substantial damageNTSB CHI88LA038Accident · No injuriesLimited investigationFinal reportCessna 210-5 · East Lansing, MIThe aircraft was landed at night on runway 9 which is 2530' in length with a 600' displaced threshold. This runway was ice covered and winds were recorded 25 minutes before the accident at a reporting facility 5 nautical miles west of the accident site as 160…Dec 31, 1987 · N1802Z · Substantial damageNTSB DEN88FA044Accident · Serious injuriesField investigationFinal reportSwearingen SA-26AT · Telluride, CODuring a visual apch, the plt said he encountered 2000 fpm downdrafts. The plt stated he added power and executed a normal apch at 120 KTS, compensating for downdrafts/crosswinds. After touchdown, the plt said he did not get a beta light on the right eng. He…Dec 30, 1987 · N4468M · Substantial damageNTSB SEA88LA033Accident · 1 fatalLimited investigationFinal reportCessna 182C · Las Vegas, NVThe aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to…Dec 29, 1987 · N8819T · DestroyedNTSB LAX88LA081Accident · No injuriesLimited investigationFinal reportCessna 172M · Banning, CADuring a pleasure flight while on final approach, aprx 10 ft above the rwy, the acft suddenly dropped and bounced on the rwy. After a nearby rain storm passed over the area, the acft was flown to the home base. Several days later, the operator discovered…Dec 29, 1987 · N12943 · Substantial damageNTSB FTW88LA043Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Woodworth, LAThe plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose…Dec 29, 1987 · N5719G · Substantial damageNTSB MIA88NA070Accident · Minor injuriesFinal reportMcDonnell Douglas DC-9-31 · Pensacola, FLDec 28, 1987 · N8948E · Substantial damageNTSB DEN88IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Denver, CODuring landing roll the acft struck a taxiway marker. Visibility was reported by RVR to be 2200. Actual visibility was near zero due to blowing snow. Plt stated he did not lose cntrl but finite cntrl not possible due to lack of visibility and cross winds of…Dec 27, 1987 · N72830 · Minor damageNTSB MKC88LA034Accident · No injuriesLimited investigationFinal reportLuscombe 8-A · Chillicothe, MODuring a ldg attempt, acft touched down and swerved abruptly. Loss of control was experienced by PIC, and acft made a 180 degree turn on the runway. PIC stated the brakes may have been frozen, as he had taxied thru standing water during departure.Dec 26, 1987 · N71288 · Substantial damageNTSB CHI88LA036Accident · No injuriesLimited investigationFinal reportCessna 150M · Redwood Falls, MNWind was 210 degrees at 13 knots when the student pilot attempted a landing on snow compacted runway 12. The student stated that a gust of wind pushed the aircraft sideways and it struck a snowbank when it exited the runway to the left.Dec 26, 1987 · N704XX · Substantial damageNTSB CHI88LA034Accident · No injuriesLimited investigationFinal reportCessna 172K · Staunton, ILDuring the flare for landing the aircraft drifted to the right and the right wingtip contacted the rudders of two aircraft parked with their tails 21' and 23' from the centerline of the runway. The wingspan of the accident aircraft is 35'9'. Had the pilot…Dec 22, 1987 · N78705 · Substantial damageNTSB MKC88LA031Accident · No injuriesLimited investigationFinal reportSonerai 2L · St. Louis, MOWhile practicing take offs and ldgs, PIC lost directional control during rollout. He added power and struck a snowbank just after becoming airborne during running takeoff.Dec 21, 1987 · N502WM · Substantial damageNTSB FTW88FA039Accident · 15 fatalField investigationFinal reportAerospatiale SA-330J · Eugene IslandThe helicopter, with 2 plts & 13 passengers, was on an IFR flt to a psn in the gulf of Mexico. From that psn, they proceeded under VFR to an off-shore oil drilling rig (EI-190). As the helicopter was arriving from the se, there was a strong wind from the NE.…Dec 21, 1987 · N3596N · DestroyedNTSB DEN88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Las Cruces, NMWhile practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.…Dec 19, 1987 · N23497 · Substantial damageNTSB MIA88LA066Accident · No injuriesLimited investigationFinal reportCessna A188B · South Bay, FLThe plt attempted a landing on a narrow runway, on an embankment. The airplane swerved to the left, into a crosswind, and left the rwy. The right main ldg gear collided with a boulder; the airplane nosed over and came to rest in the water.Dec 18, 1987 · N731LS · Substantial damageNTSB MIA88LA064Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Marathon, FLWhile on a personal flt after the plt lowered the landing gear for landing, the left main landing gear did not extend. The plt continued the apch, & after touchdown, the acft veered off the rwy, collided with trees, then came to rest. According to FAA…Dec 15, 1987 · N707CC · Substantial damageNTSB ATL88LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Grantham, NCThe airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time.Dec 13, 1987 · N6258S · Substantial damageNTSB MIA88LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Fellsmere, FLWhile on a business flt over the company's property the plt elected to land the acft on a 40 foot wide dirt road. After touchdown the acft drifted off the left side of the road, due in part, to a crosswind. The left wing collided with a tree.Dec 12, 1987 · N80BJ · Substantial damageNTSB ATL88LA063Accident · No injuriesLimited investigationFinal reportCessna 150K · Portland, TNThe student plt rptd that the airplane veered off the rt side of the rwy into a ditch while ldg in x-wind conditions. The student plt estimated that the wind velocity was 10 KTS with gusts to 20 KTS. The student rptdly had about 32 hrs total flt experience,…Dec 12, 1987 · N5995G · Substantial damageNTSB ATL88LA062Accident · No injuriesLimited investigationFinal reportCessna 172P · Columbus, OHAt 1343 EST, the student plt contacted apch ctl & asked for lndg info. He was adzd to continue VFR for rwy 31. When he contacted the tower at 1347, the wind was fm 200 deg at 13 KTS. Tower psnl gave him the choice of rwy 31 or 28L; he elected to lnd on rwy…Dec 11, 1987 · N52701 · Substantial damageNTSB SEA88LA082Accident · No injuriesLimited investigationFinal reportCessna TU206G · Silverdale, WAWhile on the lndg roll with a qtrg hdwnd, the acft enctrd a gust which pushed it to the left. The plt said he applied full rgt aileron, but it had no effect. As the acft was 'being blown' toward trees, the plt applied full rgt brake. He said the left wing tip…Dec 10, 1987 · N4953Z · Substantial damageNTSB MIA88FA058Accident · No injuriesField investigationFinal reportEmbraer EMB 120 · Columbus, MSThe acft landed gear up while on a training flight, the crew stated that they had completed 2 hours of training when the first officer requested a single engine no flap approach demonstration. Both pilots stated that during this demonstration they neglected…Dec 10, 1987 · N232AS · Substantial damageNTSB ATL88LA058Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Marlboro, OHThe student plt rptd that he flew a flat final apch to remain clear of trees. The airspeed began to drop, and the airplane subsequently landed hard after clearing the trees.Dec 10, 1987 · N87102 · Substantial damageNTSB NYC88LA055Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · White Plains, NYThe cross country business flight was uneventful from concord, new hampshire to White Plains, new york under clear sky. During final approach, the pilot extended the gear but did not notice that the circuit breaker had opened and the gear was not lowered. The…Dec 7, 1987 · N866Q · Substantial damageNTSB CHI88LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILThe plt returned to the arpt after dark & noted there was an excessive x-wind for the active rwy. He elected to land on the unlighted grass rwy (rwy 14) which was aligned more favorably with the wind. He thought that on final apch, he had aligned the acft…Dec 6, 1987 · N757KW · Substantial damageNTSB ANC88DAG01Accident · No injuriesFinal reportCessna 207A · Atmautluak, AKThe aircraft was on final approach when a vehicle appeared to be on the runway coming at the aircraft. The pilot pulled the aircraft up over the snow machine but settled back to the ground alongside the runway.Dec 6, 1987 · N73503 · Substantial damageNTSB MIA88LA054Accident · No injuriesLimited investigationFinal reportCessna 310F · Opa Locka, FLThe plt stated that he had made three touch & go landings & on the fourth landing, while on rollout, the left main gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed that the left main gear downlock rod…Dec 5, 1987 · N317L · Substantial damageNTSB MIA88LA053Accident · No injuriesLimited investigationFinal reportBeech C-45H · Miami, FLWhile practicing short field landings the plt flared the acft for landing after which it stalled, descended right wing low, then crashed onto the rwy. The acft then touched down on the nose landing gear causing it to collapse, & slid off the rwy.Dec 4, 1987 · N4209V · Substantial damageNTSB MIA88IA052Incident · No injuriesIncident investigationFinal reportBeech 58 · Vicksburg, MSWhile on a part 135 on-demand domestic passenger flt, the acft landed gear up. The plt stated that he forgot to lower the landing gear. There was no mechanical failure or malfunction.Dec 3, 1987 · N3012W · Minor damageNTSB ATL88LA051Accident · No injuriesLimited investigationFinal reportCessna 172F · Eden, NCThe student plt attempted to land in a farm pasture adjacent to his brother's farm. The airplane ldg gear 'dug in' on ldg, and the airplane nosed over. The student plt described the terrain as 'wet & soggy'. The student did not have an instructor's…Dec 2, 1987 · N8674U · Substantial damageNTSB MIA88LA048Accident · No injuriesLimited investigationFinal reportCessna 172K · Pensacola, FLThe pvt plt flying the acft for the first time from the rt seat landed it aprx 170 ft short of the runway on soft grass. The acft rolled 6-10 ft, after which the nose gear sank & the acft then nosed over & came to rest inverted.Nov 29, 1987 · N84613 · Substantial damageNTSB MIA88LA047Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Quincy, FLThe plt stated that he performed a prelanding check on final apch but failed to lower the landing gear. He continued the apch, & just prior to touchdown, was advised that the gear was not down. The apch to landing was continued & the acft slid to a stop. He…Nov 29, 1987 · N9492T · Substantial damageNTSB DEN88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Telluride, CODuring a downwind landing, the plt experienced difficulty in controlling his acft. Approximately 2,500 feet from the west end of the rwy the acft ground looped into some rocks and was substantially damaged. The plt stated that he was landing downwind and…Nov 28, 1987 · N6547A · Substantial damageNTSB MIA88LA045Accident · No injuriesLimited investigationFinal reportMooney M-22 · Fort Pierce, FLPlt stated that on landing roll at approximately 30 to 35 knots the nose landing gear began to shimmy and turn to the left. Full right brake and rudder could not correct the left turning tendency of the aircraft. The aircraft ran off the left side of the…Nov 26, 1987 · N7739M · Substantial damageNTSB LAX88LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Sacramento, CAA Cessna 172N veered off runway 30. The pilot reported that a gust of wind lifted the left wing resulting in the right wing scraping the runway surface. The airplane subsequently ground looped to the right and departed the runway. The winds were reported to…Nov 25, 1987 · N75825 · Substantial damage