NTSB investigations, MI
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\" = 'MI' 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" = 'MI' 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 CHI83LA187Accident · No injuriesLimited investigationFinal reportTuk Gregory Quickie Q-2 · Ann Arbor, MIThe home built acft was on its 1st test flt. According to the plt, the throttle became bound when he attempted to add power after checking the stall characteristics. Reportedly, the eng lost power at about this time when a rapid throttle movement was made.…NTSB CHI83LA181Accident · No injuriesLimited investigationFinal reportCessna 172P · Mt. Pleasant, MIWhile on a local sight-seeing flt, the plt elected to land at mt Pleasant, MI for lunch. A low pass was made over rwy 09. The plt reported that while he was on a second approach to land, the acft encountered wind gusts and a loss of altitude. The plane's…NTSB CHI83LA168Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Harrison, MIThe pilot stated that he executed a go-around on the first landing attempt because of a strong crosswind and high airspeed. On the second approach, he executed a go-around from the flare because of a 'strong updraft'. The pilot statedthat during the…NTSB CHI83LA167Accident · No injuriesLimited investigationFinal reportCessna 172M · Holland, MIThe acft landed nose wheel first in a gusty crosswind. The active runway was 5 and the wind was 150 degrees at 15 KTS gusting to 21 KTS. The pilot stated that before she could round out a wind gust caused the acft to drop and make contacton the nose gear. The…NTSB CHI83LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-140E · Lake, MIThe pilot stated the wind shifted at about 50 ft AGL and the acft stopped climbing and mushed down and collided with a fence.NTSB CHI83LA159Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Fraser, MIThe aircraft stalled and undershot the runway landing about 100 feet short, where it collided with a ditch and nosed over. The pilot and his wife aboard the aircraft were not injured. The aircraft landed on runway 09 and the wind was from 110 degrees at 15…NTSB CHI83LA158Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Fraser, MIThe pilot stated he lost directional control of the aircraft after touchdown during a crosswind landing. The aircraft departed the right side of the runway into a muddy area and nosed over.NTSB CHI83LA141Accident · No injuriesLimited investigationFinal reportCessna 182 · Carson City, MIThe plt reported that he had called the owner of the private airstrip, 3 days before the accident. At that time, the rwy was reported as 'firm & in good condition.' On the day of the accident, the plt flew over the arpt & visually checked it. It appeared fine…NTSB CHI83LA134Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly AX-7 · Augusta, MIThe Balloon made a hard landing and ejected the pilot and passenger. The landing was made in a school parking lot. Afterdropping the occupants the Balloon contacted power lines with the envelope. The occurants were not injured.NTSB CHI83LA129Accident · No injuriesLimited investigationFinal reportRand KR1 KR-1 · Watervliet, MIThe pilot stated that he had flown the aircraft on the previous day and the operation had been satisfactory. Prior to that flight the aircraft had not been flown for two years. After takeoff he experienced power interruption, made a 180 degree turn back to…NTSB CHI83LA127Accident · Minor injuriesLimited investigationFinal reportAeronca Champion 7AC · Newberry, MIThe aircraft collided with a telephone pole while attempting a takeoff on skis. The snow was wet, sparse and sticky and the takeoff was being performed on a taxiway because it had more snow. This was a dual instructional flight with the student at the…NTSB CHI83LA117Accident · No injuriesLimited investigationFinal reportBeech 58 · Detroit, MIDuring arrival, the plt received vectors for an ILS approach. He elected to make a localizer only approach. At the outer marker, the acft was aprx 200 ft above the minimum altitude & above the approach speed. The plt reported that he reduced the airspeed…NTSB CHI83LA116Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Three Oaks, MIThe instructor (CFI) & his student had started flying at aprx 1900 EST. The purpose was to give the student aprx 3 hrs of night instruction. A refueling stop was made at south bend, IN. According to the student, the CFI stayed in the acft during the…NTSB CHI83LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harrisville, MIThe plt reported that during a touch-and-go landing on a snow covered rwy, the acft hit a chunk of frozen snow. Reportedly, he had departed from the same rwy & had been making touch-and-go landing, but did not see the obstruction.NTSB CHI83LA113Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Jackson, MIComplete electrical failure occurred at 8,000 ft. the plt diverted to Jackson & the acft landed wheels-up. The plt laterstated that he thought he was familiar with the emergency gear extension procedures in the flt manual but that he might not have put the…NTSB CHI83LA112Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Three Oaks, MIThe acft collided with a wire during the landing approach and landed hard enough to collapse the nose gear. According to the owner the flt was not authorized and the person at the controls held no pilot certificate. The pilot made the following statement, 'I…NTSB CHI83LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Napoleon, MIThe aircraft lost power during climb after takeoff. The pilot made a forced landing in an open field. He stated that contamentation was the cause of the power loss.NTSB CHI83LA101Accident · No injuriesLimited investigationFinal reportCessna 185 · Jackson, MIThe tailwheel acft veered during landing on rwy 5 & the left landing gear collapsed. The wind was 110 degrees 6 KTS. The pilot states he had a flat tire. The local controller who observed the landing reported seeing the acft swerve to the right. An FAA…NTSB DCA83AA014Accident · 3 fatalFinal reportMcDonnell Douglas DC-8-54F · Detroit, MIAccording to witnesses, the takeoff roll was normal, & the acft rotated to a takeoff attitude about 1/2 to 2/3 of the way down the rwy. After lift-off, the acft's pitch attitude steepened & the plane climbed to about 1000 ft AGL. The acft then rolled to the…NTSB CHI83LA072Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Detroit, MIThe plt stated that as she was crossing the threshold she noticed that the acft had been blown over too FAR to the rightof the rwy. After correcting for this, she leveled off too high & the acft nosed down onto the rwy.NTSB CHI83IA063Incident · No injuriesIncident investigationFinal reportDouglas DC9-30 · Pellston, MIBefore departing traverse city the captain was informed that emmet city arpt was sanded at about 1736 and that icy runway conditions were turning to slush. He was also told that rwy 32 would be sanded again prior to his arrival. This was accomplished, with a…NTSB CHI83LA061Accident · No injuriesLimited investigationFinal reportCessna 310R · Gaylord, MIPrior to a flight from charleston, WV to sault ste marie, MI, the pilot was briefed to expect icing conditions. During the flight, mixed and rime icing conditions were encountered; however, the deicing equipment removed it satisfactorily. An update weather…NTSB CHI83LA051Accident · Minor injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Muskegon, MIThe pilot descended below his altitude and struck trees approximately 4.7 miles south of his destination. The aircraft continued to fly and the pilot elected to make an emergency landing. After touchdown the aircraft skidded down the runway for approximately…NTSB CHI83LA057Accident · No injuriesLimited investigationFinal reportColonial C-1 · Kalamazoo, MIPilot lost oil pressure and elected to land in a plowed field. Nose gear collapsed during landing. Oil leak was the cause of the drop in quantity and pressure.NTSB CHI83FA068Accident · 1 fatalField investigationFinal reportCGS Hawk · Dewitt, MIThe owner had been conducting hi-speed taxi practice with short takeoff/landing hops in the same direction but was unable to obtain lift-off. He then asked the plt to see what the problem was the plt said he would not attempt to fly the ultralight. On the 2nd…NTSB CHI83LA046Accident · No injuriesLimited investigationFinal reportStinson 108 · Milan, MIWhile on downwind the pilot stated he "pulled the carburator heat on and almost immediately reduced the power." At this point the engine stopped. Although he attempted to restart the engine while executing emergency procedures, the engine failed to respond.…NTSB CHI83FA044Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · Evart, MIThe aircraft flew into trees during low flight in IMC weather. The pilot had received a weather briefing and was instrument rated but was not on an IFR flight plan. IMC weather was forecast for the route planned. Hunters heard the aircraft fly over at a low…NTSB CHI83LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · New Hudson, MIThe pilot was giving a plane ride to his brother, his brother's grandson and the child's mother. The child's grandmother wanted to take pictures and walked into the parking area next to the taxiway. While looking through the viewfinder, her depth perception…NTSB CHI83LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Port Hope, MIThe pilot estimated that the wind was from 210 to 220 deg at 15 KTS. He reported that the grass runway was soft and wet. For takeoff on runway 18, he used 10 deg of flaps and about 1/2 of the available aileron while using a soft field takeoff procedure. The…NTSB DEN83FTI02Accident · 2 fatalFinal reportCessna 172P · Dillon, MIThe pilot and three passengers departed Dillon, mt at about 0740 MDT to scout for elk in preparation for hunting the next day. According to a passenger, they flew directly to a mountain area about 30 miles away where they spotted some elk. He said that while…NTSB CHI83LA018Accident · 2 fatalLimited investigationFinal reportMooney M20E · Sault Ste Marie, MIThe pilot was on a VMC flight plainwell, MI. To Sault st Marie, MI. Prior to and during the flight the pilot obtained weather briefings on conditions relative to his intended route of flight. A witness near the crash site stated the aircraft passed over her…NTSB CHI83FA014Accident · 1 fatalField investigationFinal reportBeech A24R · Lansing, MIWitnesses observed the acft flying in an easterly direction, level but in a slightly descending flight path. No smoke, flame or parts falling from the acft were observed. The eng sound was steady & loud. The descent continued at a shallow angle until impact.…NTSB CHI83LA013Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Port Huron, MIOn touchdown a gust of wind hit the aircraft, the pilot lost directional control, swerved to the right and nosed over. The pilot reported wind gusts to 30 KTS.NTSB CHI83LA008Accident · Serious injuriesLimited investigationFinal reportCessna T188C · Sparta, MIWitnesses observed a normal climb out, but as the acft cleared trees the plt began jettisoning the load. The plt stated that about 1/2 mi from the departure end of rwy 6 the acft seemed to mush & then descend into the trees. The wind at grand rapids, 20 mi…NTSB CHI82IA364Incident · No injuriesIncident investigationFinal reportCessna 152 · Pontiac, MIThe pilot was on a local flight in Cessna 152, N4745B, practicing landings during a period of peak traffic. While the pilot was in the traffic to land on runway 27R, another Cessna 152, N24236, was cleared onto the left runway (27L). At 1722:05, N24236 was…NTSB CHI82DA363Accident · No injuriesFinal reportAeronca 7EC · Detroit, MIAircraft made left turn after takeoff at 15 feet AGL behind tree line which interferred with available wind. Aircraft stalled and dragged left wing, followed by cartwheel and sinking.NTSB CHI82DA352Accident · Minor injuriesFinal reportBreezy RLU-1 · Marshall, MIAfter landing, the pilot lost directional control of the aircraft. Subsequently, it departed the right side of the runway and turned over. An examination of the wheel brakes revealed no mechanical failure or malfunction. Reportedly, there was a crosswind from…NTSB CHI82FA350Accident · 2 fatalField investigationFinal reportMooney M20E · Houghton, MIThe acft crashed into trees while making an ILS approach to Houghton county memorial arpt, hancock, MI. The weather was IMC and an IFR flt plan had been filed. The two occupants were held in the acft by seat belts and were fatally injured in the crash and…NTSB CHI82DA349Accident · No injuriesFinal reportBensen BM8 · Zilwauker, MIDuring flight at about 1500 ft AGL, the aircraft engine lost power. The pilot made a steep approach to land in a small field surrounded by power lines. He stated that during an extreme flare to stop the forward flight, the main rotor blades hit the ground and…NTSB CHI82DA348Accident · No injuriesFinal reportCessna 172M · Cheboygan, MIThe flight was being conducted over the waters of lake huron when engine stoppage occurred. Unable to glide to the airport the pilot ditched the aircraft on the shoreline in the water. The post-accident investigation revealed that the foam rubber from the air…NTSB CHI82DA346Accident · No injuriesFinal reportPiper PA-23-250 · Holland, MIPilot taxiing to takeoff collided with fuel pumps.NTSB CHI82DA345Accident · Serious injuriesFinal reportRaven S55 · Mattawan, MIDuring a landing in an open field the balloon collided with wires and started to burn. The pilot stated that her attention was temporarily distracted as the balloon approached a corral with horses and she was adjusting the maneuvering valve for landing. The…NTSB CHI82DA341Accident · No injuriesFinal reportAero Commander 681 · Pontiac, MIDuring cruise flight the pilot observed the hydraulic system pressure fluctuating. The pilot immediately went into a hold pattern and attempted to ascertain the problem. After repeated attempts the pilot was able to lower the nose gear and the right main…NTSB CHI82DA333Accident · No injuriesFinal reportPiper J-3C65 · Bloomfield Hill, MITakeoff was from se end of a lake about 4,000 ft long (se to nw) with a small island in the center. The plt stated that after lift-off he obtained climb speed but the acft would not climb from about 20-30 ft above the water. Severe turbulence was encountered…NTSB CHI82DA332Accident · No injuriesFinal reportHiller 12B · Detroit, MIThe plt entered the Detroit city arpt area from the west with winds from 280 degrees at 18K gusting to 23K. At 150-175 ft AGL the plt added power in order to reduce his closure rate, traveling southeasterly at the time. The acft then started yawing to the…NTSB CHI82FA326Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Athens, MIThe acft was landing on rwy 27 which has a 350 ft displaced threshold due to 24 ft high power lines on the approach. A witness stated the plt was low & narrowly missed the wires on the first touch & go. During the second approach the plt was noticeably lower…NTSB CHI82DA325Accident · No injuriesFinal reportCameron 0-77 · Wall Lake, MIThe pilot reported that during flight, he encountered unexpected light turbulence and elected to land at the next available spot. He stated that during a landing approach at about 50 ft above the treetops, a gust of wind was encountered that forced hot air…NTSB CHI82DA322Accident · No injuriesFinal reportGrumman AA-5A · Frankford, MIThe pilot landed hard and lost directional control of the aircraft. He executed the landing into a 19 kt head wind, in the rain, with a wet runway.NTSB CHI82DA334Accident · No injuriesFinal reportCessna 210 · Holland, MIDuring landing, the aircraft swerved to the left and went off the runway. The left gear struck a runway light fixture and failed. Also, the horizontal stabilizer hit a runway light and was damaged. An inspection of the wheel assembly revealed no mechanical…NTSB CHI82DA311Accident · No injuriesFinal reportDragon Fly · Plymouth, MITest flight in new experimental aircraft. During the first landing the aircraft ballooned, stalled and impacted left wing first.