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 CEN09LA318Accident · Serious injuriesLimited investigationFinal reportAerostar International S-60A · Albuquerque, NMThe pilot's excessive descent rate.May 25, 2009 · N120RB · No damageNTSB CEN09CA321Accident · No injuriesData collectionFinal reportCessna U206C · Brainerd, MNThe pilot's failure to maintain aircraft control while landing in gusty winds.May 25, 2009 · N3970G · Substantial damageNTSB WPR09CA260Accident · No injuriesData collectionFinal reportStinson SR-8B · Tacoma, WAThe application of unintended braking input due to the pilot's failure to keep his feet correctly positioned on the rudder pedals during the landing roll.May 24, 2009 · N17119 · Substantial damageNTSB ERA09CA307Accident · No injuriesData collectionFinal reportAerotek Pitts Spec · Beaver Falls, PAThe pilot’s failure to maintain directional control of the airplane during the landing rollout.May 24, 2009 · N55MF · Substantial damageNTSB CEN09LA319Accident · No injuriesLimited investigationFinal reportMileski Zenair · New Hudson, MIThe pilot's improper flare which resulted in a hard landing and subsequent failure of the nose landing gear.May 24, 2009 · N701MW · Substantial damageNTSB CEN09CA314Accident · No injuriesData collectionFinal reportJabiru J230-SP · Delavan, WIThe pilot's failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.May 24, 2009 · N685J · Substantial damageNTSB WPR09CA271Accident · No injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 235 · Ontario, ORThe pilot's misjudged landing flare. Contributing to the accident was the pilot's lack of any experience in the make and model airplane.May 23, 2009 · N315RA · Substantial damageNTSB CEN09CA317Accident · Serious injuriesData collectionFinal reportCessna 182E · Martinsville, INThe pilot's failure to attain the proper touchdown point during landing and his delay in initiating a successful go-around, which resulted in a loss of airspeed and an aerodynamic stall.May 22, 2009 · N3229Y · Substantial damageNTSB ERA09CA301Accident · No injuriesData collectionFinal reportCessna 172N · Tunkhannock, PAThe pilot's failure to attain the proper touchdown point while landing with a tailwind.May 21, 2009 · N9492E · Substantial damageNTSB ERA09CA300Accident · No injuriesData collectionFinal reportTecnam P2002 · Stevensville, MDThe pilot's failure to maintain proper airspeed on final approach, which resulted in an aerodynamic stall.May 21, 2009 · N524LM · Substantial damageNTSB CEN09CA320Accident · No injuriesData collectionFinal reportBeech B19 · Winsted, MNThe student pilot's improper flare during the soft-field landing. Contributing to the accident was the flight instructor's inadequate supervision during the landing.May 21, 2009 · N3214L · Substantial damageNTSB CEN09CA310Accident · No injuriesData collectionFinal reportLuscombe 8E · Ozona, TXThe pilot's failure to maintain directional control of the airplane during landing.May 21, 2009 · N2450K · Substantial damageNTSB WPR09CA257Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZThe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control on the landing roll out.May 20, 2009 · N1591A · Substantial damageNTSB WPR09CA252Accident · No injuriesData collectionFinal reportCessna 185E · Tacoma, WAThe pilot's failure to maintain directional control while landing with a crosswind.May 18, 2009 · N70083 · Substantial damageNTSB WPR09FA246Accident · Minor injuriesField investigationFinal reportCessna 172 · Burlington, WAThe failure of the pilot of another airplane to maintain adequate visual lookout during the approach.May 17, 2009 · N70323 · 2 aircraft · Substantial damageNTSB WPR09CA266Accident · No injuriesData collectionFinal reportCessna 172S · Flagstaff, AZThe student pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control during landing.May 17, 2009 · N541ER · Substantial damageNTSB WPR09CA265Accident · No injuriesData collectionFinal reportBoeing E75 · Cottonwood, AZThe pilot's inadequate compensation for the crosswinds during the landing roll.May 17, 2009 · N4787V · Substantial damageNTSB CEN09CA301Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Las Cruces, NMThe pilot's failure to maintain directional control while landing in a crosswind. Contributing to the accident was the pilot's decision to land on a runway with a prevailing crosswind.May 17, 2009 · N8042D · Substantial damageNTSB ANC09CA044Accident · No injuriesData collectionFinal reportMaule M-4-220C · Nenana, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.May 17, 2009 · N2031U · Substantial damageNTSB ERA09LA295Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout, which resulted in excessive side loads to the right main landing gear and the separation of the outer main landing gear rib from the right wing.May 16, 2009 · N323JT · Substantial damageNTSB ANC09CA046Accident · Minor injuriesData collectionFinal reportWinship Kent S Dogger Craft · Palmer, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a nose over and substantial damage to the airplane.May 16, 2009 · N530KW · Substantial damageNTSB ANC09CA043Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll, resulting in a ground loop and substantial damage to the airplane.May 15, 2009 · N1999P · Substantial damageNTSB CEN09CA300Accident · Minor injuriesData collectionFinal reportDiamond DA20 · Olathe, KSThe student pilot's improper landing flare and recovery from a bounced landing, as well as his improper decision to continue the takeoff after striking the propeller on the runway.May 14, 2009 · N926AF · Substantial damageNTSB WPR09CA243Accident · No injuriesData collectionFinal reportART Lee Delano CH701 · Oakdale, CAThe pilot's inadequate compensation for the gusty crosswind conditions while landing.May 13, 2009 · N701LD · Substantial damageNTSB CEN09IA294Incident · Minor injuriesIncident investigationFinal reportBoeing 737 · Houston, TXThe pilot's inadvertent application of excessive braking after touchdown, which caused the right wheels to lock and several tires to blow and resulted in a subsequent brake fire.May 13, 2009 · N371SW · Minor damageNTSB CEN09CA305Accident · No injuriesData collectionFinal reportFlight Design CT2K · Mitchell, SDThe pilot's inadequate compensation for the gusting winds during landing.May 13, 2009 · N433CT · Substantial damageNTSB CEN09CA293Accident · No injuriesData collectionFinal reportCessna 170B · Roswell, NMThe pilot's failure to maintain directional control while landing.May 13, 2009 · N3210A · Substantial damageNTSB CEN09LA291Accident · No injuriesLimited investigationFinal reportUnivair Ercoupe · Brighton, MIThe pilot's failure to attain the proper touchdown point, and his failure to initiate a go-around.May 12, 2009 · N99811 · Substantial damageNTSB CEN09CA292Accident · No injuriesData collectionFinal reportCessna 172N · Springdale, ARThe student pilot's failure to maintain control of the airplane during the landing roll and subsequent go-around.May 12, 2009 · N73842 · Substantial damageNTSB ANC09CA039Accident · No injuriesData collectionFinal reportCessna 170B · Kenai, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop. A factor contributing to the accident was the pilot's diverted attention during the landing.May 12, 2009 · N3469C · Substantial damageNTSB ERA09CA287Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Danville, PAThe student pilot's failure to maintain control during a landing.May 11, 2009 · N8403R · Minor damageNTSB WPR09LA236Accident · No injuriesLimited investigationFinal reportCessna 140 · Mesquite, NVThe pilot's loss of directional control during landing resulting from binding of the left wheel's brake actuating system for an undetermined reason.May 10, 2009 · N73017 · Substantial damageNTSB CEN09CA304Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · San Antonio, TXThe instructor pilot’s improper landing flare.May 10, 2009 · N169PA · Substantial damageNTSB WPR09LA242Accident · No injuriesLimited investigationFinal reportCessna 182M · Madera, CAThe pilot’s failure to maintain directional control of the airplane throughout the landing.May 9, 2009 · N71165 · Substantial damageNTSB WPR09CA280Accident · No injuriesData collectionFinal reportAeronca 7AC · El Cajon, CAThe pilot's failure to maintain directional control while landing with gusting crosswinds.May 9, 2009 · N3370E · Substantial damageNTSB WPR09CA233Accident · No injuriesData collectionFinal reportCessna 172R · Coeur d'Alene, IDThe student pilot's inadequate compensation for the crosswinds while landing.May 9, 2009 · N2383Q · Substantial damageNTSB ERA09CA299Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Montgomery, NYThe student pilot's failure to maintain aircraft control on landing. Contributing to the accident was the flight instructor's lack of total experience as an instructor and delayed corrective action.May 9, 2009 · N482MA · Substantial damageNTSB DCA09FA048Accident · Serious injuriesField investigationFinal reportBoeing DC-10 · Baltimore, MDthe captain’s inappropriate control inputs following a firm landing, resulting in two hard nose-gear impacts before executing a go-around. Contributing to the inappropriate control inputs was the captain’s fatigue and physical discomfort; and a possible lack…May 6, 2009 · N139WA · Substantial damageNTSB DCA09FA047Accident · Minor injuriesField investigationFinal reportAirbus A320 · Denver, COThe first officer’s excessive pitch-up of the airplane while landing with a tailwind, which resulted in a tailstrike following a bounced landing. Contributing to the bounced landing were a high descent rate and excessive thrust resulting from the first…May 4, 2009 · N311US · Substantial damageNTSB ERA09CA277Accident · No injuriesData collectionFinal reportPiper PA-30 · Great Barrington, MAThe pilot's improper decision to land with a tailwind.Apr 30, 2009 · N8034Y · Substantial damageNTSB ERA09CA275Accident · No injuriesData collectionFinal reportPiper PA-12 · Georgetown, SCThe pilot's failure to maintain directional control during landing roll. Contributing to the accident was the pilot’s lack of experience in the make and model airplane.Apr 29, 2009 · N3036M · Substantial damageNTSB ERA09IA267Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MAInstallation of an improper bearing in the landing gear actuator.Apr 27, 2009 · N769EA · Minor damageNTSB WPR09LA217Accident · Minor injuriesLimited investigationFinal reportGoodacre CA4-HP · Mansfield, WAThe pilot's failure to maintain aircraft control while landing with a known crosswind condition.Apr 26, 2009 · N33254 · Substantial damageNTSB ERA09CA276Accident · Serious injuriesData collectionFinal reportArbc Inc DBA Lindstrand 60X · Louisville, KYThe passenger's inadequate bracing during landing.Apr 26, 2009 · N877LX · No damageNTSB ANC09LA035Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Palmer, AKThe non-certificated pilot’s decision to attempt to "ski" atop a water-covered tidal area in an airplane equipped with over-sized main landing gear tires, resulting in a loss of control and a nose over.Apr 26, 2009 · N3256B · Substantial damageNTSB ERA09CA268Accident · No injuriesData collectionFinal reportDiamond DA20 · Townsend, GAThe pilot's failure to maintain directional control during a landing roll with a crosswind. Contributing to the accident was the pilot's lack of experience in the make and model airplane.Apr 25, 2009 · N561CS · Substantial damageNTSB ERA09CA265Accident · Minor injuriesData collectionFinal reportCessna 172E · Como, MSThe pilot's inadequate recovery from a bounced landing.Apr 25, 2009 · N5683T · Substantial damageNTSB WPR09CA229Accident · No injuriesData collectionFinal reportSiai-Marchetti SM 1019 · Novato, CAThe pilot's inadequate compensation for the gusting crosswinds. Contributing to the accident was the flight instructor's failure to take timely remedial action.Apr 24, 2009 · N391RV · Substantial damageNTSB ERA09CA278Accident · No injuriesData collectionFinal reportCessna 172N · Pinehurst, NCThe student pilot's improper landing flare.Apr 24, 2009 · N500TC · Substantial damageNTSB ERA09LA258Accident · 1 fatalLimited investigationFinal reportCessna A188B · Pinehurst, GAThe pilot's failure to maintain aircraft control for undetermined reasons.Apr 23, 2009 · N4789Q · Substantial damage