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 LAX05CA121Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's failure to maintain directional control.Mar 22, 2005 · N4101E · Substantial damageNTSB NYC05CA062Accident · No injuriesData collectionFinal reportCessna 150L · Mitchellville, MDThe pilot's inadequate compensation for wind conditions. A factor was the gusty wind conditions.Mar 19, 2005 · N11965 · Substantial damageNTSB IAD05LA049Accident · No injuriesLimited investigationFinal reportTaylorcraft F19 · Northampton, MAThe pilot/owner's improper decision to conduct the flight with a known deficiency in equipment, which resulted in a loss of control when the tailwheel springs became disconnected. Factors were the disconnection of the tailwheel springs, the snow bank, and…Mar 19, 2005 · N3679T · Substantial damageNTSB DEN05LA064Accident · No injuriesLimited investigationFinal reportCessna 177B · Rock Springs, WYthe pilot's improper flare and recovery from a bounced landing.Mar 19, 2005 · N30874 · Substantial damageNTSB ANC05LA051Accident · No injuriesLimited investigationFinal reportArctic S-1B2 · Anchorage, AKA main landing gear collapse during the landing touch down due to a non-secured clevis bolt at the common attach point on the landing gear oleo shock.Mar 19, 2005 · N67AT · Substantial damageNTSB MIA05LA081Accident · No injuriesLimited investigationFinal reportBeech C-45H · Panama City, FLThe overload failure of the left main landing gear for undetermined reasons during the landing roll resullting in collapse of the left main landing gear.Mar 18, 2005 · N231SK · Substantial damageNTSB DFW05CA091Accident · No injuriesData collectionFinal reportCessna 172N · Rio Grande City, TXThe pilot's failure to maintain clearance from objects, and his improper compensation for wind conditions while landing. A contributing factor was the gusty wind condition.Mar 18, 2005 · N6372D · Substantial damageNTSB LAX05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Flagstaff, AZthe loss of directional control during landing for undetermined reasons.Mar 15, 2005 · N504SR · Substantial damageNTSB SEA05LA065Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Graham, WAThe failure of the right main gear due to separation of the attachment hardware.Mar 13, 2005 · N5509M · Substantial damageNTSB SEA05LA064Accident · No injuriesLimited investigationFinal reportCessna 182Q · Shelton, WAThe pilot's improper flare which resulted in a hard landing.Mar 13, 2005 · N96985 · Substantial damageNTSB NYC05FA058Accident · 3 fatalField investigationFinal reportGrumman American AA-5 · Chesapeake, OHThe pilot's failure to maintain airspeed during the aborted landing, which resulted in an inadvertent stall.Mar 13, 2005 · N6511L · DestroyedNTSB MIA05LA077Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · DeLand, FLThe failure of the pilot to maintain sufficient airspeed during landing, resulting in an inadvertent stall, undershoot and collision with the ground.Mar 13, 2005 · N14420 · Substantial damageNTSB MIA05CA078Accident · No injuriesData collectionFinal reportCessna 180A · Orange Springs, FLThe pilot's failure to abort the landing and his misjudgment of the runway distance needed to complete the landing.Mar 13, 2005 · N5341D · Substantial damageNTSB LAX05LA178Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-26A · Blythe, CAthe pilot's failure to lower the landing gear prior to landing. A factor to the accident was the pilot's diverted attention due to the flap system anomaly.Mar 12, 2005 · N333WF · Substantial damageNTSB LAX05LA112Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Thermal, CAthe pilot's inadequate in-flight planning and failure to refuel the helicopter, which resulted in fuel exhaustion.Mar 12, 2005 · N5311V · Substantial damageNTSB ATL05CA062Accident · Minor injuriesData collectionFinal reportCessna 172P · Redstone Arsnl, ALThe pilot's failure to maintain adequate airspeed during approach, which resulted in an inadvertent stall and subsequent collision with the runway. Factors were the turbulence and crosswind conditions.Mar 12, 2005 · N5456K · DestroyedNTSB MIA05IA087Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Jacksonville, FLInadequate welding procedure by the manufacturer resulting in a poor weld of the nose landing gear and collapse of the nose landing gear during a porpoised landing.Mar 11, 2005 · N8160C · Minor damageNTSB LAX05CA111Accident · No injuriesData collectionFinal reportCessna 172A · Emigrant Gap, CAthe pilot's inadequate preflight planning and his selection of an unsuitable landing area, resulting in an encounter with a snow-covered runway.Mar 11, 2005 · N4682G · Substantial damageNTSB DFW05CA095Accident · No injuriesData collectionFinal reportAyres S-2R · Marvell, ARThe pilot's failure to maintain directional control while landing. A contributing factor was gusty winds.Mar 11, 2005 · N8422V · Substantial damageNTSB DFW05CA084Accident · No injuriesData collectionFinal reportGrumman G-164A · Gilbert, LAThe pilot's failure to maintain control of the airplane during landing. A contributing factor was a deflated right main tire.Mar 10, 2005 · N5327 · Substantial damageNTSB NYC05IA055Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAE-125-700A · Teterboro, NJThe pilot in command's inadequate in-flight planning, which resulted in an overrun landing on a contaminated runway. Factors were inadequate crew coordination, gusty winds, and a slush covered runway.Mar 9, 2005 · N703TS · Minor damageNTSB LAX05LA110Accident · No injuriesLimited investigationFinal reportCessna A185E · Tucson, AZa loss of directional control due to the failure of unknown maintenance personnel to install the tailwheel-locking collar, and the inadequate maintenance inspection of the worn tailwheel steering arm.Mar 9, 2005 · N4530F · Substantial damageNTSB ATL05CA060Accident · Minor injuriesData collectionFinal reportSavage RV-8 · Goldsboro, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.Mar 9, 2005 · N187WS · Substantial damageNTSB DFW05LA080Accident · Minor injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Shreveport, LAThe pilot's misjudgment of airspeed and his failure to abort the landing resulting in an overrun. A contributing factor was the wet runway.Mar 7, 2005 · N8098T · Substantial damageNTSB SEA05LA054Accident · 1 fatalLimited investigationFinal reportSimpkins RV-6A · Yamhill, ORThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in a nose over. Factors contributing to the accident included the wet runway and the embankment.Mar 6, 2005 · N664DS · Substantial damageNTSB MIA05CA072Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Opa Locka, FLThe dual student's improper descent rate during a simulated engine failure and simulated forced landing and the CFI's inadequate remedial action which resulted in a hard landing.Mar 6, 2005 · N21427 · Substantial damageNTSB ATL05CA059Accident · No injuriesData collectionFinal reportEcker Starduster 1 · Millington, TNThe malfunction of the left main landing gear wheel brake during landing roll on a grassy area, resulting in a nose over.Mar 6, 2005 · N74EK · Substantial damageNTSB ATL05CA057Accident · No injuriesData collectionFinal reportLuscombe 8A · Lexington, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.Mar 6, 2005 · N45524 · Substantial damageNTSB IAD05LA042Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Andover, NJThe pilot receiving instruction's failure to maintain directional control during the landing roll. Factors in the accident were the flight instructors delayed remedial action, and crosswind.Mar 5, 2005 · N87955 · Substantial damageNTSB DFW05LA081Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Westport, OKThe collapsing of the right main landing gear as a result of the failure of the scissors assembly.Mar 5, 2005 · N33AC · Substantial damageNTSB MIA05CA067Accident · No injuriesData collectionFinal reportCessna 172 · Jacksonville, FLThe pilot's improper landing flare which resulted in a hard landing.Mar 3, 2005 · N4980R · Substantial damageNTSB MIA05CA068Accident · No injuriesData collectionFinal reportCessna 305A · Bartow, FLThe pilots failure to maintain directional control resulting in the airplane ground-looping. A factor in the accident was the pilots lack of total experience in the airplane make and model.Mar 2, 2005 · N54550 · Substantial damageNTSB MIA05CA065Accident · No injuriesData collectionFinal reportCessna 172 · Madison, MSThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.Mar 2, 2005 · N212CF · Substantial damageNTSB CHI05CA075Accident · Serious injuriesData collectionFinal reportCessna 172K · Portage, WIThe pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…Feb 26, 2005 · N7325G · Substantial damageNTSB ANC05LA043Accident · No injuriesLimited investigationFinal reportCessna 185 · Russian Mission, AKThe pilot's misjudged landing flare during landing, which resulted in a hard landing and structural damage to the fuselage when the left main landing gear collapsed. A factor associated with the accident is pressure placed upon the pilot by the…Feb 26, 2005 · N80449 · Substantial damageNTSB SEA05LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · The Dalles, ORThe student pilot's improper compensation for the wind condition and the improper rejected landing procedure, which resulted in the collision with terrain. A contributing factor to the accident was the crosswind condition.Feb 22, 2005 · N181WC · Substantial damageNTSB MIA05LA062Accident · No injuriesLimited investigationFinal reportHoward DGA-15 · Daytona Beach, FLMaintenance personnel failure to detect corrosion in the landing gear strut, resulting in the gear collapsing during landing and damage to the airplane.Feb 22, 2005 · N68431 · Substantial damageNTSB DEN05LA061Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Spanish Fork, UTthe student's failure to maintain control of the helicopter. Contributing factors were high airspeed, high rate of descent, the instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.Feb 22, 2005 · N780SH · Substantial damageNTSB MIA05CA061Accident · No injuriesData collectionFinal reportCessna 172 · Brooksville, FLThe pilot's improper landing flare which resulted in substantial damage during the subsequent hard landing.Feb 21, 2005 · N98636 · Substantial damageNTSB LAX05LA103Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Kapolei, HIthe pilot's inadequate compensation for the quartering tailwind conditions, and his failure to maintain directional control of the airplane during landing. Related factors were the tailwind and crosswind.Feb 21, 2005 · N2248B · Substantial damageNTSB ATL05CA054Accident · No injuriesData collectionFinal reportPiper PA-22 · Holly Ridge, NCThe CFI's improper use of the rudder control and normal braking during the landing roll that resulted in the collapse of the nose gear assembly.Feb 18, 2005 · N1476A · Substantial damageNTSB SEA05CA050Accident · No injuriesData collectionFinal reportAviat Husky A-1 · Kalispell, MTThe pilot's failure to maintain clearance from a tree located off the departure end of his private airstrip during an aborted landing attempt. Factors include trees located near the departure end of the runway.Feb 17, 2005 · N22HU · Substantial damageNTSB LAX05CA098Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Chandler, AZthe students pilot's failure to maintain directional control resulting in a collision with the taxiway sign.Feb 17, 2005 · N80565 · Substantial damageNTSB MIA05LA059Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Brookhaven, MSThe pilot's inadequate compensation for wind and his failure to maintain control of the airplane during landing, which resulted in the airplane ground looping.Feb 16, 2005 · N39057 · Substantial damageNTSB ANC05LA041Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Kipnuk, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a departure from the runway and collision with a snow bank. A factor contributing to the accident was snow-covered terrain.Feb 16, 2005 · N36CF · Substantial damageNTSB LAX05CA096Accident · No injuriesData collectionFinal reportAeronca 7EC · Grass Valley, CAthe pilot's failure to maintain directional control.Feb 14, 2005 · N4725E · Substantial damageNTSB ANC05CA031Accident · Minor injuriesData collectionFinal reportDickson RV-7A · Panacea, FLThe pilot's misjudged landing flare, which resulted in a hard landing, the collapse of the nose gear, and subsequent nose over.Feb 12, 2005 · N429WD · Substantial damageNTSB LAX05CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Roosevelt, AZthe pilot's failure to maintain directional control.Feb 10, 2005 · N973EL · Substantial damageNTSB CHI05LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Grafton, NDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control during the landing. Factors associated with the accident were the crosswind condition and the snow bank.Feb 10, 2005 · N2291E · Substantial damageNTSB CHI05CA072Accident · No injuriesData collectionFinal reportGulfstream American 690C · Indianapolis, INThe pilot's failure to maintain directional control during landing touchdown and rollout. Contributing factors were the pilot's inadequate compensation for the crosswind condition, the runway light which the aircraft struck and the muddy grass area…Feb 10, 2005 · N840JK · Substantial damage