OpenAirDocs.org

NTSB investigations

53,702 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 ENG15WA036Incident · No injuriesForeign investigationBoeing 737 · Quetta, PakistanThe government of Pakistan has notified the NTSB of an accident involving a Boeing 737-400 airplane that occurred on July 16, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under the…Jul 16, 2015 · AP-BJT · Minor damageNTSB WPR15CA214Accident · Minor injuriesData collectionFinal reportPiper PA-28-151 · Laurier, WAThe pilot's inadequate decision to continue the approach, which resulted in a long landing and insufficient runway remaining to stop the airplane before it departed the end of the runway.Jul 15, 2015 · C-GDYN · Substantial damageNTSB WPR15LA218Accident · No injuriesLimited investigationFinal reportDafoe Gerald W Tcow Smith CUB · Cascade, IDA gouge in the right brake master cylinder piston O-ring, which resulted in a loss of brake pressure and reduced effectiveness after landing. Contributing to the accident was the pilot’s decision to operate the airplane with an ongoing brake issue.Jul 14, 2015 · N810GL · Substantial damageNTSB GAA15CA184Accident · No injuriesData collectionFinal reportPiper PA 12 · Buhl, IDThe student/instructed pilot lost directional control during the landing roll, resulting in a runway excursion, and ground loop.Jul 14, 2015 · N3795M · Substantial damageNTSB GAA15CA185Accident · No injuriesData collectionFinal reportBarron Starduster SA 300 · Whiteville, NCThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.Jul 12, 2015 · N5618 · Substantial damageNTSB ANC15LA048Accident · No injuriesLimited investigationFinal reportCessna 210 · Juneau, AKA loss of hydraulic fluid due to a fractured left main landing gear hydraulic actuator as a result of a fatigue crack, which led to the landing gear collapsing upon touchdown.Jul 12, 2015 · N3607Y · Substantial damageNTSB GAA15CA213Accident · No injuriesData collectionFinal reportCessna A185F · Dauphin Island, ALThe pilot's loss of directional control during the landing roll in gusty wind conditions which resulted in a ground loop and impact with terrain.Jul 11, 2015 · N185DK · Substantial damageNTSB ERA15CA267Accident · No injuriesData collectionFinal reportBrandt Leroy E Challenger II · Batavia, NYThe pilot's improper flare, which resulted in a hard landing and subsequent loss of directional control.Jul 11, 2015 · N434LB · Substantial damageNTSB WPR15LA209Accident · No injuriesLimited investigationFinal reportMooney M 20G · Phoenix, AZThe pilots' failure to apply carburetor heat during the approach for landing, which resulted in a total loss of engine power due to carburetor icing.Jul 10, 2015 · N9152V · Substantial damageNTSB ERA15LA268Accident · No injuriesLimited investigationFinal reportCessna 170 · Buffalo, NYThe pilot’s failure to maintain directional control of the airplane during the landing with a light quartering tailwind, which resulted in the failure of the landing gear and a subsequent ground loop.Jul 10, 2015 · C-FHER · Substantial damageNTSB GAA15CA180Accident · No injuriesData collectionFinal reportPietenpol AIR Camper · Burlington, WIThe student pilot's failure to maintain pitch control during the landing touchdown, resulting in a hard landing.Jul 9, 2015 · N29NX · Substantial damageNTSB GAA15CA174Accident · No injuriesData collectionFinal reportPilatus PC12 · Belgrade, MTThe pilot's improper use of pitch control during an instructional maneuver, which resulted in a tail strike during landing.Jul 8, 2015 · N220CL · Substantial damageNTSB ANC15CA047Accident · No injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Elfin Cove, AKThe pilot's failure to maintain clearance from a boat while landing.Jul 8, 2015 · N543SR · Substantial damageNTSB ERA15WA284Accident · Serious injuriesForeign investigationRobinson R66 · Baykalsk, RussiaJul 7, 2015 · RA-05773 · Substantial damageNTSB WPR15WA225Incident · No injuriesForeign investigationBoeing 737-800 · TamuningOn July 5, 2015, about 0210 local time, a Boeing 737-800, HL8224, Korean Airlines Flight 2115, had a runway excursion at A. B. Won Pat Guam International Airport. Tamuning, Guam. Korean Airlines was operating the airplane under the provisions of the Korean…Jul 5, 2015 · HL8224 · Minor damageNTSB GAA15CA176Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar SL · Montgomery, NYThe pilot's improper pitch control which resulted in a hard landing. A factor contributing to the accident was the pilot's improper recovery from a bounced landing.Jul 5, 2015 · N163PH · Substantial damageNTSB WPR15FA208Accident · 1 fatalField investigationFinal reportMooney M20E · Salem, ORThe pilot's unstabilized approach and delayed remedial action, which resulted in a porpoise during landing. Also causal to the accident was the pilot’s exceedance of the airplane's critical angle-of-attack during the subsequent aborted landing, which resulted…Jul 4, 2015 · N5608Q · Substantial damageNTSB GAA15CA186Accident · No injuriesData collectionFinal reportPiper J3C · Arcadia, FLThe pilot's failure to maintain directional control during the landing, which resulted in a runway excursion and collision with terrain.Jul 4, 2015 · N3274U · Substantial damageNTSB GAA15CA165Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Comanche, OKThe pilot's failure to maintain proper pitch control during touchdown, which resulted in a nose over and impact with terrain.Jul 4, 2015 · N317MA · Substantial damageNTSB GAA15CA182Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Llano, TXThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion and a collision with terrain.Jul 3, 2015 · N71108 · Substantial damageNTSB GAA15CA162Accident · No injuriesData collectionFinal reportCessna 172N · Lubbock, TXThe student pilot's improper flare during landing which resulted in abnormal runway contact and damage to the firewall.Jul 3, 2015 · N6326J · Substantial damageNTSB GAA15CA170Accident · No injuriesData collectionFinal reportCessna T182T · Oak Island, NCThe pilot's improper level off and flare, which resulted in a bounced landing and firewall damage.Jul 2, 2015 · N2080Q · Substantial damageNTSB CEN15LA300Accident · Serious injuriesLimited investigationFinal reportBalony Kubicek Spol BB60Z · Fort Carson, COThe pilot’s improper burner control, which allowed the balloon’s envelope to cool, and the balloon’s subsequent encounter with a drop in wind velocity during a high wind landing approach, both of which resulted in the balloon’s descent rate increasing too…Jul 2, 2015 · N210GB · No damageNTSB GAA15CA168Accident · No injuriesData collectionFinal reportCessna A188B · Saratoga, WYThe pilot's loss of directional control during the landing roll, which resulted in a runway excursion, and a ground loop.Jul 1, 2015 · N60691 · Substantial damageNTSB WPR15LA202Accident · No injuriesLimited investigationFinal reportShort Bros SD3 60 · Kapolei, HIThe pilots’ failure to extend the landing gear before landing. Contributing to the accident was the pilots’ failure to complete the Before Landing checklist.Jun 30, 2015 · N221LM · Substantial damageNTSB GAA15CA183Accident · No injuriesData collectionFinal reportCessna 180 · Cahokia, ILThe pilot's failure to maintain directional control during the landing roll which resulted in a ground loop.Jun 30, 2015 · N3888C · Substantial damageNTSB GAA15CA150Accident · Minor injuriesData collectionFinal reportCessna TR182 · Rio Vista, CAThe pilot's use of improper procedures during an aborted landing, resulting in a runway excursion and a collision with a canal.Jun 30, 2015 · N739WW · Substantial damageNTSB GAA15CA147Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kailua-Kona, HIThe flight instructor's decision to conduct a high altitude pinnacle landing without adequate power, which resulted in the helicopter impacting terrain during the approach. Contributing to the accident was the density altitude at the high altitude pinnacle…Jun 29, 2015 · N227FT · Substantial damageNTSB ANC15CA045Accident · No injuriesData collectionFinal reportJohnson Gary PA 18 Super CUB KIT · Palmer, AKThe pilot's excessive use of brakes during the landing roll resulting in a nose over.Jun 29, 2015 · N808GJ · Substantial damageNTSB GAA15CA149Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Novato, CAThe pilot's improper pitch control which resulted in a bounced landing, runway excursion, and collision with terrain.Jun 28, 2015 · N9069J · Substantial damageNTSB GAA15CA146Accident · No injuriesData collectionFinal reportCessna 150L · Huntsville, ALThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a porpoise, and firewall damage.Jun 28, 2015 · N19337 · Substantial damageNTSB GAA15CA144Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Williston, NDThe pilot's failure to maintain directional control, which resulted in a runway excursion, and a collision with runway marking signs.Jun 28, 2015 · N8723 · Substantial damageNTSB GAA15CA148Accident · No injuriesData collectionFinal reportMooney M20R · West Mifflin, PAThe pilot's failure to maintain pitch control during landing, which resulted in a bounce and loss of control during landing, followed by a runway excursion, and collision with terrain during an attempt to abort the landing.Jun 27, 2015 · N93TK · Substantial damageNTSB ANC15CA042Accident · No injuriesData collectionFinal reportCessna U206G · Anchorage, AKThe pilot's improper recovery from a bounced landing, and his failure to maintain directional control.Jun 27, 2015 · N756BW · Substantial damageNTSB GAA15CA187Accident · No injuriesData collectionFinal reportHier James A Long EZ · Show Low, AZThe right main landing gear leg fracture, which resulted in the landing gear wheel separation and a runway excursion.Jun 26, 2015 · N793H · Substantial damageNTSB GAA15CA160Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Anacortes, WAThe pilot's excessive brake application during the landing roll resulting in a nose over.Jun 26, 2015 · N28437 · Substantial damageNTSB GAA15CA156Accident · No injuriesData collectionFinal reportCessna 172N · Vernal, UTThe pilot's failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.Jun 26, 2015 · N3159E · Substantial damageNTSB GAA15CA140Accident · No injuriesData collectionFinal reportCessna 172 - S · Traverse City, MIThe student pilot's failure to maintain pitch control during the landing, resulting in a hard landing.Jun 25, 2015 · N195NW · Substantial damageNTSB GAA15CA155Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Salisbury, MDThe student pilot's loss of directional control during the landing roll, resulting in a runway excursion and collision with terrain.Jun 24, 2015 · N577MA · Substantial damageNTSB WPR15LA198Accident · Serious injuriesLimited investigationFinal reportCessna TU206F · Schafers Meadows, MTThe pilot's failure to maintain directional control of the airplane during the landing roll in variable and gusting wind conditions.Jun 23, 2015 · N8424Q · Substantial damageNTSB GAA15CA132Accident · Minor injuriesData collectionFinal reportErvin Rex H Bear Hawk · Merrill, ORThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Jun 21, 2015 · N939RE · Substantial damageNTSB GAA15CA302Accident · No injuriesData collectionFinal reportAviat A · Grants Pass, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Jun 20, 2015 · N90ND · Substantial damageNTSB GAA15CA159Accident · No injuriesData collectionFinal reportVans RV-12 · Oshkosh, WIThe pilot's failure to monitor the airplane's glide path during the final approach, which resulted in a low approach path and impact with terrain.Jun 20, 2015 · N242VA · Substantial damageNTSB GAA15CA129Accident · No injuriesData collectionFinal reportLancair ES - NO Series · Hampshire, ILThe failure of the brake master cylinder which resulted in a loss of brake pressure and the subsequent loss of directional control during the landing roll.Jun 19, 2015 · N800TR · Substantial damageNTSB ERA15LA249Accident · No injuriesLimited investigationFinal reportBeech B 55 · Clearwater, FLThe pilot's delayed completion of the before landing checklist, including the extension of the landing gear, during an approaching thunderstorm, which resulted in a landing with the landing gear in transit and the subsequent collapse of the landing gear.Jun 19, 2015 · N216RW · Substantial damageNTSB WPR15LA186Accident · Serious injuriesLimited investigationFinal reportRockwell International S 2R · Washtucna, WAThe pilot's failure to maintain directional control while landing with a quartering tailwind.Jun 16, 2015 · N8420V · Substantial damageNTSB ERA15LA240Accident · No injuriesClass 3 · LimitedFinal reportWeatherly 201B · Pell City, ALThe inadequate inspection of the airplane's landing gear, which resulted in a collapse of the right main landing gear due to cracking and corrosion.Jun 14, 2015 · N1272W · Substantial damageNTSB CEN15CA274Accident · No injuriesData collectionFinal reportEnstrom F 28C · Romeoville, ILThe certified flight instructor (CFI) did not maintain directional control during a downwind emergency running landing to soft muddy terrain, which resulted in a dynamic rollover. Contributing to the accident was the CFI's delayed or insufficient remedial…Jun 14, 2015 · N51778 · Substantial damageNTSB GAA15CA142Accident · No injuriesData collectionFinal reportCessna 182P · Westminster, MDThe flight instructor's delayed remedial action during the landing flare, which resulted in a hard landing and porpoise.Jun 13, 2015 · N1248S · Substantial damageNTSB GAA15CA121Accident · No injuriesData collectionFinal reportCessna P210N · Bozeman, MTThe pilot's failure to complete the required before landing checks, resulting in the execution of a gear up landing causing substantial damage to the lower fuselage of the airplane.Jun 13, 2015 · N86SB · Substantial damage