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 CHI87LA091Accident · Minor injuriesLimited investigationFinal reportBeech BE 36 · Alma, MIAccording to the plt, during the preflight inspection, he determined that both gas tanks were full and 'everything was in order.' After aprx one hour of local flight, the plt entered a left downwind for rwy 27 at gratiot community airport, Alma, Michigan. The…NTSB CHI87LA090Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Hopkins, MIThe plt stated that 'everything was normal' on downwind and base, but that he experienced rough air and 'side to side motion' of the acft on final approach to rwy 27. According to the plt, he held an airspeed of 70 mph with 'some power' until he had the rwy…NTSB DCA87MA022Accident · 9 fatalMajor investigationFinal reportCASA C-212-CC · Romulus, MIThe capt made a steep, short, fast visual approach to the runway behind a departing DC-9. The evidence indicates the capt placed the power levers into beta mode to slow the aircraft rapidly and make a short field landing. An asymmetric thrust condition…NTSB CHI87LA089Accident · No injuriesLimited investigationFinal reportCessna 182F · Pontiac, MIWhile the acft was being taxied to a hangar after landing, the left main gear collapsed. An investigation revealed the left main landing gear spring strut, pn 0741601-1, had failed where it was clamped to the fuselage. A metallurgical exam of the fracture…NTSB CHI87LA084Accident · No injuriesLimited investigationFinal reportCessna 172 · Charlevoix, MIUpon landing the nose wheel buckled after striking a snowbank and the aircraft flipped over. Pilot reported there was a problem with the nose wheel although inspection of the nose wheel after the accident did not reveal any malfunction.NTSB CHI87FA081Accident · Serious injuriesField investigationFinal reportBoeing 747-122 · Detroit, MIDrg flt, united flt 108 recd info of a bomb threat. Due to a short time limit, specified in the threat, the flt divertedto Detroit & the slides were used to evacuate the acft; 8 of 10 slides deployed nmly & were used. The slide at door 4R didn't inflate &…NTSB CHI87LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Utica, MIThe pilot experienced a loss of power to 900 RPM shortly after takeoff. The plt had climbed to 2000 ft and reduced power. When the RPM dropped to 900 RPM he applied carb heat to no avail. The acft was landed in a field 6 miles north of the departure arpt.…NTSB CHI87LA077Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bridgman, MIPlt was attempting to takeoff from a soft field. The gear caught a rise in the field and acft settled back to the soft ground tearing off the nose wheel and damaging both wings.NTSB CHI87DEC01Accident · Serious injuriesFinal reportCessna 150 · Troy, MIOutside air temperature was approximately 5 degress f when the aircraft on initial climb experienced a total power loss. The pilot lowered the nose and attempted to make a turn to return to the runway. The aircraft did complete approximately 180 to 190…NTSB CHI87LA062Accident · No injuriesLimited investigationFinal reportMooney M20J · Kalamazoo, MIAfter requesting clearance to Kalamazoo county airport (azo) due to icing problems, the plt was given radar vectors to the ILS runway 35 approach. Four minutes later the plt stated that it was 'probably going to be a dead stick landing.' When asked what he…NTSB CHI87FA060Accident · 2 fatalField investigationFinal reportCessna 150L · Lakeview, MIWitnesses observed the aircraft buzzing a farm where a friend of the pilot resided. Following a low pass, the aircraft pulled up into a steep, left climbing turn. At the top of the climb, the nose dropped and the aircraft spiraled into the ground.NTSB DCA87IA015Incident · No injuriesIncident investigationFinal reportATR ATR-42 · Detroit, MIDrg arr, the flt was vectored for an ILS rwy 3R apch. At that time, ATIS info indcd mod mixed icing in clds. The capt rprtd the acft entered the cloud tops at 5500', was in the clds aprx 5 min & accumulated abt 1.5' of rime ice. He statedice accumulation was…NTSB CHI87LA044Accident · No injuriesLimited investigationFinal reportCessna T303 · Benton Harbor, MIThe plt was flying to Benton Harbor to get work done on a continuing problem with the right eng throttle. On final apch, the plt did not get a gear down indication and tried to cycle the gear. Not sure that the gear was down, the plt choose to go-around. When…NTSB CHI87FA048Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · N. Manitou Isl., MIThe plt had recvd an unfavorable wx brief that included a SIGMET on flt icing. Enroute during flt over a large body of water he experienced power loss and was at too low a altitude to glide to shore. The plt attempted to ld on a island but crashed in a lake.NTSB CHI87LA043Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Marquette, MIWhile on landing rollout the student pilot skidded off the left side of the runway and collided with a snowbank. The student stated he was holding excessive left rudder and brake pressure.NTSB CHI87DEM05Accident · Serious injuriesFinal reportCessna T210L · Lawton, MIThe plt experienced a loss of control shortly after takeoff which resulted in an uncontrolled descent. The acft struck the ground with its left wingtip causing it to flip over onto its side. The plt reported that the auto-plt had been worked on after having…NTSB CHI87LA045Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Capac, MITen minutes after takeoff and just prior to letdown from 350 feet AGL a main rotor blade drag strut failed due to progressive fatigue through a threaded portion of the strut. Only partial control of the helicopter was possible after the failure. The pilot…NTSB CHI87DEM04Accident · Serious injuriesFinal reportDevries Sonerai II · Wayland, MIThe volkswagen engine of this homebuilt aircraft lost power sometime during flight. Subsequently, the aircraft crashed during a forced landing in a field. The pilot received serious head injuries during impact and could not remember details of the accident.…NTSB CHI87LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Gaylord, MIThe plt landed on a closed rwy and the acft collided with a snowbank. A NOTAM had been issued three days prior, closing the rwy, however, the plt stated that he had not checked notoms prior to departing traverse city. A plt of another acft, who reported being…NTSB CHI87LA032Accident · No injuriesLimited investigationFinal reportBurkhart Grob 109B · Gregory, MIWhile landing, the aircraft bounced twice, so the pilot decided to go around and make a second attempt. On climb out, the landing gear struck 65 ft tall trees at the end of the runway. The aircraft then stalled and collided with the terrain. Reportedly, the…NTSB CHI87LA025Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Detroit, MIUpon landing at Detroit metropolitan airport, the pilot stated that he was instructed by the tower to make a right turn on runway 3C or taxiway j, and taxi to butler aviation. The pilot then turned onto what he thought was taxiway j, but was actually a paved…NTSB CHI87DEM03Accident · No injuriesFinal reportRalley 3A · Gowen, MIThe pilot stated that the aircraft stalled while practicing an emergency landing. He also stated that he should have pulled up from the practice emergency procedure sooner.NTSB CHI87LA011Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Grand Ledge, MIThe aircraft experienced engine failure during takeoff and nosed over in an open field. The pilot stated that he did his runup on the right fuel tank and took off on the left fuel tank. Inspection of the aircraft found water in the left fuel tank. The pilot…NTSB CHI87DEM02Accident · No injuriesFinal reportLeblanc Dragonfly · Lansing, MIThe home built acft was on a test flt & was being flown by a plt with only about 2.5 hrs of flt time in this make & model. During the landing, the acft touched down hard & began to porpoise. The canard & wooden prop were damaged during the occurrence.NTSB CHI87LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Galesburg, MIThe student plt reported becoming ill which resulted in her getting off course between flint, MI, and grand haven, MI, during a three leg x-country. The acft was not refueled upon reaching grand haven and fuel exhaustion occurred en route to coldwater. The…NTSB CHI87DEM01Accident · 1 fatalFinal reportBrown Acro Sport II · Grand Haven, MIAccording to the pilot after takeoff he leveled off to gain airspeed and then entered a 60 degree pitch up attitude. The pilot stated at about 400 feet AGL he noticed the airspeed was lower than 'normal'. Shortly thereafter the aircraft stalled and entered a…NTSB CHI87LA003Accident · No injuriesLimited investigationFinal reportCessna 150L · East Jordan, MIThe pilot stated that after extending 10 degrees of flaps and applying carburetor heat on final apch, he reduced throttle. Upon throttle reduction, the engine quit. Inspection of the engine revealed a broken mixture control cable housing. The engine operated…NTSB CHI86FA230Accident · 2 fatalField investigationFinal reportCessna 172K · East Tawas, MIAircraft collided with trees while in low level flight following a predawn departure. An airport 10 miles to the north was reporting very low ceilings with visibilities lower than 1/2 mile in fog and drizzle. The proximity to the departure airport and the…NTSB CHI86FEC07Accident · No injuriesFinal reportPiper PA-36-285 · Imlay City, MIThe pilot stated that takeoff acceleration did not seem normal. He rotated approx 5 mph early and could not climb out. He delayed emergency dumping of the load of insecticide until clearing a drainage ditch. He stated that if he would have dumped at the end…NTSB CHI86LA227Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Grosse Ile, MIThe pilot stated that he had a habit of landing left of the centerline. While landing with a right crosswind, the aircraft drifted to the left and the left wing struck three construction sawhorses, placed off the left side of the runway.NTSB CHI86LA222Accident · No injuriesLimited investigationFinal reportCessna 310G · Ypsilanti, MIThe left main gear collapsed and the acft veered off the left side of the runway during the landing roll at an groundspeed of aprx 30 KTS. Inspection of the landing gear disclosed a bent push pull tube.NTSB CHI86FA218Accident · Minor injuriesField investigationFinal reportLearjet 24 · Ypsilanti, MICrew attempted ILS approach with indefinite ceiling and RVR=o in fog. Co-pilot at controls. During missed approach, acft contacted runway where glideslope intersects terrain with sufficient force to shear all three landing gear. Right engine spolled down…NTSB CHI86FEC06Accident · 1 fatalFinal reportLawrence Baby Great Lakes · Holly, MIThe plt/owner had recently acquired the acft & had only about 3 hrs of flt time in this make & model. After taking off, he flew to the area of a friend's house & made svrl passes over a field near the house. After the last pass, the plt turned to an easterly…NTSB CHI86MA216Incident · No injuriesMajor investigationFinal reportBoeing 737-222 · Lansing, MIPiedmont flt PI255 (a Boeing 737, N749N) was dscndg in visual conds on an IFR clnc when it & a twin commanche (Piper PA-30, N7399Y) converged & passed within a rprtd 50 to 100 ft of each other. The near collision occurred as the PA-30 was cruising westbound…NTSB CHI86LA209Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Milford, MIThe pilot used full power and 10 degrees of flaps to perform a short field takeoff from a sod strip. He rotated for takeoff less than halfway down the 1100 ft runway, then kept the acft low to accelerate to 80 KTS. He then pulled up to clear a row of 40 ft…NTSB CHI86LA211Accident · No injuriesLimited investigationFinal reportCessna 175 · Muskegon, MIJust prior to applying takeoff power the pilot switched to the left fuel tank. Fuel from this tank had never been used by this pilot since he purchased the aircraft two weeks earlier. Shortly after breaking ground the engine quit. Although the pilot switched…NTSB CHI86LA203Accident · Minor injuriesLimited investigationFinal reportRepublic RC-3 · Keego Harbor, MIAccording to the pilot, as he was preparing to land on a lake and was at an altitude of approximately 100 feet, he noticed that he did not have full flaps down. He then reached down, and by error, lowered the landing gear instead of the flaps. During…NTSB CHI86FEM14Accident · No injuriesFinal reportPiper PA-25-235 · White Pigeon, MIThe pilot took off with a full load of seed on a 1300 ft runway during shifting wind conditions. He struck a fence before he had enough airspeed to establish a climb.NTSB CHI86LA208Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · Ionia, MIAccording to the plt, at approximately 20 miles south of Ionia county airport, Ionia, Michigan, he used frontal zone lift to climb to 4600 MSL (3800 AGL), and he encountered no further lift. The plt stated that he anticipated an increase in wind gradient…NTSB CHI86LA206Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-150 · Fraser, MITake off was aborted after aircraft failed to achieve sufficient airspeed to allow it to climb out of ground effect. During the subsequent landing and rollout the aircraft ran off the end of the runway and was destroyed. The plt did not report any…NTSB CHI86LA204Accident · No injuriesLimited investigationFinal reportCessna 182G · Chesaning, MIThe pilot was making his first landing to a sod runway. While decelerating over the runway at about 6' AGL. The aircraft began to sink rapidly. He added power, but the landing gear hit hard and the aircraft bounced several feet back into the air. He added…NTSB CHI86LA205Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Linden, MIThe newly certificated pvt plt with three passengers was attempting to practice a short field takeoff on the 2500 ft long asphalt runway. The owner's manual recommends 25 degrees of flaps to perform the takeoff. The plt did not extend any flaps. After…NTSB CHI86FA198Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Perrinton, MIThe pvt PIC and his pax, also a pvt plt, departed the pic's pvt airstrip for a local pleasure flt. An acft, similar in size and color to the plt's was seen doing low level flt at tree top level with abrupt pull-ups near where the plt normally flew. The plt…NTSB CHI86FEM13Accident · Minor injuriesFinal reportPiper PA-28-140 · Menominee, MIThe acft lost eng pwr shortly after takeoff. The plt attempted to land back on the rwy but ran off the end into a ditch. The reason for the power loss could not be determined.NTSB CHI86LA190Accident · No injuriesLimited investigationFinal reportBeech B-19 · Manchester, MIThe pilot states, that on flare out the aircraft ballooned and then settled, sustaining a hard landing. The nose gear failed upon touchdown.NTSB CHI86LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Traverse City, MIWhile flaring to land, the aircraft had excessive speed and ballooned. Subsequently, it bounced twice, then began to veer to the left. The pilot performed a go-around. During the initial portion of the go-around, the left wing struck a runway edge identifier…NTSB CHI86LA187Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Charlevoix, MIAccording to the pilot,on their first approach they were unable to see the airport at 1300 feet, so they raised the gear and flaps and climbed to 1800 feet, at which time they saw the airport. The pilot decided to make a VFR landing on runway 26 and forgot…NTSB CHI86FEM12Accident · No injuriesFinal reportRobinson R-22HP · Grayling, MIThe helicopter, during cruise flight, was flying low in an attempt to remain clear of clouds when it struck a power line and was forced to make an emergency landing. The helicopter received substantial damaged when it struck the power line and reportedly…NTSB CHI86LA178Accident · No injuriesLimited investigationFinal reportCessna 172N · West Branch, MIThe student pilot's CFI had advised him to refuel at an en route arpt on the x-county solo flt because there was no fuel avail at departure arpt. The student did not dip thetanks but stated 'based on my calculations of fuel burn there should have been enough…NTSB CHI86LA176Accident · No injuriesLimited investigationFinal reportCessna 150 · Allegan, MIGrass steip measures 1800 feet by 45 feet. Seven-foot tall corn stalks surround both sides of airstrip. The aircraft veered off center, to the left, during touchdown. Left wing contacted corn stalks, causing aircraft to cartwheel.