NTSB investigations, WA
32 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 3 |
| 2002 | 3 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA' AND 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 SEA02LA178Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Anacortes, WANormal braking application was excessive during the landing roll resulting in the aircraft nosing over.NTSB SEA02LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · NAS Whidbey, WAThe pilot's improper decision to taxi behind a standing large military turbo-prop aircraft, which he knew may be performing periodic engine test runs, without first initiating communications to insure that the engine power on the standing aircraft would…NTSB SEA02LA033Accident · No injuriesLimited investigationFinal reportBeech B-19 · Moses Lake, WAThe instructor's inadequate supervision of the student pilot. Also, the dual student's incorrect use of the fuel selector valve. A factor was the uneven terrain.NTSB SEA01LA162Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Shelton, WAThe binding/grabbing of the right main gear braking system during the landing roll.NTSB SEA01LA103Accident · No injuriesLimited investigationFinal reportPiper J3F-65 · Brush Prairie, WAThe first pilot's failure to maintain aircraft control during a high-speed taxi maneuver. Tall grass adjacent to the runway was a factor.NTSB SEA01LA081Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAThe high wind conditions encountered as the aircraft began its takeoff roll. Contributing factors were the variable and gusty wind conditions.NTSB SEA01LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Spangle, WAThe pilot's inadequately executed remedial action and his failure to ensure that the aircraft touched down at the proper location. Factors include a dark night, an unlighted runway, and trees off the approach end of the runway.NTSB SEA99LA163Accident · No injuriesLimited investigationFinal reportStinson V77 · Tacoma, WAThe pilot-in-command's inadvertent use of heavier than normal braking during the landing roll. A contributing factor was the gusty wind conditions.NTSB SEA98LA165Accident · No injuriesLimited investigationFinal reportAeronca 7BCM · Vancouver, WAThe pilots inadequate remedial action, while attempting to recover from an inadvertent activation of the brakes, during the landing-roll. Factors include the inadvertent brake activation and the rough/uneven runway.NTSB SEA98LA168Accident · No injuriesLimited investigationFinal reportCessna 140 · Battleground, WANose Over for undetermined reasons.NTSB SEA98LA034Accident · No injuriesLimited investigationFinal reportCessna U-206E · Friday Harbor, WAthe pilot's failure to park with the aircraft headed into the wind in high wind conditions. A factor include the high wind condition.NTSB SEA97LA134Accident · No injuriesLimited investigationFinal reportCessna 172C · Fall City, WAthe pilot's selection of unsuitable terrain for landing. The soft, wet terrain was a related factor.NTSB SEA97LA080Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, WAthe pilots' inadequate evaluation of the strong winds, when they attempted to turn to taxi with a very strong tailwind. Factors relating to the accident included the high and unfavorable winds.NTSB SEA97LA053Accident · No injuriesLimited investigationFinal reportCessna 170B · Toledo, WAThe pilot's excessive application of the brakes on a tailwheel equipped aircraft. Factors include the pilot's inadequate compensation for wind conditions, and a crosswind blowing at the time of the landing.NTSB SEA96LA109Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Richland, WAthe pilot's failure to perform a go-around and his subsequent excessive use of the aircraft brakes. The short airstrip length and the pilot's excessive airspeed for the approach were related factors.NTSB SEA96LA108Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Rimrock, WAthe pilot's delay in aborting the takeoff, and his excessive use of brakes while decelerating the airplane during the aborted takeoff. Factors relating to the accident were: the pilot's loading the airplane above its maximum gross weight, high density…NTSB SEA95LA073Accident · No injuriesLimited investigationFinal reportFleet 7 · Arlington, WAThe pilot-in-command's improper use of the brakes. A factor was the failure to maintain directional control during landing rollout.NTSB SEA92LA190Accident · Serious injuriesLimited investigationFinal reportWSK PZL Mielec M-18A Dromader · Mattawa, WAThe inadvertent locking of the acft brakes while landing by the PIC, resulting in an acft nose over on the gravel strip.NTSB SEA92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Ocean Shores, WAThe pilot's misjudgement of wind information. A factor contributing to the accident was high wind conditions.NTSB SEA91LA244Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Metaline Falls, WAThe pilot's inadvertent use of the parking brake. A factor contributing to the accident was the absence of the parking brake on the landing checklist.NTSB SEA90LA173Accident · No injuriesLimited investigationFinal reportCessna 172P · Granite Falls, WAThe pilot in command's use of excessive flaps for takeoff resulting in loss of climb performance.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 SEA86LA048Accident · No injuriesLimited investigationFinal reportCessna 206 · Wenatchee, WAThe pilot diverted from his intended destination of pangborn field to a local private airstrip due to local fog. 8' of crusted snow was present on the runway and the aircraft nosed over on landing roll.NTSB SEA85LA087Accident · No injuriesLimited investigationFinal reportCessna 182 · Walla Walla, WADuring taxi from landing a gust of wind pushed the acft from behind onto soft ground where it nosed over.NTSB SEA85LA047Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Wenatchee, WAThe plt elected to make a precautionary landing onto a snow covered grain field. He stated his artifical horizon was inoperative & darkness was approaching. Also, he said he saw a needle flicker & he was not sure if it was a fuel gage or his oil pressure…NTSB SEA84LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR B9-4000 · Vancouver, WAThe pilot stated after the accident that he applied too much brake during the landing roll. The aircraft nosed over.NTSB SEA84LA092Accident · No injuriesLimited investigationFinal reportCessna 180H · Seattle, WAThe acft nosed over during the landing roll. The plt reported he used excessive braking.NTSB SEA84LA084Accident · No injuriesLimited investigationFinal reportCessna C-172M · West Sound, WAThe acft nosed over during landing after the occupants had misidentified the landing area in a farmers field. During roll-out in the soft soil the landing gear bogged down and the acft flipped over.NTSB SEA83LA206Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Selah, WAWhile landing on a road, during an aerial application operation, the acft nosed over. According to the plt, the brakes had not released after he had released the toe brakes. He reported that he found the parking brake midway between the on & off positions.NTSB SEA83LA108Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Touchet, WAThe acft nosed over during landing and came to rest inverted in an off airport landing. The pilot was surveying some land to be sprayed to estimate the cost. He landed on the field which was very soft and the acft nosed over. The pilot was not injured.NTSB SEA82DA067Accident · No injuriesFinal reportCessna A185F · N.W. Of Copalis, WADuring the landing roll the pilot applied brakes and the tailwheel equipped aircraft nosed over. The runway surface is characterized as hard/damp sand due to its proximity to the ocean and is periodically submerged during high tide conditions.NTSB SEA82DA059Accident · Minor injuriesFinal reportWeatherly 201A · Hartline, WAWhile landing on a roadway, the right main landing gear encountered soft, loose dirt. The pilot applied left braking action to maintain directional control, and the aircraft nosed over.