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 CHI86FEM11Accident · Serious injuriesFinal reportCessna 150E · Muskegon, MIThe plt rprtd that drg takeoff, the acft lifted off at about the midpoint of the rwy & climbed to just above treetop level. He turned the acft slightly into the wind, then noted that it seem to lose the ability to climb further. The stall warning horn sounded…NTSB CHI86LA173Accident · No injuriesLimited investigationFinal reportLake LA-250 · Frankfort, MIThe plt rprtd that during an attempted go-around, a crosswind caught the right wing and blew the acft to the left. The left wing hit a hangar door & was torn off, then the acft crashed to the ground & came to rest upside down. The wind was rprtd to be gusting…NTSB CHI86FA172Accident · 3 fatalField investigationFinal reportCessna 441 · Norton Shores, MIN6857E was transporting executives from holland, MI, to muskegon. The pilot was executing an asr approach to runway 06. The mda is 537 ft AGL. Co-pilot called out 1200 feet then below 1000 feet, pilot continued approach. Aircraft struck trees two miles from…NTSB CHI86FEC05Accident · No injuriesFinal reportJerry Berry MONO-FLY · Blissfield, MIThe acft was damaged in a forced lndg after a power loss at 200 ft AGL. The plt/owner had an ignition problem with the eng quitting in flt. After ground checks & repairs the eng was ground run successfully but during test flt it quit again. An attempt was…NTSB CHI86FA170Accident · Serious injuriesField investigationFinal reportGrumman AA5B · Benton Harbor, MIThe aircraft departed on runway 09. Passenger remembers the pilot starting to turn back to the airport when the wings went perpendicular to the horizon and the ground came rushing up. Teardown of the engine revealed a bent push rod and a split push rod shroud…NTSB CHI86LA164Accident · No injuriesLimited investigationFinal reportCessna 150F · Selfridge Ang, MIThe plt became lost at night over a large body of water and requested assistance. When identified by ATC, the acft did not have enough fuel remaining to reach an arpt. The acft suffered fuel exhaustion on final apch and was landed on a golf course 2000 ft…NTSB CHI86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fraser, MIAircraft nosed over during an attempted downwind dead stick landing on an airport after running out of fuel. The aircraft landed at midfield and was unable to stop before running off of the end of the runway.NTSB CHI86FEM10Accident · Minor injuriesFinal reportPiper PA-25-235 · Ionia, MIDuring initial banner pick-up of a banner towing operation the tow cable fouled the rudder control mechanism. The rudder was jammed and the banner release mechanism failed to operate. The aircraft impacted the ground left wing first and was substantially…NTSB CHI86FEC04Accident · Serious injuriesFinal reportCameron 77 · Hamburg, MIPlt made a precautionary landing reportedly due to high winds. Upon touchdown the basket tipped and one of the pax received a fractured left leg.NTSB CHI86LA160Accident · No injuriesLimited investigationFinal reportBeech V35B · Mackinac Island, MIAfter making two go-arounds the aircraft's landing gear collapsed as the aircraft porpoised on the runway during the third landing attempt.NTSB CHI86FEM09Accident · 2 fatalFinal reportCessna 172I · Nunica, MIThe acft was seen flying over the water at an alt of aprx 150-200 ft AGL prior to hitting wires. The acft was flying into the sun at the time of the wire strike.NTSB CHI86FEM07Accident · No injuriesFinal reportCessna 188B · Bay City, MIDuring an ag spray operation, the plt flew over the area before starting his swath runs. On his first run, he flew over wires at the end of the field. On the return swath run, he attempted to fly under the wires. While doing so, the acft struck a newly…NTSB CHI86LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Belleville, MIThe plt aware she was ld on a 1750' wet grass strip elected to ld over high tension lines in calm wind. Pilot made two approaches and ld on third. Pilot aware of poor braking action turned off ignition. Acft ran off end of rwy and struck a ditch.NTSB CHI86FEM08Accident · Serious injuriesFinal reportBeech B35 · Paw Paw, MIOn takeoff at approx 100' the engine began to falter. The pilot did a 180 deg turn and landed about 1/2 way down the runway. After bouncing twice and seeing that he would probably run off the end, he performed a go-around. At a point near the end of the…NTSB CHI86FEM06Accident · No injuriesFinal reportCessna 170 · Houghton Lake, MIThis student pilot on his initial solo flight bounced the acft during landing. On the second bounce, the pilot inadvertently applied the toe braked and aircraft nosed over.NTSB CHI86LA147Accident · No injuriesLimited investigationFinal reportCessna 195 · Port Huron, MIThe flight was to be a currency flight for the plt who indicated the acft had sat unused for over 8 months. After 10-15 minutes of flight the engine stopped. A hard landing was made on lake st. clair and the acft was substantially damaged. When interviewed…NTSB CHI86FEM05Accident · No injuriesFinal reportEagle DW-1 · Baroda, MIThe plt shut down the acft engine after noticing oil on the canopy and a loss of oil pressure. A forced landing was performed in a corn field and the acft nosed over. Post accident inspection disclosed the oil pressure hose had ruptured.NTSB CHI86LA140Accident · No injuriesLimited investigationFinal reportCessna 150F · Gaylord, MIOn rollout, while the plt was attempting to correct a drift to the right, the acft suddenly veered to the left and the nose gear collapsed. During the resulting slide, the aircraft began burning and was destroyed. The plt reported that the magnesium hub of…NTSB CHI86LA139Accident · No injuriesLimited investigationFinal reportTaylorcraft DC-65 · Plainwell, MIWhile departing to the north in light wind conditions, the pilot made a decision to abort the takeoff, then realized he would not be able to stop on the remaining runway. He attempted to continue the takeoff. He zoomed the aircraft to clear wires in his path,…NTSB CHI86FA137Accident · 1 fatalField investigationFinal reportPiper PA-23-150 · Warren, MIThe acft developed a small oil leak during a x-country flt. The plt reduced power to idle to conserve oil even though the oil pressure was still in the normal range. During the descent the acfts airspeed was not maintained and the acft contacted the ground in…NTSB CHI86LA136Accident · No injuriesLimited investigationFinal reportCessna 404 · Marquette, MIThe acft was landed on snow covered rwy 26 with winds from 300 degs at 20 KTS gusting to 30 KTS. Directional control of the acft was lost during the first third of the landing roll and it traveled off the left side of the rwy. The acft entered soft terrain…NTSB CHI86LA128Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Pickney, MIThe balloonest had briefed and positioned his two pax for a anticipated hard/drag landing in a 9 kt wind. He stated the balloon touched and bounced then touched and bounced again before it entered the drag sequence of the landing. The female pax suffered a…NTSB CHI86LA134Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Mt Clemens, MIAfter aprx 20 successful takeoffs & landings, the eng of the helicopter lost power at about 300 ft AGL, due to a #1 connecting rod failure. During an autorotation, the helicopter landed in trees & was destroyed. Although the pilot was instructing a new…NTSB CHI86LA133Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIThe pilot stated that during landing the right wing of the glider touched the ground causing a right turn. The left wing then caught on a truck tire causing a 70 degree turn to the left. The glider was stopped when the right wing struck a barn. He was later…NTSB CHI86LA130Accident · No injuriesLimited investigationFinal reportCessna 150 · Gregory, MIThe CFI stated that the purpose of the flight was to look at property and give a bfr to his dual student. The aircraft struck wires while on approach to runway 23 at the smith farm airport. The CFI stated this accident could have been prevented had he used a…NTSB CHI86IA121Incident · No injuriesIncident investigationFinal reportBoeing 727-231 · Detroit, MIWhile taxiing for takeoff a male pax panicked and shouted 'open the door!' During a smoke-in-the-cabin occurrence (overheated a/c pack). The lead fa mistook this 'instruction' as coming from the cockpit and opened an exit door. Passengers interpreted her…NTSB CHI86FA120Accident · 2 fatalField investigationFinal reportLuscombe 8B · Pittsford, MIThe pilot overshot final approach due to a 10-15 kt tailwind on base leg. According to a pilot friend on the ground he put the acft into a 60 degree bank to in an attempt to realign himself with the final approach course. During this steep turn the aircraft…NTSB CHI86LA124Accident · No injuriesLimited investigationFinal reportHughes 269A · Lowell, MIThe pilot had just completed two autorotations when he landed hard on the third. The main rotor flexed down severing the tailboom and tailrotor. Although the pilot had logged over 6000 hours flight time, he had only 51 hours total rotorcraft time. He had…NTSB CHI86FEM04Accident · No injuriesFinal reportPerkins Viking Dragonfly · Lansing, MIOn his first flight in this type of homebuilt the pilot encountered what he said was windshear on final approach for his first landing. He added power and the aircraft pitched up 30 degrees. He pushed down on the stick and the aircraft pitched down violently.…NTSB CHI86FEC02Accident · Minor injuriesFinal reportCessna T210M · Highland, MIThe aircraft was in cruise when the engine started sputtering. According to the pilot, he switched tanks and the engine would start to run then miss, start to run then-miss, over and over again. The pilot stated that while this was happening he was losing…NTSB CHI86FEC01Accident · Minor injuriesFinal reportTaylorcraft BC12-D · Leslie, MIThe acft was damaged during a forced lndg following a loss of power after a low pass over an off arpt intended landing area. The plt was overflying a field belonging to a friend in preparation for a possible landing when a loud clunk was heard from the eng…NTSB CHI86FEC03Accident · No injuriesFinal reportCessna U-206B · Tecumseh, MIThe acft collided with terrain following a landing on rwy 18. According to the plt, a gust of wind lifted the right wing of the acft during roll out. The propeller then struck the ground and the acft rocked back onto the right wing.NTSB CHI86LA114Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Plymouth, MIThe eng quit during climb out shortly after takeoff. The plt switched tanks and tried a restart with no success. The acft then experienced a nose gear collapse and nosed over during a landing roll in a field. Investigation revealed the fuel line to the…NTSB CHI86FA108Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Boyne Falls, MIAfter the plt was cleared for an rnav-b apch, the acft crashed on hilly trrn aprx 3 mi se of the arpt at an elev of 750'MSL. Impact occurred after the acft had turned to the sse & was dscndg. Min dscnt alt (mda) for the apch was 1680'. No preimpact mechanical…NTSB CHI86LA105Accident · No injuriesLimited investigationFinal reportCessna 150J · Lansing, MIThe student pilot flew a four leg round-robin with touch and go landing after each leg. After his return to his point of origin and following his second touch and go there, the engine quit at 100 ft AGL, halfway down the runway. He bounced into the grass at…NTSB CHI86LA104Accident · No injuriesLimited investigationFinal reportCessna 175 · Gregory, MIThe newly purchased acft was being flown off of the seller's turf strip. After taking off, the acft struck 50 ft trees off of the end of the runway. The seller, who watched the takeoff, stated that the pilot overrotated the acft after lift-off.NTSB DCA86AA021Accident · 3 fatalFinal reportEmbraer EMB-110P1 · Alpena, MIDrg arrival at 2125 EST, simmons airline flt 1746 was adzd by wurtsmith afb apch ctl that the 2052 EST wx at phelps collins arpt was: sky partially obscd, ceiling 100' overcast, vis 1/2 mi with lgt drizzle & fog, & to expect an ILS apch. However, at 2119, a…NTSB CHI86FA102Accident · 3 fatalField investigationFinal reportBellanca 17-30A · Frankfort, MIThe plt was taking off from his local arpt and local residents described conditions of 100 ft vis in heavy ground fog. After lift-off he began a left turn toward a 300 ft high ridge topped by 100 ft trees. The acft struck the tree tops, the plt lost control…NTSB CHI86FA094Accident · 1 fatalField investigationFinal reportCessna 152 · Drayton Plaines, MIAfter a home built dragon fly gnd looped, other acft in the VFR traffic pattern were sent around, including a Cessna 152(C-152), N93604, flown by a student plt. Shortly after the dragon fly was clrd fm the rwy, Cessna 172 (C-172), N48003, entered the pattern,…NTSB CHI86LA091Accident · No injuriesLimited investigationFinal reportCessna 210M · While Lake Twp., MIThe acft was four miles from the arpt on an ILS apch when an eng failure was experienced. The acft was damaged during the forced landing on a frozen lake. Post accident eng teardown revealed the eng failure originated from movement of the #2 main bearing.…NTSB CHI86FA079Accident · 2 fatalField investigationFinal reportCessna 421C · Birmingham, MIAt rotation the right eng failed. The acft entered a skidding turn to the rt and continued to climb to about 100 ft AGL. During the turn 110 deg from t.o. heading acft rolled inverted and descended into a car port. Extensive post impact fire destroyed acft,…NTSB CHI86LA070Accident · No injuriesLimited investigationFinal reportCessna 185 · St. Ignace, MIThe pilot stated that after the application of full power for takeoff his seat slid back to its full aft position. He could not reach any of the controls. He then unfastened his seat belt and lunged forward to pull the power off. At this time the right wing…NTSB CHI86LA072Accident · No injuriesLimited investigationFinal reportBeech A23A · Hastings, MIThe pilot estimated he had 13 gallons of fuel on board for the estimated fifty minute flight. He estimated his fuel burn at nine gallons per hour giving him an hour and twenty five minute fuel endurance. He ran out of fuel an hour and twenty five minutes…NTSB CHI86LA067Accident · No injuriesLimited investigationFinal reportSikorsky S-58F · North Adams, MIWhile accomplishing preflight systems checks with the engine running and the rotor system engaged the aircraft experienced a hydraulic hardover. Uncommanded displacement of the flight controls caused the aircraft to pitch up and left simultaneously. The pilot…NTSB CHI86LA063Accident · No injuriesLimited investigationFinal reportCessna 150H · Charlotte, MIThe student was performing a practice approach to an emergency landing on a frozen, snow covered lake. After he had flown to an altitude low over the lake the instructor took over the controls. At this point the aircraft struck a ridge of snow and came to a…NTSB CHI86MA056Incident · No injuriesMajor investigationFinal reportMcdonnell Douglas DC-10-10 · Detroit, MIN101AA was operating as American flt 192. Flt 192 was originally cleared to land on rwy 21R; however, a preceeding acft had a landing gear problem, so flt 192 was cleared to land on rwy 21C, instead. The coplt, who was flying the acft, made a side-step…NTSB CHI86MA052Accident · 6 fatalMajor investigationFinal reportCessna 177B · Brooklyn, MIThe pilot took off with five passengers approximately 170 pounds over maximum allowable gross weight into known moderate icing conditions. His aircraft was not equipped to fly in these conditions. Radio and radar contact were lost at approximately 3500 feet…NTSB CHI86FEM03Accident · 1 fatalFinal reportRobinson R22A · Grand Rapids, MIThe plt reported he flew into the wolverine power plant for the purpose of picking up a passenger to whom he was to demonstrate the helicopter's ability to survey power lines. He continued to report, shortly after landing during normal engine shut down…NTSB CHI86MA047Accident · 5 fatalMajor investigationFinal reportBeech B-60 · Carp Lake, MIDrg arrival, the plt reported a problem with his #1 nav, but said he would try to make an ILS apch. He said he would return to pontiac, if his ILS did not work. ARTCC cleared him for the ILS rwy 32 apch & instructed him to contact pellston radio (fss). At…NTSB CHI86FA046Accident · 2 fatalField investigationFinal reportAerospatiale SA365N · Adrian, MIThe purpose of this flight was to pick up an injured patient and return him to a medical center. The weather was adequate for a VFR takeoff. However, enroute weather reports indicated fog and probable low ceilings. According to the single survivor of the…