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 LAX82FVD09Accident · No injuriesFinal reportBellanca 7ECA · Sonoma, CAControl was lost during takeoff when, according to the pilot's statement, a sudden extreme wind gust caused the aircraftto change its heading. The aircraft contacted water at the side of the runway and came to rest nose down. Winds were reportedly gusting to…NTSB FTW82DA051Accident · No injuriesFinal reportCessna 152 · Mckinney, TXDuring local solo flight the aircraft veered off the left side of the runway resulting in substantial damage to the Cessna. The winds were gusting from 8 to 13 knots 35 degrees to the left of the runway heading.NTSB DEN82DA027Accident · No injuriesFinal reportPiper PA-22 · Trinidad, COThe pilot reported that the aircraft started to veer left as the tail came up during the takeoff roll. He corrected with rudder, but did not maintain directional control. As a ground loop developed, he noted there was insufficient airspeed to lift off and…NTSB LAX82DA056Accident · No injuriesFinal reportCessna 172 · Big Bear, CAThe pilot stated that during landing she flared the airplane and touched down hard. On the third bounce she added power for a go-around. The plane drifted to the left, collided with a snowbank and flipped over.NTSB DEN82DA026Accident · No injuriesFinal reportCessna 172 · Bryce Canyon, UTAfter arriving from a cross-country flight, the pilot landed on an icy runway with calm wind conditions. During ground roll, the aircraft began sliding to the left. The left wheel hit snow and pulled the aircraft further left. The pilot applied right rudder…NTSB SEA82DA021Accident · No injuriesFinal reportCessna 340A · Sunriver, ORThe instructor was providing dual instruction to a private pilot with no previous time in this nor any multi- engine aircraft. Also, the pirvate pilot had not flown within the previous 90 days. He initiated a takeoff on runway 18 with the wind from 210…NTSB LAX82DA053Accident · No injuriesFinal reportCessna 152 · Lodi, CAThe pilot stated that during the landing roll he felt a vibration in the nose gear. Subsequently the aircraft veered offthe runway into soft ground and collapsed the nose gear.NTSB FTW82DA048Accident · No injuriesFinal reportCessna A185F · S. Of Morgan Ci, LAThe pilot was making a westbound takeoff from a canal with a 15 knot south crosswind when his boot and pant leg became entangled in the aircraft's water rudder lever. This caused the pilot to lose control and the aircraft drifted to the right into a moored…NTSB CHI82DA031Accident · No injuriesFinal reportAeronca 7BCM · Hoffman, MNWhile landing on a snow covered driveway in an Aeronca equipped with skis the left wing raised up and the right wingtip caught the ground. The pilot stated the wind was gusting to 18 knots.NTSB NYC82DA020Accident · No injuriesFinal reportPiper PA-28-140 · Sussex, NJAfter returning from a local flight, the pilot landed on runway 03 with the wind from 310 degrees at 15 gusting 20 knots. The runway had been plowed, but it was about 60 percent covered with patches of snow. The pilot reported that during the landing roll, a…NTSB LAX82DA052Accident · No injuriesFinal reportCessna 172 · Flagstaff, AZThe pilot made a night landing without landing lights. The runway was narrowed by snow banks inside the runway lights. The aircraft skidded on the icy runway and rode up onto the right snowbank, dragging the left wing. When the aircraft yawed to the right the…NTSB FTW82FPD08Accident · Serious injuriesFinal reportCessna 150H · Saginaw, TXDuring the takeoff roll, the pilot heard a noise that was followed by a vibration at lift-off. Reportedly, the flight controls did not respond properly while the aircraft was in flight. The pilot returned for landing and held the nose gear off as long as…NTSB MKC82DA020Accident · No injuriesFinal reportPiper PA-32-300 · Topeka, KSThe pilot was practicing crosswind landings on runway 35. The wind was from 290 degrees at 15 gusting 23 knots. During a landing flare, a gust of wind was encountered. The plane skidded and departed the runway. The nose gear struck an ice bank and collapsed.NTSB CHI82DA029Accident · No injuriesFinal reportMooney M-20 · Shell Lake, WIThe pilot initiated his takeoff roll on a runway covered with hard packed snow. As the nosewheel was lifted off of the runway, the aircraft started to drift left. The pilot stated that when he applied right rudder and slightly lowered the nose, the plane came…NTSB FTW82DA044Accident · No injuriesFinal reportCessna 152 · Midland, TXDuring the student's first supervised solo flight he landed normally but lost control prior to adding power for a touch and go landing. The aircraft ran off the runway and collided with a pile of gravel coming to rest inverted.NTSB DEN82DA021Accident · No injuriesFinal reportHughes 269C · Bondurant, WYThe pilot stated that he became disoriented in a white out condition due to blowing snow during a landing attempt. He then lowered the collective to stop the blowing snow and the left side of the helicopter broke through the crust of a four foot thick snow…NTSB CHI82DA028Accident · No injuriesFinal reportPiper PA-38-112 · Grand Rapids, MIThe pilot-in-command was a student on a check flight for a private license. The check pilot was an FAA inspector. The flight was conducted from an airport with runways that were partially covered with snow and ice. The mishap occurred while the pilot was…NTSB ANC82DA019Accident · No injuriesFinal reportPiper PA-32 · Tuntutuliak, AKDuring takeoff on a runway covered with 7 to 8 inches of snow,the aircraft pulled to the right. The pilot reduced engine power,but was unable to maintain directional control. The aircraft veered off the side of the runway. Pilot reported snow removal…NTSB FTW82DA045Accident · No injuriesFinal reportCessna 180K · S.E. Of Houma, LAThe pilot elected to takeoff from a canal with a quartering tailwind due to approaching fog. The aircraft drifted left and its wing struck a piling.NTSB CHI82DA027Accident · No injuriesFinal reportBeech C-45H · Anoka, MNThe pilot elected to land on runway 35 with a left quartering headwind at 20 knots. He stated that the approach and landing seemed normal with no undue crab or crosswind correction. After landing, the plane made a quick turn to the left. The pilot reported…NTSB FTW82DA040Accident · No injuriesFinal reportBeech A23-24 · Hobbs, NMThe pilot attempted to takeoff on a runway with icy patches, lost control and slid off the side into a snowbank. The pilot did not possess any type of pilots certificate due to the fact that he could not pass a medical examination.NTSB DEN82FTE16Accident · No injuriesFinal reportCessna 180 · Saquache, CODuring a round-robin VFR flight the pilot landed at cochetopa strip and shut down for 1 hour. The pilot stated that at the time of takeoff the wind velocity had increased to 20-25 knots with almost a direct crosswind. During takeoff the aircraft drifted left…NTSB LAX82FJA03Accident · No injuriesFinal reportCessna 305 (L-19) · Mokuleia, HIDuring the landing roll, the aircraft began to veer left and would not respond to right rudder or brake application. The plane continued off the left side of the runway, and the right wing was damaged. An investigation revealed that the right brake had…NTSB LAX82DA041Accident · No injuriesFinal reportCessna 172N · Bullhead City, AZWhile the pilot was landing with a tailwind, the aircraft went off the left side of the runway and traveled over a raised area beside the runway. The pilot reported that the nosewheel caught on the hillside as a gust of wind was encountered and the airplane…NTSB SEA82DA016Accident · No injuriesFinal reportCessna TU206G · Pullman, WAThe aircraft had a rudder/directional control problem that had been occurring intermittently. When it occurred during the previous flight, the pilot had to use full right rudder to keep the ball centered. Before landing on that flight, he made a low pass near…NTSB CHI82DA023Accident · No injuriesFinal reportCessna 152 · Peoria, ILReportedly, the student tookoff without his instructor's appproval. He initiated a takeoff roll on runway 35 with the wind from 230 degrees at 11 knots. He stated that the wind shifted and caught him from behind as he was about to lift off. Directional…NTSB CHI82DA022Accident · No injuriesFinal reportCessna 172N · Sandusky, OHThe wind was from the south-southwest at 15, gusting 20 knots. The fixed base operator had advised all pilots to use runway 18. After arriving, the pilot of N737LH saw another aircraft using runway 27 and elected to land on that runway. He noted a left…NTSB NYC82DA018Accident · No injuriesFinal reportMaule M-5-235C · White Plains, NYAfter returning from a short local flight, the pilot landed in light and variable wind conditions. During landing, the aircraft bounced and ground looped. The left main gear failed and the left wing and propeller were damaged.NTSB CHI82FEC08Accident · No injuriesFinal reportCessna 152 · Ypsilanti, MIDuring takeoff from a hard packed snow and icy runway the aircraft veered left into a snowbank off the side of the runway. The student pilot stated that prior to the takeoff roll he had full deflection of the left aileron and was anticipating with right…