OpenAirDocs.org

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.

NTSB MKC82DA051Accident · No injuriesFinal reportCessna 172L · Des Moines, IAThe pilot landed on runway 23 with the wind from 230 degrees at 34 gusting 40 knots. After turning off to the right side of the runway, a gust of wind tipped the aircraft, turned it further to the right, and then blew it over on its back.Mar 30, 1982 · N4325Q · Substantial damageNTSB CHI82DA107Accident · No injuriesFinal reportCessna 172K · Fairmont, MNThe pilot encountered adverse weather and elected to land at Fairmont,Minnesota. While taxiing after landing, the aircraft flipped over in strong wind conditions.Mar 30, 1982 · N84344 · Substantial damageNTSB NYC82DA025Accident · No injuriesFinal reportCessna 172M · Haverhill, MAThe pilot landed on a wet and muddy strip beside a hard topped runway. After traveling about 100 ft down the strip, the wheels began to sink. As the plane almost came toa stop, the nose wheel sank into the mud and the plane slowly nosed over.Mar 21, 1982 · N3644T · Substantial damageNTSB MIA82DA090Accident · No injuriesFinal reportMckinley Eaa P-2 Biplane · Brooksville, FLWhile en route, the pilot elected to land at an uncontrolled airport. During the landing roll, he observed a glider landing in the opposite direction. He departed the runway to the right to avoid a collision and nosed over when he applied brakes.Mar 20, 1982 · N26JM · Substantial damageNTSB ATL82DA077Accident · No injuriesFinal reportCessna 152 · Allendale, SCDuring a solo three hundred mile cross country flight the student pilot stated that he strayed to the south of his intended course. He subsequently became disoriented and after circling an area for about 30 minutes began to panic and elected to land. The…Mar 20, 1982 · N757VV · Substantial damageNTSB CHI82DA085Accident · No injuriesFinal reportPiper PA-22-150 · Rockford, ILThe pilot had taxied to runway 24. While making a turn to runup, the wind picked up the right wing and tail, and flipped the plane over on its back.Mar 13, 1982 · N2470P · DestroyedNTSB ANC82DA023Accident · No injuriesFinal reportPiper PA-18 · Near Gulkana, AKThe pilot stated that he arrived at crosswinds lake, made a low pass and attempted to contact the wheels on the snow to determine if a landing was possible. The wheels broke through the crust on the snow and the aircraft flipped over.Mar 2, 1982 · N8293C · Substantial damageNTSB MIA82DA052Accident · No injuriesFinal reportGreat Lakes 2T1A-2 · Pembroke Pines, FLWitnesses observed the pilot taxiing downwind at a speed above normal when the aircraft's tail was seen to raise and the aircraft turned over.Feb 18, 1982 · N3667L · Substantial damageNTSB DEN82DA036Accident · Minor injuriesFinal reportPiper PA-18 · Plentywood, MTOn 2/16/82, the county sheriff received information that the pilot had wrecked his aircraft on 2/13/82. He went to the scene and observed the aircraft in an inverted position on snow covered terrain. On 2/20/82, he received information that the pilot had…Feb 14, 1982 · N4380Z · Substantial damageNTSB LAX82DA068Accident · No injuriesFinal reportPiper PA-38-112 · Hickman, CAThe plt had landed at turlock muni arpt from a solo x-country flt from oakland. After encountering difficulty in starting the engine, the plt departed turlock for oakdale. About 3-5 min later the engine sounded "badly" & the plt madea precautionary landing at…Feb 10, 1982 · N2562K · DestroyedNTSB CHI82DA038Accident · No injuriesFinal reportCessna 172 · Greencastle, INThe student arrived at the airport on a cross-country flight and requested landing advisories on the UNICOM frequency. The student stated that somebody replied that runway 18 was in use. Before landing, the pilot overflew the airport 4 times. Two of these…Feb 7, 1982 · N7804U · Substantial damageNTSB LAX82DA058Accident · No injuriesFinal reportCessna 180K · El Cajon, CAThe pilot reported that while he and a passenger were on a local flight, he elected to look at a local grass strip near el capitan lake. He made several low passes and then touched down momentarily on a touch and go landing. After that, he felt the surface…Feb 1, 1982 · N2596K · Substantial damageNTSB MIA82DKJ03Accident · No injuriesFinal reportCessna 172 · Malone, FLThe pilot elected to land on a runway with 800 feet of hard sod and 2700 feet of soft dirt. The aircraft nosed over when the nose wheel dug into the dirt.Jan 15, 1982 · N5559T · Substantial damageNTSB LAX82DA037Accident · No injuriesFinal reportCessna TR182 · Springerville, AZWhile taxiing to the ramp after landing the wind caught the right wing and turned the aircraft over on its back. The pilot reported that the wind was gusting up to 70 knots.Jan 5, 1982 · N738XP · Substantial damageNTSB NYC82DA016Accident · No injuriesFinal reportCessna 172 · Galeton, PAAfter takeoff from the original departure point, the pilot flew to a local airport and landed on runway 28. The runway was covered with snow and the winds were from 270 degrees at 10 knots. After landing, the pilot taxied back for takeoff. While in a right…Jan 2, 1982 · N25084 · Substantial damage