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 FTW04CA218Accident · No injuriesData collectionFinal reportBeech BE-58 · Groveton, TXThe pilot's intentional ground loop to avoid colliding with deer that entered the runway during the landing roll. A contributing factor was the tall grass adjacent to the runway that prevented detection of the deer.Aug 20, 2004 · N8140R · DestroyedNTSB ATL04CA168Accident · No injuriesData collectionFinal reportChristen Industries A1B · Hickory, NCThe pilot’s inadequate compensation for wind conditions and his failure to maintain directional control, during landing roll which resulted in a loss of control and collision with a trailer. The crosswind was a factor in the accident.Aug 20, 2004 · N367SA · Substantial damageNTSB DEN04LA127Accident · No injuriesLimited investigationFinal reportCessna 172S · Carlsbad, NMthe student pilot's inadequate flare resulting in a hard landing. A contributing factor was the tailwind conditions.Aug 19, 2004 · N849SP · Substantial damageNTSB SEA04CA170Accident · No injuriesData collectionFinal reportCessna 180J · Pittsburg, ORThe pilot's failure to maintain clearance from an object (pole) during an aborted landing. The pilot's delayed decision to abort the landing and a pole were factors.Aug 18, 2004 · N52096 · Substantial damageNTSB LAX04CA296Accident · No injuriesData collectionFinal reportPilatus PC-12/45 · Show Low, AZthe collision with an elk during the landing roll. The dark night lighting conditions was a factor.Aug 18, 2004 · N562NA · Substantial damageNTSB FTW04CA228Accident · No injuriesData collectionFinal reportMooney M20E · San Antonio, TXThe pilot's misjudged distance and his failure to abort the landing. A factor was the prevailing tailwind.Aug 18, 2004 · N3379X · Substantial damageNTSB DEN04IA126Incident · No injuriesIncident investigationFinal reportCessna 750 · Jackson, WYthe failure of the right main landing gear trailing link due to fatigue cracking initiated by an undetected manufacturing defect. A contributing factor was the improper plating process by unknown manufacture personnel.Aug 18, 2004 · N961QS · Minor damageNTSB CHI04CA230Accident · No injuriesData collectionFinal reportBowles Questair Venture · Liberal, KSThe loss of directional control during landing for undetermined reasons.Aug 18, 2004 · N39SB · Substantial damageNTSB IAD04CA038Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Eliot, METhe pilot's failure to maintain airspeed above stall which resulted in a hard landing and collapse of the landing gear. Also causal was the flight instructor's inadequate supervision.Aug 17, 2004 · N4631J · Substantial damageNTSB CHI04CA233Accident · No injuriesData collectionFinal reportEurocopter AS 350 B2 · New Hudson, MIThe autorotation performed by the dual student and the delayed remedial action by the certified flight instructor.Aug 17, 2004 · N631SD · Substantial damageNTSB SEA04CA160Accident · No injuriesData collectionFinal reportBeyers Kitfox IV · Sandpoint, IDThe pilot's failure to maintain aircraft control during the landing roll. Contributing factors were the rough grass runway, and the trees on the left side of the runway.Aug 16, 2004 · N90TY · Substantial damageNTSB LAX04CA303Accident · No injuriesData collectionFinal reportRockwell 112TC · Bullhead City, AZthe pilot's failure to extend the landing gear prior to landing. Factors in the accident were the pilot's failure to use a checklist and to verify that the gear were extended.Aug 16, 2004 · N54RR · Substantial damageNTSB FTW04LA214Accident · No injuriesLimited investigationFinal reportCessna T188C · Heth, ARThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Aug 16, 2004 · N9314J · Substantial damageNTSB DEN04CA125Accident · Minor injuriesData collectionFinal reportMaule M-6-235 · Dubois, WYthe pilot's misjudgment of altitude/distance resulting in an undershoot of the runway.Aug 16, 2004 · N167MC · Substantial damageNTSB CHI04LA232Accident · No injuriesLimited investigationFinal reportCessna 182S · Eastport, MIThe pilot misjudging the landing flare resulting in the hard landing and his unsuccessful remedial action following the bounced landing.Aug 15, 2004 · N537CR · Substantial damageNTSB CHI04CA228Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Elkhart, INThe failure of the seat during landing roll and the subsequent pilot's airplane handling not being possible.Aug 15, 2004 · N4303A · Substantial damageNTSB CHI04CA226Accident · No injuriesData collectionFinal reportDevereux Mustang II · Elkhart, INThe pilot not maintaining directional control during landing roll. A factor was the soft terrain, and the inadequate training in type aircraft.Aug 14, 2004 · N44DX · Substantial damageNTSB LAX04CA290Accident · No injuriesData collectionFinal reportCessna 172S · Honolulu, HIthe student pilot's misjudged flare, which resulted in a hard landing. Also causal was the student pilot's improper recovery from a bounced landing and pilot induced porpoise and failure to maintain directional control on the landing roll, which resulted in…Aug 13, 2004 · N3554Y · Substantial damageNTSB MIA04CA109Accident · No injuriesData collectionFinal reportCessna 172SP · Miami, FLThe pilot's failure to maintain control while landing with a crosswind and gusting wind conditions, which resulted in the airplane veering off the runway and incurring damage.Aug 12, 2004 · N21063 · Substantial damageNTSB FTW04LA213Accident · No injuriesLimited investigationFinal reportCessna A185F · New Braunfels, TXThe pilot's inadequate compensation for wind and his failure to maintain directional control. A contributing factor was the crosswind.Aug 12, 2004 · N1666R · Substantial damageNTSB CHI04CA222Accident · No injuriesData collectionFinal reportMooney M20J · Huntington, INThe pilot's inadequate flare and unsuccessful recovery from a bounced landing, and the pilot's and flight instructor's failure to maintain directional control and airspeed during the subsequent aborted landing, which resulted in a stall. A factor was the…Aug 11, 2004 · N201AM · Substantial damageNTSB LAX04CA289Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Scottsdale, AZthe pilot's misjudged flare, resulting in a stall and hard landing, and his failure to maintain directional control. The pilot's improper recovery from a bounced landing is a contributing factor.Aug 10, 2004 · N8414E · Substantial damageNTSB NYC04CA190Accident · Serious injuriesData collectionFinal reportClassic Waco YMF · Bar Harbor, METhe pilot's inadequate compensation for wind conditions. A factor was the crosswind.Aug 9, 2004 · N723SR · Substantial damageNTSB FTW04CA193Accident · Serious injuriesData collectionFinal reportHead Balloons AX8-88 · Baton Rouge, LAThe pilot's selection of an unsuitable area for landing. A contributing factor was the high vegetation.Aug 9, 2004 · N83063 · No damageNTSB NYC04CA189Accident · No injuriesData collectionFinal reportCessna 172P · Wilkes-Barre, PAThe student pilot's improper flare and improper recover from a bounced landing. Factors in this accident were the crosswind condition and the partial failure of the airplane's transceiver, as reported by the pilot.Aug 8, 2004 · N4599D · Substantial damageNTSB DEN04CA117Accident · Minor injuriesData collectionFinal reportMooney M20K · Jackson Hole, WYthe pilot's failure to maintain aircraft control resulting in a stall/mush. Contributing factors include the windshear, the crosswind and the runway light.Aug 8, 2004 · N11640 · Substantial damageNTSB CHI04CA216Accident · No injuriesData collectionFinal reportGlasflugel H301 · Hutchinson, KSThe pilot's improper decision to change the landing area at a low altitude and the inadequate flare that resulted in a hard landing.Aug 8, 2004 · N25KD · Substantial damageNTSB ANC04LA090Accident · No injuriesLimited investigationFinal reportCessna 185F · Wasilla, AKThe pilot's failure to compensate for a crosswind during landing and his failure to maintain directional control, which resulted in a loss of control and collision with a ditch. A factor contributing to the accident was a crosswind.Aug 8, 2004 · N61609 · Substantial damageNTSB CHI04LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Bradford, ILThe pilot's misjudgment of speed and distance, and his failure to perform a go-around. Additional factors were the wet runway and the ditch.Aug 6, 2004 · N6677Q · Substantial damageNTSB FTW04CA207Accident · No injuriesData collectionFinal reportBell 47G-3B-1 · Troy, TXThe flight instructor's improper flare, resulting in a hard landing. A contributing factor was the high density altitude.Aug 5, 2004 · N47713 · Substantial damageNTSB CHI04CA241Accident · No injuriesData collectionFinal reportCessna 172R · Olathe, KSThe student pilot flared too high and failed to recover from a bounced landing.Aug 5, 2004 · N458CM · Substantial damageNTSB ANC04CA088Accident · No injuriesData collectionFinal reportCessna 182F · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the ensuing aborted landing when the airplane encountered soft terrain. Factors contributing to the accident were the soft, swampy area surrounding the landing zone.Aug 5, 2004 · N3481U · Substantial damageNTSB ANC04CA085Accident · No injuriesData collectionFinal reportCessna 402C · Huslia, AKThe pilot's failure to extend the landing gear, which resulted in an inadvertent wheels up landing. A factor associated with the accident was the pilot's diverted attention.Aug 5, 2004 · N300SN · Substantial damageNTSB DEN04LA116Accident · No injuriesLimited investigationFinal reportMooney M20R · Aspen, COthe pilot's failure to maintain control of the airplane. Contributing factors was the pilot flaring the airplane too high, his misunderstanding of the instructor's attempt to take control of the airplane. and the instructor's inadequate supervision of the…Aug 4, 2004 · N4157 · Substantial damageNTSB MIA04CA116Accident · No injuriesData collectionFinal reportCessna 152 · Sarasota, FLThe student pilot's incorrect recovery following a bounced landing resulting in a hard landing and collapse of the nose landing gear.Aug 3, 2004 · N218JA · Substantial damageNTSB CHI04LA207Accident · No injuriesLimited investigationFinal reportSkystar Kitfox · Westfield, INthe failure of the pilot to maintain adequate airspeed resulting in a stall.Aug 3, 2004 · N197BR · Substantial damageNTSB NYC04CA184Accident · No injuriesData collectionFinal reportPascucci RAF 2000 · Beverly, MAThe pilot's failure to maintain aircraft control while landing. A factor in this accident was the crosswind condition.Aug 2, 2004 · N62188 · Substantial damageNTSB SEA04LA153Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Redmond, ORUnknown malfunction of the landing gear system for undetermined reasons that resulted in a gear collapse during landing.Aug 1, 2004 · N9394P · Substantial damageNTSB SEA04CA151Accident · No injuriesData collectionFinal reportPiper PA22-20 · Wht Sulphur Spg, MTThe failure of the private pilot receiving flight training for a tail wheel endorsement to maintain aircraft control, and his excessive braking during the landing roll, subsequently nosing over the airplane. A contributing factor was the flight instructor's…Aug 1, 2004 · N3838P · Substantial damageNTSB FTW04LA202Accident · No injuriesLimited investigationFinal reportCessna 140 · Kingston, OKThe failure by the other pilot to maintain visual lookout for other aircraft during landing.Aug 1, 2004 · N2632N · 2 aircraft · Substantial damageNTSB FTW04LA198Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · La Porte, TXThe loss of engine power for undetermined reasons.Aug 1, 2004 · N7892B · DestroyedNTSB CHI04CA211Accident · No injuriesData collectionFinal reportStamsta Wittman Tailwind W10 · Waunakee, WIThe pilot's failure to maintain proper airspeed during final approach, which resulted in the inadvertent stall/mush at a low altitude and subsequent hard landing. A factor to the accident was the pilot's unsuccessful remedial action to the encountered…Aug 1, 2004 · N917WT · Substantial damageNTSB NYC04LA182Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-27 · Windsor, VAThe pilot's improper use of a navigation aid, which resulted in him becoming lost, and having to perform a forced landing.Jul 31, 2004 · N127FP · Substantial damageNTSB MIA04CA114Accident · No injuriesData collectionFinal reportCessna 140 · Wimauma, FLThe improper in-flight weather evaluation by the student pilot resulting in a downwind landing and subsequent nose over.Jul 31, 2004 · N89617 · Substantial damageNTSB FTW04CA200Accident · No injuriesData collectionFinal reportBoeing A75N1 · Bay City, TXThe pilot's failure to maintain directional control during landing. A contributing factor was the pilot's decision to land with a quartering tailwind.Jul 31, 2004 · N75272 · Substantial damageNTSB DEN04LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Hurricane, UTthe student pilot's failure to maintain aircraft control during the landing. Contributing factors include the crosswind, the wind gusts, and the exceeded maximum demonstrated crosswind component.Jul 31, 2004 · N5426J · Substantial damageNTSB CHI04CA208Accident · No injuriesData collectionFinal reportCherkas Murphy Rebel · Dunseith, NDThe pilot's misjudged speed/distance, and his failure to maintain directional control during landing roll, which resulted in the inadvertent ground-loop.Jul 31, 2004 · C-GKHN · Substantial damageNTSB CHI04CA209Accident · Minor injuriesData collectionFinal reportCessna 172M · Sublette, KSThe student pilot's inadequate compensation for the crosswind condition, and her failure to maintain aircraft control during landing. Factors contributing to the accident included the student pilot's unsuccessful recovery from the bounced landings and the…Jul 30, 2004 · N105PD · Substantial damageNTSB SEA04CA149Accident · No injuriesData collectionFinal reportRobinson R-22 · Boise, IDThe pilot's failure to initiate a flare prior to contacting the ground while attempting to land the helicopter on a dark night. Factors include a distraction created by the flicker of a low rotor rpm light, the glare of nearby flood lights, and the lack of…Jul 29, 2004 · N8356R · Substantial damageNTSB LAX04LA284Accident · No injuriesLimited investigationFinal reportCessna 206 · Truckee, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control of the airplane.Jul 29, 2004 · N8622Z · Substantial damage