NTSB investigations, MN
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\" = 'MN' 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" = 'MN' 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 CHI82DA313Accident · No injuriesFinal reportCessna 152 · Chatfield, MNThe pilot reported that he was landing on runway 36 at a private airport with a crosswind from 300 deg at 17, gusting 26 KTS. The wind was blowing over tall trees along the left side of the runway, near the approach end. The pilot stated that this resulted in…NTSB CHI82DA279Accident · No injuriesFinal reportBell 47G-2 · Plainview, MNWhile making cleanup swaths over an odd shaped portion of a corn field, the pilot made two turns of about 220 degrees each in close proximity to each other. The second turn was made downwind from two previous swaths that had just been completed. During a…NTSB CHI82DA276Accident · No injuriesFinal reportPiper PA25-235C · Ada, MNThe pilot sprayed one field and proceeded to the next field about 2 miles away. He stated that he executed a tight 270 deg turn to the right at about 100 ft. he also stated that after about 90 deg through the turn, the aircraft lost power, stalled and…NTSB CHI82DA269Accident · No injuriesFinal reportCessna 172N · Isle, MNThe pilot was on a cross-country flight and began an approach to a private airstrip. He reported that the weather conditions were good with light turbulence. About 100 ft from the threshold, the aircraft began to settle and the pilot added power. However, the…NTSB CHI82DA265Accident · No injuriesFinal reportEagle DW-1 · Murdock, MNThe pilot was en route to a bean field when the ground adjustable propeller came out of adjustment. The pilot dumped the load and made a forced landing in a beanfield. During the landing, the aircraft nosed over and was substantially damaged. An investigation…NTSB CHI82DA261Accident · No injuriesFinal reportGrumman G-164B · East Grand Fork, MNThe acft stalled during pull-up from a swath run.NTSB CHI82DA248Accident · No injuriesFinal reportCessna 182C · Deer River, MNThe pilot reported that when he was briefed by the flight service station, he was told the ceilings were low, but VFR conditions were expected by 1000 CDT. The pilot departed at 0850 CDT in weather conditions that he estimated to be 1000 ft overcast with 8 mi…NTSB CHI82DA247Accident · No injuriesFinal reportAero Commander S2R · Graceville, MNThe pilot was on an aerial application flight to a field with power lines alongside. The wind was reported to be from the southeast a 6, gusting 11 KTS. The pilot said that he encountered "dead air" while he was in his fourth porcedure turn. Due to the…NTSB CHI82FA231Accident · 2 fatalField investigationFinal reportCessna 150J · New York Mills, MNThe acft took off from a 2,500 ft alfalfa field which initially sloped downward then upward near the point of lift-off. A witness stated the acft did not appear to climb. The acft collided with 40 ft high power lines approximately 1000 ft from the point of…NTSB CHI82DA233Accident · No injuriesFinal reportCessna 150M · Santisgo, MNDuring aerial photo mission engine began to run rough. Pilot headed home but was forced to land enroute. Aircraft swerved and nosed over. Exam of engine showed exhaust valve stuck open.NTSB CHI82FER22Accident · Serious injuriesFinal reportAeronca 7AC · Maple Plain, MNThe pilot reported that he circled the farm area several times to find a suitable landing site. He decided on a portion of the farmer's field next to the house and made a final pass to inspect the area. During the pass, he saw some trees and reportedly…NTSB CHI82DA218Accident · Serious injuriesFinal reportMooney M20J · Duluth, MNPlt wx briefed at 2148 by kenora fss, ontario, Canada. Area & terminal forecasts indicated VFR conds to exist at Duluth. Subsequently, at 2151, Duluth arpt notamed closed, all rwy & approach lites out. The ILS rwy 9 g/s later went out of service, but not…NTSB CHI82FER21Accident · Serious injuriesFinal reportBarrett BG-5 · Maple Plain, MNDuring landing approach the gyrocopter collided with a powerline. The student pilot lost control and crashed beyond the powerlines. The pilot was attempting to land in a farm field adjacent to a relative's house.NTSB CHI82DA222Accident · No injuriesFinal reportCessna 170B · Princeton, MNAfter arriving, the pilot made a go-around on his first approach to runway 33 when he saw a truck on the runway. On his second downwind, he determined that trucks were operating only on the displaced portion of runway 15. He continued the second approach in…NTSB CHI82DA208Accident · No injuriesFinal reportCessna A188B · Greenbush, MNThe aircraft crashed during takeoff from a grass runway that had not been mowed for several weeks. The field elevation was 1070 ft, the wind was calm, and the temperature and dew point were 62 and 50 degrees. A full flap (20 degree) configuration was used for…NTSB CHI82FA206Accident · 1 fatalField investigationFinal reportMcclary Mong Sport · Cedar, MNWitnesses observed the acft enter a steep nose down attitude & slow spiral from which the acft did not recover.NTSB CHI82DER20Accident · No injuriesFinal reportCessna 188B · Hallock, MNDuring landing roll to investigate a stalled truck, the aircraft collided with the truck which backed into the aircraft's roll out path. After the collision, the aircraft ran into a ditch.NTSB CHI82DA202Accident · Minor injuriesFinal reportCessna 150 · Cambridge, MNOn his first solo flight the student pilot stated he panicked at about 400 feet AGL and decided to land in a plowed field. During the landed sequence the aircraft nosed over.NTSB CHI82FER19Accident · No injuriesFinal reportHardie Tern II · Stillwater, MNThe aircraft stalled while maneuvering for a landing. The pilot was unable to properly recover before the aircraft collided with the ground.NTSB CHI82DA193Accident · No injuriesFinal reportCessna 182 · Tracy, MNThe pilot reported that during a normal landing, the left main gear axle failed and he was unable to control the aircraft. The aircraft went off the runway and the nose gear collapsed when it encountered soft mud.NTSB CHI82DA196Accident · No injuriesFinal reportBell 47D1 · Le Sueur, MNDuring a spraying operation, the aircraft was being refueled from a 200 gal fuel tank, mounted on the rear of a truck. The truck was parked on a slight slope with the outlet for the servicing hose at the lower end. After the helicopter was serviced with 14…NTSB CHI82FER18Accident · 1 fatalFinal reportAeronca 65-TF · Staples, MNThe pilot was making low passes over a river in search of a drowned man. He made a steep right turn and the aircraft stalled, dove into trees and impacted the ground nose first. The pilot stated the aircraft's door had been removed and that the aircraft had…NTSB CHI82DA177Accident · Minor injuriesFinal reportBlanik L-13 · Warren, MNThe pilot was having difficulty controlling the glider during the tow and released prematurely. The destination was 12 to 14 miles away with 10-15 kt headwinds. When the pilot decided the destination could not be made a road was selected for a forced landing…NTSB CHI82FA174Accident · 1 fatalField investigationFinal reportCessna A188 · Blue Earth, MNThe flagman stated that during the swath run the acft was following the contour of the field. The flagman thought the plt was getting close to the end of the field & was about to call him on the radio when the acft pulled up to about a 45 deg nose high…NTSB CHI82DA162Accident · No injuriesFinal reportHiller 12E · Benson, MNHelicopter flying at 250 feet to stay below clouds had engine failure. Landed downwind in muddy field. Right skid collapsed.NTSB CHI82FA160Accident · 1 fatalField investigationFinal reportCessna 172C · Sunburg, MNThe pilot received several weather briefings and was advised of a severe cold front and thunderstorms in an area on his route. Prior to takeoff, he was advised that VFR flight was not recommended. While en route, the pilot reported that he was "totally…NTSB CHI82DA137Accident · No injuriesFinal reportCessna 150 · Blaine, MNWhile on final approach the pilot stated that the engine lost power. The aircraft landed about 700 feet short of the runway in rough terrain. Investigation disclosed at least 1 1/2 pints of water in the left fuel tank, water in the carburetor bowl, and the…NTSB CHI82DA136Accident · No injuriesFinal reportBellanca 7ECA · Maple Lake, MNThe pilot lost directional control during landing in strong crosswind conditions with gusts to 22 knots. The aircraft departed the runway and collided with a parked aircraft. The pilot stated that he was not currently proficient in crosswind landing, should…NTSB CHI82FA123Accident · 3 fatalField investigationFinal reportMooney M20J · Bird Island, MNThe aircraft departed thief rivers, MN and proceeded en route to new ulm, MN. One witness near the accident site heard a noise that sounded to him like an explosion. He and other witnesses in the vicinity saw the aircraft descending out of control in a roll…NTSB CHI82DA107Accident · No injuriesFinal reportCessna 172K · Fairmont, MNThe pilot encountered adverse weather and elected to land at Fairmont,Minnesota. While taxiing after landing, the aircraft flipped over in strong wind conditions.NTSB CHI82DA104Accident · No injuriesFinal reportCessna 180 · Duluth, MNThe student pilot was making touch and go landings on RUNWAY09 while preparing for a flight check. After landing, he proceeded to open the cowl flaps and push in the carburetor heat control. He stated that at that time, he let the ailerons go to a neutral…NTSB CHI82DA090Accident · No injuriesFinal reportCessna 182 · Bremen Township, MNDuring a VFR flight, the pilot encountered deteriorating weather and elected to make a precautionary landing on a snow covered, cultivated field. The pilot reported that during a soft field approach for landing, the aircraft flipped over when it contacted the…NTSB CHI82DA084Accident · Serious injuriesFinal reportPiper PA-28 · Cambridge, MNThe pilot had expected that strong headwinds would decrease during flight; however, they continued. The pilot made an enroute stop for fuel, but after landing, he found that the airport was deserted. He stated that he recalculated the elapsed time, etc, and…NTSB CHI82DA095Accident · No injuriesFinal reportCessna 172G · Cambridge, MNAfter landing on runway 16, the aircraft ran off the right side of the runway. It hit a snowbank, and both wing spars were bent.NTSB CHI82DA081Accident · No injuriesFinal reportPiper PA-23 250 · Grand Marais, MNAfter clearing trees located approximately 1000 feet from the end of the runway the pilot reduced power and added flaps in an attempt to land close to the approach end. The aircraft struck a snowbank on short final for the snow covered runway 27.NTSB CHI82DA079Accident · Serious injuriesFinal reportMooney M20J · Crystal, MNWhile attempting to start the eng, the pilot could not get the starter to engage. He asked the passenger to get out and rotate the propeller to a different location in hopes of getting the starter to engage. With the magnetos and master switch off, the prop…NTSB CHI82DA075Accident · No injuriesFinal reportBeech 23 · Aitkin, MNAfter landing on a partially snow covered runway the pilot lost directional control and struck a snowbank. The aircraft traveled approximately 15 feet before nosing down into the snow covered terrain.NTSB CHI82DA067Accident · No injuriesFinal reportPiper PA-28-140 · Lakerville, MNWhile on downwind, the pilot moved the fuel selector to what he believed was the left tank position. He also moved the throttle to idle to simulate an engine failure. He extended his pattern to allow time for another pilot to back-taxi down the runway to the…NTSB CHI82DA069Accident · No injuriesFinal reportCessna 180 · New Richland, MNThe pilot was returning home after completion of an annual inspection of the aircraft. After returning, the aircraft was landed on a wet, icy sod runway. During the landing roll the aircraft came in contact with a snowbank and nosed over.NTSB CHI82DA044Accident · No injuriesFinal reportCessna 172 · Anoka, MNThe pilot was practicing touch and go landings. He reported that on his last landing, the wind pushed him toward the right side of the runway. The right main gear encountered snow and pulled the aircraft further to the right into a drift beside the runway.…NTSB CHI82DA035Accident · Minor injuriesFinal reportCessna 150 · Buffalo, MNThe instructor and student departed with the intention of making a touch and go landing after takeoff. During the landing, the aircraft veered to the right and struck a 3 to 4 ft snowbank. The student stated that on short final, the aircraft dropped and…NTSB CHI82DA031Accident · No injuriesFinal reportAeronca 7BCM · Hoffman, MNWhile landing on a snow covered driveway in an Aeronca equipped with skis the left wing raised up and the right wingtip caught the ground. The pilot stated the wind was gusting to 18 knots.NTSB CHI82DA027Accident · No injuriesFinal reportBeech C-45H · Anoka, MNThe pilot elected to land on runway 35 with a left quartering headwind at 20 knots. He stated that the approach and landing seemed normal with no undue crab or crosswind correction. After landing, the plane made a quick turn to the left. The pilot reported…NTSB CHI82FER16Accident · 1 fatalClosedRutan EZ · Hackensack, MNNTSB CHI82FA017Accident · 1 fatalClosedPiper PA-28 · Preston, MNNTSB CHI82DER17Accident · No injuriesClosedPiper PA-38 · Albert Lea, MNNTSB CHI82FER15Accident · Minor injuriesClosedMooney M20K · Buffalo, MNNTSB CHI82DER14Accident · No injuriesClosedBell 47G2 · Kerrick, MNNTSB CHI82FER13Accident · No injuriesClosedCessna 182B · Eden Prairie, MNNTSB CHI82IA015Incident · No injuriesClosedDouglas DC-10 · Minneapolis, MN