NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
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\" = 260) 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" = 260) 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 LAX86LA152Accident · No injuriesLimited investigationFinal reportCessna C-152T · Fresno, CAA Cessna 152 collided with terrain after running off rwy 29L. The plt indicated he made a go-around on first approach due to difficulty maintaining rwy heading. On second approach he was aligned a little left of centerline and elected to land. The acft…NTSB ANC86LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe flight instructor stated that he was demonstrating a stall landing to the student pilot. After touchdown and rollout the aircraft struck a snow drift on the runway causing the aircraft to nose over on its back.NTSB NYC86LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hartford, CTThe cross country solo flight was taking off on runway 02 at Hartford, Connecticut. The pilot performed a runup and was cleared for takeoff. The pilot attempted rotation at about 60 KIAS, but aircraft did not lift off. Trim tab was set at neutral on runup. As…NTSB FTW86LPA16Accident · No injuriesFinal reportCessna 188 · Atlanta, TXThe pilot lost directional control of the aircraft during the landing roll. It then departed the runway and ran into a drainage ditch which collapsed the main landing gear.NTSB ANC86LA040Accident · No injuriesLimited investigationFinal reportCessna 170-B · Whittier, AKThe pilot stated that after touchdown he realized that the snow was soft. The aircraft nosed over on its back.NTSB ANC86LA038Accident · No injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKThe pilot stated that during the takeoff roll he added power too fast for the takeoff. The pilot failed to compensate with rudder.NTSB MKC86LA070Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Mulvane, KSThe PIC of the acft landed his Cessna 182 to the north on a farm pasture he owns which doubles as a landing strip. The PIC stated he approached too high and too fast, landing about midway of the field. A fence which borders the field was fast approaching with…NTSB LAX86LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Hayward, CAA Cessna 172P collided with a rwy light after veering off rwy 28. The winds at the time off the accident were reported from 350 deg at 6 KTS. The right main landing gear collapsed when it struck a rwy light damaging the right wing and tail section.NTSB FTW86LA045Accident · 1 fatalLimited investigationFinal reportCessna TU206F · Goliad, TXThe pilot apparently failed to properly recover from a bounced landing and broke a landing gear wheel. The aircraft hit and fatally injured a person on the ground. Local authorities believe the persons body was then transported about four miles and thrown…NTSB MKC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Lake City, ARThe flight instructor and his student touched down on the newly constructed private dirt strip in the airplane and rolled for 610 feet before the main gear bogged down. The nosewheel then cocked sideways and the airplane rolled forward to the inverted…NTSB DEN86LA100Accident · No injuriesLimited investigationFinal reportCessna A185F · Bozeman, MTAccording to the plt, shortly after touchdown, the right wing came up and the acft seemed to be pushed to the left. The plt said before he regained control, the left wing and horizontal stabilizer contacted the ground. The plt later learned that a Boeing 767…NTSB SEA86LA076Accident · No injuriesLimited investigationFinal reportBeech 18 · Seattle, WAThe pilot lost control of the aircraft on takeoff and a subsequent groundloop occurred. Although the pilot has a DC-3 type rating, he had only 20 hours in this aircraft.NTSB BFO86LA019Accident · No injuriesLimited investigationFinal reportCessna 150M · Orange, VAAt about 1245 EST, the plt took off on his second flt of the day and flew in the local area about 30 minutes. Upon returning to Orange county arpt, the plt observed the tetrahedron during the left downwind leg for rwy 25, and noted that the wind had changed…NTSB SEA86LA077Accident · No injuriesLimited investigationFinal reportAeronca 7AC · East Sound, WAUpon rollout, a loss of directional control occurred during a wind gust. The pilot elected to go-around. Shortly after lift off, the main gear of the aircraft struck VASI lights. The aircraft then struck the ground.NTSB MKC86LA067Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Jacksonville, ARThe pilot was attempting a takeoff from a sod strip in an Aeronca tail dragger aircraft in gusty wind conditions. The air strip runway is situated along a north-south heading with the rptd winds fm 290 degrees magnetic at 13 knots with gusts to 18 knots. As…NTSB ATL86LA086Accident · No injuriesLimited investigationFinal reportGrumman American AA5A · Fayetteville, NCDuring landing roll the pilot lost directional control of the aircraft. The aircraft ground looped and swerved off the runway. The pilot stated that he should have been more diligent in correcting for the crosswind condition.NTSB SEA86LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · American Falls, IDThe student pilot was attempting to make a touch and go, when the aircraft veered to the left of the runway and struck an embankment. The student failed to use enough right rudder to maintain directional control. The runway's width is 50 feet.NTSB DEN86LA090Accident · No injuriesLimited investigationFinal reportCessna 180J · Casper, WYAccording to the flt instructor, during the touch and go landing, directional control was lost when brakes were applied and the acft ground looped. During the investigation, it was ascertained that an 'o' ring on the right wheel had dislodged, resulting in…NTSB MKC86LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Grain Valley, MOThe PIC was making a roundtrip flt to numerous airports across Kansas and Missouri. The owner of the aircraft was aboard for the trip which was for pleasure. The PIC had obtained weather info and was apprised of the wind conditions for his route of flt. Upon…NTSB FTW86LRD08Accident · No injuriesFinal reportCessna 172P · Many, LAThe acft drifted off the rt side of the rwy into the soft shoulder during landing in a 10-12 kt x-wind. When the nose gear contacted the soft dirt it collapsed, which resulted in a nose over.NTSB NYC86FHA01Accident · No injuriesFinal reportPiper PA-28-140 · Doylestown, PAThe Piper PA-28-140 was landing on rwy 23. The winds were reported to be from 320' - 330' with a velocity of 20 KTS and gusts to 30 KTS. The student pilot lost control on landing and veared off the right side of runway. The aircraft received substantial…NTSB DEN86LA087Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Red Lodge, MTThe plt stated that during the ground roll phase of landing at Red Lodge, MT, he lost control of the acft which entered into a ground loop to the right. Just prior to the acft departing the right side of the rwy, he applied maximum braking, and the acft nosed…NTSB CHI86LA095Accident · No injuriesLimited investigationFinal reportCessna 172C · Waupun, WIDrg arrival for a x-wind landing, the plt made a high apch & used full flaps to steepen his dscnt over trees near the apch end of the rwy. He stated that the touchdown was normal, but before he could raise the flaps, the x-wind pushed the plane to the left.…NTSB CHI86LA093Accident · No injuriesLimited investigationFinal reportBeech C23 · Elkhart, INThe plt was unable to start the acft eng and got out to pull the prop through by hand. The magneto switch had been left in the both position and the eng started as the passenger primed the eng while the plt pulled the prop through. The plt was unable to stop…NTSB DEN86LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Quemado, NMThe plt said the wind was variable and gusty. When the takeoff was started there was a quartering headwind but as takeoff speed was reached the wind switched to a tailwind. The acft lifted off but immediately settled back to the rwy. The plt then added flaps…NTSB DEN86IA083Incident · No injuriesIncident investigationFinal reportCessna T207A · Longmont, COAccording to the FAA examiner, the plt whom he was giving a checkride to applied full brakes during the short field landing, causing both tires to fail.NTSB NYC86LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Nashua, NHThe student pilot was performing touch and go landings at boire field when he applied power to takeoff, he was distracted by the flap control setting. During this distraction the aircraft drifted to the left. Full right rudder was used in an attempt to…NTSB FTW86LQA01Accident · Minor injuriesFinal reportCessna 152 · El Paso, TXThe acft went off the rwy and nosed over in the rough sand. The plt said that she looked into the cockpit to locate the flap switch to raise the flaps for a running takeoff. Power had already been added and the acft started to the left by the time the plt…NTSB LAX86LVM02Accident · No injuriesFinal reportBellanca 7ECA · San Jose, CAThe acft ground looped to the left after landing. The student plt said he attempted with rudder and aileron to regain directional control but failed. After rolling into the grass the acft nosed over. The plt said he should have held the stick back to assure…NTSB MKC86LA063Accident · No injuriesLimited investigationFinal reportCessna 170B · Alliance, NEThe plt had just completed a biennial flight review in Alliance, Nebraska and was returning to land on his ranch property south of Alliance. Wind rpts fm the Alliance airport, and the FAA flight service station in scottsbluff, indicated winds generally fm the…NTSB ATL86LA078Accident · No injuriesLimited investigationFinal reportCessna 172N · Washington, NCThe student pilot stated that the aircraft encountered a gust of wind during landing flare causing the aircraft to drift to the left upon touchdown. In an attempt to correct for the drift the student pilot applied left brake pressure as well as left rudder…NTSB FTW86LQG08Accident · No injuriesFinal reportWayne Mathews Glas AIR SH2R · Ranger, TXThe acft drifted left off the rwy during takeoff and collided with trees. This was a home built acft that had just been certified. The owner/builder had made high speed taxi runs but did not feel comfortable to fly it. Another plt was asked and after a short…NTSB CHI86LA088Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Frankfort, ILFollowing a descent through icing conditions the plt was told by the UNICOM operator that the active rwy was 'slippery'.the plt landed aprx 600-700 ft down the 3176 ft rwy and found that the braking action deteriorated from poor to nil during rollout. He…NTSB MIA86LA078Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Clewiston, FLThe plt stated that a x-wind caused him to lose control of the acft while attempting to land on a x-country flt. The acft departed the rwy and struck a ditch. The plt indicated that no pre-flt wx briefing was obtained prior to departure.NTSB ANC86LA029Accident · No injuriesLimited investigationFinal reportCessna 185 · Mccarthy, AKThe pilot stated that he touched down too hard and the main wheels broke through the crust on the snow. The pilot lost control of the aircraft causing the plane to nose over on its back.NTSB SEA86LA057Accident · No injuriesLimited investigationFinal reportCessna 172 · Renton, WAThe pilot failed to maintain directional control during takeoff. Although a crosswind from the left was present the pilot lost control for unknown reasons to the left, crossing the taxiway and then striking a parked vehicle and building. No mechanical reason…NTSB CHI86LA082Accident · No injuriesLimited investigationFinal reportCessna 340R · Galesburg, ILThe pilot was diverting into Galesburg due to bad weather at his original destination. Following an ILS approach at Galesburg he spotted the runway at '200 ft plus' off to his right. He then 'side-stepped' to the right but touched down in a crabbed angle. He…NTSB NYC86LA067Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Vincentown, NJThe pilot stated that a normal approach and a 3 point landing were made at the red lion airport. However after the aircraft rolled for 2-3 seconds, it started to drift to the right. Left rudder was applied, but there was no response. The pilot then applied…NTSB MKC86LA056Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Des Moines, IAThe student pilot stated he was on the takeoff roll for a practice flight when he lost directional control and ran off the left edge of the runway and stayed there until it impacted a taxi/intersection sign.NTSB SEA86LA050Accident · No injuriesLimited investigationFinal reportCessna T210-H · Cascade Locks, ORDuring landing roll on the 1800 foot long 30 foot wide wet runway, the aircraft veered right off the runway and then nosed over. The pilot applied brakes twice with no effect and the third time they grabbed. No malfunctions were found during inspection or…NTSB SEA86LA049Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Metlakatla, AKWind was 070 degrees at 20 KTS with 6-12 inch sweels. N127WA was positioned at north side of dock for departure toward east. N1018H was holding at east side of dock. Deck hand cast off N127WA before plt started engine; acft began to drift back into dock. Plt…NTSB MIA86LA067Accident · No injuriesLimited investigationFinal reportCessna 152 · San Juan, PRThe student pilot, on his third supervised solo flight, lost control of the aircraft during the landing roll and collided with an aircraft parked south of the runway.NTSB FTW86LRG12Accident · No injuriesFinal reportFairchild 24R-46A · Lakeway, TXThe dual instructional flight terminated in a crosswind landing with the rated pilot receiving dual instruction manipulating the controls. During the landing rollout directional control was lost and the aircraft veered to the left. According to the instructor…NTSB CHI86LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Baraboo, WIThe plt attempted a x-wind landing that was beyond his capabilities. He stated that if the x-wind was excessive he intended to divert to another arpt with a more favorable runway. At touchdown the aircraft drifted right into a two foot high snow bank off the…NTSB MIA86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Melbourne, FLThe plt stated that on his landing rollout he lost control of the acft & veered off the left side of rwy 9L collapsing the nose gear.NTSB FTW86LRA05Accident · No injuriesFinal reportCessna 172 · Tomball, TXThe acft veered off the left side of the rwy during landing. The nose wheel dug into mud and the acft nosed over. The plt said he was unable to correct the violent turn to the left.NTSB MKC86LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, MODuring an aborted takeoff in strong crosswinds, the acft veered off the rwy and into a ditch near the runways edge. The nose gear collapsed rearward and the right wing dropped striking the ground. The plt stated he aborted the takeoff when the acft felt like…NTSB DEN86LA068Accident · Minor injuriesLimited investigationFinal reportCameron 0-77 · Rio Rancho, NMThe plt stated that during the inflation of his balloon, the safety line holding the basket to his support vehicle broke during windy conditions. According to the plt, he tried to inflate the envelope in order to climb above buildings nearby. The plt…NTSB NYC86LA062Accident · No injuriesLimited investigationFinal reportCessna 172 · Durhamville, NYThe flight was returning from a 4-LEG 300-mile cross country trip. On flare touchdown, the pilot reported severe vibration. As brakes were applied the vibration increased, and the aircraft became uncontrollable. The aircraft pulled to the right and collided…NTSB BFO86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Leesburg, VAThe student pilot stated that uneven braking during landing caused the aircraft to swerve off the side of the runway. He further added that he applied full power shortly thereafter due to the fact that the aircraft was heading for a ditch. The aircraft…