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 WPR14CA125Accident · No injuriesData collectionFinal reportCessna 172K · Eastsound, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing in gusty wind conditions.Feb 4, 2014 · N78330 · Substantial damageNTSB ERA14CA121Accident · No injuriesData collectionFinal reportCessna 172R · Fort Pierce, FLThe student pilot's improper landing flare, which resulted in a hard landing.Feb 3, 2014 · N828BM · Substantial damageNTSB CEN14CA130Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 D · Worthington, MNThe pilot's loss of control during a crosswind landing.Feb 3, 2014 · N43462 · Substantial damageNTSB DCA14WA056Accident · Serious injuriesForeign investigationBoeing 737-900 · Surabaya, IndonesiaThe Indonesian National Transportation Safety Committee (NTSC) has notified the NTSB of an accident involving a Boeing 737-900 that occurred on February 1, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the NTSC investigation under…Feb 1, 2014 · PK-LFH · Substantial damageNTSB CEN14LA127Accident · No injuriesLimited investigationFinal reportPiaggio P180 - Avanti II · Springfield, ILThe pilot's decision to reengage the hydraulic system following the successful extension of the landing gear using the emergency extension procedures. Contributing to the accident was the failure of the directional control valve in the gear-up position and…Jan 31, 2014 · N700FE · Substantial damageNTSB ERA14LA108Accident · No injuriesLimited investigationFinal reportEnstrom F 28A · Memphis, TNA skid tube clamp weld failure due to high residual stress, which resulted in a skid collapse during landing. Contributing to the accident was the airplane manufacturer’s lack of adequate guidance for periodically inspecting the skid tube clamp.Jan 29, 2014 · N24RB · Substantial damageNTSB WPR14LA105Accident · No injuriesLimited investigationFinal reportPiper PA 23-250 · Camarillo, CAThe inadequate hydraulic pressure due to a damaged O-ring in the hydraulic powerpack, which prevented the right main landing gear (MLG) downlock from locking in the extended positon and allowed the right MLG to collapse during landing.Jan 28, 2014 · N5977Y · Substantial damageNTSB ERA14LA107Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · West Palm Beach, FLThe pilot/owner’s failure to maintain the airplane in accordance with a mandatory service bulletin and an airworthiness directive, which resulted in the nose landing gear collapse during landing.Jan 28, 2014 · N16389 · Substantial damageNTSB WPR14LA112Accident · No injuriesLimited investigationFinal reportWeinzierl Searey · Stanwood, WAThe noncertificated pilot’s failure to maintain clearance from water while maneuvering at a low altitude over glassy water conditions, which adversely affected his depth perception.Jan 27, 2014 · N669DT · Substantial damageNTSB WPR14LA102Accident · No injuriesLimited investigationFinal reportBeech C90 · Columbia, CAThe pilot’s unstabilized night visual approach, which resulted in a hard landing and the collapse of all three landing gear.Jan 27, 2014 · N350WA · Substantial damageNTSB ERA14CA109Accident · No injuriesData collectionFinal reportCessna 172S · Immokalee, FLThe student pilot's improper landing flare, which resulted in a hard landing.Jan 27, 2014 · N21670 · Substantial damageNTSB WPR14LA114Accident · No injuriesLimited investigationFinal reportPitts S2C · Roseburg, ORThe pilot’s loss of orientation while scanning for airport traffic during the turn from the base to final legs of the traffic pattern, which resulted in his failure to maintain clearance from a tree.Jan 26, 2014 · N102ZT · Substantial damageNTSB WPR14CA109Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Willcox, AZThe pilot's decision to land off airport on unsuitable terrain that resulted in a collision with hidden objects.Jan 26, 2014 · N9683P · Substantial damageNTSB DCA14WA053Accident · No injuriesForeign investigationBoeing 737-300 · Honiara, Solomon IslandsThe Civil Aviation Authority of Solomon Islands (CAASI), has notified the NTSB of an accident involving a Boeing 737-300 that occurred on January 26, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the CAASI investigation under the…Jan 26, 2014 · ZK-TLCNTSB WPR14CA103Accident · No injuriesData collectionFinal reportWaco Classic YMF F5C · Renton, WAThe pilot's failure to maintain directional control of the airplane during landing.Jan 25, 2014 · N188L · Substantial damageNTSB ERA14CA102Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · West Palm Beach, FLThe certificated flight instructor's failure to maintain helicopter control during a run-on landing, resulting in a rollover and ground collision.Jan 23, 2014 · N72AP · Substantial damageNTSB DCA14WA050Incident · No injuriesForeign investigationFairchild Industries SA226-TC · Archerfield, AustraliaOn January 23, 2014, a Fairchild Industries SA226-TC, registration number VH-OGX, experienced a runway excursion following landing at the Archerfield Airport (YBAF), Archerfield, Queensland, Australia. The airplane sustained minor damage and there were no…Jan 23, 2014 · VH-OGX · No damageNTSB CEN14CA119Accident · No injuriesData collectionFinal reportPiper PA46 500TP · Tulsa, OKThe loss of directional control while landing due to the failure of the inner tube in the left tire.Jan 23, 2014 · N403KC · Substantial damageNTSB ERA14LA101Accident · No injuriesLimited investigationFinal reportSchweizer 269C 1 · Titusville, FLThe flight instructor’s inadvertent side-loading of the left skid while demonstrating a running landing, which resulted in a bending overstress fracture of the left skid tube and a subsequent roll-over.Jan 21, 2014 · N2110J · Substantial damageNTSB ERA14CA097Accident · No injuriesData collectionFinal reportCessna 195B · Winchester, VAThe pilot's attempt to avoid a deer on the runway, which resulted in loss of aircraft control, a runway excursion, and collision with a runway sign.Jan 19, 2014 · N1960C · Substantial damageNTSB ERA14LA103Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Zephyrhills, FLThe pilot’s inadequate compensation for gusting wind conditions, which resulted in a hard landing that produced forces beyond the structural capability of the airframe.Jan 18, 2014 · N3668N · Substantial damageNTSB ERA14CA095Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Milledgeville, GAThe student pilots inadequate landing flare, which resulted in a hard landing.Jan 16, 2014 · N353DC · Substantial damageNTSB DCA14WA059Incident · No injuriesForeign investigationBoeing 737 · Grand Cayman, Cayman IslandsThe Air Accidents Investigation Branch of the UK (AAIB-UK) has notified the NTSB of an accident involving a Boeing 737 that occurred on January 15, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB-UK's investigation under the…Jan 16, 2014 · VP-CKY · No damageNTSB CEN14TA116Accident · Minor injuriesFinal reportAutogyro Mtosport · Spring, TXThe pilot’s failure to maintain the gyroplane’s rotor control during the landing roll in gusting crosswind conditions.Jan 16, 2014 · N250TX · Substantial damageNTSB CEN14CA114Accident · No injuriesData collectionFinal reportCessna 340 · Coldwater, MIAirport personnel did not remove the snow banks from the intersecting runway and/or close the intersection runway, which resulted in the airplane impacting the snow banks. Contributing to the accident was the reduced visibility inhibiting the pilot's ability…Jan 15, 2014 · N10MF · Substantial damageNTSB DCA14IA037Incident · No injuriesIncident investigationFinal reportBoeing 737 7H4 · Branson, MOThe Flight crew's failure to properly identify the airport and runway of intended landing. Contributing to the incident was the flight crew's failure to comply with procedures for use of navigation information and visual cues to verify the airport and runway…Jan 13, 2014 · N272WN · No damageNTSB WPR14CA095Accident · No injuriesData collectionFinal reportHallendorf Tom RV 6 · Sacramento, CAThe pilot's failure to maintain directional control during landing roll in gusty wind conditions.Jan 12, 2014 · N6888 · Substantial damageNTSB WPR14CA093Accident · Minor injuriesData collectionFinal reportMaule M 7-235 · Lake Havasu, AZThe pilots' failure to verify the landing gear position prior to the water landing and the pilot/examiner's failure to adequately monitor the pilot.Jan 10, 2014 · N6136T · Substantial damageNTSB CEN14CA108Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Beaumont, TXThe student pilot not controlling the helicopter following a wind gust and the flight instructor's inadequate remedial action resulting in the helicopter rolling over on its side during a landing.Jan 9, 2014 · N994HV · Substantial damageNTSB DCA14WA030Accident · Serious injuriesForeign investigationBoeing 767-3W0ER · Madinah, Saudi ArabiaThe Kingdom of Saudi Arabia, Aviation Investigation Bureau (AIB), has notified the NTSB of an accident involving a Boeing 767-300 that occurred on January 5, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AIB investigation under…Jan 5, 2014 · HS-BKE · Minor damageNTSB CEN14FA099Accident · 1 fatalField investigationFinal reportCanadair CL 600 2B16 · Aspen, COThe flight crew's failure to maintain airplane control during landing following an unstabilized approach. Contributing to the accident were the flight crew's decision to land with a tailwind above the airplane's operating limitations and their failure not to…Jan 5, 2014 · N115WF · DestroyedNTSB CEN14CA104Accident · No injuriesData collectionFinal reportCessna 172P · Cotulla, TXThe student pilot did not maintain control of the airplane while landing. The flight instructor's failure to monitor the flight contributed to the accident.Jan 5, 2014 · N55277 · Substantial damageNTSB WPR14CA090Accident · No injuriesData collectionFinal reportCessna 140 · Marana, AZThe pilot did not maintain directional control during the landing roll out when the right brake did not release completely after he applied, then released brake pressure, which resulted in a ground loop. Contributing to the accident was the taxi speed.Jan 4, 2014 · N76463 · Substantial damageNTSB WPR14CA088Accident · No injuriesData collectionFinal reportClayhold Sportsman GS-2 · Manzanita, ORThe pilot's inadequate landing flare and failure to maintain control of the airplane while landing with gusting wind.Jan 4, 2014 · N391TD · Substantial damageNTSB ERA14LA089Accident · No injuriesLimited investigationFinal reportFK Lightplanes FK9 ELA SW · Canton, GAA partial loss of engine power during cruise flight due to an overly lean fuel-air mixture, which resulted from an incorrectly installed float chamber vent line and led to a subsequent off-airport landing.Jan 4, 2014 · N611SP · Substantial damageNTSB DCA14CA034Accident · No injuriesData collectionFinal reportBoeing 737 · Las Vegas, NVthe captain's over rotation during the bounced landing.Jan 4, 2014 · N8327A · Substantial damageNTSB CEN14LA107Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Silver City, NMThe collapse of the landing gear during landing for reasons that could not be determined during postaccident examinations.Jan 3, 2014 · N6767P · Substantial damageNTSB CEN14CA098Accident · No injuriesData collectionFinal reportBell 206B · Temple, TXThe pilot's loss of control while landing on a mobile helipad.Jan 2, 2014 · N400XL · Substantial damageNTSB WPR14CA083Accident · No injuriesData collectionFinal reportCessna 195A · Salinas, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Dec 31, 2013 · N369JJ · Substantial damageNTSB CEN14CA096Accident · Minor injuriesData collectionFinal reportCessna 172K · Concordia, KSThe pilot's failure to maintain a proper glidepath during approach which resulted in the airplane landing long, and his decision to turn off of the runway during the landing roll which resulted in a collision with an earth berm.Dec 30, 2013 · N1176M · Substantial damageNTSB ERA14CA080Accident · Minor injuriesData collectionFinal reportSchweizer 269C · White Plains, NYThe flight instructor's failure to maintain airspeed during a practice autorotation, which resulted in a hard landing and subsequent loss of controlDec 28, 2013 · N2056J · Substantial damageNTSB WPR14CA077Accident · Minor injuriesData collectionFinal reportCessna T182T · Hillsboro, ORThe pilot's decision to continue the instrument approach beyond the published missed approach point.Dec 25, 2013 · N3531F · Substantial damageNTSB WPR14CA075Accident · Serious injuriesData collectionFinal reportCessna 152 · St. Ignatius, MTThe non-certificated pilot's failure to maintain a stabilized approach for landing that resulted in a long landing and subsequent runway overrun.Dec 24, 2013 · N5533B · Substantial damageNTSB ERA14CA078Accident · No injuriesData collectionFinal reportCessna 172S · Miami, FLThe pilot's improper flare during a gusty, crosswind landing.Dec 24, 2013 · N17223 · Substantial damageNTSB ANC14CA013Accident · No injuriesData collectionFinal reportPiper PA 20 · Platinum, AKThe pilot's failure to maintain directional control during a crosswind landing.Dec 24, 2013 · N7069K · Substantial damageNTSB WPR14CA074Accident · No injuriesData collectionFinal reportCessna 172M · Fullerton, CAThe pilot's inadequate landing flare, which resulted in a bounced landing.Dec 23, 2013 · N80238 · Substantial damageNTSB WPR14CA073Accident · No injuriesData collectionFinal reportCessna A185F · Carson City, NVThe pilot's failure to maintain directional control during landing which resulted in the airplane veering off the runway and nosing over.Dec 22, 2013 · N185CY · Substantial damageNTSB DCA14WA024Incident · No injuriesForeign investigationBoeing 767 · Arusha, TanzaniaDec 18, 2013 · ET-AQW · No damageNTSB CEN14LA091Accident · Serious injuriesLimited investigationFinal reportQuicksilver Unknown · Palestine, TXThe noncertificated pilot’s failure to maintain airspeed, which resulted in an inadvertent stall during landing.Dec 17, 2013 · UNREG · Substantial damageNTSB CEN14LA089Accident · Minor injuriesLimited investigationFinal reportCessna 305C (0 1E) · Hondo, TXThe pilot's loss of directional control during an attempted go-around for reasons that could not be determined based on the available evidence. Contributing to the accident was the flight instructor’s and pilot’s decision to continue flight after experiencing…Dec 17, 2013 · N83CN · Substantial damage