NTSB investigations, MT
7 cases where the first occurrence was “Abrupt maneuver”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
Where
Latest 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\" = 100)
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" = 100) 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 DEN88LA147Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Fort Peck, MTThe pilot made a takeoff from a muddy, dirt, road. He said that after he become airborne he put his aircraft into a sharp turn in order to avoid some power lines. Although he was successful in avoiding the power lines, he inadvertently stalled the aircraft…NTSB DEN87LA075Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Columbus, MTA pre-solo student and CFI were practicing landings. The CFI reduced pwr on climbout at 300 to 400 feet. During the discussion of what to do in case of lost pwr on takeoff, the student executed a steep, 180 degree turn, toward the arpt. The acft stalled, and…NTSB DEN87FA042Accident · Serious injuriesField investigationFinal reportAero Commander 690A · Miles City, MTThe plt of the nonscheduled domestic pax air taxi flt was flying the vor/dme rwy 22 apch to wiley field, Miles City, MT. The plt said he turned on the autopilot and after turning inbound from the procedure turn towards the faf he engaged the apch mode. After…NTSB DEN87LA013Accident · No injuriesLimited investigationFinal reportPitts S-1D · Shelby, MTThe plt took off with little or no warmup, pushed the acft to max performance at 10 ft, performed a max performance climb to 300 to 400 ft and reduced throttle to idle. As the acft reached stall speed, the plt dived at a 45 degree angle and impacted the…NTSB DEN86LA178Accident · No injuriesLimited investigationFinal reportCessna 182F · Joliet, MTAccording to the plt, horses ran in front of him during landing and he was forced to make evasive maneuvers. During the evasive maneuvers, the acft ground looped and was substantially damaged.NTSB DEN85FA179Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Columbus, MTAfter making a low pass over his pax home, the plt pulled the acft up abruptly and stalled at a very low altitude. The alt was too low for the plt to effect a successful recovery before ground impact.NTSB DEN83LA096Accident · No injuriesLimited investigationFinal reportCessna 182P · Ashland, MTThe acft lifted off early, stalled, dropped a wing and cartwheeled to a stop. The left main gear was sheared off in the impact. The pilot stated that during the takeoff from his own ranch airstrip a horse ran out on the rwy in front of the acft. He said there…