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 ERA12LA195Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Americus, GAThe failure of maintenance personnel to properly secure a portion of the right wing leading edge, which resulted in the separation of the associated section of the leading edge during takeoff and the loss of directional control during the subsequent landing.Feb 25, 2012 · N59661 · Substantial damageNTSB CEN12LA168Accident · No injuriesLimited investigationFinal reportCessna 180H · Conroe, TXThe pilot’s failure to maintain directional control during the landing. Contributing to the accident was the flight instructor’s delayed intervention and the pilot’s lack of experience in tailwheel airplanes.Feb 21, 2012 · N3SM · Substantial damageNTSB WPR12CA134Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Dillingham, HIThe student pilot’s inadequate recovery from a bounced landing.Feb 20, 2012 · N103SH · Substantial damageNTSB DCA12WA040Incident · No injuriesForeign investigationDornier 328 · Reykjavik, IcelandThe Iceland Air Accident Investigation Board (AAI) has notified the NTSB of an incident involving a Dornier D328 that occurred on February 20, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions…Feb 20, 2012 · N953EF · Minor damageNTSB ANC12CA023Accident · No injuriesData collectionFinal reportCessna 182A · Anchorage, AKThe pilot's inadvertent landing on a frozen lake in dark night conditions.Feb 20, 2012 · N6147B · Substantial damageNTSB WPR12CA114Accident · No injuriesData collectionFinal reportAeronca 7BCM · Woodland, CAThe pilot did not maintain directional control during landing.Feb 19, 2012 · N6451C · Substantial damageNTSB ERA12CA211Accident · No injuriesData collectionFinal reportCessna 172M · Mayaquez, PRThe pilot did not maintain control of the airplane while landing in crosswind conditions.Feb 19, 2012 · N5286H · Substantial damageNTSB CEN12LA176Accident · No injuriesLimited investigationFinal reportAviat A-1C-200 · Bowling Green, OHThe pilot’s failure to maintain directional control during landing.Feb 19, 2012 · N45TT · Substantial damageNTSB ERA12CA189Accident · No injuriesData collectionFinal reportCessna 172S · Caldwell, NJThe student pilot’s loss of directional control during a crosswind landing.Feb 18, 2012 · N506SP · Substantial damageNTSB CEN12LA218Accident · No injuriesLimited investigationFinal reportCessna 182A · New Philadelphia, OHThe inadequate maintenance of the wheel attachment bolts, which resulted in the left wheel separating from the landing gear during landing due to ductile overstress fractures.Feb 18, 2012 · N20DE · Substantial damageNTSB CEN12CA160Accident · No injuriesData collectionFinal reportCessna 180 · South Fork, COThe pilot's loss of directional control while landing on a patchy snow-covered runway.Feb 18, 2012 · N56180 · Substantial damageNTSB ERA12LA184Accident · Serious injuriesLimited investigationFinal reportMooney M20TN · Fayetteville, NCThe pilot’s failure to maintain adequate separation behind a large airplane during landing, which resulted in an encounter with wake turbulence and a loss of control.Feb 17, 2012 · N118RZ · Substantial damageNTSB ERA12IA187Incident · No injuriesIncident investigationFinal reportCessna 402B · Fort Lauderdale, FLThe overload fracture of the right main landing gear bellcrank and a securing bolt, which resulted in the collapse of the right main landing gear.Feb 16, 2012 · N402GZ · Minor damageNTSB ERA12CA182Accident · Minor injuriesData collectionFinal reportBeech 58 · South Charleston, WVThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.Feb 15, 2012 · N9460Q · Substantial damageNTSB WPR12LA104Accident · No injuriesLimited investigationFinal reportBeech G18 · Hollister, CAThe pilot’s failure to maintain adequate airspeed during the initial climb, which resulted in an aerodynamic stall and a subsequent hard landing, loss of directional control, and ground loop.Feb 14, 2012 · VH-NWB · Substantial damageNTSB WPR12CA112Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not maintain directional control while landing on a snow-contaminated runway.Feb 14, 2012 · N8433V · Substantial damageNTSB ERA12CA185Accident · No injuriesData collectionFinal reportCessna 172S · Eufaula, ALAn inadvertent collision with a deer during a night landing.Feb 14, 2012 · N6194V · Substantial damageNTSB DCA12WA038Accident · No injuriesForeign investigationFairchild SA-227 · Brisbane, AustraliaThe Australian Transportation Safety Bureau (ATSB) has notified the NTSB of an incident involving a Fairchild SA-227 that occurred on February 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…Feb 14, 2012 · VH-UZA · Substantial damageNTSB ERA12CA177Accident · No injuriesData collectionFinal reportRockwell International 114 · Hilton Head, SCThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind.Feb 12, 2012 · N4851W · Substantial damageNTSB WPR12CA101Accident · No injuriesData collectionFinal reportLearjet 31A · Wheatland, WYThe flight crew’s loss of directional control during landing on an ice- and water-contaminated runway, which resulted in a runway excursion.Feb 11, 2012 · N382AL · Substantial damageNTSB ERA12CA178Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper flare and recovery from a bounced landing.Feb 10, 2012 · N67973 · Substantial damageNTSB ANC12CA022Accident · No injuriesData collectionFinal reportCessna 172I · McCarthy, AKThe pilot lost directional control during landing.Feb 10, 2012 · N46279 · Substantial damageNTSB CEN12CA159Accident · No injuriesData collectionFinal reportMaule MX-7-235 · Tea, SDThe pilot did not maintain directional control of the airplane during a crosswind landing.Feb 8, 2012 · N5664N · Substantial damageNTSB ERA12CA172Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Greenville, SCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.Feb 7, 2012 · N4592R · Substantial damageNTSB ERA12LA188Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Culpeper, VAThe pilot's failure to use the manufacturer's checklist to troubleshoot the perceived malfunction and thereby ensure the position of the landing gear before landing. The reason the landing gear were not down and locked could not be determined, as no…Feb 6, 2012 · N1WE · Substantial damageNTSB WPR12CA103Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not reduce the airplane’s descent rate prior to the landing flare/touchdown, which resulted in a hard landing.Feb 5, 2012 · N4894X · Substantial damageNTSB CEN12CA148Accident · No injuriesData collectionFinal reportPiper PA-18 · Thedford, NEThe pilot did not maintain directional control during landing, which resulted in a runway excursion.Feb 5, 2012 · N3671Z · Substantial damageNTSB CEN12CA157Accident · Minor injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot did not extend the landing gear before landing.Feb 4, 2012 · N2696C · Substantial damageNTSB WPR12LA090Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Dinsmore, CAThe flight instructor's delayed remedial action, inadequate recovery from a bounced landing, and failure to attain/maintain adequate airspeed during an attempted go-around.Feb 3, 2012 · N3879S · Substantial damageNTSB ERA12WA183Incident · No injuriesForeign investigationEmbraer EMB-500 · Campo Grande, BrazilOn February 3, 2012, about 2333 universal coordinated time, an Embraer EMB-500 airplane, Brazilian registration PR-PHE, experienced an anti-skid brake failure during landing roll at the Campo Grande International Airport (SBCG), Campo Grande, Brazil, which…Feb 3, 2012 · PR-PHE · Minor damageNTSB WPR12CA088Accident · No injuriesData collectionFinal reportCessna 172S · Mokuleia, HIThe pilot's improper landing flare and inadequate recovery from a bounced landing.Feb 2, 2012 · N5026C · Substantial damageNTSB CEN12LA147Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Kansas City, MOThe failure of the nosewheel steering pushrod, which resulted in a loss of airplane directional control and runway excursion.Feb 2, 2012 · N6564V · Substantial damageNTSB ANC12CA021Accident · No injuriesData collectionFinal reportBeech 99 · Anchorage, AKThe pilot's premature power reduction, which resulted in a runway undershoot.Feb 1, 2012 · N991AK · Substantial damageNTSB WPR12CA086Accident · No injuriesData collectionFinal reportCessna 180 · Cascade, IDThe pilot's inadequate compensation for a wind gust during landing, which resulted in a runway excursion. Contributing to the accident was a windsock partially sheltered by trees that provided inaccurate wind information.Jan 30, 2012 · N3242D · Substantial damageNTSB ERA12IA166Incident · No injuriesIncident investigationFinal reportGulfstream G150 · Baltimore, MDThe pilot-in-command's failure to obtain the proper touchdown point or landing reference speed and failure to initiate a go-around when it became evident that the airplane was landing long and fast. Contributing to the incident was a lack of effective flight…Jan 30, 2012 · N272CB · Minor damageNTSB ERA12CA167Accident · No injuriesData collectionFinal reportRemos G-3/600 · Sarasota, FLThe student pilot’s loss of directional control during the landing roll.Jan 29, 2012 · N133LS · Substantial damageNTSB ERA12CA162Accident · No injuriesData collectionFinal reportCessna 172L · Grand Isle, VTThe pilot's inability to stop the airplane on a grass runway with undetected ice.Jan 28, 2012 · N811P · Substantial damageNTSB WPR12LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chehalis, WAThe pilot did not correctly manage his glide profile during a simulated engine-out forced landing. Contributing to the accident was the pilot's decision not to add additional engine power, which resulted in a runway undershoot.Jan 27, 2012 · N15791 · Substantial damageNTSB WPR12CA082Accident · No injuriesData collectionFinal reportCessna 172P · Honolulu, HIThe student pilot’s improper landing flare and inadequate directional control while performing an aborted landing.Jan 26, 2012 · N66540 · Substantial damageNTSB ANC12CA020Accident · No injuriesData collectionFinal reportHelio H-295 · Old Minto, AKThe pilot's decision to land on unsuitable terrain, which resulted in the airplane nosing over.Jan 26, 2012 · N713C · Substantial damageNTSB ERA12CA156Accident · No injuriesData collectionFinal reportBeech 58 · Walterboro, SCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion. Contributing to the accident was the sunglare.Jan 24, 2012 · N358CC · Substantial damageNTSB DCA12WA028Accident · No injuriesForeign investigationMcdonnell Douglas MD80 · Kabul, AfghanistanThe Afghanistan Civil Aviation Authority (ACAA) has notified the NTSB of an accident involving an MD-80 that occurred on January 24, 2012. The ACAA delegated the investigation to the Spanish Comisión de Investigación de Accidentes e Incidentes de Aviación…Jan 24, 2012 · EC-JJS · Substantial damageNTSB ANC12CA019Accident · No injuriesData collectionFinal reportCessna 207A · Nikiski, AKThe pilot's improper identification of the runway surface. Contributing to the accident was the snow covering the runway lights.Jan 23, 2012 · N800DF · Substantial damageNTSB WPR12CA079Accident · No injuriesData collectionFinal reportCessna 172M · Richland, WAThe student pilot's improper landing flare and inadequate directional control during landing.Jan 22, 2012 · N64270 · Substantial damageNTSB CEN12LA141Accident · No injuriesLimited investigationFinal reportBell 206B · Irving, TXA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.Jan 22, 2012 · N555NB · Substantial damageNTSB WPR12CA077Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · San Diego, CAThe pilot's inadequate directional control during the landing roll.Jan 14, 2012 · N409EV · Substantial damageNTSB CEN12CA136Accident · No injuriesData collectionFinal reportMooney M20K · Willmar, MNThe pilot landed without lowering the landing gear.Jan 13, 2012 · N262RW · Substantial damageNTSB DCA12WA025Incident · No injuriesForeign investigationBoeing 737 · Fort Nelson, CanadaThe Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving a Boeing 737 that occurred on January 9, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the provisions of ICAO…Jan 9, 2012 · C-GDEJ · Minor damageNTSB WPR12LA097Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAThe pilot’s failure to review or execute any applicable checklist procedures or troubleshoot or take corrective action before landing despite indications that the landing gear was not extended. Contributing to the accident were the pilot’s misunderstanding of…Jan 8, 2012 · N580TC · Substantial damageNTSB ERA12CA140Accident · No injuriesData collectionFinal reportLuscombe 8A · Umatilla, FLA failure of the left main landing gear due to a preexisting crack and corrosion, which resulted in a loss of directional control during landing.Jan 7, 2012 · N77859 · Substantial damage