NTSB investigations, MT
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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.\"eventStateOrRegion\" = 'MT' AND c.\"eventCountry\" = 'USA' 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' 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 DEN82DTI14Accident · No injuriesFinal reportStarke KR-2 · Wolf Creek, MTWhile flying at a low altitude over the Missouri river the aircraft collided with a powerline damaging the propeller and cowling. The pilot used ground transportation to pickup a new propeller. He repaired the aircraft, surveyed the takeoff area and attempted…NTSB DEN82DTI13Accident · No injuriesFinal reportAir Tractor AT-301 · Ruyard, MTThe aircraft was refueled prior to takeoff. The pilot reported that the takeoff was normal until about 75 ft off the runway when the engine quit. During a forced landing, the plane touched down in a 3-point attitude, bounced, and then hit the ground in a nose…NTSB DEN82FTA10Accident · Serious injuriesFinal reportPiper PA-25-235 · Glendive, MTThe pilot reported that he had just loaded the sprayer and had made one pass downhill. At the end of the field, he started a left turn to make an uphill pass. The pilot stated that he got into bad air or down slope air and started to dump the chemical but it…NTSB DEN82DA095Accident · No injuriesFinal reportCessna 150 · Dillon, MTWhile the student pilot was landing, the aircraft bounced and nosed over. The pilot had only 4 hours of solo time.NTSB DEN82DA087Accident · No injuriesFinal reportCessna 185A · Marion, MTThe pilot reported that when he was on final approach, he lost all control, while at an airspeed of about 74 mph, and the aircraft struck the ground in a nose low attitude. He reported that the wind was variable at 10 gusting 20 KTS. About 35 miles away at…NTSB DEN82DA085Accident · Minor injuriesFinal reportCessna 180 · Cut Bank, MTThe pilot reported that during landing, the aircraft veered off the right side of the runway even though he used left rudder. After departing the runway, the aircraft encountered a shallow ditch and went over on its back. The pilot reported that the winds…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 DEN82DA065Accident · No injuriesFinal reportPiper PA-18-180 · Savage, MTThe pilot reported that after takeoff, he remained at about 100 ft AGL and proceeded toward Savage, MT. He said he intended to fly over his partner's farm near Savage. Nearly 20 minutes after takeoff, a loss of engine RPM was noted as the pilot approached his…NTSB DEN82DA063Accident · No injuriesFinal reportPiper PA-23 · Gardiner, MTDuring arrival, the pilot observed that an aircraft was stuck in the mud on runway 28. After a short radio discussion with the pilot of the immobilized aircraft, a decision was made to land on the opposite runway. The pilot reported that just prior to…NTSB DEN82DA060Accident · No injuriesFinal reportCessna 170B · Worden, MTThe pilot reported that the carburetor heat control became inoperative while on a cross-country flight. The weather conditions were conducive to the formation of carburetor ice. A decision was made to land in an alfalfa field while the engine was still…NTSB DEN82FA056Accident · 3 fatalField investigationFinal reportCessna 320F · Missoula, MTDuring arrival for an ILS-2 approach to runway 11, the pilot was advised to hold at the kona NDB while snowplows finished clearing the runway. At that time, the Missoula weather was 1200 ft obscured, 2 mi visibility with light snow and fog, temperature and…NTSB DEN82DTI12Accident · No injuriesFinal reportCessna A188B · Carter, MTThe owner reported that the pilot landed on a road in a crosswind condition. The purpose for landing was to reload for fertilizer application. After touchdown, the aircraft ran off the road and flipped over.NTSB DEN82DA051Accident · No injuriesFinal reportCessna 182K · St. Ignatius, MTThe pilot stated that he and his passengers attempted to remove as much snow as possible from the aircraft and that he was confident that the propeller blast would blow away whatever snow remained. Although the wind at surrounding stations was generally…NTSB DEN82DA048Accident · No injuriesFinal reportCessna T182RG · Laurel, MTThe aircraft landed long on a down slope runway and ran off the end collapsing the landing gear. The pilot stated that he should have used full flaps instead of the 20 degrees he used.NTSB DEN82FTI11Accident · 1 fatalFinal reportCessna TR182 · Livingstone, MTThe plane crashed about six miles west of livingston, Montana. It was found to have struck about 50 ft below a 5300 ft ridge, while in a 20 degree climb attitude. The weather at livingston was: 900 ft broken, 2500 ft overcast, visibility 10 miles, wind…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…NTSB DEN82DA023Accident · No injuriesFinal reportBellanca 7GCBC · Havre, MTWhile taking off to help gather cattle, the right axle failed as the left wing was picked up by gusty winds. The plane spun around 180 degrees and flipped over. The pilot reported that the axles were not heavy enough for consistent rough field use.NTSB DEN82FTA09Accident · 1 fatalFinal reportCessna 177B · Wolf Pt., MTThe pilot reported that he encountered a snow squall while cruising at 5000 ft MSL on a VFR flight plan at night. He stated that he descended to 4000 ft MSL to try to get under the squall and continue. He was unable to remember what happened after descending…NTSB DEN82FTI10Accident · Serious injuriesFinal reportPiper PA-28-140 · Near Bozeman, MTThe pilot was on an early morning flight over mountainous terrain at 8500 feet. While inbound to his destination, he encountered an area of restricted visibility with snow. As he started a right turn to correct to his desired course, his passenger alerted him…NTSB DEN82FA016Accident · 2 fatalField investigationFinal reportCessna 210 · Helena, MTThe aircraft crashed into a mountain at the 9300 foot level. The pilot was on course for his destination. The minimum obstacle clearance altitude for his location was 10,800 feet. Weather was not a problem but the accident did occur during hours of darkness.…NTSB DEN82DTI09Accident · No injuriesFinal reportAir Tractor AT-301 · Greenough, MTDuring takeoff the aircraft struck a snow berm. The aircraft received substantial damage to both wings and prop. The aircraft had been landed on a county road about a week earlier due to deteriorating weather.NTSB DEN82FTA08Accident · Serious injuriesClosedPiper PA-24 · Rock Springs, MTNTSB DEN81DTA07Accident · Minor injuriesClosedCessna 152 · Big Timber, MTNTSB DEN82FTA06Accident · No injuriesClosedAeronca 7DC · Billings, MTNTSB DEN82FTA05Accident · No injuriesClosedHughes 269C · Billings, MTNTSB DEN82FTA04Accident · Minor injuriesClosedAyres S2R · Richey, MTNTSB DEN82FTI08Accident · No injuriesClosedCessna 182 · Chinook, MTNTSB DEN82FTI07Accident · No injuriesClosedBeech 35-C33 · Dillion, MTNTSB DEN82FTI06Accident · No injuriesClosedPiper PA-22 · Missoula, MTNTSB DEN82FTI05Accident · Minor injuriesClosedPiper PA-30 · Sheridan, MTNTSB DEN82FTI04Accident · No injuriesClosedBellanca 7GCBC · Fairfield, MTNTSB DEN82FTI03Accident · No injuriesClosedBell 47D1 · Haugen, MTNTSB DEN82FTI02Accident · No injuriesClosedBell 206B · Whitehall, MTNTSB DEN81FTA03Accident · No injuriesClosedBrantly B-2B · Broadus, MTNTSB DEN82FTA02Accident · No injuriesClosedPiper PA-18 · Ekalaka, MTNTSB DEN81FTA01Accident · Serious injuriesClosedPiper PA-18 · Glasgow, MTNTSB DEN82FTI01Accident · Serious injuriesClosedPiper PA-28 · Helena, MTNTSB DEN81FA068Accident · 1 fatalClosedCessna T210L · Big Timber, MTNTSB DEN81DTI21Accident · No injuriesClosedCessna 185 · Somers, MTNTSB DEN81FTI20Accident · Serious injuriesClosedBeech 23 · Deer Lodge, MTNTSB DEN81FTA14Accident · Minor injuriesClosedPiper PA-18 · Zortman, MTNTSB DEN81FTI19Accident · No injuriesClosedEnstrom 280C · Helena, MTNTSB DEN81FTI18Accident · No injuriesClosedAero Comdr 681 · Great Falls, MTNTSB DEN81FTI17Accident · Serious injuriesClosedPiper PA-18 · Buffalo, MTNTSB DEN81FTI15Accident · Serious injuriesClosedCessna 172N · Libby, MTNTSB DEN81FTA13Accident · No injuriesClosedCessna 177 · Lavina, MTNTSB DEN81FA056Accident · 2 fatalClosedCessna 150M · Sidney, MTNTSB DEN81FA055Accident · 3 fatalClosedPiper PA-28 · Kalispell, MTNTSB DEN81FTA12Accident · 1 fatalClosedAero Comdr A-9B · Park City, MTNTSB DEN81FTA11Accident · Serious injuriesClosedCessna T-50 · Ft Smith, MT