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 ANC89LA105Accident · No injuriesLimited investigationFinal reportHelio H800 · King Salmon, AKThe pilot selected unsuitable terrain for the landing. Soft/wet (muddy) terrain conditions were contributing factors.NTSB ANC89LA097Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Sheshalik, AKPilot-in-command's failure to perform an adequate preflight inspection of the airplane's brakes.NTSB CHI89DEI01Accident · No injuriesFinal reportCox/Pitts Special S-1S · Alliance, OHFailure of the pilot to maintain proper runway alignment. The soft terrain was a related factor.NTSB MKC89LA129Accident · Minor injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Wynne, ARUnsuitable terrain selected by the pilot. A contributing factor was the rough/uneven landing area.NTSB LAX89LA206Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Big Sur, CAThe pilot elected to attempt a takeoff from a field that he had previously made a forced landing to and the airplane nosed over during the attempt. Contributing to the accident was the high grass that became entangled in the tailwheel and the soft downhill…NTSB ANC89LA077Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Green Island, AKFailure of the pilot to select a suitable landing area. Factors related to the accident were: rough water conditions, and the pilot's lack of experience in this make and model of aircraft.NTSB NYC89LA132Accident · No injuriesLimited investigationFinal reportCessna 150 · Woodstock, CTInadequate compensation for wind conditions by the pilot which resulted in not maintaining proper alignment with the runway. The crosswind and soft/wet terrain were contributing factors.NTSB LAX89DVG06Accident · No injuriesFinal reportGrumman G-164B · Davis, CAThe pilot failed to properly use his brakes during the off airport landing.NTSB ANC89LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKFailure of the pilot to go-around when he did not attain the proper touchdown point, which required excessive use of brakes to stop on the short landing area.NTSB ANC89LA066Accident · No injuriesLimited investigationFinal reportCessna 150A · Chisana, AKThe pilot's selection of unsuitable terrain for the landing. The soft/uneven terrain is considred to be a contributing factor.NTSB ATL89LA129Accident · No injuriesLimited investigationFinal reportCessna 152 · Gratis, OHThe foreign material (bird nest) in the engine compartment, and failure of the dual student or instructor pilot (CFI) to identify and remove it during their preflight inspection of the aircraft. Soft terrain in the emergency landing area and smoke from the…NTSB LAX89LA148Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lancaster, CAImproper planning/decision by the pilot. Strong/gusty winds contributed to the accident.NTSB ATL89LA107Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Swainsboro, GAThe pilot's decision to land at an unlighted airstrip in low light conditions, and her subsequent, inadvertent selectionof unsuitable terrain bordering the runway.NTSB MKC89LA070Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Griffithville, ARThe failure of the pilot to assure suitable terrain was being used for the landing.NTSB SEA89LA046Accident · No injuriesLimited investigationFinal reportCessna 180J · Elk City, IDThe pilot's failure to maintain a proper runway alignment on touchdown. Contributing to the accident were the soft snow conditions on the ranch airstrip.NTSB LAX89DVG03Accident · Minor injuriesFinal reportEaa WAG-AERO Sport · Placerville, CAThe student's improper application of brakes during the touchdown/flare phase of the landing causing the aircraft to nose over.NTSB SEA89LA032Accident · No injuriesLimited investigationFinal reportCessna 185F · Juneau, AKThe misjudgement of the runway conditions on the part of the pilot prior to landing. Contributing to the accident were deep snow on the runway, box canyon configuration of the area precluding runway overflight, marginal weather/light conditions for assessing…NTSB ANC89LA017Accident · No injuriesLimited investigationFinal reportCessna A185F · Kasitsna Bay, AKThe plt was landing on a beach to deliver mail. He rprtd that during touchdown, the acft skipped about 50 ft before settling to the ground, then it remained in contact with the ground & rolled straight ahead. During the landing roll, the acft nosed over. The…NTSB MKC89LA023Accident · No injuriesLimited investigationFinal reportStearman B75N1 · Benton, ARThe flt was uneventful until the landing at the saline county arpt, Benton, ark. The PIC stated he applied too much brake and applied it prematurely during the landing roll and the acft nosed over to the inverted posn. The resultant impact crushed the…NTSB ANC88LA103Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Delta Junction, AKThe private pilot reported that he was attempting to land at an unimproved, off-airport landing site near Delta Junction, AK. The landing area that he selected was muddier than he had anticipated, and the airplane decelerated too rapidly and nosed over,…NTSB MIA88LA243Accident · No injuriesLimited investigationFinal reportCessna 180J · Pahokee, FLThe plt stated that he was attempting a wheel landing. On rollout he 'hit' the brakes. The acft nosed over and came to rest inverted.NTSB ANC88LA151Accident · 1 fatalLimited investigationFinal reportCessna U206F · Lake Minchumina, AKThe plt said he was taxiing the floatplane from a windy/wavy location to a small protected cove for a final preflt. While taxiing, the top cap of the left float was open & the float began filling with water. Subsequently, the float- plane rolled over & sank.NTSB DEN88LA130Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · West Jordon, UTNTSB ATL88LA148Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lowell, OHThe plt rptd that he landed in a 12-14 kt, 90 degree x-wind. The initial portion of the ldg rollout was shielded from the wind by a row of trees bordering part of the upwind side of the rwy. Upon reaching a clearing in the trees, the airplane was exposed to…NTSB CHI88LA085Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Indianapolis, INFifteen minutes after the pilot had taken off on a tow plane operation he returned to the local arpt. After landing he turned downwind to taxi to the ramp. The wind raised the tail of the tailwheel acft and nosed the acft inverted. The pilot estimated the…NTSB CHI88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Mendota, ILDuring the landing roll, in gusty, crosswind conditions the upwind wing of the aircraft lifted and the aircraft experienced a noseover.NTSB SEA88LA063Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cashmere, WAThe acft touched down near midfield while landing on an 1800 ft long downsloping runway. When the pilot rapidly applied throttle for go-around, the engine faltered. He applied hard braking to stop on the runway and the aircraft nosed over.NTSB SEA88LA056Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Las Vegas, NVThe student pilot departed the airport for a cross country flight without filing a flight plan or obtaining a weather briefing. Upon returning to the originating airport he discovered that the winds were unfavorable for landing at that airport. The pilot then…NTSB ANC88LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Big Lake, AKThe newly certificated private pilot was attempting to perform a soft-field, touch-and-go landing at an unimproved, off-airport site in deep snow. The airplane's main landing gear became mired in the snow, the nose wheel pitched down and the airplane…NTSB MIA88LA120Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Hialeah, FLWhile attempting to land in a field the pilot misjudged the height of the grass. The front part of the skids became entangled in the 2 foot height grass and the aircraft nosed over. Instruction was not taking place, however, the second pilot had 75 hours in…NTSB NYC88LA103Accident · No injuriesLimited investigationFinal reportCessna 140 · Schroon Lake, NYDuring landing roll on a frozen lake, the left landing gear dug into a soft spot. The aircraft nosed over and was substantially damaged. In his recommendation for prevention of this acc, the plt said 'by not lndg on ice.'NTSB NYC88LA102Accident · No injuriesLimited investigationFinal reportCessna 172 · Newport, VTDuring landing roll out on a frozen lake. The nose wheel contacted a soft spot in the ice and flipped over.NTSB DEN88LA070Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Circle, MTPlt and passenger were hunting coyotes from the air. Upon landing to pick up a coyote they had shot, the acft encountered deep snow and nosed over.NTSB ANC88LA029Accident · No injuriesLimited investigationFinal reportCessna 180 · 70 Nw Anchorage, AKThe pilot stated that during the landing roll on the frozen lake he lost directional control of the aircraft due to the snow on the lake. The aircraft then nosed over on its back.NTSB DEN88LA066Accident · No injuriesLimited investigationFinal reportPiper J3C · Cody, WYDuring an attempted landing at a private airstrip which was covered by 5-6 inches of dry powdered snow, the acft touched down. It pitched forward and nosed over. After the acft came to rest, the pilot got out of the acft, examined the landing gear, and…NTSB MIA88LA102Accident · Minor injuriesLimited investigationFinal reportHess QUICKIE-2 · Orlando, FLThe plt stated that on the landing rollout, the acft began to veer left. While he was attempting correction to the right, the acft hit a bump off the runway, flipped over & came to rest inverted.NTSB MIA88LA091Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Port Saint Joe, FLWhile on a business flt, unable to locate the landing site with darkness approaching & low supply of fuel, the plt performed a precautionary landing on a soft dirt road. During the landing roll the acft nosed over & came to rest. The plt did not file an acc…NTSB CHI88LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILThe plt returned to the arpt after dark & noted there was an excessive x-wind for the active rwy. He elected to land on the unlighted grass rwy (rwy 14) which was aligned more favorably with the wind. He thought that on final apch, he had aligned the acft…NTSB ATL88LA051Accident · No injuriesLimited investigationFinal reportCessna 172F · Eden, NCThe student plt attempted to land in a farm pasture adjacent to his brother's farm. The airplane ldg gear 'dug in' on ldg, and the airplane nosed over. The student plt described the terrain as 'wet & soggy'. The student did not have an instructor's…NTSB NYC88LA009Accident · No injuriesLimited investigationFinal reportCessna 140 · New Milford, CTThe flight en route was uneventful; however, during the landing at New Milford, CT, the aircraft's propeller struck the surface of the runway & the plane nosed over. The plt stated that he applied the brakes too harshly.NTSB ATL88LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, NCThe student plt became lost on the return leg of his 1st solo cross-country flt. He elected to make a precautionary ldg in a plowed field after observing the acft fuel gauges indicating near empty. The acft nosewheel sank into soft dirt during rollout and the…NTSB SEA88LA004Accident · No injuriesLimited investigationFinal reportCessna 180C · Juneau, AKWhile landing onto a soft, sandy beach area the aircraft nosed over inverted. The plt failed to file an accident report.NTSB NYC87LA269Accident · No injuriesLimited investigationFinal reportRyan ST-3RR · Hamburg, NYAccording to the plt, when he arrived at the arpt, the winds were from 280 deg at 20 gusting 25 KTS. He believed that with the strong x-wind & gusts, it would be safer to land on sod beside the rwy. During the landing, the main gear sank into the sod & the…NTSB ANC87LA156Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Valdez, AKThe pilot stated that he was landing at an unimproved, off airport site when the main gear hit a hole during the landing roll and the aircraft nosed over.NTSB DEN87LA227Accident · No injuriesLimited investigationFinal reportCessna 182Q · Albuquerque, NMThe instructor took control of the acft to make the landing due to excessive crosswind. The ip stated that the apch speed was 70 to 75 KTS. The acft was landed on the first third of runway and brakes applied with half runway remaining. Ip reported that brake…NTSB DEN87LA205Accident · No injuriesLimited investigationFinal reportCessna 172C · Cut Bank, MTThe plt stated that she radioed the Cut Bank fss and was told that the wind was 060 degrees at 41 knots. She then landed the acft uneventfully. However, while turning 90 degrees off the rwy onto a taxiway, the acft nosed over.NTSB FTW87DPA04Accident · No injuriesFinal reportRoe/Pietenpol Aircamper · Arlington, TXAs the plt was landing, he applied excessively hard braking & the acft nosed over. No pre-acdnt part failure or malfunction was evident.NTSB DEN87LA184Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Devils Lake, NDThe pvt plt, an A&P mechanic, was commuting home from the local airport in his aircraft. Upon landing, the main gear sank into soft soil and the acft nosed over.NTSB SEA87LA126Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Dallas, ORThe pilot inadvertently landed with a quartering gusting tailwind. On landing rollout the aircraft nosed over inverted.NTSB CHI87LA134Accident · No injuriesLimited investigationFinal reportCessna U206C · Grand Rapids, MNThe plt rprtd that drg a water lndg, the left float dug in & caused the left wing to strike the water. Subsequently, the acft nosed over. The plt did not rprt any abnormal wind or water condition.