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 CEN13CA136Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Upper Sandusky, OHThe pilot's failure to maintain directional control while landing in gusty crosswind conditions.Jan 15, 2013 · N7ZR · Substantial damageNTSB CEN13CA129Accident · No injuriesData collectionFinal reportBeech 65-B80 · Alexandria, MNThe pilot’s failure to stop the airplane on the downsloping, ice-contaminated runway after landing with a tailwind. Contributing to the accident was the pilot’s failure to account for the wind conditions and failure to obtain runway conditions.Jan 11, 2013 · N110BA · Substantial damageNTSB WPR13CA089Accident · Minor injuriesData collectionFinal reportStribling James L RV4 · Georgetown, CAThe pilot’s improper landing flare and failure to maintain directional control during landing.Jan 8, 2013 · N70AC · Substantial damageNTSB ANC13CA019Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Palmer, AKThe pilot's selection of unsuitable terrain for an off-airport landing, which resulted in a ground-loop.Jan 4, 2013 · N7780Y · Substantial damageNTSB WPR13LA082Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · North Las Vegas, NVThe pilot’s failure to maintain an adequate descent rate while on final approach, which resulted in a hard landing and landing gear collapse due to overload following the failure of both engines to respond to power inputs during an attempted go-around for…Jan 2, 2013 · N3AG · Substantial damageNTSB CEN13LA127Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Elkhart, INThe pilot’s improper flare, which resulted in a bounced landing.Jan 2, 2013 · N707HL · Substantial damageNTSB CEN13CA124Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Menard, TXThe helicopter landed hard during a forced landing.Jan 2, 2013 · N744RM · Substantial damageNTSB WPR13CA079Accident · No injuriesData collectionFinal reportCessna 182P · Chiloquin, ORThe flight instructor’s failure to maintain airplane control during a landing on a snow-covered runway.Jan 1, 2013 · N58677 · Substantial damageNTSB WPR13LA093Accident · No injuriesLimited investigationFinal reportKaufmann Vans RV-10 · Las Vegas, NVA missing elevator control assembly attachment bolt, which rendered the elevator control system ineffective and resulted in a loss of pitch control, and the pilot’s incorrect installation of the elevator control assembly.Dec 31, 2012 · N104BK · Substantial damageNTSB CEN13CA120Accident · No injuriesData collectionFinal reportRobidoux Lionel Wittman W 10 · Hobart, INThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and subsequent hard landing.Dec 30, 2012 · N641TD · Substantial damageNTSB CEN13CA125Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Middle Bass Island, OHThe pilot did not attain the proper touchdown point during landing, which resulted in impact with the edge of the runway surface.Dec 27, 2012 · N428S · Substantial damageNTSB ERA13CA098Accident · Minor injuriesData collectionFinal reportMckay Gene RV-9A · Brunswick, GAThe pilot’s failure to maintain airplane control while landing in gusting wind conditions.Dec 26, 2012 · N281MC · Substantial damageNTSB CEN13CA112Accident · No injuriesData collectionFinal reportCessna 172M · Eveleth, MNThe student pilot’s improper landing flare, which resulted in a hard nosewheel landing.Dec 21, 2012 · N9660H · Substantial damageNTSB ERA13LA095Accident · No injuriesLimited investigationFinal reportCessna 150J · Indian Trail, NCThe flight instructor’s failure to maintain adequate glidepath and airspeed control during short final approach and the airplane’s improper touchdown point, which resulted in a runway overrun.Dec 20, 2012 · N50757 · Substantial damageNTSB ERA13CA090Accident · No injuriesData collectionFinal reportAmerican AA-5 · Hot Springs, VAThe pilot’s failure to maintain airplane control while attempting to land in crosswind conditions.Dec 20, 2012 · N5813L · Substantial damageNTSB ANC13CA018Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Skwentna, AKThe pilot's loss of control while landing in gusting wind conditions.Dec 17, 2012 · N121KT · Substantial damageNTSB ANC13LA016Accident · No injuriesLimited investigationFinal reportCessna 150C · Juneau, AKThe collapse of the left main landing gear during the landing roll, as a result of fatigue cracking. Contributing to the accident was the improper maintenance of the landing gear.Dec 13, 2012 · N1901Z · Substantial damageNTSB WPR13CA067Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Rawlins, WYThe pilot's failure to maintain main rotor rpm during takeoff, which resulted in a hard landing and subsequent rollover.Dec 11, 2012 · N4073Q · Substantial damageNTSB ERA13CA092Accident · No injuriesData collectionFinal reportLiberty Aerospace XL-2 · Lynchburg, VAThe student pilot’s improper flare, which resulted in a hard landing.Dec 11, 2012 · N208AU · Substantial damageNTSB DCA13WA033Incident · No injuriesForeign investigationBoeing 737 · Shonai, JapanOn 8 December 2012, at approximately 1326 UTC (2236 local time), a Boeing 737-800, registration JA57AN, operated by All Nippon Airways, overran the runway after landing at Shonai Airport (RJSY), Yamagata, Japan, and came to rest in the grass area past the end…Dec 8, 2012 · JA57AN · No damageNTSB ERA13CA079Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Easton, MDThe pilot's failure to maintain directional control while landing.Dec 4, 2012 · N2835W · Substantial damageNTSB WPR13LA063Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-1T · Billings, MTThe pilot’s inability to maintain directional control during the landing roll because of the failure of the tailwheel support bracket.Dec 2, 2012 · N49309 · Substantial damageNTSB CEN13CA090Accident · No injuriesData collectionFinal reportCessna 172N · McKinney, TXThe pilot’s inadequate flare, which resulted in a hard nosewheel landing.Dec 1, 2012 · N737TY · Substantial damageNTSB CEN13CA084Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Melbourne, ARThe pilot's failure to maintain directional control of the airplane during the landing.Dec 1, 2012 · N63MY · Substantial damageNTSB WPR13CA055Accident · No injuriesData collectionFinal reportPiper PA18 · Needles, CAThe flight instructor, while demonstrating a water landing to the pilot receiving instruction, did not maintain proper alignment with the landing surface, which resulted in a hard landing.Nov 24, 2012 · N2224 · Substantial damageNTSB CEN13LA071Accident · Minor injuriesLimited investigationFinal reportScott Ironsides · East Troy, WIFailure of the steel weld fittings on the right main landing gear.Nov 24, 2012 · N1879 · Substantial damageNTSB CEN13CA077Accident · No injuriesData collectionFinal reportChristen Industries Pitts S-2S · Grain Valley, MOThe pilot's improper landing flare, which led to a bounced landing and subsequent loss of control.Nov 24, 2012 · N15PU · Substantial damageNTSB CEN13CA087Accident · No injuriesData collectionFinal reportCessna 150F · Red Oak, IAThe loss of control while landing due to the solo student pilot's delay to execute a go-around and his improper control inputs during a bounced landing.Nov 20, 2012 · N8000S · Substantial damageNTSB CEN13CA074Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe pilot’s failure to maintain directional control of the airplane while landing.Nov 18, 2012 · N4811G · Substantial damageNTSB ERA13LA061Accident · No injuriesLimited investigationFinal reportCessna 550 · Greenwood, SCCollision with a deer during the landing roll, which resulted in a compromised fuel tank and a postimpact fire.Nov 17, 2012 · N6763L · Substantial damageNTSB CEN13CA098Accident · No injuriesData collectionFinal reportCessna 172N · Moline, ILThe student pilot's misjudgment of the landing flare, which resulted in a bounced landing.Nov 15, 2012 · N6231F · Substantial damageNTSB CEN13LA057Accident · No injuriesLimited investigationFinal reportCessna T182T · San Antonio, TXThe pilot’s misjudgment of the landing speed and the runway distance remaining and his delay in applying the brakes, which resulted in an overrun.Nov 13, 2012 · N856DK · Substantial damageNTSB ERA13WA063Accident · Serious injuriesForeign investigationCessna 525B · Sao Paulo, BrazilOn November 11, 2012, at 1921 universal coordinated time, a Cessna Citation 525B, Brazilian registration PR-MRG, sustained substantial damage when it overran the runway during landing. One of the 2 crewmembers received serious injuries and the other received…Nov 11, 2012 · PR-MRG · Substantial damageNTSB CEN13IA059Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Minneapolis, MNLoose electrical connections to the hydraulic system and anomalies in the hydraulic shuttle valve and power pack, which resulted in an uncommanded gear unlock and collapse of the left main landing gear. Contributing to the accident was the operator’s failure…Nov 10, 2012 · N619BA · Minor damageNTSB CEN13CA064Accident · Minor injuriesData collectionFinal reportLawson Ron Rans S-19 · Crowley, LAThe pilot’s improper landing flare, which resulted in the collapse of the nose landing gear and the airplane nosing over.Nov 10, 2012 · N434KL · Substantial damageNTSB ERA13LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fort Lauderdale, FLThe collapse of the right main landing gear during landing for reasons that could not be duplicated or determined during the postaccident investigation because of the initial unavailability of the airplane after the accident.Nov 5, 2012 · N4534J · Substantial damageNTSB WPR13CA046Accident · No injuriesData collectionFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Sacramento, CAThe student pilot’s improper landing flare, which resulted in a hard landing.Nov 4, 2012 · N110GX · Substantial damageNTSB CEN13LA050Accident · No injuriesLimited investigationFinal reportWaco SRE · Lafayette, LAThe pilot’s inability to maintain directional control of the airplane during the landing roll.Nov 4, 2012 · NC247E · Substantial damageNTSB CEN13CA043Accident · Minor injuriesData collectionFinal reportFairchild Heli-Porter Pilatus PC6/B1A-H2 · Georgetown, OHThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.Nov 3, 2012 · N476XP · Substantial damageNTSB WPR13CA040Accident · No injuriesData collectionFinal reportSpackman Avid Flyer · Casper, WYThe pilot’s failure to maintain directional control during the landing roll.Nov 2, 2012 · N130PS · Substantial damageNTSB WPR13CA033Accident · Minor injuriesData collectionFinal reportCessna 140 · Watsonville, CAThe pilot’s failure to maintain airplane control during the landing roll.Nov 2, 2012 · N77227 · Substantial damageNTSB CEN13CA040Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during landing.Nov 2, 2012 · N172FU · Substantial damageNTSB DCA13WA029Incident · No injuriesForeign investigationBoeing 737 · Pontianak, IndonesiaThe National Transportation Safety Committee (KNKT) of Indonesia has notified the NTSB of an accident involving a Boeing 737-400 that occurred on November 01, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT investigation under…Nov 1, 2012 · PK-LIF · Minor damageNTSB CEN13FA038Accident · No injuriesField investigationFinal reportPiaggio P180 · Boyne City, MIThe select/bypass valve's failure to seal correctly because of improper shimming, which resulted in an uncommanded and uncontrollable left turn during landing. Contributing to the accident was the overhaul facility's improper overhaul of the steering manifold.Oct 31, 2012 · N401WS · Substantial damageNTSB WPR13CA032Accident · No injuriesData collectionFinal reportCessna 152 · Long Beach, CAThe student pilot's improper landing flare and recovery from a bounced landing.Oct 29, 2012 · N48340 · Substantial damageNTSB WPR13LA034Accident · No injuriesLimited investigationFinal reportJeffair Barracuda · Payson, AZThe failure of the landing gear to remain extended during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Oct 27, 2012 · N19GS · Substantial damageNTSB WPR13IA026Incident · No injuriesIncident investigationFinal reportCessna P210N · Oakland, CAThe pilot’s failure to follow proper procedures to confirm that the main landing gear was down and locked before landing.Oct 27, 2012 · N43CE · Minor damageNTSB WPR13CA024Accident · No injuriesData collectionFinal reportCessna 170A · Calexico, CAThe pilot's failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.Oct 27, 2012 · N1332D · Substantial damageNTSB CEN13CA037Accident · No injuriesData collectionFinal reportBates Starduster SA-300 · Reklaw, TXThe pilot’s improper recovery from a bounced landing, which resulted in a noseover.Oct 27, 2012 · N2369 · Substantial damageNTSB ERA13LA041Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5A · Fairhope, ALThe Grumman pilot’s loss of directional control during landing for undetermined reasons because postaccident examination of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the Piper pilot…Oct 26, 2012 · N26380 · 2 aircraft · Substantial damage