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 CEN12LA635Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mecosta, MIThe pilot's improper landing flare, which resulted in a bounced landing and loss of airplane control.Sep 15, 2012 · N58844 · Substantial damageNTSB CEN12LA629Accident · No injuriesLimited investigationFinal reportVarga 2150A · Clinton, IAThe pilot of the other airplane failing to adequately monitor for other aircraft while landing.Sep 13, 2012 · N4651V · 2 aircraft · Substantial damageNTSB WPR12LA422Accident · No injuriesLimited investigationFinal reportHawker MK 11 SEA Fury · Reno, NVThe collapse of the right main landing gear due to failure of the landing gear rotary selector valve seal.Sep 11, 2012 · N4434P · Substantial damageNTSB CEN12CA644Accident · No injuriesData collectionFinal reportCessna 421C · Kenedy, TXThe pilot’s improper flare, which resulted in a hard landing and subsequent collapse of the landing gear.Sep 11, 2012 · N5534G · Substantial damageNTSB CEN12CA624Accident · No injuriesData collectionFinal reportCessna 172R · Salina, KSThe flight instructor's improper flare in gusty wind conditions, which resulted in a hard landing.Sep 11, 2012 · N824KS · Substantial damageNTSB CEN12CA641Accident · No injuriesData collectionFinal reportPiper PA-11 · Ft. Morgan, COThe pilot's loss of control during landing after encountering an unexpected wind gust.Sep 10, 2012 · N4589M · Substantial damageNTSB CEN12CA620Accident · No injuriesData collectionFinal reportCessna 172H · Phillipsburg, OHThe pilot’s improper flare, which resulted in a hard landing.Sep 9, 2012 · N2484L · Substantial damageNTSB ANC12CA104Accident · No injuriesData collectionFinal reportStinson 108-2 · Nikiski, AKThe pilot's selection of an unsuitable landing surface, which resulted in a loss of control during the landing roll.Sep 9, 2012 · N9723K · Substantial damageNTSB CEN12CA618Accident · No injuriesData collectionFinal reportBeech V35 · Decatur, TXThe pilot's inattention during the landing roll, which resulted in retraction of the landing gear instead of the flaps.Sep 8, 2012 · N149G · Substantial damageNTSB ERA12CA553Accident · No injuriesData collectionFinal reportCessna 182T · Marion, SCThe pilot's improper landing flare, which resulted in a hard landing.Sep 7, 2012 · N635CP · Substantial damageNTSB CEN12LA672Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Horseshoe Bay, TXThe off-centered right main landing gear ball joint, which resulted in the right main landing gear collapsing during landing.Sep 7, 2012 · N850ZM · Substantial damageNTSB CEN12CA612Accident · No injuriesData collectionFinal reportHawker Beechcraft G36 · Decatur, TXThe pilot's delay in executing the aborted landing, which resulted in a runway excursion.Sep 6, 2012 · N563AP · Substantial damageNTSB WPR12CA398Accident · No injuriesData collectionFinal reportLake John K MA-5 Charger · Eagle Mountain, UTThe airplane’s encounter with a large hole in the runway during the landing roll, which resulted in a loss of control and subsequent runway excursion.Sep 5, 2012 · N795MC · Substantial damageNTSB DCA12RA143Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoOn September 5, 2012, an Aeromexico Boeing 737-800, registration XA-JOY, experienced heavy vibration during the landing roll and multiple ceiling panels and passenger service units fell down in the aft cabin at Benito Juárez Mexico City International Airport…Sep 5, 2012 · XA-JOY · Minor damageNTSB WPR12CA393Accident · No injuriesData collectionFinal reportBeech 95-55 · Spanoway, WAThe pilot’s failure to lower the landing gear prior to landing.Sep 4, 2012 · N4QC · Substantial damageNTSB WPR12LA391Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Toledo, ORThe pilot’s failure to maintain directional control of the airplane after landing.Sep 3, 2012 · N3700V · Substantial damageNTSB WPR12CA397Accident · No injuriesData collectionFinal reportChampion 7GC · Spanish Fork, UTThe pilot’s failure to maintain directional control during the landing roll.Sep 3, 2012 · N61819 · Substantial damageNTSB WPR12CA390Accident · No injuriesData collectionFinal reportMaule MXT-7-180A · Manzanita, ORThe pilot’s inadequate compensation for the crosswind during landing, which resulted in a loss of directional control.Sep 3, 2012 · N353LS · Substantial damageNTSB ERA12CA560Accident · No injuriesData collectionFinal reportCessna 172S · Sebring, FLThe student pilot's improper flare, which resulted in a hard landing.Sep 3, 2012 · N9965P · Substantial damageNTSB CEN12CA608Accident · No injuriesData collectionFinal reportRolladen-Schneider OHG LS3-A · Navasota, TXThe pilot’s inadequate compensation for landing area conditions during an off-airport landing, which resulted in a loss of directional control and a collision with terrain.Sep 3, 2012 · N27UP · Substantial damageNTSB WPR12CA389Accident · Minor injuriesData collectionFinal reportCessna 182L · Metaline Falls, WAThe pilot’s inadequate compensation for a sudden wind shift during the landing roll, which resulted in a runway overrun.Sep 2, 2012 · N42014 · Substantial damageNTSB WPR12CA388Accident · Minor injuriesData collectionFinal reportPiggott John H Bearhawk · Sequim, WAThe student pilot's failure to maintain directional control on landing.Sep 2, 2012 · N347JP · Substantial damageNTSB ANC12CA099Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.Sep 2, 2012 · N67178 · Substantial damageNTSB ERA12FA540Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Falmouth, MAThe flight instructor’s inadequate remedial action. Contributing to the accident was the student pilot’s poor control of the airplane during the approach.Sep 1, 2012 · N221DV · Substantial damageNTSB ERA12CA569Accident · No injuriesData collectionFinal reportCessna 172S · Farmingdale, NYThe student pilot's improper landing flare, which resulted in a hard landing.Sep 1, 2012 · N2409E · Substantial damageNTSB CEN12CA614Accident · No injuriesData collectionFinal reportCessna L-19E · Lancaster, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Sep 1, 2012 · N4431F · Substantial damageNTSB CEN12CA596Accident · No injuriesData collectionFinal reportArvold Jordon R CH 750 · Colfax, WIThe pilot did not maintain control of the airplane while landing with a gusty crosswind.Sep 1, 2012 · N32JA · Substantial damageNTSB WPR12LA384Accident · Minor injuriesLimited investigationFinal reportCessna 182R · St. Johns, AZThe pilot’s delay in executing a go-around, which resulted in a runway overrun. Contributing to the accident were the pilot’s failure to establish the proper glidepath and airspeed on final approach and his improper use of flaps during the go-around.Aug 31, 2012 · N5458N · Substantial damageNTSB WPR12LA383Accident · No injuriesLimited investigationFinal reportCessna 177RG · Olympia, WAA loss of directional control during landing for reasons that could not be determined because postaccident examination of the nose gear steering mechanism did not reveal any anomalies that would have precluded normal operation.Aug 31, 2012 · N300ZX · Substantial damageNTSB ERA12IA550Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MACompany maintenance personnel’s failure to comply with the airplane manufacturer’s service instructions by not removing the cracked drag brace from service nor inspecting the repaired drag brace at the appropriate interval, which resulted in the failure of…Aug 31, 2012 · N769EA · Minor damageNTSB CEN12CA607Accident · No injuriesData collectionFinal reportNorth American AT-6F · Council Bluffs, IAAn unlocking of the excessively worn tailwheel lock mechanism, which resulted in a loss of directional control during landing.Aug 31, 2012 · N244GR · Substantial damageNTSB ANC12CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Aniak, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.Aug 31, 2012 · N3615M · Substantial damageNTSB ANC12CA098Accident · No injuriesData collectionFinal reportMaule M-5-210C · Juneau, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, resulting in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.Aug 31, 2012 · N378X · Substantial damageNTSB WPR12CA380Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe flight instructor’s delayed response in correcting the student pilot’s improper landing flare, which resulted in a hard landing.Aug 30, 2012 · N309PA · Substantial damageNTSB CEN12LA593Accident · No injuriesLimited investigationFinal reportMudge Ray KIT FOX 5 · Bowling Green, OHThe pilot receiving instruction's excessive braking during the landing roll, which resulted in a loss of control.Aug 30, 2012 · N84KF · Substantial damageNTSB ERA12LA535Accident · 1 fatalLimited investigationFinal reportBeech 95-A55 · Millville, NJThe pilot receiving instruction failed to maintain airplane control during the simulated engine-out landing. Contributing to the accident was the flight instructor's failure to take timely remedial action.Aug 29, 2012 · N71BM · Substantial damageNTSB CEN12CA671Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Goldsby, OKThe commercial pilot did not attain the proper touchdown point during the landing, which resulted in a premature touchdown and an impact with the edge of the runway surface.Aug 29, 2012 · N7602C · Substantial damageNTSB WPR12LA377Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Everett, WAA hard landing likely made by the private pilot on a solo flight that preceded the dual instructional flight during which the wing damage became obvious.Aug 28, 2012 · N4922T · Substantial damageNTSB WPR12CA375Accident · No injuriesData collectionFinal reportCessna 172 · Sand Point, IDA deer strike during the landing flare. Contributing to the accident was the airport’s lack of any deer incursion prevention measures, such as an airport perimeter fence.Aug 28, 2012 · N3082E · Substantial damageNTSB ANC12CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to identify the appropriate touchdown point, which resulted in a nose over.Aug 28, 2012 · N4316Z · Substantial damageNTSB DCA12WA131Incident · No injuriesForeign investigationBoeing 767 · London, United KingdomThe United Kingdom Air Accident Investigation Branch (AAIB) has notified the NTSB of an accident involving a Boeing 767 airplane that occurred on August 27, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…Aug 27, 2012 · N642UA · No damageNTSB CEN12LA584Accident · 1 fatalLimited investigationFinal reportTop Dog TD2 · Bemidji, MNThe pilot's failure to maintain aircraft control and his inadequate flare during landing. Contributing to the accident was the pilot’s failure to obtain training on the operation of the accident aircraft.Aug 27, 2012 · N71314 · Substantial damageNTSB CEN12CA576Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Watkins, COThe pilot did not maintain control of the airplane while landing in gusty wind conditions.Aug 25, 2012 · N215VS · Substantial damageNTSB ERA12CA533Accident · Minor injuriesData collectionFinal reportStearman M-2 · Robbinsville, NJThe pilot's failure to maintain directional control during the landing roll.Aug 24, 2012 · N9055 · Substantial damageNTSB DCA12WA133Accident · No injuriesForeign investigationDouglas DC9 · Santo Domingo, VenezuelaThe Venezuela Dirección General para la Prevención e Investigación de Accidentes Aéreos (PIAA) has notified the NTSB of an accident involving a Douglas DC-9-82 that occurred on August 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist…Aug 24, 2012 · YV493T · Substantial damageNTSB WPR12LA366Accident · No injuriesLimited investigationFinal reportPiper PA-30 B · Scappoose, ORThe failure of the landing gear to fully extend as a result of a failure of the landing gear transmission assembly for reasons that could not be determined based on the available evidence.Aug 23, 2012 · N222BP · Substantial damageNTSB ERA12CA558Accident · No injuriesData collectionFinal reportBeech 35-C33 · Burlington, NCThe pilot's improper landing flare, which resulted in a hard landing.Aug 22, 2012 · N331DP · Substantial damageNTSB CEN12CA574Accident · No injuriesData collectionFinal reportFantasy Air Sro Allegro 2000 · Centralia, ILThe pilot’s failure to maintain directional control of the airplane during the landing roll.Aug 22, 2012 · N25015 · Substantial damageNTSB CEN12CA564Accident · Minor injuriesData collectionFinal reportCessna T210N · Boulder, COThe pilot’s decision to continue the unstable approach, which resulted in a loss of control during landing and a runway excursion.Aug 22, 2012 · N85S · Substantial damageNTSB WPR12CA399Accident · No injuriesData collectionFinal reportCessna 182F · Hood River, ORThe pilot's improper landing flare and inadequate recovery from a bounced landing.Aug 20, 2012 · N34SR · Substantial damage