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 LAX08CA017Accident · No injuriesData collectionFinal reportCessna 182P · Troutdale, ORThe pilot's inadequate compensation for the tailwind condition and failure to maintain an adequate airspeed.Oct 7, 2007 · N6415F · Substantial damageNTSB DFW08CA005Accident · No injuriesData collectionFinal reportStinson 108-2 · Indianola, MSThe pilot's failure to compensate for the existing wind conditions while landing. A contributing factor was the crosswind.Oct 7, 2007 · N9603K · Substantial damageNTSB CHI08CA009Accident · No injuriesData collectionFinal reportCessna Turbo Centurion T210 · Festus, MOThe deer on the runway during the airplane landing rollout.Oct 7, 2007 · N100GK · Substantial damageNTSB LAX08LA004Accident · No injuriesLimited investigationFinal reportYakovlev YAK-50 · El Cajon, CAThe inadequate visual lookout of the pilot of another airplane and his failure to maintain clearance from a taxiing airplane.Oct 6, 2007 · N509RA · 2 aircraft · Minor damageNTSB NYC08CA003Accident · No injuriesData collectionFinal reportCessna 170A · Wadesboro, NCThe pilot's improper recovery from a bounced landing.Oct 4, 2007 · N5494C · Substantial damageNTSB CHI08CA013Accident · No injuriesData collectionFinal reportCessna 182 · Middlefield, OHThe proper touchdown point not obtained by the pilot and the inadequate supervision by the certified flight instructor during landing. A contributing factor was the rough terrain encountered during landing.Oct 4, 2007 · N9774F · Substantial damageNTSB CHI08CA004Accident · Serious injuriesData collectionFinal reportProgressive Aerodyne Searey · Cokato, MNThe inadequate flare by the pilot during landing. Contributing factors were the lack of an endorsement by the pilot, the lack of total experience in the type of aircraft by the pilot, and the glassy water.Oct 4, 2007 · N452TR · Substantial damageNTSB ANC08TA006Accident · No injuriesFinal reportAviat A1B · Palmer, AKThe flight instructor's failure to maintain clearance from high vegetation during the off-airport landing.Oct 4, 2007 · N739 · Substantial damageNTSB DFW08CA006Accident · No injuriesData collectionFinal reportVans RV6 · Halifax, VAThe pilot's inadvertent stall during a forced landing. A contributing factor was the pilot's failure to place the electronic prop controller in the manual mode prior to aborting the landing which resulted in a loss of engine power.Oct 2, 2007 · N6RP · Substantial damageNTSB DEN08CA001Accident · Serious injuriesData collectionFinal reportDegelia Rotor Flight Dynamic · Ashland, KYthe pilot's failure to maintain aircraft control during the landing flare resulting in a hard landing. Contributing factors were the crosswind and the pilot's failure to recover from a bounced landing.Oct 2, 2007 · N444PD · Minor damageNTSB NYC07CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Indiana, PAThe student pilot's failure to maintain directional control while landing.Sep 30, 2007 · N1839T · Substantial damageNTSB LAX07CA288Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Laurel, MTCorrosion and fatigue-induced failure of the landing gear structure.Sep 30, 2007 · N41695 · Substantial damageNTSB LAX07CA285Accident · No injuriesData collectionFinal reportPiper PA-32R-301T · Stockton, CAThe pilot's inadequate compensation for the gusty, crosswind and downdraft wind condition, which resulted in a hard landing.Sep 30, 2007 · N4175A · Substantial damageNTSB NYC07LA241Accident · Serious injuriesLimited investigationFinal reportEverson Sidewinder · Pensacola, FLThe pilot's failure to attain the proper touchdown point while landing.Sep 29, 2007 · N62RE · Substantial damageNTSB LAX07CA283Accident · No injuriesData collectionFinal reportLuscombe 8E · Ramona, CAthe installation and subsequent failure of an incorrect part, which jammed in one wheel's brake caliper and induced the pilot's loss of directional control.Sep 29, 2007 · N2826K · Substantial damageNTSB DFW07CA211Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Navasota, TXThe hard landing as result of the pilot's improper landing flare.Sep 29, 2007 · N7149P · Substantial damageNTSB CHI07CA308Accident · No injuriesData collectionFinal reportCessna 172 SP · Heath, OHThe improper flare and inadequate recovery from a bounced landing by the student pilot. A factor was the student pilot's lack of experience.Sep 29, 2007 · N2327J · Substantial damageNTSB DFW07CA210Accident · No injuriesData collectionFinal reportCessna 172 · McKinney, TXThe student pilot's failure to compensate for existing conditions while landing. A contributing factor was the prevailing crosswind.Sep 28, 2007 · N364GW · Substantial damageNTSB DFW07CA209Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Pampa, TXThe pilot's failure to extend the landing gear prior to landing.Sep 28, 2007 · N45014 · Substantial damageNTSB SEA07CA274Accident · No injuriesData collectionFinal reportCessna A185F · Lexington, ORThe pilot's failure to maintain directional control during the landing roll which resulted in an inadvertent ground loop/swerve.Sep 26, 2007 · N6497E · Substantial damageNTSB NYC07CA239Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Atlantic, PAThe pilot's failure to maintain aircraft control.Sep 25, 2007 · N39263 · Substantial damageNTSB NYC07CA235Accident · No injuriesData collectionFinal reportCessna 172 · Meriden, CTThe student pilot's inadequate recovery from a bounced landing.Sep 21, 2007 · N7837G · Substantial damageNTSB ANC07CA105Accident · No injuriesData collectionFinal reportPiper PA-32 · Chenega Bay, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with a ditch during the landing roll. A factor associated with the accident was the ditch.Sep 21, 2007 · N3948W · Substantial damageNTSB SEA07CA272Accident · No injuriesData collectionFinal reportJeffrey Wilson Escapade · La Grande, ORThe pilot's failure to maintain directional control during the landing, which resulted in a ground loop and substantial damage to the airplane's left wing. A contributing factor was the flight instructor's delayed remedial action.Sep 20, 2007 · N7078T · Substantial damageNTSB SEA07CA267Accident · No injuriesData collectionFinal reportCessna 340A · Schellville, CAThe pilot's misjudgment of speed and distance, which resulted in an overrun of the runway. Contribution factors are the pilot's inadvertent landing at the wrong airport with a shorter runway than his intended destination and limited braking effectiveness…Sep 20, 2007 · C-FTPA · Substantial damageNTSB NYC07CA238Accident · No injuriesData collectionFinal reportCessna 190 · Yulee, FLThe pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.Sep 20, 2007 · N190BJ · Substantial damageNTSB DEN07CA163Accident · Serious injuriesData collectionFinal reportAerostar S81A · Hartsel, COthe pilot's inability to maintain the proper descent rate. A factor contributing to the accident was the unfavorable wind conditions.Sep 20, 2007 · N5294D · No damageNTSB DEN07CA162Accident · Minor injuriesData collectionFinal reportCessna 182Q · Glenwood Spring, COThe pilot's failure to go around when it became apparent that he could not land and stop the airplane on the remaining runway. Factors contributing to the accident were the tailwind and the gusts.Sep 20, 2007 · N97996 · Substantial damageNTSB DEN07CA161Accident · No injuriesData collectionFinal reportCessna 182P · Santa Rosa, NMThe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.Sep 20, 2007 · N8033M · Substantial damageNTSB SEA07LA266Accident · Serious injuriesLimited investigationFinal reportSt. Claire Ragtop-01 · Perris, CAThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing factors to the accident were the fence and the undetermined brake malfunction.Sep 19, 2007 · N3134Q · Substantial damageNTSB NYC07CA240Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bridgeport, CTThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the crosswind weather condition.Sep 18, 2007 · N9285J · Substantial damageNTSB LAX07CA276Accident · No injuriesData collectionFinal reportCessna 177RG · Compton, CAthe pilot misjudged the flare resulting in a hard landing and loss of aircraft control.Sep 16, 2007 · N1844Q · Substantial damageNTSB DFW07CA200Accident · Minor injuriesData collectionFinal reportVans RV-7A · Vernon, TXThe pilot's failure to maintain control of the airplane while landing. A contributing factor was the prevailing tailwind.Sep 16, 2007 · N729CM · Substantial damageNTSB CHI07CA314Accident · No injuriesData collectionFinal reportAeronca 7AC · Kent, OHThe inadequate compensation for wind conditions and the directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gusts, and ditch.Sep 16, 2007 · N1950E · Substantial damageNTSB CHI07CA300Accident · Serious injuriesData collectionFinal reportCameron Balloons O-77 · Creston, IAThe pilot's inadvertent flight into adverse (high wind) weather conditions, which resulted in a hard landing. Contributing to the accident was the high wind encountered during the balloon flight and the barbed-wire fence.Sep 16, 2007 · N9539G · Substantial damageNTSB NYC07LA229Accident · Minor injuriesLimited investigationFinal reportIsrael Aircraft Industries Astra SPX · Atlanta, GAThe pilot's failure to initiate a missed approach and his failure to obtain the proper touchdown point while landing in the rain. Contributing to the accident were the operator's lack of standard operating procedures and the inadequate maintenance of the…Sep 14, 2007 · N100G · Substantial damageNTSB NYC07LA227Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · West Chester, PAThe total failure of the left brake disc due to corrosion.Sep 14, 2007 · N5073T · Substantial damageNTSB LAX07LA278Accident · No injuriesLimited investigationFinal reportSkykits Savannah ADV · Lava Hot Spring, IDFailure of the pilot to maintain aircraft control during landing.Sep 14, 2007 · N769R · Substantial damageNTSB LAX07CA275Accident · Minor injuriesData collectionFinal reportCessna U206G · Fort Bragg, CAThe pilot's misjudged speed and distance, which resulted in a landing overrun of the runway.Sep 14, 2007 · N5344U · Substantial damageNTSB SEA07CA261Accident · No injuriesData collectionFinal reportAviat A-1B · Grangeville, IDThe pilot's failure to maintain directional control during the landing roll. Factors include a ditch located between the runway and the taxiway.Sep 13, 2007 · N319AM · Substantial damageNTSB NYC07CA224Accident · Minor injuriesData collectionFinal reportPiper PA-28R-200 · Tampa, FLThe pilot's misjudged altitude/distance, which resulted in a hard landing, prior to the runway.Sep 13, 2007 · N1145X · Substantial damageNTSB CHI07CA299Accident · No injuriesData collectionFinal reportSchweizer 300 CBI · Minneapolis, MNThe dual student's improper flare during the simulated autorotation, and the flight instructor's delayed remedial action.Sep 13, 2007 · N269HB · DestroyedNTSB SEA07CA268Accident · No injuriesData collectionFinal reportMooney M20D · Placerville, CAThe pilot's failure to extend the landing gear prior to landing. A contributing factor was the pilots impaired performance.Sep 12, 2007 · N1229X · Substantial damageNTSB NYC07CA231Accident · No injuriesData collectionFinal reportMooney M20C · Allentown, PAThe pilot's improper recovery from a bounced landing.Sep 12, 2007 · N6731U · Substantial damageNTSB CHI07CA297Accident · No injuriesData collectionFinal reportBoeing Stearman E75 · Gordon, NEThe pilot's failure to maintain directional control during the crosswind landing which resulted in the inadvertent ground loop.Sep 12, 2007 · N68462 · Substantial damageNTSB ATL07CA126Accident · No injuriesData collectionFinal reportRans RV-9A · Harvest, ALThe pilot's improper landing flare and touchdown.Sep 12, 2007 · N269RV · Substantial damageNTSB SEA07CA256Accident · Minor injuriesData collectionFinal reportRogerson Hiller RH-1100 · Stanwood, WAThe pilot's failure to execute a go-around and his failure to reduce his groundspeed to zero prior to touching down on the rough/uneven terrain. Factors include the momentary restriction of a flight control, rough/uneven terrain, and a tailwind.Sep 11, 2007 · N6014U · DestroyedNTSB NYC07CA222Accident · Minor injuriesData collectionFinal reportLancair IV-P · Alabaster, ALThe pilot's failure to attain the proper touchdown point.Sep 11, 2007 · N335DF · Substantial damageNTSB CHI07CA296Accident · Minor injuriesData collectionFinal reportCessna 172 Skyhawk · Stockton, MOThe pilot's improper recovery from a bounced landing, her subsequent loss of control of the airplane, and the inadvertent stall.Sep 11, 2007 · N12189 · Substantial damageNTSB DEN07LA156Accident · No injuriesLimited investigationFinal reportCessna 402B · Hobbs, NMThe failure of the left main landing gear down lock due to overload causing the main landing gear to collapse.Sep 10, 2007 · N402BF · Substantial damage