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 MIA85IA238Incident · No injuriesIncident investigationFinal reportAeronca 7AC · Ft. Lauderdale, FLThe plt stated that while taxing for takeoff the acft encountered a gust of wind. Nosed over & the propeller & right wing tip struck the ground.NTSB ANC85LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Fairbanks, AKDuring landing the plt applied hard braking to avoid an airplane and rolled over.NTSB DEN85LA223Accident · No injuriesLimited investigationFinal reportCessna 120 · Erie, COThe plt stated after the accident that she had landed and the acft rolled aprx 600 ft when she attempted to turn off onto the taxiway while the acft was traveling at a moderate speed. A witness stated that he saw the trees 'lock up' as the acft approached the…NTSB CHI85LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Valparaiso, INThe acft nosed over during landing. The plt said that he made a wheel lndg and after the acft slowed to 20 mph the tail lifted and the acft nosed over.NTSB ANC85LA127Accident · No injuriesLimited investigationFinal reportPiper J-3 · Tyrone Creek, AKThe plt delayed initiating an aborted landing, and the acft rolled into water at the end of the rwy where it nosed over.NTSB MKC85LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Corning, ARThe student plt became disoriented while on a solo cross country flt. When the acft became low on fuel the plt decided to land on a plowed fld. The fld was soft and the acft nosed over shortly after touchdown.NTSB CHI85LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · East Alton, ILThe acft was blown inverted by wind gusts shortly after landing. The plt stated the wx was fine until after touchdown when the wind began gusting to 35 KTS. The plt turned the acft left off the rwy, contacted ground control and initiated a right turn onto the…NTSB NYC85LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Champlain, NYDuring the landing in a pasture with tall grass, the main wheels contacted the grass, the acft slowed rapidly and nosed over.NTSB NYC85LA148Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Peru, NYThe acft nosed over while landing on a private sod airstrip. The plt reported touchdown was made on an unmowed portion of the airstrip. The acft slowed quickly and nosed over just prior to coming to a stop.NTSB CHI85LA217Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrill, WIThe plt was performing touch-and-go's when on the landing roll she allowed the acft to drift off the rwy into soft terrain. The acft nosed over. The plt stated that she was looking inside to raise the flaps.NTSB NYC85LA130Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Pittsburgh, PAThe personal transportation flight took off from allegheny co. ariport and made one landing back at the airport. The flight then departed the airport and made a landing on the water with the wheels down causing the aircraft to tip o ver onto its back.NTSB ANC85LA068Accident · No injuriesLimited investigationFinal reportCessna A152AEROBAT · Whittier, AKThe pilot in command failed to perform an adequate reconnaisance of the airport prior to landing and did not avail himself of all information concerning the runway conditions.NTSB NYC85LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Kintnersville, PAThe pilot decided to abort the takeoff when he realized that too much runway was being used. During the rollout, the pilot began to turn the aircraft to the right. The wind lifted the tail of the aircraft until it nosed over onto its back.NTSB SEA85LA087Accident · No injuriesLimited investigationFinal reportCessna 182 · Walla Walla, WADuring taxi from landing a gust of wind pushed the acft from behind onto soft ground where it nosed over.NTSB FTW85LA136Accident · No injuriesLimited investigationFinal reportCessna 180 · Houma, LAThe plt was attempting to takeoff from a short muddy strip near Houma, LA. He elected to abort the takeoff & applied brakes. The acft then rolled over a dry area on the strip, where braking action became effective & the aircraft nosed over. No mechanical…NTSB MIA85LA103Accident · No injuriesLimited investigationFinal reportCessna 182M · Davie, FLPlt stated he intended to land at opa-locka and he was in a hurry to do so because a passenger had become air sick. Instead, the plt unintentionally landed on an ultralight airstrip. The landing gear dug into soft terrain during the landing roll and the acft…NTSB MKC85LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Waldron, MOThe acft nosed over inverted after the left landing gear wheel contacted snow alongside the rwy during a touch and go.NTSB ANC85FA042Accident · No injuriesField investigationFinal reportPiper PA-18 · Minto, AKThe plt had landed the ski equipped acft on the shore of a lake that was covered with grassy tundra & snow. For a subsequent takeoff, he elected to continue straight ahead rather than back taxi to where he had a known surface condition. During the takeoff,…NTSB SEA85LA047Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Wenatchee, WAThe plt elected to make a precautionary landing onto a snow covered grain field. He stated his artifical horizon was inoperative & darkness was approaching. Also, he said he saw a needle flicker & he was not sure if it was a fuel gage or his oil pressure…NTSB DEN85LA054Accident · No injuriesLimited investigationFinal reportCessna 180 · Marion, MTThe acft nosed over onto its back after the plt landed in snow 6 to 8 inches in depth.NTSB LAX85LA087Accident · No injuriesLimited investigationFinal reportCessna 172N · Pacoima, CAThe plt landed normally & taxied off the rwy. The acft encountered a gust of wind & nosed over. Winds were reported as 300 deg at 20 KTS gusting to 25 KTS.NTSB LAX85FA050Accident · No injuriesField investigationFinal reportCessna 305A · Los Alamitos, CAThe acft nosed over during landing roll. Plt stated he had just completed a glider tow mission and that on touchdown the tail wheel began to shimmy excessively. The acft lifted off and settled back on the rwy, at which time the tail wheel shimmy became worse…NTSB ATL85LA027Accident · No injuriesLimited investigationFinal reportCessna 180J · Harmony, NCThe commercial plt being checked in a tail wheel equipped acft by a CFI on board made 2 successful landings. During the 3rd landing roll, the acft nosed over. The student said that he applied 'heavy' braking during an attempted downslope, short field landing…NTSB ANC85LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKAccording to the plt, when he arrived at the gravel bar the passengers to be picked up were not there & could not be located from the air. After making low passes over the gravel bar he determined that the snow did not look deep and touched down to check the…NTSB LAX85LA022Accident · No injuriesLimited investigationFinal reportCessna 180 · Santa Monica, CAPlt reproted, descent made to mda of 740 ft MSL and visual contact made with rwy 1/2 mile east of arpt. Slipped acft to within 200 ft of rwy and made a wheel landing midfield. Both wheels locked up and acft nosed over. Plt stated, 'I may have had my feet on…NTSB LAX84LA468Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Van Nuys, CADuring the third touch & go landing the certificated plt receiving dual instruction was at the controls when directional control was temporarily lost. The CFI in the front cockpit regained control. Shortly thereafter the plt under instruction applied heavy…NTSB ANC84LA171Accident · No injuriesLimited investigationFinal reportHelio H-395A · Shellerbager Ps, AKThe plt landed on a rwy that was covered with 18 to 30 inches of snow. Shortly after touchdown the acft nosed over. The plt recommended that when in doubt about landing-don't land.NTSB ATL84LA269Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Virginia Beach, VAOn landing roll plt diverted aircraft to right to avoid a truck which had pulled onto the runway. This placed the aircraft in line with banner towing equipment. The plt applied the brakes while the tail wheel was still off the ground in attempts to stop prior…NTSB MIA84LA236Accident · No injuriesLimited investigationFinal reportCessna 172 · Winter Haven, FLThe acft landed on glassy water in a nose low attitude and nosed over. The CFI who was checking out an applicant for a seaplane rating said he was preparing to call for or actually pulled the nose up as the acft floats hit the water and went under. According…NTSB SEA84LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR B9-4000 · Vancouver, WAThe pilot stated after the accident that he applied too much brake during the landing roll. The aircraft nosed over.NTSB ANC84LA138Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Iliamna, AKPlt had delivered new float plane. Owner requested a demo flt as pilot at controls. Pilot in command permitted this despite knowledge that owner had no float plane experience. Takeoff and pattern circuit were normal. Landing flare appeared slightly nose low…NTSB ANC84LA136Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Nabesna Glacier, AKAccording to the plt, due to obstacles and downdrafts a higher than normal approach was flown to the unimproved gravel and sand landing area. Touchdown was long and heavy braking was applied. As the acft rolled into a sandy area and nosed over.NTSB ATL84LA220Accident · Minor injuriesLimited investigationFinal reportSnow 600-S2C · Lambert, MSDuring the landing roll the tailwheel reportedly oscillated braking the shock strut lugs allowing the tail of the acft to contact the sod runway. The plt applied hard braking and the acft nosed over. The plt reported nothing was wrong with the tailwheel…NTSB ANC84LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Seldovia, AKThe acft nosed over during landing on a 2600 ft gravel rwy nestled in the hills with variable winds. The plt had temporarily traded acft for this trip and had not flown this type of acft for the preceding 90 day period. He normally flew his Cessna 185. He was…NTSB MKC84LA199Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Sherrill, ARThe plt stated he was landing with a slight tailwind & the new brake system on the acft was sensitive. During touchdown,the acft nose over.NTSB FTW84LA294Accident · No injuriesLimited investigationFinal reportCessna 152 · Washington, OKThe plt reported that after he had landed & decelerated almost to taxi speed, the nose gear dug into soft terrain as he was turning off the landing area. The acft then slowly nosed over.NTSB ANC84LA106Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Anchorage, AKThe plt made an off arpt landing in a soft field camouflaged by tall weeds & marsh grass. He thought the terrain was dry, but the soil was wet & soft, & after a very short roll, the acft nosed over.NTSB NYC84LA220Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Orange, MAThe plt stated that he was giving local sightseeing flights. He indicated that a 'wide' gentleman and a 'moderate' size gentleman boarded the acft. The plt moved the throttle to ensure clearance but found one of the pax restricted the movement slightly. The…NTSB MKC84LA170Accident · No injuriesLimited investigationFinal reportStolp Starduster Starduster II · Lawrence, KSDuring takeoff roll from a grass covered runway the plt aborted the takeoff. The acft nosed over as the plt attempted to bring it to a stop. The plt stated that the acft did not appear to be accelerating as it should & so he aborted the takeoff. He said that…NTSB LAX84LA352Accident · No injuriesLimited investigationFinal reportCessna T210 · California City, CAThe plt felt a vibration as he circled a lake bed, so he decided to make a precautionary landing. During the landing, the nose gear dug into a soft spot and the acft nosed over.NTSB ATL84LA210Accident · Minor injuriesLimited investigationFinal reportJohnson Skyote · Portsmouth, VAThe acft was a recently manufactured, home built plane that was equipped with brakes that were designed for a much larger (Piper PA-23) acft. The plt stated that the brakes were too sensitive for his acft, a skyote. Also, he equipped it with a high quality…NTSB MKC84LA161Accident · No injuriesLimited investigationFinal reportCessna 172P · Wichita, KSThe acft nosed over while taxiing onto the rwy in high winds. The plt had received the ATIS weather that reported arpt surface winds from 190 degrees at 26 KTS gusting to 41 KTS. The plt taxied to the rwy and was turning to line up when the wind picked up one…NTSB ANC84LA081Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Skwentna, AKThe plt selected a marshy soft tundra for a landing. The rollout was longer than intended. Before stopping, the acft landing gear sank into the muskeg & the acft nosed over. The plt stated that no deficiencies were noted in equipment.NTSB FTW84LA252Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Port Aransas, TXPlt stated an engine miss was experienced. Plt elected a precautionary landing on the beach during which main gear dug into sand and acft nosed over. During a helicopter recovery the acft was jettisoned from aprx 500 ft AGL. Impact damage resulting from the…NTSB ANC84FA075Accident · No injuriesField investigationFinal reportPiper PA-12 · Palmer, AKThe acft landed fast & long on the rough 1300 ft grass & dirt rwy. At the departure end of the strip, the the acft nosed over as the plt was applying braking action.NTSB ANC84LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gakona, AKThe acft broke the ice on fox lake during landing and nosed over. The plt refused to file an accident report and is not reachable by telephone. No flt plan was filed so departure point is unknown as are the details of the occurrence.NTSB ATL84LA171Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Rosedale, MSThe plt was transporting the acft to a newly constructed, private ag strip to begin aerial application. During the landing roll, one of the main landing gear rolled into a soft spot & sank into the ground, then the acft nosed over.NTSB NYC84LA160Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Newburyport, MAWhile landing on rwy 28, the acft encountered a gust of wind. The plt reported that the wind caught the tail of the acft & caused it to drift. He stated that he continued the landing, but applied the brakes too fast & the acft nosed over. He reported the wind…NTSB ATL84LA161Accident · No injuriesLimited investigationFinal reportWaco RNF · Thomaston, GADuring the landing roll the acft drifted to the side of the sod strip where a wheel encountered a surface deviation. The acft turned & nosed over.NTSB ATL84LA157Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wilmington, NCWhile the plt was taxiing after landing, one wheel of the acft mired in a soft spot. The acft then veered into softer terrain & nosed over.