Skip to content

NTSB investigations

214 cases where the first occurrence was “Nose gear collapsed”.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 192) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 192)
  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.

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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 192)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ANC96LA152Accident · No injuriesLimited investigationFinal reportCessna 206F · Talkeetna, AKThe disconnection of the nosegear scissors assembly due to the loss of a retainer bolt.Sep 8, 1996 · N9515G · Substantial damage NTSB LAX96IA300Incident · No injuriesIncident investigationFinal reportDouglas DC-9-51 · Honolulu, HIImproper installation of a flexible hydraulic hose by company maintenance personnel and inadequate inspection of the work by company inspectors which resulted in the loose hose becoming entangled in the nose gear linkage, preventing complete extension of the…Aug 8, 1996 · N420EA · Minor damage NTSB ANC96LA115Accident · No injuriesLimited investigationFinal reportde Havilland DHC-4 · New Stuyahok, AKThe collapse of the nosegear precipitated by the failure of the hydraulic nosegear drag strut locking actuator.Aug 2, 1996 · N800NC · Substantial damage NTSB SEA96LA140Accident · No injuriesLimited investigationFinal reportPiper PA-31 · Jackson, WYAn improper screw installation by an unknown individual into the instrument panel, which restricted movement of the gear handle resulting in premature disengagement of the normal landing gear extension system. A factor was one or more improperly adjusted nose…Jul 2, 1996 · N27518 · Substantial damage NTSB ANC96IA077Incident · No injuriesIncident investigationFinal reportCessna 206 · Kodiak, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were: soft terrain, the use of an oversize nose wheel tire, and the FAA's inadequate field approval process for tundra tires.Jun 1, 1996 · N9608G · Minor damage NTSB CHI96LA166Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgregor, MNthe nose gear collapsed when it hit a soft spot in the runway.May 18, 1996 · N3750V · Substantial damage NTSB CHI96LA162Accident · No injuriesLimited investigationFinal reportSwearingen SA226TC · Fargo, NDthe flight crew did not comply with the gear down and lock checklist. The factors were a jammed nose gear and inattentive preflight planning/preparations by the pilot-in-command.May 17, 1996 · N229AM · Substantial damage NTSB LAX96LA123Accident · No injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAthe pilot's improper use of the elevator control, while landing.Feb 29, 1996 · N2132F · Substantial damage NTSB LAX96LA055Accident · No injuriesLimited investigationFinal reportSchafer Lancair 360 · Mesa, AZfailure of the nose gear strut, during landing.Nov 26, 1995 · N56DS · Substantial damage NTSB MIA96LA011Accident · No injuriesLimited investigationFinal reportCessna 172Q · Ormond Beach, FLThe student pilot's improper recovery from a bounced landing and his failure to execute a go-around. Contributing to the accident were: the student pilot's high, fast approach and his misjudgment of the flare during landing.Oct 20, 1995 · N913AT · Substantial damage NTSB NYC95LA150Accident · No injuriesLimited investigationFinal reportCessna 172N · Stormville, NYThe reported pothole in the runway.Jul 9, 1995 · N734CG · Substantial damage NTSB SEA95LA122Accident · No injuriesLimited investigationFinal reportCessna 177B · Seattle, WAThe pilot's inadequate remedial action when he encountered porpoising after landing on the nosewheel.Jun 16, 1995 · N19806 · Substantial damage NTSB ANC95LA077Accident · No injuriesLimited investigationFinal reportCessna 402B · Tuntutuliak, AKThe airport maintenance personnel's inadequate maintenance of the runway by not replacing the yellow cones that marked the soft area. The soft area on the runway was a related factor.Jun 12, 1995 · N710WS · Substantial damage NTSB MIA95LA071Accident · No injuriesLimited investigationFinal reportCessna 152 · Venice, FLThe pilot's failure to perform a go-around and failure to apply power to recover from the bounced landing.Feb 7, 1995 · N47183 · Substantial damage NTSB LAX95LA014Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Palo Alto, CAthe pilot's improper bounced landing recovery technique.Oct 12, 1994 · N8154C · Substantial damage NTSB LAX94LA288Accident · No injuriesLimited investigationFinal reportCessna 177 · Rota Island (Pacific Ocean)The pilot's porpoising the aircraft upon landing and his inadequate recovery from a bounced landing.Jul 17, 1994 · N1423C · Substantial damage NTSB ATL94LA096Accident · No injuriesLimited investigationFinal reportBeech 23-C23 · Knightdale, NCThe pilot's improper landing flare that resulted in the collapse of the nose landing gear.May 6, 1994 · N6660R · Substantial damage NTSB MIA94LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Panama City, FLThe improper recovery from a bounced landing by the pilot-in- command.Mar 7, 1994 · N48239 · Substantial damage NTSB SEA94LA058Accident · No injuriesLimited investigationFinal reportCessna 402C · Billings, MTThe nose gear actuator froze. A factor to the accident was temperature extremes.Feb 7, 1994 · N2718Y · Substantial damage NTSB MIA94LA022Accident · Minor injuriesLimited investigationFinal reportScott LONG-EZ · Hernando, FLThe failure of the nose gear down relay on the landing gear retraction/extension assembly for undetermined reasons, resulting in the collapse of the nose wheel on landing, and subsequent nose over.Nov 13, 1993 · N83TS · Substantial damage NTSB LAX93LA374Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Columbia, CAthe pilot's improper use of the elevator control during the takeoff ground roll which resulted in a porpoise and nose gear collapse. A factor in the accident was the pilot's low total experience and lack of total time in type.Sep 26, 1993 · N3561H · Substantial damage NTSB SEA93LA204Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot's failure to maintain the proper airspeed and glidepath.Sep 19, 1993 · N3117Y · Substantial damage NTSB ANC93LA162Accident · No injuriesLimited investigationFinal reportCessna 172 · Knik Glacier, AKThe pilot's improper inflight planning/decision, and his failure to attain the proper touchdown point. Factors were the rain and the rough/uneven terrain.Aug 22, 1993 · N3817S · Substantial damage NTSB CHI93LA262Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Branson, MOthe fractured nose gear retract arm which allowed the nose gear to collapse.Jul 16, 1993 · N7636Y · Substantial damage NTSB CHI93LA255Accident · No injuriesLimited investigationFinal reportCessna 182 · Prairie City, IAthe pilot's premature liftoff. Factors in the accident are the soft and wet sod runway.Jul 11, 1993 · N91162 · Substantial damage NTSB ANC93LA083Accident · No injuriesLimited investigationFinal reportBeech 56TC · Chistochina, AKThe pilot's improper decision to land on a rough airstrip.Jun 7, 1993 · N9194Q · Substantial damage NTSB ANC93IA084Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Anchorage, AKThe failure of the nose landing gear inner cylinder from an overload/overstress condition.Jun 7, 1993 · N673MA · Minor damage NTSB ANC93IA076Incident · No injuriesIncident investigationFinal reportCessna 310 · Kodiak, AKThe failure of the nose gear idler bell crank due to overstress by an undetermined source.May 31, 1993 · N5847M · Minor damage NTSB ANC93LA068Accident · No injuriesLimited investigationFinal reportCessna 402B · Kivalina, AKThe pilot's failure to check the condition of the runway before takeoff. The soft runway condition was a factor in the accident.May 25, 1993 · N401NA · Substantial damage NTSB MIA93IA120Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Daytona Beach, FLFatigue failure of the drag link assembly bolt.May 5, 1993 · N21427 · Minor damage NTSB LAX93LA197Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Lakeport, CAthe student pilot's misjudging the landing flare altitude. A factor relating to this accident was the student pilot's lack of total experience.Apr 28, 1993 · N6273Q · Substantial damage NTSB DEN93IA050Incident · No injuriesIncident investigationFinal reportPiper PA-34-200 · Boulder, CONot determined.Mar 27, 1993 · N4519T · Minor damage NTSB CHI93IA110Incident · No injuriesIncident investigationFinal reportFokker 100 · Chicago, ILFailure of the company station manager to follow proper dispatch procedures, and ice accumulation on the nose gear locking mechanism. Factors related to the incident were: wet snow (slush) on the runway at the departure airport, and inadequate design which…Mar 13, 1993 · N895US · Minor damage NTSB ANC93LA038Accident · No injuriesLimited investigationFinal reportCessna U206A · Willow, AKThe abrupt aircraft handling by the pilot in command. Factors were the collapse of the nose gear and the soft, snow covered terrain.Feb 28, 1993 · N8076Z · Substantial damage NTSB FTW93LA066Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe pilot's inadequate flare and the improper recovery from a bounced landingJan 13, 1993 · N64949 · Substantial damage NTSB MIA93IA013Incident · No injuriesIncident investigationFinal reportFairchild F-27 · Titusville, FLThe failure of contract maintenance personnel to comply with written maintenance instructions, resulting in the failure of the nose gear on landing roll.Nov 4, 1992 · N101FG · Minor damage NTSB MIA92LA161Accident · Minor injuriesLimited investigationFinal reportBacon Questair Venture LX · Boca Raton, FLThe inadequate inspection/service of the nose gear acuator by other maintenance personnel causing the contamination and subsequent failure.Aug 7, 1992 · N95U · Substantial damage NTSB SEA92LA122Accident · No injuriesLimited investigationFinal reportNorth American Navion · Spokane, WAThe partial failure of the nose gear trunnion. Factors include the pilot's decision to land with the gear in the up position.Jun 9, 1992 · N91132 · Substantial damage NTSB BFO92LA078Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Middlesex, NYThe nose over of the aircraft during landing. A factor contributing to the accident was rough terrain.May 27, 1992 · N8569U · Substantial damage NTSB MIA92IA090Incident · No injuriesIncident investigationFinal reportCessna 402C · Fort Lauderdale, FLImproper overhaul by company maintenance personnel and inaccurate gear down and locked indication in the cockpit.Mar 1, 1992 · N6786C · Minor damage NTSB MIA91LA136Accident · No injuriesLimited investigationFinal reportBeech F-90 · Key West, FLOverload failure of the nose landing gear resulting in the collapse of the nose landing gear during the landing roll.May 4, 1991 · N208RC · Substantial damage NTSB MIA91LA083Accident · No injuriesLimited investigationFinal reportCessna T210N · Panama City, FLThe pilot's improper recovery from a bounced landing. A factor was the pilot's lack of recent night flight experience.Feb 20, 1991 · N6136Y · Substantial damage NTSB ANC91IA020Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Nome, AKWas the sheared fitting on the nose gear actuator shuttle valve which caused the nose gear to not extend for landing.Jan 15, 1991 · N4118G · Minor damage NTSB MIA91IA059Incident · No injuriesIncident investigationFinal reportCessna 402C · Marathon, FLFatigue failure of a nose landing gear drag brace assembly which caused the nose landing gear to collapse during the landing roll. Contributing to the accident was an inadequate inspection of the airplane approximately 7 hours earlier by company maintenance…Dec 31, 1990 · N155PB · Minor damage NTSB MIA91IA048Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · Sanford, FLCollapse of the nose landing gear during the landing roll due to inadequate nose gear assembly and failure of the nose landing gear drag link bolt.Dec 19, 1990 · N3062H · Minor damage NTSB NYC91LA027Accident · No injuriesLimited investigationFinal reportCessna 404 · Pittsburgh, PAA failure of nose landing gear retraction cylinder attach points which allowed the nose landing gear to collapse.Nov 13, 1990 · N54SA · Substantial damage NTSB SEA91LA002Accident · No injuriesLimited investigationFinal reportBeech 58 · Seattle, WAThe pilot did not flare the airplane on landing. Factors related to the accident were: the pilot did not adequately recover from a bounced landing and the nose gear assembly failed in overload.Oct 2, 1990 · N7232K · Substantial damage NTSB CHI90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Webster, WIThe failure of the nose gear transmission mounting bracket which resulted in nose gear collapse during the landing roll.Jul 14, 1990 · N8095Y · Substantial damage NTSB CHI90LA170Accident · No injuriesLimited investigationFinal reportCessna R182 · Lambertville, MIPilot in command's mis-placement of the airplanes landing gear lever in the 'up' position while the airplane was on the ground, thereby allowing the landing gear squat switch, located in the nose gear compartment, to function as a retracting controller during…Jul 6, 1990 · N757DG · Substantial damage NTSB LAX90LA239Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAThe student pilot not flaring for the touchdown.Jul 1, 1990 · N89756 · Substantial damage