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.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DEN89LA163Accident · No injuriesLimited investigationFinal reportCessna A188B · Fort Benton, MTFailure of the tailwheel assembly attaching bolts.NTSB SEA89LA112Accident · No injuriesLimited investigationFinal reportCessna TU206G · Las Vegas, NVThe loss of directional control as a result of gusting wind conditions.NTSB NYC89LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Pittsburgh, PALoss of control during landing rollout due to excessive application of brakes by the pilot.NTSB MKC89LA133Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Ceour, MOThe failure of the pilot to plan the approach and maintain alignment with the sod landing strip. The pilot's innattention to the grass strip resulted in a landing in a soft wheat field.NTSB SEA89LA107Accident · No injuriesLimited investigationFinal reportCessna 180F · Reno, NVThe pilot's failure to maintain directional control during landing.NTSB ANC89FA091Accident · No injuriesField investigationFinal reportde Havilland DHC-2 · Anchorage, AKFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve.NTSB SEA89LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Gerlach, NVThe pilot displayed poor judgement by selecting unsuitable terrain for landing. As a result, the airplane nosed over during the landing roll on the soft terrain.NTSB SEA89LA106Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Longbranch, WAThe poor in-flight decision by the pilot to land on water, downwind. His failure to compensate for the wind conditions resulted in a loss of control and nose over of the airplane.NTSB CHI89LA107Accident · Serious injuriesLimited investigationFinal reportCessna 172I · New Era, MIThe pilot's misjudgement of the proper touchdown point.NTSB ANC89LA089Accident · No injuriesLimited investigationFinal reportCessna 150-L · Alexander River, AKThe failure of the pilot to land at the proper touchdown point and the resulting hard landing. Damage to the airplane precluded a go-around and resulted in the intentional swerve into a River to avoid injuries to people on the ground.NTSB CHI89LA108Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cedar, MIPilot in command attempting to land with too high an aispeed and with insufficient runway remaining to allow either a go around or the ability to bring the airplane to a stop in the space remaining.NTSB FTW89LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Austin, TXThe failure of the aircraft brake system. Factors include high tail wind.NTSB DEN89LA135Accident · No injuriesLimited investigationFinal reportCessna 210 · Halls Crossing, UTInadequate aircraft handling by the pilot, resulting in a runway overrun.NTSB CHI89LA106Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Elyria, OHFailure (shearing) of the right main gear attaching bolts. A contributing factor was: failure of the owner/operator to comply with service bulletin #673B.NTSB MKC89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Ft Leavenworth, KSThe student pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing to the accident was the student's lack of total experience.NTSB MKC89LA129Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Wynne, ARUnsuitable terrain selected by the pilot. A contributing factor was the rough/uneven landing area.NTSB MKC89LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Pine Bluff, ARImproper in-flight planning/decision by the pilot by continuing the approach when the runway lights did not activate. Contributing factors were: dark night and soft terrain.NTSB CHI89DET07Accident · No injuriesFinal reportGood Varieze · Spencerville, INThe pilot's failure to maintain proper runway alignment during the soft field landing.NTSB SEA89LA101Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Vancouver, WAThe pilot's failure to maintain directional control during landing ground roll, resulting in a ground loop and nose over. The crosswind is considered to be a contributing factor to the accident.NTSB NYC89DFJ01Accident · Minor injuriesFinal reportDavis DA-2A · Skaneateles, NYThe pilot's hard landing which resulted in nose gear collapse.NTSB SEA89LA097Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Boulder City, NVPoor judgement of the pilot by flying, while impaired from consumption of alcohol, and his delay in initiating a go-around when the aircraft drifted to the right of the runway. Related factors were: light conditions at dusk, unfavorable winds, and failure of…NTSB MKC89LA126Accident · Serious injuriesLimited investigationFinal reportOlson BD-4 · Cedar Rapids, IAPremature lift-off and inadvertent stall by the pilot. A loss of directional control and an inadvertent ground swerve by the pilot were contributing factors.NTSB MIA89LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Cedar Key, FLThe pilot's failure to maintain directional control during landing.NTSB MIA89LA169Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Lauderdale, FLThe pilot's late flare which resulted in a hard landing that exceeded the design stress limits of the airplane.NTSB BFO89LA041Accident · No injuriesLimited investigationFinal reportCessna 152 · Dover Afb, DEThe pilot's improper flare, improper recovery from a bounced landing, and his delay in initiating a go-around, which resulted in an uncontrolled porpoise, loss of directional control, and an uncontrolled ground swerve. His lack of experience, a crosswind, and…NTSB NYC89LA145Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Erwinna, PALoss control and collision with trees due to failure of the student pilot to compensate for the wind and lack of supervision by the CFI.NTSB ATL89LA156Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Myrtle Beach, SCThe improper installation/modification of the banner tow system, which jammed the rudder during a landing. The wind and terrain conditions were related factors.NTSB NYC89LA143Accident · No injuriesLimited investigationFinal reportBeech 60 · Philadelphia, PAImproper flare by the pilot during the landing, and his failure to maintain directional control of the aircraft.NTSB MKC89LA122Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Columbia, MOThe gear-up landing which was made by an unknown/unauthorized person.NTSB LAX89LA210Accident · No injuriesLimited investigationFinal reportBeech E-90 · Tuba City, AZThat ground personnel did not properly clear the runway of animals prior to reporting to the pilot that it was clear to land.NTSB ANC89LA083Accident · No injuriesLimited investigationFinal reportCessna 185F · Toksook Bay, AKThe pilot inadvertently landed on water with the gear extended.NTSB CHI89LA098Accident · No injuriesLimited investigationFinal reportCessna P210N · Wheeling, ILFailure of the pilot to extend the landing gear, which resulted in a wheels-up landing.NTSB ANC89LA080Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilots failure to maintain directional control of the aircraft during a touch and go landing which resulted in a ground loop.NTSB SEA89FA092Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Angoon, AKPilot failed to assure the landing gear on the amphibious floats were retracted for the water landing.NTSB DEN89FA123Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas MD-80 · Denver, COA right main landing gear vibration of unknown origin, which resulted in a failure of the right main landing gear torque link and side brace.NTSB NYC89LA137Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oneonta, NYThe pilot lost control of the aircraft while landing in gusty wind conditions.NTSB MIA89LA161Accident · No injuriesLimited investigationFinal reportCessna 182R · Tutwiler, MSLoss of control of the aircraft due to an encounter with a dust devil while on the ground.NTSB CHI89LA099Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Crandon, WIImproper inflight planning/decision by the pilot which resulted in loss of control & subsequent wingtip collision with the ground during the landing. The crosswind and turbulence were contributing factors.NTSB NYC89LA138Accident · No injuriesLimited investigationFinal reportHughes 269A · Swanton, VTThe pilot failed to maintain directional control.NTSB MIA89LA160Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Fort Lauderdale, FLFailure of the pilot to maintain directional control which resulted in an inadvertent ground swerve. The crosswind and the pilot's improper use of brakes were contributing factors.NTSB LAX89LA205Accident · No injuriesLimited investigationFinal reportCessna 190 · Livermore, CAThe failure of the flight instructor to maintain directional control. Contributing to the accident was the flight instructors lack of experience in this type aircraft.NTSB ATL89LA152Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Indian Trail, NCThe pilot's delay in aborting the landing after a bounced landing. Contributing factors were: improper flare by the pilot and the transmissions lines.NTSB SEA89LA096Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Hermiston, ORFailure and separation of the left main landing wheel.NTSB MKC89LA115Accident · No injuriesLimited investigationFinal reportCessna 180 · Duluth, MNThe failure of the pilot to maintain control of the aircraft while attempting to land in turbulent gusty wind conditions.NTSB MIA89IA156Incident · No injuriesIncident investigationFinal reportTemco GC-1B · Crestview, FLFailure of the pilots to maintain directional control of the aircraft. Contributing to the incident was the crosswind and lack of brakes avialable to the pilot-in-command (PIC).NTSB FTW89LA104Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Ardmore, OKThe flight instructor failed to recognize that the aircraft was developing a dangerous sink rate during the autorotation and take corrective action by executing a power recovery. Contributing to the accident were the gusty wind conditions.NTSB MIA89IA153Incident · No injuriesIncident investigationFinal reportBoeing 727-100 · Guantanamo, PRFailure of the pilot in command to properly compensate for a crosswind condition, and failure to utilize the proper crosswind landing technique.NTSB ANC89LA077Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Green Island, AKFailure of the pilot to select a suitable landing area. Factors related to the accident were: rough water conditions, and the pilot's lack of experience in this make and model of aircraft.NTSB SEA89LA090Accident · No injuriesLimited investigationFinal reportStits SA-3A · Jackpot, NVInadequate wind compensation by the pilot. Contributing to the accident were gusty grosswinds.NTSB MIA89FA151Accident · 1 fatalField investigationFinal reportCessna TU206F · Immokalee, FLThe pilot's failure to establish the descent angle which would attain the proper touchdown point. Consequently, the airplane collided, in flight, with the airport boundary fence.