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 SEA94LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Spangle, WAThe pilot not maintaining clearance from the fence. A factor in the accident was the dusk light conditions.Apr 3, 1994 · N6746B · Substantial damageNTSB BFO94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, DEInadequate clearance from obstacles, which resulted in birds strike. A factor was night conditions.Apr 3, 1994 · N2542L · Substantial damageNTSB LAX94LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beowawe, NVthe pilot's inadvertent application of the brakes combined with excessive forward control pressure during recovery from a bounced landing.Apr 2, 1994 · N8884D · Substantial damageNTSB ATL94LA073Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Boone, NCThe excessive speed used on final approach to the short runway by the pilot, and the failure of the pilot to use the proper touchdown point on the runway for landing.Apr 2, 1994 · N5704P · Substantial damageNTSB CHI94LA124Accident · No injuriesLimited investigationFinal reportCessna 177RG · Charlotte, MIthe deer which ran onto the runway. Factors related to the accident were the night conditions and the runway lights which were contacted.Mar 31, 1994 · N7581V · Substantial damageNTSB SEA94LA093Accident · No injuriesLimited investigationFinal reportCessna 210D · Cobalt, IDThe pilot selected unsuitable terrain for landing. Factors in the accident were: the wet runway and rising terrain that precluded a go-around.Mar 30, 1994 · N3820Y · Substantial damageNTSB SEA94LA092Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Levan, UTThe left main landing gear wheel bearing broke resulting in the wheel jamming and the airplane nosing over.Mar 30, 1994 · N6754Q · Substantial damageNTSB ATL94LA072Accident · Serious injuriesLimited investigationFinal reportFoote M1 Mustang · Marietta, GAThe failure of the pilot to maintain control of the aircraft. Factors in the accident were the lack of familiarization with the aircraft by the pilot, and throttle cable rigging in the experimental aircraft.Mar 30, 1994 · N130MJ · Substantial damageNTSB LAX94LA175Accident · No injuriesLimited investigationFinal reportMooney M-20C · Hyampom, CAThe pilot's failure to follow proper procedures by assuring that the landing gear locking mechanism was properly engaged.Mar 29, 1994 · N4045N · Substantial damageNTSB MIA94LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Parkland, FLImproper planning/decision by the director of operations, and failure of the instructor pilot to take adequate remedial action. A factor related to the accident was: the soft/wet runway condition.Mar 28, 1994 · N9786B · Substantial damageNTSB FTW94LA113Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Houston, TXThe pilot's failure to maintain directional control.Mar 28, 1994 · N73SL · Substantial damageNTSB MIA94LA107Accident · No injuriesLimited investigationFinal reportCessna 310Q · West Palm Beach, FLThe pilot-in-command's inadvertent landing with the brakes on, resulting in a bounced landing and his failure to maintain airspeed after a bounced landing which resulted in the aircraft stalling and landing hard.Mar 26, 1994 · N69978 · Substantial damageNTSB MIA94LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Stuart, FLPoor in-flight planning/decision by the pilot-in-command. Contributing to the accident was wind information disregarded by the pilot-in-command.Mar 26, 1994 · N6HV · Substantial damageNTSB ATL94LA068Accident · No injuriesLimited investigationFinal reportBeech C23 · Dahlonega, GAThe poor in-flight decision by the pilot to divert his attention from the runway on short final in order to retrieve a flashlight.Mar 26, 1994 · N9722Q · Substantial damageNTSB ANC94LA042Accident · Minor injuriesLimited investigationFinal reportBell 206B · Wrangell, AKThe pilot-in-command's failure to assure that he had the proper clearance from obstructions prior to landing on the platform. A factor in the accident was the high obstruction (tree strump).Mar 26, 1994 · N49727 · DestroyedNTSB CHI94LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Dubuque, IAthe student pilot's improper recovery from a bounced landing. The student pilot's lack of total flight experience was a factor.Mar 25, 1994 · N89761 · Substantial damageNTSB SEA94LA090Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Driggs, IDDirectional control was not maintained. A factor to the accident was: inadequate remedial action.Mar 24, 1994 · N86807 · Substantial damageNTSB NYC94LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Amherst, MAThe student pilot's inadvertently becoming lost, and the subsequent precautionary landing in a field, resulting in a collision with soft terrain and nose over.Mar 23, 1994 · N6460L · Substantial damageNTSB LAX94LA172Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Simi Valley, CAThe student pilot's improper hovering autorotation by allowing the helicopter to drift laterally and rearward, resulting in the helicopter rolling over during touchdown, and the flight instructor's inadequate supervision of the flight.Mar 23, 1994 · N4081P · Substantial damageNTSB CHI94LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.Mar 23, 1994 · N97650 · Substantial damageNTSB SEA94LA089Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Gillette, WYProcedures/directives were not followed and partial failure of the landing gear selector switch. A factor to the accident was an inoperative gear warning system.Mar 21, 1994 · N9415S · Substantial damageNTSB CHI94LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Richmond, WIthe failure of the pilot to maintain directional control.Mar 21, 1994 · N7812W · Substantial damageNTSB NYC94LA070Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Albion, NYthe pilot's loss of directional control during the landing roll, and the subsequent collision with soft terrain and nose over. Factors related to the accident were: the snowbanks on either side of the runway, and the pilot's lack of recent flight experience.Mar 20, 1994 · N60827 · Substantial damageNTSB CHI94LA120Accident · No injuriesLimited investigationFinal reportDefelici Kitfox III · Oxford, IAthe failure of the pilot-in-command (CFI) to maintain directional control. A factor related to the accident was the inadvertent interference with the flight controls by the student pilot.Mar 20, 1994 · N596D · Substantial damageNTSB ATL94LA066Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chamblee, GAThe pilot's failure to compensate for the wind condition during landing. A factor is a tailwind.Mar 19, 1994 · N57TH · Substantial damageNTSB NYC94LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Fairfield, NJThe failure of the pilot to attain a proper touchdown, at the proper speed which resulted in an overrun and contact with a fence. A factor was the failure of the pilot to follow his initial air traffic instructions.Mar 18, 1994 · N9585B · Substantial damageNTSB FTW94LA111Accident · No injuriesLimited investigationFinal reportCessna 172M · Flippin, ARThe student pilot's premature flare and the resultant inadvertent stall.Mar 18, 1994 · N6654H · Substantial damageNTSB FTW94LA106Accident · No injuriesLimited investigationFinal reportCessna 172L · Buena Vista, COThe improper supervision of the instructor pilot. A factor was the loss of directional control by the student pilot.Mar 18, 1994 · N7876G · Substantial damageNTSB ANC94LA040Accident · No injuriesLimited investigationFinal reportCessna 180 · Eureka Lodge, AKThe pilot-in-command's selection of unsuitable terrain for a landing.Mar 18, 1994 · N2423F · Substantial damageNTSB CHI94LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Wheeling, ILthe student pilot's improper recovery from a bounced landing.Mar 17, 1994 · N2MS · Substantial damageNTSB CHI94LA112Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 900 · Detroit, MIthe nose landing gear jammed in the UP position due to low pressure in the nose gear strut. A factor associated with the accident is the manufacturer's insufficient standards/requirements for determining the amount of nose strut inflation.Mar 17, 1994 · N327K · Substantial damageNTSB NYC94LA059Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Norwood, MAThe inadequate supervision by the instructor pilot during the landing, resulting in the improper runway alignment by the student pilot, and the subsequent collision with a snowbank. A factor related to the accident was the incomplete runway snow removal.Mar 16, 1994 · N7303R · Substantial damageNTSB LAX94LA161Accident · No injuriesLimited investigationFinal reportLuscombe 8EZ · Prescott, AZthe flying pilot's inadequate compensation for the existing crosswind condition, his failure to maintain directional control, and the inadvertent entry into a ground loop. A factor in the accident was the flying pilot's lack of experience in conventional…Mar 12, 1994 · N2295K · Substantial damageNTSB ANC94LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Soldotna, AKThe failure of the pilot-in-command/flight instructor to maintain directional control of the airplane.Mar 12, 1994 · N3485Z · Substantial damageNTSB SEA94LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Seattle, WAThe student's improper flare for landing and the instructor's delayed remedial action.Mar 11, 1994 · N52807 · Substantial damageNTSB CHI94LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ottumwa, SDinadequate compensation for wind conditions and the pilot's failure to maintain directional control. Factors related to the accident were the crosswind and the fence posts.Mar 11, 1994 · N14395 · Substantial damageNTSB CHI94DEP03Accident · No injuriesFinal reportLancair 360 · Waukesha, WIThe pilot's improper flare during landing. Factors related to the accident were a loss of directional control and rough terrain.Mar 11, 1994 · N3603R · Substantial damageNTSB SEA94LA080Accident · No injuriesLimited investigationFinal reportUnrein 80-P51D · Scapp00se, ORThe inadvertent unlocking of the tailwheel lock. Factors include the manufacturer's inadequate tailwheel lock.Mar 10, 1994 · N51PL · Substantial damageNTSB NYC94LA060Accident · No injuriesLimited investigationFinal reportCessna 172K · Dayton, OHthe pilot's failure to maintain directional control which resulted in a runway overrun. Factors are the pilot's improper recovery from a bounced landing, and his lack of experience.Mar 10, 1994 · N79136 · Substantial damageNTSB LAX94LA156Accident · No injuriesLimited investigationFinal reportCessna 152 · Angwin, CAthe failure of the pilot to maintain directional control of the aircraft. A factor in the accident was the pilots lack of total experience.Mar 10, 1994 · N5368M · Substantial damageNTSB CHI94LA102Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hutchinson, MNthe pilot's failure to maintain directional control. Factors associated with the accident were the crosswind, the pilot's lack of total experience, the concrete block and the dirt back.Mar 9, 1994 · N6625W · Substantial damageNTSB SEA94LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Evanston, WYThe pilot's inadequate compensation for wind conditions. Factors include gusty crosswind, and the pilot's lack of total experience.Mar 8, 1994 · N19678 · Substantial damageNTSB SEA94LA076Accident · Minor injuriesLimited investigationFinal reportTucker Kitfox IV · Vancouver, WAAileron flight controls that were jammed by the pilot's seat slipping from its mount. Factors include inadequate seat installation by the manufacturer.Mar 8, 1994 · N1942J · Substantial damageNTSB MIA94LA088Accident · No injuriesLimited investigationFinal reportCessna 150M · Vero Beach, FLThe failure of the student pilot to properly recover from a bounced landing.Mar 8, 1994 · N714MJ · Substantial damageNTSB MIA94LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Panama City, FLThe improper recovery from a bounced landing by the pilot-in- command.Mar 7, 1994 · N48239 · Substantial damageNTSB SEA94LA075Accident · No injuriesLimited investigationFinal reportCessna 175A · Stanley, IDThe pilot's failure to maintain the proper descent rate. Factors include downdrafts on final approach.Mar 6, 1994 · N6995E · Substantial damageNTSB SEA94LA074Accident · No injuriesLimited investigationFinal reportBeech 58P · Billings, MTThe pilot's inadvertent retraction of the landing gear while on the runway.Mar 6, 1994 · N717HL · Substantial damageNTSB NYC94LA055Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · South Bethlehem, NYThe failure of the pilot to maintain proper alignment with the runway and the inadequate snow removal.Mar 5, 1994 · N7139P · Substantial damageNTSB MIA94LA083Accident · Minor injuriesLimited investigationFinal reportHarper, Jack M. Mustang II · Lake City, FLThe failure of the bolts which secure the right main landing gear wheel assembly to the strut assembly.Mar 5, 1994 · N20768 · Substantial damageNTSB CHI94LA133Accident · No injuriesLimited investigationFinal reportBell 47-62 · Aurora, MOThe dual students inadequate flare and the pilot in command's (flight instructor) delayed remedial action.Mar 5, 1994 · N6711D · Substantial damage