NTSB investigations
214 cases where the first occurrence was “Nose gear collapsed”.
Cases, newest first
Query with SQL
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 MIA90LA094Accident · No injuriesLimited investigationFinal reportBeech B-19 · Everglades City, FLThe pilots failure to flare the aircraft for landing resulting in the nose landing gear contacting the runway causing it to separate.NTSB ATL90LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Peewee Valley, KYThe pilot's improper precautionary landings. The pilot's improper planning/decisions, the low fuel level, and the terrain conditions at the airstrip were related factors.NTSB DEN90LA056Accident · No injuriesLimited investigationFinal reportCessna 404 · Englewood, COThe collapse of the nose gear assembly for undetermined reasons.NTSB FTW90LA042Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Tomball, TXCollapse of the nose gear for an undetermined reason.NTSB ATL89LA205Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Hertford, NCPilot's failure to properly flare the airplane during landing. Factors contributing to the accident were the high obstructions at both ends of the runway.NTSB ANC89LA146Accident · No injuriesLimited investigationFinal reportCessna 172 · Eureka Lodge, AKImproper planning/decision by the pilot. A contributing factor was the hump (uneven surface) on the runway.NTSB MIA89LA150Accident · No injuriesLimited investigationFinal reportCessna 152 · Marco, FLFailure of the pilot to control the approach speed which resulted in a bounced landing. No recovery was made from the bounced landing, and the airplane was allowed to stall. The airplane then landed on the nose landing gear, which resulted in its overload…NTSB ANC89LA072Accident · No injuriesLimited investigationFinal reportCessna 182H · White Mountain, AKThe pilot's selection of the wrong runway, which was closed. A factor related to the accident was: the snow crusted runway.NTSB ANC89IA068Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Cordova, AKFailure of the upper trunion bolt which normally holds the upper portion of the over center down link.NTSB SEA89LA058Accident · No injuriesLimited investigationFinal reportNorth American T-28A · Jerome, IDThe failure of another person to report a hard landing which resulted in the airplane not being inspected by authorized personnel.NTSB NYC89LA108Accident · No injuriesLimited investigationFinal reportBeech TC-45J · Johnstown, PAFailure of the pilot to maintain runway alignment. The crosswind and snow covered runway were related factors.NTSB LAX89LA085Accident · No injuriesLimited investigationFinal reportCessna TR182 · Oakland, CAPrevious damage due to previous hard landing.NTSB ATL89IA026Incident · No injuriesIncident investigationFinal reportBeech 58 · Georgetown, SCThe plt reported that the nose gear collapsed after a 'normal' ldg. An FAA inspector who examined the rwy after the mishap reported that he found tire marks which indicated that the nose tire had contacted the rwy several times after the main tires touched…NTSB DEN88LA192Accident · No injuriesLimited investigationFinal reportCessna 206 · Saint George, UTDrg the landing roll, the nose gear collapsed, then the acft veered off the rwy, enctrd soft dirt/gravel terrain & nosed over. A post-acdnt inspn revealed that two attaching bolts on the left side of the nose gear yoke had failed & that the TW0 bolts on the…NTSB MKC88LA163Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Freeburg, MOWhile attempting to land on a farm pasture that the plt had previously walked over to check, the aircraft nose wheel collapsed, followed by a nose over. The aircraft landed nose low with no flaps and dug into the grass runway.NTSB CHI88LA196Accident · No injuriesLimited investigationFinal reportCessna 320E · Springfield, ILDrg a night arrival, the plt failed to get a down & locked indcn for the nose gear. He made svrl low passes over the rwy for observation. Tower & fire/rescue personnel rprtd the nose gear appeared to be extended, so the plt made a normal landing. As the nose…NTSB CHI88FA143Accident · No injuriesField investigationFinal reportShort Brothers SC.7 · Cleveland, OHFatigue failure on the radius between the body of the nose landing gear and the portion containing the arms.NTSB ATL88LA188Accident · No injuriesLimited investigationFinal reportMooney M-20 · Hartwell, GAThe nose gear collapsed while taxiing at a speed of about 5 mph after landing. The annual inspection failed to disclose a material problem with the gear truss. Examination of the fractured component disclosed that the tubular material had rusted from the…NTSB MKC88LA097Accident · No injuriesLimited investigationFinal reportCessna 310K · Kansas City, KSDuring a lndg roll subsequent to landing, the nose landing gear collapsed. A post-impact insptn of the gear indicated that a bolt (which retains the retract arm to the bellcrank) had sheared. The bolt was also discovered to have been installed in the wrong…NTSB ATL88DMG04Accident · Minor injuriesFinal reportMarrek Smyth Sidewinder · Honea Path, SCNTSB MKC88LA051Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Texarkana, ARFollowing the completion of the ILS approach and landing on runway 22 at the Texarkana, Arkansas airport the nose gear of the aircraft collapsed during the landing roll. The aircraft collided with the runway causing substantial damage to the aircraft. The…NTSB ATL88LA076Accident · No injuriesLimited investigationFinal reportCessna 182G · Lancaster, OHThe plt rptd that the airplane began to veer left almost immediately after touchdown. The airplane subsequently swerved off of the rwy. Traveled across a snow-covered grassy area, and impacted a taxiway embankment. The nose gear was found to be collapsed…NTSB ANC88FA022Accident · Minor injuriesField investigationFinal reportCessna 208 · Bethel, AKThe plt had planned to back taxi for takeoff on rwy 36. The tower controller asked if a rwy 18 departure would be acceptable to accommodate an arriving acft & the plt accepted a clnc. He started his takeoff with 3900' remaining on the 6399' rwy. After initial…NTSB ATL88LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Grantham, NCThe airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time.NTSB LAX88LA044Accident · No injuriesLimited investigationFinal reportBeech D18S · Mokuleia, HIThe plt rprtd that he had made a normal preflight, but after the acft had rolled about 200 to 250 ft on the takeoff roll, the nose gear collapsed. The acft came to rest with damage to the nose section, props & engs. Drg an inspn of the acft, the landing gear…NTSB NYC88LA038Accident · No injuriesLimited investigationFinal reportGrumman AA-1B · Tewksbury, MAThe student pilot was attempting a landing at Tewksbury, Massachusetts when he flared above the runway, bounced several times and collapsed the nose wheel. The aircraft slid down the runway, made contact with the right side of the runway edge, spun around,…NTSB SEA88LA006Accident · No injuriesLimited investigationFinal reportCessna 206 · Winnemucca, NVThe acft nose gear collapsed during takeoff and the acft nosed over. The plt stated to inspectors that recent maintenance had been performed on the nose gear. Shortly after the accident the acft was locked in a hangar. The plt has failed to file an accident…NTSB FTW87LA216Accident · No injuriesLimited investigationFinal reportCessna 172 · Edmond, OKThe pilot executed a short field approach to a private airstrip. During the landing roll the nose gear collapsed resulting in the aircraft's nose contacting the terrain. No reason for the nose gear collapse could be determined.NTSB BFO87LA058Accident · Minor injuriesLimited investigationFinal reportBeech D50C · Somerville, VAThe nose gear prematurely retracted and the props contacted the gravel runway during the takeoff initial climb. The plt attempted to continue the takeoff and the acft settled into trees off the departure end of the rwy. Post-accident inspection failed to…NTSB FTW87LA176Accident · No injuriesLimited investigationFinal reportPiper PA28R-201 · Houston, TXAccording to the pilot, during takeoff roll, and at the point of rotation the nose gear failed, causing the aircraft to drop down striking the runway with the prop. The aircraft then became airborne for approx. 15 sec. The pilot landed the aircraft on an…NTSB SEA87LA130Accident · Minor injuriesLimited investigationFinal reportCessna 206 · Olympia, WADuring landing roll the pilot was unable to maintain directional control. The aircraft veered to the side of the runway onto soft terrain. The aircraft then nosed over inverted. Investigation revealed that the nose gear had collapsed but the reason for the…NTSB ATL87LA180Accident · No injuriesLimited investigationFinal reportLockheed L-382-30 · Dayton, OHThe flight experienced separation of the nose landing gear during the landing roll. Investigation showed that the failure was related to the progression of a preexisting crack on the nose landing gear strut assembly. The probelms with the nose landing gear…NTSB FTW87LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Okmulgee, OKDuring a normal uneventful approach, and upon touchdown, the aircraft's nose gear collapsed for undetermined reasons. The aircraft slid to a stop causing substantial damage.NTSB FTW87LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Midland, TXDuring a touch and go landing on a sod strip the nose gear collapsed. The strut assembly part number 0594300-5 failed for an undetermined reason and the aircraft nosed over to the inverted position.NTSB MIA87LA112Accident · No injuriesLimited investigationFinal reportCessna 182C · Branford, FLThe plt was unable to locate his postion, & with wx conditions deteriorating & darkness approaching, elected to land in a field. Upon touchdown, the nose gear broke off, the acft nosed over & came to rest inverted.NTSB MKC87LA045Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Flippin, ARThe pilot stated that immediately upon touchdown, the nose slowly descended to the runway. The airplane slid for 450 feet before it stopped. A support bracket and an angle was found broken. It has not been determined if the parts were broken before or after…NTSB SEA87LA022Accident · No injuriesLimited investigationFinal reportCessna 182G · Juneau, AKAccording to the plt, he 'greased' the acft on the rwy, but the cast alluminum yoke on the nose gear failed & the nosewheel left the airplane. The strut then failed & the acft was further damaged.NTSB MKC87LA006Accident · No injuriesLimited investigationFinal reportCessna 421C · Hot Springs, ARThe pilot stated that gear went down normally, he had three green lights and the gear warning horn was not on and he could see that the nose gear was down by looking in the nacelle mirror. After touchdown, the nose was lowered and as it touched the runway,…NTSB LAX86LA329Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Salinas, CAThe acft collided with the surface of rwy 13 after the nose gear collapsed. The plt indicated the three green gear safe indicator lights were illuminated prior to touchdown. The acft was landed on the main gear first and then the nose gear. The nose gear…NTSB ANC86IA137Incident · No injuriesIncident investigationFinal reportCessna 207A · Togiak, AKAfter landing the airplane was taxiing to park and the pilot noticed the steering becoming stiff. He stopped the airplane and examined the nose gear and found it to have pivoted forward with the wheel coming to rest against the nose cowling. The mechanic…NTSB LAX86LA261Accident · No injuriesLimited investigationFinal reportCessna 150M · Santa Paula, CAWhile practicing takeoffs and landings on an authorized solo instructional flight the student pilot ballooned and began to porpoise down the runway. On the third nose gear contact with the runway the nose gear collapsed.NTSB NYC86LA120Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Plymouth, MAThe acft touched down on a grass landing area and the nose gear collapsed. The acft appeared to have touched down between a crossing runway and taxiway, both of which are asphalt. There is a depression, aprx 18-24 inches deep, that the acft crossed. Wrinkles…NTSB MIA86LA130Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Panama City, FLThe plt stated that on his apch he had a gear down & locked indication but on landing rollout, the nose gear completely collapsed and the acft slid to a stop on the rwy. Post accident examination of the landing gear system revealed that the nose gear…NTSB CHI86LA125Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Noblesville, INTwo successful takeoffs and landings had previously been completed during the training flight. On the approach for the third landing, the crew received a three-green indication, but after touchdown, the nose gear folded and the aircraft settled on its nose.…NTSB LAX86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mesa, AZThe pilot lost control of the aircraft which traveled off the runway following a nose gear collapse during landing. Examination of the aircraft revealed evidence of side loading.NTSB NYC86LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Frankfort, NYThe plt diverted to Frankfort-highland en route from his original destination of utica, NY, because of IFR weather at utica. The plt stated that as the nose wheel settled to the rwy during touchdown, it dug into snow on the rwy and the acft nosed over. It was…NTSB ATL86LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Hickory, NCStudent pilot was returning from a solo cross country flight. In his report the student said he flew a long final with the VASI showing a proper descent angle. The acft was landed with a shallow flare touching down in a flat attitude. It bounced, bounced…NTSB CHI85LA388Accident · No injuriesLimited investigationFinal reportCessna 152 · Delta, OHThe plt was performing a soft fld landing. When the nose wheel settled onto the airstrip it dug into the soft terrain, collapsed and the acft nosed over.NTSB ATL85LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Peachtree City, GAPilot was renewing proficiency in light acft. On first touch and go landing, according to his statement during phone interview, he flared, acft ballooned, landed hard and porpoised. During ensuing roll out nose of acft settled and prop contacted runway. Acft…NTSB NYC85LA176Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Hookstown, PAThe instructor and student were practicing normal takeoffs and landings. According to the pilot, on the sixth landing, at the correct airspeed, the aircraft touched down on the main gear and then the noise wheel collapsed. The aircraft then nosed over.…