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 LAX83LA145Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS2-33A · Fremont, CAThe acft banged into the ground during the takeoff ground run. The glider had swerved off the rwy during the tow into a muddy grass area, the plt attempted a premature takeoff to prevent getting struck in the mud. He stated that lack of forward speed and the…NTSB FTW83LA152Accident · No injuriesLimited investigationFinal reportNorth American AT-6 · Norman, OKDuring arrival, the plt landed with a 30 deg left crosswind. After touching down in a 3-point attitude, the acft swerved to the right & turned aprx 25 deg before the plt regained control. He corrected the heading to parallel the runway aprx 10 ft right of a…NTSB CHI83LA128Accident · No injuriesLimited investigationFinal reportCessna 150D · Wilmington, OHThe aircraft operated by a student pilot swerved off the runway during a touch and go landing and nosed over. The pilot had been practicing touch and go landing for about 40 minutes preceding the accident. During the last landing he toucheddown in a crab and…NTSB ANC83LA051Accident · No injuriesLimited investigationFinal reportCessna 150M · Chugiak, AKThe student plt & his instructor had just completed a dual instruction flt & the student was on his 1st solo. He took off from the uncontrolled arpt which had snow on the rwy, except the middle 10 ft of the rwy was clear & dry. As the student was in the…NTSB DEN83LA094Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Havre, MTThe plt reported that he was taking off from a dirt strip on his farm to check on some cattle from the air. During the takeoff roll, the left main gear went into some mud & pulled the acft to the left. Subsequently, the acft contacted frozen dirt piles & some…NTSB DEN83LA068Accident · No injuriesLimited investigationFinal reportCessna 170B · Buffalo, WYThe acfts main left gear collapsed during a groundloop on landing. The pilot stated that his approach to landing was normal but after touchdown the acft veered to the right. He said the wind was not a factor. The pilot gave a federal inspector the impression…NTSB ANC83LA048Accident · No injuriesLimited investigationFinal reportDouglas DC-6A · Nuiqsut, AKThe captain reported that the acft moved faster at idle pwr because the cargo had been offloaded. When he checked the brakes halfway down the taxiway he found that the brakes would not slow the acft on glare ice and snow. The flt engineer began reversing the…NTSB LAX83LA119Accident · No injuriesLimited investigationFinal reportCessna 172P · Chandler, AZThe acft left the runway during landing and entered a plowed field where a wing made contact with the furrows. The pilot stated that because of the crosswind he used only 10 degrees of flaps. A gust of wind caught the acft as he flaredfor landing and pushed…NTSB CHI83LA119Accident · No injuriesLimited investigationFinal reportCessna 140 · Elyria, OHThe acft veered off the left side of rwy 27 and nosed over during landing. This was the student pilots second supervisedsolo and his third landing to a full stop. The weather was VMC with the wind from 360 degrees at 4 KTS.NTSB NYC83LA069Accident · No injuriesLimited investigationFinal reportCessna 152 · Mountville, PAThe turf rwy was wet from melting snow with snowbanks on both sides. The plt decided to take off from the left side staying clear of mud. Acceleration was slower than normal due to the wet grass & as the plt tried to rotate a loud bang was heard. The plt…NTSB LAX83LA111Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Chino, CAThe acft bounced ground looped off the runway and nosed over during landing. The acft left the runway and went into grass that was about 3 feet high. When the landing gear dug into soft dirt the acft nosed over. The pilot had only about 3 hours flying time in…NTSB NYC83LA066Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Blairstown, NJThe plt lost directional control & the acft swerved into a snowbank.NTSB LAX83LA106Accident · No injuriesLimited investigationFinal reportCessna 182RG · Marble Canyon, AZDuring the landing the pilot lost control of the aircraft in a gusty wind. The aircraft left the runway and nosed over. In soft terrain. He blamed his slow reaction and inexperience for the accident. The wind was from 300 degrees at 11 KTS gusting to 18 KTS.NTSB FTW83LA124Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Arcola, TXThe pilot reported that he was landing on runway 10 with a wind from the southeast & gusting. He reported that a strong gust caught the acft just at touchdown, causing the left main gear to contact a soft shoulder which sloped away from the pavement.…NTSB DEN83LA064Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COThe acft went out of control during an attempted go-around and contacted snow covered terrain where it nosed over. The pilot encountered gusty cross-winds at touchdown during landing and started a go-around. The go-around attempt was unsuccessful as the acft…NTSB ATL83LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Mocksville, NCThe acft nosed over in the mud off the rwy during landing. This was the student plts 2nd solo and during landing roll inpreparation for a running take off (touch and go) control of the acft was lost. The student said he started to go then changed his mind and…NTSB ATL83LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Leonardtown, MDPilot did not maintain alignment during takeoff and collided with a pile driver. The aircraft was then landed gear up inan adjacent field. The wind was calm and there was no known reason for failure to maintain runway alignment.NTSB ATL83FID04Accident · No injuriesFinal reportCessna 210G · Chesterfield, VAThe acft collided with a snow bank during landing. The student pilot was making touch & go landings on a traffic flight. The snow banks covered 17 feet on each side of the runway. Runway width was 75 feet. The CFI said the acft drifted to the left during a…NTSB MKC83LA067Accident · No injuriesLimited investigationFinal reportBeech B23 · Omaha, NEThe pilot was not totally familiar with the operation of this aircraft. The aircraft engine was started without setting the parking brake properly. The pilot did not have his feet on the brakes and could not reduce the throttle because of the throttle lock.…NTSB LAX83FA100Accident · No injuriesField investigationFinal reportHelio H-395 · Tucson, AZThe acft ground looped during landing and collided with an acft arresting system component. The pilot was landing on RWY11L. He did not report any difficulty controlling the acft until he began his flare. At that time he stated that a slight air disturbance…NTSB LAX83LA101Accident · No injuriesLimited investigationFinal reportGrumman G164 · Avenal, CADuring a landing after a spraying operation, the right brake failed and the aircraft collided with a berm before nosing over. The pilot said the right brake failed to keep aircraft on the runway when the rudder became ineffective. The 'o' ring part number an…NTSB FTW83LA111Accident · Serious injuriesLimited investigationFinal reportBellanca 14-19-3A · Plainview, TXThe flt reported that the battery was too low to start the engine. A 72 yr old ex-pilot offered to hand prop the plane, but after trying, he then offered to hold the brakes. With the ex-pilot at the controls & holding the brakes, the plt began to hand prop…NTSB FTW83LA109Accident · No injuriesLimited investigationFinal reportSwearingen SA-26T · Houston, TXThe plt reported that after the nosewheel touched down, it began a violent & uncontrollable oscillation, then locked aprx 25 deg to the left. The acft veered off the left side of the runway, crossed an area of soft ground and angled across a taxiway. After…NTSB DEN83LA057Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Burlington, COThe acft crashed during an attempted go-around. The pilot had landed downwind with an approach speed of 80 KTS and 25 degrees flaps. The pilot said he used rwy 13 instead of 31 because of a NOTAM prohibiting landing on rwy 31. There was no NOTAM to that…NTSB ATL83LA101Accident · No injuriesLimited investigationFinal reportBeech H18 · Talladega, ALThe plt stated that shortly after full power application & prior to tailwheel lift-off, the 'right wing raised aprx 3 to 4 ft into the air.' The acft then began drifting left. During ensuing maneuvers, the plt alternately advanced & retarded the throttle as…NTSB ANC83IA044Incident · No injuriesIncident investigationFinal reportCessna 207A · Kwigillingok, AKWhile on takeoff the right main landing gear broke through the crust of a snow drift. The aircraft then veered to the right into a snowbank.NTSB ANC83IA043Incident · No injuriesIncident investigationFinal reportCessna 207A · Kivalina, AKThe acft departed the left side of the runway on its takeoff roll due to misting or frosting of the windshield reducing visibility. The phenomenon is common to the area. The rwy is in poor condition with precautions to use the center only for takeoff &…NTSB MKC83LA071Accident · No injuriesLimited investigationFinal reportCessna 150L · S. Sioux City, NEThe aircraft drifted left during landing and collided with a snow bank. The instructor stated that the inexperienced student pilot flared the aircraft too high. The aircraft contacted the runway near the centerline but strayed left stillin a nose high…NTSB NYC83LA063Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Millbrook, NYPlt stated the left wheel froze causing a loss of directional control. The acft made a 90 deg turn to the right & slid backwards down an embankment into a pond.NTSB LAX83LVG08Accident · No injuriesFinal reportPiper PA-24 · Fair Oaks, CAThe pilot stated that he approached runway 18 at 70-80 mph and after touchdown he pulled the hand brake. The acft spun right 45 degrees and skidded off the runway. He said it felt like the right brake grabbed hard. The acft came to a stop about 25 feet from…NTSB CHI83LA101Accident · No injuriesLimited investigationFinal reportCessna 185 · Jackson, MIThe tailwheel acft veered during landing on rwy 5 & the left landing gear collapsed. The wind was 110 degrees 6 KTS. The pilot states he had a flat tire. The local controller who observed the landing reported seeing the acft swerve to the right. An FAA…NTSB ANC83IA041Incident · No injuriesIncident investigationFinal reportGates Learjet LR24DXR · St. Paul Island, AKWhile on landing roll out the acft slid to the left and contacted a snow berm causing the nose landing gear to fail aft. The reported winds were 90 degrees to the right of the runway & the runway was covered with ice.NTSB CHI83LA102Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Kentland, INThe acft veered off the right side of rwy 27 and collapsed the landing gear during landing. The wind was from 180 degrees at 15 KTS. The pilot did not report any mechanical problems with the tailwheel acft.NTSB NYC83LA059Accident · No injuriesLimited investigationFinal reportBeech G18S · Wilkes-Barre, PAThe plt lost directional control & collided with a drainage ditch causing the main gear to collapse.NTSB MIA83LA067Accident · No injuriesLimited investigationFinal reportPace THORP-T-18 · Tampa, FLThe acft drifted left during takeoff and collided with a VASI light. The pilot stated to a witness that he knew he was going left but thought he would be airborne before leaving the runway. The left rudder cable was frayed and broke sometime in the takeoff…NTSB NYC83LA058Accident · No injuriesLimited investigationFinal reportCessna 172P · Bridgeport, CTAfter practicing three takeoffs and landings, a fourth takeoff was aborted. The student completed a run-up, checked the controls and received clearance to takeoff. He stated that he began rolling straight down the centerline, then at about 45 KTS, the plane…NTSB DEN83LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COThe acft collided with a snowbank at the edge of the rwy during rollout on landing and nosed over. The student pilot stated that he had made one touch and go landing on rwy 16L. The tower changed traffic to 16R and gave winds as from 110DEGREES at 10 KTS. The…NTSB ANC83LA039Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe student plt stated that on the landing roll with a 7 kt right x-wind, the acft began drifting to the left. Reportedly, he tried to correct with right rudder, but the fire extinguisher had come loose & became jammed under the right rudder pedal.…NTSB MIA83LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Palmetto, FLAccording to the pilot he lost directional control of the aircraft during the landing roll. The aircraft veered to the left and went off the runway colliding with a drainage ditch and fence. No mechanical failure of malfunctions were reported.NTSB NYC83LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Danbury, CTThe student plt was taking off on rwy 08 with a wind from the northeast at 11 KTS. He reported that he was aprx 100 ft into the takeoff roll when the acft swerved to the left. Subsequently, the acft collided with a snowbank on the left edge of the rwy.NTSB CHI83FA092Accident · No injuriesField investigationFinal reportObryon Mustang II · West Chicago, ILThe home built acft was on its 1st flt after being constructed. The takeoff was initiated on rwy 33 with the wind from 030 deg at 10 KTS. The plt reported that during the takeoff, the right wing lifted, but the left wing would not come up. When control became…NTSB MKC83LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Ord, NEThe student pilot reported that on his third touch-and-go, he was momentarily distracted and looked down inside the aircraft. He inadvertentently pushed the left rudder and was unable to regain directional control before the left main wheel ran off the side…NTSB NYC83LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Meriden, CTAfter returning from an out-and-back x-country, the plt landed on a rwy with patches of ice. He stated that as the acft touched down, the left main wheel seemed to be frozen and skidded on a patch of ice. As the acft continued to skid, the left main wheel…NTSB MIA83FA063Accident · No injuriesField investigationFinal reportBeech E18-S · Naples, FLThe acft departed the right side of the runway and the right gear separated from the acft. Examination of the fracture surface revealed no evidence of fatigue or other type of slow growth cracking.NTSB LAX83LA078Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Yucca Valley, CAThe pilot was attempting a takeoff from Yucca Valley airport when he lost control of the aircraft and it swerved off therunway into a wash where it flipped over onto its back. The pilot said he encountered a dust devil which made the aircraft uncontrollable.…NTSB FTW83LA096Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-30 · Lubbock, TXThe plt stated that after a normal approach, touchdown & initial roll-out, the acft veer right & struck a 3 to 4 ft snowbank. An investigation revealed that snow had been falling for over 12 hrs & an 80 ft wide path had been plowed down the center of the…NTSB FTW83IA094Incident · No injuriesIncident investigationFinal reportBoeing B-737-200 · Lubbock, TXDuring taxi to takeoff the acft slid off the taxiway into the snow and became stuck. The taxiway was covered with snow &ice.NTSB LAX83LA075Accident · No injuriesLimited investigationFinal reportCessna 188 · Five Points, CAThe pilot lost control of his aircraft during takeoff in a cross wind. The aircraft ground looped collapsed the right main landing gear and nosed over. The agricultural operations were canceled at this provisional strip because of wind and the aircraft was…NTSB ATL83LA088Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Portsmouth, VAThe plt lost directional during the second solo landing & ran off the rwy.NTSB LAX83FVM07Accident · No injuriesFinal reportPitts S1S · San Jose, CAThe pilot made a rolling takeoff and apparently locked the tailwheel while turning. During later landing the aircraft became uncontrollable and ground-looped off the runway into mud where it flipped over. The tailwheel was locked out of detent and was unable…