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 SEA07CA029Accident · No injuriesData collectionFinal reportCessna 172RG · Laurel, MTThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and subsequent nose over. A contributing factor was the crosswind condition.Dec 11, 2006 · N6501V · Substantial damageNTSB NYC07CA045Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Danbury, CTThe student pilot's inadequate recovery from a bounced landing, which resulted in a hard landing.Dec 11, 2006 · N44635 · Substantial damageNTSB DFW07CA037Accident · No injuriesData collectionFinal reportHughes 269B · Houma, LAA partial loss of engine power as a result of a cracked engine cylinder and broken spark plug which resulted in a hard landing. A factor was that it was not possible to attain proper rotor RPM.Dec 11, 2006 · N9396F · Substantial damageNTSB CHI07LA036Accident · Minor injuriesLimited investigationFinal reportNavion Navion G · Coalton, OHThe pilot failed to follow the checklist and lower the landing gear. A factor in the accident was the fence post.Dec 11, 2006 · N33FL · Substantial damageNTSB NYC07CA046Accident · No injuriesData collectionFinal reportCessna 172R · Northhampton, MAThe pilot's inadequate recovery from a bounced landing.Dec 10, 2006 · N9421Z · Substantial damageNTSB DEN07LA036Accident · No injuriesLimited investigationFinal reportFairchild SA227BC · Gillette, WYwind shear.Dec 8, 2006 · N779BC · Substantial damageNTSB SEA07LA030Accident · No injuriesLimited investigationFinal reportCessna P210N · Burns, ORThe pilot's failure to put the landing gear down for landing.Dec 6, 2006 · N6006P · Substantial damageNTSB MIA07CA025Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Miami, FLThe failure of the pilot to maintain directional control during the landing roll resulting in a ground loop, and subsequent wing contact with the runway.Dec 4, 2006 · N113KJ · Substantial damageNTSB NYC07LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Livermore Falls, METhe pilot's failure to maintain directional control during landing, which resulted in a groundloop.Dec 3, 2006 · N8019F · Substantial damageNTSB DFW07CA033Accident · No injuriesData collectionFinal reportStits Flut-R-Bug SA6B · Camerson, TXThe pilot's improper landing flare and inadequate recovery from a bounced landing which resulted in a hard landing. A factor was the delayed remedial action by the flight instructor.Dec 2, 2006 · N3129 · Substantial damageNTSB LAX07CA050Accident · No injuriesData collectionFinal reportRobinson R22B · Redding, CAThe student's misjudged landing flare, the instructor's inadequate supervision of the flight, and the instructor's failure to maintain adequate rotor rpm.Nov 27, 2006 · N7198N · Substantial damageNTSB CHI07CA030Accident · No injuriesData collectionFinal reportAviat A-1B · St Louis, MOThe pilot's failure to maintain directional control during landing which resulted in the wing striking the ground during the inadvertent ground loop.Nov 26, 2006 · N74HP · Substantial damageNTSB CHI07CA028Accident · No injuriesData collectionFinal reportCessna 421C · Moline, ILThe incorrect installation of the torque link scissor assembly by maintenance personnel, which resulted in the collapse of the right main landing gear during landing.Nov 26, 2006 · N471BW · Substantial damageNTSB SEA07LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTThe student pilot's misjudged distance/speed during final approach, which resulted in an overrun during landing roll and collision with a fence.Nov 25, 2006 · N93239 · Substantial damageNTSB ATL07CA022Accident · No injuriesData collectionFinal reportCessna 172N · Reidsville, NCThe pilot's failure to maintain directional control of the airplane during landing roll, which resulted in an on ground collision with trees.Nov 25, 2006 · N172LF · Substantial damageNTSB CHI07CA029Accident · No injuriesData collectionFinal reportCessna 150J · South Haven, MIThe pilot's inadequate compensation for the crosswind during landing. Factors were the crosswind and the ditch.Nov 24, 2006 · N61235 · Substantial damageNTSB LAX07CA044Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Springerville, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing. A factor was the crosswind.Nov 23, 2006 · N4925L · Substantial damageNTSB DFW07CA030Accident · No injuriesData collectionFinal reportCessna 152 · Houston, TXThe pilot's improper flare, which resulted in a hard landing. A factor was the misjudged touchdown point.Nov 23, 2006 · N67503 · Substantial damageNTSB CHI07CA031Accident · No injuriesData collectionFinal reportCessna 120 · Perryville, MOThe pilot's failure to maintain directional control during landing which resulted in an overload of the tailwheel attachment structure in the fuselage.Nov 23, 2006 · N1915N · Substantial damageNTSB DFW07CA028Accident · No injuriesData collectionFinal reportCessna 172N · Spring, TXLoss of directional control for undetermined reasons.Nov 22, 2006 · N81HT · Substantial damageNTSB NYC07CA035Accident · Minor injuriesData collectionFinal reportBaggett RV6A · Nokesville, VAThe pilot's inadequate compenstation for a crosswind while landing, which resulted in a loss of directional control.Nov 21, 2006 · N5779 · Substantial damageNTSB LAX07CA043Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Santa Clarita, CAthe student pilot's inadequate compensation for wind conditions and the instructor's failure to arrest the descent, which resulted in a dynamic rollover. Also causal was the inadequate supervision by the instructor. A factor in the accident was the wind shift…Nov 21, 2006 · N994HV · Substantial damageNTSB LAX07CA042Accident · No injuriesData collectionFinal reportPippert Zenith CH-701 · Yerington, NVthe pilot's inadequate compensation for the wind conditions and failure to maintain both directional and pitch control.Nov 21, 2006 · N7092B · Substantial damageNTSB MIA07CA019Accident · No injuriesData collectionFinal reportCessna 172S · New Smyrna, FLThe student pilot's improper recovery from a bounced landing.Nov 19, 2006 · N53095 · Substantial damageNTSB LAX07CA038Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Grand Canyon, AZThe pilot's inadequate compensation for the crosswind condition during the landinf roll which resulted in a loss of control and an on ground collision with a berm.and failure to maintain directional control.Nov 19, 2006 · N8477F · Substantial damageNTSB DEN07CA026Accident · Serious injuriesData collectionFinal reportLiberty Aerospace Liberty XL-2 · Albuquerque, NMthe student pilot's improper flare and subsequent improper recovery from a bounced landing resulting in an inadvertent loss of control.Nov 19, 2006 · N531XL · Substantial damageNTSB CHI07IA067Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Fort Wayne, INThe fatigue failure/separation of the engine mount's nose gear actuator attachment foot, and the manufacturer's inadequate engine mount/nose gear actuator attachment design.Nov 18, 2006 · N4185L · Minor damageNTSB ATL07CA019Accident · Serious injuriesData collectionFinal reportHolmgreen RV-6A · Midway, GAAn on ground encounter with rough/uneven terrain during the landing roll out resulting in the collapse of the nosewheel and subsequent nose over.Nov 18, 2006 · N525RV · Substantial damageNTSB NYC07LA032Accident · No injuriesLimited investigationFinal reportColumbia LC41-550FG · Somerville, NJThe tug driver's inadequate lookout for landing traffic before crossing the runway.Nov 17, 2006 · N1442E · Substantial damageNTSB CHI07CA025Accident · No injuriesData collectionFinal reportCessna 172G · Ankeny, IAThe pilot's improper decision to land on an unlighted runway at night, and her resulting failure to attain a proper touchdown point leading to the landing over run. Contributing factors were the night (low light) condition and the ditch encountered during the…Nov 17, 2006 · N1374F · Substantial damageNTSB SEA07LA018Accident · No injuriesLimited investigationFinal reportAviat A-1B · Fruitland, UTThe pilot's improper in-flight decision to land on snow covered terrain. Deep snow on the terrain that the pilot chose to land on was a factor in this accident.Nov 15, 2006 · N85HY · Substantial damageNTSB LAX07CA036Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Tucson, AZThe pilot's improper use of the spoilers during the landing flare, which resulted in a hard landing, and his inadequate bounced landing recovery technique.Nov 15, 2006 · N4115M · Substantial damageNTSB CHI07LA024Accident · 1 fatalLimited investigationFinal reportMaule MX-7-180B · Edenville, MIThe pilot's loss of control during landing on a lake resulting in the amphibian aircraft flipping over inverted.Nov 15, 2006 · N4159K · Substantial damageNTSB MIA07CA016Accident · No injuriesData collectionFinal reportJerald F. Huffman Rebel · Wimauma, FLThe pilot's inadvertent application of brakes during the landing flare touchdown which resulted in the airplane nosing over.Nov 14, 2006 · N4038W · Substantial damageNTSB DEN07CA023Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Fe, NMthe pilot's failure to maintain directional control during the landing roll, and his failure to maintain airspeed which resulted in a stall and hard landing.Nov 13, 2006 · N87VF · Substantial damageNTSB NYC07CA028Accident · Minor injuriesData collectionFinal reportPiper PA-11 · Van Hornsville, NYThe pilot's failure to maintain clearance from trees during landing.Nov 11, 2006 · N4549M · Substantial damageNTSB DEN07FA022Accident · 1 fatalField investigationFinal reportCessna 337C · Alamogordo, NMThe pilot's incapacitation due to a heart attack while landing, which resulted in a loss of control and an on ground collision with objects.Nov 8, 2006 · N2500S · DestroyedNTSB LAX07CA030Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Glendale, AZthe pilot's failure to maintain directional control of the airplane during landing.Nov 7, 2006 · N333LC · Substantial damageNTSB DEN07IA021Incident · No injuriesIncident investigationFinal reportBeech P35 · Los Alamos, NMthe failure of both pilots to maintain adequate visual lookout during the visual approach. A contributing factor was the failure of N5368E's pilot to communicate his intentions on the Common Traffic Advisory Frequency.Nov 6, 2006 · N102H · 2 aircraft · Minor damageNTSB MIA07CA012Accident · No injuriesData collectionFinal reportAmerican AA-1 · Lakeland, FLThe pilot's misjudgment of the landing flare/touchdown which resulted in a hard landing.Nov 5, 2006 · N5657L · Substantial damageNTSB MIA07FA005Accident · No injuriesField investigationFinal reportBritish Aerospace HS 125-700A · Fort Lauderdale, FLThe failure of the flight crew to extend the landing gear. Contributing to the accident was the inoperative audible landing gear warning system.Nov 1, 2006 · N232TN · Substantial damageNTSB SEA07LA013Accident · No injuriesLimited investigationFinal reportCessna 172S · Richfield, UTThe student pilot's inability to compensate for the gusty crosswinds during the initial part of the landing roll, which resulted in a loss of control and a noseover. Factors associated with the accident are gusty crosswinds, and a mound/berm of dirt alongside…Oct 31, 2006 · N2097G · Substantial damageNTSB NYC07LA020Accident · No injuriesLimited investigationFinal reportCessna 182RG · Toms River, NJThe private pilot's failure to attain the proper touchdown point, and the flight instructor's inadequate remedial action, which resulted in a landing short of the runway. A contributing factor was the gusty wind conditions.Oct 31, 2006 · N6362T · Substantial damageNTSB DFW07LA021Accident · No injuriesLimited investigationFinal reportPiper PA32-301XTC · San Marcos, TXThe pilot's improper recovery from a bounced landing.Oct 31, 2006 · N506C · Substantial damageNTSB CHI07CA019Accident · No injuriesData collectionFinal reportAviat S2B · Larimore, NDThe pilot's failure to maintain proper alignment with the runway which resulted in the airplane nosing over. A factor associated with the accident was the soft terrain encountered.Oct 29, 2006 · N149TM · Substantial damageNTSB CHI07CA012Accident · Minor injuriesData collectionFinal reportCessna 172 · Maryville, MOThe pilot's inadequate recovery from a bounced landing leading to the nose gear overload.Oct 29, 2006 · N8196B · Substantial damageNTSB NYC07IA015Incident · No injuriesIncident investigationFinal reportBoeing 757-224 · Newark, NJThe flight crew's misidentification of the parallel taxiway as the active runway, resulting in the flight crew executing a landing on the taxiway. Contributing was the night lighting conditions.Oct 28, 2006 · N17105 · No damageNTSB NYC07CA013Accident · No injuriesData collectionFinal reportCessna 152 · Lancaster, PAThe student pilot's inadequate flare, which resulted in a nosegear collapse during landing.Oct 27, 2006 · N68727 · Substantial damageNTSB LAX07LA019Accident · No injuriesLimited investigationFinal reportCessna 310N · Lake Havasu Cit, AZthe pilot's failure to extend the landing gear prior to touchdown.Oct 27, 2006 · N56MB · Substantial damageNTSB CHI07CA014Accident · No injuriesData collectionFinal reportBellanca 7ECA · Eden Prairie, MNThe pilot not maintaining directional control of the tailwheel airplane during the landing roll. A factor was the runway sign that was impacted.Oct 27, 2006 · N57410 · Substantial damage