NTSB investigations, MT
19 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 1 |
| 2000 | 2 |
| 2004 | 1 |
| 2006 | 1 |
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\" = 'MT' 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" = 'MT' 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 SEA06CA178Accident · Minor injuriesData collectionFinal reportCessna 150 · Laurel, MTThe pilot's excessive application of the brakes during an aborted takeoff, which resulted in a nose over.NTSB SEA04CA151Accident · No injuriesData collectionFinal reportPiper PA22-20 · Wht Sulphur Spg, MTThe failure of the private pilot receiving flight training for a tail wheel endorsement to maintain aircraft control, and his excessive braking during the landing roll, subsequently nosing over the airplane. A contributing factor was the flight instructor's…NTSB SEA01LA018Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Great Falls, MTThe pilot's improper decision to land on unsuitable terrain. Factors include snow covered terrain.NTSB SEA00LA047Accident · No injuriesLimited investigationFinal reportCessna 180H · Bozeman, MTAircraft control was not maintained. Inadequate remedial action was a factor.NTSB SEA97LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Deer Lodge, MTThe pilot's improper decision to abort the takeoff, and his improper use of brakes during the abort. A factor contributing to the accident was the pilot's failure to maintain directional control during the takeoff roll.NTSB SEA97LA019Accident · No injuriesLimited investigationFinal reportCessna 170B · Utica, MTThe pilot's improper use of the brakes, while landing a tailwheel aircraft in crosswind conditions. The crosswind was a related factor.NTSB SEA96LA086Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTthe pilot's excessive use of brakes during the landing rollout.NTSB SEA96LA018Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Seeley Lake, MTThe pilot's selection of unsuitable terrain for landing. The snow covered runway was a factor.NTSB SEA92LA171Accident · No injuriesLimited investigationFinal reportBoeing B-75 · Three Forks, MTThe pilot's failure to maintain directional control. Factors include a crosswind gust.NTSB DEN90LA018Accident · No injuriesLimited investigationFinal reportCessna U206B · Billings, MTImproper planning/decision by the pilot while taxiing during unfavorable wind conditions.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 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 DEN87LA086Accident · No injuriesLimited investigationFinal reportBoeing A75L3 · Belgrade, MTThe plt report that he was landing on a 9000 x 150 ft asphalt rwy. The wind was nearly down the rwy at 4 to 9 KTS. In a telephone interview 2 days after the accident the plt reported that he was making a 'wheels' landing. He said when the main gear was about…NTSB DEN86LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wisdom, MTThe student plt departed minden, NV on an unauthorized x-co flt that terminated in the accident at Wisdom, MT. During the landing roll at an abandoned arpt at Wisdom, the nose of the acft dug into the snow covered runway and the acft nosed over. The plt…NTSB DEN85LA054Accident · No injuriesLimited investigationFinal reportCessna 180 · Marion, MTThe acft nosed over onto its back after the plt landed in snow 6 to 8 inches in depth.NTSB DEN83LA050Accident · No injuriesLimited investigationFinal reportCessna 180K · Billings, MTThe tailwheel (conventional gear) aircraft was equipped with a robertson stol modification. The pilot reported that with this modification, the plane's stall speed was lowered to 28 to 30 KTS. While in the traffic pattern, tower asked him to keep his speed up…NTSB DEN82DA123Accident · No injuriesFinal reportLuscombe 8A · Laurel, MTDuring the landing roll, the pilot applied heavy braking and the aircraft nosed over, this occurred after he had landed longer than normal and was slowing to gain access to a taxiway. The temperature was 85 degrees fahrenheit and the asphalt runway was hot,…NTSB DEN82DA069Accident · No injuriesFinal reportPiper PA-18-150 · Hardin, MTThe pilot and his copilot were on a flight to a private ranch strip. The pilot reported that his approach was normal, except it was hot and ground effect carried the plane a little too FAR. He stated that the field was soft, and when he applied brakes…NTSB 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…