NTSB investigations
665 cases where the first occurrence was “Nose over”.
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\" = 300) 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" = 300) 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 FTW87LA127Accident · No injuriesLimited investigationFinal reportCessna 140 · Waco, TXThe pilot stated that brakes were applied during the landing roll prior to the tailwheel making ground contact causing the aircraft to nose over and come to rest inverted. The aircraft was substantially damaged.NTSB FTW87DPA01Accident · Serious injuriesFinal reportNorth American SNJ-5 · Mckinney, TXThe pilot reportedly made a normal touchdown in a calm wind condition. During the landing rollout,however, he applied excessive braking. This caused the tail wheel equipped aircraft to nose over into an inverted attitude.NTSB MIA87LA159Accident · No injuriesLimited investigationFinal reportCessna 120 · Oklawaha, FLThe plt stated that a t-strm had recently passed over his home airstrip made of clay & grass & had left a puddle of standing water about 4 inches deep on a portion of the rwy. During the landing roll, just prior to the tailwheel contacting the rwy, the main…NTSB ATL87LA141Accident · No injuriesLimited investigationFinal reportCessna 150 · China Grove, NCDuring a supervised solo crosscountry flight, the student pilot reported that he got lost and was unable to visually locate his check point. After attempting to contact approach control for radar fixes, the pilot elected to make a precautionary landing in a…NTSB ANC87LA071Accident · No injuriesLimited investigationFinal reportCessna 182A · Talkeetna, AKThe pilot was tardy when deciding to abort the takeoff attempt from a rough short strip. The airplane ran into soft over-run and nosed over.NTSB FTW87LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Amarillo, TXAfter landing, the pilot attempted to taxi the aircraft to the ramp when he encountered strong gusty winds. The passenger and four linemen attempted to hold the aircraft down, but the winds blew the aircraft over inverted causing substantial damage.NTSB CHI87LA118Accident · No injuriesLimited investigationFinal reportPiper J3C · Midland, MIWhile taxiing to runway 24 run up area the aircraft flipped over onto its nose. The pilot stated a gust of wind caught the plane from behind. Winds at the tri-city airport, 12 miles southeast of Midland, were reported from 130 degrees at 6 knots.NTSB DEN87LA106Accident · Minor injuriesLimited investigationFinal reportShort Brothers SC7 · Denver, COThe plt said that he made a normal crosswind landing on rwy 26L at stapleton international arpt, Denver, Colorado. After leaving the rwy and taxiing parallel to the rwy he observed the wind increasing in velocity. He stopped the acft but a strong gust of wind…NTSB DEN87LA086Accident · No injuriesLimited investigationFinal reportBoeing A75L3 · Belgrade, MTThe plt report that he was landing on a 9000 x 150 ft asphalt rwy. The wind was nearly down the rwy at 4 to 9 KTS. In a telephone interview 2 days after the accident the plt reported that he was making a 'wheels' landing. He said when the main gear was about…NTSB ATL87LA077Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Dothan, ALThe plt reported that the acft nosed over when he applied the brakes during ldg roll-out. He estimated his groundspeed to be about 15-20 mph at the time.NTSB MIA87LA094Accident · No injuriesLimited investigationFinal reportCessna A185E · Melbourne, FLThe student plt inadvertently lowered the landing gear on the downwind leg in preparation for a water landing. The flt then turned base to final, &, upon touchdown, the acft nosed over & came to rest inverted in the lake. Investigation revealed that the…NTSB NYC87LA077Accident · No injuriesLimited investigationFinal reportStinson 108 · Wildwood, NJThe plt rprtd that prior to takeoff, he taxied thru svrl puddles of water from melting snow. The temp at that time was rprtd as 25 deg. He rprtd that when he landed at Wildwood, the wind was from 290 deg at 15 gusting 20 KTS & the temp was 30 deg. He said…NTSB ATL87LA048Accident · No injuriesLimited investigationFinal reportBeech D-17-S · Louisville, KYFollowing a normal landing on runway 06 at bowman field, the acft nosed over while clearing the rwy. The plt reported applying brakes and recalled feeling the tailwheel lift off the ground. The plt did not report any system malfunction, and the investigation…NTSB CHI87DEX02Accident · Minor injuriesFinal reportRohdecap/Thorp T-18 · Elwood, INThe plt departed anderson, Indiana to check farm fields for standing water, then elected to land at the Elwood arpt at Elwood, Indiana. The sod rwy at the arpt had an uneven gradient & was soft from recent rains. While landing on the soft,uneven rwy, the acft…NTSB ATL87LA015Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Ada, OHPlt stated that elevator control was lost during the landing roll. Acft nosed over inverted and received substantial damage. Investigation revealed that the lower cable to elevator bellcrank forward turnbuckle was fractured. Bellcrank was badly corroded. Last…NTSB MKC87LA010Accident · No injuriesLimited investigationFinal reportCessna 185 · Oakley, KSThe plt stated his landing apch was too fast and the acft touched down long. He then applied brakes and the acft nosed down resulting in the propeller striking the rwy. The acft then proceeded to flip over onto it's back. The plt stated he should not have…NTSB MIA87LA007Accident · No injuriesLimited investigationFinal reportWaco YMF · Key West, FLThe acft nosed over during landing roll. The professional plt stated that he was certain the brakes were off prior to takeoff and that he was sure he was not 'riding' the braked on landing. The plt stated that he thought the parking brake may have come on…NTSB SEA87LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Petersburg, AKThe plt reported that while landing on a river the acft skidded on river silt. He stated he could not stop the acft which traveled to the FAR end of the river into 8 inch deep water where it nosed over.NTSB BFO87FA003Accident · Minor injuriesField investigationFinal reportBellanca 8GCBC · Keysville, VAThe pilot made a tailwheel high touchdown on the 1850 foot grass strip. Shortly after touchdown, the nose dropped and, although the pilot said he moved the control stick fully aft, the propeller struck the ground, and the aircraft flipped inverted.NTSB ANC86LA163Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Windy Fork Rive, AKThe pilot lost control of the aircraft and nosed over during landing on a gravel bar. The pilot stated that the airplane nosed over because he stood on the brakes hard during the landing roll to prevent traveling into the river. The plt could not be contacted…NTSB ANC86LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big River, AKThe pilot attempted a touch and go landing to evaluate a questionable landing area. The area was too soft for a touch and go. The acft became mired in mod and nosed over.NTSB MIA86LA247Accident · No injuriesLimited investigationFinal reportCessna 140 · Jacksonville, FLThe accident occurred while practicing takeoffs and landings in a grass area adjacent to the asphalt runway. The aircraft contacted soft mud during the landing roll and nosed over.NTSB ANC86LA143Accident · No injuriesLimited investigationFinal reportCessna TU206A · Talkeetna, AKThe pilot forgot to retract the landing gear on the amphibous floats after taking off from a gravel runway. He landed on a lake with the wheels extended and the airplane turned over.NTSB SEA86LA218Accident · No injuriesLimited investigationFinal reportCessna A185E · Soldier Bar Air, IDThe pilot was attempting to land on a 1600 foot runway with a tailwind. The density altitude at the time was about 6300 feet. During braking a gust of wind occurred and the aircraft nosed over inverted.NTSB CHI86LA203Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Keego Harbor, MIAccording to the pilot, as he was preparing to land on a lake and was at an altitude of approximately 100 feet, he noticed that he did not have full flaps down. He then reached down, and by error, lowered the landing gear instead of the flaps. During…NTSB MKC86LA161Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Lewisville, ARThe PIC made a landing to a rain soaked sod rwy when the acft's right main gear fell into a large mud hole during the landing roll and the acft flipped inverted. The subsequent flipping action substantially damaged the acft.NTSB LAX86LA300Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · San Jose, CAThe plt applied the brakes heavily during the landing roll. As the aircraft slowed to approximately 5 mph it nosed over on its back.NTSB ANC86LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Port Moller, AKThe aircraft nosed over on landing rollout after landing on a beach.NTSB ANC86LA110Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe plt stated that he landed in the water with the landing gear on the floats in the down and locked position. The acft nosed over in the water on touchdown. The plt stated he failed to use a before landing checklist.NTSB LAX86LA301Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Pleasant Grove, CAThe pilot said the aircraft had new brakes installed prior to the flight. After touchdown at the conclusion of a local flight, the pilot said he 'applied too much pressure to the pedals and could not release the pressure in time to prevent the aircraft from…NTSB FTW86LPJ10Accident · No injuriesFinal reportGrumman G-164 · Hooker, OKThe pilot stated that the aircraft flipped over when he landed in soft dirt on his recently extended private landing strip.NTSB MIA86LA158Accident · No injuriesLimited investigationFinal reportCessna 182A · Winter Haven, FLThe plt stated that as he was taxiing the acft from landing, the nose gear became stuck in soft dirt. The propeller then struck the ground and the acft nosed over.NTSB MIA86LA258Accident · Minor injuriesLimited investigationFinal reportBrewster Fleet 7 · Arcadia, FLAccording to statements, the pilot experienced brake difficulty & the acft flipped over during landing rollout & came to rest inverted.NTSB DEN86LA106Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Tioga, NDThe plt dept minot, ND, with his son aboard, for a pvt airstrip near his home of windrose, ND. He said because of high winds he landed at Tioga, ND. He said that while taxiing after landing strong gusty winds flipped his acft upside down. The acft was…NTSB NYC86LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Newburyport, MAWhile taxiing on a grass taxiway, the acft contacted a soft spot in the grass and nosed over.NTSB ATL86LA091Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Hampton, GADuring landing roll the pilot was unable to keep the tailwheel on the ground and the aircraft nosed over. Post crash examination of the wreckage disclosed that the brake pads were worn down to the rivets.NTSB SEA86LA072Accident · No injuriesLimited investigationFinal reportPatrick Henry Fokker DR. 1 · Gold Hill, ORPlt attempted spur of the moment landing in open field. Acft wheels sank into soft terrain after touchdown and acft nosed over.NTSB DEN86LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wisdom, MTThe student plt departed minden, NV on an unauthorized x-co flt that terminated in the accident at Wisdom, MT. During the landing roll at an abandoned arpt at Wisdom, the nose of the acft dug into the snow covered runway and the acft nosed over. The plt…NTSB LAX86LA100Accident · Minor injuriesLimited investigationFinal reportErcoupe E · Apple Valley, CAThe plt stated that the acft's eng lost power and the acft flipped over during an attempted forced landing on a dirt road in front of his residence. A witness stated that the acft made three low passes over the dirt road prior to touchdown. A witness…NTSB SEA86LA048Accident · No injuriesLimited investigationFinal reportCessna 206 · Wenatchee, WAThe pilot diverted from his intended destination of pangborn field to a local private airstrip due to local fog. 8' of crusted snow was present on the runway and the aircraft nosed over on landing roll.NTSB MKC86LA054Accident · No injuriesLimited investigationFinal reportCessna 150 · Bancroft, IAThe plt became disoriented on a night, VFR flt and landed at an arpt to determine his location. The unattended arpt did not have a phone so the plt tookoff again enroute to his original dest. He became disoriented a second time and, because the acft was…NTSB NYC86LA063Accident · No injuriesLimited investigationFinal reportLuscombe 8B · Turin, NYThe personal flight from oswego, NY to Turin, NY was uneventful and without problems. However while landing in soft snow, the right ski dug into the soft snow. The landing gear failed and the aircraft nosed over onto its back and was substantially damaged.…NTSB CHI86LA061Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mount Gilead, OHAccording to the arpt manager, the plt was taxiing down the active in gusty wind conditions at a fairly rapid rate of speed. As the plt turned into the run-up pad area the acft nosed over.NTSB ANC86LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fishtrap Lake, AKPilot attempted to land his wheel equipped aircraft on frozen lake with water overflow and 12 to 18 inches snow. Acft broke through top layer of thin ice and nosed over upon touchdown.NTSB DEN86LA024Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Berthoud, COThe plt stated that he made 7-9 high speed taxies to pack the snow on the grass strip, aborting mid-strip when flying speed was not attained. On the final run, the plt said the acft again failed to reach flying speed and decided to abort mid-strip. The plt…NTSB ANC86LA008Accident · No injuriesLimited investigationFinal reportCessna 150 · Rainbow Lake, AKThe plt reported that after the acft touched down on a snow covered, frozen lake, he was unable to hold the nose gear up, due to the depth of the snow. When the nose came down, the nose gear buckled under & the acft nosed over.NTSB SEA86LA019Accident · No injuriesLimited investigationFinal reportCessna C206 · Funter Bay, AKThe left main gear did not retract and during water landing caused the aircraft to nose over. The link pin rod was found to be broken and the cylinder assembly main retract link and pin down latch were found to be bent.NTSB ATL85LA281Accident · No injuriesLimited investigationFinal reportCessna A188B · Baxley, GAPlt attempted ldg in cultivated field after sowing load of rye grass seed. Grnd was soft and wheel dug in and acft nosed over. Plt was not injured.NTSB ATL85LA265Accident · No injuriesLimited investigationFinal reportBellanca Champion 7GCAA · Alabaster, ALThe plt lost directional control of the acft during a landing. The acft nosed over coming to rest inverted. The plt related that a gust of wind caused the loss of control.NTSB ANC85LA165Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Gold King Creek, AKThe plt stated that when he landed, the acft was rolling out on its main gear in a tail low attitude, when he applied braking action. A moment later, the acft began to pitch nose down. He compensated with full up elevator, but the acft nosed over.