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 CHI93LA106Accident · Minor injuriesLimited investigationFinal reportBeech A23-19 · Farmington, MOThe pilot's failure to maintain aircraft control.Mar 8, 1993 · N6908Q · Substantial damageNTSB LAX93LA142Accident · No injuriesLimited investigationFinal reportChampion 7EC · Riverside, CAThe cfi's inadequate supervision of the flight, the dual student's failure to maintain directional control and improper use of the normal brakes. Contributing to this accident was the dual student's improper use of the rudder.Mar 7, 1993 · N9099B · Substantial damageNTSB FTW93LA098Accident · No injuriesLimited investigationFinal reportCessna 177 · Overbrook, OKThe pilot's improper compensation for wind conditions and his failure to recover from a bounced landing. A factor was turbulenceMar 7, 1993 · N3103T · DestroyedNTSB MIA93LA081Accident · No injuriesLimited investigationFinal reportRoot, Arthur T. Delta Dyke JD-2 · Sebastian, FLThe pilot-in-command's improper flare and recovery from a bounced landing, resulting in a hard landing which caused landing gear failure. Contributing to the accident was the pilot's lack of total flight time and flight time in the make and model.Mar 6, 1993 · N641AR · Substantial damageNTSB CHI93LA105Accident · No injuriesLimited investigationFinal reportCessna 172M · Romeo, MIThe pilot's failure to maintain directional control.Mar 6, 1993 · N20043 · Substantial damageNTSB CHI93LA101Accident · No injuriesLimited investigationFinal reportBeech 200 · Chesterfield, MOThe pilot's failure to maintain directional control after encountering whiteout conditions in the landing flare.Mar 3, 1993 · N7257T · Substantial damageNTSB BFO93LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · New Cumberland, PAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was the tailwind and the student pilot's lack of total experience.Mar 3, 1993 · N4705Q · Substantial damageNTSB BFO93LA039Accident · No injuriesLimited investigationFinal reportCessna 335 · Owensboro, KYFailure of airport personnel to report the runway condition by NOTAM when airport snow removal personnel left snow piled on the edges of the runway. Factors related to the accident were: dark night, fog, and the snowbank.Mar 3, 1993 · N26CP · Substantial damageNTSB CHI93LA108Accident · No injuriesLimited investigationFinal reportCessna 150M · Aurora, MOThe pilot-in-command's failure to maintain directional control.Mar 2, 1993 · N704RS · Substantial damageNTSB DEN93LA029Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Broomfield, CORudder control interference.Mar 1, 1993 · N4908G · DestroyedNTSB BFO93LA037Accident · No injuriesLimited investigationFinal reportCessna 182Q · Gettysburg, PAThe pilot's inadequate in-flight decision to land on the snow covered runway that was not currently maintained. Contributing to the pilot's decision was the inadequate report of the runway's condition.Mar 1, 1993 · N95747 · Substantial damageNTSB SEA93LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Winnett, MTThe student pilot's failure to maintain directional control. Factors contributing to the accident were the snowbank and lack of total experience in type operation.Feb 28, 1993 · N789FG · Substantial damageNTSB DEN93LA028Accident · No injuriesLimited investigationFinal reportMaule M-5-220C · Englewood, COFailure by the pilot to maintain control of the aircraft. A factor was: lack of experience in type of aircraft.Feb 28, 1993 · N16CB · Substantial damageNTSB CHI93LA100Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Mason City, IAExcessive braking by the dual student.Feb 28, 1993 · N2611K · Substantial damageNTSB BFO93LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Napoleon, OHThe intentional stall resulting in a hard landing. Contributing to the accident was the premature flare which led to an exceeded proper touchdown point and the student pilot's lack of overall experience.Feb 28, 1993 · N5220W · Substantial damageNTSB CHI93LA098Accident · No injuriesLimited investigationFinal reportCessna 172M · Grain Valley, MOThe student pilot's improper recovery from a bounced landing and failure to maintain directional control.Feb 27, 1993 · N64425 · Substantial damageNTSB CHI93LA112Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Brainerd, MNThe pilot's improper flare which resulted in a bounced, hard landing and the subsequent loss of directional control.Feb 26, 1993 · N44109 · Substantial damageNTSB CHI93LA096Accident · No injuriesLimited investigationFinal reportCessna 172K · Jackson, MIThe pilot's failure to maintain directional control.Feb 25, 1993 · N46460 · Substantial damageNTSB CHI93LA095Accident · No injuriesLimited investigationFinal reportCessna 150M · Canton, MIThe student pilot's failure to maintain directional control.Feb 25, 1993 · N9297U · Substantial damageNTSB LAX93LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Santa Ana, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain an adequate approach reference airspeed. Factors in the accident were the pilot's low experience in the aircraft.Feb 24, 1993 · N43Y · Substantial damageNTSB FTW93LA089Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Indian Village, LALanding performed short of the runway threshold. Factor was wet grassy terrainFeb 22, 1993 · N48455 · Substantial damageNTSB CHI93LA092Accident · No injuriesLimited investigationFinal reportCessna 185F · Bridgeport, NEThe pilot's failure to maintain proper runway alignment during the landing roll.Feb 21, 1993 · N252W · Substantial damageNTSB LAX93LA128Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Palo Alto, CAThe pilots inadequate compensation for the existing crosswind condition and his resultant loss of directional control.Feb 20, 1993 · N5506C · Substantial damageNTSB LAX93LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bakersfield, CAThe overload failure of the right main landing gear strut attach bolts due to a hard landing. The hard landing was the result of the student misjudging the landing flare, and, the inadequate supervision of the flight by the flight instructor.Feb 20, 1993 · N9750K · Substantial damageNTSB BFO93LA031Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Hudson, NYFailure of the pilot to maintain directional control, which resulted in an advertent ground swerve. The snowbank was a related factor.Feb 20, 1993 · N999HF · Substantial damageNTSB ANC93LA036Accident · No injuriesLimited investigationFinal reportMaule M5 · Chena Hot Sprng, AKThe total failure of the landing gear axle as a result of a pre existing fracture in the axle.Feb 20, 1993 · N9176E · Substantial damageNTSB BFO93LA028Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Pittsfield, METhe pilot's inadequate inflight decision to continue a landing without runway lights, and his delay in initiating a go-around. A related factor was the pilot's over confidence in his ability.Feb 19, 1993 · N6192A · Substantial damageNTSB FTW93LA088Accident · No injuriesLimited investigationFinal reportCessna 340A · Clovis, NMThe pilot's failure to execute a go around. Factors were the tailwind, the icy runway conditions and the pilot's improper touchdown pointFeb 18, 1993 · N2666J · Substantial damageNTSB CHI93LA091Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Evansville, INThe partial failure of the normal brake system.Feb 18, 1993 · N3733B · Substantial damageNTSB SEA93LA066Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Battleground, WAThe pilot in command's allowing the aircraft to enter a stall/spin condition. Factors contributing to the accident were a tailwind, power lines and trees.Feb 16, 1993 · N2100V · DestroyedNTSB LAX93LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Galt, CAThe pilot's inadequate compensation for the existing crosswind conditions and his failure to maintain directional control of the aircraft. A factor in the accident was the pilot's limited total flight experience.Feb 16, 1993 · N67615 · Substantial damageNTSB LAX93LA121Accident · No injuriesLimited investigationFinal reportBeech C35 · Susanville, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot's misjudging his distance and altitude and the prevailing light snow conditions.Feb 16, 1993 · N1844D · Substantial damageNTSB LAX93LA122Accident · No injuriesLimited investigationFinal reportCessna 182E · Corning, CAThe pilot's poor preflight inspection. Factors relating to this accident were the not properly secured oil cap and the oil covered windshield.Feb 15, 1993 · N9300X · Substantial damageNTSB FTW93LA086Accident · No injuriesLimited investigationFinal reportH. Raymond Busby Mustang II · Arlington, TXThe pilot's failure to attain the proper touchdown point and his delay in initiating the aborted landing. A factor was the wet runway and deteriorated braking actionFeb 14, 1993 · N80RH · DestroyedNTSB BFO93IA026Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Portland, METhe pilot in command's excessive airspeed during approach, and his failure to follow the proper braking procedures during landing as per company training. Factors contributing to the accident include a tailwind and a wet, downhill runway.Feb 13, 1993 · N403PE · No damageNTSB LAX93LA116Accident · No injuriesLimited investigationFinal reportCessna 210 · Fullerton, CAThe pilot's failure to follow the checklist. A factor relating to this accident was the misadjustment of the landing gear locking mechanism which caused intermittent operation.Feb 12, 1993 · N9668T · Substantial damageNTSB FTW93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ruston, LAFailure at a hydraulic fitting, which resulted in a hydraulic leak, loss of hydraulic fluid, and subsequent loss of braking action during the landing roll.Feb 11, 1993 · N6290Y · Substantial damageNTSB BFO93LA025Accident · No injuriesLimited investigationFinal reportCessna 172RG · White Plains, NYThe collapse of the left main landing gear for an undetermined reason.Feb 10, 1993 · N6433V · Substantial damageNTSB MIA93LA066Accident · No injuriesLimited investigationFinal reportCessna 172K · Plymouth, FLUndetected damage to the right main gear brake line which developed a leak and resulted in failure of the brake. The pilot was unable to maintain directional control, or stop the aircraft, prior to colliding with aircraft parked to the side of the runway.Feb 9, 1993 · N79563 · Substantial damageNTSB CHI93LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lincoln, NEThe pilot's failure to attain the proper touchdown point and failure to abort the landing. The wet, grass landing area was a factor.Feb 7, 1993 · N1253T · Substantial damageNTSB MIA93LA063Accident · No injuriesLimited investigationFinal reportBates Barracuda I · Bay St. Louis, MSUndetermined due to the destruction of the airplane after the gear collapsed on landing.Feb 6, 1993 · N852DH · DestroyedNTSB CHI93LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lafayette, INThe pilot-in-command's decision to initiate flight into known icing conditions which resulted in an accummulation of airframe ice. The icing conditions and the pilot's disregard of the weather advisory were factors.Feb 6, 1993 · N8784W · Substantial damageNTSB ATL93LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Fuquay-Varina, NCThe student pilot's failure to judge a proper touchdown point, and his failure to maintain directional control after landing. A factor was the pilot's lack of total experience.Feb 5, 1993 · N49945 · Substantial damageNTSB SEA93LA062Accident · Minor injuriesLimited investigationFinal reportCessna 185E · North Bend, ORThe pilot's failure to maintain directional control, and inadequate remedial action. Factors include a poor inflight decision, and gusty crosswinds.Feb 4, 1993 · N5849J · Substantial damageNTSB NYC93LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Valley Point, WVThe failure of the pilot to make a rejected landing when the airplane failed to decelerate properly. A factor related to the accident was the failure of the pilot to close the throttle upon touchdown.Feb 4, 1993 · N9839V · Substantial damageNTSB SEA93LA061Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Medford, ORMovement of the tailwheel assembly was restricted. Improper maintenance was a factor.Feb 2, 1993 · N11096 · Substantial damageNTSB CHI93LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Pontiac, MIFailure of the student pilot to maintain directional control.Feb 2, 1993 · N68155 · Substantial damageNTSB CHI93LA084Accident · No injuriesLimited investigationFinal reportPiper PA-12 · White Bear Lake, MNThe pilot selected unsuitable terrain for landing. The snow covered runway was a factor.Feb 2, 1993 · N3854M · Substantial damageNTSB FTW93LA079Accident · No injuriesLimited investigationFinal reportCessna 150M · Bowie, TXThe student pilot's inadequate compensation for the gusty crosswind, and his improper decision to attempt a takeoff after touching down off the runway surface. Factors which contributed to the accident was the gusting wind condition and the high grass.Feb 1, 1993 · N9199U · Substantial damageNTSB CHI93LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Warren, MNThe pilot's inadequate compensation for variable wind conditions during landing. The crosswind was a factor.Feb 1, 1993 · N3571V · Substantial damage