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 CHI83DA308Accident · Minor injuriesFinal reportVon Berg VEE BEE 4 · Saginaw, MIThe pilot of the home built aircraft was making a high speed taxi run when the aircraft inadvertently became airborne. The plane climbed to about 100 ft AGL and then the engine lost power. During landing, the aircraft was substantially damaged. The pilot…NTSB DEN82FTA11Accident · 2 fatalFinal reportPiper PA-18 · Hardin, MIThe wreckage was found 3/4 mi west of the nw end of a farm rwy in the approximate position of where a right turn would occur from the downwind leg to the base leg of a right pattern to the se rwy. The wreckage showed evidence of a right rotational moment at…NTSB CHI82DA298Accident · No injuriesFinal reportQuickie · Greenville, MIDuring the preflight inspection. The laminar-flow wing and canard were carefully wiped free of a heavy deposit of dew. All items of inspection were satisfactory. The engine was warmed up while taxiing to the runway. It was noted that beads of moisture were…NTSB CHI82DA297Accident · No injuriesFinal reportLake LA-4-200 · Standard Rock, MIAfter landing on a Lake to fish, the water got rough, so the pilot attempted a takeoff. During the takeoff run, the left float hit a wave and broke off. The takeoff was aborted without further damage.NTSB CHI82DA275Accident · Minor injuriesFinal reportErcoupe 415C · Port Sheldon Tw, MIDuring a VFR flight along lake Michigan shoreline the pilot encountered a decrease in ceiling height. The pilot chose to make a 180 degrees maneuver and return to the airport but during the turn encountered a fog bank. The pilot decended to avoid the fog bank…NTSB CHI82DA273Accident · No injuriesFinal reportCessna 120 · Niles, MIThe student was on his second solo flight in evening hours. Reportedly, after he had completed 4 landings, dusk was approaching and the instructor told him to make only 2 more landings. When the student was about ready to takeoff on his 6th pattern, a king…NTSB CHI82DA263Accident · No injuriesFinal reportBeech B19 · Berrien Springs, MIDuring landing, the aircraft bounced and the pilot lost directional control. Subsequently, the aircraft departed the left side of the runway, went into a muddy area, and was substantially damaged.NTSB CHI82DA257Accident · No injuriesFinal reportBeech 36 · Ypsilanti, MIAfter the engine was started, the pilot found that he needed a new microphone. He stated that he leaned over to the right to help the passenger open the door and apparently bumped the throttle. The aircraft moved and struck a parked Grumman American AA-5A,…NTSB CHI82DA256Accident · No injuriesFinal reportPiper PA-32RT · Mackinac, MIAircraft landed wheels up. No malfunction of the landing gear system could be found.NTSB CHI82DA258Accident · No injuriesFinal reportLuscombe 8F · Belleville, MIDuring the approach the acft stalled about 20 ft AGL. The plt added power but the acft touched down short of the rwy & collided with a ditch.NTSB CHI82DA323Accident · No injuriesFinal reportPiper PA-18 · Ranier, MIPilot stalled turning on final approach and crashed into water. No malfunctions found.NTSB CHI82DA246Accident · No injuriesFinal reportRepublic RC-3 · Saginaw, MIThe pilot stated that he took off with 35 gal of fuel aboard. After about 128 nautical miles, the engine lost power. While landing in a muddy corn field with the gear retracted, the aircraft slid a short distance then nosed over. One of the first persons to…NTSB CHI82DA245Accident · No injuriesFinal reportHughes 269A · Davison, MIThe student pilot was making a 180 degree pedal turn to the right while hovering. The instructor pilot (ip) stated that after 90 degrees of turn, the rate of turning started to increase and the student applied left pedal to slow the turn. The ip noted that…NTSB CHI82FA236Accident · 2 fatalField investigationFinal reportCessna 152 · Morenci, MIThe flt departed the toledo surburban arpt at 1800 for a local instructional flt. One witness described the acft as flying very erratically. It was dipping from side to side & gaining & losing altitude very rapidly. He next observed the plane climb straight…NTSB CHI82DA229Accident · Minor injuriesFinal reportClancy Skybaby · Grand Haven, MIDuring the pilots fourth takeoff roll of the day the right wing began to drop and the aircraft drifted off the runway. Power was reduced and brakes applied but the aircraft overturned after encountering a soft sodded area. After the accident it was noted that…NTSB CHI82DA226Accident · No injuriesFinal reportPiper PA-38 · Lowell, MIDuring the administration of a private pilot flight test, the prospective private pilot failed to gain sufficient airspeed on takeoff to enable the aircraft to climb. Approximately 3/4THS of the way down the runway the check pilot elected to abort the takeoff…NTSB CHI82DA224Accident · No injuriesFinal reportCessna 170B · Fowlerville, MIThe student pilot bounced on landing, veered to the left, and nosed over after encountering a soft spot in the corn field that the aircraft had entered.NTSB CHI82FA214Accident · 2 fatalField investigationFinal reportPiper PA-32 · Charlevoix, MIThe acft departed the Charlevoix arpt & crashed 1 mile south of the arpt. Two persons tried to discourage the plt from leaving because of the poor weather. Witnesses described the weather as raining hard & visibility poor with an estimated visibility at 200…NTSB CHI82DA212Accident · No injuriesFinal reportBell 47G-2A · Hudsonville, MIThe pilot was flying a swath run that required him to fly under electric wires near a blacktop county road. As the pilot was coming off the field and passing under the wires, he realized he was on a collision course with a car. He pulled up to avoid the car…NTSB CHI82DA207Accident · No injuriesFinal reportCessna 182RG · Midland, MIWhile taxiing to the wash rack, the pilot decided to make a takeoff and landing. After takeoff, he entered the downwind and observed two other aircraft entering behind him. While maintaining separation from the other aircraft and looking for a flock of birds…NTSB CHI82FA200Accident · 2 fatalField investigationFinal reportPiper PA-38 · Niles, MIAt about 1300 EDT, the aircraft took off on a local training flight with a student and a certified flight instructor on board. Later at about 1325, the plane crashed in a wooded area about 1 mi northeast of the approach end of runway 21. One witness reported…NTSB CHI82DA204Accident · No injuriesFinal reportMooney M20F · Plainwell, MIThe pilot reported that when he entered the traffic pattern, the radios did not work. He stated that he had his mind on this problem and did not put the gear down. Also, he reported that on downwind, the gear warning horn did not work, and subsequently, the…NTSB CHI82DA194Accident · Serious injuriesFinal reportAeronca AR-58 · Grand Haven, MIAfter liftoff the pilot lost directional control and crashed in a swamp. The aircraft was substantially damaged.NTSB CHI82DA191Accident · No injuriesFinal reportConvair 240 · Detroit, MIThe captain stated that during an ILS approach, he saw the approach lights about 3 miles from the touchdown point. Reportedly, the plane was on the glide slope and localizer as he continued on final approach. After passing minumums, the aircraft went into a…NTSB CHI82FA186Accident · 2 fatalField investigationFinal reportCessna 172N · Milford, MIEarlier in the evening during a return flt from london, ontario to pontiac, MI the plt became disoriented & was radar vectored to detroit city arpt, the only arpt reporting VMC. The plt landed at about 2208. After landing the plt received two wx briefings at…NTSB CHI82DA183Accident · No injuriesFinal reportCessna 310R · Holland, MIDuring landing roll pilot said right brake malfunctioned. His attempts to control aircraft with rudder failed as aircraft slowed. Aircraft left runway and collided with a ditch. Brake had air in the line.NTSB CHI82DA182Accident · No injuriesFinal reportCessna 150G · White Cloud, MIThe student pilot stated he was too high on final approach so he attempted a go-around. As he applied power, the nose increased in pitch attitude and the empennage struck the runway. The aircraft started to turn to the left, the left wing struck the runway…NTSB CHI82FA181Accident · 3 fatalField investigationFinal reportBeech A23 · Northville, MIAt 1701 EDT on 5/21/82, the non-instrument rated pilot called a flight service station and requested an IFR weather briefing. The briefing was for a flight from lapeer, Michigan to frankfort, Kentucky. The plane departed the next day at about 1200 EDT with no…NTSB CHI82DA178Accident · No injuriesFinal reportBalloon Works FIREFLY-7 · Wyoming, MIThe pilot was attempting to takeoff from a parking lot. He stated that when the Balloon was about 15 feet from the ground a gust of wind pushed the Balloon down into some trees and an apartment house.NTSB CHI82DA167Accident · No injuriesFinal reportPiper PA-22-150 · Harrison, MIDuring takeoff the pilot failed to clear a chain link fence. The aircraft collided with a ditch and the left main landing gear collapsed.NTSB CHI82DA163Accident · No injuriesFinal reportVolmer Amphibian · Muskegon, MIThe pilot returned to land on a lake after making touch and go landings at an airport. He stated that he made a water landing with the gear extended. During touchdown, the amphibious aircraft nosed over.NTSB CHI82DA161Accident · No injuriesFinal reportCessna 152 · Romeo, MIThe student pilot was practicing touch and go landings. On the third takeoff the aircraft veered to the left and the student was unable to correct. The aircraft continued into a soft field and nosed over. The wind was calm and the weather clear.NTSB CHI82DA159Accident · No injuriesFinal reportLake LA-4 · Dowagiac, MIThe pilot stated that while turning the aircraft during taxi to the shore the aircraft ran into the wake of a boat and skipped sideways. When the aircraft encountered a second wave the right wing struck the water shearing off the sponson and bending the wing.NTSB CHI82DA156Accident · No injuriesFinal reportPiper PA-28-180 · Yale, MIThe pilot elected to make a go-around due to a wind shift. During the attempted go-around the aircraft collided with trees about 700 feet off the end of the runway and crashed in a corn field.NTSB CHI82DA149Accident · No injuriesFinal reportHughes 269C · Flint, MIThe aircrew were on an instructional flight to prepare the student, a rated pilot, for a flight instructor rating. After practicing several autorotation approaches, the helicopter was landed. The instructor pilot (ip) stated that after touchdown, he and the…NTSB CHI82DA129Accident · Minor injuriesFinal reportHughes 269A · Lowell, MIDuring the first solo flight in a helicopter the pilot was instructed to make three normal takeoffs and landings. On the second landing, when the aircraft came to a hover, the back of the skid struck the ground during a drift-back. The helicopter rolled and…NTSB CHI82DA125Accident · No injuriesFinal reportPiper PA-28-140 · Caro, MIThe pilot reported that a partial loss of engine power occurred at about 200 ft AGL during takeoff. During a forced landing in a farm field, the nose wheel fork failed and the propeller and engine cowling were damaged. The pilot suspected a stuck value, but…NTSB CHI82DA121Accident · No injuriesFinal reportRand K.R.1 · Plymouth, MIOn takeoff roll the left upwind wing lifted and the pilot lost directional control. The aircraft swerved to the right and struck a parked bonanza, N5587D, causing substantial damage to both aircraft. Investigation revealed that the pilot attempted to takeoff…NTSB CHI82DA120Accident · No injuriesFinal reportPiper PA-34 · Gaylord, MIDuring a night visual approach the aircraft landed about 90 ft short of the runway. The aircraft slid across the ground onto the runway pavement and swerved to the right striking a runway light and ending up on a snowbank.NTSB CHI82DA116Accident · No injuriesFinal reportCessna 152 · Pontiac, MIWhile the student pilot was on his fifth touch and go pattern, the plane veered to the left after touchdown. The left main gear then encountered snow and pulled the aircraft further left into a snowbank. The student claimed that the owners had advised him to…NTSB CHI82DA114Accident · Minor injuriesFinal reportCessna T210L · Detroit, MIThe pilot elected to land at an alternate airport when he encountered poor visibility and icing conditions. While receiving vectors to Detroit metro the pilot reported he was low on fuel and needed to land. During the approach the engine quit. The aircraft…NTSB CHI82DA111Accident · Serious injuriesFinal reportBeech 95 · Pontiac, MIIt was dark and the temperature was about 20 degrees when the pilot and two passengers arrived at the plane. The pilot had started the right engine before the passengers arrived, but the left engine failed to start in the cold temperature. The pilot was…NTSB CHI82IA112Incident · No injuriesIncident investigationFinal reportRockwell Sabreliner 65 · Detroit, MIThe right engine was started as the passengers completed boarding. After the copilot secured the cabin door and took his seat, the pilot released the parking brake and control lock and applied power to taxi. When a turn was commanded the nosewheel steering…NTSB CHI82IA102Incident · No injuriesIncident investigationFinal reportBeech 65-88 · Kalamazo, MIPrior to landing the pilot could not extend the right main landing gear. He attempted to extend the gear by recycling the system and by using the manual extension, but to no avail. Subsequently, the aircraft was landed on a paved runway with the gear…NTSB CHI82FA098Accident · No injuriesField investigationFinal reportBeech 65-A90 · Kalamazoo, MIThe plt heard a grinding noise when he attempted to lower the landing gear. The gear would not extend with either the normal or emergency systems. The acft landed with the gear in the partially extended position. Subsequent to examinationof the nose landing…NTSB CHI82FA096Accident · Serious injuriesField investigationFinal reportCessna 414 · Jackson, MIAt approximately 90K after liftoff from a touch & go the copilot, who was flying from the left seat, indicated problems with the right eng. The plt had been observing trucks on the right side of the rwy. He stated they could have set it back down except he…NTSB CHI82DA089Accident · No injuriesFinal reportCessna 310 · Freemont, MIThe student was a rated pilot on his first instructional flight in this aircraft. After a practice aborted takeoff, the student applied power to start another takeoff. At about this time, the aircraft veered to the right. The instructorapplied left rudder and…NTSB CHI82DA074Accident · No injuriesFinal reportCessna 152 · Williamsburg, MIDuring a VFR approach the pilot stated he was concentrating on not landing long. The aircraft touched down in snow about 50 feet short of the landing area and slid, nose down, for approximately 50 feet. The pilot had flown a total of 3.2 hours in the last 90…NTSB CHI82DA073Accident · No injuriesFinal reportCessna 150 · Manchester, MIDuring takeoff the student pilot lost directional control and struck a snowbank. The student stated at 40-50 knots the left wheel bogged down in snow or encountered a rut and the aircraft twisted sharply left.NTSB CHI82DA049Accident · No injuriesFinal reportCessna 172N · Lambertville, MIThe pilot and 3 passengers returned to the airport after a flight in the local area. A normal approach was made with 20 degrees of flaps for a crosswind landing. The pilot reported that his approach speed was a little fast. During landing, the aircraft…