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 MKC89LA084Accident · No injuriesLimited investigationFinal reportCessna 177 · Fort Dodge, IAThe failure of the pilot to adequately compensate for existing wind conditions, to flare properly, and to recover properly from a bounced landing. The gusty x-wind conditions contributed to the accident.NTSB FTW89LA072Accident · No injuriesLimited investigationFinal reportCessna A185F · Lake Arthur, LAThe failure of the pilot to see and avoid tree limbs that extended over the edge of the canal. Factors related to the accident were: the tree limbs and dirt bank near the edge of the selected landing area.NTSB BFO89FA024Accident · No injuriesField investigationFinal reportLearjet 25 · Roanoke, VACo-pilots poorly planned approach which resulted in an overrun landing. A contributing factor was the captains poor supervision of the approach and landing.NTSB BFO89LA025Accident · No injuriesLimited investigationFinal reportCessna 170A · Ravenswood, WVThe pilots decision to land with a tailwind and inadequately compensating for the wind conditions.NTSB NYC89LA103Accident · No injuriesLimited investigationFinal reportBeech A100 · Johnstown, PAFailure of the down lock plate, which allowed the landing gear to collapse.NTSB CHI89LA059Accident · No injuriesLimited investigationFinal reportCessna 150L · Sellersburg, INThe failure of the student pilot to control the airplane during the landing flare and touchdown. The student pilots lack of experience and gusty crosswinds are contributing factors to the accident.NTSB MIA89LA112Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Marathon, FLThe pilot failed to maintain directional control of the aircraft and inadvertently allowed it to ground loop. Crosswind was a contributing factor.NTSB ATL89LA108Accident · No injuriesLimited investigationFinal reportBeech A36 · Chamblee, GAThe inattention of the pilot which resulted in the inadvertent retraction of the landing gear during the landing roll.NTSB SEA89LA067Accident · No injuriesLimited investigationFinal reportCessna TU206 · Anacortes, WAThe pilot diverted his attention during the landing, which resulted in an improper flare & hard landing. His lack of recent flying experience was a related factor.NTSB CHI89FA058Accident · No injuriesField investigationFinal reportCessna 177RG · Rockford, ILThe inadequate servicing of the hydraulic fluid by maintenance personnel and the pilot's failure to extend the landing gear manually.NTSB ATL89LA109Accident · No injuriesLimited investigationFinal reportCessna 182Q · Pickens, SCImproper flare by the pilot and inadequate supervision of the flight by the other crew member.NTSB MKC89LA081Accident · No injuriesLimited investigationFinal reportRockwell S2R T34 · Heth, ARAircraft control not maintained by the pilot in command due to landing in a tailwind of excessive velocity which the pilot misjudged or failed to recognize.NTSB SEA89LA075Accident · No injuriesLimited investigationFinal reportCessna 150E · Hillsboro, ORThe improper landing flare performed by an unqualified person at the controls who had no flight training.NTSB NYC89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Honesdale, PAThe loss of directional control by the pilot during landing.NTSB NYC89LA100Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Lakewood, NJThe pilot's failure to adequately compensate for the crosswind conditions. Contributing to the accident were the crosswind conditions.NTSB ATL89LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Swainsboro, GAThe pilot's decision to land at an unlighted airstrip in low light conditions, and her subsequent, inadvertent selectionof unsuitable terrain bordering the runway.NTSB MIA89LA107Accident · No injuriesLimited investigationFinal reportCessna 402A · Miami, FLThe overload failure of the bellcrank for the left main gear retraction linkage assembly for an unknown reason.NTSB ATL89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tiffin, OHThe pilots improper recovery from a bounced landing which led to inadvertent porpoising and loss of directional control.NTSB MIA89LA106Accident · No injuriesLimited investigationFinal reportCessna 152 · Olive Branch, MSThe pilot's failure to maintain directional control which resulted in an inadvertent ground swerve. The crosswind and ditch were contributing factors.NTSB MIA89LA105Accident · No injuriesLimited investigationFinal reportCessna 150 · Arcadia, FLThe pilot's delayed to go around after landing long with excessive speed.NTSB MIA89LA104Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · St Augustine, FLInadvertently retraction of the landing gear, and failure of the instructor pilot (CFI) to note that the gear had been retracted. A factor related to the accident was: improper flare by the student pilot.NTSB CHI89LA060Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILImproper flare by the pilot. The crosswind (quartering headwind) was considered to be a factor.NTSB SEA89LA055Accident · Minor injuriesLimited investigationFinal reportCessna TU206-G · Reno, NVThe pilot's failure to adequately compensate for crosswinds. Contributing to the accident was the pilot's decision to land the amphibious aircraft in strong crosswind conditions.NTSB MIA89LA102Accident · Serious injuriesLimited investigationFinal reportAdams AX-9 · Jacksonville, FLThe failure of a passenger to follow pre-briefed instructions during landing.NTSB CHI89LA056Accident · No injuriesLimited investigationFinal reportCessna TR182 II · Sandwich, ILThe pilot's poor handling of the aircraft, improper flare and inadequate recovery from a bounced landing.NTSB MIA89LA099Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Ocala, FLFailure of the vehicle driver to see and yield to the acft that was landing on rwy 27. Contributing factors were: vehicle on the runway and inadequate visual lookout by the pilot.NTSB ANC89LA050Accident · No injuriesLimited investigationFinal reportCessna 185 · Shell Lake, AKThe pilot's improper inflight decision in selecting unsuitable terrain on which to land. Contributing to the accident was the rough/uneven terrain and the snowbank.NTSB NYC89LA108Accident · No injuriesLimited investigationFinal reportBeech TC-45J · Johnstown, PAFailure of the pilot to maintain runway alignment. The crosswind and snow covered runway were related factors.NTSB LAX89LA122Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Fullerton, CAThe failure of the pilot to maintain directional control during the landing roll.NTSB MKC89LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Cresco, IAFailure of the pilot to maintain control of the airplane during the landing on a closed runway.NTSB CHI89LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Superior, WIFailure of the pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were the icy and snow covered runway conditions and the snowbank.NTSB LAX89LA124Accident · No injuriesLimited investigationFinal reportCessna 182L · Upland, CAThe pilot failed to correct the attitude of the aircraft and achieve proper alignment with the runway prior to landing touchdown.NTSB ATL89LA097Accident · No injuriesLimited investigationFinal reportCessna 180J · W. Columbia, SCImproper torquing of the attachment bolt during installation by unknown person(s), which resulted in the separation of the bolt and nut and subsequent separation of the main landing gear from the airplane.NTSB MKC89LA071Accident · No injuriesLimited investigationFinal reportCessna 310 · Des Moines, IAThe failure of the pilot to properly flare the airplane. Contributing to the accident were the weather conditions.NTSB FTW89LA062Accident · No injuriesLimited investigationFinal reportCessna 421B · San Antonio, TXThe failure of the pilot to follow the proper procedures/directives by not following the glideslope which resulted in not being able to attain the proper touchdown point.NTSB MKC89LA073Accident · No injuriesLimited investigationFinal reportCessna 310Q · Norfolk, NEThe pilot's failure to maintain adequate airspeed during the landing which resulted in an inadequate flare. Contributingto the accident were the icing conditions and ice accumulation of the wings of the airplane.NTSB MKC89LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Griffithville, ARThe failure of the pilot to assure suitable terrain was being used for the landing.NTSB MKC89LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Crookston, MNThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was the icy/snow covered runway.NTSB MKC89LA068Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Harrisburg, ARThe failure of the hydraulic line which rendered the brake system inoperative.NTSB MKC89LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Rapids, MNThe pilot's failure to adequately compensate for the crosswind conditions. Contributing to the accident were the gusty crosswind conditions.NTSB NYC89FA092Accident · Minor injuriesField investigationFinal reportCessna S550 · Poughkeepsie, NYThe pilot's improper use of the powerplant controls, which resulted in actuation (tripping) of the reverse load limiters on the thrust reversers and subsequent reduction of available power in both engines. Factors related to the accident were: the pilot's…NTSB FTW89LA060Accident · No injuriesLimited investigationFinal reportCessna 172 · Jacksboro, TXFailure of the pilot to go around, when she did not attain the proper touchdown point (landed long) and had excessive airspeed to stop on the runway. A factor related to the accident was the unfavorable wind condition (sudden wind shift).NTSB FTW89LA058Accident · No injuriesLimited investigationFinal reportCessna 172 · Marietta, OKFailure of the pilot to select the proper runway, which resulted in a downwind landing and an overrun of the runway. The gusty tailwind, ditch, and railing (fence) were factors.NTSB FTW89DQA03Accident · No injuriesFinal reportBurkhart Grob G109B · El Paso, TXPilot in command's loss of control due to overcontrolling the aircraft. The situation was proceeded by a high sink rate that resulted in a hard landing with an inadequate recovery from a bounced landing. Contributing to the accident was the pilot's…NTSB ATL89LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Liberty, NCThe pilot's inadvertent landing at the wrong airport, contributing to the accident was the failure of the airport personnel to notify the FAA of the existance of the airport so it could be properly designated on aviation charts.NTSB SEA89LA051Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Albany, ORThe failure of the student pilot to maintain directional control of the airplane during landing and the improper use of flight controls. Contributing to the accident were the crosswind and the pilot's lack of total experience.NTSB MIA89IA094Incident · No injuriesIncident investigationFinal reportBeech B60 · Jacksonville, FLFailure of the left main landing gear retract rod due to poor maintenance and inspection of the main gear assembly.NTSB MIA89LA092Accident · No injuriesLimited investigationFinal reportBell 47G · Oklawaha, FLPilot's failure to properly control the helicopter during an attempted landing on the back of a truck. Contributing to the accident was the pilot's lack of experience in performing similar landings.NTSB NYC89FA089Accident · Minor injuriesField investigationFinal reportAerospatiale AS-350D · Spring Valley, NYFailure of the FAA flight examiner (f/e) to follow proper procedures concerning the autorotation, and improper remedial action by the pilot-in-command (PIC). Factors related to the accident were: lack of information in the flight manual concerning…NTSB LAX89DUJ05Accident · Serious injuriesFinal reportWarwick Thorp T-18 · Aguila, AZFailure of the pilot to maintain directional control, which resulted in the aircraft veering off the runway. Factors related to the accident were: uneven runway & the ditch.